require ('mysql-config.php'); $conn_id = mysql_connect("$host","$myuser","$mypass") or die("Verbindung zur Datenbank fehlgeschlagen"); mysql_select_db("$db",$conn_id); $result1 = mysql_query("SELECT * FROM oc_akten WHERE position='Kommandierender Offizier' AND einheitschiff = 'USS Bravestar NCC-75209' "); $per1 = mysql_fetch_array($result1); $result2 = mysql_query("SELECT * FROM oc_akten WHERE position='Kommandierender Offizier' AND einheitschiff = 'USS Enterprise NCC-1701-H' "); $per2 = mysql_fetch_array($result2); $result3 = mysql_query("SELECT * FROM oc_akten WHERE position='Kommandierender Offizier' AND einheitschiff = 'USS Hawk NCC-77891-B' "); $per3 = mysql_fetch_array($result3); $result4 = mysql_query("SELECT * FROM oc_akten WHERE position='Kommandierender Offizier' AND einheitschiff = 'USS Nimitz NCC-24043-A' "); $per4 = mysql_fetch_array($result4); $result5 = mysql_query("SELECT * FROM oc_akten WHERE position='Kommandierender Offizier' AND einheitschiff = 'USS Yamato NCC-80247' "); $per5 = mysql_fetch_array($result5); $result10 = mysql_query("SELECT * FROM oc_akten WHERE position='1. Offizier' AND einheitschiff = 'USS Bravestar NCC-75209' "); $per10 = mysql_fetch_array($result10); $result20 = mysql_query("SELECT * FROM oc_akten WHERE position='1. Offizier' AND einheitschiff = 'USS Enterprise NCC-1701-H' "); $per20 = mysql_fetch_array($result20); $result30 = mysql_query("SELECT * FROM oc_akten WHERE position='1. Offizier' AND einheitschiff = 'USS Hawk NCC-77891-B' "); $per30 = mysql_fetch_array($result30); $result40 = mysql_query("SELECT * FROM oc_akten WHERE position='1. Offizier' AND einheitschiff = 'USS Nimitz NCC-24043-A' "); $per40 = mysql_fetch_array($result40); $result50 = mysql_query("SELECT * FROM oc_akten WHERE position='1. Offizier' AND einheitschiff = 'USS Yamato NCC-80247' "); $per50 = mysql_fetch_array($result50); $result11 = mysql_query("SELECT * FROM oc_akten WHERE position='Taktischer Offizier' AND einheitschiff = 'USS Bravestar NCC-75209' "); $per11 = mysql_fetch_array($result11); $result21 = mysql_query("SELECT * FROM oc_akten WHERE position='Taktischer Offizier' AND einheitschiff = 'USS Enterprise NCC-1701-H' "); $per21 = mysql_fetch_array($result21); $result31 = mysql_query("SELECT * FROM oc_akten WHERE position='Taktischer Offizier' AND einheitschiff = 'USS Hawk NCC-77891-B' "); $per31 = mysql_fetch_array($result31); $result41 = mysql_query("SELECT * FROM oc_akten WHERE position='Taktischer Offizier' AND einheitschiff = 'USS Nimitz NCC-24043-A' "); $per41 = mysql_fetch_array($result41); $result51 = mysql_query("SELECT * FROM oc_akten WHERE position='Taktischer Offizier' AND einheitschiff = 'USS Yamato NCC-80247' "); $per51 = mysql_fetch_array($result51); $result12 = mysql_query("SELECT * FROM oc_akten WHERE position='Sicherheitsoffizier' AND einheitschiff = 'USS Bravestar NCC-75209' "); $per12 = mysql_fetch_array($result12); $result22 = mysql_query("SELECT * FROM oc_akten WHERE position='Sicherheitsoffizier' AND einheitschiff = 'USS Enterprise NCC-1701-H' "); $per22 = mysql_fetch_array($result22); $result32 = mysql_query("SELECT * FROM oc_akten WHERE position='Sicherheitsoffizier' AND einheitschiff = 'USS Hawk NCC-77891-B' "); $per32 = mysql_fetch_array($result32); $result42 = mysql_query("SELECT * FROM oc_akten WHERE position='Sicherheitsoffizier' AND einheitschiff = 'USS Nimitz NCC-24043-A' "); $per42 = mysql_fetch_array($result42); $result52 = mysql_query("SELECT * FROM oc_akten WHERE position='Sicherheitsoffizier' AND einheitschiff = 'USS Yamato NCC-80247' "); $per52 = mysql_fetch_array($result52); $result13 = mysql_query("SELECT * FROM oc_akten WHERE position='OPS/CONN Offizier' AND einheitschiff = 'USS Bravestar NCC-75209' "); $per13 = mysql_fetch_array($result13); $result23 = mysql_query("SELECT * FROM oc_akten WHERE position='OPS/CONN Offizier' AND einheitschiff = 'USS Enterprise NCC-1701-H' "); $per23 = mysql_fetch_array($result23); $result33 = mysql_query("SELECT * FROM oc_akten WHERE position='OPS/CONN Offizier' AND einheitschiff = 'USS Hawk NCC-77891-B' "); $per33 = mysql_fetch_array($result33); $result43 = mysql_query("SELECT * FROM oc_akten WHERE position='OPS/CONN Offizier' AND einheitschiff = 'USS Nimitz NCC-24043-A' "); $per43 = mysql_fetch_array($result43); $result53 = mysql_query("SELECT * FROM oc_akten WHERE position='OPS/CONN Offizier' AND einheitschiff = 'USS Yamato NCC-80247' "); $per53 = mysql_fetch_array($result53); $result14 = mysql_query("SELECT * FROM oc_akten WHERE position='Leitender Wissenschaftsoffizier' AND einheitschiff = 'USS Bravestar NCC-75209' "); $per14 = mysql_fetch_array($result14); $result24 = mysql_query("SELECT * FROM oc_akten WHERE position='Leitender Wissenschaftsoffizier' AND einheitschiff = 'USS Enterprise NCC-1701-H' "); $per24 = mysql_fetch_array($result24); $result34 = mysql_query("SELECT * FROM oc_akten WHERE position='Leitender Wissenschaftsoffizier' AND einheitschiff = 'USS Hawk NCC-77891-B' "); $per34 = mysql_fetch_array($result34); $result44 = mysql_query("SELECT * FROM oc_akten WHERE position='Leitender Wissenschaftsoffizier' AND einheitschiff = 'USS Nimitz NCC-24043-A' "); $per44 = mysql_fetch_array($result44); $result54 = mysql_query("SELECT * FROM oc_akten WHERE position='Leitender Wissenschaftsoffizier' AND einheitschiff = 'USS Yamato NCC-80247' "); $per54 = mysql_fetch_array($result54); $result15 = mysql_query("SELECT * FROM oc_akten WHERE position='Chefingenieur' AND einheitschiff = 'USS Bravestar NCC-75209' "); $per15 = mysql_fetch_array($result15); $result25 = mysql_query("SELECT * FROM oc_akten WHERE position='Chefingenieur' AND einheitschiff = 'USS Enterprise NCC-1701-H' "); $per25 = mysql_fetch_array($result25); $result35 = mysql_query("SELECT * FROM oc_akten WHERE position='Chefingenieur' AND einheitschiff = 'USS Hawk NCC-77891-B' "); $per35 = mysql_fetch_array($result35); $result45 = mysql_query("SELECT * FROM oc_akten WHERE position='Chefingenieur' AND einheitschiff = 'USS Nimitz NCC-24043-A' "); $per45 = mysql_fetch_array($result45); $result55 = mysql_query("SELECT * FROM oc_akten WHERE position='Chefingenieur' AND einheitschiff = 'USS Yamato NCC-80247' "); $per55 = mysql_fetch_array($result55); $result16 = mysql_query("SELECT * FROM oc_akten WHERE position='Leitender Medizinischer Offizier' AND einheitschiff = 'USS Bravestar NCC-75209' "); $per16 = mysql_fetch_array($result16); $result26 = mysql_query("SELECT * FROM oc_akten WHERE position='Leitender Medizinischer Offizier' AND einheitschiff = 'USS Enterprise NCC-1701-H' "); $per26 = mysql_fetch_array($result26); $result36 = mysql_query("SELECT * FROM oc_akten WHERE position='Leitender Medizinischer Offizier' AND einheitschiff = 'USS Hawk NCC-77891-B' "); $per36 = mysql_fetch_array($result36); $result46 = mysql_query("SELECT * FROM oc_akten WHERE position='Leitender Medizinischer Offizier' AND einheitschiff = 'USS Nimitz NCC-24043-A' "); $per46 = mysql_fetch_array($result46); $result56 = mysql_query("SELECT * FROM oc_akten WHERE position='Leitender Medizinischer Offizier' AND einheitschiff = 'USS Yamato NCC-80247' "); $per56 = mysql_fetch_array($result56); $result17 = mysql_query("SELECT * FROM oc_akten WHERE position='Counselor' AND einheitschiff = 'USS Bravestar NCC-75209' "); $per17 = mysql_fetch_array($result17); $result27 = mysql_query("SELECT * FROM oc_akten WHERE position='Counselor' AND einheitschiff = 'USS Enterprise NCC-1701-H' "); $per27 = mysql_fetch_array($result27); $result37 = mysql_query("SELECT * FROM oc_akten WHERE position='Counselor' AND einheitschiff = 'USS Hawk NCC-77891-B' "); $per37 = mysql_fetch_array($result37); $result47 = mysql_query("SELECT * FROM oc_akten WHERE position='Counselor' AND einheitschiff = 'USS Nimitz NCC-24043-A' "); $per47 = mysql_fetch_array($result47); $result57 = mysql_query("SELECT * FROM oc_akten WHERE position='Counselor' AND einheitschiff = 'USS Yamato NCC-80247' "); $per57 = mysql_fetch_array($result57); if ($per1[einheitschiff] == "USS Bravestar NCC-75209" && $per1[position] == "Kommandierender Offizier") { $ko_bravestar = "1"; } else { $ko_bravestar = "0"; } if ($per2[einheitschiff] == "USS Enterprise NCC-1701-H" && $per2[position] == "Kommandierender Offizier") { $ko_enterprise = "1"; } else { $ko_enterprise = "0"; } if ($per3[einheitschiff] == "USS Hawk NCC-77891-B" && $per3[position] == "Kommandierender Offizier") { $ko_hawk = "1"; } else { $ko_hawk = "0"; } if ($per4[einheitschiff] == "USS Nimitz NCC-24043-A" && $per4[position] == "Kommandierender Offizier") { $ko_nimitz = "1"; } else { $ko_nimitz = "0"; } if ($per5[einheitschiff] == "USS Yamato NCC-80247" && $per5[position] == "Kommandierender Offizier") { $ko_yamato = "1"; } else { $ko_yamato = "0"; } if ($per10[einheitschiff] == "USS Bravestar NCC-75209" && $per10[position] == "1. Offizier") { $xo_bravestar = "1"; } else { $xo_bravestar = "0"; } if ($per20[einheitschiff] == "USS Enterprise NCC-1701-H" && $per20[position] == "1. Offizier") { $xo_enterprise = "1"; } else { $xo_enterprise = "0"; } if ($per30[einheitschiff] == "USS Hawk NCC-77891-B" && $per30[position] == "1. Offizier") { $xo_hawk = "1"; } else { $xo_hawk = "0"; } if ($per40[einheitschiff] == "USS Nimitz NCC-24043-A" && $per40[position] == "1. Offizier") { $xo_nimitz = "1"; } else { $xo_nimitz = "0"; } if ($per50[einheitschiff] == "USS Yamato NCC-80247" && $per50[position] == "1. Offizier") { $xo_yamato = "1"; } else { $xo_yamato = "0"; } if ($per11[einheitschiff] == "USS Bravestar NCC-75209" && $per11[position] == "Taktischer Offizier") { $to_bravestar = "1"; } else { $to_bravestar = "0"; } if ($per21[einheitschiff] == "USS Enterprise NCC-1701-H" && $per21[position] == "Taktischer Offizier") { $to_enterprise = "1"; } else { $to_enterprise = "0"; } if ($per31[einheitschiff] == "USS Hawk NCC-77891-B" && $per31[position] == "Taktischer Offizier") { $to_hawk = "1"; } else { $to_hawk = "0"; } if ($per41[einheitschiff] == "USS Nimitz NCC-24043-A" && $per41[position] == "Taktischer Offizier") { $to_nimitz = "1"; } else { $to_nimitz = "0"; } if ($per51[einheitschiff] == "USS Yamato NCC-80247" && $per51[position] == "Taktischer Offizier") { $to_yamato = "1"; } else { $to_yamato = "0"; } if ($per12[einheitschiff] == "USS Bravestar NCC-75209" && $per12[position] == "Sicherheitsoffizier") { $so_bravestar = "1"; } else { $so_bravestar = "0"; } if ($per22[einheitschiff] == "USS Enterprise NCC-1701-H" && $per22[position] == "Sicherheitsoffizier") { $so_enterprise = "1"; } else { $so_enterprise = "0"; } if ($per32[einheitschiff] == "USS Hawk NCC-77891-B" && $per32[position] == "Sicherheitsoffizier") { $to_hawk = "1"; } else { $so_hawk = "0"; } if ($per42[einheitschiff] == "USS Nimitz NCC-24043-A" && $per42[position] == "Sicherheitsoffizier") { $so_nimitz = "1"; } else { $to_nimitz = "0"; } if ($per52[einheitschiff] == "USS Yamato NCC-80247" && $per52[position] == "Sicherheitsoffizier") { $so_yamato = "1"; } else { $so_yamato = "0"; } if ($per13[einheitschiff] == "USS Bravestar NCC-75209" && $per13[position] == "OPS/CONN Offizier") { $oco_bravestar = "1"; } else { $oco_bravestar = "0"; } if ($per23[einheitschiff] == "USS Enterprise NCC-1701-H" && $per23[position] == "OPS/CONN Offizier") { $oco_enterprise = "1"; } else { $oco_enterprise = "0"; } if ($per33[einheitschiff] == "USS Hawk NCC-77891-B" && $per33[position] == "OPS/CONN Offizier") { $oco_hawk = "1"; } else { $oco_hawk = "0"; } if ($per43[einheitschiff] == "USS Nimitz NCC-24043-A" && $per43[position] == "OPS/CONN Offizier") { $oco_nimitz = "1"; } else { $oco_nimitz = "0"; } if ($per53[einheitschiff] == "USS Yamato NCC-80247" && $per53[position] == "OPS/CONN Offizier") { $oco_yamato = "1"; } else { $oco_yamato = "0"; } if ($per14[einheitschiff] == "USS Bravestar NCC-75209" && $per14[position] == "Leitender Wissenschaftsoffizier") { $wo_bravestar = "1"; } else { $wo_bravestar = "0"; } if ($per24[einheitschiff] == "USS Enterprise NCC-1701-H" && $per24[position] == "Leitender Wissenschaftsoffizier") { $wo_enterprise = "1"; } else { $wo_enterprise = "0"; } if ($per34[einheitschiff] == "USS Hawk NCC-77891-B" && $per34[position] == "Leitender Wissenschaftsoffizier") { $wo_hawk = "1"; } else { $wo_hawk = "0"; } if ($per44[einheitschiff] == "USS Nimitz NCC-24043-A" && $per44[position] == "Leitender Wissenschaftsoffizier") { $wo_nimitz = "1"; } else { $wo_nimitz = "0"; } if ($per54[einheitschiff] == "USS Yamato NCC-80247" && $per54[position] == "Leitender Wissenschaftsoffizier") { $wo_yamato = "1"; } else { $wo_yamato = "0"; } if ($per15[einheitschiff] == "USS Bravestar NCC-75209" && $per15[position] == "Chefingenieur") { $ci_bravestar = "1"; } else { $ci_bravestar = "0"; } if ($per25[einheitschiff] == "USS Enterprise NCC-1701-H" && $per25[position] == "Chefingenieur") { $ci_enterprise = "1"; } else { $ci_enterprise = "0"; } if ($per35[einheitschiff] == "USS Hawk NCC-77891-B" && $per35[position] == "Chefingenieur") { $ci_hawk = "1"; } else { $ci_hawk = "0"; } if ($per45[einheitschiff] == "USS Nimitz NCC-24043-A" && $per45[position] == "Chefingenieur") { $ci_nimitz = "1"; } else { $ci_nimitz = "0"; } if ($per55[einheitschiff] == "USS Yamato NCC-80247" && $per55[position] == "Chefingenieur") { $ci_yamato = "1"; } else { $ci_yamato = "0"; } if ($per16[einheitschiff] == "USS Bravestar NCC-75209" && $per16[position] == "Leitender Medizinischer Offizier") { $lmo_bravestar = "1"; } else { $lmo_bravestar = "0"; } if ($per26[einheitschiff] == "USS Enterprise NCC-1701-H" && $per26[position] == "Leitender Medizinischer Offizier") { $lmo_enterprise = "1"; } else { $lmo_enterprise = "0"; } if ($per36[einheitschiff] == "USS Hawk NCC-77891-B" && $per36[position] == "Leitender Medizinischer Offizier") { $lmo_hawk = "1"; } else { $lmo_hawk = "0"; } if ($per46[einheitschiff] == "USS Nimitz NCC-24043-A" && $per46[position] == "Leitender Medizinischer Offizier") { $lmo_nimitz = "1"; } else { $lmo_nimitz = "0"; } if ($per56[einheitschiff] == "USS Yamato NCC-80247" && $per56[position] == "Leitender Medizinischer Offizier") { $lmo_yamato = "1"; } else { $lmo_yamato = "0"; } if ($per17[einheitschiff] == "USS Bravestar NCC-75209" && $per17[position] == "Counselor") { $cr_bravestar = "1"; } else { $cr_bravestar = "0"; } if ($per27[einheitschiff] == "USS Enterprise NCC-1701-H" && $per27[position] == "Counselor") { $cr_enterprise = "1"; } else { $cr_enterprise = "0"; } if ($per37[einheitschiff] == "USS Hawk NCC-77891-B" && $per37[position] == "Counselor") { $cr_hawk = "1"; } else { $cr_hawk = "0"; } if ($per47[einheitschiff] == "USS Nimitz NCC-24043-A" && $per47[position] == "Counselor") { $cr_nimitz = "1"; } else { $cr_nimitz = "0"; } if ($per57[einheitschiff] == "USS Yamato NCC-80247" && $per57[position] == "Counselor") { $cr_yamato = "1"; } else { $cr_yamato = "0"; } echo"
...::WANTED-LIST // Freie Posten::... |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|