Dr.CustUmz
05-19-2020, 03:01 PM
So I have a query I run on hook : forumdisplay_loggedinuser
$viewers = $db->query_first("SELECT user.avatarid FROM " . TABLE_PREFIX . "user WHERE userid = " . $loggedin['userid'] . "");
there's more to the code, and this works on forumdisplay by using $viewers in forumdisplay_loggedinuser template.
My issue is in showthread, showthread uses the same template (forumdisplay_loggedinuser) to show active users, yet my plugin is not loading in showthread. I have played with the hook location, (obviously hooking it to showthread_loggedinuser) first, and have tried a few other locations, yet I cant get this to return anything at all in showthread.
None of the plugin is wrapped in a this script condition either.
THE FULL CODE (works in forumdisplay, can not get to work in showthread)
$viewers = $db->query_first("SELECT user.avatarid FROM " . TABLE_PREFIX . "user WHERE userid = " . $loggedin['userid'] . "");
if ($viewers['avatarid'])
{
// using a predefined avatar
$avatar = $db->query_first("SELECT avatarpath FROM " . TABLE_PREFIX . "avatar WHERE avatarid = " . $viewers['avatarid'] . "");
$avatarid = $avatar['avatarid'];
$viewers = "<div class=\"list-avatar\"><img class=\"embedded-avatar\" src=\"" . $vbulletin->options['bburl'] . "/" . $avatar['avatarpath'] ."\" alt=\"" . $loggedin['username'] . "'s Avatar\"/></div>";
}
else
{
// not using a predefined avatar, check for custom
if ($avatar = $db->query_first("SELECT dateline, userid FROM " . TABLE_PREFIX . "customavatar WHERE userid = " . $loggedin['userid'] . ""))
{
// using a custom avatar
$avatarurl = ($vbulletin->options['usefileavatar']) ? "" . $vbulletin->options['avatarurl'] . "/avatar$avatar[userid]_" . $vbulletin->userinfo['avatarrevision'] . ".gif" : "" . $vbulletin->options['bburl'] . "/image.php?u=" . $loggedin['userid'] . "&dateline=" . $avatar['dateline'] . "";
$viewers = "<div class=\"list-avatar\"><img class=\"embedded-avatar\" src=\"$avatarurl\" alt=\"" . $loggedin['username'] . "'s Avatar\"/></div>";
}
else
{
// no avatar specified
$nouseavatarchecked = HTML_CHECKED;
$avatarchecked[0] = '';
$uppercase = ucfirst($loggedin['username']);
$firstlet = $uppercase[0];
$viewers = "<div class=\"list-avatar no-avatar\">" . $firstlet . "</div>";
}
}
$viewers = $db->query_first("SELECT user.avatarid FROM " . TABLE_PREFIX . "user WHERE userid = " . $loggedin['userid'] . "");
there's more to the code, and this works on forumdisplay by using $viewers in forumdisplay_loggedinuser template.
My issue is in showthread, showthread uses the same template (forumdisplay_loggedinuser) to show active users, yet my plugin is not loading in showthread. I have played with the hook location, (obviously hooking it to showthread_loggedinuser) first, and have tried a few other locations, yet I cant get this to return anything at all in showthread.
None of the plugin is wrapped in a this script condition either.
THE FULL CODE (works in forumdisplay, can not get to work in showthread)
$viewers = $db->query_first("SELECT user.avatarid FROM " . TABLE_PREFIX . "user WHERE userid = " . $loggedin['userid'] . "");
if ($viewers['avatarid'])
{
// using a predefined avatar
$avatar = $db->query_first("SELECT avatarpath FROM " . TABLE_PREFIX . "avatar WHERE avatarid = " . $viewers['avatarid'] . "");
$avatarid = $avatar['avatarid'];
$viewers = "<div class=\"list-avatar\"><img class=\"embedded-avatar\" src=\"" . $vbulletin->options['bburl'] . "/" . $avatar['avatarpath'] ."\" alt=\"" . $loggedin['username'] . "'s Avatar\"/></div>";
}
else
{
// not using a predefined avatar, check for custom
if ($avatar = $db->query_first("SELECT dateline, userid FROM " . TABLE_PREFIX . "customavatar WHERE userid = " . $loggedin['userid'] . ""))
{
// using a custom avatar
$avatarurl = ($vbulletin->options['usefileavatar']) ? "" . $vbulletin->options['avatarurl'] . "/avatar$avatar[userid]_" . $vbulletin->userinfo['avatarrevision'] . ".gif" : "" . $vbulletin->options['bburl'] . "/image.php?u=" . $loggedin['userid'] . "&dateline=" . $avatar['dateline'] . "";
$viewers = "<div class=\"list-avatar\"><img class=\"embedded-avatar\" src=\"$avatarurl\" alt=\"" . $loggedin['username'] . "'s Avatar\"/></div>";
}
else
{
// no avatar specified
$nouseavatarchecked = HTML_CHECKED;
$avatarchecked[0] = '';
$uppercase = ucfirst($loggedin['username']);
$firstlet = $uppercase[0];
$viewers = "<div class=\"list-avatar no-avatar\">" . $firstlet . "</div>";
}
}