//
// ------------------------------------------------------------------------- //
// E-Xoops: Content Management for the Masses //
// < http://www.e-xoops.com > //
// ------------------------------------------------------------------------- //
// Original Author: Pascal Le Boustouller
// Author Website : http://www.perso-search.com/e-xoopsien/
// Licence Type : GPL
// ------------------------------------------------------------------------- //
include("header.php");
include(XOOPS_ROOT_PATH."/modules/MyAnnonces/cache/config.php");
include(XOOPS_ROOT_PATH."/modules/MyAnnonces/include/functions.php");
include_once(XOOPS_ROOT_PATH."/modules/MyAnnonces/class/arbre.php");
$mytree = new XoopsArbre($db->prefix("ann_categories"),"cid","pid");
if($xoopsConfig['startpage'] == "MyAnnonces"){
$xoopsOption['show_rblock'] =1;
include(XOOPS_ROOT_PATH."/header.php");
make_cblock();
echo "
";
}else{
$xoopsOption['show_rblock'] =0;
include(XOOPS_ROOT_PATH."/header.php");
}
echo "";
# function index
#####################################################
function index() {
global $db, $xoopsConfig, $xoopsUser, $moderated, $myts, $mytree, $souscat, $classm, $nbsouscat, $meta, $newann, $affichnbann;
OpenTable();
echo ""._CLA_ADDFROM." ".$meta['title']."
";
if ($moderated == '1') {
list($propo) = $db->fetch_row($db->query("SELECT COUNT(*) FROM ".$db->prefix("ann_annonces")." WHERE valid='No'"));
if ( $xoopsUser ) {
if ( $xoopsUser->isAdmin() ) {
echo "
";
OpenTable();
echo ""._CLA_ADMINCADRE."
\n";
if($propo == 0)
{
echo "
"._CLA_NO_CLA."
"._CLA_ACCESADMIN."";
} else {
echo ""._CLA_THEREIS." $propo "._CLA_WAIT."
"._CLA_SEEIT."";
}
CloseTable();
echo "";
}
}
}
$intro = join('', file("./cache/intro.php"));
echo "".$myts->makeTareaData4Show($intro, 1, 1, 1)."
";
$result=$db->query("SELECT cid, title, img FROM ".$db->prefix("ann_categories")." WHERE pid = 0 ORDER BY $classm") or die("Error");
list($ncatp) = $db->fetch_row($db->query("SELECT COUNT(*) FROM ".$db->prefix("ann_categories")." WHERE pid=0"));
echo "
"._CLA_SEARCHANN."
\n";
echo "
";
echo "\n";
$count = 1;
while($myrow = $db->fetch_array($result)) {
$cid = $myrow['cid'];
$title = $myts->makeTboxData4Show($myrow['title']);
echo " | $title";
if ($affichnbann == "1") {
$totallink = getTotalItems($myrow['cid'], Yes);
echo " ($totallink)";
}
echo " ";
if ($souscat == 1) {
// get child category objects
$arr=array();
$arr=$mytree->getFirstChild($myrow['cid'], "$classm");
$space = 0;
$chcount = 1;
foreach($arr as $ele){
$chtitle=$myts->makeTboxData4Show($ele['title']);
if ($chcount>$nbsouscat){
echo ", ...";
break;
}
if ($space>0) {
echo ", ";
}
echo "".$chtitle."";
$space++;
$chcount++;
}
}
$bis = ($ncatp+1)/2;
$bis = (int)$bis;
if ($count==$bis) {
echo " | | ";
echo " |
";
list($ann) = $db->fetch_row($db->query("SELECT COUNT(*) FROM ".$db->prefix("ann_annonces")." WHERE valid='Yes'"));
list($catt) = $db->fetch_row($db->query("SELECT COUNT(*) FROM ".$db->prefix("ann_categories").""));
echo "
"._CLA_ACTUALY." $ann "._CLA_ANNONCES." "._CLA_INCAT." $catt "._CLA_CAT3."";
if ($moderated == '1') {
echo "
"._CLA_AND." $propo "._CLA_WAIT3."";
}
echo ".";
echo "
";
CloseTable();
if ($newann == 1) {
echo "";
OpenTable();
showNew();
CloseTable();
}
copyright();
SupprClaDay();
}
# function view (categories)
#####################################################
function view($cid, $debut, $ord, $class) {
global $db, $xoopsConfig, $nb_affichage, $myts, $mytree, $imagecat, $classm, $meta;
include_once(XOOPS_ROOT_PATH.'/class/xoopspagenav.php');
OpenTable();
$pathstring = ""._CLA_MAIN." ";
$nicepath = $mytree->getNicePathFromId($cid, "title", "index.php?pa=view");
$pathstring .= $nicepath;
list($nbe) = $db->fetch_row($db->query("SELECT COUNT(*) FROM ".$db->prefix("ann_annonces")." where valid='Yes' AND cid='$cid'"));
echo $pathstring." ($nbe)
";
echo "
[ "._CLA_ADDANNONCE2." | "._CLA_SEARCHANN." ]";
$count = 0;
if ($debut=="") { $debut=0; }
$pagenav = new XoopsPageNav($nbe, $nb_affichage, $debut, "pa=view&cid=$cid&class=$class&ord=$ord&debut", "");
$subresult=$db->query("select cid, title, img from ".$db->prefix("ann_categories")." where pid=$cid ORDER BY $classm");
$numrows = $db->num_rows($subresult);
if ($numrows != 0) {
$scount = 0;
echo "
"._CLA_AVAILAB."
"
."";
while(list($ccid, $title, $img) = $db->fetch_row($subresult)) {
$title = $myts->makeTboxData4Show($title);
$numrows = getTotalItems($ccid, Yes);
echo " $title ($numrows)";
categorynewgraphic($ccid);
echo " | ";
$scount++;
if ($scount==4) {
echo "
";
$scount = 0;
}
}
if ($count != 0) {
echo "
";
} else {
$cols = 4-$scount;
echo " | ";
}
}
showViewAnnonces($debut, $cid, $nb_affichage, $nbe, $ord, $class);
echo "
";
if(!isset($debut)) $debut=0;
// Show navigation bar
echo "".$pagenav->renderNav(3, 3)."
";
CloseTable();
copyright();
}
# function viewannonces
#####################################################
function viewannonces($lid) {
global $db, $xoopsConfig, $xoopsUser, $monnaie, $claday, $ynprice, $myts, $meta;
$result=$db->query("SELECT lid, cid, title, type, description, tel, price, typeprix, date, email, submitter, usid, town, country, valid, photo, view FROM ".$db->prefix("ann_annonces")." WHERE lid = '$lid'");
$recordexist = $db->num_rows($result);
OpenTable();
echo ""._CLA_MAIN." » "._CLA_DETAIL."
";
if ($recordexist) {
list($lid, $cid, $title, $type, $description, $tel, $price, $typeprix, $date, $email, $submitter, $usid, $town, $country, $valid, $photo, $view)= $db->fetch_row($result);
$db->query("UPDATE ".$db->prefix("ann_annonces")." SET view=view+1 WHERE lid = '$lid'");
$date2 = $date + ($claday*86400);
$date = formatTimestamp($date,"s");
$date2 = formatTimestamp($date2,"s");
$title = $myts->makeTboxData4Show($title);
$type = $myts->makeTboxData4Show($type);
$description = $myts->makeTboxData4Show($description);
$tel = $myts->makeTboxData4Show($tel);
$price = $myts->makeTboxData4Show($price);
$typeprix = $myts->makeTboxData4Show($typeprix);
$submitter = $myts->makeTboxData4Show($submitter);
$town = $myts->makeTboxData4Show($town);
$country = $myts->makeTboxData4Show($country);
$imprD = "
";
$envD = "
";
echo "
"._CLA_ANNFROM." ";
if ($usid > 0) {
echo "$submitter";
} else {
echo "$submitter";
}
echo " n� $lid ("._CLA_VIEW2." $view)";
if ($xoopsUser) {
$calusern = $xoopsUser->getVar("uid", "E");
if ($usid == $calusern) {
echo " ";
}
}
echo"
";
if ( $xoopsUser ) {
if ( $xoopsUser->isAdmin() ) {
echo " ";
}
}
echo " $type : $title |
$description ";
if ($ynprice == 1) {
if ($price > 0) { echo""._CLA_PRICE2." $price $monnaie - $typeprix "; }
}
echo ""._CLA_CONTACT." "._CLA_BYMAIL2."";
if ($tel) { echo " "._CLA_TEL." $tel"; }
if ($town) { echo " "._CLA_TOWN." $town"; }
if ($country) { echo " "._CLA_COUNTRY." $country"; }
if ($photo) {
echo "  ";
} else {
echo "
";
}
$result8 = $db->query("select title from ".$db->prefix("ann_categories")." where cid='$cid'");
list($ctitle) = $db->fetch_row($result8);
echo ""._CLA_CAT2." $ctitle";
echo " "._CLA_DATE2." $date "._CLA_DISPO." $date2 $imprD $envD";
echo " |
";
} else {
echo "
"._CLA_NOCLAS."";
}
CloseTable();
copyright();
}
# function categorynewgraphic
#####################################################
function categorynewgraphic($cat) {
global $db;
$newresult = $db->query("select date from ".$db->prefix("ann_annonces")." where cid=$cat and valid = 'Yes' order by date desc limit 1");
list($timeann)= $db->fetch_row($newresult);
echo " ";
$count = 1;
$startdate = (time()-(86400 * $count));
if ($startdate < $timeann) {
echo "
";
}
}
switch($pa) {
case "viewannonces":
viewannonces($lid);
break;
case "view":
view($cid, $debut, $ord, $class);
break;
case "views":
views($sid, $debut);
break;
default:
index();
break;
}
include(XOOPS_ROOT_PATH."/footer.php");
?>