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