protected function validateUniqueValue() { if (!isset($this->form->saveresult) || $this->form->saveresult != 1) { return true; } //validate unique field value in database if (isset($this->field->uniquevaluesonly) && $this->field->uniquevaluesonly == 1) { //get values of all recordsets in datatable $details = array(); $db = JFactory::getDbO(); if (isset($this->field->id) && is_numeric($this->field->id)) { $query = ' SELECT F' . $this->field->id . ' FROM #__visforms_' . $this->form->id; $db->setQuery($query); $details = $db->loadColumn(); } //check if there is a match if (in_array($this->field->dbValue, $details)) { $this->field->isValid = false; $app = JFactory::getApplication(); $app->enqueueMessage(JText::sprintf('COM_VISFORMS_UNIQUE_VALUE_REQUIRED', $this->field->label, $this->field->dbValue)); return false; } } return true; }
public static function getPriceDisplayMethod($group_id) { if (!isset(JeproshopGroupModelGroup::$group_price_display_method[$group_id])) { $db = JFactory::getDbO(); $query = "SELECT " . $db->quoteName('price_display_method') . " FROM " . $db->quoteName('#__jeproshop_group'); $query .= " WHERE " . $db->quoteName('group_id') . " = " . (int) $group_id; $db->setQuery($query); self::$group_price_display_method[$group_id] = $db->loadResult(); } return self::$group_price_display_method[$group_id]; }
/** * Method to get the form * @return object with data * @since Joomla 1.6 */ function getForm() { $db = JFactory::getDbO(); $query = ' SELECT * FROM #__visforms ' . ' WHERE id = ' . $this->_id; $db->setQuery($query); $form = $db->loadObject(); $registry = new JRegistry(); //Convert frontendsettings field to an array $registry->loadString($form->frontendsettings); $form->frontendsettings = $registry->toArray(); foreach ($form->frontendsettings as $name => $value) { //make names shorter and set all frontendsettings as properties of form object $form->{$name} = $value; } return $form; }
/** * TuiyoModelProfile::getUserAvatars() * [OBSULATE!!] * @return */ public function getUserAvatars() { $user = JFactory::getUser(); $dbo = JFactory::getDbO(); $query = "SELECT r.resourceID as id, r.url, r.fileTitle as title" . "\nFROM #__tuiyo_resources r" . "\nWHERE r.contentType='AVATAR' AND r.userID =" . $dbo->Quote((int) $user->id); $dbo->setQuery($query); //echo $dbo->getQuery(); return (array) $dbo->loadAssocList(); }