hello,

i try to display stats like phpbb

amount of members
amount of topics and
newest member

in my addon_whosonline.php

i think the sql statements must look like

$count_members=mysql_num_rows(mysql_querry("SELECT * FROM minibbtable_users"));
$count_topics=mysql_num_rows(mysql_querry("SELECT * FROM minibbtable_topics"));
$sql_new_user=mysql_querry("SELECT username,user_id FROM minibbtable_users ORDER BY id ASC LIMIT 0,1")

but how can i realise this statements with db_simpleSelect()

sorry my bad english

The info you want is all present in stats.html

{$numUsers} {$numTopics} {$l_stats_lastReg}

_Marco

Take a look at bb_func_stats.php - all these commands are presented there with db_simpleSelect()