public function getField() { $objReturn = NULL; $strSql = "SELECT * FROM pcms_element_field WHERE elementId = '%s' AND templateFieldId = '%s' ORDER BY sort"; $objFields = ElementField::select(sprintf($strSql, $this->elementid, $this->templatefieldid)); if (is_object($objFields) && $objFields->count() > 0) { $objReturn = $objFields->current(); } return $objReturn; }
public static function fileHasDuplicates($strFileValue, $intOffset = 0) { global $_CONF; $blnReturn = false; $strSql = "SELECT pcms_element_field_bigtext.id FROM pcms_element_field_bigtext, pcms_element_field, pcms_element \r\n\t\t\tWHERE pcms_element_field_bigtext.value LIKE '%%%s\\n%%' \r\n\t\t\tAND pcms_element_field_bigtext.fieldId = pcms_element_field.id\r\n\t\t\tAND pcms_element_field.elementId = pcms_element.id\r\n\t\t\tAND pcms_element.accountId = '%s'"; $strSql = sprintf($strSql, quote_smart($strFileValue), quote_smart($_CONF['app']['account']->getId())); $objElementFields = ElementField::select($strSql); if ($objElementFields->count() > $intOffset) { $blnReturn = true; } return $blnReturn; }
public function getFieldByTemplateField($intFieldId) { $objReturn = NULL; if ($this->id > 0) { $strSql = sprintf("SELECT * FROM pcms_element_field WHERE elementId = %s AND templateFieldId = %s", self::quote($this->id), self::quote($intFieldId)); $objElementFields = ElementField::select($strSql); if (is_object($objElementFields) && $objElementFields->count() > 0) { $objReturn = $objElementFields->current(); } } return $objReturn; }
public static function fileHasDuplicates($strFileValue, $intOffset = 0) { global $_CONF; $blnReturn = FALSE; $strSql = "SELECT pcms_element_field_bigtext.id FROM pcms_element_field_bigtext, pcms_element_field, pcms_element\r\n\t\t\tWHERE pcms_element_field_bigtext.value LIKE %s\r\n\t\t\tAND pcms_element_field_bigtext.fieldId = pcms_element_field.id\r\n\t\t\tAND pcms_element_field.elementId = pcms_element.id\r\n\t\t\tAND pcms_element.accountId = %s"; $strSql = sprintf($strSql, self::quote('%' . $strFileValue . '\\n%%'), self::quote($_CONF['app']['account']->getId())); $objElementFields = ElementField::select($strSql); if ($objElementFields->count() > $intOffset) { $blnReturn = TRUE; } return $blnReturn; }
public static function setDefault($intId) { global $_CONF; self::$__object = "ContentLanguage"; self::$__table = "pcms_language"; //*** This could take a while. set_time_limit(60 * 60); $objReturn = NULL; //*** Adjust all fields who cascade from the default language. $strSql = sprintf("SELECT * FROM " . self::$__table . " WHERE `default` <> '1' AND `accountId` = '%s'", $_CONF['app']['account']->getId()); $objLanguages = self::select($strSql); $objDefaultLang = ContentLanguage::getDefault(); if (is_object($objDefaultLang)) { $strSql = "SELECT pcms_element_field.* FROM \r\n\t\t\t\t\t`pcms_element`,\r\n\t\t\t\t\t`pcms_element_field`,\r\n\t\t\t\t\t`pcms_element_field_bigtext`\r\n\t\t\t\tWHERE pcms_element_field.id = pcms_element_field_bigtext.fieldId\r\n\t\t\t\tAND pcms_element_field_bigtext.cascade = '1'\r\n\t\t\t\tAND pcms_element.id = pcms_element_field.elementId\r\n\t\t\t\tAND pcms_element.accountId = '%s'\r\n\t\t\t\tUNION \r\n\t\t\t\tSELECT pcms_element_field.* FROM \r\n\t\t\t\t\t`pcms_element`,\r\n\t\t\t\t\t`pcms_element_field`,\r\n\t\t\t\t\t`pcms_element_field_date`\r\n\t\t\t\tWHERE pcms_element_field.id = pcms_element_field_date.fieldId\r\n\t\t\t\tAND pcms_element_field_date.cascade = '1'\r\n\t\t\t\tAND pcms_element.id = pcms_element_field.elementId\r\n\t\t\t\tAND pcms_element.accountId = '%s'\r\n\t\t\t\tUNION \r\n\t\t\t\tSELECT pcms_element_field.* FROM \r\n\t\t\t\t\t`pcms_element`,\r\n\t\t\t\t\t`pcms_element_field`,\r\n\t\t\t\t\t`pcms_element_field_number`\r\n\t\t\t\tWHERE pcms_element_field.id = pcms_element_field_number.fieldId\r\n\t\t\t\tAND pcms_element_field_number.cascade = '1'\r\n\t\t\t\tAND pcms_element.id = pcms_element_field.elementId\r\n\t\t\t\tAND pcms_element.accountId = '%s'\r\n\t\t\t\tUNION \r\n\t\t\t\tSELECT pcms_element_field.* FROM \r\n\t\t\t\t\t`pcms_element`,\r\n\t\t\t\t\t`pcms_element_field`,\r\n\t\t\t\t\t`pcms_element_field_text`\r\n\t\t\t\tWHERE pcms_element_field.id = pcms_element_field_text.fieldId\r\n\t\t\t\tAND pcms_element_field_text.cascade = '1'\r\n\t\t\t\tAND pcms_element.id = pcms_element_field.elementId\r\n\t\t\t\tAND pcms_element.accountId = '%s'"; $strSql = sprintf($strSql, $_CONF['app']['account']->getId(), $_CONF['app']['account']->getId(), $_CONF['app']['account']->getId(), $_CONF['app']['account']->getId()); $objFields = ElementField::select($strSql); foreach ($objFields as $objField) { $strDefaultValue = $objField->getRawValue($objDefaultLang->getId()); foreach ($objLanguages as $objLanguage) { $objValue = $objField->getValueObject($objLanguage->getId()); if (is_object($objValue)) { $objValue->delete(false); } $objValue = $objField->getNewValueObject(); $objValue->setValue($strDefaultValue); $objValue->setLanguageId($objLanguage->getId()); $objValue->setCascade(false); $objField->setValueObject($objValue); } } //*** Set the new default language. $objDefaultLang->default = 0; $objDefaultLang->save(); } $objLanguage = self::selectByPK($intId); $objLanguage->default = 1; $objLanguage->save(); if (class_exists("AuditLog")) { AuditLog::addLog(AUDIT_TYPE_LANGUAGE, $objLanguage->getId(), $objLanguage->getName(), "setdefault"); } return $objReturn; }