Show Thread Enhancements - vB.org Rating System Replica

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.

[ran_iu_Conan]

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

[gldtn]

Any plans on updating this to vB3.7?

[baz_kingfish]

Originally Posted by 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.

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.
;-)

PHP Code:

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; 
 }  
} 


Originally Posted by codehack

PHP Code:

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

Originally Posted by baz_kingfish

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]

Originally Posted by 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.

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:

PHP 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; 
 }  
}