rZone
Owner
Data inscrierii: 27/Iul/2010
Mesaje: 65
|
 Trimis: 28/07/2010 23:53 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=('') |
|
