This is an old revision of the document!

IEN Officers - generation

<php> <?php start off the PHP processing remembering not to close the php tag work out how many officers to promote. $Ensigns = rand(1,20) * rand (1,6); $Lts = $Ensigns + rand(1,10) * rand (1,6); $LtCdrs = $Lts + rand (0,10) * rand(1,5); $Cdrs = $LtCdrs + rand (0,8) * rand(1,5); $Capts = $Cdrs + rand (0,4) * rand (0,1); $RAdms = $Capts + rand (0,1) * rand (0,1) * rand(0,4); $Apps = rand (6,200); $no = 590000;

set up some arrays as lookups for the values from the d10 rolls $Branch = array (“Pilot”, “Astronaut”, “Pacifier Pilot”, “Command”, “Astronaut”, “Technical”, “Legal”, “Medical”, “Logistics”, “Marine”); $Posting = array (“Small Ship”, “Capital Ship”, “Logs Ship”, “Shipyard”, “Training”, “Port Staff”, “Special Duties”, “Staff”, “Staff”, “Naval Academy”, “Command”, “Command”, “Admiralty”, “Command”); $Ranks = array (“Ensign”, “Lieutenant”, “Lt.Commander”, “Commander”, “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 “The following Officers have been promoted with effect from 3209.001 \n”; echo “\n”; Echo “ ^ No. ^ Rank ^ Firstname ^ Surname ^ Branch ^ Posting ^ Location ^ \n”; $appl=1; for each applicant then roll the various dice and then set the variables do { $Experience=rand(0,9); $post=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 > 3) { 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";
         } 
       }

work out the officer's rank (before promotion) if($appl<$Ensigns) {$rank=0;} elseif($appl>$RAdms) {rank=5;} elseif($appl>$Capts) {rank=4;} elseif($appl>$Cdrs) {rank=3;} elseif($appl>$LtCdrs) {rank=2;} else {rank=1;} Modify posting score

 $posting = $post + $rank;
 $newrank = $rank +1;
         

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);

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”]; $no=$no-rand(1,100); echo “<br> | $no | $Ranks[$rank] | $Forename | $Surname | $Branch[$Experience] | $Posting[$posting] | $Homeworld | \n ”; $appl++; } while ($appl⇐$apps); ?> </php>