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

who is online mod advanced

Author bretterelse
Guest
#1 | Posted: 22 Apr 2006 10:53 
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

Author _Marco
Registered
#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}

_Marco

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

Author Team
8-)
#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:

 ?
You are welcome to post anonymously, by entering a nickname with no password (if the similar Username has not been taken yet), or by leaving both fields empty. If you have a forums account, you can also sign in from this page without posting a message, or sign in and post at once.


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
Install the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB