Any one have...

Any one have Highest player items plus ranking on php
And Referral system php script to add it on my website system !

I can watch later if i find my query.
The query also watch for the optional pkus value of an item ( advance elixier )
I will post it later here.
Is query fine? Or you need hole php script?

Quote:

---

Originally Posted by LordCloud

I can watch later if i find my query.
The query also watch for the optional pkus value of an item ( advance elixier )
I will post it later here.
Is query fine? Or you need hole php script?

---

its ok if give me both of them xD

This is query to get all plus values from player inventory. Its ordered by plusvalue. So highest plus is first result.
Should be easy for you to use this query in PHP now.
Is this fine ? Or did you need something else ?

Code:

---

select item.RefItemID, item.OptLevel, adv.nOptValue, ref.CodeName128, chars.CharName16
FROM _Items as item
left join _RefObjCommon as ref on item.RefItemID = ref.ID
left join _BindingOptionWithItem as adv on item.ID64 = adv.nItemDBID
left join _Inventory as inv on item.ID64 = inv.ItemID
left join _Char as chars on inv.CharID = chars.CharID
WHERE
ref.CodeName128 not like 'item_etc%'
and ref.CodeName128 not like 'item_mall%'
and adv.bOptType = 2
and chars.CharName16 is not NULL
order by OptLevel desc

---

Quote:

---

Originally Posted by LordCloud

This is query to get all plus values from player inventory. Its ordered by plusvalue. So highest plus is first result.
Should be easy for you to use this query in PHP now.
Is this fine ? Or did you need something else ?

Code:

---

select item.RefItemID, item.OptLevel, adv.nOptValue, ref.CodeName128, chars.CharName16
FROM _Items as item
left join _RefObjCommon as ref on item.RefItemID = ref.ID
left join _BindingOptionWithItem as adv on item.ID64 = adv.nItemDBID
left join _Inventory as inv on item.ID64 = inv.ItemID
left join _Char as chars on inv.CharID = chars.CharID
WHERE
ref.CodeName128 not like 'item_etc%'
and ref.CodeName128 not like 'item_mall%'
and adv.bOptType = 2
and chars.CharName16 is not NULL
order by OptLevel desc

---

---

Thanks :)

but i need also in php because im not perfect on php :) still newbie

Than i need information which design you use. I dont know your website si i dont know if you want this as a module ...
Or show me where you want to add this information.
I also need the way how you use the database connect.

just give me the php source with database connection and i will add it to my website design

You use mysql command in yournohp or odbc or something else?
There are lot of ways to implement such things so a bit more details would be helpfull if you want php script from me.