[Query] SQL Scripts

[4Shared]

Você deve executar esses scripts com consulta análise (Query Analizer), ou implementadas no SQL Agent

Auto Zen Fix

UPDATE Character

SET Money = 2000000000

WHERE Money < 1 OR Money > 2000000

Auto Stats Fix

UPDATE Character

SET Strength = 32767

WHERE Strength < 0 OR Strength > 32767

UPDATE Character

SET Dexterity = 32767

WHERE Dexterity < 0 OR Dexterity > 32767

UPDATE Character

SET Vitality = 32767

WHERE Vitality < 0 OR Vitality > 32767

UPDATE Character

SET Energy = 32767

WHERE Energy < 0 OR Energy > 32767

Auto Pk Clear

UPDATE Character

SET PkLevel = 0 , PkTime = 0 , PkCount = 0

Where PkLevel > 2

Auto Class Upgrade

UPDATE Character

SET Class = 17

WHERE Class = 16

UPDATE Character

SET Class = 1

WHERE Class = 0

UPDATE Character

SET Class = 33

WHERE Class = 32

Guild Score BUG

UPDATE Guild

SET G_Score=('0')

WHERE G_Score<-1

Creditos

UPDATE MEMB_CREDITS

SET Credits = Credits + 50

FROM MEMB_CREDITS JOIN MEMB_STAT ON MEMB_CREDITS.memb___id = MEMB_STAT.memb___id

COLLATE Latin1_general_CI_AI

WHERE OnlineHours = 1 And ConnectStat = 1

Remover resets

UPDATE Character

SET Resets=('0')

WHERE Resets>0

Remover Inventarios

UPDATE Character

SET Inventory=('')

Removendo vaults

UPDATE warehouse

SET Items=('')

Removendo um Caracter Inventário

UPDATE Character

SET Inventory=('')

WHERE Name='Nebiros'

Remover um Vault

UPDATE warehouse

SET Items=('')

WHERE AccountID='Omaru'

UNBAN ALL Players

UPDATE Character

SET CtlCode=('0')

WHERE CtlCode=('1')

Auto reset

UPDATE Character

SET cLevel=('1') , experience=('0')

WHERE cLevel>349

Créditos: o criador de scripts desconhecido

recopilare e adicionar mais cedo.

saudações