function smiley($message)
{
$smileys = $this->getSmileys();
foreach ($smileys as $smile) {
$message = str_replace($smile['code'], '<img src="'.XOOPS_UPLOAD_URL.'/'.htmlspecialchars($smile['smile_url']).'" alt="" />', $message);
}
return $message;
}
function smiley($message)
{
$db =& Database::getInstance();
if (count($this->smileys) == 0) {
if ($getsmiles = $db->query("SELECT * FROM ".$db->prefix("smiles"))){
while ($smiles = $db->fetchArray($getsmiles)) {
$message = str_replace($smiles['code'], '<img src="'.XOOPS_UPLOAD_URL.'/'.htmlspecialchars($smiles['smile_url']).'" alt="" />', $message);
array_push($this->smileys, $smiles);
}
}
}
elseif (is_array($this->smileys)) {
foreach ($this->smileys as $smile) {
$message = str_replace($smile['code'], '<img src="'.XOOPS_UPLOAD_URL.'/'.htmlspecialchars($smile['smile_url']).'" alt="" />', $message);
}
}
return $message;
}
SELECT t.topic_id, t.topic_replies, t.forum_id, t.topic_title, t.topic_views, t.type_id, f.forum_name, p.post_id, p.post_time, p.icon, p.uid, p.poster_name FROM xoops_bb_topics AS t LEFT JOIN xoops_bb_posts AS p ON t.topic_last_post_id=p.post_id LEFT JOIN xoops_bb_forums AS f ON f.forum_id=t.forum_id WHERE 1=1 AND t.forum_id IN (17,20,19,18,22,23,24,25,26,41,21,63,27,28,29,30,31,35,61,44,37,39,36,32,59,16,34,2,3,4,5,6,7,8,9,11,62,47,48,49,50,51,13,64,52,53,54,55,56,57,58,38,43,14,40) AND t.approved = 1 AND t.topic_time>1169069351 ORDER BY t.topic_last_post_id DESC LIMIT 0, 5
Error number: 1054
Error message: Unknown column 't.type_id' in 'field list'