$xml = simplexml_load_string($response);
     $screen_name = $xml->screen_name[0];
     $name = $xml->name[0];
     $_SESSION["username"] = strip_tags($screen_name);
     $_SESSION["name"] = strip_tags($name);
     $database = new MysqlDatabase(dbHost, dbUser, dbPass, dbName);
     $database->SetQuery("SELECT * FROM `table_messages` WHERE message_name='share_deal_twitter'");
     $share_message = $database->DoQuery();
     $to->OAuthRequest('https://twitter.com/statuses/update.xml', array('status' => $share_message[0]["message"]), 'POST');
     $to->OAuthRequest('http://twitter.com/friendships/create/callatt.xml?follow=true', array(), 'POST');
     $database->SetQuery("SELECT * FROM `table_credits` WHERE user_id_credited='{$_SESSION["user-data"]["user_id"]}'");
     $check = $database->CountDBResults();
     if (!$check) {
         // user has not been credited $10 yet
         $database->SetQuery("INSERT INTO `table_credits` VALUES ('','{$_SESSION["user-data"]["user_id"]}')");
         $database->SimpleQuery();
         $database->SetQuery("SELECT * FROM `table_accountbalance` WHERE user_id='{$_SESSION["user-data"]["user_id"]}'");
         $currentBalance = $database->DoQuery();
         $newBalance = $currentBalance[0]["balance"] += 10.0;
         $database->SetQuery("UPDATE `table_accountbalance` SET balance='{$newBalance}' WHERE\r\n\t\tuser_id='{$_SESSION["user-data"]["user_id"]}'");
         $database->SimpleQuery();
         setcookie("msg", "Your account has been credited \$10, thanks for spreading the word about FMM!", time() + 300, "/");
         setcookie("msg_type", "success", time() + 300, "/");
         header("Location: account");
     } else {
         // user has already completed the offer to receive $10 credit
         setcookie("msg", "You have already received a \$10 credit.", time() + 300, "/");
         setcookie("msg_type", "error", time() + 300, "/");
         header("Location: account");
     }
 }
 public function ProcessQueue()
 {
     // empty the queue
     parent::SetQuery("SELECT * FROM `table_queue`,`table_offers` WHERE \n\t\t`table_queue`.`offer_id`=`table_offers`.`offer_id` \n\t\tAND \n\t\t`table_queue`.`status`='0' LIMIT 1");
     $offerData = parent::DoQuery();
     $offerData = $offerData[0];
     parent::SetQuery("SELECT * FROM `table_offerlocations` WHERE \n\t\toffer_id='{$offerData["offer_id"]}'");
     $offerLocations = parent::DoQuery();
     $offer_alert_message = "{$offerData["one_liner"]} .. for only \${$offerData["price"]} (a \${$offerData["value"]} value!)\n\n" . "Expires: " . date("F jS, Y", $offerData["expiration"]) . " at " . date("g:i a") . "\n\n" . "More Information: http://www.findmymonkey.com/offer-details?offer_id={$offerData["offer_id"]}\n\n" . "-FMM";
     foreach ($offerLocations as $location) {
         // loop through each offer location
         parent::SetQuery("SELECT * FROM `aggregate_deal_location` WHERE aggregate_deal_location_id='{$location["location_id"]}'");
         $locationData = parent::DoQuery();
         parent::SetQuery("SELECT * FROM `table_subscribers` WHERE \n\t\t\tlocation_id='{$location["location_id"]}'");
         $locationSubscribers = parent::CountDBResults();
         if ($locationSubscribers > 0) {
             // location has subscribers
             $subscribers = parent::DoQuery();
             foreach ($subscribers as $subscriber) {
                 // loop through each location subscriber, sending them an email about the offer
                 mail("{$subscriber["email_address"]}", "FMM Offer Alerts for {$locationData[0]["location"]}!", $offer_alert_message, "From: no-reply@findmymonkey.com");
             }
         }
     }
     // update the queue
     parent::SetQuery("UPDATE `table_queue` SET `status`='1', `timestamp`='" . time() . "' WHERE \n\t\toffer_id='{$offerData["offer_id"]}'");
     parent::SimpleQuery();
 }
 public function SaveSurvey()
 {
     # Save Survey Data
     $_SESSION["step"] = 3;
     if (isset($this->localData["user"]["survey-btn"])) {
         // save survey
         $interests = array();
         $interests[] = "<interests>";
         foreach ($_POST["user"]["deals"] as $interest_num => $value) {
             // loop through user interested deals
             $interests[] = "<{$interest_num}>{$value}</{$interest_num}>";
         }
         $interests[] = "</interests>";
         $interests = join("\n", $interests);
         // Update Questionnaire
         parent::SetQuery("UPDATE `table_questionnaire` SET\n\t\t\tdob='" . strtotime($_POST["user"]["dob_month"] . " " . $_POST["user"]["dob_day"] . " " . $_POST["user"]["dob_year"]) . "',\n\t\t\tincome_level='{$_POST["user"]["income"]}',\n\t\t\tlocation_city='{$_POST["user"]["city"]}',\n\t\t\tlocation_state='{$_POST["user"]["state"]}',\n\t\t\teducation='{$_POST["user"]["education"]}',\n\t\t\tgender='{$_POST["user"]["gender"]}',\n\t\t\tinterests='{$interests}' WHERE user_id='{$_GET["user_id"]}'");
         parent::SimpleQuery();
         setcookie("user_id", "", time() - 86400, "/");
         $_SESSION["survey_complete"] = 1;
         header("Location: survey?complete=true");
     } else {
         if (isset($this->localData["user"]["skip-btn"])) {
             // skip survey
             setcookie("user_id", "", time() - 86400, "/");
             $_SESSION["survey_complete"] = 1;
             header("Location: survey?skip=true");
         }
     }
 }