Zikula Community

• **unknown user**
  
  

  • Rank: Freshman
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 56

  Posted: Jul 31, 2004 - 01:33 PM

  how can i put the number of users like some where on my page fo rexample.. 125 registered users thanks

  • 
  •  
• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 176

  Posted: Jul 31, 2004 - 07:25 PM

  Perhaps with something like this, paraphrased from the stats module:
  
  $userdb = $dbconn->Execute("SELECT count(*) AS count FROM $pntable[users]");
  list($usernum) = $userdb->fields;
  echo pnVarPrepForDisplay($usernum-1);
  
  That's the basic idea. If you set it up right, you could even make a variable accessible to your theme (plugin script with Xanthia for example), and just display the total count on your site globally if you want.
  --Kevin

  • 
  •  
• Pharaoh
  
  

  • Rank: Freshman
  • Registered: Jan 16, 2003
  • Last visit: Oct 21, 2009
  • Posts: 96

  Posted: Sep 27, 2004 - 06:38 PM

  thanks for the code :)
  
  I put
  
  

  Code

  <!--[php]-->
  $dbconn =& pnDBGetConn(true);
  $pntable =& pnDBGetTables();
  $userdb = $dbconn->Execute("SELECT count(*) AS count FROM $pntable[users]");
  list($usernum) = $userdb->fields;
  echo pnVarPrepForDisplay($usernum-1);
  <!--[/php]-->

  
  
  In my Xanthia template and it showed the number of members, it'd probably be neater to make a plugin for Xanthia tho like you say, but for me that does it's job on an entry page "We have this many members, Join/Register" :)

  • 
  •  
•  
•  

Users on-line

• mdee

This list is based on users active over the last 60 minutes.