Team BlueWater Game Online Tutorial's
Bine ati venit la Team-BlueWater!!Tutorial's 4 all Games!

[Release] SQL Code: Search who has EXC Full Opts

View previous topic View next topic Go down

[Release] SQL Code: Search who has EXC Full Opts

Post  m4s4cru on Tue Aug 02, 2011 10:18 am

This is a code I found in MG forum.

It searchs for exc full item

RUN THIS IN QUERY ANALYZER:
Code:
select * from warehouse where (charindex (0xbf, items) %10=8) or (charindex (0xff, items) %10=8) or (charindex (0x7f, items) %10=8) or (charindex (0x3f, items) %10=8)
select * from character where (charindex (0xbf, inventory) %10=8) or (charindex (0xff, inventory) %10=8) or (charindex (0x7f, inventory) %10=8) or (charindex (0x3f, inventory) %10=8)
now, if you want to BLOCK char who have those items, u can change it a little bit:
[/code]
Code:
update character set CtlCode = '1' where (charindex (0xbf, inventory) %10=8) or (charindex (0xff, inventory) %10=8) or (charindex (0x7f, inventory) %10=8) or (charindex (0x3f, inventory) %10=8)
this one only blocks who have those items in inventory.

Ban all excepting GMs
Code:
update character set CtlCode = '1' where ((charindex (0xbf, inventory) %10=8) or (charindex (0xff, inventory) %10=8) or (charindex (0x7f, inventory) %10=8) or (charindex (0x3f, inventory) %10=8)) and (CtlCode <> '8')

you can play with it a little bit, maybe if you manage some complete code (checking and banning all) you can release it in here
avatar
m4s4cru
Admin
Admin

Mesaje : 172
Data de inscriere : 2011-07-29
Varsta : 26

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum