ServerDev Development Community

We Want You (Editors, Developers) Let's Code
 
HomeRegisterLog in

Share | 
 

 [Guide] Auto Class Rank 19

View previous topic View next topic Go down 
AuthorMessage
RON
Administrator
Administrator
avatar

Posts : 63
Join date : 2013-09-08
Age : 20

PostSubject: [Guide] Auto Class Rank 19   Wed Jul 02, 2014 7:58 am

                               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:
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, [color=#ff0000]@style + 144[/color], 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.
Back to top Go down
http://serverdevelopment.forumtl.com
 
[Guide] Auto Class Rank 19
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» [1.D9] The Lord Of Parasites
» High Rank Rathalos! Please Help!
» Professor Zabbey's Guide to B Class Tuning
» High rank black diablos
» High Rank Gunner Armor

Permissions in this forum:You cannot reply to topics in this forum
ServerDev Development Community :: Cabal Online :: Cabal Guides & Templates-
Jump to: