Auto Class Rank 19

S37uP!Update · Sep 10, 2010

How to create character's with class rank 19 automatically!

For EP 2
# Go to : Enterprise Manager>Microsoft SQL Servers>SQL Server Group>(local)(Windows NT)>Databases>GameDb>Stored Procedures
# Open : cabal_sp_newchar

For EP 8
# Go to : Enterprise Manager>Microsoft SQL Servers>SQL Server Group>(local)(Windows NT)>Databases >Server01>Stored Procedures
# Open : cabal_sp_newchar

Find :

Code:

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   [USER=1333352388]Character[/USER]idx,  [USER=551894]Char[/USER]name, LEV, [EXP], [STR], [DEX], [INT], [PNT], Rank, Alz,
WorldIdx, Position, [B][COLOR="Red"]@style[/COLOR][/B], HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1
from #TempTable

Replace :

Code:

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   [USER=1333352388]Character[/USER]idx,  [USER=551894]Char[/USER]name, LEV, [EXP], [STR], [DEX], [INT], [PNT], Rank, Alz,
WorldIdx, Position, [B][COLOR="Red"]@style + 144[/COLOR][/B], HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1
from #TempTable

+8 = Class Rank 2
+16 = Class Rank 3
+24 = Class Rank 4
+32 = Class Rank 5
+40 = Class Rank 6
+48 = Class Rank 7
+56 = Class Rank 8
+64 = Class Rank 9
+72 = Class Rank 10
+80 = Class Rank 11
+88 = Class Rank 12
+96 = Class Rank 13
+104 = Class Rank 14
+112 = Class Rank 15
+120 = Class Rank 16
+128 = Class Rank 17
+136 = Class Rank 18
+144 = Class Rank 19
+152 = Class Rank 20

USE THANKS BUTTON.

© S37uP!Update

Cancel · Sep 10, 2010

I will test it later, but what does this +144 Stands for?

Why does it Class Rank up to 19? Can you define it?
Would this change the HP?

Code:

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, [B][COLOR="Red"]HP + 1000[/COLOR][/B], MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1
from #TempTable

Would you be so friendly a even write how to Auto give Levels and Map Codes and Stats, and Honour Rank and Alz?

Would be usefull, because i wotn get clever from the Guide of chumpy.

emi · Sep 10, 2010

Cancel said:
I will test it later, but what does this +144 Stands for?

Why does it Class Rank up to 19? Can you define it?
Would this change the HP?

Code:

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, [B][COLOR="Red"]HP + 1000[/COLOR][/B], MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1 from #TempTable

Would you be so friendly a even write how to Auto give Levels and Map Codes and Stats, and Honour Rank and Alz?

Would be usefull, because i wotn get clever from the Guide of chumpy.

explained here

price · Sep 13, 2010

Hey can someone tell me the id for Class rank 9 ??

19=144 and 9= ????

pls answer fast need it for my server...

S37uP!Update · Sep 16, 2010

For class rank 9 put 64.

price · Sep 16, 2010

Thanks man

Zenzor · Nov 23, 2010

how give class rank 19 more combo and special skills to all new characters ? pls give-me help

chumpywumpy · Nov 23, 2010

Adding skills like combo/board/bike is not so simple. Your skills are stored as one big binary value in the database so you need to be able to decode the skill binaries, edit and then update the char templates witht e new binary. Here is an example:

Code:

0x020001004D0101245401012655010127900101297C01012C7D01012D7E01012E7F01012F0100004002000041030000420400004305000044060000450700004608000047090000480A0000490B00004A0C00004B0D00004C0E00004D0F00004E1000004F1100005012000051130000521400005315000054160000551700005618000057190000581A0000591B00005A1C00005B1D00005C1E00005D1F00005E2000005F2100006022000061230000622400006325000064260000652700006628000067290000682A0000692B00006A2C00006B2D00006C2E00006D2F00006E3000006F3100007032000071330000723400007335000074360000753700007638000077390000783A0000793B00007A3C00007B3D00007C

So, first you must understand how char templates work (there is a guide in my sig) and then you must learn how to decode the skill binary so you can edit it. If you don't already understand how the item binaries work then you won't find this easy (it is made up almost exactly the same way), if you know how item binaries work then it's fairly easy.

http://forum.ragezone.com/f460/tips-decode-item-binary-430732/

S37uP!Update · Dec 2, 2010

chumpywumpy said:
Adding skills like combo/board/bike is not so simple. Your skills are stored as one big binary value in the database so you need to be able to decode the skill binaries, edit and then update the char templates witht e new binary. Here is an example:

Code:

0x020001004D0101245401012655010127900101297C01012C7D01012D7E01012E7F01012F0100004002000041030000420400004305000044060000450700004608000047090000480A0000490B00004A0C00004B0D00004C0E00004D0F00004E1000004F1100005012000051130000521400005315000054160000551700005618000057190000581A0000591B00005A1C00005B1D00005C1E00005D1F00005E2000005F2100006022000061230000622400006325000064260000652700006628000067290000682A0000692B00006A2C00006B2D00006C2E00006D2F00006E3000006F3100007032000071330000723400007335000074360000753700007638000077390000783A0000793B00007A3C00007B3D00007C

