Item Rank

[ILowe]

hello

item rank .php I want to hide all the tablets, but how?

the basic code

PHP Code:

$query = mssql_query("select top 100 it.OptLevel, ch.CharName16, obj.AssocFileIcon128, obj.Country
    from _Items as it
    LEFT JOIN [dbo].[_Inventory] as inv ON it.ID64 = inv.ItemID
    LEFT JOIN [dbo].[_Char] as ch ON inv.CharID = ch.CharID
    LEFT JOIN [dbo].[_RefObjCommon] as obj ON it.RefItemID = obj.ID
    where ch.CharName16 is not NULL
    ORDER BY it.OptLevel DESC"); 


[鳳凰城]

You're giving us the basic query line which is not related to these tablets? really? share the whole ranking.php so we can help you.

[ILowe]

Originally Posted by Phoenix 1337

You're giving us the basic query line which is not related to these tablets? really? share the whole ranking.php so we can help you.

with a special message sent

[鳳凰城]

echo '<td><img src="./img/'.$row['AssocFileIcon128'].'.png" width="32" height="32" alt=""/></td>';

Remove it.

[ILowe]

All items will don't appear , I just want to hide tablet

[鳳凰城]

Its in html/css. specified in html/css

[Zodiao]

$query = mssql_query("select top 100 it.OptLevel, ch.CharName16, obj.AssocFileIcon128, obj.Country
from _Items as it
LEFT JOIN [dbo].[_Inventory] as inv ON it.ID64 = inv.ItemID
LEFT JOIN [dbo].[_Char] as ch ON inv.CharID = ch.CharID
LEFT JOIN [dbo].[_RefObjCommon] as obj ON it.RefItemID = obj.ID
where ch.CharName16 is not NULL
ORDER BY it.OptLevel DESC");

well, just add a role which makes an exception for stones :



where ch.CharName16 is not NULL AND CODENAME128 NOT LIKE '%STONE%'

^Just a template...

[Royalblades]

select top 100 it.OptLevel, ch.CharName16, obj.AssocFileIcon128, obj.Country
from _Items as it
INNER JOIN [dbo].[_Inventory] as inv ON it.ID64 = inv.ItemID
INNER JOIN [dbo].[_Char] as ch ON inv.CharID = ch.CharID
INNER JOIN [dbo].[_RefObjCommon] as obj ON it.RefItemID = obj.ID
where ch.CharName16 is not NULL AND obj.TypeID1 = 3 AND ch.charname16 not in (select charname from _guildmember where guildid = (select guildid from _char where charname='ONE CHARNAME FROM YOUR GM GUILD'))
ORDER BY it.OptLevel DESC