divisies niet meer dan twee

DI

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?

jopitan

Meer informatie? Waar heb je het over enzovoort.

DI

PHP

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?

Malik

Heb het niet super strak bekeken maar hoeveel teams zitten er dan in divisie 3-7?

(als je in db kijkt)

DI

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.

ICTscripters

Dé plek voor IT

Dé plek voor IT

Fallen Kingdom Game

Crimora.nl

RPG game gebouwd met AI

(Verkoop) Criminals

Het Grote Vibe Code Topic

Ictscripters Chat

Het oorspronkelijke Criminals Script

StraatBaas is back, maar hoe?!

Straatbaas.eu – complete Nederlandstalige en Engelstalige online maffia-RPG

306 Nieuwe Domeinnamen Juni 2026

4-letter domein: Togi.nl

divisies niet meer dan twee

Participate now!

Quanscient ontvangt €10M om AI- en kwantum-native hardware engineering te bevorderen - Tech.eu

Datalek bij leverancier Canvas - Universiteit van Amsterdam

Data privacy in 2026: Hoe de naleving van GDPR verandert

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2