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

Geschlossen
  1. Mo. 22.04.2013 11:37 Uhr #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. Mo. 22.04.2013 11:43 Uhr #2
    User Pic
    Rock@wulf Hall Of Fame
    Registriert seit
    03.06.2004
    Beiträge
    3.282
    Beitragswertungen
    239 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. Mo. 22.04.2013 11:48 Uhr #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. Mo. 22.04.2013 12:00 Uhr #4
    User Pic
    Rock@wulf Hall Of Fame
    Registriert seit
    03.06.2004
    Beiträge
    3.282
    Beitragswertungen
    239 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. Mo. 22.04.2013 12:12 Uhr #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. Mo. 22.04.2013 12:32 Uhr #6
    User Pic
    Lord|Schirmer Administrator
    Registriert seit
    21.03.2007
    Beiträge
    7.629
    Beitragswertungen
    1192 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. Mo. 22.04.2013 12:33 Uhr #7
    User Pic
    Rock@wulf Hall Of Fame
    Registriert seit
    03.06.2004
    Beiträge
    3.282
    Beitragswertungen
    239 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. Mo. 22.04.2013 12:34 Uhr #8
    User Pic
    Lord|Schirmer Administrator
    Registriert seit
    21.03.2007
    Beiträge
    7.629
    Beitragswertungen
    1192 Beitragspunkte
    Jub mach ich lächeln
    rules :: doku :: faq :: linkus
    0 Mitglieder finden den Beitrag gut.
  9. Mo. 05.05.2014 07:43 Uhr #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. Mo. 26.05.2014 01:45 Uhr #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!
    Deutscher Angsthasen Clan :: Battlefield 4
    0 Mitglieder finden den Beitrag gut.
Geschlossen

Zurück zu Module und Modifikationen

Optionen: Bei einer Antwort zu diesem Thema eine eMail erhalten