Location: PHPKode > projects > PHP-Fusion > db_updates/db_update 09-06-24.txt
<?php
$result = dbquery("ALTER TABLE ".$db_prefix."users ADD user_actiontime INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER user_status");

$result = dbquery("SELECT user_id, user_rights FROM ".$db_prefix."users WHERE user_level='103'");
while ($data = dbarray($result)) {
	$result2 = dbquery("UPDATE ".$db_prefix."users SET user_rights='".$data['user_rights'].".S9' WHERE user_id='".$data['user_id']."'");
}

$result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S9', 'members.gif', 'User Management', 'settings_users.php', '4')");


$result = dbquery("CREATE TABLE ".$db_prefix."suspends (
suspend_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
suspended_user MEDIUMINT(8) UNSIGNED NOT NULL,
suspending_admin MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
suspend_ip VARCHAR(20) NOT NULL DEFAULT '0.0.0.0',
suspend_date INT(10) NOT NULL DEFAULT '0',
suspend_reason TEXT NOT NULL,
suspend_type TINYINT(1) NOT NULL DEFAULT '0',
reinstating_admin MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
reinstate_reason TEXT NOT NULL,
reinstate_date INT(10) NOT NULL DEFAULT '0',
reinstate_ip VARCHAR(20) NOT NULL DEFAULT '0.0.0.0',
PRIMARY KEY (suspend_id)
) ENGINE=MyISAM");

?>
Return current item: PHP-Fusion