New plugin questions

[Andreas]

No, you should not use global_start when this is only being used on Forumhome.

Use forumhome_complete (this Hook gets called just before the FORUMHOME Template gets eval()ed):

PHP Code:

$memberotm = $db->query_first("
    SELECT user.username, user.userid FROM " . TABLE_PREFIX . "user
    LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON (userfield.userid=user.userid AND userfield.field9='Yes')
    LIMIT 1
");
$moderatorotm = $db->query_first("
    SELECT user.username, user.userid FROM " . TABLE_PREFIX ." user AS user
    LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON (userfield.userid=user.userid AND userfield.field10='Yes')
    LIMIT 1
");