public function __construct()
{
$expired = time() - Lib::GetSetting('sess.gc_maxlifetime');
$users = DBA::Open()->Query("SELECT * FROM " . USERS . " WHERE birthday != 0");
$this->count = $users->NumRows();
$this->users = $users->GetIterator();
$this->i = 1;
}
public function Current()
{
$temp = $this->users->Current();
// todo format datre
$temp['created'] = date("d-m-y", $temp['created']);
if ($temp['seen'] >= time() - Lib::GetSetting('sess.gc_maxlifetime')) {
$temp['online_status'] = $this->lang['L_ONLINE'];
} else {
$temp['online_status'] = $this->lang['L_OFFLINE'];
}
$temp['avatar'] = $temp['avatar'] != '' && $temp['avatar'] != 0 ? '<img src="Uploads/Avatars/' . $temp['id'] . '.gif" border="0" alt="" />' : NULL;
return $temp;
}
public function Execute(Template $template, Session $session, $request)
{
$forum = new Forum();
//foreach(DBA::Open()->Query("SELECT * FROM ". SESSIONS) as $s) { print_r($s); }
//$rows = $forum->getForums((@$session['user']['perms'] & ADMIN));
/* Set the templates */
$template->content = array('file' => 'forums.html');
if ($template['WOLenable'] == 1) {
$template->users_online = array('file' => 'online_users.html');
}
if ($template['showbirthdays'] == 1) {
$template->todays_bdays = array('file' => 'birthdays.html');
}
$suspend = $session['user']['perms'] & ADMIN ? 1 : 0;
/* Set the forums and categoris */
$template->categories = new ForumList(FALSE, $suspend);
/* Set the title of the page */
$template['title'] = $template['L_HOME'];
$expired = time() - Lib::GetSetting('sess.gc_maxlifetime');
/* Display message for unlogged users */
if ($session['user'] instanceof Guest) {
$template['welcome_title'] = sprintf($template['L_WELCOMETITLE'], $template['forum_description']);
// you can use forum_name here instead
$template['welcome_msg'] = $template['L_WELCOMEMESSAGE'];
} else {
$template->welcome_msg = array('hide' => TRUE);
}
/* Set the online users list */
if ($template['displayloggedin'] == 1) {
$template->online_users = new Online_Users();
}
if ($template['showbirthdays'] == 1) {
$template->birthdays = new Birthdays();
}
//DBA::Open()->Execute("delete from k4_pmsgs");
//echo DBA::Open()->GetValue("select count(*) from k4_pmsgs");
//print_r(DBA::Open()->GetRow("SELECT * FROM ". FORUMS ." WHERE row_left = 1"));
//foreach(DBA::Open()->Query("SELECT * FROM ". POSTS ." WHERE row_left < 0 OR row_right < 0") as $t) { print_r($t); }
$stats = DBA::Open()->GetRow("SELECT (SELECT COUNT(*) FROM " . USERS . " WHERE invisible = 0) AS num_members, (SELECT COUNT(s.uid) FROM " . USERS . " u, " . SESSIONS . " s WHERE u.invisible = 1 AND u.id = s.uid) AS num_invisible, (SELECT MAX(id) FROM " . USERS . ") AS newest_uid, (SELECT name FROM " . USERS . " ORDER BY created DESC LIMIT 1) AS newest_user, (SELECT COUNT(*) FROM " . USERS . " WHERE seen >= {$expired}) AS num_online, (SELECT COUNT(*) FROM " . POSTS . ") AS num_articles, (SELECT COUNT(*) FROM " . SESSIONS . ") AS num_total FROM " . USERS);
/* Set the board statistics */
$template['newest_member'] = sprintf($template['L_NEWESTMEMBER'], $stats['newest_uid'], $stats['newest_user']);
$template['total_posts'] = sprintf($template['L_TOTALPOSTS'], $stats['num_articles']);
$template['total_users'] = sprintf($template['L_TOTALUSERS'], $stats['num_members']);
$guests = $stats['num_total'] - $stats['num_online'] < 0 ? 0 : $stats['num_total'] - $stats['num_online'];
$guests = $template['WOLguests'] == 1 ? $guests : '--';
$template['online_stats'] = sprintf($template['L_ONLINEUSERSTATS'], $stats['num_total'], $stats['num_online'], $guests, $stats['num_invisible']);
/* Set the number of queries */
$template['num_queries'] = $session->dba->num_queries;
return TRUE;
}
public function Execute(Template $template, Session $session, $request)
{
// view a member's profile
if (isset($request['id'])) {
$id = intval($request['id']);
/* Chck if we're trying to look at the gues user */
if ($id == 0) {
return new Error($template['L_USERDOESNTEXIST'], $template);
}
/* Get our user from the db */
$user = DBA::Open()->GetRow("SELECT * FROM " . USERS . " WHERE id = {$id}");
/* If our user has admin perms, use a different tamplate */
if ($session['user']['perms'] & ADMIN) {
$template->content = array('file' => 'admin/member.html');
} else {
$template->content = array('file' => 'member.html');
}
/* set the user info template variables */
$template['id'] = $user['id'];
$template['name'] = $user['name'];
$template['email'] = $user['email'];
$template['posts'] = $user['posts'];
$template['created'] = relative_time($user['created']);
$template['rank'] = $user['rank'];
if ($template['displayemails'] == 1) {
$template->email_link = array('hide' => TRUE);
} else {
if ($template['displayemails'] == 0) {
$template->email_address = array('hide' => TRUE);
}
}
/* Set the last seen time */
$user['seen'] = $user['seen'] == 0 ? time() : $user['seen'];
$user['last_seen'] = $user['last_seen'] == 0 ? time() : $user['last_seen'];
$template['seen'] = $user['seen'] >= time() - Lib::GetSetting('sess.gc_maxlifetime') ? relative_time($user['seen']) : relative_time($user['last_seen']);
/* Set the user's online status field on the template */
if ($user['seen'] >= time() - Lib::GetSetting('sess.gc_maxlifetime')) {
$template['online_status'] = $template['L_ONLINE'];
} else {
$template['online_status'] = $template['L_OFFLINE'];
}
}
/* Set the number of queries */
$template['num_queries'] = $session->dba->num_queries;
return TRUE;
}
public function Current()
{
$row = $this->post_info->Current();
$this->count++;
$row['count'] = $this->count;
$row['created'] = relative_time($row['created']);
if ($row['poster_id'] != 0) {
$user = $this->dba->GetRow("SELECT * FROM " . USERS . " WHERE id = " . $row['poster_id']);
if ($user['seen'] >= time() - Lib::GetSetting('sess.gc_maxlifetime')) {
$row['online_status'] = $this->lang['L_ONLINE'];
} else {
$row['online_status'] = $this->lang['L_OFFLINE'];
}
$row['user_num_posts'] = $user['posts'];
$row['user_rank'] = $user['rank'] != '' ? $user['rank'] : '--';
$row['avatar'] = $user['avatar'] != '' && $user['avatar'] != 0 ? '<img src="Uploads/Avatars/' . $user['id'] . '.gif" border="0" alt="" />' : ' ';
$row['signature'] = $user['signature'] != '' && !is_null($user['signature']) && $row['allow_sigs'] == 1 ? '<br /><br />' . stripslashes($user['signature']) : ' ';
} else {
$row['poster_name'] = $this->lang['L_ADMINISTRATOR'];
$row['online_status'] = '--';
$row['user_num_posts'] = '--';
$row['user_rank'] = '--';
}
$row['name'] = stripslashes($row['name']);
$row['name'] = $row['member_has_read'] == 0 ? '<span class="text-decoration:italic;">' . $row['name'] . '</span>' : $row['name'];
$row['display'] = $this->pm['num_children'] == $this->count - 1 || $row['member_has_read'] == 0 ? 'block' : 'none';
$bbcode = new BBParser(stripslashes($row['body_text']), TRUE);
//$row['quoted_text'] = str_replace("\r\n", '\n', addslashes($bbcode->Revert($row['body_text'])));
$row['body_text'] = $bbcode->QuickExecute();
return $row;
}
public function __construct()
{
$expired = time() - Lib::GetSetting('sess.gc_maxlifetime');
$this->users = DBA::Open()->Query("SELECT * FROM " . USERS . " WHERE seen >= {$expired} AND invisible = 0")->GetIterator();
}
public function Current()
{
$row = $this->post_info->Current();
$this->count++;
$row['count'] = $this->count;
$row['created'] = relative_time($row['created']);
if ($row['poster_id'] != 0) {
$user = $this->dba->GetRow("SELECT * FROM " . USERS . " WHERE id = " . $row['poster_id']);
if ($user['seen'] >= time() - Lib::GetSetting('sess.gc_maxlifetime')) {
$row['online_status'] = $this->lang['L_ONLINE'];
} else {
$row['online_status'] = $this->lang['L_OFFLINE'];
}
$row['user_num_posts'] = $user['posts'];
$row['user_rank'] = $user['rank'] != '' ? $user['rank'] : '--';
$row['avatar'] = $user['avatar'] != '' && $user['avatar'] != 0 && $row['allow_avatars'] == 1 ? '<img src="Uploads/Avatars/' . $user['id'] . '.gif" border="0" alt="" />' : ' ';
$row['signature'] = $user['signature'] != '' && !is_null($user['signature']) && $row['allow_sigs'] == 1 ? '<br /><br />' . stripslashes($user['signature']) : ' ';
/* Set the user ranks */
$row['user_ranks'] = '';
foreach ($this->dba->Query("SELECT * FROM " . RANKS . " WHERE group_id = (SELECT group_id FROM " . USER_IN_GROUP . " WHERE id = " . $user['id'] . ")") as $rank) {
$row['user_ranks'] .= $rank['rank'] . ' <br />';
}
foreach ($this->dba->Query("SELECT * FROM " . RANKS . " WHERE user_id = " . $user['id']) as $rank) {
$row['user_ranks'] .= $rank['rank'] . ' <br />';
}
if ($this->session['user']['perms'] & ADMIN) {
$row['delete'] = '<a href="admin.php?act=delete_single&type=1&id=' . $row['id'] . '"><img src="Images/' . $this->settings['imageset'] . '/Buttons/delete.gif" alt="" border="0" /></a>';
}
} else {
$row['online_status'] = '--';
$row['user_num_posts'] = '--';
$row['user_rank'] = '--';
$row['user_ranks'] = '';
}
$row['name'] = stripslashes($row['name']);
$bbcode = new BBParser(stripslashes($row['body_text']), TRUE);
$row['body_text'] = $bbcode->QuickExecute();
$row['edited'] = intval($row['edited']) != 0 ? '<br /><br /><span class="smalltext"><em>' . $this->lang['L_EDITEDON'] . ' ' . date("F j, Y, g:i a", $row['edited']) . '</em></span>' : ' ';
return $row;
}
