]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-list_primera.php
Functions imported, some dev-scripts added
[mailer.git] / inc / modules / admin / what-list_primera.php
index f500925d529dc098ca8e8eb7e2b931de92e95063..93dd36b03ca5c46a1d3c302d59be46525210b8c0 100644 (file)
@@ -41,7 +41,7 @@ if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 ADD_DESCR("admin", __FILE__);
 
 // Check for entries
-$result = SQL_QUERY("SELECT id, userid, primera_account, primera_amount, primera_timestamp, primera_type, primera_api_message, primera_api_status FROM "._MYSQL_PREFIX."_user_primera ORDER BY primera_timestamp DESC, id DESC",
+$result = SQL_QUERY("SELECT id, userid, primera_account, primera_amount, primera_timestamp, primera_type, primera_api_message, primera_api_status FROM `{!_MYSQL_PREFIX!}_user_primera` ORDER BY primera_timestamp DESC, id DESC",
        __FILE__, __LINE__);
 
 // Are there some entries to display?
@@ -55,12 +55,16 @@ if (SQL_NUMROWS($result) > 0) {
                $content['primera_amount']              = TRANSLATE_COMMA($content['primera_amount']);
                $content['primera_timestamp']   = MAKE_DATETIME($content['primera_timestamp'], "2");
                $content['raw_type']                    = strtolower($content['primera_type']);
-               $content['primera_type']                        = PRIMERA_TRANSFER_STATUS($content['primera_type']);
+               $content['primera_type']                = PRIMERA_TRANSFER_STATUS($content['primera_type']);
+
+               // Fix empty message and status
+               if (empty($content['primera_api_message'])) $content['primera_api_message'] = "---";
+               if (empty($content['primera_api_status']))  $content['primera_api_status']  = "OK";
 
                // Append it and switch colors
                $OUT .= LOAD_TEMPLATE("admin_list_primera_row", true, $content);
                $SW = 3 - $SW;
-       }
+       } // END - while
 
        // Load main template
        LOAD_TEMPLATE("admin_list_primera_main", false, $OUT);