Lastwars -prozentzahl

Gehe zu Seite:

Geschlossen

Fr. 22.06.2007 21:55 Uhr #1

flaky12 Mitglied

Registriert seit
03.04.2007

Beiträge
424

Beitragswertungen

Hallo
Wie ist es möglich bei den lastwars eine prozentzahl unter verloren gewonnen und unentschieden zu machen? alsozu wie viel prozent gewonnen....
Hoffe ihr versteht was ich meine

verwendete ilchClan Version: 1.1

betroffene Homepage: externer Link
0 Mitglieder finden den Beitrag gut.
- zitieren
Fr. 22.06.2007 23:42 Uhr #2

Jan Hall Of Fame

Registriert seit
17.01.2007

Beiträge
3.646

Beitragswertungen

Ja möglich ist das.
Leider hab ich keine Ahung von php, sonst würde ich es dir gerne machen.:S
0 Mitglieder finden den Beitrag gut.
- zitieren

Sa. 23.06.2007 09:02 Uhr #3

Mairu Coder

So habs mal kurz gemacht, in der include/contents/wars.php unter (Ziele 50+)

$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);

Das einfügen

$anzGes2 = $anzGes == 0 ? 0.01 : $anzGes/100;
    $proWin = round($anzWin/$anzGes2,2).'%';
    $proLos = round($anzLos/$anzGes2,2).'%';
    $proPat = round($anzPat/$anzGes2,2).'%';
    $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 ) , 0 );

und dabei auch die beiden Zeilen mit $tpl am Anfang überschreiben.

Dann noch in der includes/templates/wars.htm am Anfang unter

<tr class="Cnorm">
    <td align="center"><font class="textalter">{GES}</font></td>
    <td align="center"><font color="#00FF00">{WIN}</font></td>
    <td align="center"><font color="#FF4242">{LOS}</font></td>
    <td align="center"><font color="#FFEE00">{PAT}</font></td>
</tr>

und über dem </table> noch das

<tr class="Cnorm">
    <td align="center">&nbsp;</td>
    <td align="center"><font color="#00FF00">{PWIN}</font></td>
    <td align="center"><font color="#FF4242">{PLOS}</font></td>
    <td align="center"><font color="#FFEE00">{PPAT}</font></td>
</tr>

einfügen.

Und auch immer mal ein Blick auf die FAQ werfen. | Mairus Ilchseite

0 Mitglieder finden den Beitrag gut.

zitieren

Sa. 23.06.2007 10:16 Uhr #4

flaky12 Mitglied

Registriert seit
03.04.2007

Beiträge
424

Beitragswertungen

Geht Perfekt.

Danke
0 Mitglieder finden den Beitrag gut.
- zitieren
Fr. 19.02.2010 00:53 Uhr #5

justinleebrain Mitglied

Registriert seit
17.07.2008

Beiträge
82

Beitragswertungen

Hi

ich wieder.
Hab das hier mal ausprobiert und es hat nciht ganz hingehauen!
Hatte zwar einen Balken mit den Zahlen siege untentschieden usw. aber der war 1.tens Grau,also ohne Farbe und 2tens hat er mein Design total gesprengt.Woran kanns liegen weiss das jemand?
Wäre schön.

Mfg Jason

externer Link
xfire:jasonvorheees
0 Mitglieder finden den Beitrag gut.
- zitieren
Fr. 19.02.2010 13:06 Uhr #6

Lord|Schirmer Administrator

Registriert seit
21.03.2007

Beiträge
7.680

Beitragswertungen

Da wirst Du was falsch eingesetzt haben!

Der Code von Mairu funktioniert und bezieht sich auf das Script!
Prüfe nochmal was und wie Du es eingefügt hast!

rules :: doku :: faq :: linkus
0 Mitglieder finden den Beitrag gut.
- zitieren
Fr. 19.02.2010 14:17 Uhr #7

justinleebrain Mitglied

Registriert seit
17.07.2008

Beiträge
82

Beitragswertungen

Ich kriegs nicht gebacken mit dem was mairu meint:auch die beiden Zeilen mit $tpl am Anfang überschreiben & mit dem: am Anfang unter Code. brauch bestimmt mehr schlaf um das mal richtig zu verstehen grins. Ich habs nun überall mal reingehauen aber nix seufz.

Zuletzt modifiziert von justinleebrain am 21.02.2010 - 13:21:53

externer Link
xfire:jasonvorheees
0 Mitglieder finden den Beitrag gut.
- zitieren
Fr. 19.02.2010 15:11 Uhr #8

Lord|Schirmer Administrator

Registriert seit
21.03.2007

Beiträge
7.680

Beitragswertungen

Lieber justinleebrain es gibt hier einen Tag für CODE, damit dieser korrekt dargestellt wird, bitte diesen nutzen!

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

So. 21.02.2010 13:21 Uhr #9

justinleebrain Mitglied

So Lord habs geändert.

