just tested it. this works.. and it even goes in the db when you loggout. so this works like perfect. now we just need a perfect anti tool:-P
i made a sql like this:
Quote:
Select
ci.CharID
,ci.Type
,ci.TypeID
,i.ItemName
,i.ReqLevel
,ci.Bag
,ci.Slot
,ci.ItemUID
,ci.Craftname
,ci.Gem1
,ci.Gem2
,ci.Gem3
,ci.Gem4
,ci.Gem5
,ci.Gem6
,ci.Quality
,ci.Count
,ci.Del
From PS_GameData.dbo.CharItems ci
inner join PS_GameDefs.dbo.Items i
on ci.Type=i.Type and ci.TypeID = i.TypeID
Where
i.ReqLevel < 31 and ci.Gem1='7' or
i.ReqLevel < 31 and ci.Gem1='14' or
i.ReqLevel < 31 and ci.Gem1='21' or
i.ReqLevel < 31 and ci.Gem1='28' or
i.ReqLevel < 31 and ci.Gem1='35' or
i.ReqLevel < 31 and ci.Gem1='42' or
i.ReqLevel < 31 and ci.Gem1='49' or
i.ReqLevel < 31 and ci.Gem1='56' or
i.ReqLevel < 31 and ci.Gem1='63' or
i.ReqLevel < 31 and ci.Gem1='82' or
i.ReqLevel < 31 and ci.Gem1='96' or
i.ReqLevel < 31 and ci.Gem1='105' or
i.ReqLevel < 31 and ci.Gem1='124' or
i.ReqLevel < 31 and ci.Gem1='125' or
i.ReqLevel < 31 and ci.Gem1='126' or
i.ReqLevel < 31 and ci.Gem1='127' or
i.ReqLevel < 31 and ci.Gem1='143' or
i.ReqLevel < 31 and ci.Gem1='150' or
i.ReqLevel < 31 and ci.Gem1='177' or
i.ReqLevel < 31 and ci.Gem1='178' or
i.ReqLevel < 31 and ci.Gem1='179' or
i.ReqLevel < 31 and ci.Gem1='180' or
i.ReqLevel < 31 and ci.Gem1='189' or
i.ReqLevel < 31 and ci.Gem1='190' or
i.ReqLevel < 31 and ci.Gem1='241' or
i.ReqLevel < 31 and ci.Gem1='242' or
i.ReqLevel < 31 and ci.Gem1='243' or
i.ReqLevel < 31 and ci.Gem1='254' or
i.ReqLevel < 31 and ci.Gem1='255'
or
i.ReqLevel < 31 and ci.Gem2='7' or
i.ReqLevel < 31 and ci.Gem2='14' or
i.ReqLevel < 31 and ci.Gem2='21' or
i.ReqLevel < 31 and ci.Gem2='28' or
i.ReqLevel < 31 and ci.Gem2='35' or
i.ReqLevel < 31 and ci.Gem2='42' or
i.ReqLevel < 31 and ci.Gem2='49' or
i.ReqLevel < 31 and ci.Gem2='56' or
i.ReqLevel < 31 and ci.Gem2='63' or
i.ReqLevel < 31 and ci.Gem2='82' or
i.ReqLevel < 31 and ci.Gem2='96' or
i.ReqLevel < 31 and ci.Gem2='105' or
i.ReqLevel < 31 and ci.Gem2='124' or
i.ReqLevel < 31 and ci.Gem2='125' or
i.ReqLevel < 31 and ci.Gem2='126' or
i.ReqLevel < 31 and ci.Gem2='127' or
i.ReqLevel < 31 and ci.Gem2='143' or
i.ReqLevel < 31 and ci.Gem2='150' or
i.ReqLevel < 31 and ci.Gem2='177' or
i.ReqLevel < 31 and ci.Gem2='178' or
i.ReqLevel < 31 and ci.Gem2='179' or
i.ReqLevel < 31 and ci.Gem2='180' or
i.ReqLevel < 31 and ci.Gem2='189' or
i.ReqLevel < 31 and ci.Gem2='190' or
i.ReqLevel < 31 and ci.Gem2='241' or
i.ReqLevel < 31 and ci.Gem2='242' or
i.ReqLevel < 31 and ci.Gem2='243' or
i.ReqLevel < 31 and ci.Gem2='254' or
i.ReqLevel < 31 and ci.Gem2='255'
or
i.ReqLevel < 31 and ci.Gem3='7' or
i.ReqLevel < 31 and ci.Gem3='14' or
i.ReqLevel < 31 and ci.Gem3='21' or
i.ReqLevel < 31 and ci.Gem3='28' or
i.ReqLevel < 31 and ci.Gem3='35' or
i.ReqLevel < 31 and ci.Gem3='42' or
i.ReqLevel < 31 and ci.Gem3='49' or
i.ReqLevel < 31 and ci.Gem3='56' or
i.ReqLevel < 31 and ci.Gem3='63' or
i.ReqLevel < 31 and ci.Gem3='82' or
i.ReqLevel < 31 and ci.Gem3='96' or
i.ReqLevel < 31 and ci.Gem3='105' or
i.ReqLevel < 31 and ci.Gem3='124' or
i.ReqLevel < 31 and ci.Gem3='125' or
i.ReqLevel < 31 and ci.Gem3='126' or
i.ReqLevel < 31 and ci.Gem3='127' or
i.ReqLevel < 31 and ci.Gem3='143' or
i.ReqLevel < 31 and ci.Gem3='150' or
i.ReqLevel < 31 and ci.Gem3='177' or
i.ReqLevel < 31 and ci.Gem3='178' or
i.ReqLevel < 31 and ci.Gem3='179' or
i.ReqLevel < 31 and ci.Gem3='180' or
i.ReqLevel < 31 and ci.Gem3='189' or
i.ReqLevel < 31 and ci.Gem3='190' or
i.ReqLevel < 31 and ci.Gem3='241' or
i.ReqLevel < 31 and ci.Gem3='242' or
i.ReqLevel < 31 and ci.Gem3='243' or
i.ReqLevel < 31 and ci.Gem3='254' or
i.ReqLevel < 31 and ci.Gem3='255'
or
i.ReqLevel < 31 and ci.Gem4='7' or
i.ReqLevel < 31 and ci.Gem4='14' or
i.ReqLevel < 31 and ci.Gem4='21' or
i.ReqLevel < 31 and ci.Gem4='28' or
i.ReqLevel < 31 and ci.Gem4='35' or
i.ReqLevel < 31 and ci.Gem4='42' or
i.ReqLevel < 31 and ci.Gem4='49' or
i.ReqLevel < 31 and ci.Gem4='56' or
i.ReqLevel < 31 and ci.Gem4='63' or
i.ReqLevel < 31 and ci.Gem4='82' or
i.ReqLevel < 31 and ci.Gem4='96' or
i.ReqLevel < 31 and ci.Gem4='105' or
i.ReqLevel < 31 and ci.Gem4='124' or
i.ReqLevel < 31 and ci.Gem4='125' or
i.ReqLevel < 31 and ci.Gem4='126' or
i.ReqLevel < 31 and ci.Gem4='127' or
i.ReqLevel < 31 and ci.Gem4='143' or
i.ReqLevel < 31 and ci.Gem4='150' or
i.ReqLevel < 31 and ci.Gem4='177' or
i.ReqLevel < 31 and ci.Gem4='178' or
i.ReqLevel < 31 and ci.Gem4='179' or
i.ReqLevel < 31 and ci.Gem4='180' or
i.ReqLevel < 31 and ci.Gem4='189' or
i.ReqLevel < 31 and ci.Gem4='190' or
i.ReqLevel < 31 and ci.Gem4='241' or
i.ReqLevel < 31 and ci.Gem4='242' or
i.ReqLevel < 31 and ci.Gem4='243' or
i.ReqLevel < 31 and ci.Gem4='254' or
i.ReqLevel < 31 and ci.Gem4='255'
or
i.ReqLevel < 31 and ci.Gem5='7' or
i.ReqLevel < 31 and ci.Gem5='14' or
i.ReqLevel < 31 and ci.Gem5='21' or
i.ReqLevel < 31 and ci.Gem5='28' or
i.ReqLevel < 31 and ci.Gem5='35' or
i.ReqLevel < 31 and ci.Gem5='42' or
i.ReqLevel < 31 and ci.Gem5='49' or
i.ReqLevel < 31 and ci.Gem5='56' or
i.ReqLevel < 31 and ci.Gem5='63' or
i.ReqLevel < 31 and ci.Gem5='82' or
i.ReqLevel < 31 and ci.Gem5='96' or
i.ReqLevel < 31 and ci.Gem5='105' or
i.ReqLevel < 31 and ci.Gem5='124' or
i.ReqLevel < 31 and ci.Gem5='125' or
i.ReqLevel < 31 and ci.Gem5='126' or
i.ReqLevel < 31 and ci.Gem5='127' or
i.ReqLevel < 31 and ci.Gem5='143' or
i.ReqLevel < 31 and ci.Gem5='150' or
i.ReqLevel < 31 and ci.Gem5='177' or
i.ReqLevel < 31 and ci.Gem5='178' or
i.ReqLevel < 31 and ci.Gem5='179' or
i.ReqLevel < 31 and ci.Gem5='180' or
i.ReqLevel < 31 and ci.Gem5='189' or
i.ReqLevel < 31 and ci.Gem5='190' or
i.ReqLevel < 31 and ci.Gem5='241' or
i.ReqLevel < 31 and ci.Gem5='242' or
i.ReqLevel < 31 and ci.Gem5='243' or
i.ReqLevel < 31 and ci.Gem5='254' or
i.ReqLevel < 31 and ci.Gem5='255'
|
this is my item list so change it to your item list..
but this is only for checking. for now i'm going to give them 1 chance to get clean if not banning is the option:-P
but if some have a way to make this as a command please share:-)
i don't know why capes always end up in this lapis query's but they do.. LOL no capes are not normaly linked..even tho they say so in the db..