stats question

[kosmo101]

Hello
how would i find the file (php) that tabulates the total members & mailing list subscribers? I know the block it is in but i need to know where it pulls that from... some function page maybe? Would like to see..

thanks

[kosmo101]

found it.. but how would i be able to add say 100 to the members count through the php file not adding them manually...code is:

$query = "select count(*) as tu from idx_users where status = 1";
$result = $dbConn->Execute($query);
$total_member = $result->Fields("tu");

[Bruceper]

why not just generate 100 users and import them into phpmyadmin. It would take less than one minute to do

[kosmo101]

u have any mySQL dump data to share for this? thank you!

[Bruceper]

Export your users table, copy one line and paste it 100 times. Then add an increasing number to the username and reimport.

Ensure that you copy a line from a user who is already verified otherwise your user count will not increase.

[esm]

found it.. but how would i be able to add say 100 to the members count through the php file not adding them manually...code is:

$query = "select count(*) as tu from idx_users where status = 1";
$result = $dbConn->Execute($query);
$total_member = $result->Fields("tu");

two seconds:

$total_member = $result->Fields("tu")+100;

.