/**
* Display the ads under the given category ID. Also puts in the
* subscription link and breadcrumbs.
* @param integer $cat Category number to list
* @return string HTML for category list
*/
function adListCat($cat = '')
{
global $_TABLES, $LANG_ADVT, $_CONF, $_USER, $_CONF_ADVT, $_GROUPS;
global $CatListcolors;
if ($cat == '') {
return;
}
if (CLASSIFIEDS_checkCatAccess($cat) < 2) {
return CLASSIFIEDS_errorMsg($LANG_ADVT['cat_unavailable'], 'alert');
}
$T = new Template(CLASSIFIEDS_PI_PATH . '/templates');
$T->set_file('header', CLASSIFIEDS_getTemplate('adlisthdrCat'));
$T->set_var('pi_url', $_CONF['site_url'] . '/' . $_CONF_ADVT['pi_name']);
$sql = "SELECT image, owner_id, group_id, papa_id\n perm_owner, perm_group, perm_members, perm_anon\n FROM {$_TABLES['ad_category']}\n WHERE cat_id={$cat}";
$r = DB_query($sql);
if (!$r || DB_numRows($r) < 1) {
return;
}
$row = DB_fetchArray($r);
$img_name = $row['image'];
if ($img_name != '') {
$T->set_var('catimg_url', CLASSIFIEDS_thumbUrl($img_name));
}
// Set the breadcrumb navigation
//$T->set_var('breadcrumbs', CLASSIFIEDS_BreadCrumbs($cat), true);
USES_classifieds_class_category();
$T->set_var('breadcrumbs', adCategory::BreadCrumbs($cat), true);
// if non-anonymous, allow the user to subscribe to this category
if (!COM_isAnonUser()) {
$result = DB_getItem($_TABLES['ad_notice'], 'count(*)', "uid = {$_USER['uid']} AND cat_id = {$cat}");
// Determine whether the user is subscribed to notifications for
// this category and display a message and or link accordingly
$subscribed = $result > 0 ? 1 : 0;
if ($subscribed) {
$T->set_var('subscribe_msg', '<a href="' . CLASSIFIEDS_makeURL('del_notice', $cat) . '">' . COM_createImage(CLASSIFIEDS_URL . '/images/unsubscribe.png', $LANG_ADVT['remove'], array('title' => $LANG_ADVT['you_are_subscribed'], 'class' => 'gl_mootip')));
} else {
$T->set_var('subscribe_msg', '<a href="' . CLASSIFIEDS_makeURL('add_notice', $cat) . '">' . COM_createImage(CLASSIFIEDS_URL . '/images/subscribe.png', $LANG_ADVT['subscribe'], array('title' => $LANG_ADVT['subscribe'], 'class' => 'gl_mootip')));
}
// Display a link to submit an ad to the current category
$submit_url = '';
if (SEC_hasRights($_CONF_ADVT['pi_name'] . '.admin')) {
$submit_url = $_CONF['site_admin_url'] . '/plugins/' . $_CONF_ADVT['pi_name'] . '/index.php?mode=edit&cat=' . $cat;
} elseif (CLASSIFIEDS_checkCatAccess($cat, false, $row) == 3) {
$submit_url = $_CONF['site_url'] . '/submit.php?type=' . $_CONF_ADVT['pi_name'] . '&cat=' . $cat;
}
$T->set_var('submit_url', $submit_url);
} else {
// Not-logged-in users can't subscribe or submit.
$T->set_var('subscribe_msg', '');
$T->set_var('submit_msg', '');
}
// This is a comma-separated string of category IDs for a SQL "IN" clause.
// Start with the current category
$cat_for_adlist = $cat;
// Get the sub-categories which have this category as their parent
USES_classifieds_class_category();
$subcats = adCategory::SubCats($cat);
$listvals = '';
$max = count($CatListcolors);
$i = 0;
foreach ($subcats as $row) {
// for each sub-category, add it to the list for getting ads
$cat_for_adlist .= ",{$row['cat_id']}";
// only show the category selection for immediate children.
if ($row['papa_id'] != $cat) {
continue;
}
$T->set_block('header', 'SubCat', 'sCat');
if ($row['fgcolor'] == '' || $row['bgcolor'] == '') {
if ($i >= $max) {
$i = 0;
}
$T->set_var('bgcolor', $CatListcolors[$i][0]);
$T->set_var('fgcolor', $CatListcolors[$i][1]);
$i++;
} else {
$T->set_var('bgcolor', $row['bgcolor']);
$T->set_var('fgcolor', $row['fgcolor']);
}
$T->set_var('subcat_url', CLASSIFIEDS_makeURL('list', $row['cat_id']));
$T->set_var('subcat_name', $row['cat_name']);
$T->set_var('subcat_count', adCategory::TotalAds($row['cat_id']));
$T->parse('sCat', 'SubCat', true);
}
// Get the count of ads under this category
$time = time();
$sql = "SELECT cat_id FROM {$_TABLES['ad_ads']}\n WHERE cat_id IN ({$cat_for_adlist})\n AND exp_date > {$time} " . COM_getPermSQL('AND', 0, 2);
//echo $sql;
$result = DB_query($sql);
if (!$result) {
return CLASSIFIEDS_errorMsg($LANG_ADVT['database_error'], 'alert');
}
$totalAds = DB_numRows($result);
$where_clause = " ad.cat_id IN ({$cat_for_adlist})\n AND ad.exp_date > {$time} ";
$T->parse('output', 'header');
$retval = $T->finish($T->get_var('output'));
$retval .= adExpList('', $cat, $where_clause);
return $retval;
}
/**
* Calls itself recursively to find all sub-categories.
* Stores an array of category information in $subcats.
*
* @param integer $id Current Category ID
* @param integer $master_id ID of top-level category being searched
* @return string HTML for breadcrumbs
*/
public static function SubCats($id, $master_id = 0)
{
global $_TABLES, $LANG_ADVT;
static $subcats = array();
$id = (int) $id;
if ($id == 0) {
return array();
}
// must have a valid category ID
// On the initial call, $master_id is normally blank so set it to
// the current $id. For recursive calls, $master_id will be provided.
$master_id = (int) $master_id;
if ($master_id == 0) {
$master_id = $id;
}
if (isset($subcats[$id])) {
return $subcats[$id];
} else {
$subcats[$id] = array();
}
$sql = "SELECT cat_name, cat_id, fgcolor, bgcolor, papa_id\n FROM {$_TABLES['ad_category']} \n WHERE papa_id={$id}";
//echo $sql;die;
$result = DB_query($sql);
if (!$result) {
return CLASSIFIEDS_errorMsg($LANG_ADVT['database_error'], 'alert');
}
while ($row = DB_fetchArray($result, false)) {
$subcats[$master_id][$row['cat_id']] = $row;
$subcats[$id][$row['cat_id']]['total_ads'] = adCategory::TotalAds($row['cat_id']);
$A = adCategory::SubCats($row['cat_id'], $master_id);
if (!empty($A)) {
array_merge($subcats[$id], $A);
}
}
return $subcats[$master_id];
}
/**
* Display an ad's detail
* @param string $ad_id ID of ad to display
*/
function adDetail($ad_id = '')
{
global $_USER, $_TABLES, $_CONF, $LANG_ADVT, $_CONF_ADVT;
USES_lib_comments();
// Determind if this is an administrator
$admin = SEC_hasRights($_CONF_ADVT['pi_name'] . '.admin');
$ad_id = COM_sanitizeID($ad_id);
if ($ad_id == '') {
// An ad id is required for this function
return CLASSIFIEDS_errorMsg($LANG_ADVT['missing_id'], 'alert');
}
$srchval = isset($_GET['query']) ? trim($_GET['query']) : '';
// We use this in a few places here, so might as well just
// figure it out once and save it.
$perm_sql = COM_getPermSQL('AND', 0, 2, 'ad') . ' ' . COM_getPermSQL('AND', 0, 2, 'cat');
// get the ad information.
$sql = "SELECT ad.*\n FROM {$_TABLES['ad_ads']} ad\n LEFT JOIN {$_TABLES['ad_category']} cat\n ON ad.cat_id = cat.cat_id\n WHERE ad_id='{$ad_id}'";
if (!$admin) {
$sql .= $perm_sql;
}
$result = DB_query($sql);
if (!$result || DB_numRows($result) < 1) {
return CLASSIFIEDS_errorMsg($LANG_ADVT['no_ad_found'], 'note', 'Oops...');
}
$ad = DB_fetchArray($result, false);
// Check access to the ad. If granted, check that access isn't
// blocked by any category.
$my_access = CLASSIFIEDS_checkAccess($ad['ad_id'], $ad);
if ($my_access >= 2) {
$my_cat_access = CLASSIFIEDS_checkCatAccess($ad['cat_id'], false);
if ($my_cat_access < $my_access) {
$my_access = $my_cat_access;
}
}
if ($my_access < 2) {
return CLASSIFIEDS_errorMsg($LANG_ADVT['no_permission'], 'alert', $LANG_ADVT['access_denied']);
}
$cat = (int) $ad['cat_id'];
// Increment the views counter
$sql = "UPDATE {$_TABLES['ad_ads']} \n SET views = views + 1 \n WHERE ad_id='{$ad_id}'";
DB_query($sql);
// Get the previous and next ads
$condition = " AND ad.cat_id={$cat}";
if (!$admin) {
$condition .= $perm_sql;
}
$sql = "SELECT ad_id\n FROM {$_TABLES['ad_ads']} ad\n LEFT JOIN {$_TABLES['ad_category']} cat\n ON ad.cat_id = cat.cat_id\n WHERE ad_id < '{$ad_id}' \n {$condition}\n ORDER BY ad_id DESC\n LIMIT 1";
$r = DB_query($sql);
list($preAd_id) = DB_fetchArray($r, false);
$sql = "SELECT ad_id\n FROM {$_TABLES['ad_ads']} ad\n LEFT JOIN {$_TABLES['ad_category']} cat\n ON ad.cat_id = cat.cat_id\n WHERE ad_id > '{$ad_id}' \n {$condition}\n ORDER BY ad_id ASC\n LIMIT 1";
$r = DB_query($sql);
list($nextAd_id) = DB_fetchArray($r, false);
// Get the user contact info. If none, just show the email link
$sql = "SELECT * \n FROM {$_TABLES['ad_uinfo']} \n WHERE uid='{$ad['uid']}'";
//echo $sql;
$result = DB_query($sql);
$uinfo = array();
if ($result && DB_numRows($result) > 0) {
$uinfo = DB_fetchArray($result);
} else {
$uinfo['uid'] = '';
$uinfo['address'] = '';
$uinfo['city'] = '';
$uinfo['state'] = '';
$uinfo['postal'] = '';
$uinfo['tel'] = '';
$uinfo['fax'] = '';
}
// Get the hot results (most viewed ads)
$time = time();
$sql = "SELECT ad.ad_id, ad.cat_id, ad.subject,\n cat.cat_id, cat.fgcolor, cat.bgcolor\n FROM {$_TABLES['ad_ads']} ad\n LEFT JOIN {$_TABLES['ad_category']} cat\n ON ad.cat_id = cat.cat_id\n WHERE ad.exp_date > {$time} \n {$perm_sql}\n ORDER BY views DESC \n LIMIT 4";
//echo $sql;die;
$hotresult = DB_query($sql);
// convert line breaks & others to html
$patterns = array('/\\n/');
$replacements = array('<br />');
$ad['descript'] = PLG_replaceTags(COM_checkHTML($ad['descript']));
$ad['descript'] = preg_replace($patterns, $replacements, $ad['descript']);
$ad['subject'] = strip_tags($ad['subject']);
$ad['price'] = strip_tags($ad['price']);
$ad['url'] = COM_sanitizeUrl($ad['url']);
$ad['keywords'] = strip_tags($ad['keywords']);
// Highlight search terms, if any
if ($srchval != '') {
$ad['subject'] = COM_highlightQuery($ad['subject'], $srchval);
$ad['descript'] = COM_highlightQuery($ad['descript'], $srchval);
}
$detail = new Template(CLASSIFIEDS_PI_PATH . '/templates');
$detail->set_file('detail', 'detail.thtml');
if ($admin) {
$base_url = CLASSIFIEDS_ADMIN_URL . '/index.php';
$del_link = $base_url . '?delete=ad&ad_id=' . $ad_id;
$edit_link = $base_url . '?edit=ad&ad_id=' . $ad_id;
} else {
$base_url = CLASSIFIEDS_URL . '/index.php';
$del_link = $base_url . '?mode=Delete&id=' . $ad_id;
$edit_link = $base_url . '?mode=editad&id=' . $ad_id;
}
// Set up the "add days" form if this user is the owner
// or an admin
if ($my_access == 3) {
// How many days has the ad run?
$max_add_days = CLASSIFIEDS_calcMaxAddDays(($ad['exp_date'] - $ad['add_date']) / 86400);
if ($max_add_days > 0) {
$detail->set_var('max_add_days', $max_add_days);
}
}
if ($ad['exp_date'] < $time) {
$detail->set_var('is_expired', 'true');
}
USES_classifieds_class_category();
$detail->set_var(array('base_url' => $base_url, 'edit_link' => $edit_link, 'del_link' => $del_link, 'curr_loc' => adCategory::BreadCrumbs($cat, true), 'subject' => $ad['subject'], 'add_date' => date($_CONF['shortdate'], $ad['add_date']), 'exp_date' => date($_CONF['shortdate'], $ad['exp_date']), 'views_no' => $ad['views'], 'descript' => $ad['descript'], 'ad_type' => CLASSIFIEDS_getAdTypeString($ad['ad_type']), 'uinfo_address' => $uinfo['address'], 'uinfo_city' => $uinfo['city'], 'uinfo_state' => $uinfo['state'], 'uinfo_postcode' => $uinfo['postcode'], 'uinfo_tel' => $uinfo['tel'], 'uinfo_fax' => $uinfo['fax'], 'price' => $ad['price'], 'ad_id' => $ad_id, 'ad_url' => $ad['url'], 'username' => $_CONF_ADVT['disp_fullname'] == 1 ? COM_getDisplayName($ad['uid']) : DB_getItem($_TABLES['users'], 'username', "uid={$ad['uid']}"), 'fgcolor' => $ad['fgcolor'], 'bgcolor' => $ad['bgcolor'], 'cat_id' => $ad['cat_id']));
// Display a link to email the poster, or other message as needed
$emailfromuser = DB_getItem($_TABLES['userprefs'], 'emailfromuser', "uid={$ad['uid']}");
if ($_CONF['emailuserloginrequired'] == 1 && COM_isAnonUser() || $emailfromuser < 1) {
$detail->set_var('ad_uid', '');
} else {
$detail->set_var('ad_uid', $ad['uid']);
}
if ($my_access == 3) {
$detail->set_var('have_userlinks', 'true');
if ($admin || $_CONF_ADVT['usercanedit'] == 1) {
$detail->set_var('have_editlink', 'true');
} else {
$detail->set_var('have_editlink', '');
}
} else {
$detail->set_var('have_userlinks', '');
}
// Retrieve the photos and put into the template
$sql = "SELECT photo_id, filename\n FROM {$_TABLES['ad_photo']} \n WHERE ad_id='{$ad_id}'";
$photo = DB_query($sql);
$photo_detail = '';
$detail->set_var('have_photo', '');
// assume no photo available
if ($photo && DB_numRows($photo) >= 1) {
while ($prow = DB_fetchArray($photo)) {
$img_small = LGLIB_ImageUrl(CLASSIFIEDS_IMGPATH . '/' . $prow['filename'], $_CONF_ADVT['detail_img_width']);
$img_disp = CLASSIFIEDS_dispUrl($prow['filename']);
if (!empty($img_small)) {
$detail->set_block('detail', 'PhotoBlock', 'PBlock');
$detail->set_var(array('tn_width' => $_CONF_ADVT['detail_img_width'], 'small_url' => $img_small, 'disp_url' => $img_disp));
$detail->parse('PBlock', 'PhotoBlock', true);
$detail->set_var('have_photo', 'true');
}
}
}
if (DB_count($_TABLES['ad_ads'], 'owner_id', (int) $ad['owner_id']) > 1) {
$detail->set_var('byposter_url', CLASSIFIEDS_URL . '/index.php?' . "page=byposter&uid={$ad['owner_id']}");
}
// Show previous and next ads
if ($preAd_id != '') {
$detail->set_var('previous', '<a href="' . CLASSIFIEDS_makeURL('detail', $preAd_id) . "\"><<</a>");
}
if ($nextAd_id != '') {
$detail->set_var('next', '<a href="' . CLASSIFIEDS_makeURL('detail', $nextAd_id) . "\"> >></a>");
}
// Show the "hot results"
$hot_data = '';
if ($hotresult) {
$detail->set_block('detail', 'HotBlock', 'HBlock');
while ($hotrow = DB_fetchArray($hotresult)) {
$detail->set_var(array('hot_title' => $hotrow['subject'], 'hot_url' => CLASSIFIEDS_makeURL('detail', $hotrow['ad_id']), 'hot_cat' => displayCat($hotrow['cat_id'])));
/*$hot_data .= "<tr><td class=\"hottitle\"><a href=\"" .
CLASSIFIEDS_makeURL('detail', $hotrow['ad_id']) .
"\">{$hotrow['subject']}</a></small></td>\n";
$hot_data .= "<td class=\"hotcat\">( " . displayCat($hotrow['cat_id']) .
" )</td></tr>\n";*/
}
$detail->parse('HBlock', 'HotBlock', true);
}
$detail->set_var('whats_hot_row', $hot_data);
// Show the user comments
if (plugin_commentsupport_classifieds() && $ad['comments_enabled'] < 2) {
$detail->set_var('usercomments', CMT_userComments($ad_id, $ad['subject'], 'classifieds', '', '', 0, 1, false, false, $ad['comments_enabled']));
//$detail->set_var('usercomments', CMT_userComments($ad_id, $subject,
// 'classifieds'));
}
$detail->parse('output', 'detail');
$display = $detail->finish($detail->get_var('output'));
return $display;
}
// Display the list of ads, either pending or all
$content .= adList(true);
break;*/
/*case 'Xadminads':
// Display the list of ads, either pending or all
$content .= adList(true);
break;*/
case 'Xadmincats':
case 'editcat':
// Display the form to manage categories
$cat_id = isset($_REQUEST['cat_id']) ? (int) $_REQUEST['cat_id'] : 0;
//USES_classifieds_categories();
USES_classifieds_class_category();
$content .= CLASSIFIEDS_adminMenu('cat');
//$content .= CLASSIFIEDS_catEdit($cat_id);
$C = new adCategory($cat_id);
$content .= $C->Edit();
break;
case 'admincats':
USES_classifieds_admin();
$content .= CLASSIFIEDS_adminCategories();
break;
/*case 'Xadminother':
$T1 = new Template(CLASSIFIEDS_PI_PATH . '/templates/admin/');
$T1->set_file('content', 'adminother.thtml');
$T1->set_var('cat_list', SEC_getGroupDropdown($_CONF_ADVT['defgrpcat'], 3));
$T1->set_var('cat_perms', SEC_getPermissionsHTML(
$_CONF_ADVT['default_perm_cat'][0],
$_CONF_ADVT['default_perm_cat'][1],
$_CONF_ADVT['default_perm_cat'][2],
$_CONF_ADVT['default_perm_cat'][3]));
