Auto Class Rank 19

Printable View

Show 100 post(s) from this thread on one page

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?

Show 100 post(s) from this thread on one page