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 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 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 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>'; }
header("Content-type: text/html; charset=utf-8"); if ($_GET['do'] == 'edit') { $qry = db("SELECT * FROM " . $db['cw_comments'] . "\n WHERE id = '" . intval($_GET['cid']) . "'"); $get = _fetch($qry); $get_id = '?'; $get_userid = $get['reg']; $get_date = $get['datum']; if ($get['reg'] == 0) { $regCheck = false; } else { $regCheck = true; $pUId = $get['reg']; } $editedby = show(_edited_by, array("autor" => cleanautor($userid), "time" => date("d.m.Y H:i", time()) . _uhr)); } else { $get_id = cnt($db['cw_comments'], " WHERE cw = " . intval($_GET['id']) . "") + 1; $get_userid = $userid; $get_date = time(); if ($chkMe == 'unlogged') { $regCheck = false; } else { $regCheck = true; $pUId = $userid; } } $get_hp = $_POST['hp']; $get_email = $_POST['email']; $get_nick = $_POST['nick']; if (!$regCheck) { if ($get_hp) { $hp = show(_hpicon_forum, array("hp" => links($get_hp)));
} break; case 'preview': header("Content-type: text/html; charset=utf-8"); if (isset($_GET['edit']) && !empty($_GET['edit'])) { $qry = db("SELECT * FROM " . $db['gb'] . "\n WHERE id = '" . intval($_GET['edit']) . "'"); $get = _fetch($qry); $get_id = '?'; $get_userid = $get['reg']; $get_date = $get['datum']; if ($get['reg'] == 0) { $regCheck = true; } $editby = show(_edited_by, array("autor" => cleanautor($userid), "time" => date("d.m.Y H:i", time()) . _uhr)); } else { $get_id = cnt($db['gb']) + 1; $get_userid = $userid; $get_date = time(); if ($chkMe == 'unlogged') { $regCheck = true; } } $get_hp = $_POST['hp']; $get_email = $_POST['email']; $get_nick = $_POST['nick']; if ($get_hp) { $gbhp = show(_hpicon, array("hp" => links($get_hp))); } else { $gbhp = ""; } if ($get_email) {
$show = show($dir . "/form_vote", array("head" => _votes_admin_edit_head, "value" => "edit", "id" => $_GET['id'], "what" => $what, "value" => _button_value_edit, "br1" => "", "br2" => "", "question1" => re($get['titel']), "a1" => voteanswer("a1", $_GET['id']), "a2" => voteanswer("a2", $_GET['id']), "a3" => voteanswer("a3", $_GET['id']), "a4" => voteanswer("a4", $_GET['id']), "a5" => voteanswer("a5", $_GET['id']), "a6" => voteanswer("a6", $_GET['id']), "a7" => voteanswer("a7", $_GET['id']), "error" => "", "a8" => voteanswer("a8", $_GET['id']), "a9" => voteanswer("a9", $_GET['id']), "a10" => voteanswer("a10", $_GET['id']), "intern" => $intern, "isclosed" => $isclosed, "closed" => _votes_admin_closed, "interna" => _votes_admin_intern, "question" => _votes_admin_question, "answer" => _votes_admin_answer)); } elseif ($_GET['do'] == "editvote") { $qry = db("SELECT * FROM " . $db['vote_results'] . "\n WHERE vid = '" . intval($_GET['id']) . "'"); $get = _fetch($qry); $upd = db("UPDATE " . $db['votes'] . "\n SET `titel` = '" . up($_POST['question']) . "',\n `intern` = '" . (int) $_POST['intern'] . "',\n `closed` = '" . (int) $_POST['closed'] . "'\n WHERE id = '" . intval($_GET['id']) . "'"); $upd1 = db("UPDATE " . $db['vote_results'] . "\n SET `sel` = '" . up($_POST['a1']) . "'\n WHERE what = 'a1'\n AND vid = '" . intval($_GET['id']) . "'"); $upd2 = db("UPDATE " . $db['vote_results'] . "\n SET `sel` = '" . up($_POST['a2']) . "'\n WHERE what = 'a2'\n AND vid = '" . intval($_GET['id']) . "'"); for ($i = 3; $i <= 10; $i++) { if (!empty($_POST['a' . $i . ''])) { if (cnt($db['vote_results'], " WHERE vid = '" . intval($_GET['id']) . "' AND what = 'a" . $i . "'") != 0) { $upd = db("UPDATE " . $db['vote_results'] . "\n SET `sel` = '" . up($_POST['a' . $i . '']) . "'\n WHERE what = 'a" . $i . "'\n AND vid = '" . intval($_GET['id']) . "'"); } else { $ins = db("INSERT INTO " . $db['vote_results'] . "\n SET `vid` = '" . $_GET['id'] . "',\n `what` = 'a" . $i . "',\n `sel` = '" . up($_POST['a' . $i . '']) . "'"); } } if (cnt($db['vote_results'], " WHERE vid = '" . intval($_GET['id']) . "' AND what = 'a" . $i . "'") != 0 && empty($_POST['a' . $i . ''])) { $del = db("DELETE FROM " . $db['vote_results'] . "\n WHERE vid = '" . intval($_GET['id']) . "'\n AND what = 'a" . $i . "'"); } } $show = info(_vote_admin_successful_edited, "?admin=votes"); } elseif ($_GET['do'] == "menu") { $qryv = db("SELECT intern FROM " . $db['votes'] . "\n WHERE id = '" . intval($_GET['id']) . "'\n AND intern = 1"); if (_rows($qryv)) { $show = error(_vote_admin_menu_isintern, 1); } else { $qrys = db("SELECT * FROM " . $db['votes'] . "\n WHERE id = '" . intval($_GET['id']) . "'"); $get = _fetch($qrys); if ($get['menu'] == 1) { $qry = db("UPDATE " . $db['votes'] . "\n SET menu = '0'"); header("Location: ?admin=votes"); } else {
$qry = db("DELETE FROM " . $db['artikel'] . "\n WHERE id = '" . intval($_GET['id']) . "'"); $show = info(_artikel_deleted, "?admin=artikel"); } elseif ($_GET['do'] == 'public') { if ($_GET['what'] == 'set') { $upd = db("UPDATE " . $db['artikel'] . "\n SET `public` = '1',\n \t\t\t\t\t `datum` = '" . time() . "'\n WHERE id = '" . intval($_GET['id']) . "'"); } elseif ($_GET['what'] == 'unset') { $upd = db("UPDATE " . $db['artikel'] . "\n SET `public` = '0'\n WHERE id = '" . intval($_GET['id']) . "'"); } header("Location: ?admin=artikel"); } else { if (isset($_GET['page'])) { $page = $_GET['page']; } else { $page = 1; } $entrys = cnt($db['artikel']); $qry = db("SELECT * FROM " . $db['artikel'] . "\n ORDER BY `public` ASC, `datum` DESC \n\t\t\t\t\t\t\t\t\t LIMIT " . ($page - 1) * $maxadminartikel . "," . $maxadminartikel . ""); while ($get = _fetch($qry)) { $edit = show("page/button_edit_single", array("id" => $get['id'], "action" => "admin=artikel&do=edit", "title" => _button_title_edit)); $delete = show("page/button_delete_single", array("id" => $get['id'], "action" => "admin=artikel&do=delete", "title" => _button_title_del, "del" => convSpace(_confirm_del_artikel))); $titel = show(_artikel_show_link, array("titel" => re(cut($get['titel'], $lnewsadmin)), "id" => $get['id'])); $class = $color % 2 ? "contentMainSecond" : "contentMainFirst"; $color++; $public = $get['public'] == 1 ? '<a href="?admin=artikel&do=public&id=' . $get['id'] . '&what=unset"><img src="../inc/images/public.gif" alt="" title="' . _non_public . '" /></a>' : '<a href="?admin=artikel&do=public&id=' . $get['id'] . '&what=set"><img src="../inc/images/nonpublic.gif" alt="" title="' . _public . '" /></a>'; if (empty($get['datum'])) { $datum = _no_public; } else { $datum = date("d.m.y H:i", $get['datum']) . _uhr; } $show_ .= show($dir . "/admin_show", array("date" => $datum, "titel" => $titel, "class" => $class, "autor" => autor($get['autor']), "intnews" => "", "sticky" => "", "public" => $public, "edit" => $edit, "delete" => $delete)); }
} else { $pagenr = ceil($cntpage / $maxfposts); } $qrylp = db("SELECT date,nick,reg,email FROM " . $db['f_posts'] . "\n WHERE sid = '" . $get['id'] . "'\n ORDER BY date DESC"); if (_rows($qrylp)) { $getlp = _fetch($qrylp); $lpost = show(_forum_thread_lpost, array("nick" => autor($getlp['reg'], '', $getlp['nick'], $getlp['email']), "date" => date("d.m.y H:i", $getlp['date']) . _uhr)); $lpdate = $getlp['date']; } else { $lpost = "-"; $lpdate = ""; } $threadlink = show(_forum_thread_search_link, array("topic" => cut(re($get['topic']), $lforumtopic), "id" => $get['id'], "sticky" => $sticky, "hl" => $_GET['search'], "closed" => $closed, "lpid" => $cntpage + 1, "page" => $pagenr)); $class = $color % 2 ? "contentMainSecond" : "contentMainFirst"; $color++; $results .= show($dir . "/forum_search_results", array("new" => check_new($get['lp']), "topic" => $threadlink, "subtopic" => cut(re($get['subtopic']), $lforumsubtopic), "hits" => $get['hits'], "replys" => cnt($db['f_posts'], " WHERE sid = '" . $get['id'] . "'"), "class" => $class, "lpost" => $lpost, "autor" => autor($get['t_reg'], '', $get['t_nick'], $get['t_email']))); } } $nav = nav($entrys, $maxfsearch, $getstr); $show = show($dir . "/forum_search_show", array("head" => _forum_search_results, "autor" => _autor, "thread" => _forum_thread, "lpost" => _forum_lpost, "nav" => $nav, "results" => $results, "replys" => _forum_replys, "hits" => _hits)); } } //Diverse Abfragen if ($_GET['searchplugin'] == true) { $onclick = 'onclick="more(1)" style="cursor:pointer"'; $img = '<img id="img1" src="../inc/images/expand.gif" alt="" />'; $style = 'style="display:none"'; if ($_GET['si_board'] == true) { $si_board = "checked=\"checked\""; } if (empty($strkat)) {
$show = show($dir . "/forum_show_subkats", array("head" => _config_forum_head, "subkathead" => $skathead, "subkats" => $subkats, "add" => $add, "subkat" => _config_forum_subkat, "delete" => _deleteicon_blank, "edit" => _editicon_blank)); } } else { $qry = db("SELECT * FROM " . $db['f_kats'] . "\n ORDER BY kid"); while ($get = _fetch($qry)) { $kat = show(_config_forum_kats_titel, array("kat" => re($get['name']), "id" => $get['id'])); $edit = show("page/button_edit_single", array("id" => $get['id'], "action" => "admin=" . $_GET['admin'] . "&do=edit", "title" => _button_title_edit)); $delete = show("page/button_delete_single", array("id" => $get['id'], "action" => "admin=" . $_GET['admin'] . "&do=delete", "title" => _button_title_del, "del" => convSpace(_confirm_del_entry))); if ($get['intern'] == 1) { $status = _config_forum_intern; } else { $status = _config_forum_public; } $class = $color % 2 ? "contentMainSecond" : "contentMainFirst"; $color++; $kats .= show($dir . "/forum_show_kats", array("class" => $class, "kat" => $kat, "status" => $status, "skats" => cnt($db['f_skats'], " WHERE sid = '" . intval($get['id']) . "'"), "edit" => $edit, "delete" => $delete)); } $show = show($dir . "/forum", array("head" => _config_forum_head, "mainkat" => _config_forum_mainkat, "edit" => _editicon_blank, "skats" => _cnt, "status" => _config_forum_status, "delete" => _deleteicon_blank, "add" => _config_forum_kats_add, "kats" => $kats)); if ($_GET['do'] == "newkat") { $qry = db("SELECT * FROM " . $db['f_kats'] . "\n ORDER BY kid"); while ($get = _fetch($qry)) { $positions .= show(_select_field, array("value" => $get['kid'] + 1, "what" => _nach . ' ' . re($get['name']), "sel" => "")); } $show = show($dir . "/katform", array("fkat" => _config_katname, "head" => _config_forum_kat_head, "fkid" => _position, "fart" => _kind, "positions" => $positions, "public" => _config_forum_public, "intern" => _config_forum_intern, "value" => _button_value_add, "kat" => "")); } elseif ($_GET['do'] == "addkat") { if (!empty($_POST['kat'])) { if ($_POST['kid'] == "1" || "2") { $sign = ">= "; } else { $sign = "> "; }
$sel = ""; } $years .= show(_select_field, array("value" => $x, "sel" => $sel, "what" => $x)); } if ($language == "deutsch") { $endc = "n"; } else { $endc = ""; } $c = cnt($db['newscomments']); if ($c == "1") { $com = _news_kommentar; } else { $com = _news_kommentare . $endc; } $stats = show(_news_stats, array("news" => $entrys, "comments" => cnt($db['newscomments']), "com" => $com)); $qrykat = db("SELECT * FROM " . $db['newskat'] . ""); while ($getkat = _fetch($qrykat)) { $kategorien .= '<option value="' . $getkat['id'] . '">-> ' . $getkat['kategorie'] . '</option>'; } for ($i = 1; $i <= 12; $i++) { if (!$pyear) { if ($i == date("n", time())) { $sel[$i] = "selected=\"selected\""; } else { $sel[$i] = ""; } } else { if ($i == nonum($pmonth)) { $sel[$i] = "selected=\"selected\""; } else {
$img = "expand"; while ($getdl = _fetch($qrydl)) { if ($_GET['hl'] == $getdl['id']) { $display = ""; $img = "collapse"; $download = highlight(re($getdl['download'])); } else { $download = re($getdl['download']); } $link = show(_downloads_link, array("id" => $getdl['id'], "download" => $download, "titel" => re($getdl['download']), "target" => $target)); $class = $color % 2 ? "contentMainSecond" : "contentMainFirst"; $color++; $show .= show($dir . "/downloads_show", array("class" => $class, "link" => $link, "kid" => $get['id'], "display" => $display, "beschreibung" => bbcode($getdl['beschreibung']), "hits" => $getdl['hits'])); } $cntKat = cnt($db['downloads'], " WHERE kat = '" . $get['id'] . "'"); if (cnt($db['downloads'], "WHERE kat = '" . $get['id'] . "'") == 1) { $dltitel = _dl_file; } else { $dltitel = _site_stats_files; } $kat = show(_dl_titel, array("id" => $get['id'], "icon" => $moreicon, "file" => $dltitel, "cnt" => $cntKat, "name" => re($get['name']))); $class = $color % 2 ? "contentMainSecond" : "contentMainFirst"; $color++; $kats .= show($dir . "/download_kats", array("kat" => $kat, "class" => $class, "kid" => $get['id'], "img" => $img, "download" => _dl_file, "hits" => _hits, "show" => $show, "display" => $display)); } } $index = show($dir . "/downloads", array("kats" => $kats, "head" => _downloads_head)); break; case 'download': if (settings("reg_dl") == 1 && $chkMe == "unlogged") { $index = error(_error_unregistered);
} else { if ($_GET['do'] == "delete") { $qry = db("DELETE FROM " . $db['shout'] . "\n WHERE id = '" . intval($_GET['id']) . "'"); header("Location: " . $_SERVER['HTTP_REFERER'] . '#shoutbox'); } } break; case 'archiv': $where = _site_shoutbox; $title = $pagetitle . " - " . $where . ""; if (isset($_GET['page'])) { $page = $_GET['page']; } else { $page = 1; } $entrys = cnt($db['shout']); $i = $entrys - ($page - 1) * $maxshoutarchiv; $qry = db("SELECT * FROM " . $db['shout'] . "\n ORDER BY datum DESC\n LIMIT " . ($page - 1) * $maxshoutarchiv . "," . $maxshoutarchiv . ""); while ($get = _fetch($qry)) { $is_num = preg_match("#\\d#", $get['email']); if ($is_num && !check_email($get['email'])) { $nick = autor($get['email']); } else { $nick = '<a href="mailto:' . $get['email'] . '" title="' . $get['nick'] . '">' . cut($get['nick'], $lshoutnick) . '</a>'; } $class = $color % 2 ? "contentMainTop" : "contentMainFirst"; $color++; if (permission("shoutbox")) { $del = "<a href='../shout/?action=admin&do=delete&id=" . $get['id'] . "'>\n <img src='../inc/images/delete_small.gif' border='0' alt=''></a>"; } else { $del = "";
$where = "Installer"; $title = $pagetitle . " - " . $where . ""; ## INSTALLER ## if (isset($_POST['submit'])) { // alte Tabellen/Spalten löschen db("DROP TABLE IF EXISTS " . $sql_prefix . "clans"); // neue Tabellen/Spalten anlegen db("CREATE TABLE " . $sql_prefix . "clans (\n\t\t\t\t\t\t`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,\n`clantag` VARCHAR( 20 ) NOT NULL ,\n`gegner` VARCHAR( 100 ) NOT NULL ,\n`url` VARCHAR( 249 ) NOT NULL ,\n`country` VARCHAR( 20 ) NOT NULL DEFAULT 'de',\n\t\t\t\t\t\tPRIMARY KEY (`id`)) "); db("ALTER TABLE " . $sql_prefix . "clanwars ADD `cid` int(5) NOT NULL default '0'"); $qry = db("SELECT id,clantag,gegner,url,gcountry FROM " . $sql_prefix . "clanwars ORDER BY id"); while ($get = _fetch($qry)) { db("INSERT INTO " . $sql_prefix . "clans (id,clantag,gegner,url,country) VALUES \n\t\t('" . $get["id"] . "',\n\t\t'" . $get["clantag"] . "',\n\t\t'" . $get["gegner"] . "',\n\t\t'" . $get["url"] . "',\n\t\t'" . $get["gcountry"] . "')"); db("UPDATE " . $sql_prefix . "clanwars SET `cid` = " . $get["id"] . " WHERE id = " . $get["id"]); } // Check ob Install i.O. velief if (cnt($sql_prefix . "clans") > '0') { $show = '<tr> <td class="contentHead" align="center"><span class="fontGreen"><b>Installation erfolgreich!</b></span></td> </tr> <tr> <td class="contentMainFirst" align="center"> Die benötigten Tabellen konnten erfolgreich erstellt werden.<br> <br> <b>Lösche unbedingt den installer-Ordner!</b> </td> </tr> <tr> <td class="contentBottom"></td> </tr>'; } else { $show = '<tr>
if (!isset($_GET['action'])) { $action = ""; } else { $action = $_GET['action']; } switch ($action) { default: if ($chkMe == "unlogged" || $chkMe < "2") { $index = error(_error_wrong_permissions, 1); } else { if (isset($_GET['page'])) { $page = $_GET['page']; } else { $page = 1; } $entrys = cnt($db['clankasse']); $qry = db("SELECT * FROM " . $db['clankasse'] . "\n ORDER BY datum DESC\n LIMIT " . ($page - 1) * $maxclankasse . "," . $maxclankasse . ""); while ($get = _fetch($qry)) { $betrag = $get['betrag']; $betrag = str_replace(".", ",", $betrag); if ($get['pm'] == "0") { $pm = show(_clankasse_plus, array("betrag" => $betrag, "w" => $w)); } else { $pm = show(_clankasse_minus, array("betrag" => $betrag, "w" => $w)); } $edit = show("page/button_edit_single", array("id" => $get['id'], "title" => _button_title_edit, "action" => "action=admin&do=edit")); $delete = show("page/button_delete_single", array("id" => $get['id'], "title" => _button_title_delete, "action" => "action=admin&do=delete", "del" => convSpace(_confirm_del_entry))); $class = $color % 2 ? "contentMainSecond" : "contentMainFirst"; $color++; $show .= show($dir . "/clankasse_show", array("betrag" => $pm, "id" => $get['id'], "class" => $class, "for" => re($get['member']), "transaktion" => re($get['transaktion']), "delete" => $delete, "edit" => $edit, "datum" => date("d.m.Y", $get['datum']))); $i--;
case 'compreview': if ($_GET['do'] == 'edit') { $qry = db("SELECT * FROM " . $db['acomments'] . "\n WHERE id = '" . intval($_GET['cid']) . "'"); $get = _fetch($qry); $get_id = '?'; $get_userid = $get['reg']; $get_date = $get['datum']; if ($get['reg'] == 0) { $regCheck = false; } else { $regCheck = true; $pUId = $get['reg']; } $editedby = show(_edited_by, array("autor" => cleanautor($userid), "time" => date("d.m.Y H:i", time()) . _uhr)); } else { $get_id = cnt($db['acomments'], " WHERE artikel = " . intval($_GET['id']) . "") + 1; $get_userid = $userid; $get_date = time(); if ($chkMe == 'unlogged') { $regCheck = false; } else { $regCheck = true; $pUId = $userid; } } $get_hp = $_POST['hp']; $get_email = $_POST['email']; $get_nick = $_POST['nick']; if (!$regCheck) { if ($get_hp) { $hp = show(_hpicon_forum, array("hp" => links($get_hp)));
@unlink($tmp4); } } $show = info(_cw_admin_edited, "?admin=cw"); } } elseif ($_GET['do'] == "delete") { $qry = db("DELETE FROM " . $db['cw'] . "\n WHERE id = '" . intval($_GET['id']) . "'"); $qry = db("DELETE FROM " . $db['cw_comments'] . "\n WHERE cw = '" . intval($_GET['id']) . "'"); $show = info(_cw_admin_deleted, "?admin=cw"); } elseif ($_GET['do'] == "top") { $qry = db("UPDATE " . $db['cw'] . "\n SET `top` = '" . intval($_GET['set']) . "'\n WHERE id = '" . intval($_GET['id']) . "'"); $show = info(empty($_GET['set']) ? _cw_admin_top_unsetted : _cw_admin_top_setted, "?admin=cw"); } else { if (isset($_GET['page'])) { $page = $_GET['page']; } else { $page = 1; } $qry = db("SELECT * FROM " . $db['cw'] . "\n ORDER BY datum DESC\n LIMIT " . ($page - 1) * $maxadmincw . "," . $maxadmincw . ""); $entrys = cnt($db['cw']); while ($get = _fetch($qry)) { $top = empty($get['top']) ? '<a href="?admin=cw&do=top&set=1&id=' . $get['id'] . '"><img src="../inc/images/no.gif" alt="" title="' . _cw_admin_top_set . '" /></a>' : '<a href="?admin=cw&do=top&set=0&id=' . $get['id'] . '"><img src="../inc/images/yes.gif" alt="" title="' . _cw_admin_top_unset . '" /></a>'; $edit = show("page/button_edit_single", array("id" => $get['id'], "action" => "admin=cw&do=edit", "title" => _button_title_edit)); $delete = show("page/button_delete_single", array("id" => $get['id'], "action" => "admin=cw&do=delete", "title" => _button_title_del, "del" => convSpace(_confirm_del_cw))); $class = $color % 2 ? "contentMainSecond" : "contentMainFirst"; $color++; $show_ .= show($dir . "/clanwars_show", array("class" => $class, "cw" => re($get['clantag']) . " - " . re($get['gegner']), "datum" => date("d.m.Y H:i", $get['datum']) . _uhr, "top" => $top, "id" => $get['id'], "edit" => $edit, "delete" => $delete)); } $show = show($dir . "/clanwars", array("head" => _clanwars, "add" => _cw_admin_head, "date" => _datum, "titel" => _opponent, "show" => $show_, "navi" => nav($entrys, $maxadmincw, "?admin=cw"))); } }
} else { $replace = $getm['place']; } $event = show(_awards_event, array("event" => $getm['event'], "url" => $getm['url'])); $awards .= show($dir . "/awards_show", array("class" => $class, "date" => date("d.m.Y", $getm['date']), "place" => $replace, "prize" => $getm['prize'], "event" => $event)); } $nav = nav($entrys, $maxawards, "?action=showall&id=" . $get['id'] . ""); $showawards = show($dir . "/awards_show_all", array("squad" => _awards_head_squad, "date" => _awards_head_date, "place" => _awards_head_place, "prize" => _awards_head_prize, "url" => _awards_head_link, "nav" => $nav, "awards" => $awards)); if (cnt($db['awards'], " WHERE squad = " . $get['id']) != 0) { $show .= show($dir . "/squads_show_all", array("id" => $get['id'], "shown" => $shown, "display" => $display, "awards" => $showawards, "squad" => $squad . " (" . cnt($db['awards'], " WHERE squad = " . $get['id']) . ")", "img" => $img)); } } $qry = db("SELECT game,icon FROM " . $db['squads'] . "\n WHERE status = '1'\n GROUP BY game\n ORDER BY game ASC"); while ($get = _fetch($qry)) { $class = $color % 2 ? "contentMainSecond" : "contentMainFirst"; $color++; $img = squad($get['icon']); $legende .= show(_awards_legende, array("game" => re($get['game']), "img" => $img, "class" => $class)); } $legende = show($dir . "/legende", array("legende_head" => _awards_head_legende, "legende" => $legende)); $stats = show(_awards_stats, array("anz" => cnt($db['awards']))); $index = show($dir . "/main", array("head" => _awards_head, "stats" => $stats, "legende" => $legende, "show" => $show)); break; } ## SETTINGS ## $title = $pagetitle . " - " . $where . ""; $time_end = generatetime(); $time = round($time_end - $time_start, 4); page($index, $title, $where, $time); ## OUTPUT BUFFER END ## gz_output();
0000693 foreach and others with no braces cause parse error <?php # the following causes a parse error $arr = array("ASdf", "asdf"); foreach ($arr as $key => $val) { echo "{$key}, {$val}\n"; } for ($i = 0; $i < 10; $i++) { echo "{$i}\n"; } function cnt() { static $i = 0; $i++; return $i; } while (cnt() < 10) { echo "counted\n"; }
} } $index = show($dir . "/squads_full", array("member" => empty($member) ? _member_squad_no_entrys : $member, "desc" => empty($get['beschreibung']) ? '' : '<tr><td class="contentMainSecond">' . bbcode($get['beschreibung']) . '</td></tr>', "squad" => $squad, "style" => $style, "back" => _error_back, "id" => intval($_GET['id']))); break; default: $qry = db("SELECT * FROM " . $db['squads'] . " WHERE team_show = 1 ORDER BY pos"); while ($get = _fetch($qry)) { $class = $color % 2 ? "contentMainSecond" : "contentMainFirst"; $color++; $squad = show(_gameicon, array("icon" => $get['icon'])) . ' ' . re($get['name']); $style = ''; foreach ($picformat as $end) { if (file_exists(basePath . '/inc/images/squads/' . intval($get['id']) . '.' . $end)) { $style = 'text-align:center;padding:0'; $squad = '<img src="../inc/images/squads/' . intval($get['id']) . '.' . $end . '" alt="' . re($get['name']) . '" />'; break; } } $show .= show($dir . "/squads_show", array("id" => $get['id'], "squad" => $squad, "style" => $style, "class" => $class, "beschreibung" => bbcode($get['beschreibung']), "squadname" => re($get['name']))); } $cntm = db("SELECT * FROM " . $db['squaduser'] . " GROUP BY user"); $weare = show(_member_squad_weare, array("cm" => _rows($cntm), "cs" => cnt($db['squads'], "WHERE team_show = 1"))); $index = show($dir . "/squads", array("squadhead" => _member_squad_head, "weare" => $weare, "show" => $show)); break; } ## SETTINGS ## $time_end = generatetime(); $time = round($time_end - $time_start, 4); page($index, $title, $where, $time); ## OUTPUT BUFFER END ## gz_output();
$color++; $postausgang .= show($dir . "/postausgang", array("titel" => $titel, "empfaenger" => autor($get['an']), "datum" => $date, "class" => $class, "readed" => $readed, "delete" => $delete, "id" => $get['id'])); } $msghead = show(_msghead, array("nick" => autor($userid))); $index = show($dir . "/msg", array("msghead" => $msghead, "posteingang" => _posteingang, "postausgang" => _postausgang, "titel" => _msg_title, "del" => _msg_del, "absender" => _msg_absender, "legende" => _legende, "legendemsg" => _legende_msg, "legendereaded" => _legende_readed, "empfaenger" => _msg_empfaenger, "datum" => _datum, "new" => _msg_new, "newglobal" => $newglobal, "newicon" => _newicon, "yesno" => _yesno, "deleteicon" => _deleteicon_blank, "showincoming" => $posteingang, "showsended" => $postausgang)); } } break; case 'userlist': $where = _site_ulist; if (isset($_GET['page'])) { $page = $_GET['page']; } else { $page = 1; } $entrys = cnt($db['users'], " WHERE level != 0"); if ($_GET['show'] == "search") { $qry = db("SELECT id,nick,level,email,hp,steamid,hlswid,bday,sex,icq,status,position,regdatum\n\t\t\t\t\t\t FROM " . $db['users'] . "\n WHERE nick LIKE '%" . $_GET['search'] . "%'\n AND level != 0\n ORDER BY nick\n LIMIT " . ($page - 1) * $maxuserlist . "," . $maxuserlist . ""); } elseif ($_GET['show'] == "bday") { $qry = db("SELECT id,nick,level,email,hp,steamid,hlswid,bday,sex,icq,status,position,regdatum\n\t\t\t\t\t\t FROM " . $db['users'] . "\n WHERE bday LIKE '" . date("d", intval($_GET['time'])) . "." . date("m", intval($_GET['time'])) . ".____" . "'\n AND level != 0\n ORDER BY nick\n LIMIT " . ($page - 1) * $maxuserlist . "," . $maxuserlist . ""); } elseif ($_GET['show'] == "newreg") { $qry = db("SELECT id,nick,level,email,hp,steamid,hlswid,bday,\n sex,icq,status,position,regdatum FROM " . $db['users'] . "\n WHERE regdatum > '" . $_SESSION['lastvisit'] . "'\n AND level != '0'\n\t\t\t\t \t\t ORDER BY regdatum DESC,nick\n LIMIT " . ($page - 1) * $maxuserlist . "," . $maxuserlist . ""); } elseif ($_GET['show'] == "lastlogin") { $qry = db("SELECT id,nick,level,email,hp,steamid,hlswid,bday,\n sex,icq,status,position,regdatum FROM " . $db['users'] . "\n WHERE level != '0'\n\t\t\t\t \t\t ORDER BY time DESC,nick\n LIMIT " . ($page - 1) * $maxuserlist . "," . $maxuserlist . ""); } elseif ($_GET['show'] == "lastreg") { $qry = db("SELECT id,nick,level,email,hp,steamid,hlswid,bday,sex,\n icq,status,position,regdatum FROM " . $db['users'] . "\n WHERE level != '0'\n\t\t\t \t\t\t ORDER BY regdatum DESC,nick\n LIMIT " . ($page - 1) * $maxuserlist . "," . $maxuserlist . ""); } elseif ($_GET['show'] == "online") { $qry = db("SELECT id,nick,level,email,hp,steamid,hlswid,bday,\n sex,icq,status,position,time FROM " . $db['users'] . "\n WHERE level != '0'\n\t\t\t \t\t\t ORDER BY time DESC,nick\n LIMIT " . ($page - 1) * $maxuserlist . "," . $maxuserlist . ""); } elseif ($_GET['show'] == "country") { $qry = db("SELECT id,nick,level,email,hp,steamid,\n hlswid,bday,sex,icq,status,position,country FROM " . $db['users'] . "\n WHERE level != '0'\n\t\t \t\t\t\t ORDER BY country,nick\n LIMIT " . ($page - 1) * $maxuserlist . "," . $maxuserlist . ""); } elseif ($_GET['show'] == "sex") {
} break; case 'usergallery': if ($chkMe != 'unlogged') { $infos = show(_upload_usergallery_info, array("userpicsize" => $upicsize)); $index = show($dir . "/usergallery", array("uploadhead" => _upload_head_usergallery, "file" => _upload_file, "name" => "file", "upload" => _button_value_upload, "beschreibung" => _upload_beschreibung, "info" => _upload_info, "infos" => $infos)); if ($_GET['do'] == "upload") { $tmpname = $_FILES['file']['tmp_name']; $name = $_FILES['file']['name']; $type = $_FILES['file']['type']; $size = $_FILES['file']['size']; if (!$tmpname) { $index = error(_upload_no_data, 1); } elseif ($size > $upicsize . "000") { $index = error(_upload_wrong_size, 1); } elseif (cnt($db['usergallery'], " WHERE user = "******"/inc/images/uploads/usergallery/" . $userid . "_" . $_FILES['file']['name'])) { $index = error(_upload_file_exists, 1); } else { copy($tmpname, basePath . "/inc/images/uploads/usergallery/" . $userid . "_" . $_FILES['file']['name']); @unlink($_FILES['file']['tmp_name']); $qry = db("INSERT INTO " . $db['usergallery'] . "\n SET `user` = '" . (int) $userid . "',\n `beschreibung` = '" . up($_POST['beschreibung'], 1) . "',\n `pic` = '" . up($_FILES['file']['name']) . "'"); $index = info(_info_upload_success, "../user/?action=editprofile&show=gallery"); } } elseif ($_GET['do'] == "edit") { $qry = db("SELECT * FROM " . $db['usergallery'] . "\n WHERE id = '" . intval($_GET['gid']) . "'"); $get = _fetch($qry); if ($get['user'] == $userid) { $infos = show(_upload_usergallery_info, array("userpicsize" => $upicsize)); $index = show($dir . "/usergallery_edit", array("uploadhead" => _upload_head_usergallery, "file" => _upload_file, "showpic" => img_size("inc/images/uploads/usergallery/" . $get['user'] . "_" . $get['pic']), "id" => $_GET['gid'], "showbeschreibung" => re($get['beschreibung']), "name" => "file", "upload" => _button_value_edit, "beschreibung" => _upload_beschreibung, "info" => _upload_info, "infos" => $infos));
} if (strlen(@round($allsize / 1048576 * $allhits, 0)) >= 4) { $alltraffic = @round($allsize / 1073741824 * $allhits, 2) . ' GB'; } else { $alltraffic = @round($allsize / 1048576 * $allhits, 2) . ' MB'; } if (strlen(@round($allsize / 1048576, 0)) >= 4) { $allsize = @round($allsize / 1073741824, 2) . ' GB'; } else { $allsize = @round($allsize / 1048576, 2) . ' MB'; } $stats = show($dir . "/downloads", array("head" => _site_dl, "files" => _site_stats_files, "nfiles" => cnt($db['downloads']), "size" => _stats_dl_size, "hosted" => _stats_hosted, "allsize" => $allsize, "traffic" => _stats_dl_traffic, "ntraffic" => $alltraffic, "hits" => _stats_dl_hits, "nhits" => $allhits)); } else { $allcomments = cnt($db['newscomments']); $allnews = cnt($db['news']); $allkats = cnt($db['newskat']); $qry = db("SELECT * FROM " . $db['newskat'] . ""); $i = 1; while ($get = _fetch($qry)) { if ($i == $allkats) { $end = ""; } else { $end = ","; } $kats .= re($get['kategorie']) . $end . " "; $i++; } $qry = db("SELECT datum FROM " . $db['news'] . "\n ORDER BY datum ASC"); $get = _fetch($qry); $time = time() - $get['datum']; $days = @round($time / 86400);
} if (date("d.m.Y", $getawaya['end']) == date("d.m.Y", time())) { $wieder = _away_today; } $awaya .= show(_user_away_now, array("id" => $getawaya['id'], "user" => autor($getawaya['userid']), "wieder" => $wieder, "what" => $getawaya['titel'])); } } $away_now = show(_user_away_currently, array("ncaway" => _lobby_away, "caway" => $awaya)); } /** Neue Forum Topics anzeigen */ $qryft = db("SELECT s1.t_text,s1.id,s1.topic,s1.kid,s2.kattopic,s3.intern,s1.sticky\n FROM " . $db['f_threads'] . " s1, " . $db['f_skats'] . " s2, " . $db['f_kats'] . " s3\n WHERE s1.kid = s2.id\n AND s2.sid = s3.id\n ORDER BY s1.lp DESC\n LIMIT 10"); $ftopics = ''; if (_rows($qryft) >= 1) { while ($getft = _fetch($qryft)) { if (fintern($getft['kid'])) { $lp = cnt($db['f_posts'], " WHERE sid = '" . $getft['id'] . "'"); $pagenr = ceil($lp / config('m_ftopics')); $page = $pagenr == 0 ? 1 : $pagenr; $getp = db("SELECT text FROM " . $db['f_posts'] . "\n WHERE kid = '" . $getft['kid'] . "'\n AND sid = '" . $getft['id'] . "'\n ORDER BY date DESC\n LIMIT 1", false, true); $text = strip_tags(!empty($getp) ? $getp['text'] : $getft['t_text']); $intern = $getft['intern'] != 1 ? "" : '<span class="fontWichtig">' . _internal . ':</span>'; $wichtig = $getft['sticky'] != 1 ? '' : '<span class="fontWichtig">' . _sticky . ':</span> '; $ftopics .= show($dir . "/userlobby_forum", array("id" => $getft['id'], "pagenr" => $page, "p" => $lp + 1, "intern" => $intern, "wichtig" => $wichtig, "lpost" => cut(re($text), 100), "kat" => re($getft['kattopic']), "titel" => re($getft['topic']), "kid" => $getft['kid'])); } } } // Userlevel if (($lvl = data("level")) == 1) { $mylevel = _status_user; } elseif ($lvl == 2) { $mylevel = _status_trial;
include basePath . "/inc/bbcode.php"; ## SETTINGS ## $time_start = generatetime(); lang($language); $where = "Installer"; $title = $pagetitle . " - " . $where . ""; ## INSTALLER ## if (isset($_POST['submit'])) { // neue Tabellen/Spalten anlegen db("CREATE TABLE " . $sql_prefix . "jokes (\n\t\t\t\t\t\t`id` int(5) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t\t `uid` int(5) NOT NULL,\n\t\t\t\t\t\t `title` varchar(32) NOT NULL,\n\t\t\t\t\t\t `content` text NOT NULL,\n\t\t\t\t\t\t `date` int(12) NOT NULL DEFAULT '0',\n\t\t\t\t\t\t `status` int(1) NOT NULL DEFAULT '0',\n\t\t\t\t\t\tPRIMARY KEY (`id`)) "); // neue Tabellen/Spalten anlegen db("CREATE TABLE " . $sql_prefix . "joke_rating (\n\t\t\t\t\t\t`id` int(10) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t\t `uid` int(10) NOT NULL,\n\t\t\t\t\t\t `jid` int(10) NOT NULL,\n\t\t\t\t\t\t `pkt` int(1) NOT NULL,\n\t\t\t\t\t\tPRIMARY KEY (`id`)) "); db("INSERT INTO " . $sql_prefix . "jokes (id,uid,title,content,date,status) VALUES ('1','1','Ball','Rollte ein Ball um die Ecke und fällt um.','" . time() . "','1')"); db("ALTER TABLE " . $sql_prefix . "permissions ADD `jokes` int(1) NOT NULL default '0'"); // Check ob Install i.O. velief if (cnt($sql_prefix . "jokes") > '0') { $show = '<tr> <td class="contentHead" align="center"><span class="fontGreen"><b>Installation erfolgreich!</b></span></td> </tr> <tr> <td class="contentMainFirst" align="center"> Die benötigten Tabellen konnten erfolgreich erstellt werden.<br> <br> <b>Lösche unbedingt den installer-Ordner!</b> </td> </tr> <tr> <td class="contentBottom"></td> </tr>'; } else { $show = '<tr>
include basePath . "/inc/bbcode.php"; ## SETTINGS ## $time_start = generatetime(); lang($language); $where = "Installer"; $title = $pagetitle . " - " . $where . ""; ## INSTALLER ## if (isset($_POST['submit'])) { // alte Tabellen/Spalten löschen db("DROP TABLE IF EXISTS " . $sql_prefix . "quickinfo"); // neue Tabellen/Spalten anlegen db("CREATE TABLE " . $sql_prefix . "quickinfo (\n\t\t\t\t\t\t`id` int(10) NOT NULL auto_increment,\n\t\t\t\t\t\t`title` varchar(32) NOT NULL,\n\t\t\t\t\t\t`content` varchar(500) NOT NULL,\n\t\t\t\t\t\t`more` varchar(200) NOT NULL,\n\t\t\t\t\t\t`status` int(1) NOT NULL default '0',\n\t\t\t\t\t\tPRIMARY KEY (`id`)) "); db("INSERT INTO " . $sql_prefix . "quickinfo (id,title,content,more,status) VALUES ('1','Beispiel','Hier mal ein Beispieleintrag!','http://dzcp-zone.de','1')"); db("ALTER TABLE " . $sql_prefix . "permissions ADD `quickinfo` int(1) NOT NULL default '0'"); // Check ob Install i.O. velief if (cnt($sql_prefix . "quickinfo") > '0') { $show = '<tr> <td class="contentHead" align="center"><span class="fontGreen"><b>Installation erfolgreich!</b></span></td> </tr> <tr> <td class="contentMainFirst" align="center"> Die benötigten Tabellen konnten erfolgreich erstellt werden.<br> <br> <b>Lösche unbedingt den installer-Ordner!</b> </td> </tr> <tr> <td class="contentBottom"></td> </tr>'; } else { $show = '<tr>