$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."users");
$result = dbquery("CREATE TABLE ".$db_prefix."users (
user_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
user_name VARCHAR(30) NOT NULL DEFAULT '',
user_algo VARCHAR(10) NOT NULL DEFAULT 'sha256',
user_salt VARCHAR(40) NOT NULL DEFAULT '',
user_password VARCHAR(64) NOT NULL DEFAULT '',
user_admin_algo VARCHAR(10) NOT NULL DEFAULT 'sha256',
user_admin_salt VARCHAR(40) NOT NULL DEFAULT '',
user_admin_password VARCHAR(64) NOT NULL DEFAULT '',
user_email VARCHAR(100) NOT NULL DEFAULT '',
user_hide_email TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
user_offset CHAR(5) NOT NULL DEFAULT '0',
user_avatar VARCHAR(100) NOT NULL DEFAULT '',
user_posts SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
user_threads TEXT NOT NULL,
user_joined INT(10) UNSIGNED NOT NULL DEFAULT '0',
user_lastvisit INT(10) UNSIGNED NOT NULL DEFAULT '0',
user_ip VARCHAR(45) NOT NULL DEFAULT '0.0.0.0',
user_ip_type TINYINT(1) UNSIGNED NOT NULL DEFAULT '4',
user_rights TEXT NOT NULL,
user_groups TEXT NOT NULL,
user_level TINYINT(3) UNSIGNED NOT NULL DEFAULT '101',
user_status TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
user_actiontime INT(10) UNSIGNED NOT NULL DEFAULT '0',
user_theme VARCHAR(100) NOT NULL DEFAULT 'Default',
user_location VARCHAR(50) NOT NULL DEFAULT '',
user_birthdate DATE NOT NULL DEFAULT '0000-00-00',
user_skype VARCHAR(100) NOT NULL DEFAULT '',
user_aim VARCHAR(16) NOT NULL DEFAULT '',
user_icq VARCHAR(15) NOT NULL DEFAULT '',
user_msn VARCHAR(100) NOT NULL DEFAULT '',
user_yahoo VARCHAR(100) NOT NULL DEFAULT '',
user_web VARCHAR(200) NOT NULL DEFAULT '',
user_sig TEXT NOT NULL,
PRIMARY KEY (user_id),
KEY user_name (user_name),
KEY user_joined (user_joined),
KEY user_lastvisit (user_lastvisit)
) ENGINE=MYISAM;");
// getmequick at gmail dot com
// http://www.php.net/manual/en/function.unserialize.php#71270
function unserializeFix($var) {
$var = preg_replace('!s:(\d+):"(.*?)";!e', "'s:'.strlen('$2').':\"$2\";'", $var);
return unserialize($var);
}
$data = dbarray($result);
$user_info = unserializeFix(stripslashes($data['user_info']));
$result = dbquery("INSERT INTO ".DB_USERS." (".$user_info['user_field_fields'].") VALUES (".$user_info['user_field_inputs'].")");
$result = dbquery("DELETE FROM ".DB_NEW_USERS." WHERE user_code='".$_GET['code']."' LIMIT 1");
Category Forum
User Administration - 8Labels
None yet
Statistics
3 participants
Notifications
You are not receiving notifications from this thread.
Related Questions