X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fadmin%2Fwhat-refbanner.php;h=21b8a84e9c6f8ec494b3d78494156783cd662ff5;hb=ccc4a69ce9b17aa8d7b1554a3b2b017db091821b;hp=857b516d6e2759e3dcfb5453133688a21705c9aa;hpb=81bfbcd72e424060ea1223b49ad92fcfa150f361;p=mailer.git diff --git a/inc/modules/admin/what-refbanner.php b/inc/modules/admin/what-refbanner.php index 857b516d6e..21b8a84e9c 100644 --- a/inc/modules/admin/what-refbanner.php +++ b/inc/modules/admin/what-refbanner.php @@ -49,49 +49,49 @@ ADD_DESCR('admin', __FILE__); $SEL = 0; // Some sanity-check -if ((!REQUEST_ISSET_POST(('url'))) || (!REQUEST_ISSET_POST(('alternate')))) { +if ((!REQUEST_ISSET_POST('url')) || (!REQUEST_ISSET_POST(('alternate')))) { REQUEST_UNSET_POST('ok'); } // Check selection count if (REQUEST_ISSET_POST('sel')) $SEL = countPostSelection(); -if (IS_FORM_SENT()) { +if (isFormSent()) { // Fix older calls from add-new-banner-form if (!REQUEST_ISSET_GET(('mode'))) REQUEST_SET_GET('mode', 'add'); $sql = ''; switch (REQUEST_GET('mode')) { - case 'add': - // Check if banner is already added - $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE url='%s' LIMIT 1", + case 'add': + // Check if banner is already added + $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE url='%s' LIMIT 1", array(REQUEST_POST('url')), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 0) { - // Add banner - SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_refbanner` (url, alternate, visible) + if (SQL_NUMROWS($result) == 0) { + // Add banner + SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_refbanner` (url, alternate, visible) VALUES ('%s','%s','%s')", array(REQUEST_POST('url'), REQUEST_POST('alternate'), REQUEST_POST('visible')), __FILE__, __LINE__); - } else { - // Free memory - SQL_FREERESULT($result); - } - break; - - case 'edit': // Update banner - foreach (REQUEST_POST('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", + } else { + // Free memory + SQL_FREERESULT($result); + } + break; + + case 'edit': // Update banner + foreach (REQUEST_POST('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( - REQUEST_POST('url', $id), - REQUEST_POST('alternate', $id), - REQUEST_POST('visible'), - $id + REQUEST_POST('url', $id), + REQUEST_POST('alternate', $id), + REQUEST_POST('visible'), + $id ), __FILE__, __LINE__); - } - break; + } + break; } if (SQL_AFFECTEDROWS() == 1) { @@ -106,7 +106,7 @@ VALUES ('%s','%s','%s')", 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__); + array(bigintval($id)), __FILE__, __LINE__); list($url, $alt, $vis) = SQL_FETCHROW($result); SQL_FREERESULT($result); @@ -134,13 +134,13 @@ VALUES ('%s','%s','%s')", // 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__); + 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__); + __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { // Make referal banner editable and deletable $OUT = ''; $SW = 2;