<h2>Editing File: /var/softaculous/fud/default/draw_forum_list.inc</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php
/**
* copyright            : (C) 2001-2018 Advanced Internet Designs Inc.
* email                : forum@prohost.org
* $Id$
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; version 2 of the License.
**/

	$collapse = $usr-&gt;cat_collapse_status ? unserialize($usr-&gt;cat_collapse_status) : array();
	$cat_id = !empty($_GET['cat'])    ? (int) $_GET['cat']    : 0;
	$frm_id = !empty($_GET['frm_id']) ? (int) $_GET['frm_id'] : 0;

	if ($cat_id &amp;&amp; !empty($collapse[$cat_id])) {
		$collapse[$cat_id] = 0;
	}

	require $FORUM_SETTINGS_PATH .'idx.inc';
	if (!isset($cidxc[$cat_id])) {
		$cat_id = 0;
	}

	$cbuf = $forum_list_table_data = $cat_path = '';

	if ($cat_id) {
		$cid = $cat_id;
		while (($cid = $cidxc[$cid][4]) &gt; 0) {
			$cat_path = '&amp;nbsp;&amp;raquo; &lt;a href=&quot;[[relativeurl]]/index.php?t=i&amp;amp;cat='.$cid.'&amp;amp;'._rsid.'&quot;&gt;'.$cidxc[$cid][1].'&lt;/a&gt;'. $cat_path;
		}
		$cat_path = '&lt;br /&gt;
&lt;a href=&quot;[[relativeurl]]/index.php?t=i&amp;amp;'._rsid.'&quot;&gt;Home&lt;/a&gt;
'.$cat_path.'&amp;nbsp;&amp;raquo; &lt;b&gt;'.$cidxc[$cat_id][1].'&lt;/b&gt;';
	}

	/* List of fetched fields &amp; their ids
	  0	msg.subject,
	  1	msg.id AS msg_id,
	  2	msg.post_stamp,
	  3	users.id AS user_id,
	  4	users.alias
	  5	forum.cat_id,
	  6	forum.forum_icon
	  7	forum.id
	  8	forum.last_post_id
	  9	forum.moderators
	  10	forum.name
	  11	forum.descr
	  12	forum.url_redirect
	  13	forum.post_count
	  14	forum.thread_count
	  15	forum_read.last_view
	  16	is_moderator
	  17	read perm
	  18	is the category using compact view
	*/
	$c = uq('SELECT
				m.subject, m.id, m.post_stamp,
				u.id, u.alias,
				f.cat_id, f.forum_icon, f.id, f.last_post_id, f.moderators, f.name, f.descr, f.url_redirect, f.post_count, f.thread_count,
				'. (_uid ? 'fr.last_view, mo.id, COALESCE(g2.group_cache_opt, g1.group_cache_opt) AS group_cache_opt' : '0,0,g1.group_cache_opt') .',
				c.cat_opt
			FROM fud30_fc_view v
			INNER JOIN fud30_cat c ON c.id=v.c
			INNER JOIN fud30_forum f ON f.id=v.f
			INNER JOIN fud30_group_cache g1 ON g1.user_id='. (_uid ? 2147483647 : 0) .' AND g1.resource_id=f.id
			LEFT JOIN fud30_msg m ON f.last_post_id=m.id
			LEFT JOIN fud30_users u ON u.id=m.poster_id '.
			(_uid ? ' LEFT JOIN fud30_forum_read fr ON fr.forum_id=f.id AND fr.user_id='. _uid .' LEFT JOIN fud30_mod mo ON mo.user_id='. _uid .' AND mo.forum_id=f.id LEFT JOIN fud30_group_cache g2 ON g2.user_id='. _uid .' AND g2.resource_id=f.id' : '').
			' WHERE f.parent = '. $frm_id .
			((!$is_a || $cat_id) ?  ' AND ' : '') .
			($is_a ? '' : (_uid ? ' (mo.id IS NOT NULL OR ('. q_bitand('COALESCE(g2.group_cache_opt, g1.group_cache_opt)', 1) .' &gt; 0))' : ' ('. q_bitand('g1.group_cache_opt', 1) .' &gt; 0)')) .
			($cat_id ? ($is_a ? '' : ' AND ') .' v.c IN('. implode(',', ($cf = $cidxc[$cat_id][5])) .') ' : '') .' ORDER BY v.id');

	$post_count = $thread_count = $last_msg_id = $cat = 0;
	while ($r = db_rowarr($c)) {
		/* Increase thread &amp; post count. */
		$post_count += $r[13];
		$thread_count += $r[14];

		$cid = (int) $r[5];

		if ($cat != $cid &amp;&amp; !$frm_id) {
			if ($cbuf) { /* If previous category was using compact view, print forum row. */
				if (empty($collapse[$i[4]])) { /* Only show if parent is not collapsed as well. */
					$forum_list_table_data .= '&lt;tr class=&quot;row child-c'.$cat.'&quot;&gt;
	&lt;td class=&quot;RowStyleA wo hide2&quot;&gt;&amp;nbsp;&lt;/td&gt;
	&lt;td class=&quot;RowStyleB ac wo hide2&quot;&gt;&amp;nbsp;&lt;/td&gt;
	&lt;td  class=&quot;RowStyleA wa&quot; colspan=&quot;4&quot;&gt;Available Forums:'.$cbuf.'&lt;/td&gt;
&lt;/tr&gt;';
				}
				$cbuf = '';
			}

			foreach ($cidxc as $k =&gt; $i) {
				/* 2nd check ensures that we don't end up displaying categories without any children. */ 
				if (($cat_id &amp;&amp; !isset($cf[$k])) || ($cid != $k &amp;&amp; $i[4] &gt;= $cidxc[$cid][4])) {
					continue;
				}

				/* If parent category is collapsed, hide child category. */
				if ($i[4] &amp;&amp; !empty($collapse[$i[4]])) {
					$collapse[$k] = 1;
				}

				if ($k == $cid) {
					break;	// Got it!
				}
			}
			$cat = $cid;
			if ($i[3] &amp; 1 &amp;&amp; $k != $cat_id &amp;&amp; !($i[3] &amp; 4)) {
				if (!isset($collapse[$k])) {
					$collapse[$k] = !($i[3] &amp; 2);
				}
				$forum_list_table_data .= '&lt;tr id=&quot;c'.$r[5].'&quot; style=&quot;display: table-row;&quot;&gt;
	&lt;td class=&quot;CatDesc '.(empty($collapse[$cid]) ? 'expanded' : 'collapsed' )  .'&quot; colspan=&quot;5&quot; style=&quot;padding-left: '.($i[0] ? $i[0] * 20 : '0').'px;&quot;&gt;
		&lt;a href=&quot;[[relativeurl]]/index.php?t=index&amp;amp;cat='.$k.'&amp;amp;'._rsid.'&quot; class=&quot;CatLink&quot;&gt;'.$i[1].'&lt;/a&gt; '.$i[2].'
	&lt;/td&gt;
	&lt;td class=&quot;CatDesc hide1&quot;&gt;
	'.(key($cidxc) ? '&lt;a href=&quot;javascript://&quot; onclick=\'nextCat(&quot;c'.$k.'&quot;)\'&gt;&lt;img src=&quot;[[relativeurl]]/theme/default/images/down.png&quot; alt=&quot;&quot; width=&quot;16&quot; height=&quot;11&quot; border=&quot;0&quot; style=&quot;vertical-align: top; float: right;&quot; /&gt;&lt;/a&gt;' : '' )  .'
	'.($cat ? '&lt;a href=&quot;javascript://&quot; onclick=\'prevCat(&quot;c'.$k.'&quot;)\'&gt;&lt;img src=&quot;[[relativeurl]]/theme/default/images/up.png&quot; border=&quot;0&quot; alt=&quot;&quot; width=&quot;16&quot; height=&quot;11&quot; style=&quot;vertical-align: top; float: right;&quot; /&gt;&lt;/a&gt;' : '' )  .'
&lt;/td&gt;
&lt;/tr&gt;';
			} else {
				if ($i[3] &amp; 4) {
					++$i[0];
				}
				$forum_list_table_data .= '&lt;tr id=&quot;c'.$r[5].'&quot; style=&quot;display: table-row;&quot;&gt;
	&lt;td class=&quot;CatDesc CatLockPad&quot; colspan=&quot;5&quot; style=&quot;padding-left: '.($i[0] ? $i[0] * 20 : '0').'px;&quot;&gt;
		&lt;span class=&quot;CatLockedName&quot;&gt;&lt;a href=&quot;[[relativeurl]]/index.php?t=index&amp;amp;cat='.$k.'&amp;amp;'._rsid.'&quot; class=&quot;CatLink&quot;&gt;'.$i[1].'&lt;/a&gt;&lt;/span&gt; '.$i[2].'
	&lt;/td&gt;
	&lt;td class=&quot;CatDesc hide1&quot;&gt;
	'.(key($cidxc) ? '&lt;a href=&quot;javascript://&quot; onclick=\'nextCat(&quot;c'.$k.'&quot;)\'&gt;&lt;img src=&quot;[[relativeurl]]/theme/default/images/down.png&quot; alt=&quot;&quot; width=&quot;16&quot; height=&quot;11&quot; border=&quot;0&quot; style=&quot;vertical-align: top; float: right;&quot; /&gt;&lt;/a&gt;' : '' )  .'
	'.($cat ? '&lt;a href=&quot;javascript://&quot; onclick=\'prevCat(&quot;c'.$k.'&quot;)\'&gt;&lt;img src=&quot;[[relativeurl]]/theme/default/images/up.png&quot; border=&quot;0&quot; alt=&quot;&quot; width=&quot;16&quot; height=&quot;11&quot; style=&quot;vertical-align: top; float: right;&quot; /&gt;&lt;/a&gt;' : '' )  .'
&lt;/td&gt;
&lt;/tr&gt;';
			}
		}

		/* Compact category view (ignore when expanded). */
		if ($r[18] &amp; 4 &amp;&amp; $cat_id != $cid) {
			$cbuf .= '&amp;nbsp; '.(_uid &amp;&amp; $r[15] &lt; $r[2] &amp;&amp; $usr-&gt;last_read &lt; $r[2] ? '**' : '' )  .'
&lt;a href=&quot;'.(empty($r[12]) ? '[[relativeurl]]/index.php?t='.t_thread_view.'&amp;amp;frm_id='.$r[7].'&amp;amp;'._rsid.'' : ''.$r[12].'' )  .'&quot;&gt;'.$r[10].'&lt;/a&gt;';
			continue;
		}

		/* Visible forum with no 'read' permission. */
		if (!($r[17] &amp; 2) &amp;&amp; !$is_a &amp;&amp; !$r[16]) {
			$forum_list_table_data .= '&lt;tr style=&quot;display: '.(empty($collapse[$cid]) ? 'table-row' : 'none' )  .'&quot; class=&quot;child-c'.$r[5].'&quot;&gt;
	&lt;td class=&quot;RowStyleA&quot; colspan=&quot;6&quot;&gt;'.$r[10].($r[11] ? '&lt;br /&gt;'.$r[11] : '').'&lt;/td&gt;
&lt;/tr&gt;';
			continue;
		}

		/* Code to determine the last post id for 'latest' forum message. */
		if ($r[8] &gt; $last_msg_id) {
			$last_msg_id = $r[8];
		}

		if (!_uid) { /* Anon user. */
			$forum_read_indicator = '&lt;img title=&quot;Only registered forum members can track read &amp;amp; unread messages&quot; src=&quot;[[relativeurl]]/theme/default/images/existing_content.png&quot; alt=&quot;Only registered forum members can track read &amp;amp; unread messages&quot; width=&quot;30&quot; height=&quot;30&quot; /&gt;';
		} else if ($r[15] &lt; $r[2] &amp;&amp; $usr-&gt;last_read &lt; $r[2]) {
			$forum_read_indicator = '&lt;img title=&quot;New messages&quot; src=&quot;[[relativeurl]]/theme/default/images/new_content.png&quot; alt=&quot;New messages&quot; width=&quot;30&quot; height=&quot;30&quot; /&gt;';
		} else {
			$forum_read_indicator = '&lt;img title=&quot;No new messages&quot; src=&quot;[[relativeurl]]/theme/default/images/existing_content.png&quot; alt=&quot;No new messages&quot; width=&quot;30&quot; height=&quot;30&quot; /&gt;';
		}

		if ($r[9] &amp;&amp; ($mods = unserialize($r[9]))) {
			$moderators = '';	// List of forum moderators.
			$modcount = 0;		// Use singular or plural message form.

			foreach($mods as $k =&gt; $v) {
				$moderators .= '&lt;a href=&quot;[[relativeurl]]/index.php?t=usrinfo&amp;amp;id='.$k.'&amp;amp;'._rsid.'&quot;&gt;'.$v.'&lt;/a&gt; &amp;nbsp;';
				$modcount++;
			}
			$moderators = '&lt;div class=&quot;TopBy&quot;&gt;&lt;b&gt;'.convertPlural($modcount, array('Moderator','Moderators')).':&lt;/b&gt; '.$moderators.'&lt;/div&gt;';
		} else {
			$moderators = '&amp;nbsp;';
		}

		$forum_list_table_data .= '&lt;tr style=&quot;display: '.(empty($collapse[$cid]) ? 'table-row' : 'none' )  .'&quot; class=&quot;row child-c'.$r[5].'&quot;&gt;
	&lt;td class=&quot;RowStyleA wo hide2&quot;&gt;'.($r[6] ? '&lt;img src=&quot;[[relativeurl]]/images/forum_icons/'.$r[6].'&quot; alt=&quot;Forum Icon&quot; /&gt;' : '&amp;nbsp;' ) .'&lt;/td&gt;
	&lt;td class=&quot;RowStyleB ac wo hide2&quot;&gt;'.(empty($r[12]) ? ''.$forum_read_indicator.'' : '&lt;img title=&quot;Redirection&quot; src=&quot;[[relativeurl]]/theme/default/images/moved.png&quot; alt=&quot;&quot; /&gt;' )  .'&lt;/td&gt;
	&lt;td class=&quot;RowStyleA wa&quot;&gt;&lt;a href=&quot;'.(empty($r[12]) ? '[[relativeurl]]/index.php?t='.t_thread_view.'&amp;amp;frm_id='.$r[7].'&amp;amp;'._rsid.'' : ''.$r[12].'' )  .'&quot; class=&quot;big&quot;&gt;'.$r[10].'&lt;/a&gt;'.($r[11] ? '&lt;br /&gt;'.$r[11] : '').$moderators.'&lt;/td&gt;
	&lt;td class=&quot;RowStyleB ac hide1&quot;&gt;'.(empty($r[12]) ? ''.$r[13].'' : '--' )  .'&lt;/td&gt;
	&lt;td class=&quot;RowStyleB ac hide1&quot;&gt;'.(empty($r[12]) ? ''.$r[14].'' : '--' )  .'&lt;/td&gt;
	&lt;td class=&quot;RowStyleA ac nw hide2&quot;&gt;'.(empty($r[12]) ? ''.($r[8] ? '&lt;span class=&quot;DateText&quot;&gt;'.print_date('%a, %d %B %Y', $r[2]).'&lt;/span&gt;&lt;br /&gt;By: '.($r[3] ? '&lt;a href=&quot;[[relativeurl]]/index.php?t=usrinfo&amp;amp;id='.$r[3].'&amp;amp;'._rsid.'&quot;&gt;'.$r[4].'&lt;/a&gt;' : ''.$GLOBALS['ANON_NICK'].'' ) .' &lt;a href=&quot;[[relativeurl]]/index.php?t='.d_thread_view.'&amp;amp;goto='.$r[8].'&amp;amp;'._rsid.'#msg_'.$r[8].'&quot;&gt;&lt;img title=&quot;'.$r[0].'&quot; src=&quot;[[relativeurl]]/theme/default/images/goto.gif&quot; alt=&quot;'.$r[0].'&quot; width=&quot;9&quot; height=&quot;9&quot; /&gt;&lt;/a&gt;' : 'n/a' ) .'' : '--' )  .'&lt;/td&gt;
&lt;/tr&gt;';
	}
	unset($c);

	if ($cbuf) { /* If previous category was using compact view, print forum row. */
		$forum_list_table_data .= '&lt;tr class=&quot;row child-c'.$cat.'&quot;&gt;
	&lt;td class=&quot;RowStyleA wo hide2&quot;&gt;&amp;nbsp;&lt;/td&gt;
	&lt;td class=&quot;RowStyleB ac wo hide2&quot;&gt;&amp;nbsp;&lt;/td&gt;
	&lt;td  class=&quot;RowStyleA wa&quot; colspan=&quot;4&quot;&gt;Available Forums:'.$cbuf.'&lt;/td&gt;
&lt;/tr&gt;';
	}

?&gt;
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fvar%2Fsoftaculous%2Ffud%2Fdefault'>Back to Directory</a>