Can Some One Help?

[Byronwells]

I am using a membership script.. Under admin setting there is a section where I am allowed to add categories to the site.. At the moment the standard format only allows me to add a parent/main category.

I would like this to be changed so that I am able to sub categories to the parent/main categories if I so wish..

So that I can have this format

2010 (main)
mar (sub)
feb (sub)

I have been told that I need to create a new table on the db, lets called it subcategories so that I can store the sub categories information..

Also because I wish to be able to choose multiple categories when I am adding a product to the site, I will need to create another table, called subtrack, to track all the categories..

I have created both tables, with the information that I have been told to..

Now I am onto the stage where I need to link them altogether and then to display it on the add categories page..

[djr33]

This is very complex and there will be no easy answer. Your "membership script" is a piece of code that does not allow what you want. You could try to modify it, but modifying existing code to a great degree can be very complex. At the very least you would need to show us how that works (for example, the database structure).

In the end it may just be easier to rewrite the entire setup rather than customizing. This all depends on how "open" the code is to modification. If it is very well written and documented it may not be hard at all. If it is messy and unclear then it will be very hard.


The basic method you described is right: create new places in the database to store info and link that to the members as needed. Then insert data as needed. Of course the real question becomes how to structure and organize all of this, not the individual commands.

[Byronwells]

This is very complex and there will be no easy answer. Your "membership script" is a piece of code that does not allow what you want. You could try to modify it, but modifying existing code to a great degree can be very complex. At the very least you would need to show us how that works (for example, the database structure).

In the end it may just be easier to rewrite the entire setup rather than customizing. This all depends on how "open" the code is to modification. If it is very well written and documented it may not be hard at all. If it is messy and unclear then it will be very hard.


The basic method you described is right: create new places in the database to store info and link that to the members as needed. Then insert data as needed. Of course the real question becomes how to structure and organize all of this, not the individual commands.

You can see the db structure here..
http://www.digitalresellersvault.com/template/megagame_digital.sql

[djr33]

Ok, but we also need to know how the current script works. It would be possible to rewrite everything based on the current database structure, but it's probably simpler in that case to just start over.
The real question is how complex this CMS (content management system) is that you are using-- if it's too complex it may be difficult to modify.
I'd suggest looking into hiring someone to work on this because while it's easy enough to work with databases, store info, display things, etc., creating a new level within an existing script can be very difficult and time consuming mostly because we need to figure out what the script is doing. The actual modifications are usually fast once the code is understood.

[traq]

What CMS are you using? I'd be willing to look at the scripts you're using and let you know how practical it might be to modify them. You can contact me here (www.custom-anything.com/contactme.php).