Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Find EXC Pendant/Ring ShadowBugged

Newbie Spellweaver
Joined
Dec 28, 2004
Messages
33
Reaction score
1
Hi there,
this is a code that I've just made to find EXC pendant or ring above +0 (with shadow bug).

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
SELECT Name FROM Character
OPEN STORAGE
FETCH NEXT FROM STORAGE INTO @NameList
WHILE @@FETCH_STATUS = 0
begin

set @Inv = (select 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'

what this would do?
it will only show you WHO has shadow bugged pendant/ring (WEARING THEM) in query analyzer results pane

enjoy! :thumbup:

*updated: works on any 97d version
( I don't know if it works for others versions )
 
Last edited:
Newbie Spellweaver
Joined
Dec 28, 2004
Messages
33
Reaction score
1
sry, I posted in wrong section. Could any mod move it to release section?
 
Newbie Spellweaver
Joined
Oct 20, 2004
Messages
19
Reaction score
0
and what is the version for any item made by this method ?
 
Newbie Spellweaver
Joined
May 15, 2005
Messages
5
Reaction score
0
searh only exel ring ang pendant or ring +6 +7 +8... ?
 
Newbie Spellweaver
Joined
Dec 28, 2004
Messages
33
Reaction score
1
it searchs rings and pendants exc above +0
 
Newbie Spellweaver
Joined
May 15, 2005
Messages
5
Reaction score
0
Strange I today have checked up on the a server there is nothing and before I have thrown to myself exc rings +6 , +7...
 
Newbie Spellweaver
Joined
Dec 28, 2004
Messages
33
Reaction score
1
ah, just a note:
the code checks pendants and rings that users are actually wearing them! not the ones on inv/vault.
 
Newbie Spellweaver
Joined
May 15, 2005
Messages
5
Reaction score
0
All exactly does not work, I can not so it I start...

Query analizer -> Login -> Change MuOnline -> execute
 
Newbie Spellweaver
Joined
Oct 2, 2006
Messages
19
Reaction score
0
Re: [Release] Find EXC Pendant/Ring ShadowBugged

sorry nkerz do you know any way like this to find and erase all ancient items on the DB, I am having sometroubles with this kind of items so I would like to erase them before to try to resets all accounts =o(
 
Junior Spellweaver
Joined
Oct 9, 2005
Messages
149
Reaction score
7
Re: [Release] Find EXC Pendant/Ring ShadowBugged

sorry nkerz do you know any way like this to find and erase all ancient items on the DB, I am having sometroubles with this kind of items so I would like to erase them before to try to resets all accounts =o(

on release post time MuServer`s don`t have ancient items :p
 
Banned
Banned
Joined
Feb 21, 2007
Messages
360
Reaction score
28
Re: [Release] Find EXC Pendant/Ring ShadowBugged

where can i see who have rings,pendants (shadowbugged)
 
Back
Top