Team BlueWater Game Online Tutorial's
Bine ati venit la Team-BlueWater!!Tutorial's 4 all Games!

Sql Script

View previous topic View next topic Go down

Sql Script

Post  m4s4cru on Tue Aug 02, 2011 10:12 am

Negative Money Fix
Code:

UPDATE Character
SET Money='2000000000'
WHERE Money<-1

Personal ID Code Check "Disabling"
Code:

UPDATE MEMB_INFO
SET sno__numb=('')
WHERE sno__numb>1

Starting Money (You starting money by changing ('10000000') to some other value.)
Code:

UPDATE Character
SET Money=('10000000')
WHERE Money<1


Auto Stats Fix


Code:

UPDATE Character
SET Strength='32766'
WHERE Strength<1

UPDATE Character
SET Dexterity='32766'
WHERE Dexterity<1

UPDATE Character
SET Vitality='32766'
WHERE Vitality<1

UPDATE Character
SET Energy='32766'
WHERE Energy<1


Dark Lord


Code:

UPDATE Character
SET Strength='32766'
WHERE Strength<1

UPDATE Character
SET Dexterity='32766'
WHERE Dexterity<1

UPDATE Character
SET Vitality='32766'
WHERE Vitality<1

UPDATE Character
SET Energy='32766'
WHERE Energy<1

UPDATE Character
SET Leadership='32766'
WHERE Leadership<1


Auto Clear PK

Code:

UPDATE Character
SET PkLevel = ('0'), PkTime = ('0'), PkCount = ('0')
Where PkLevel>2

Starting stats edditing

Code:

UPDATE Character
SET Strength='how mutch starting strenght you wanth'
WHERE Strenght<18

UPDATE Character
SET Dexterity='how mutch starting dexterity you wanth'
WHERE Dexterity<16

UPDATE Character
SET Vitality='how much starting vitality you wanth'
WHERE Vitality<16

UPDATE Character
SET Energy='how much starting energy you wanth'
WHERE Energy<16


Dark Lord

Code:
UPDATE Character
SET Strength='how mutch starting strenght you wanth'
WHERE Strenght<18

UPDATE Character
SET Dexterity='how mutch starting dexterity you wanth'
WHERE Dexterity<16

UPDATE Character
SET Vitality='how much starting vitality you wanth'
WHERE Vitality<16

UPDATE Character
SET Energy='how much starting energy you wanth'
WHERE Energy<16

UPDATE Character
SET Leadership='how much starting command you wanth'
WHERE Leadership<15

Incorect connected users shown on the web fix. (First Take Server Offline !) (If your server is offline maybe there is connected users shown on the web, it will fix that)


Code:

UPDATE MEMB_STAT
SET Connect_Stat='0'
WHERE Connect_Stat>0


Thise script will automaticaly teleports users from "The Place Of Excile" To Lorencia, bar
Code:

UPDATE Character
SET MapNumber=('0'), MapPosX=('125'), MapPosY=('125')
WHERE MapNumber=('5')


Thise one will fix guild score -99 bug
Code:

UPDATE Guild
SET G_Score=('0')
WHERE G_Score<-1


Thise delete all there resets (DONT USE IT LIKE JO
Code:

UPDATE Character
SET Resets=('0')
WHERE Resets>0

Thise one will clear all the vaults
Code:

UPDATE warehouse
SET Items=('')

Thise one for deleting all the items from inventories
Code:

UPDATE Character
SET Inventory=('')

Thise one will unban all the players
Code:

UPDATE Character
SET CtlCode=('0')
WHERE CtlCode=('1')

Thise one will delete all GMs
Code:

UPDATE Character
SET CtlCode=('0')
WHERE CtlCode=('8')

Thise one will delete all the level up points
Code:

UPDATE Character
SET LevelUpPoints=('0')
WHERE LevelUpPoints>0

Auto Reset
Code:

UPDATE Character
SET cLevel=('1') , experience=('0')
WHERE cLevel>349

This one will change the name of character

Code:

Update Character
Set Name=('New_Char_Name')
Where Name=('Old_Char_Name')
avatar
m4s4cru
Admin
Admin

Mesaje : 172
Data de inscriere : 2011-07-29
Varsta : 26

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum