Log in

View Full Version : Coding my own Shop - Need help with items...


Chris M
12-19-2002, 11:00 PM
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

Chris M
12-20-2002, 08:10 AM
:confused: Nobody want to help me?:(:cry:

Satan

Ember
12-20-2002, 01:16 PM
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.

Chris M
12-20-2002, 01:30 PM
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

Ember
12-20-2002, 01:47 PM
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!

Chris M
12-20-2002, 06:52 PM
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

NTLDR
12-20-2002, 07:06 PM
*lool* After much confussion good to see it finished :D

Ember
12-21-2002, 01:36 AM
Cool! So how much longer til we get a release? Or is it virtually ready to go?

Chris M
12-21-2002, 06:22 AM
@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

DrkFusion
12-21-2002, 03:51 PM
Where is the url to your shop? Is it active on your site yet?

Chris M
12-21-2002, 04:44 PM
@Arunan - I'm not going to put it on DarkBlazes Forums yet;)

Its on my test vB site, and will be part of a new website I am currently planning/building online;)

I will be buying another Domain name, and possibly another package with XPera (if Dan will allow it), and start up the site:)

Satan

Dean C
12-21-2002, 04:46 PM
Whats XPera?

- miSt

DrkFusion
12-21-2002, 05:36 PM
Originally posted by hellsatan
@Arunan - I'm not going to put it on DarkBlazes Forums yet;)

Its on my test vB site, and will be part of a new website I am currently planning/building online;)

I will be buying another Domain name, and possibly another package with XPera (if Dan will allow it), and start up the site:)

Satan
Dan will be more than happy to hehe, ask him about multi-domain hosting, or even resselling, do I still have access to the test board?

DrkFusion
12-21-2002, 05:37 PM
Originally posted by Mist
Whats XPera?

- miSt
They are a hosting company, and the same team is developing the well-awaited, secure, daiTRIX Linux.

Chris M
12-21-2002, 05:56 PM
Heh...

I don't know about reselling - I might if its better and cheaper than 2 packages;)

I did talk about Multi-domains;)

I'd prefer them to be seperate though;):)

This is a different testboard than you have access to;)

If you'd like, I can talk to you online about it:)

Satan

DrkFusion
12-21-2002, 05:58 PM
I think Reselling costs about the same as the 2 packages. Talk to him about it :)

Chris M
12-21-2002, 06:21 PM
I shall:)

Satan

zajako
12-21-2002, 06:53 PM
sounds like you want your shop system to be similar to the shop system that comes with the rpg hack, install it on a test board and see if it is anything like you want. If so then take whatever coding you need :]

Chris M
12-21-2002, 07:41 PM
Thanks zajako;) I'll definately investigate it;)

See if there is anything that can improve either;):)

Satan

Chris M
12-21-2002, 07:52 PM
Er...Where is it?:confused:

Satan

DrkFusion
12-21-2002, 10:00 PM
UHh, not sure what he means, but maybe Item Shop or something.

Chris M
12-22-2002, 10:51 AM
I think he means the RPG hack he is coding or has coded:confused:

Satan