X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fsponsor_functions.php;h=bc7a15d08f85b598a5bc87c367608cfe6b57321c;hp=e40b25ad7f747ab19401de026475b5199fd42eb4;hb=116f17077ae6fa32c7373ccd6aaf94044bb6c276;hpb=fb7120ffa230b62b54895bcf95952e1cf30f8594 diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php index e40b25ad7f..bc7a15d08f 100644 --- a/inc/libs/sponsor_functions.php +++ b/inc/libs/sponsor_functions.php @@ -37,12 +37,12 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php"; + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); } // -function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_STATUS=false) { +function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $messageArray=array(), $RET_STATUS=false) { // Init a lot variables $SAVE = true; $UPDATE = false; @@ -67,14 +67,14 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S // Check only posted input entries not the submit button switch ($k) { - case "email": + case 'email': $ALREADY = false; - if (!VALIDATE_EMAIL($v)) { + if (!isEmailValid($v)) { // Email address is not valid $SAVE = false; } else { // Do we want to add a new sponsor or update his data? - $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_sponsor_data` WHERE email='%s' LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_sponsor_data` WHERE email='%s' LIMIT 1", array($POST['email']), __FUNCTION__, __LINE__); // Is a sponsor alread in the db? @@ -95,7 +95,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S break; case "pass1": - $k = ""; $v = ""; + $k = ''; $v = ''; break; case "pass2": @@ -103,12 +103,12 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S break; case "url": - if (!VALIDATE_URL($v)) $SAVE = false; + if (!isUrlValid($v)) $SAVE = false; break; default: // Test if there is are time selections - CONVERT_SELECTIONS_TO_TIMESTAMP($POST, $DATA, $k, $skip); + convertSelectionsToTimestamp($POST, $DATA, $k, $skip); break; } @@ -125,7 +125,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S if ((empty($POST['force'])) || (!IS_ADMIN())) $POST['force'] = 0; // SQL and message string is empty by default - $sql = ""; $MSG = ""; + $sql = ''; $message = ''; // Update? if ($UPDATE) { @@ -136,16 +136,16 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S } // Remove last ", " from SQL string - $sql = substr($sql, 0, -2)." WHERE id='%s' LIMIT 1"; + $sql = substr($sql, 0, -2)." WHERE `id`='%s' LIMIT 1"; $DATA['values'][] = bigintval(REQUEST_GET('id')); // Generate message - $MSG = SPONSOR_GET_MESSAGE(ADMIN_SPONSOR_UPDATED, "updated", $MSGs); + $message = SPONSOR_GET_MESSAGE(ADMIN_SPONSOR_UPDATED, "updated", $messageArray); $ret = "updated"; - } elseif ((!$ALREADY) || (($POST['force'] == "1") && (IS_ADMIN()))) { + } elseif ((!$ALREADY) || (($POST['force'] == '1') && (IS_ADMIN()))) { // Add new sponsor, first add more data $DATA['keys'][] = "sponsor_created"; $DATA['values'][] = time(); - $DATA['keys'][] = "status"; + $DATA['keys'][] = 'status'; if ((!$NO_UPDATE) && (IS_ADMIN()) && ($GLOBALS['what'] == "add_sponsor")) { // Only allowed for admin $DATA['values'][] = "PENDING"; @@ -155,24 +155,24 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S // Generate hash code $DATA['keys'][] = "hash"; - $DATA['values'][] = md5(session_id().":".$POST['email'].":".GET_REMOTE_ADDR().":".GET_USER_AGENT().":".time()); + $DATA['values'][] = md5(session_id().':'.$POST['email'].':'.detectRemoteAddr().':'.detectUserAgent().':'.time()); $DATA['keys'][] = "remote_addr"; - $DATA['values'][] = GET_REMOTE_ADDR(); + $DATA['values'][] = detectRemoteAddr(); } // Implode all data into strings $KEYS = implode(", " , $DATA['keys']); - $VALUES = str_repeat("%s', '", count($DATA['values']) - 1); + $valueS = str_repeat("%s', '", count($DATA['values']) - 1); // Generate string - $sql = "INSERT INTO `{!_MYSQL_PREFIX!}_sponsor_data` (".$KEYS.") VALUES ('".$VALUES."%s')"; + $sql = "INSERT INTO `{!_MYSQL_PREFIX!}_sponsor_data` (".$KEYS.") VALUES ('".$valueS."%s')"; // Generate message - $MSG = SPONSOR_GET_MESSAGE(getMessage('ADMIN_SPONSOR_ADDED'), "added", $MSGs); + $message = SPONSOR_GET_MESSAGE(getMessage('ADMIN_SPONSOR_ADDED'), "added", $messageArray); $ret = "added"; } elseif ((!$NO_UPDATE) && (IS_ADMIN())) { // Add all data as hidden data - $OUT = ""; + $OUT = ''; foreach ($POST as $k => $v) { // Do not add 'force' ! if ($k != "force") { @@ -187,7 +187,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S return; } else { // Already added! - $MSG = sprintf(getMessage('SPONSOR_ALREADY_FOUND', $POST['email'])); + $message = sprintf(getMessage('SPONSOR_ALREADY_FOUND', $POST['email'])); $ret = "already"; } @@ -198,19 +198,19 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S // Output message if ((!$NO_UPDATE) && (IS_ADMIN())) { - LOAD_TEMPLATE("admin_settings_saved", false, $MSG); + LOAD_TEMPLATE('admin_settings_saved', false, $message); } } else { // Error found! - $MSG = SPONSOR_GET_MESSAGE(getMessage('SPONSOR_DATA_NOT_SAVED'), "failed", $MSGs); - LOAD_TEMPLATE("admin_settings_saved", false, $MSG); + $message = SPONSOR_GET_MESSAGE(getMessage('SPONSOR_DATA_NOT_SAVED'), "failed", $messageArray); + LOAD_TEMPLATE('admin_settings_saved', false, $message); } // Shall we return the status? if ($RET_STATUS) return $ret; } // -function SPONSOR_TRANSLATE_STATUS ($status) { +function sponsorTranslateUserStatus ($status) { // Construct constant name $constantName = sprintf("ACCOUNT_%s", $status); @@ -228,7 +228,7 @@ function SPONSOR_TRANSLATE_STATUS ($status) { // Search for an email address in the database function SPONSOR_FOUND_EMAIL_DB ($email) { // Do we already have the provided email address in our DB? - $ret = (GET_TOTAL_DATA($email, "sponsor_data", "id", "email", true) == 1); + $ret = (GET_TOTAL_DATA($email, "sponsor_data", "id", 'email', true) == 1); // Return result return $ret; @@ -254,9 +254,9 @@ function IS_SPONSOR () { $ret = false; if ((isSessionVariableSet('sponsorid')) && (isSessionVariableSet('sponsorpass'))) { // Check cookies against database records... - $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_sponsor_data` -WHERE id='%s' AND password='%s' AND `status`='CONFIRMED' LIMIT 1", - array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FUNCTION__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_sponsor_data` +WHERE `id`='%s' AND password='%s' AND `status`='CONFIRMED' LIMIT 1", + array(bigintval(getSession('sponsorid')), getSession('sponsorpass')), __FUNCTION__, __LINE__); if (SQL_NUMROWS($result) == 1) { // All is fine $ret = true; @@ -272,13 +272,13 @@ WHERE id='%s' AND password='%s' AND `status`='CONFIRMED' LIMIT 1", // function GENERATE_SPONSOR_MENU($current) { - $OUT = ""; + $OUT = ''; $WHERE = " AND active='Y'"; - if (IS_ADMIN()) $WHERE = ""; + if (IS_ADMIN()) $WHERE = ''; // Load main menu entries $result_main = SQL_QUERY("SELECT action AS main_action, title AS main_title FROM `{!_MYSQL_PREFIX!}_sponsor_menu` -WHERE (what='' OR `what` IS NULL) ".$WHERE." +WHERE (`what`='' OR `what` IS NULL) ".$WHERE." ORDER BY `sort`", __FUNCTION__, __LINE__); if (SQL_NUMROWS($result_main) > 0) { // Load every menu and it's sub menus @@ -290,7 +290,7 @@ ORDER BY `sort`", array($content['main_action']), __FUNCTION__, __LINE__); if (SQL_NUMROWS($result_sub) > 0) { // Load sub menus - $SUB = ""; + $SUB = ''; while ($content2 = SQL_FETCHARRAY($result_sub)) { // Merge both arrays $content = merge_array($content, $content2); @@ -318,7 +318,7 @@ ORDER BY `sort`", $OUT .= LOAD_TEMPLATE("sponsor_action", true, $content); } else { // No sub menus active - $OUT .= LOAD_TEMPLATE("admin_settings_saved", true, getMessage('SPONSOR_NO_SUB_MENUS_ACTIVE')); + $OUT .= LOAD_TEMPLATE('admin_settings_saved', true, getMessage('SPONSOR_NO_SUB_MENUS_ACTIVE')); } // Free memory @@ -326,7 +326,7 @@ ORDER BY `sort`", } } else { // No main menus active - $OUT .= LOAD_TEMPLATE("admin_settings_saved", true, getMessage('SPONSOR_NO_MAIN_MENUS_ACTIVE')); + $OUT .= LOAD_TEMPLATE('admin_settings_saved', true, getMessage('SPONSOR_NO_MAIN_MENUS_ACTIVE')); } // Free memory @@ -338,14 +338,14 @@ ORDER BY `sort`", // function GENERATE_SPONSOR_CONTENT ($what) { - $OUT = ""; + $OUT = ''; $INC = sprintf("inc/modules/sponsor/%s.php", $what); - if (INCLUDE_READABLE($INC)) { + if (isIncludeReadable($INC)) { // Every sponsor action will output nothing directly. It will be written into $OUT! - LOAD_INC_ONCE($INC); + loadIncludeOnce($INC); } else { // File not found! - $OUT .= LOAD_TEMPLATE("admin_settings_saved", true, sprintf(getMessage('SPONSOR_CONTENT_404'), $what)); + $OUT .= LOAD_TEMPLATE('admin_settings_saved', true, sprintf(getMessage('SPONSOR_CONTENT_404'), $what)); } // Return content @@ -362,8 +362,8 @@ function UPDATE_SPONSOR_LOGIN () { // Update last online timestamp SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET last_online=UNIX_TIMESTAMP() -WHERE id='%s' AND password='%s' LIMIT 1", - array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FUNCTION__, __LINE__); +WHERE `id`='%s' AND password='%s' LIMIT 1", + array(bigintval(getSession('sponsorid')), getSession('sponsorpass')), __FUNCTION__, __LINE__); // This update went fine? $login = (SQL_AFFECTEDROWS() == 1); @@ -382,7 +382,7 @@ function SPONSOR_SAVE_DATA ($POST, $content) { 'ok', 'pass1', 'pass2'); // Set default message ("not saved") - $MSG = getMessage('SPONSOR_ACCOUNT_DATA_NOT_SAVED'); + $message = getMessage('SPONSOR_ACCOUNT_DATA_NOT_SAVED'); // Check for submitted passwords if ((!empty($POST['pass1'])) && (!empty($POST['pass2']))) { @@ -425,7 +425,7 @@ function SPONSOR_SAVE_DATA ($POST, $content) { $sql .= " `status`='EMAIL', hash='%s',"; // Generate hash code - $HASH = md5(session_id().":".$POST['email'].":".GET_REMOTE_ADDR().":".GET_USER_AGENT().":".time()); + $HASH = md5(session_id().':'.$POST['email'].':'.detectRemoteAddr().':'.detectUserAgent().':'.time()); $DATA[] = $HASH; } // END - if } // END - if @@ -434,20 +434,20 @@ function SPONSOR_SAVE_DATA ($POST, $content) { $sql = substr($sql, 0, -1); // Add SQL tail data - $sql .= " WHERE id='%s' AND password='%s' LIMIT 1"; - $DATA[] = bigintval(get_session('sponsorid')); - $DATA[] = get_session('sponsorpass'); + $sql .= " WHERE `id`='%s' AND password='%s' LIMIT 1"; + $DATA[] = bigintval(getSession('sponsorid')); + $DATA[] = getSession('sponsorpass'); // Saving data was completed... ufff... switch ($GLOBALS['what']) { case "account": // Change account data if ($EMAIL === true) { - $MSG = getMessage('SPONSOR_ACCOUNT_EMAIL_CHANGED'); + $message = getMessage('SPONSOR_ACCOUNT_EMAIL_CHANGED'); $templ = "admin_sponsor_change_email"; $subj = getMessage('ADMIN_SPONSOR_ACC_EMAIL_SUBJ'); } else { - $MSG = getMessage('SPONSOR_ACCOUNT_DATA_SAVED'); + $message = getMessage('SPONSOR_ACCOUNT_DATA_SAVED'); $templ = "admin_sponsor_change_data"; $subj = getMessage('ADMIN_SPONSOR_ACC_DATA_SUBJ'); } @@ -455,19 +455,19 @@ function SPONSOR_SAVE_DATA ($POST, $content) { case "settings": // Change settings // Translate some data - $content['receive'] = TRANSLATE_YESNO($content['receive_warnings']); - $content['interval'] = CREATE_FANCY_TIME($content['warning_interval']); + $content['receive'] = translateYesNo($content['receive_warnings']); + $content['interval'] = createFancyTime($content['warning_interval']); // Set message template and subject for admin - $MSG = getMessage('SPONSOR_SETTINGS_SAVED'); + $message = getMessage('SPONSOR_SETTINGS_SAVED'); $templ = "admin_sponsor_settings"; $subj = getMessage('ADMIN_SPONSOR_SETTINGS_SUBJ'); break; default: // Unknown sponsor what value! DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Unknown sponsor module (what) %s detected.", $GLOBALS['what'])); - $MSG = sprintf(getMessage('SPONSOR_UNKNOWN_WHAT'), $GLOBALS['what']); - $templ = ""; $subj = ""; + $message = sprintf(getMessage('SPONSOR_UNKNOWN_WHAT'), $GLOBALS['what']); + $templ = ''; $subj = ''; break; } @@ -481,16 +481,16 @@ function SPONSOR_SAVE_DATA ($POST, $content) { $DATA = $POST; // Change some data - if (isset($content['gender'])) $content['gender'] = TRANSLATE_GENDER($content['gender']); - if (isset($DATA['gender'])) $DATA['gender'] = TRANSLATE_GENDER($DATA['gender']); - if (isset($content['receive_warnings'])) $DATA['receive'] = TRANSLATE_YESNO($POST['receive_warnings']); - if (isset($content['warning_interval'])) $DATA['interval'] = CREATE_FANCY_TIME($POST['warning_interval']); + if (isset($content['gender'])) $content['gender'] = translateGender($content['gender']); + if (isset($DATA['gender'])) $DATA['gender'] = translateGender($DATA['gender']); + if (isset($content['receive_warnings'])) $DATA['receive'] = translateYesNo($POST['receive_warnings']); + if (isset($content['warning_interval'])) $DATA['interval'] = createFancyTime($POST['warning_interval']); // Send email to admins - SEND_ADMIN_NOTIFICATION($subj, $templ, $content); + sendAdminNotification($subj, $templ, $content); // Shall we send mail to the sponsor's new email address? - if ($content['receive_warnings'] == "Y") { + if ($content['receive_warnings'] == 'Y') { // Okay send email with confirmation link to new address and with no confirmation link // to the old address @@ -499,7 +499,7 @@ function SPONSOR_SAVE_DATA ($POST, $content) { { case "account": // Change account data $email_msg = LOAD_EMAIL_TEMPLATE("sponsor_change_data", $content); - SEND_EMAIL($content['email'], getMessage('SPONSOR_ACC_DATA_SUBJ'), $email_msg); + sendEmail($content['email'], getMessage('SPONSOR_ACC_DATA_SUBJ'), $email_msg); if ($EMAIL === true) { // Add hash code to content array @@ -507,14 +507,14 @@ function SPONSOR_SAVE_DATA ($POST, $content) { // Second mail goes to the new address $email_msg = LOAD_EMAIL_TEMPLATE("sponsor_change_email", $content); - SEND_EMAIL($content['email'], getMessage('SPONSOR_ACC_EMAIL_SUBJ'), $email_msg); + sendEmail($content['email'], getMessage('SPONSOR_ACC_EMAIL_SUBJ'), $email_msg); } break; case "settings": // Change settings // Send email $email_msg = LOAD_EMAIL_TEMPLATE("sponsor_settings", $content); - SEND_EMAIL($content['email'], getMessage('SPONSOR_SETTINGS_SUBJ'), $email_msg); + sendEmail($content['email'], getMessage('SPONSOR_SETTINGS_SUBJ'), $email_msg); break; } } // END - if @@ -522,7 +522,7 @@ function SPONSOR_SAVE_DATA ($POST, $content) { } // END - if // Return final message - return $MSG; + return $message; } //