ADD_DESCR("admin", __FILE__);
// Load all actions
-$result = SQL_QUERY("SELECT id, status, action, new_status FROM "._MYSQL_PREFIX."_surfbar_actions ORDER BY id ASC", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT `id`, `status`, `action`, `new_status`
+FROM `{!_MYSQL_PREFIX!}_surfbar_actions`
+ORDER BY `status` ASC, `action` ASC", __FILE__, __LINE__);
// Entries found?
if (SQL_NUMROWS($result) > 0) {
LOAD_TEMPLATE("admin_list_surfbar_actions", false, $OUT);
} else {
// No entries found, very bad!
- LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_SURFBAR_NO_ACTIONS);
+ LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_SURFBAR_NO_ACTIONS'));
}
// Free result