Auto Map & Warp Codes

Scris de **Adryyy** Lun Iul 19, 2010 4:44 am

GAMEDB > Stored Procedures > cabal_sp_newchar > si paste

Cod:

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 = '511', MapsBField = '511' where CharacterIdx = @characteridx
end

SET NOCOUNT OFF
end
GO

Sursa: Topic Gratuit