Using External PHP Pages

[ICThawk]

Originally Posted by kh99

It looks like you've misspelled 'navbar' in your preregister call.

Good catch. Sadly with that fixed it still doesn't work. Ideas?

[nima6]

It is official. I am an idiot. I had a spelling error as well

[kh99]

Originally Posted by ICThawk

Good catch. Sadly with that fixed it still doesn't work. Ideas?

Which hook are you using? Try using parse_templates if you aren't already.

[ICThawk]

Originally Posted by kh99

Which hook are you using? Try using parse_templates if you aren't already.

I don't know what parse templates are.

I used the hook global_start. execution order 5.

Does the PHP code need to be contained in <?php tags?

Here is the code in my php file in case it matters.

PHP Code:

<?php

require_once('./global.php');

// Query the database and get the count 
$result = mysql_query("SELECT * FROM ajax_chat_online"); 
$num_rows = mysql_num_rows($result); 

// Display the results 
echo $num_rows; 


?>

[kh99]

You don't need the <?php in plugin code.

'parse_templates' is a different hook location, but 'global_start' will work so you're OK.

I think you had another typo in the code you posted above (there's an extra space in 'includedphp ', which I now see is a typo in the "Rendering Templates..." article).

Try this:

PHP Code:

ob_start();
  include('/home/bluepr12/public_html/wavingthewheat.com/chatuser.php');
  $includedphp = ob_get_contents();
ob_end_clean();

vB_Template::preRegister('navbar',array('includedphp' => $includedphp)); 


BTW, not to confuse things further, but you could also do something like this in the plugin:

PHP Code:

$result = mysql_query("SELECT * FROM ajax_chat_online");  
$num_chatting = mysql_num_rows($result);  
vB_Template::preRegister('navbar',array('num_chatting' => $num_chatting)); 


and {vb:raw num_chatting} in the template, and you wouldn't need the external file.

[ICThawk]

kh99 thanks a ton for your help. I decided to go with your last option and have the plugin execute the php.

I have a couple more questions though.

1.) What hook do I need to use so that this will display on the front page. It works on the forum, but not on the CMS.

2.) I would like to list who is online on the forum home. In that ajax_chat_online table each online user is stored in a row. I would like to display the column userName for all entries separated by a comma. Any thoughts?

Again, thank you very much for all your help so far!

[kh99]

Originally Posted by ICThawk

1.) What hook do I need to use so that this will display on the front page. It works on the forum, but not on the CMS.

Try global_bootstrap_init_start

2.) I would like to list who is online on the forum home. In that ajax_chat_online table each online user is stored in a row. I would like to display the column userName for all entries separated by a comma. Any thoughts?

PHP Code:

global $vbulletin;

$results = $vbulletin->db->query_read_slave("SELECT userName FROM ajax_chat_online");
while ($row = $vbulletin->db->fetch_array($results))
    $chat_userlist[] = $row['userName'];
$chat_userlist = implode(',', $chat_userlist);
$vbulletin->db->free_result($results);
vB_Template::preRegister('navbar', array('chat_userlist' => $chat_userlist)); 


Obviously, if you're using the same plugin as you are for the count you could combine both so you're not doing two queries.

[ICThawk]

Thanks! You had a typo but I caught it. Thanks for all of your help!!

--------------- Added [DATE]1314893620[/DATE] at [TIME]1314893620[/TIME] ---------------

Man you have no idea how helpful you have been. With your help I have put together the following Mod Thread https://vborg.vbsupport.ru/showthread.php?p=2240829 to help everyone else who is in the same boat as me.

--------------- Added [DATE]1314962655[/DATE] at [TIME]1314962655[/TIME] ---------------

Well I have found one hiccup. With the second plugin. The one that displays the userNames.

If no one is in the chat and the code returns a NULL result then it breaks the site. Gives me a cookie in header already sent error. Thoughts??

[ICThawk]

Bump

[kh99]

Sorry, I always seem to miss when posts get auto-merged.

Anyway, yeah, didn't think of that. You want something like this:

PHP Code:

global $vbulletin; 

$results = $vbulletin->db->query_read_slave("SELECT userName FROM ajax_chat_online"); 
while ($row = $vbulletin->db->fetch_array($results)) 
    $chat_userlist[] = $row['userName']; 
if (is_array($chat_userlist))
{
    $chat_userlist = implode(',', $chat_userlist); 
    $vbulletin->db->free_result($results); 
}
else
{
    // set $chat_userlist to a "no one chatting" message if you want, or leave blank.
    $chat_userlist = '';
}
vB_Template::preRegister('navbar', array('chat_userlist' => $chat_userlist));