phpBB.de

// Start add - EMOTIONS MOD
$lang['Emotion'] = "Stimmung:<br>";//used in users profile to display witch emotion he/she has
$lang['Agressive'] = "Aggressiv";
$lang['Amazed'] = "Verblüfft";
$lang['Angry'] = "Zornig";
$lang['Bored'] = "Gelangweilt";
$lang['Busy'] = "Beschäftigt";
$lang['Buzzed'] = "Summend";
$lang['Cold'] = "Frostig";
$lang['Cool'] = "Cool";
$lang['Dead'] = "Gestorben";
$lang['Fine'] = "Prima";
$lang['Happy'] = "Glücklich";
$lang['Hot'] = "Heiss";
$lang['Ill'] = "Krank";
$lang['Inlove'] = "Verliebt";
$lang['Inspired'] = "Begeistert";
$lang['Sad'] = "Traurig";
$lang['Shocked'] = "Erschreckt";
$lang['Sleep'] = "Schlafend";
$lang['Tired'] = "Müde";
$lang['No_emotion_specify'] = "nicht sichtbar";
// End add - EMOTIONS MOD

<!-- Start add - Emotion MOD -->
<tr>
<td class="row1"><span class="gen">{L_EMOTION}</span></td>
<td class="row2">{EMOTION_SELECT}</td>
</tr>
<!-- End add - Emotion MOD -->

<!-- Start add - Emotion MOD -->
<tr>
<td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_EMOTION}:</span></td>
<td> <b><span class="gen">{EMOTION}</span></b></td>
</tr>
<!-- End add - Emotion MOD -->

<i>&nbsp;&nbsp;{postrow.POSTER_EMOTION}</i><br />

// Start add - Emotion MOD
switch ($postrow[$i]['user_emotion'])
{
case 1 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_agressive'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Agressive']."\" title=\"" . $lang['Emotion'] . ":".$lang['Agressive']. "\" border=\"0\" />"; break;
case 2 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_amazed'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Amazed']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Amazed']. "\" border=\"0\" />"; break;
case 3 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_angry'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Angry']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Angry']. "\" border=\"0\" />"; break;
case 4 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_bored'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Bored']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Bored']. "\" border=\"0\" />"; break;
case 5 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_busy'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Busy']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Busy']. "\" border=\"0\" />"; break;
case 6 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_buzzed'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Buzzed']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Buzzed']. "\" border=\"0\" />"; break;
case 7 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_cold'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Cold']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Cold']. "\" border=\"0\" />"; break;
case 8 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_cool'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Cool']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Cool']. "\" border=\"0\" />"; break;
case 9 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_dead'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Dead']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Dead']. "\" border=\"0\" />"; break;
case 10 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_fine'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Fine']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Fine']. "\" border=\"0\" />"; break;
case 11 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_happy'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Happy']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Happy']. "\" border=\"0\" />"; break;
case 12 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_hot'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Hot']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Hot']. "\" border=\"0\" />"; break;
case 13 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_ill'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Ill']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Ill']. "\" border=\"0\" />"; break;
case 14 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_inlove'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Inlove']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Inlove']. "\" border=\"0\" />"; break;
case 15 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_inspired'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Inspired']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Inspired']. "\" border=\"0\" />"; break;
case 16 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_sad'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Sad']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Sad']. "\" border=\"0\" />"; break;
case 17 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_shocked'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Shocked']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Shocked']. "\" border=\"0\" />"; break;
case 18 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_sleep'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Sleep']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Sleep']. "\" border=\"0\" />"; break;
case 19 : $emotion_image = $lang['Emotion']." <img src=\"" . $images['icon_tired'] . "\" alt=\"" . $lang['Emotion']. ":".$lang['Tired']. "\" title=\"" . $lang['Emotion'] . ":".$lang['Tired']. "\" border=\"0\" />"; break;
default : $emotion_image="";
}
// End add - Emotion MOD

Couldn't query themes table

DEBUG MODE

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

SELECT emotion_id, emotion_name_german FROM phpbb_emotions ORDER BY emotion_id

Line : 151
File : functions_selects.php