Item Rank

[loveme]

hello

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

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

[MentaL]

[Royalblade]

hmm dont know if 3 is the right number.. been some times i touched those things... but try this

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 AND obj.TypeID1 = 3
    ORDER BY it.OptLevel DESC

Keep in mind, this should only show you items now...equipable items. At least for Chinese chars, you might have to look up the type for euros. However, u get the idea ^^

[loveme]

again ? all tablet have ?

[Royalblade]

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     ORDER BY it.OptLevel DESC

I just tried it out with inner joins... it works perfectly. dont know what your doing wrong

[loveme]

ok thx

[loveme]

How can I hide the GM?

[MaDenGo]

could you release to us that item rank file/php/script ?

[loveme]

.php How can I hide the GM

[Royalblade]

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 LIKE '_GM_%'
ORDER BY it.OptLevel DESC

Underscore = "can be anything, but only 1 character"
% sign = "can be anything, multiple characters"

just try it out and itll work.