Le isso aew
Procedure: GameDb.dbo.cabal_sp_newchar;
....
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, HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, 1023, 1023, '7680000', 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
-- ALTERAR AKI
exec CabalCash.dbo.up_addmycashitem @characteridx,'1','24','ITEMIDX','ITEMOPT','DURACAO';
-- FIM ALTERACAO
commit tran
----------------------------------------------------------------------------------------------
...
se não conseguir da uma olhada nesse tópico :
Créditos ao : hawayano