Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Page 1 of 11 1 2 3 ... LastLast
Results 1 to 10 of 109
  1. #1
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    Review 'n Rating System

    Hello, I am desperately searching for a Reviews 'n Rating Sytem (like the one in hotscripts, resourceindex etc). I would prefer to be free. The one who finds me a working one will get 10 turtle dollars
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations

  2.  

  3. #2
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times

  4. #3
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    I wish it could be downloaded
    Plus I need it for multiple pages
    Can anyone make one or suggest ???
    (If you make I can give u adviews on my Website)
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations

  5. #4
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    Is it based upon databased content?

  6. #5
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    Ok, well I'll do my best to help you (or whoever wants to build it) with the architecture.

    I think it should be pretty simple, depending on how you wanna do it.

    If you're going with a database, here's a MySQL schema of how you can do it.
    Code:
    CREATE TABLE item (
        id int(11) NOT NULL auto_increment,
        name varchar(255) NOT NULL,
        description text NOT NULL,
        url varchar(255) NOT NULL,
        date_created datetime NOT NULL DEFAULT NOW(),
        PRIMARY KEY (id)
    )
    
    CREATE TABLE user (
        id int(11) NOT NULL auto_increment,
        first_name varchar(255) NOT NULL,
        last_name varchar(255) NOT NULL,
        date_joined datetime NOT NULL DEFAULT NOW(),
        PRIMARY KEY (id)
    )
    
    CREATE TABLE rating (
        id int(11) NOT NULL auto_increment,
        user_id int(11) UNSIGNED NOT NULL REFERENCES user(id),
        item_id int(11) UNSIGNED NOT NULL REFERENCES item(id),
        value int(11) NOT NULL,
        comments text NULL,
        date_created datetime NOT NULL DEFAULT NOW(),
        PRIMARY KEY (id)
    )
    That's about as complex a schema as you can get for a rating system. I'm basing this on MySQL as your database. I'll post queries a bit later.

  7. #6
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    Incidentally, you might already have an "item" table... it is a generic representation of any table that you have that stores the items that you want to rate (such as articles or software or scripts or whatever).

  8. #7
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    Here are some queries to go with the above schema:
    Code:
    -- Get a list of all items and their ratings
    SELECT
        item.*,
        SUM(rating.value) / COUNT(rating.value) AS value
    FROM 
        rating
        INNER JOIN item ON item.id = rating.item_id
    -- WHERE item.id = $item_id -- optional for specific item
    GROUP BY 
        item.id
    
    -- Get all comments / ratings related to one item
    SELECT
        item.id AS item_id,
        item.name AS item_name,
        item.description AS item_description,
        user.id AS user_id,
        user.first_name || ' ' || user.last_name AS user_name,
        rating.id,
        rating.value,
        rating.comments
    FROM 
        item
        INNER JOIN rating ON rating.item_id = item.id
        INNER JOIN user ON rating.user_id = user.id
    WHERE item.id = $item_id

  9. #8
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    Thanks, can u complete that scripts ? I will give u as much as adviews you want to my Webmasters Site. (Maximum 100.000 adviews)
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations

  10. #9
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    I'll do my best.... I'm not too good w/ PHP

  11. #10
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    What are you going to be rating in your website? What other information do you want stored about them?


Page 1 of 11 1 2 3 ... LastLast

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 10:37 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com