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>
