StarMedia
Va asteptam in grupul nostru de pe facebook: Click

Distribuiţi
Vezi subiectul anteriorIn josVezi subiectul urmator
avatar
Mr.Bonu$s
V.I.P
V.I.P
Mesaje : 2900
Varsta : 23
Localizare : -=[Italy]=-
Sunt pe forum din : 06/08/2009

Mai Mule Scripturi Ptr Sql Query

la data de Lun 25 Ian 2010, 13:09
----------------------
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
------------------------------------------------------------------

Sper Sa Va Fi Folositoare!
Lautaru
Membru
Membru
Mesaje : 389
Varsta : 25
Localizare : Pitesti
Sunt pe forum din : 01/04/2009

Re: Mai Mule Scripturi Ptr Sql Query

la data de Lun 25 Ian 2010, 14:47
gj mane ! Smile
avatar
Merlin
Moderator Global
Moderator Global
Mesaje : 5856
Localizare : Pământ
Sunt pe forum din : 26/10/2009

Re: Mai Mule Scripturi Ptr Sql Query

la data de Lun 25 Ian 2010, 15:44
TC! :smile4234:
Continut sponsorizat

Re: Mai Mule Scripturi Ptr Sql Query

Vezi subiectul anteriorSusVezi subiectul urmator
Permisiunile acestui forum:
Nu puteti raspunde la subiectele acestui forum