Vá em Iniciar » Todos os Programas » Microsoft SQL Server » Query Analyser e Rode as Seguintes Query's Abaixo:

cabal_sp_delchar

Código PHP:
Quote:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

/****** Object: Stored Procedure dbo.cabal_sp_delchar Script Date: 2008-4-14 5:52:47 ******/

ALTER PROCEDURE [dbo].[cabal_sp_delchar] (@characteridx int)
AS

begin
SET NOCOUNT ON
DECLARE @ROWCOUNT int

BEGIN
--If GuildMaster, return 0xB2
SELECT 
@ROWCOUNT COUNT(A.GroupIndexFROM GUILDGROUP A
INNER JOIN
(
SELECT GroupIndex FROM GUILDMEMBER WHERE CharacterIndex = @characteridx
B
ON A
.GroupIndex B.GroupIndex
WHERE A
.GroupPermission 0

IF( @ROWCOUNT )
BEGIN
SELECT CONVERT
(INT0xB2)
SET NOCOUNT OFF
RETURN
END
END

begin tran
INSERT INTO DELETED_CABAL_CHARACTER_TABLE
(
CHARACTERIDXNAMELEVEXPSTRDEXINTPNTRANKALZWORLDIDXPOSITIONSTYLEHPMPSWDPNTMAGPNTRANKEXPFLAGSWARPBFIELDMAPSBFIELDSPPENALTYEXPLOGOUTTIMERPREPUTATIONLOGINTIMEPLAYTIMECHANNELIDXCreateDateEQUIPDATAINVENDATASKILLDATAQSLOTDATAQDFLAGSQSTDATAQSTFLAGSLevel0Level1Level2Level3Level4Exp0Exp1Exp2Exp3Exp4CraftFlagsPKPenaltyNationBBeadData)
SELECT
A
.CHARACTERIDXNAMELEVEXPSTRDEXINTPNTRANKALZWORLDIDXPOSITIONSTYLEHPMPSWDPNTMAGPNTRANKEXPA.FLAGSWARPBFIELDMAPSBFIELDSPPENALTYEXPLOGOUTTIMERPREPUTATIONLOGINTIMEPLAYTIMECHANNELIDXCreateDateB.DATAC.DATAD.DATAE.DATAF.FLAGSG.DATAG.FLAGSH.Level0H.Level1H.Level2H.Level3H.Level4H.Exp0H.Exp1H.Exp2H.Exp3H.Exp4H.FlagsA.PKPenaltyA.NationI.DATA
FROM CABAL_CHARACTER_TABLE A
LEFT OUTER JOIN CABAL_EQUIPMENT_TABLE B ON A
.CHARACTERIDX B.CHARACTERIDX
LEFT OUTER JOIN CABAL_INVENTORY_TABLE C ON A
.CHARACTERIDX C.CHARACTERIDX
LEFT OUTER JOIN CABAL_SKILLLIST_TABLE D ON A
.CHARACTERIDX D.CHARACTERIDX
LEFT OUTER JOIN CABAL_QUICKSLOT_TABLE E ON A
.CHARACTERIDX E.CHARACTERIDX
LEFT OUTER JOIN CABAL_QDDATA_TABLE F ON A
.CHARACTERIDX F.CHARACTERIDX
LEFT OUTER JOIN CABAL_QUESTDATA_TABLE G ON A
.CHARACTERIDX G.CHARACTERIDX
LEFT OUTER JOIN CABAL_CRAFT_TABLE H ON A
.CHARACTERIDX H.CHARACTERIDX
LEFT OUTER JOIN CABAL_BBEAD_TABLE I ON A
.CHARACTERIDX I.CHARACTERIDX
WHERE A
.CHARACTERIDX = @characteridx

delete from chat_buddy_table where 
(RegisterCharIdx = @characteridx) OR (RegisteeCharIdx = @characteridx)
delete from chat_buddygroup_table where CharIdx = @characteridx
delete from guildmember where characterindex 
= @characteridx
delete from cabal_bbead_table where CharacterIdx
=@characteridx
delete from cabal_craft_table where Characteridx
=@characteridx
delete from cabal_equipment_table where CharacterIdx
=@characteridx
delete from cabal_inventory_table where CharacterIdx
=@characteridx
delete from cabal_skilllist_table where CharacterIdx
=@characteridx
delete from cabal_quickslot_table where CharacterIdx
=@characteridx
delete from cabal_questdata_table where CharacterIdx
=@characteridx
delete from cabal_qddata_table where CharacterIdx
=@characteridx
delete from cabal_character_table where CharacterIdx
=@characteridx

set 
@ROWCOUNT = @@ROWCOUNT
commit tran
IF( @ROWCOUNT )
BEGIN
-- ???? ??? ???
DECLARE @
USERNUM INT, @SERVERIDX INT
SET 
@USERNUM = @CHARACTERIDX/8
SET 
@SERVERIDX DBO.GETSERVERIDX()
EXEC ACCOUNT.dbo.CABAL_SP_UPDATE_CHARACTER_COUNT @USERNUM, @SERVERIDX, -1
END

SELECT CONVERT
(INT0xA1)

SET NOCOUNT OFF
end

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO 


cabal_sp_newchar ( Começar com Grau 1 )

Código PHP:
Quote:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

/****** Object: Stored Procedure dbo.cabal_sp_newchar Script Date: 2008-4-14 5:52:47 ******/

ALTER 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(int0xA0) + @stylemast
------------------------------------------------------------------------------------------------

select charTable.*, etcTable.equipmentDataetcTable.inventoryDataetcTable.skillData,
etcTable.quickSlotDataetcTable.questDataetcTable.questFlagsData
into 
#tempTable
from account.dbo.cabal_newCharData_table as charTable,
account.dbo.cabal_newEtcData_table as etcTable,
select top 1 charDataIdxetcDataIdx from 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
(int0x01)
drop table #tempTable
return
END
-----------------------------------------------------------------------------------------------
-- ??? ??? ??
EXEC account.dbo.cabal_sp_update_character_count @userNum, @serverIdx1

--??? ??
insert into cabal_character_tableCharacterIdxNameLEV, [EXP], [STR], DEX, [INT], PNTRankAlz,
WorldIdx, [Position], StyleHPMPSPSwdPNTMagPNTRankEXPFlagsWarpBFieldMapsBFieldReputationReserved1 )
select @characteridx, @charnameLEV, [EXP], [STR], [DEX], [INT], [PNT], RankAlz,
WorldIdxPosition, @styleHPMPSPSwdPNTMagPNTRankEXPFlagsWarpBFieldMapsBFieldReputationReserved1
from 
#TempTable

begin tran
insert into cabal_equipment_table 
(characterIdxdataselect @characteridxequipmentData from #TempTable
insert into cabal_inventory_table (characterIdxdataselect @characteridxinventoryData from #TempTable
insert into cabal_skilllist_table (characterIdxdataselect @characteridxskillData from #TempTable
insert into cabal_quickslot_table (characterIdxdataselect @characteridxquickSlotData from #TempTable
insert into cabal_questdata_table (characterIdxdataflagsselect @characteridxquestDataquestFlagsData from #TempTable
commit tran
----------------------------------------------------------------------------------------------

-- ??? 
0xA1 0xA6
drop table 
#tempTable
select convert(int, @result)
-----------------------------------------------------------------------------------------------
end

SET NOCOUNT OFF
end

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO 


cabal_sp_newchar ( Começar com Grau 11 )

Código PHP:
Quote:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

/****** Object: Stored Procedure dbo.cabal_sp_newchar Script Date: 2008-4-14 5:52:47 ******/

ALTER 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(int0xA0) + @stylemast
------------------------------------------------------------------------------------------------

select charTable.*, etcTable.equipmentDataetcTable.inventoryDataetcTable.skillData,
etcTable.quickSlotDataetcTable.questDataetcTable.questFlagsData
into 
#tempTable
from account.dbo.cabal_newCharData_table as charTable,
account.dbo.cabal_newEtcData_table as etcTable,
select top 1 charDataIdxetcDataIdx from 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
(int0x01)
drop table #tempTable
return
END
-----------------------------------------------------------------------------------------------
-- ??? ??? ??
EXEC account.dbo.cabal_sp_update_character_count @userNum, @serverIdx1

--??? ??
insert into cabal_character_tableCharacterIdxNameLEV, [EXP], [STR], DEX, [INT], PNTRankAlz,
WorldIdx, [Position], StyleHPMPSPSwdPNTMagPNTRankEXPFlagsWarpBFieldMapsBFieldReputationReserved1 )
select @characteridx, @charnameLEV, [EXP], [STR], [DEX], [INT], [PNT], RankAlz,
WorldIdxPosition, @style+80HPMPSPSwdPNTMagPNTRankEXPFlagsWarpBFieldMapsBFieldReputationReserved1
from 
#TempTable

begin tran
insert into cabal_equipment_table 
(characterIdxdataselect @characteridxequipmentData from #TempTable
insert into cabal_inventory_table (characterIdxdataselect @characteridxinventoryData from #TempTable
insert into cabal_skilllist_table (characterIdxdataselect @characteridxskillData from #TempTable
insert into cabal_quickslot_table (characterIdxdataselect @characteridxquickSlotData from #TempTable
insert into cabal_questdata_table (characterIdxdataflagsselect @characteridxquestDataquestFlagsData from #TempTable
commit tran
----------------------------------------------------------------------------------------------

-- ??? 
0xA1 0xA6
drop table 
#tempTable
select convert(int, @result)
-----------------------------------------------------------------------------------------------
end

SET NOCOUNT OFF
end

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO 


Aperte F5 e Tudo Pronto. Poderá Criar Seu Char Sem Problemas!

OBS: Escolha Apenas uma query do cabal_sp_newchar a desejar entre começar Grau 1 ou 11 .