[AJAX/vBOptimise] vB Profile Ratings 1.0.0

[Deceptor]

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 (https://vborg.vbsupport.ru/misc.php?do=producthelp&pid=__vb_active_caching), 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]

Awesome man. You've made my day and Xmas!! :D

Just one little thing to add. Can you show an overall average of their rating and HOW many times a user been added on "Mini Statistics"?

I'll love you forever! :)

[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?

[Deceptor]

Update: Fixed typo in javascript and in uninstall code.

[Hasann]

Nice mod Deceptor thank you

btw can you add view who rated option

[Deceptor]

Thanks Hasann,

Sounds like a reasonable thing to show, yeah, you think it'd look best in a tab on the profile?

[Hasann]

Yes best way to show in vB version 3.8 in a tab
I like to see who rated option like this mod https://vborg.vbsupport.ru/showthread.php?t=61635
but this mod is for old vb version there's a no tab

[Deceptor]

Alrighty :) I'll do just that, update will probably be tomorrow since it's nearly 4am my time.

[m2006]

thank you for mod good..

[Huy Ho?ng]

Nice. Install

[lazydesis]

thanks ..its a good mod

[Megatr0n]

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? :p

[kaptanblack]

Thanks very nice..

[RvG2]

Deceptor, this is very nice :)

[Deceptor]

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? :p
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! :D

[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? :D

I hope it's before Xmas. :)

[Deceptor]

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

[Megatr0n]

My fingers are crossed. :D

[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. :D

[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,11 4,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)? :D

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

[Deceptor]

Megatron - I can definately say Yes to that request :)

[Megatr0n]

Megatron - I can definately say Yes to that request :)

Awesome.

Have an date in mind? :D

[Megatr0n]

Megatron - I can definately say Yes to that request :)

Sorry Deceptor but I had another requested feature in mind.

Maybe the user being notified via PM when they've been rated? :)

[Deceptor]

I could probably do that in an update after the next, though I don't think it'd be worth much really, all the same it could be optional I guess :)

[Megatr0n]

Sounds good. :)

[MissKalunji]

think this will work on 3.7.4?

[Deceptor]

It's untested MissKalunji, but I see no reason it shouldn't work, give it a try :) At the most your members page may be temporarily disabled/have an error, in which cause just uninstall the product and you're all good.

[MissKalunji]

nop don't seem to be working...i don't see anything even after doing the template change

Edit : Flush cache don't seem to work properly i had to turn vb optimize off and put it back on for it to show

[Deceptor]

If you have problems with vB Optimise flush cache, please post over in that thread and I'll assist you :)

As for the profile ratings, are they working as expected?

[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

[Deceptor]

Hey,

I'd do the suggestion but for the sake of keeping things in vB consistent I'll leave it as a drop down menu I'm afraid :)

[MissKalunji]

okay Cool

[Megatr0n]

Deceptor, when will this hack be updated next? :D

[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. :D

I also want to move the Top Rated Member to the header template, any ideas?
________
No2 Vaporizer (http://www.vaporshop.com)

[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]

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 :D
Good job man ill keep my eye on this mod

[Sweeks]

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 :D
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 (http://www.yamaha-tech.com/wiki/Yamaha_DragStar_650)

[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?

[tecnozul]

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.

I have this same problem :(

[Sweeks]

Working 3.7.4 here
________
Gang Bang Asian (http://www.++++tube.com/categories/583/asian/videos/1)

[tecnozul]

my version is 3.8

[C138 Kaysone]

problem i have is its not showing up in my admin cp to configure

[Cerbero1000]

No way to work on my 3.7.5
There is a problem (all pages) in class_profilerating.php on line 12

[DoubleGlasses]

I'm loving this mod! Thanks for it. I'd having one bug with it using Vbulletin 3.8.2.... for some reason my stats won't show on the home page. I'm able to vote on profiles but not see who the top rated person is.

Any suggestions?

[The4um]

thank you, looks so nice

[xlcstaff]

Hi, i'm trying to put $profilerating in postbit lgacy but nothing!
How can i put the stars there?

[andy2295]

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.



Yes confirmed as well. I just removed the mod and the problem is gone. Quite simply do not use this mod if you have vbadvanced installed

[joomla]

Thank you excellent

[DNG]

seems nice, thanks

[Feanor_87]

Yes confirmed as well. I just removed the mod and the problem is gone. Quite simply do not use this mod if you have vbadvanced installed
Yeah... this sucks. Oh well, it would have been a good MOD to have

[badheeu]

when installing this mod I get this error

Fatal error: Call to undefined method vb_activecache::flush() in /home/kmamv/domains/kma-forum.com/public_html/includes/adminfunctions_template.php(2359) : eval()'d code on line 6

[Cerbero1000]

Working fine now! I'll pay to have a module with top 10/20 users by rating...
Please contact me info@tarantulas.it