Profile Enhancements - [AJAX/vBOptimise] vB Profile Ratings 1.0.0

vB Profile Ratings

vB Profile Ratings is an add on for vBulletin which will allow your forum users to rate user profiles, just like they would for threads.

Features

• On/Off Switch
• Ratings are AJAX
• Add Profile Ratings to member profiles
• Show "Top Rated" member on forum home (Optional)
• Optionally integrate into vB Optimise, killing the extra query this mod adds to your member pages.
• Ability to choose how "Top Rated" is calculated.
• Ability to allow members rate themselves
• Ability to allow members to change previous ratings they've made on a member

Change Log
No changes as of yet

Enjoy

[Megatr0n]

Deceptor, when will this hack be updated next?

[Deceptor]

It's the next one to recieve an update, after I've finished off something else first Probably today, latest tomorrow.

[Megatr0n]

Awesome.

[Sweeks]

Installed but for some reason no one can rate me and everyone else is rateable. We have two administrators me and my girlfriend, she can be rated but I cant and I am the only who cant be rated. Any ideas?

Marked as installed! VB 3.7.4 PL1

A suggestion would be to have a right side profile block with all of the rating stuff in. I tried myself but couldnt get it to work without a db error.

I also want to move the Top Rated Member to the header template, any ideas?
________
No2 Vaporizer

[GrendelKhan{TSU]

awesome.

anyway to be able to show a small thumbb of the profile image or user's avatar in the forum stats? that would be leet

[christian8a]

Originally Posted by MissKalunji

Yes it does work

*suggestion* instead of having the drop down menue maybe we can have it similar to youtube where you can select on the stars themselves? i don't know if you get what i'm saying?

Check image below

I seccond this, I think vb needs to change that drop down menu to the actual day type of usage. This rating mod Is one of the ones Ive been waiting for but will wait a bit to see some changes, hopefully that star rating one instead of drop dow
Good job man ill keep my eye on this mod

[Sweeks]

Originally Posted by christian8a

I seccond this, I think vb needs to change that drop down menu to the actual day type of usage. This rating mod Is one of the ones Ive been waiting for but will wait a bit to see some changes, hopefully that star rating one instead of drop dow
Good job man ill keep my eye on this mod

Agreed. Clicking on the stars is much better than a drop down. A mini avatar on forumhome of the top rated member would be awesome too!
________
Yamaha dragstar 650 specifications

[VbNuts]

Hello,

This is a great mod but it does not work with Vbadvance. I got a mysql error message when i went to visit my front page.

I installed product, did the template edits, then i went to go to my front page and got the following error.

Database error in vBulletin 3.8.0 Release Candidate 2:

Invalid SQL:

			SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, user.*, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
			, allowsmilie, pagetext_html, postparsed.hasimages, showsignature, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usertextfield.signature, thread.iconid AS threadiconid, iconpath AS threadiconpath, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
			FROM thread AS thread
			LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
			LEFT JOIN user AS user ON (user.userid = post.userid)
			 LEFT JOIN postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 9 AND postparsed.languageid = 1)
				LEFT JOIN sigparsed AS sigparsed ON (sigparsed.userid = user.userid AND sigparsed.styleid = 9 AND sigparsed.languageid = 1)
				LEFT JOIN sigpic AS sigpic ON (sigpic.userid = post.userid)
				LEFT JOIN usertextfield AS usertextfield ON (user.userid = usertextfield.userid) LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
				LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid) LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
			WHERE thread.threadid IN(41,4,3)
			AND thread.dateline > 1222907756
			
			
			ORDER BY thread.dateline DESC
			LIMIT 10;

MySQL Error   : Column 'votenum' in field list is ambiguous
Error Number  : 1052
Request Date  : Tuesday, December 30th 2008 @ 06:35:56 PM
Error Date    : Tuesday, December 30th 2008 @ 06:35:56 PM
Script        : 
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community

I then wanted to make sure that this was because of this mod so i disabled the product still got the error, i then went to uninstall it and that corrected everything.

I am using the latest version of vb 3.8

Please help.

[VbNuts]

Any support on this issue?

[TimberFloorAu]

will this work on 3.7.4?