Show username from a certain thread

[stuartn]

Hopefully a simple bit of help required.

Say I wanted to show a simple text of the username with a post id = 1000000 i.e. the member posted our millionth post how would you do this ?

[kh99]

You can of course find post 1000000 by going to showtrhead.php&p=1000000. You could also do a db query, like:

SELECT username FROM post WHERE postid=1000000

but it sounds like maybe you want code to automatically display it somewhere?

[stuartn]

I understand that element what I struggle with is once I have the $result is how to get this into the vb system to show within the head template.

PHP Code:

$million = $vbulletin->db->query_read("SELECT username FROM " . TABLE_PREFIX . "post WHERE postid = '5'"); 


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

I'm using no 5 in the above to see if it shows the right result.

[kh99]

I think I'd create a plugin using hook parse_templates, and code like this:

$million = $vbulletin->db->query_first("SELECT username FROM " . TABLE_PREFIX . "post WHERE postid = '5'");  
if (!empty($million))
{
   vB_Template::preRegister('header', array('million' => $million['username']));
}

then in the header template, use {vb:raw million}.

[stuartn]

Didn't work - got an error 'Call to undefined method vB_Database::query_read_first()'

so removed the 'first' and no error but its not showing up.

[kh99]

Oops, yeah, it's just query_first. I fixed the above code.

[stuartn]

Thanks thats working now.