');
}
if(!$_GET['name']) {
$filename = $_GET['url'];
$title = $_GET['title'];
echo ('You forgot to enter a name!
');
}
elseif(!$_GET['filename']) {
echo ('Trouble! The script encountered an error. Wait a minute and try again, or contact the webmaster. ');
}
elseif(!$error) {
$filename = $_GET['filename'];
$title = $_GET['title'];
$name = $_GET['name'];
$comment = $_GET['comment'];
//Database section! Add a new comment field to the film's slice of the database.
//extract date
$day = date(D);
$date = date(j);
$month = date(F);
$hour = date(H);
$minutes = date(i);
$timestamp = "At ".$hour.":".$minutes." on ".$day.", ".$month." ".$date.", ".$name." wrote:";
$newcomment = $timestamp."\n ".$comment."\n \n ";
print $newcomment." ";
}
/*
$db = @mysql_connect("mysql.csail.mit.edu","filmsai","filmsAI+3456") or die("Whoops! Couldn't connect to the database \
server. Try again in a minute or contact the webmaster.");
@mysql_select_db("filmsAI",$db) or die("Whoops! Couldn't select database. Try again in a minute or contact the webmaster.");
$result = @mysql_query("SELECT * FROM `comments` WHERE `id`=0",$db);
$resultno = mysql_num_fields($result);
//print $resultno." ";
//$lastno = $resultno - 2;
//for ($i = 1; $i <= $lastno; $i++) {
// printf("comment%03s\n ", $i);
// }
$newno = $resultno - 1;
$newcommentname = sprintf("comment%03s\n ", $newno);
@mysql_query("ALTER TABLE `comments` ADD $newcommentname TEXT NOT NULL",$db) or die("Whoops! The script failed to set the new comments. Try again in a minute or contact the webmaster.");
@mysql_query("ALTER TABLE `comments` ADD FULLTEXT ('$newcommentname')",$db) or die("Foo! No good.");
@mysql_query("INSERT INTO `comments` (`id`, `filename`, `$newcommentname`) VALUES (
$number = substr($filename,0,2);
echo ('