Query Database in global.php and print it in Postbit

[rin]

Hello,

I have this query in global.php and want to print it in postbit. Basically showing a small notice wether the member has agreed to the Terms of Service or not.
$tos is for showing a global notice to everyone who has not yet agreed.
$tospost should be the small notice in the postbit. However, if I add $tospost in my postbit nothing will be shown... Why is that?

if(isset($vbulletin->userinfo['userid']) AND $vbulletin->userinfo[username] != "Unregistered")
{
$tos = $db->query_first("
SELECT rules
FROM " . TABLE_PREFIX . "user WHERE userid = " . $vbulletin->userinfo['userid'] . "");
$tos = $tos['rules'];
if($tos == 0)
{
$tos = "<table class='tborder' cellpadding='$stylevar[cellpadding]' cellspacing='$stylevar[cellspacing]' border='0' width='100%' align='center'>
<tr>
<td class='alt1' width='64' align='left'><a href='terms.php'><img src='images/misc/terms.png' border='0' /></a></td><td class='alt2' align='left' vAlign='top'><span style='font-size:x-large;'><strong><i>Terms of Service</i></strong></span><br />Hello " . $vbulletin->userinfo[username] . "! You currently show up as 'Not Agreed'. This is most likely because you still have not agreed to our <i>Terms of Service</i> or because the <i>Terms of Service</i> have been changed and need to be reapplied. You can take the neccessarry steps when you follow <a href='terms.php'>this link.</a> Thanks for your cooperation.
<br /><i>If you can not change your status, please contact the administrator <b><a href='private.php?do=newpm&u=1'>aio</a></b></i></td>
</tr>
</table><br />";
$tospost = "<a href='terms.php'>Not Agreed</a>";
}
else
{
$tos = "";
$tospost = "Agreed";
}
}

[rin]

I hope someone can help me. At vBulletin they told me to ask here.

[rin]

Thanks for any help

[Mitch100degrees]

Hello,

I have this query in global.php and want to print it in postbit. Basically showing a small notice wether the member has agreed to the Terms of Service or not.
$tos is for showing a global notice to everyone who has not yet agreed.
$tospost should be the small notice in the postbit. However, if I add $tospost in my postbit nothing will be shown... Why is that?

if(isset($vbulletin->userinfo['userid']) AND $vbulletin->userinfo[username] != "Unregistered")
{
$tos = $db->query_first("
SELECT rules
FROM " . TABLE_PREFIX . "user WHERE userid = " . $vbulletin->userinfo['userid'] . "");
$tos = $tos['rules'];
if($tos == 0)
{
$tos = "<table class='tborder' cellpadding='$stylevar[cellpadding]' cellspacing='$stylevar[cellspacing]' border='0' width='100%' align='center'>
<tr>
<td class='alt1' width='64' align='left'><a href='terms.php'><img src='images/misc/terms.png' border='0' /></a></td><td class='alt2' align='left' vAlign='top'><span style='font-size:x-large;'><strong><i>Terms of Service</i></strong></span><br />Hello " . $vbulletin->userinfo[username] . "! You currently show up as 'Not Agreed'. This is most likely because you still have not agreed to our <i>Terms of Service</i> or because the <i>Terms of Service</i> have been changed and need to be reapplied. You can take the neccessarry steps when you follow <a href='terms.php'>this link.</a> Thanks for your cooperation.
<br /><i>If you can not change your status, please contact the administrator <b><a href='private.php?do=newpm&u=1'>aio</a></b></i></td>
</tr>
</table><br />";
$tospost = "<a href='terms.php'>Not Agreed</a>";
}
else
{
$tos = "";
$tospost = "Agreed";
}
}

Alert me as to why it has to be in global.php? If you only want to display it in your postbit, you can throw it in a plugin.

Put it in the postbit_display_complete hook.

Additionally, there's no need to query the database for the user's information. Use this code:

if(isset($post['userid']) AND $post['username'] != "Unregistered")
{
$tos = $post['rules'];
if($tos == 0)
{
$tos = "<table class='tborder' cellpadding='$stylevar[cellpadding]' cellspacing='$stylevar[cellspacing]' border='0' width='100%' align='center'>
<tr>
<td class='alt1' width='64' align='left'><a href='terms.php'><img src='images/misc/terms.png' border='0' /></a></td><td class='alt2' align='left' vAlign='top'><span style='font-size:x-large;'><strong><i>Terms of Service</i></strong></span><br />Hello " . $vbulletin->userinfo[username] . "! You currently show up as 'Not Agreed'. This is most likely because you still have not agreed to our <i>Terms of Service</i> or because the <i>Terms of Service</i> have been changed and need to be reapplied. You can take the neccessarry steps when you follow <a href='terms.php'>this link.</a> Thanks for your cooperation.
<br /><i>If you can not change your status, please contact the administrator <b><a href='private.php?do=newpm&u=1'>aio</a></b></i></td>
</tr>
</table><br />";
$tospost = "<a href='terms.php'>Not Agreed</a>";
}
else
{
$tos = "";
$tospost = "Agreed";
}
}

[socomcup]

I have pretty much been looking for the same exact thingm thank you for posting this.

So can I make my own SQL query now from another database in this plugin?

Thanks for the help

[rin]

Works like a charm! Thanks a lot for your help!~