SQL SCRIPS FOR MU ONLINE

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=('')