-ProtectoR- Level 2
Брой мнения : 38 Birthday : 01.01.1995 Join date : 19.08.2013 Age : 29 Местожителство : България My Hobbie : Street Fitness,Anime
| Заглавие: [Guide] Как да се защитим от ShadowBug с Ring Нед Авг 25, 2013 12:27 am | |
| - Код:
-
DECLARE @NameList varchar(10), @cnt int declare @Inv binary(760), @Pendant binary(10), @Ring1 binary(10), @Ring2 binary(10)
set @cnt = 0 DECLARE STORAGE CURSOR LOCAL FOR !@#$%^ Name FROM Character OPEN STORAGE FETCH NEXT FROM STORAGE INTO @NameList WHILE @@FETCH_STATUS = 0 begin
set @Inv = (!@#$%^ inventory from Character where name = @NameList and isnull(ctlcode,0)<>8) set @Pendant = SUBSTRING(@inv,91,10) set @Ring1 = SUBSTRING(@inv,101,10) set @Ring2 = SUBSTRING(@inv,111,10)
if (SUBSTRING(@Pendant,2,1) > 0x08) and (SUBSTRING(@Pendant,2,1) <> 0xFF) and (SUBSTRING(@Pendant,8,1) > 0x80) and (SUBSTRING(@Pendant,8,1) <> 0x00) and (SUBSTRING(@Pendant,8,1) <> 0xC0) begin print @NameList+' have exc pendant above +0' set @cnt = @cnt + 1 end if (SUBSTRING(@Ring1,2,1) > 0x08) and (SUBSTRING(@Ring1,2,1) <> 0xFF) and (SUBSTRING(@Ring1,8,1) > 0x80) and (SUBSTRING(@Ring1,8,1) <> 0x00) and (SUBSTRING(@Ring1,8,1) <> 0xC0) begin print @NameList+' have exc ring above +0' set @cnt = @cnt + 1 end if (SUBSTRING(@Ring2,2,1) > 0x08) and (SUBSTRING(@Ring2,2,1) <> 0xFF) and (SUBSTRING(@Ring2,8,1) > 0x80) and (SUBSTRING(@Ring2,8,1) <> 0x00) and (SUBSTRING(@Ring2,8,1) <> 0xC0) begin print @NameList+' have exc ring above +0' set @cnt = @cnt + 1 end FETCH NEXT FROM STORAGE INTO @NameList end CLOSE STORAGE DEALLOCATE STORAGE print convert(varchar,@cnt) + ' Illegal item(s) found' Просто го пускате в Query Analyzera и проблема е решен :) | |
|
WorldMU Level 1
Брой мнения : 6 Birthday : 01.01.1990 Join date : 23.10.2013 Age : 34 Местожителство : SOFIA My Hobbie : MuOnline Owner My Humor :
| Заглавие: Re: [Guide] Как да се защитим от ShadowBug с Ring Съб Окт 26, 2013 7:37 pm | |
| Ще пробвaм но дa нямa някaкви стрaнични процеси. | |
|