Code: Select all
$s_privmsg_new = 0;
}
Code: Select all
$s_privmsg_new = 0;
Code: Select all
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_gender,user_birthday, user_next_birthday_greeting, user_active, user_actkey)
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, '$gender','$birthday','$next_birthday_greeting',";
Code: Select all
, user_active, user_actkey
Code: Select all
Could not insert data into users table
DEBUG MODE
SQL Error : 1062 Duplicate entry '8388607' for key 1
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_gender,user_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES (8388608, 'sert', 1020415482, '202cb962ac59075b964b07152d234b70', '[email protected]', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, -6, 'D M d, Y g:i a', 'english', 1, 0, 1, '0','999999','',0, '03c61e1fb04cc')
Line : 551
File : /hsphere/local/home/abc/test/includes/usercp_register.php
Code: Select all
SQL-query:
UPDATE users SET user_lastlogon=user_lastvisit
#
#-----[ ADD SQL ]------------------------------------------
#
SQL-query:
INSERT INTO config (config_name, config_value) VALUES ('hidde_last_logon', '0')
Code: Select all
[FIND]
$dato=create_date('mdY', time(),$board_config['board_timezone']);
$timetoday=mktime(0,1,0,$dato[0].$dato[1],$dato[2].$dato[3],$dato[4].$dato[5].$dato[6].$dato[7]);
[REPLACE WITH]
$dato=create_date('Hi', time(),$board_config['board_timezone']);
$timetoday = time() - (3600*$dato[0].$dato[1]) - (60*$dato[2].$dato[3]);