1. BEGIN TRAN
   
2. IF @Num <> 0
   
3. BEGIN
   
4. IF @StackSize > 1
   
5. BEGIN
   
6. SET @dur = 1
   
7. END
   
8. SET @CNum = substring(cast(@Num as varbinary(4)), 4, 1) + substring(cast(@Num as varbinary(4)), 3, 1) + substring(cast(@Num as varbinary(4)), 2, 1) + substring(cast(@Num as varbinary(4)), 1, 1)
   
9. SET @Cdur = cast(substring(cast(@dur as varbinary(2)), 2, 1)+substring(cast(@dur as varbinary(2)), 1, 1) as varchar(2))
   
10. SET @Cstack = cast(substring(cast(@StackSize as varbinary(2)), 2, 1)+substring(cast(@StackSize as varbinary(2)), 1, 1) as varchar(2))
    
11. IF @Num <> 0
    
12. BEGIN
    
13. IF @location = 1
    
14. BEGIN
    
15. SELECT @strItem = strItem FROM USERDATA WHERE strUserId = @playerID
    
16. SET @x = 1
    
17. WHILE @x <= 400
    
18. BEGIN
    
19. IF [dbo].GetNum(@strItem, @x) = 0
    
20. BEGIN
    
21. SET @pos = @x
    
22. SET @x = 400
    
23. END
    
24. SET @x = @x + 8
    
25. END
    
26. 
    
27. UPDATE USERDATA SET strItem = cast(substring(strItem, 1, @pos-1) + cast(cast(@CNum as varchar(4)) + @Cdur + @Cstack as varchar(8)) + substring(strItem, @pos + 8, 401 - @pos) as binary(400)) WHERE strUserID = @playerID
    
28. END
    
29. ELSE
    
30. BEGIN
    
31. SELECT @WarehouseData = WareHouseData FROM WAREHOUSE WHERE strAccountID = @playerID
    
32. SET @x = 1
    
33. WHILE @x <= 3200
    
34. BEGIN
    
35. IF [dbo].GetWNum(@WarehouseData, @x) = 0
    
36. BEGIN
    
37. SET @pos = @x
    
38. SET @x = 3200
    
39. END
    
40. SET @x = @x + 8
    
41. END
    
42. UPDATE WAREHOUSE SET WareHouseData = cast(substring(WareHouseData, 1, @pos - 1) + cast(cast(@CNum as varchar(4)) + @Cdur + @Cstack as varchar(8)) + substring(WareHouseData, @pos + 8, 3208 - @pos) as binary(3200)) WHERE strAccountID = @playerID
    
43. END
    
44. END
    
45. END
    
46. COMMIT TRAN
    
47. RETURN

复制代码

用法

1. exec insert_item 'ID', Item Id , Piece

复制代码

謝謝分享~~~

适用于哪些版本

什么版本都能用哈哈

1# ctgwglzc


这个要怎么用啊

很好的东西，谢谢分享！

這個怎麼測試  ct可以簡單說明一下嗎?  謝謝

不错 写GM工具的话也可以用到

这个不够先进
也不够简单
如果玩家在线也会容易无效

9# aiiq


您說清楚點吧   聽不懂啊~~~哈哈