<?PHP

/* ====================
Seditio - Website engine
Copyright Neocrome & Seditio Team
https://seditio.org
[BEGIN_SED]
File=forums.php
Version=179
Updated=2022-jul-15
Type=Core
Author=Seditio Team
Description=Forums
[END_SED]
==================== */

if (!defined('SED_CODE')) { die('Wrong URL.'); }

list($usr['auth_read'], $usr['auth_write'], $usr['isadmin']) = sed_auth('forums', 'any');
sed_block($usr['auth_read']);

$id = sed_import('id','G','INT');
$s = sed_import('s','G','ALP');
$q = sed_import('q','G','INT');
$p = sed_import('p','G','INT');
$d = sed_import('d','G','INT');
$o = sed_import('o','G','ALP');
$w = sed_import('w','G','ALP',4);
$c = sed_import('c','G','ALP');
$quote = sed_import('quote','G','INT');
$poll = sed_import('poll','G','INT');
$vote = sed_import('vote','G','INT');
$unread_done = FALSE;
$filter_cats = FALSE;
//$ce = explode('_', $s); ??
$sys['sublocation'] = $L['Home'];

/* === Hook === */
$extp = sed_getextplugins('forums.sections.first');
if (is_array($extp))
	{ foreach($extp as $k => $pl) { include(SED_ROOT . '/plugins/'.$pl['pl_code'].'/'.$pl['pl_file'].'.php'); } }
/* ===== */

if ($n=='markall' && $usr['id']>0)
	{
	$sql = sed_sql_query("UPDATE $db_users set user_lastvisit='".$sys['now_offset']."' WHERE user_id='".$usr['id']."'");
	$usr['lastvisit'] = $sys['now_offset'];
	}

