ilch.de :: Forum :: Ilch Clan 1.1 :: Module und Modifikationen

habe ich versucht klappt zwar aber irgendwie bindet er mein komplette seite noch mal in die box ein da habe ich meine siete doppelt hier der code vileicht wir jemand anderes schlau
<?php
#   Copyright by: Manuel  
#   Support: www.ilch.de  




  
function lastfussball1_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'].' :: fussball1';
	$hmenu = 'fussball1';
	$design = new design ( $title , $hmenu );
	$design->header();

	$ergWin = db_query('SELECT COUNT(id) FROM `prefix_fussball1` WHERE wlp = "1"');
	$anzWin = db_result($ergWin,0);
	$ergLos = db_query('SELECT COUNT(id) FROM `prefix_fussball1` WHERE wlp = "2"');
	$anzLos = db_result($ergLos,0);
	$ergPat = db_query('SELECT COUNT(id) FROM `prefix_fussball1` WHERE wlp = "3"');
	$anzPat = db_result($ergPat,0);
	$ergGes = db_query('SELECT COUNT(id) FROM `prefix_fussball1` WHERE status= "3"');
	$anzGes = db_result($ergGes,0);
	$tpl = new tpl ( 'fussball1vs.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.land,a.gegner,a.page,a.game,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y - %H:%i:%s') as time FROM prefix_fussball1 a left join prefix_groups b ON a.tid = b.id WHERE status = 2 AND a.datime >= '".$akttime."' ORDER BY a.datime LIMIT 1");
	if ( db_num_rows ( $erg ) == 0 ) {
		echo '<tr class="Cmite"><td colspan="4"><strong>kein Spiel die Woche</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_fussball1 ORDER BY `game`" );
		$mtype= dblistee ( '', "SELECT DISTINCT `mtyp`,`mtyp` FROM prefix_fussball1 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 , "?fussball1-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_fussball1 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();
}
?>
<?php


defined ('main') or die ( 'no direct access' );


echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">';
$erg = db_query('SELECT * FROM prefix_fussball2 WHERE status = "3" ORDER BY datime DESC LIMIT 2');
while ($row = db_fetch_object($erg) ) {
	$row->tag = ( empty($row->tag) ? $row->gegner : $row->tag );

if (file_exists("include/images/icons/$row->game.gif")){
$game = '<img src="include/images/icons/'.$row->game.'.gif">&nbsp;';
}else{
$game = '';
}

  if ($row->wlp == 1) {
		$was = '<img src="include/images/icons/win.gif" border="0">';
	} elseif ($row->wlp == 2) {
		$was = '<img src="include/images/icons/los.gif" border="0">';	
	} elseif ($row->wlp == 3) {
		$was = '<img src="include/images/icons/pad.gif" border="0">';
	
	}
	echo'<tr><td align="left"">';
	echo''.$game.''.$was.'&nbsp;&nbsp;<a href="index.php?fussball2-more-'.$row->id.'">';
	echo $row->owp.':'.$row->opp.' - '.$row->tag.'</a></td></tr>';
}
echo '</table>';
?>
Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Module und Modifikationen » 2 boxen in ein box
