error_reporting(E_ALL);
ini_set('display_errors', '0');
//ini_set('default_charset', 'utf-8');
$HL='';
$PUB='';
$DEL='';
$P49='';
$JUNKMAIL='';
$DELALL='';
$PubAll='';
$unPubAll='';
$RDATE='';
$rsetz='';
$ID='';
$ADD='';
$wHeadline='';
$wText='';
$asource='';
$wDate='';
$nTime='';
$tindex='';
$wposter='';
$wtitle='';
$aEDIT='';
$wposter='';
$UPD='';
$u='';
$n='';
$t='';
$E='';
$dibs='';
$dibtime='';
$ffont='';
$arsource='';
$bcolor="#ffffff";
foreach ($_REQUEST as $key => $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)){ ?>
exit;
} else {
$g_editor=$pEditor;
//echo $g_editor;
}
}
echo $g_editor;
//$destinationTable="tblholder";
$destinationTable="tbltwar";
$NOPOST=false;
$HEADLINER=false;
if ($HL != ''){
$HEADLINER=true;
}
if ($PUB != ''){
Publish($PUB);
}
if ($DEL != ''){
DelRecord($DEL);
}
if ($P49 != ''){
Page49($P49);
}
// Delete anything from Las Vegas Review-Journal
$ssql="select * from tbltwar where artoriginal like '%lvrj%' ";
$result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error());
$rc=pg_num_rows($result);
if($rc > 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);
}
?>
/*
*
*
*
*
*
*
* Begin HTML Head
*
*
*
*
*
*
*
*/
?>
<>
//include("inc_fontlinks.php"); ?>
include('incnamelinks.php');
include('incjscripts.txt');
?>
//include "incfontz.php" ?>
Poster
/*
*
*
*
*
*
*
* Begin HTML Body
*
*
*
*
*
*
*
*/
?>
Refresh
$runningtotal=0;
$arrIndexen[1][0]="WoT";
$arrIndexen[1][1]="Navy";
$arrIndexen[1][2]="White";
$arrIndexen[2][0]="WoT Background";
$arrIndexen[2][1]="Maroon";
$arrIndexen[2][2]="White";
$arrIndexen[3][0]="Non-WoT";
$arrIndexen[3][1]="Green";
$arrIndexen[3][2]="White";
$arrIndexen[4][0]="Opinion";
$arrIndexen[4][1]="Orange";
$arrIndexen[4][2]="Black";
$arrIndexen[5][0]="Russia-Former Soviet Union";
$arrIndexen[5][1]="#33ccff";
$arrIndexen[5][2]="Black";
$arrIndexen[6][0]="Seedy Pols";
$arrIndexen[6][1]="Olive";
$arrIndexen[6][2]="White";
$ssql="select count(*) as t,tindex from tbltwar where upper(published)='NO' or published is null group by tindex order by tindex";
$res = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error());
while($r = pg_fetch_object($res)){
printf("%s: %d %s ",$arrIndexen[$r->tindex][1],$arrIndexen[$r->tindex][2],$arrIndexen[$r->tindex][0],$r->t," ") ;
$runningtotal += $r->t;
}
echo "" . $runningtotal . " total records ";
?>
//);
$n=date("N",strtotime($today));
?>
$yesterdate=date('m/d/Y',strtotime($yesterday)); ?>
... Yesterday echo date("l m/d/Y",strtotime($yesterdate)) ?>
Today echo date("l m/d/Y",strtotime($today)) ?>
Tomorrow echo date("l m/d/Y",strtotime($tomorrow)) ?>
/* *************************************************************************************************
Pull the private O Club entries for the past seven days and display them
************************************************************************************************* */
$ssql = "select tblbulletinboard.* from tblbulletinboard where sprivate='YES' ";
$ssql = $ssql . "order by id desc limit 25";
$sresult = pg_query($ssql) or die ("Error in query: $query. " . pg_last_error());
while ($srow = pg_fetch_object($sresult)) { ?>
print nl2br($srow->comments) ?>
print $srow->sname . "- " . date("m/d/Y H:i",strtotime($srow->dtstamp)) ?>
}
?>
//******************************************************************************
// Handle Posts
//******************************************************************************
$ssql="select tbltwar.*,category ";
$ssql = $ssql . "from tbltwar
left join tblcategories on category=rheadline
where published is null or published='NO'";
$ssql = $ssql . "order by _order,id desc";
//print $ssql;
$result = pg_query($ssql) or die ("Error in select query: $query. " . pg_last_error());
echo "" . pg_num_rows($result) . " articles ";
echo " ";
echo "Editor O Club ";
echo "O Club [Admin] ";
echo "Whois ";
?>
Thugburg
$PREV="";
$ssql="select rheadline,rdate,rbanner,tbltwar.id,tindex,rquote,file_under,referrer ";
$ssql = $ssql . "from tbltwar
left join tblcategories on category=rheadline
where published is null or published='NO'";
$ssql = $ssql . "order by _order, tbltwar.id desc";
$Tresult = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error());
if (pg_num_rows($result) > 0)
{
while($Trow = pg_fetch_object($Tresult))
{ ?>
if ($Trow->rheadline != $PREV){ ?>
echo $Trow->rheadline; ?>
} ?>
if(dropImmediateHL($Trow->rbanner)==TRUE || dropImmediate($Trow->rquote)==TRUE){
echo "DELETED " . $Trow->rbanner . " " . $Trow->referrer;
dumpLocalTrash($Trow->id);
}else{ ?>
echo $Trow->rbanner; ?> ( echo $Trow->tindex; ?>)
}
$PREV=$Trow->rheadline;
}
}
?>
$ctr=1; ?>
In the Hoover...
$ssql="select headline,slink,tblcategories.category
from tblheadlinez
inner join tblcategories on tblheadlinez.category=tblcategories.category
order by tblcategories.category, tblheadlinez.id desc";
$result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error());
//echo $ssql;
$lasthdr="";
while($row = pg_fetch_object($result)){ ?>
if($row->category != $lastrhdr){ ?>
echo $row->category; ?>
$lastrhdr=$row->category;
} ?>
echo $ctr++ ?>. echo $row->headline; ?>
} ?>
function dumpLocalTrash($id){
$ssql="delete from tbltwar where id=$id";
$scumresult = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error());
}
?>
$bgc="white";
//Have to make a second trip to the database because we just deleted any DROPIMMEDIATES
$ssql="select tbltwar.*,_order
from tbltwar
left join tblcategories on category=rheadline
where published is null or published='NO'
order by _order, tbltwar.id DESC nulls first";
$result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error());
//echo $ssql;
if (pg_num_rows($result) > 0)
{
while($srow = pg_fetch_object($result))
{
?>
if ($srow->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=" echo $bgc ?>">
echo $srow->rheadline ?>
$ssql = "SELECT * from tblcategories order by _order";
$Cresult = pg_query($ssql) or die ("Error in query: $ssql. " . pg_error());
if (pg_num_rows($Cresult) > 0)
{
while($Crow = pg_fetch_object($Cresult))
{ ?>
echo $Crow->category ?>
}
}?>
tindex,1) ?>>WoT Operations
tindex,2) ?>>WoT Background
tindex,3) ?>>Non-WoT
tindex,4) ?>>Opinion
tindex,5) ?>>Russia-Former Soviet Union
tindex,6) ?>>Seedy Politicians
include ("incFileUnder.php"); ?>
echo $srow->rbanner; ?>
$qte=$srow->rquote; ?>
//echo strtotime($srow->rdate) . "/" . strtotime($yesterday) . " "; ?>
echo nl2br ($qte); ?> echo isContinued($srow->id); ?>
StarringRoles($srow->id) ?>
Posted by: echo $srow->poster; ?>
echo $srow->rdate; ?>
echo $srow->rtime; ?>
if($srow->rtime != '00:00'){ ?>
} ?>
Edit
Publish
// if the item hasn't been continued, and it's longer than 5 paragraphs, offer to Page 49 it
if (isContinued($srow->id)==""){ ?>
$b=str_replace("br>","br />",nl2br($qte));
$tmp=explode(' ',$b);
$cnt=count_all($tmp);
if($cnt > 5){
?>
Page 49
}
} ?>
Preview
echo wordcount($srow->rquote) ?> words
Top echo $srow->tracking; ?>
Foto Touched by:
echo $srow->referrer ?>
Delete
}
}
?>