vB.org Rating System Replica

[Rich]

I applogize for releasing this modification again for a second time. The initial thread has gone insane and literally doubles and triples ALL of my posts each time I have responded to the thread. I am not certain why, but it only occurs in that thread, so here we go again. lol

This modification will replicate the rating system found here on vBulletin.org. There is currently a release by Magnus out there that does some of this.

This version functions just like vb.orgs.

If you wish to see how this will appear, you can view the top of any page where there is a thread here on the .org. That rating box is what you will be installing.

I mean no disrespect to Magnus for releasing this modification. (It isn't his code, but he released something very similar.) I wanted to be able to support it and update the thread as needed.

------------------------------------------------------------------------------------------------

New Updated File Includes The Corrections To Make The Change Voting Work.

[Brandon Sheley]

Thanks, will check it out

I think a user said this version doesn't use AJAX like the version used here ?

[Rich]

Hello,

This version doesn't use ajax, though it is something I will be looking into tomorrow.

[optrex]

Thanks Rich. Ill wait until the next update before installing then, so I dont have to do things twice over.

[YsTyle]

thanks - installed :)

[obmob]

Well, i've been trying to make this work as vb.org... so far, no luck.

Is it me, or it only allows you one vote per thread?

I've voted, logged out and logged in with a regular user and i can't vote again. :(

[Rich]

Hello,

I am currently packaging up the corrected version. I have it all worked out. I should be releasing it within the next 15 minutes or so.

Update:

The attached zip (first thread) includes the template edits as well as the plugin required to make this work. Ajax now functions as it should and multiple ratings has returned. (Sorry about that.) All in all, it should be all set now.

[obmob]

Congratulations, it seems to be working! :D

Will test some more and see if i didn't miss something, i'm getting the "you voted popup" when submitting my vote. :p

thanks

[Rich]

Hello,

I currently have this running on my site. I ran it past 10 of my users, and not a single error arose. (Which is why I released it.) Let me know if you get it squared away.

[obmob]

Just the popup message, i changed this:

<script type="text/javascript" src="clientscript/vbulletin_ajax_threadrate.js?v=368"></script>
<script type="text/javascript">
<!--
vB_AJAX_ThreadRate_Init('showthread_threadrate_for m');
var threadid = $threadinfo[threadid];
//-->
</script>

For this:

<script type="text/javascript" src="clientscript/vbulletin_ajax_threadrate.js?v=368"></script>
<script type="text/javascript">
<!--
vB_AJAX_ThreadRate_Init('showthread_threadrate_for m');
var threadid = $threadinfo[threadid];
window.alert = null;
//-->
</script>

Thank you! :D

[Rich]

I updated the zip file with the nullified window alert. Thanks obmob!

[Stoebi]

Hi

thank you very much for your nice module :)
My wish is to see what i voted for.
Example:
Rating: **
My wish:
Your voted for this $thread_title: *** - Average Rating: **


The original Rating allows me to change my vote. Can you rerealize this too, please?


What do you think about my wishes?


Kind Regards, Stoebi

[optrex]

Great ideas Stoebi - this has a lot of potential.

[Smiry Kin's]

Possible to turn into a product? hate my templates looking messy..

Also what is the plugin used for? i did all the templates, it worked perfectly.. ajax etc..?

[rayphua]

1. Thread rating does not show in search for New Posts.

2. When we set "Required Thread Rating Votes to Show Rating" in Admincp to 2 or more, a single vote still does not do anything. Click on Vote Now and the box still stays there, does not disappear or anything, like nothing is happening.

[Mecho]

Hey .. i installed this hack but it seems this one is not working for me too ..

i will pm u ( Rich ) my site detail and i will appreciate if u can check , of course if u have time ;)

[Rich]

Possible to turn into a product? hate my templates looking messy..

Also what is the plugin used for? i did all the templates, it worked perfectly.. ajax etc..?

The reason it isn't a product is because most users have a modified SHOWTHREAD template. I would hate for this mod to break the functionality of modifications they may already have, or modifications that have made to sections that require editting.

The plugin queries the threadrate table to see if the user has voted already or not. If they have, it shows the rating. If they haven't, it shows the rate box.

Stoebi, I will look into that this weekend. (I work full-time and have 2 kids. lol)

1. Thread rating does not show in search for New Posts.

