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

[lazydesis]

thanks ..its a good mod

[Megatr0n]

Originally Posted by Deceptor

I'll make an update with that being optional, I did consider it during the design phase but felt it'd look too bloaty. Each to their own I guess

Regarding "how many times a user been added on Mini Statistics", what do you mean exactly?

Sorry Deceptor, I meant how many times a user has been rated and an overall average of their rating to be showing on the Mini Statistics area.

Something like this. See attachment below.

Also, how about a rating scale 1 - 10?

[kaptanblack]

Thanks very nice..

[RvG2]

Deceptor, this is very nice

[Deceptor]

Originally Posted by Megatr0n

Sorry Deceptor, I meant how many times a user has been rated and an overall average of their rating to be showing on the Mini Statistics area.

Something like this. See attachment below.

Also, how about a rating scale 1 - 10?

Ah I see, I get you now, no problem

As rating 1-10, I'm afraid not due to consistency, every default part of vBulletin that has ratings is the same 1-5 star, such as threads, and blogs. It would be inconsistent not to do that here, and consistency is key to great design

[Megatr0n]

Hey Deceptor,

No problem but if you can implement the other suggestions. That'd be awesome!

[rob01]

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, 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 vbb_thread AS thread
			LEFT JOIN vbb_post AS post ON (post.postid = thread.firstpostid)
			LEFT JOIN vbb_user AS user ON (user.userid = post.userid)
			 LEFT JOIN vbb_postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1) LEFT JOIN vbb_icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN vbb_avatar as avatar ON (avatar.avatarid = user.avatarid)
				LEFT JOIN vbb_customavatar as customavatar ON (customavatar.userid = user.userid) LEFT JOIN vbb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
			WHERE thread.threadid IN(41,39,38,36,34,33,32,24,22,21)
			AND thread.dateline > 1222304002

any idea?

[Deceptor]

rob01 - Where is this error occuring, can you show me the rest of it?

[Megatr0n]

Hi Deceptor,

When will be the next update be available with the suggested features?

I hope it's before Xmas.

[Deceptor]

Not sure I'll be able to squeeze it out today, but I'll try