PROCEDURE SITE JOGANDOMU

[rodrigopf]

Boa noite, alguem poderia me ajudar com esta procedure, estou modificando o site do jogandomu pra versao 97d+1.0 (FOXMUTEAM), porem não sei os pontos certos para mudar, o varbinary do bau eh 1920 e esse esta configurado para 3840, o louis falou q tem q mudar de 16 para 10 porem ja mudei e nao surgiu efeito algum....

CREATE PROCEDURE [dbo].[VERIFICAR_ITENS]
@uid varchar(20),
@type binary(2)
AS

Begin 

SET NoCOUNT ON
DECLARE
@wh_acid varchar(10),
@wh_data binary(3840),
@wh_type binary(2),
@wh_full binary(1),
@wh_serial binary(4),
@wj_serial binary(4),
@wh_13 binary(1),
@k int,
@j int,
@qtd int,
@find int,
@conn int

SELECT @conn = (SELECT top 1 connectstat FROM memb_stat where memb___id=@uid)

SET @k=0
SET @qtd=0
SET @find=0

if @conn = 0 
BEGIN
--Verifica Baú
SELECT @wh_data=items FROM warehouse where accountid = @uid

WHILE @k<120 AND @wh_data IS NOT NULL
BEGIN
SET @wh_type=SUBSTRING(@wh_data,@k*16+1,2)
SET @k=@k+1

IF 
@wh_type <> @type
and @wh_type <> 0xFFFF
BEGIN
SET @find = 1
END
END

SET @k=0

--Verifica Baú
IF @find = 0 
BEGIN

WHILE @k<120 AND @wh_data IS NOT NULL
BEGIN
SET @wh_type=SUBSTRING(@wh_data,@k*16+1,2)
SET @wh_serial=SUBSTRING(@wh_data,@k*16+4,4)
SET @wh_13=SUBSTRING(@wh_data,@k*16+8,1)
SET @k=@k+1

IF 
@wh_type = @type
BEGIN
SET @find=0
SET @j=0

WHILE @j < (@k-1)
BEGIN
SET @wj_serial=SUBSTRING(@wh_data,@j*16+4,4)
SET @j=@j+1

IF @wj_serial = @wh_serial
BEGIN
SET @find=1
INSERT INTO LOG_DUPE_EVENTO (login,serial,evento) VALUES (@uid, @wj_serial,'K5')
END
END

set @wh_data = substring(@wh_data ,1,16*@j)+0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF+substring(@wh_data,16*@j+17,len(@wh_data))

IF @find=0 and @wh_serial<>0x00000000
BEGIN
SET @qtd = @qtd+1
END

END
END
END
IF @qtd >= 120 
BEGIN
update [warehouse] set [items]=@wh_data where [AccountId]=@uid

if @type = 0x0E00
begin
declare @nome varchar(10)
select @nome = dbo.fn_char_forte(@uid)
if exists (select login from mk_medalhas where login = @uid and name = @nome)
UPDATE MK_MEDALHAS SET medal_joias=1 where name = @nome
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_joias) VALUES (@uid,@nome,1)
end
END
END

select @qtd as qtd, @find as find

END