2. When we set "Required Thread Rating Votes to Show Rating" in Admincp to 2 or more, a single vote still does not do anything. Click on Vote Now and the box still stays there, does not disappear or anything, like nothing is happening.

I will also look into this as well.

Hey .. i installed this hack but it seems this one is not working for me too ..

i will pm u ( Rich ) my site detail and i will appreciate if u can check , of course if u have time

I contacted him back and found his site has a few java errors that are causing the problems. Once those are located and corrected, this should work fine on his site.

[obmob]

Still playing around, so far, it seems to be working just fine. :D

[rb290]

Got any previews?

[Rich]

Taken from my release post:

If you wish to see how this will appear, you can view the top of any page where there is a thread here on the .org. That rating box is what you will be installing.

[esperone]

well done. great mod.

[rainyleaves]

Great Mod!!
Thank you very much for your nice module!!

But I got very big problem.
It's just only my problem.

Your Ajax code conflicts with Vbcredit Mod's ajax code.

Your code:
<script type="text/javascript" src="clientscript/vbulletin_ajax_threadrate.js?v=368"></script>

Vbcredit code:
<script type="text/javascript" src="clientscript/credits_ajax_postadd.js?v=$vboptions[simpleversion]"></script>

I love your mod.
I really want use your mod.
Can I fix the conflicts?
Please...Could you fix the problem?
Sorry my English.

Thanks... :)

[Rich]

Your code:
<script type="text/javascript" src="clientscript/vbulletin_ajax_threadrate.js?v=368"></script>

That should actually be:

<script type="text/javascript" src="clientscript/vbulletin_ajax_threadrate.js?v=$vboptions[simpleversion]"></script>

That slipped by me. Sorry. (I will update the download.) The ajax I am using is actually the default ajax already found in the showthread template.

[TheBlackPoet]

i like this a lot.. thanks... installed

[rayphua]

Hi Rich,

What are the changes done on this new version?

Is the following done?

. Thread rating does not show in search for New Posts.

2. When we set "Required Thread Rating Votes to Show Rating" in Admincp to 2 or more, a single vote still does not do anything. Click on Vote Now and the box still stays there, does not disappear or anything, like nothing is happening.

3. Changing of votes - I don't see where we are able to change the votes.

Further, since this template has changed several times now, I think it is good if you are able to direct these changes for those who installed the previous versions. Instead of us trying to figure out what has changed, there should be info like....add this back in from previous deleted lines...find and delete this line, etc. This would save us a lot of time, and avoid mistakes.

Thanks.

[rainyleaves]

Thanks!! for your time , Rich.

I found my problem.
Conflict code is red code.
I fixed that after deleted the red code.
I think the red code is overlapped with VBcredit's same code.

Anyway, Thanks for your reply. :)

<script type="text/javascript" src="clientscript/vbulletin_ajax_threadrate.js?v=368"></script>
<script type="text/javascript">
<!--
vB_AJAX_ThreadRate_Init('showthread_threadrate_for m');
var threadid = $threadinfo[threadid];
window.alert = null;
//-->
</script>

[djdonx]

This is exactly what I'm looking for, except for one thing..

I only want to apply this to a certain group of forums, not the whole board

Is there a way to do this?

[momo2]

Installed worked like a charm.... thanks so much..

[djdonx]

Any help on my query?

[Snatch]

In the TXT you writes

################################################## ########################################
Find and REMOVE:
################################################## ########################################

