Mai Mule Scripturi Ptr Sql Query

Vezi subiectul anterior Vezi subiectul urmator In jos

Mai Mule Scripturi Ptr Sql Query

Mesaj Scris de Hyena la data de Joi Apr 08, 2010 5:49 pm

---------------------
Cod:Negative
Money Fix :

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

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

Cod:Personal ID Code Check
"Disabling" :

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

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

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

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

Cod:Auto Stats Fix :

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




If
there is a Dark Lord Then it's will look so :



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

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

Cod:Auto Clear PK

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

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

Cod:
Starting stats edditing:

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




For versions
that have Dark Lord :



UPDATE Character
SET
Strength='how mutch starting strenght you wanth'
WHERE Strength<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


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

Cod: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).

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


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

Cod: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')


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

Cod:This one will fix guild score
-99 bug.

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

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

Cod:This delete all the resets

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

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

Cod:This one will clear all the
vaults.

UPDATE warehouse
SET Items=('')

----------------------
Cod:
This one for deleting all
the items from inventories.

UPDATE Character
SET
Inventory=('')

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

Cod:This one will unban all the
players.

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

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

Cod:This one will delete all GMs.

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

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

Cod:This one will delete all the
level up points.

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

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

Cod:Auto Reset

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

Mesaje : 236
Data de inscriere : 12/03/2010
Varsta : 22

Vezi profilul utilizatorului http://bluegame.forumers.ro

Sus In jos

Re: Mai Mule Scripturi Ptr Sql Query

Mesaj Scris de Rimaru la data de Sam Iul 10, 2010 8:57 am

la ce folosesc astea?
avatar
Rimaru

Mesaje : 36
Data de inscriere : 14/03/2010

Vezi profilul utilizatorului

Sus In jos

Vezi subiectul anterior Vezi subiectul urmator Sus


 
Permisiunile acestui forum:
Nu puteti raspunde la subiectele acestui forum