Hallo Zusammen,
ich habe die "rangliste.gruppenspiele.php" kopiert um eine neue Rangliste zu erstellen, bei der nur User angezeigt werden, welche bezahlt haben.
In der funktion habe ich folgenden Code erstellt:
PHP
- function returnGrpRanglisteFirma1($type, $grp, $begin, $length, $nav=0)
- {
- global $RUNTIME, $CONFIG, $_SESSION;
- $own = getRanglistenPlatzPlatz($type,$_SESSION['s_id']);
- ?>
- <table width="100%" cellpadding="0" cellspacing="0" border="0">
- <tr>
- <td class="tabHeaderRandl" style="width: 25px">Rang</td>
- <td class="tabHeaderMid" style="width: 300px" align="left" >Name</td>
- <td class="tabHeaderMid" style="width: 20px" align="center">Favorit</td>
- <td class="tabHeaderMid">Bild</td>
- <td class="tabHeaderMid" align="center">Tipps</td>
- <td class="tabHeaderMid" align="center">E</td>
- <td class="tabHeaderMid" align="center">D</td>
- <td class="tabHeaderMid" align="center">T</td>
- <?php
- if (($type == "boni") || ($type == "grp_boni"))
- echo "<td class=\"tabHeaderMid\" align=\"center\">B</td>";
- ?>
- <td class="tabHeaderRandr" style="width: 30px" align="center">Punkte</td>
- </tr>
- <?php
- $lastrang = 0;
- $sql = $CONFIG['MYSQL']['CONNECT']->query("
- SELECT tb1.*
- FROM ". $CONFIG['MYSQL']['PREFIX'] ."rangliste_". $type ." tb1
- LEFT JOIN ". $CONFIG['MYSQL']['PREFIX'] ."users tb2 ON tb2.id = tb1.uid
- WHERE tb1.grpid = '".$grp."'
- AND tb2.bezahlt = 1 ORDER BY platz ASC LIMIT ". $begin .",". $length);
- if ($sql->num_rows > 0)
- {
- while ($ar = $sql->fetch_array())
- {
- $sql2 = $CONFIG['MYSQL']['CONNECT']->query("SELECT fav,usr,userpic FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE id = '".$ar['uid']."' ");
- $row = $sql2->fetch_array();
- $ownstyle = "";
- $laston = $row['lastLogin'];
- if ($laston > (time() - $skript['actiontime']))
- $ownstyle = $ownstyle."background-color:#ccffcc;";
- if ($own == $ar['platz'])
- $ownstyle = $ownstyle."background-color:#99ccff;";
- $rangstyle = "";
- if ($ar['rang'] == 1)
- $rangstyle = " background-color:#FF0000; color:#ffffff;";
- if ($ar['rang'] == 2)
- $rangstyle = " background-color:#00FF00; color:#ffffff;";
- if ($ar['rang'] == 3)
- $rangstyle = " background-color:#CC9900; color:#ffffff;";
- if ($ar['rang'] == 4)
- $rangstyle = " background-color:#0066FF; color:#ffffff;";
- if ($ar['rang'] == 5)
- $rangstyle = " background-color:#660033; color:#ffffff;";
- if ($ar['rang'] == 6)
- $rangstyle = " background-color:#666666; color:#ffffff;";
- if ($ar['rang'] <= 200000 && $ar['rang'] > 6)
- $rangstyle = " background-color:#666666; color:#ffffff;";
- if (file_exists("img/flags/".$row['fav'].".png"))
- $flag = $CONFIG['PATH']."img/flags/".$row['fav'].".png";
- else
- $flag = $CONFIG['PATH']."img/flags/fifa.png";
- #<!-- Beginn MOD-Userpic -->
- if (file_exists("img/userpic/".$row['userpic']))
- $userpic = $CONFIG['PATH']."img/userpic/".$row['userpic'];
- else
- $userpic = $CONFIG['PATH']."img/userpic/empty.jpg";
- #<!-- Beginn MOD-Userpic -->
- ?>
- <tr>
- <td class="tabContentRandl" style="<?php echo $ownstyle.$rangstyle; ?>text-align:right; padding-right:10px;"><?php
- if ($lastrang < $ar['rang'])
- echo "";
- if ($own == $ar['platz'])
- echo "<b>";
- if ($lastrang < $ar['rang'])
- echo $ar['rang'];
- else
- echo " ";
- $lastrang = $ar['rang'];
- if ($own == $ar['platz'])
- echo "</b>";
- echo "</td>";
- echo "<td class=\"tabContentMid\" align=\"left\" >";
- if ($own == $ar['platz'])
- echo "<b>";
- echo getTipper($ar['uid'],1);
- if ($own == $ar['platz'])
- echo "</b>";
- if ($CONFIG['USERNAME'] == 0){
- echo "<br /> <i>(".getTipperName($ar['uid'],1).")</i>";
- }else{
- echo "<br /> <i>".getTipperName($ar['uid'],1)."</i>";
- }
- if ($own == $ar['platz'])
- echo "</b>";
- ?></td>
- <td class="tabContentMid" align="center"><img src="<?php echo $flag?>" style="padding:1px;border:0px;"></td>
- <!-- Beginn MOD-Userpic -->
- <td class="tabContentMid" align="center"><img src="<?php echo $userpic?>" style="padding:1px;border:0px; width:40px; height:40px;"></td>
- <!-- Ende MOD-Userpic -->
- <td class="tabContentMid" align="center"><?php echo $ar['tipps']?></td>
- <td class="tabContentMid" align="center"><?php echo $ar['e']?></td>
- <td class="tabContentMid" align="center"><?php echo $ar['d']?></td>
- <td class="tabContentMid" align="center"><?php echo $ar['t']?></td>
- <?php
- if (($type == "boni") || ($type == "grp_boni"))
- echo "<td class=\"tabContentMid\" align=\"center\">".$ar['b']."</td>";
- ?>
- <td class="tabContentRandr" align="center"><b><?php echo $ar['pkt']?></b></td>
- </tr>
- <?php
- }
- }
- echo "</table>";
- if ($nav == 1)
- {
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."rangliste_".$type." WHERE grpid = '".$grp."'");
- $num = $sql->num_rows;
- $pagesT = $num / $CONFIG['RANGLISTE']['UPP'];
- if ((int)$pagesT != $pagesT)
- $max = (int)$pagesT + 1;
- else
- $max = $pagesT;
- generatePageNavigation((isset($RUNTIME['PATH'][4]) ? $RUNTIME['PATH'][4] : 1), $max,"rangliste/rangliste/". $RUNTIME['PATH'][2] ."/". ((isset($RUNTIME['PATH'][3])) ? $RUNTIME['PATH'][3] : '0') ."/");
- }
- }
Damit werden auch nur die User die bezahlt haben angezeigt. Allerdings steht vor dem erstplatzierten die Zahl 2.
Hab ihr eine Idee.
Vielen Dank im Voraus.