miniBB Support Forums | 16 years on The Web
miniBB ® 


 | Begin | Register | Reply | Search | Statistics | File Bank | 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
 Share Topic's Link

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

Post as a Guest, leaving the Password field blank. You could also enter a Guest name, if it's not taken by a member yet. Sign-in and post at once, or just sign-in, bypassing the message's text.

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 ® Home  Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contact Us
Get the Captcha add-on: protect your miniBB-forums from the automated spam and flood.