Beste leden,
Ik ben bezig met een voetbalspel, en wil graag zorgen dat er 7 divisies zijn ipv 2, ik heb tevens 1000 punten dus lijkt me wel dat je dan alle 7 divisies te zien krijgt.
Weet iemand hoe dit kan?
Beste leden,
Ik ben bezig met een voetbalspel, en wil graag zorgen dat er 7 divisies zijn ipv 2, ik heb tevens 1000 punten dus lijkt me wel dat je dan alle 7 divisies te zien krijgt.
Weet iemand hoe dit kan?
Meer informatie? Waar heb je het over enzovoort.
if ($teamid != 0) {
echo '<script> location.href="main.php" </script>';
exit;
}
$sQueryA = 'SELECT ontslag FROM users WHERE id = ' . $_SESSION['id'];
$iResultA = mysql_query($sQueryA);
$aObjectA = mysql_fetch_object($iResultA);
if ($aObjectA->ontslag > 0) {
?>
<div class="block margin">
<h3><span class="left"></span>Team kiezen</h3>
<div class="padding-x">
<p>
Je hebt laatst ontslag genomen waardoor je nu nog <?=$aObjectA->ontslag?> <?=($aObjectA->ontslag > 1) ? 'dagen' : 'dag'?> geen team kunt kiezen.
</p>
</div>
</div>
<?
include 'bottom.php';
exit;
}
$aLand['nl'] = "<img src='images/vlaggen/vlag_nederland.png' alt='Nederland'>";
$sQuery = 'SELECT punten FROM users WHERE id = ' . $_SESSION['id'];
$iResult = mysql_query($sQuery);
$aObject = mysql_fetch_object($iResult);
$aPunten = array ( 7 >= 0, 6 > 49, 5 > 99, 4 > 124, 3 > 249, 2 > 499, 1 > 999 );
$iPunten = $aObject->punten;
if ($iPunten > 49) $iDivisie = 6;
elseif ($iPunten > 99) $iDivisie = 5;
elseif ($iPunten > 124) $iDivisie = 4;
elseif ($iPunten > 249) $iDivisie = 3;
elseif ($iPunten > 499) $iDivisie = 2;
elseif ($iPunten > 999) $iDivisie = 1;
else $iDivisie = 7;
if (isset($_GET['division']) && is_numeric($_GET['division'])) {
$iDiv = $_GET['division'];
if ($iDiv > 0 && $iDiv < 8) {
if ($iDiv >= $iDivisie) {
if (isset($_GET['country']) && is_numeric($_GET['country'])) {
$iCountry = $_GET['country'];
if (isset($_GET['competition']) && is_numeric($_GET['competition'])) {
$iCompetition = $_GET['competition'];
$sQuery = 'SELECT * FROM teams WHERE divisie = ' . $iDiv . ' AND land = ' . $iCompetition . ' ORDER BY position ASC, points DESC, name ASC';
$iResult = mysql_query($sQuery);
echo '
<div class="block" id="teams">
<h3><span class="left"></span>Team kiezen</h3>
<div class="padding">
<ul>
<li class="header">
<div class="number cell center"><div class="left"></div><abbr title="">#</abbr></div>
<div class="name cell"><div class="left"></div><abbr title="Team">Team</abbr></div>
<div class="manager cell center"><div class="left"></div><abbr title="Manager">Manager</abbr></div>
<div class="matches cell center"><div class="left"></div><abbr title="Wedstrijden gespeeld">WG</abbr></div>
<div class="points cell center"><div class="left"></div><abbr title="Punten">P</abbr></div>
<div class="kies cell center"><div class="left"></div></div>
</li>';
$i = 1;
while ( $aObject = mysql_fetch_object($iResult) ) {
echo '
<li>
<div class="number cell center"><div class="left"></div>' . $i . '</div>
<div class="name cell"><div class="left"></div>' . $aObject->name . '</div>
<div class="manager cell center"><div class="left"></div>'. $aObject->trainer . '</div>
<div class="matches cell center"><div class="left"></div>' . $aObject->matches . '</div>
<div class="points cell center"><div class="left"></div>' . $aObject->points . '</div>
<div class="kies cell center"><div class="left"></div>';
if ($aObject->trainer == '') echo '<a href="jointeam.php?id=' . $aObject->id . '">Kies</a>';
echo '</div>
</li>
';
$i ++;
}
echo ' </ul>
<br /><a href="serverlist.php?division=' . $iDiv . '&country=' . $iCountry . '">Terug</a>
<div class="clear"></div>
</div>
<div class="bottom"><div class="row-1"></div><div class="row-2"></div></div>
</div>';
}else{
$sQuery = 'SELECT * FROM competities WHERE divisie = ' . $iDiv . ' AND land = ' . $iCountry;
$iResult = mysql_query($sQuery);
echo '
<div class="block" id="competition">
<h3><span class="left"></span>Competitie kiezen</h3>
<div class="padding">
<ul>
<li class="header">
<div class="vlag cell center"><div class="left"></div></div>
<div class="land cell center"><div class="left"></div><abbr title="Competitie">Competitie</abbr></div>
<div class="vacatures cell center"><div class="left"></div><abbr title="Vacatures">Vacatures</abbr></div>
<div class="week cell center"><div class="left"></div><abbr title="Week">Week</abbr></div>
<div class="kies cell center"><div class="left"></div><abbr title=""></abbr></div>
</li>';
while ( $aObject = mysql_fetch_object($iResult) ) {
$sQuery2 = 'SELECT id FROM teams WHERE land = ' . $aObject->id;
$iResult2 = mysql_query($sQuery2);
$iMax = mysql_num_rows($iResult2);
$sQuery1 = 'SELECT id FROM teams WHERE land = ' . $aObject->id . ' AND trainer = ""';
$iResult1 = mysql_query($sQuery1);
$iVacatures = mysql_num_rows($iResult1);
$sQuery3 = 'SELECT afkorting FROM landen WHERE id = ' . $iCountry;
$iResult3 = mysql_query($sQuery3);
$aObject3 = mysql_fetch_object($iResult3);
echo '
<li>
<div class="vlag cell center"><div class="left"></div>' . $aLand[$aObject3->afkorting] . '</div>
<div class="land cell center"><div class="left"></div>' . $aObject->naam . '</div>
<div class="vacatures cell center"><div class="left"></div>' . $iVacatures . '/' . $iMax . '</div>
<div class="week cell center"><div class="left"></div>' . $aObject->week . '</div>
<div class="kies cell center"><div class="left"></div><a href="serverlist.php?division=' . $iDiv . '&country=' . $aObject->land . '&competition=' . $aObject->id . '">Kies</a></div>
</li>
';
}
echo ' </ul>
<br /><a href="serverlist.php?division=' . $iDiv . '">Terug</a>
<div class="clear"></div>
</div>
<div class="bottom"><div class="row-1"></div><div class="row-2"></div></div>
</div>';
}
}else{
echo '
<div class="block" id="country">
<h3><span class="left"></span>Land kiezen</h3>
<div class="padding">
<ul>
<li class="header">
<div class="vlag cell center"><div class="left"></div></div>
<div class="land cell"><div class="left"></div><abbr title="Land">Land</abbr></div>
<div class="vacatures cell center"><div class="left"></div><abbr title="Vacatures">Vacatures</abbr></div>
<div class="kies cell center"><div class="left"></div><abbr title=""></abbr></div>
</li>';
$sQuery = 'SELECT * FROM landen';
$iResult = mysql_query($sQuery);
while ( $aObject = mysql_fetch_object($iResult) ) {
$iMax = 0;
$iVacatures = 0;
$sQuery3 = 'SELECT * FROM competities WHERE land = ' . $aObject->id;
$iResult3 = mysql_query($sQuery3);
while ( $aObject3 = mysql_fetch_object($iResult3) ) {
$sQuery2 = 'SELECT * FROM teams WHERE divisie = ' . $iDiv . ' AND land = ' . $aObject3->id;
$iResult2 = mysql_query($sQuery2);
$iMax += mysql_num_rows($iResult2);
$sQuery1 = 'SELECT * FROM teams WHERE divisie = ' . $iDiv . ' AND trainer = "" AND land = ' . $aObject3->id;
$iResult1 = mysql_query($sQuery1);
$iVacatures += mysql_num_rows($iResult1);
}
echo '
<li>
<div class="vlag cell center"><div class="left"></div>' . $aLand[$aObject->afkorting] . '</div>
<div class="land cell"><div class="left"></div>' . $aObject->competitie . '</div>
<div class="vacatures cell center"><div class="left"></div>' . $iVacatures . '/' . $iMax . '</div>
<div class="kies cell center"><div class="left"></div><a href="serverlist.php?division=' . $iDiv . '&country=' . $aObject->id . '">Kies</a></div>
</li>
';
}
echo ' </ul>
<br /><a href="serverlist.php">Terug</a>
<div class="clear"></div>
</div>
<div class="bottom"><div class="row-1"></div><div class="row-2"></div></div>
</div>';
}
}else{
echo '<script> location.href="serverlist.php" </script>';
}
}else{
echo 'Deze divisie bestaat niet.';
}
}else{
echo '
<div class="block" id="division">
<h3><span class="left"></span>Divisie kiezen</h3>
<div class="padding">
<ul>
<li class="header">
<div class="divisie cell center"><div class="left"></div><abbr title="Divisie">Divisie</abbr></div>
<div class="vacatures cell center"><div class="left"></div><abbr title="Vacatures">Vacatures</abbr></div>
<div class="punten cell center"><div class="left"></div><abbr title="Benodigde punten">Punten nodig</abbr></div>
<div class="kies cell center"><div class="left"></div><abbr title=""></abbr></div>
</li>';
for ( $i = 1; $i < 8; $i ++ ) {
if ($i < $iDivisie) continue;
$sQuery = 'SELECT * FROM teams WHERE divisie = ' . $i;
$iResult = mysql_query($sQuery);
$iMax = mysql_num_rows($iResult);
$sQuery1 = 'SELECT * FROM teams WHERE divisie = ' . $i . ' AND trainer = ""';
$iResult1 = mysql_query($sQuery1);
$iVacatures = mysql_num_rows($iResult1);
echo '
<li>
<div class="divisie cell center"><div class="left"></div>Divisie ' . $i . '</div>
<div class="vacatures cell center"><div class="left"></div>' . $iVacatures . '/' . $iMax . '</div>
<div class="punten cell center"><div class="left"></div>' . $aPunten[$i] . '</div>
<div class="kies cell center"><div class="left"></div><a href="serverlist.php?division=' . $i . '">Kies</a></div>
</li>
';
}
echo '
</ul>
<div class="clear"></div>
</div>
<div class="bottom"><div class="row-1"></div><div class="row-2"></div></div>
</div>
';
}
Toon Meer
Ik krijg maximaal maar 2 diviesies te zien, maar wil graag alle 7 zien.
Hoe kan ik daar voor zorgen?
Heb het niet super strak bekeken maar hoeveel teams zitten er dan in divisie 3-7?
(als je in db kijkt)
Er zijn de volgende: Divisie 1, 2, 3, 4, 5, 6 en 7
Mijn bedoeling is als je 0 punten hebt dat je bij divisie 7 begint en hoe meer punten je hebt hoe meer divisies ze komen, dus eerst 6 dan 5 etc.
Heb je nog geen account? Registreer je nu en word deel van onze community!