$sel) { // Secure ID $id = bigintval($id); // Update entry SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_refbanner` SET url='%s', alternate='%s', `visible`='%s' WHERE id=%s LIMIT 1", array( REQUEST_POST('url', $id), REQUEST_POST('alternate', $id), REQUEST_POST('visible'), $id ), __FILE__, __LINE__); } break; } if (SQL_AFFECTEDROWS() == 1) { $content = getMessage('SETTINGS_SAVED'); } else { $content = "{--SETTINGS_NOT_SAVED--}"; } LOAD_TEMPLATE('admin_settings_saved', false, $content); } elseif (($SEL > 0) && (REQUEST_ISSET_POST('edit'))) { // Edit banner $SW = ''; $OUT = ''; foreach (REQUEST_POST('sel') as $id => $sel) { // Load data $result = SQL_QUERY_ESC("SELECT url, alternate, visible FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE id=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); list($url, $alt, $vis) = SQL_FETCHROW($result); SQL_FREERESULT($result); // Preapre data for the row $content = array( 'sw' => $SW, 'id' => $id, 'url' => $url, 'alt' => $alt, 'vis' => ADD_SELECTION("yn", $vis , "visible"), ); // Load row template and switch color $OUT .= LOAD_TEMPLATE("admin_refbanner_edit_row", true, $content); $SW = 3 - $SW; } // @TODO Rewrite this constant define('__BANNER_ROWS', $OUT); // Load main template LOAD_TEMPLATE("admin_refbanner_edit"); } else { if (($SEL > 0) && (REQUEST_ISSET_POST('del'))) { // Delete banner foreach (REQUEST_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 $OUT = ''; $SW = 2; while ($content = SQL_FETCHARRAY($result)) { // Preapre data for the row // @TODO Rewritings: alt->alternate,cnt->counter,clx->clicks in template $content = array( 'sw' => $SW, 'id' => $content['id'], 'url' => $content['url'], 'alt' => $content['alternate'], 'vis' => TRANSLATE_YESNO($content['visible']), 'cnt' => $content['counter'], 'clx' => $content['clicks'] ); // Load row template and switch color $OUT .= LOAD_TEMPLATE("admin_refbanner_row", true, $content); $SW = 3 - $SW; } // Free memory SQL_FREERESULT($result); // @TODO Rewrite this constant define('__BANNER_ROWS', $OUT); // Load main template LOAD_TEMPLATE("admin_refbanner"); } // Form for adding new referal levels LOAD_TEMPLATE("admin_add_banner"); } // ?>