they turn off the register page. before they release this. so better we wait for them till they tell us how to turn on the register page.
[ERROR/WARNING]
Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated., SQL state 22001 in SQLExecDirect in C:\xampp\htdocs\sites\regist.php on line 72
[CODE] line 24 to 93
if(!$_CONFIG['registration_enabled']) {
$strOutputErrorArray[] = $_LANG['error_registration_disabled'];
}
if(isSpamming($_POST['inputCheckTimestamp'], $_POST['inputCheckKey'], $_SESSION['inputCheckKey'])) {
$strOutputErrorArray[] = $_LANG['error_spam'];
}
if(empty($account) or empty($pass1) or empty($pass2) or empty($email) or empty($email2) or empty($gefra) or empty($geant) or empty($birthday)) {
$strOutputErrorArray[] = $_LANG['error_fill_in_all_fields'];
}
if(!isset($_POST['registCheckbox'])) {
$strOutputErrorArray[] = $_LANG['error_confirm_recaptcha'];
}
if($accountcheck1 > 0 OR $accountcheck2 > 0) {
$strOutputErrorArray[] = $_LANG['error_accountname_is_taken'];
}
if((strlen($account) > 16) || (strlen($account) < 3)) {
$strOutputErrorArray[] = $_LANG['error_account_length'];
}
if ($account != preg_replace ("/[^A-Za-z0-9]/", "", $account)) {
$strOutputErrorArray[] = $_LANG['error_no_special_characters_account'];
}
if((strlen($pass1) > 16) || (strlen($pass1) < 6)) {
$strOutputErrorArray[] = $_LANG['error_password_length'];
}
if($pass1 != $pass2) {
$strOutputErrorArray[] = $_LANG['error_passwords_indistinguishable'];
}
if($geant != preg_replace('/[^A-Za-z0-9 ]/', '', $geant)) {
$strOutputErrorArray[] = $_LANG['error_no_special_characters_secret_answer'];
}
if(strtolower($email) != strtolower($email2)) {
$strOutputErrorArray[] = $_LANG['error_mails_indistinguishable'];
}
if(!preg_match('/^[a-zA-Z0-9-_.]+@[a-zA-Z0-9-_.]+\.[a-zA-Z]{2,4}$/', $email)) {
$strOutputErrorArray[] = $_LANG['error_mail_must_be_valid'];
}
if(in_array($provider, $_CONFIG['web_mail_provider'])) {
$strOutputErrorArray[] = $_LANG['error_spam_provider'];
}
if(!strtotime($birthday)) {
$strOutputErrorArray[] = $_LANG['error_valid_birthday'];
}
if(count($strOutputErrorArray) > 0) {
echo createMessage($strOutputErrorArray, 'fail');
}
else {
if(odbc_exec($odbc_connect, '
EXEC [' . $_CONFIG['db_databases']['acc'] . '].[dbo].[usp_createAccount] @account=\'' . $account . '\', @pw=\''.$md5pw.'\', @email=\''.$email.'\', @gefra=\''.$gefra.'\', @geant=\''.md5($_CONFIG['security_secretAnswerSalt'].$geant).'\', @birthday=\''.date($_CONFIG['web_date_format']['date'], strtotime($birthday)).'\', @ip = \'' . $_SERVER['REMOTE_ADDR'] . '\', @lang=\'' . $_CONFIG['web_default_lang'] . '\'
')) {
$_SESSION['user'] = strtolower($account);
$_SESSION['votepoints'] = 0;
$_SESSION['cash'] = 0;
echo createMessage('Der Account ' . cleanHtmlOutput($account) . ' wurde erfolgreich registriert.', 'success');
}
else {
echo createMessage('Der Account konnte nicht in die Datenbank geschrieben werden.', 'fail');
}
}
}
else {
if($_CONFIG['registration_enabled']) {
if($_CONFIG['registration_verify_mail_enabled']) {
echo createMessage($_LANG['notify_registration'], 'hint');
}
}
else {
echo createMessage($_LANG['error_registration_disabled'], 'fail');
}
}
?>
