function set_autoincrement($table, $column, $length, $unsigned = true)
{
global $db, $lang;
$sql = "ALTER IGNORE TABLE {$table} MODIFY {$column} mediumint({$length}) " . ($unsigned ? 'unsigned ' : '') . "NOT NULL auto_increment";
if (check_mysql_version()) {
$sql2 = "SHOW COLUMNS FROM {$table} LIKE '{$column}'";
$db->sql_return_on_error(true);
$result = $db->sql_query($sql2);
$db->sql_return_on_error(false);
if (!$result) {
throw_error("Couldn't get table status!", __LINE__, __FILE__, $sql2);
}
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$row) {
throw_error("Couldn't get table status!", __LINE__, __FILE__, $sql2);
}
if (strpos($row['Extra'], 'auto_increment') !== false) {
echo "<li>{$table}: " . $lang['Ai_message_no_update'] . '</li>' . "\n";
} else {
echo "<li>{$table}: <b>" . $lang['Ai_message_update_table'] . '</b></li>' . "\n";
$db->sql_return_on_error(true);
$result = $db->sql_query($sql);
$db->sql_return_on_error(false);
if (!$result) {
throw_error("Couldn't alter table!", __LINE__, __FILE__, $sql);
}
}
} else {
echo "<li>{$table}: <b>" . $lang['Ai_message_update_table_old_mysql'] . '</b></li>' . "\n";
$db->sql_return_on_error(true);
$result = $db->sql_query($sql);
$db->sql_return_on_error(false);
if (!$result) {
throw_error("Couldn't alter table!", __LINE__, __FILE__, $sql);
}
}
}
$result = $db->sql_query($sql);
$db->sql_return_on_error(false);
if (!$result) {
erc_throw_error("Couldn't get user data!", __LINE__, __FILE__, $sql);
}
?>
<p><?php
echo $lang['Removing_admins'] . ':';
?>
</p>
<ul>
<?php
while ($row = $db->sql_fetchrow($result)) {
if ($auth_method != 'board' || $board_user != $row['username']) {
// Checking whether user is a moderator
if (check_mysql_version()) {
$sql2 = "SELECT ug.user_id\n\t\t\t\t\t\t\t\tFROM " . USER_GROUP_TABLE . " ug\n\t\t\t\t\t\t\t\t\tINNER JOIN " . AUTH_ACCESS_TABLE . " aa ON ug.group_id = aa.group_id\n\t\t\t\t\t\t\t\tWHERE ug.user_id = " . $row['user_id'] . " AND ug.user_pending <> 1 AND aa.auth_mod = 1";
} else {
$sql2 = "SELECT ug.user_id\n\t\t\t\t\t\t\t\tFROM " . USER_GROUP_TABLE . " ug, " . AUTH_ACCESS_TABLE . " aa\n\t\t\t\t\t\t\t\tWHERE ug.group_id = aa.group_id\n\t\t\t\t\t\t\t\t\tAND ug.user_id = " . $row['user_id'] . "\n\t\t\t\t\t\t\t\t\tAND ug.user_pending <> 1 AND aa.auth_mod = 1";
}
$db->sql_return_on_error(true);
$result2 = $db->sql_query($sql2);
$db->sql_return_on_error(false);
if (!$result2) {
erc_throw_error("Couldn't get moderator data!", __LINE__, __FILE__, $sql2);
}
$new_state = intval(($row2 = $db->sql_fetchrow($result2)) ? MOD : USER);
$db->sql_freeresult($result2);
$sql2 = "UPDATE " . USERS_TABLE . "\n\t\t\t\t\t\t\tSET user_level = {$new_state}\n\t\t\t\t\t\t\tWHERE user_id = " . $row['user_id'];
$db->sql_return_on_error(true);
$result2 = $db->sql_query($sql2);
