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

Scripst for SQL !

View previous topic View next topic Go down

Scripst for SQL !

Post  m4s4cru on Tue Aug 02, 2011 12:14 pm

Am gasit scripturile astea pe un forum ...si mam gandit ca poate ar fi de folos si pe aici....asa ca sa nu comentati aiurea...nui creatia mea...am adus numa pt. folosinta altora:
Code:
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

---
Give Credits For Game Play Time
---
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


---
DELETE ALL RESETS
---
UPDATE Character
SET Resets=('0')
WHERE Resets>0


---
DELETE ALL INVENTORIES
---
UPDATE Character
SET Inventory=('')

---
DELETE ALL WAREHOUSES
---
UPDATE warehouse
SET Items=('')

---
DELETE One Character INVENTORY
---
UPDATE Character
SET Inventory=('')
WHERE Name='Omaru'

---
DELETE One WAREHOUSE
---
UPDATE warehouse
SET Items=('')
WHERE AccountID='Omaru'

---
UNBAN ALL Players
---
UPDATE Character
SET CtlCode=('0')
WHERE CtlCode=('1')


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

How to fix Guide Score Bug:
UPDATE Guild
SET G_Score=('0')
WHERE G_Score<-1

Negative Money Fix :

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

--------------------------------

Personal ID Code Check "Disabling" :

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

-----------------------------

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

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

-------------------------------

Auto Clear PK


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

--------------------------------------

This script will automatically teleports users from "The Place Of Exile" To Lorencia, bar !

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


-------------------------------------


This delete all there resets (DONT USE IT LIKE JO.

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

----------------------

This one will clear all the vaults.

UPDATE warehouse
SET Items=('')

----------------------

This one for deleting all the items from inventories.

UPDATE Character
SET Inventory=('')

----------------------

This one will unban all the players.

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

-----------------------

This one will delete all GMs.

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

------------------------

This one will delete all the level up points.

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

Credits:
=Master=
Diablo
Omaru
Damian
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


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