ilch Forum » Ilch Clan 1.1 » Module und Modifikationen » next war ab zusage

Geschlossen
  1. #1
    User Pic
    Drakukolose Mitglied
    Registriert seit
    29.03.2013
    Beiträge
    27
    Beitragswertungen
    0 Beitragspunkte
    hi leuts,
    ich habe folgende idee scheiter bissher nur an der umsetzung.

    wenn wars anstehen kann man ja an die squad mitglieder ne anfrage stellen od sie zu dem anstehenden War teilnehmen oder Absagen.
    Jetzt meine idee wie kann ich sowas einfügen das die member auch ein weiss noch nicht genau anklicken können statt gleich zu oder absagen zu müssen viele meiner Member sind Berufstätig und habe viel zu tun.

    also nochmal in kurz
    Zusagen/ Absagen/ weiss noch nicht würde ich gern mit hinzu fügen
    In welcher datei müßte ich den code dann einfügen und wenn welchen???

    betroffene Homepage: dormagenerelite.funpic.de


    Zuletzt modifiziert von Drakukolose am 22.04.2013 - 11:47:17
    0 Mitglieder finden den Beitrag gut.
  2. #2
    User Pic
    Rock@wulf Entwickler
    Registriert seit
    03.06.2004
    Beiträge
    3.277
    Beitragswertungen
    237 Beitragspunkte
    Leutz sucht doch mal im Forum.....
    Meine Postings repräsentieren meine Meinung wenn nicht anders gekennzeichnet.
    MFG Rock@wulf
    0 Mitglieder finden den Beitrag gut.
  3. #3
    User Pic
    Drakukolose Mitglied
    Registriert seit
    29.03.2013
    Beiträge
    27
    Beitragswertungen
    0 Beitragspunkte
    habe leider dies bezüglich nix gefunden sry, wenn du was gefunden haben solltest sei so nett und schick mir nen link bitte.

    die vote.php is es nicht wo ich einträge machen muss oder??? ich muss gestehen ich habe keinerlei erfahrung mit dem ganzen hier daherbitte um nachsicht


    Zuletzt modifiziert von Drakukolose am 22.04.2013 - 11:52:46
    0 Mitglieder finden den Beitrag gut.
  4. #4
    User Pic
    Rock@wulf Entwickler
    Registriert seit
    03.06.2004
    Beiträge
    3.277
    Beitragswertungen
    237 Beitragspunkte
    Hm ich muss gestehen ich finds grade auch nicht... O.o

    Prinzipell funktioniert das allerdings muss man ein wenig im code rumfummeln

    evtl advanced wars nutzen da ist das meines wissens mit drin

    Ehm ja nein da auch nicht ....

    bitte mal die verwendete wars.php sowie wars-next.htm posten

    Zuletzt modifiziert von Rock@wulf am 22.04.2013 - 12:08:12
    Meine Postings repräsentieren meine Meinung wenn nicht anders gekennzeichnet.
    MFG Rock@wulf
    0 Mitglieder finden den Beitrag gut.
  5. #5
    User Pic
    Drakukolose Mitglied
    Registriert seit
    29.03.2013
    Beiträge
    27
    Beitragswertungen
    0 Beitragspunkte
    hier der derzeitige War.php Code
    aus dem Ordner Include/contens/war.php
    <?php
    // Copyright by: Manuel
    // Support: www.ilch.de
    defined ('main') or die ('no direct access');
    
    function get_erg_liste($wid) {
        $list = '';
        $enar = array ('jpg', 'gif', 'png', 'jpeg');
        $erg = db_query("SELECT * FROM prefix_warmaps WHERE `wid` = " . $wid);
        while ($row = db_fetch_assoc($erg)) {
            if ($row['opp'] == $row['owp']) {
                $farbe = 'FDFBB7'; #pat
            } elseif ($row['opp'] < $row['owp']) {
                $farbe = 'C8E1B8'; #win
            } elseif ($row['opp'] > $row['owp']) {
                $farbe = 'D8B9B9'; #los
            }
            foreach($enar as $v) {
                if (file_exists ('include/images/wars/' . $wid . '_' . $row['mnr'] . '.' . $v)) {
                    $size = getimagesize('include/images/wars/' . $wid . '_' . $row['mnr'] . '.' . $v);
                    $breite = $size[0];
                    $hoehe = $size[1];
                    $row['map'] = '<a href="#" onClick="javascript:window.open(\'include/images/wars/' . $wid . '_' . $row['mnr'] . '.' . $v . '\',\'bild\',\'height=' . $hoehe . ',width=' . $breite . '\')">' . $row['map'] . '</a>';
                    break;
                }
            }
            $list .= '<tr bgcolor="#' . $farbe . '">';
            $list .= '<td><font color="#000000">' . $row['map'] . '</font></td>';
            $list .= '<td><font color="#000000">' . $row['opp'] . '</font></td>';
            $list .= '<td><font color="#000000">' . $row['owp'] . '</font></td>';
            $list .= '</tr>';
        }
        return ($list);
    }
    
    function lastwars_get_memberlist ($id) {
        $l = '';
        $erg = db_query("SELECT prefix_user.id,prefix_user.name FROM prefix_user LEFT JOIN prefix_warmember ON prefix_warmember.uid = prefix_user.id AND prefix_warmember.wid = " . $id . " WHERE wid = " . $id . " ORDER BY prefix_user.name ASC");
        while ($r = db_fetch_assoc($erg)) {
            $l .= '<a href="index.php?user-details-' . $r['id'] . '">' . $r['name'] . '</a>, ';
        }
        return (substr($l, 0, - 2));
    }
    
    if ($menu->get(2) == '' OR $menu->getA(2) == 'p') {
        $title = $allgAr['title'] . ' :: Wars';
        $hmenu = 'Wars';
        $design = new design ($title , $hmenu);
        $design->header();
    
    	$out = array('GES' => 0, 'WIN' => 0, 'LOS' => 0, 'PAT' => 0, 'TITLE' => $allgAr['title']);
    
    	if (isset($_POST['tid']) and is_numeric($_POST['tid'])) {
    		$tid = escape($_POST['tid'], 'integer');
    		$where1 = 'AND tid = '.$tid;
    		$where2 = 'AND a.tid = '.$tid;
    		$out['TITLE'] = db_result(db_query('SELECT `name` FROM `prefix_groups` WHERE `id` = ' . $tid));
    	} else {
    		$where1 = $where2 = '';
    	}
    
        $keys = array(1 => 'WIN', 2 => 'LOS', 3 => 'PAT');
        $qry = db_query('SELECT `wlp`, COUNT(`id`) AS sum FROM `prefix_wars` WHERE `status` = 3 ' . $where1 . ' GROUP BY `wlp`');
        while ($r = db_fetch_assoc($qry)) {
            $out[$keys[$r['wlp']]] = $r['sum'];
            $out['GES'] += $r['sum'];
        }
        $tpl = new tpl ('wars.htm');
        $tpl->set_ar_out ($out , 0);
        $akttime = date('Y-m-d');
        $class = '';
        $erg = db_query('SELECT a.id,a.gegner,a.page,a.game,b.name as team,DATE_FORMAT(a.datime,"%d.%m.%Y - %H:%i:%s") as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id WHERE a.status = 2 AND a.datime >= "' . $akttime . '" ' . $where2 . ' ORDER BY a.datime');
        if (db_num_rows ($erg) == 0) {
            echo '<tr class="Cmite"><td colspan="4"><strong>kein Next War vorhanden</strong></td></tr>';
        } else {
            while ($row = db_fetch_assoc($erg)) {
                if ($class == 'Cmite') {
                    $class = 'Cnorm';
                }else {
                    $class = 'Cmite';
                }
                $row['page'] = get_homepage($row['page']);
                $row['team'] = get_wargameimg($row['game']) . '&nbsp;' . $row['team'];
                $row['class'] = $class;
                $tpl->set_ar_out($row, 1);
            }
        }
        $tpl->out(2);
        $class = '';
    		$wlps = array(1 => $lang['win'], 2 => $lang['los'], 3 => $lang['pat']);
    		$sqla = 'WHERE status = 3 AND ';
            $wheres = array();
    		if (isset($_POST['tid']) and !empty($_POST['tid'])) {
    			$teams = dblistee ($_POST['tid'], "SELECT `id`, `name` FROM `prefix_groups` ORDER BY `name`");
    			$wheres[] = 'tid = ' . escape($_POST['tid'], 'integer');
    		    //wlps einschränken
    		    $qry = db_query('SELECT DISTINCT wlp FROM prefix_wars ' . (count($wheres) ? $sqla . implode(' AND ', $wheres) : ''));
    		    $dbwlps = array();
    		    while($r = db_fetch_assoc($qry)){
    		        $dbwlps[] = (int)$r['wlp'];
    		    }
    		    foreach ($wlps as $k => $v){
                    if (!in_array($k, $dbwlps)) {
    		            unset($wlps[$k]);
    		        }
    		    }
    		} else {
    			$teams = dblistee ('', "SELECT `id`, `name` FROM `prefix_groups` ORDER BY `name`");
    		}
            if (isset($_POST['wlp']) and !empty($_POST['wlp'])) {
                $wlp = arlistee($_POST['wlp'], $wlps);
                $wheres[] = 'wlp = ' . escape($_POST['wlp'], 'integer');
            } else {
                $wlp = arlistee('', $wlps);
            }
    		if (isset($_POST['spiel']) and !empty($_POST['spiel'])) {
    			$game = dblistee ($_POST['spiel'], "SELECT DISTINCT `game`,`game` FROM `prefix_wars` " .(count($wheres) ? $sqla . implode(' AND ', $wheres) : ''). " ORDER BY `game`");
    			$wheres[] = 'game = "'.escape($_POST['spiel'], 'string').'"';
    		} else {
    			$game = dblistee ('', "SELECT DISTINCT `game`,`game` FROM `prefix_wars` " .(count($wheres) ? $sqla . implode(' AND ', $wheres) : ''). " ORDER BY `game`");
    		}
            if (isset($_POST['typ']) and !empty($_POST['typ'])) {
                $mtyp = dblistee ($_POST['typ'], "SELECT DISTINCT `mtyp`,`mtyp` FROM `prefix_wars` " .(count($wheres) ? $sqla . implode(' AND ', $wheres) : ''). " ORDER BY `mtyp`");
                $wheres[] = 'mtyp = "'.escape($_POST['typ'], 'string').'"';
            } else {
                $mtyp = dblistee ('', "SELECT DISTINCT `mtyp`,`mtyp` FROM `prefix_wars` " .(count($wheres) ? $sqla . implode(' AND ', $wheres) : ''). " ORDER BY `mtyp`");
            }
    
            $tpl->set_ar_out (array('tid' => $teams, 'game' => $game, 'typ' => $mtyp, 'wlp' => $wlp) , 3);
    	if ($menu->get(1) == 'last') {
            $tpl->out(4);
            $sqla = 'WHERE status = 3 ' . (!empty($wheres) ? ' AND ' . implode(' AND ', $wheres) : '');
            // seiten funktion
            $limit = $allgAr['wars_last_limit']; // Limit
    		if (isset($_POST['page']) and is_numeric($_POST['page']) and $_POST['page'] >= 1) {
    			$menu->set_url(2, 'p'.intval($_POST['page']));
    		}
            $page = ($menu->getA(2) == 'p' ? $menu->getE(2) : 1);
            $MPL = db_make_sites ($page , $sqla , $limit , "?wars-last" , 'wars');
    
    		$MPL = preg_replace('%-p(\d+)"%', '$0 onclick="return loadLWPage($1);"', $MPL);
    
    		$anfang = ($page - 1) * $limit;
            // seiten funktion
            $farbe1wlpar = array(1 => 'C8E1B8', 2 => 'D8B9B9', 3 => 'FDFBB7');
            $farbe2wlpar = array(1 => '00FF00', 2 => 'FF0000', 3 => 'FFFF00');
            $erg = db_query("SELECT a.owp,a.opp,a.wlp,a.land,a.mtyp,a.game,a.id,a.gegner,a.page,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id " . $sqla . " ORDER BY a.datime DESC, id DESC LIMIT " . $anfang . "," . $limit);
            while ($row = db_fetch_assoc($erg)) {
                $row['erg'] = $row['opp'] . ':' . $row['owp'];
                $row['farbe'] = $farbe1wlpar[$row['wlp']];
                $row['farbe2'] = $farbe2wlpar[$row['wlp']];
                if ($class == 'Cmite') {
                    $class = 'Cnorm';
                } else {
                    $class = 'Cmite';
                }
                $row['page'] = get_homepage($row['page']);
                $row['team'] = get_wargameimg($row['game']) . '&nbsp;' . $row['team'];
                $row['class'] = $class;
                $tpl->set_ar_out($row, 5);
            }
            $tpl->set_out('MPL', $MPL, 6);
    	}
        $design->footer();
    } elseif (is_numeric($menu->get(2))) {
        $_GET['mehr'] = escape($menu->get(2), 'integer');
    
        $erg = @db_query("SELECT
    	DATE_FORMAT(datime,'%d.%m.%Y') as datum,
    	tid, status, owp, opp, wlp,
    	DATE_FORMAT(datime,'%H:%i:%s') as zeit,
    	gegner, tag, page, mail, icq, wo, prefix_wars.`mod`, mtyp,
    	game, land, txt, prefix_wars.id,
    	name as team
    	FROM prefix_wars
    	left join prefix_groups ON prefix_wars.tid = prefix_groups.id
    	WHERE prefix_wars.id = " . $_GET['mehr']);
    
        db_check_erg ($erg);
    
        $row = db_fetch_assoc($erg);
        $row['page'] = get_homepage($row['page']);
        $row['txt'] = bbcode($row['txt']);
        if ($row['status'] == 2) {
            // nextwars
            $title = $allgAr['title'] . ' :: Wars :: Nextwars';
            $hmenu = '<a href="?wars" class="smalfont">Wars</a><b> &raquo; </b>Nextwars';
            $design = new design ($title , $hmenu);
            $design->header();
            $tpl = new tpl ('wars_next');
            $row['tag'] = (empty($row['tag']) ? $row['gegner'] : $row['tag']);
            if ($_SESSION['authright'] <= - 3) {
                $row['mail'] = $row['mail'];
                $row['icq'] = $row['icq'];
                $row['wo'] = $row['wo'];
                $row['txt'] = $row['txt'];
            } else {
                $row['icq'] = 'locked';
                $row['mail'] = 'locked';
                $row['wo'] = 'locked';
                $row['txt'] = 'locked';
            }
            $tpl->set_ar_out($row, 0);
    
            if ($_SESSION['authright'] <= - 2) {
                // get benoetige member
                $bm = substr($row['mod'], 0, 3);
                $needed = '';
                for($i = 0;$i < strlen($bm);$i++) {
                    if (is_numeric($bm {
                                $i}
                            )) {
                        $needed .= $bm {
                            $i};
                    }
                }
    
                $uid = $_SESSION['authid'];
                if ($menu->get(3) == 'delete') {
                    $uid = $menu->get(4);
                }
                $ck = db_count_query("SELECT COUNT(wid) FROM prefix_warmember WHERE wid = " . $_GET['mehr'] . " AND uid = " . $uid);
                // eine zu bzw. absage loeschen
                if ($menu->get(3) == 'delete' AND ((has_right(array($row['tid'])) === true AND $uid == $_SESSION['authid']) OR is_siteadmin('wars')) AND $ck == 1) {
                    db_query("DELETE FROM prefix_warmember WHERE wid = " . $_GET['mehr'] . " AND uid = " . $uid);
                    $ck = 0;
                }
    
                $available = db_count_query("SELECT COUNT(uid) FROM prefix_warmember WHERE wid = " . $_GET['mehr'] . " AND aktion = 1");
                $aout1 = array (
                    'needed' => $needed,
                    'available' => $available,
                    'id' => $_GET['mehr']
                    );
                $tpl->set_ar_out($aout1, 1);
                if ($ck == 0 AND has_right(array($row['tid'])) === true) {
                    if (isset ($_POST['sub'])) {
                        $aktion = ($_POST['sub'] == 'zusagen' ? 1 : 0);
                        $kom = escape($_POST['kom'], 'string');
                        db_query("INSERT INTO prefix_warmember (uid,wid,aktion,kom) VALUES (" . $_SESSION['authid'] . "," . $_GET['mehr'] . "," . $aktion . ",'" . $kom . "')");
                    } else {
                        $tpl->out(2);
                    }
                }
                $class = '';
                $aktionar = array ('<font style="color:#FF0000; background:#666666; font-weight:bold;">abgesagt</font>', '<font style="font-weight:bold; color:#00FF00; background:#666666;">zugesagt</font>');
                $erg1 = db_query("SELECT b.id as uid, b.name, a.aktion, a.kom FROM prefix_warmember a left join prefix_user b ON b.id = a.uid WHERE a.wid = " . $_GET['mehr']);
                while ($row1 = db_fetch_assoc($erg1)) {
                    if ($class == 'Cmite') {
                        $class = 'Cnorm';
                    } else {
                        $class = 'Cmite';
                    }
                    $row1['class'] = $class;
                    $row1['aktion'] = $aktionar[$row1['aktion']];
                    if ($row1['uid'] == $_SESSION['authid'] OR is_siteadmin('wars')) {
                        $row1['name'] = '<a href="index.php?wars-more-' . $_GET['mehr'] . '-delete-' . $row1['uid'] . '"><img src="include/images/icons/del.gif" border="0" title="l&ouml;schen" /></a> &nbsp; ' . $row1['name'];
                    }
                    $tpl->set_ar_out($row1, 3);
                }
            }
            $tpl->out(4);
        } elseif ($row['status'] == 3) {
            // lastwars
            $row['memberliste'] = lastwars_get_memberlist($_GET['mehr']);
            $wlpar = array(1 => 'gewonnen', 2 => 'verloren', 3 => 'unentschieden');
            $row['erg'] = $row['owp'] . ' zu ' . $row['opp'];
            $row['ergliste'] = get_erg_liste($_GET['mehr']);
            $row['wlp'] = $wlpar[$row['wlp']];
            $title = $allgAr['title'] . ' :: Wars :: Lastwars';
            $hmenu = '<a href="?wars" class="smalfont">Wars</a><b> &raquo; </b>Lastwars';
            $design = new design ($title , $hmenu);
            $design->header();
            $tpl = new tpl ('wars_last');
            $row['tag'] = (empty($row['tag']) ? $row['gegner'] : $row['tag']);
            $tpl->set_ar_out($row, 0);
            // kommentare fuer lastwars
            if ($allgAr['wars_last_komms'] < 0 AND has_right ($allgAr['wars_last_komms'])) {
                // aktion
                if (isset ($_POST['kommentar_fuer_last_wars'])) {
                    $name = $_SESSION['authname'];
                    $text = escape($_POST['text'], 'textarea');
                    db_query("INSERT INTO prefix_koms (name,cat,text,uid) VALUES ('" . $name . "','WARSLAST', '" . $text . "', " . $_GET['mehr'] . " )");
                }
                if (isset ($_GET['kommentar_fuer_last_wars_loeschen']) AND is_siteadmin('wars')) {
                    db_query("DELETE FROM prefix_koms WHERE cat = 'WARSLAST' AND uid = " . $_GET['mehr'] . " AND id = " . $_GET['kommentar_fuer_last_wars_loeschen']);
                }
                // anzeigen
                $tpl->out(1);
                $class = '';
                $erg = db_query("SELECT name,text,id FROM prefix_koms WHERE cat = 'WARSLAST' AND uid = " . $_GET['mehr'] . " ORDER BY id DESC");
                while ($r = db_fetch_assoc($erg)) {
                    $class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite');
                    $r['text'] = bbcode($r['text']);
                    if (is_siteadmin('wars')) {
                        $r['text'] .= '<a href="index.php?wars-more-' . $_GET['mehr'] . '=0&amp;kommentar_fuer_last_wars_loeschen=' . $r['id'] . '"><img src="include/images/icons/del.gif" title="l&ouml;schen" alt="l&ouml;schen" border="0"></a>';
                    }
                    $r['class'] = $class;
                    $tpl->set_ar_out($r, 2);
                }
                $tpl->out(3);
            }
        }
        $design->footer();
    }
    
    ?>



    Zuletzt modifiziert von Drakukolose am 22.04.2013 - 12:13:53

    Wars next.htm aus den Ordner: /include/templates

    <table border="0" cellspacing="1" cellpadding="5" class="border">
    <tr class="Chead">
    	<td colspan="2"><b>{_lang_war} {_lang_against}: {tag}</b></td>
    </tr><tr>
    	<td class="Cdark" colspan="2" align="left"><b>&nbsp;{_lang_opponent} {_lang_info}</b></td>
    </tr><tr>
    	<td class="Cmite">{_lang_clancountry}:</td>
    	<td class="Cnorm"><img src="include/images/flags/{land}" alt="" border="0"></td>
    </tr><tr>
    	<td class="Cmite">{_lang_name}:</td>
    	<td class="Cnorm">{gegner}</td>
    </tr><tr>
    	<td class="Cmite">{_lang_homepage}</td>
    	<td class="Cnorm"><a href="{page}" target="_blank">{page}</a></td>
    </tr><tr>
    	<td class="Cmite">{_lang_mail}</td>
    	<td class="Cnorm">{mail}</td>
    </tr><tr>
    	<td class="Cmite">{_lang_icq}</td>
    	<td class="Cnorm">{icq}</td>
    </tr><tr>
    	<td class="Cdark" colspan="2" align="left"><b>&nbsp;{_lang_match} {_lang_info}</b></td>
    </tr><tr>
    	<td class="Cmite">{_lang_date}</td>
    	<td class="Cnorm"><strong>{_lang_On} {datum} {_lang_at} {zeit} {_lang_oclock}</strong></td>
    </tr><tr>
    	<td class="Cmite">{_lang_meetingplace}</td>
    	<td class="Cnorm">{wo}</td>
    </tr><tr>
    	<td class="Cmite">{_lang_squad}</td>
    	<td class="Cnorm"><u><i><b>{team}</b></i></u></td>
    </tr><tr>
    	<td class="Cmite">{_lang_xonx}</td>
    	<td class="Cnorm">{mod}</td>
    </tr><tr>
    	<td class="Cmite">{_lang_matchtype}:</td>
    	<td class="Cnorm">{mtyp}</td>
    </tr><tr>
    	<td class="Cmite">{_lang_game}:</td>
    	<td class="Cnorm">{game}</td>
    </tr><tr>
    	<td class="Cmite">{_lang_remark}:</td>
    	<td class="Cnorm">{txt}</td>
    </tr>
    </table>
    <br/>
    <table width="100%" border="0" cellspacing="1" cellpadding="5" class="border">
    {EXPLODE}
    <tr class="Cdark">
    	<td>{_lang_present} / {_lang_away} &nbsp; - &nbsp; ( {_lang_promise}: {available} {_lang_from} {_lang_needed}: {needed} )</td>
    </tr>
    {EXPLODE}
    <tr class="Cnorm">
    	<td>
    	<form action="index.php?wars-more-{id}" method="POST"><table><tr><td colspan="3"><input name="kom" size="65" /></td></tr>
      <tr><td><input type="radio" id="zusage" value="zusagen" name="sub" checked /><label for="zusage"  style="cursor: pointer;"> {_lang_promise}</label></td>
      <td><input type="radio" id="absage" value="absagen" name="sub"  /><label for="absage"  style="cursor: pointer;"> {_lang_cancellation}</label></td>
      <td align="right"><input type="submit" value="{_lang_formsub}"  /></td></tr></table></form>
    	</td>
    </tr>
    {EXPLODE}
    <tr class="{class}">
    	<td><b>{name}</b> {_lang_had} {aktion} <u>{_lang_comment}:</u> {kom}</td>
    </tr>
    {EXPLODE}
    </table>



    Zuletzt modifiziert von Drakukolose am 22.04.2013 - 12:19:08
    0 Mitglieder finden den Beitrag gut.
  6. #6
    User Pic
    Lord|Schirmer Administrator
    Registriert seit
    21.03.2007
    Beiträge
    7.260
    Beitragswertungen
    1114 Beitragspunkte
    <?php
    // Copyright by: Manuel
    // Support: www.ilch.de
    defined ('main') or die ('no direct access');
     
    function get_erg_liste($wid) {
        $list = '';
        $enar = array ('jpg', 'gif', 'png', 'jpeg');
        $erg = db_query("SELECT * FROM prefix_warmaps WHERE `wid` = " . $wid);
        while ($row = db_fetch_assoc($erg)) {
            if ($row['opp'] == $row['owp']) {
                $farbe = 'FDFBB7'; #pat
            } elseif ($row['opp'] < $row['owp']) {
                $farbe = 'C8E1B8'; #win
            } elseif ($row['opp'] > $row['owp']) {
                $farbe = 'D8B9B9'; #los
            }
            foreach($enar as $v) {
                if (file_exists ('include/images/wars/' . $wid . '_' . $row['mnr'] . '.' . $v)) {
                    $size = getimagesize('include/images/wars/' . $wid . '_' . $row['mnr'] . '.' . $v);
                    $breite = $size[0];
                    $hoehe = $size[1];
                    $row['map'] = '<a href="#" onClick="javascript:window.open(\'include/images/wars/' . $wid . '_' . $row['mnr'] . '.' . $v . '\',\'bild\',\'height=' . $hoehe . ',width=' . $breite . '\')">' . $row['map'] . '</a>';
                    break;
                }
            }
            $list .= '<tr bgcolor="#' . $farbe . '">';
            $list .= '<td><font color="#000000">' . $row['map'] . '</font></td>';
            $list .= '<td><font color="#000000">' . $row['opp'] . '</font></td>';
            $list .= '<td><font color="#000000">' . $row['owp'] . '</font></td>';
            $list .= '</tr>';
        }
        return ($list);
    }
     
    function lastwars_get_memberlist ($id) {
        $l = '';
        $erg = db_query("SELECT prefix_user.id,prefix_user.name FROM prefix_user LEFT JOIN prefix_warmember ON prefix_warmember.uid = prefix_user.id AND prefix_warmember.wid = " . $id . " WHERE wid = " . $id . " ORDER BY prefix_user.name ASC");
        while ($r = db_fetch_assoc($erg)) {
            $l .= '<a href="index.php?user-details-' . $r['id'] . '">' . $r['name'] . '</a>, ';
        }
        return (substr($l, 0, - 2));
    }
     
    if ($menu->get(2) == '' OR $menu->getA(2) == 'p') {
        $title = $allgAr['title'] . ' :: Wars';
        $hmenu = 'Wars';
        $design = new design ($title , $hmenu);
        $design->header();
     
        $out = array('GES' => 0, 'WIN' => 0, 'LOS' => 0, 'PAT' => 0, 'TITLE' => $allgAr['title']);
     
        if (isset($_POST['tid']) and is_numeric($_POST['tid'])) {
            $tid = escape($_POST['tid'], 'integer');
            $where1 = 'AND tid = '.$tid;
            $where2 = 'AND a.tid = '.$tid;
            $out['TITLE'] = db_result(db_query('SELECT `name` FROM `prefix_groups` WHERE `id` = ' . $tid));
        } else {
            $where1 = $where2 = '';
        }
     
        $keys = array(1 => 'WIN', 2 => 'LOS', 3 => 'PAT');
        $qry = db_query('SELECT `wlp`, COUNT(`id`) AS sum FROM `prefix_wars` WHERE `status` = 3 ' . $where1 . ' GROUP BY `wlp`');
        while ($r = db_fetch_assoc($qry)) {
            $out[$keys[$r['wlp']]] = $r['sum'];
            $out['GES'] += $r['sum'];
        }
        $tpl = new tpl ('wars.htm');
        $tpl->set_ar_out ($out , 0);
        $akttime = date('Y-m-d');
        $class = '';
        $erg = db_query('SELECT a.id,a.gegner,a.page,a.game,b.name as team,DATE_FORMAT(a.datime,"%d.%m.%Y - %H:%i:%s") as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id WHERE a.status = 2 AND a.datime >= "' . $akttime . '" ' . $where2 . ' ORDER BY a.datime');
        if (db_num_rows ($erg) == 0) {
            echo '<tr class="Cmite"><td colspan="4"><strong>kein Next War vorhanden</strong></td></tr>';
        } else {
            while ($row = db_fetch_assoc($erg)) {
                if ($class == 'Cmite') {
                    $class = 'Cnorm';
                }else {
                    $class = 'Cmite';
                }
                $row['page'] = get_homepage($row['page']);
                $row['team'] = get_wargameimg($row['game']) . '&nbsp;' . $row['team'];
                $row['class'] = $class;
                $tpl->set_ar_out($row, 1);
            }
        }
        $tpl->out(2);
        $class = '';
            $wlps = array(1 => $lang['win'], 2 => $lang['los'], 3 => $lang['pat']);
            $sqla = 'WHERE status = 3 AND ';
            $wheres = array();
            if (isset($_POST['tid']) and !empty($_POST['tid'])) {
                $teams = dblistee ($_POST['tid'], "SELECT `id`, `name` FROM `prefix_groups` ORDER BY `name`");
                $wheres[] = 'tid = ' . escape($_POST['tid'], 'integer');
                //wlps einschränken
                $qry = db_query('SELECT DISTINCT wlp FROM prefix_wars ' . (count($wheres) ? $sqla . implode(' AND ', $wheres) : ''));
                $dbwlps = array();
                while($r = db_fetch_assoc($qry)){
                    $dbwlps[] = (int)$r['wlp'];
                }
                foreach ($wlps as $k => $v){
                    if (!in_array($k, $dbwlps)) {
                        unset($wlps[$k]);
                    }
                }
            } else {
                $teams = dblistee ('', "SELECT `id`, `name` FROM `prefix_groups` ORDER BY `name`");
            }
            if (isset($_POST['wlp']) and !empty($_POST['wlp'])) {
                $wlp = arlistee($_POST['wlp'], $wlps);
                $wheres[] = 'wlp = ' . escape($_POST['wlp'], 'integer');
            } else {
                $wlp = arlistee('', $wlps);
            }
            if (isset($_POST['spiel']) and !empty($_POST['spiel'])) {
                $game = dblistee ($_POST['spiel'], "SELECT DISTINCT `game`,`game` FROM `prefix_wars` " .(count($wheres) ? $sqla . implode(' AND ', $wheres) : ''). " ORDER BY `game`");
                $wheres[] = 'game = "'.escape($_POST['spiel'], 'string').'"';
            } else {
                $game = dblistee ('', "SELECT DISTINCT `game`,`game` FROM `prefix_wars` " .(count($wheres) ? $sqla . implode(' AND ', $wheres) : ''). " ORDER BY `game`");
            }
            if (isset($_POST['typ']) and !empty($_POST['typ'])) {
                $mtyp = dblistee ($_POST['typ'], "SELECT DISTINCT `mtyp`,`mtyp` FROM `prefix_wars` " .(count($wheres) ? $sqla . implode(' AND ', $wheres) : ''). " ORDER BY `mtyp`");
                $wheres[] = 'mtyp = "'.escape($_POST['typ'], 'string').'"';
            } else {
                $mtyp = dblistee ('', "SELECT DISTINCT `mtyp`,`mtyp` FROM `prefix_wars` " .(count($wheres) ? $sqla . implode(' AND ', $wheres) : ''). " ORDER BY `mtyp`");
            }
     
            $tpl->set_ar_out (array('tid' => $teams, 'game' => $game, 'typ' => $mtyp, 'wlp' => $wlp) , 3);
        if ($menu->get(1) == 'last') {
            $tpl->out(4);
            $sqla = 'WHERE status = 3 ' . (!empty($wheres) ? ' AND ' . implode(' AND ', $wheres) : '');
            // seiten funktion
            $limit = $allgAr['wars_last_limit']; // Limit
            if (isset($_POST['page']) and is_numeric($_POST['page']) and $_POST['page'] >= 1) {
                $menu->set_url(2, 'p'.intval($_POST['page']));
            }
            $page = ($menu->getA(2) == 'p' ? $menu->getE(2) : 1);
            $MPL = db_make_sites ($page , $sqla , $limit , "?wars-last" , 'wars');
     
            $MPL = preg_replace('%-p(\d+)"%', '$0 onclick="return loadLWPage($1);"', $MPL);
     
            $anfang = ($page - 1) * $limit;
            // seiten funktion
            $farbe1wlpar = array(1 => 'C8E1B8', 2 => 'D8B9B9', 3 => 'FDFBB7');
            $farbe2wlpar = array(1 => '00FF00', 2 => 'FF0000', 3 => 'FFFF00');
            $erg = db_query("SELECT a.owp,a.opp,a.wlp,a.land,a.mtyp,a.game,a.id,a.gegner,a.page,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id " . $sqla . " ORDER BY a.datime DESC, id DESC LIMIT " . $anfang . "," . $limit);
            while ($row = db_fetch_assoc($erg)) {
                $row['erg'] = $row['opp'] . ':' . $row['owp'];
                $row['farbe'] = $farbe1wlpar[$row['wlp']];
                $row['farbe2'] = $farbe2wlpar[$row['wlp']];
                if ($class == 'Cmite') {
                    $class = 'Cnorm';
                } else {
                    $class = 'Cmite';
                }
                $row['page'] = get_homepage($row['page']);
                $row['team'] = get_wargameimg($row['game']) . '&nbsp;' . $row['team'];
                $row['class'] = $class;
                $tpl->set_ar_out($row, 5);
            }
            $tpl->set_out('MPL', $MPL, 6);
        }
        $design->footer();
    } elseif (is_numeric($menu->get(2))) {
        $_GET['mehr'] = escape($menu->get(2), 'integer');
     
        $erg = @db_query("SELECT
        DATE_FORMAT(datime,'%d.%m.%Y') as datum,
        tid, status, owp, opp, wlp,
        DATE_FORMAT(datime,'%H:%i:%s') as zeit,
        gegner, tag, page, mail, icq, wo, prefix_wars.`mod`, mtyp,
        game, land, txt, prefix_wars.id,
        name as team
        FROM prefix_wars
        left join prefix_groups ON prefix_wars.tid = prefix_groups.id
        WHERE prefix_wars.id = " . $_GET['mehr']);
     
        db_check_erg ($erg);
     
        $row = db_fetch_assoc($erg);
        $row['page'] = get_homepage($row['page']);
        $row['txt'] = bbcode($row['txt']);
        if ($row['status'] == 2) {
            // nextwars
            $title = $allgAr['title'] . ' :: Wars :: Nextwars';
            $hmenu = '<a href="?wars" class="smalfont">Wars</a><b> &raquo; </b>Nextwars';
            $design = new design ($title , $hmenu);
            $design->header();
            $tpl = new tpl ('wars_next');
            $row['tag'] = (empty($row['tag']) ? $row['gegner'] : $row['tag']);
            if ($_SESSION['authright'] <= - 3) {
                $row['mail'] = $row['mail'];
                $row['icq'] = $row['icq'];
                $row['wo'] = $row['wo'];
                $row['txt'] = $row['txt'];
            } else {
                $row['icq'] = 'locked';
                $row['mail'] = 'locked';
                $row['wo'] = 'locked';
                $row['txt'] = 'locked';
            }
            $tpl->set_ar_out($row, 0);
     
            if ($_SESSION['authright'] <= - 2) {
                // get benoetige member
                $bm = substr($row['mod'], 0, 3);
                $needed = '';
                for($i = 0;$i < strlen($bm);$i++) {
                    if (is_numeric($bm {
                                $i}
                            )) {
                        $needed .= $bm {
                            $i};
                    }
                }
     
                $uid = $_SESSION['authid'];
                if ($menu->get(3) == 'delete') {
                    $uid = $menu->get(4);
                }
                $ck = db_count_query("SELECT COUNT(wid) FROM prefix_warmember WHERE wid = " . $_GET['mehr'] . " AND uid = " . $uid);
                // eine zu bzw. absage loeschen
                if ($menu->get(3) == 'delete' AND ((has_right(array($row['tid'])) === true AND $uid == $_SESSION['authid']) OR is_siteadmin('wars')) AND $ck == 1) {
                    db_query("DELETE FROM prefix_warmember WHERE wid = " . $_GET['mehr'] . " AND uid = " . $uid);
                    $ck = 0;
                }
     
                $available = db_count_query("SELECT COUNT(uid) FROM prefix_warmember WHERE wid = " . $_GET['mehr'] . " AND aktion = 1");
                $aout1 = array (
                    'needed' => $needed,
                    'available' => $available,
                    'id' => $_GET['mehr']
                    );
                $tpl->set_ar_out($aout1, 1);
                if ($ck == 0 AND has_right(array($row['tid'])) === true) {
                    if (isset ($_POST['sub'])) {
                        switch ($_POST['sub']) {
    						case 'zusagen': $aktion = 1; break;
    						case 'absagen': $aktion = 0; break;
    						case 'vielleicht': $aktion = 2; break;
    					};
                        $kom = escape($_POST['kom'], 'string');
                        db_query("INSERT INTO prefix_warmember (uid,wid,aktion,kom) VALUES (" . $_SESSION['authid'] . "," . $_GET['mehr'] . "," . $aktion . ",'" . $kom . "')");
                    } else {
                        $tpl->out(2);
                    }
                }
                $class = '';
                $aktionar = array ('<font style="color:#FF0000; background:#666666; font-weight:bold;">abgesagt</font>', '<font style="font-weight:bold; color:#00FF00; background:#666666;">zugesagt</font>', '<font style="font-weight:bold; color:#FFFF00; background:#666666;">vielleicht</font>');
                $erg1 = db_query("SELECT b.id as uid, b.name, a.aktion, a.kom FROM prefix_warmember a left join prefix_user b ON b.id = a.uid WHERE a.wid = " . $_GET['mehr']);
                while ($row1 = db_fetch_assoc($erg1)) {
                    if ($class == 'Cmite') {
                        $class = 'Cnorm';
                    } else {
                        $class = 'Cmite';
                    }
                    $row1['class'] = $class;
                    $row1['aktion'] = $aktionar[$row1['aktion']];
                    if ($row1['uid'] == $_SESSION['authid'] OR is_siteadmin('wars')) {
                        $row1['name'] = '<a href="index.php?wars-more-' . $_GET['mehr'] . '-delete-' . $row1['uid'] . '"><img src="include/images/icons/del.gif" border="0" title="l&ouml;schen" /></a> &nbsp; ' . $row1['name'];
                    }
                    $tpl->set_ar_out($row1, 3);
                }
            }
            $tpl->out(4);
        } elseif ($row['status'] == 3) {
            // lastwars
            $row['memberliste'] = lastwars_get_memberlist($_GET['mehr']);
            $wlpar = array(1 => 'gewonnen', 2 => 'verloren', 3 => 'unentschieden');
            $row['erg'] = $row['owp'] . ' zu ' . $row['opp'];
            $row['ergliste'] = get_erg_liste($_GET['mehr']);
            $row['wlp'] = $wlpar[$row['wlp']];
            $title = $allgAr['title'] . ' :: Wars :: Lastwars';
            $hmenu = '<a href="?wars" class="smalfont">Wars</a><b> &raquo; </b>Lastwars';
            $design = new design ($title , $hmenu);
            $design->header();
            $tpl = new tpl ('wars_last');
            $row['tag'] = (empty($row['tag']) ? $row['gegner'] : $row['tag']);
            $tpl->set_ar_out($row, 0);
            // kommentare fuer lastwars
            if ($allgAr['wars_last_komms'] < 0 AND has_right ($allgAr['wars_last_komms'])) {
                // aktion
                if (isset ($_POST['kommentar_fuer_last_wars'])) {
                    $name = $_SESSION['authname'];
                    $text = escape($_POST['text'], 'textarea');
                    db_query("INSERT INTO prefix_koms (name,cat,text,uid) VALUES ('" . $name . "','WARSLAST', '" . $text . "', " . $_GET['mehr'] . " )");
                }
                if (isset ($_GET['kommentar_fuer_last_wars_loeschen']) AND is_siteadmin('wars')) {
                    db_query("DELETE FROM prefix_koms WHERE cat = 'WARSLAST' AND uid = " . $_GET['mehr'] . " AND id = " . $_GET['kommentar_fuer_last_wars_loeschen']);
                }
                // anzeigen
                $tpl->out(1);
                $class = '';
                $erg = db_query("SELECT name,text,id FROM prefix_koms WHERE cat = 'WARSLAST' AND uid = " . $_GET['mehr'] . " ORDER BY id DESC");
                while ($r = db_fetch_assoc($erg)) {
                    $class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite');
                    $r['text'] = bbcode($r['text']);
                    if (is_siteadmin('wars')) {
                        $r['text'] .= '<a href="index.php?wars-more-' . $_GET['mehr'] . '=0&amp;kommentar_fuer_last_wars_loeschen=' . $r['id'] . '"><img src="include/images/icons/del.gif" title="l&ouml;schen" alt="l&ouml;schen" border="0"></a>';
                    }
                    $r['class'] = $class;
                    $tpl->set_ar_out($r, 2);
                }
                $tpl->out(3);
            }
        }
        $design->footer();
    }
     
    ?>


    <table border="0" cellspacing="1" cellpadding="5" class="border">
    <tr class="Chead">
        <td colspan="2"><b>{_lang_war} {_lang_against}: {tag}</b></td>
    </tr><tr>
        <td class="Cdark" colspan="2" align="left"><b>&nbsp;{_lang_opponent} {_lang_info}</b></td>
    </tr><tr>
        <td class="Cmite">{_lang_clancountry}:</td>
        <td class="Cnorm"><img src="include/images/flags/{land}" alt="" border="0"></td>
    </tr><tr>
        <td class="Cmite">{_lang_name}:</td>
        <td class="Cnorm">{gegner}</td>
    </tr><tr>
        <td class="Cmite">{_lang_homepage}</td>
        <td class="Cnorm"><a href="{page}" target="_blank">{page}</a></td>
    </tr><tr>
        <td class="Cmite">{_lang_mail}</td>
        <td class="Cnorm">{mail}</td>
    </tr><tr>
        <td class="Cmite">{_lang_icq}</td>
        <td class="Cnorm">{icq}</td>
    </tr><tr>
        <td class="Cdark" colspan="2" align="left"><b>&nbsp;{_lang_match} {_lang_info}</b></td>
    </tr><tr>
        <td class="Cmite">{_lang_date}</td>
        <td class="Cnorm"><strong>{_lang_On} {datum} {_lang_at} {zeit} {_lang_oclock}</strong></td>
    </tr><tr>
        <td class="Cmite">{_lang_meetingplace}</td>
        <td class="Cnorm">{wo}</td>
    </tr><tr>
        <td class="Cmite">{_lang_squad}</td>
        <td class="Cnorm"><u><i><b>{team}</b></i></u></td>
    </tr><tr>
        <td class="Cmite">{_lang_xonx}</td>
        <td class="Cnorm">{mod}</td>
    </tr><tr>
        <td class="Cmite">{_lang_matchtype}:</td>
        <td class="Cnorm">{mtyp}</td>
    </tr><tr>
        <td class="Cmite">{_lang_game}:</td>
        <td class="Cnorm">{game}</td>
    </tr><tr>
        <td class="Cmite">{_lang_remark}:</td>
        <td class="Cnorm">{txt}</td>
    </tr>
    </table>
    <br/>
    <table width="100%" border="0" cellspacing="1" cellpadding="5" class="border">
    {EXPLODE}
        <tr class="Cdark">
            <td>{_lang_present} / {_lang_away} &nbsp; - &nbsp; ( {_lang_promise}: {available} {_lang_from} {_lang_needed}: {needed} )</td>
        </tr>
    {EXPLODE}
    <tr class="Cnorm">
        <td>
            <form action="index.php?wars-more-{id}" method="POST">
            <table>
                <tr>
                    <td colspan="3"><input name="kom" size="65" /></td>
                </tr>
                <tr>
                    <td><input type="radio" id="zusage" value="zusagen" name="sub" checked /><label for="zusage" style="cursor: pointer;"> {_lang_promise}</label></td>
                    <td><input type="radio" id="vielleicht" value="vielleicht" name="sub" /><label for="vielleicht" style="cursor: pointer;"> {_lang_maybe}</label></td>
                    <td><input type="radio" id="absage" value="absagen" name="sub" /><label for="absage" style="cursor: pointer;"> {_lang_cancellation}</label></td>
                    <td align="right"><input type="submit" value="{_lang_formsub}" /></td>
                </tr>
            </table>
            </form>
        </td>
    </tr>
    {EXPLODE}
    <tr class="{class}">
        <td><b>{name}</b> {_lang_had} {aktion} <u>{_lang_comment}:</u> {kom}</td>
    </tr>
    {EXPLODE}
    </table>


    und in die language Dateien:
    {_lang_maybe} = vielleicht


    - Info über Änderungsinhalte -
    include/contents/wars.php
    $aktion = ($_POST['sub'] == 'zusagen' ? 1 : 0);

    zu
    switch ($_POST['sub']) {
      case 'zusagen': $aktion = 1; break;
      case 'absagen': $aktion = 0; break;
      case 'vielleicht': $aktion = 2; break;
    };

    und
    $aktionar = array ('<font style="color:#FF0000; background:#666666; font-weight:bold;">abgesagt</font>', '<font style="font-weight:bold; color:#00FF00; background:#666666;">zugesagt</font>');

    zu
    $aktionar = array ('<font style="color:#FF0000; background:#666666; font-weight:bold;">abgesagt</font>', '<font style="font-weight:bold; color:#00FF00; background:#666666;">zugesagt</font>', '<font style="font-weight:bold; color:#FFFF00; background:#666666;">vielleicht</font>');


    include/templates/wars_next.htm
    <td><input type="radio" id="zusage" value="zusagen" name="sub" checked /><label for="zusage" style="cursor: pointer;"> {_lang_promise}</label></td>
    <td><input type="radio" id="absage" value="absagen" name="sub" /><label for="absage" style="cursor: pointer;"> {_lang_cancellation}</label></td>

    zu
    <td><input type="radio" id="zusage" value="zusagen" name="sub" checked /><label for="zusage" style="cursor: pointer;"> {_lang_promise}</label></td>
    <td><input type="radio" id="vielleicht" value="vielleicht" name="sub" /><label for="vielleicht" style="cursor: pointer;"> {_lang_maybe}</label></td>
    <td><input type="radio" id="absage" value="absagen" name="sub" /><label for="absage" style="cursor: pointer;"> {_lang_cancellation}</label></td>


    und zum Schluss die Sprach-Variable in den Language Dateien hinzufügen
    include/includes/lang/de.php
    'maybe' => 'vielleicht',

    include/includes/lang/en.php
    'maybe' => 'maybe',



    Zuletzt modifiziert von Lord|Schirmer am 22.04.2013 - 12:56:06
    rules :: doku :: faq :: linkus
    1 Mitglieder finden den Beitrag gut.
  7. #7
    User Pic
    Rock@wulf Entwickler
    Registriert seit
    03.06.2004
    Beiträge
    3.277
    Beitragswertungen
    237 Beitragspunkte
    Na da war er schneller lächeln

    Schreib doch mal ne FAQ ^^
    Meine Postings repräsentieren meine Meinung wenn nicht anders gekennzeichnet.
    MFG Rock@wulf
    0 Mitglieder finden den Beitrag gut.
  8. #8
    User Pic
    Lord|Schirmer Administrator
    Registriert seit
    21.03.2007
    Beiträge
    7.260
    Beitragswertungen
    1114 Beitragspunkte
    Jub mach ich lächeln
    rules :: doku :: faq :: linkus
    0 Mitglieder finden den Beitrag gut.
  9. #9
    User Pic
    Sor3x Mitglied
    Registriert seit
    01.05.2014
    Beiträge
    6
    Beitragswertungen
    0 Beitragspunkte
    Top vielen dank für die viele Arbeit
    0 Mitglieder finden den Beitrag gut.
  10. #10
    User Pic
    VicMediFight Mitglied
    Registriert seit
    09.05.2014
    Beiträge
    1
    Beitragswertungen
    0 Beitragspunkte
    Super, vielen Dank, genau das hatte ich auch gesucht, klappte einwandfrei!
    0 Mitglieder finden den Beitrag gut.
Geschlossen

Zurück zu Module und Modifikationen

Optionen: Bei einer Antwort zu diesem Thema eine eMail erhalten