$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");
}
}
}
