function navi($kat)
{
global $db, $chkMe, $userid, $designpath;
if ($k = _fetch(db("SELECT `level` FROM " . $db['navi_kats'] . " WHERE `placeholder` = '" . up($kat) . "'"))) {
$intern = $chkMe >= 2 ? '' : " AND s1.`internal` = '0'";
$permissions = $kat == 'nav_admin' && admin_perms($userid) ? "" : $intern . " AND " . intval($chkMe) . " >= '" . intval($k['level']) . "'";
$qry = db("SELECT s1.* FROM " . $db['navi'] . " AS s1 LEFT JOIN " . $db['navi_kats'] . " AS s2 ON s1.kat = s2.placeholder\n WHERE s1.kat = '" . up($kat) . "' AND s1.`shown` = '1' " . $permissions . "\n ORDER BY s1.pos");
while ($get = _fetch($qry)) {
if ($get['type'] == 0) {
$link = '';
} elseif ($get['type'] == 1 || $get['type'] == 2 || $get['type'] == 3) {
$name = $get['wichtig'] == 1 ? '<span class="fontWichtig">' . navi_name(re($get['name'])) . '</span>' : navi_name(re($get['name']));
$target = $get['target'] == 1 ? '_blank' : '_self';
if (file_exists($designpath . '/menu/' . $get['kat'] . '.html')) {
$link = show("menu/" . $get['kat'] . "", array("target" => $target, "href" => re($get['url']), "title" => strip_tags($name), "css" => ucfirst(str_replace('nav_', '', re($get['kat']))), "link" => $name));
} else {
$link = show("menu/nav_link", array("target" => $target, "href" => re($get['url']), "title" => strip_tags($name), "css" => ucfirst(str_replace('nav_', '', re($get['kat']))), "link" => $name));
}
$table = strstr($link, '<tr>') ? true : false;
}
$navi .= $link;
}
}
return empty($navi) ? '' : ($table ? '<table class="navContent" cellspacing="0">' . $navi . '</table>' : $navi);
}
function motm()
{
global $db, $allowHover;
$userpics = get_files(basePath . '/inc/images/uploads/userpics/');
$qry = db("SELECT * FROM " . $db['users'] . " WHERE level >= 2");
while ($rs = _fetch($qry)) {
foreach ($userpics as $userpic) {
$tmpId = intval($userpic);
if ($tmpId == $rs['id']) {
$temparr[] = $rs['id'];
$a++;
break;
}
}
}
$arrayID = rand(0, count($temparr) - 1);
$uid = $temparr[$arrayID];
$get = _fetch(db("SELECT * FROM " . $db['users'] . " WHERE id = '" . $uid . "'"));
if (!empty($get) && !empty($temparr)) {
$status = $get['status'] == 1 || $get['level'] == 1 ? _aktiv : _inaktiv;
if ($allowHover == 1) {
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . rawautor($get['id']) . '</td></tr><tr><td width=80px><b>' . _posi . ':</b></td><td>' . getrank($get['id']) . '</td></tr><tr><td><b>' . _status . ':</b></td><td>' . $status . '</td></tr><tr><td><b>' . _age . ':</b></td><td>' . getAge($get['bday']) . '</td></tr><tr><td colspan=2 align=center>' . jsconvert(userpic($get['id'])) . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$member = show("menu/motm", array("uid" => $get['id'], "upic" => userpic($get['id'], 130, 161), "info" => $info));
} else {
$member = '';
}
return empty($member) ? '' : '<table class="navContent" cellspacing="0">' . $member . '</table>';
}
function fvote($id, $ajax = false)
{
global $db, $balken_vote_menu, $prev;
if (!permission("votes")) {
$intern = ' AND intern = 0';
}
$qry = db("SELECT * FROM " . $db['votes'] . " WHERE id = '" . $id . "' " . $intern . "");
$get = _fetch($qry);
if (_rows($qry)) {
$qryv = db("SELECT * FROM " . $db['vote_results'] . " WHERE vid = '" . $get['id'] . "' ORDER BY id ASC");
while ($getv = _fetch($qryv)) {
$stimmen = sum($db['vote_results'], " WHERE vid = '" . $get['id'] . "'", "stimmen");
if ($stimmen != 0) {
if (ipcheck("vid_" . $get['id']) || isset($_COOKIE[$prev . "vid_" . $get['id']]) || $get['closed'] == 1) {
$percent = round($getv['stimmen'] / $stimmen * 100, 1);
$rawpercent = round($getv['stimmen'] / $stimmen * 100, 0);
$balken = show(_votes_balken, array("width" => $rawpercent));
$votebutton = "";
$results .= show("forum/vote_results", array("answer" => re($getv['sel']), "percent" => $percent, "stimmen" => $getv['stimmen'], "balken" => $balken));
} else {
$votebutton = '<input id="contentSubmitFVote" type="submit" value="' . _button_value_vote . '" class="voteSubmit" />';
$results .= show("forum/vote_vote", array("id" => $getv['id'], "answer" => re($getv['sel'])));
}
} else {
$votebutton = '<input id="contentSubmitFVote" type="submit" value="' . _button_value_vote . '" class="voteSubmit" />';
$results .= show("forum/vote_vote", array("id" => $getv['id'], "answer" => re($getv['sel'])));
}
}
$qryf = db("SELECT id,kid FROM " . $db['f_threads'] . " WHERE vote = '" . $get['id'] . "'");
$getf = _fetch($qryf);
$vote = show("forum/vote", array("titel" => re($get['titel']), "vid" => $get['id'], "fid" => $getf['id'], "kid" => $getf['kid'], "umfrage" => _forum_vote, "results" => $results, "votebutton" => $votebutton, "stimmen" => $stimmen));
}
return empty($vote) ? '' : ($ajax ? $vote : '<div id="navFVote">' . $vote . '</div>');
}
function ftopics()
{
global $db, $maxftopics, $lftopics, $maxfposts, $allowHover;
$f = 0;
$qry = db("SELECT s1.*,s2.id AS subid FROM " . $db['f_threads'] . " s1, " . $db['f_skats'] . " s2, " . $db['f_kats'] . " s3\n WHERE s1.kid = s2.id AND s2.sid = s3.id ORDER BY s1.lp DESC LIMIT 100");
while ($get = _fetch($qry)) {
if ($f == $maxftopics) {
break;
}
if (fintern($get['kid'])) {
$lp = cnt($db['f_posts'], " WHERE sid = '" . $get['id'] . "'");
$pagenr = ceil($lp / $maxfposts);
if ($pagenr == 0) {
$page = 1;
} else {
$page = $pagenr;
}
if ($allowHover == 1) {
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . jsconvert(re($get['topic'])) . '</td></tr><tr><td><b>' . _forum_posts . ':</b></td><td>' . $lp . '</td></tr><tr><td><b>' . _forum_lpost . ':</b></td><td>' . date("d.m.Y H:i", $get['lp']) . _uhr . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$ftopics .= show("menu/forum_topics", array("id" => $get['id'], "pagenr" => $page, "p" => $lp + 1, "titel" => cut(re($get['topic']), $lftopics), "info" => $info, "kid" => $get['kid']));
$f++;
}
}
return empty($ftopics) ? '' : '<table class="navContent" cellspacing="0">' . $ftopics . '</table>';
}
function top_match()
{
global $db, $allowHover, $llwars, $picformat, $sql_prefix;
$qry = db("SELECT s1.datum,s1.cid,s1.id,s1.bericht,s1.xonx,s1.punkte,s1.gpunkte,s1.squad_id,s2.icon,s2.name FROM " . $db['cw'] . " AS s1\n LEFT JOIN " . $db['squads'] . " AS s2 ON s1.squad_id = s2.id\n WHERE `top` = '1'\n ORDER BY RAND()");
if ($get = _fetch($qry)) {
//Clans Mod
$clandetailssql = db("SELECT clantag, gegner FROM " . $sql_prefix . "clans WHERE id LIKE " . $get['cid']);
$clans = _fetch($clandetailssql);
$squad = '_defaultlogo.jpg';
$gegner = '_defaultlogo.jpg';
foreach ($picformat as $end) {
if (file_exists(basePath . '/inc/images/clanwars/' . $get['cid'] . '_logo.' . $end)) {
$gegner = $get['cid'] . '_logo.' . $end;
}
if (file_exists(basePath . '/inc/images/squads/' . $get['squad_id'] . '_logo.' . $end)) {
$squad = $get['squad_id'] . '_logo.' . $end;
}
}
if ($allowHover == 1 || $allowHover == 2) {
$hover = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . jsconvert(re($get['name'])) . '<br/>vs.<br/> ' . jsconvert(re($clans['gegner'])) . '</td></tr><tr><td><b>' . _played_at . ':</b></td><td>' . date("d.m.Y H:i", $get['datum']) . _uhr . '</td></tr><tr><td><b>' . _cw_xonx . ':</b></td><td>' . jsconvert(re($get['xonx'])) . '</td></tr><tr><td><b>' . _result . ':</b></td><td>' . cw_result_nopic_raw($get['punkte'], $get['gpunkte']) . '</td></tr><tr><td><b>' . _comments_head . ':</b></td><td>' . cnt($db['cw_comments'], "WHERE cw = '" . $get['id'] . "'") . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$topmatch .= show("menu/top_match", array("id" => $get['id'], "clantag" => re(cut($clans['clantag'], $llwars)), "team" => re(cut($get['name'], $llwars)), "game" => substr(strtoupper(str_replace('.' . $icon, '', re($get['icon']))), 0, 5), "id" => $get['id'], "gegner" => $gegner, "squad" => $squad, "hover" => $hover, "info" => $get['datum'] > time() ? date("d.m.Y", $get['datum']) : cw_result_nopic($get['punkte'], $get['gpunkte'])));
}
return empty($topmatch) ? '<center style="margin:3px 0">' . _no_top_match . '</center>' : '<table class="navContent" cellspacing="0">' . $topmatch . '</table>';
}
function vote($ajax = false)
{
global $db, $balken_vote_menu, $prev;
$qry = db("SELECT * FROM " . $db['votes'] . " WHERE menu = '1' AND forum = 0");
$get = _fetch($qry);
if (_rows($qry)) {
$qryv = db("SELECT * FROM " . $db['vote_results'] . " WHERE vid = '" . $get['id'] . "' ORDER BY what");
while ($getv = _fetch($qryv)) {
$stimmen = sum($db['vote_results'], " WHERE vid = '" . $get['id'] . "'", "stimmen");
if ($stimmen != 0) {
if (ipcheck("vid_" . $get['id']) || isset($_COOKIE[$prev . "vid_" . $get['id']]) || $get['closed'] == 1) {
$percent = round($getv['stimmen'] / $stimmen * 100, 1);
$rawpercent = round($getv['stimmen'] / $stimmen * 100, 0);
$balken = show(_votes_balken, array("width" => $rawpercent));
$votebutton = "";
$results .= show("menu/vote_results", array("answer" => re($getv['sel']), "percent" => $percent, "stimmen" => $getv['stimmen'], "balken" => $balken));
} else {
$votebutton = '<input id="contentSubmitVote" type="submit" value="' . _button_value_vote . '" class="voteSubmit" />';
$results .= show("menu/vote_vote", array("id" => $getv['id'], "answer" => re($getv['sel'])));
}
} else {
$votebutton = '<input id="contentSubmitVote" type="submit" value="' . _button_value_vote . '" class="voteSubmit" />';
$results .= show("menu/vote_vote", array("id" => $getv['id'], "answer" => re($getv['sel'])));
}
}
$vote = show("menu/vote", array("titel" => re($get['titel']), "vid" => $get['id'], "results" => $results, "votebutton" => $votebutton, "stimmen" => $stimmen));
}
return empty($vote) ? '<center style="margin:2px 0">' . _vote_menu_no_vote . '</center>' : ($ajax ? $vote : '<div id="navVote">' . $vote . '</div>');
}
function counter()
{
//$sql_prefix hinzufügen
global $db, $today, $counter_start, $useronline, $where, $isSpider, $sql_prefix;
if (!$isSpider) {
$qry2day = db("SELECT visitors FROM " . $db['counter'] . "\n WHERE today = '" . $today . "'");
if (_rows($qry2day)) {
$get2day = _fetch($qry2day);
$v_today = $get2day['visitors'];
} else {
$v_today = 0;
}
$gestern = time() - 86400;
$tag = date("j", $gestern);
$monat = date("n", $gestern);
$jahr = date("Y", $gestern);
$yesterday = $tag . "." . $monat . "." . $jahr;
$qryyday = db("SELECT visitors FROM " . $db['counter'] . "\n WHERE today = '" . $yesterday . "'");
if (_rows($qryyday)) {
$getyday = _fetch($qryyday);
$yDay = $getyday['visitors'];
} else {
$yDay = 0;
}
$qrystats = db("SELECT SUM(visitors) AS allvisitors,\n MAX(visitors) AS maxvisitors,\n MAX(maxonline) AS maxonline,\n AVG(visitors) AS avgvisitors,\n SUM(visitors) AS allvisitors\n FROM " . $db['counter'] . "");
$getstats = _fetch($qrystats);
if (abs(online_reg()) != 0) {
$qryo = db("SELECT id FROM " . $db['users'] . "\n WHERE time+'" . $useronline . "'>'" . time() . "'\n AND online = 1\n ORDER BY nick");
while ($geto = _fetch($qryo)) {
$ousers .= '<tr><td>' . rawautor($geto['id']) . '</td><td align=right valign=middle><small>' . jsconvert(getrank($geto['id'])) . '</small></td></tr>';
}
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . _online_head . '</td></tr><tr><td><table width=100% cellpadding=0 cellspacing=0>' . $ousers . '</table></td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
//Klicks Mod
if (strpos($_SERVER['PHP_SELF'], "/admin/") !== false) {
$clicksnumber = "-";
} else {
if ($_SERVER['QUERY_STRING'] != "") {
$whereclicks = $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING'];
} else {
$whereclicks = $_SERVER['PHP_SELF'];
}
$clicksrownumber = mysql_num_rows(db("SELECT klicks FROM " . $sql_prefix . "klicks WHERE wo = '" . $whereclicks . "'"));
if ($clicksrownumber == 0) {
$qry = db("INSERT INTO " . $sql_prefix . "klicks \n SET `wo` = '" . $whereclicks . "',\n `klicks` = '1'");
$clicksnumber = 1;
} else {
$clicksnumber = mysql_fetch_array(db("SELECT klicks FROM " . $sql_prefix . "klicks WHERE wo = '" . $whereclicks . "'"));
$clicksnumber = $clicksnumber[0] + 1;
$qry = db("UPDATE " . $sql_prefix . "klicks SET klicks = '" . $clicksnumber . "' WHERE wo LIKE '" . $whereclicks . "'");
}
}
//Klicks Mod Ende
$counter = show("menu/counter", array("v_today" => $v_today, "aufrufe" => $clicksnumber, "v_yesterday" => $yDay, "v_all" => $getstats['allvisitors'] + $counter_start, "v_perday" => round($getstats['avgvisitors'], 2), "v_max" => $getstats['maxvisitors'], "g_online" => abs(online_guests($where) - online_reg()), "u_online" => abs(online_reg()), "info" => $info, "v_online" => $getstats['maxonline'], "head_online" => _head_online, "head_visits" => _head_visits, "head_max" => _head_max, "user" => _cnt_user, "guests" => _cnt_guests, "today" => _cnt_today, "yesterday" => _cnt_yesterday, "all" => _cnt_all, "percentperday" => _cnt_pperday, "perday" => _cnt_perday, "online" => _cnt_online));
return '<table class="navContent" cellspacing="0">' . $counter . '</table>';
}
}
function rotationsbanner()
{
global $db;
$qry = db("SELECT * FROM " . $db['sponsoren'] . "\n\t\t\t WHERE banner = 1 ORDER BY RAND() LIMIT 1");
while ($get = _fetch($qry)) {
$rotationbanner .= show(_sponsors_bannerlink, array("id" => $get['id'], "title" => htmlspecialchars(str_replace('http://', '', re($get['link']))), "banner" => empty($get['blink']) ? "../banner/sponsors/banner_" . $get['id'] . "." . $get['bend'] : re($get['blink'])));
}
return empty($rotationbanner) ? '' : $rotationbanner;
}
function l_reg()
{
global $db, $llreg, $maxlreg;
$qry = db("SELECT id,nick,country,regdatum FROM " . $db['users'] . "\n ORDER BY regdatum DESC\n LIMIT " . $maxlreg . "");
while ($get = _fetch($qry)) {
$lreg .= show("menu/last_reg", array("nick" => re(cut($get['nick'], $llreg)), "country" => flag($get['country']), "reg" => date("d.m.", $get['regdatum']), "id" => $get['id']));
}
return empty($lreg) ? '' : '<table class="navContent" cellspacing="0">' . $lreg . '</table>';
}
function sponsors()
{
global $db;
$qry = db("SELECT * FROM " . $db['sponsoren'] . " WHERE box = 1 ORDER BY pos");
while ($get = _fetch($qry)) {
$banner = show(_sponsors_bannerlink, array("id" => $get['id'], "title" => htmlspecialchars(str_replace('http://', '', re($get['link']))), "banner" => empty($get['xlink']) ? "../banner/sponsors/box_" . $get['id'] . "." . $get['xend'] : re($get['xlink'])));
$sponsors .= show("menu/sponsors", array("banner" => $banner));
}
return empty($sponsors) ? '' : '<table class="navContent" cellspacing="0">' . $sponsors . '</table>';
}
function events()
{
global $db, $sql_prefix;
$qry = db("SELECT id, name, start FROM " . $sql_prefix . "events_info\n WHERE (`start` >= " . time() . " OR (`start` <= " . time() . " AND `ende` >= " . time() . ")) AND `show` = 1\n ORDER BY `start`\n LIMIT " . config('m_events') . "");
while ($get = _fetch($qry)) {
$events = show(_ev_next_event_link, array("datum" => date("d.m.", $get['start']), "id" => $get['id'], "event" => $get['name']));
$eventbox .= show("menu/event", array("events" => $events));
}
return empty($eventbox) ? '<center style="margin:2px 0">' . _no_events . '</center>' : '<table class="navContent" cellspacing="0">' . $eventbox . '</table>';
}
function events()
{
global $db, $maxevent;
$qry = db("SELECT id,datum,title,event FROM " . $db['events'] . "\n WHERE datum > " . time() . "\n ORDER BY datum\n LIMIT " . $maxevent . "");
while ($get = _fetch($qry)) {
$events = show(_next_event_link, array("datum" => date("d.m.", $get['datum']), "timestamp" => $get['datum'], "event" => $get['title']));
$eventbox .= show("menu/event", array("events" => $events));
}
return empty($eventbox) ? '<center style="margin:2px 0">' . _no_events . '</center>' : '<table class="navContent" cellspacing="0">' . $eventbox . '</table>';
}
function l_wars()
{
global $db, $maxlwars, $llwars, $allowHover;
$qry = db("SELECT s1.datum,s1.gegner,s1.id,s1.bericht,s1.xonx,s1.clantag,s1.punkte,s1.gpunkte,s1.squad_id,s2.icon,s2.name FROM " . $db['cw'] . " AS s1\n LEFT JOIN " . $db['squads'] . " AS s2 ON s1.squad_id = s2.id\n WHERE datum < " . time() . "\n ORDER BY datum DESC\n LIMIT " . $maxlwars . "");
while ($get = _fetch($qry)) {
if ($allowHover == 1 || $allowHover == 2) {
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . jsconvert(re($get['name'])) . '<br/>vs.<br/> ' . jsconvert(re($get['gegner'])) . '</td></tr><tr><td><b>' . _played_at . ':</b></td><td>' . date("d.m.Y H:i", $get['datum']) . _uhr . '</td></tr><tr><td><b>' . _cw_xonx . ':</b></td><td>' . jsconvert(re($get['xonx'])) . '</td></tr><tr><td><b>' . _result . ':</b></td><td>' . cw_result_nopic_raw($get['punkte'], $get['gpunkte']) . '</td></tr><tr><td><b>' . _comments_head . ':</b></td><td>' . cnt($db['cw_comments'], "WHERE cw = '" . $get['id'] . "'") . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$lwars .= show("menu/last_wars", array("id" => $get['id'], "clantag" => re(cut($get['clantag'], $llwars)), "icon" => re($get['icon']), "info" => $info, "result" => cw_result_pic($get['punkte'], $get['gpunkte'])));
}
return empty($lwars) ? '' : '<table class="navContent" cellspacing="0">' . $lwars . '</table>';
}
function top_dl()
{
global $db, $maxtopdl, $ltopdl, $allowHover;
$qry = db("SELECT * FROM " . $db['downloads'] . " ORDER BY hits DESC\n LIMIT " . $maxtopdl . "");
while ($get = _fetch($qry)) {
if ($allowHover == 1) {
$getkat = _fetch(db("SELECT name FROM " . $db['dl_kat'] . " WHERE id = '" . $get['kat'] . "'"));
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . jsconvert(re($get['download'])) . '</td></tr><tr><td><b>' . _datum . ':</b></td><td>' . date("d.m.Y H:i", $get['date']) . _uhr . '</td></tr><tr><td><b>' . _dl_dlkat . ':</b></td><td>' . jsconvert(re($getkat['name'])) . '</td></tr><tr><td><b>' . _hits . ':</b></td><td>' . $get['hits'] . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$top_dl .= show("menu/top_dl", array("id" => $get['id'], "titel" => cut(re($get['download']), $ltopdl), "info" => $info, "hits" => $get['hits']));
}
return empty($top_dl) ? '' : '<table class="navContent" cellspacing="0">' . $top_dl . '</table>';
}
function partners()
{
global $db;
$qry = db("SELECT * FROM " . $db['partners'] . " ORDER BY `textlink` ASC, `id` DESC");
while ($get = _fetch($qry)) {
if ($get['textlink'] == 1) {
$partners .= show("menu/partners_textlink", array("link" => $get['link'], "name" => re($get['banner'])));
} else {
$partners .= show("menu/partners", array("link" => re($get['link']), "title" => htmlspecialchars(str_replace('http://', '', re($get['link']))), "banner" => re($get['banner'])));
}
$table = strstr($partners, '<tr>') ? true : false;
}
return empty($partners) ? '' : ($table ? '<table class="navContent" cellspacing="0">' . $partners . '</table>' : $partners);
}
function n_wars()
{
global $db, $maxnwars, $lnwars, $allowHover;
$qry = db("SELECT s1.id,s1.datum,s1.clantag,s1.maps,s1.gegner,s1.squad_id,s2.icon,s1.xonx,s2.name FROM " . $db['cw'] . " AS s1\n LEFT JOIN " . $db['squads'] . " AS s2 ON s1.squad_id = s2.id\n WHERE s1.datum > " . time() . "\n ORDER BY s1.datum\n LIMIT " . $maxnwars . "");
if (_rows($qry)) {
while ($get = _fetch($qry)) {
if ($allowHover == 1 || $allowHover == 2) {
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . jsconvert(re($get['name'])) . '<br/>vs.<br /> ' . jsconvert(re($get['gegner'])) . '</td></tr><tr><td><b>' . _datum . ':</b></td><td>' . date("d.m.Y H:i", $get['datum']) . _uhr . '</td></tr><tr><td><b>' . _cw_xonx . ':</b></td><td>' . jsconvert(re($get['xonx'])) . '</td></tr><tr><td><b>' . _cw_maps . ':</b></td><td>' . jsconvert(re($get['maps'])) . '</td></tr><tr><td><b>' . _comments_head . ':</b></td><td>' . cnt($db['cw_comments'], "WHERE cw = '" . $get['id'] . "'") . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$nwars .= show("menu/next_wars", array("id" => $get['id'], "clantag" => re(cut($get['clantag'], $lnwars)), "icon" => re($get['icon']), "info" => $info, "datum" => date("d.m.:", $get['datum'])));
}
}
return empty($nwars) ? '' : '<table class="navContent" cellspacing="0">' . $nwars . '</table>';
}
function team($tID = '')
{
global $db, $teamRow, $l_team;
//SQL
if (!empty($tID)) {
$where = "WHERE id = '" . intval($tID) . "' AND navi = 1";
} else {
$where = "WHERE navi = '1' ORDER BY RAND()";
}
$get = _fetch(db("SELECT * FROM " . $db['squads'] . " " . $where . ""));
//Members
$qrym = db("SELECT s1.squad,s2.id,s2.level,s2.nick,s2.status,s2.rlname,s2.bday,s4.position\n FROM " . $db['squaduser'] . " AS s1\n LEFT JOIN " . $db['users'] . " AS s2\n ON s2.id=s1.user\n LEFT JOIN " . $db['userpos'] . " AS s3\n ON s3.squad=s1.squad AND s3.user=s1.user\n LEFT JOIN " . $db['pos'] . " AS s4\n ON s4.id=s3.posi\n WHERE s1.squad='" . $get['id'] . "'\n AND s2.level != 0\n ORDER BY s4.pid");
$i = 1;
$cnt = 0;
while ($getm = _fetch($qrym)) {
unset($tr1, $tr2);
if ($i == 0 || $i == 1) {
$tr1 = "<tr>";
}
if ($i == $teamRow) {
$tr2 = "</tr>";
$i = 0;
}
$status = $getm['status'] == 1 || $getm['level'] == 1 ? _aktiv : _inaktiv;
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . rawautor($getm['id']) . '</td></tr><tr><td width=80px><b>' . _posi . ':</b></td><td>' . getrank($getm['id'], $get['id']) . '</td></tr><tr><td><b>' . _status . ':</b></td><td>' . $status . '</td></tr><tr><td><b>' . _age . ':</b></td><td>' . getAge($getm['bday']) . '</td></tr><tr><td colspan=2 align=center>' . jsconvert(userpic($getm['id'])) . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
$member .= show("menu/team_show", array("pic" => userpic($getm['id'], 40, 50), "tr1" => $tr1, "tr2" => $tr2, "squad" => $get['id'], "info" => $info, "id" => $getm['id'], "width" => round(100 / $teamRow, 0)));
$i++;
$cnt++;
}
if (is_float($cnt / $teamRow)) {
for ($e = $i; $e <= $teamRow; $e++) {
$end .= '<td></td>';
}
$end = $end . "</tr>";
}
// Next / last ID
$all = cnt($db['squads'], "WHERE `navi` = '1'");
$next = _fetch(db("SELECT id FROM " . $db['squads'] . " WHERE `navi` = '1' AND `id` > '" . $get['id'] . "' ORDER BY `id` ASC LIMIT 1"));
if (empty($next)) {
$next = _fetch(db("SELECT id FROM " . $db['squads'] . " WHERE `navi` = '1' ORDER BY `id` ASC LIMIT 1"));
}
$last = _fetch(db("SELECT id FROM " . $db['squads'] . " WHERE `navi` = '1' AND `id` < '" . $get['id'] . "' ORDER BY `id` DESC LIMIT 1"));
if (empty($last)) {
$last = _fetch(db("SELECT id FROM " . $db['squads'] . " WHERE `navi` = '1' ORDER BY `id` DESC LIMIT 1"));
}
//Output
$team = show("menu/team", array("row" => $teamRow, "team" => re($get['name']), "id" => $get['id'], "next" => $next['id'], "last" => $last['id'], "br1" => $all <= 1 ? '<!--' : '', "br2" => $all <= 1 ? '-->' : '', "member" => $member, "end" => $end));
return '<div id="navTeam">' . $team . '</div>';
}
function newsticker()
{
global $db, $allowHover;
if (!permission("intnews")) {
$int = "AND intern = 0";
}
$qry = db("SELECT id,titel,autor,datum,kat FROM " . $db['news'] . " WHERE public = '1'AND datum <= '" . time() . "' " . $int . " ORDER BY id DESC LIMIT 20");
while ($get = _fetch($qry)) {
if ($allowHover == 1) {
$getkat = _fetch(db("SELECT kategorie FROM " . $db['newskat'] . " WHERE id = '" . $get['kat'] . "'"));
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . jsconvert(re($get['titel'])) . '</td></tr><tr><td><b>' . _datum . ':</b></td><td>' . date("d.m.Y H:i", $get['datum']) . _uhr . '</td></tr><tr><td><b>' . _autor . ':</b></td><td>' . rawautor($get['autor']) . '</td></tr><tr><td><b>' . _news_admin_kat . ':</b></td><td>' . jsconvert(re($getkat['kategorie'])) . '</td></tr><tr><td><b>' . _comments_head . ':</b></td><td>' . cnt($db['newscomments'], "WHERE news = '" . $get['id'] . "'") . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$news .= '<a href="../news/?action=show&id=' . $get['id'] . '" ' . $info . '>' . re($get['titel']) . '</a> | ';
}
return show("menu/newsticker", array("news" => $news));
}
function l_artikel()
{
global $db, $maxlartikel, $lartikel, $allowHover;
$qry = db("SELECT id,titel,text,autor,datum,kat,public FROM " . $db['artikel'] . "\n\t\t\t WHERE public = 1\n ORDER BY id DESC\n LIMIT " . $maxlartikel . "");
if (_rows($qry)) {
while ($get = _fetch($qry)) {
$qrykat = db("SELECT kategorie FROM " . $db['newskat'] . "\n WHERE id = '" . $get['kat'] . "'");
$getkat = _fetch($qrykat);
$text = strip_tags($get['text']);
if ($allowHover == 1) {
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . jsconvert(re($get['titel'])) . '</td></tr><tr><td><b>' . _datum . ':</b></td><td>' . date("d.m.Y H:i", $get['datum']) . _uhr . '</td></tr><tr><td><b>' . _autor . ':</b></td><td>' . rawautor($get['autor']) . '</td></tr><tr><td><b>' . _news_admin_kat . ':</b></td><td>' . jsconvert(re($getkat['kategorie'])) . '</td></tr><tr><td><b>' . _comments_head . ':</b></td><td>' . cnt($db['acomments'], "WHERE artikel = '" . $get['id'] . "'") . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$l_articles .= show("menu/last_artikel", array("id" => $get['id'], "titel" => re(cut($get['titel'], $lartikel)), "text" => cut(bbcode($text), 260), "datum" => date("d.m.Y", $get['datum']), "info" => $info));
}
}
return empty($l_articles) ? '' : '<table class="navContent" cellspacing="0">' . $l_articles . '</table>';
}
function l_news()
{
global $db, $maxlnews, $lnews, $allowHover;
if (!permission("intnews")) {
$int = "AND intern = 0";
}
$qry = db("SELECT id,titel,autor,datum,kat,public,timeshift FROM " . $db['news'] . "\n WHERE public = 1\n\t\t\t\t\t\t\t AND datum <= " . time() . "\n\t\t\t " . $int . "\n ORDER BY id DESC\n LIMIT " . $maxlnews . "");
while ($get = _fetch($qry)) {
$qrykat = db("SELECT kategorie FROM " . $db['newskat'] . "\n WHERE id = '" . $get['kat'] . "'");
$getkat = _fetch($qrykat);
if ($allowHover == 1) {
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . jsconvert(re($get['titel'])) . '</td></tr><tr><td><b>' . _datum . ':</b></td><td>' . date("d.m.Y H:i", $get['datum']) . _uhr . '</td></tr><tr><td><b>' . _autor . ':</b></td><td>' . rawautor($get['autor']) . '</td></tr><tr><td><b>' . _news_admin_kat . ':</b></td><td>' . jsconvert(re($getkat['kategorie'])) . '</td></tr><tr><td><b>' . _comments_head . ':</b></td><td>' . cnt($db['newscomments'], "WHERE news = '" . $get['id'] . "'") . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$l_news .= show("menu/last_news", array("id" => $get['id'], "titel" => re(cut($get['titel'], $lnews)), "datum" => date("d.m.Y", $get['datum']), "info" => $info));
}
return empty($l_news) ? '' : '<table class="navContent" cellspacing="0">' . $l_news . '</table>';
}
function random_gallery()
{
global $db;
$imgArr = array();
$files = get_files('../gallery/images/');
$get = _fetch(db("SELECT * FROM " . $db['gallery'] . " ORDER BY RAND()"));
foreach ($files as $file) {
if (intval($file) == $get['id']) {
array_push($imgArr, $file);
}
}
shuffle($imgArr);
if (!empty($imgArr[0])) {
$gallery = show("menu/random_gallery", array("image" => $imgArr[0], "id" => $get['id'], "kat" => re($get['kat'])));
}
return empty($gallery) ? '' : '<table class="navContent" cellspacing="0">' . $gallery . '</table>';
}
function uotm()
{
global $db, $allowHover;
$imgFiles = array();
$folder = get_files('../inc/images/uploads/userpics');
foreach ($folder as $file) {
array_push($imgFiles, $file);
}
if (count($imgFiles) != 0) {
$userid = intval($imgFiles[rand(0, count($imgFiles) - 1)]);
$get = _fetch(db("SELECT id,nick,country,bday FROM " . $db['users'] . " WHERE id = '" . $userid . "'"));
if (!empty($get)) {
if ($allowHover == 1) {
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . rawautor($get['id']) . '</td></tr><tr><td width=50%><b>' . _age . ':</b></td><td>' . getAge($get['bday']) . '</td></tr><tr><td colspan=2 align=center>' . jsconvert(userpic($get['id'])) . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$uotm = show("menu/uotm", array("uid" => $userid, "upic" => userpic($get['id'], 130, 161), "info" => $info));
}
}
return empty($uotm) ? '' : '<table class="navContent" cellspacing="0">' . $uotm . '</table>';
}
function shout($ajax = 0)
{
global $db, $maxshout, $lshouttext, $lshoutnick, $shout_max_zeichen, $userid, $chkMe;
$qry = db("SELECT * FROM " . $db['shout'] . "\n ORDER BY id DESC LIMIT " . $maxshout . "");
$i = 1;
while ($get = _fetch($qry)) {
$class = $color % 2 ? "navShoutContentFirst" : "navShoutContentSecond";
$color++;
if (permission("shoutbox")) {
$delete = '<a href="../shout/?action=admin&do=delete&id=' . $get['id'] . '" onclick="return(DZCP.del(\'' . _confirm_del_shout . '\'))"><img src="../inc/images/delete_small.gif" title="' . _button_title_del . '" alt="' . _button_title_del . '" /></a>';
} else {
$delete = "";
}
$is_num = preg_match("#\\d#", $get['email']);
if ($is_num && !check_email($get['email'])) {
$nick = autor($get['email'], "navShout");
} else {
$nick = '<a class="navShout" href="mailto:' . eMailAddr($get['email']) . '" title="' . $get['nick'] . '">' . cut($get['nick'], $lshoutnick) . '</a>';
}
$show .= show("menu/shout_part", array("nick" => $nick, "datum" => date("j.m.Y H:i", $get['datum']) . _uhr, "text" => bbcode(wrap(re($get['text']), $lshouttext)), "class" => $class, "del" => $delete));
$i++;
}
if (settings('reg_shout') == 1 && $chkMe == 'unlogged') {
$dis = ' style="text-align:center;cursor:wait" disabled="disabled"';
$dis1 = ' style="cursor:wait;color:#888" disabled="disabled"';
$only4reg = _shout_must_reg;
} else {
if ($chkMe == "unlogged") {
$form = show("menu/shout_form", array("dis" => $dis));
$sec = show("menu/shout_antispam", array("help" => _login_secure_help, "dis" => $dis));
} else {
$form = autor($userid, "navShout");
}
}
$add = show("menu/shout_add", array("form" => $form, "t_zeichen" => _zeichen, "noch" => _noch, "dis1" => $dis1, "dis" => $dis, "only4reg" => $only4reg, "security" => $sec, "zeichen" => $shout_max_zeichen));
$shout = show("menu/shout", array("shout" => $show, "shoutbox" => _shoutbox_head, "archiv" => _shoutbox_archiv, "add" => $add));
return empty($ajax) ? '<table class="navContent" cellspacing="0">' . $shout . '</table>' : $show;
}
function counter()
{
global $db, $today, $counter_start, $useronline, $where, $isSpider;
if (!$isSpider) {
$qry2day = db("SELECT visitors FROM " . $db['counter'] . "\n WHERE today = '" . $today . "'");
if (_rows($qry2day)) {
$get2day = _fetch($qry2day);
$v_today = $get2day['visitors'];
} else {
$v_today = 0;
}
$gestern = time() - 86400;
$tag = date("j", $gestern);
$monat = date("n", $gestern);
$jahr = date("Y", $gestern);
$yesterday = $tag . "." . $monat . "." . $jahr;
$qryyday = db("SELECT visitors FROM " . $db['counter'] . "\n WHERE today = '" . $yesterday . "'");
if (_rows($qryyday)) {
$getyday = _fetch($qryyday);
$yDay = $getyday['visitors'];
} else {
$yDay = 0;
}
$qrystats = db("SELECT SUM(visitors) AS allvisitors,\n MAX(visitors) AS maxvisitors,\n MAX(maxonline) AS maxonline,\n AVG(visitors) AS avgvisitors,\n SUM(visitors) AS allvisitors\n FROM " . $db['counter'] . "");
$getstats = _fetch($qrystats);
if (abs(online_reg()) != 0) {
$qryo = db("SELECT id FROM " . $db['users'] . "\n WHERE time+'" . $useronline . "'>'" . time() . "'\n AND online = 1\n ORDER BY nick");
while ($geto = _fetch($qryo)) {
$ousers .= '<tr><td>' . rawautor($geto['id']) . '</td><td align=right valign=middle><small>' . jsconvert(getrank($geto['id'])) . '</small></td></tr>';
}
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . _online_head . '</td></tr><tr><td><table width=100% cellpadding=0 cellspacing=0>' . $ousers . '</table></td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$counter = show("menu/counter", array("v_today" => $v_today, "v_yesterday" => $yDay, "v_all" => $getstats['allvisitors'] + $counter_start, "v_perday" => round($getstats['avgvisitors'], 2), "v_max" => $getstats['maxvisitors'], "g_online" => abs(online_guests($where) - online_reg()), "u_online" => abs(online_reg()), "info" => $info, "v_online" => $getstats['maxonline'], "head_online" => _head_online, "head_visits" => _head_visits, "head_max" => _head_max, "user" => _cnt_user, "guests" => _cnt_guests, "today" => _cnt_today, "yesterday" => _cnt_yesterday, "all" => _cnt_all, "percentperday" => _cnt_pperday, "perday" => _cnt_perday, "online" => _cnt_online));
return '<table class="navContent" cellspacing="0">' . $counter . '</table>';
}
}
function jokes()
{
global $db, $sql_prefix, $userid;
//###### Settings #####
$maxl = 600;
//### Settings Ende ###
//rating speichern
if (isset($_GET['jid']) and isset($_GET['jokerating']) and isset($userid) and $_GET['jokerating'] <= 5) {
$al = mysql_num_rows(db("SELECT id FROM " . $sql_prefix . "joke_rating WHERE jid LIKE '" . $_get['jid'] . "' AND uid LIKE '" . $userid . "'"));
if ($al == 0) {
$qry = db("INSERT INTO " . $sql_prefix . "joke_rating \n SET `jid` = '" . (int) $_GET['jid'] . "',\n `uid` = '" . (int) $userid . "',\n `pkt` = '" . (int) $_GET['jokerating'] . "'");
}
}
//Ausgabe
$min = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$max = mktime(23, 59, 59, date("m"), date("d"), date("Y"));
$qrys = db("SELECT * FROM " . $sql_prefix . "jokes WHERE date >= " . $min . " AND date < " . $max . " AND status != 0 ORDER BY RAND()");
if (mysql_num_rows($qrys) != 0) {
$get = _fetch($qrys);
$content = $get['content'];
$textparts = explode("\n", wordwrap($content, 200, "\n"));
if ($get['content'] != $textparts[0]) {
$content = $textparts[0] . " [...]";
$more = '<a href="../jokes/?action=show&id=' . $get['id'] . '">' . _jokes_more . '</a>';
} else {
$content = $textparts[0];
$more = '<a href="../jokes/?action=show&id=' . $get['id'] . '">' . _jokes_show . '</a>';
}
//rating
if (isset($userid)) {
$bv = mysql_num_rows(db("SELECT * FROM " . $sql_prefix . "joke_rating WHERE jid LIKE " . $get['id'] . " AND uid LIKE " . $userid . ""));
if ($bv == '0') {
/*$rating = 'Vote:
<a href="?'.$_SERVER['QUERY_STRING'].'&jokerating=1&jid='.$get['id'].'">1</a>
<a href="?'.$_SERVER['QUERY_STRING'].'&jokerating=2&jid='.$get['id'].'">2</a>
<a href="?'.$_SERVER['QUERY_STRING'].'&jokerating=3&jid='.$get['id'].'">3</a>
<a href="?'.$_SERVER['QUERY_STRING'].'&jokerating=4&jid='.$get['id'].'">4</a>
<a href="?'.$_SERVER['QUERY_STRING'].'&jokerating=5&jid='.$get['id'].'">5</a>';*/
//RATING FUNKTION
?>
<link rel="stylesheet" type="text/css" href="../jokes/style.css">
<script type="text/javascript" src="../jokes/jquery.js"></script>
<script type="text/javascript" src="../jokes/script.js"></script>
<?php
$votee = db("SELECT avg(pkt) AS rating FROM " . $sql_prefix . "joke_rating WHERE jid LIKE " . $get['id'], true, true);
$rating = round($votee[0], 1);
if ($rating > 0) {
$hover1 = 'class="hover"';
} else {
$hover1 = "";
}
if ($rating > 1.5) {
$hover2 = 'class="hover"';
} else {
$hover2 = "";
}
if ($rating > 2.5) {
$hover3 = 'class="hover"';
} else {
$hover3 = "";
}
if ($rating > 3.5) {
$hover4 = 'class="hover"';
} else {
$hover4 = "";
}
if ($rating > 4.5) {
$hover5 = 'class="hover"';
} else {
$hover5 = "";
}
$rating = '
<div id="rating_' . $get['id'] . '">
<span class="star_1"><img src="../jokes/star_blank.png" alt="" ' . $hover1 . '/></span>
<span class="star_2"><img src="../jokes/star_blank.png" alt="" ' . $hover2 . '/></span>
<span class="star_3"><img src="../jokes/star_blank.png" alt="" ' . $hover3 . '/></span>
<span class="star_4"><img src="../jokes/star_blank.png" alt="" ' . $hover4 . '/></span>
<span class="star_5"><img src="../jokes/star_blank.png" alt="" ' . $hover5 . '/></span>
</div>
<div class="clearleft"> </div> ';
//RATING FUNKTION ENDE
} else {
?>
<style type="text/css">
.hover {
background: url('../jokes/star.png');
z-index: 1;
}
img {
border: 0;
}
</style>
<?php
$votee = db("SELECT avg(pkt) AS rating FROM " . $sql_prefix . "joke_rating WHERE jid LIKE " . $get['id'], true, true);
$rating = round($votee[0], 1);
if ($rating > 0) {
$hover1 = 'class="hover"';
} else {
$hover1 = "";
}
if ($rating > 1.5) {
$hover2 = 'class="hover"';
} else {
$hover2 = "";
}
if ($rating > 2.5) {
$hover3 = 'class="hover"';
} else {
$hover3 = "";
}
if ($rating > 3.5) {
$hover4 = 'class="hover"';
} else {
$hover4 = "";
}
if ($rating > 4.5) {
$hover5 = 'class="hover"';
} else {
$hover5 = "";
}
$rating = '
<div id="rating_' . $get['id'] . '">
<span><img src="../jokes/star_blank.png" alt="" ' . $hover1 . '/></span>
<span><img src="../jokes/star_blank.png" alt="" ' . $hover2 . '/></span>
<span><img src="../jokes/star_blank.png" alt="" ' . $hover3 . '/></span>
<span><img src="../jokes/star_blank.png" alt="" ' . $hover4 . '/></span>
<span><img src="../jokes/star_blank.png" alt="" ' . $hover5 . '/></span>
</div>
<div class="clearleft"> </div>' . _jokes_voted;
}
} else {
?>
<style type="text/css">
.hover {
background: url('../jokes/star.png');
z-index: 1;
}
img {
border: 0;
}
</style>
<?php
$votee = db("SELECT avg(pkt) AS rating FROM " . $sql_prefix . "joke_rating WHERE jid LIKE " . $get['id'], true, true);
$rating = round($votee[0], 1);
if ($rating > 0) {
$hover1 = 'class="hover"';
} else {
$hover1 = "";
}
if ($rating > 1.5) {
$hover2 = 'class="hover"';
} else {
$hover2 = "";
}
if ($rating > 2.5) {
$hover3 = 'class="hover"';
} else {
$hover3 = "";
}
if ($rating > 3.5) {
$hover4 = 'class="hover"';
} else {
$hover4 = "";
}
if ($rating > 4.5) {
$hover5 = 'class="hover"';
} else {
$hover5 = "";
}
$rating = '
<div id="rating_' . $get['id'] . '">
<span><img src="../jokes/star_blank.png" alt="" ' . $hover1 . '/></span>
<span><img src="../jokes/star_blank.png" alt="" ' . $hover2 . '/></span>
<span><img src="../jokes/star_blank.png" alt="" ' . $hover3 . '/></span>
<span><img src="../jokes/star_blank.png" alt="" ' . $hover4 . '/></span>
<span><img src="../jokes/star_blank.png" alt="" ' . $hover5 . '/></span>
</div>
<div class="clearleft"> </div>' . _jokes_login;
}
$index = show("menu/jokes", array("title" => "Witz von " . autor($get['uid']), "content" => bbcode($content), "more" => $more, "rating" => $rating));
} else {
//nichts eingetragen
$index = show("menu/jokes", array("title" => "", "content" => _jokes_empty, "more" => "", "rating" => ""));
}
return empty($index) ? '' : '<table class="navContent" cellspacing="0">' . $index . '</table>';
}
$data .= '<td class="calDay"></td>';
} elseif ($datum == $ktoday) {
$data .= show($dir . "/day", array("day" => $day, "event" => $events, "class" => "calToday"));
} else {
$data .= show($dir . "/day", array("day" => $day, "event" => $events, "class" => "calDay"));
}
$i++;
}
}
$show .= "<tr>" . $data . "</tr>";
}
$index = show($dir . "/kalender", array("monate" => $month, "jahr" => $year, "show" => $show, "what" => _button_value_show, "montag" => _montag, "dienstag" => _dienstag, "mittwoch" => _mittwoch, "donnerstag" => _donnerstag, "freitag" => _freitag, "samstag" => _samstag, "sonntag" => _sonntag, "head" => _kalender_head));
break;
case 'show':
$qry = db("SELECT * FROM " . $db['events'] . "\n WHERE DATE_FORMAT(FROM_UNIXTIME(datum), '%d.%m.%Y') = '" . date("d.m.Y", intval($_GET['time'])) . "'\n ORDER BY datum");
while ($get = _fetch($qry)) {
if (permission("editkalender")) {
$edit = show("page/button_edit", array("id" => $get['id'], "action" => "action=admin&do=edit", "title" => _button_title_edit));
} else {
$edit = "";
}
$events .= show($dir . "/event_show", array("event" => _kalender_event, "time" => _kalender_uhrzeit, "edit" => $edit, "show_time" => date("H:i", $get['datum']) . _uhr, "show_event" => bbcode($get['event']), "show_title" => re($get['title'])));
}
$head = show(_kalender_events_head, array("datum" => date("d.m.Y", $_GET['time'])));
$index = show($dir . "/event", array("head" => $head, "events" => $events));
break;
case 'admin':
header("Location: ../admin/?admin=kalender&do=edit&id=" . $_GET['id']);
break;
}
## INDEX OUTPUT ##
$qry = db("SELECT id,user,nick,pwd,email,level,position,listck\n FROM " . $db['users'] . "\n WHERE id = '" . intval($_GET['edit']) . "'");
while ($get = _fetch($qry)) {
if ($get['level'] == 1) {
$selu = "selected=\"selected\"";
} elseif ($get['level'] == 2) {
$selt = "selected=\"selected\"";
} elseif ($get['level'] == 3) {
$selm = "selected=\"selected\"";
} elseif ($get['level'] == 4) {
$sela = "selected=\"selected\"";
}
$qrysq = db("SELECT id,name FROM " . $db['squads'] . "\n ORDER BY pos");
while ($getsq = _fetch($qrysq)) {
$qrypos = db("SELECT id,position FROM " . $db['pos'] . "\n ORDER BY pid");
$posi = "";
while ($getpos = _fetch($qrypos)) {
$check = db("SELECT * FROM " . $db['userpos'] . "\n WHERE posi = '" . $getpos['id'] . "'\n AND squad = '" . $getsq['id'] . "'\n AND user = '******'edit']) . "'");
if (_rows($check)) {
$sel = "selected=\"selected\"";
} else {
$sel = "";
}
$posi .= show(_select_field_posis, array("value" => $getpos['id'], "sel" => $sel, "what" => re($getpos['position'])));
}
$qrysquser = db("SELECT squad FROM " . $db['squaduser'] . "\n WHERE user = '******'edit']) . "'\n AND squad = '" . $getsq['id'] . "'");
if (_rows($qrysquser)) {
$check = "checked=\"checked\"";
} else {
$check = "";
}
$esquads .= show(_checkfield_squads, array("id" => $getsq['id'], "check" => $check, "eposi" => $posi, "noposi" => _user_noposi, "squad" => re($getsq['name'])));
include basePath . "/inc/bbcode.php";
## SETTINGS ##
$time_start = generatetime();
lang($language);
$where = 'Mitgliederkarte';
$dir = "membermap";
## SECTIONS ##
$mm_qry = db('SELECT u.`id`, u.`nick`, u.`city`, u.`gmaps_koord` FROM ' . $db['users'] . ' u WHERE u.`gmaps_koord` != "" ORDER BY u.gmaps_koord, u.id');
$mm_coords = '';
$mm_infos = "'<tr>";
$mm_markerIcon = '';
$mm_lastCoord = '';
$i = 0;
$realCount = 0;
$markerCount = 0;
while ($mm_get = _fetch($mm_qry)) {
if ($mm_lastCoord != $mm_get['gmaps_koord']) {
if ($i > 0) {
$mm_coords .= ',';
$mm_infos .= "</tr>','<tr>";
}
$mm_infos .= '<td><b style="font-size:13px"> ' . re($mm_get['city']) . '</td></tr><tr>';
$mm_coords .= 'new google.maps.LatLng' . $mm_get['gmaps_koord'];
$realCount++;
} else {
if ($markerCount > 0) {
$mm_markerIcon .= ',';
}
$mm_markerIcon .= $realCount - 1 . ':true';
$markerCount++;
}
$posi = db("UPDATE " . $db['squads'] . "\n SET `pos` = pos+1\n WHERE pos " . $sign . " '" . intval($_POST['position']) . "'");
}
if ($_POST['position'] == "lazy") {
$newpos = "";
} else {
$newpos = "`pos` = '" . (int) $_POST['position'] . "',";
}
if ($_POST['icon'] == "lazy") {
$newicon = "";
} else {
$newicon = "`icon` = '" . up($_POST['icon']) . "',";
}
$qry = db("UPDATE " . $db['squads'] . "\n SET `name` = '" . up($_POST['squad']) . "',\n `game` = '" . up($_POST['game']) . "',\n " . $newpos . "\n " . $newicon . "\n `beschreibung` = '" . up($_POST['beschreibung'], 1) . "',\n `shown` = '" . (int) $_POST['show'] . "',\n `navi` = '" . (int) $_POST['roster'] . "',\n\t\t\t\t\t\t\t\t\t\t\t\t `team_show`\t\t= '" . (int) $_POST['team_show'] . "',\n `status` = '" . (int) $_POST['status'] . "'\n WHERE id = '" . intval($_GET['id']) . "'");
if ($_POST['navi'] != "lazy") {
$qry = db("SELECT * FROM " . $db['navi'] . " WHERE url = '../squads/?action=shows&id=" . intval($_GET['id']) . "'");
$get = _fetch($qry);
if (_rows($qry)) {
if ($_POST['navi'] == "1" || "2") {
$sign = ">= ";
} else {
$sign = "> ";
}
$kat = preg_replace('/-(\\d+)/', '', $_POST['navi']);
$pos = preg_replace("=nav_(.+)-=", "", $_POST['navi']);
$posi = db("UPDATE " . $db['navi'] . "\n\t\t\t\t\t\t\t\t\t\t\t\t\tSET pos = pos+1\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE pos " . $sign . " '" . intval($pos) . "'");
$posi = db("UPDATE " . $db['navi'] . "\n\t\t\t\t\t\t\t\t\t\t\t\t\tSET `pos` = '" . (int) $pos . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`kat` = '" . up($kat) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`name` = '" . up($_POST['squad']) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`url` = '../squads/?action=shows&id=" . intval($_GET['id']) . "'\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE id = '" . intval($get['id']) . "'");
} else {
if ($_POST['navi'] == "1" || "2") {
$signnav = ">= ";
} else {
$signnav = "> ";
}
if (!empty($p)) {
$p = ', ' . substr($p, 0, strlen($p) - 1);
}
db("INSERT INTO " . $db['permissions'] . " SET `user` = '" . intval($insert_id) . "'" . $p);
}
////////////////////
// internal boardpermissions
if (!empty($_POST['board'])) {
foreach ($_POST['board'] as $v) {
db("INSERT INTO " . $db['f_access'] . " SET `user` = '" . intval($insert_id) . "', `forum` = '" . $v . "'");
}
}
////////////////////
$sq = db("SELECT * FROM " . $db['squads'] . "");
while ($getsq = _fetch($sq)) {
if (isset($_POST['squad' . $getsq['id']])) {
$qry = db("INSERT INTO " . $db['squaduser'] . "\n SET `user` = '" . (int) $insert_id . "',\n `squad` = '" . (int) $_POST['squad' . $getsq['id']] . "'");
}
if (isset($_POST['squad' . $getsq['id']])) {
$qry = db("INSERT INTO " . $db['userpos'] . "\n SET `user` = '" . (int) $insert_id . "',\n `posi` = '" . (int) $_POST['sqpos' . $getsq['id']] . "',\n `squad` = '" . (int) $getsq['id'] . "'");
}
}
$tmpname = $_FILES['file']['tmp_name'];
$name = $_FILES['file']['name'];
$type = $_FILES['file']['type'];
$size = $_FILES['file']['size'];
$endung = explode(".", $_FILES['file']['name']);
$endung = strtolower($endung[count($endung) - 1]);
if ($tmpname) {
$imageinfo = getimagesize($tmpname);
