/**
* retrieves stored link state and validates timestamp
*
* @param int $id
* @param string $artlang
* @param boolean $checkDate
* @result mixed false if entry does not exist. true if status expired, otherwise last link state text
*/
function getEntryState($id = 0, $artlang = '', $checkDate = false)
{
$interval = $this->getURLValidateInterval();
$query = sprintf("\n SELECT \n links_state, links_check_date \n FROM \n %sfaqdata \n WHERE \n id = %d \n AND \n lang = '%s'", SQLPREFIX, $id, $this->db->escapeString($artlang));
if ($result = $this->db->query($query)) {
while ($row = $this->db->fetchObject($result)) {
$_linkState = $row->links_state;
if (trim($_linkState) == "") {
$_linkState = true;
}
if ($row->links_check_date > $interval) {
return $_linkState;
} else {
if ($checkDate == false) {
return $_linkState;
} else {
return true;
}
}
}
} else {
return false;
}
}
