Rank"); //$rank=mysql_fetch_object($q3); switch($type) { case "Name": case "Species": case "Position": case "Rname": case "Email": case "Gender": case "age": case "eye": case "hair": case "height": case "weight" : $q=mysql_query("select $type from $tbl where ID = $id"); $crew=mysql_fetch_row($q); print(" USS Atlanta - Crew Bios
Please enter a value for $type:
"); break; case "Status"; $q=mysql_query("select $type from $tbl where ID = $id"); $crew=mysql_fetch_row($q); print(" USS Atlanta - Crew Bios
Please enter a value for $type:
"); break; case "Department": $q=mysql_query("select $type from $tbl where ID = $id"); $crew=mysql_fetch_row($q); $q2=mysql_query("select * from deptlist"); print(" USS Atlanta - Crew Bios
Please enter a value for $type:
"); break; case "branch"; print(" USS Atlanta - Crew Bios
Please enter a value for $type:
"); break; case "service_type": print(" USS Atlanta - Crew Bios
Please enter a value for $type:
"); break; case "Rank": $q=mysql_query("select * from $tbl where ID = $id"); $crew=mysql_fetch_object($q); if ($crew->service_type=='C') { $rtable = "rank"; } else {$rtable="rank_enlisted";} $q2 = mysql_query("select * from $rtable"); print(" USS Atlanta - Crew Bios
Please enter a value for $type:
"); break; case "family": case "childhood": case "ee": case "pob": case "sfc": case "interests": case "personality": case "snotes": case "skills": $q=mysql_query("select $type from $tbl where ID = $id"); $crew=mysql_fetch_row($q); print(" USS Atlanta - Crew Bios
Please enter a value for $type:
"); break; case "image": print(" USS Atlanta - Crew Bios
PHOTO:
"); break; default: print("ERROR Changing player info: admin.;php"); } break; case "show": $plr=mysql_query("select * from crew where ID = '$id'"); $bios=mysql_query("select * from bios where ID = '$id'"); $deco = mysql_query("select a.award_id, a.reason, a.idx, b.ID from decorations a, crew b where a.plr_id = b.ID and a.plr_id = '$id'"); $bio=mysql_fetch_object($bios); $row=mysql_fetch_object($plr); if ($row->service_type =='C') {$st="Commissioned"; $rtable="rank";} else {$st="Enlisted"; $rtable="rank_enlisted";} $rank = mysql_query("select * from $rtable where ID = $row->Rank"); $rnk=mysql_fetch_object($rank); $dept = mysql_query("select * from deptlist where ref = $row->Department"); $dp = mysql_fetch_object($dept); if ($row->branch=='M') {$br="Marines"; $rrnk = $rnk->marine_rank; } else if ($row->branch=='N') {$br="Navy"; $rrnk = $rnk->rank; } else {$br="Civilian"; $rrnk = $rnk->rank; } print(" USS Atlanta - Crew Bios

Character Menu

"); if ($row->Status == "PC") { print(""); } print("
$row->Name is a $row->Status. Change Status
Player's name is $row->Rname Change Name
Email address is Email>$row->EmailChange Email
"); print(" "); break; case "addimage": $userfile = stripslashes($userfile); //$photodir = "www/bios/"; if(($userfile != "none")AND $userfile){ $ftype=explode(".",$_FILES['userfile']['name']); $stock .=$photodir; $stock .=$id; $stock .=".jpg"; // $stock=$photodir.$id.".jpg"; copy("$userfile","$stock") or die("$ftype[1] $stock -Photo Upload Failed"); } $blah = "bios/"; $blah .=$id; $blah .=".jpg"; mysql_query("update bios set image = '$blah' where ID='$id'"); header("Location:http:admin.php?mode=show&id=$id"); break; default: $roster = mysql_query("select * from crew where ship = '$ship_num' and Status in ('PC','NPC','RNPC') order by Name"); $pending = mysql_query("select * from crew where ship = '$ship_num' and Status = 'PENDING' order by Name"); $departed = mysql_query("select * from crew where ship = '$ship_num' and Status = 'PST' order by Name"); print(" USS Atlanta - Crew Bios

Acive Characters

Character Name$row->NameDepartment$dp->list
Branch$brService Type:$st
Current Rank$rrnkPosition$row->Position"); print("
Species$row->SpeciesAge$bio->age
Eyes$bio->eyeHair$bio->hair
Height$bio->heightWeight$bio->weight
Gender$row->GenderPlace of Birth$bio->pob
Family
$bio->family
Childhood$bio->childhood
Early Education$bio->ee
Starfleet Career$bio->sfc
Decorations "); $count=1; print(""); while($rowd=mysql_fetch_object($deco)) { $imgs = mysql_query("select name, idx from awards where idx = $rowd->award_id"); while ($rowe=mysql_fetch_object($imgs)) { if ($count == 1) { print("");} else if ($count==2) {print("");} else if ($count ==3) { print(""); $count=0;} $count++; } } print("
idx&idx2=$rowe->idx>idx&idx2=$rowe->idx> idx&idx2=$rowe->id x>
"); print("
Interests$bio->interests
personality$bio->personality
Special Notes$bio->snotes
Skills$bio->skills
Imageimage>
Add A New Character
"); $flag=1; while ($row=mysql_fetch_object($roster)) { if ($flag ==1) {print(""); } print(""); if ($flag == 3) { print(""); } $flag++; if ($flag == 4) { $flag=1; } } print("
NameNameName
ID>$row->Name [$row->Status]
"); print("

Decommissioned Characters

Add A New Charac ter
"); $flag=1; while ($row=mysql_fetch_object($departed)) { if ($flag ==1) {print(""); } print(""); if ($flag == 3) { print(""); } $flag++; if ($flag == 4) { $flag=1; } } print("
ID>$row->Name [$row->Status]
"); print("

New Character Submittiosn

Add A New Charac ter
"); $flag=1; while ($row=mysql_fetch_object($pending)) { if ($flag ==1) {print(""); } print(""); if ($flag == 3) { print(""); } $flag++; if ($flag == 4) { $flag=1; } } print("
ID>$row->Name [$row->Status]
"); }