$value){ $$key = $value; echo $key . " " . $value . "
"; } $source=$arsource; include('pg_utf_connect.php'); include "incgetstrelements.php"; include('incutfcleanup.php'); include('inccontinued.php'); include('incspamScum.php'); include('incstarringroles.php'); include('incdropimmediate.php'); include('incdatefunctions_nih.php'); //include('incpresentdate.php'); $DD=date("m/d/Y"); $today=date("m/d/Y"); $yesterday=date("m/d/Y",(strtotime($today)-(60*60*24))); $tomorrow=date("m/d/Y",(strtotime($today)+(60*60*24))); $yesterdib=date("m/d/Y H:i",strtotime($yesterday)); $tomorrow_dib=date("m/d/Y H:i",strtotime($tomorrow)); $todib=date("m/d/Y H:i",$today); $NAKED=true; // Get the current cookie... if ($_COOKIE["rbname"] != ''){ $pEditor=isEditor($_COOKIE["rbname"]); //echo $pEditor; } else { $pEditor=""; } //$ffont=getfont($pEditor); include "incfcheckeditor.php"; $CCOLOR=CheckEditor($pEditor); $ffont=getfont($pEditor); function isEditor($x){ $SSQL="select * from tbleditors where upper(cookie)='" . strtoupper($x) . "'"; $result = pg_query($SSQL) or die ("Error in query: $SSQL. " . pg_last_error()); $row = pg_fetch_object($result); if ($row){ return $x; } return ""; } if (!$NAKED){ if(!isPoster($pEditor)){ ?> 0){ $ssql="delete from tbltwar where artoriginal like '%lvrj%' "; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); } if ($DELALL != ''){ DelAll(); } if ($PubAll != ''){ PublishAll($yesterday,$tomorrow); } if ($unPubAll != ''){ unPublishAll($yesterday,$tomorrow); } if ($RDATE == ''){ $RDATE=date("Y-m-d"); } if ($rsetz != ''){ updatetindex($ID,$rsetz); } $edate=getMaxDate(); if ($ADD != ''){ //$rheadline=utfScrub($rheadline); if($rheadline==""){ $rheadline="NULL"; } else { $rheadline="'" . str_replace("'","''",$rheadline) . "'"; } //$rquote=utfScrub($rquote); if($rquote==""){ $rquote="''"; } else { $rquote="'" . str_replace("'","''",$rquote) . "'"; } $artoriginal=$asource; if($artoriginal==""){ $artoriginal="NULL"; } else { $artoriginal="'" . str_replace("'","''",$artoriginal) . "'"; } $rdate=$wDate; $RDATE=$wDate; if($rdate==""){ $rdate="'" . date("Y-m-d") . "'"; $RDATE=$wDate; } else { $rdate="'$rdate'"; } $rtime=$nTime; if($rtime==""){ $rtime="'" . date("H:i") . "'"; } else { $rtime="'$rtime'"; } $PINDEX=$tindex; if($PINDEX==""){ $PINDEX="'3'"; } else { $PINDEX="'$PINDEX'"; } if($wposter != '') $pPoster=$wposter; $DUPEENTRY=""; //Check for dupes... $ssql="select id as t from tbltwar where artoriginal=" . $artoriginal . " "; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); if (pg_num_rows($result) > 0){ $crow = pg_fetch_object($result); $DUPEENTRY="Dupe URL: "; $published='NO'; } if($DUPEENTRY==""){ //Check for dupe headlines... $ssql="select id as t from tbltwar where rbanner='" . str_replace("'","''",$wtitle) . "' and (rdate=$rdate or rdate='$yesterday')"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); if (pg_num_rows($result) > 0){ $crow = pg_fetch_object($result); $DUPEENTRY="Dupe headline: "; $published='NO'; } } $rbanner=$DUPEENTRY . $wtitle; if($rbanner==""||$rbanner=="''"){ $NOPOST=true; } else { $rbanner="'" . str_replace("'","''",$rbanner) . "'"; } $referrer="'" .$pEditor . ' ' . $aEDIT . "'"; // CONTENTS OF INCARTICLEINSERT.PHP $SSQL="select nextval('tbltwar_seq'::regclass) as i"; $result = pg_query($SSQL) or die ("Error in query: $SSQL. " . pg_last_error()); $row = pg_fetch_object($result); if ($row) $nid=$row->i; $nid++; /* $wHeadline=UTFcleanup($wHeadline); $wtitle=UTFcleanup($wtitle); $wtext=UTFcleanup($wtext); * */ $wText=str_replace("'","''",$wText); $wtitle=str_replace("'","''",$wtitle); $wHeadline=str_replace("'","''",$wHeadline); $ssql = "INSERT INTO tbltwar (id,rheadline,rbanner,rquote,artoriginal,rdate,poster, "; $ssql = $ssql . "rtime,tindex,referrer,published,file_under,tracking) values "; $ssql = $ssql . "(nextval('tbltwar_seq'),'$wHeadline','$wtitle','$wText','$asource','$wDate','$wposter', "; $ssql = $ssql . "'$nTime','$tindex',$referrer,'$published','$file_under','Poster')"; //echo $ssql; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); /*----------------------UPDATE THE POSTERS TABLE----------------------*/ $ssql="update tblposters set dtstamp='" . date("Y-m-d") . "',ip='$aEDIT' where poster='$wposter'"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_error()); } //===============================UPDATE RECORD=======================================// if ($UPD != ''){ $rheadline=$wHeadline; if($rheadline==""){ $rheadline="NULL"; } else { $rheadline="'" . str_replace("'","''",$rheadline) . "'"; } $rbanner=$wtitle; if($rbanner==""){ $NOPOST=true; } else { $rbanner="'" . str_replace("'","''",$rbanner) . "'"; } $rquote=$wText; if($rquote==""){ $rquote="''"; } else { $rquote=str_replace("--","—",$rquote); $rquote="'" . str_replace("'","''",$rquote) . "'"; $rquote=str_replace(chr(146),'',$rquote); } $artoriginal=$asource; if($artoriginal==""){ $artoriginal="NULL"; } else { $artoriginal="'" . str_replace("'","''",$artoriginal) . "'"; } $rdate=$wDate; $RDATE=$wDate; if($rdate==""){ $rdate="'" . date("Y-m-d") . "'"; $RDATE=$wDate; } else { $rdate="'$rdate'"; } $rtime=$nTime; if($rtime==""){ $rtime="'" . date("H:i") . "'"; } else { $rtime="'$rtime'"; } $PINDEX=$tindex; if($PINDEX==""){ $PINDEX="'3'"; } else { $PINDEX="'$PINDEX'"; } $referrer="'" .$pEditor . ' ' . $aEDIT . "'"; $ssql = "update tbltwar set rheadline=$rheadline,rbanner=$rbanner,"; $ssql = $ssql . "rquote=$rquote,artoriginal=$artoriginal,rdate=$rdate,poster='$wposter', "; $ssql = $ssql . "rtime=$rtime,tindex=$PINDEX,referrer=$referrer,published='$published' where id='$UPD'"; /*----------------------DON'T POST IF NO HEADLINE---------------------*/ if(!$NOPOST){ $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); } /*----------------------UPDATE THE POSTERS TABLE----------------------*/ } //*********************** STOPPED USING MYSQL VERSION AS MASTER, SO ONLY PGSQL********************************* if($E == ''){ $wTitle=""; $wHeadline=""; $wText=""; $tindex="1"; $arsource=""; $wDate = date("Y-m-d"); $nTime=date("H:i"); $wposter=""; $published=""; $ip=$_SERVER['REMOTE_ADDR']; } else { $ssql = "SELECT * from tbltwar where id=$E"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); if (pg_num_rows($result) > 0){ $crow = pg_fetch_object($result); $wHeadline=$crow->rheadline; $wTitle=$crow->rbanner; $wText=$crow->rquote; $arsource=$crow->artoriginal; $wDate=$crow->rdate; $nTime=$crow->rtime; $tindex=$crow->tindex; $wposter=$crow->poster; $ip=$crow->referrer; $published=$crow->published; } } if ($wposter=="") $wposter=$pEditor; if ($t != ""){ $wText=str_replace("%u201C",""",$t); $wText=str_replace("%u201D",""",$wText); $wText=str_replace("%u2019","'",$wText); $wText=str_replace("%u2014","‐",$wText); $wText=str_replace("%u2018","'",$wText); } ?> <> Poster
%s: %d %s",$arrIndexen[$r->tindex][1],$arrIndexen[$r->tindex][2],$arrIndexen[$r->tindex][0],$r->t," ") ; $runningtotal += $r->t; } echo ""; ?>
Refresh " . $runningtotal . " total records
...   Yesterday    Today    Tomorrow
","

"); ?>
Recent 24
Mugshots
Rogues' Gallery
Pix
All Photos

File under:
Title
Text
Source
 
            ')">
Bold Italic Underline Strike Bullet Super Blockquote Small Big Comment Sidebar Inline Link Squish Mark Edited Foto Photo GoogleMap rb Names  Organizations Locations
Post Private Comments
comments) ?>
sname . "- " . date("m/d/Y H:i",strtotime($srow->dtstamp)) ?>
0) { while($Trow = pg_fetch_object($Tresult)) { ?> rheadline != $PREV){ ?> rheadline; } } ?>
" . pg_num_rows($result) . " articles"; echo "    "; echo "Editor  O Club  "; echo "O Club [Admin]  "; echo "Whois "; ?> Thugburg 
rheadline; ?>
    rbanner)==TRUE || dropImmediate($Trow->rquote)==TRUE){ echo "DELETED " . $Trow->rbanner . " " . $Trow->referrer; dumpLocalTrash($Trow->id); }else{ ?> rbanner; ?> (tindex; ?>)
category != $lastrhdr){ ?> category; } ?>

In the Hoover...
category; ?>
. headline; ?>

0) { while($srow = pg_fetch_object($result)) { ?>
tindex == 1){ $bgc="page1"; } else if ($srow->tindex == 2){ $bgc="page2"; } else if ($srow->tindex == 5){ $bgc="page5"; } else if ($srow->tindex == 6){ $bgc="page6"; } else if ($srow->tindex == 4){ $bgc="page4"; } else { $bgc="page3"; } ?> id ?> class="">
   
rbanner; ?> rquote; ?>
rdate) . "/" . strtotime($yesterday) . "
"; ?>
id); ?> id) ?>
Posted by: poster; ?>   rdate; ?>  rtime; ?>  rtime != '00:00'){ ?> Edit    Publish   id)==""){ ?> ","br />",nl2br($qte)); $tmp=explode('
',$b); $cnt=count_all($tmp); if($cnt > 5){ ?> Page 49 Preview   rquote) ?> words   Top  tracking; ?>
Foto Touched by: referrer ?>   Delete  

= '$y' and rdate <= '$t'"; //echo $ssql; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); } function unPublishAll($y,$t){ $ssql = "update tbltwar set published='NO' where rdate = '$t'"; //echo $ssql; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); } function Publish($X){ $SSQL="update tbltwar set published='YES' WHERE id=$X "; $result = pg_query($SSQL) or die ("Error in query: $SSQL. " . pg_last_error()); //print $SSQL; //DelRecord($X); } function DelRecord($X){ $SSQL = "DELETE FROM tbltwar WHERE id=$X"; $result = pg_query($SSQL) or die ("Error in query: $SSQL. " . pg_last_error()); } function DelAll(){ $SSQL = "DELETE FROM tbltwar WHERE published != 'YES'"; $result = pg_query($SSQL) or die ("Error in query: $SSQL. " . pg_last_error()); } function updatetindex($ID,$T){ $ssql = "update tbltwar set tindex=$T where id='$ID'"; //echo $ssql; $result = pg_query($ssql) or die ("Error in query: $query. " . pg_last_error()); } function CheckEditor($X){ $ssql = "select * from tbleditors where cookie='$X'"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); $row = pg_fetch_object($result); if ($row) return $row->color; return "WHITE"; } function getMaxDate(){ $ssql = "select max(rdate) as t from tbltwar"; $result =pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); $row = pg_fetch_object($result); if ($row) return $row->t; return false; } function isPoster($X){ $ssql = "select id from tbleditors where upper(cookie)='". strtoupper($X) . "'"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); $row = pg_fetch_object($result); if ($row) return true; return false; } function isSelected($x,$y){ if($x==$y) return "Selected"; return ""; } function insertFotoLinks(){ $ssql = "select flink,fname,directory from tblfotos where directory <> 'bloids' and fcat not like '% Archive' order by fname"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); $row = pg_fetch_object($result); while($row = pg_fetch_object($result)){ ?>