Перемещаясь в архив, объявление снимается с публикации - AdsManager

						case 'archive':
							$this->_db->setQuery('UPDATE #__adsmanager_ads SET published=0,recall_mail_sent=0 WHERE id='.$id);
							$this->_db->query();

						case 'archive':
							$this->_db->setQuery('UPDATE #__adsmanager_ads SET recall_mail_sent=0 WHERE id='.$id);
							$this->_db->query();

$this->_db->setQuery( " SELECT a.*,c.name as cat, c.id as catid FROM #__adsmanager_ads as a".
		      " INNER JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id ".
		      " INNER JOIN #__adsmanager_categories as c ON adcat.catid = c.id ".
		      " WHERE a.recall_mail_sent = 1 AND a.expiration_date <= CURDATE() AND c.published = 1 AND a.published = 1 GROUP BY a.id");

$this->_db->setQuery( " SELECT a.*,c.name as cat, c.id as catid FROM #__adsmanager_ads as a".
		      " INNER JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id ".
		      " INNER JOIN #__adsmanager_categories as c ON adcat.catid = c.id ".
		      " WHERE a.recall_mail_sent = 1 AND a.expiration_date <= CURDATE() AND c.published = 1 AND a.published = 1 AND c.id <> $conf->archive_catid GROUP BY a.id");

" WHERE a.recall_mail_sent = 1 AND a.expiration_date <= CURDATE() AND c.published = 1 AND a.published = 1 AND c.id <> $conf->archive_catid GROUP BY a.id");