phpBB.de

Code: Alles auswählen

#
#----[ OPEN ] ---------------
#

includes/functions_selects.php

#
#----[ FIND ]-------------------
#
//
// Pick an emotion
//
function emotion_select($default_emotion, $select_name = "emotion")
{
	global $db;



	$sql = "SELECT emotion_id, emotion_name
		FROM " . EMOTIONS_TABLE . "
		ORDER BY  emotion_id";
	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, "Couldn't query themes table", "", __LINE__, __FILE__, $sql);
	}

	$emotion_select = '<select name="' . $select_name . '">';
	while ( $row = $db->sql_fetchrow($result) )
	{
		$selected = ( $row['emotions_id'] == $default_emotion ) ? ' selected="selected"' : '';

		$emotion_select .= '<option value="' . $row['emotion_id'] . '"' . $selected . '>' . $row['emotion_name'] . '</option>';
	}
	$emotion_select .= "</select>";

	return $emotion_select;

}

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

//
// Pick an emotion
//
function emotion_select($default_emotion, $select_name = "emotion")
{
	global $db, $userdata;

$language = $userdata['user_lang'];
$default_emotion = $userdata['user_emotion'];
switch ($default_emotion)
{
	case 0 : $def_emo = 'keine'; break;
	case 1 : $def_emo = $lang['Agressive']; break;
	case 2 : $def_emo = $lang['Amazed']; break;
	case 3 : $def_emo = $lang['Angry']; break;
	case 4 : $def_emo = $lang['Bored']; break;
	case 5 : $def_emo = $lang['Busy']; break;
	case 6 : $def_emo = $lang['Buzzed']; break;
	case 7 : $def_emo = $lang['Cold']; break;
	case 8 : $def_emo = $lang['Cool']; break;
	case 9 : $def_emo = $lang['Dead']; break;
	case 10 : $def_emo = $lang['Fine']; break;
	case 11 : $def_emo = $lang['Happy']; break;
	case 12 : $def_emo = $lang['Hot']; break;
	case 13 : $def_emo = $lang['Ill']; break;
	case 14 : $def_emo = $lang['Inlove']; break;
	case 15 : $def_emo = $lang['Inspired']; break;
	case 16 : $def_emo = $lang['Sad']; break;
	case 17 : $def_emo = $lang['Shocked']; break;
	case 18 : $def_emo = $lang['Sleep']; break;
	case 19 : $def_emo = $lang['Tired']; break;
}

if ($language ='german')
	{
	$sql = "SELECT emotion_id, emotion_name_german
		FROM " . EMOTIONS_TABLE . "
		ORDER BY  emotion_id";
	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, "Couldn't query themes table", "", __LINE__, __FILE__, $sql);
	}

	$emotion_select = '<select name="' . $select_name . '">';
	while ( $row = $db->sql_fetchrow($result) )
	{
  $selected = ( $row['emotion_id'] == $default_emotion ) ? ' selected="selected"' : '';

		$emotion_select .= '<option value="' . $row['emotion_id'] . '"' . $selected . '>' . $row['emotion_name_german'] . '</option>';
	}
	$emotion_select .= "</select>";

	return $emotion_select;
	}
	else
	{
	$sql = "SELECT emotion_id, emotion_name_english
		FROM " . EMOTIONS_TABLE . "
		ORDER BY  emotion_id";
	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, "Couldn't query themes table", "", __LINE__, __FILE__, $sql);
	}

	$emotion_select = '<select name="' . $select_name . '">';
	while ( $row = $db->sql_fetchrow($result) )
	{
		$selected = ( $row['emotions_id'] == $default_emotion ) ? ' selected="selected"' : '';

		$emotion_select .= '<option value="' . $row['emotion_id'] . '"' . $selected . '>' . $row['emotion_name_english'] . '</option>';
	}
	$emotion_select .= "</select>";

	return $emotion_select;
	}
}

Code: Alles auswählen

SQL Error : 1054 Unknown column 'emotion_name_german' in 'field list'

SELECT emotion_id, emotion_name_german FROM phpbb_gsemotions ORDER BY emotion_id

Line : 151
File : functions_selects.php