X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-refbanner.php;h=92009735a150a9cb9b697c8b7902a7fc1dd544ad;hp=ba4d56c81cab3206abf9c22e4d9dbce9d51fdbd6;hb=a4dd1eb45ae25ed017a862a4edac1e2828acbee6;hpb=c78089215285d52d483760699d07a96dfbbe0671 diff --git a/inc/modules/admin/what-refbanner.php b/inc/modules/admin/what-refbanner.php index ba4d56c81c..92009735a1 100644 --- a/inc/modules/admin/what-refbanner.php +++ b/inc/modules/admin/what-refbanner.php @@ -1,7 +1,7 @@ $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; - } - + break; + + case 'edit': // Update banner + foreach (postRequestParameter('sel') as $id => $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( + postRequestParameter('url', $id), + postRequestParameter('alternate', $id), + postRequestParameter('visible'), + $id + ), __FILE__, __LINE__); + } + break; + } // END - switch + + // Check if we have saved (updated) if (SQL_AFFECTEDROWS() == 1) { - $content = SETTINGS_SAVED; + // Updated! + $content = '{--SETTINGS_SAVED--}'; } else { - $content = "{--SETTINGS_NOT_SAVED--}"; + // Nothing has been updated + $content = '{--SETTINGS_NOT_SAVED--}'; } - LOAD_TEMPLATE("admin_settings_saved", false, $content); -} elseif (($SEL > 0) && (REQUEST_ISSET_POST('edit'))) { + + // Display message + loadTemplate('admin_settings_saved', false, $content); +} elseif ((ifPostContainsSelections()) && (isFormSent('edit'))) { // Edit banner - $SW = ""; $OUT = ""; - foreach (REQUEST_POST('sel') as $id => $sel) { + $OUT = ''; + foreach (postRequestParameter('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); + $result = SQL_QUERY_ESC("SELECT `id`, `url`, `alternate`, `visible` FROM `{?_MYSQL_PREFIX?}_refbanner` WHERE `id`=%s LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + $content = SQL_FETCHARRAY($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"), - ); + $content['visible'] = addSelectionBox('yn', $content['visible'], 'visible'); // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_refbanner_edit_row", true, $content); - $SW = 3 - $SW; - } - define('__BANNER_ROWS', $OUT); + $OUT .= loadTemplate('admin_edit_refbanner_row', true, $content); + } // END - foreach // Load main template - LOAD_TEMPLATE("admin_refbanner_edit"); + loadTemplate('admin_edit_refbanner', false, $OUT); } else { - if (($SEL > 0) && (REQUEST_ISSET_POST('del'))) - { + if ((ifPostContainsSelections()) && (isFormSent('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__); - } - } + foreach (postRequestParameter('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 // 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 - ); + $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 referal banner editable and deletable + $OUT = ''; + while ($content = SQL_FETCHARRAY($result)) { // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_refbanner_row", true, $content); - $SW = 3 - $SW; - } + $OUT .= loadTemplate('admin_list_refbanner_row', true, $content); + } // END - while // Free memory SQL_FREERESULT($result); - define('__BANNER_ROWS', $OUT); // Load main template - LOAD_TEMPLATE("admin_refbanner"); - } + loadTemplate('admin_list_refbanner', false, $OUT); + } // END - if // Form for adding new referal levels - LOAD_TEMPLATE("admin_add_banner"); + loadTemplate('admin_add_refbanner'); } -// +// [EOF] ?>