0ct0pu5/mylittleforum
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
mylittleforum/includes/index.inc.php
Heiko August 45d2bf30a2 distinguish between new and not marked as read also for registered users (#219) 
* Fix: an entry is only new, if it is, not, if it's unread
* Change: intendation by tab on a few places

fixes #209
2017-05-01 19:58:52 +02:00

286 lines
15 KiB
PHP
Raw Permalink Blame History

<?php
if(!defined('IN_INDEX'))
{
header('Location: ../index.php');
exit;
}
if(isset($_SESSION[$settings['session_prefix'].'user_id'])) {
$tmp_user_id = $_SESSION[$settings['session_prefix'].'user_id'];
} else {
$tmp_user_id = 0;
}
if(isset($_SESSION[$settings['session_prefix'].'usersettings']['user_view'])) $user_view = $_SESSION[$settings['session_prefix'].'usersettings']['user_view'];
else $user_view = $settings['default_view'];
if(isset($_SESSION[$settings['session_prefix'].'usersettings']['fold_threads'])) $fold_threads = $_SESSION[$settings['session_prefix'].'usersettings']['fold_threads'];
else $fold_threads = $settings['fold_threads'];
if(isset($_SESSION[$settings['session_prefix'].'usersettings']['thread_order']))
{
if($_SESSION[$settings['session_prefix'].'usersettings']['thread_order']==0) $thread_order = 0;
else $thread_order = 1;
}
elseif(isset($_GET['thread_order']))
{
if(isset($_GET['thread_order'])) $thread_order = 0;
else $thread_order = 1;
}
else $thread_order = 0;
if(isset($_SESSION[$settings['session_prefix'].'usersettings']['category'])) $category = intval($_SESSION[$settings['session_prefix'].'usersettings']['category']);
elseif(isset($_GET['category'])) $category = intval($_GET['category']);
else $category = 0;
if(isset($_GET['page']))
{
$page = intval($_GET['page']);
$_SESSION[$settings['session_prefix'].'usersettings']['page']=$page;
}
elseif(isset($_SESSION[$settings['session_prefix'].'usersettings']['page']))
{
$page = intval($_SESSION[$settings['session_prefix'].'usersettings']['page']);
}
if(empty($page)) $page = 1;
if($thread_order==0) $db_thread_order = 'time';
else $db_thread_order = 'last_reply';
$_SESSION[$settings['session_prefix'].'usersettings']['current_page'] = $page;
$descasc="DESC";
$ul = ($page-1) * $settings['threads_per_page'];
// database request
if($categories == false) // no categories defined
{
$result=mysqli_query($connid, "SELECT id, tid FROM ".$db_settings['forum_table']." WHERE pid = 0".$display_spam_query_and." ORDER BY sticky DESC, ".$db_thread_order." ".$descasc." LIMIT ".$ul.", ".$settings['threads_per_page']) or raise_error('database_error',mysqli_error($connid));
}
elseif(is_array($categories) && $category <= 0) // there are categories and all categories or category selection should be shown
{
if(isset($category_selection_query) && $category==-1) // category selection
{
$category_ids_query = $category_selection_query;
$pid_result = mysqli_query($connid, "SELECT COUNT(*) FROM ".$db_settings['forum_table']." WHERE pid = 0".$display_spam_query_and." AND category IN (".$category_ids_query.")");
list($total_threads) = mysqli_fetch_row($pid_result);
mysqli_free_result($pid_result);
}
$result=mysqli_query($connid, "SELECT id, tid FROM ".$db_settings['forum_table']." WHERE pid = 0".$display_spam_query_and." AND category IN (".$category_ids_query.") ORDER BY sticky DESC, ".$db_thread_order." ".$descasc." LIMIT ".$ul.", ".$settings['threads_per_page']) or raise_error('database_error',mysqli_error($connid));
}
elseif(is_array($categories) && $category > 0) // there are categories and only one category should be shown
{
if(in_array($category, $category_ids))
{
$result=mysqli_query($connid, "SELECT id, tid FROM ".$db_settings['forum_table']." WHERE category = '".mysqli_real_escape_string($connid, $category)."' AND pid = 0".$display_spam_query_and." ORDER BY sticky DESC, ".$db_thread_order." ".$descasc." LIMIT ".$ul.", ".$settings['threads_per_page']) or raise_error('database_error',mysqli_error($connid));
// how many entries?
$pid_result = mysqli_query($connid, "SELECT COUNT(*) FROM ".$db_settings['forum_table']." WHERE pid = 0".$display_spam_query_and." AND category = '".mysqli_real_escape_string($connid, $category)."'");
list($total_threads) = mysqli_fetch_row($pid_result);
mysqli_free_result($pid_result);
}
else // invalid category
{
header('Location: index.php');
exit;
}
}
$result_count = @mysqli_num_rows($result);
if($result_count > 0)
{
while($zeile = mysqli_fetch_array($result))
{
$thread_result = @mysqli_query($connid, "SELECT id, pid, tid, ft.user_id, user_type, UNIX_TIMESTAMP(ft.time) AS time, UNIX_TIMESTAMP(ft.time + INTERVAL ".intval($time_difference)." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, name, user_name, subject, IF(text='',true,false) AS no_text, category, views, marked, locked, sticky, spam, rst.user_id AS req_user
FROM ".$db_settings['forum_table']." AS ft
LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id=ft.user_id
LEFT JOIN ".$db_settings['read_status_table']." AS rst ON rst.posting_id = ft.id AND rst.user_id = ". intval($tmp_user_id) ."
WHERE tid = ".$zeile['tid'].$display_spam_query_and."
ORDER BY ft.time ASC") or raise_error('database_error',mysqli_error($connid));
// put result into arrays:
while($data = mysqli_fetch_array($thread_result))
{
// count replies:
if(!isset($replies[$data['tid']])) $replies[$data['tid']] = 0;
else ++$replies[$data['tid']];
// count number of views of single posting, if option is enabled
if($settings['count_views'] != 0) {
$data['views'] = max($data['views']-1, 0); // this subtracts the first view by the author after posting and prevents negative number of views
// count total number of views of thread
if(!isset($total_views[$data['tid']]))
$total_views[$data['tid']] = 0;
$total_views[$data['tid']] += $data['views'];
}
if($data['user_id']>0)
{
if(!$data['user_name']) $data['name'] = $lang['unknown_user'];
else $data['name'] = htmlspecialchars($data['user_name']);
}
else $data['name'] = htmlspecialchars($data['name']);
$data['subject'] = htmlspecialchars($data['subject']);
if(isset($categories[$data['category']]) && $categories[$data['category']]!='') $data['category_name']=$categories[$data['category']];
if ($data['req_user'] !== NULL and is_numeric($data['req_user'])) {
$data['is_read'] = true;
$data['new'] = false;
} else {
$data['is_read'] = false;
if (isset($_SESSION[$settings['session_prefix'].'usersettings']['newtime']) && $_SESSION[$settings['session_prefix'].'usersettings']['newtime'] < $data['time'] || ($last_visit && ($data['last_reply'] > $last_visit or $data['time'] > $last_visit))) {
$data['new'] = true;
} else {
$data['new'] = false;
}
}
// convert formated time to a utf-8:
$data['formated_time'] = format_time($lang['time_format'],$data['timestamp']);
if($data['pid']==0) $threads[] = $data['id'];
$data_array[$data['id']] = $data;
$child_array[$data['pid']][] = $data['id'];
}
mysqli_free_result($thread_result);
}
@mysqli_free_result($result);
}
// latest postings:
if($settings['latest_postings']>0)
{
if($categories == false)
{
$latest_postings_result = @mysqli_query($connid, "SELECT id, pid, tid, name, user_name, ft.user_id, UNIX_TIMESTAMP(ft.time) AS time, UNIX_TIMESTAMP(ft.time + INTERVAL ".intval($time_difference)." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, subject, category, rst.user_id AS req_user
FROM ".$db_settings['forum_table']." AS ft
LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id=ft.user_id
LEFT JOIN ".$db_settings['read_status_table']." AS rst ON rst.posting_id = ft.id AND rst.user_id = ". intval($tmp_user_id) ."
WHERE spam=0
ORDER BY ft.time DESC LIMIT ".$settings['latest_postings']) or raise_error('database_error',mysqli_error($connid));
}
else
{
if($category>0)
{
$latest_postings_result = @mysqli_query($connid, "SELECT id, pid, tid, name, user_name, ft.user_id, UNIX_TIMESTAMP(ft.time) AS time, UNIX_TIMESTAMP(ft.time + INTERVAL ".intval($time_difference)." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, subject, category, rst.user_id AS req_user
FROM ".$db_settings['forum_table']." AS ft
LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id=ft.user_id
LEFT JOIN ".$db_settings['read_status_table']." AS rst ON rst.posting_id = ft.id AND rst.user_id = ". intval($tmp_user_id) ."
WHERE spam=0 AND category = ".intval($category)."
ORDER BY ft.time DESC LIMIT ".$settings['latest_postings']) or raise_error('database_error',mysqli_error($connid));
}
else
{
$latest_postings_result = @mysqli_query($connid, "SELECT id, pid, tid, name, user_name, ft.user_id, UNIX_TIMESTAMP(ft.time) AS time, UNIX_TIMESTAMP(ft.time + INTERVAL ".intval($time_difference)." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, subject, category, rst.user_id AS req_user
FROM ".$db_settings['forum_table']." AS ft
LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id=ft.user_id
LEFT JOIN ".$db_settings['read_status_table']." AS rst ON rst.posting_id = ft.id AND rst.user_id = ". intval($tmp_user_id) ."
WHERE spam=0 AND category IN (".$category_ids_query.")
ORDER BY ft.time DESC LIMIT ".$settings['latest_postings']) or raise_error('database_error',mysqli_error($connid));
}
}
if(mysqli_num_rows($latest_postings_result)>0)
{
$i=0;
while($latest_postings_data = mysqli_fetch_array($latest_postings_result))
{
$latest_postings[$i]['id'] = intval($latest_postings_data['id']);
$latest_postings[$i]['tid'] = intval($latest_postings_data['tid']);
$latest_postings[$i]['pid'] = intval($latest_postings_data['pid']);
$latest_postings[$i]['subject'] = htmlspecialchars($latest_postings_data['subject']);
if($latest_postings_data['user_id']>0)
{
if(!$latest_postings_data['user_name']) $latest_postings[$i]['name'] = $lang['unknown_user'];
else $latest_postings[$i]['name'] = htmlspecialchars($latest_postings_data['user_name']);
}
else
{
$latest_postings[$i]['name'] = htmlspecialchars($latest_postings_data['name']);
}
if ($latest_postings_data['req_user'] !== NULL and is_numeric($latest_postings_data['req_user'])) {
$latest_postings[$i]['is_read'] = true;
} else {
$latest_postings[$i]['is_read'] = false;
}
$latest_postings[$i]['timestamp'] = $latest_postings_data['timestamp'];
$latest_postings[$i]['formated_time'] = format_time($lang['time_format'],$latest_postings_data['timestamp']);
if(isset($categories[$latest_postings_data['category']]) && $categories[$latest_postings_data['category']]!='') $latest_postings[$i]['category_name']=$categories[$latest_postings_data['category']];
$ago['days'] = floor((TIMESTAMP - $latest_postings_data['time'])/86400);
$ago['hours'] = floor(((TIMESTAMP - $latest_postings_data['time'])/3600)-($ago['days']*24));
$ago['minutes'] = floor(((TIMESTAMP - $latest_postings_data['time'])/60)-($ago['hours']*60+$ago['days']*1440));
if($ago['hours']>12) $ago['days_rounded'] = $ago['days'] + 1;
else $ago['days_rounded'] = $ago['days'];
$latest_postings[$i]['ago'] = $ago;
$i++;
}
$smarty->assign('latest_postings',$latest_postings);
}
mysqli_free_result($latest_postings_result);
}
// Check for unlock users
if(isset($_SESSION[$settings['session_prefix'].'user_id']) && isset($_SESSION[$settings['session_prefix'].'user_type']) && $_SESSION[$settings['session_prefix'].'user_type'] >= 1) {
// Pruefe, ob es registrierte aber bisher nicht freigeschaltete Accounts gibt (Anz. der Logins == 0 && Lock-Status == TRUE)
$unlocked_user_result = mysqli_query($connid, "SELECT count(*) AS 'non_activated_users' FROM ".$db_settings['userdata_table']." WHERE `logins` = 0 AND `user_lock` = 1 AND `activate_code` = '' AND (SELECT TRUE FROM ".$db_settings['settings_table']." WHERE `name` = 'register_mode' AND `value` = 1) = TRUE") or raise_error('database_error',mysqli_error($connid));
if(mysqli_num_rows($unlocked_user_result) > 0 && $row = mysqli_fetch_assoc($unlocked_user_result)) {
$smarty->assign('number_of_non_activated_users', intval($row['non_activated_users']));
}
mysqli_free_result($unlocked_user_result);
}
// tag cloud:
if($settings['tag_cloud']==1) $smarty->assign("tag_cloud",tag_cloud($settings['tag_cloud_day_period'],$settings['tag_cloud_scale_min'],$settings['tag_cloud_scale_max']));
$page_count = ceil($total_threads / $settings['threads_per_page']);
$subnav_link = array('mode'=>'posting', 'title'=>'new_topic_link_title', 'name'=>'new_topic_link');
if(isset($data_array)) $smarty->assign('data',$data_array);
#if(isset($tree)) $smarty->assign("tree",$tree);
if(isset($threads)) {
$smarty->assign("threads",$threads);
$smarty->assign('replies',$replies);
if (isset($total_views))
$smarty->assign('total_views',$total_views);
}
if(isset($child_array)) $smarty->assign("child_array",$child_array);
$smarty->assign("page",$page);
$smarty->assign("category",$category);
$smarty->assign("page_count",$page_count);
$smarty->assign('pagination_top', pagination($page_count,$page,$settings['page_browse_range'],$settings['page_browse_show_last']));
$smarty->assign('pagination', pagination($page_count,$page,3));
$smarty->assign("item_count",$total_threads);
$smarty->assign("items_per_page",$settings['threads_per_page']);
$smarty->assign("thread_order",$thread_order);
$smarty->assign("descasc",$descasc);
$smarty->assign('fold_threads',$fold_threads);
if($category!=0) $cqsa = '&amp;category='.$category;
else $cqsa = '';
if($page>1)
{
$smarty->assign('link_rel_first', 'index.php?mode=index&amp;page=1'.$cqsa);
$smarty->assign('link_rel_prev', 'index.php?mode=index&amp;page='.($page-1).$cqsa);
}
if($page<$page_count)
{
$smarty->assign('link_rel_next', 'index.php?mode=index&amp;page='.($page+1).$cqsa);
$smarty->assign('link_rel_last', 'index.php?mode=index&amp;page='.$page_count.$cqsa);
}
if($total_spam>0 && !isset($_SESSION[$settings['session_prefix'].'usersettings']['show_spam'])) $smarty->assign('show_spam_link',true);
elseif($total_spam>0 && isset($_SESSION[$settings['session_prefix'].'usersettings']['show_spam'])) $smarty->assign('hide_spam_link',true);
if($total_spam>0) $smarty->assign('delete_spam_link',true);
$smarty->assign("subnav_link",$subnav_link);
if($user_view==1) $smarty->assign('subtemplate','index_table.inc.tpl');
else $smarty->assign('subtemplate','index.inc.tpl');
$template = 'main.tpl';
?>
Reference in a new issue View git blame Copy permalink