/** * 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; }
/** * Insert or update an ad with form values. Setting $admin to true * allows ads to be saved on behalf of another user. * * @param string $savetype Save action to perform * @return array * [0] = string value of page to redirect to * [1] = content of any error message or text */ function adSave($savetype = 'edit') { global $_TABLES, $_CONF_ADVT, $_USER, $_CONF, $LANG_ADVT, $LANG12; global $LANG_ADMIN; $admin = SEC_hasRights($_CONF_ADVT['pi_name'] . '.admin'); // Sanitize form variables. There should always be an ad id defined $A = array(); if (isset($_POST['ad_id'])) { $A['ad_id'] = COM_sanitizeID($_POST['ad_id'], false); } elseif (isset($_POST['id'])) { $A['ad_id'] = COM_sanitizeID($_POST['id'], false); } if ($A['ad_id'] == '') { return array(CLASSIFIEDS_URL, 'Missing Ad ID'); } // Make sure the current user can edit this ad. if (CLASSIFIEDS_checkAccess($A['ad_id']) < 3) { return array(); } $A['subject'] = trim($_POST['subject']); $A['descript'] = trim($_POST['descript']); if ($_POST['postmode'] == 'plaintext') { $A['descript'] = nl2br($A['descript']); } $A['price'] = trim($_POST['price']); $A['url'] = COM_sanitizeUrl($_POST['url'], array('http', 'https'), 'http'); $A['catid'] = (int) $_POST['catid']; $A['ad_type'] = (int) $_POST['ad_type']; $A['keywords'] = trim($_POST['keywords']); $A['add_date'] = COM_applyFilter($_POST['add_date'], true); $A['exp_date'] = COM_applyFilter($_POST['exp_date'], true); if ($A['exp_date'] == 0) { $A['exp_date'] = $A['add_date']; } $A['exp_sent'] = (int) $_POST['exp_sent'] == 1 ? 1 : 0; $A['owner_id'] = (int) $_POST['owner_id']; $A['group_id'] = (int) $_POST['group_id']; $A['uid'] = $A['owner_id']; $A['comments_enabled'] = (int) $_POST['comments_enabled']; switch ($savetype) { case 'moderate': case 'adminupdate': case 'savesubmission': case 'editsubmission': case 'submission': $perms = SEC_getPermissionValues($_POST['perm_owner'], $_POST['perm_group'], $_POST['perm_members'], $_POST['perm_anon']); $A['perms'] = $perms; break; case $LANG_ADMIN['save']: case $LANG12[8]: default: $A['perms'] = array((int) $_POST['perm_owner'], (int) $_POST['perm_group'], (int) $_POST['perm_members'], (int) $_POST['perm_anon']); break; } // Set anon permissions according to category if not an admin. // To avoid form injection. if (!$admin && DB_getItem($_TABLES['ad_category'], 'perm_anon', "cat_id='{$A['cat_id']}'") == '0') { $A['perms'][3] = 0; } $photo = $_FILES['photo']; $moredays = COM_applyFilter($_POST['moredays'], true); if ($_CONF_ADVT['purchase_enabled'] && !$admin) { // non-administrator is limited to the available days on account, // if applicable. USES_classifieds_class_userinfo(); $User = new adUserInfo(); $moredays = min($moredays, $User->getMaxDays()); } // Validate some fields. $errmsg = ''; if ($A['subject'] == '') { $errmsg .= "<li>{$LANG_ADVT['subject_required']}</li>"; } if ($A['descript'] == '') { $errmsg .= "<li>{$LANG_ADVT['description_required']}</li>"; } if ($errmsg != '') { $errmsg = "<span class=\"alert\"><ul>{$errmsg}</ul></span>\n"; // return to edit page so user can correct return array(1, $errmsg); //return $errmsg; } // Calculate the new number of days. For an existing ad start from the // date added, if new then start from now. If the ad has already expired, // then $moredays will be added to now() rather than exp_date. if ($moredays > 0) { $moretime = $moredays * 86400; $save_exp_date = $A['exp_date']; if ($A['exp_date'] < time()) { $basetime = time(); } else { $basetime = $A['exp_date']; } $A['exp_date'] = min($basetime + $moretime, $A['add_date'] + intval($_CONF_ADVT['max_total_duration']) * 86400); // Figure out the number of days added to this ad, and subtract // it from the user's account. $days_used = (int) (($A['exp_date'] - $save_exp_date) / 86400); if ($_CONF_ADVT['purchase_enabled'] && !$admin) { $User->UpdateDaysBalance($days_used * -1); } // Reset the "expiration notice sent" flag if the new date is at least // one more day from the old one. //if ($A['exp_date'] - $save_exp_date >= 86400) { if ($days_used > 0) { $A['exp_sent'] = 0; } } $errmsg .= CLASSIFIEDS_UploadPhoto($A['ad_id'], 'photo'); if ($errmsg != '') { // Display the real error message, if there is one return array(1, "<span class=\"alert\"><ul>{$errmsg}</ul></span>\n"); //return "<span class=\"alert\"><ul>$errmsg</ul></span>\n"; } if (($savetype == 'moderate' || $savetype == 'editsubmission' || $savetype == 'submission') && plugin_ismoderator_classifieds()) { // If we're editing a submission, delete the submission item // after moving data to the main table $status = CLASSIFIEDS_insertAd($A, 'ad_ads'); if ($status == NULL) { DB_delete($_TABLES['ad_submission'], 'ad_id', $A['ad_id']); } else { $errmsg = $status; } // Now we've duplicated most functions of the moderator approval, // so call the plugin_ function to do the same post-approval stuff plugin_moderationapprove_classifieds($A['ad_id'], $A['owner_id']); } elseif (CLASSIFIEDS_checkAccess($A['ad_id']) == 3) { CLASSIFIEDS_updateAd($A); } else { return array(1, "Acess Denied"); } //$errmsg = COM_showMessage('02', $_CONF_ADVT['pi_name']); //$errmsg = ''; if ($errmsg == '') { return array(0, '02'); } else { return array(1, $errmsg); } //return $errmsg; }