/** * Remove all resources and tags and delete a list. * * @return bool True on success, false on error. * @access public */ public function emptyList() { // Remove Resources $sql = 'DELETE FROM "user_resource" ' . "WHERE \"user_id\" = '" . $this->escape($this->user_id) . "' " . "AND \"list_id\" = '" . $this->escape($this->id) . "'"; $removeResource = new User_resource(); $removeResource->query($sql); // Remove Resource Tags $sql = 'DELETE FROM "resource_tags" ' . "WHERE \"user_id\" = '" . $this->escape($this->user_id) . "' " . "AND \"list_id\" = '" . $this->escape($this->id) . "'"; $removeTags = new Resource_tags(); $removeTags->query($sql); // Remove the List $this->delete(); // If we got this far, there were no fatal DB errors so report success return true; }
/** * Get information saved in a user's favorites for a particular record. * * @param string $resourceId ID of record being checked. * @param int $listId Optional list ID (to limit results to a particular * list). * * @return array * @access public */ public function getSavedData($resourceId, $listId = null) { $savedList = array(); $sql = 'SELECT "user_resource".*, "user_list"."title" as list_title, ' . '"user_list"."id" as list_id ' . 'FROM "user_resource", "resource", "user_list" ' . 'WHERE "resource"."id" = "user_resource"."resource_id" ' . 'AND "user_resource"."list_id" = "user_list"."id" ' . 'AND "user_resource"."user_id" = ' . "'" . $this->escape($this->id) . "' " . 'AND "resource"."record_id" = ' . "'" . $this->escape($resourceId) . "'"; if (!is_null($listId)) { $sql .= ' AND "user_resource"."list_id"=' . "'" . $this->escape($listId) . "'"; } $saved = new User_resource(); $saved->query($sql); if ($saved->N) { while ($saved->fetch()) { $savedList[] = clone $saved; } } return $savedList; }
function getSavedData($resourceId, $source, $listId = null) { require_once 'User_resource.php'; $savedList = array(); $sql = "SELECT user_resource.*, user_list.title as list_title, user_list.id as list_id " . "FROM user_resource, resource, user_list " . "WHERE resource.id = user_resource.resource_id " . "AND user_resource.list_id = user_list.id " . "AND user_resource.user_id = '{$this->id}' " . "AND resource.source = '{$source}' " . "AND resource.record_id = '{$resourceId}'"; if (!is_null($listId)) { $sql .= " AND user_resource.list_id='{$listId}'"; } $saved = new User_resource(); $saved->query($sql); if ($saved->N) { while ($saved->fetch()) { $savedList[] = clone $saved; } } return $savedList; }