QA script for Reset players!

QA script for Reset

For each personage apart

Is it Below presented script Reset for each personage apart!


# Information:
--------------------
Reset lvl: '400'
Reset point: '300'
Reset money: 100'000'000 zen
Vault: 'NOT NULL'
Inventoty: 'NULL'
MagicList: 'NULL'
Quest: 'NULL' (It Is Zeroized)
Class: 'NULL' (It Is Zeroized)
LevelUpPoint: '0' (It Is Zeroized)
Reset Map: 'Lorencia'
PkLevel: '3'
PkTime: '0'
Reset script for: DK/BK, DW/SM, FE/ME, MG, DL.


P.S. -> Now under Reset, LevelUpPoint from old Reset will not remain!
-
-

Code:

---

Use MuOnline;
UPDATE Character SET LevelUpPoint=0
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE ((Class=0) or (Class=1) or (Class=16) or (Class=17) or (Class=32) or (Class=33) or (Class=48) or (Class=64)) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)

UPDATE Character SET cLevel=1, LevelUpPoint=300*(Resets+1), Class=0, Experience=0, Strength=18, Dexterity=18, Vitality=15, Energy=30, Inventory=NULL, MagicList=NULL, Money=Money-(100000000), MapNumber=0, MapPosX=125, MapPosY=123, PkLevel=3, PkTime=0, Quest=NULL, Resets=Resets+(1)
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE ((Class=0) or (Class=1)) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)

UPDATE Character SET cLevel=1, LevelUpPoint=300*(Resets+1), Class=16, Experience=0, Strength=28, Dexterity=20, Vitality=25, Energy=10, Inventory=NULL, MagicList=NULL, Money=Money-(100000000), MapNumber=0, MapPosX=125, MapPosY=123, PkLevel=3, PkTime=0, Quest=NULL, Resets=Resets+(1)
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE ((Class=16) or (Class=17)) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)

UPDATE Character SET cLevel=1, LevelUpPoint=300*(Resets+1), Class=32, Experience=0, Strength=22, Dexterity=25, Vitality=20, Energy=15, Inventory=NULL, MagicList=NULL, Money=Money-(100000000), MapNumber=0, MapPosX=125, MapPosY=123, PkLevel=3, PkTime=0, Quest=NULL, Resets=Resets+(1)
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE ((Class=32) or (Class=33)) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)

UPDATE Character SET cLevel=1, LevelUpPoint=300*(Resets+1), Class=48, Experience=0, Strength=26, Dexterity=26, Vitality=26, Energy=26, Inventory=NULL, MagicList=NULL, Money=Money-(100000000), MapNumber=0, MapPosX=125, MapPosY=123, PkLevel=3, PkTime=0, Quest=NULL, Resets=Resets+(1)
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE (Class=48) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)

UPDATE Character SET cLevel=1, LevelUpPoint=300*(Resets+1), Class=64, Experience=0, Strength=26, Dexterity=26, Vitality=26, Energy=26, Inventory=NULL, MagicList=NULL, Money=Money-(100000000), MapNumber=0, MapPosX=125, MapPosY=123, PkLevel=3, PkTime=0, Quest=NULL, Leadership=26, Resets=Resets+(1)
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE (Class=64) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)

---

P.S. -> Can whomever to be necessary!


------
Credits go to S@nek.

# for all - The Explanation of the classes player!

Сlass = '0' : Dark Wizard
Сlass = '1' : Soul Master
Сlass = '16' : Dark Knight
Сlass = '17' : Blade Knight
Сlass = '32' : Fairy Elf
Сlass = '33' : Muse Elf
Сlass = '48' : Magik Gladiator
Сlass = '64' : Dark Lord

# for Moderators - Please delete this post!

not bad ... 6/10

Nothing special...just generated script from one MU reset generator :protest:

player keep poinst after reset?
you can make one script?

Saniok Rupe buka la tati 10/10

Moldova Rullezz Good job . Saneok!

it bad and this dont realise 0/10

#9, DragonMU - Script good and worker, but envy DragonMU does not cost(stand), who you guilty that you has shown itself as liar on my Forum...


P.S. -> If you can do better script, so do and publish, rather then blears the eyes...

better to test it first dragonmu before you post the ratings..lolz

Quote:

---

Originally Posted by HexaMaster

Nothing special...just generated script from one MU reset generator :protest:

---

:clap_1: :clap_1:

Quote:

---

Originally Posted by HexaMaster

Nothing special...just generated script from one MU reset generator :protest:

---

You always so speak, when release not your...

P.S. -> Insult someone else work of all master, but do most something....

this noob post.

how i can make RESET of 3

how about if you like to implement build systsem and you like that different characters class will get different max points. let say 65k for DL 55k for SM and MG, 75k for Elf and summoner and 50k for BK. what is the script need to execute for this kind of build system?

its old to make it like that now all pepole useing web sites.

Sorry for diggin up an old topic but i had some trouble with this one.

- After running it, every body returned to zero. For example, all SM turned into Wiz, BK turned into DK.
- Items got lost (or so they say)
- My reset limits (10) are gone
- Resets turned to auto

Is this what this is supposed to do?
If so, i would like an alternative script to remove the SM to Wiz, reset limit to go back to 10 and remove auto reset