miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
qwerty miniBB Support Forums / qwerty /   

who is online mod advanced

Author bretterelse
#1 | Posted: 22 Apr 2006 10:53 

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

Author _Marco
#2 | Posted: 22 Apr 2006 22:10 | Edited by: _Marco 
The info you want is all present in stats.html

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


Author bretterelse
#3 | Posted: 23 Apr 2006 12:08 

Author Team
#4 | Posted: 25 Apr 2006 06:52 
Take a look at bb_func_stats.php - all these commands are presented there with db_simpleSelect()

qwerty miniBB Support Forums / qwerty / who is online mod advanced Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

Only registered users are allowed to post here. Please, enter your username/password details upon posting a message, or register first.

Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Check out the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB