can this hack have option:

a select tool to see who has the most feedback or a list of feedback users that have been rated?

this way we can see if users just play with users profiles, we are able to moderate that.

Well I was planning a top X page, but I think you are wanting something a little different, like who rated the most people list?

no...a page that list who has been ranked....maybe threw adminCP. That way, it would be easy to know if some1 has been ranked and doesnt know it, and it might be some useless or not valid ranking....

not even a page, maybe on the member list page, to have their rank count listed, and be able to sort them.

I have installed this on vB 2.3 and everything works great except for this morning I have received 3 Errors. I have looked and I think there might be a problem as it is addressing there is no ratetradetotal....

Here is the error...

Database error in vBulletin 2.3.0:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid,ratetradetotal
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid = '954692'

mysql error: Table 'gunsnet.ratetradetotal' doesn't exist

mysql error number: 1146

Date: Tuesday 06th of May 2003 11:48:08 AM
Script: http://www.gunsnet.net/forums/forums...&postid=954692
Referer: http://www.gunsnet.net/forums/showth...692#post954692


eoc Jason, I want to first thank you for an awesome program and second you think we may be able to fix this?

I did personally change the USER table to reflect the change --> ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;


Thanks

@bowhunt

Looks like u never ran:

[sql]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;[/sql]

I ran it.

PRIMARY KEY (userrateid),
KEY rateduser (userid)
);

That might be my problem, but I am guessing.

Keyname Type Cardinality Action Field
PRIMARY PRIMARY 566 Drop Edit userrateid
userrateid
rateduser INDEX 94 Drop Edit userid

bowhunt - I've run into that probably occationally before, and I can't seem to trace down the error... it's few and far between when I see it so it's hard to determine the cause.

I've seen the same error happen with the other user ratings hack. :(

Well I guess I see it more when I have a very active website. We have on average 700 to 900 people online at any even time so yeah we have quite a few people using the program on deals they have done together.

I surely wish someone could fix it for sure.