- Joined
- Jan 17, 2009
- Messages
- 1,212
- Reaction score
- 975
Edit cabal_sp_newchar
Code Hornner Rank 1 - 18
Code skill combo board bike
Sample
open cabal_skilllist_table in Gamedb and click Show SQL Panel
Code:
/****** Object: Stored Procedure dbo.cabal_sp_newchar Script Date: 2008-4-14 5:52:47 ******/
CREATE PROCEDURE [dbo].[cabal_sp_newchar] (@charname varchar(16), @characteridx int, @style int, @stylemast int)
AS
begin
SET NOCOUNT ON
if( exists ( select * from cabal_badwoard where badword=@charname ) ) select convert(int,0x04)
else if( exists ( select * from cabal_character_table where Name=@charname ) ) select convert(int,0x03)
else if( exists ( select * from cabal_character_table where characteridx=@characteridx ) ) select convert(int,0x02)
else if( @stylemast < 0x01 or @stylemast > 0x06 ) select convert(int,0x02)
else
begin
-----------------------------------------------------------------------------------------------
declare @RegTime dateTime, @userNum int, @serverIdx int, @result int
set @userNum = @characterIdx/8
set @serverIdx = dbo.getServerIdx()
set @RegTime = getDate()
set @result = convert(int, 0xA0) + @stylemast
------------------------------------------------------------------------------------------------
select charTable.*, etcTable.equipmentData, etcTable.inventoryData, etcTable.skillData,
etcTable.quickSlotData, etcTable.questData, etcTable.questFlagsData
into #tempTable
from GAMESERVER.account.dbo.cabal_newCharData_table as charTable,
GAMESERVER.account.dbo.cabal_newEtcData_table as etcTable,
( select top 1 charDataIdx, etcDataIdx from GAMESERVER.account.dbo.cabal_newFlagData_table
where channel = @serverIdx) as flagTable
where flagTable.etcDataIdx = etcTable.dataIdx and flagTable.charDataIdx = charTable.dataIdx
and charTable.classType = etcTable.classType and charTable.classType = @stylemast
IF( NOT EXISTS ( select * from #tempTable))
BEGIN
select convert(int, 0x01)
drop table #tempTable
return
END
-----------------------------------------------------------------------------------------------
-- ??? ??? ??
EXEC GAMESERVER.account.dbo.cabal_sp_update_character_count @userNum, @serverIdx, 1
--??? ??
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[COLOR="Red"](8*19) << Edit ClassRack 20[/COLOR], HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1
from #TempTable
begin tran
insert into cabal_equipment_table (characterIdx, data) select @characteridx, equipmentData from #TempTable
insert into cabal_inventory_table (characterIdx, data) select @characteridx, inventoryData from #TempTable
insert into cabal_skilllist_table (characterIdx, data) select @characteridx, skillData from #TempTable
insert into cabal_quickslot_table (characterIdx, data) select @characteridx, quickSlotData from #TempTable
insert into cabal_questdata_table (characterIdx, data, flags) select @characteridx, questData, questFlagsData from #TempTable
commit tran
----------------------------------------------------------------------------------------------
-- ??? 0xA1 ~ 0xA6
drop table #tempTable
select convert(int, @result)
-----------------------------------------------------------------------------------------------
-- Here is where I added the Warp and Map codes, near the bottom of the procedure
update cabal_character_table set WarpBField = '1023', MapsBField = '1023' where CharacterIdx = @characteridx
update cabal_character_table set LEV = '1', Alz = '20000000', Reputation = '7600000', [COLOR="Red"]Reputation = '1280000' << Hornner Rack 10[/COLOR],Nation = '0' where CharacterIdx = @characteridx
[COLOR="Red"]UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx[/COLOR] <<< code open all quest
end
SET NOCOUNT OFF
end
GO
Code Hornner Rank 1 - 18
Code:
1 10000
2 20000
3 40000
4 80000
5 160000
6 320000
7 640000
8 1280000
9 2560000
10 5120000
11 10240000
12 20480000
13 40960000
14 81920000
15 163840000
16 327680000
17 655360000
18 1310720000
Code skill combo board bike
Code:
WA
update cabal_skilllist_table set Data = 0x4D01014654010148550101499001014B7C01014E7D01014F 7E0101507F010151D00009026700092064000921E600042265 000923A3010147CC00140337000905D9001406CD001407CA00 140822000909CE00140ADA00140BDB00140C1A00090D2B0009 0EDC001400DD001401A40101442C010A522E0108532F010854 390103553A010356A5010166A6010167
where CharacterIdx = @characteridx
BL
update cabal_skilllist_table set Data = 0x020001004D01014656010148570101499201014B8001014E 8101014F8201015083010151CB001401D0000902CC00140314 0009041B000905D3001406C9000F0728000908CD0014093400 090A4600090BA3010147C40101452300090CCA00140D380009 0EA40101442C0109522E0106532F0106543A01015539010156 A5010166A6010167 where CharacterIdx = @characteridx
WI
update cabal_skilllist_table set Data = 0x640001204D01014658010148590101499401014BE7001421 E8001422E9000F23EC001424EA00092589000928730014297A 00142A7600142B7D00142C020009008000012DD0000901A301 01478C000F26E50014278B00092EEB00142F8D000C30E4000F 31E3000632E2000633A40101442C010A522F01085330010854 380103553701035634010157A5010166A6010167 where CharacterIdx = @characteridx
FA
update cabal_skilllist_table set Data = 0xA80101204B0101434D0101465A0101485B0101499601014B 8701014E8801014F890101508A0101510200090095001422ED 001423EE001424EF000125F000142697001427F1001428BE01 1429C301142AB701142BBA01142C9800142DF300142EF20014 2FF4001421D0000901A3010147F5001430F600093110011432 9B000933110114349C000935F7001436A40101449900093712 011438C40101452C010A5230010854380103553A0103562F01 085737010353A5010166A6010167 where CharacterIdx = @characteridx
FS
update cabal_skilllist_table set Data = 0x020009004C0101434D0101465C0101485D0101499801014B 8401014E8501014F86010150D00009017A0014247D0014257B 0014261600090201000903F9001420FA0014229F000923F800 1427DF000128730014297600142A7E00142BFB00142CA30101 47E000142DE100142EA40101443900120424001405C4010145 7400142F770014307F0001317C001232E6000421780001332C 010A522F0108533A010354380103553001085637010357A501 0166A6010167where CharacterIdx = @characteridx
FB
update cabal_skilllist_table set Data = 0x020009004D0101465E0101485F0101499A01014B9C01014E 9D01014F9E0101502E00090111001402D00009032100140425 0009053A00090602011422FE001423FD001424FF001425DF00 1420A301014736001407A40101442A000908060114210D0114 260F011427F100142801011429EF00142A6400092B6500092C 6600092D0E01142E2C010A522F0101532E010154390103563A 01035737010355A5010166A6010167 where CharacterIdx = @characteridx
Sample
open cabal_skilllist_table in Gamedb and click Show SQL Panel
Code:
update cabal_skilllist_table set Data = 0x020009004D0101465E0101485F0101499A01014B9C01014E 9D01014F9E0101502E00090111001402D00009032100140425 0009053A00090602011422FE001423FD001424FF001425DF00 1420A301014736001407A40101442A000908060114210D0114 260F011427F100142801011429EF00142A6400092B6500092C 6600092D0E01142E2C010A522F0101532E010154390103563A 01035737010355A5010166A6010167 where CharacterIdx = 1234
Last edited: