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);