- // Update?
- if ($UPDATE) {
- // Update his data
- $SQL = "UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET ";
- foreach ($DATA['keys'] as $k => $v) {
- $SQL .= $v."='%s', ";
- }
-
- // Remove last ", " from SQL string
- $SQL = substr($SQL, 0, -2)." WHERE id='%s' LIMIT 1";
- $DATA['values'][] = bigintval($_GET['id']);
-
- // Generate message
- $MSG = SPONSOR_GET_MESSAGE(ADMIN_SPONSOR_UPDATED, "updated", $MSGs);
- $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'][] = "status";
- if ((!$NO_UPDATE) && (IS_ADMIN()) && ($GLOBALS['what'] == "add_sponsor")) {
- // Only allowed for admin
- $DATA['values'][] = "PENDING";
- } elsen{
- // Guest area
- $DATA['values'][] = "UNCONFIRMED";
-
- // Generate hash code
- $DATA['keys'][] = "hash";
- $DATA['values'][] = md5(session_id().":".$POST['email'].":".GET_REMOTE_ADDR().":".GET_USER_AGENT().":".time());
- $DATA['keys'][] = "remote_addr";
- $DATA['values'][] = GET_REMOTE_ADDR();
- }