bei mir wills einfach nicht klappen.
Bei dir auf der Hp ist die stats anzeige echt nice grins.
ich schnall einfach nicht an welche stellen ich es in der wars.php & der wars.htm reinschreiben soll das es funzt.Hatt noch nie so ein prob was einzufügen.Hab wohl ein bier zu viel getrunken und dabei ein paar gehirnzellen zuviel vernichtet.

das ist meine wars.htm

<table border="0" cellspacing="1" cellpadding="1" class="border">
<tr class="Chead">
    <td align="center" colspan="4" ><b>{TITLE}</b></td>
</tr><tr class="Cmite">
    <td align="center">{_lang_whole}</td>
    <td align="center">{_lang_win}</td>
    <td align="center">{_lang_los}</td>
    <td align="center">{_lang_pat}</td>
</tr><tr class="Cnorm">
    <td align="center"><font class="textalter">{GES}</font></td>
    <td align="center"><font color="#00FF00">{WIN}</font></td>
    <td align="center"><font color="#FF4242">{LOS}</font></td>
    <td align="center"><font color="#FFEE00">{PAT}</font></td>
</tr>
</table>
<br>
<br>
<table width="100%" border="0" cellspacing="1" cellpadding="2" class="border">
<tr class="Chead">
    <td colspan="4"><b>{_lang_nextwars}</b></td>
</tr>
<tr class="Cdark">
    <td width="30%"><b>{_lang_date}</b></td>
    <td width="30%"><b>{_lang_opponent}</b></td>
    <td width="30%"><b>{_lang_squad}</b></td>
    <td width="10%"><b>{_lang_more}</b></td>
</tr>
{EXPLODE}
<tr class="{class}">
    <td>{time}</td>
    <td><a href="{page}" target="_blank">{gegner}</a></td>
    <td>{team}</td>
    <td><a href="index.php?wars-more-{id}">{_lang_more}</a></td>
</tr>
{EXPLODE}
</table>
<br />
<br />
{EXPLODE}
<form action="?wars-last" method="POST">
<input type="hidden" name="che" value="1">
<table width="100%" border="0" cellspacing="1" cellpadding="2" class="border">
<tr class="Chead">
    <td colspan="3"><b>{_lang_lastwars}</b></td>
</tr>
<tr class="Cnorm">
    <td>Team:</td>
    <td colspan="2"><select name="tid"><option value="">----------</option> {tid}</select></td>
</tr>
<tr class="Cmite">
    <td>{_lang_result}:</td>
    <td colspan="2"><select name="wpl">
    <option value="">----------</option>
    <option value="1">{_lang_win}</option>
    <option value="2">{_lang_los}</option>
    <option value="3">{_lang_pat}</option>
    </select>
    </td>
</tr>
<tr class="Cnorm">
    <td>Game:</td>
    <td colspan="2"><select name="spiel"><option value="">----------</option> {game}</select></td>
</tr>
<tr class="Cmite">
    <td>Typ:</td>
    <td colspan="2"><select name="typ"><option value="">----------</option> {typ}</td>
</tr>
<tr class="Cnorm">
<td></td><td><input type="Submit" name="Go" value="Go"></td><td><a href="index.php?wars-last">Zeige alle {_lang_lastwars}</a></td>
</tr>
</table>
</form>
{EXPLODE}
<table width="100%" border="0" cellspacing="1" cellpadding="2" class="border">
<tr class="Chead">
    <td colspan="7"><b>{_lang_lastwars}</b></td>
</tr>
<tr class="Cdark">
    <td width="15%"><b>{_lang_date}</b></td>
    <td width="20%"><b>{_lang_opponent}</b></td>
    <td width="25%"><b>{_lang_squad}</b></td>
    <td width="15%"><b>{_lang_matchtype}</b></td>
    <td width="15%"><b>{_lang_result}</b></td>
    <td width="10%"><b>{_lang_more}</b></td>
</tr>
{EXPLODE}
<tr class="{class}">
    <td>{time}</td>
    <td><img src="include/images/flags/{land}" alt="" /> <a href="{page}" target="_blank">{gegner}</a></td>
    <td>{team}</td>
    <td>{mtyp}</td>
  <td><div style="border: solid #{farbe2} 1px; margin: 0px; background-color: #{farbe}; color:#000000">{erg}</div></td>
    <td><a href="index.php?wars-more-{id}">{_lang_more}</a></td>
</tr>
{EXPLODE}
</table>

und das die wars.php

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

<?php
#   Copyright by: Manuel Staechele
#   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];
                 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>';
 
 if (file_exists('include/images/maps/'.$row['map'].'.jpg') ) {
              $list .= '<td><a href="#" onClick="javascript:window.open(\'include/images/maps/'.$row['map'].'.jpg\',\'bild\',\'height=500 ,width=500\')"><img src="include/images/maps/'.$row['map'].'.jpg" width="100" height="80" border="0" alt="'.$row['map'].'" title="'.$row['map'].'" /></a></td>';
              } else {
              $list .= '<td><img src="include/images/maps/nopic.jpg" width="100" height="80" border="0"></td>';
              }
   if ( file_exists ( 'include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v ) ) {
$list .= '<td><a href="#" onClick="javascript:window.open(\'include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v.'\',\'bild\',\'height='.$hoehe.',width='.$breite.'\')"><img src="include/images/wars/'.$wid.'_'.$row['mnr'].'.jpg" width="100" height="80" border="0"></a></td>';
} else {
$list .= '<td><a><img src="include/images/wars/noscreen.jpg" width="100" height="80" border="0"></a></td>';
 
     }
   }
