/**
* Remove an extra image from database and file system.
*
* <code>
* $imageId = 1;
* $imagesFolder = "/.../folder";
*
* $image = new CrowdFundingImageRemoverExtra(JFactory::getDbo(), $image, $imagesFolder);
* $image->remove();
* </code>
*/
public function remove()
{
// Get the image
$query = $this->db->getQuery(true);
$query->select("a.image, a.thumb")->from($this->db->quoteName("#__crowdf_images", "a"))->where("a.id = " . (int) $this->imageId);
$this->db->setQuery($query);
$row = $this->db->loadObject();
if (!empty($row)) {
// Remove the image from the filesystem
$file = JPath::clean($this->imagesFolder . DIRECTORY_SEPARATOR . $row->image);
if (JFile::exists($file)) {
JFile::delete($file);
}
// Remove the thumbnail from the filesystem
$file = JPath::clean($this->imagesFolder . DIRECTORY_SEPARATOR . $row->thumb);
if (JFile::exists($file)) {
JFile::delete($file);
}
// Delete the record
$query = $this->db->getQuery(true);
$query->delete($this->db->quoteName("#__crowdf_images"))->where($this->db->quoteName("id") . " = " . (int) $this->imageId);
$this->db->setQuery($query);
$this->db->execute();
}
}
/**
* Validate project owner.
*
* <code>
* $projectId = 1;
* $userId = 2;
*
* $owner = new Crowdfunding\Validator\Project\Owner(\JFactory::getDbo(), $projectId, $userId);
* if(!$owner->isValid()) {
* ......
* }
* </code>
*
* @return bool
*/
public function isValid()
{
$query = $this->db->getQuery(true);
$query->select('COUNT(*)')->from($this->db->quoteName('#__crowdf_projects', 'a'))->where('a.id = ' . (int) $this->projectId)->where('a.user_id = ' . (int) $this->userId);
$this->db->setQuery($query, 0, 1);
return (bool) $this->db->loadResult();
}
/**
* This method loads data about e-mail template from a database.
*
* <code>
* $emailId = 1;
*
* $email = new Emailtemplates\Email();
* $email->setDb(JFactory::getDbo());
* $email->load($emailId);
* </code>
*
* @param int $id
*/
public function load($id)
{
$query = $this->db->getQuery(true);
$query->select('a.id, a.title, a.subject, a.body, a.sender_name, a.sender_email, a.catid')->from($this->db->quoteName('#__emailtemplates_emails', 'a'))->where('a.id = ' . (int) $id);
$this->db->setQuery($query);
$result = (array) $this->db->loadAssoc();
$this->bind($result);
}
/**
* Validate project owner.
*
* <code>
* $projectId = 1;
* $userId = 2;
*
* $owner = new Crowdfunding\Validator\Project\Owner(\JFactory::getDbo(), $projectId, $userId);
* if(!$owner->isValid()) {
* ......
* }
* </code>
*
* @return bool
*/
public function isValid()
{
$query = $this->db->getQuery(true);
$query->select("COUNT(*)")->from($this->db->quoteName("#__crowdf_projects", "a"))->where("a.id = " . (int) $this->projectId)->where("a.user_id = " . (int) $this->userId);
$this->db->setQuery($query, 0, 1);
$result = $this->db->loadResult();
return (bool) $result;
}
protected function load()
{
$query = $this->db->getQuery(true);
$query->select('a.id, a.name')->from($this->db->quoteName('#__itpsc_countries', 'a'))->order('a.name ASC');
// Get the options.
$this->db->setQuery($query);
$this->data = $this->db->loadAssocList('id', 'name');
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\JomSocial(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (!empty($ids)) {
$query = $this->db->getQuery(true);
$query->select("a.userid AS user_id, a.avatar, a.thumb")->from($this->db->quoteName("#__community_users", "a"))->where("a.userid IN ( " . implode(",", $ids) . ")");
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList("user_id");
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\EasySocial(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (count($ids) > 0) {
$query = $this->db->getQuery(true);
$query->select('a.id AS user_id, a.name, a.username, ' . 'b.alias, b.permalink, ' . 'c.small, c.medium, c.square, c.large')->from($this->db->quoteName('#__users', 'a'))->leftJoin($this->db->quoteName('#__social_users', 'b') . ' ON a.id = b.user_id')->leftJoin($this->db->quoteName('#__social_avatars', 'c') . ' ON a.id = c.uid')->where('a.id IN ( ' . implode(',', $ids) . ')');
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList('user_id');
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\Gravatar(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (!empty($ids)) {
$query = $this->db->getQuery(true);
$query->select("a.id AS user_id, a.email, MD5(a.email) as hash")->from($this->db->quoteName("#__users", "a"))->where("a.id IN ( " . implode(",", $ids) . ")");
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList("user_id");
}
}
/**
* Remove all address for the user name
*
* Method is called after user data is deleted from the database
*
* @param array $user Holds the user data
* @param boolean $success True if user was successfully stored in the database
* @param string $msg Message
*
* @return boolean
*
* @since 1.6
*/
public function onUserAfterDelete($user, $success, $msg)
{
if (!$success) {
return false;
}
$query = $this->db->getQuery(true)->delete($this->db->quoteName('#__dogecointipping_address'))->where($this->db->quoteName('user_id') . ' = ' . (int) $user['id']);
$this->db->setQuery($query)->execute();
return true;
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\JomSocial(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (count($ids) > 0) {
$query = $this->db->getQuery(true);
$query->select('a.userid AS user_id, a.avatar, a.thumb')->from($this->db->quoteName('#__community_users', 'a'))->where('a.userid IN ( ' . implode(',', $ids) . ')');
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList('user_id');
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\Gravatar(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (count($ids) > 0) {
$query = $this->db->getQuery(true);
$query->select('a.id AS user_id, a.email, MD5(a.email) as hash')->from($this->db->quoteName('#__users', 'a'))->where('a.id IN ( ' . implode(',', $ids) . ')');
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList('user_id');
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\EasySocial(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (!empty($ids)) {
$query = $this->db->getQuery(true);
$query->select("a.id AS user_id, a.name, a.username, " . "b.alias, b.permalink, " . "c.small, c.medium, c.square, c.large")->from($this->db->quoteName("#__users", "a"))->leftJoin($this->db->quoteName("#__social_users", "b") . " ON a.id = b.user_id")->leftJoin($this->db->quoteName("#__social_avatars", "c") . " ON a.id = c.uid")->where("a.id IN ( " . implode(",", $ids) . ")");
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList("user_id");
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\Kunena(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (!empty($ids)) {
// Create a new query object.
$query = $this->db->getQuery(true);
$query->select("a.userid AS user_id, a.avatar")->from($this->db->quoteName("#__kunena_users", "a"))->where("a.userid IN ( " . implode(",", $ids) . ")");
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList("user_id");
}
}
/**
* Load country data from database.
*
* <code>
* $countryId = 1;
*
* $country = new CrowdFundingCountry(JFactory::getDbo());
* $country->load($countryId);
* </code>
*
* @param int $id
*/
public function load($id)
{
$query = $this->db->getQuery(true);
$query->select("a.id, a.name, a.code, a.code4, a.latitude, a.longitude, a.currency, a.code")->from($this->db->quoteName("#__crowdf_countries", "a"))->where("a.id = " . (int) $id);
$this->db->setQuery($query);
$result = $this->db->loadAssoc();
if (!empty($result)) {
$this->bind($result);
}
}
/**
* This method loads data about category from a database.
*
* <code>
* $db = JFactory::getDbo();
* $categoryId = 1;
*
* $category = new UserIdeasCategory();
* $category->setDb($db);
* $category->load($categoryId);
* </code>
*/
public function load($id)
{
$query = $this->db->getQuery(true);
$query->select("a.title, a.description," . $query->concatenate(array("a.id", "a.alias"), ":") . " AS slug")->from($this->db->quoteName("#__categories", "a"))->where("a.id = " . (int) $id)->where("a.extension = " . $this->db->quote("com_userideas"));
$this->db->setQuery($query);
$result = $this->db->loadAssoc();
if (!empty($result)) {
$this->bind($result);
}
}
/**
* This method loads data about e-mail template from a database.
*
* <code>
* $emailId = 1;
*
* $email = new UserIdeasEmail();
* $email->setDb(JFactory::getDbo());
* $email->load($emailId);
* </code>
*/
public function load($id)
{
$query = $this->db->getQuery(true);
$query->select("a.id, a.title, a.subject, a.body, a.sender_name, a.sender_email")->from($this->db->quoteName("#__uideas_emails", "a"))->where("a.id = " . (int) $id);
$this->db->setQuery($query);
$result = $this->db->loadAssoc();
if (!empty($result)) {
$this->bind($result);
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\SocialCommunity(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (count($ids) > 0) {
// Create a new query object.
$query = $this->db->getQuery(true);
$query->select('a.id AS user_id, a.image_icon, a.image_small, a.image_square, a.image, ' . $query->concatenate(array('a.id', 'a.alias'), ':') . ' AS slug, ' . 'b.name as location, b.country_code')->from($this->db->quoteName('#__itpsc_profiles', 'a'))->leftJoin($this->db->quoteName('#__itpsc_locations', 'b') . ' ON a.location_id = b.id')->where('a.id IN ( ' . implode(',', $ids) . ')');
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList('user_id');
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\SocialCommunity(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (!empty($ids)) {
// Create a new query object.
$query = $this->db->getQuery(true);
$query->select("a.id AS user_id, a.image_icon, a.image_small, a.image_square, a.image, " . $query->concatenate(array("a.id", "a.alias"), ":") . " AS slug, " . "b.name as location, b.country_code")->from($this->db->quoteName("#__itpsc_profiles", "a"))->leftJoin($this->db->quoteName("#__itpsc_locations", "b") . " ON a.location_id = b.id")->where("a.id IN ( " . implode(",", $ids) . ")");
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList("user_id");
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\Kunena(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $userIds
*/
public function load(array $userIds)
{
if (count($userIds) > 0) {
// Create a new query object.
$query = $this->db->getQuery(true);
$query->select('a.userid AS user_id, a.avatar')->from($this->db->quoteName('#__kunena_users', 'a'))->where('a.userid IN ( ' . implode(',', $userIds) . ')');
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList('user_id');
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\EasyProfile(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (count($ids) > 0) {
// Create a new query object.
$query = $this->db->getQuery(true);
$query->select('a.id AS user_id, a.avatar, ' . $query->concatenate(array('b.id', 'b.username'), ':') . ' AS slug')->from($this->db->quoteName('#__jsn_users', 'a'))->innerJoin($this->db->quoteName('#__users', 'b') . ' ON a.id = b.id')->where('a.id IN ( ' . implode(',', $ids) . ')');
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList('user_id');
}
}
/**
* Load location data from database.
*
* <code>
* $locationId = 1;
*
* $location = new Crowdfunding\Location(\JFactory::getDbo());
* $location->load($locationId);
* </code>
*
* @param int $id
*/
public function load($id)
{
$query = $this->db->getQuery(true);
$query->select("a.id, a.name, a.latitude, a.longitude, a.country_code, a.state_code, a.timezone, a.published")->from($this->db->quoteName("#__crowdf_locations", "a"))->where("a.id = " . (int) $id);
$this->db->setQuery($query);
$result = $this->db->loadAssoc();
if (!empty($result)) {
$this->bind($result);
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\CommunityBuilder(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (!empty($ids)) {
// Create a new query object.
$query = $this->db->getQuery(true);
$query->select("a.id AS user_id, a.name, " . "b.avatar, " . $query->concatenate(array("a.id", "a.username"), ":") . " AS slug")->from($this->db->quoteName("#__users", "a"))->innerJoin($this->db->quoteName("#__comprofiler", "b") . " ON a.id = b.user_id")->where("a.id IN ( " . implode(",", $ids) . ")");
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList("user_id");
}
}
/**
* Load the data for all user accounts by userId
*
* <code>
* $userId = 1;
*
* $accounts = new VirtualCurrencyAccounts(JFactory::getDbo());
* $accounts->load($userId);
* </code>
*
* @param integer $userId
*/
public function load($userId)
{
$query = $this->db->getQuery(true);
$query->select("a.id, a.amount, a.note, a.currency_id, a.user_id, " . "b.title, b.code, b.symbol, " . "c.name")->from($this->db->quoteName("#__vc_accounts", "a"))->innerJoin($this->db->quoteName("#__vc_currencies", "b") . " ON a.currency_id = b.id")->innerJoin($this->db->quoteName("#__users", "c") . " ON a.user_id = c.id")->where("a.user_id = " . (int) $userId);
$this->db->setQuery($query);
$results = $this->db->loadAssocList();
if (!empty($results)) {
$this->items = $results;
}
}
/**
* Load a data about a type from database.
*
* @param int $id Type ID
*
* <code>
* $typeId = 1;
*
* $type = new CrowdFundingType(JFactory::getDbo());
* $type->load($typeId);
* </code>
*/
public function load($id)
{
$query = $this->db->getQuery(true);
$query->select("a.id, a.title, a.description, a.params")->from($this->db->quoteName("#__crowdf_types", "a"))->where("a.id = " . (int) $id);
$this->db->setQuery($query);
$result = $this->db->loadAssoc();
if (!$result) {
$result = array();
}
$this->bind($result);
}
/**
* This method returns a number of all comments.
*
* @return int
*/
public function getTotalComments()
{
$query = $this->db->getQuery(true);
$query->select("COUNT(*)")->from($this->db->quoteName("#__uideas_comments", "a"));
$this->db->setQuery($query);
$result = $this->db->loadResult();
if (!$result) {
$result = 0;
}
return $result;
}
/**
* Load user data
*
* <code>
* $userId = 1;
*
* $profile = new ITPrismIntegrateProfileGravatar();
* $profile->load($userId);
* </code>
*
* @param int $id
*/
public function load($id)
{
$query = $this->db->getQuery(true);
$query->select("a.id AS user_id, a.email")->from($this->db->quoteName("#__users", "a"))->where("a.id = " . (int) $id);
$this->db->setQuery($query);
$result = $this->db->loadAssoc();
if (!empty($result)) {
// Set values to variables
$this->bind($result);
}
}
/**
* Load data of a record from database.
*
* <code>
* $id = 1;
*
* $partner = new CrowdfundingPartners\Partner();
* $partner->setDb(\JFactory::getDbo());
* $partner->load($id);
* </code>
*
* @param int $keys
* @param array $options
*/
public function load($keys, $options = array())
{
$query = $this->db->getQuery(true);
$query->select("a.id, a.name, a.project_id, a.partner_id")->from($this->db->quoteName("#__cfpartners_partners", "a"))->where("a.id = " . (int) $keys);
$this->db->setQuery($query);
$result = $this->db->loadAssoc();
if (!$result) {
$result = array();
}
$this->bind($result);
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new ITPrismIntegrateProfilesGravatar();
* $profiles->load($ids);
* </code>
*
* @param $ids
*/
public function load($ids)
{
if (!empty($ids)) {
$query = $this->db->getQuery(true);
$query->select("a.id AS user_id, a.email")->from($this->db->quoteName("#__users", "a"))->where("a.id IN ( " . implode(",", $ids) . ")");
$this->db->setQuery($query);
$results = $this->db->loadObjectList();
if (!empty($results)) {
foreach ($results as $result) {
$this->profiles[$result->user_id] = $result;
}
}
}
}
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new ITPrismIntegrateProfilesEasySocial();
* $profiles->load($ids);
* </code>
*
* @param $ids
*/
public function load($ids)
{
if (!empty($ids)) {
$query = $this->db->getQuery(true);
$query->select("a.id AS user_id, a.name, a.username, " . "b.alias, b.permalink, " . "c.medium AS avatar")->from($this->db->quoteName("#__users", "a"))->leftJoin($this->db->quoteName("#__social_users", "b") . " ON a.id = b.user_id")->leftJoin($this->db->quoteName("#__social_avatars", "c") . " ON a.id = c.uid")->where("a.id IN ( " . implode(",", $ids) . ")");
$this->db->setQuery($query);
$results = $this->db->loadObjectList();
if (!empty($results)) {
foreach ($results as $result) {
$this->profiles[$result->user_id] = $result;
}
}
}
}
/**
* Update schemas of com_gamification.
*
* @param array $results
* @param JDatabaseDriver $db
*
* @throws Exception
*/
protected function updateGamificationPlatform($results, $db)
{
$extensions = 'com_gamification';
JLoader::import('Gamification.Version');
$version = new Gamification\Version();
if (version_compare($results[$extensions]['version_id'], $version->getShortVersion(), '<')) {
$query = $db->getQuery(true);
$query->update($db->quoteName('#__schemas'))->set($db->quoteName('version_id') . '=' . $db->quote($version->getShortVersion()))->where($db->quoteName('extension_id') . ' = ' . $db->quote($results[$extensions]['extension_id']));
$db->setQuery($query);
$db->execute();
$msg = JText::sprintf('PLG_SYSTEM_DISTRIBUTION_MIGRATION_UPDATED_SCHEMAS_S', $extensions, $results[$extensions]['extension_id'], $results[$extensions]['version_id'], $version->getShortVersion());
JFactory::getApplication()->enqueueMessage($msg);
}
}
