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]

My fingers are crossed.

[YsTyle]

great mod, installed

how can i make it show only one star when user is not ranked?

[Megatr0n]

I hope this hack gets updated soon.

[rob01]

uhmm when i try to go into User CP

[Deceptor]

This mod doesn't effect User CP rob01, what version of vB are you running? This is designed for 3.8

[t?rkg?rc?]

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,
		 
			thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
			thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
			thread.prefixid, thread.taglist, hiddencount, deletedcount
			
			, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
			, threadread.readtime AS threadread
			, threadredirect.expires
			, post_user.displaygroupid AS post_user_displaygid, post_user.usergroupid AS post_user_usergid, last_post_user.displaygroupid AS last_post_user_displaygid, last_post_user.usergroupid AS last_post_user_usergid
		FROM thread AS thread
			LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
			
			 LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
			
			
			LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
			LEFT JOIN user AS last_post_user ON (thread.lastposter = last_post_user.username)
LEFT JOIN user AS post_user ON (thread.postuserid = post_user.userid)
		WHERE thread.threadid IN (0,772,1391,1377,1375,103,776,1204,1118,112,113,114,116,115,109,107,106,105,104) 
		ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Column 'votenum' in field list is ambiguous
Error Number  : 1052
Request Date  : Thursday, December 25th 2008 @ 11:36:26 PM
Error Date    : Thursday, December 25th 2008 @ 11:36:26 PM
Script        : http://www.xxxxxxxxx.com/forumdisplay.php?f=9
Referrer      : http://www.xxxxxxxx.com/index.php
IP Address    : xxxxxxxxxxxx
Username      : xxxxxxx
Classname     : vB_Database
MySQL Version : 5.0.45

[Deceptor]

turk - I'll see if I can replicate the issue, so far I haven't been able to myself.

[Megatr0n]

Hi Deceptor,

Hope you had a fantastic Xmas and have a wonderful New Years Eve.

Do you think this hack will be updated before NYE with the requested features (including Hassan's)?

Just waiting for them to be squeezed in before I install it.

[Deceptor]

Megatron - I can definately say Yes to that request

[Megatr0n]

Originally Posted by Deceptor

Megatron - I can definately say Yes to that request

Awesome.

Have an date in mind?