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

Ictscripters Chat

Help testers nodig voor android app Urgent

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Afspraken systeem met planbeperking

Developer Gezocht

Na 15 jaar terug van weggeweest: iCriminals.nl is terug (BETA)!

Op zoek naar de legends

[FREE] WeFact Hosting module

Domeinportfolio uitkuis

Heel wat sterke domeinen > 2 letters, 3 letters, premiums

367 Nieuwe Domeinnamen Februari 2026

divisies niet meer dan twee

Participate now!

Samsung zal miljoenen verdienen aan Apple iPhone Fold dankzij zijn 12GB RAM

Apple heeft zojuist iOS 26.4 Beta 4 vrijgegeven: hier is de verwachte lanceerdatum.

Kritieke kwetsbaarheid in Nginx UI bedreigt gevoelige data

Functioneel ontwerp

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

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

Gebruikers die dit topic bekijken