예제 #1
0
파일: motm.php 프로젝트: nopuls/dzcp
function motm()
{
    global $db, $allowHover;
    $userpics = get_files(basePath . '/inc/images/uploads/userpics/');
    $qry = db("SELECT * FROM " . $db['users'] . " WHERE level >= 2");
    while ($rs = _fetch($qry)) {
        foreach ($userpics as $userpic) {
            $tmpId = intval($userpic);
            if ($tmpId == $rs['id']) {
                $temparr[] = $rs['id'];
                $a++;
                break;
            }
        }
    }
    $arrayID = rand(0, count($temparr) - 1);
    $uid = $temparr[$arrayID];
    $get = _fetch(db("SELECT * FROM " . $db['users'] . " WHERE id = '" . $uid . "'"));
    if (!empty($get) && !empty($temparr)) {
        $status = $get['status'] == 1 || $get['level'] == 1 ? _aktiv : _inaktiv;
        if ($allowHover == 1) {
            $info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . rawautor($get['id']) . '</td></tr><tr><td width=80px><b>' . _posi . ':</b></td><td>' . getrank($get['id']) . '</td></tr><tr><td><b>' . _status . ':</b></td><td>' . $status . '</td></tr><tr><td><b>' . _age . ':</b></td><td>' . getAge($get['bday']) . '</td></tr><tr><td colspan=2 align=center>' . jsconvert(userpic($get['id'])) . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
        }
        $member = show("menu/motm", array("uid" => $get['id'], "upic" => userpic($get['id'], 130, 161), "info" => $info));
    } else {
        $member = '';
    }
    return empty($member) ? '' : '<table class="navContent" cellspacing="0">' . $member . '</table>';
}
예제 #2
0
function counter()
{
    //$sql_prefix hinzufügen
    global $db, $today, $counter_start, $useronline, $where, $isSpider, $sql_prefix;
    if (!$isSpider) {
        $qry2day = db("SELECT visitors FROM " . $db['counter'] . "\n                   WHERE today = '" . $today . "'");
        if (_rows($qry2day)) {
            $get2day = _fetch($qry2day);
            $v_today = $get2day['visitors'];
        } else {
            $v_today = 0;
        }
        $gestern = time() - 86400;
        $tag = date("j", $gestern);
        $monat = date("n", $gestern);
        $jahr = date("Y", $gestern);
        $yesterday = $tag . "." . $monat . "." . $jahr;
        $qryyday = db("SELECT visitors FROM " . $db['counter'] . "\n                   WHERE today = '" . $yesterday . "'");
        if (_rows($qryyday)) {
            $getyday = _fetch($qryyday);
            $yDay = $getyday['visitors'];
        } else {
            $yDay = 0;
        }
        $qrystats = db("SELECT SUM(visitors) AS allvisitors,\n                           MAX(visitors) AS maxvisitors,\n                           MAX(maxonline) AS maxonline,\n                           AVG(visitors) AS avgvisitors,\n                           SUM(visitors) AS allvisitors\n                    FROM " . $db['counter'] . "");
        $getstats = _fetch($qrystats);
        if (abs(online_reg()) != 0) {
            $qryo = db("SELECT id FROM " . $db['users'] . "\n                  WHERE time+'" . $useronline . "'>'" . time() . "'\n                  AND online = 1\n                  ORDER BY nick");
            while ($geto = _fetch($qryo)) {
                $ousers .= '<tr><td>' . rawautor($geto['id']) . '</td><td align=right valign=middle><small>' . jsconvert(getrank($geto['id'])) . '</small></td></tr>';
            }
            $info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . _online_head . '</td></tr><tr><td><table width=100% cellpadding=0 cellspacing=0>' . $ousers . '</table></td></tr>\')" onmouseout="DZCP.hideInfo()"';
        }
        //Klicks Mod
        if (strpos($_SERVER['PHP_SELF'], "/admin/") !== false) {
            $clicksnumber = "-";
        } else {
            if ($_SERVER['QUERY_STRING'] != "") {
                $whereclicks = $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING'];
            } else {
                $whereclicks = $_SERVER['PHP_SELF'];
            }
            $clicksrownumber = mysql_num_rows(db("SELECT klicks FROM " . $sql_prefix . "klicks WHERE wo = '" . $whereclicks . "'"));
            if ($clicksrownumber == 0) {
                $qry = db("INSERT INTO " . $sql_prefix . "klicks \n                       SET `wo`  = '" . $whereclicks . "',\n                           `klicks`  = '1'");
                $clicksnumber = 1;
            } else {
                $clicksnumber = mysql_fetch_array(db("SELECT klicks FROM " . $sql_prefix . "klicks WHERE wo = '" . $whereclicks . "'"));
                $clicksnumber = $clicksnumber[0] + 1;
                $qry = db("UPDATE " . $sql_prefix . "klicks SET klicks = '" . $clicksnumber . "' WHERE wo LIKE '" . $whereclicks . "'");
            }
        }
        //Klicks Mod Ende
        $counter = show("menu/counter", array("v_today" => $v_today, "aufrufe" => $clicksnumber, "v_yesterday" => $yDay, "v_all" => $getstats['allvisitors'] + $counter_start, "v_perday" => round($getstats['avgvisitors'], 2), "v_max" => $getstats['maxvisitors'], "g_online" => abs(online_guests($where) - online_reg()), "u_online" => abs(online_reg()), "info" => $info, "v_online" => $getstats['maxonline'], "head_online" => _head_online, "head_visits" => _head_visits, "head_max" => _head_max, "user" => _cnt_user, "guests" => _cnt_guests, "today" => _cnt_today, "yesterday" => _cnt_yesterday, "all" => _cnt_all, "percentperday" => _cnt_pperday, "perday" => _cnt_perday, "online" => _cnt_online));
        return '<table class="navContent" cellspacing="0">' . $counter . '</table>';
    }
}
예제 #3
0
파일: team.php 프로젝트: nopuls/dzcp
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>';
}
예제 #4
0
파일: newsticker.php 프로젝트: nopuls/dzcp
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&amp;id=' . $get['id'] . '" ' . $info . '>' . re($get['titel']) . '</a> | ';
    }
    return show("menu/newsticker", array("news" => $news));
}
예제 #5
0
파일: l_artikel.php 프로젝트: nopuls/dzcp
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>';
}
예제 #6
0
파일: l_news.php 프로젝트: nopuls/dzcp
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>';
}
예제 #7
0
파일: uotm.php 프로젝트: nopuls/dzcp
function uotm()
{
    global $db, $allowHover;
    $imgFiles = array();
    $folder = get_files('../inc/images/uploads/userpics');
    foreach ($folder as $file) {
        array_push($imgFiles, $file);
    }
    if (count($imgFiles) != 0) {
        $userid = intval($imgFiles[rand(0, count($imgFiles) - 1)]);
        $get = _fetch(db("SELECT id,nick,country,bday FROM " . $db['users'] . " WHERE id = '" . $userid . "'"));
        if (!empty($get)) {
            if ($allowHover == 1) {
                $info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . rawautor($get['id']) . '</td></tr><tr><td width=50%><b>' . _age . ':</b></td><td>' . getAge($get['bday']) . '</td></tr><tr><td colspan=2 align=center>' . jsconvert(userpic($get['id'])) . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
            }
            $uotm = show("menu/uotm", array("uid" => $userid, "upic" => userpic($get['id'], 130, 161), "info" => $info));
        }
    }
    return empty($uotm) ? '' : '<table class="navContent" cellspacing="0">' . $uotm . '</table>';
}
예제 #8
0
파일: counter.php 프로젝트: nopuls/dzcp
function counter()
{
    global $db, $today, $counter_start, $useronline, $where, $isSpider;
    if (!$isSpider) {
        $qry2day = db("SELECT visitors FROM " . $db['counter'] . "\n                   WHERE today = '" . $today . "'");
        if (_rows($qry2day)) {
            $get2day = _fetch($qry2day);
            $v_today = $get2day['visitors'];
        } else {
            $v_today = 0;
        }
        $gestern = time() - 86400;
        $tag = date("j", $gestern);
        $monat = date("n", $gestern);
        $jahr = date("Y", $gestern);
        $yesterday = $tag . "." . $monat . "." . $jahr;
        $qryyday = db("SELECT visitors FROM " . $db['counter'] . "\n                   WHERE today = '" . $yesterday . "'");
        if (_rows($qryyday)) {
            $getyday = _fetch($qryyday);
            $yDay = $getyday['visitors'];
        } else {
            $yDay = 0;
        }
        $qrystats = db("SELECT SUM(visitors) AS allvisitors,\n                           MAX(visitors) AS maxvisitors,\n                           MAX(maxonline) AS maxonline,\n                           AVG(visitors) AS avgvisitors,\n                           SUM(visitors) AS allvisitors\n                    FROM " . $db['counter'] . "");
        $getstats = _fetch($qrystats);
        if (abs(online_reg()) != 0) {
            $qryo = db("SELECT id FROM " . $db['users'] . "\n                  WHERE time+'" . $useronline . "'>'" . time() . "'\n                  AND online = 1\n                  ORDER BY nick");
            while ($geto = _fetch($qryo)) {
                $ousers .= '<tr><td>' . rawautor($geto['id']) . '</td><td align=right valign=middle><small>' . jsconvert(getrank($geto['id'])) . '</small></td></tr>';
            }
            $info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . _online_head . '</td></tr><tr><td><table width=100% cellpadding=0 cellspacing=0>' . $ousers . '</table></td></tr>\')" onmouseout="DZCP.hideInfo()"';
        }
        $counter = show("menu/counter", array("v_today" => $v_today, "v_yesterday" => $yDay, "v_all" => $getstats['allvisitors'] + $counter_start, "v_perday" => round($getstats['avgvisitors'], 2), "v_max" => $getstats['maxvisitors'], "g_online" => abs(online_guests($where) - online_reg()), "u_online" => abs(online_reg()), "info" => $info, "v_online" => $getstats['maxonline'], "head_online" => _head_online, "head_visits" => _head_visits, "head_max" => _head_max, "user" => _cnt_user, "guests" => _cnt_guests, "today" => _cnt_today, "yesterday" => _cnt_yesterday, "all" => _cnt_all, "percentperday" => _cnt_pperday, "perday" => _cnt_perday, "online" => _cnt_online));
        return '<table class="navContent" cellspacing="0">' . $counter . '</table>';
    }
}
예제 #9
0
파일: index.php 프로젝트: nopuls/dzcp
$markerCount = 0;
while ($mm_get = _fetch($mm_qry)) {
    if ($mm_lastCoord != $mm_get['gmaps_koord']) {
        if ($i > 0) {
            $mm_coords .= ',';
            $mm_infos .= "</tr>','<tr>";
        }
        $mm_infos .= '<td><b style="font-size:13px">&nbsp;' . re($mm_get['city']) . '</td></tr><tr>';
        $mm_coords .= 'new google.maps.LatLng' . $mm_get['gmaps_koord'];
        $realCount++;
    } else {
        if ($markerCount > 0) {
            $mm_markerIcon .= ',';
        }
        $mm_markerIcon .= $realCount - 1 . ':true';
        $markerCount++;
    }
    $userInfos = '<b>' . rawautor($mm_get['id']) . '</b><br /><b>' . _position . ':</b> ' . getrank($mm_get['id']) . '<br />' . userpic($mm_get['id']);
    $mm_infos .= '<td><div id="memberMapInner">' . $userInfos . '</div></td>';
    $mm_lastCoord = $mm_get['gmaps_koord'];
    $i++;
}
$mm_infos .= "</tr>'";
$index = show($dir . "/membermap", array('head' => _membermap, 'mm_coords' => $mm_coords, 'mm_infos' => $mm_infos, 'mm_markerIcon' => $mm_markerIcon));
## SETTINGS ##
$title = $pagetitle . " - " . $where . "";
$time_end = generatetime();
$time = round($time_end - $time_start, 4);
page($index, $title, $where, $time);
## OUTPUT BUFFER END ##
gz_output();
예제 #10
0
 for ($iw = 1; $iw <= 7; $iw++) {
     unset($bdays, $cws, $infoBday, $infoCW, $infoEvent);
     $datum = mktime(0, 0, 0, $monat, $i, $jahr);
     $wday = getdate($datum);
     $wday = $wday['wday'];
     if (!$wday) {
         $wday = 7;
     }
     if ($wday != $iw) {
         $data .= '<td class="calDay"></td>';
     } else {
         $qry = db("SELECT id,bday,nick FROM " . $db['users'] . "\n                   WHERE bday LIKE '" . cal($i) . "." . $monat . ".____" . "'");
         if (_rows($qry)) {
             $infoBday = '';
             while ($get = _fetch($qry)) {
                 $infoBday .= '&lt;img src=../inc/images/bday.gif class=icon alt= /&gt;' . '&nbsp;' . jsconvert(_kal_birthday . rawautor($get['id'])) . '<br />';
             }
             $info = ' onmouseover="DZCP.showInfo(\'' . $infoBday . '\')" onmouseout="DZCP.hideInfo()"';
             $bdays = '<a href="../user/?action=userlist&amp;show=bday&amp;time=' . $datum . '"' . $info . '><img src="../inc/images/bday.gif" alt="" /></a>';
         } else {
             $bdays = "";
         }
         $qry = db("SELECT datum,gegner FROM " . $db['cw'] . "\n                     WHERE DATE_FORMAT(FROM_UNIXTIME(datum), '%d.%m.%Y') = '" . cal($i) . "." . $monat . "." . $jahr . "'");
         if (_rows($qry)) {
             $infoCW = '';
             while ($get = _fetch($qry)) {
                 $infoCW .= '&lt;img src=../inc/images/cw.gif class=icon alt= /&gt;' . '&nbsp;' . jsconvert(_kal_cw . re($get['gegner'])) . '<br />';
             }
             $info = ' onmouseover="DZCP.showInfo(\'' . $infoCW . '\')" onmouseout="DZCP.hideInfo()"';
             $cws = '<a href="../clanwars/?action=kalender&amp;time=' . $datum . '"' . $info . '><img src="../inc/images/cw.gif" alt="" /></a>';
         } else {
function kalender($month = "", $year = "")
{
    global $db, $sql_prefix;
    if (!empty($month) && !empty($year)) {
        $monat = cal($month);
        $jahr = $year;
    } else {
        $monat = date("m");
        $jahr = date("Y");
    }
    for ($i = 1; $i <= 12; $i++) {
        $mname = array("1" => _jan, "2" => _feb, "3" => _mar, "4" => _apr, "5" => _mai, "6" => _jun, "7" => _jul, "8" => _aug, "9" => _sep, "10" => _okt, "11" => _nov, "12" => _dez);
        if ($monat == $i) {
            $month = $mname[$i];
        }
    }
    $today = mktime(0, 0, 0, date("n"), date("d"), date("Y"));
    $i = 1;
    while ($i <= 31 && checkdate($monat, $i, $jahr)) {
        unset($event);
        unset($data);
        unset($bdays);
        unset($cws);
        for ($iw = 1; $iw <= 7; $iw++) {
            unset($titlecw);
            unset($titlebd);
            unset($titleev);
            $datum = mktime(0, 0, 0, $monat, $i, $jahr);
            $wday = getdate($datum);
            $wday = $wday['wday'];
            if (!$wday) {
                $wday = 7;
            }
            if ($wday != $iw) {
                $data .= "<td class=\"navKalEmpty\"></td>";
            } else {
                $qry = db("SELECT id,bday FROM " . $db['users'] . " WHERE bday LIKE '" . cal($i) . "." . $monat . ".____" . "'");
                if (_rows($qry)) {
                    while ($get = _fetch($qry)) {
                        $bdays = "set";
                        $titlebd .= '<tr><td><img src=../inc/images/bday.gif class=icon alt= /> ' . jsconvert(_kal_birthday . rawautor($get['id'])) . '</td></tr>';
                    }
                } else {
                    $bdays = "";
                    $titlebd = "";
                }
                $qry = db("SELECT datum,cid FROM " . $db['cw'] . " WHERE DATE_FORMAT(FROM_UNIXTIME(datum), '%d.%m.%Y') = '" . cal($i) . "." . $monat . "." . $jahr . "'");
                if (_rows($qry)) {
                    while ($get = _fetch($qry)) {
                        //Clans Mod
                        $clandetailssql = db("SELECT gegner FROM " . $sql_prefix . "clans WHERE id LIKE " . $get['cid']);
                        $clans = _fetch($clandetailssql);
                        $cws = "set";
                        $titlecw .= '<tr><td><img src=../inc/images/cw.gif class=icon alt= /> ' . jsconvert(_kal_cw . re($clans['gegner'])) . '</td></tr>';
                    }
                } else {
                    $cws = "";
                    $titlecw = "";
                }
                $qry = db("SELECT datum,title FROM " . $db['events'] . " WHERE DATE_FORMAT(FROM_UNIXTIME(datum), '%d.%m.%Y') = '" . cal($i) . "." . $monat . "." . $jahr . "'");
                if (_rows($qry)) {
                    while ($get = _fetch($qry)) {
                        $event = "set";
                        $titleev .= '<tr><td><img src=../inc/images/event.gif class=icon alt= /> ' . jsconvert(_kal_event . re($get['title'])) . '</td></tr>';
                    }
                } else {
                    $event = "";
                    $titleev = "";
                }
                $info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . cal($i) . '.' . $monat . '.' . $jahr . '</td></tr>' . $titlebd . $titlecw . $titleev . '\')" onmouseout="DZCP.hideInfo()"';
                if ($event == "set" || $cws == "set" || $bdays == "set") {
                    $day = '<a class="navKal" href="../kalender/?m=' . $monat . '&amp;y=' . $jahr . '&amp;hl=' . $i . '" ' . $info . '>' . cal($i) . '</a>';
                } else {
                    $day = cal($i);
                }
                if (!checkdate($monat, $i, $jahr)) {
                    $data .= '<td class="navKalEmpty"></td>';
                } elseif ($datum == $today) {
                    $data .= show("menu/kal_day", array("day" => $day, "id" => "navKalToday"));
                } else {
                    $data .= show("menu/kal_day", array("day" => $day, "id" => "navKalDays"));
                }
                $i++;
            }
        }
        $show .= "<tr>" . $data . "</tr>";
    }
    if ($monat + 1 == 13) {
        $nm = 1;
        $ny = $jahr + 1;
    } else {
        $nm = $monat + 1;
        $ny = $jahr;
    }
    if ($monat - 1 == 0) {
        $lm = 12;
        $ly = $jahr - 1;
    } else {
        $lm = $monat - 1;
        $ly = $jahr;
    }
    $kalender = show("menu/kalender", array("monat" => $month, "show" => $show, "year" => $jahr, "nm" => $nm, "ny" => $ny, "lm" => $lm, "ly" => $ly, "montag" => _nav_montag, "dienstag" => _nav_dienstag, "mittwoch" => _nav_mittwoch, "donnerstag" => _nav_donnerstag, "freitag" => _nav_freitag, "samstag" => _nav_samstag, "sonntag" => _nav_sonntag));
    return '<div id="navKalender">' . $kalender . '</div>';
}
예제 #12
0
/**
 * DZCP - deV!L`z ClanPortal 1.6 Final
 * http://www.dzcp.de
 * Menu: Kalender
 */
function kalender($month = "", $year = "")
{
    global $db, $sql_prefix;
    if (!empty($month) && !empty($year)) {
        $monat = cal($month);
        $jahr = $year;
    } else {
        $monat = date("m");
        $jahr = date("Y");
    }
    for ($i = 1; $i <= 12; $i++) {
        $mname = array("1" => _jan, "2" => _feb, "3" => _mar, "4" => _apr, "5" => _mai, "6" => _jun, "7" => _jul, "8" => _aug, "9" => _sep, "10" => _okt, "11" => _nov, "12" => _dez);
        if ($monat == $i) {
            $month = $mname[$i];
        }
    }
    $today = mktime(0, 0, 0, date("n"), date("d"), date("Y"));
    $i = 1;
    $show = '';
    while ($i <= 31 && checkdate($monat, $i, $jahr)) {
        $data = '';
        $event = '';
        $bdays = '';
        $cws = '';
        for ($iw = 1; $iw <= 7; $iw++) {
            unset($titlecw);
            unset($titlebd);
            unset($titleev);
            $datum = mktime(0, 0, 0, $monat, $i, $jahr);
            $wday = getdate($datum);
            $wday = $wday['wday'];
            if (!$wday) {
                $wday = 7;
            }
            if ($wday != $iw) {
                $data .= "<td class=\"navKalEmpty\"></td>";
            } else {
                $titlebd = '';
                $bdays = "";
                $qry = db("SELECT id,bday FROM " . $db['users'] . " WHERE bday LIKE '" . cal($i) . "." . $monat . ".____" . "'");
                if (_rows($qry)) {
                    while ($get = _fetch($qry)) {
                        $bdays = "set";
                        $titlebd .= '&lt;img src=../inc/images/bday.gif class=icon alt= /&gt;' . '&nbsp;' . jsconvert(_kal_birthday . rawautor($get['id'])) . '&lt;br />';
                    }
                }
                $cws = "";
                $titlecw = "";
                $qry = db("SELECT datum,gegner FROM " . $db['cw'] . " WHERE DATE_FORMAT(FROM_UNIXTIME(datum), '%d.%m.%Y') = '" . cal($i) . "." . $monat . "." . $jahr . "'");
                if (_rows($qry)) {
                    while ($get = _fetch($qry)) {
                        $cws = "set";
                        $titlecw .= '&lt;img src=../inc/images/cw.gif class=icon alt= /&gt;' . '&nbsp;' . jsconvert(_kal_cw . re($get['gegner'])) . '&lt;br />';
                    }
                }
                $event = "";
                $titleev = "";
                $qry = db("SELECT s1.*, s2.name as katname FROM " . $sql_prefix . "events_info as s1 JOIN " . $sql_prefix . "events_kat as s2\n                   WHERE s1.kat = s2.id AND DATE_FORMAT(FROM_UNIXTIME(start), '%d.%m.%Y') <= '" . cal($i) . "." . $monat . "." . $jahr . "' AND DATE_FORMAT(FROM_UNIXTIME(ende), '%d.%m.%Y') >= '" . cal($i) . "." . $monat . "." . $jahr . "' AND s1.show = 1");
                if (_rows($qry)) {
                    while ($get = _fetch($qry)) {
                        $pfadbild = "inc/images/eventkat/" . $get['kat'];
                        if (file_exists(basePath . "/" . $pfadbild . ".gif")) {
                            $bild = '<img src=../' . $pfadbild . '.gif class=icon  alt= />';
                        } elseif (file_exists(basePath . "/" . $pfadbild . ".jpg")) {
                            $bild = '<img src=../' . $pfadbild . '.jpg class=icon  alt= />';
                        } elseif (file_exists(basePath . "/" . $pfadbild . ".png")) {
                            $bild = '<img src=../' . $pfadbild . '.png class=icon  alt= />';
                        } else {
                            $bild = "<img src=../inc/images/event.gif class=icon alt= />";
                        }
                        $event = "set";
                        $titleev .= '<tr><td>' . $bild . jsconvert(re($get['katname']) . ': ' . re($get['name'])) . '</td></tr>';
                    }
                }
                $info = 'onmouseover="DZCP.showInfo(\'' . cal($i) . '.' . $monat . '.' . $jahr . '\', \'' . $titlebd . $titlecw . $titleev . '\')" onmouseout="DZCP.hideInfo()"';
                if ($event == "set" || $cws == "set" || $bdays == "set") {
                    $day = '<a class="navKal" href="../kalender/?m=' . $monat . '&amp;y=' . $jahr . '&amp;hl=' . $i . '" ' . $info . '>' . cal($i) . '</a>';
                } else {
                    $day = cal($i);
                }
                if (!checkdate($monat, $i, $jahr)) {
                    $data .= '<td class="navKalEmpty"></td>';
                } elseif ($datum == $today) {
                    $data .= show("menu/kal_day", array("day" => $day, "id" => "navKalToday"));
                } else {
                    $data .= show("menu/kal_day", array("day" => $day, "id" => "navKalDays"));
                }
                $i++;
            }
        }
        $show .= "<tr>" . $data . "</tr>";
    }
    if ($monat + 1 == 13) {
        $nm = 1;
        $ny = $jahr + 1;
    } else {
        $nm = $monat + 1;
        $ny = $jahr;
    }
    if ($monat - 1 == 0) {
        $lm = 12;
        $ly = $jahr - 1;
    } else {
        $lm = $monat - 1;
        $ly = $jahr;
    }
    $kalender = show("menu/kalender", array("monat" => $month, "show" => $show, "year" => $jahr, "nm" => $nm, "ny" => $ny, "lm" => $lm, "ly" => $ly, "montag" => _nav_montag, "dienstag" => _nav_dienstag, "mittwoch" => _nav_mittwoch, "donnerstag" => _nav_donnerstag, "freitag" => _nav_freitag, "samstag" => _nav_samstag, "sonntag" => _nav_sonntag));
    return '<div id="navKalender">' . $kalender . '</div>';
}