navigation('topics');
}
elseif($view == 'posts')
{
$disp_posts = $forum_user['disp_posts'];
$result = $db->query('SELECT id FROM '.$db->prefix.'posts WHERE posted > '.$datestart.' AND posted < '.$dateend);
$num_replies = $db->num_rows($result);
$num_pages = ceil(($num_replies) / $disp_posts);
$p = (!isset($_GET['p']) || $_GET['p'] <= 1 || $_GET['p'] > $num_pages) ? 1 : $_GET['p'];
$start_from = $disp_posts * ($p - 1);
$pages = paginate($num_pages, $p, 'calendar.php?view=posts&date='.$year.'.'.$month.'.'.$day);
$result = $db->query('
SELECT
p.id, p.poster, p.poster_id, p.message, p.posted, p.topic_id,
t.id as tid, t.subject as tsub, t.forum_id,
f.id as fid, f.forum_name as fname
FROM '.$db->prefix.'posts AS p
INNER JOIN '.$db->prefix.'topics AS t ON p.topic_id=t.id
INNER JOIN '.$db->prefix.'forums AS f ON t.forum_id=f.id
LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$forum_user['g_id'].')
WHERE
p.posted > '.$datestart.' AND
p.posted < '.$dateend.' AND
(fp.read_forum IS NULL OR fp.read_forum=1)
ORDER BY p.posted LIMIT '.$start_from.','.$disp_posts
)or error('Unable to fetch topic list for forum', __FILE__, __LINE__, $db->error());
?>
navigation('posts');
}
elseif($view == 'bday')
{
$result = $db->query('SELECT id, username, use_avatar, last_post, registered, birthday, DAYOFMONTH(birthday) as day FROM '.$db->prefix.'users WHERE DAYOFMONTH(birthday) = '.$day.' AND MONTH(birthday) = '.$month.' ORDER BY username') or error('Unable to fetch birtday list', __FILE__, __LINE__, $db->error());
?>
navigation('bday');
}
elseif($view == 'event')
{
$stype = (isset($_GET['id']))? 'e.id = '.intval($_GET['id']) : 'dayofmonth(e.date) = '.$day.' AND month(e.date) = '.$month ;
$result = $db->query('SELECT e.id, e.date, e.title, e.user_id, e.body, u.username as username, u.num_posts as posts, u.registered as reg, g.g_title as group_id FROM '.$db->prefix.'calendar AS e INNER JOIN '.$db->prefix.'users AS u ON e.user_id=u.id LEFT JOIN '.$db->prefix.'groups AS g ON u.group_id=g.g_id WHERE '.$stype) or error('Unable to fetch event list', __FILE__, __LINE__, $db->error());
?>
}
else
{
if($type == "posts")
{
$result = $db->query('SELECT t.posted FROM '.$db->prefix.'topics as t LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=t.forum_id AND fp.group_id='.$forum_user['g_id'].') WHERE t.posted > '.$month_start.' AND t.posted < '.$month_end.' AND (fp.read_forum IS NULL OR fp.read_forum=1)') or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());
$topic = array(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
while($topic_list = $db->fetch_row($result))
{
$time = date("j",$topic_list[0]);
$topic[$time]++;
};
$result = $db->query('SELECT p.posted FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON p.topic_id=t.id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=t.forum_id AND fp.group_id='.$forum_user['g_id'].') WHERE p.posted > '.$month_start.' AND p.posted < '.$month_end.' AND (fp.read_forum IS NULL OR fp.read_forum=1)') or error('Unable to fetch posts list', __FILE__, __LINE__, $db->error());
$posts = array(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
while($post_list = $db->fetch_assoc($result))
{
$time = date('j',$post_list['posted']);
$posts[$time]++;
};
}
elseif($type == "events")
{
$result = $db->query('SELECT DAYOFMONTH(birthday) as day, username FROM '.$db->prefix.'users WHERE MONTH(birthday) = '.$month) or error('Unable to fetch birtday list', __FILE__, __LINE__, $db->error());
$bdays = array('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');
while($bday_list = $db->fetch_assoc($result))
{
if(count($bday_list)>3) $bdays[$bday_list['day']]++;
else $bdays[$bday_list['day']] .="".$bday_list['username']."'s ".$lang_calendar['Birthday']." ";
};
$result = $db->query('SELECT id, title, DAYOFMONTH(date) as day FROM '.$db->prefix.'calendar WHERE MONTH(date) = '.$month.' AND (YEAR(date) = '.$year.' OR YEAR(date) = "0000")') or error('Unable to fetch calendar dates', __FILE__, __LINE__, $db->error());
$dates = array('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');
while($dates_list = $db->fetch_assoc($result))
{
$dates[$dates_list['day']] .= "".$dates_list['title']." ";
};
}
?>