XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Total members
Register
1
Hardy
Total members

  • 2004/1/25 3:12

  • Hardy

  • Just popping in

  • Posts: 38

  • Since: 2003/11/16


I want to show my total members in whosonline block or custom blocks, What i must to do??

Thanks
2
svaha
Re: Total members

  • 2004/1/25 9:37

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Found this thread for some info
Total number of members
It's in xoopsmembers
3
Hardy
Re: Total members

  • 2004/1/26 3:05

  • Hardy

  • Just popping in

  • Posts: 38

  • Since: 2003/11/16


thanks..

but i mean, i want to display total members in blocks. How to do it??

I've same question with TooBaked.. :)
4
svaha
Re: Total members

  • 2004/1/26 8:57

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


You can find this for instance in the stats block of inc blocks from the inconnu team :
Quote:
$result = $xoopsDB->query("SELECT uid from ".$xoopsDB->prefix("users")." where level='1' order by uid DESC",1);
list($numbers) = $xoopsDB->fetchRow($result);

and
$numbers contains the total number of registered users.
Just fit this to your needs

Hope this helps
5
Mithrandir
Re: Total members

if you are making a query anyway, I'd suggest you do it like this:
$result = $xoopsDB->query("SELECT count(uid) FROM ".$xoopsDB->prefix("users")." WHERE level='1'";
6
svaha
Re: Total members

  • 2004/1/26 18:49

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Thnx Mithrandir
7
Hardy
Re: Total members

  • 2004/1/28 6:59

  • Hardy

  • Just popping in

  • Posts: 38

  • Since: 2003/11/16


thanks..
but where i must to put that code?? sorry.. too many question, i'm newbie :)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

153 user(s) are online (62 user(s) are browsing Support Forums)

Members: 0

Guests: 153

more...

Donat-O-Meter

Stats
Goal: AU$15.00
Due Date: Jun 30
Gross Amount: AU$0.00
Net Balance: AU$0.00
Left to go: AU$15.00
Make donations with PayPal!

Latest GitHub Commits