I`m working on a website for a little silkroad pserver at the moment and I want to display the item-infos of every item a char is carrying.
Im using these queries to find the common information about an item. The problem is that the second query only returns the default values of the item, not the pimped ones.
Code:
SELECT *
FROM sro_vt_shard.dbo._items AS item
LEFT JOIN sro_vt_shard.dbo._refitemnames AS n
ON n.itemid = item.refitemid
WHERE item.id64 = XXXXXXXXX
Code:
SELECT *
FROM sro_vt_shard.dbo._refobjcommon AS refcommon
LEFT JOIN sro_vt_shard.dbo._refobjitem AS refitem
ON refitem.id = refcommon.link
WHERE refcommon.id = XXXX
These are the connections between database and item that i already found out, but please remember that these are only the correct values of the items that you bought from an NPC (+0% no blues).
PHP Code:
//Required level: ReqLevel1
//PattackMax_L: Physical Attack Lower
//PattackMax_U: Physical Attack Upper
//PAttackInc: Physical Attack Increase
//MAttackMin_L: Magical Attack Lower
//MAttackMin_U: Magical Attack Uppwer
//MAttackInc: Magical Attach Increase
//Dur_L: Durability
//Range: Attack distance : 10
//HR_L: Attack Rate (HR_U, HRInc)
//Critical: CHR_L (CHR_U)
//PAStrMin_L to PAStrMax_L: Physical reinforce
//MAInt_Min_L to MAInt_Max_L: Magical reinforce
//ReqGender: 1 = male, 0 = female, 2 = both
//MaxMagicOptCount: Max. no. of magic options: XUnit
greetz Rubba-Lipped Robba
