topics started in postbit

[heretic]

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;


// 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:


<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,$starts;


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.