- public function getEntriesByView($view, $user_id, $limit = '') {
- switch ($_SESSION['sort'])
- {
- case 'ia':
- $order = 'ORDER BY id';
- break;
- case 'id':
- $order = 'ORDER BY id DESC';
+ public function retrieveOneByURL($url, $user_id) {
+ $entry = NULL;
+ $sql = "SELECT * FROM entries WHERE url=? AND user_id=?";
+ $params = array($url, $user_id);
+ $query = $this->executeQuery($sql, $params);
+ $entry = $query->fetchAll();
+
+ return isset($entry[0]) ? $entry[0] : null;
+ }
+
+ public function reassignTags($old_entry_id, $new_entry_id) {
+ $sql = "UPDATE tags_entries SET entry_id=? WHERE entry_id=?";
+ $params = array($new_entry_id, $old_entry_id);
+ $query = $this->executeQuery($sql, $params);
+ }
+
+ public function getEntriesByView($view, $user_id, $limit = '', $tag_id = 0) {
+ switch ($view) {
+ case 'archive':
+ $sql = "SELECT * FROM entries WHERE user_id=? AND is_read=? ";
+ $params = array($user_id, 1);