Wernis API now reconizes failed API responses

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

diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php
index 1e2fd625b6b89c16c93032dbfb8e8b561db772c3..ddb605da4974e3274ba793bb252cefd1ced84f9c 100644 (file)
--- a/inc/modules/admin/what-config_rallye_prices.php
+++ b/inc/modules/admin/what-config_rallye_prices.php
@@ -188,8 +188,8 @@ VALUES ('%s','%s','%s','%s')",
                }
        } else {
                // a rallye was selected, so check if there are already prices assigned...
-               $result = SQL_QUERY_ESC("SELECT id, price_level, points, info FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE rallye_id=%s ORDER BY price_level",
-               array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__);
+               $result = SQL_QUERY_ESC("SELECT `id`, `price_level`, points`, `info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s ORDER BY `price_level` ASC",
+                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__);
 
                if (SQL_NUMROWS($result) > 0) {
                        // Load all prices for the selected rallye
@@ -236,13 +236,13 @@ VALUES ('%s','%s','%s','%s')",
        $result = SQL_QUERY("SELECT
        d.id, d.admin_id, d.start_time, d.end_time, d.title, a.login, d.is_active
 FROM
-       `{?_MYSQL_PREFIX?}_rallye_data` AS d,
+       `{?_MYSQL_PREFIX?}_rallye_data` AS d
 LEFT JOIN
        `{?_MYSQL_PREFIX?}_admins` AS a
 ON
        d.admin_id=a.id
 ORDER BY
-       `d.start_time` DESC", __FILE__, __LINE__);
+       d.start_time DESC", __FILE__, __LINE__);
        if (SQL_NUMROWS($result) > 0) {
                // List found rallyes
                $OUT = ''; $SW = 2;
@@ -251,15 +251,14 @@ ORDER BY
                        if ($content['is_active'] == 'Y') $select = "<div class=\"big\">".$content['id']."</div>";
 
                        // Prepare data for the row template
-                       // @TODO Rewritings: admin_id->admin_id, alogin->login in template
                        $content = array(
                                'sw'         => $SW,
                                'id'         => $content['id'],
                                'select'     => $select,
                                'title'      => $content['title'],
-                               'admin_id'        => $content['admin_id'],
+                               'admin_id'   => $content['admin_id'],
                                'email_link' => generateEmailLink($content['admin_id']),
-                               'alogin'     => $content['login'],
+                               'login'      => $content['login'],
                                'start'      => generateDateTime($content['start_time'], 3),
                                'end'        => generateDateTime($content['end_time'], 3),
                        );