Auto Class Rank 19

Printable View

10-09-10
S37uP!Update

Auto Class Rank 19

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

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, @style + 144, 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
10-09-10
Cancel

Re: Auto Class Rank 19

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, HP + 1000, 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.
10-09-10
emi

Re: Auto Class Rank 19

Quote:

Originally Posted by Cancel

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, HP + 1000, 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
13-09-10
price

Re: Auto Class Rank 19

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

19=144 and 9= ????

pls answer fast need it for my server...
16-09-10
S37uP!Update

Re: Auto Class Rank 19

For class rank 9 put 64.
16-09-10
price

Re: Auto Class Rank 19

Thanks man ;)
23-11-10
dragaobr

Re: Auto Class Rank 19

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

Re: Auto Class Rank 19

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-...binary-430732/
02-12-10
S37uP!Update

Re: Auto Class Rank 19

Quote:

Originally Posted by chumpywumpy

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-...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 !
03-12-10
cypher

Re: Auto Class Rank 19

Quote:

Originally Posted by S37uP!Update

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..
27-01-11
youbrey

Re: Auto Class Rank 19

Quote:

Originally Posted by S37uP!Update

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, @style, 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, @style + 144, 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
27-01-11
Millenial

Re: Auto Class Rank 19

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.
27-01-11
Yamachi

Re: Auto Class Rank 19

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

Re: Auto Class Rank 19

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

Quote:

Originally Posted by Millenial

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?
30-01-11
emi

Re: Auto Class Rank 19

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

Re: Auto Class Rank 19

Quote:

Originally Posted by emi

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...
17-08-12
SILVERSONYath

Re: Auto Class Rank 19

who tells me what is the code for the rank

10, 11, 12, 13, 14, 15, 16, 17, 18,
03-10-12
S37uP!Update

Re: Auto Class Rank 19

Quote:

Originally Posted by SILVERSONYath

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
29-05-13
nescafeIV

Re: Auto Class Rank 19

(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????
29-05-13
S37uP!Update

Re: Auto Class Rank 19

Yes, just the database name is changed, Server01 instead of GameDb
29-05-13
imd1haha

Re: Auto Class Rank 19

Sir, may i have the link of the microsoft SQL? Wanna download it. Thanks..

What is that for sir? the ranking that you said?
18-06-13
Distroay

Re: Auto Class Rank 19

I can not find Enterprise Manager in Microsoft SQL Server 2008
30-07-13
S37uP!Update

Re: Auto Class Rank 19

MSSQL Server 2008 - Let me google that for you
Management Studio - Let me google that for you
13-09-13
asifa

Re: Auto Class Rank 19

Quote:

Originally Posted by youbrey

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

Go to SERVER01 - programmability - stored procedures dbo.cbal_sp_newchar

its work for me
30-03-14
busternr

Re: Auto Class Rank 19

What is Enterprise Manager ?
08-04-19
lordgell

Re: Auto Class Rank 19

Quote:

Originally Posted by S37uP!Update

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

Can't find cabal_sp_newchar where is it T_T
08-04-19
S37uP!Update

Re: Auto Class Rank 19

Quote:

Originally Posted by lordgell

Can't find cabal_sp_newchar where is it T_T

That's outdated, this table exist only on EPISODE 2 Database, the table name on EP 8 Database is different, just search around your DB and you will find it, don't be lazy.
08-04-19
lordgell

Re: Auto Class Rank 19

Quote:

Originally Posted by S37uP!Update

That's outdated, this table exist only on EPISODE 2 Database, the table name on EP 8 Database is different, just search around your DB and you will find it, don't be lazy.

i did search on my db and found cabal_new_chardata_table and cabal_new_char_data but i dont see reputation and style rows, so i manually add it, but it doesn't work still stuck at rank 6 and honor 0 when i create new char, idk how the guy who owned the DB did this....

- - - Updated - - -

edit: i found a solution.
08-04-19
Drav3n

Re: Auto Class Rank 19

Databases >> Server01 >> Stored Procedures >> cabal_sp_newchar