");

$q4=mysql_query("select * from crew where ID = '$player_id'"); 
$qr=mysql_fetch_assoc($q4);

print_r($qr);
print ("
"); 	

$q3=mysql_query("select a.*, b.Name, a.post_num from posts_index a, crew b where b.ship='$ship_num' and a.char_id=b.ID and a. post_num='$row->idx'");
$rass=mysql_fetch_assoc($q3);


$qi_str = "insert into post_index (`post_num`,`name`,`title`,`char_id`,`timestamp`,`position`,`ship`) values ('$post_num', '$qr[Name]','$rass[title]','$rass[char_id]','$rass[timestamp]','$qr[Position]','$qr[ship]')"; 
print ($qi_str);  


break;


case "delete1":

mysql_query("delete from posts_index where ship='$ship_num' and post_num = '$idx'");
mysql_query("delete from ships_logs2 where ship='$ship_num' and idx = '$idx'");

header("Location:postcare.php?mode=sh_chapter&id=$tid");

break;
case "updatedb":

if (empty($title)) { print("You must have a title.  Please go back and add a title."); exit(); }
if (empty($stardate)) { print("You must have a stardate.  Please go back and add a stardate."); exit();}
if (empty($time)) { print("You must have a time.  Please go back and add a time."); exit(); }
if (empty($detail)) { print("You must have story details.  Please go back and add add your story."); exit();}

mysql_query("update ships_logs2 set stardate = '$stardate', time='$time', detail = '$detail' where ship='$ship_num' and idx = '$idx'");
mysql_query("update posts_index set title = '$title' where ship='$ship_num' and post_num = '$idx'");

header("Location:postcare.php?mode=sh_chapter&id=$id");
break;

case "sh_chapter":

print("
");

$q = mysql_query("select *  from  ships_logs2 where ship='$ship_num' and tid = '$id' order by stardate, time");


while($row=mysql_fetch_object($q)) {

$q2 = mysql_query("select title from posts_index where ship='$ship_num' and post_num='$row->idx' limit 1");

$title = mysql_fetch_row($q2);


print("

idx>Post Number:
$row->idxidx&tid=$row->tid> Delete
Title:
Stardate:
Time:
Word Count:
$row->word_count
$row->detail");

print("
Post Authors:

");
$q3=mysql_query("select a.*, b.Name from posts_index a, crew b where b.ship='$ship_num' and a.char_id=b.ID and a. post_num='$row->idx'");
while($row3=mysql_fetch_object($q3)) {
print("$row3->Name
");
}

print("idx&tid=$row->tid>Append Player
");
print("
");
}
break;
default:
$q = mysql_query("select * from chapters where ship = '$ship_num'");
print("
");

print("
Post Management
Please select the chapter you wish to modify:
");

while($row=mysql_fetch_object($q)) {
print("id&mode=sh_chapter>$row->title
");

}

}