How do I go about designing this system?

[xomissjaye]

I've been looking for something like this since forever.  I see it on most German Sites but I can never seem to find a tutorial.  It seems like a CMS system.  I want to find out how they are able to have categories and are able to let the visitors sort to content to whatever they are looking for.  They also can organize it occording to how recent it was added.  I know they should have a log in type thing.  Which probably makes life so much easier.  Here are some examples:

 

http://www.fire-graphics.org/

http://celestial-star.net/layouts/new/  (i love how this is set up)

http://crystal-diamonds.de/layouts.php

http://the-peril.com/

http://shizoo-design.de/

 

Some even have their layouts pointing to an html page?  I would love any advise you can give me Thanks :]

 

[ignace]

http://celestial-star.net/layouts/type/div/ euhm.. looks like they are going to make it you easy in finding out how they did it.

[pthurmond]

Sorting and filtering output results is really easy and you can do it from two different areas. The best way is on the server side in PHP. You just either use a small form or links with _GET vars in them and then check those vars for certain conditions and then use those conditions in your SQL query for filtering and sorting.

 

If you are looking for the CMS they use then good luck. I didn't see anything I recognized in the output as coming from a particular CMS (not that that is not easy to hide).

 

Are there any other specific features you want to be able to do? I can give you some SQL examples if you want.

 

[ignace]

Actually you can do this quiet easy:

 

CREATE TABLE products (
    products_id INTEGER NOT NULL AUTO_INCREMENT,
    products_categories_id SMALLINT,
    products_series_id SMALLINT, # is product part of some series?
    products_users_id SMALLINT, # used to sort on top submitter
    products_type VARCHAR(32), # used to sort on div layout, table layout, ..
    products_preview_count SMALLINT, # used to sort on most reviewed
    products_download_count SMALLINT, # used to sort on most downloaded
    products_added_date DATETIME, # used to sort on newest
    KEY fk_products_categories_id (products_categories_id),
    KEY fk_products_series_id (products_series_id),
    KEY fk_products_users_id (products_users_id),
    PRIMARY KEY (products_id)
);

CREATE TABLE products_series (
    products_series_id SMALLINT NOT NULL AUTO_INCREMENT,
    products_series_title VARCHAR(64),
    products_series_description TEXT,
    PRIMARY KEY (products_series_id)
);

CREATE TABLE products_ratings ( # used to sort by most rated
    products_ratings_products_id INTEGER NOT NULL,
    products_ratings_rating TINYINT, # number from 1 to 127 possible
    products_ratings_count SMALLINT, # times voted for that specific number
    PRIMARY KEY (products_ratings_products_id, products_ratings_rating)
);

#INSERT INTO products_ratings (products_ratings_products_id, products_ratings_rating) VALUES (1, 5) ON DUPLICATE KEY products_ratings_count = products_ratings_count + 1

CREATE TABLE categories (
    categories_id SMALLINT NOT NULL AUTO_INCREMENT,
    categories_name VARCHAR(32),
    PRIMARY KEY (categories_id)
);