[Guide] How To Open All Quests

[Backo]

Edit cabal_sp_newchar

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

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

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

update cabal_skilllist_table set Data = 0x020009004D0101465E0101485F0101499A01014B9C01014E 9D01014F9E0101502E00090111001402D00009032100140425 0009053A00090602011422FE001423FD001424FF001425DF00 1420A301014736001407A40101442A000908060114210D0114 260F011427F100142801011429EF00142A6400092B6500092C 6600092D0E01142E2C010A522F0101532E010154390103563A 01035737010355A5010166A6010167 where CharacterIdx = 1234