invenupdate.sql

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

--drop proc dbo.s_UpdateInven
create proc dbo.s_UpdateInven
@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
@iIDate11 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN11 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo11 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount11 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv11 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption11 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption11 as smallint, -- 胶泡 可记 2
@iIDate12 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN12 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo12 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount12 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv12 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption12 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption12 as smallint, -- 胶泡 可记 2
@iIDate13 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN13 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo13 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount13 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv13 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption13 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption13 as smallint, -- 胶泡 可记 2
@iIDate14 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN14 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo14 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount14 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv14 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption14 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption14 as smallint, -- 胶泡 可记 2
@iIDate15 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN15 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo15 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount15 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv15 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption15 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption15 as smallint, -- 胶泡 可记 2
@iIDate16 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN16 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo16 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount16 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv16 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption16 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption16 as smallint, -- 胶泡 可记 2
@iIDate17 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN17 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo17 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount17 as int, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv17 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption17 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption17 as smallint, -- 胶泡 可记 2
@iIDate18 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN18 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo18 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount18 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv18 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption18 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption18 as smallint, -- 胶泡 可记 2
@iIDate19 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN19 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo19 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount19 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv19 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption19 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption19 as smallint, -- 胶泡 可记 2

@iIDate20 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN20 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo20 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount20 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv20 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption20 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption20 as smallint, -- 胶泡 可记 2
@iIDate21 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN21 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo21 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount21 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv21 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption21 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption21 as smallint, -- 胶泡 可记 2
@iIDate22 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN22 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo22 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount22 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv22 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption22 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption22 as smallint, -- 胶泡 可记 2
@iIDate23 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN23 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo23 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount23 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv23 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption23 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption23 as smallint, -- 胶泡 可记 2
@iIDate24 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN24 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo24 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount24 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv24 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇
@iSpOption24 as int, -- 漂荐可记3俺 酒捞袍 殿鞭
@shSttOption24 as smallint, -- 胶泡 可记 2
@iIDate25 as int, --_ItemDate int, -- Item 积己 锅龋
@siISN25 as int, -- _ItemSN smallint, -- Item 捞 积己 揪府倔
@siINo25 as smallint, -- _ItemNo smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
@iICount25 as tinyint, -- _ItemCount Item 狼 肮荐(荐樊屈老 版快)
@bILv25 as tinyint, --_ItemLevel tinyint, -- Item狼 泅犁 饭骇