-<?PHP
-session_start();
-// this will overlay our current system
-function presign(){
- global $petition;
- $id = session_id();
- $page = $petition->real_escape_string($_SERVER['REQUEST_URI']);
- $email = $petition->real_escape_string($_COOKIE['email']);
- $name = $petition->real_escape_string($_COOKIE['pNAME']);
- $phone = $petition->real_escape_string($_COOKIE['pPHONE']);
- if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
- $ip = $_SERVER['HTTP_CLIENT_IP'];
- } elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
- $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
- } else {
- $ip = $_SERVER['REMOTE_ADDR'];
- }
- $ip = $petition->real_escape_string($ip);
- $browser_string = $petition->real_escape_string($_SERVER['HTTP_USER_AGENT']);
- $petition->query("insert into presign (php_session_id,php_page,name,email_for_follow_up,phone_for_validation,ip_address,browser_string)
- values ('$id','$page','$name','$email','$phone','$ip','$browser_string') ");
-}
-?>
+<?PHP
+session_start();
+// this will overlay our current system
+function presign(){
+ global $petition;
+ $id = session_id();
+ $page = $petition->real_escape_string($_SERVER['REQUEST_URI']);
+ $email = $petition->real_escape_string($_COOKIE['email']);
+ $name = $petition->real_escape_string($_COOKIE['pNAME']);
+ $phone = $petition->real_escape_string($_COOKIE['pPHONE']);
+ if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
+ $ip = $_SERVER['HTTP_CLIENT_IP'];
+ } elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
+ $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
+ } else {
+ $ip = $_SERVER['REMOTE_ADDR'];
+ }
+ $petition_name = $petition->real_escape_string($_COOKIE['pID']);
+ $invite = $petition->real_escape_string($_COOKIE['invite']);
+ $invite_error = $petition->real_escape_string($_COOKIE['invite_error']);
+ $ip = $petition->real_escape_string($ip);
+ $browser_string = $petition->real_escape_string($_SERVER['HTTP_USER_AGENT']);
+ $now = $petition->real_escape_string(date('r'));
+ $only_date = $petition->real_escape_string(date('Y-m-d'));
+ $petition->query("insert into presign (only_date,invite_error,invite,petition,php_session_id,php_page,name,email_for_follow_up,phone_for_validation,ip_address,browser_string,action_on)
+ values ('$only_date','$invite_error','$invite','$petition_name','$id','$page','$name','$email','$phone','$ip','$browser_string','$now') ");
+}
+?>