MySQL Users registered count

[xandizitxu]

I want to know the query that I can give me how many users are in a specific usergroup.

so i can limit user registration,
adding this code on register.php

$useregn = mysql_query("The query")
$reguser = fetch_mysql_assoc("useregn")

if ($reguser > "2000")
die('Limit user reach')

I really need this, thanks if anyone can support me.

[WhaLberg]

Feel free to use this:

PHP Code:

$usercount = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE usergroupid='x'");

$totalusers = vb_number_format($usercount); 


[xandizitxu]

Thank You!

[Paul M]

Except you don't want to use vb_number_format() as you will break comparisons.

[xandizitxu]

If I insert this on my register.php it will work?

PHP Code:

$usercount = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE usergroupid='2'");

$totalusers = vb_number_format($usercount);  

if ($totalusers > 2000)
die ("Registration is closed"); 


It will work?

[Dean C]

If you put this code in the correct place in register.php it will work:

PHP Code:

$usercount = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE usergroupid='2'");



if ($usercount['count'] >= 2000)
die ("Registration is closed"); 


I'm surprised there's not a mod to do this already actually, might see if I can code up a clean solution this evening

[xandizitxu]

Oh thank you! I would love that! ^^