i did that
Code:
global $post_thanks_cash, $post_thanks_done, $db;
if (empty($post_thanks_done))
{
$post_thanks_querys = $db->query("SELECT postid FROM ". TABLE_PREFIX ."post WHERE threadid = '$post[threadid]'");
$post_thanks_postids = 0;
while ($post_thanks_query = $db->fetch_array($post_thanks_querys))
{
$post_thanks_postids .= ",$post_thanks_query[postid]";
}
$post_thanks_cashe = $db->query("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN ($post_thanks_postids) ORDER BY username ASC");
$act = 1;
and when i go to thank, i get this error
Code:
Database error in vBulletin 3.5.1:
Invalid SQL:
UPDATE vb3_user
SET post_thanks_thanked_times = 1 + post_thanks_thanked_times, post_thanks_thanked_posts = 1 + post_thanks_thanked_posts, reputation = $vboptions[post_thanks_reputation] + reputation
WHERE userid = 741;
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 '[post_thanks_reputation] + reputation
WHERE userid = 741' at line 2