Hallo Zusammen,
wer kann mir helfen, beim Abändern der NextWars Anmeldung. Mir ist folgendes aufgefallen, wenn sich Member anmelden, dann wird die Reihenfolge, in der sich die Member angemeldet haben, nicht eingehalten. D.h. Wenn sich einer am z.b 1.3 angemeldet hat und danach am 4.3. einer zugesagt hat, dann steht unter umständen der vom 4.3 vor dem 1.3. und das wäre ja nicht so fair, denn wer zuerst kommt, mahlt zuerst.
Nun hätte ich das gerne nach Datum/Uhrzeit sortiert und dann, wenn z.b. bei einem 5on5 War schon 5 zugesagte Member hat, dass dann eine separates Feld mit Ersatzspieler kommt, die anschließend noch zusagen....
Ich hoffe es versteht jeder mein Anliegen.
verwendete ilchClan Version: 1.1
betroffene Homepage: externer Link
Beitrag zur Merkliste hinzufügen
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
ilch Forum » Ilch Clan 1.1 » Allgemein » NextWars Anmeldung ändern!
| Geschlossen | ||
-
kleinere geänderte Module für Ilch auf unserer HP: externer Link
-
hat hier niemand sowas gebastelt für sich, der mir vielleicht den Code geben kann???kleinere geänderte Module für Ilch auf unserer HP: externer Link
-
Mi. 07.05.2008
23:24 Uhr
#3
- Registriert seit
- 21.03.2007
- Beiträge
- 7.634
- Beitragswertungen
Ich habe erst heute den Thread gelesen!
Hier meine Umsetzung!
In der Datenbank in ic1_warmember eine neue Tabelle erstellen: Feld: dat Typ: date Standart: 0000-00-00
in wars.php im content-Ordner
so ab Zeile 217 in das ändern:$kom = escape($_POST['kom'],'string'); $dat = date('Y.n.j'); db_query("INSERT INTO prefix_warmember (uid,wid,aktion,dat,kom) VALUES (".$_SESSION['authid'].",".$_GET['mehr'].",".$aktion.",'".$dat."','".$kom."')"); } else { $tpl->out(2); } } $class = ''; $erg1 = db_query("SELECT b.id as uid, b.name, a.aktion, a.kom, DATE_FORMAT(a.dat,'%d.%m.%Y') as datum FROM prefix_warmember a left join prefix_user b ON b.id = a.uid WHERE a.wid = ".$_GET['mehr']." ORDER BY a.dat ASC"); while ($row1 = db_fetch_assoc($erg1) ) { if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; } $aktionar = array ('<font style="color:#FF0000; font-weight:bold;">hat am '.$row1['datum'].' abgesagt</font>','<font style="font-weight:bold; color:#00FF00;">hat am '.$row1['datum'].' zugesagt</font>','<font style="font-weight:bold; color:#FFFF00;">ist seit '.$row1['datum'].' unsicher</font>'); $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öschen" /></a> '.$row1['name']; } $tpl->set_ar_out($row1,3); } } $tpl->out(4);
Funktioniert bei mir perfekt!
Falls es noch probleme geben sollte, nochmal melden,
dann poste ich die ganze Datei! -
ja poste mal bitte die komplette datei, denn jetzt bringt er mir gerade diesen Fehler:
Parse error: syntax error, unexpected '}' in /var/www/web20/html/include/contents/wars.php on line 236kleinere geänderte Module für Ilch auf unserer HP: externer Link -
Do. 08.05.2008
17:40 Uhr
#5
- Registriert seit
- 21.03.2007
- Beiträge
- 7.634
- Beitragswertungen
Die Fehlermeldung sagt, das ein unerwartetes } in Zeile 236 erschienen ist!
meine wars.php
<head> <meta http-equiv="Content-Language" content="de"> </head> <?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]; $map = '<a href="include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v.'" rel="lightbox">'.$row['map'].'</a>'; $bild = '<a href="include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v.'" rel="lightbox"><img src="include/images/maps/'.$row['map'].'.jpg" width="160" height="110" style="border: 1px solid #808080"></a>'; }else{ $map = $row['map']; $bild = '<img src="include/images/maps/'.$row['map'].'.jpg" width="160" height="110" style="border: 1px solid #808080">'; } break; } $list .= '<tr bgcolor="#333333">'; $list .= '<td align="center"><font color="#999999">'.$map.'</font></td>'; $list .= '<td align="center"><font color="#999999">'.$bild.'</font></td>'; $list .= '<td align="center"><font color="#999999">'.$row['opp'].'</font></td>'; $list .= '<td align="center"><font color="#999999">'.$row['owp'].'</font></td>'; $list .= '</tr>'; } return ($list); } function lastwars_get_memberlist ( $id ) { $l = ''; $erg = db_query("SELECT prefix_user.id,prefix_user.name,prefix_user.avatar FROM prefix_user LEFT JOIN prefix_warmember ON prefix_warmember.uid = prefix_user.id AND prefix_warmember.wid = ".$id." WHERE wid = ".$id." ORDER by recht, -regist"); while($r = db_fetch_assoc($erg)) { $name = file_exists($r['avatar']) ? '<img src="'.$r['avatar'].'" width="40" height="40" style="border: 1px solid #808080" alt="'.$r['name'].'" info="'.$r['name'].'" />' : '<img src="http://1204.pg-server.de/include/images/avatars/noavatar.jpg" width="40" height="40" style="border: 1px solid #808080" alt="'.$r['name'].'" info="'.$r['name'].'" />'; $l .= '<a href="index.php?user-details-'.$r['id'].'">'.$name.' '.$r['name'].'</a><br>'; } 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); $anzGes2 = $anzGes == 0 ? 0.01 : $anzGes/100; $proWin = round($anzWin/$anzGes2,2).'%'; $proLos = round($anzLos/$anzGes2,2).'%'; $proPat = round($anzPat/$anzGes2,2).'%'; $balWin = round($anzWin/$anzGes2/2,0); $balLos = round($anzLos/$anzGes2/2,0); $balPat = round($anzPat/$anzGes2/2,0); $tpl = new tpl ( 'wars.htm' ); $tpl->set_ar_out ( array('PAT' => $anzPat, 'WIN' => $anzWin, 'LOS' => $anzLos, 'GES' => $anzGes, 'TITLE'=> $allgAr['title'], 'PPAT' => $proPat, 'PWIN' => $proWin, 'PLOS' => $proLos, 'BPAT' => $balPat, 'BWIN' => $balWin, 'BLOS' => $balLos,) , 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<br><i>um %H:%i Uhr</i>') 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']).' '.$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($_REQUEST['tid'])){ $sqla.= 'AND tid="'.$_REQUEST['tid'].'" '; $searchstring.="&tid=".$_REQUEST['tid']; } if(!empty($_REQUEST['wpl'])){ $sqla.= 'AND wlp="'.$_REQUEST['wpl'].'" '; $searchstring.="&wpl=".$_REQUEST['wpl']; } if(!empty($_REQUEST['spiel'])){ $sqla.= 'AND game="'.$_REQUEST['spiel'].'" '; $searchstring.="&spiel=".$_REQUEST['spiel']; } if(!empty($_REQUEST['typ'])){ $sqla.= 'AND mtyp="'.$_REQUEST['typ'].'" '; $searchstring.="&typ=".$_REQUEST['typ']; } # seiten funktion $limit = $allgAr['wars_last_limit']; // Limit $page = ( $menu->getA(2) == 'p' ? $menu->getE(2) : 1 ); $MPL = db_make_sites ($page , $sqla , $limit , "?wars-last", 'wars'); $MPL=str_replace('">',$searchstring.'">',$MPL); $anfang = ($page - 1) * $limit; # seiten funktion $farbe1wlpar = array(1=>'C8E1B8',2=>'D8B9B9',3=>'FDFBB7'); $farbe2wlpar = array(1=>'00FF00',2=>'FF0000',3=>'FFFF00'); $erg = db_query("SELECT a.owp,a.opp,a.wlp,a.land,a.mtyp,a.game,a.id,a.gegner,a.page,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id ".$sqla." ORDER BY a.datime DESC, id DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_assoc($erg) ) { $row['erg'] = $row['opp'].':'.$row['owp']; $row['farbe'] = $farbe1wlpar[$row['wlp']]; $row['farbe2'] = $farbe2wlpar[$row['wlp']]; if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; } $row['page'] = get_homepage($row['page']); $row['bild'] = get_wargameimg($row['game']); $row['team'] = $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> » </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'] <= -2 ) { $row['mail']=$row['mail']; $row['icq']=$row['icq']; $row['wo']=$row['wo']; $row['txt']=$row['txt']; } else{ $row['icq']='locked'; $row['mail']='locked'; $row['wo']='locked'; $row['txt']='locked'; } $tpl->set_ar_out($row,0); if ( $_SESSION['authright'] <= -2 ) { # get benoetige member $bm = substr($row['mod'],0,3); $needed = ''; for($i=0;$i<strlen($bm);$i++) { if ( is_numeric($bm{$i}) ) { $needed .= $bm{$i}; } } $uid = $_SESSION['authid']; if ($menu->get(3) == 'delete') { $uid = $menu->get(4); } $ck = db_count_query("SELECT COUNT(wid) FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND uid = ".$uid); # eine zu bzw. absage loeschen if ( $menu->get(3) == 'delete' AND ((has_right(array($row['tid'])) === true AND $uid == $_SESSION['authid']) OR is_siteadmin('wars')) AND $ck == 1) { db_query("DELETE FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND uid = ".$uid ); $ck = 0; } $available = db_count_query("SELECT COUNT(uid) FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND aktion = 1"); $aout1 = array ( 'needed' => $needed, 'available' => $available, 'id' => $_GET['mehr'] ); $tpl->set_ar_out($aout1,1); if ( $ck == 0 AND has_right(array($row['tid'])) === true) { if ( isset ($_POST['sub']) ) { switch ($_POST['sub']) { case 'zusagen': $aktion = 1; break; case 'absagen': $aktion = 0; break; case 'vielleicht': $aktion = 2; break; } ; $kom = escape($_POST['kom'],'string'); $dat = date('Y.n.j'); db_query("INSERT INTO prefix_warmember (uid,wid,aktion,dat,kom) VALUES (".$_SESSION['authid'].",".$_GET['mehr'].",".$aktion.",'".$dat."','".$kom."')"); } else { $tpl->out(2); } } $class = ''; $erg1 = db_query("SELECT b.id as uid, b.name, a.aktion, a.kom, DATE_FORMAT(a.dat,'%d.%m.%Y') as datum FROM prefix_warmember a left join prefix_user b ON b.id = a.uid WHERE a.wid = ".$_GET['mehr']." ORDER BY a.dat ASC"); while ($row1 = db_fetch_assoc($erg1) ) { if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; } $aktionar = array ('<font style="color:#FF0000; font-weight:bold;">hat am '.$row1['datum'].' abgesagt</font>','<font style="font-weight:bold; color:#00FF00;">hat am '.$row1['datum'].' zugesagt</font>','<font style="font-weight:bold; color:#FFFF00;">ist seit '.$row1['datum'].' unsicher</font>'); $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öschen" /></a> '.$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=>'<font style="color:00FF00;">GEWONNEN</font>',2=>'<font style="color:FF0000;">VERLOREN</font>',3=>'<font style="color:FFFF00;">UNENTSCHIEDEN</font>'); $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> » </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&kommentar_fuer_last_wars_loeschen='.$r['id'].'"><img src="include/images/icons/del.gif" title="löschen" alt="löschen" border="0"></a>'; } $r['class'] = $class; $tpl->set_ar_out($r,2); } $tpl->out(3); } } $design->footer(); } ?>
Achtung hier sind aber einige Veränderung (wie Lightboxeinbindung, Farbausgaben, Design) getätigt worden, also wenn möglich nur den Ausschnitt kopieren, welchen ich im vorherigen Post geschrieben habe!
Auf jedem Fall zeigt es das Datum jeder Waranmeldung in der richtigen Sortierung an!
Zuletzt modifiziert von Lord|Schirmer am 08.05.2008 - 17:43:19 -
Hilfe, ich bin echt zu blöd. :'( Habe es jetzt schon an zwei verschiedenen Positionen probiert, auch da wo du es drin hast. Hier mal mein Code ohne der Ergänzung:
<?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']).' '.$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']).' '.$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> » </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öschen" /></a> '.$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> » </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&kommentar_fuer_last_wars_loeschen='.$r['id'].'"><img src="include/images/icons/del.gif" title="löschen" alt="löschen" border="0"></a>'; } $r['class'] = $class; $tpl->set_ar_out($r,2); } $tpl->out(3); } } $design->footer(); } ?>
wo muss ich deinen Code jetzt einfügen!?kleinere geänderte Module für Ilch auf unserer HP: externer Link -
Do. 08.05.2008
18:24 Uhr
#7
- Registriert seit
- 21.03.2007
- Beiträge
- 7.634
- Beitragswertungen
Ich habe Dir deine wars.php mal angepasst!
Sollte funktionieren! Einfach ersetzen!
<?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']).' '.$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']).' '.$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="index.php?wars" class="smalfont">Wars</a><b> » </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'); $dat = date('Y.n.j'); db_query("INSERT INTO prefix_warmember (uid,wid,aktion,dat,kom) VALUES (".$_SESSION['authid'].",".$_GET['mehr'].",".$aktion.",'".$dat."','".$kom."')"); } else { $tpl->out(2); } } $class = ''; $erg1 = db_query("SELECT b.id as uid, b.name, a.aktion, a.kom, DATE_FORMAT(a.dat,'%d.%m.%Y') as datum FROM prefix_warmember a left join prefix_user b ON b.id = a.uid WHERE a.wid = ".$_GET['mehr']." ORDER BY a.dat ASC"); while ($row1 = db_fetch_assoc($erg1) ) { if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; } $aktionar = array ('<font style="color:#FF0000; background:#666666; font-weight:bold;">hat am '.$row1['datum'].' abgesagt</font>','<font style="font-weight:bold; color:#00FF00; background:#666666;">hat am '.$row1['datum'].' zugesagt</font>'); $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öschen" /></a> '.$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="index.php?wars" class="smalfont">Wars</a><b> » </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&kommentar_fuer_last_wars_loeschen='.$r['id'].'"><img src="include/images/icons/del.gif" title="löschen" alt="löschen" border="0"></a>'; } $r['class'] = $class; $tpl->set_ar_out($r,2); } $tpl->out(3); } } $design->footer(); } ?> -
vielen DANK erst mal, werde es gleich beim nächsten War testenkleinere geänderte Module für Ilch auf unserer HP: externer Link
| Geschlossen | ||
 |
Zurück zu Allgemein | |
Optionen: Bei einer Antwort zu diesem Thema eine eMail erhalten