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.

 

[aspire219]

Re: [Guide]Default character stats

nice work! gonna test it

 

[bauru]

Re: [Guide]Default character stats

10x ray

 

[RayOfLight]

Re: [Guide]Default character stats

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

 

[DarkerLT]

Re: [Guide]Default character stats

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

Re: [Guide]Default character stats

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

Well, i dont...

 

[RayOfLight]

Re: [Guide]Default character stats

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

Re: [Guide]Default character stats

But most of servers are for fun

After max stats server becomes boring Good guide anyway.

 

[RayOfLight]

Re: [Guide]Default character stats

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]

Re: [Guide] Default character stats

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.