function getRestriction()
{
$sWhereSQL = parent::getRestriction();
$oMain = $this->getAdsMain();
if (isset($this->aCurrent['third_restr']) && $this->aCurrent['third_restr'] != '') {
$sWhereSQL .= " AND {$this->aCurrent['third_restr']} ";
}
if (isset($this->aCurrent['custom_filter1']) && $this->aCurrent['custom_filter1'] != '') {
$sWhereSQL .= " AND {$this->aCurrent['custom_filter1']} ";
}
if (isset($this->aCurrent['custom_filter2']) && $this->aCurrent['custom_filter2'] != '') {
$sWhereSQL .= " AND {$this->aCurrent['custom_filter2']} ";
}
$bSpec = isAdmin();
$sSign = "<";
$sTimeCheck = " AND UNIX_TIMESTAMP() - `{$oMain->_oConfig->sSQLPostsTable}`.`LifeTime`*24*60*60 __sign__ `{$oMain->_oConfig->sSQLPostsTable}`.`DateTime`";
switch ($this->aCurrent['second_restr']) {
case 'expired':
$sSign = ">";
$bSpec = FALSE;
break;
case 'manage':
$sSign = "<";
$bSpec = FALSE;
break;
case 'outtime':
$sTimeCheck = "";
break;
}
if (!$bSpec) {
$sWhereSQL .= str_replace('__sign__', $sSign, $sTimeCheck);
}
return $sWhereSQL;
}
function getRestriction()
{
$sWhereSQL = parent::getRestriction();
$oMain = $this->getAdsMain();
/*if (isset($this->aCurrent['second_restr']) && $this->aCurrent['second_restr'] == 'toptoday') {
$sWhereSQL .= " AND DATE(FROM_UNIXTIME(`{$oMain->_oConfig->sSQLPostsTable}`.`DateTime`)) = CURDATE() ";
}*/
if (isset($this->aCurrent['third_restr']) && $this->aCurrent['third_restr'] != '') {
$sWhereSQL .= " AND {$this->aCurrent['third_restr']} ";
}
if (isset($this->aCurrent['custom_filter1']) && $this->aCurrent['custom_filter1'] != '') {
$sWhereSQL .= " AND {$this->aCurrent['custom_filter1']} ";
}
if (isset($this->aCurrent['custom_filter2']) && $this->aCurrent['custom_filter2'] != '') {
$sWhereSQL .= " AND {$this->aCurrent['custom_filter2']} ";
}
//if (isAdmin() == false) {
if ($this->aCurrent['second_restr'] != 'manage' && isAdmin() == false) {
$sWhereSQL .= " AND UNIX_TIMESTAMP() - `{$oMain->_oConfig->sSQLPostsTable}`.`LifeTime`*24*60*60 < `{$oMain->_oConfig->sSQLPostsTable}`.`DateTime`";
}
return $sWhereSQL;
}
