- foreach ($_POST['sel'] as $id => $sel) {
- SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!MYSQL_PREFIX!}_refbanner` WHERE id=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
- }
- }
-
- // Referal levels
- $result = SQL_QUERY("SELECT id, url, alternate, visible, counter, clicks FROM `{!MYSQL_PREFIX!}_refbanner` ORDER BY url", __FILE__, __LINE__);
- if (SQL_NUMROWS($result) > 0)
- {
- // Make referal banner editable and deletable
- $SW = 2; $OUT = "";
- while (list($id, $url, $alt, $vis, $cntr, $clks) = SQL_FETCHROW($result))
- {
- // Preapre data for the row
- $content = array(
- 'sw' => $SW,
- 'id' => $id,
- 'url' => $url,
- 'alt' => $alt,
- 'vis' => TRANSLATE_YESNO($vis),
- 'cnt' => $cntr,
- 'clx' => $clks
- );
-
+ foreach (postRequestElement('sel') as $id => $sel) {
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_refbanner` WHERE `id`=%s LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ } // END - foreach
+ } // END - if
+
+ // Referral levels
+ $result = SQL_QUERY('SELECT `id`,`url`,`alternate`,`visible`,`counter`,`clicks` FROM `{?_MYSQL_PREFIX?}_refbanner` ORDER BY `url` ASC', __FILE__, __LINE__);
+
+ // Entries found?
+ if (!SQL_HASZERONUMS($result)) {
+ // Make referral banner editable and deletable
+ $OUT = '';
+ while ($content = SQL_FETCHARRAY($result)) {