phpBB.de

Code: Alles auswählen

Konnte Gästebucheintrag nicht hinzufügen!

Could not add entry!

DEBUG MODE

SQL Error : 1270 Illegal mix of collations (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'between'

SELECT COUNT(an) AS zaehle FROM phpbb_nickpagegb WHERE von = '2' AND an = '2' AND zeit BETWEEN '1104879950' AND '1104879981'

Line : 255
File : C:\Programme\apachefriends\xampp\htdocs\forum\nickpage_gb.php

Code: Alles auswählen

//Sicherheit
$sql = "SELECT safe_gb FROM ".NICKPAGE_TABLE." WHERE $uid='".$uid."'";
if( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Konnte UID nicht bestimmen!Could not get user id!', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);

//User möchte das nur eingeloggte USer ins GB schreiben dürfen
if($row['safe_gb'] == "1" AND $userdata['user_id'] == "-1")
{
	message_die(GENERAL_ERROR, $lang['NP_STOP'].': <b>'.$HTTP_GET_VARS['user'].'</b> '.$lang['NP_GB_USER_WANTS'].'!');
}

//Admin möchte, das nur ...
if($guestbook_writer == "1" AND $userdata['user_id'] == "-1")
{
	message_die(GENERAL_ERROR, $lang['NP_STOP'].': '.$lang['NP_GB_REGISTERED_ONLY'].'!');
}

//Gästebuch ist gesperrt
if($allow_guestbook == "0")
{
	message_die(GENERAL_ERROR, $lang['NP_STOP'].': '.$lang['NP_GB_FORBIDDEN_FROM_ADMIN'].'!');
}


if($HTTP_POST_VARS['addgbentry'] AND $HTTP_POST_VARS['message'] != "")
{
	if($userdata['user_id'] == "-1")
	{
		$von_uid = -1;
		$username = safeHTML($HTTP_POST_VARS['autor']);
	}
	else
	{
		$von_uid = $userdata['user_id'];
		$username = $userdata['username'];
	}
	//Spam?
	$sql = "SELECT COUNT(an) AS zaehle FROM ".GAESTEBUCH_TABLE." WHERE von = '".$von_uid."' AND an = '".$uid."' AND zeit BETWEEN '".(time()-30)."' AND '".(time()+1)."'";
	if( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Konnte Gästebucheintrag nicht hinzufügen!<br><br>Could not add entry!', '', __LINE__, __FILE__, $sql);
	}
	$row = $db->sql_fetchrow($result);
	if($row['zaehle'] == "0")
	{
		$sql = "INSERT INTO ".GAESTEBUCH_TABLE." (von, an, autor, zeit, message) VALUES ('".$von_uid."', '".$uid."', '".$username."', '".time()."', '".bbencode_first_pass(safeHTML($HTTP_POST_VARS['message']),$uid)."')";
		if( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Konnte Gästebucheintrag nicht hinzufügen!<br><br>Could not add entry!', '', __LINE__, __FILE__, $sql);
		}
		if(mysql_affected_rows() == "1")
		{
			mailto($uid);
			echo '<span class="genmed"><br>
			<br>
			<br>
			<center>'.$lang['NP_GB_THX'].'<br>
			'.$lang['NP_WINDOW_CLOSE'].'</center></span>
			<script type="text/javascript">
			<!--
			window.setTimeout("window.close()",5000);
			//-->
			</script>
			';
			exit;
		}
	}
	else
	{
		echo '<span class="genmed"><br>
		<br>
		<br>
		<center>'.$lang['NP_GB_THX'].'<br>
		'.$lang['NP_WINDOW_CLOSE'].'</center></span>
		<script type="text/javascript">
		<!--
		window.setTimeout("window.close()",5000);
		//-->
		</script>
		';
		exit;
	}
}
if($userdata['user_id'] == "-1")
{
	$template->assign_block_vars('Autor',array());
}

$template->assign_vars(array(
	'U_WARNING' => $lang['NP_WARNING'],
	'U_YOUR_NAME' => $lang['NP_YOUR_NAME'],
	'U_MESSAGE_TO' => $lang['NP_MESSAGE_TO'],
	'U_ADD_ENTRY' => $lang['NP_ADD_ENTRY'],
	'U_RESET_ENTRY' => $lang['NP_RESET_ENTRY'],
	'Nickname' => $HTTP_GET_VARS['user'],
));