Yusuke
User STM
Data inscrierii: 23/Oct/2009
Mesaje: 90
Localitate: Targu-Jiu
|
 Trimis: 24/10/2009 07:36 Titlul subiectului: Scripturi folositoare la SQL |
 |
|
Aceste scripturi le puneti in sql query analizer la db MuOnline
Auto Pk Clear
UPDATE Character
SET PkLevel = 0 , PkTime = 0 , PkCount = 0
Where PkLevel > 2
Guild Score BUG
UPDATE Guild
SET G_Score=('0')
WHERE G_Score<-1
DELETE ALL RESETS
UPDATE Character
SET Resets=('0')
WHERE Resets>0
DELETE ALL INVENTORIES
UPDATE Character
SET Inventory=('')
UNBAN ALL Players
UPDATE Character
SET CtlCode=('0')
WHERE CtlCode=('1')
Negative Money Fix
UPDATE Character
SET Money='2000000000'
WHERE Money<-1
Auto Pk Clear
UPDATE Character
SET PkLevel = 0 , PkTime = 0 , PkCount = 0
Where PkLevel > 2
DELETE ALL WAREHOUSES
UPDATE warehouse
SET Items=('')
_________________
Hehe |
|
