====== Randomly Generated Officers ======

<php>

// 11 work out how many applicants. 
$apps = rand (20,60);

// set up some arrays as lookups for the values from the d10 rolls
$prev = array ("Pilot", "Astronaut", "Pacifier Pilot", "Command", "Astronaut", "Technical", "Legal", "Medical", "Logistics", "Marine");
$crim = array ("Colonial Fleet", "Battle Fleet", "Fleet Support", "Naval Staff", "Training", "Port Staff", "Special Duties", "Shipyard", "Naval Staff", "Naval Academy", "Command", "Command", "Admiralty", "Command");
$refs = array ("Poor", "Guarded", "Guarded", "Guarded", "Average", "Good", "Good", "Good", "Excellent", "Excellent");
$Ranks = array ("Ensign", "Lieutenant", "Lt.Commander", "Commander", "Captain", "Flag Captain", "Rear Admiral", "Vice Admiral", "Admiral of the White", "Admiral of the Black","Grand Admiral");

// set up a table inside a form so that the chosen applicants can be taken forwards to the next stage. 

echo "<h2>Applicant Details</h2> \n
      \n       
      <form action=recruit.php method=post>
       <table width = 85% cellpadding = 1>\n
       <tr> \n
         <td><b>Last 4 \n
         <td><b>Current Rank \n
         <td><b>Firstname \n
         <td><b>Surname \n
         <td><b>Branch \n
         <td><b>Current Location \n
         <td><b>New Posting \n
       </tr>"; 
$appl=1;
$rank=0;
// for each applicant then roll the various dice and then set the variables
do
  {
    $CrimCheck=rand(0,9);
    $Experience=rand(0,9);
    $RefCheck=rand(0,9);
    $Gender=rand(0,8);
    $BirthGender=$Gender;
    $GenderChanged="No";
    if($Gender==0)
      {
       $GenderChanged="Yes";
       $BirthGender=rand(1,8);
       $Gender=rand(1,8);
      }
    if($Gender==9)
      {
       $BirthGender=rand(1,8);
       $gend="Cyborg";
      }
        if($Gender<5)
      { $sex="M"; $gend="M"; }
    elseif($Gender<9)
      { $sex="F"; $gend="F"; }
    elseif($BirthGender<5)
      { $sex="M"; $gend="M"; }
    else
      { $sex="F"; $gend="F"; }
    $Homeworld="Earth, Q0";
    $gen=rand(0,9);
      if($gen > 2)
        {
          // set the necessary connection variables to connect to MySQL
          include ("/var/www/html/INI/sqlconnect.php"); 

          // connect to MySQL server and select the INI database
          include ("/var/www/html/INI/sqlconnect2.php"); 
          $db1 = mysql_select_db('full-moon_info_-_INI',$connection);

          // randomly select a system from the database 
          $sql1 = 'SELECT * FROM `stardata` where control = "EE" ORDER BY Rand() LIMIT 5';
          $homes = mysql_query($sql1);
          while ($row1=mysql_fetch_array($homes,MYSQL_ASSOC))
           {
            end($row1);
            extract($row1);
            
            $Homeworld = "$StarName, Q$Quadrant";
           } 
         }
      
// set the necessary connection variables to connect to MySQL
include ("/var/www/html/IFU/sqlconnect.php"); 


// 21 connect to MySQL server and select the IFU database
include ("/var/www/html/IFU/sqlconnect2.php"); 
$db = mysql_select_db('full-moon_info_-_IFU',$connection);

// randomly select a group of names from the database 
$sql = 'SELECT * FROM `Names` ORDER BY Rand() LIMIT 10';
$names = mysql_query($sql);

// step through the selected list of names to get a surname and forename from separate rows
  while ($row=mysql_fetch_array($names,MYSQL_ASSOC))
  {
    extract($row);
    $LastName = $Surname; 
    next($row);

// then randomly take a firstname of the correct gender from the same list
    if ($Gender==$sex)
    { 
     $Forename = $FirstName;
     next($row);
     extract($row);
     end($row);
    }
   }




// $Surnames = mysql_query($sql2);
// $Surname = $Surnames["Surname"];

// $sql2 = 'SELECT * FROM `Names` WHERE Gender=$sex ORDER BY Rand() LIMIT 2';
// $FirstName = $names["FirstName"];
$last4 = $appl + rand (1000,9799);
$promote = $promote + 1 + $rank + rand (0,6);

if ($promote>35)
     {$rank++; $promote=0;}
$PQ = $Quadrant;
$move = rand (0,10);
if ($move>7) 
    {
     if($PQ==0) {$PQ=rand(0,8);}
     if($PQ>0) {$PQ = rand(0,1) * rand (0,8);}
     }


echo "
       <tr> \n
         <td>$last4 \n
         <td>$Ranks[$rank] \n
         <td>$Forename \n
         <td>$LastName \n
         <td>$prev[$Experience] \n
         <td>$Homeworld \n
         <td>$crim[$CrimCheck], Q$PQ \n
       </tr>";

$appl++;
   
} while ($appl<=$apps); 
echo "</table>";


echo "</form>";

</php>