So, first you must understand how char templates work (there is a guide in my sig) and then you must learn how to decode the skill binary so you can edit it. If you don't already understand how the item binaries work then you won't find this easy (it is made up almost exactly the same way), if you know how item binaries work then it's fairly easy.

http://forum.ragezone.com/f460/tips-decode-item-binary-430732/

That's really,really hard for newbie i know that because i already test by myself , for first time it was like imposible for me,you can look at the tutorials but still be really hard to understand how to decode !

cypher · Dec 3, 2010

S37uP!Update said:
That's really,really hard for newbie i know that because i already test by myself , for first time it was like imposible for me,you can look at the tutorials but still be really hard to understand how to decode !

Nothing hard if you try. I remember when I first discovered how skills work by taking 1 step at a time and having pacience. It's not hard if you know a bit of everything..

youbrey · Jan 27, 2011

S37uP!Update said:

How to create character's with class rank 19 automatically!

# Go to : Enterprise Manager>Microsoft SQL Servers>SQL Server Group>(local)(Windows NT)>Databases>GameDb>Stored Procedures
# Open : cabal_sp_newchar

Find :

Code:

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, [B][COLOR="Red"]@style[/COLOR][/B], HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1
from #TempTable

Replace :

Code:

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, [B][COLOR="Red"]@style + 144[/COLOR][/B], HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1
from #TempTable

USE THANKS BUTTON.

© S37uP!Update

hi...
nice share.....
but i am still not understand about this....
where is "enterprise manager"??
where is cabal_sp_newchar???
how to open it???
thanks

Millenial · Jan 27, 2011

He means that you need to launch the MSSQL Enterprise Manager, which you can find in the "Programs" tab on your windows under the name of "Microsoft SQL Server".

Then, you need to connect to your Windows NT server (local), and then go to the database "gamedb", where the character and guild data are stored.

Go to the "Stored Procedures" in the "gamedb" database, find "cabal_sp_newchar", right click on it and select "Properties".

Then do what the guide says.

Yamachi · Jan 27, 2011

Ignore youbrey, guys. He seems to think RaGEZONE is a hacking forum he can leech from.

youbrey · Jan 30, 2011

when i open my sql,i cant open server group...
because i not have a conection for server....
how i can conect to server in my sql??

---------- Post added at 01:47 AM ---------- Previous post was at 01:25 AM ----------

Millenial said:
He means that you need to launch the MSSQL Enterprise Manager, which you can find in the "Programs" tab on your windows under the name of "Microsoft SQL Server".

Then, you need to connect to your Windows NT server (local), and then go to the database "gamedb", where the character and guild data are stored.

Go to the "Stored Procedures" in the "gamedb" database, find "cabal_sp_newchar", right click on it and select "Properties".

Then do what the guide says.

i cant connect to my windows server (local)
how i can connetc to my server?

emi · Jan 30, 2011

Oh my gosh,did you read some guides when you made it?Or did you used the search button in your life before?

youbrey · Jan 30, 2011

emi said:
Oh my gosh,did you read some guides when you made it?Or did you used the search button in your life before?

what you mean??
sorry because i am newbie....
newbie not a leacher...

SILVERSONYath · Aug 17, 2012

who tells me what is the code for the rank

10, 11, 12, 13, 14, 15, 16, 17, 18,

S37uP!Update · Oct 3, 2012

SILVERSONYath said:
who tells me what is the code for the rank

10, 11, 12, 13, 14, 15, 16, 17, 18,

+8 = Class Rank 2
+16 = Class Rank 3
+24 = Class Rank 4
+32 = Class Rank 5
+40 = Class Rank 6
+48 = Class Rank 7
+56 = Class Rank 8
+64 = Class Rank 9
+72 = Class Rank 10
+80 = Class Rank 11
+88 = Class Rank 12
+96 = Class Rank 13
+104 = Class Rank 14
+112 = Class Rank 15
+120 = Class Rank 16
+128 = Class Rank 17
+136 = Class Rank 18
+144 = Class Rank 19
+152 = Class Rank 20

nescafeIV · May 29, 2013

(Go to : Enterprise Manager>Microsoft SQL Servers>SQL Server Group>(local)(Windows NT)>Databases>GameDb>Stored Procedures
# Open : cabal_sp_newchar )

>>>it's same SQL Server Management Studio r2????

S37uP!Update · May 29, 2013

Yes, just the database name is changed, Server01 instead of GameDb

Welcome!

Auto Class Rank 19

wWw.F403.OrG

Skilled Illusionist

ANTI

Newbie Spellweaver

wWw.F403.OrG

Newbie Spellweaver

Junior Spellweaver

The Dinosaur

wWw.F403.OrG

The Cat in the Hat

Newbie Spellweaver

Newbie Spellweaver

Banned

Newbie Spellweaver

ANTI

Newbie Spellweaver

Newbie Spellweaver

wWw.F403.OrG

Newbie Spellweaver

wWw.F403.OrG

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor