$DATA['values'][] = bigintval(REQUEST_GET('id'));
// Generate message
- $message = SPONSOR_GET_MESSAGE(ADMIN_SPONSOR_UPDATED, "updated", $messageArray);
+ $message = SPONSOR_GET_MESSAGE(getMessage('ADMIN_SPONSOR_UPDATED'), 'updated', $messageArray);
$ret = "updated";
} elseif ((!$ALREADY) || (($POST['force'] == '1') && (IS_ADMIN()))) {
// Add new sponsor, first add more data
- $DATA['keys'][] = "sponsor_created"; $DATA['values'][] = time();
+ $DATA['keys'][] = 'sponsor_created'; $DATA['values'][] = time();
$DATA['keys'][] = 'status';
- if ((!$NO_UPDATE) && (IS_ADMIN()) && (getWhat() == "add_sponsor")) {
+ if ((!$NO_UPDATE) && (IS_ADMIN()) && (getWhat() == 'add_sponsor')) {
// Only allowed for admin
$DATA['values'][] = 'PENDING';
} else {
$DATA['values'][] = 'UNCONFIRMED';
// Generate hash code
- $DATA['keys'][] = "hash";
+ $DATA['keys'][] = 'hash';
$DATA['values'][] = md5(session_id().':'.$POST['email'].':'.detectRemoteAddr().':'.detectUserAgent().':'.time());
- $DATA['keys'][] = "remote_addr";
+ $DATA['keys'][] = 'remote_addr';
$DATA['values'][] = detectRemoteAddr();
}
// Implode all data into strings
- $KEYS = implode(", " , $DATA['keys']);
+ $KEYS = implode("`, `" , $DATA['keys']);
$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
$message = SPONSOR_GET_MESSAGE(getMessage('ADMIN_SPONSOR_ADDED'), "added", $messageArray);
- $ret = "added";
+ $ret = 'added';
} elseif ((!$NO_UPDATE) && (IS_ADMIN())) {
// Add all data as hidden data
$OUT = '';
define('__EMAIL' , $POST['email']);
// Ask for adding a sponsor with same email address
- LOAD_TEMPLATE("admin_add_sponsor_already");
+ LOAD_TEMPLATE('admin_add_sponsor_already');
return;
} else {
// Already added!