I just deleted the Who Read a Thread... But, the problem is still happening. The "Who Viewed This Thread?" is still listed in the download / upload plugins area. But, I can't find it listed anywhere in the manager.. This is odd.
--------------- Added [DATE]1220545097[/DATE] at [TIME]1220545097[/TIME] ---------------
I downloaded that one plugin (that I can't find in manager to delete or disable) and the query it runs is;
Quote:
// Get who has already viewed this thread
$currentthread = $db->query_first("SELECT whoviewed FROM ".TABLE_PREFIX."thread WHERE threadid = $threadid");
$vieweduserids = explode(" ", $currentthread['whoviewed']);
$userinfo = fetch_userinfo($vbulletin->userinfo['userid']);
if (!$userinfo['invisible'] OR $showinvisible)
{
if (!empty($currentthread['whoviewed']))
{
if (!in_array($vbulletin->userinfo['userid'], $vieweduserids))
{
$db->query_write("UPDATE ".TABLE_PREFIX."thread SET whoviewed = CONCAT(whoviewed, \" \", \"" .$vbulletin->userinfo['userid'] . "\") WHERE threadid = $threadid");
}
}
else
{
$db->query_write("UPDATE ".TABLE_PREFIX."thread SET whoviewed = \"" . $vbulletin->userinfo['userid'] . "\" WHERE threadid = $threadid");
}
}
// Who has viewed this thread?
if (empty($currentthread['whoviewed']))
{
$thread['viewers'] = '('.strtolower($vbphrase['none']).')';
}
else
{
$result = $db->query_read("SELECT userid, username FROM ".TABLE_PREFIX."user WHERE userid IN (" . implode(", ", $vieweduserids) . ")");
$viewers = array();
while ($user = $db->fetch_array($result))
{
array_push($viewers, "<a target=\"_blank\" href=\"member.php?".$vbulletin->session['sessionurl'] . "u=".$user['userid'] . "\">" . htmlspecialchars($user['username']) . "</a>");
}
$thread['viewers'] = implode(", ", $viewers);
}
|
--------------- Added [DATE]1220550920[/DATE] at [TIME]1220550920[/TIME] ---------------
Quote:
Originally Posted by Opserty
Disable them one by one till your error goes away, then you which one is causing it...
|
Just did, that.. I don't know what the hell is up with this thing. Disabling all hooks fixes it, but, when I disabled every one, one by one, nothing was fixed. Could it be two combining and making a problem?

--------------- Added [DATE]1220573787[/DATE] at [TIME]1220573787[/TIME] ---------------
Anyone???