Cateva scripturi SQL

Aici sunt cateva scripturi folositoare pentru serverul de MuOnline

Toate scripturile se ruleaza in SQL Query Analyzer "MuOnline"
----------------------
Negative zen Fix :

Cod:

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

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

Pentru a avea zen cand creezi un caracter de la 0.in loc de 10000000 puneti cat vreti:

Cod:

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

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

Script Stats Fix...cand bagati mai mult de 32767 al str...se pun punctele automal la 32766 :

Cod:

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

Daca pe server aveti DL puneti asta:

Cod:

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>2

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


Cate puncte sa aiba un caracter cand il faceti de la 0:
Inlocuiti 1-32767 cu cate puncte vreti sa aiba un chr cand il creati:

Cod:

UPDATE Character
SET Strength='1-32767'
WHERE Strenght<18

UPDATE Character
SET Dexterity='1-32767'
WHERE Dexterity<16

UPDATE Character
SET Vitality='32767'
WHERE Vitality<16

UPDATE Character
SET Energy='1-32767'
WHERE Energy<16

Daca aveti DL pe server puneti asta :

Cod:

UPDATE Character
SET Strength='1-32767'
WHERE Strenght<18

UPDATE Character
SET Dexterity='32767'
WHERE Dexterity<16

UPDATE Character
SET Vitality='1-32767'
WHERE Vitality<16

UPDATE Character
SET Energy='1-32767'
WHERE Energy<16

UPDATE Character
SET Leadership='1-32767'
WHERE Leadership<15>0

-------------------------
Acest script teleporteaza automat playeri din Place of Exile in Lorencia bar!

Cod:

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

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

Cu asta fixezi guild score -99

Cod:


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

----------------------
Acest script goleste vaultul jucatorilor.

Cod:

UPDATE warehouse
SET Items=('')

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

Acest script sterge toate itemele din inventori.

Cod:

UPDATE Character
SET Inventory=('')

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

Cu asta debanezi toti jucatori banati.

Cod:


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

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

Cu acesta scoti toti GM's de pe server..

Cod:

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

Credits
->RZ
->&eu