public static function smileys_list()
{
global $db, $config;
$server_url = ip_functions::create_server_url();
$smileys_path = $server_url . (!empty($config['smilies_path']) ? ($config['smilies_path'] . '/') : 'images/smiles/');
$sql = "SELECT code, smile_url FROM " . SMILIES_TABLE . " ORDER BY smilies_order";
if ($result = $db->sql_query($sql))
{
$smileys_list = array();
while ($row = $db->sql_fetchrow($result))
{
$arr = array(
'code' => $row['code'],
'replace' => '[img]' . $smileys_path . $row['smile_url'] . '[/img]'
);
$smileys_list[] = $arr;
}
$db->sql_freeresult($result);
unset($arr);
}
return $smileys_list;
}
