Insert dummy i array! Hjælp søges.
Hejsa eksperter.Jeg har et lille problem jeg ikke tænkte over da jeg lavede mit system.
Systemet skal kunne håntere 16 - 32 - 64 users men vis der ikke er nok eller kun er ca eks 64 brugere skal man kunne sætte nogle dummys ind. Walkover1,2,3 osv. alt efter hvor mange der er brug for. Men nu kommer mit problem hvordan laver jeg det og sørger for at dummys ikke kommer til at spille mod hinanen. :S
Her er min kode kun for users uden dummys. Håber i vil hjælpe mig i får resten af alle du points jeg har. :D
<?php
session_start();
DB::Conn("open");
$cup_id = $_GET['cup_id'];
echo "Render list<br>";
$SQLa = "SELECT team_teams_id, stage FROM x_systems_team WHERE team_cup_id = '$cup_id' ORDER BY stage desc limit 1";
$loadina = mysql_query($SQLa) or die("There is an Error in the database");
while ($Geta = mysql_fetch_object($loadina)){
$stage = $Geta->stage;
echo $stage;
$SQL = "SELECT team_teams_id FROM x_systems_team WHERE team_cup_id = '$cup_id' && stage = '$stage' && team_validation = 'accepted'";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
$team1 = array();
$team2 = array();
$i = 0;
while ($Get = mysql_fetch_object($loadin)){
$i++;
if ( $i % 2 == 0 )
{
$team1[] = $Get->team_teams_id;
}
else
{
$team2[] = $Get->team_teams_id;
}
}
}
shuffle( $team1 );
shuffle( $team2 );
$teams = array_combine($team1, $team2);
//foreach ( $teams as $t1 => $t2 )
for($x = 0; $x < count($team1); $x++)
{
// echo "$t1 vs. $t2<br />";
echo $team1[$x] . " vs. " . $team2[$x] . "<br>";
mysql_query("INSERT INTO x_systems_result (
result_team_id_a,
result_team_id_b,
result_cup_id,
stage
) VALUES (
'".$team1[$x]."',
'".$team2[$x]."',
'".$cup_id."',
'".$stage."'
)") or die (Java::Alert("MySQL Error: ".mysql_error()));
Java::GoToURL("./index.php?page=edit.validation");
}
?>
