Kod: Markera allt
$userArray = array(
'user_id' => '',
'user_type' => 0,
'group_id' => 2,
'user_permissions' => '',
'user_perm_from' => 0,
'user_ip' => $_SERVER['REMOTE_ADDR'],
'user_regdate' => time(),
'username' => $_POST['username'],
'username_clean' => strtolower($_POST['username']),
'user_password' => md5($_POST['pwd1']),
'user_passchg' => time(),
'user_pass_convert' => 0,
'user_email' => strtolower($_POST['mail1']),
'user_email_hash' => crc32(strtolower($_POST['mail1']).strlen($_POST['mail1'])),
'user_birthday' => '',
'user_lastvisit' => 0,
'user_lastmark' => time(),
'user_lastpost_time' => 0,
'user_lastpage' => '',
'user_last_confirm_key' => '',
'user_last_search' => 0,
'user_warnings' => 0,
'user_last_warning' => 0,
'user_login_attempts' => 0,
'user_inactive_reason' => 0,
'user_inactive_time' => 0,
'user_posts' => 0,
'user_lang' => 'sv',
'user_timezone' => 1.00,
'user_dst' => 1,
'user_dateformat' => '|D d M Y|, H:i',
'user_style' => 1,
'user_rank' => 0,
'user_colour' => '',
'user_new_privmsg' => 0,
'user_unread_privmsg' => 0,
'user_last_privmsg' => 0,
'user_message_rules' => 0,
'user_full_folder' => -3,
'user_topic_show_days' => 0,
'user_topic_sortby_type' => 't',
'user_topic_sortby_dir' => 'd',
'user_post_show_days' => 0,
'user_post_sortby_type' => 't',
'user_post_sortby_dir' => 'a',
'user_notify' => 0,
'user_notify_pm' => 1,
'user_notify_type' => 0,
'user_allow_pm' => 1,
'user_allow_viewonline' => 1,
'user_allow_viewemail' => 1,
'user_allow_massemail' => 1,
'user_options' => 895,
'user_avatar' => '',
'user_avatar_type' => 0,
'user_avatar_width' => 0,
'user_avatar_height' => 0,
'user_sig' => '',
'user_sig_bbcode_uid' => '',
'user_sig_bbcode_bitfield' => '',
'user_from' => '',
'user_icq' => '',
'user_aim' => '',
'user_yim' => '',
'user_msnm' => '',
'user_jabber' => '',
'user_website' => '',
'user_occ' => '',
'user_interests' => '',
'user_actkey' => '',
'user_newpasswd' => ''
);
$userArray2 = $userArray;
$sql = 'INSERT INTO `phpbb_users` (';
while(count($userArray2)){
if($i == 0){
$sql = $sql.'`'.key($userArray2).'`';
$i = 1;
}else{
$sql = $sql.', `'.key($userArray2).'`';
}
array_shift($userArray2);
}
$sql = $sql.') VALUES (';
$j = 0;
while(count($userArray) > 0){
if($j == 0){
$sql = $sql.'\''.current($userArray).'\'';
$j = 1;
}else{
$sql = $sql.', \''.current($userArray).'\'';
}
array_shift($userArray);
}
$sql = $sql.')';
mysql_query($sql);
