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;
}
