$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 = 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; } 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 $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 ); // Load row template and switch color $OUT .= LOAD_TEMPLATE("admin_refbanner_row", true, $content); $SW = 3 - $SW; } // Free memory SQL_FREERESULT($result); define('__BANNER_ROWS', $OUT); // Load main template LOAD_TEMPLATE("admin_refbanner"); } // Form for adding new referal levels LOAD_TEMPLATE("admin_add_banner"); } // ?>