return ($list);
}
function lastwars_get_memberlist (  $id ) {
    $l = '';
    $erg = db_query("SELECT prefix_user.id,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 prefix_user.id ASC");
    while($r = db_fetch_assoc($erg)) {
    $l .= file_exists($r['avatar']) ? '<a href="index.php?user-details-'.$r['id'].'"><img src="'.$r['avatar'].'" alt="'.$r['name'].'" info="'.$r['name'].'" /></a>  ' : '<a href="index.php?user-details-'.$r['id'].'"><img src="include/images/avatars/noavatar.jpg" alt="'.$r['name'].'" info="'.$r['name'].'" /></a>  ';
    }
return (substr($l,0,-2));
}
if ( $menu->get(2) == '' OR $menu->getA(2) == 'p' ) {
    $title = $allgAr['title'].' :: Wars';
    $hmenu = 'Wars';
    $design = new design ( $title , $hmenu );
    $design->header();
 
    $ergWin = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE wlp = "1"');
    $anzWin = db_result($ergWin,0);
    $ergLos = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE wlp = "2"');
    $anzLos = db_result($ergLos,0);
    $ergPat = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE wlp = "3"');
    $anzPat = db_result($ergPat,0);
    $ergGes = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE status= "3"');
    $anzGes = db_result($ergGes,0);
    $tpl = new tpl ( 'wars.htm' );
    $tpl->set_ar_out ( array('PAT' => $anzPat, 'WIN' => $anzWin, 'LOS' => $anzLos, 'GES' => $anzGes, 'TITLE'=> $allgAr['title'] ) , 0 );
    $akttime = date('Y-m-d');
    $class = '';
    $erg = db_query("SELECT a.id,a.gegner,a.page,a.game,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y - %H:%i:%s') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id WHERE status = 2 AND a.datime >= '".$akttime."' ORDER BY a.datime");
    if ( db_num_rows ( $erg ) == 0 ) {
        echo '<tr class="Cmite"><td colspan="4"><strong>kein Next War vorhanden</strong></td></tr>';
    } else {
        while ($row = db_fetch_assoc($erg) ) {
            if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
            $row['page'] = get_homepage($row['page']);
      $row['team'] = get_wargameimg($row['game']).'&nbsp;'.$row['team'];
            $row['class'] = $class;
            $tpl->set_ar_out($row,1);
        }
    }
    $tpl->out(2);
    $class = '';
    if ( $menu->get(1) == '' ) {
        $teams = dblistee ( '', "SELECT id,name FROM prefix_groups ORDER BY name");
        $game= dblistee ('', "SELECT DISTINCT `game`,`game` FROM prefix_wars ORDER BY `game`" );
        $mtype= dblistee ( '', "SELECT DISTINCT `mtyp`,`mtyp` FROM prefix_wars ORDER BY `mtyp`" );
        $tpl->set_ar_out ( array('tid' => $teams, 'game' => $game, 'typ' => $mtype ) , 3 );
    } elseif ($menu->get(1) == 'last') {
        $tpl->out(4);
        $sqla='WHERE status = 3 ';
        if(!empty($_POST['tid'])){
            $sqla.= 'AND tid="'.$_POST['tid'].'" ';
        }
        if(!empty($_POST['wpl'])){
            $sqla.= 'AND wlp="'.$_POST['wpl'].'" ';
        }
        if(!empty($_POST['spiel'])){
            $sqla.= 'AND game="'.$_POST['spiel'].'" ';
        }
        if(!empty($_POST['typ'])){
            $sqla.= 'AND mtyp="'.$_POST['typ'].'" ';
        }
        # seiten funktion
        $limit = $allgAr['wars_last_limit'];  // Limit
        $page = ( $menu->getA(2) == 'p' ? $menu->getE(2) : 1 );
        $MPL = db_make_sites ($page , "WHERE status = 3" , $limit , "?wars-last" , 'wars' );
        $anfang = ($page - 1) * $limit;
        # seiten funktion
        $farbe1wlpar = array(1=>'C8E1B8',2=>'D8B9B9',3=>'FDFBB7');
        $farbe2wlpar = array(1=>'00FF00',2=>'FF0000',3=>'FFFF00');
        $erg = db_query("SELECT a.owp,a.opp,a.wlp,a.land,a.mtyp,a.game,a.id,a.gegner,a.page,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id ".$sqla." ORDER BY a.datime DESC, id DESC LIMIT ".$anfang.",".$limit);
        while ($row = db_fetch_assoc($erg) ) {
            $row['erg'] = $row['opp'].':'.$row['owp'];
            $row['farbe'] = $farbe1wlpar[$row['wlp']];
            $row['farbe2'] = $farbe2wlpar[$row['wlp']];
            if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
            $row['page'] = get_homepage($row['page']);
      $row['team'] = get_wargameimg($row['game']).'&nbsp;'.$row['team'];
            $row['class'] = $class;
            $tpl->set_ar_out($row,5);
        }
        $tpl->out(6);
        echo $MPL;
    }
  $design->footer();
} elseif ( is_numeric($menu->get(2)) ) {
    $_GET['mehr'] = escape($menu->get(2),'integer');
 
    $erg = @db_query("SELECT
    DATE_FORMAT(datime,'%d.%m.%Y') as datum,
    tid, status, owp, opp, wlp,
    DATE_FORMAT(datime,'%H:%i:%s') as zeit,
    gegner, tag, page, mail, icq, wo, prefix_wars.`mod`, mtyp,
    game, land, txt, prefix_wars.id,
    name as team
    FROM prefix_wars
    left join prefix_groups ON prefix_wars.tid = prefix_groups.id
    WHERE prefix_wars.id = ".$_GET['mehr']);
 
  db_check_erg ($erg);
 
  $row = db_fetch_assoc($erg);
  $row['page'] = get_homepage($row['page']);
    $row['txt'] = bbcode($row['txt']);
    if ( $row['status'] == 2 ) {
    # nextwars
        $title = $allgAr['title'].' :: Wars :: Nextwars';
        $hmenu = '<a href="?wars" class="smalfont">Wars</a><b> &raquo; </b>Nextwars';
        $design = new design ( $title , $hmenu );
        $design->header();
        $tpl = new tpl ('wars_next');
        $row['tag'] = ( empty($row['tag']) ? $row['gegner'] : $row['tag'] );
        if ( $_SESSION['authright'] <= -3 ) {
            $row['mail']=$row['mail'];
            $row['icq']=$row['icq'];
            $row['wo']=$row['wo'];
            $row['txt']=$row['txt'];
        } else{
            $row['icq']='locked';
            $row['mail']='locked';
            $row['wo']='locked';
            $row['txt']='locked';
        }
        $tpl->set_ar_out($row,0);
 
        if ( $_SESSION['authright'] <= -2 ) {
            # get benoetige member
            $bm = substr($row['mod'],0,3); $needed = '';
            for($i=0;$i<strlen($bm);$i++) {
                if ( is_numeric($bm{$i}) ) {
                    $needed .= $bm{$i};
                }
            }
 
      $uid = $_SESSION['authid'];
      if ($menu->get(3) == 'delete') { $uid = $menu->get(4); }
      $ck = db_count_query("SELECT COUNT(wid) FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND uid = ".$uid);
 
            # eine zu bzw. absage loeschen
            if ( $menu->get(3) == 'delete' AND ((has_right(array($row['tid'])) === true AND $uid == $_SESSION['authid']) OR is_siteadmin('wars')) AND $ck == 1) {
                db_query("DELETE FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND uid = ".$uid );
                $ck = 0;
            }
 
            $available = db_count_query("SELECT COUNT(uid) FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND aktion = 1");
            $aout1 = array (
                    'needed' => $needed,
                    'available' => $available,
                    'id' => $_GET['mehr']
                );
            $tpl->set_ar_out($aout1,1);
            if ( $ck == 0 AND has_right(array($row['tid'])) === true) {
                if ( isset ($_POST['sub']) ) {
                    $aktion = ( $_POST['sub'] == 'zusagen' ? 1 : 0 );
                    $kom = escape($_POST['kom'],'string');
                    db_query("INSERT INTO prefix_warmember (uid,wid,aktion,kom) VALUES (".$_SESSION['authid'].",".$_GET['mehr'].",".$aktion.",'".$kom."')");
                } else {
                    $tpl->out(2);
                }
            }
            $class = '';
            $aktionar = array ('<font style="color:#FF0000; background:#666666; font-weight:bold;">abgesagt</font>','<font style="font-weight:bold; color:#00FF00; background:#666666;">zugesagt</font>');
            $erg1 = db_query("SELECT b.id as uid, b.name, a.aktion, a.kom FROM prefix_warmember a left join prefix_user b ON b.id = a.uid WHERE a.wid = ".$_GET['mehr']);
            while ($row1 = db_fetch_assoc($erg1) ) {
                if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
                $row1['class'] = $class;
                $row1['aktion'] = $aktionar[$row1['aktion']];
                if ( $row1['uid'] == $_SESSION['authid'] OR is_siteadmin('wars')) {
                    $row1['name'] = '<a href="index.php?wars-more-'.$_GET['mehr'].'-delete-'.$row1['uid'].'"><img src="include/images/icons/del.gif" border="0" title="l&ouml;schen" /></a> &nbsp; '.$row1['name'];
                }
                $tpl->set_ar_out($row1,3);
            }
        }
    $tpl->out(4);
 
    } elseif ($row['status'] == 3) {
        # lastwars
        $row['memberliste'] = lastwars_get_memberlist($_GET['mehr']);
        $wlpar = array(1=>'gewonnen',2=>'verloren',3=>'unentschieden');
        $row['erg'] = $row['owp'].' zu '.$row['opp'];
        $row['ergliste'] = get_erg_liste($_GET['mehr']);
        $row['wlp'] = $wlpar[$row['wlp']];
        $title = $allgAr['title'].' :: Wars :: Lastwars';
        $hmenu = '<a href="?wars" class="smalfont">Wars</a><b> &raquo; </b>Lastwars';
        $design = new design ( $title , $hmenu );
        $design->header();
        $tpl = new tpl ('wars_last');
        $row['tag'] = ( empty($row['tag']) ? $row['gegner'] : $row['tag'] );
        $tpl->set_ar_out($row,0);
        # kommentare fuer lastwars
        if ($allgAr['wars_last_komms'] < 0 AND has_right ($allgAr['wars_last_komms'])) {
            # aktion
            if (isset ($_POST['kommentar_fuer_last_wars'])) {
                $name = $_SESSION['authname'];
                $text = escape($_POST['text'],'textarea');
                db_query("INSERT INTO prefix_koms (name,cat,text,uid) VALUES ('".$name."','WARSLAST', '".$text."', ".$_GET['mehr']." )");
            }
            if (isset ($_GET['kommentar_fuer_last_wars_loeschen']) AND is_siteadmin('wars')) {
                db_query("DELETE FROM prefix_koms WHERE cat = 'WARSLAST' AND uid = ".$_GET['mehr']." AND id = ".$_GET['kommentar_fuer_last_wars_loeschen']);
            }
            # anzeigen
            $tpl->out(1);
            $class = '';
            $erg = db_query("SELECT name,text,id FROM prefix_koms WHERE cat = 'WARSLAST' AND uid = ".$_GET['mehr']." ORDER BY id DESC");
            while($r = db_fetch_assoc($erg)) {
                $class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
                $r['text']  = bbcode($r['text']);
                if (is_siteadmin('wars')) { $r['text'] .= '<a href="index.php?wars-more-'.$_GET['mehr'].'=0&amp;kommentar_fuer_last_wars_loeschen='.$r['id'].'"><img src="include/images/icons/del.gif" title="l&ouml;schen" alt="l&ouml;schen" border="0"></a>'; }
                $r['class'] = $class;
                $tpl->set_ar_out($r,2);
            }
            $tpl->out(3);
        }
    }
  $design->footer();
}
?>

externer Link
xfire:jasonvorheees

0 Mitglieder finden den Beitrag gut.

zitieren

So. 21.02.2010 13:52 Uhr #10

Lord|Schirmer Administrator

wars.htm

100

101

<table border="0" cellspacing="1" cellpadding="1" class="border">
<tr class="Chead">
    <td align="center" colspan="4" ><b>{TITLE}</b></td>
</tr><tr class="Cmite">
    <td align="center">{_lang_whole}</td>
    <td align="center">{_lang_win}</td>
    <td align="center">{_lang_los}</td>
    <td align="center">{_lang_pat}</td>
</tr><tr class="Cnorm">
    <td align="center"><font class="textalter">{GES}</font></td>
    <td align="center"><font color="#00FF00">{WIN}</font></td>
    <td align="center"><font color="#FF4242">{LOS}</font></td>
    <td align="center"><font color="#FFEE00">{PAT}</font></td>
</tr><tr class="Cnorm">
    <td align="center">100%</td>
    <td align="center"><font color="#00FF00">{PWIN}</font></td>
    <td align="center"><font color="#FF4242">{PLOS}</font></td>
    <td align="center"><font color="#FFEE00">{PPAT}</font></td>
</tr>
</table>
<br>
<br>
<table width="100%" border="0" cellspacing="1" cellpadding="2" class="border">
<tr class="Chead">
    <td colspan="4"><b>{_lang_nextwars}</b></td>
</tr>
<tr class="Cdark">
    <td width="30%"><b>{_lang_date}</b></td>
    <td width="30%"><b>{_lang_opponent}</b></td>
    <td width="30%"><b>{_lang_squad}</b></td>
    <td width="10%"><b>{_lang_more}</b></td>
</tr>
{EXPLODE}
<tr class="{class}">
    <td>{time}</td>
    <td><a href="{page}" target="_blank">{gegner}</a></td>
    <td>{team}</td>
    <td><a href="index.php?wars-more-{id}">{_lang_more}</a></td>
</tr>
{EXPLODE}
</table>
<br />
<br />
{EXPLODE}
<form action="?wars-last" method="POST">
<input type="hidden" name="che" value="1">
<table width="100%" border="0" cellspacing="1" cellpadding="2" class="border">
<tr class="Chead">
    <td colspan="3"><b>{_lang_lastwars}</b></td>
</tr>
<tr class="Cnorm">
    <td>Team:</td>
    <td colspan="2"><select name="tid"><option value="">----------</option> {tid}</select></td>
</tr>
<tr class="Cmite">
    <td>{_lang_result}:</td>
    <td colspan="2"><select name="wpl">
    <option value="">----------</option>
    <option value="1">{_lang_win}</option>
    <option value="2">{_lang_los}</option>
    <option value="3">{_lang_pat}</option>
    </select>
    </td>
</tr>
<tr class="Cnorm">
    <td>Game:</td>
    <td colspan="2"><select name="spiel"><option value="">----------</option> {game}</select></td>
</tr>
<tr class="Cmite">
    <td>Typ:</td>
    <td colspan="2"><select name="typ"><option value="">----------</option> {typ}</td>
</tr>
<tr class="Cnorm">
<td></td><td><input type="Submit" name="Go" value="Go"></td><td><a href="index.php?wars-last">Zeige alle {_lang_lastwars}</a></td>
</tr>
</table>
</form>
{EXPLODE}
<table width="100%" border="0" cellspacing="1" cellpadding="2" class="border">
<tr class="Chead">
    <td colspan="7"><b>{_lang_lastwars}</b></td>
</tr>
<tr class="Cdark">
    <td width="15%"><b>{_lang_date}</b></td>
    <td width="20%"><b>{_lang_opponent}</b></td>
    <td width="25%"><b>{_lang_squad}</b></td>
    <td width="15%"><b>{_lang_matchtype}</b></td>
    <td width="15%"><b>{_lang_result}</b></td>
    <td width="10%"><b>{_lang_more}</b></td>
</tr>
{EXPLODE}
<tr class="{class}">
    <td>{time}</td>
    <td><img src="include/images/flags/{land}" alt="" /> <a href="{page}" target="_blank">{gegner}</a></td>
    <td>{team}</td>
    <td>{mtyp}</td>
  <td><div style="border: solid #{farbe2} 1px; margin: 0px; background-color: #{farbe}; color:#000000">{erg}</div></td>
    <td><a href="index.php?wars-more-{id}">{_lang_more}</a></td>
</tr>
{EXPLODE}
</table>

wars.php

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

<?php
#   Copyright by: Manuel Staechele
#   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];
                 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>';
  
 if (file_exists('include/images/maps/'.$row['map'].'.jpg') ) {
              $list .= '<td><a href="#" onClick="javascript:window.open(\'include/images/maps/'.$row['map'].'.jpg\',\'bild\',\'height=500 ,width=500\')"><img src="include/images/maps/'.$row['map'].'.jpg" width="100" height="80" border="0" alt="'.$row['map'].'" title="'.$row['map'].'" /></a></td>';
              } else {
              $list .= '<td><img src="include/images/maps/nopic.jpg" width="100" height="80" border="0"></td>';
              }
   if ( file_exists ( 'include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v ) ) {
$list .= '<td><a href="#" onClick="javascript:window.open(\'include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v.'\',\'bild\',\'height='.$hoehe.',width='.$breite.'\')"><img src="include/images/wars/'.$wid.'_'.$row['mnr'].'.jpg" width="100" height="80" border="0"></a></td>';
} else {
$list .= '<td><a><img src="include/images/wars/noscreen.jpg" width="100" height="80" border="0"></a></td>';
  
     }
   }
return ($list);
}
function lastwars_get_memberlist (  $id ) {
    $l = '';
    $erg = db_query("SELECT prefix_user.id,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 prefix_user.id ASC");
    while($r = db_fetch_assoc($erg)) {
    $l .= file_exists($r['avatar']) ? '<a href="index.php?user-details-'.$r['id'].'"><img src="'.$r['avatar'].'" alt="'.$r['name'].'" info="'.$r['name'].'" /></a>  ' : '<a href="index.php?user-details-'.$r['id'].'"><img src="include/images/avatars/noavatar.jpg" alt="'.$r['name'].'" info="'.$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);
    $anzGes2 = $anzGes == 0 ? 0.01 : $anzGes/100;
    $proWin = round($anzWin/$anzGes2,2).'%';
    $proLos = round($anzLos/$anzGes2,2).'%';
    $proPat = round($anzPat/$anzGes2,2).'%';
    $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 ) , 0 );
    $akttime = date('Y-m-d');
    $class = '';
    $erg = db_query("SELECT a.id,a.gegner,a.page,a.game,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y - %H:%i:%s') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id WHERE status = 2 AND a.datime >= '".$akttime."' ORDER BY a.datime");
    if ( db_num_rows ( $erg ) == 0 ) {
        echo '<tr class="Cmite"><td colspan="4"><strong>kein Next War vorhanden</strong></td></tr>';
    } else {
        while ($row = db_fetch_assoc($erg) ) {
            if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
            $row['page'] = get_homepage($row['page']);
      $row['team'] = get_wargameimg($row['game']).'&nbsp;'.$row['team'];
            $row['class'] = $class;
            $tpl->set_ar_out($row,1);
        }
    }
    $tpl->out(2);
    $class = '';
    if ( $menu->get(1) == '' ) {
        $teams = dblistee ( '', "SELECT id,name FROM prefix_groups ORDER BY name");
        $game= dblistee ('', "SELECT DISTINCT `game`,`game` FROM prefix_wars ORDER BY `game`" );
        $mtype= dblistee ( '', "SELECT DISTINCT `mtyp`,`mtyp` FROM prefix_wars ORDER BY `mtyp`" );
        $tpl->set_ar_out ( array('tid' => $teams, 'game' => $game, 'typ' => $mtype ) , 3 );
    } elseif ($menu->get(1) == 'last') {
        $tpl->out(4);
        $sqla='WHERE status = 3 ';
        if(!empty($_POST['tid'])){
            $sqla.= 'AND tid="'.$_POST['tid'].'" ';
        }
        if(!empty($_POST['wpl'])){
            $sqla.= 'AND wlp="'.$_POST['wpl'].'" ';
        }
        if(!empty($_POST['spiel'])){
            $sqla.= 'AND game="'.$_POST['spiel'].'" ';
        }
        if(!empty($_POST['typ'])){
            $sqla.= 'AND mtyp="'.$_POST['typ'].'" ';
        }
        # seiten funktion
        $limit = $allgAr['wars_last_limit'];  // Limit
        $page = ( $menu->getA(2) == 'p' ? $menu->getE(2) : 1 );
        $MPL = db_make_sites ($page , "WHERE status = 3" , $limit , "?wars-last" , 'wars' );
        $anfang = ($page - 1) * $limit;
        # seiten funktion
        $farbe1wlpar = array(1=>'C8E1B8',2=>'D8B9B9',3=>'FDFBB7');
        $farbe2wlpar = array(1=>'00FF00',2=>'FF0000',3=>'FFFF00');
        $erg = db_query("SELECT a.owp,a.opp,a.wlp,a.land,a.mtyp,a.game,a.id,a.gegner,a.page,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id ".$sqla." ORDER BY a.datime DESC, id DESC LIMIT ".$anfang.",".$limit);
        while ($row = db_fetch_assoc($erg) ) {
            $row['erg'] = $row['opp'].':'.$row['owp'];
            $row['farbe'] = $farbe1wlpar[$row['wlp']];
            $row['farbe2'] = $farbe2wlpar[$row['wlp']];
            if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
            $row['page'] = get_homepage($row['page']);
      $row['team'] = get_wargameimg($row['game']).'&nbsp;'.$row['team'];
            $row['class'] = $class;
            $tpl->set_ar_out($row,5);
        }
        $tpl->out(6);
        echo $MPL;
    }
  $design->footer();
} elseif ( is_numeric($menu->get(2)) ) {
    $_GET['mehr'] = escape($menu->get(2),'integer');
  
    $erg = @db_query("SELECT
    DATE_FORMAT(datime,'%d.%m.%Y') as datum,
    tid, status, owp, opp, wlp,
    DATE_FORMAT(datime,'%H:%i:%s') as zeit,
    gegner, tag, page, mail, icq, wo, prefix_wars.`mod`, mtyp,
    game, land, txt, prefix_wars.id,
    name as team
    FROM prefix_wars
    left join prefix_groups ON prefix_wars.tid = prefix_groups.id
    WHERE prefix_wars.id = ".$_GET['mehr']);
  
  db_check_erg ($erg);
  
  $row = db_fetch_assoc($erg);
  $row['page'] = get_homepage($row['page']);
    $row['txt'] = bbcode($row['txt']);
    if ( $row['status'] == 2 ) {
    # nextwars
        $title = $allgAr['title'].' :: Wars :: Nextwars';
        $hmenu = '<a href="?wars" class="smalfont">Wars</a><b> &raquo; </b>Nextwars';
        $design = new design ( $title , $hmenu );
        $design->header();
        $tpl = new tpl ('wars_next');
        $row['tag'] = ( empty($row['tag']) ? $row['gegner'] : $row['tag'] );
        if ( $_SESSION['authright'] <= -3 ) {
            $row['mail']=$row['mail'];
            $row['icq']=$row['icq'];
            $row['wo']=$row['wo'];
            $row['txt']=$row['txt'];
        } else{
            $row['icq']='locked';
            $row['mail']='locked';
            $row['wo']='locked';
            $row['txt']='locked';
        }
        $tpl->set_ar_out($row,0);
  
        if ( $_SESSION['authright'] <= -2 ) {
            # get benoetige member
            $bm = substr($row['mod'],0,3); $needed = '';
            for($i=0;$i<strlen($bm);$i++) {
                if ( is_numeric($bm{$i}) ) {
                    $needed .= $bm{$i};
                }
            }
  
      $uid = $_SESSION['authid'];
      if ($menu->get(3) == 'delete') { $uid = $menu->get(4); }
      $ck = db_count_query("SELECT COUNT(wid) FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND uid = ".$uid);
  
            # eine zu bzw. absage loeschen
            if ( $menu->get(3) == 'delete' AND ((has_right(array($row['tid'])) === true AND $uid == $_SESSION['authid']) OR is_siteadmin('wars')) AND $ck == 1) {
                db_query("DELETE FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND uid = ".$uid );
                $ck = 0;
            }
  
            $available = db_count_query("SELECT COUNT(uid) FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND aktion = 1");
            $aout1 = array (
                    'needed' => $needed,
                    'available' => $available,
                    'id' => $_GET['mehr']
                );
            $tpl->set_ar_out($aout1,1);
            if ( $ck == 0 AND has_right(array($row['tid'])) === true) {
                if ( isset ($_POST['sub']) ) {
                    $aktion = ( $_POST['sub'] == 'zusagen' ? 1 : 0 );
                    $kom = escape($_POST['kom'],'string');
                    db_query("INSERT INTO prefix_warmember (uid,wid,aktion,kom) VALUES (".$_SESSION['authid'].",".$_GET['mehr'].",".$aktion.",'".$kom."')");
                } else {
                    $tpl->out(2);
                }
            }
            $class = '';
            $aktionar = array ('<font style="color:#FF0000; background:#666666; font-weight:bold;">abgesagt</font>','<font style="font-weight:bold; color:#00FF00; background:#666666;">zugesagt</font>');
            $erg1 = db_query("SELECT b.id as uid, b.name, a.aktion, a.kom FROM prefix_warmember a left join prefix_user b ON b.id = a.uid WHERE a.wid = ".$_GET['mehr']);
            while ($row1 = db_fetch_assoc($erg1) ) {
                if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
                $row1['class'] = $class;
                $row1['aktion'] = $aktionar[$row1['aktion']];
                if ( $row1['uid'] == $_SESSION['authid'] OR is_siteadmin('wars')) {
                    $row1['name'] = '<a href="index.php?wars-more-'.$_GET['mehr'].'-delete-'.$row1['uid'].'"><img src="include/images/icons/del.gif" border="0" title="l&ouml;schen" /></a> &nbsp; '.$row1['name'];
                }
                $tpl->set_ar_out($row1,3);
            }
        }
    $tpl->out(4);
  
    } elseif ($row['status'] == 3) {
        # lastwars
        $row['memberliste'] = lastwars_get_memberlist($_GET['mehr']);
        $wlpar = array(1=>'gewonnen',2=>'verloren',3=>'unentschieden');
        $row['erg'] = $row['owp'].' zu '.$row['opp'];
        $row['ergliste'] = get_erg_liste($_GET['mehr']);
        $row['wlp'] = $wlpar[$row['wlp']];
        $title = $allgAr['title'].' :: Wars :: Lastwars';
        $hmenu = '<a href="?wars" class="smalfont">Wars</a><b> &raquo; </b>Lastwars';
        $design = new design ( $title , $hmenu );
        $design->header();
        $tpl = new tpl ('wars_last');
        $row['tag'] = ( empty($row['tag']) ? $row['gegner'] : $row['tag'] );
        $tpl->set_ar_out($row,0);
        # kommentare fuer lastwars
        if ($allgAr['wars_last_komms'] < 0 AND has_right ($allgAr['wars_last_komms'])) {
            # aktion
            if (isset ($_POST['kommentar_fuer_last_wars'])) {
                $name = $_SESSION['authname'];
                $text = escape($_POST['text'],'textarea');
                db_query("INSERT INTO prefix_koms (name,cat,text,uid) VALUES ('".$name."','WARSLAST', '".$text."', ".$_GET['mehr']." )");
            }
            if (isset ($_GET['kommentar_fuer_last_wars_loeschen']) AND is_siteadmin('wars')) {
                db_query("DELETE FROM prefix_koms WHERE cat = 'WARSLAST' AND uid = ".$_GET['mehr']." AND id = ".$_GET['kommentar_fuer_last_wars_loeschen']);
            }
            # anzeigen
            $tpl->out(1);
            $class = '';
            $erg = db_query("SELECT name,text,id FROM prefix_koms WHERE cat = 'WARSLAST' AND uid = ".$_GET['mehr']." ORDER BY id DESC");
            while($r = db_fetch_assoc($erg)) {
                $class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
                $r['text']  = bbcode($r['text']);
                if (is_siteadmin('wars')) { $r['text'] .= '<a href="index.php?wars-more-'.$_GET['mehr'].'=0&amp;kommentar_fuer_last_wars_loeschen='.$r['id'].'"><img src="include/images/icons/del.gif" title="l&ouml;schen" alt="l&ouml;schen" border="0"></a>'; }
                $r['class'] = $class;
                $tpl->set_ar_out($r,2);
            }
            $tpl->out(3);
        }
    }
  $design->footer();
}
?>

rules :: doku :: faq :: linkus

0 Mitglieder finden den Beitrag gut.

zitieren

So. 21.02.2010 14:33 Uhr #11

justinleebrain Mitglied

Registriert seit
17.07.2008

Beiträge
82

Beitragswertungen

Lord:!

ich könnt dich umarmen!
So reicht mir das schon vielen vielen Dank!!!!

externer Link
xfire:jasonvorheees
0 Mitglieder finden den Beitrag gut.
- zitieren

Beitrag zur Merkliste hinzufügen

ilch Forum » Allgemein » HTML, PHP, SQL,... » Lastwars -prozentzahl