equipupdate.sql

Soul的源代码,类似于劲舞团之类的游戏

--drop proc dbo.s_UpdateEquip
create proc dbo.s_UpdateEquip
@iIndex as int,--_charIndex int, --character Server 俊辑 积己等 key

@iIDate0 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN0 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo0 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount0 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv0 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption0 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption0 as smallint, -- 胶泡 可记 2
@iIDate1 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN1 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo1 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount1 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv1 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption1 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption1 as smallint, -- 胶泡 可记 2
@iIDate2 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN2 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo2 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount2 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv2 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption2 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption2 as smallint, -- 胶泡 可记 2
@iIDate3 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN3 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo3 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount3 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv3 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption3 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption3 as smallint, -- 胶泡 可记 2
@iIDate4 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN4 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo4 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount4 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv4 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption4 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption4 as smallint, -- 胶泡 可记 2
@iIDate5 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN5 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo5 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount5 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv5 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption5 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption5 as smallint, -- 胶泡 可记 2
@iIDate6 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN6 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo6 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount6 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv6 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption6 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption6 as smallint, -- 胶泡 可记 2
@iIDate7 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN7 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo7 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount7 as int, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv7 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption7 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption7 as smallint, -- 胶泡 可记 2
@iIDate8 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN8 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo8 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount8 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv8 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption8 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption8 as smallint, -- 胶泡 可记 2
@iIDate9 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN9 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo9 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount9 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv9 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption9 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption9 as smallint, -- 胶泡 可记 2
@iIDate10 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN10 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo10 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount10 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv10 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption10 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption10 as smallint -- 胶泡 可记 2

As
SET NOCOUNT on
begin tran

update dbo.EquipItem set  
_ItemDate0 = @iIDate0, _ItemSN0 = @siISN0, _ItemNo0 = @siINo0, _ItemCount0 = @iICount0, 
_ItemLevel0 = @bILv0, _iSpOption0 = @iSpOption0, _SttOption0 = @shSttOption0,
_ItemDate1 = @iIDate1, _ItemSN1 = @siISN1, _ItemNo1 = @siINo1, _ItemCount1 = @iICount1,
_ItemLevel1 = @bILv1, _iSpOption1 = @iSpOption1, _SttOption1 = @shSttOption1,
_ItemDate2 = @iIDate2, _ItemSN2 = @siISN2, _ItemNo2 = @siINo2, _ItemCount2 = @iICount2,
_ItemLevel2 = @bILv2,  _iSpOption2 = @iSpOption2, _SttOption2 = @shSttOption2, 
_ItemDate3 = @iIDate3, _ItemSN3 = @siISN3, _ItemNo3 = @siINo3, _ItemCount3 = @iICount3,
_ItemLevel3 = @bILv3,  _iSpOption3 = @iSpOption3, _SttOption3 = @shSttOption3,
_ItemDate4 = @iIDate4, _ItemSN4 = @siISN4, _ItemNo4 = @siINo4, _ItemCount4 = @iICount4,
_ItemLevel4 = @bILv4,  _iSpOption4 = @iSpOption4, _SttOption4 = @shSttOption4,
_ItemDate5 = @iIDate5, _ItemSN5 = @siISN5, _ItemNo5 = @siINo5, _ItemCount5 = @iICount5,
_ItemLevel5 = @bILv5,  _iSpOption5 = @iSpOption5, _SttOption5 = @shSttOption5,
_ItemDate6 = @iIDate6, _ItemSN6 = @siISN6, _ItemNo6 = @siINo6, _ItemCount6 = @iICount6,
_ItemLevel6 = @bILv6, _iSpOption6 = @iSpOption6, _SttOption6 = @shSttOption6,
_ItemDate7 = @iIDate7, _ItemSN7 = @siISN7, _ItemNo7 = @siINo7, _ItemCount7 = @iICount7,
_ItemLevel7 = @bILv7, _iSpOption7 = @iSpOption7, _SttOption7 = @shSttOption7,
_ItemDate8 = @iIDate8, _ItemSN8 = @siISN8, _ItemNo8 = @siINo8, _ItemCount8 = @iICount8,
_ItemLevel8 = @bILv8, _iSpOption8 = @iSpOption8, _SttOption8 = @shSttOption8,
_ItemDate9 = @iIDate9, _ItemSN9 = @siISN9, _ItemNo9 = @siINo9, _ItemCount9 = @iICount9,
_ItemLevel9 = @bILv9, _iSpOption9 = @iSpOption9, _SttOption9 = @shSttOption9,
_ItemDate10 = @iIDate10, _ItemSN10 = @siISN10, _ItemNo10 = @siINo10, _ItemCount10 = @iICount10,
_ItemLevel10 = @bILv10, _iSpOption10 = @iSpOption10, _SttOption10 = @shSttOption10 
where _charIndex = @iIndex
-- 费归俊 狐牶促 酒捞袍 墨款飘 tinyint
if @@Error <> 0
	begin
		rollback tran
	end
else
	begin
		commit tran
	end
go