What exactly are the issues you're having? More details please
I thought I'd leave that to the PMs, but hey...why not?
The site in progress is at www.toytraderz.com
, which I hope to have live by June some time. One feature of the site is a Toy Database, the main page of which can be found here:http://www.toytraderz.com/index.php?name=ttgallery
The structure of this CMS's image gallery is like so. First there are categories, which can have related subcategories. Then the albums (which hold images and info) are attached to the applicable category or subcategory. Examples you’ll see on the site now are:
Star Wars > Modern
Star Wars > Modern > Hasbro – Saga (2006-present)
Star Wars > Modern > Hasbro – Saga (2006-present) > Figures
These categories then have albums which hold each item’s details and images. For instance, the Hasbro – Saga 2006 category > Figures category has a subcategory of albums for each item in that line, shown here:http://www.toytraderz.com/index.php?name=ttgallery&cat=28
Each album then has a set of images. So data is pulled from a categories table, an albums table, and a pictures table.
You can see on the main gallery page what one of the problems is. The main Star Wars category, when you total up everything in the applicable subcategories, has 751 items and 341 images. But as you can see it doesn’t show this aggregate count in the main gallery menu or sub categories – it only shows “0” unless the next level down is the album itself. Example can be seen here:http://www.toytraderz.com/index.php?name=ttgallery&cat=25
Where all these categories have subcategories except Kubrick, so they're all showing 0 except Kubrick's count of 2.
The second issue is the search. It appears to be using an “or” operator to search rather than an “and”. Here is the search page:http://www.toytraderz.com/index.php?name=ttgallery&file=search
Let’s say I type in “Alien”. I get 43 items. I type in “game” and I get 6 items. Now, if I want to put in “Alien Game”, I should only get the 6 items, but instead I’m getting 43 because it’s searching to see if the keywords has game *or* Alien, not game *and* Alien. I know what the issue is here, I just don't know how to fix it.
I really didn't want to show this until it was ready to launch, but no biggie...anyone bored enough is welcome to get in there and make some posts in the forum to get things going.
Coincidentally, if anyone feels like contributing to the site, let me know. There's a ton of work to do in the toy database and I know there are some knowledgable collectors out there that would loooove to help.