$DATA['values'][] = bigintval(getRequestParameter('id'));
// Generate message
- $message = getMessageFromIndexedArray(getMessage('ADMIN_SPONSOR_UPDATED'), 'updated', $messageArray);
- $ret = "updated";
+ $message = getMessageFromIndexedArray('{--ADMIN_SPONSOR_UPDATED--}', 'updated', $messageArray);
+ $ret = 'updated';
} elseif (($ALREADY === false) || (($postData['force'] == 1) && (isAdmin()))) {
// Add new sponsor, first add more data
$DATA['keys'][] = 'sponsor_created'; $DATA['values'][] = time();
}
// Implode all data into strings
- $keyArray = implode("`, `" , $DATA['keys']);
+ $keyArray = implode('`, `' , $DATA['keys']);
$valueArray = str_repeat("%s', '", count($DATA['values']) - 1);
// Generate string
- $sql = "INSERT INTO `{?_MYSQL_PREFIX?}_sponsor_data` (`" . $keyArray . "`) VALUES ('" . $valueArray . "%s')";
+ $sql = 'INSERT INTO `{?_MYSQL_PREFIX?}_sponsor_data` (`' . $keyArray . "`) VALUES ('" . $valueArray . "%s')";
// Generate message
- $message = getMessageFromIndexedArray(getMessage('ADMIN_SPONSOR_ADDED'), 'added', $messageArray);
+ $message = getMessageFromIndexedArray('{--ADMIN_SPONSOR_ADDED--}', 'added', $messageArray);
$ret = 'added';
} elseif (($update === true) && (isAdmin())) {
// Add all data as hidden data
} // END - if
} else {
// Error found!
- $message = getMessageFromIndexedArray(getMessage('SPONSOR_DATA_NOT_SAVED'), 'failed', $messageArray);
+ $message = getMessageFromIndexedArray('{--SPONSOR_DATA_NOT_SAVED--}', 'failed', $messageArray);
loadTemplate('admin_settings_saved', false, $message);
}
//
function addSponsorMenu ($current) {
$OUT = '';
- $WHERE = " AND active='Y'";
+ $WHERE = " AND `active`='Y'";
if (isAdmin()) $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."
-ORDER BY `sort`", __FUNCTION__, __LINE__);
- if (SQL_NUMROWS($result_main) > 0) {
+ $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 . "
+ORDER BY
+ `sort` ASC", __FUNCTION__, __LINE__);
+ if (!SQL_HASZERONUMS($result_main)) {
// Load every menu and it's sub menus
while ($content = SQL_FETCHARRAY($result_main)) {
// Load sub menus
- $result_sub = SQL_QUERY_ESC("SELECT what AS sub_what, title AS sub_title FROM `{?_MYSQL_PREFIX?}_sponsor_menu`
-WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ".$WHERE."
-ORDER BY `sort`",
+ $result_sub = SQL_QUERY_ESC("SELECT
+ `what` AS `sub_what`, `title` AS `sub_title`
+FROM
+ `{?_MYSQL_PREFIX?}_sponsor_menu`
+WHERE
+ `action`='%s' AND
+ `what` != '' AND
+ `what` IS NOT NULL
+ " . $WHERE . "
+ORDER BY
+ `sort` ASC",
array($content['main_action']), __FUNCTION__, __LINE__);
- if (SQL_NUMROWS($result_sub) > 0) {
+ if (!SQL_HASZERONUMS($result_sub)) {
// Load sub menus
$SUB = '';
while ($content2 = SQL_FETCHARRAY($result_sub)) {
$OUT .= loadTemplate('sponsor_action', true, $content);
} else {
// No sub menus active
- $OUT .= loadTemplate('admin_settings_saved', true, getMessage('SPONSOR_NO_SUB_MENUS_ACTIVE'));
+ $OUT .= loadTemplate('admin_settings_saved', true, '{--SPONSOR_NO_SUB_MENUS_ACTIVE--}');
}
// Free memory
}
} else {
// No main menus active
- $OUT .= loadTemplate('admin_settings_saved', true, getMessage('SPONSOR_NO_MAIN_MENUS_ACTIVE'));
+ $OUT .= loadTemplate('admin_settings_saved', true, '{--SPONSOR_NO_MAIN_MENUS_ACTIVE--}');
}
// Free memory
'ok', 'pass1', 'pass2');
// Set default message ("not saved")
- $message = getMessage('SPONSOR_ACCOUNT_DATA_NOT_SAVED');
+ $message = '{--SPONSOR_ACCOUNT_DATA_NOT_SAVED--}';
// Check for submitted passwords
if ((!empty($postData['pass1'])) && (!empty($postData['pass2']))) {
$sql = "UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET";
foreach ($postData as $key => $value) {
// Mmmmm, too less security here???
- $sql .= " `".secureString($key)."`='%s',";
+ $sql .= " `" . secureString($key) . "`='%s',";
// We will secure this later inside the SQL_QUERY_ESC() function
$DATA[] = secureString($value);
$sql = substr($sql, 0, -1);
// Add SQL tail data
- $sql .= " WHERE `id`=%s AND password='%s' LIMIT 1";
+ $sql .= " WHERE `id`=%s AND `password`='%s' LIMIT 1";
$DATA[] = bigintval(getSession('sponsorid'));
$DATA[] = getSession('sponsorpass');
switch (getWhat()) {
case 'account': // Change account data
if ($EMAIL === true) {
- $message = getMessage('SPONSOR_ACCOUNT_EMAIL_CHANGED');
- $templ = 'admin_sponsor_change_email';
- $subj = getMessage('ADMIN_SPONSOR_ACC_EMAIL_SUBJ');
+ $message = '{--SPONSOR_ACCOUNT_EMAIL_CHANGED--}';
+ $templ = 'admin_sponsor_change_email';
+ $subj = '{--ADMIN_SPONSOR_ACC_EMAIL_SUBJECT--}';
} else {
- $message = getMessage('SPONSOR_ACCOUNT_DATA_SAVED');
- $templ = 'admin_sponsor_change_data';
- $subj = getMessage('ADMIN_SPONSOR_ACC_DATA_SUBJ');
+ $message = '{--SPONSOR_ACCOUNT_DATA_SAVED--}';
+ $templ = 'admin_sponsor_change_data';
+ $subj = '{--ADMIN_SPONSOR_ACC_DATA_SUBJECT--}';
}
break;
case 'settings': // Change settings
- // Translate some data
- $content['receive'] = translateYesNo($content['receive_warnings']);
- $content['interval'] = createFancyTime($content['warning_interval']);
-
// Set message template and subject for admin
- $message = getMessage('SPONSOR_SETTINGS_SAVED');
- $templ = 'admin_sponsor_settings';
- $subj = getMessage('ADMIN_SPONSOR_SETTINGS_SUBJ');
+ $message = '{--SPONSOR_SETTINGS_SAVED--}';
+ $templ = 'admin_sponsor_settings';
+ $subj = '{--ADMIN_SPONSOR_SETTINGS_SUBJECT--}';
break;
default: // Unknown sponsor what value!
logDebugMessage(__FUNCTION__, __LINE__, sprintf("Unknown sponsor module (what) %s detected.", getWhat()));
$message = getMaskedMessage('SPONSOR_UNKNOWN_WHAT', getWhat());
- $templ = ''; $subj = '';
+ $templ = '';
+ $subj = '';
break;
} // END - switch
// Add all data to content
$content['new_data'] = $postData;
- // Translate some data
- if (isset($content['gender'])) $content['gender'] = translateGender($content['gender']);
- if (isset($content['new_data']['gender'])) $content['new_data']['gender'] = translateGender($content['new_data']['gender']);
- if (isset($content['receive_warnings'])) $content['new_data']['receive'] = translateYesNo($content['new_data']['receive_warnings']);
- if (isset($content['warning_interval'])) $content['new_data']['interval'] = createFancyTime($content['new_data']['warning_interval']);
-
// Send email to admins
sendAdminNotification($subj, $templ, $content);
switch (getWhat()) {
case 'account': // Change account data
$email_msg = loadEmailTemplate('sponsor_change_data', $content);
- sendEmail($content['email'], getMessage('SPONSOR_ACC_DATA_SUBJ'), $email_msg);
+ sendEmail($content['email'], '{--SPONSOR_ACC_DATA_SUBJECT--}', $email_msg);
if ($EMAIL === true) {
// Add hash code to content array
// Second mail goes to the new address
$email_msg = loadEmailTemplate('sponsor_change_email', $content);
- sendEmail($content['email'], getMessage('SPONSOR_ACC_EMAIL_SUBJ'), $email_msg);
+ sendEmail($content['email'], '{--SPONSOR_ACC_EMAIL_SUBJECT--}', $email_msg);
} // END - if
break;
case 'settings': // Change settings
// Send email
$email_msg = loadEmailTemplate('sponsor_settings', $content);
- sendEmail($content['email'], getMessage('SPONSOR_SETTINGS_SUBJ'), $email_msg);
+ sendEmail($content['email'], '{--SPONSOR_SETTINGS_SUBJECT--}', $email_msg);
break;
} // END - switch
} // END - if
projects / mailer.git / blobdiff