hello , i have created a method of what i would do to achieve what you trying to do ...

All items would be stored in its own table so eg.. 'rpg_items'

each item created in the world will have its own id along with its own stats.

table 'rpg_items' may contain such fields as 'id' , 'lvl' , 'type'.. ect

e.g


id: 8292 | lvl: 50| type: weapon | item_name: sword-of-a-thousand-truths | stats: stabina/80***health/200|
id: 8293 | lvl: 1| type: resource | item_name: brown-bread | stats: health/20|



--

All clients would be stored in their own table so eg.. 'rpg_client'

each client created in the world will have there own row of fields

eg.

user: huntysin | pass: AHJKHIUJH76786KJHSJH|items_on: 2342,5454,23,34255,53|inventory: 232,233,5,3,4,235,2323,43,5,36,6,3,45,346,3,46,3,4 6,346|


----


so when flash wants to request the inventory, all you do is send your inventory array (witch contains all of the item id's) to a php script that searches each id in the array and parses the information into something that flash can read.

e.g echoing something looking like this.

&item0=8292,50,weapon, sword-of-a-thousand-truths, stabina/80***health/200&
&item1=8293,1,resource,brown-bread, health/20&


witch will then be parsed with your own flash functions to put the data into use.

---

hope this all makes sense and helps.