Coding my own Shop - Need help with items...
 

As of now, I have a fully operational admin script, and a partially completed shop script...

I say partialy completed, because each store is going to be hand-coded, and that will take time...

I need help with automating the script, so that the item they are purchasing gets entered into their user item's list (useritems) in the user table...

The variable for the item name is $name...

How would I make it insert the item, but not overwrite any previous data, and make sure there is some sort of distinction between Items, like a comma or something...

Satan

:confused: Nobody want to help me?:(:cry:

Satan

I have very basic knowledge of php and SQL, but basically you want to read the data, and the new piece onto the end, and then re-instert it... but you already knew that. Hope someone else can help more than me :)

Or what you COULD do, is have a field for every item in the member table, and when they buy it change it from "no" to "yes", and then when displaying the image, you could just say list from XXX fields where item = yes. Just an idea.

I don't know if I'm going to have images - The stores are going to be quite big;)

Unfortunately, due to the size of the shops, I doubt I could have a field in the user table for every single item:(

Satan

Hmm, well... I wouldnt do it having a field with all their items in it, I think it poses to many problems. but it would make expansion, ie adding new items to the store, easier... its just making it work!

Ah:)

Shop finished!:)

With help from NTLDR, I managed to figure out how to insert a value into the Database and add a comma and space between items;):)

Satan

*lool* After much confussion good to see it finished :D

Cool! So how much longer til we get a release? Or is it virtually ready to go?

@OrangeCow - I don't know that I am going to release;)

Its taken a bit of time, and it still isn't tweaked to my satisfaction...

Thanks NTLDR - This part of it is finally done yes!:)

Like I said - I may not release, or I may update bits etc and release it;)

:)

Satan

Where is the url to your shop? Is it active on your site yet?