xbdevsponsor |
19th February 2023 07:14 |
Code:
$sysops = get_row_count('users', "WHERE sysop='yes'");
$superadmins = get_row_count('users', "WHERE superadmin='yes'");
$supermoderators = get_row_count('users', "WHERE supermod='yes'");
$comvip = get_row_count('users', "WHERE comvip='yes'");
$donorvip = get_row_count('users', "WHERE donorvip='yes'");
$warned = number_format(get_row_count("users", "WHERE warned='no'"));
$irc = get_row_count('users', "WHERE irc='yes'");
$irc_idle = number_format(get_row_count("users", "WHERE irc_idle='no'"));
$suspened = number_format(get_row_count("users", "WHERE suspended='no'"));
phpmyadmin now:
Code:
Alter table users add sysop enum('yes','no') not null default 'no';
Alter table users add superadmin enum('yes','no') not null default 'yes';
Alter table users add supermod enum('yes','no') not null default 'no';
Alter table users add irc enum('yes','no') not null default 'no';
Alter table users add irc_idle enum('yes','no') not null default 'no';
ALTER TABLE users ADD suspended enum('yes','no') not null default 'no';
ALTER TABLE users ADD vip enum('yes','no') not null default 'no';
Alter table users add warned enum('yes','no') not null default 'no';
Above is new features added to this for more ideas as how it works :) good luck :gum:
extras:
Code:
$sysops = get_row_count('users', "WHERE sysop='yes'");
$superadmins = get_row_count('users', "WHERE superadmin='yes'");
$supermoderators = get_row_count('users', "WHERE supermod='yes'");
$comvip = get_row_count('users', "WHERE comvip='yes'");
$donorvip = get_row_count('users', "WHERE donorvip='yes'");
$warned = number_format(get_row_count("users", "WHERE warned='no'"));
$irc = get_row_count('users', "WHERE irc='yes'");
$irc_idle = number_format(get_row_count("users", "WHERE irc_idle='no'"));
$suspened = number_format(get_row_count("users", "WHERE suspended='no'"));
phpmyadmin now:
Code:
Alter table users add sysop enum('yes','no') not null default 'no';
Alter table users add superadmin enum('yes','no') not null default 'yes';
Alter table users add supermod enum('yes','no') not null default 'no';
Alter table users add irc enum('yes','no') not null default 'no';
Alter table users add irc_idle enum('yes','no') not null default 'no';
ALTER TABLE users ADD suspended enum('yes','no') not null default 'no';
ALTER TABLE users ADD vip enum('yes','no') not null default 'no';
Alter table users add warned enum('yes','no') not null default 'no';
Above is new features added to this for more ideas as how it works :) good luck :gum:
extras:
Code:
//==09 users on index
$active3 ="";
$file = "./cache/active.txt";
$expire = 30; // 30 seconds
if (file_exists($file) && filemtime($file) > (time() - $expire)) {
$active3 = unserialize(file_get_contents($file));
} else {
$dt = sqlesc(time() - 180);
$active1 = sql_query("SELECT id, username, class, warned, donor FROM users WHERE last_access >= $dt ORDER BY class DESC") or sqlerr(__FILE__, __LINE__);
while ($active2 = mysqli_fetch_assoc($active1)) {
$active3[] = $active2;
}
$OUTPUT = serialize($active3);
$fp = fopen($file, "w");
fputs($fp, $OUTPUT);
fclose($fp);
} // end else
$activeusers = "";
if (is_array($active3))
foreach ($active3 as $arr) {
if ($activeusers) $activeusers .= ",\n";
$activeusers .= "";
$arr["username"] = " " . htmlspecialchars($arr['username']) . "";
$donator = $arr["donor"] === "yes";
$warned = $arr["warned"] === "yes";
if ($CURUSER)
$activeusers .= "{$arr["username"]}";
else
$activeusers .= "{$arr["username"]}";
if ($donator)
$activeusers .= "";
if ($warned)
$activeusers .= "";
$activeusers .= "";
}
if (!$activeusers)
$activeusers = "{$lang['index_noactive']}";
echo "
Owners (0) | Super Admin (0) | Administrators (0) | Super Mod (0) | Moderators (0) | V.I.P (0) | ComVIP (0) | Trustee VIP | Scene Trustee | Extreme Users (0) | Power Users (0) | Members (0) | Validating (0) | Suspended (0)
";
echo " ";
|