[Release]Sql Scripts (HoT)

[diablo21]

Hello All
Today i will share you Sql Scripts

Not all scripts are writed by me..
I can't know the right credits because alot people may know thise scripts.
But thise scripts will help you alot if you are looking for them.
So let's get started:
-----------------------------------------------------------------

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

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

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

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


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


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

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

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

Thise one will clear all the vaults.

UPDATE warehouse
SET Items=('')

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

Thise one for deleting all the items from inventories.

UPDATE Character
SET Inventory=('')

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

Thise one will unban all the players.

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

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

Thise one will delete all GMs.

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

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

Thise one will delete all the level up points.

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

That is all i have..
You can simply full thise post by helping people to know more.
So if you know another script that is not writed here, you can simply share it.

Credits:
=Master=
Diablo
Omaru
Damian

[tagegor]

Oooold
BTW, ty

[inthoxicated]

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

this is what i`m looking for some time,but,what`s with
SET Credits = Credits + 50
line,shoud be edited SET Credits = 10,or SET Credits = Credits + 10 ?

[GrInYa]

good

[j3imz]

thnx for this..
but the credits is not working

[GoldbertGTR]

Good Release! 7/10!