#!/usr/bin/perl

my $r = Apache->request;
	
print "HTTP/1.1 200 OK
Server: Apache/1.3b3 mod_perl/1.08
";

use DBI;
use strict 'vars';
require 'ctime.pl';          

use slashmod;
my ($imagedir,$rootdir,$datadir)=slashmod::config();
my $dbh;

	
sub main
{
        $dbh ||= slashmod::dbconnect();

        my %FORM = slashmod::getform();
	my %COOKIES = slashmod::getcookies();

	my ($aid, $thisuser, $error, $email, $url, $seclev)=("", "","","","",0);
	if ($COOKIES{session} ne "") {
	  ($aid,$seclev)=slashmod::getadmininfo($COOKIES{session});
	}
	if (defined $FORM{aid} and defined $FORM{pwd}) {
	  ($aid,$seclev)=slashmod::setadmininfo($FORM{aid},$FORM{pwd});
	}
	($thisuser,$email,$url)=slashmod::getuserinfo($COOKIES{userinfo});
	$thisuser=$aid;

	print "Content-Type: text/html\n\n";

	slashmod::header("Slashdot Admin","nohead");
	print "<H3>&nbsp;</H3><fONT size=2>";

	if($seclev > 0) {
		print " [ <A href=$ENV{SCRIPT_NAME}?op=logout>Logout $aid</A>
			| <A href=$rootdir/>Home</A>
			| <A href=$ENV{SCRIPT_NAME}>List</A>
			| <A href=$ENV{SCRIPT_NAME}?op=topics>Topics</A>
			";
	}
	if($seclev > 10) { 
		print "	| <A href=$ENV{SCRIPT_NAME}?op=edit>New</A>
			| <A href=$ENV{SCRIPT_NAME}?op=list>Modify</A> 
			";
	}
	if($seclev > 499) {	
		print "	| <A href=$ENV{SCRIPT_NAME}?op=submissions>Submissions</A>";
	}
	if($seclev > 1000) {
		print "	| <A href=$ENV{SCRIPT_NAME}?op=blocks>Blocks</A>
			| <A href=$rootdir/pollBooth.pl>Polls</A> ";
	}
	if($seclev > 10000) {
		print " | <A href=$ENV{SCRIPT_NAME}?op=authors>Authors</A>
			| <A href=$ENV{SCRIPT_NAME}?op=vars>Variables</A>
			";
	}
	if($seclev > 0) {
		print "] </FONT><P>";
	}

	if(not $seclev) {
		slashmod::titlebar("99%","Login $error");
		
		print "<fORM action=$ENV{SCRIPT_NAME} method=post>
			<CENTER><TABLE>
			 <TR>
			  <TD align=right>Login</TD>
			  <TD><INPUT type=name name=aid></TD>
			 </TR><TR>
			  <TD align=right>Password</TD>
			  <TD><INPUT type=password name=pwd></TD>
			 </TR><TR>
			  <TD> </TD><TD><INPUT type=submit
			  value=\"Login\"></TD></FORM>
			</TABLE></CENTER>
		";
	} elsif($FORM{'op'} eq "logout") {
		$dbh->do("DELETE FROM sessions WHERE aid='$aid'");
		print "You are now logged out.  Bub-Bye";
	} elsif($FORM{'op'} eq "submissions" or $FORM{op} eq "rmsub"
		or $FORM{op} eq "GenQuickies") {
		slashmod::titlebar("99%","Submissions Admin");
		submissioned(%FORM);
	} elsif($FORM{op} eq "topiced") {
		topiced(%FORM);
	} elsif($FORM{'op'} eq "viewsub") {
		editstory($aid,"",$FORM{subid});
	} elsif($FORM{'op'} eq "save") {
		$FORM{dept}=~ s/'/''/gi;
		$FORM{title}=~ s/'/''/gi;
		$FORM{bodytext}=~ s/'/''/gi;
		$FORM{introtext}=~ s/'/''/gi;
		my $cursor=$dbh->prepare("INSERT into stories
			(sid,aid,tid,title,dept,introtext,bodytext,
				time,writestatus,commentcount,hits,section)
			VALUES('$FORM{sid}',
			  '$FORM{aid}', '$FORM{tid}', '$FORM{title}',
			  '$FORM{dept}','$FORM{introtext}', 
			  '$FORM{bodytext}', NOW(),1,0,0,'$FORM{section}')");
		$cursor->execute;
		$cursor->finish;
		slashmod::titlebar("99%","Article Saved","c");
		liststories($aid,$FORM{next});
	} elsif($FORM{'op'} eq "update") {
		$FORM{dept}=~ s/'/''/gi;
		$FORM{bodytext}=~ s/'/''/gi;
		$FORM{introtext}=~ s/'/''/gi;
		$FORM{title}=~ s/'/''/gi;
		my $cursor=$dbh->prepare("UPDATE stories
			set aid='$FORM{aid}',
				tid='$FORM{tid}',
				title='$FORM{title}',
				dept='$FORM{dept}',
				introtext='$FORM{introtext}',
				bodytext='$FORM{bodytext}',
				section='$FORM{section}',
				writestatus=1
			WHERE sid=\"$FORM{sid}\"");
		$cursor->execute;
		slashmod::titlebar("99%","Article Updated","c");
	} elsif($FORM{'op'} eq "list") {
		slashmod::titlebar("99%","Article List","c");
		liststories($aid,$FORM{next});
	} elsif($FORM{'op'} eq "delete") {
		rmstory($aid,$FORM{sid});
		liststories($aid,$FORM{next});
	} elsif($FORM{'op'} eq "preview") {
		editstory($aid,"","",%FORM);
	} elsif($FORM{'op'} eq "edit") {
		slashmod::titlebar("99%","Article Editor","c");
		editstory($aid, $FORM{sid});
	} elsif($FORM{'op'} eq "topics") {
		listtopics($seclev);
	} elsif($FORM{'op'} eq "blocks") {
		blocklist();
	} elsif($FORM{'op'} eq "blocksave") {
		blocksave(%FORM);
	} elsif($FORM{'op'} eq "blockadmin") {
		blockadmin(%FORM);
	} elsif($FORM{'op'} eq "authors") {
		listauthors();
	} elsif($FORM{'op'} eq "authorsave") {
		saveauthors(%FORM);
		listauthors();
	} elsif($FORM{'op'} eq "vars") {
		listvars();
	} elsif($FORM{'op'} eq "savevars") {
		savevars(%FORM);
		listvars();
	} else {
		slashmod::titlebar("99%","Story List","c");
		liststories("",$FORM{next});
	}
	slashmod::writelog("admin",$aid);

	if($seclev > 0) {
		print "<P align=right>Current Users: <b><fONT color=006666>";
		my $c=$dbh->prepare("SELECT aid FROM sessions 
					GROUP BY aid ORDER BY aid");
		$c->execute();
		while(my ($aid)=$c->fetchrow()) {
			print "$aid ";
		}
		$c->finish();
	}
	print "</B></FONT> &nbsp; </TD></TR></TABLE>";

}


sub submissioned
{
	my (%FORM)=@_;
	if($FORM{op} eq "rmsub") {
		$dbh->do("DELETE from submissions
					where  subid='$FORM{subid}'");
		delete $FORM{op};
		delete $FORM{subid};
		
		foreach my $key (keys %FORM) {
			my ($t,$n)=split("_",$key);
			if($t eq "note") {
				if($FORM{$key} ne "") {
				  print "$n ";
				  $dbh->do("UPDATE submissions
					set note='$FORM{$key}'
					WHERE subid='$n'") 
				}
			} else {
				print "$key " unless not
				$dbh->do("DELETE from submissions
					WHERE subid='$key'");
			}
		}
	}
	if(lc($FORM{op}) eq "genquickies") {
		my $c=$dbh->prepare("SELECT story FROM submissions
					WHERE subid='quickies'");
		$c->execute();
		my ($stuff)=$c->fetchrow();
		$dbh->do("DELETE FROM submissions WHERE subid='quickies'");
		$c=$dbh->prepare("SELECT subid,subj,email,name,story
				 FROM submissions
			        WHERE note='Quik'");
		$c->execute();
		while(my ($subid, $subj, $email, 
			$name, $story)=$c->fetchrow()) {
			$stuff.=" <A href=\"mailto:$email\">$name</A> writes 
				  <I>\"$story\"</I>\n\n";
		}


		$stuff=~s/'/''/g;
		my $strSQL="INSERT into submissions
			(subid,subj,email,name,time,story)
			VALUES('quickies','Generated Quickies',
				'','',now(),'$stuff')";
		print "$strSQL";
		$dbh->do($strSQL);
		$c->finish();
	}
	
	
	print "<fORM action=$ENV{SCRIPT_NAME} method=post>
		<INPUT type=hidden name=op value=rmsub>";

	my $cursor=$dbh->prepare("SELECT subid, subj, time,tid,note
				  FROM submissions
				  ORDER BY time");
	$cursor->execute;
	my ($subid, $subj, $time,$tid,$note)="";
	while(($subid, $subj, $time,$tid,$note)=$cursor->fetchrow) {
		print "<bR>$time 
			<SELECT name=note_$subid>
				<OPTION>$note
				<OPTION>Nope
				<OPTION>Wait
				<OPTION>Old!
				<OPTION>Post
				<OPTION>Quik</A>
			</SELECT>
			<INPUT type=checkbox name=$subid>	
			<A
	href=$ENV{SCRIPT_NAME}?op=viewsub\&subid=$subid>$subj&nbsp;</A>
			(<A 
	href=$ENV{SCRIPT_NAME}?op=rmsub\&subid=$subid>delete</a>)
		<b>$tid</B> ";
				
		}
	print "<P><INPUT type=submit value=\"Update\">
		  <INPUT type=submit name=op value=\"GenQuickies\"> 
	</FORM>";
	$cursor->finish;
}	

sub topiced
{
	my (%FORM)=@_;
	if($FORM{tid} ne "") {
		$dbh->do("DELETE from topics WHERE tid='$FORM{tid}'");
		$dbh->do("INSERT into topics VALUES('$FORM{tid}','$FORM{image}',
					    '$FORM{alttext}','$FORM{width}',
					    '$FORM{height}')");
	}


	print "<fORM action=$ENV{SCRIPT_NAME} method=post>
		<INPUT type=hidden name=op value=topiced>
		<SELECT name=nexttid onChange='form.submit()'>";

	if($FORM{nexttid} ne "") { print "<OPTION>$FORM{nexttid}\n"; }
	my $c=$dbh->prepare("SELECT tid FROM topics ORDER BY tid");
	$c->execute();
	while(my ($tid)=$c->fetchrow()) {
		print "<OPTION>$tid\n";
	}
	print "<OPTION value=>New</OPTION></SELECT>";

	my $c=$dbh->prepare("SELECT tid,width,height,alttext,image FROM topics
				WHERE tid='$FORM{nexttid}'");
	$c->execute;
	my ($tid,$width,$height,$alttext,$image)=$c->fetchrow();
	if($FORM{nexttid} ne "") {
     		print "<bR><IMG src=$imagedir/topics/$image alt=\"$alttext\"
                       width=$width height=$height>";
	}
	print "<bR>
		Tid<bR>
		<INPUT type=name name=tid value=$tid><bR>";



	print "	Dimensions<bR>
		<INPUT type=name name=width value=$width size=4>
		<INPUT type=name name=height value=$height size=4><bR>
		Alt Text<bR>
		<INPUT type=name name=alttext value=\"$alttext\"><bR>
		Image<bR>
		<INPUT type=name name=image value=$image><bR>
		<INPUT type=submit value=Select></FORM>
		";

}



sub blockadmin
{
	my (%FORM)=@_;
	slashmod::titlebar("98%","Block:$FORM{bid}");
	print "<fORM action=$ENV{SCRIPT_NAME} method=post>
		<INPUT type=hidden name=op value=blockadmin>
		<INPUT type=hidden name=oldbid value=$FORM{bid}>";

	my $c=$dbh->prepare("SELECT bid FROM blocks order by bid");
	$c->execute();

	print "Block Name: <SELECT name=bid onChange=\"form.submit()\">";
	if(defined $FORM{bid} and $FORM{button} ne "new") {
		print "<OPTION>$FORM{bid}";
	} else {
		print "<OPTION>";
	}

	while(my ($bid)=$c->fetchrow()) {
		print "<OPTION>$bid";
	}
	print "</SELECT><bR>";
	my $blockcontents="";
	if(defined $FORM{newbid}) {
		print "Inserted $FORM{newbid}<bR>";
		$dbh->do("INSERT into blocks VALUES('$FORM{newbid}','$FORM{block}')");
	}
	if($FORM{button} eq "new") {
		print "<INPUT type=name name=newbid value=\"\"><bR>";
	} elsif($FORM{button} eq "del") {
		print "Deleted $FORM{bid}<bR>";
		$dbh->do("DELETE from BLOCKS where bid='$FORM{bid}'");
	} else {
		print "Saving $FORM{oldbid}<bR>";
		$dbh->do("UPDATE blocks set block='$FORM{block}' 
				WHERE bid='$FORM{oldbid}' ");
	}

	if($FORM{bid} ne "" and $FORM{button} ne "new") {
		my $c=$dbh->prepare("SELECT block FROM blocks where bid='$FORM{bid}'");	
		$c->execute();
		($blockcontents)=$c->fetchrow();
	} 
	$c->finish();
	print "<TEXTAREA name=block cols=60 rows=15>$blockcontents</TEXTAREA>
		<bR><INPUT type=submit name=button value=save>
	       <INPUT type=submit name=button value=new>
	       <INPUT type=submit name=button value=del></FORM>";
}

sub listvars
{
	my $c=$dbh->prepare("SELECT name,value,description FROM vars");
	$c->execute();
	print "<fORM action=$ENV{SCRIPT_NAME} method=POST>
		<INPUT type=hidden name=op value=savevars>
	";
	while(my ($name, $value, $desc)=$c->fetchrow()) {
		print "<P><fONT color=006666><b>$name</B> $desc</FONT><bR>
			<INPUT type=name name=$name value=\"$value\">";
	}
	$c->finish();
	print "<P><fONT color=006666><b>New Variable</B></FONT><bR>
	       Name <INPUT type=name name=new_name size=30><bR>
	       Desc <INPUT type=name name=new_desc size=60><bR>
               Value <INPUT type=name name=new_value size=60><bR>
		<INPUT type=submit name=submit>
	       </FORM>
		";

	
}

sub savevars
{
	my (%FORM)=@_;
	# Update Each Var
	foreach (keys %FORM) {
		if(not /new_/ and $_ ne "op" and $_ ne "submit") { 
			slashmod::setvar($_,$FORM{$_});
			print "$_ = $FORM{$_} <bR>";	
		} 
	}
	$dbh->do("DELETE from vars where value=''");
	if($FORM{new_name} ne "") {
		print "Inserting $FORM{new_name}<bR>";
		slashmod::newvar($FORM{new_name}, $FORM{new_value}, $FORM{new_desc});
	}
}

sub listauthors
{
	my $c=$dbh->prepare("SELECT aid,name,url,email,pwd,seclev, copy,quote FROM authors");
	$c->execute();
	print "<fORM action=$ENV{SCRIPT_NAME} method=post>
	       <INPUT type=hidden name=op value=authorsave>";
	while(my ($aid, $name, $url, $email, $pwd, $seclev)=$c->fetchrow()) {
		
		slashmod::titlebar("99%",$aid,"nc");
		print "<INPUT type=name name=$aid"."_name value=\"$name\">
		       <INPUT type=name name=$aid"."_url value=\"$url\"><bR>
		       <INPUT type=password name=$aid"."_pwd value=\"$pwd\">
		       <INPUT type=name name=$aid"."_email value=\"$email\">
		       <INPUT type=name name=$aid"."_seclev value=\"$seclev\" size=6>
			<P>
			";
	}
	$c->finish();

	slashmod::titlebar("99%","New User","nc");
	print "<INPUT type=name name=new_aid value=\"\"><bR>
		       <INPUT type=name name=new_name value=\"\">
		       <INPUT type=name name=new_url value=\"\"><bR>
		       <INPUT type=name name=new_pwd value=\"\">
		       <INPUT type=name name=new_email value=\"\">
		       <INPUT type=name name=new_seclev value=\"\" size=6>";
	
	print " <P>Completely useless.  Don't bother trying to
		<INPUT type=submit value=submit name=submit>	
		</FORM>";

}

sub saveauthors
{
	my (%FORM)=@_;
	my @authors;
	# Get the list of all 
	my $c=$dbh->prepare("SELECT aid FROM authors");
	$c->execute();
	while(my ($aid)=$c->fetchrow) {
		push @authors, $aid;
	}	
	$c->finish();

	foreach my $key (@authors) {
		print "Updating $key ".$FORM{$key."_email"}."<bR>";
		my $c=$dbh->prepare("UPDATE authors SET
					pwd='".$FORM{$key."_pwd"}."',
					email='".$FORM{$key."_email"}."',
					seclev='".$FORM{$key."_seclev"}."',
					name='".$FORM{$key."_name"}."',
					url='".$FORM{$key."_url"}."',
					copy='".$FORM{$key."_copy"}."',
					quote='".$FORM{$key."_quote"}."'
					WHERE aid='$key'");
		$c->execute();
		$c->finish();
	}
	$dbh->do("DELETE from authors where seclev=0");

	# Insert Newbie
	if($FORM{new_aid} ne "") {
		$dbh->do("INSERT into authors
			VALUES('$FORM{new_aid}', '$FORM{new_name}', 
			       '$FORM{new_url}', '$FORM{new_email}',
				'','',
			       '$FORM{new_pwd}', $FORM{new_seclev})");
		print "Inserted $FORM{new_aid}\n<bR>";
	}


}

sub blocklist()
{
	my $c=$dbh->prepare("SELECT block,bid FROM blocks");
	$c->execute();
	print "<fORM action=$ENV{SCRIPT_NAME} method=POST>
		<INPUT type=hidden name=op value=\"blocksave\">";
	while(my ($block, $bid)=$c->fetchrow()) {
		slashmod::titlebar("99%","$bid");
		print "<TEXTAREA name=$bid cols=60 rows=10>$block</TEXTAREA><P>";
	}
	$c->finish();

	slashmod::titlebar("99%","New Block");
	print "Name:<INPUT type=name name=newname value=\"\"><bR>
		<TEXTAREA name=newblock cols=60 rows=10></TEXTAREA>
		<INPUT type=submit value=Save>";

}

sub blocksave()
{
	my (%FORM)=@_;
	foreach my $key (keys %FORM) {
		if($key ne "newblock" and $key ne "newname" and $key ne "op") {
			$FORM{$key}=~s/'/''/g;
			if($FORM{$key} ne "") {
				print "Updating $key<bR>";
				$dbh->do("UPDATE blocks SET
							block='$FORM{$key}'
						     WHERE bid='$key'");
			} else {
				print "Deleting $key<bR>";
				$dbh->do("DELETE from blocks
						     WHERE bid='$key'");
			}
		}
	}
	if($FORM{newname} ne "" and $FORM{newblock} ne "") {
		$FORM{newblock}=~s/'/''/g;
		$dbh->do("INSERT into blocks VALUES('$FORM{newname}',
							     '$FORM{newblock}',
							     '')");
		print "$FORM{newname} Inserted.";
	} else { print "No need to insert anything new $FORM{newname}<bR>"; }


}


sub rmstory
{
	my ($aid, $sid) =@_;
	$dbh->do("UPDATE stories 
					set writestatus=5
					WHERE
				  ('$aid'=aid OR '$aid'='CmdrTaco') AND
				  '$sid'=sid");
	slashmod::titlebar("99%","$sid will probably be deleted in 60 seconds.");

}

sub listtopics
{
	my ($seclev)=$_[0];
	my ($tid,$image, $alttext, $width, $height)="";
	my $cursor=$dbh->prepare("SELECT tid,image,alttext,width,height
				  FROM topics
				  ORDER BY tid");
	slashmod::titlebar("99%","Topic Lister");
	my $x=0;
	$cursor->execute;
	print "<TABLE width=600 align=center>";
	while(($tid,$image,$alttext,$width,$height)=$cursor->fetchrow) {
		if($x++ % 5 == 0) {
			print "</TR><TR>";
		}
		print "<TD align=center>";
		if($seclev > 1000) {
			print "<A href=$ENV{SCRIPT_NAME}?op=topiced&nexttid=$tid>";
		}
		print "	<IMG src=$imagedir/topics/$image alt=\"$alttext\"
			  width=$width height=$height border=0><bR>$tid</A></TD>";
				
	}
	print "</TR></TABLE>";
}

sub editstory
{
	my ($author,$sid,$subid,%FORM) = @_;
	my ($cursor,$thisection,$thistype);
	my ($title,$dept,$aid,$tid,$introtext,$bodytext,$time)="";
	print"	<fORM action=$ENV{SCRIPT_NAME} method=POST>";
	if(defined %FORM) { 

		$title=$FORM{title};
		$dept=$FORM{dept};
		$aid=$FORM{aid};
		$tid=$FORM{tid};
		$introtext=$FORM{introtext};
		$bodytext=$FORM{bodytext};
		$thisection=$FORM{section};
		slashmod::titlebar("99%","$title");
		$dept=~ s/ /-/gi;
                $sid=slashmod::getsid();

		print "<b>from the $dept dept.</B><bR>
			$introtext
			<P>$bodytext";

		print "<P>
			<INPUT type=submit name=op value=save>
			<INPUT type=submit name=op value=preview>
			<P>
		 	<CENTER><IMG src=$imagedir/greendot.gif width=80%
			hspace=20
			height=1></CENTER><P>
		<INPUT type=hidden name=sid value=$sid>";
		print "<INPUT type=hidden name=aid value=\"$author\">";
	}elsif(defined $subid) {
		# Format a submission for article editing.
		$cursor=$dbh->prepare("SELECT subid, email, name, subj, tid, story
				FROM submissions
				WHERE subid='$subid'");
		$cursor->execute();
		my ($subid, $email, $name);
		($subid, $email, $name, $title, $tid, $introtext)=$cursor->fetchrow();
		$introtext=~s/\n\n/<P>/gi;
		$introtext=$introtext." "; # Add a charachter so regex works
		$introtext=~s/(?!"|=)(.|\n|^)(http|ftp|gopher|telnet):\/\/(.*?)[\s]/ <A href="$2:\/\/$3"> link <\/A> /gi;

		print "<P><b>$name $email</B>
			<P>$introtext
			<P>
		[ <A href=$ENV{SCRIPT_NAME}?op=rmsub\&subid=$subid>Delete
			Submission</A> ]<bR>";

		$introtext="<A href=\"mailto:$email\">$name</A> writes
<I>\"$introtext\"</I>";
		$sid=slashmod::getsid();
		$thisection="articles";
                print "
                        <INPUT type=hidden name=aid value=\"$author\">"; 
	
	} elsif(defined $sid) {
		$thistype="edit";
		$cursor=$dbh->prepare("SELECT title,aid, dept,tid, introtext,
			bodytext,time,section FROM stories
			WHERE sid='$sid'");
		$cursor->execute;
		($title,$aid,$dept,$tid,$introtext,$bodytext,$time,$thisection)
			=$cursor->fetchrow;
		print "Article Created on $time<bR>
			<INPUT type=submit name=op value=update>
			<INPUT type=hidden name=aid value=\"$aid\">
			<INPUT type=submit name=op value=delete><bR>";
		
	} else {
		$sid=slashmod::getsid();
		$tid="news";
		$thisection="articles";
		print "
			<INPUT type=hidden name=aid value=\"$author\">";
	}
	print "
		<bR><INPUT type=hidden name=sid value=\"$sid\">
		title <INPUT type=name name=title value=\"$title\" size=50><bR>
		dept  <INPUT type=name name=dept value=\"$dept\" size=50><bR>
		topic <SELECT name=tid>
		 <OPTION>$tid
		";
	$cursor=$dbh->prepare("SELECT tid from topics ORDER BY tid");
	$cursor->execute;
	while(my ($thistid)=$cursor->fetchrow) {
		print "<OPTION>$thistid\n";
	}
		
	print "</SELECT>
	type <SELECT name=section>
		<OPTION>$thisection".getsections()."
		</SELECT><bR>

		Intro Copy<bR>
		<TEXTAREA name=introtext cols=60 rows=10>$introtext</TEXTAREA><bR>";
	if($thistype eq "edit") {
		print "<INPUT type=submit name=op value=update><bR>";
	} else { print "
		<INPUT type=submit name=op value=save>
		<INPUT type=submit name=op value=preview><bR>";
	}
	print "	Extended Copy<bR>
		<TEXTAREA name=bodytext cols=60 rows=10>$bodytext</TEXTAREA><bR>";
	if($thistype eq "edit") {
		print "<INPUT type=submit name=op value=update><bR>";
	} else { print "
		<INPUT type=submit name=op value=save>
		<INPUT type=submit name=op value=preview><bR>";
	}
}


sub getsections
{
        my ($r,$tid)="";
        my $cursor=$dbh->prepare("SELECT section from sections");
        $cursor->execute();
        while(my ($section)=$cursor->fetchrow) { $r.="<OPTION>$section"; }
        return $r;
}       

sub liststories
{
	my ($author,$first) = @_;
	my ($hits,$comments, $cursor,$sid,$aid,$title,$time)="";
	my $x=0;
	if($author eq "CmdrTaco" or $author eq "Hemos") {
		$cursor=$dbh->prepare("select hits, commentcount, sid, title, aid,
				date_format(time,\"m/d h:i\")
				FROM stories ORDER BY time DESC");
	} elsif($author eq "") {
		$cursor=$dbh->prepare("SELECT hits, commentcount, sid, title, aid,
				date_format(time,\"m/d h:i\")
				FROM stories ORDER BY time DESC");
	} else {
		$cursor=$dbh->prepare("SELECT hits, commentcount, sid, title, aid, 
				date_format(time,\"m/d h:i\")
				FROM stories 
				WHERE '$author'=aid
				ORDER BY time DESC");
	}

	$cursor->execute;
	while(($hits,$comments,$sid,$title,$aid,$time)=$cursor->fetchrow) {
		$x++;
		if($x >= $first and $x < ($first+30) ) {
			if($author eq "") {
				print "<fONT size=2><b>$x</B></FONT> <A
				href=$rootdir/article.pl?sid=$sid&mode=flat>
				$title\&nbsp;</A>
				by <b>$aid</B> ($hits/$comments) $time <bR>";
			} else {
				print "<fONT size=2><b>$x</B></FONT> <A
				href=$ENV{SCRIPT_NAME}?op=edit\&sid=$sid>
				$title\&nbsp;</A>
				by <b>$aid</b> ($hits/$comments)  $time <bR>";
			}
		}

	}
	$first+=30;
	my $left=$x-$first;
	if ($x > $first) {
	print "<P><b><A
		href=$ENV{SCRIPT_NAME}?op=list\&next=$first>$left More</A></B>";
	}
}


main();
$dbh->disconnect() unless not $dbh;
1;
<!--'"</title></head>-->

<script type="text/javascript">
//OwnerIQ
var __oiq_pct = 50;
if( __oiq_pct>=100 || Math.floor(Math.random()*100/(100-__oiq_pct)) > 0 ) {
var _oiqq = _oiqq || [];
_oiqq.push(['oiq_addPageBrand','Lycos']);
_oiqq.push(['oiq_addPageCat','Internet > Websites']);
_oiqq.push(['oiq_addPageLifecycle','Intend']);
_oiqq.push(['oiq_doTag']);
(function() {
var oiq = document.createElement('script'); oiq.type = 'text/javascript'; oiq.async = true;
oiq.src = document.location.protocol + '//px.owneriq.net/stas/s/lycosn.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(oiq, s);
})();
}
//Google Analytics
var _gaq = _gaq || [];
_gaq.push(['_setAccount','UA-21402695-19']);
_gaq.push(['_setDomainName','tripod.com']);
_gaq.push(['_setCustomVar',1,'member_name','antimicrosoft',3]);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
//Lycos Init
function getReferrer() {
var all= this.document.cookie;
if (all== '') return false;
var cookie_name = 'REFERRER=';
var start = all.lastIndexOf(cookie_name);
if (start == -1) return false;
start += cookie_name.length;
var end = all.indexOf(';', start);
if (end == -1) end = all.length;
return all.substring(start, end);
}
function getQuery() {
var rfr = getReferrer();
if (rfr == '') return false;
var q = extractQuery(rfr, 'yahoo.com', 'p=');
if (q) return q;
q = extractQuery(rfr, '', 'q=');
return q ? q : "";
}
function extractQuery(full, site, q_param) {
var start = full.lastIndexOf(site);
if (start == -1) return false;
start = full.lastIndexOf(q_param);
if (start == -1) return false;
start += q_param.length;
var end = full.indexOf('&', start);
if (end == -1) end = full.length;
return unescape(full.substring(start, end)).split(" ").join("+");
}
function generateHref(atag, template){
atag.href=template.replace('_MYURL_', window.location.href.replace('http://', '')).replace('_MYTITLE_','Check%20out%20this%20Tripod%20Member%20site!'); 
}
var lycos_ad = Array();
var lycos_onload_timer;
var cm_role = "live";
var cm_host = "tripod.lycos.com";
var cm_taxid = "/memberembedded";
var tripod_member_name = "antimicrosoft";
var tripod_member_page = "antimicrosoft/linux/admin.pl";
var tripod_ratings_hash = "1714530741:3c7c668f8859df1db7987a0c08227b20";

var lycos_ad_category = null;

var lycos_ad_remote_addr = "209.202.244.9";
var lycos_ad_www_server = "www.tripod.lycos.com";
var lycos_ad_track_small = "";
var lycos_ad_track_served = "";
var lycos_search_query = getQuery();
</script>

<script type="text/javascript" src="https://scripts.lycos.com/catman/init.js"></script>

<script type='text/javascript'>
 var googletag = googletag || {};
 googletag.cmd = googletag.cmd || [];
 (function() {
   var gads = document.createElement('script');
   gads.async = true;
   gads.type = 'text/javascript';
   var useSSL = 'https:' == document.location.protocol;
   gads.src = (useSSL ? 'https:' : 'http:') +
     '//www.googletagservices.com/tag/js/gpt.js';
   var node = document.getElementsByTagName('script')[0];
   node.parentNode.insertBefore(gads, node);
 })();
</script>

<script type='text/javascript'>
 googletag.cmd.push(function() {
   googletag.defineSlot('/95963596/TRI_300X250_dfp', [300, 250], 'div-gpt-ad-1450204159126-0').addService(googletag.pubads());
   googletag.defineSlot('/95963596/TRI_above_728x90_dfp', [728, 90], 'div-gpt-ad-1450204159126-1').addService(googletag.pubads());
   googletag.defineSlot('/95963596/TRI_below_728x90_dfp', [728, 90], 'div-gpt-ad-1450204159126-2').addService(googletag.pubads());
   googletag.pubads().enableSingleRequest();
   googletag.enableServices();
 });
</script>


<script type="text/javascript"> 
(function(isV)
{
    if( !isV )
    {
        return;
    }
    var adMgr = new AdManager();
    var lycos_prod_set = adMgr.chooseProductSet();
    var slots = ["leaderboard", "leaderboard2", "toolbar_image", "toolbar_text", "smallbox", "top_promo", "footer2", "slider"];
    var adCat = this.lycos_ad_category;
    adMgr.setForcedParam('page', (adCat && adCat.dmoz) ? adCat.dmoz : 'member');
    if (this.lycos_search_query)
    {
        adMgr.setForcedParam("keyword", this.lycos_search_query);
    } 
    else if(adCat && adCat.find_what)
    {
        adMgr.setForcedParam('keyword', adCat.find_what);
    }
    
    for (var s in slots)
    {
        var slot = slots[s];
        if (adMgr.isSlotAvailable(slot))
        {
            this.lycos_ad[slot] = adMgr.getSlot(slot);
        }
    }

    adMgr.renderHeader();
    adMgr.renderFooter();
}((function() {

var w = 0, h = 0, minimumThreshold = 300;

if (top == self)
{
    return true;
}
if (typeof(window.innerWidth) == 'number' )
{
    w = window.innerWidth;
    h = window.innerHeight;
}
else if (document.documentElement && (document.documentElement.clientWidth || document.documentElement.clientHeight))
{
    w = document.documentElement.clientWidth;
    h = document.documentElement.clientHeight;
}
else if (document.body && (document.body.clientWidth || document.body.clientHeight))
{
    w = document.body.clientWidth;
    h = document.body.clientHeight;
}
return ((w > minimumThreshold) && (h > minimumThreshold));
}())));




window.onload = function()
{
    var f = document.getElementById("FooterAd");
    var b = document.getElementsByTagName("body")[0];
    b.appendChild(f);
    f.style.display = "block";
    document.getElementById('lycosFooterAdiFrame').src = '/adm/ad/footerAd.iframe.html';
    


    
    // DOM Inj Ad
    (function(isTrellix)
    {
        var e = document.createElement('iframe');
        e.style.border = '0';
        e.style.margin = 0;
        e.style.display = 'block';
        e.style.cssFloat = 'right';
        e.style.height = '254px';
        e.style.overflow = 'hidden';
        e.style.padding = 0;
        e.style.width = '300px';


        var isBlokedByDomain = function( href )
        {
            var blockedDomains = [
                "ananyaporn13000.tripod.com",
                "xxxpornxxx.tripod.com"
            ];
            var flag = false;
            
            for( var i=0; i<blockedDomains.length; i++ )
            {
                if( href.search( blockedDomains[ i ] ) >= 0 )
                {
                    flag = true;
                }
            }
            return flag;
        }

        var getMetaContent = function( metaName )
        {
            var metas = document.getElementsByTagName('meta');
            for (i=0; i<metas.length; i++)
            { 
                if( metas[i].getAttribute("name") == metaName )
                { 
                    return metas[i].getAttribute("content"); 
                } 
            }
            return false;
        }
        
        var getCommentNodes = function(regexPattern)
        {
            var nodes = {};
            var nodesA = [];
            var preferredNodesList = ['a', 'c', 'b'];
        
            (function getNodesThatHaveComments(n, pattern)
            {
                if (n.hasChildNodes())
                {
                    if (n.tagName === 'IFRAME')
                    {
                        return false;
                    }
                    for (var i = 0; i < n.childNodes.length; i++)
                    {
                        if ((n.childNodes[i].nodeType === 8) && (pattern.test(n.childNodes[i].nodeValue)))
                        {
                            var areaName = pattern.exec(n.childNodes[i].nodeValue)[1];
                            nodes[areaName] = n;
                        }
                        else if (n.childNodes[i].nodeType === 1)
                        {
                            getNodesThatHaveComments(n.childNodes[i], pattern);
                        }
                    }
                }
            }(document.body, regexPattern));

            for (var i in preferredNodesList)
            {
                if (nodes[preferredNodesList[i]])
                {
                    if( isTrellix && nodes[preferredNodesList[i]].parentNode.parentNode.parentNode.parentNode )
                    {
                        nodesA.push(nodes[preferredNodesList[i]].parentNode.parentNode.parentNode.parentNode);
                    }
                    else
                    {
                        nodesA.push( nodes[preferredNodesList[i]] );
                    }
                }
            }
            return nodesA;
        }
        
        
        var properNode = null;
        var areaNodes = getCommentNodes( new RegExp( '^area Type="area_(\\w+)"' ) );

        for (var i = 0; i < areaNodes.length; i++)
        {
            var a = parseInt(getComputedStyle(areaNodes[i]).width);
            if ((a >= 300) && (a <= 400))
            {
                properNode = areaNodes[i];
                break;
            }
        }


        var propertyName = getMetaContent("property") || false;
        if( isTrellix && (properNode) )
        {
            e.src = '/adm/ad/injectAd.iframe.html';
            properNode.insertBefore(e, properNode.firstChild);
        }
        else if( isTrellix && !( properNode ) ) // Slap the ad eventhought there is no alocated slot
        {
            e.src = '/adm/ad/injectAd.iframe.html';
            e.style.cssFloat = 'none';
            var cdiv = document.createElement('div');
            cdiv.style = "width:300px;margin:10px auto;";
            cdiv.appendChild( e );
            b.insertBefore(cdiv, b.lastChild);
        }
        else if( !isBlokedByDomain( location.href ) )
        {
            var injF = document.createElement('iframe');
            injF.style.border = '0';
            injF.style.margin = 0;
            injF.style.display = 'block';
            injF.style.cssFloat = 'none';
            injF.style.height = '254px';
            injF.style.overflow = 'hidden';
            injF.style.padding = 0;
            injF.style.width = '300px';
            injF.src = '/adm/ad/injectAd.iframe.html';

            if( b && ( !isTrellix || ( typeof isTrellix == "undefined" ) ) ) // All other tripod props
            {
                var cdiv = document.createElement('div');
                cdiv.style = "width:300px;margin:10px auto;";
                cdiv.appendChild( injF );
                b.insertBefore(cdiv, b.lastChild);
            } 
        }
  }( document.isTrellix ));
}

</script>

<div id="tb_container" style="background:#DFDCCF; border-bottom:1px solid #393939; position:relative; z-index:999999999!important">
<!--form name="search" onSubmit="return searchit()" id='header_search' >
<input type="text" placeholder="Search" size=30 name="search2" value="">
<input type="button" value="Go!" onClick="searchit()">
</form>
<style>
form#header_search {
    width: 916px;
    margin: 0 auto 8px;
    position: relative;
}


form#header_search input {
    height: 40px;
    font-size: 14px;
    line-height: 40px;
    padding: 0 8px;
    box-sizing: border-box;
    background: #F4F2E9;
    border: 1px solid #BBB8B8;
    transition: background-color 300ms ease-out,
                color 300ms ease;
}

form#header_search input[type="text"] {
    width: 100%;
}
form#header_search input[type="text"]:focus {
    border-color: #A2D054;
    background-color: #fff;
    box-shadow: 0 0px 12px -4px #A2D054;
}



form#header_search input[type="button"] {
    position: absolute;
    top: 1px;
    right: 1px;
    opacity: 1;
    background: #DFDCCF;
    color: #463734;
    width: 125px;
    cursor: pointer;
    height: 38px;
    border: none;
}
form#header_search input[type="text"]:focus ~ input[type='button']:hover,
form#header_search input[type='button']:hover {
    background-color: #A5CE56;
    color: #fff;
}
form#header_search input[type="text"]:focus ~ input[type='button'] {
    background-color: #52AEDF;
    color: #fff;
}

</style>

<script>
function searchit(){
    
    // determine environment 
    var search_env 
    if (lycos_ad_www_server.indexOf(".pd.") > -1) {
       search_env = 'http://search51.pd.lycos.com/a/';
    } else if (lycos_ad_www_server.indexOf(".qa.") > -1) {
       search_env = 'http://search51.qa.lycos.com/a/';
    } else {
       search_env = 'http://search51.lycos.com/a/';
    }

var search_term = encodeURIComponent(document.search.search2.value)
var search_url = search_env+search_term;
window.open(search_url);

return false
}
</script-->
<style>
    .adCenterClass{margin:0 auto}
</style>
<div id="tb_ad" class="adCenterClass" style="display:block!important; overflow:hidden; width:916px;">

<div id="ad_container" style="display:block!important; float:left; width:728px ">
<script type="text/javascript">
if (typeof lycos_ad !== "undefined" && "leaderboard" in lycos_ad) {
  document.write(lycos_ad['leaderboard']);
}
</script>
</div>
</div>
</div>
<script type="text/javascript">
if (typeof lycos_ad !== "undefined" && "slider" in lycos_ad) {
  document.write(lycos_ad['slider']);
}
</script> <!-- added 7/22 -->
<div id="FooterAd" style="background:#DFDCCF; border-top:1px solid #393939; clear:both; display:none; width:100%!important; position:relative; z-index:999999!important; height:90px!important"> 
<div class="adCenterClass" style="display:block!important; overflow:hidden; width:916px;">
<div id="footerAd_container" style="display:block!important; float:left; width:728px">
<iframe id="lycosFooterAdiFrame" style="border:0; display:block; float:left; height:96px; overflow:hidden; padding:0; width:750px"></iframe>
</div>
</div>
</div>