How to store for a store.

Edison

Hello.

Im trying to make a PhP RPG Store. And Im having trouble Storing the Items that the user has, I want to know how exactly I could store the items in a single cell of a table, all help is appreicated thanks.

-Edison-

FrozNic

read a tutorial?! codemonkey.com should help! it's not something someone can simply tell u how to do. if u want to use d-bases, read how to use them, once you know how to use them then u can ask more specific questions, because the question you just asked is not simply a matter of telling u how to fix one line of code. your asking how to build an entire website.

Edison

Sorry bout that. I didnt mean to be so general. I was just in a hurry and all. Ok, this is my deal. I know how to make the store, but the only problem im having is trying to figure out some way to store the items that my users purchase in a Items cell on the database.

Hmm, lets see if I can get even MORE specific.

Alright, I have already coded a Currency system for a RPG engine type thing, it is just a collection of scripts and such that will make it ALOT easier to run an online RPG.

I know how to make it so it checks how much money one has, and if they can purchase it. I know how to make it so that it would add or subtract the item, its just I need to know how the items in a users account would be stored together, like a totally seperate row and table, and I could edit and show the items that the user has easily.

Get my drift now? Ill go to the site you suggested. Thanks for your help.

-Edison-

FrozNic

im not sure i understand exactly what you're saying but lemee put this idea up and tell me if it's close to what you're doing.

diablo 2 and ever quest both have this method of game play, where if a user has bought or picked up an item, it not only goes into his inventory but posts somewhere so that uniqly he's the only one with those items. so, in essence, if your user picks up an item, place it into a table called, say, inventory and make another table called inventoryItems or whatever. in table inventory store values like this:

Player | InventoryItemsID
FrozNic | 12, 43, 35, 32, 822

comma delemted...
or another way to make this table would be, if you have only a certain amount of items that a player can have, make that many columns and once the columns are filled, the player can't have anymore items...

so it would look like this:

Player | item1 | item2 | item3 | etc
FrozNic | 12 | 43 | 35 | 32 | 822 | etc

in inventoryItems, store values like this:

ID | item
12 | shortsword

and any other details you want with it (abilities for that item (etc))

does that makes sense? i'm not sure if that's your problem but if it is, that should work just fine.

Edison

That is kinda what im talking about.

Exactly what im trying to say is kinda hard.

Alright, lets say. Me, Edison, buys a short sword from a shop.

The fact that I now own a short sword, idealy, would be recorded into the MySQL database. Inside of a table that would have all my, Edisons, information, like name, lvl, bio, cash, etc. It would have a cell called Items.

And when I go to check out my stats in the stats page, where it would show all my information, which would just be an echo of all the values in the table, it would show all my items, neatly.

Now here is my question. If I buy more than one item:
1. Would I store them in the same cell.
2. If I did, how would I seperate them.
3. Also, how would I show that I have them all? Would I use an array or something?
4. If I could seperate them with comma's , how would I insert a comma after every entry?

This question is really bugging me. I hope it makes sense now.

Edison

::bump::