[Ted S]

Tips & Tricks Using Template Variables:

While the Helpful Answers section may appear to only add to a small part of your post it can be used much more extensively to change the color of an entire post, to add a special icon or just about anything else you like. Here are list of the variables available for your templates and a few sample conditions you can use with them:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Future Updates:

I'm pleased with this addon so far but plan to extend it as feedback comes in so please share your comments and suggestions as they will be read and responded too.

Coming soon... A page showcasing your top 10 (or 20 or 30 or 100) posts.

[Ted S]

Thanks for the private feedback; I've added a simple page showing the Most Helpful Answers. This can be disabled through the options and the number of results to show can also be configured.

[Spank]

Brill, will download and install later. Thanks

[Rickeo]

Any chance of getting this to work on 3.8x?

[Ted S]

Originally Posted by Rickeo

Any chance of getting this to work on 3.8x?

http://www.vbulletin.org/forum/showthread.php?t=204117

[GigaSb]

help here please, got errors:

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
spamlog.postid AS spamlog_postid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

,post.goodrank,post.totalrank,helpfulanswer.helpfulanswerid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 4 AND postparsed.languageid = 3)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 4 AND sigparsed.languageid = 3)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
LEFT JOIN helpfulanswer AS helpfulanswer ON(helpfulanswer.postid = post.postid and helpfulanswer.userid = 1)
WHERE post.postid IN (0,210,231)
ORDER BY post.dateline;

MySQL Error : Table 'mysite_fph.helpfulanswer' doesn't exist
Error Number : 1146
Request Date : Wednesday, February 4th 2009 @ 11:26:54 AM
Error Date : Wednesday, February 4th 2009 @ 11:26:54 AM
Script : http://www.mysite.co.il/showthread.php?t=188
Referrer : http://www.mysite.co.il/forumdisplay.php?f=3
IP Address : XX.XXX.XX.XXX
Username : PCTech
Classname : vB_Database
MySQL Version : 5.0.37-standard

[6piston]

Originally Posted by GigaSb

help here please, got errors:

Database error in vBulletin 3.7.0:

try this:
http://www.vbulletin.org/forum/showp...91&postcount=8

[6piston]

hi Ted

i've created the sql table manually using the link i posted above. but now, i get other sql errors. this time:

when i click Yes / No the AJAX effect doesn't work, instead, a window pops up and says:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Zerotohundred.com Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
<style type="text/css">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="http://www.zerotohundred.com/newforums/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The Zerotohundred.com database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">www.zerotohundred.com</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The www.zerotohundred.com forum technical staff have been notified of the error, though you may <a href="mailto:">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>

<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.7.2:

Invalid SQL:



SELECT post.goodrank,post.totalrank

FROM vb3post

WHERE postid = 2661498;

MySQL Error : Unknown column 'post.goodrank' in 'field list'
Error Number : 1054
Request Date : Wednesday, February 4th 2009 @ 09:37:03 PM
Error Date : Wednesday, February 4th 2009 @ 09:37:04 PM
Script : http://www.zerotohundred.com/newforu...fulanswers.php
Referrer : http://www.zerotohundred.com/newforu...-sohc-bot.html
IP Address : 124.82.95.141
Username : Tom
Classname : vB_Database
MySQL Version : 5.0.51a-community-log</textarea></form>

</body>
</html>

so it's this:
MySQL Error : Unknown column 'post.goodrank' in 'field list'

please advise ted

[GigaSb]

i added the query that u advised me..
thank u very much!

[apiasto]

i am getting the same error.i will wait for stable hack

[6piston]

cool!. now you may face the next same prob as i am

[tpearl5]

hrm - I like this idea, although I've already modified the wording of the reputation system to resemble something similar.

[Ted S]

My appologies to those who have experienced bugs with the system. 3 issues were identified (2 with queries like the errors above show) and 1 in the creation of the table. An updated version has been released which solves all known issues.

[Ted S]

Note: Version 1.3.3 has been released which fixes several small issues related to creating the mySQL table for this addon and with two queries. With this update the current mysql query errors will go away and the table will be properly created.

All users are advised to upgrade while those who have experienced database errors should uninstall and then upgrade.

To upgrade simply upload the new version of helpfulanswer.php and install the new plugin file.