Small Hack

How Do I List Diff Users Count On Main Page

Platinum Members: ?
Platinum+ Members: ?
Moderators: ?
Super Moderator: ?
Administrators: ?

How Do I Fill In The "?"'s

i know it's a templat edit, but what coding is required for it to work?

[Dean C]

This requires more of a template edit. It requires code modications also.

Something like this in your index.php:

PHP Code:

$platinum_usergroupid = 7; 
$platinum_users = $DB_site->query_first("SELECT COUNT(*) AS total FROM user WHERE usergroupid='".invtal($platinum_usergroupid)."'"); 


A bit of modifcation of that code will do the trick

[Logitech-2004]

Fatal error: Call to undefined function: invtal() in /var/www/html/platinum/index.php on line 16

[Lesane]

Typo from mist, change invtal into intval

[Logitech-2004]

Platinum+ Members: Array
ummm?

[Neo]

$platinum_users[total]
$platinumplus_users[total]
$moderators[total]
etc

make sure you add the array name after the variable.

[Logitech-2004]

Thanx Neo!!! Hey, U Want To Make That Hack For Me?

[Logitech-2004]

$3M1=$DB_site->query_first("SELECT FROM 3MStatus WHERE 3M1");
$3M2=$DB_site->query_first("SELECT FROM 3MStatus WHERE 3M2");
$3M3=$DB_site->query_first("SELECT FROM 3MStatus WHERE 3M3");
$3M4=$DB_site->query_first("SELECT FROM 3MStatus WHERE 3M4");

Do You See Problem With This?

[assassingod]

Yes, in the WHERE clause you arent setting a column. You need to use WHERE colname = '3m1' etc

(You have to change colname though)

Also, you aren't selecting anything. (If you want to select everything, use SELECT * )

[Logitech-2004]

i have in my database

Table: 3MStstus
And Col's 3M1 3M2 3M3 3M4