$sql = sed_sql_query("SELECT s.*, n.* FROM $db_forum_sections AS s LEFT JOIN
	$db_forum_structure AS n ON n.fn_code=s.fs_category WHERE fs_parentcat = '0'
    ORDER BY fs_parentcat ASC, fn_path ASC, fs_order ASC");

// All subforums	

$sql2 = sed_sql_query("SELECT fs_id, fs_title, fs_desc, fs_icon, fs_parentcat, fs_lt_id, fs_lt_title, fs_lt_date, fs_lt_posterid, fs_lt_postername 
	FROM $db_forum_sections WHERE fs_parentcat > 0 ORDER BY fs_order ASC");

while ($fsn_sub = sed_sql_fetchassoc($sql2))
	{	
		$forum_subforums[$fsn_sub['fs_id']] = $fsn_sub;
	}

//---

if (!isset($sed_sections_act))
	{
	$sed_sections_act = array();
	$timeback = $sys['now'] - 604800;
	$sqlact = sed_sql_query("SELECT fs_id FROM $db_forum_sections");
	while ($tmprow = sed_sql_fetchassoc($sqlact))
		{
		$section = $tmprow['fs_id'];
		$sqltmp = sed_sql_query("SELECT COUNT(*) FROM $db_forum_posts WHERE fp_creation>'$timeback' AND fp_sectionid='$section'");
		$sed_sections_act[$section] = sed_sql_result($sqltmp, 0, "COUNT(*)");
		}
	sed_cache_store('sed_sections_act', $sed_sections_act, 600);
	}

if (!isset($sed_sections_vw))
	{
	$sed_sections_vw = array();
	$sqltmp = sed_sql_query("SELECT online_subloc, COUNT(*) FROM $db_online WHERE online_location='Forums' GROUP BY online_subloc");
	while ($tmprow = sed_sql_fetchassoc($sqltmp))
		{
		$sed_sections_vw[$tmprow['online_subloc']] = $tmprow['COUNT(*)'];
		}
	sed_cache_store('sed_sections_vw', $sed_sections_vw, 120);
	}

$secact_max = max($sed_sections_act);

$out['markall'] = ($usr['id']>0) ? "<a href=\"".sed_url("forums","n=markall")."\">".$L['for_markallasread']."</a>" : '';

$out['subtitle'] = $L['Forums'];
$title_tags[] = array('{MAINTITLE}', '{SUBTITLE}', '{TITLE}');
$title_tags[] = array('%1$s', '%2$s', '%3$s');
$title_data = array($cfg['maintitle'], $cfg['subtitle'], $out['subtitle']);
$out['subtitle'] = sed_title('forumstitle', $title_tags, $title_data);

// ---------- Breadcrumbs
$urlpaths = array();
$urlpaths[sed_url("forums")] = $L['Forums'];

/* ===== */
$out['canonical_url'] = ($cfg['absurls']) ? sed_url("forums") : $sys['abs_url'].sed_url("forums");
/* ===== */

/* === Hook === */
$extp = sed_getextplugins('forums.sections.main');
if (is_array($extp))
	{ foreach($extp as $k => $pl) { include(SED_ROOT . '/plugins/'.$pl['pl_code'].'/'.$pl['pl_file'].'.php'); } }
/* ===== */

require(SED_ROOT . "/system/header.php");

$mskin = "skins/".$skin."/forums.sections.tpl";
$t = new XTemplate($mskin);

$t->assign(array(
	"FORUMS_SECTIONS_TITLE" => "<a href=\"".sed_url("forums")."\">".$L['Forums']."</a>",
	"FORUMS_SECTIONS_SHORTTITLE" => $L['Forums'],
	"FORUMS_SECTIONS_PAGETITLE" => "<a href=\"".sed_url("forums")."\">".$L['Forums']."</a>",
	"FORUMS_SECTIONS_BREADCRUMBS" => sed_breadcrumbs($urlpaths),
	"FORUMS_SECTIONS_MARKALL" =>  $out['markall'],
	"FORUMS_SECTIONS_SEARCH" => sed_url("plug", "e=search&frm=1"),
	"FORUMS_SECTIONS_FOLDALL" => sed_url("forums", "c=fold", "#top"),
	"FORUMS_SECTIONS_UNFOLDALL" => sed_url("forums", "c=unfold", "#top"),
	"FORUMS_SECTIONS_GMTTIME" => $L['Alltimesare']." ".$usr['timetext'],
	"FORUMS_SECTIONS_WHOSONLINE" => $out['whosonline']." : ".$out['whosonline_reg_list']
));

/* === Hook - Part1 : Set === */
$extp = sed_getextplugins('forums.sections.loop');
/* ===== */

$catnum = 1;

while ($fsn = sed_sql_fetchassoc($sql)) //v178
	{
	$fsn_arr[$fsn['fn_id']][$fsn['fs_id']] = $fsn;
	$sect_arr[$fsn['fn_id']] = $fsn;
	
	}

// by structure extending
foreach ($sect_arr as $fsec_key => $fsec)
	{
	$cattitle = "<a href=\"javascript:sedjs.toggleblock('blk_".$fsec['fs_category']."')\">";
	$cattitle .= $sed_forums_str[$fsec['fs_category']]['tpath'];
	$cattitle .= "</a>";
	
	$lt_date = $fsec['fs_lt_date'];
	
	if ($c=='fold')
		{ $fold = TRUE; }
	elseif ($c=='unfold')
		{ $fold = FALSE; }
	elseif (!empty($c))
		{
		$fold = ($c == $fsec['fs_category']) ? FALSE : TRUE;
		}
	else
		{ $fold = (!$sed_forums_str[$fsec['fs_category']]['defstate']) ? TRUE : FALSE; }	
		
	$fsec['toggle_state'] = ($fold) ? " style=\"display:none;\"" : '';	
	$fsec['toggle_body'] = "id=\"blk_".$fsec['fs_category']."\" ".$fsec['toggle_state'];

	$t-> assign(array(
		"FORUMS_SECTIONS_ROW_CAT_TITLE" => $cattitle,
		"FORUMS_SECTIONS_ROW_CAT_ICON" => $fsec['fn_icon'],
		"FORUMS_SECTIONS_ROW_CAT_SHORTTITLE" => sed_cc($fsec['fn_title']),
		"FORUMS_SECTIONS_ROW_CAT_DESC" => sed_parse($fsec['fn_desc']),
		"FORUMS_SECTIONS_ROW_CAT_DEFSTATE" => sed_cc($fsec['fn_defstate']),
		"FORUMS_SECTIONS_ROW_CAT_TOGGLE" =>$fsec['toggle_body'],
		"FORUMS_SECTIONS_ROW_CAT_ID" => $fsec['fs_category']
	));	
		
	// by sections extending v178
	$fs_num = 0;
	foreach ($fsn_arr[$fsec_key] as $fsn_key => $fsn)
		{
		if (sed_auth('forums', $fsn['fs_id'], 'R'))
			{
			
			$fsn['fs_topiccount_all'] = $fsn['fs_topiccount'] + $fsn['fs_topiccount_pruned'];
			$fsn['fs_postcount_all'] = $fsn['fs_postcount'] + $fsn['fs_postcount_pruned'];
			$fsn['fs_newposts'] = '0';
			$fsn['fs_desc'] = sed_parse($fsn['fs_desc']);
			$fsn['fs_desc'] .= ($fsn['fs_state']) ? " ".$L['Locked'] : '';
						
			$sed_sections_vw_cur = (isset($sed_sections_vw[$fsn['fs_title']]) && $sed_sections_vw[$fsn['fs_title']]) ? $sed_sections_vw[$fsn['fs_title']] : "0";

			if (!$fsn['fs_lt_id'])
				{ sed_forum_sectionsetlast($fsn['fs_id']); }

			if ($usr['id']>0 && $fsn['fs_lt_date']>$usr['lastvisit'] && $fsn['fs_lt_posterid']!=$usr['id'])
				{
				$fsn['fs_title'] = "+ ".$fsn['fs_title'];
				$fsn['fs_newposts'] = '1';
				}

			if ($fsn['fs_lt_id']>0)
				{
				$fsn['fs_timago'] = sed_build_timegap($fsn['fs_lt_date'], $sys['now_offset']);
				$fsn['lastpost'] = ($usr['id']>0 && $fsn['fs_lt_date']>$usr['lastvisit'] && $fsn['fs_lt_posterid']!=$usr['id']) ? "<a href=\"".sed_url("forums","m=posts&q=".$fsn['fs_lt_id']."&n=unread", "#unread")."\">" : "<a href=\"".sed_url("forums","m=posts&q=".$fsn['fs_lt_id']."&n=last", "#bottom")."\">";
				$fsn['lastpost'] .= sed_cutstring($fsn['fs_lt_title'], 32)."</a>";
				}
			else
				{
				$fsn['fs_timago'] = '&nbsp;'; 
				$fsn['lastpost'] = '&nbsp;';
				$fsn['fs_lt_date'] = '&nbsp;';
				$fsn['fs_lt_postername'] = '';
				$fsn['fs_lt_posterid'] = 0;
				}

			$fsn['fs_lt_date'] = ($fsn['fs_lt_date']>0) ? sed_build_date($cfg['formatmonthdayhourmin'], $fsn['fs_lt_date']) : '';
			$fsn['fs_viewcount_short'] = ($fsn['fs_viewcount']>9999) ? floor($fsn['fs_viewcount']/1000)."k" : $fsn['fs_viewcount'];
			$fsn['fs_lt_postername'] = sed_build_user($fsn['fs_lt_posterid'], sed_cc($fsn['fs_lt_postername']));

			if (!$secact_max)
				{
				$section_activity = '';
				$section_activity_img = '';
				$secact_num = 0;
				}
			else
				{
				$secact_num = round(6.25 * $sed_sections_act[$fsn['fs_id']] / $secact_max);
				if ($secact_num>5) { $secact_num = 5; }
				if (!$secact_num && $sed_sections_act[$fsn['fs_id']]>1) { $secact_num = 1; }
				$section_activity_img = "<img src=\"skins/".$skin."/img/system/activity".$secact_num.".gif\" alt=\"\" />";
				}
			$fs_num++;

			$t-> assign(array(
				"FORUMS_SECTIONS_ROW_ID" => $fsn['fs_id'],
				"FORUMS_SECTIONS_ROW_CAT" => $fsn['fs_category'],
				"FORUMS_SECTIONS_ROW_STATE" => $fsn['fs_state'],
				"FORUMS_SECTIONS_ROW_ORDER" => $fsn['fs_order'],
				"FORUMS_SECTIONS_ROW_TITLE" => $fsn['fs_title'],
				"FORUMS_SECTIONS_ROW_DESC" => $fsn['fs_desc'],
				"FORUMS_SECTIONS_ROW_ICON" => $fsn['fs_icon'],
				"FORUMS_SECTIONS_ROW_TOPICCOUNT" => $fsn['fs_topiccount'],
				"FORUMS_SECTIONS_ROW_POSTCOUNT" => $fsn['fs_postcount'],
				"FORUMS_SECTIONS_ROW_TOPICCOUNT_ALL" => $fsn['fs_topiccount_all'],
				"FORUMS_SECTIONS_ROW_POSTCOUNT_ALL" => $fsn['fs_postcount_all'],
				"FORUMS_SECTIONS_ROW_VIEWCOUNT" => $fsn['fs_viewcount'],
				"FORUMS_SECTIONS_ROW_VIEWCOUNT_SHORT" => $fsn['fs_viewcount_short'],
				"FORUMS_SECTIONS_ROW_VIEWERS" => $sed_sections_vw_cur,
				"FORUMS_SECTIONS_ROW_URL" => sed_url("forums","m=topics&s=".$fsn['fs_id']),
				"FORUMS_SECTIONS_ROW_LASTPOSTDATE" => $fsn['fs_lt_date'],
				"FORUMS_SECTIONS_ROW_LASTPOSTER" => $fsn['fs_lt_postername'],
				"FORUMS_SECTIONS_ROW_LASTPOST" => $fsn['lastpost'],
				"FORUMS_SECTIONS_ROW_TIMEAGO" => $fsn['fs_timago'],
				"FORUMS_SECTIONS_ROW_ACTIVITY" => $section_activity_img,
				"FORUMS_SECTIONS_ROW_ACTIVITYVALUE" => $secact_num,
				"FORUMS_SECTIONS_ROW_NEWPOSTS" => $fsn['fs_newposts'],
				"FORUMS_SECTIONS_ROW_ODDEVEN" => sed_build_oddeven($fs_num),
				"FORUMS_SECTIONS_ROW" => $fsn
				));

			/* ============ For Subforums  Sed 172 ================== */
			if (isset($forum_subforums) && is_array($forum_subforums))
			{
			$ii = 0;
			foreach ($forum_subforums as $key => $row)
				{
				if ($forum_subforums[$key]['fs_parentcat'] == $fsn['fs_id'])
					{
					if ($row['fs_lt_date'] > $lt_date)
						{
						$fsnn = $forum_subforums[$key];
						$fsnn['fs_lt_date'] = sed_build_date($cfg['formatmonthdayhourmin'], $fsnn['fs_lt_date']);
						$fsnn['lastpost'] = ($usr['id']>0 && $fsnn['fs_lt_date']>$usr['lastvisit'] && $fsnn['fs_lt_posterid']!=$usr['id']) ? "<a href=\"".sed_url("forums", "m=posts&q=".$fsnn['fs_lt_id']."&n=unread", "#unread")."\">" : "<a href=\"".sed_url("forums", "m=posts&q=".$fsnn['fs_lt_id']."&n=last", "#bottom")."\">";
						$fsnn['lastpost'] .= sed_cutstring($fsnn['fs_lt_title'], 32)."</a>";
						$fsnn['fs_timago'] = sed_build_timegap($row['fs_lt_date'], $sys['now_offset']);

						$t-> assign(array(
							"FORUMS_SECTIONS_ROW_LASTPOSTDATE" => $fsnn['fs_lt_date'],
							"FORUMS_SECTIONS_ROW_LASTPOSTER" => sed_build_user($fsnn['fs_lt_posterid'], sed_cc($fsnn['fs_lt_postername'])),
							"FORUMS_SECTIONS_ROW_LASTPOST" => $fsnn['lastpost'],
							"FORUMS_SECTIONS_ROW_TIMEAGO" => $fsnn['fs_timago']
							));

						$lt_date = $row['fs_lt_date'];
						}
			   
					if ($usr['id']>0 && $row['fs_lt_date']>$usr['lastvisit'] && $row['fs_lt_posterid']!=$usr['id'])
						{
						$row['fs_title'] = "+ ".$row['fs_title'];
						}        

					$ii++;
					$t->assign(array(
						"FORUMS_SECTIONS_ROW_SUBFORUMS_ID" => $row['fs_id'],
						"FORUMS_SECTIONS_ROW_SUBFORUMS_TITLE" => $row['fs_title'],
						"FORUMS_SECTIONS_ROW_SUBFORUMS_DESC" => $row['fs_desc'],
						"FORUMS_SECTIONS_ROW_SUBFORUMS_ICON" => $row['fs_icon'],
						"FORUMS_SECTIONS_ROW_SUBFORUMS_URL" => sed_url("forums","m=topics&s=".$row['fs_id']),
						"FORUMS_SECTIONS_ROW_SUBFORUMS_ODDEVEN" => sed_build_oddeven($ii),
						"FORUMS_SECTIONS_ROW_SUBFORUMS_NUM" => $ii,
						"FORUMS_SECTIONS_ROW_SUBFORUMS" => $row
						));

					$t->parse("MAIN.FORUMS_SECTIONS_ROW.FORUMS_SECTIONS_ROW_SECTION.FORUMS_SECTIONS_ROW_SUBFORUMS.FORUMS_SECTIONS_ROW_SUBFORUMS_LIST");
				}
			}
				
				if ($ii > 0) {
					$t->parse("MAIN.FORUMS_SECTIONS_ROW.FORUMS_SECTIONS_ROW_SECTION.FORUMS_SECTIONS_ROW_SUBFORUMS");
				}
			}
			/* ============ ======== ================== */

			/* === Hook - Part2 : Include === */
			if (is_array($extp))
				{ foreach($extp as $k => $pl) { include(SED_ROOT . '/plugins/'.$pl['pl_code'].'/'.$pl['pl_file'].'.php'); } }
			/* ===== */

			$t->parse("MAIN.FORUMS_SECTIONS_ROW.FORUMS_SECTIONS_ROW_SECTION");
			}

		$catnum++;
		}
	$t->parse("MAIN.FORUMS_SECTIONS_ROW");	
	}

/* === Hook === */
$extp = sed_getextplugins('forums.sections.tags');
if (is_array($extp))
	{ foreach($extp as $k => $pl) { include(SED_ROOT . '/plugins/'.$pl['pl_code'].'/'.$pl['pl_file'].'.php'); } }
/* ===== */

$t->parse("MAIN");
$t->out("MAIN");

require(SED_ROOT . "/system/footer.php");

?>