| |
_deleted = $database->loadResult();
$database->setQuery( "SELECT CURRENT_DATE()");
$date_current = $database->loadResult();
if ( $date_current > $date_deleted) {
$sql = "SELECT id FROM #__marketplace_ads WHERE date_created < DATE_SUB( '$date_current', INTERVAL $duration DAY)";
$database->setQuery( $sql);
$rows = $database->loadObjectList();
// delete all images from outdated ads
foreach($rows as $row) {
$adid = $row->id;
for($extid = 0, $nbext = sizeof($picext) ; $extid < $nbext ; $extid++) {
// image1 delete
$a_pict = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$adid."a_t.".$picext[$extid];
if ( file_exists( $a_pict)) {
unlink( $a_pict);
}
$a_pic = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$adid."a.".$picext[$extid];
if ( file_exists( $a_pic)) {
unlink( $a_pic);
}
// image2 delete
$b_pict = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$adid."b_t.".$picext[$extid];
if ( file_exists( $b_pict)) {
unlink( $b_pict);
}
$b_pic = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$adid."b.".$picext[$extid];
if ( file_exists( $b_pic)) {
unlink( $b_pic);
}
// image3 delete
$c_pict = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$adid."c_t.".$picext[$extid];
if ( file_exists( $c_pict)) {
unlink( $c_pict);
}
$c_pic = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$adid."c.".$picext[$extid];
if ( file_exists( $c_pic)) {
unlink( $c_pic);
}
}
}
// now delete all outdated ads
$sql = "DELETE FROM #__marketplace_ads WHERE date_created < DATE_SUB( '$date_current', INTERVAL $duration DAY)";
$database->setQuery( $sql);
if ($database->getErrorNum()) {
echo $database->stderr();
} else {
$database->query();
}
// set delete marker on today
$sql = "UPDATE #__marketplace_config SET date_deleted = CURRENT_DATE()";
$database->setQuery( $sql);
if ($database->getErrorNum()) {
echo $database->stderr();
} else {
$database->query();
}
}
echo "";
echo "";
echo "";
include($mosConfig_absolute_path.'/components/com_marketplace/topmenu.php');
include($mosConfig_absolute_path.'/components/com_marketplace/recent5.php');
echo "
";
echo "
";
// build index-page: marketplace_categories
$database->setQuery("SELECT * FROM #__marketplace_categories WHERE published='1' ORDER BY sort_order");
$rows = $database->loadObjectList();
echo "";
echo "";
echo "| ".JOO_CATEGORY." | ";
echo "".JOO_ENTRIES." | ";
echo "".JOO_LASTENTRY." | ";
echo " ";
foreach($rows as $row) {
if($row->has_entries == 0) {
echo "";
}
else {
$linkTarget = sefRelToAbs( "index.php?option=com_marketplace&page=show_category&catid=".$row->id."&Itemid=".$Itemid);
echo " ";
}
if($row->has_entries == 0) {
echo "| ";
}
else {
echo " | ";
}
if($row->has_entries == 0) {
echo "
";
echo "";
echo "";
echo "";
echo "".$row->name."
";
echo "";
echo $row->description;
echo "";
echo " | ";
echo " ";
echo " ";
}
else {
echo "";
echo "";
echo "";
echo "";
echo "";
echo "![](".$mosConfig_live_site."/components/com_marketplace/images/categories/".$row->image.") ";
echo "";
echo "";
echo " | ";
echo "";
echo " ";
echo " | ";
echo "";
echo "".$row->name."
";
echo "";
echo $row->description;
echo "";
echo " | ";
echo " ";
echo " ";
}
echo " | ";
if($row->has_entries > 0) {
echo "";
// number of entries
$database->setQuery("SELECT COUNT(*) AS ad_count
FROM #__marketplace_ads
WHERE category='$row->id' AND published='1'");
$rows_ads = $database->loadObjectList();
foreach($rows_ads as $row_ad) {
$ad_count = $row_ad->ad_count;
}
echo $ad_count;
echo " | ";
}
if($row->has_entries > 0) {
echo "";
// last entry
$database->setQuery("SELECT user, date_format(date_created, '%d.%m.%Y' ) as date_cr
FROM #__marketplace_ads
WHERE category='$row->id' AND published='1'
ORDER BY date_created DESC, id DESC
LIMIT 1");
$rows_date = $database->loadObjectList();
$datum = "-";
foreach($rows_date as $row_date) {
$datum = $row_date->date_cr;
$ad_username = $row_date->user;
}
echo $datum;
if ( $ad_count > 0) {
echo "
";
echo "";
echo JOO_FROM;
echo "".$ad_username."";
echE END=###
?>
|
Portal.Lg.Ua:) Украинский портал. Интересные Новости. Цікаві новини. Коротко о самом интересном. © 2023
| | |
Ответственность за содержание публикации полностью ложится на источник информации (см.«Сайт Источника. Администрация портала Ukrwebmir Net может не разделять мнение автора. |
|
|
|
|
|
|
|
|
