Rejstacja na serwer PHP. Pomoc ;)

[3R✘]

Proszę o pomoc w edycji rejstracji na serwer.

Tabelki w mysql account standardowe

 

Występujący błąd:

ERROR:

• errorno=1054
• error=Unknown column 'sid_register' in 'field list'
• query=INSERT INTO account.account SET Login = 'tester', password = PASSWORD('zaq12wsx'), email = '[email protected]', social_id = '1234567', cash = '0', create_time = '14-02-03 03-29-39', sid_register='aac8a268139dfd1f73ef46ddb1c48c91', status='OK'
• file=/register.php

 

 

Kod PHP:

<?php




	include("config.php");
	include("_functions.php");
	include("includes/class/class_theme.php");
	
// main includes################################################################

################################################################################
// OF PAGE
load_lang('global');
$pg = 'rejestracja';
$query = safe_sql("SELECT * FROM ".$config['db_site'].".tuor_config WHERE config_name='$pg'");
$s = mysql_fetch_assoc($query);
	
if($s['config_value']=='off') { set_info($lang['off_'.$pg], 'error'); }
	
else {
################################################################################
	if(defined("TUOR"))	{
	if(user_logged() == 'yes')	{header("Location: ".$config['site_url']); 	
	} else { 
	
	
	
	
	$theme = new theme_classes;
	$theme->open_page("Rejestracja", load_key('register'), load_desc('register'));
    include("includes/theme_block/page_open.php");
	load_headline('register');
	
	
		mysql_select_db($config['db_account']);
		
		$key = $_GET['key'];
		$email = base64_decode($_GET['email']);
		
	if(isset($key) and isset($email)) {
		$sql = safe_sql("
			SELECT Login, email, sid_register
			FROM ".$config['db_account'].".account 
			WHERE email='$email' AND sid_register='$key'");
		if(mysql_num_rows($sql)==1) {
			safe_sql("UPDATE ".$config['db_account'].".account SET sid_register='', status='OK' WHERE email='$email' AND sid_register='$key'");
			set_info($lang['register_ok'], 'passed');
		}
	}
	else {	
		
		require_once ("includes/recaptchalib.php");
				
		$publickey = "6LfE2sUSAAAAAG9F50oAQIux83fdV2Okd4MgJFWk";
		$privatekey = "6LfE2sUSAAAAACRPyPA0CSmBk3KIrmf-9dfitA3v";
		$resp = null;
		$error = null;
		
		
		$r_login = htmlspecialchars($_POST['login']);
		$r_email = htmlspecialchars($_POST['email']);
		$r_pass = $_POST['pass'];
		$r_repass = $_POST['repass'];
		$r_zipcode = $_POST['zipcode'];
		$ref = $_GET['r'];
		
		
		$query_l = mysql_num_rows(safe_sql("SELECT Login FROM ".$config['db_account'].".account WHERE Login='$r_login'"));
		$query_e = mysql_num_rows(safe_sql("SELECT email FROM ".$config['db_account'].".account WHERE email='$r_email'"));
		$resp = recaptcha_check_answer ($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]);
		
		if(isset($_POST['register'])) {
		      if($r_login == '') 		{  $err = 'Wpisz Login'; }	  
		  elseif(strlen($r_login)<4) 	{  $err = 'Za Krotki Login, Minimum znaki 4.'; }
		  elseif(strlen($r_login)>20) 	{  $err = 'Za Dlugi Login, max 20 znakow.'; }
		  elseif(!preg_match("/^[a-z\d_]{4,20}$/i", $r_login)) { $err = 'Bledny login, tylko litery i cyfry (a-z, 0-9)'; }
		  elseif($query_l>=1)	{  $err = 'Podany Login jest juz zajety'; }
		  elseif($r_email == '') 		{  $err = 'Wpisz Email'; }
		  elseif(!preg_match("/^[^@]+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/", $r_email)) {  $err = 'Email jest nieprawidlowy'; }
		  elseif($query_e>=1)	{  $err = 'Podany Email jest juz zajety'; }
		  elseif($r_pass == '') 		{  $err = 'Wpisz Haslo'; }
		  elseif(strlen($r_pass)<7)		{  $err = 'Za Krotkie Haslo, Minimum 7 znakow.'; }
		  elseif($r_repass == '') 		{  $err = 'Powtórz Haslo'; }
		  elseif($r_pass <> $r_repass) 	{  $err = 'Hasla nie pasuja do siebie'; } 
		  elseif($_POST["recaptcha_response_field"]=='') { $err = 'Przepisz kod ReCaptcha.'; }
		  elseif(!$resp->is_valid) { $err = 'Zly kod ReCaptcha'; $error = $resp->error; }
		   elseif($_POST["reg"]<>'yes') { $err = 'Zatwierdz oswiadczenie o przeczytaniu regulaminu'; $error = $resp->error; }
		  else {
		       
				
				$cash=0;
				$date = date("y-m-d h-i-s", time());
				$ip = $_SERVER['REMOTE_ADDR'];
				$hash = rand(100000, 999999);
				$hash .= time();
				$key = md5($hash);
				
				if(isset($ref)) {
				$sql_ref = "ref='".$ref."',
				ref_status='no',";
				}
				
				safe_sql("INSERT INTO ".$config['db_account'].".account SET 
				Login = '".$r_login."', 
				password = PASSWORD('".$r_pass."'), 
				email = '".$r_email."', 
				social_id = '1234567',  
				cash = '".$cash."', 
				create_time = '".$date."',
				sid_register='".$key."',
				".$sql_ref."
				status='OK' ");
				
				load_lang('mail');	
					
				$message = $lang['register_message'];
				
				$mmel = base64_encode($r_email);
				$message = str_replace("{USER}", $r_login, $message);
				$message = str_replace("{KEY}", $key, $message);
				$message = str_replace("{EMAIL}", $mmel, $message);
				$message = str_replace("{IP}", $ip, $message);
										
				$mailheader  = "FROM: Itanos.pl <[email protected]> \n";
				$mailheader .= "MIME-Version: 1.0\n";
				$mailheader .= "Content-Type: text/html;\n";
				$mailheader .= "\tcharset=\"UTF-8\"\n";
			
	
				mail($r_email, $lang['register_header'], $message, $mailheader);		
			
				
				set_info($lang['account-create'], 'passed');
		  }
		}
				if(isset($ref)) {
				$ac_ref = '?r='.$ref;
				}
				$theme->open_tpl("register_body");
				$theme->change_tpl(array(
							'ACTION' =>	$config['site_url'].'register.php'.$ac_ref,
							'INFO_REG' =>	$lang['register-info-reg'],
							'ERROR' => $err,
							'R_EMAIL' => $r_email,
							'R_LOGIN' => $r_login,
							'RECAPTCHA' => recaptcha_get_html($publickey, $error),
						));
				$theme->show_tpl();
	 	}
	include("includes/theme_block/page_tail.php");
	$theme->close_page();
	}
  }
}
?>