RevBomb patch applied (thanks to profi-concept)

[mailer.git] / inc / modules / admin / what-list_surfbar_actions.php

diff --git a/inc/modules/admin/what-list_surfbar_actions.php b/inc/modules/admin/what-list_surfbar_actions.php
index c3fb242a1fb63a9e3131d1cdd4e2540c187959ab..8765e12bdd148f0649ba97cfc3eedca6120c4838 100644 (file)
--- a/inc/modules/admin/what-list_surfbar_actions.php
+++ b/inc/modules/admin/what-list_surfbar_actions.php
@@ -10,7 +10,12 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Auflistung von Mitgliederaktionen der Surfbar    *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision:: 856                                                    $ *
+ * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. Mär 2009)              $ *
+ * $Tag:: 0.2.1-FINAL                                                 $ *
+ * $Author:: stelzi                                                   $ *
+ * Needs to be in all Files and every File needs "svn propset           *
+ * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
@@ -41,7 +46,9 @@ if ((!defined('__SECURITY')) || (!is_admin())) {
 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) {
@@ -75,7 +82,7 @@ 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