• Forum
• Ilch Clan 1.1
• Fehlersuche und Probleme
• Advancedwars 1.2 [2 Probleme]

ilch Forum » Ilch Clan 1.1 » Fehlersuche und Probleme » Advancedwars 1.2 [2 Probleme]

1. Fr. 04.01.2013 12:40 Uhr #1

   

   DerLange_313 Mitglied

   Registriert seit

   25.03.2012

   Beiträge

   37

   Beitragswertungen

   

   Problem 1:
   Wenn noch keiner bei den Nextwar zugesagt hat zereisst er das Design, siehe
   
   Bild externer Link
   
   laut der Changelog wurde es gefixt und laut Versionskontrolle habe ich da die Version 1.2. Sobald der erste User zu- / absagt schiebt er das Design wieder zusammen. Ich weiss auch nicht in welcher Datei er das ablegt, müsste ja eigentlich die wars_next.htm sein.
   
   
   Problem 2:
   Gegner Logo Größe
   Da es immer wieder Leute gibt die es nicht schaffen ein Bild zu verkleinern, habe ich einmal selbst hand angelegt und die Bildgröße vom Gegner auf 150px x 150px in der Nextwars und Lastwars und Topmatchbox festgesetzt.
   Nun stehe ich vor dem Problem das wenn man die NEWS bei Nextwars editiert / übernimmt er die original Größe von dem Gegnerlogo anzeigt, ist ja auch nicht schlimm da es ein BBCode ist.
   Besteht dort auch die Möglichkeit es via HTML festzusetzen?
   
   
   Datei include/admin/wars.php
   
   

   <?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_teamlist ($tid) {
   			$abf = "SELECT * FROM prefix_groups";
   			$erg = db_query($abf);
   			$ar = array();
   			while($row = db_fetch_assoc($erg)) {
   			if($row['id'] == $tid) {
   				$selected = "selected";
   			}
   				$ar[$row[id]] = $row['name'];
   			}
   			
    return $ar;
   }
   
   function get_opponents ($oid) {
   			$abf = "SELECT * FROM prefix_opponents";
   			$erg = db_query($abf);
   			$ar = array();
   			while($row = db_fetch_assoc($erg)) {
   			if($row['oid'] == $oid) {
   				$selected = "selected";
   			}
   				$ar[$row[oid]] = ''.$row['name'].' ('.$row['tag'].')';
   			}
   			
    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) ) {
   					  @chmod('include/images/wars/'.$nname, 0777);
   						$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
   			$_GET['delete'] = escape($_GET['delete'],'integer');
         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>';
   		}
   		
   		
   		#TOPMATCH
   		if( !empty ( $_GET['topmatch'] ) ) {
   			$_GET['topmatch'] = escape($_GET['topmatch'],'integer');
         $row = db_fetch_assoc(db_query("SELECT topmatch FROM prefix_wars WHERE id = $_GET[topmatch]"));
         
         if($row['topmatch'] == 1) {
           db_query("UPDATE prefix_wars Set topmatch = 0 WHERE id = ".$_GET['topmatch']."");
           $msg = '<tr class="Cmite"><td colspan="2">Topmatch entfernt.</td></tr>';
         } else {
           db_query("UPDATE prefix_wars Set topmatch = 0 WHERE topmatch = 1");
           db_query("UPDATE prefix_wars Set topmatch = 1 WHERE id = ".$_GET['topmatch']."");
           $msg = '<tr class="Cmite"><td colspan="2">Topmatch gesetzt.</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['oid'] = escape($_POST['oid'], 'integer');
   			$_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['txt'] = escape($_POST['txt'], 'string');
   			$_POST['wo'] = escape($_POST['wo'], 'string');
   			$_POST['lineupopp'] = escape($_POST['lineupopp'], 'string');
   			$_POST['lineupowp'] = escape($_POST['lineupowp'], 'string');
   			$_POST['pw'] = escape($_POST['pw'], 'string');
   			$_POST['oppstate'] = escape($_POST['oppstate'], 'string');
   			$_POST['owpstate'] = escape($_POST['owpstate'], 'string');
   			$_POST['maps'] = escape($_POST['maps'], 'string');
   			$_POST['tv'] = escape($_POST['tv'], 'string');
   				
   			if ( empty ($_POST['pkey']) ) {
   				db_query("INSERT INTO prefix_wars (`datime`,`status`,wlp,`owp`,`opp`,oid,wo,tid,`mod`,game,mtyp,txt,mlink,lineupopp,lineupowp,oppstate,owpstate,maps,tv,pw) VALUES ('".get_datime()."',3,'".$_POST['wlp']."','".$_POST['sumowp']."','".$_POST['sumopp']."','".$_POST['oid']."','".$_POST['wo']."','".$_POST['tid']."','".$_POST['mod']."','".$_POST['game']."','".$_POST['mtyp']."','".$_POST['txt']."','".$_POST['mlink']."','".$_POST['lineupopp']."','".$_POST['lineupowp']."','".$_POST['oppstate']."','".$_POST['owpstate']."','".$_POST['maps']."','".$_POST['tv']."','".$_POST['pw']."')");
   				$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 ".get_opponent_details('name', $_POST['oid'])."', '".$_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']."',oid = '".$_POST['oid']."',wo = '".$_POST['wo']."',tid = '".$_POST['tid']."',`mod` = '".$_POST['mod']."',game = '".$_POST['game']."',mtyp = '".$_POST['mtyp']."',txt = '".$_POST['txt']."',mlink = '".$_POST['mlink']."', lineupopp = '".$_POST['lineupopp']."', lineupowp = '".$_POST['lineupowp']."', oppstate = '".$_POST['oppstate']."', owpstate = '".$_POST['owpstate']."', maps = '".$_POST['maps']."', tv = '".$_POST['tv']."', pw = '".$_POST['pw']."' WHERE id = '".$_POST['pkey']."'");
   				$wid = $_POST['pkey'];
   				for($i=1;$i<=7;$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);
   					}
   				}
   		if($_POST['news'] == 0) {
   			
   			$gegner = get_opponent_details("name", $_POST['oid']);
   			$glogo = get_opponent_details("logo", $_POST['oid']);
   			$team = get_team_details ('name', $_POST['tid']);
   			$_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');
   			
   			$warstamp = mktime($_POST['stu'],$_POST['min'],$_POST['sek'],$_POST['mon'],$_POST['day'],$_POST['jahr']);
   			$wardate = date("d.m.Y", $warstamp);
   			$wardate .= ' um ';
   			$wardate .= date("H:i", $warstamp);
   			$wardate .= ' Uhr';
   			
   			if(empty($_POST['oppstate'])) {
   				$_POST['oppstate'] == 'Kein Statement abgegeben';
   			}
   			if(empty($_POST['owpstate'])) {
   				$_POST['owpstate'] == 'Kein Statement abgegeben';
   			}
   			if(empty($_POST['lineupopp'])) {
   				$_POST['lineupopp'] == 'tba';
   			}
   			if(empty($_POST['lineupowp'])) {
   				$_POST['lineupowp'] == 'tba';
   			}
   			$text = '';
   			$text .= '[size=15][b][center]'.$team.'   vs.   '.$gegner.'      [/center]  [/b]     [/size]';
   			$text .= '\n \n';
   			$text .= '[center][img]include/images/teams/'.$_POST['tid'].'.png[/img]           [size=14][b]VS[/b][/size]           [img]'.$glogo.'[/img][/center]
   [center][url='.$_POST['mlink'].']Matchlink[/url][/center]
   [center][color=#00FF00][size=18]'.$_POST['sumowp'].'[/size][/color] - [color=#FF0000][size=18]'.$_POST['sumopp'].'[/size][/color][/center]';
   			$text .= '\n \n';
   			$text .='[b]Datum[/b] :   '.$wardate;
   			$text .= '\n';
   			$text .='[b]Map[/b] :   '.$_POST['maps'];
   			$text .= '\n \n';
   
   			
   			$date = date("Y-m-d H-i-s", time());
   			
   				$getid = "SELECT * FROM prefix_wars ORDER BY id DESC LIMIT 1";
   				$getid2= db_query($getid);
   				$r=db_fetch_assoc($getid2);
   				
   			
   			
   			if(!empty($_POST['pkey'])) {
   			$exists = db_result(db_query("SELECT COUNT(news_id) FROM prefix_news WHERE war = $_POST[pkey]"),0);
   				if($exists == 1) {
   					$write = "UPDATE prefix_news Set news_title = '$team vs. $gegner', news_text = '$text' WHERE war = $_POST[pkey]";
   					$wirteerg = db_query($write);
   				} else {
   					$write = "INSERT INTO prefix_news (news_title,user_id,news_time,news_recht,news_kat,news_text,war) VALUES ('".$team." vs. ".$gegner."', 0, '".$date."', 0, 'Wars', '".$text."', '".$_POST['pkey']."')";
   					$writeerg = db_query($write);
   				}
   			} else {
   				$write = "INSERT INTO prefix_news (news_title,user_id,news_time,news_recht,news_kat,news_text,war) VALUES ('".$team." vs. ".$gegner."', 0, '".$date."', 0, 'Wars', '".$text."', '".$r['id']."')";
   				$writeerg = db_query($write);
   			}
   		}
           # 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 ".get_opponent_details('name',$_POST['oid'])."', 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 ".get_opponent_details('name',$_POST['oid'])."', '".$_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,oid,tid,wo,`mod`,game,mtyp,txt,mlink,lineupopp,lineupowp,oppstate,owpstate,maps,tv,pw FROM prefix_wars WHERE id = '".$_GET['pkey']."'");
   			
   			$_ilch = db_fetch_assoc($erg);
   			
   			if(empty($_ilch['logo'])) {
   				$_ilch['logo'] = "include/images/logos/";
   			}
   			$_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<=7;$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 ('wo'=>'','pkey' => 0, 'wlp' => '', 'opp' => '', 'owp' => '', 'oid' => '', 'mtyp' => '', 'tid' => 0, 'txt' => '', 'mod' => '', 'game' => '', 'day' => date('d'), 'mon' => date('m'), 'jahr' => date('Y'), 'stu' => date('H'), 'min' => date('i'), 'sek' => date('s'), 'kalck' => '', 'mlink' => 'http://', 'lineupopp' => '', 'lineupowp' => '', 'oppstate' => '', 'owpstate' => '', 'maps' => '', 'tv' => '', 'pw' => '' );
   			for($i=1;$i<=7;$i++) {
   				$_ilch['map'.$i] = '';
   				$_ilch['opp'.$i] = '';
   				$_ilch['owp'.$i] = '';
   			}
   		}
   		$_ilch['msg'] = ( isset ($msg) ? $msg : '' );
   		$_ilch['oid'] = arlistee ( $_ilch['oid'] , get_opponents($_ilch['oid']) );
   		$_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,oid,game,owp,opp,tid,topmatch 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']);
   	  $row['gegner'] = get_opponent_details('name', $row['oid']);
   	  $row['land2'] = get_opponent_details('land', $row['oid']);
   	  if($row['topmatch'] == 1) {
         $row['topmatchstatus'] = '<img src="include/images/icons/jep.gif" alt="JA" />';
       } else {
         $row['topmatchstatus'] = '<img src="include/images/icons/nop.gif" alt="NEIN" />';
       }
   	  if($row['opp'] > $row['owp']) {
   		$color = "red";
   	  } elseif($row['opp'] < $row['owp']) 
   	  {
   		$color = "green";
   	  } else {
   		$color = "orange";
   	}
   	  $row['erg'] = '<span style="color: '.$color.'">'.$row['owp'].':'.$row['opp'].'</span>';
   	  $row['team'] = get_team_details('name', $row['tid']);
   			$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'] ) ) {
   		$_GET['delete'] = escape($_GET['delete'],'integer');
   			# 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>';
   		}
   		
   		#TOPMATCH
   		if( !empty ( $_GET['topmatch'] ) ) {
   			$_GET['topmatch'] = escape($_GET['topmatch'],'integer');
         $row = db_fetch_assoc(db_query("SELECT topmatch FROM prefix_wars WHERE id = $_GET[topmatch]"));
         
         if($row['topmatch'] == 1) {
           db_query("UPDATE prefix_wars Set topmatch = 0 WHERE id = ".$_GET['topmatch']."");
           $msg = '<tr class="Cmite"><td colspan="2">Topmatch entfernt.</td></tr>';
         } else {
           db_query("UPDATE prefix_wars Set topmatch = 0 WHERE topmatch = 1");
           db_query("UPDATE prefix_wars Set topmatch = 1 WHERE id = ".$_GET['topmatch']."");
           $msg = '<tr class="Cmite"><td colspan="2">Topmatch gesetzt.</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['oid'] = escape($_POST['oid'], 'integer');
   			$_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['txt'] = escape($_POST['txt'], 'string');
   			$_POST['mlink'] = get_homepage(escape($_POST['mlink'], 'string'));
   			$_POST['wo'] = escape($_POST['wo'], 'string');
   			$_POST['lineupopp'] = escape($_POST['lineupopp'], 'string');
   			$_POST['lineupowp'] = escape($_POST['lineupowp'], 'string');
   			$_POST['oppstate'] = escape($_POST['oppstate'], 'string');
   			$_POST['owpstate'] = escape($_POST['owpstate'], 'string');
   			$_POST['maps'] = escape($_POST['maps'], 'string');
   			$_POST['tv'] = escape($_POST['tv'], 'string');
   			$_POST['pw'] = escape($_POST['pw'], 'string');
   		
   				
   				
   			if ( empty ($_POST['pkey']) ) {
   				db_query("INSERT INTO prefix_wars (datime,`status`,oid,wo,tid,`mod`,game,mtyp,txt,mlink,lineupopp,lineupowp,oppstate,owpstate,maps,tv,pw) VALUES ('".get_datime()."',2,'".$_POST['oid']."','".$_POST['wo']."','".$_POST['tid']."','".$_POST['mod']."','".$_POST['game']."','".$_POST['mtyp']."','".$_POST['txt']."','".$_POST['mlink']."','".$_POST['lineupopp']."','".$_POST['lineupowp']."','".$_POST['oppstate']."','".$_POST['owpstate']."','".$_POST['maps']."','".$_POST['tv']."','".$_POST['pw']."')");
           $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 ".get_opponent_details('name',$_POST['oid'])."', '".$_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 = 2,oid = '".$_POST['oid']."',wo = '".$_POST['wo']."',tid = '".$_POST['tid']."',`mod` = '".$_POST['mod']."',game = '".$_POST['game']."',mtyp = '".$_POST['mtyp']."',txt = '".$_POST['txt']."', mlink = '".$_POST['mlink']."', lineupopp = '".$_POST['lineupopp']."', lineupowp = '".$_POST['lineupowp']."', oppstate = '".$_POST['oppstate']."', owpstate = '".$_POST['owpstate']."', maps = '".$_POST['maps']."', tv = '".$_POST['tv']."', pw = '".$_POST['pw']."' 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 ".get_opponent_details('name',$_POST['oid'])."', 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($_POST['news'] == 0) {
   			
   			$gegner = get_opponent_details("name", $_POST['oid']);
   			$glogo = get_opponent_details("logo", $_POST['oid']);
   			$tlogo = get_team_details('logo', $_POST['tid']);
   			$team = get_team_details ('name', $_POST['tid']);
   			$_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');
   			
   			$warstamp = mktime($_POST['stu'],$_POST['min'],$_POST['sek'],$_POST['mon'],$_POST['day'],$_POST['jahr']);
   			$wardate = date("d.m.Y", $warstamp);
   			$wardate .= ' um ';
   			$wardate .= date("H:i", $warstamp);
   			$wardate .= ' Uhr';
   			
   			if(empty($_POST['oppstate'])) {
   				$_POST['oppstate'] == 'Kein Statement abgegeben';
   			}
   			if(empty($_POST['owpstate'])) {
   				$_POST['owpstate'] == 'Kein Statement abgegeben';
   			}
   			if(empty($_POST['lineupopp'])) {
   				$_POST['lineupopp'] == 'tba';
   			}
   			if(empty($_POST['lineupowp'])) {
   				$_POST['lineupowp'] == 'tba';
   			}
   			
   			$text = '';
   			$text .= '[size=15][b][center]'.$team.'   vs.   '.$gegner.'      [/center]  [/b]     [/size]';
   			$text .= '\n \n';
   			$text .= '[center][img]'.$tlogo.'[/img]           [size=14][b]VS[/b][/size]           [img]'.$glogo.'[/img][/center]
   			';
   			$text .= '\n \n';
   			$text .='[b]Matchbeginn[/b] :   '.$wardate;
   			$text .= '\n';
   			$text .='[b]Maps[/b] :   '.$_POST['wo'];
   			$text .= '\n';
   			$text .='[b]Server [/b] :   '.$_POST['pw'];
   			$text .= '\n';
   			$text .='[b]Regeln / Sondervereinbarungen [/b] :   '.$_POST['txt'];			
   			$text .= '\n \n';
   						
   			$date = date("Y-m-d H-i-s", time());
   			
   				$getid = "SELECT * FROM prefix_wars ORDER BY id DESC LIMIT 1";
   				$getid2= db_query($getid);
   				$r=db_fetch_assoc($getid2);
   				
   			
   			if(!empty($_POST['pkey'])) {
   			$exists = db_result(db_query("SELECT COUNT(news_id) FROM prefix_news WHERE war = $_POST[pkey]"),0);
   				if($exists == 1) {
   					$write = "UPDATE prefix_news Set news_title = '$team vs. $gegner', news_text = '$text' WHERE war = $_POST[pkey]";
   					$wirteerg = db_query($write);
   				} else {
   					$write = "INSERT INTO prefix_news (news_title,user_id,news_time,news_recht,news_kat,news_text,war) VALUES ('".$team." vs. ".$gegner."', 0, '".$date."', 0, 'Wars', '".$text."', '".$_POST['pkey']."')";
   					$writeerg = db_query($write);
   				}
   			} else {
   				$write = "INSERT INTO prefix_news (news_title,user_id,news_time,news_recht,news_kat,news_text,war) VALUES ('".$team." vs. ".$gegner."', 0, '".$date."', 0, 'Wars', '".$text."', '".$r['id']."')";
   				$writeerg = db_query($write);
   			}
   
   		}
   		}
   		if ( !empty ($_GET['pkey']) ) {
   			$erg = db_query("SELECT DATE_FORMAT(datime,'%d.%m.%Y.%H.%i.%s') as datime, id,status,oid,wo,tid,`mod`,game,mtyp,txt,mlink,lineupopp,lineupowp,oppstate,owpstate,maps,tv,pw 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 ('wo'=>'','pkey' => '', 'wlp' => '', 'erg1' => '', 'erg2' => '', 'oid' => '', 'lineupopp' => '', 'lineupowp' => '', 'oppstate' => '', 'owpstate' => '', 'maps' => '', 'tv' => '', 'mtyp' => '', 'tid' => 0, 'txt' => '','pw' => '', 'mlink' => 'http://', '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['oid'] = arlistee ( $_ilch['oid'] , get_opponents($_ilch['oid']) );
   		$_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 * 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']);
   	  $r['gegner'] = get_opponent_details('name', $r['oid']);
   	  $r['land2'] = get_opponent_details('land', $r['oid']);
   		$r['team'] = get_team_details('name', $r['tid']);
   		if($r['topmatch'] == 1) {
         $r['topmatchstatus'] = '<img src="include/images/icons/jep.gif" alt="JA" />';
       } else {
         $r['topmatchstatus'] = '<img src="include/images/icons/nop.gif" alt="NEIN" />';
       }
       
         $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,oid,game,tid,topmatch 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']);
   	  $row['land2'] = get_opponent_details('land', $row['oid']);
   	  $row['gegner'] = get_opponent_details('name', $row['oid']);
   	  $row['land2'] = get_opponent_details('land', $row['oid']);
   	  $row['team'] = get_team_details('name', $row['tid']);
   	  if($row['topmatch'] == 1) {
         $row['topmatchstatus'] = '<img src="include/images/icons/jep.gif" alt="JA" />';
       } else {
         $row['topmatchstatus'] = '<img src="include/images/icons/nop.gif" alt="NEIN" />';
       }
   			$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,oid,wo,tid,`mod`,game,mtyp,txt FROM prefix_wars WHERE id = '".$menu->get(2)."'");
   		$_ilch = db_fetch_assoc($erg);
   		if(!empty($_ilch['oid'])) {
   			$_ilch['land'] = get_opponent_details('land', $_ilch['oid']);
   			$_ilch['gegner'] = get_opponent_details('name', $_ilch['oid']);
   			$_ilch['tag'] = get_opponent_details('tag', $_ilch['oid']);
   			$_ilch['page'] = get_opponent_details('homepage', $_ilch['oid']);
   			$_ilch['kname'] = get_opponent_details('kontaktname', $_ilch['oid']);
   			$_ilch['mail'] = get_opponent_details('email', $_ilch['oid']);
   			$_ilch['icq'] = get_opponent_details('icq', $_ilch['oid']);
   		}
   		$_ilch['tid'] = get_teamname($_ilch['tid']);
   		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;
     case 'check' :
   		$design = new design ( 'Admins Area', 'Admins Area', 2 );
   		$design->header();
   		$tpl = new tpl ('wars/check', 1);
   		
   		$tpl->set_out('VERSION', 1.2, 0);
   		$design->footer();
     break;
     case 'teams' :
     	$design = new design ( 'Admins Area', 'Admins Area', 2 );
   		$design->header();
   		$tpl = new tpl ('wars/teams', 1);
   		
   		$_ilch['tid'] = arlistee ( $_ilch['tid'] , get_teamlist($_ilch['tid']) );
   		$tpl->set_ar_out($_ilch,0);
   		
   		if(isset($_POST['uplogo'])) {
   			$id = $_POST['id'];
   				$avatar_sql_update = '';
         if ( !empty ( $_FILES['avatarfile']['name'] ) ) {
   				$file_tmpe = $_FILES['avatarfile']['tmp_name'];
           $rile_type = ic_mime_type ($_FILES['avatarfile']['tmp_name']);
   				$file_type = $_FILES['avatarfile']['type'];
   				$file_size = $_FILES['avatarfile']['size'];
           $fmsg = $lang['avatarisnopicture'];
           $size  = @getimagesize ($file_tmpe);
           $endar = array (1 => 'gif', 2 => 'jpg', 3 => 'png');
   				if ( ($size[2] == 1 OR $size[2] == 2 OR $size[2] == 3) AND $size[0] > 10 AND $size[1] > 10 AND substr ( $file_type , 0 , 6 ) == 'image/' AND substr ( $rile_type , 0 , 6 ) == 'image/' ) {
   				  $endung = $endar[$size[2]];
             $breite = $size[0];
             $hoehe  = $size[1];
             $fmsg = $lang['avatarcannotupload'];
   				  if ( $breite = 100 AND $hoehe = 100 ) {
   					  $neuer_name = 'include/images/teams/'.$id.'.'.$endung;
   						@unlink (db_result(db_query("SELECT logo FROM prefix_groups WHERE id = ".$id),0));
               move_uploaded_file ( $file_tmpe , $neuer_name );
               @chmod($neuer_name, 0777);
               $avatar_sql_update = "logo = '".$neuer_name."'";
               $fmsg = $lang['pictureuploaded'];
   					}
   				}
   			$abf = "UPDATE prefix_groups Set $avatar_sql_update WHERE id = $id";
   			$erg = db_query($abf);
   			echo $lang['pictureuploaded'];
   			}
   			
   		}
   		
   			if($menu->get(2) == "edit") {
   				$tid = escape($_POST['tid'], "integer");
   					$abf = "SELECT * FROM prefix_groups WHERE id = $tid";
   					$erg = db_query($abf);
   					
   					$row = db_fetch_assoc($erg);
   					
   					$tpl->set_ar_out($row,1);
   			}
   		$design->footer();
     break;
     case 'opponent' :
   		$design = new design ( 'Admins Area', 'Admins Area', 2 );
   		$design->header();
   
   		$tpl = new tpl ( 'wars/opponent', 1);
   			$oid = escape($menu->get(3), "integer");
   		$tpl->set_out("","",0);
   
   		if($menu->get(2) == "") {
   		$ar['land'] = '<option></option>'.arliste ( '' , get_nationality_array() , $tpl , 'land' );
   
   		$tpl->set_ar_out($ar,1);
   		}
   		if($menu->get(2) == "edit") {
   			
   
   			$abf = "SELECT * FROM prefix_opponents WHERE oid = $oid";
   			$erg = db_query($abf);
   			
   			$row = db_fetch_assoc($erg);
   			
   			$row['land'] = '<option></option>'.arliste ( $row['land'] , get_nationality_array() , $tpl , 'land' );
   			if(!empty($row['logo'])) {
   			$row['logo2'] = '<img src="'.$row['logo'].'" />';
   			} else {
   			$row['logo2'] = '';
   			}
   			$tpl->set_ar_out($row, 2);
   			
   		}
   		if($menu->get(2) == "save") {
   			if(isset($_POST['new'])) {
   				$abf = "INSERT INTO prefix_opponents (name, tag, homepage, land, kontaktname,kontaktemail,kontakticq) VALUES ('$_POST[name]', '$_POST[tag]', '$_POST[hp]', '$_POST[land]', '$_POST[kontaktname]', '$_POST[kontaktemail]','$_POST[kontakticq]')";
   				$erg = db_query($abf);
   				$id = db_last_id();
   				
   				$avatar_sql_update = '';
   		      if ( !empty ( $_FILES['avatarfile']['name'] ) ) {
   						$file_tmpe = $_FILES['avatarfile']['tmp_name'];
   		        $rile_type = ic_mime_type ($_FILES['avatarfile']['tmp_name']);
   						$file_type = $_FILES['avatarfile']['type'];
   						$file_size = $_FILES['avatarfile']['size'];
   		        $fmsg = $lang['avatarisnopicture'];
   		        $size  = @getimagesize ($file_tmpe);
   		        $endar = array (1 => 'gif', 2 => 'jpg', 3 => 'png');
   						if ( ($size[2] == 1 OR $size[2] == 2 OR $size[2] == 3) AND $size[0] > 10 AND $size[1] > 10 AND substr ( $file_type , 0 , 6 ) == 'image/' AND substr ( $rile_type , 0 , 6 ) == 'image/' ) {
   						  $endung = $endar[$size[2]];
   		          $breite = $size[0];
   		          $hoehe  = $size[1];
   		          $fmsg = $lang['avatarcannotupload'];
   						  if ( $breite = 100 AND $hoehe = 100 ) {
   							  $neuer_name = 'include/images/clanlogos/'.$id.'.'.$endung;
   								@unlink (db_result(db_query("SELECT logo FROM prefix_opponents WHERE oid = ".$id),0));
   		            move_uploaded_file ( $file_tmpe , $neuer_name );
   		            @chmod($neuer_name, 0777);
   		            $avatar_sql_update = "logo = '".$neuer_name."'";
   		            $fmsg = $lang['pictureuploaded'];
   							}
   						}
   					$abf = "UPDATE prefix_opponents Set $avatar_sql_update WHERE oid = $id";
   					$erg = db_query($abf);
   					}
   			  
   			  
   						  
   				echo 'Erfolgreich eingetragen';
   			}
   			if(isset($_POST['edit'])) {
   			  
   			  $avatar_sql_update = '';
   		      if ( !empty ( $_FILES['avatarfile']['name'] ) ) {
   						$file_tmpe = $_FILES['avatarfile']['tmp_name'];
   		        $rile_type = ic_mime_type ($_FILES['avatarfile']['tmp_name']);
   						$file_type = $_FILES['avatarfile']['type'];
   						$file_size = $_FILES['avatarfile']['size'];
   		        $fmsg = $lang['avatarisnopicture'];
   		        $size  = @getimagesize ($file_tmpe);
   		        $endar = array (1 => 'gif', 2 => 'jpg', 3 => 'png');
   						if ( ($size[2] == 1 OR $size[2] == 2 OR $size[2] == 3) AND $size[0] > 10 AND $size[1] > 10 AND substr ( $file_type , 0 , 6 ) == 'image/' AND substr ( $rile_type , 0 , 6 ) == 'image/' ) {
   						  $endung = $endar[$size[2]];
   		          $breite = $size[0];
   		          $hoehe  = $size[1];
   		          $fmsg = $lang['avatarcannotupload'];
   						  if ( $breite = 100 AND $hoehe = 100 ) {
   							  $neuer_name = 'include/images/clanlogos/'.$oid.'.'.$endung;
   								@unlink (db_result(db_query("SELECT logo FROM prefix_opponents WHERE oid = ".$oid),0));
   		            move_uploaded_file ( $file_tmpe , $neuer_name );
   		            @chmod($neuer_name, 0777);
   		            $avatar_sql_update = "logo = '".$neuer_name."',";
   		            $fmsg = $lang['pictureuploaded'];
   							}
   						}
   					} elseif ( isset($_POST['avatarloeschen']) ) {
   		        $fmsg = $lang['picturedelete'];
   		        @unlink (db_result(db_query("SELECT logo FROM prefix_opponents WHERE oid = ".$oid),0));
   		        $avatar_sql_update = "logo = '',";
   		      }
   			  
   			  
   				$abf = "UPDATE prefix_opponents Set name = '$_POST[name]', tag = '$_POST[tag]', homepage = '$_POST[hp]', land = '$_POST[land]', kontaktname = '$_POST[kontaktname]', $avatar_sql_update kontaktemail = '$_POST[kontaktemail]', kontakticq = '$_POST[kontakticq]' WHERE oid = $oid";
   				$erg = db_query($abf);
   				
   		    		
   				
   
   				echo 'Erfolgreich editiert';
   			}
   		}
   		$tpl->set_out("","",3);
   
   		$select = "SELECT * FROM prefix_opponents ORDER BY name";
   		$query = db_query($select);
   
   			while($r = db_fetch_assoc($query)) {
   				
   				
   			$tpl->set_ar_out($r, 4);
   			}
   		$tpl->set_out("","",5);
   		if($menu->get(2) == "del") {
   			 @unlink (db_result(db_query("SELECT logo FROM prefix_opponents WHERE oid = ".$menu->get(3)),0));
   			 db_query('DELETE FROM `prefix_opponents` WHERE oid = "'.$menu->get(3).'" LIMIT 1');
   		}
   		
   		$design->footer();
     break;
     case 'fightus' : 
   		$design = new design ( 'Admins Area', 'Admins Area', 2 );
   		$design->header();
   
   		$tpl = new tpl ( 'wars/fightus', 1);
   		
   		$tpl->out(0);
   		if(is_numeric($menu->get(2))) {
   			
   			$id = escape($menu->get(2), "integer");
   			$abf = "SELECT * FROM prefix_fightus WHERE id = $id";
   			$erg = db_query($abf);
   			
   			$row = db_fetch_assoc($erg);
   		
   			$row['team'] = get_team_details('name', $row['tid']);
   			if(isset($_POST['createop'])) {
   				$result = db_result(db_query("SELECT count(oid) FROM prefix_opponents WHERE name = '$row[oname]'"),0);
   				if($result == 0) {
   					db_query("INSERT INTO prefix_opponents (name, tag, homepage, land, kontaktname, kontaktemail, kontakticq) VALUES ('".$row['oname']."','".$row['otag']."','".$row['opage']."','".$row['oland']."','".$row['okontaktperson']."','".$row['oemail']."','".$row['oicq']."')");
   					$lastoid = db_last_id();
   				} else {
   					$abf = "SELECT oid FROM prefix_opponents WHERE name = '$row[oname]' LIMIT 1";
   					$erg = db_query($abf);
   					$r = db_fetch_assoc($erg);
   					$lastoid = $r['oid'];
   				}
   				
   				db_query("INSERT INTO prefix_wars (datime,`status`,oid,wo,tid,`mod`,game,mtyp,txt,mlink,lineupopp,lineupowp,oppstate,owpstate,maps,tv,pw) VALUES ('".$row['datum']."',2,'".$lastoid."','".$row['server']."','".$row['tid']."','".$_row['xonx']."','".$row['spiel']."','".$row['matchtyp']."','".$row['nachricht']."','','','','','','','','')");
   				
   				db_query("DELETE FROM prefix_fightus WHERE id = $row[id]");
   			
   				wd("admin.php?wars-fightus", "Nextwar erfolgreich eingetragen");
   			} else {
   				$tpl->set_ar_out($row,3);
   			}
   			
   			
   			
   		} else {
   			$abf = "SELECT id,oname,otag,opage,oland,okontaktperson,oemail,oicq,server,DATE_FORMAT(datum,'%d.%m.%Y - %H:%i:%s') as time,tid,xonx,spiel,matchtyp,nachricht FROM prefix_fightus";
   			$erg = db_query($abf);
   			
   			while($row = db_fetch_assoc($erg)) {
   				
   			$row['tid'] = get_team_details('name',$row['tid']);
   				$tpl->set_ar_out($row,1);
   				
   			}
   			$tpl->out(2);
   		}
   		
   		
   		$design->footer();
     break;
     }
   ?>

   
   
   betroffene Homepage: externer Link

   externer Link / externer Link / externer Link
   0 Mitglieder finden den Beitrag gut.

   • zitieren
2. Fr. 04.01.2013 14:03 Uhr #2

   

   dastiii Mitglied

   Registriert seit

   27.12.2005

   Beiträge

   2.354

   Beitragswertungen

   

   Problem 1:
   
   

   <table width="100%" cellpadding="1" cellspacing="1" border="0">
   	<tr>
   		<td width="100%" class="Chead" align="left"><strong>&raquo; Matchübersicht</strong></td>
   	</tr>
   	<tr>
   		<td width="100%" class="Cmite" valign="top">
   			<table width="100%" cellpadding="1" cellspacing="1" border="0">
   				<tr>
   					<td width="100%" colspan="3" class="Cmite">&nbsp;</td>
   				</tr>
   				<tr>
   					<td width="35%" class="Cnorm" align="center" style="font-size: 12px; font-weight: bold;">
   						&nbsp; <img src="{teamlogo}" style="border:1px solid #000000;" /><br />{team}
   					</td>
   					<td width="30%" class="Cmite" style="font-size: 20px;" align="center"><strong>[{owp} : {opp}]</strong><br />{mlink}</td>
   					<td width="35%" class="Cnorm" align="center" style="font-size: 12px; font-weight: bold;">
   						&nbsp; <img src="{logo}" style="border:1px solid #000000;" /><br /> <img src="include/images/flags/{land}" alt="" /> <a href="?clans-{oid}" target="_blank">{gegner}</a>
   				</tr>
   				<tr>
   					<td>&nbsp;</td>
   				</tr>	
   				<tr>
   					<td width="100%" align="center" colspan="3"></td>
   				</tr>
   			</table>
   			<table width="100%" cellpadding="1" cellspacing="1" border="0">
   				<tr>
   					<td colspan="3" align="left" class="Chead"><strong>&raquo; Matchdetails</strong></td>
   				</tr>
   				<tr>
   					<td width="100%" colspan="3" class="Cnorm" align="left">
   						<table width="100%" cellpadding="1" cellspacing="1" border="0">
   							<tr>
   								<td width="33%" class="Cmite">Datum:</td>
   								<td width="67%" class="Cnorm">{datum}</td>
   							</tr>
   							<tr>
   								<td width="33%" class="Cmite">Uhrzeit:</td>
   								<td width="67%" class="Cnorm">{zeit} {_lang_oclock}</td>
   							</tr>
   							<tr>
   								<td width="33%" class="Cmite">Spieltyp:</td>
   								<td width="67%" class="Cnorm">{mtyp} ({mod})</td>
   							</tr>
   							<tr>
   								<td width="33%" class="Cmite">Server:</td>
   								<td width="67%" class="Cnorm">{wo}</td>
   							</tr>
   							<tr>
   								<td width="33%" class="Cmite" style="margin-left:10px;">&raquo; Password:</td>
   								<td width="67%" class="Cnorm">{pw}</td>
   							</tr>
   							<tr>
   								<td width="33%" class="Cmite">TV-Server:</td>
   								<td width="67%" class="Cnorm">{tv}</td>
   							</tr>
   						</table>
   					</td>
   				</tr>
   			</table>
   		</td>
   	</tr>
   	<tr>
   		<td colspan="3" align="left" class="Chead"><strong>&raquo; Informationen</strong></td>
   	</tr>
   	<tr>
   		<td width="100%" colspan="3" class="Cnorm" align="left">{txt}</td>
   	</tr>
   	<tr>
   		<td colspan="3" align="left" class="Chead"><strong>&raquo; Zu-/Absagen</strong></td>
   	</tr>
   	{EXPLODE}
   	<tr class="Cdark">
   		<td>{_lang_present} / {_lang_away} &nbsp; - &nbsp; ( {_lang_promise}: {available} {_lang_from} {_lang_needed}: {needed} )</td>
   	</tr>
   	{EXPLODE}
   </table>
   <table width="100%" border="0" cellspacing="1" cellpadding="1" class="border">
   	<tr class="Cdark">
   		<td class="Cnorm">
   		<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>
   </table>
   <table width="100%" border="0" cellspacing="1" cellpadding="5" class="border">
   	{EXPLODE}
   	<tr class="{class}">
   		<td>{name} hat für dieses Match {aktion} <u>{_lang_comment}:</u> {kom}</td>
   	</tr>
   	{EXPLODE}
   </table>

   
   
   Den Inhalt deiner wars_next.html damit ersetzen.

   externer Link
   1 Mitglieder finden den Beitrag gut.

   • zitieren
3. Fr. 04.01.2013 16:19 Uhr #3

   

   DerLange_313 Mitglied

   Registriert seit

   25.03.2012

   Beiträge

   37

   Beitragswertungen

   

   Super, danke dir.......
   
   Ok, Problem 1 ist behoben !
   
   Wer kann mir bei Problem 2 noch helfen?

   externer Link / externer Link / externer Link
   0 Mitglieder finden den Beitrag gut.

   • zitieren
4. Sa. 05.01.2013 23:35 Uhr #4

   

   DerLange_313 Mitglied

   Registriert seit

   25.03.2012

   Beiträge

   37

   Beitragswertungen

   

   zu problem 2, also kann man da nichts machen? besteht denn die Möglichkeit über das BB Modul etwas zu machen bzw. einen zusatz dafür zu schreiben?

   externer Link / externer Link / externer Link
   0 Mitglieder finden den Beitrag gut.

   • zitieren
5. So. 06.01.2013 10:52 Uhr #5

   

   Mairu Coder

   Registriert seit

   16.06.2006

   Beiträge

   15.334

   Beitragswertungen

   

   Ok hier mal ne Anleitung, zuerst die includes/class/bbcode.php nach
   

           //> Darf BB Code [IMG] dekodiert werden?
           if($this->permitted['img'] == true) {
               //> Format: [img]xxx.de[/img]
               $this->pattern[] = "%\[img\]([-a-zA-Z0-9@:\%_\+,.~#?&//=]+?)\[\/img\]%eUi";
               $this->replace[] = "\$this->_img('\$1')";
         //> Format: [img=left|right]xxx.de[/img]
         $this->pattern[] = "%\[img=(left|right)\]([-a-zA-Z0-9@:\%_\+,.~#?&//=]+?)\[\/img\]%eUi";
             $this->replace[] = "\$this->_img('\$2','\$1')";
       }

   
   
   suchen und wie folgt ersetzen
   

           //> Darf BB Code [IMG] dekodiert werden?
           if ($this->permitted['img'] == true) {
               //> Format: [img]xxx.de[/img]
               $this->pattern[] = "%\[img\]([-a-zA-Z0-9@:\%_\+,.~#?&//=]+?)\[\/img\]%eUi";
               $this->replace[] = "\$this->_img('\$1')";
               //> Format: [img=left|right]xxx.de[/img]
               $this->pattern[] = "%\[img=([^\]]+)\]([-a-zA-Z0-9@:\%_\+,.~#?&//=]+?)\[\/img\]%eUi";
               $this->replace[] = "\$this->_img('\$2','\$1')";
           }

   
   
   weiter nach

       //> Bilder auf Verkleinern via Javascript überprüfen.
       function _img($string, $float='') {
           if ($float == 'none' OR $float == 'left' OR $float == 'right') {
             $float = 'style="float:'.$float.'; margin: 5px;" ';
           } else {
             $float = '';
           }
           $image = '<img src="'.$string.'" alt="" title="" border="0" class="bbcode_image" '.$float.'/>';
           return $image;
       }

   
   suchen und durch

       //> Bilder auf Verkleinern via Javascript überprüfen.
       function _img($string, $params = '') {
           $imgParams = array();
           $paramAr = explode(';', $params);
           $float = '';
           foreach ($paramAr as $param) {
               if (in_array($param, array('none', 'left', 'right'))) {
                   $imgParams[] = 'style="float:'.$float.'; margin: 5px;"';
               } elseif (preg_match('%^(\d+)(w|h)?$%', $param, $matches) === 1) {
                   if (!isset($matches[2])) {
                       $type = 'w';
                   } else {
                       $type = $matches[2];
                   }
                   $$type = $matches[1];
               }
           }
           if (isset($w)) {
               $imgParams[] = 'width="' . $w . '"';
           }
           if (isset($h)) {
               $imgParams[] = 'height="' . $h . '"';
           }
           $image = '<img src="'.$string.'" alt="" title="" border="0" class="bbcode_image" '
               . implode(' ', $imgParams) . '/>';
           return $image;
       }

   ersetzen.
   
   Dann kannst du bei Bilder im BBCode wie folgt die Größe anpassen.
   
   

   [img=120] <- Breite 120
   [img=120w;80h] <- Breite 120, Höhe 80
   [img=left;60h] <- Auch mit floating kombinierbar

   
   
   Bei Verwendung von Breite und Höhe muss man allerdings aufpassen, dass man das Seitenverhältnis nicht fälschlicherweise ändert.

   Und auch immer mal ein Blick auf die FAQ werfen. | Mairus Ilchseite
   1 Mitglieder finden den Beitrag gut.

   • zitieren
6. So. 06.01.2013 11:06 Uhr #6

   

   DerLange_313 Mitglied

   Registriert seit

   25.03.2012

   Beiträge

   37

   Beitragswertungen

   

   Wow, super Mairu.....vielen vielen Dank, das mit dem Seiten verhältnis habe ich ihm schon erklärt, da die anderen Boxen auch auf 150x150px festgesetzt sind, er soll Hauptsächliche Quadratische Logos hochladen.
   
   
   Ich will nicht nerven bzw. noch ein Thema eröffnen, aber wo legt er fest das er die Liste ansicht im Forum soweit Links erstellt.
   
   Screen: externer Link

   externer Link / externer Link / externer Link
   0 Mitglieder finden den Beitrag gut.

   • zitieren
7. So. 06.01.2013 15:05 Uhr #7

   

   Mairu Coder

   Registriert seit

   16.06.2006

   Beiträge

   15.334

   Beitragswertungen

   

   Mhh obwohl ich auf der Seite eigentlich keine reset.css eingebunden ist, denke ich trotzdem dass es über eine css Regel für ul wieder gehen sollte.
   
   Kannst ja mal versuchen in der style.css eine Regel
   

   ul { margin-left: 20px; }

   
   
   einzufügen, ggf. Strg + F5 um Browsercache zu leeren beim Neuladen der Seite benutzen.

   Und auch immer mal ein Blick auf die FAQ werfen. | Mairus Ilchseite
   1 Mitglieder finden den Beitrag gut.

   • zitieren
8. So. 06.01.2013 16:54 Uhr #8

   

   DerLange_313 Mitglied

   Registriert seit

   25.03.2012

   Beiträge

   37

   Beitragswertungen

   

   Ja es funktioniert mit dem angegebenen Code in css, ich hatte das problem auch schon bei den anderen zwei Seiten gehabt, aber das nie wirklich verfolgt woran der Fehler liegen könnte, da man diese Funktion seltener braucht.
   
   Denke das der Fehler dann in den Design von DD ist, aber egal.
   
   Ich dank dir nochmal für die Unterstützung....!

   externer Link / externer Link / externer Link
   0 Mitglieder finden den Beitrag gut.

   • zitieren
9. Mi. 16.01.2013 12:59 Uhr #9

   

   DerLange_313 Mitglied

   Registriert seit

   25.03.2012

   Beiträge

   37

   Beitragswertungen

   

   So, etwas merkwürdiges ist momentan bei der NEWS übernahme....
   
   ich habe den obigen Code in der wars.php eingesetzt, das ganze funktioniert bei mir auch, wenn zumindest ich (als Admin) die NEWS dafür schreibe.
   
   Wenn aber der Clanleader selber die NEWS schreibt ist der Code nicht vorhanden, dadurch das er ja andere rechte hat besteht da vielleicht der Fehler?
   
   
   EDIT:
   hab es gefunden, in der wars.php hat er noch einen Code für die NEWS, angepasst und zack da geht es dann auch.
   
   
   Zuletzt modifiziert von DerLange_313 am 16.01.2013 - 19:31:57

   externer Link / externer Link / externer Link
   0 Mitglieder finden den Beitrag gut.

   • zitieren
10. Mo. 21.01.2013 10:05 Uhr #10

    

    IRvD Mitglied

    Registriert seit

    30.03.2010

    Beiträge

    460

    Beitragswertungen

    

    Will mich auch einmal recht Herzlich bei Mairu für die Erweiterung des BBCodes bedanken
    1 Mitglieder finden den Beitrag gut.

    • zitieren
11. So. 10.03.2013 09:50 Uhr #11

    

    Lord|Schirmer Administrator

    Registriert seit

    21.03.2007

    Beiträge

    7.675

    Beitragswertungen

    

    Ich hätte noch eine kleine Anmerkung zum float, da ich es bei mir gerade eingebunden habe:
    
    

    $imgParams[] = 'style="float:'.$float.'; margin: 5px;"';

    
    zu
    

    $imgParams[] = 'style="float:'.$param.'; margin: 5px;"';

    rules :: doku :: faq :: linkus
    0 Mitglieder finden den Beitrag gut.

    • zitieren