ilch Forum » Ilch Clan 1.1 » Fehlersuche und Probleme » last.php

Geschlossen
  1. #1
    User Pic
    Dream Hunter Mitglied
    Registriert seit
    14.05.2006
    Beiträge
    270
    Beitragswertungen
    0 Beitragspunkte
    Hallo, ich habe ein Problem. Da wir ein Xbox 360 Clan sind spielen wir maximal im Clan War 10 Maps. Und da man im Ilch Admin Menü unter Last Wars nur 5 Maps eintragen kann und nur für 5 maps die punkte eintragen kann, entschließ ich mich dazu in dem Ordner /include/admin/templates die last.htm näher zu untersuchen.
    Ich wollte es so haben da sman max. 10 maps und punkte verteilung eintragen kann. ALso ich habe die last.htm so bearbeitet das man jetzt 10 Wars eintragen kann, aber jetzt kommt mein Problem:

    Jetzt steht bei jedem Texteingabe feld bei Gegner und Eigene:

    Gegner: {opp} (und zwischen p und } die zahl (6,7,8,9,10) für die jeweilige map. Eigene: {owp} und zwischen p und } die zahl (6,7,8,9,10) für die jeweilige map.

    Wie bekomme ich dieses {opp} und {owp} in den text eingabe feldern weg? Also ich kann ja immer dieses owp und opp wegmachen und dann die punkte eintragen aber wenn ich da sjedesmal machen muss wird es ja lässtig. Ich habe noch ein Problem, obwohl ich 10 Maps und Punkteverteilungen eintragen kann weird dann auf der Page nur 5 maps angezeigt. Ich brauche hilfe!

    Hier der code der last.htm:

    <table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/wars_last.png" /></td><td width="30"></td><td valign="bottom"><h1>Lastwars</h1></td></tr></table>
    
    <table cellpadding="0" cellspacing="0" border="0" width="100%">
    <tr>
    	<td width="60%" valign="top">
    		<form action="admin.php?wars-last" method="POST" name="form">
    		<input type="hidden" name="pkey" value="{pkey}" />
    		<input type="hidden" name="status" value="3" />
    		<table class="border" cellpadding="3" cellspacing="1" border="0">
    		{msg}
        <tr class="Cdark">
    			<td colspan="2"><b>Basis Informationen</b></td>
    		</tr><tr>
    			<td class="Cmite">Gegner Nation</td>
    			<td class="Cnorm"><select name="land">{land}</select></td>
    		</tr><tr>
    			<td class="Cmite">Gegner Name</td>
    			<td class="Cnorm"><input size="46" type="text" name="gegner" value="{gegner}"></td>
    		</tr><tr>
    			<td class="Cmite">Gegner Tag</td>
    			<td class="Cnorm"><input size="46" type="text" name="tag" value="{tag}"></td>
    		</tr><tr>
    			<td class="Cmite">Gegner Page</td>
    			<td class="Cnorm"><input size="40" type="text" name="page" value="{page}"> <a href="javascript:visitpage()">Visit</a></td>
    		</tr><tr class="Cdark">
    			<td colspan="2"><b>Ansprechpartner</b></td>
    		</tr><tr>
    			<td class="Cmite">Gegner Email</td>
    			<td class="Cnorm"><input size="47" type="text" name="email" value="{mail}"></td>
    		</tr><tr>
    			<td class="Cmite">Gegner ICQ</td>
    			<td class="Cnorm"><input size="47" type="text" name="icq" value="{icq}"></td>
    		</tr><tr class="Cdark">
    			<td colspan="2"><b>Matchinfo</b></td>
    		</tr><tr>
    			<td class="Cmite">Datum | Zeit</td>
    			<td class="Cnorm"><table cellpadding="0" cellspacing="0" border="0"><tr><td><input type="text" name="day" value="{day}" size="2"><b>.</b><input type="text" name="mon" value="{mon}" size="2"><b>.</b><input type="text" name="jahr" value="{jahr}" size="4">&nbsp;<b>-</b>&nbsp;<input type="text" name="stu" value="{stu}" size="2"><b>:</b><input type="text" name="min" value="{min}" size="2"><b>:</b><input type="text" name="sek" value="{sek}" size="2">&nbsp;&nbsp;</td><td><input type="checkbox" id="kalender"{kalck} value="yes" name="kalender" /></td><td><label for="kalender" style="cursor: pointer"><span class="smalfont">Kalender eintragen / &auml;ndern.</span></label></td></tr></table></td>
    		</tr><tr>
    			<td class="Cmite">Treffpunkt</td>
    			<td class="Cnorm"><input type="Text" name="wo" value="{wo}" size="46" ></td>
    		</tr><tr>
    			<td class="Cmite">Team</td>
    			<td class="Cnorm"><select name="tid">{tid}</select></td>
    		</tr><tr>
    			<td class="Cmite">XonX</td>
    			<td class="Cnorm"><select onchange="sichtbarA()" name="mod">{mod}<option value="neu">Neu:</option></select>&nbsp;<input type="text" name="newmod" /></td>
    		</tr><tr>
    			<td class="Cmite">Game</td>
    			<td class="Cnorm"><select onchange="sichtbarB()" name="game">{game}<option value="neu">Neu:</option></select>&nbsp;<input type="text" name="newgame" /></td>
    		</tr><tr>
    			<td class="Cmite">Matchtyp</td>
    			<td class="Cnorm"><select onchange="sichtbarC()" name="mtyp">{mtyp}<option value="neu">Neu:</option></select>&nbsp;<input type="text" name="newmtyp" /></td>
    		</tr><tr>
    			<td class="Cmite">Member</td>
    			<td class="Cnorm"><a href="javascript:manageMember()">Member die gespielt haben verwalten.</a></td>
    		</tr><tr>
    			<td class="Cmite">Ergebnis</td>
    			<td class="Cnorm"><select name="wlp">{wlp}</select></td>
    		</tr><tr>
    			<td class="Cmite"></td>
    			<td class="Cnorm">
    			<table cellpadding="0" cellspacing="0" border="0">
    			<tr>
    				<td>Map/Runde</td>
    				<td>Gegner&nbsp;&nbsp;</td>
    				<td>Eigene</td>
    			</tr><tr>
    				<td><input type="text" name="map[1]" value="{map1}" />&nbsp;&nbsp;</td>
    				<td><input type="text" size="3" onKeyUp="setOPPsum()" name="opp[1]" value="{opp1}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOWPsum()" name="owp[1]" value="{owp1}" /></td>
    				<td><a href="javascript:manageMap({pkey},1)">Bild</a></td>
    			</tr><tr>
    				<td><input type="text" name="map[2]" value="{map2}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOPPsum()" name="opp[2]" value="{opp2}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOWPsum()" name="owp[2]" value="{owp2}" /></td>
    				<td><a href="javascript:manageMap({pkey},2)">Bild</a></td>
    			</tr><tr>
    				<td><input type="text" name="map[3]" value="{map3}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOPPsum()" name="opp[3]" value="{opp3}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOWPsum()" name="owp[3]" value="{owp3}" /></td>
    				<td><a href="javascript:manageMap({pkey},3)">Bild</a></td>
    			</tr><tr>
    				<td><input type="text" name="map[4]" value="{map4}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOPPsum()" name="opp[4]" value="{opp4}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOWPsum()" name="owp[4]" value="{owp4}" /></td>
    				<td><a href="javascript:manageMap({pkey},4)">Bild</a></td>
    			</tr><tr>
    				<td><input type="text" name="map[5]" value="{map5}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOPPsum()" name="opp[5]" value="{opp5}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOWPsum()" name="owp[5]" value="{owp5}" /></td>
    				<td><a href="javascript:manageMap({pkey},5)">Bild</a></td>
                            </tr><tr>
    				<td><input type="text" name="map[6]" value="{map5}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOPPsum()" name="opp[6]" value="{opp6}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOWPsum()" name="owp[6]" value="{owp6}" /></td>
    				<td><a href="javascript:manageMap({pkey},6)">Bild</a></td>
                            </tr><tr>
    				<td><input type="text" name="map[7]" value="{map5}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOPPsum()" name="opp[7]" value="{opp7}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOWPsum()" name="owp[7]" value="{owp7}" /></td>
    				<td><a href="javascript:manageMap({pkey},7)">Bild</a></td>
                            </tr><tr>
    				<td><input type="text" name="map[8]" value="{map5}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOPPsum()" name="opp[8]" value="{opp8}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOWPsum()" name="owp[8]" value="{owp8}" /></td>
    				<td><a href="javascript:manageMap({pkey},8)">Bild</a></td>
                            </tr><tr>
    				<td><input type="text" name="map[9]" value="{map5}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOPPsum()" name="opp[9]" value="{opp9}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOWPsum()" name="owp[9]" value="{owp9}" /></td>
    				<td><a href="javascript:manageMap({pkey},9)">Bild</a></td>
                            </tr><tr>
    				<td><input type="text" name="map[10]" value="{map5}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOPPsum()" name="opp[10]" value="{opp10}" /></td>
    				<td><input type="text" size="3" onKeyUp="setOWPsum()" name="owp[10]" value="{owp10}" /></td>
    				<td><a href="javascript:manageMap({pkey},10)">Bild</a></td>
    			</tr><tr>
    				<td align="right">Summe:&nbsp;&nbsp;</td>
    				<td><input type="text" size="3" name="sumopp" value="{opp}" /></td>
    				<td><input type="text" size="3" name="sumowp" value="{owp}" /></td>
    			</tr>
    			</table>
    			</td>
    		</tr><tr>
    			<td class="Cmite">Nachricht</td>
    			<td class="Cnorm"><textarea cols="47" rows="2" name="txt">{txt}</textarea></td>
    		</tr><tr class="Cdark">
    			<td></td>
    			<td><input type="submit" value="Absenden" name="sub" /></td>
    		</tr>
    		</table>
    		</form>
    	</td>
    	<td width="40%" valign="top">
    		<table class="border" cellpadding="3" cellspacing="1" border="0">
    		<tr class="Chead">
    			<td colspan="3">&Uuml;bersicht</td>
    		</tr>
    {EXPLODE}
    		<tr class="{class}">
    			<td>{game} {gegner}</td>
    			<td align="center"><a href="javascript:del('{id}')"><img src="include/images/icons/del.gif" alt="{_lang_delete}" title="{_lang_delete}" /></a></td>
    			<td align="center"><a href="admin.php?wars-last&amp;pkey={id}"><img src="include/images/icons/edit.gif" alt="{_lang_change}" title="{_lang_change}" /></a></td>
    		</tr>
    {EXPLODE}
    		</table>
    {MPL}
    	</td>
    </tr>
    </table>
    
    <script language="JavaScript" type="text/javascript">
    <!--
      function del ( id1 ) {
        var x = confirm ( "do you really want to delete?" );
    		if ( x ) {
    		  document.location.href="admin.php?wars-last&delete="+id1;
    		}
    	}
      function manageMap ( wid, mid ) {
        if ( wid == 0 ) {
          alert ( 'Bitte den Lastwar erst speichern und dann hier das Bild einfuegen!...' );
        } else if (document.getElementsByName('opp['+mid+']')[0].value == '' || document.getElementsByName('owp['+mid+']')[0].value == '' || document.getElementsByName('map['+mid+']')[0].value == '') {
          alert ( 'Bitte erstmal den Namen und die Ergebnisse dieser Runde/Map eintragen!..' );
        } else {
          var Fenster = window.open ('admin.php?wars-last-upload=0&wid=' + wid + '&mid=' + mid, 'managemap', 'scrollbars=yes,height=150,width=325,left=300,top=50');
          Fenster.focus();
        }
      }
      function manageMember () {
        if ( document.form.pkey.value == 0 ) {
          alert ( 'Bitte den Lastwar erst speichern und dann hier die Member bearbeiten!...' );
        } else {
          var Fenster = window.open ('admin.php?wars-last-members&wid={pkey}', 'manageMember', 'scrollbars=yes,height=300,width=250,left=300,top=50');
          Fenster.focus();
        }
      }
      function setOPPsum () {
        var summe = 0;
        summe = summe + ( document.getElementsByName('opp[1]')[0].value * 1);
        summe = summe + ( document.getElementsByName('opp[2]')[0].value * 1);
        summe = summe + ( document.getElementsByName('opp[3]')[0].value * 1);
        summe = summe + ( document.getElementsByName('opp[4]')[0].value * 1);
        summe = summe + ( document.getElementsByName('opp[5]')[0].value * 1);
        summe = summe + ( document.getElementsByName('opp[6]')[0].value * 1);
        summe = summe + ( document.getElementsByName('opp[7]')[0].value * 1);
        summe = summe + ( document.getElementsByName('opp[8]')[0].value * 1);
        summe = summe + ( document.getElementsByName('opp[9]')[0].value * 1);
        summe = summe + ( document.getElementsByName('opp[10]')[0].value * 1);
        document.form.sumopp.value = summe;
      }
      function setOWPsum () {
        var summe = 0;
        summe = summe + ( document.getElementsByName('owp[1]')[0].value * 1);
        summe = summe + ( document.getElementsByName('owp[2]')[0].value * 1);
        summe = summe + ( document.getElementsByName('owp[3]')[0].value * 1);
        summe = summe + ( document.getElementsByName('owp[4]')[0].value * 1);
        summe = summe + ( document.getElementsByName('owp[5]')[0].value * 1);
        summe = summe + ( document.getElementsByName('owp[6]')[0].value * 1);
        summe = summe + ( document.getElementsByName('owp[7]')[0].value * 1);
        summe = summe + ( document.getElementsByName('owp[8]')[0].value * 1);
        summe = summe + ( document.getElementsByName('owp[9]')[0].value * 1);
        summe = summe + ( document.getElementsByName('owp[10]')[0].value * 1);
        document.form.sumowp.value = summe;
      }
    	function sichtbarA(){
    	  if(document.form.mod.value=="neu"){
    		  document.form.newmod.style.visibility="visible";
    		} else {
    		  document.form.newmod.style.visibility="hidden";
    		}
    	}
      function sichtbarB() {
    	  if(document.form.game.value=="neu"){
    		  document.form.newgame.style.visibility="visible";
    		} else {
    		  document.form.newgame.style.visibility="hidden";
    		}
      }
    	function sichtbarC() {
    	  if(document.form.mtyp.value=="neu"){
    		  document.form.newmtyp.style.visibility="visible";
    		} else {
    		  document.form.newmtyp.style.visibility="hidden";
    		}
      }
      function visitpage () {
        var page = document.form.page.value;
        var n = 'page';
        var o = '';
        var f = window.open (page, n, o);
        f.focus();
      }
    	sichtbarB();
    	sichtbarC();
    	sichtbarA();
    //-->
    </script>


    betroffene Homepage: externer Link


    Zuletzt modifiziert von Dream Hunter am 01.07.2006 - 09:51:47
    0 Mitglieder finden den Beitrag gut.
  2. #2
    User Pic
    SLJ Hall Of Fame
    Registriert seit
    18.05.2004
    Beiträge
    15.492
    Beitragswertungen
    3 Beitragspunkte
    Jetztmust du nur noch die passende php datei dazu erweitern! Und mit großer warscheinlichkeit auch noch was in der datenbank ändern.

    mfg
    SLJ
    externer Link
    Ilch 1.0.4 PHP 7.0 und PDO Fähig na klar lächeln
    0 Mitglieder finden den Beitrag gut.
  3. #3
    User Pic
    Dream Hunter Mitglied
    Registriert seit
    14.05.2006
    Beiträge
    270
    Beitragswertungen
    0 Beitragspunkte
    In welcher php denn? z.B da sist meine wars.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();
    
    	$ergWin = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE wlp = "1"');
    	$anzWin = db_result($ergWin,0);
    	$ergLos = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE wlp = "2"');
    	$anzLos = db_result($ergLos,0);
    	$ergPat = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE wlp = "3"');
    	$anzPat = db_result($ergPat,0);
    	$ergGes = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE status= "3"');
    	$anzGes = db_result($ergGes,0);
    	$tpl = new tpl ( 'wars.htm' );
    	$tpl->set_ar_out ( array('PAT' => $anzPat, 'WIN' => $anzWin, 'LOS' => $anzLos, 'GES' => $anzGes, 'TITLE'=> $allgAr['title'] ) , 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(datime,'%d.%m.%Y - %H:%i:%s') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id WHERE status = 2 AND a.datime >= '".$akttime."' 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 = '';
    	if ( $menu->get(1) == '' ) {
    		$teams = dblistee ( '', "SELECT id,name FROM prefix_groups ORDER BY name");
    		$game= dblistee ('', "SELECT DISTINCT `game`,`game` FROM prefix_wars ORDER BY `game`" );
    		$mtype= dblistee ( '', "SELECT DISTINCT `mtyp`,`mtyp` FROM prefix_wars ORDER BY `mtyp`" );
    		$tpl->set_ar_out ( array('tid' => $teams, 'game' => $game, 'typ' => $mtype ) , 3 );
    	} elseif ($menu->get(1) == 'last') {
    		$tpl->out(4);
    		$sqla='WHERE status = 3 ';
    		if(!empty($_POST['tid'])){
    			$sqla.= 'AND tid="'.$_POST['tid'].'" ';
    		}
    		if(!empty($_POST['wpl'])){
    			$sqla.= 'AND wlp="'.$_POST['wpl'].'" ';
    		}
    		if(!empty($_POST['spiel'])){
    			$sqla.= 'AND game="'.$_POST['spiel'].'" ';
    		}
    		if(!empty($_POST['typ'])){
    			$sqla.= 'AND mtyp="'.$_POST['typ'].'" ';
    		}
    		# seiten funktion
    		$limit = $allgAr['wars_last_limit'];  // Limit
    		$page = ( $menu->getA(2) == 'p' ? $menu->getE(2) : 1 );
    		$MPL = db_make_sites ($page , "WHERE status = 3" , $limit , "?wars-last" , 'wars' );
    		$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->out(6);
    		echo $MPL;
    	}
      $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();
    }
    ?>
    0 Mitglieder finden den Beitrag gut.
  4. #4
    User Pic
    Dream Hunter Mitglied
    Registriert seit
    14.05.2006
    Beiträge
    270
    Beitragswertungen
    0 Beitragspunkte
    Hier die richtige wars.php:

    ICH BRAUCHE HILFE!!!


    <?php
    #   Copyright by: Manuel
    #   Support: www.ilch.de
    
    
    defined ('main') or die ( 'no direct access' );
    defined ('admin') or die ( 'only admin access' );
    
    $um = $menu->get(1);
    
    # get Flag list
    # 1 akt flag
    function get_wlp_array () {
    	$ar = array (
    		1 => 'gewonnen',
    		2 => 'verloren',
    		3 => 'unentschieden'
    	);
    return ($ar);
    }
    
    function get_datime() {
    	$own = true;
    	$_POST['day'] = escape($_POST['day'],'integer');
    	$_POST['mon'] = escape($_POST['mon'],'integer');
    	$_POST['jahr'] = escape($_POST['jahr'],'integer');
    	$_POST['stu'] = escape($_POST['stu'],'integer');
    	$_POST['min'] = escape($_POST['min'],'integer');
    	$_POST['sek'] = escape($_POST['sek'],'integer');
    	if ( checkdate ($_POST['mon'], $_POST['day'] , $_POST['jahr']) == FALSE ) {
    		$own = false;
    	} elseif ( $_POST['stu'] > 24 OR $_POST['min'] > 60 OR $_POST['sek'] > 60 ) {
    		$own = false;
    	}
    	if ( $own ) {
    		return ( $_POST['jahr'].'-'.$_POST['mon'].'-'.$_POST['day'].' '.$_POST['stu'].':'.$_POST['min'].':'.$_POST['sek'] );
    	} else {
    		return ( date('Y-m-d H:i:s' ) );
    	}
    }
    
    switch ( $um ) {
    
      default :
      	$design = new design ( 'Admins Area', 'Admins Area', 2 );
    		$design->header();
        ?>
        Folgende Auswahlm&ouml;glichkeiten:
        <ul>
        <li><a href="admin.php?wars-last">Lastwars</a></li>
        <li><a href="admin.php?wars-next">Nextwars</a></li>
        </ul>
        <?php  
        $design->footer();
        break;
    	# last wars
    	case 'last' :
    		# image upload
    		if ( $menu->get(2) == 'upload' ) {
    			$tpl = new tpl ( 'wars/upload', 1 );
    			$msg = '';
    			# aktion
    			if ( isset ($_FILES['f']['name']) ) {
    				$tmp = explode('.',$_FILES['f']['name']);
    				if ( $tmp[1] == 'gif' OR $tmp[1] == 'png' OR $tmp[1] == 'jpg' OR $tmp[1] == 'jpeg')  {
    					$nname = $_POST['wid'].'_'.$_POST['mid'].'.'.$tmp[1];
    					if ( move_uploaded_file ( $_FILES['f']['tmp_name'], 'include/images/wars/'.$nname) ) {
    						$ar = array ( 'gif'=>'gif','png'=>'png','jpg'=>'jpg','jpeg'=>'jpeg' );
    						unset($ar[$tmp[1]]);
    						foreach($ar as $v) {
    							@unlink ( 'include/images/wars/'.$_POST['wid'].'_'.$_POST['mid'].'.'.$v );
    						}
    						$msg = 'Datei ('.$_FILES['f']['name'].' ) <font color="#00FF00">erfolgreich hochgeladen</font><br />';
    					} else {
    						$msg = 'Datei ( '.$_FILES['f']['name'].' ) <font color="#FF0000">nicht erfolgreich hochgeladen</font><br />';
    					}
    				} else {
    					$msg = 'Bitte nur Bilder mit der Endung: .gif, .png, .jpg oder .jpeg!';
    				}
    			}
    			if ( isset($_GET['d']) ) {
    				if ( @unlink ( $_GET['d'] ) ) {
    					$msg = 'Datei <font color="#00FF00">erfolgreich gel&ouml;scht</font><br />';
    				} else {
    					$msg = 'Datei <font color="#FF0000">konnte nicht gel&ouml;scht werden</font><br />';
    				}
    			}
    			# anzeigen
    			if ( !is_writeable ( 'include/images/wars' ) ) {
    				$msg = 'Bitte erst dem Ordner "images/wars" Schreibrechte (chmod 777) geben.';
    			}
    			$mid = $_REQUEST['mid'];
    			$wid = $_REQUEST['wid'];
    			$file = 'Noch kein Bild hochgeladen... ';
    			$ar = array ( 'gif','png','jpg','jpeg' );
    			foreach($ar as $v) {
    				if ( file_exists ( 'include/images/wars/'.$wid.'_'.$mid.'.'.$v ) ) {
    					$size=getimagesize('include/images/wars/'.$wid.'_'.$mid.'.'.$v);
    					$breite=$size[0];
    					$hoehe=$size[1];
    					$file  = '<a href="javascript:openImgWindow(\''.$v.'\','.$hoehe.','.$breite.')">include/images/wars/'.$wid.'_'.$mid.'.'.$v.'</a>';
    					$file .= '&nbsp; &nbsp; <a href="javascript:deleteMap(\''.$v.'\')"><img src="include/images/icons/del.gif" border="0" title="l&ouml;schen" /></a>';
    					break;
    				}
    			}
    		$tpl->set('wid' ,$wid);
    		$tpl->set('mid' ,$mid);
    		$tpl->set('file', $file );
    		$tpl->set('msg' ,$msg);
    		$tpl->out(0);
    		exit ();
    		}
    		# manag member for war...
    		if ( $menu->get(2) == 'members' ) {
    			$tpl = new tpl ( 'wars/last_member', 1 );
    			$msg = '';
    			# aktion
    			if (isset($_POST['add_uid']) AND !empty($_POST['add_uid'])) {
    				db_query("INSERT INTO prefix_warmember (wid,uid,aktion) VALUES (".$_REQUEST['wid'].",".$_POST['add_uid'].",1)");
    			}
    			if (isset($_GET['delete_uid']) AND !empty($_GET['delete_uid'])) {
    				db_query("DELETE FROM prefix_warmember WHERE wid = ".$_REQUEST['wid']." AND uid = ".$_GET['delete_uid']);
    			}
    			# anzeigen
    			$tpl->set('msg',$msg);
    			$tpl->set('wid',$_REQUEST['wid']);
    			$tpl->set('liste', dblistee ( 0, "SELECT prefix_user.id,name FROM prefix_user LEFT JOIN prefix_warmember ON prefix_warmember.uid = prefix_user.id AND prefix_warmember.wid = ".$_REQUEST['wid']." WHERE prefix_warmember.aktion is NULL AND recht <= -2 ORDER BY `name`" ) );
    			$tpl->out(0);
    			$class = '';
    			$erg = db_query("SELECT prefix_user.id, prefix_user.name FROM prefix_warmember LEFT JOIN prefix_user ON prefix_user.id = prefix_warmember.uid WHERE wid = ".$_REQUEST['wid']." ORDER BY prefix_user.name ASC");
    			while($r = db_fetch_assoc($erg)) {
    				$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
    				$r['class'] = $class;
    				$tpl->set_ar_out($r,1);
    			}
    			$tpl->out(2);
    			exit();
    		}
    		# last wars
    		$design = new design ( 'Admins Area', 'Admins Area', 2 );
    		$design->header();
    		$show = true;
    		$tpl = new tpl ( 'wars/last', 1);
    		if ( !empty ( $_GET['delete'] ) ) {
    			# aus kalender loeschen fals vorhanden
          db_query("DELETE FROM prefix_kalender WHERE text like '%more-".$_GET['delete']."]%'");
    			db_query("DELETE FROM prefix_wars WHERE id = '".$_GET['delete']."'");
    			$wid = $_GET['delete'];
    			$imgar = array ('gif','png','jpg','jpeg');
          for($i=1;$i<=5;$i++) {
    				db_query("DELETE FROM prefix_warmaps WHERE wid = ".$wid." AND mnr = ".$i);
            foreach ($imgar as $v) {
              if ( file_exists('include/images/wars/'.$wid.'_'.$i.'.'.$v) ) {
    					  unlink ('include/images/wars/'.$wid.'_'.$i.'.'.$v);
    				  }
            }
    			}
    			$msg = '<tr class="Cmite"><td colspan="2">Erfolgreich gel&ouml;scht</td></tr>';
    		}
    		if ( !empty($_POST['sub']) ) {
    			if ( !empty($_POST['newmod']) ) {
    				$_POST['mod'] = $_POST['newmod'];
    			}
    			if ( !empty($_POST['newgame']) ) {
    				$_POST['game'] = $_POST['newgame'];
    			}
    			if ( !empty($_POST['newmtyp']) ) {
    				$_POST['mtyp'] = $_POST['newmtyp'];
    			}
    			if ( empty($_POST['tid']) ) {
    				$_POST['tid'] = 0;
    			}
    
    			$_POST['gegner'] = escape($_POST['gegner'], 'string');
    			$_POST['page'] = get_homepage(escape($_POST['page'], 'string'));
    			$_POST['tid'] = escape($_POST['tid'], 'integer');
    			$_POST['mod'] = escape($_POST['mod'], 'string');
    			$_POST['game'] = escape($_POST['game'], 'string');
    			$_POST['mtyp'] = escape($_POST['mtyp'], 'string');
    			$_POST['land'] = escape($_POST['land'], 'string');
    			$_POST['txt'] = escape($_POST['txt'], 'string');
    			$_POST['tag'] = escape($_POST['tag'], 'string');
    			$_POST['email'] = escape($_POST['email'], 'string');
    			$_POST['icq'] = escape($_POST['icq'], 'string');
    			$_POST['wo'] = escape($_POST['wo'], 'string');
    
    			if ( empty ($_POST['pkey']) ) {
    				db_query("INSERT INTO prefix_wars (`datime`,`status`,wlp,`owp`,`opp`,gegner,tag,page,mail,icq,wo,tid,`mod`,game,mtyp,land,txt) VALUES ('".get_datime()."',3,'".$_POST['wlp']."','".$_POST['sumowp']."','".$_POST['sumopp']."','".$_POST['gegner']."','".$_POST['tag']."','".$_POST['page']."','".$_POST['email']."','".$_POST['icq']."','".$_POST['wo']."','".$_POST['tid']."','".$_POST['mod']."','".$_POST['game']."','".$_POST['mtyp']."','".$_POST['land']."','".$_POST['txt']."')");
    				$wid = db_last_id();
    				for($i=1;$i<=5;$i++) {
    					if ( $_POST['map'][$i] != '' AND $_POST['opp'][$i] != '' AND $_POST['owp'][$i] != '' ) {
    						db_query("INSERT INTO prefix_warmaps (wid,mnr,map,opp,owp) VALUES (".$wid.",".$i.",'".$_POST['map'][$i]."',".$_POST['opp'][$i].",".$_POST['owp'][$i].")");
    					}
    				}
            
            # in den kalender eintragen wenn gewuenscht
            if (isset($_POST['kalender']) AND $_POST['kalender'] == 'yes') {
              $timestamp = strtotime(get_datime());
              $page = str_replace('admin.php','index.php',$_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"]);
              db_query("INSERT INTO prefix_kalender (time, title, text, recht) VALUES (".$timestamp.",'Lastwar gegen ".$_POST['gegner']."', '".$_POST['mtyp']." ".$_POST['mod']." in ".$_POST['game']." gegen [url=".$_POST['page']."]".$_POST['gegner']."[/url]\n\n[url=http://".$page."?wars-more-".$wid."]details des Wars[/url]', 0)");
            }
    				$msg = '<tr class="Cmite"><td colspan="2">Erfolgreich eingetragen</td></tr>';
    			} else {
    				db_query("UPDATE prefix_wars SET datime = '".get_datime()."', status = 3,wlp = '".$_POST['wlp']."',owp = '".$_POST['sumowp']."',opp = '".$_POST['sumopp']."',gegner = '".$_POST['gegner']."',tag = '".$_POST['tag']."',page = '".$_POST['page']."',mail = '".$_POST['email']."',icq = '".$_POST['icq']."',wo = '".$_POST['wo']."',tid = '".$_POST['tid']."',`mod` = '".$_POST['mod']."',game = '".$_POST['game']."',mtyp = '".$_POST['mtyp']."',land = '".$_POST['land']."',txt = '".$_POST['txt']."' WHERE id = '".$_POST['pkey']."'");
    				$wid = $_POST['pkey'];
    				for($i=1;$i<=5;$i++) {
    					$a = db_count_query("SELECT COUNT(*) FROM prefix_warmaps WHERE mnr = ".$i." AND wid = ".$wid);
    					if ( $a == 0 AND $_POST['map'][$i] != '' AND $_POST['opp'][$i] != '' AND $_POST['owp'][$i] != '' ) {
                db_query("INSERT INTO prefix_warmaps (wid,mnr,map,opp,owp) VALUES (".$wid.",".$i.",'".$_POST['map'][$i]."',".$_POST['opp'][$i].",".$_POST['owp'][$i].")");
    					} elseif ( $a == 1 AND ( $_POST['map'][$i] == '' OR $_POST['opp'][$i] == '' AND $_POST['owp'][$i] == '') ) {
    						db_query("DELETE FROM prefix_warmaps WHERE wid = ".$wid." AND mnr = ".$i);
    						if ( file_exists('include/images/wars/'.$wid.'_'.$i.'.gif') ) { unlink ('include/images/wars/'.$wid.'_'.$i.'.gif'); }
    						if ( file_exists('include/images/wars/'.$wid.'_'.$i.'.png') ) { unlink ('include/images/wars/'.$wid.'_'.$i.'.png'); }
    						if ( file_exists('include/images/wars/'.$wid.'_'.$i.'.jpg') ) { unlink ('include/images/wars/'.$wid.'_'.$i.'.jpg'); }
    						if ( file_exists('include/images/wars/'.$wid.'_'.$i.'.jpeg') ) { unlink ('include/images/wars/'.$wid.'_'.$i.'.jpeg'); }
    					} elseif ( $a == 1 AND $_POST['map'][$i] != '' AND $_POST['opp'][$i] != '' AND $_POST['owp'][$i] != '' ) {
    						db_query("UPDATE prefix_warmaps SET map = '".$_POST['map'][$i]."', opp = ".$_POST['opp'][$i].", owp = ".$_POST['owp'][$i]." WHERE wid = ".$wid." AND mnr = ".$i);
    					}
    				}
            # in den kalender eintragen wenn gewuenscht
            if (isset($_POST['kalender']) AND $_POST['kalender'] == 'yes') {
              $timestamp = strtotime(get_datime());
              $page = str_replace('admin.php','index.php',$_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"]);
              if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_kalender WHERE text like '%more-".$wid."]%'"),0)) {
                db_query("UPDATE prefix_kalender SET time = ".$timestamp.", title = 'Lastwar gegen ".$_POST['gegner']."', text = '".$_POST['mtyp']." ".$_POST['mod']." in ".$_POST['game']." gegen [url=".$_POST['page']."]".$_POST['gegner']."[/url]\n\n[url=http://".$page."?wars-more-".$wid."]details des Wars[/url]' WHERE text like '%more-".$wid."]%'");
              } else {
                db_query("INSERT INTO prefix_kalender (time, title, text, recht) VALUES (".$timestamp.",'Lastwar gegen ".$_POST['gegner']."', '".$_POST['mtyp']." ".$_POST['mod']." in ".$_POST['game']." gegen [url=".$_POST['page']."]".$_POST['gegner']."[/url]\n\n[url=http://".$page."?wars-more-".$wid."]details des Wars[/url]', 0)");
              }
            }
    				$msg = '<tr class="Cmite"><td colspan="2">Erfolgreich ver&auml;ndert</td></tr>';
    			}
    		}
    		if ( !empty ($_GET['pkey']) ) {
    			$erg = db_query("SELECT DATE_FORMAT(datime,'%d.%m.%Y.%H.%i.%s') as datime, id,status,wlp,owp,opp,gegner,tag,page,mail,icq,tid,wo,`mod`,game,mtyp,land,txt FROM prefix_wars WHERE id = '".$_GET['pkey']."'");
    			$_ilch = db_fetch_assoc($erg);
    			$_ilch['pkey'] = $_GET['pkey'];
    			list($_ilch['day'],$_ilch['mon'],$_ilch['jahr'],$_ilch['stu'],$_ilch['min'],$_ilch['sek']) = explode('.',$_ilch['datime']);
          $_ilch['kalck'] = (db_result(db_query("SELECT COUNT(*) FROM prefix_kalender WHERE text like '%more-".$_GET['pkey']."]%'"),0,0) == 1 ? ' checked' : '');
    			$wid = $_GET['pkey'];
    			for($i=1;$i<=5;$i++) {
    				$erg =  db_query("SELECT map,opp,owp FROM prefix_warmaps WHERE mnr = ".$i." AND wid = ".$wid);
    				if ( db_num_rows($erg) == 0 ) {
    					$_ilch['map'.$i] = '';
    					$_ilch['opp'.$i] = '';
    					$_ilch['owp'.$i] = '';
    				} else {
    					$mpr = db_fetch_assoc($erg);
    					$_ilch['map'.$i] = $mpr['map'];
    					$_ilch['opp'.$i] = $mpr['opp'];
    					$_ilch['owp'.$i] = $mpr['owp'];
    				}
    			}
    		} else {
    			$_ilch = array ('tag'=>'','mail'=>'','icq'=>'','wo'=>'','pkey' => 0, 'wlp' => '', 'opp' => '', 'owp' => '', 'gegner' => '', 'page' => 'http://', 'mtyp' => '', 'tid' => 0, 'land' => '', 'txt' => '', 'mod' => '', 'game' => '', 'day' => date('d'), 'mon' => date('m'), 'jahr' => date('Y'), 'stu' => date('H'), 'min' => date('i'), 'sek' => date('s'), 'kalck' => '' );
    			for($i=1;$i<=5;$i++) {
    				$_ilch['map'.$i] = '';
    				$_ilch['opp'.$i] = '';
    				$_ilch['owp'.$i] = '';
    			}
    		}
    		$_ilch['msg'] = ( isset ($msg) ? $msg : '' );
    		$_ilch['tid'] = dblistee ( $_ilch['tid'], "SELECT id, name FROM prefix_groups ORDER BY name");
    		$_ilch['mod'] = dblistee ( $_ilch['mod'], "SELECT DISTINCT `mod`,`mod` FROM prefix_wars ORDER BY `mod`" );
    		$_ilch['game'] = dblistee ( $_ilch['game'], "SELECT DISTINCT `game`,`game` FROM prefix_wars ORDER BY `game`" );
    		$_ilch['mtyp'] = dblistee ( $_ilch['mtyp'], "SELECT DISTINCT `mtyp`,`mtyp` FROM prefix_wars ORDER BY `mtyp`" );
    		$_ilch['land'] = arlistee ( $_ilch['land'] , get_nationality_array() );
    		$_ilch['wlp'] = arlistee ( $_ilch['wlp'] , get_wlp_array() );
    		$tpl->set_ar_out($_ilch,0);
        $page = ( $menu->getA(2) == 'p' ? $menu->getE(2) : 1 );
    		$limit = 20; $class = '';
    		$MPL = db_make_sites ($page , 'WHERE status = 3' , $limit , '?wars-last' , 'wars' );
    		$anfang = ($page - 1) * $limit;
    		$abf = "SELECT id,gegner,game FROM prefix_wars WHERE status = 3 ORDER BY id DESC LIMIT ".$anfang.",".$limit;
    		$erg = db_query($abf);
    		while ($row = db_fetch_assoc($erg) ) {
    			$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite' );
    			$row['class'] = $class;
          $row['game'] = get_wargameimg($row['game']);
    			$tpl->set_ar ( $row );
    			$tpl->out(1);
    		}
    		$tpl->set ( 'MPL', $MPL );
    		$tpl->out(2);
    		$design->footer();
    	break;
    
    	# Next wars
    	case 'next' :
        
    		$design = new design ( 'Admins Area', 'Admins Area', 2 );
    		$design->header();
    		$show = true;
    		$tpl = new tpl ( 'wars/next', 1);
    		if ( !empty ( $_GET['delete'] ) ) {
    			# aus kalender loeschen fals vorhanden
          db_query("DELETE FROM prefix_kalender WHERE text like '%more-".$_GET['delete']."]%'");
          db_query("DELETE FROM prefix_wars WHERE id = '".$_GET['delete']."'");
    			$msg = '<tr class="Cmite"><td colspan="2">Erfolgreich gel&ouml;scht</td></tr>';
    		}
    		if ( !empty($_POST['sub']) ) {
    			if ( !empty($_POST['newmod']) ) {
    				$_POST['mod'] = $_POST['newmod'];
    			}
    			if ( !empty($_POST['newgame']) ) {
    				$_POST['game'] = $_POST['newgame'];
    			}
    			if ( !empty($_POST['newmtyp']) ) {
    				$_POST['mtyp'] = $_POST['newmtyp'];
    			}
    			if ( empty($_POST['tid']) ) {
    				$_POST['tid'] = 0;
    			}
    
    			$_POST['gegner'] = escape($_POST['gegner'], 'string');
    			$_POST['page'] = get_homepage(escape($_POST['page'], 'string'));
    			$_POST['tid'] = escape($_POST['tid'], 'integer');
    			$_POST['mod'] = escape($_POST['mod'], 'string');
    			$_POST['game'] = escape($_POST['game'], 'string');
    			$_POST['mtyp'] = escape($_POST['mtyp'], 'string');
    			$_POST['land'] = escape($_POST['land'], 'string');
    			$_POST['txt'] = escape($_POST['txt'], 'string');
    			$_POST['tag'] = escape($_POST['tag'], 'string');
    			$_POST['email'] = escape($_POST['email'], 'string');
    			$_POST['icq'] = escape($_POST['icq'], 'string');
    			$_POST['wo'] = escape($_POST['wo'], 'string');
    			if ( empty ($_POST['pkey']) ) {
    				db_query("INSERT INTO prefix_wars (datime,`status`,gegner,tag,page,mail,icq,wo,tid,`mod`,game,mtyp,land,txt) VALUES ('".get_datime()."',2,'".$_POST['gegner']."','".$_POST['tag']."','".$_POST['page']."','".$_POST['email']."','".$_POST['icq']."','".$_POST['wo']."','".$_POST['tid']."','".$_POST['mod']."','".$_POST['game']."','".$_POST['mtyp']."','".$_POST['land']."','".$_POST['txt']."')");
            $wid = db_last_id();
            # in den kalender eintragen wenn gewuenscht
            if (isset($_POST['kalender']) AND $_POST['kalender'] == 'yes') {
              $timestamp = strtotime(get_datime());
              $page = str_replace('admin.php','index.php',$_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"]);
              db_query("INSERT INTO prefix_kalender (time, title, text, recht) VALUES (".$timestamp.",'Nextwar gegen ".$_POST['gegner']."', '".$_POST['mtyp']." ".$_POST['mod']." in ".$_POST['game']." gegen [url=".$_POST['page']."]".$_POST['gegner']."[/url]\n\n[url=http://".$page."?wars-more-".$wid."]details des Wars[/url]', 0)");
            }
    				$msg = '<tr class="Cmite"><td colspan="2">Erfolgreich eingetrage</td></tr>';
    			} else {
    				db_query("UPDATE prefix_wars SET datime = '".get_datime()."', status = 2,gegner = '".$_POST['gegner']."',tag = '".$_POST['tag']."',page = '".$_POST['page']."',mail = '".$_POST['email']."',icq = '".$_POST['icq']."',wo = '".$_POST['wo']."',tid = '".$_POST['tid']."',`mod` = '".$_POST['mod']."',game = '".$_POST['game']."',mtyp = '".$_POST['mtyp']."',land = '".$_POST['land']."',txt = '".$_POST['txt']."' WHERE id = '".$_POST['pkey']."'");
            $wid = $_POST['pkey'];
            # in den kalender eintragen wenn gewuenscht
            if (isset($_POST['kalender']) AND $_POST['kalender'] == 'yes') {
              $timestamp = strtotime(get_datime());
              $page = str_replace('admin.php','index.php',$_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"]);
              if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_kalender WHERE text like '%more-".$wid."]%'"),0)) {
                db_query("UPDATE prefix_kalender SET time = ".$timestamp.", title = 'Nextwar gegen ".$_POST['gegner']."', text = '".$_POST['mtyp']." ".$_POST['mod']." in ".$_POST['game']." gegen [url=".$_POST['page']."]".$_POST['gegner']."[/url]\n\n[url=http://".$page."?wars-more-".$wid."]details des Wars[/url]' WHERE text like '%more-".$wid."]%'");
              } else {
                db_query("INSERT INTO prefix_kalender (time, title, text, recht) VALUES (".$timestamp.",'Nextwar gegen ".$_POST['gegner']."', '".$_POST['mtyp']." ".$_POST['mod']." in ".$_POST['game']." gegen [url=".$_POST['page']."]".$_POST['gegner']."[/url]\n\n[url=http://".$page."?wars-more-".$wid."]details des Wars[/url]', 0)");
              }
            }
            $msg = '<tr class="Cmite"><td colspan="2">Erfolgreich ver&auml;ndert</td></tr>';
    			}
    		}
    		if ( !empty ($_GET['pkey']) ) {
    			$erg = db_query("SELECT DATE_FORMAT(datime,'%d.%m.%Y.%H.%i.%s') as datime, id,status,gegner,tag,page,mail,icq,wo,tid,`mod`,game,mtyp,land,txt FROM prefix_wars WHERE id = '".$_GET['pkey']."'");
    			$_ilch = db_fetch_assoc($erg);
    			list($_ilch['day'],$_ilch['mon'],$_ilch['jahr'],$_ilch['stu'],$_ilch['min'],$_ilch['sek']) = explode('.',$_ilch['datime']);
          $_ilch['kalck'] = (db_result(db_query("SELECT COUNT(*) FROM prefix_kalender WHERE text like '%more-".$_GET['pkey']."]%'"),0,0) == 1 ? ' checked' : '');
    			$_ilch['pkey'] = $_GET['pkey'];
    		} else {
    			$_ilch = array ('tag'=>'','mail'=>'','icq'=>'','wo'=>'','pkey' => '', 'wlp' => '', 'erg1' => '', 'erg2' => '', 'gegner' => '', 'page' => 'http://', 'mtyp' => '', 'tid' => 0, 'land' => '', 'txt' => '', 'mod' => '', 'game' => '', 'day' => date('d'), 'mon' => date('m'), 'jahr' => date('Y'), 'stu' => date('H'), 'min' => date('i'), 'sek' => date('s'), 'kalck' => '' );
    		}
    		$_ilch['msg'] = ( isset ($msg) ? $msg : '' );
    		$_ilch['tid'] = dblistee ( $_ilch['tid'], "SELECT id, name FROM prefix_groups ORDER BY name");
    		$_ilch['mod'] = dblistee ( $_ilch['mod'], "SELECT DISTINCT `mod`,`mod` FROM prefix_wars ORDER BY `mod`" );
    		$_ilch['game'] = dblistee ( $_ilch['game'], "SELECT DISTINCT `game`,`game` FROM prefix_wars ORDER BY `game`" );
    		$_ilch['mtyp'] = dblistee ( $_ilch['mtyp'], "SELECT DISTINCT `mtyp`,`mtyp` FROM prefix_wars ORDER BY `mtyp`" );
    		$_ilch['land'] = arlistee ( $_ilch['land'] , get_nationality_array() );
    		$tpl->set_ar_out($_ilch,0);
    		
        $page = ( $menu->getA(2) == 'p' ? $menu->getE(2) : 1 );
        
        $class = '';
        if ($page == 1) {
        $abf = "SELECT id,gegner,game FROM prefix_wars WHERE status = 1 ORDER BY id DESC";
        $erg = db_query($abf);
        while ($r = db_fetch_assoc($erg)) {
          $class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite' );
          $r['class'] = $class;
          $r['game'] = get_wargameimg($r['game']);
          $tpl->set_ar ($r);
          $tpl->out(1);
        }
        }
        
    		$limit = 20; 
    		$MPL = db_make_sites ($page , 'WHERE status = 2' , $limit , '?wars-next' , 'wars' );
    		$anfang = ($page - 1) * $limit;
    		$abf = "SELECT id,gegner,game FROM prefix_wars WHERE status = 2 ORDER BY id DESC LIMIT ".$anfang.",".$limit;
    		$erg = db_query($abf);
    		while ($row = db_fetch_assoc($erg) ) {
    			$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite' );
    			$row['class'] = $class;
          $row['game'] = get_wargameimg($row['game']);
    			$tpl->set_ar ( $row );
    			$tpl->out(2);
    		}
    		$tpl->set ( 'MPL', $MPL );
    		$tpl->out(3);
    		$design->footer();
    	break;
      case 'info' :
    		$design = new design ( 'Admins Area', 'Admins Area', 2 );
    		$design->header();
        $erg = db_query("SELECT DATE_FORMAT(datime,'%d.%m.%Y.%H.%i.%s') as datime, id,status,gegner,tag,page,mail,icq,wo,tid,`mod`,game,mtyp,land,txt FROM prefix_wars WHERE id = '".$menu->get(2)."'");
    		$_ilch = db_fetch_assoc($erg);
    		list($_ilch['day'],$_ilch['mon'],$_ilch['jahr'],$_ilch['stu'],$_ilch['min'],$_ilch['sek']) = explode('.',$_ilch['datime']);
        $tpl = new tpl ('wars/info', 1);
        $tpl->set_ar_out($_ilch,0);
        $design->footer();
      break;
    }
    ?>
    0 Mitglieder finden den Beitrag gut.
  5. #5
    User Pic
    Dream Hunter Mitglied
    Registriert seit
    14.05.2006
    Beiträge
    270
    Beitragswertungen
    0 Beitragspunkte
    ICH BRAUCHE HILFE!
    0 Mitglieder finden den Beitrag gut.
  6. #6
    User Pic
    Tyrargo Mitglied
    Registriert seit
    30.01.2006
    Beiträge
    5.541
    Beitragswertungen
    7 Beitragspunkte
    kannst dich mal etwas gedulden? ist ja schlimm heut morgen... schau mal aufn tacho, ist grad mal halb 12!

    denk dran, gestern war viertelfinale und deutschland hat gewonnen! glaub nicht, daß die leute um 8 schon wieder am pc sitzen (ok, ich schon ^^) am samstag morgen, bei diesem wetter!
    0 Mitglieder finden den Beitrag gut.
  7. #7
    User Pic
    Chaax Mitglied
    Registriert seit
    20.11.2007
    Beiträge
    12
    Beitragswertungen
    0 Beitragspunkte
    Hi,

    ist das prob gelöst ???

    ich habe das selbe prob und möchte die tabelle von 5 auf 8 erweitern.

    was genau muss ich den alles ändern???

    wäre für hilfe dankbar.

    vg
    chaax
    0 Mitglieder finden den Beitrag gut.
Geschlossen

Zurück zu Fehlersuche und Probleme

Optionen: Bei einer Antwort zu diesem Thema eine eMail erhalten