phpBB.de

Code: Alles auswählen

			$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_birthday, user_next_birthday_greeting, user_active, user_actkey)

Code: Alles auswählen

			$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_birthday, user_next_birthday_greeting, user_active, user_actkey, user_regip)

Code: Alles auswählen

				$sql .= "0, '" . str_replace("\'", "''", $user_actkey) . "')";
			}
			else
			{
				$sql .= "1, '')";
			}

			if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )

Code: Alles auswählen

				$sql .= "0, '" . str_replace("\'", "''", $user_actkey) . "', ";
			}
       				 else 
        			 { 
        			    $sql .= "1, '', "; 
        			 } 
	
        			 $sql .= "'$user_ip' )";

			if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )

Code: Alles auswählen

# 
#-----[ FIND ]------------------------------------------------------ 
# 

$sql .= "0, '" . str_replace("\'", "''", $user_actkey) . "')"; 

# 
#-----[ REPLACE WITH ]---------------------------------------------- 
# 

$sql .= "0, '" . str_replace("\'", "''", $user_actkey) . "', "; 

Code: Alles auswählen

$sql = "INSERT INTO " . USERS_TABLE  .............