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