Files
Testing/classified.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

182 lines
7.1 KiB
PHP

<?php
/* $Id: classified.php 152 2009-04-02 20:50:48Z john $ */
$page = "classified";
include "header.php";
// DISPLAY ERROR PAGE IF USER IS NOT LOGGED IN AND ADMIN SETTING REQUIRES REGISTRATION
if( (!$user->user_exists && !$setting['setting_permission_classified']) || ($user->user_exists && (1 & ~(int)$user->level_info['level_classified_allow'])) )
{
$page = "error";
$smarty->assign('error_header', 639);
$smarty->assign('error_message', 656);
$smarty->assign('error_submit', 641);
include "footer.php";
}
// PARSE GET/POST
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
if(isset($_GET['classified_id'])) { $classified_id = $_GET['classified_id']; } elseif(isset($_POST['classified_id'])) { $classified_id = $_POST['classified_id']; } else { $classified_id = 0; }
// DISPLAY ERROR PAGE IF NO OWNER
$classified = new se_classified($user->user_info['user_id'], $classified_id);
if( !$classified->classified_exists || !$owner->user_exists )
{
$page = "error";
$smarty->assign('error_header', 639);
$smarty->assign('error_message', 828);
$smarty->assign('error_submit', 641);
include "footer.php";
}
// GET PRIVACY LEVEL
$privacy_max = $owner->user_privacy_max($user);
$allowed_to_view = (bool) ($privacy_max & $classified->classified_info['classified_privacy' ]);
$allowed_to_comment = (bool) ($privacy_max & $classified->classified_info['classified_comments']);
if( !$allowed_to_view )
{
header('Location: '.$url->url_create('profile', $owner->user_info['user_username']));
exit();
}
// UPDATE CLASSIFIED VIEWS IF GROUP VISIBLE
if( $allowed_to_view )
{
$classified->classified_info['classified_views']++;
$sql = "UPDATE se_classifieds SET classified_views='{$classified->classified_info['classified_views']}' WHERE classified_id='{$classified->classified_info['classified_id']}' LIMIT 1";
$database->database_query($sql);
}
// GET CLASSIFIED COMMENTS
$comment = new se_comment('classified', 'classified_id', $classified->classified_info['classified_id']);
$total_comments = $comment->comment_total();
$comments = $comment->comment_list(0, 10);
// GET CUSTOM CLASSIFIED STYLE IF ALLOWED
if( $classified->classifiedowner_level_info['level_classified_style'] && $allowed_to_view )
{
$sql ="SELECT classifiedstyle_css FROM se_classifiedstyles WHERE classifiedstyle_user_id='{$owner->user_info['user_id']}' LIMIT 1";
$resource = $database->database_query($sql);
if( $database->database_num_rows($resource) )
$classifiedstyle_info = $database->database_fetch_assoc($resource);
if( $classifiedstyle_info )
$global_css = $classifiedstyle_info['classifiedstyle_css'];
}
// MAKE SURE TITLE IS NOT EMPTY, CONVERT BODY HTML CHARACTERS BACK
if( !$classified->classified_info['classified_title'] )
$classified->classified_info['classified_title'] = 'Untitled';
$classified->classified_info['classified_body'] = str_replace("\r\n", "", htmlspecialchars_decode($classified->classified_info['classified_body']));
// GET CLASSIFIED ALBUM INFO AND MEDIA ARRAY
$sql = "SELECT * FROM se_classifiedalbums WHERE classifiedalbum_classified_id='{$classified->classified_info['classified_id']}' LIMIT 1";
$resource = $database->database_query($sql) or die("<b>Error: </b>".$database->database_error()."<br /><b>File: </b>".__FILE__."<br /><b>Line: </b>".__LINE__."<br /><b>Query: </b>".$sql);
if( $database->database_num_rows($resource) )
{
$classifiedalbum_info = $database->database_fetch_assoc($resource);
$file_array = $classified->classified_media_list(0, 10, "classifiedmedia_id ASC", "(classifiedmedia_classifiedalbum_id='{$classifiedalbum_info['classifiedalbum_id']}')", TRUE);
$total_files = $classified->classified_media_total($classifiedalbum_info['classifiedalbum_id']);
}
// GET SUBCAT IF NECESSARY
$sql = "SELECT classifiedcat_id, classifiedcat_dependency FROM se_classifiedcats WHERE classifiedcat_id='{$classified->classified_info['classified_classifiedcat_id']}' LIMIT 1";
$resource = $database->database_query($sql);
if( $database->database_num_rows($resource) )
$thiscat = $database->database_fetch_assoc($resource);
if( !$thiscat || !$thiscat['classifiedcat_dependency'] )
{
$classified->classified_info['classified_classifiedsubcat_id'] = 0;
}
else
{
$classified->classified_info['classified_classifiedsubcat_id'] = $classified->classified_info['classified_classifiedcat_id'];
$classified->classified_info['classified_classifiedcat_id'] = $thiscat['classifiedcat_dependency'];
}
// GET FIELDS
$classifiedcat_info = $database->database_fetch_assoc($database->database_query("SELECT t1.classifiedcat_id AS subcat_id, t1.classifiedcat_title AS subcat_title, t1.classifiedcat_dependency AS subcat_dependency, t2.classifiedcat_id AS cat_id, t2.classifiedcat_title AS cat_title FROM se_classifiedcats AS t1 LEFT JOIN se_classifiedcats AS t2 ON t1.classifiedcat_dependency=t2.classifiedcat_id WHERE t1.classifiedcat_id='{$classified->classified_info['classified_classifiedcat_id']}'"));
if( !$classifiedcat_info['subcat_dependency'] )
{
$cat_where = "classifiedcat_id='{$classified->classified_info['classified_classifiedcat_id']}'";
}
else
{
$cat_where = "classifiedcat_id='{$classifiedcat_info['subcat_dependency']}'";
}
$field = new se_field("classified", $classified->classifiedvalue_info);
$field->cat_list(0, 1, 0, $cat_where, "classifiedcat_id='0'", "");
// DELETE NOTIFICATIONS
if( $user->user_info['user_id']==$owner->user_info['user_id'] )
{
$database->database_query("
DELETE FROM
se_notifys
USING
se_notifys
LEFT JOIN
se_notifytypes
ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id
WHERE
se_notifys.notify_user_id='{$owner->user_info['user_id']}' AND
se_notifytypes.notifytype_name='classifiedcomment' AND
notify_object_id='{$classified->classified_info['classified_id']}'
");
}
// SET SEO STUFF
$global_page_content = $classified->classified_info['classified_title'];
$global_page_content = cleanHTML(str_replace('>', '> ', $global_page_content), NULL);
if( strlen($global_page_content)>255 ) $global_page_content = substr($global_page_content, 0, 251).'...';
$global_page_content = addslashes(trim(preg_replace_callback('/\s+/', ' ',$global_page_content)));
$global_page_title = array(
4500144,
$owner->user_displayname,
$global_page_content
);
$global_page_content = $classified->classified_info['classified_body'];
$global_page_content = cleanHTML(str_replace('>', '> ', $global_page_content), NULL);
if( strlen($global_page_content)>255 ) $global_page_content = substr($global_page_content, 0, 251).'...';
$global_page_content = addslashes(trim(preg_replace_callback('/\s+/', ' ',$global_page_content)));
$global_page_description = array(
4500144,
$owner->user_displayname,
$global_page_content
);
// ASSIGN VARIABLES AND DISPLAY CLASSIFIED PAGE
$smarty->assign_by_ref('classified', $classified);
$smarty->assign_by_ref('cats', $field->cats);
$smarty->assign('comments', $comments);
$smarty->assign('total_comments', $total_comments);
$smarty->assign('allowed_to_comment', $allowed_to_comment);
$smarty->assign('files', $file_array);
$smarty->assign('total_files', $total_files);
include "footer.php";
?>