PDA

View Full Version : Buy / Sell / Trade User Rating System


devrykid
08-26-2003, 10:55 PM
i have phpMyAdmin 2.4.0 and installed Buy / Sell / Trade User Rating System version 1.11 and dont know how to set up:
-----------------------------------------------------------------
2. Execute the following SQL Queries (Can be done in PHPMyAdmin):
-----------------------------------------------------------------

CREATE TABLE user_rate_trade (
userrateid INT(10) unsigned NOT NULL auto_increment,
rateduser INT(10) unsigned DEFAULT '0' NOT NULL,
userid INT(10) unsigned DEFAULT '0' NOT NULL,
userrating SMALLINT(6) DEFAULT '0' NOT NULL,
userbuysell TINYINT(1) DEFAULT '0' NOT NULL,
userdate DATE DEFAULT '0000-00-00' NOT NULL,
usercomments VARCHAR(80) NOT NULL,
userurl VARCHAR(255) NOT NULL,
PRIMARY KEY (userrateid),
KEY rateduser (userid)
);

ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;

i go through ipowerweb.com and was wanting to know if anyone could help me out??