public function getFieldById($intId) { $objReturn = NULL; $intId = (int) $intId; if ($intId > 0) { $strSql = "SELECT pcms_element_field.* FROM pcms_element_field, pcms_element, pcms_element_schedule\n\t\t\t\t\tWHERE pcms_element_field.id = %s\n\t\t\t\t\tAND pcms_element.id = pcms_element_field.elementId\n\t\t\t\t\tAND pcms_element.active = '1'\n\t\t\t\t\tAND pcms_element.accountId = '%s'\n\t\t\t\t\tAND pcms_element.id = pcms_element_schedule.elementId\n\t\t\t\t\tAND pcms_element_schedule.startDate <= '%s'\n\t\t\t\t\tAND pcms_element_schedule.endDate >= '%s'\n\t\t\t\t\tORDER BY pcms_element_field.sort"; $objFields = ElementField::select(sprintf($strSql, DBA__Object::escape($intId), PCMS_Client::getAccount()->getId(), __Elements::toMysql(), __Elements::toMysql())); if ($objFields->count() > 0) { $objField = $objFields->current(); $objReturn = new __ElementField($objField->getElementId(), TemplateField::selectByPk($objField->getTemplateFieldId())); } } return $objReturn; }