public function markRead($notificationObj)
{
$userId = parent::getUserId();
if ($userId == false) {
return "Invalid User";
}
$sth = $this->db->prepare("UPDATE Notifications SET NotificationRead = 1 WHERE NotificationId = :notificationId AND UserId = :userId LIMIT 1");
$sth->execute(array(":notificationId" => $notificationObj["id"], ":userId" => $userId));
// ASSume success
$response = $this->defaultResponseObj;
$response["Success"] = true;
$response["DB_Error"] = $sth->errorInfo();
return $response;
}
public function disconnect($deleteObj)
{
$response = $this->defaultResponseObj;
$userId = parent::getUserId();
if ($userId == false) {
return "Invalid User";
}
$contextio = new ContextIO(CONTEXTIO_KEY, CONTEXTIO_SECRET);
$apiResponse = $contextio->deleteUser($deleteObj["contextio_id"]);
if ($apiResponse == false) {
// Failed to delete the account
$response["Message"] = "Account not found. Contact us for additional assistance.";
} else {
$rawResponse = $apiResponse->getRawResponse();
$rawResponse = json_encode($rawResponse, true);
if (property_exists($rawResponse, "error") && $rawResponse["error"] != "") {
// Failed to delete the account
$response["Message"] = "Unable to unlink account at this time. Try again later or contact us for additional assistance.";
$response["ApiResponse"] = $apiResponse->getRawResponse();
} else {
// Deleted account, delete reference from our database
$sth = $this->db->prepare("DELETE FROM EmailAccounts WHERE Contextio_Id = :id LIMIT 1");
$sth->execute(array(":id" => $deleteObj["contextio_id"]));
$response["Success"] = true;
$response["Message"] = "Account has been successfully unlinked.";
}
}
return $response;
}
public function vote($voteObj)
{
$userId = parent::getUserId();
if ($userId == false) {
return "Invalid AuthToken";
}
// Get the current vote
$sth = $this->db->prepare("SELECT * FROM Votes WHERE UserId = :userId AND ShareId = :shareId LIMIT 1");
$success = $sth->execute(array(":userId" => $userId, ":shareId" => $voteObj["shareId"]));
$result = $sth->fetch();
if ($success && $result != false) {
$up = 0;
$down = 0;
if ($voteObj["voteType"] == "down") {
// Change to a down vote
$down = 1;
} else {
if ($voteObj["voteType"] == "up") {
$up = 1;
}
}
$sthUpdateVote = $this->db->prepare("UPDATE Votes SET UpVote = :up, DownVote = :down WHERE UserId = :userId AND ShareId = :shareId LIMIT 1");
$sthUpdateVote->execute(array(":up" => $up, ":down" => $down, ":userId" => $userId, "shareId" => $voteObj["shareId"]));
//print_r($sthUpdateVote->errorInfo());
} else {
$up = 0;
$down = 0;
// Submit a new vote
if ($voteObj["voteType"] == "up") {
$up = 1;
} else {
if ($voteObj["voteType"] == "down") {
$down = 1;
}
}
$sthNewVote = $this->db->prepare("INSERT INTO Votes (VoteId, UserId, ShareId, UpVote, DownVote, Flag)\n\t\t\t\t\t\t\t\tVALUES ('', :userId, :shareId, :up, :down, 0)");
$sthNewVote->execute(array(":userId" => $userId, ":shareId" => $voteObj["shareId"], ":up" => $up, ":down" => $down));
}
// Update the rank after every vote
$this->_calculateRank($voteObj["shareId"]);
// Record the action
$notifications = new Notifications();
$notifications->recordAction($userId, $voteObj["voteType"], $voteObj["shareId"]);
$response = $this->defaultResponseObj;
$response["Success"] = true;
$response["Message"] = "Vote recorded";
return $response;
}
public static function adminId()
{
return Model::getUserId();
}
<?php
require_once "app/configs/Global_Config.php";
$mysqli = new Mysql_Connection();
$model = new Model($mysqli->getConn());
$view = new View($model);
$user = "******";
$userid = "NOT YET SET";
$chainname = "NOT SET";
$troveid = "NOT SET";
$keywords = "NOT SET";
$notes = "NOT SET";
if (isset($_POST['AddUser'])) {
$user = $_POST['AddUser'];
$userid = $model->getUserId($user);
}
if (isset($_POST['AddChain'])) {
$chainname = $_POST['AddChain'];
}
if (isset($_POST['AddSource'])) {
$troveid = $_POST['AddSource'];
}
if (isset($_POST['AddKeywords'])) {
$keywords = trim($_POST['AddKeywords']);
}
if (isset($_POST['AddNotes'])) {
$notes = trim($_POST['AddNotes']);
}
if ($model->addSourceToChain($userid, $chainname, $keywords, $notes, $troveid) === TRUE) {
$res = $view->showChain($model->getChainSources($_POST['AddChain']));
echo $res;
function userId(Model $model, $field, $value)
{
$user_id_data = $model->getUserId($field, $value);
return $user_id_data['user_id'];
}
