Item Rank

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


---

http://img585.imageshack.us/img585/2235/063d.png

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

Code:

---


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 ^^

again ? all tablet have ?

Code:

---


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

ok thx

How can I hide the GM?

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

.php How can I hide the GM

Code:

---


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.