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

Beta-testers gezocht voor Crypto-oefenplatform

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

Developer Gezocht

Op zoek naar de legends

[FREE] WeFact Hosting module

Help testers nodig voor android app Urgent

Versio vervanger

Afspraken systeem met planbeperking

321 Nieuwe Domeinnamen December 2025

Meerdere mafia game template te koop

Van een pixelige afbeelding naar een strakke, moderne website

divisies niet meer dan twee

Participate now!

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

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