some easy sql code

[Sylv3R69]

OK, CODE FIXED!!!

Pls testing, and srry my bad english...

15 age bug:

Use MuOnline;
UPDATE dbo.MEMB_INFO SET sno__numb = '1111111111111'

guild score fix ex: guild score: -1 or -3

UPDATE Guild
SET G_Score = 0
WHERE G_Score < 0

stat point fix:
If strength= 32790 --> change 32767

Use MuOnline;
UPDATE Character SET Strength = '32767' WHERE Strength >'32767'
UPDATE Character SET Dexterity = '32767' WHERE Dexterity >'32767'
UPDATE Character SET Vitality = '32767' WHERE Vitality >'32767'
UPDATE Character SET Energy = '32767' WHERE Energy >'32767'

zen fix:
If you have exl: -1232353 zen ---> change + 2.000.000.000 zen
zen < 0 ---> change 2.000.000.000 zen

UPDATE Character
Set Money=('2000000000')
WHERE Money<0

secret map:
If you go lorencia 230 160 and you exit, wait 1-2 minits and relog, change map position Illusion Temple 104 134 49 = illusion temple 6

UPDATE Character
SET MapNumber= 49, MapPosX = 104, MapPosY = 134
WHERE (MapNumber = 0) and (MapPosX = 230) and (MapPosY = 160);

LVL 3 character php code, and not /evo:
pls turn off /evo
If you have 50 reset and 1 lvl or high--->change lvl3 character.


Update c set
Class=65
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=1 and m.ConnectStat = 0 AND c.Class=64 and c.Resets>=50

Update c set
Class=34
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=1 and m.ConnectStat = 0 AND c.Class=33 and c.Resets>=50

Update c set
Class=49
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=1 and m.ConnectStat = 0 AND c.Class=48 and c.Resets>=50

Update c set
Class=2
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=1 and m.ConnectStat = 0 AND c.Class=1 and c.Resets>=50

Update c set
Class=18
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=1 and m.ConnectStat = 0 AND c.Class=17 and c.Resets>=50

 

[BilllmanGR]

Re: [Guide]some easy sql code

Ty nice guide

 

[wolfulus]

Re: [Guide]some easy sql code

almost all of them are wrong
so, fix it

 

[noobies]

Re: [Guide]some easy sql code

Ty nice guide

Tested?
I'll test when i get home >,<

 

[vaiben]

Re: [Guide]some easy sql code

UPDATE Character
Set Money=('2000000000')
WHERE Money<1

If player has 0zen it will make 2kkk... fix it...
so it will be:

UPDATE Character
Set Money=('2000000000')
WHERE Money<0

Thx i needed that script to make move to other map when relog...

 

[wolfulus]

Re: [Guide]some easy sql code

this too: Resets<=50

resets must be greater than or equal... not less than, so:

Resets>=50

 

[Sylv3R69]

Re: [Guide]some easy sql code

Ohh oke, thy everybody...
srry any problem, because this quick guide...

 

[Sylv3R69]

Re: [Guide]some easy sql code

Oke, and now, i today change lightsaber 2 hands -----> 1 hands


Text.bmd (extremueditor 0.7 - program)
change this ---->

Hand = 0
columb = 1


items.txt or item(kor).txt
change this ----->

// ItemSlot Skill X Y Serial Option Drop Item Name ItemLVL DmgMin DmgMax Speed Durability MagicDur MagicPwr Str Agi DW/SM DK/BK Elf/ME MG DL

10 0 22 1 4 1 1 1 "Light Saber" 40 47 61 25 50 0 0 0 80 60 0 0 0 1 0 1 1 1 0