Default character stats

[RayOfLight]

We all love having a max stats character, right from the start
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.



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

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

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.

[MentaL]

[aspire219]

nice work! gonna test it

[bauru]

10x ray :)

[RayOfLight]

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

[DarkerLT]

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 ^^

[-/7y/I9I-]

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

Well, i dont... ;)

[RayOfLight]

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

[-/7y/I9I-]

But most of servers are for fun

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

[RayOfLight]

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 =/

[deyomornia]

looks nice.. gonna test it.. :)

[TheUninvited]

it doesht works for s5:(

[ViktorFr]

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

[buffon]

mumaker

[ViktorFr]

please give me download libk ofthat rogram please

[cswars]

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

[tutero69]

10/10

nice GUIDE and QUERY Ray ,, :)

[RayOfLight]

Oh my...good old times.

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.

10/10

nice GUIDE and QUERY Ray ,, :)

Thanks.