vb.org Archive - Where to place this script?

I wrote this script to pull the top 10 leaders out of the vbpool software

PHP Code:


		
			
<?php
require_once('./global.php');
global $vbulletin;
 
$query = $vbulletin->db->query_read
("SELECT COUNT(G.vbpool_gameid) AS score, U.username AS username, P.userid AS userid
FROM vbpool_game G, vbpool_picks P, user U, vbpool_week W, vbpool_pool X
WHERE (G.winner=P.pick OR G.winner='-1')
AND G.vbpool_gameid=P.vbpool_gameid
AND P.userid=U.userid
AND W.vbpool_weekid=G.vbpool_weekid
AND X.vbpool_poolid=W.vbpool_poolid
AND X.vbpool_poolid=2
GROUP BY userid
ORDER BY score DESC, username ASC
LIMIT 10");
 
$rownum = 1;
//echo '<tbody><tr>';
// Retrieve and print every record.
while($player=$db->fetch_array($query))
{
if($rownum==1) $leader = $player['userid'];
$thisscore = $player['score'];
$thisname = $player['username'];
$thisuserid = $player['userid'];
$weekscore = $scorecache[$thisuserid];
$rownum++;
echo "<td class='smallfont' align='left'><strong>$thisname</strong></td>
<td align='right'>$thisscore</td><br />";
}
echo '</tr></tbody>';
 
?>

i have a sidebar on the left side of my forums: http://www.sportsrant.com/forums/ and I want to place this on the side bar

I just do not know where to place the hook, I am not to familiar with that part

Any help would be great

Thanks
Mike
sportsrant.com

I was able to get a hook in place but i now I am having another problem.

Right now I am getting my results, but if I use to cells within a row, the cells go outside the rows and cause the results to expand the cells

Can someone help me out here

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (1)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

X vBulletin 3.8.12 by vBS Debug Information

Page Generation 0.00899 seconds
Memory Usage 1,717KB
Queries Executed 10 (?)

More Information

Template Usage:

(1)ad_footer_end
(1)ad_footer_start
(1)ad_header_end
(1)ad_header_logo
(1)ad_navbar_below
(1)bbcode_php_printable
(1)footer
(1)gobutton
(1)header
(1)headinclude
(6)option
(1)post_thanks_navbar_search
(1)printthread
(1)printthreadbit
(1)spacer_close
(1)spacer_open

Phrase Groups Available:

global
postbit
showthread

Included Files:

./printthread.php
./global.php
./includes/init.php
./includes/class_core.php
./includes/config.php
./includes/functions.php
./includes/class_hook.php
./includes/modsystem_functions.php
./includes/class_bbcode_alt.php
./includes/class_bbcode.php
./includes/functions_bigthree.php

Hooks Called:

init_startup
init_startup_session_setup_start
init_startup_session_setup_complete
cache_permissions
fetch_threadinfo_query
fetch_threadinfo
fetch_foruminfo
style_fetch
cache_templates
global_start
parse_templates
global_setup_complete
printthread_start
bbcode_fetch_tags
bbcode_create
bbcode_parse_start
bbcode_parse_complete_precache
bbcode_parse_complete
printthread_post
printthread_complete

Messages:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00899 seconds Memory Usage 1,717KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (1)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: