function getMovements()
{
global $db;
global $login;
$result = $db->selectList($this->table, "*", "`userid`=" . $login->currentUserID(), "`timestamp` DESC");
if (count($result) > 0) {
foreach ($result as $i => $r) {
$result[$i]['time'] = timeElapsed($r['timestamp']);
}
}
return $result;
}
function listActive()
{
global $db;
global $config;
$limit = (int) $config->get('login', 'session-time');
$tbl_users = MYSQL_TABLE_PREFIX . 'users';
$time = time() - $limit;
$sql = "SELECT * FROM `" . $tbl_users . "` WHERE `lastaction`>=" . $time;
$result = $db->query($sql);
while ($row = mysql_fetch_assoc($result)) {
$row['str_lastaction'] = timeElapsed($row['lastaction']);
$row['url'] = makeURL('profile', array('userid' => $row['userid']));
$list[] = $row;
}
return $list;
}
function makeNews(&$comments, &$db, $table, $tbl_users, $start, $end, $title)
{
global $lng;
$news = '';
$result = $db->query("SELECT * FROM `" . $table . "`, `" . $tbl_users . "`\r\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE `" . $table . "`.`userid` = `" . $tbl_users . "`.`userid` \r\n\t\t\t\t\t\t\t\t\t\t\t\tAND `timestamp`>" . $start . " \r\n\t\t\t\t\t\t\t\t\t\t\t\tAND `timestamp`<" . $end . " \r\n\t\t\t\t\t\t\t\t\t\t\t\tAND (`language` = '" . secureMySQL($lng) . "' OR `language` = '')\r\n\t\t\t\t\t\t\t\t\t\t\t\tAND (`domainid` = 0 OR `domainid` = " . getCurrentDomainIndex() . ")\r\n\t\t\t\t\t\t\t\t\t\t\t\tORDER BY `timestamp` DESC;");
while ($row = mysql_fetch_assoc($result)) {
$row['time'] = timeElapsed($row['timestamp']);
$row['url'] = makeURL('news', array('newsid' => $row['newsid']));
$row['text'] = stripslashes($row['text']);
$row['title'] = stripslashes($row['title']);
$row['user_url'] = makeURL('profile', array('userid' => $row['userid']));
$row['comments'] = $comments->count('news', $row['newsid']);
$news[] = $row;
}
return array('title' => $title, 'news' => $news, 'news_count' => mysql_num_rows($result));
}
<?php
if ($this->isInstalled('board')) {
$area['title'] = $lang->get('posts');
$area['content'] = '';
$tbl_p = MYSQL_TABLE_PREFIX . 'post';
$tbl_t = MYSQL_TABLE_PREFIX . 'thread';
$tbl_b = MYSQL_TABLE_PREFIX . 'board';
$tbl_gu = MYSQL_TABLE_PREFIX . 'group_users';
$tbl_g = MYSQL_TABLE_PREFIX . 'groups';
$limit = (int) $config->get('board', 'box-posts');
$limit = $limit > 0 ? $limit : 5;
if ($config->get('board', 'box-thread-once') == 1) {
$sql = $db->query("SELECT posts.userid as userid, posts.timestamp, threads.thread, boards.boardid, threads.threadid \r\n\t\t\t\t\t\tFROM `" . $tbl_t . "` AS threads \r\n\t\t\t\t\t\tINNER JOIN `" . $tbl_p . "` AS posts\r\n\t\t\t\t\t\tON threads.lastpost=posts.postid\r\n\t\t\t\t\t\tINNER JOIN `" . $tbl_b . "` AS boards\r\n\t\t\t\t\t\tON threads.boardid=boards.boardid\r\n\t\t\t\t\t\tLEFT JOIN `" . $tbl_g . "` AS groups\r\n\t\t\t\t\t\tON boards.`assigned_groupid`=groups.groupid\r\n\t\t\t\t\t\tLEFT JOIN `" . $tbl_gu . "` AS group_users\r\n\t\t\t\t\t\tON boards.`assigned_groupid`=group_users.groupid\r\n\t\t\t\t\t\tWHERE group_users.userid=" . $login->currentUserID() . " OR (group_users.userid is NULL AND groups.groupid IS NULL)\r\n\t\t\t\t\t\tORDER BY posts.timestamp DESC\r\n\t\t\t\t\t\tLIMIT {$limit};");
} else {
$sql = $db->query("SELECT posts.userid as userid, posts.timestamp, threads.thread, boards.boardid, threads.threadid FROM \r\n\t\t\t\t\t\t`" . $tbl_p . "` AS posts \r\n\t\t\t\t\t\tINNER JOIN `" . $tbl_t . "` AS threads \r\n\t\t\t\t\t\tON threads.threadid=posts.threadid\r\n\t\t\t\t\t\tINNER JOIN `" . $tbl_b . "` AS boards\r\n\t\t\t\t\t\tON threads.boardid=boards.boardid\r\n\t\t\t\t\t\tLEFT JOIN `" . $tbl_g . "` AS groups\r\n\t\t\t\t\t\tON boards.`assigned_groupid`=groups.groupid\r\n\t\t\t\t\t\tLEFT JOIN `" . $tbl_gu . "` AS group_users\r\n\t\t\t\t\t\tON boards.`assigned_groupid`=group_users.groupid\r\n\t\t\t\t\t\tWHERE group_users.userid=" . $login->currentUserID() . " OR (group_users.userid is NULL AND groups.groupid IS NULL)\r\n\t\t\t\t\t\tORDER BY posts.timestamp DESC\r\n\t\t\t\t\t\tLIMIT {$limit};");
}
$list = array();
while ($list_entry = mysql_fetch_assoc($sql)) {
$list[] = $list_entry;
}
if (null != $list && count($list) > 0) {
foreach ($list as $l) {
$u = $user->getUserById($l['userid']);
$area['content'] = $area['content'] . "<p>» " . makeHtmlURL($l['thread'], makeURL('board', array('boardid' => $l['boardid'], 'threadid' => $l['threadid']))) . ' (' . makeHTMLURL($u['nickname'], makeURL('profile', array('userid' => $u['userid']))) . ', ' . timeElapsed($l['timestamp']) . ')</p/>';
}
}
$areas[] = $area;
}
function getNewestDownloads()
{
global $db, $login, $rights, $current_language;
$groups = $rights->getGroups($login->currentUserId());
if (count($groups) > 0) {
$groupswhere = "IN (-1,";
for ($i = 0; $i < count($groups) - 1; $i++) {
$groupswhere .= $groups[$i]['groupid'] . ",";
}
$groupswhere .= $groups[count($groups) - 1]['groupid'] . ")";
} else {
$groupswhere = " = -1";
}
$tbl_dl = MYSQL_TABLE_PREFIX . 'media_downloads';
$tbl_cat = MYSQL_TABLE_PREFIX . 'media_categories';
$tbl_perm = MYSQL_TABLE_PREFIX . 'media_categories_permissions';
$items = array();
$result = $db->query("\r\n\t\t\tSELECT timestamp, dl.categoryid, dl.name, dl.downloadid, dl.description, perm.groupid FROM " . $tbl_dl . " AS dl \r\n\t\t\tLEFT JOIN " . $tbl_perm . " AS perm ON dl.categoryid = perm.categoryid\r\n\t\t\tLEFT JOIN " . $tbl_cat . " AS cat ON cat.categoryid = dl.categoryid\r\n\t\t\tWHERE IFNULL(perm.groupid, -1) " . $groupswhere . " \r\n\t\t\tAND (cat.language = '' OR cat.language = '" . $current_language . "')\r\n\t\t\tGROUP BY dl.downloadid\r\n\t\t\tORDER BY timestamp DESC \r\n\t\t\tLIMIT 10;");
while ($row = mysql_fetch_assoc($result)) {
$row['time'] = timeElapsed($row['timestamp']);
$row['url'] = makeURL('media', array('categoryid' => $row['categoryid'], 'downloadid' => $row['downloadid']));
$items[] = $row;
}
return $items;
}
function makeLastPost($boardid, $threadid, $postid, $ppp)
{
global $lang;
global $db;
global $user;
global $debug;
if ($postid > 0) {
$debug->add('ppp', $ppp);
$page = lastPage($threadid, $ppp);
$post = $db->selectOneRow(MYSQL_TABLE_PREFIX . 'post', "*", "`postid`=" . (int) $postid);
$u = $user->getUserByID($post['userid']);
$s[] = "%a";
$r[] = $u['nickname'];
$s[] = "%t";
$r[] = timeElapsed($post['timestamp']);
return makeHTMLURL(str_replace($s, $r, $lang->get('last_post_by')), makeURL('board', array('boardid' => $boardid, 'threadid' => $threadid, 'page' => $page), "post" . $postid));
} else {
return $lang->get('last_post_none');
}
}
}
}
$smarty->assign('list', $list);
} else {
// include the template
$smarty->assign('path', $template_dir . '/pm.tpl');
// get message
$message = $db->selectOneRow($tbl_outbox, '*', "`senderid`=" . $login->currentUserID() . " AND `pmid`=" . (int) $_GET['pmid']);
// get users
$u = $user->getUserByID($message['recieverid']);
$me = $login->currentUser();
$message['reciever'] = $u['nickname'];
$message['reciever_url'] = makeURL('profile', array('userid' => $message['recieverid']));
$message['sender'] = $me['nickname'];
$message['sender_url'] = makeURL('profile', array('userid' => $message['senderid']));
$message['timestamp_str'] = timeElapsed($message['timestamp']);
// add a breadcrumb containing subject
$breadcrumbs->addElement($message['subject'], makeURL($mod, array('mode' => 'inbox', 'pmid' => $_GET['pmid'])));
// add br to message
$message['message'] = $bbcode->parse($message['message']);
$smarty->assign('message', $message);
}
break;
case "write":
$breadcrumbs->addElement($lang->get('write'), makeURL($mod, array('mode' => 'write')));
if (isset($_POST['send']) && trim($_POST['subject'] != '' && trim($_POST['message']) != '')) {
$u = $user->find($_POST['reciever'], 1);
if ($u !== false) {
// check if inbox is full
$otherinbox = $db->num_rows($tbl_inbox, "`recieverid`=" . $u[0]['userid']);
$allowed = $config->get($mod, 'inbox_limit');
function smarty_function_timeelapsed($params, $template)
{
if (isset($params['time'])) {
return timeElapsed($params['time']);
}
}
<?php
$tbl = MYSQL_TABLE_PREFIX . 'shoutbox';
$tbl_u = MYSQL_TABLE_PREFIX . 'users';
$lockTime = (int) $config->get('shoutbox', 'lock-time');
if ($lockTime <= 0) {
$lockTime = 15;
}
if (@trim($_POST['text']) != '' && $login->currentUser() !== false) {
$last_post = $db->selectOneRow($tbl, "*", "`userid`=" . $login->currentUserId(), "`timestamp` DESC");
if ($last_post['timestamp'] + $lockTime < time()) {
$db->insert($tbl, array('userid', 'timestamp', 'text'), array($login->currentUserID(), time(), "'" . str_replace("\n", "", trim($_POST['text'])) . "'"));
}
}
$posts = $db->selectList($tbl . "`, `" . $tbl_u, "*", "`" . $tbl_u . "`.`userid`=`" . $tbl . "`.`userid`", "`timestamp` DESC", (int) $config->get('shoutbox', 'posts'));
if (null != $posts && count($posts) > 0) {
foreach ($posts as $i => $p) {
$posts[$i]['timestamp_str'] = timeElapsed($p['timestamp']);
$posts[$i]['url'] = makeURL('profile', array('userid' => $p['userid']));
$posts[$i]['text'] = $bbcode->parse($p['text']);
}
}
if ($config->get('shoutbox', 'reverse') == 1) {
$posts = array_reverse($posts);
}
$smarty->assign('posts', $posts);
$smarty->display('../boxes/shoutbox/posts.tpl');
$statistic['visitors_yesterday'] = $stat->visitorsYesterday();
$statistic['visitors_this_month'] = $stat->visitorsThisMonth();
$statistic['visitors_overall'] = $stat->visitorsOverall();
$visitorList = $stat->listOnline();
if (count($visitorList) > 0) {
foreach ($visitorList as $i => $v) {
$visitorList[$i]['url'] = makeURL('profile', array('userid' => $v['userid']));
@($visitorList[$i]['duration_str'] = durationToString($v['duration']));
}
}
$statistic['visitor_list'] = $visitorList;
$lastSeenList = $stat->lastSeen();
if (count($lastSeenList) > 0) {
foreach ($lastSeenList as $i => $v) {
$lastSeenList[$i]['url'] = makeURL('profile', array('userid' => $v['userid']));
$lastSeenList[$i]['timeelapsed'] = timeElapsed($v['lastaction']);
}
}
$statistic['lastseen'] = $lastSeenList;
$statistic['visitors_per_day'] = $stat->visitorsPerDay();
$month = date("n");
$year = date("Y");
if (isset($_POST['btnChangeYearAndMonth'])) {
$month = (int) $_POST['Date_Month'];
$year = (int) $_POST['Date_Year'];
}
$statistic['table_this_month'] = $stat->visitorsTablePerMonth($month, $year);
$statistic['this_month_name'] = date("F", mktime(0, 0, 0, $month, 1, $year));
$statistic['table_this_year'] = $stat->visitorsTablePerYear($year);
$statistic['this_year_name'] = date("Y", mktime(0, 0, 0, $month, 1, $year));
$statistic['table_browseragent'] = $stat->makeBrowseragentList();
function find($needle)
{
global $user, $bbcode;
$sql = "SELECT * FROM `" . $this->table . "` WHERE `text` LIKE '%" . secureMySQL($needle) . "%' LIMIT 20;";
$result = $this->db->query($sql);
$list = array();
while ($row = mysql_fetch_assoc($result)) {
$u = $user->getUserByID($row['userid']);
$l['time'] = timeElapsed($row['timestamp']);
$l['nickname'] = $u['nickname'];
$l['text'] = $bbcode->parse($row['text']);
$l['mod'] = $row['mod'];
$l['url'] = makeURL('profile', array('userid' => $row['userid']));
$list[] = $l;
}
return $list;
}
<?php
if ($login->currentUser() !== false) {
if ($_POST['text'] != '') {
$db->insert('tournamentcomm', array('tournamentid', 'userid', 'encid', 'roundid', 'text', 'timestamp'), array((int) $_POST['tournamentid'], $login->currentUserId(), (int) $_POST['encid'], (int) $_POST['roundid'], "'" . $_POST['text'] . "'", time()));
}
$list = $db->selectList('tournamentcomm`, `' . MYSQL_TABLE_PREFIX . 'users', '*', "`tournamentid`=" . (int) $_POST['tournamentid'] . "\r\n\t\t\tAND `encid`=" . (int) $_POST['encid'] . "\r\n\t\t\tAND `roundid`=" . (int) $_POST['roundid'] . "\r\n\t\t\tAND `" . MYSQL_TABLE_PREFIX . "tournamentcomm`.`userid`=`" . MYSQL_TABLE_PREFIX . "users`.`userid`", "`timestamp` DESC");
foreach ($list as $i => $item) {
$list[$i]['timestamp_str'] = timeElapsed($item['timestamp']);
}
$smarty->assign('list', $list);
$smarty->display('../mod/default/tournament/communication.tpl');
}
<?php
if ($this->isInstalled('news')) {
$area['title'] = $lang->get('news');
$area['content'] = '';
$topnews = $db->selectList(MYSQL_TABLE_PREFIX . 'news', "*", "`domainid` = 0 OR `domainid` = " . getCurrentDomainIndex(), "`timestamp` DESC", "5");
if (null != $topnews && count($topnews) > 0) {
foreach ($topnews as $top) {
$area['content'] = $area['content'] . "<p>» " . makeHtmlURL($top['title'], makeURL('news', array('newsid' => $top['newsid']))) . ' (' . timeElapsed($top['timestamp']) . ')</p>';
}
}
$areas[] = $area;
}
<?php
//$lang->addModSpecificLocalization('events');
$table = MYSQL_TABLE_PREFIX . 'events';
$tbl_reg = MYSQL_TABLE_PREFIX . 'register';
$tbl_users = MYSQL_TABLE_PREFIX . 'users';
$e = $db->selectOneRow($table, "*", "`end`>" . time(), "`start` ASC", "1");
if (@$e['eventid'] == '') {
$tpl_file = $template_dir . "/none.tpl";
} else {
$e['url'] = makeURL('events', array('eventid' => $e['eventid']));
//$e['start'] = date('d.m.Y / H:i', $e['start']);
$e['start'] = time() > $e['start'] ? timeElapsed($e['start']) : timeLeft($e['start']);
$e['end'] = date('d.m.Y / H:i', $e['end']);
$e['registered'] = $db->num_rows($tbl_reg, "`eventid`=" . $e['eventid']);
$e['payed'] = $db->num_rows($tbl_reg, "`eventid`=" . $e['eventid'] . " AND `payed` > 0");
$e['payed_pre'] = $db->num_rows($tbl_reg, "`eventid`=" . $e['eventid'] . " AND `payed`!=0 AND `payed`!=2");
$e['payed_box_office'] = $db->num_rows($tbl_reg, "`eventid`=" . $e['eventid'] . " AND `payed`=2");
$e['seats_free'] = $e['seats'] - $e['registered'];
$bar_width = 100;
// is user registered?
$reg = $db->num_rows($tbl_reg, "`userid`=" . $login->currentUserID() . " \r\n\t\t\t\t\t\t\t\t\t\tAND `eventid`=" . $e['eventid']);
$smarty->assign('box_events_reg', $reg);
if ($reg == 1) {
$smarty->assign('box_events_state', $lang->get('event_registered'));
} else {
$smarty->assign('box_events_state', $lang->get('event_not_registered'));
}
if ($e['free'] == 0) {
$e['not_payed'] = $e['registered'] - $e['payed'];
}
<?php
if ($this->isInstalled('article')) {
$area['title'] = $lang->get('article');
$area['content'] = '';
$articles = $db->selectList('article', "*", "1", "`timestamp` DESC", "5");
if (null != $articles && count($articles) > 0) {
foreach ($articles as $article) {
$area['content'] = $area['content'] . "<p>» " . makeHtmlURL($article['title'], makeURL('article', array('articleid' => $article['articleid'], 'categoryid' => $article['categoryid']))) . ' (' . timeElapsed($article['timestamp']) . ')</p>';
}
}
$areas[] = $area;
}
$usr = $login->currentUser();
if ($usr !== false) {
$smarty->assign('nickname', $usr['nickname']);
}
if (isset($_POST['delete']) && $isallowed) {
$db->delete($tbl, "`guestbookid`=" . (int) $_POST['guestbookid']);
$notify->add($lang->get('guestbook'), $lang->get('deleted'));
}
if (isset($_POST['add']) && $_POST['email'] == '') {
if (trim($_POST['author']) == '' || trim($_POST['message']) == '') {
$notify->add($lang->get('guestbook'), $lang->get('fill_all'));
} else {
if ($ip_blocker_enabled == 1 && $db->num_rows($tbl, "`ipadress`='" . getRemoteAdr() . "' AND `timestamp`>" . (time() - $ip_blocker_limit)) == 0 || $ip_blocker_enabled == 0) {
$db->insert($tbl, array('timestamp', 'author', 'message', 'ipadress'), array(time(), "'" . $_POST['author'] . "'", "'" . strip_tags($_POST['message']) . "'", "'" . getRemoteAdr() . "'"));
} else {
$notify->add($lang->get('guestbook'), $lang->get('ip-blocker'));
}
}
}
$messageCount = $db->num_rows($tbl, "1");
$messagesPerPage = $config->get($mod, 'entries-per-page');
@$pages->setValues((int) $_GET['page'], $messagesPerPage, $messageCount);
$list = $db->selectList($tbl, "*", "1", "`timestamp` DESC", $pages->currentValue() . ", " . (int) $messagesPerPage);
if (count($list) > 0) {
foreach ($list as $i => $l) {
$list[$i]['time'] = timeElapsed($l['timestamp']);
$list[$i]['message'] = $bbcode->parse($l['message']);
}
}
$smarty->assign('list', $list);
$smarty->assign('pages', $pages->get($mod, array()));
<?php
$lang->addModSpecificLocalization('board');
$tbl_p = MYSQL_TABLE_PREFIX . 'post';
$tbl_t = MYSQL_TABLE_PREFIX . 'thread';
$tbl_b = MYSQL_TABLE_PREFIX . 'board';
$tbl_gu = MYSQL_TABLE_PREFIX . 'group_users';
$tbl_g = MYSQL_TABLE_PREFIX . 'groups';
$limit = (int) $config->get('board', 'box-posts');
$limit = $limit > 0 ? $limit : 5;
$ppp = $config->get('board', 'posts-per-page');
require_once './mod/default/board/board.function.php';
if ($config->get('board', 'box-thread-once') == 1) {
$sql = $db->query("SELECT posts.userid as userid, posts.timestamp, threads.thread, boards.boardid, threads.threadid, threads.lastpost \r\n\t\t\t\t\tFROM `" . $tbl_t . "` AS threads \r\n\t\t\t\t\tINNER JOIN `" . $tbl_p . "` AS posts\r\n\t\t\t\t\tON threads.lastpost=posts.postid\r\n\t\t\t\t\tINNER JOIN `" . $tbl_b . "` AS boards\r\n\t\t\t\t\tON threads.boardid=boards.boardid\r\n\t\t\t\t\tLEFT JOIN `" . $tbl_g . "` AS groups\r\n\t\t\t\t\tON boards.`assigned_groupid`=groups.groupid\r\n\t\t\t\t\tLEFT JOIN `" . $tbl_gu . "` AS group_users\r\n\t\t\t\t\tON boards.`assigned_groupid`=group_users.groupid\r\n\t\t\t\t\tWHERE group_users.userid=" . $login->currentUserID() . " OR (group_users.userid is NULL AND groups.groupid IS NULL)\r\n\t\t\t\t\tORDER BY posts.timestamp DESC\r\n\t\t\t\t\tLIMIT {$limit};");
} else {
$sql = $db->query("SELECT posts.userid as userid, posts.timestamp, threads.thread, boards.boardid, threads.threadid, threads.lastpost FROM \r\n\t\t\t\t\t`" . $tbl_p . "` AS posts \r\n\t\t\t\t\tINNER JOIN `" . $tbl_t . "` AS threads \r\n\t\t\t\t\tON threads.threadid=posts.threadid\r\n\t\t\t\t\tINNER JOIN `" . $tbl_b . "` AS boards\r\n\t\t\t\t\tON threads.boardid=boards.boardid\r\n\t\t\t\t\tLEFT JOIN `" . $tbl_g . "` AS groups\r\n\t\t\t\t\tON boards.`assigned_groupid`=groups.groupid\r\n\t\t\t\t\tLEFT JOIN `" . $tbl_gu . "` AS group_users\r\n\t\t\t\t\tON boards.`assigned_groupid`=group_users.groupid\r\n\t\t\t\t\tWHERE group_users.userid=" . $login->currentUserID() . " OR (group_users.userid is NULL AND groups.groupid IS NULL)\r\n\t\t\t\t\tORDER BY posts.timestamp DESC\r\n\t\t\t\t\tLIMIT {$limit};");
}
$list = array();
while ($list_entry = mysql_fetch_assoc($sql)) {
$list[] = $list_entry;
}
if (null != $list && count($list) > 0) {
foreach ($list as $i => $l) {
$u = $user->getUserById($l['userid']);
$list[$i]['url'] = makeURL('board', array('boardid' => $l['boardid'], 'threadid' => $l['threadid'], 'page' => lastPage($l['threadid'], $ppp)), "post" . $l['lastpost']);
$list[$i]['info'] = '(' . makeHTMLURL($u['nickname'], makeURL('profile', array('userid' => $u['userid']))) . ', ' . timeElapsed($l['timestamp']) . ')';
}
}
$smarty->assign('box_board_posts', $list);
$tpl_file = $template_dir . "/posts.tpl";
$visible = true;
$e['start'] = date('d.m.Y / H:i', $e['start']);
$e['end'] = date('d.m.Y / H:i', $e['end']);
$e['reg_start'] = date('d.m.Y / H:i', $e['reg_start']);
$e['reg_end'] = date('d.m.Y / H:i', $e['reg_end']);
$e['registered'] = $db->num_rows($tbl_reg, "`eventid`=" . (int) $_GET['eventid']);
$e['payed'] = $db->num_rows($tbl_reg, "`eventid`=" . (int) $_GET['eventid'] . " AND `payed` > 0");
$e['payed_pre'] = $db->num_rows($tbl_reg, "`eventid`=" . (int) $_GET['eventid'] . " AND `payed`=1");
$e['payed_box_office'] = $db->num_rows($tbl_reg, "`eventid`=" . (int) $_GET['eventid'] . " AND `payed`=2");
$e['seats_free'] = $e['seats'] - $e['registered'];
if ($e['free'] == 0) {
$e['not_payed'] = $e['registered'] - $e['payed'];
}
if ($e['last_check'] == 0) {
$e['last_check'] = $lang->get('never');
} else {
$e['last_check'] = timeElapsed($e['last_check']);
}
$smarty->assign('path', $template_dir . "/view.tpl");
$smarty->assign('event', $e);
// edit and remove urls
$smarty->assign('edit_url', makeURL($mod, array('mode' => 'edit', 'eventid' => $e['eventid'])));
$smarty->assign('remove_url', makeURL($mod, array('mode' => 'remove', 'eventid' => $e['eventid'])));
$smarty->assign('paystate_url', makeURL($mod, array('mode' => 'paystate', 'eventid' => $e['eventid'])));
$smarty->assign('agb_url', makeURL($mod, array('mode' => 'agb', 'eventid' => $e['eventid'])));
// Paystate bar
if ($e['free'] == 0) {
$smarty->assign('payed_width', 100 * $e['payed'] / $e['seats'] * ($bar_width / 100));
$smarty->assign('not_payed_width', 100 * $e['not_payed'] / $e['seats'] * ($bar_width / 100));
$smarty->assign('free_width', 100 * $e['seats_free'] / $e['seats'] * ($bar_width / 100));
} else {
$smarty->assign('payed_width', 100 * $e['registered'] / $e['seats'] * ($bar_width / 100));
<?php
$smarty->assign('path', $template_dir . "/credit.tpl");
$smarty->assign('mv', $credit->getMovements());
$smarty->assign('balance', $credit->getBalance());
$smarty->assign('last_activity', timeElapsed($credit->getLastActivity()));
$register->joinGroup($tournament, $groupid, $_POST['creategroup_password']);
}
}
if (isset($_POST['unjoin'])) {
$register->leaveTournament($tournamentid);
}
if (isset($_POST['joingroup'])) {
$register->joinGroup($tournament, $_POST['joingroup_groupid'], $_POST['joingroup_password']);
}
$smarty->assign('already_joined', $register->alreadyJoined($tournamentid));
$smarty->assign('grouplist', $register->getPlayerList($tournament));
}
if ($tournament['start'] > time()) {
$tournament['start_str'] = timeLeft($tournament['start']);
} else {
$tournament['start_str'] = timeElapsed($tournament['start']);
}
// Ranking of tournament
if ($tournament['state'] == 2 || $tournament['state'] == 3) {
$ranking = $tournament_obj->ranking();
$smarty->assign('ranking', $ranking);
}
$tournament['regcount'] = $register->getRegCount($tournamentid);
$smarty->assign('tournament', $tournament);
break;
case 'editstate':
if (!$right['add_remove_edit']) {
break;
}
if (isset($_POST['save'])) {
$tournamentList->setState($tournamentid, $_POST['state']);
// check if user exists
if ($u !== false) {
// set breadcrumb
$breadcrumbs->addElement($u['nickname'], makeURL($mod, array('userid' => $u['userid'])));
// set my userid
$smarty->assign('myid', $login->currentUserId());
// include the template
$smarty->assign('path', $template_dir . '/profile.tpl');
if ($config->get('profile', 'hide-lastname') == '1') {
$u['lastname'] = substr($u['lastname'], 0, 1) . '.';
}
$smarty->assign('user', $u);
// avatar
$smarty->assign('avatar', $avatar->get($_GET['userid']));
// last seen
$smarty->assign('last_seen', timeElapsed($u['lastaction']));
// clan
if ($this->isInstalled('clan')) {
$clanid = (int) $db->selectOne('clan_member', 'clanid', "`userid`=" . $userid);
if ($clanid > 0) {
$clan = $db->selectOneRow('clan', '*', '`clanid`=' . $clanid);
$clan['url'] = makeURL('clan', array('clanid' => $clanid));
$smarty->assign('clan', $clan);
}
}
// get personal fields
$tbl_fields = MYSQL_TABLE_PREFIX . 'personal_fields';
$tbl_data = MYSQL_TABLE_PREFIX . 'personal_data';
$list = $db->selectList($tbl_fields);
$l = array();
if (count($list) > 0) {
<?php
global $current_language;
if ($this->isInstalled('calendar')) {
$area['title'] = $lang->get('calendar');
$area['content'] = '';
if ($login->currentUser() === false) {
$cal_list = $db->selectList('calendar', "*", "(`start` > " . time() . " AND `visible`=2)\r\n\t\t\t\tAND (`language` = '' OR `language` = '" . $current_language . "')", "`start` ASC", "5");
} else {
$cal_list = $db->selectList('calendar', "*", "(`start` > " . time() . " AND (`visible`=2 OR `visible`=1 OR (`visible`=0 AND `userid`=" . $login->currentUserId() . ")))\r\n\t\t\t\t\tAND (`language` = '' OR `language` = '" . $current_language . "')", "`start` ASC", "5");
}
if (null != $cal_list && count($cal_list) > 0) {
foreach ($cal_list as $cal) {
$time = time() > $cal['start'] ? timeElapsed($cal['start']) : timeLeft($cal['start']);
$area['content'] = $area['content'] . "<p>» " . makeHtmlURL($cal['title'], makeURL('calendar', array('calendarid' => $cal['calendarid'], 'mode' => 'view', 'day' => $cal['start']))) . ' (' . $time . ')</p>';
}
}
$areas[] = $area;
}
