miniBB ® 

miniBB

®
Support Forums
  
 | Start | Register | Search | Statistics | File Bank | 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
Partaker
#2 | Posted: 22 Apr 2006 22:10 
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
 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 forum rules; otherwise it could be locked or removed 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
Check out the Captcha add-on: protect your miniBB-forums from the automated spam and flood.


  ⇑