divisies niet meer dan twee

DI · 20 Juni 2012

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 · 20 Juni 2012

Meer informatie? Waar heb je het over enzovoort.

DI · 20 Juni 2012

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 · 20 Juni 2012

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

(als je in db kijkt)

DI · 20 Juni 2012

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.

Ik wil op afstand studeren, kennen jullie Tech?

DNS update Directadmin

PC probleem

Let op Vimexx klanten

wie kan mij helpen met Security aanscherpen voor nmijn website

Ik ben op zoek naar een goede hosting

App bouwer gezocht

4G met USB Dongle - windows 11 Chrome of Firefox - browser probleem

Xenforo buckaroo plugin

300+ Nieuwe domeinnamen Maart 2024

Actieve crime

divisies niet meer dan twee

Participate now!

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Het Belang van Standaardisatie

De Revolutionaire Rol van IT in Alzheimeronderzoek

Functioneel ontwerp

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

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

Delen