'; echo "\n"; echo ""; echo ""; echo " Webcomic, Comic and Game Reviews. Your one stop shop for time wasting brought to you by Tom Lynch and Jon Rivers. "; echo "http://30extralives.com"; $count = 0; $currdate = date("Y-m-d",time()); $currdatepost = date("Y-m-d H:i:s",time()); $result = mysql_query("select ID,thedate,thetable from RSSFeed where thedate <= '".$currdatepost."' order by thedate DESC LIMIT 5;"); while($row = mysql_fetch_array($result)) { $id = $row['ID']; $date = $row['thedate']; $thetable = $row['thetable']; if($thetable == 'Posts') { $result2 = mysql_query("select pid,Text,Date,Writer,Title,tags from Posts where Date <= '".$currdatepost."' and pid = ".$id.";"); while($row2 = mysql_fetch_array($result2)) { $date = $row2['Date']; $pubDate = date("D, d M Y H:i", strtotime($row2['Date'])); $pid = $row2['pid']; $url = "http://30extralives.com/postarchive.php?id=".$pid; $text = $row2['Text']; $title = $row2['Title']; $writer = $row2['Writer']; $tags = $row2['tags'] . ","; $offset = 0; if(strpos($tags,'1,') !== false) { $offset = 250; } echo ""; echo "".$pubDate.""; echo ""; echo "".$writer.""; echo "".$url.""; echo "")+$offset)."
...

Continue Reading ".$title."...]]>"; echo ""; } } if($thetable == 'SubPosts') { $result2 = mysql_query("select pid,sid,Text,Date,Writer,Title from SubPosts where sid = ".$id.";"); while($row2 = mysql_fetch_array($result2)) { $pubDate = date("D, d M Y H:i", strtotime($row2['Date'])); $sid = $row2['sid']; $pid = $row2['pid']; $url = "http://30extralives.com/postarchive.php?id=".$pid; $text = $row2['Text']; $title = $row2['Title']; $writer = $row2['Writer']; $date2 = strtotime($row2['Date']); echo ""; echo "".$pubDate.""; echo ""; echo "".$writer.""; echo "".$url."#".$date2.""; echo "
"))."
...

Continue Reading ".$title."...]]>"; echo ""; } } if($thetable == 'Reviews') { $result2 = mysql_query("select rid,text,Date,Writer,Title,description from Reviews where rid = ".$id.";"); while($row2 = mysql_fetch_array($result2)) { $pubDate = date("D, d M Y H:i", strtotime($row2['Date'])); $rid = $row2['rid']; $url = "http://30extralives.com/reviews.php?id=".$rid; $text = $row2['text']; $title = $row2['Title']; $writer = $row2['Writer']; $desc = $row2['description']; $result3 = mysql_query("select username from members where id = ".$writer); while($row3 = mysql_fetch_array($result3)) { $writer = $row3['username']; } if(strchr($text,"www.cincity2000.com")) { $url = "http://30extralives.com/reviews.php#CC2K"; echo ""; echo "".$pubDate.""; echo ""; echo "".$writer.""; echo "".$url.""; echo "Reviews for other people! \n\r "; echo ""; } else if(strchr($text,"www.captainbluehen.com")) { $url = "http://30extralives.com/reviews.php#CBH"; echo ""; echo "".$pubDate.""; echo ""; echo "".$writer.""; echo "".$url.""; echo "Reviews for other people! \n\r "; echo ""; } else { echo ""; echo "".$pubDate.""; echo ""; echo "".$writer.""; echo "".$url.""; echo ""))."
...

Continue Reading ".$title."...]]>"; echo ""; } } } if($thetable == 'Comic30EL') { $result2 = mysql_query("select cid,Date,Title,notes from Comic30EL where Date <= '".$currdate."' and cid = ".$id.";"); while($row2 = mysql_fetch_array($result2)) { $pubDate = date("D, d M Y H:i", strtotime($row2['Date'])); $cid = $row2['cid']; $url = "http://30extralives.com/comicarchive.php?cid=".$cid; $title = $row2['Title']; $notes = $row2['notes']; echo ""; echo "".$pubDate.""; echo ""; echo "Tom"; echo "".$url.""; echo "
Click to read ".$title."!

".$notes."
]]>"; echo ""; } } } mysql_close($con); ?>