vb.org Archive - Profile Enhancements - [AJAX/vBOptimise] vB Profile Ratings 1.0.0

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Profile Enhancements - [AJAX/vBOptimise] vB Profile Ratings 1.0.0 (https://vborg.vbsupport.ru/showthread.php?t=199568)

Deceptor

12-22-2008 10:00 PM

[AJAX/vBOptimise] vB Profile Ratings 1.0.0

1 Attachment(s)

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

12-23-2008 12:37 AM

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

12-23-2008 12:39 AM

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

12-23-2008 01:15 AM

Update: Fixed typo in javascript and in uninstall code.

Hasann

12-23-2008 01:20 AM

Nice mod Deceptor thank you

btw can you add view who rated option

Deceptor

12-23-2008 01:21 AM

Thanks Hasann,

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

Hasann

12-23-2008 01:25 AM

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

12-23-2008 01:27 AM

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

m2006

12-23-2008 09:47 AM

thank you for mod good..

Huy Ho?ng

12-23-2008 10:09 AM

Nice. Install

lazydesis

12-23-2008 12:07 PM

thanks ..its a good mod

Megatr0n

12-23-2008 12:09 PM

Quote:

Originally Posted by Deceptor (Post 1691585)

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

12-23-2008 12:16 PM

Thanks very nice..

RvG2	12-23-2008 03:54 PM

Deceptor, this is very nice :)

Deceptor

12-23-2008 07:15 PM

Quote:

Originally Posted by Megatr0n (Post 1691923)

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

12-23-2008 07:22 PM

Hey Deceptor,

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

rob01

12-23-2008 10:55 PM

Code:

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

12-24-2008 01:07 AM

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

Megatr0n

12-24-2008 11:45 AM

Hi Deceptor,

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

I hope it's before Xmas. :)

Deceptor

12-24-2008 11:47 AM

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

Megatr0n

12-24-2008 01:09 PM

My fingers are crossed. :D

YsTyle

12-24-2008 07:48 PM

great mod, installed :)

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

Megatr0n

12-24-2008 09:14 PM

I hope this hack gets updated soon. :D

rob01

12-24-2008 09:42 PM

uhmm when i try to go into User CP

Deceptor

12-25-2008 10:00 AM

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

t?rkg?rc?

12-25-2008 07:37 PM

Code:

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

12-25-2008 11:43 PM

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

Megatr0n

12-25-2008 11:57 PM

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

12-26-2008 03:58 PM

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

Megatr0n

12-26-2008 05:42 PM

Quote:

Originally Posted by Deceptor (Post 1694121)

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

Awesome.

Have an date in mind? :D

Megatr0n

12-26-2008 10:09 PM

Quote:

Originally Posted by Deceptor (Post 1694121)

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

12-26-2008 10:13 PM

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

12-26-2008 11:28 PM

Sounds good. :)

MissKalunji

12-27-2008 04:32 PM

think this will work on 3.7.4?

Deceptor

12-27-2008 04:37 PM

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

12-27-2008 04:50 PM

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

12-27-2008 04:56 PM

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

12-27-2008 04:57 PM

1 Attachment(s)

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

12-27-2008 05:26 PM

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

12-27-2008 05:30 PM

okay Cool

All times are GMT. The time now is 07:13 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01253 seconds Memory Usage 1,818KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: