public function loadByKey($key) { $db = EasyBlogHelper::db(); $query = 'SELECT * FROM ' . $db->nameQuote($this->_tbl) . ' WHERE ' . $db->nameQuote('key') . '=' . $db->Quote($key); $db->setQuery($query); $data = $db->loadObject(); return parent::bind($data); }
function loadBySource($postId, $key, $source) { $db = EasyBlogHelper::db(); $query = 'SELECT * FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote($this->_tbl) . ' ' . 'WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('uid') . '=' . $db->Quote($key) . ' ' . 'AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('post_id') . '=' . $db->Quote($postId) . ' ' . 'AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('source') . '=' . $db->Quote($source); $db->setQuery($query); $obj = $db->loadObject(); return parent::bind($obj); }
public function loadByPostId($id) { $db = $this->getDBO(); $query = 'select * FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote($this->_tbl); $query .= ' where `post_id`= ' . $db->Quote($id); $db->setQuery($query); $result = $db->loadAssoc(); return parent::bind($result); }
public function load($path = null, $type = true) { $db = EasyBlogHelper::db(); $query = 'SELECT * FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote($this->_tbl); $query .= ' WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('path') . '=' . $db->Quote($path); $query .= ' AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('type') . '=' . $db->Quote($type); $db->setQuery($query); $obj = $db->loadObject(); return parent::bind($obj); }
public function load($id = null, $type = '') { $db = EasyBlogHelper::db(); $query = 'SELECT * FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote($this->_tbl) . ' ' . 'WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('content_id') . '=' . $db->Quote($id) . ' ' . 'AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('type') . '=' . $db->Quote($type); $db->setQuery($query); $result = $db->loadObject(); if (!$result) { return false; } return parent::bind($result); }
function bindPost() { $data = array('nickname' => JRequest::getWord('nickname'), 'description' => JRequest::getVar('description'), 'url' => JRequest::getVar('url'), 'biography' => JRequest::getVar('biography'), 'title' => JRequest::getVar('title')); pr($data); exit; parent::bind($data); $avatar = JRequest::getVar('avatar', '', 'Files'); if (!empty($avatar['tmp_name'])) { require_once EBLOG_HELPERS . DIRECTORY_SEPARATOR . 'image.php'; } }
public function loadByUser($id, $type) { $db = EB::db(); $query = 'SELECT * FROM ' . $db->quoteName($this->_tbl) . ' ' . 'WHERE ' . $db->nameQuote('user_id') . '=' . $db->Quote($id) . ' ' . 'AND ' . $db->nameQuote('type') . '=' . $db->Quote($type) . ' ' . 'LIMIT 1'; $db->setQuery($query); $result = $db->loadObject(); if (!$result) { return false; } return parent::bind($result); }
function loadByUser($id, $type) { $db = $this->getDBO(); $query = 'SELECT * FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote($this->_tbl) . ' ' . 'WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('user_id') . '=' . $db->Quote($id) . ' ' . 'AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('type') . '=' . $db->Quote($type) . ' ' . 'LIMIT 1'; $db->setQuery($query); $result = $db->loadObject(); if (!$result) { return false; } return parent::bind($result); }
/** * Loads a micro posting from twitter given the post id * * @since 5.0 * @access public * @param string * @return */ public function loadByPostId($id) { $db = EB::db(); $query = array(); $query[] = 'SELECT * FROM ' . $db->qn($this->_tbl); $query[] = 'WHERE ' . $db->qn('post_id') . '=' . $db->Quote($id); $query = implode(' ', $query); $db->setQuery($query); $result = $db->loadObject(); $state = parent::bind($result); return $state; }
function bind($data, $ignore = array()) { parent::bind($data, $ignore); $this->url = $this->_appendHTTP($this->url); //default to username for blogger permalink if empty if (empty($this->permalink)) { $user = JFactory::getUser($this->id); $this->permalink = isset($user->username) ? $user->username : $this->id; $this->permalink = JFilterOutput::stringURLSafe($this->permalink); } else { $this->permalink = JFilterOutput::stringURLSafe($this->permalink); } return true; }
/** * Binds an array of data with the current profile object. * * @since 5.0 * @access public * @param string * @return */ public function bind($data, $ignore = array()) { // Load the parent bind method $state = parent::bind($data, $ignore); // Normalize the url $this->url = EB::string()->normalizeUrl($this->url); // If user's permalink is empty, we need to generate one for them. if (empty($this->permalink)) { $user = JFactory::getUser($this->id); $this->permalink = $user->username; } // Ensure that the permalink is valid $this->permalink = JFilterOutput::stringURLSafe($this->permalink); return $state; }
/** * Loads a meta data by a specific type * * @since 5.0 * @access public * @param string * @return */ public function loadByType($type, $id) { $db = EB::db(); $query = array(); $query[] = 'SELECT * FROM ' . $db->quoteName($this->_tbl); $query[] = 'WHERE ' . $db->quoteName('type') . '=' . $db->Quote($type); $query[] = 'AND ' . $db->quoteName('content_id') . '=' . $db->Quote($id); $query = implode(' ', $query); $db->setQuery($query); $data = $db->loadObject(); if (!$data) { return false; } return parent::bind($data); }
public function fill($userId, $postId, $type, $hash = '') { static $objects = array(); if (!isset($objects[$type][$postId][$userId])) { $db = $this->getDBO(); $query = 'SELECT * FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote($this->_tbl) . ' ' . 'WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('created_by') . '=' . $db->Quote($userId) . ' ' . 'AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('uid') . '=' . $db->Quote($postId) . ' ' . 'AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('type') . '=' . $db->Quote($type); if (!empty($hash)) { $query .= ' AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('sessionid') . '=' . $db->Quote($hash); } $db->setQuery($query); $result = $db->loadObject(); if (is_null($result)) { return false; } $objects[$type][$postId][$userId] = $result; } return parent::bind($objects[$type][$postId][$userId]); }
/** * Overrides parent's bind method * * @since 5.0 * @access public * @param string * @return */ public function bind($data, $ignore = array()) { parent::bind($data, $ignore); if (!$this->created) { $this->created = EB::date()->toSql(); } // we check the alias only when the category is a new category or the alias is empty if (empty($this->id) || empty($this->alias)) { jimport('joomla.filesystem.filter.filteroutput'); $i = 1; while ($this->aliasExists() || empty($this->alias)) { $this->alias = empty($this->alias) ? $this->title : $this->alias . '-' . $i; $this->alias = EBR::normalizePermalink($this->alias); $i++; } } }
/** * Must only be bind when using POST data **/ function bind($data, $post = false) { parent::bind($data); if ($post) { $acl = EasyBlogACLHelper::getRuleSet(); $my = JFactory::getUser(); // Some properties needs to be overriden. $content = JRequest::getVar('write_content_hidden', '', 'post', 'string', JREQUEST_ALLOWRAW); if ($this->id == 0) { // this is to check if superadmin assign blog author during blog creation. if (empty($this->created_by)) { $this->created_by = $my->id; } } //remove unclean editor code. $pattern = array('/<p><br _mce_bogus="1"><\\/p>/i', '/<p><br mce_bogus="1"><\\/p>/i', '/<br _mce_bogus="1">/i', '/<br mce_bogus="1">/i', '/<p><br><\\/p>/i'); $replace = array('', '', '', '', ''); $content = preg_replace($pattern, $replace, $content); // Search for readmore tags using Joomla's mechanism $pattern = '#<hr\\s+id=("|\')system-readmore("|\')\\s*\\/*>#i'; $pos = preg_match($pattern, $content); if ($pos == 0) { $this->intro = $content; // @rule: Since someone might update this post, we need to clear out the content // if it doesn't contain anything. $this->content = ''; } else { list($intro, $main) = preg_split($pattern, $content, 2); $this->intro = $intro; $this->content = $main; } $publish_up = ''; $publish_down = ''; $created_date = ''; $tzoffset = EasyBlogDateHelper::getOffSet(); if (!empty($this->created)) { $date = EasyBlogHelper::getDate($this->created, $tzoffset); $created_date = $date->toMySQL(); } if ($this->publish_down == '0000-00-00 00:00:00') { $publish_down = $this->publish_down; } else { if (!empty($this->publish_down)) { $date = EasyBlogHelper::getDate($this->publish_down, $tzoffset); $publish_down = $date->toMySQL(); } } if (!empty($this->publish_up)) { $date = EasyBlogHelper::getDate($this->publish_up, $tzoffset); $publish_up = $date->toMySQL(); } //default joomla date obj $date = EasyBlogHelper::getDate(); $this->created = !empty($created_date) ? $created_date : $date->toMySQL(); $this->modified = $date->toMySQL(); $this->publish_up = !empty($publish_up) ? $publish_up : $date->toMySQL(); $this->publish_down = empty($publish_down) ? '0000-00-00 00:00:00' : $publish_down; $this->ispending = empty($acl->rules->publish_entry) ? 1 : 0; $this->title = trim($this->title); $this->permalink = trim($this->permalink); } return true; }
/** * Must only be bind when using POST data **/ function bind($data, $post = false) { if (!$post) { return parent::bind($data); } parent::bind($data); $acl = EasyBlogACLHelper::getRuleSet(); $my = JFactory::getUser(); // Some properties needs to be overriden. $content = $this->content; //remove unclean editor code. $pattern = array('/<p><br _mce_bogus="1"><\\/p>/i', '/<p><br mce_bogus="1"><\\/p>/i', '/<br _mce_bogus="1">/i', '/<br mce_bogus="1">/i', '/<p><br><\\/p>/i'); $replace = array('', '', '', '', ''); $content = preg_replace($pattern, $replace, $content); // Search for readmore tags using Joomla's mechanism $pattern = '#<hr\\s+id=("|\')system-readmore("|\')\\s*\\/*>#i'; $pos = preg_match($pattern, $content); if ($pos == 0) { $this->intro = $content; $this->content = ''; } else { list($intro, $main) = preg_split($pattern, $content, 2); $this->intro = $intro; $this->content = $main; } $intro = $this->intro; $content = $this->content; $publish_up = ''; $publish_down = ''; $created_date = ''; $tzoffset = EasyBlogDateHelper::getOffSet(); if (!empty($this->created)) { $date = EasyBlogHelper::getDate($this->created, $tzoffset); $created_date = $date->toMySQL(); } if ($this->publish_down == '0000-00-00 00:00:00') { $publish_down = $this->publish_down; } else { if (!empty($this->publish_down)) { $date = EasyBlogHelper::getDate($this->publish_down, $tzoffset); $publish_down = $date->toMySQL(); } } if (!empty($this->publish_up)) { $date = EasyBlogHelper::getDate($this->publish_up, $tzoffset); $publish_up = $date->toMySQL(); } //default joomla date obj $date = EasyBlogHelper::getDate(); $this->created = !empty($created_date) ? $created_date : $date->toMySQL(); $this->intro = $intro; $this->content = $content; $this->modified = $date->toMySQL(); $this->publish_up = !empty($publish_up) ? $publish_up : $date->toMySQL(); $this->publish_down = empty($publish_down) ? '0000-00-00 00:00:00' : $publish_down; $this->ispending = empty($acl->rules->publish_entry) ? 1 : 0; $this->issitewide = empty($this->blog_contribute) ? 1 : 0; // Bind necessary stuffs for the next load if (isset($data['tags']) && !empty($data['tags']) && is_array($data['tags'])) { $this->set('tags', implode(',', $data['tags'])); } if (isset($data['keywords']) && !empty($data['keywords'])) { $this->set('metakey', $data['keywords']); } if (isset($data['description']) && !empty($data['description'])) { $this->set('metadesc', $data['description']); } if (isset($data['trackback']) && !empty($data['trackback'])) { $this->set('trackbacks', $data['trackback']); } if (isset($data['blogpassword']) && !empty($data['blogpassword'])) { $this->set('blogpassword', $data['blogpassword']); } // @task: Try to detect autoposting for centralized sites if (isset($data['centralized']) && !empty($data['centralized'])) { $this->set('autopost_centralized', implode(',', $data['centralized'])); } if (isset($data['socialshare']) && !empty($data['socialshare'])) { $this->set('autopost', implode(',', $data['socialshare'])); } if (isset($data['blog_contribute_source']) && $data['blog_contribute_source'] != 'easyblog') { $this->set('external_source', $data['blog_contribute_source']); $this->set('external_group_id', $data['blog_contribute']); } if (isset($data['image']) && $data['image']) { $this->set('image', $data['image']); } return true; }
/** * Overrides parent's bind method to add our own logic. * * @param Array $data **/ function bind($data, $ignore = array()) { parent::bind($data, $ignore); }
/** * Overrides parent's bind method to add our own logic. * * @param Array $data **/ function bind($data, $ignore = array()) { parent::bind($data, $ignore); if (empty($this->created)) { $this->created = EasyBlogHelper::getDate()->toMySQL(); } jimport('joomla.filesystem.filter.filteroutput'); $i = 1; while ($this->aliasExists() || empty($this->alias)) { $this->alias = empty($this->alias) ? $this->title : $this->alias . '-' . $i; $i++; } //$this->alias = JFilterOutput::stringURLSafe( $this->alias ); $this->alias = EasyBlogRouter::generatePermalink($this->alias); }