</td>
</if>
<if condition="$show['threadrating']">
<td class="vbmenu_control" id="threadrating" nowrap="nowrap">
<a href="$show[nojs_link]#goto_threadrating"><span id="threadrating_current"><if condition="$show['rating']">$vbphrase[rating]: <img class="inlineimg" src="$stylevar[imgdir_rating]/rating_$thread[rating].gif" alt="<phrase 1="$thread[votenum]" 2="$thread[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>" border="0" /><else />$vbphrase[rate_thread]</if></span></a>
<if
But the last <if make en error if I remove it like this.

[Smiry Kin's]

its actually</td>
</if>
<if condition="$show['threadrating']">
<td class="vbmenu_control" id="threadrating" nowrap="nowrap">
<a href="$show[nojs_link]#goto_threadrating"><span id="threadrating_current"><if condition="$show['rating']">$vbphrase[rating]: <img class="inlineimg" src="$stylevar[imgdir_rating]/rating_$thread[rating].gif" alt="<phrase 1="$thread[votenum]" 2="$thread[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>" border="0" /><else />$vbphrase[rate_thread]</if></span></a>
<if condition="$show['popups']"><script type="text/javascript"> vbmenu_register("threadrating"); </script></if>

[MissKalunji]

so does this work? i checked thepoet's website and it doesn't seem to be working on his?

[obmob]

It works, I'm using it on my sites. :p

[MissKalunji]

Cool Thanks!

now i don't mind using it but i wanna place it under the first thread or inside the firs tthread i've tried moving it around and it ain't working

Suggestion?

[obmob]

Hmm... i don't think it's possible to move in to the postbit template, i tried something like that with "similar threads", but never make it work >.<

Maybe Rich knows better.

[MissKalunji]

oh ok i'll keep trying maybe something's missing..
Thanks!

[optrex]

How come this is no longer supported. I thought that was the whole idea of it being released?

I wanted to be able to support it and update the thread as needed.

[Rich]

Hello,

I will be "resupporting" this modification once I get some health issues squared away. Unfortunantly, I have been going in and out of the hospital with some blood clot issues for the past few weeks. The lack of support is due to health and not an actual "support" issue. its hard to support something when you do not know if you will be here the next day to actually do it, which is why I changed the setting until they get everything with me squared away. Sorry.

[obmob]

Health comes first! Take care Rich :D

[thunder_sti]

Great Mod.

Is there a way it can be incorporated into a pictures gallery where members can rate the best pics.

For example like Hot or Not.

[Rich]

thunder_sti: This uses the default rating system that vbulletin supplies. The difference is in how the results and voting process are displayed. To create an image rating system, which there are several image systems for free on the org, you would need something different.

You could take one of the free image galleries on this site that allows for rating of the images and do a rewrite to have it display the voting results consistent with that of "Hot or Not".

MissKalunji: In order to move it like you want to, I believe it would require additional plugins to change where it is displayed. I am only on for a few minutes, and will try to get to looking into placement issues tomorrow. There are no guarantees, but I will look.

djdonx: Yes, that is something that could be incorporated. It isn't something I intended on adding, but I did write the idea down for the upgraded version of this mod I may be writing. I have a few other ideas as well.

Stoebi: That could easily be done but would serve no actual functionality. The only person who would see that would be the person who voted in that thread. The search engines wouldn't see it for seo reasons because that would only display if the person had voted. If you really want to have it anyways, shoot me a PM and I will send you how to accomplish it. It will serve no purpose though since only the person who voted would see it.

I am going to be looking into the thread rating in new posts as well as the vote changing.

[thunder_sti]

Thanks for the reply.

Jose

[The Realist]

Installed and working great.

Get well soon Rich and keep up the good work.

[hipgirl]

Thank you very much for the great mod.

Is it possible to change 'rate this thread' to 'help others by rating'? I'm new to VB. In the script I see "$vbphrase[rate_this_thread]". Seems that I need to change the value of rate_this_thread. Could anybody let me know where I can change the value?

TIA.

Michelle
www.HipGirlClips.com/Forums

[Rich]

Hello,

In the acp:

Choose Languages and Phrases > Search In Phrases > (search for text) rate_this_thread and choose Phrase Variable Name Only at the bottom and click find. Now click edit and enter what you want it to say and hit save. You just changed the phrase. ;) You can do that for any phrase btw.;)

[MissKalunji]

thunder_sti: This uses the default rating system that vbulletin supplies. The difference is in how the results and voting process are displayed. To create an image rating system, which there are several image systems for free on the org, you would need something different.

You could take one of the free image galleries on this site that allows for rating of the images and do a rewrite to have it display the voting results consistent with that of "Hot or Not".

MissKalunji: In order to move it like you want to, I believe it would require additional plugins to change where it is displayed. I am only on for a few minutes, and will try to get to looking into placement issues tomorrow. There are no guarantees, but I will look.

djdonx: Yes, that is something that could be incorporated. It isn't something I intended on adding, but I did write the idea down for the upgraded version of this mod I may be writing. I have a few other ideas as well.

Stoebi: That could easily be done but would serve no actual functionality. The only person who would see that would be the person who voted in that thread. The search engines wouldn't see it for seo reasons because that would only display if the person had voted. If you really want to have it anyways, shoot me a PM and I will send you how to accomplish it. It will serve no purpose though since only the person who voted would see it.

I am going to be looking into the thread rating in new posts as well as the vote changing.

thanks!

[hipgirl]

Thank you so much!

Michelle
www.HipGirlClips.com

[Sevilah]

??????

http://img66.imageshack.us/img66/1787/xs1vf7.gif

[Rich]

Sevilah, In the future, if you have a question, please ask it. Simply adding a picture with a bunch of question marks will typically get you no where.

I am going to assume that you want the average text displayed beside the results. If that is the case, simply do this:


SHOWTHREAD Template:

Find:




<span id="threadrating_current"><if condition="$show['rating']">$vbphrase[rating]: <img class="inlineimg" src="$stylevar[imgdir_rating]/rating_$thread[rating].gif" alt="<phrase 1="$thread[votenum]" 2="$thread[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>" border="0" /></if></span>



Replace with:

<span id="threadrating_current" class="smallfont"><if condition="$show['rating']"><strong>$vbphrase[rating]:</strong> <img class="inlineimg" src="$stylevar[imgdir_rating]/rating_$thread[rating].gif" alt="<phrase 1="$thread[votenum]" 2="$thread[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>" border="0" />&nbsp;&nbsp;(<phrase 1="$thread[votenum]" 2="$thread[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>)</if></span>

In the above code, the smallfont class added to the opening span is optional.

Now you need to edit the phrase: thread_rating_x_votes_y_average in the acp and remove the "Thread Rating:" portion of it and save it.

[obmob]

Maybe that's how Sevilah rates the mod :p

[hipgirl]

I am going to assume that you want the average text displayed beside the results. If that is the case, simply do this:


SHOWTHREAD Template:

Find:




<span id="threadrating_current"><if condition="$show['rating']">$vbphrase[rating]: <img class="inlineimg" src="$stylevar[imgdir_rating]/rating_$thread[rating].gif" alt="<phrase 1="$thread[votenum]" 2="$thread[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>" border="0" /></if></span>



Replace with:

<span id="threadrating_current" class="smallfont"><if condition="$show['rating']"><strong>$vbphrase[rating]:</strong> <img class="inlineimg" src="$stylevar[imgdir_rating]/rating_$thread[rating].gif" alt="<phrase 1="$thread[votenum]" 2="$thread[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>" border="0" />&nbsp;&nbsp;(<phrase 1="$thread[votenum]" 2="$thread[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>)</if></span>

In the above code, the smallfont class added to the opening span is optional.

Now you need to edit the phrase: thread_rating_x_votes_y_average in the acp and remove the "Thread Rating:" portion of it and save it.

Great!!! Just applied.

I noticed that somebody said the rating is not shown in 'new post' search. Same here. Is it solved? I'll keep monitoring this thread.

Thanks again for your time. Get well soon.

Michelle

[columbusgeek]

Any updates on djdonx's request about only showing in certain threads? I need the pretty functionality you have created, but really do not want it on every thread.

***NM, went with tDigg instead. That fit my need better. Sorry Rich***

[yoyoyoyo]

here are the template edits in TMS (Template Modification System) XML format - if anyone has TMS installed all they need to do is import this.

[mrmike]

Thanks! :up:

I'm running 3.5.4 and manage to fix this with some tweak :S

[Snatch]

Since I installed this mod I get this DB-Error


Datenbankfehler in vBulletin 3.6.8:

Invalid SQL:

SELECT *
FROM threadrate
WHERE userid = 1
AND threadid =;

MySQL-Fehler : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
Fehler-Nr. : 1064
Datum : Monday, November 12th 2007 @ 08:44:06 PM

[jaks]

Hi Rich,

What are the changes done on this new version?

Is the following done?

. Thread rating does not show in search for New Posts.

2. When we set "Required Thread Rating Votes to Show Rating" in Admincp to 2 or more, a single vote still does not do anything. Click on Vote Now and the box still stays there, does not disappear or anything, like nothing is happening.



Hi Rich! I hope all is well with your health.

This will be a great addition to my site however the points made by rayhua I quoted above are still issues. I can live with the rating not showing in the search for now but #2 is a serious issue since it doesn't go past the first vote. When viewing the thread you see the vote box and not the actual rating. No one can can vote now. :(

Has anyone figured out this issue and if so what is the fix?

Thanks
Jon

[NFLfbJunkie]

How can I increase the spacing between the rating selections so there's not a lot ofsapce to the left of the "Excellent" selection and to the right of the "Vote Now" button?

[masons]

Great ad-on!//

3.6.8(2) worked fine and very easy to install!

[ctfortner]

This worked great for my site, 3.6.8 (2). very easy to add, thanks for the mod, LOVE it

[tyranny]

Installed and working perfect. Using it with GARS too and it is exactly what I am looking for.

I added the code below around your voting box so only those who can vote can see it.


<if condition="$show['threadrating']">
your code here
</if>


Now it is only showing to those who can vote. I also made it show no box after voting and put the average rating inside the post as you mentioned above. Fantastic.

Thanks!

[ctfortner]

I cant figure that part out about putting the average rating inside the post, how did you do that? I did apply the code to display the average rating, but dont see how to put it inside the post?

thanks

[Sulaiti]

Great hack ....

I believe you need only update this part



<div align="left"><span class="ratetext">$vbphrase[rate_this_thread] - <em>$thread[title]</em>.</span></div>
<a name="goto_threadrating"></a>
<label for="vote5"><input type="radio" name="vote" id="vote5" value="5" />Excellent</label>
<label for="vote4"><input type="radio" name="vote" id="vote4" value="4" />Good</label>
<label for="vote3"><input type="radio" name="vote" id="vote3" value="3" />Average</label>
<label for="vote2"><input type="radio" name="vote" id="vote2" value="2" />Bad</label>
<label for="vote1"><input type="radio" name="vote" id="vote1" value="1" />Terrible</label>
<input type="hidden" name="s" value="$session[dbsessionhash]" />
<input type="hidden" name="t" value="$threadid" />
<input type="hidden" name="pp" value="$perpage" />
<input type="hidden" name="page" value="$pagenumber" />
<input type="submit" class="" value="Vote Now!" /></if></div>
</td>
</tr>



to:



<div align="$stylevar[left]"><span class="ratetext">$vbphrase[rate_this_thread] - <em>$thread[title]</em>.</span></div>
<a name="goto_threadrating"></a>
<label for="vote5"><input type="radio" name="vote" id="vote5" value="5" $votechecked[5] />$vbphrase[excellent]</label>
<label for="vote4"><input type="radio" name="vote" id="vote4" value="4" $votechecked[4] />$vbphrase[good]</label>
<label for="vote3"><input type="radio" name="vote" id="vote3" value="3" $votechecked[3] />$vbphrase[average]</label>
<label for="vote2"><input type="radio" name="vote" id="vote2" value="2" $votechecked[2] />$vbphrase[bad]</label>
<label for="vote1"><input type="radio" name="vote" id="vote1" value="1" $votechecked[1] />$vbphrase[terrible]</label>
<input type="hidden" name="s" value="$session[dbsessionhash]" />
<input type="hidden" name="t" value="$threadid" />
<input type="hidden" name="pp" value="$perpage" />
<input type="hidden" name="page" value="$pagenumber" />
<input type="submit" class="button" value="$vbphrase[vote_now]" /></if></div>
</td>
</tr>




Regards,

[tyranny]

I cant figure that part out about putting the average rating inside the post, how did you do that? I did apply the code to display the average rating, but dont see how to put it inside the post?

thanks


I just did this:

https://vborg.vbsupport.ru/showpost.php?p=1357430&postcount=49

and copied his code inside the actual post.

:)

[codehack]

Invalid SQL:

SELECT *
FROM threadrate
WHERE userid = 1
AND threadid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
Error Number : 1064
Date : Thursday, December 13th 2007 @ 03:01:01 AM
Script : http://www.xxxx.com/forum/showthread.php?t=1
Referrer :
IP Address :
Username :
Classname : vB_Database

help me!!:(

[davekeats]

Strange thing - I installed the mod perfectly, and it's appearing. The issue for me is, the rating mod is appearing even in forums for which I have NOT allowed thread ratings to appear.

What do think is up? Is there something I still need to add in the SHOWTHREAD template?

[VADOS]

Hello there!

I've installed your mod, thanx so much, it's great!

But I have a question: is it possible to move the rating table from it's original place (above the first post) to "below the first post"?

I have a template edit to make some table just below the first post (originally it's for adsense) and tried to move it there, but no good results reached. :(

[Scamorz]

Hi, i installed this excellent mod but i don't understand how i can insert the score inside the post and not at external. (like vb.org).

I installed this modify to obtain the number of votes and average: https://vborg.vbsupport.ru/showpost.php?p=1357430&postcount=49

Thanks! ;)

[synn]

Seems to work fine but I must have made a boo-boo :erm:

Under my thread tools drop down the javascript is not right:

74091

Can someone help?

[alfaowner]

I have installed this on a 3.6.4 board, all though it shows up, it doesnt alow me to vote, when I hit the button, nothing happens :(

[tei727]

love it! how do i make it show how many people voted like the VB.org does? can this be shown on the new threads?

[ran_iu_Conan]

i like it.
thanks so much
love you ^^~

[gldtn]

Any plans on updating this to vB3.7?

[baz_kingfish]

here are the template edits in TMS (Template Modification System) XML format - if anyone has TMS installed all they need to do is import this.

yoyo,
I ran the XML in TMS and created the templates, but nothing is showing up in my forum. All of the TMS modifications are "enabled", what am I missing? Lastly, is the XML based on Rich's hack or the one from Mangus?
Thanks,
KF

[mangandini]

The plugin have a bug if a thread id doesnt' exist, just modify the first line.
;-)

if ($vbulletin->userinfo['userid'] && $threadinfo[threadid])
{
if ($rating = $db->query_first("
SELECT *
FROM " . TABLE_PREFIX . "threadrate
WHERE userid = " . $vbulletin->userinfo['userid'] . "
AND threadid = $threadinfo[threadid]
"))

{
$rated = true;
}
}


Invalid SQL:

SELECT *
FROM threadrate
WHERE userid = 1
AND threadid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
Error Number : 1064
Date : Thursday, December 13th 2007 @ 03:01:01 AM
Script : http://www.xxxx.com/forum/showthread.php?t=1
Referrer :
IP Address :
Username :
Classname : vB_Database

help me!!:(

[baz_kingfish]

Mang,
What about my problem...can you help me with that?
Thanks,
KF

yoyo,
I ran the XML in TMS and created the templates, but nothing is showing up in my forum. All of the TMS modifications are "enabled", what am I missing? Lastly, is the XML based on Rich's hack or the one from Mangus?
Thanks,
KF

[Rich]

I don't use the TMS so i don't know how it operates, nor am I interested in installing it to see how it operates. (no offense to its creator. Its just not a mod I need right now.)

I am hoping to have a new version released within the next 2 weeks.

[baz_kingfish]

Thanks for responding. All the TMS does is apply the edits to the respective Template without having to go and manually search and find everything. It works beautifully. Any idea what the problem might be as to why the ratings box is not showing up? I don't even know where to start looking. Will your next release be a plugin or just a Template Mod...I can wait.

[baz_kingfish]

here are the template edits in TMS (Template Modification System) XML format - if anyone has TMS installed all they need to do is import this.

These XML template edits DO NOT WORK or test successfully in 3.6.8...

[Scamorz]

Hi, a little problem:

when i delete a post in a thread rated and then write the post link it show me an error:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT *
FROM vb_threadrate
WHERE userid = 3
AND threadid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
Error Number : 1064
Date : Sunday, February 10th 2008 @ 12:54:23 PM
Script : http://www.mysite.com/forum/showthread.php?p=84858
Referrer :
IP Address : 87.4.173.165
Username : user
Classname : vb_database


My plugin code is:

if ($vbulletin->userinfo['userid'])
{
if ($rating = $db->query_first("
SELECT *
FROM " . TABLE_PREFIX . "threadrate
WHERE userid = " . $vbulletin->userinfo['userid'] . "
AND threadid = $threadinfo[threadid]
"))

{
$rated = true;
}
}

Please anyone can help me?

Thank you!

[Scamorz]

This is the exact code:
if ($vbulletin->userinfo['userid'] && trim($threadinfo[threadid])!='')
{
if ($rating = $db->query_first("
SELECT *
FROM " . TABLE_PREFIX . "threadrate
WHERE userid = " . $vbulletin->userinfo['userid'] . "
AND threadid = $threadinfo[threadid]
"))

{
$rated = true;
}
}

[bigdaddyforums]

I managed to get this to work inside the postbit instead of showthread.

You need to replace $threadinfo[threadid] with $GLOBALS[threadid].

It's working great now, however the voting panel doesn't disappear once you've voted on the thread.

Ideally I'd like it to show the thread rating & number of votes.

[futuredood]

Strange thing - I installed the mod perfectly, and it's appearing. The issue for me is, the rating mod is appearing even in forums for which I have NOT allowed thread ratings to appear.

What do think is up? Is there something I still need to add in the SHOWTHREAD template?

I'm having similar problems, can anyone help?

[futuredood]

answered my own q.. you have to put an if condition around the code in showthread

[masterweb]

Installed on a 3.6.8 forum and works!

[jGas]

hi is it possible to add this modification INSIDE THE first post? i've tried but it isn't workin..

it works ONLY if i put it inside showthread, ONLY following all the steps in the template edits of this mod..why?

[cassis2k]

Installed on a 3.7.0 beta 5 forum and works!

Thx

[alfaowner]

Strange thing - I installed the mod perfectly, and it's appearing. The issue for me is, the rating mod is appearing even in forums for which I have NOT allowed thread ratings to appear.

What do think is up? Is there something I still need to add in the SHOWTHREAD template?

I'm having similar problems, can anyone help?

I am also having this problem, it is showing in all forums despite what the forum permissions are saying, also once I have rated the thread and refresh the page, all I get is a yellow thin line appear, with no results in it.

Question also: How do you change the font colour of the text in the box, currently it is black and I need white.

Thanks for listening, this hack is floored without these fixes requested above. FYI I am running 3.6.7

[MissKalunji]

you could probably add an <if> statement with the forum ids or go with the other made my magnus

[alfaowner]

Sorry, this really is not working, it doesnt use the forum permissions, usergroup permissions and is very buggy!

I will be uninstalling if it cannot be fixed soon. Any news from the author?

[Rich]

I am the author. If you look at the top of this page, this modification is listed as "unsupported". That means that the author released it, but is not going to support it officially.

I don't use this modification. I haven't gone and tried to upgrade it because I have been busy with my own site inbetween medical appointments. This modification is not on my priority list right now unfortunantly, though I may play with it at some point.

Sorry.

[F0xy]

it would be great if someone could support this hack and get rid of the bugs, it has so much potential too!

[MissKalunji]

Sorry, this really is not working, it doesnt use the forum permissions, usergroup permissions and is very buggy!

I will be uninstalling if it cannot be fixed soon. Any news from the author?

try this one then : https://vborg.vbsupport.ru/showthread.php?t=142733

[Ninja Tom]

Installed on 3.7.1 and it seems to be working just fine!

[lonasdigital]

Hello I would like to know how I do this forum amendments to be like in this picture:

http://img238.imageshack.us/img238/9282/dibujoxj0.png

thanks

[lonasdigital]

Can anyone tell me how to do this? please me is very important this parameter, thanks and greetings.

[Rich]

lonasdigital, that isn't part of this modification. That tells you how many people have installed whatever modification you are looking at. It has nothing to do with ratings or this modification.

[lonasdigital]

ok, forgive my clumsiness jejejeje thought that this was counting the votes and thanks and forgive, a greeting.

[lonasdigital]

Good friends do at the end got what I wanted,
forumdisplay able to put in right next to the stars the number of votes received.
https://vborg.vbsupport.ru/

[compact123]

thanks, i installed.

[rizelim]

thanks

[JohorBahru]

hi Rich,

this mod could be better if the rating bar can be hidden for those non-permission members or guest...

thanks

[Neutral Singh]

Working awesome for 3.8.0!! Thank you.

[pappocapo]

Each time a user votes pulled me this error database




Database error in vBulletin 3.7.5:
Invalid SQL:
SELECT *
FROM foro_threadrate
WHERE userid = 3288
AND threadid =;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
Error Number : 1064
Request Date : Sunday, March 1st 2009 @ 09:50:38 PM
Error Date : Sunday, March 1st 2009 @ 09:50:38 PM
Script : http://www.elforolatino.com/showthread.php?t=5213
Referrer :
IP Address : 189.168.187.42
Username : nancy_metamorphosis
Classname : vB_Database
MySQL Version :



Sorry for my English, use an online translator
*************************************************
Fixed my error when editing

[magenik]

Installed and work well on 3.8.2 without error for me (for now)

[ShawneyJ]

Good friends do at the end got what I wanted,
forumdisplay able to put in right next to the stars the number of votes received.
http://img338.imageshack.us/img338/3043/dibujocd9.png







im really interested on how you did this please?
care to share how?? :)