require ('mysql-config.php');
$conn_id = mysql_connect("$host","$myuser","$mypass") or die("Verbindung zur Datenbank fehlgeschlagen");
mysql_select_db("$db",$conn_id);
$result = mysql_query("SELECT * FROM oc_akten ORDER BY name ASC ");
$per = mysql_fetch_array($result);
echo"
A1 Omega Command Mitgliedschaft |
9 Jahre |
";
$result = mysql_query("SELECT * FROM oc_akten WHERE id>1 ORDER BY name ASC ");
while($per = mysql_fetch_array($result)) {
$jetzt = mktime();
$eintritt_oc = mktime(0,0,0,$per[eintritt_monat],$per[eintritt_tag],$per[eintritt_jahr]);
$member_years = intval(($jetzt - $eintritt_oc) / (60 * 60 * 24 * 365.2425));
if ($per[member_count] == "ON") {
$member_year_all = ($member_years + $per[oc_years]);
}
else {
$member_year_all = $per[oc_years];
}
if ($member_year_all == "9") {
$col1 = "#000000";
$col2 = "#383838";
for($num = 1; $num<1000; $num++)
{
$color9 = ($color9 == $col1) ? $col2 : $col1;
}
echo"
$per[status] |
$per[rang] $per[vorname] $per[name] |
$per[abtbez] |
$per[einheitschiff] |
$per[position] |
$member_year_all | ";
}
}
echo"
8 Jahre |
";
$result = mysql_query("SELECT * FROM oc_akten WHERE id>1 ORDER BY name ASC ");
while($per = mysql_fetch_array($result)) {
$jetzt = mktime();
$eintritt_oc = mktime(0,0,0,$per[eintritt_monat],$per[eintritt_tag],$per[eintritt_jahr]);
$member_years = intval(($jetzt - $eintritt_oc) / (60 * 60 * 24 * 365.2425));
if ($per[member_count] == "ON") {
$member_year_all = ($member_years + $per[oc_years]);
}
else {
$member_year_all = $per[oc_years];
}
if ($member_year_all == "8") {
$col1 = "#000000";
$col2 = "#383838";
for($num = 1; $num<1000; $num++)
{
$color8 = ($color8 == $col1) ? $col2 : $col1;
}
echo"
$per[status] |
$per[rang] $per[vorname] $per[name] |
$per[abtbez] |
$per[einheitschiff] |
$per[position] |
$member_year_all | ";
}
}
echo"
7 Jahre |
";
$result = mysql_query("SELECT * FROM oc_akten WHERE id>1 ORDER BY name ASC ");
while($per = mysql_fetch_array($result)) {
$jetzt = mktime();
$eintritt_oc = mktime(0,0,0,$per[eintritt_monat],$per[eintritt_tag],$per[eintritt_jahr]);
$member_years = intval(($jetzt - $eintritt_oc) / (60 * 60 * 24 * 365.2425));
if ($per[member_count] == "ON") {
$member_year_all = ($member_years + $per[oc_years]);
}
else {
$member_year_all = $per[oc_years];
}
if ($member_year_all == "7") {
$col1 = "#000000";
$col2 = "#383838";
for($num = 1; $num<1000; $num++)
{
$color7 = ($color7 == $col1) ? $col2 : $col1;
}
echo"
$per[status] |
$per[rang] $per[vorname] $per[name] |
$per[abtbez] |
$per[einheitschiff] |
$per[position] |
$member_year_all | ";
}
}
echo"
6 Jahre |
";
$result = mysql_query("SELECT * FROM oc_akten WHERE id>1 ORDER BY name ASC ");
while($per = mysql_fetch_array($result)) {
$jetzt = mktime();
$eintritt_oc = mktime(0,0,0,$per[eintritt_monat],$per[eintritt_tag],$per[eintritt_jahr]);
$member_years = intval(($jetzt - $eintritt_oc) / (60 * 60 * 24 * 365.2425));
if ($per[member_count] == "ON") {
$member_year_all = ($member_years + $per[oc_years]);
}
else {
$member_year_all = $per[oc_years];
}
if ($member_year_all == "6") {
$col1 = "#000000";
$col2 = "#383838";
for($num = 1; $num<1000; $num++)
{
$color6 = ($color6 == $col1) ? $col2 : $col1;
}
echo"
$per[status] |
$per[rang] $per[vorname] $per[name] |
$per[abtbez] |
$per[einheitschiff] |
$per[position] |
$member_year_all | ";
}
}
echo"
5 Jahre |
";
$result = mysql_query("SELECT * FROM oc_akten WHERE id>1 ORDER BY name ASC ");
while($per = mysql_fetch_array($result)) {
$jetzt = mktime();
$eintritt_oc = mktime(0,0,0,$per[eintritt_monat],$per[eintritt_tag],$per[eintritt_jahr]);
$member_years = intval(($jetzt - $eintritt_oc) / (60 * 60 * 24 * 365.2425));
if ($per[member_count] == "ON") {
$member_year_all = ($member_years + $per[oc_years]);
}
else {
$member_year_all = $per[oc_years];
}
if ($member_year_all == "5") {
$col1 = "#000000";
$col2 = "#383838";
for($num = 1; $num<1000; $num++)
{
$color5 = ($color5 == $col1) ? $col2 : $col1;
}
echo"
$per[status] |
$per[rang] $per[vorname] $per[name] |
$per[abtbez] |
$per[einheitschiff] |
$per[position] |
$member_year_all | ";
}
}
echo"
4 Jahre |
";
$result = mysql_query("SELECT * FROM oc_akten WHERE id>1 ORDER BY name ASC ");
while($per = mysql_fetch_array($result)) {
$jetzt = mktime();
$eintritt_oc = mktime(0,0,0,$per[eintritt_monat],$per[eintritt_tag],$per[eintritt_jahr]);
$member_years = intval(($jetzt - $eintritt_oc) / (60 * 60 * 24 * 365.2425));
if ($per[member_count] == "ON") {
$member_year_all = ($member_years + $per[oc_years]);
}
else {
$member_year_all = $per[oc_years];
}
if ($member_year_all == "4") {
$col1 = "#000000";
$col2 = "#383838";
for($num = 1; $num<1000; $num++)
{
$color4 = ($color4 == $col1) ? $col2 : $col1;
}
echo"
$per[status] |
$per[rang] $per[vorname] $per[name] |
$per[abtbez] |
$per[einheitschiff] |
$per[position] |
$member_year_all | ";
}
}
echo"
3 Jahre |
";
$result = mysql_query("SELECT * FROM oc_akten WHERE id>1 ORDER BY name ASC ");
while($per = mysql_fetch_array($result)) {
$jetzt = mktime();
$eintritt_oc = mktime(0,0,0,$per[eintritt_monat],$per[eintritt_tag],$per[eintritt_jahr]);
$member_years = intval(($jetzt - $eintritt_oc) / (60 * 60 * 24 * 365.2425));
if ($per[member_count] == "ON") {
$member_year_all = ($member_years + $per[oc_years]);
}
else {
$member_year_all = $per[oc_years];
}
if ($member_year_all == "3") {
$col1 = "#000000";
$col2 = "#383838";
for($num = 1; $num<1000; $num++)
{
$color3 = ($color3 == $col1) ? $col2 : $col1;
}
echo"
$per[status] |
$per[rang] $per[vorname] $per[name] |
$per[abtbez] |
$per[einheitschiff] |
$per[position] |
$member_year_all | ";
}
}
echo"
2 Jahre |
";
$result = mysql_query("SELECT * FROM oc_akten WHERE id>1 ORDER BY name ASC ");
while($per = mysql_fetch_array($result)) {
$jetzt = mktime();
$eintritt_oc = mktime(0,0,0,$per[eintritt_monat],$per[eintritt_tag],$per[eintritt_jahr]);
$member_years = intval(($jetzt - $eintritt_oc) / (60 * 60 * 24 * 365.2425));
if ($per[member_count] == "ON") {
$member_year_all = ($member_years + $per[oc_years]);
}
else {
$member_year_all = $per[oc_years];
}
if ($member_year_all == "2") {
$col1 = "#000000";
$col2 = "#383838";
for($num = 1; $num<1000; $num++)
{
$color2 = ($color2 == $col1) ? $col2 : $col1;
}
echo"
$per[status] |
$per[rang] $per[vorname] $per[name] |
$per[abtbez] |
$per[einheitschiff] |
$per[position] |
$member_year_all | ";
}
}
echo"
1 Jahre |
";
$result = mysql_query("SELECT * FROM oc_akten WHERE id>1 ORDER BY name ASC ");
while($per = mysql_fetch_array($result)) {
$jetzt = mktime();
$eintritt_oc = mktime(0,0,0,$per[eintritt_monat],$per[eintritt_tag],$per[eintritt_jahr]);
$member_years = intval(($jetzt - $eintritt_oc) / (60 * 60 * 24 * 365.2425));
if ($per[member_count] == "ON") {
$member_year_all = ($member_years + $per[oc_years]);
}
else {
$member_year_all = $per[oc_years];
}
if ($member_year_all == "1") {
$col1 = "#000000";
$col2 = "#282828";
for($num = 1; $num<1000; $num++)
{
$color1 = ($color1 == $col1) ? $col2 : $col1;
}
echo"
$per[status] |
$per[rang] $per[vorname] $per[name] |
$per[abtbez] |
$per[einheitschiff] |
$per[position] |
$member_year_all | ";
}
}
echo"
0 Jahre |
";
$result = mysql_query("SELECT * FROM oc_akten WHERE id>1 ORDER BY name ASC ");
while($per = mysql_fetch_array($result)) {
$jetzt = mktime();
$eintritt_oc = mktime(0,0,0,$per[eintritt_monat],$per[eintritt_tag],$per[eintritt_jahr]);
$member_years = intval(($jetzt - $eintritt_oc) / (60 * 60 * 24 * 365.2425));
if ($per[member_count] == "ON") {
$member_year_all = ($member_years + $per[oc_years]);
}
else {
$member_year_all = $per[oc_years];
}
if ($member_year_all == "0") {
$col1 = "#000000";
$col2 = "#282828";
for($num = 1; $num<1000; $num++)
{
$color0 = ($color0 == $col1) ? $col2 : $col1;
}
echo"
$per[status] |
$per[rang] $per[vorname] $per[name] |
$per[abtbez] |
$per[einheitschiff] |
$per[position] |
$member_year_all | ";
}
}
echo"
";
?> |