Item Rank

07/22/2013 10:02 ILowe#1

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");

[Only registered and activated users can see links. Click Here To Register...]

07/22/2013 20:32 鳳凰城#2

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.

07/23/2013 01:10 ILowe#3

Quote:

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

07/23/2013 01:45 鳳凰城#4

Quote:

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

Remove it.

07/23/2013 02:23 ILowe#5

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

07/23/2013 06:02 鳳凰城#6

Its in html/css. specified in html/css

07/26/2013 06:26 Zodiao#7

Quote:

$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...

07/27/2013 04:25 Royalblades#8

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