Default character stats

We all love having a max stats character, right from the start :laugh:
This simple query makes it possible, for everyone! It will make all stats 32000 [even DL's command] and level 400

Demo: SS with the GS and an editor after the character creation.

http://img179.imageshack.us/img179/9946/maxcopyco2.png

Run this in Query Analizer [Start > All Programs > Microsoft SQL server > Query Analizer > Login> Paste code > Parse Query [ctrl + F5] > Execute query [F5]

Note: SQL can be on, Game Server can be started, it won't do any harm.


For Old Versions, without summoner: Not tested

Code:

---

USE [MuOnline]
DELETE FROM DefaultClassType where class='0';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (0,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)

USE [MuOnline]
DELETE FROM DefaultClassType where class='16';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (16,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)


USE [MuOnline]
DELETE FROM DefaultClassType where class='32';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (32,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)

USE [MuOnline]
DELETE FROM DefaultClassType where class='48';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (48,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)

USE [MuOnline]
DELETE FROM DefaultClassType where class='64';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (64,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)

---

For new versions, with summoner Tested

Code:

---

USE [MuOnline]
DELETE FROM DefaultClassType where class='80';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (80,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)


USE [MuOnline]
DELETE FROM DefaultClassType where class='0';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (0,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)


USE [MuOnline]
DELETE FROM DefaultClassType where class='16';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (16,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)


USE [MuOnline]
DELETE FROM DefaultClassType where class='32';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (32,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)


USE [MuOnline]
DELETE FROM DefaultClassType where class='48';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (48,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)


USE [MuOnline]
DELETE FROM DefaultClassType where class='64';
INSERT INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (64,32000,32000,32000,32000,70,70,40,40,0,182,128,3,32000,400,0)

---

Query by me[Ray], thanks to my computer,microsoft and webzen.

nice work! gonna test it

10x ray :)

Hope it works for everyone. Also I'd like to say it also fixes the lack of Summoner in the new databases ^^

Also.. Add this for noobs: who are using older version Dataserver it won't work ^^ Attached Dataserver supports this. But u need update some Tables.. im not in mood to check my idea... but its logical.. Also need Wz_create_character stored procedure... ah.. Good Luck.. not bad guide... OH.. ALSO :
I Hate Max Stats Without Working..
It makes you N00B ^^

Quote:

---

We all love having a max stats character, right from the start

---

Well, i dont... ;)

Quote:

---

Originally Posted by Hiivan

Well, i dont... ;)

---

Ok ok, there are some low rates servers lovers. But most of servers are for fun and since everyone's having all jewels and boks and stuff in shops..why not max stats xD

Quote:

---

But most of servers are for fun

---

After max stats server becomes boring :) Good guide anyway.

Quote:

---

Originally Posted by Hiivan

After max stats server becomes boring :) Good guide anyway.

---

Still could be good for betas when players should find bugs not try to level up =/

looks nice.. gonna test it.. :)

it doesht works for s5:(

http://img179.imageshack.us/img179/9946/maxcopyco2.png




what is this program on right side? thats i cann see adds lvl xp any points and stuff? please give me download link of it please

mumaker

please give me download libk ofthat rogram please

Nice! But... when you restar dataserver, its not drop this table to defult???

10/10

nice GUIDE and QUERY Ray ,, :)

Oh my...good old times.

Quote:

---

Originally Posted by cswars

Nice! But... when you restar dataserver, its not drop this table to defult???

---

It should not be affected by any restarts whatsoever. If I remember correctly this alters a table from which the details for a new character are retrieved from, permanently.

Quote:

---

Originally Posted by tutero69

10/10

nice GUIDE and QUERY Ray ,, :)

---

Thanks.