topics started in postbit

I'm trying to get the topics started where the posts would be, although it's not showing up, I assume I'm not putting the query in the right place.

this isn't my code, it's off another hack, but I figured it'd be the same;

PHP Code:

// topics started hack
  $startcount = $DB_site->query_first("SELECT COUNT(title) AS starts FROM thread WHERE postusername='$userinfo[username]' AND open!='10'");
  $starts = $startcount[starts]; 


and the in postbit I put:

PHP Code:

<smallfont>Topics: $starts</smallfont><br/> 


[bira]

the query should be in showthread.php

then, in admin/functions.php, find:

	// user
	global $bbuserinfo,$session,$ignore;

And change it to:

	// user
	global $bbuserinfo,$session,$ignore[high],$starts[/high];

The reason it's not working for you now is not because of the query, it's because $starts isn't declared as global in the getpostbit function.