Auto class rank

[MaximumSatan]

I've searched the forum, and did find a guide on how to change the starter settings when creating a new char.
and I'd like to do auto rank up, but there's no colum for it in cabal_newchardata_table..

Anyone got an idea on how to do this?

[MentaL]

[chumpywumpy]

There is no column because it is part of the "style" value in the character table.

http://forum.ragezone.com/f460/tips-...s-rank-427839/

Many things make up the style value:
http://forum.ragezone.com/f459/php-s...-style-448801/

[MaximumSatan]

So what has to be done, so I get class rank 19 at server start?

[chumpywumpy]

The class values in the newEtcData table for the template set you are using becomes the style in the db. There is no easy way to change it because the server expects values 1-6 to read the template data, change those and the server won't be able to find the template data as all it is given is a style number (1-6). It would involve change to db layouts and stored procedures that i'm simply not doing to mine.

Honestly, why does nobody realise that messing with things given to you by quests is a bad idea.

EDIT: Oh well, if you really want. Open cabal_sp_newchar and find this query. The @style value is what gets given to the char, it's 1-6, just add 152.

		insert into cabal_character_table( CharacterIdx, Name, LEV, [EXP], [STR], DEX, [INT], PNT, Rank, Alz,
			WorldIdx, [Position], Style, HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1 )
		select  @characteridx, @charname, LEV, [EXP], [STR], [DEX], [INT], [PNT], Rank, Alz,
				WorldIdx, Position, @style, HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1
		from #TempTable

[MaximumSatan]

Hmm ok, that's beyond my knowledge..
I was more thinking of a trigger that does it..

[chumpywumpy]

You posted before i finished the edit so cheeky bump.

[MaximumSatan]

You posted before i finished the edit so cheeky bump.

Shall I replace @style with 152 or do like this @152?

edit: I replaced it with 152 and logged in and created a char, it worked but i had 50k atk,def rate etc
and 2280034 mana/hp lol

[chumpywumpy]

no, @style+152 (it needs to be added to the existing)

[MaximumSatan]

Working now, thank you very much.