搜索
 找回密码
 加入

80%~90%成功率查复制的方法（只在1299及1311上测试过）

ctgwglzc 2009-7-25 16:01:45 1578
返回列表 发新帖
ctgwglzc

DMM DUGA XCREAM SOKMIL等日本PPV站视频代购

  1. CREATE TABLE ITEM_DECODED(

  3. strUserID char(21) NULL DEFAULT ('-'),

  5. strAccountID char(21) NULL DEFAULT ('-'),

  7. Name varchar(50),

  9. dwID int NULL,

  11. strSerial int NULL,

  13. Durability int NULL,

  15. StackSize smallint NULL,

  17. ii [int] NULL
复制代码
  1. CREATE TABLE DUPERS_LOGGED(

  3. strUserID varchar(50) NULL DEFAULT ('-'),

  5. strAccountID varchar(21) NULL DEFAULT ('-'),

  7. Name char(50) NULL,

  9. dwID int NULL,

  11. strSerial int NULL,

  13. time smalldatetime NULL DEFAULT (getdate()),

  15. ii smallint NULL

  17. )
复制代码
  1. set ANSI_NULLS ON

  3. set QUOTED_IDENTIFIER ON

  5. go

  7. CREATE PROCEDURE [dbo].[decode_all_items_1299]

  9. --By cherry killingzones.com

  11. AS

  13. declare @StrUserID char(21)

  15. truncate table dupers_logged

  17. truncate table item_decoded

  19. DECLARE Backup_Cursor CURSOR

  21. FOR

  23. SELECT struserID from userdata

  25. OPEN Backup_Cursor

  27. FETCH NEXT FROM Backup_Cursor INTO @StrUserID

  29. WHILE @@FETCH_STATUS = 0

  31. BEGIN

  33. DECLARE @row int, @i int, @count int, @dwid int, @type varbinary(4), @StackSize int, @strSerial int, @name char(50)

  35. SET @i = 1

  37. set @name = ''

  39. WHILE @i < 401

  41. BEGIN

  43. SELECT @dwid = cast(cast(substring(cast(substring(strItem, @i,4) as varbinary(4)), 4, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 2, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int),

  45. @strSerial = cast(cast(substring(cast(substring(strSerial, @i,4) as varbinary(4)), 4, 1)+substring(cast(substring(strSerial, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(strSerial, @i,4) as varbinary(4)), 2, 1)+substring(cast(substring(strSerial, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int),

  47. @type = cast(substring(strItem, @i+4, 2) as varbinary(2)),

  49. @StackSize = cast(cast(cast( substring(strItem, @i+7, 1) as varbinary(1))+cast(substring(strItem, @i+6, 1) as varbinary(1)) as varbinary(2)) as smallint)

  51. FROM USERDATA

  53. WHERE strUserID = @StrUserID

  55. select @name = strname from item where num = @dwid

  57. IF @dwid <> 0

  59. INSERT INTO ITEM_DECODED (strUserID, Name, dwid, strSerial, Durability, StackSize, ii)

  61. VALUES (@StrUserId, @Name, @dwid, @strSerial, @type, @StackSize, (@i-1) / 8)

  63. SET @i = @i + 8

  65. END

  67. FETCH NEXT FROM Backup_Cursor INTO @StrUserID

  69. END

  71. CLOSE Backup_Cursor

  73. DEALLOCATE Backup_Cursor

  75. exec decode_all_items_inn_1299
复制代码
成功率

举报

相关推荐
 请教,如何设置+8以上成功率为0
 求助,如何修改卷+的的成功率?
 如何更改經驗值倍率與掉寶率與鎔爐成功率？？
 分享1299炉子100+10%成功率 100%+5成功率的库表!
 可以修改炉子成功率的工具，甩卖结束
 求高手告诉下1299怎么改武器跟改炉子成功率
 首饰合成卷，成功率在那里修改？
 在数据库里面怎么设置炉子的成功率啊？？？

5 回复

ctgwglzc
2009-7-24 20:38:14
楼主

举报

点击查看详情
  1. set ANSI_NULLS ON

  3. set QUOTED_IDENTIFIER ON

  5. go

  7. CREATE PROCEDURE [dbo].[decode_all_items_inn_1299]

  9. --By cherry killingzones.com

  11. AS

  13. declare @StrAccountID char(21)

  15. DECLARE Backup_Cursor CURSOR

  17. FOR

  19. SELECT straccountID from warehouse

  21. OPEN Backup_Cursor

  23. FETCH NEXT FROM Backup_Cursor INTO @StrAccountID

  25. WHILE @@FETCH_STATUS = 0

  27. BEGIN

  29. DECLARE @row int, @i int, @count int, @dwid int, @type varbinary(4), @StackSize int, @strSerial int, @name char(50)

  31. SET @i = 1

  33. set @name = ''

  35. WHILE @i < 1601

  37. BEGIN

  39. SELECT @dwid = cast(cast(substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 4, 1)+substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 2, 1)+substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int),

  41. @strSerial = cast(cast(substring(cast(substring(strSerial, @i,4) as varbinary(4)), 4, 1)+substring(cast(substring(strSerial, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(strSerial, @i,4) as varbinary(4)), 2, 1)+substring(cast(substring(strSerial, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int),

  43. @type = cast(substring(WarehouseData, @i+4, 2) as varbinary(2)),

  45. @StackSize = cast(cast(cast( substring(WarehouseData, @i+7, 1) as varbinary(1))+cast(substring(WarehouseData, @i+6, 1) as varbinary(1)) as varbinary(2)) as smallint)

  47. FROM WAREHOUSE

  49. WHERE StrAccountID = @StrAccountID

  51. select @name = strname from item where num = @dwid

  53. IF @dwid <> 0

  55. INSERT INTO ITEM_DECODED (straccountID, Name, dwid, strSerial, Durability, StackSize, ii)

  57. VALUES (@StrAccountId, @Name, @dwid, @strSerial, @type, @StackSize, (@i-1) / 8)

  59. SET @i = @i + 8

  61. END

  63. FETCH NEXT FROM Backup_Cursor INTO @StrAccountID

  65. END

  67. CLOSE Backup_Cursor

  69. DEALLOCATE Backup_Cursor

  71. exec wipe_decode_all_items_1299
复制代码
  1. set ANSI_NULLS ON

  3. set QUOTED_IDENTIFIER ON

  5. go

  7. CREATE PROCEDURE [dbo].[wipe_decode_all_items_1299]

  9. --By cherry killingzones.com

  11. AS

  13. declare @straccountid char(21), @struserid char(21), @strSerial bigint, @dwid int, @stacksize smallint, @ii smallint

  15. DECLARE Backup_Cursor CURSOR

  17. FOR

  19. SELECT straccountid, struserid, strserial, dwid, stacksize, ii from item_decoded

  21. OPEN Backup_Cursor

  23. FETCH NEXT FROM Backup_Cursor INTO @straccountid, @struserid, @strSerial, @dwid, @stacksize, @ii

  25. WHILE @@FETCH_STATUS = 0

  27. BEGIN

  29. declare @count int

  31. SELECT @count = COUNT(*) FROM ITEM_DECODED WHERE strSerial = @strSerial and dwid = @dwid

  33. IF @count > 1 and @strSerial != 0 and @dwid !=0

  35. BEGIN

  37. INSERT INTO DUPERS_LOGGED (straccountid,struserid,dwid,strserial,ii)

  39. VALUES (@straccountid,@struserid,@dwid,@strSerial,@ii)

  41. END

  43. FETCH NEXT FROM Backup_Cursor INTO @straccountid, @struserid, @strSerial, @dwid, @stacksize, @ii

  45. END

  47. CLOSE Backup_Cursor

  49. DEALLOCATE Backup_Cursor

  51. exec encode_all_items_1299
复制代码
ctgwglzc
2009-7-24 20:38:45
楼主

举报

  1. set ANSI_NULLS ON

  3. set QUOTED_IDENTIFIER ON

  5. go

  7. CREATE procedure [dbo].[encode_all_items_1299]

  9. --by cherry killingzones.com

  11. AS

  13. DECLARE @strUserID char(21),@ii int

  15. DECLARE @strName varchar(50),@dwid int,@dur int,@StackSize smallint, @row int, @i int, @Cdwid varbinary(4), @cdur varchar(2), @cstack varchar(2)

  17. DECLARE Backup_Cursor1 CURSOR

  19. FOR

  21. SELECT struserid,ii from dupers_logged where struserid!='-'

  23. OPEN Backup_Cursor1

  25. FETCH NEXT FROM Backup_Cursor1 INTO @StrUserID,@ii

  27. WHILE @@FETCH_STATUS = 0

  29. BEGIN

  31. set @strName = ''

  33. set @dwid = 0

  35. set @dur = 0

  37. set @StackSize = 0

  39. set @i = @ii * 8 + 1

  41. select @row=count( * ) from item_decoded where struserid=@StrUserID and ii < @ii

  43. if @row=0

  45. begin

  47. Set @Cdwid = Substring(cast(@dwid as varbinary(4)), 4, 1) + Substring(cast(@dwid as varbinary(4)), 3, 1) + Substring(cast(@dwid as varbinary(4)), 2, 1) + Substring(cast(@dwid as varbinary(4)), 1, 1)

  49. Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as varchar(2))

  51. Set @Cstack = cast(Substring(cast(@StackSize as varbinary(2)), 2, 1)+Substring(cast(@StackSize as varbinary(2)), 1, 1) as varchar(2))

  53. update UserData set strItem = cast( substring(strItem, 1, @i-1) + cast(cast(@Cdwid as varchar(4)) + @Cdur + @Cstack as varchar(8)) + substring(strItem, @i+8, 401-@i) as binary(400)) where strUserID = @strUserID

  55. end

  57. if @row>0

  59. Begin

  61. Set @Cdwid = Substring(cast(@dwid as varbinary(4)), 4, 1) + Substring(cast(@dwid as varbinary(4)), 3, 1) + Substring(cast(@dwid as varbinary(4)), 2, 1) + Substring(cast(@dwid as varbinary(4)), 1, 1)

  63. Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as varchar(2))

  65. Set @Cstack = cast(Substring(cast(@StackSize as varbinary(2)), 2, 1)+Substring(cast(@StackSize as varbinary(2)), 1, 1) as varchar(2))

  67. update UserData set strItem = cast( substring(strItem, 1, @i-1) + cast(cast(@Cdwid as varchar(4)) + @Cdur + @Cstack as varchar(8)) + substring(strItem, @i+8, 401-@i) as binary(400)) where strUserID = @strUserID

  69. end

  71. FETCH NEXT FROM Backup_Cursor1 INTO @StrUserID,@ii

  73. END

  75. CLOSE Backup_Cursor1

  77. DEALLOCATE Backup_Cursor1

  79. exec encode_all_items_inn_1299
复制代码
  1. set ANSI_NULLS ON

  3. set QUOTED_IDENTIFIER ON

  5. go

  7. CREATE procedure [dbo].[encode_all_items_inn_1299]

  9. --by cherry killingzones.com

  11. AS

  13. DECLARE @strAccountID char(21),@ii int

  15. DECLARE @strName varchar(50),@dwid int,@dur int,@StackSize smallint, @row int, @i int, @Cdwid varbinary(4), @cdur varchar(2), @cstack varchar(2)

  17. DECLARE Backup_Cursor2 CURSOR

  19. FOR

  21. SELECT straccountid,ii from dupers_logged where straccountid!='-'

  23. OPEN Backup_Cursor2

  25. FETCH NEXT FROM Backup_Cursor2 INTO @strAccountID ,@ii

  27. WHILE @@FETCH_STATUS = 0

  29. BEGIN

  31. set @strName = ''

  33. set @dwid = 0

  35. set @dur = 0

  37. set @StackSize = 0

  39. set @i = @ii * 8 + 1

  41. select @row=count( * ) from item_decoded where straccountid=@strAccountID

  43. if @row>0

  45. begin

  47. Set @Cdwid = Substring(cast(@dwid as varbinary(4)), 4, 1) + Substring(cast(@dwid as varbinary(4)), 3, 1) + Substring(cast(@dwid as varbinary(4)), 2, 1) + Substring(cast(@dwid as varbinary(4)), 1, 1)

  49. Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as varchar(2))

  51. Set @Cstack = cast(Substring(cast(@StackSize as varbinary(2)), 2, 1)+Substring(cast(@StackSize as varbinary(2)), 1, 1) as varchar(2))

  53. update WareHouse set WareHouseData = cast( substring(WareHouseData, 1, @i-1) + cast(cast(@Cdwid as varchar(4)) + @Cdur + @Cstack as varchar(8)) + substring(WareHouseData, @i+8, 1601-@i) as binary(1600)) where strAccountID = @strAccountID

  55. end

  57. FETCH NEXT FROM Backup_Cursor2 INTO @strAccountID,@ii

  59. END

  61. CLOSE Backup_Cursor2

  63. DEALLOCATE Backup_Cursor2

  65. truncate table item_decoded

  67. truncate table dupers_logged
复制代码
ctgwglzc
2009-7-24 20:39:24
楼主

举报

ow this will detect dupes if one item is in the character and the other/others are in the warehouse. Even across different users/accounts.

To run this all your need to do is this:
  1. exec decode_all_items_1299
复制代码
1111
2009-7-25 16:01:24

举报

直接查询分析器?
1111
2009-7-25 16:01:45

举报

都干什么用 有点中文提示就好了哈
B Color Image Link Quote Code Smilies
高级模式
游客
返回
发布新主题
ctgwglzc
积分
169744 		主题
8709 		精华
13
作者最近主题
内容均来自互联网如侵犯您的权利请邮件:[email protected] 鄂ICP备07001904号