'; } } if (empty($error)) { $used_by = mysql_znote_escape_string($user_data['name']); // ipv6 fixes if (getIP() == "::1") { $ip = ip2long("127.0.0.1"); } else { $ip = ip2long(getIP()); } $time = time(); $code = $res['code']; $points = $res['points']; $accid = $user_data['id']; $query = "UPDATE `__cornex_redeem` SET `used_by` = '$used_by' , `time` = $time , `ip` = $ip WHERE `code` = '$code'"; $query2 = "UPDATE `znote_accounts` SET `points` = `points` + $points WHERE `account_id` = $accid LIMIT 1;"; mysql_update($query); mysql_update($query2); echo $points.' points has been added to your account!'; } } else { echo 'Key is not valid'; } } ?>