MyBB Community Forums

TechMIX' fix does work, but he missed one additional line of code.

Apply his first edit, but for the second, find these 2 lines of code:

$where_sql .= " AND NOT p.thx='0'";
$searcharray["querycache"] = $db->escape_string($where_sql);

and replace with:

$where_sql .= "AND NOT thx='0'";
$query = $db->simple_select("posts", "pid", "{$where_sql}", $options);
        $pids = "";
        $comma = "";
        while($pid = $db->fetch_field($query, "pid"))
{
    $pids .= $comma.$pid;
    $comma = ",";
}
$searcharray["posts"] = $db->escape_string($pids);

Then the search will find only thanked posts and work perfectly!

Thank you.

great works like a charm.. i didnt notice the miss query code.. lol

How I can count all thanks received or given and display this number in the profile of each member?
Thanks.