Total members Incorrect and wont update!

[SatMan2028]

Tried your suggestions. Still no luck! Mysql says those rows are corrupted. I deleted them and I guess I'll have to enter in all 94 manually. I saved the info and was hoping to be able to mass upload them but it wont create the rows and write to the columns. If I create blank ones it writes the info in a matter of seconds. I created 5 new rows and inserted the data through php script and they are counted correctly. That will take some time to create 89 more empty rows since it only lets you create one at a time. almost not worth the trouble!

[SatMan2028]

Let me ask this! Is there anyway to have that code in index.php just grab the last userid! Atleast then I'll have a more accurate count since the userid's are used in sequence.

[N9ne]

SELECT userid FROM user ORDER BY userid DESC LIMIT 1

That will grab the highest userid.

[SatMan2028]

I hate to be a pain but I done the following and I know it isnt correct.

In /forums/index.php I changed :

$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=number_format($numbersmembers['users']);

to

$numbersmembers=$DB_site->query_first('SELECT userid FROM user ORDER BY userid DESC LIMIT 1');
$numbermembers=number_format($numbersmembers['users']);

What is not correct here?

[Tigga]

Change $numbermembers=number_format($numbersmembers['users']);
To $numbermembers=number_format($numbersmembers['userid']);

[SatMan2028]

OK I changed it to:

$numbersmembers=$DB_site->query_first('SELECT userid FROM user ORDER BY userid DESC LIMIT 1');
$numbermembers=number_format($numbersmembers['userid']);

AND I get this:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT userid,username FROM user WHERE userid=
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

Date: Tuesday 22nd of April 2003 02:04:41 AM
Script: http://www.satcetera.com/forums/forums/index.php
Referer: http://satcetera.com/admin.php?s=&op=adminMain

[SatMan2028]

I will pay $50.00 USD to anyone who can give me an answer to this problem. Fast money for a fast solution....I am desperate!

[N!ck]

I think there are some compatibility problems with MySQL 4, but I don't really know anything about them, so I can't help you unfortunately.

[SatMan2028]

I didn't think it would be this hard but it has me stumped. All I want is for the forums/index.php to show the last registered users id (userid). Instead of counting the number of rows in the 'user' db! So on my forums home page the "total members" shows the userid of the last registered user.

[SatMan2028]

Well how about $100 USD! Please somebody has to know how to do this!

I'm uploading the index.php! If you can make it display the userid of the last registered user instead of total number of current users, you will be my new best friend and be $100 richer!

Thanks