include('pg_connect.php'); // open database connection //$connection = pg_connect($host, $user, $pass) or die ("Unable to connect!"); // select database //pg_select_db($db) or die ("Unable to select database!"); // Get the current cookie... if (isset($_COOKIE["rbname"])){ $pEditor=checkEditor($_COOKIE["rbname"]); echo $pEditor; } else { $pEditor=""; } function checkEditor($x){ $SSQL="select * from tblEditors where cookie='$x'"; $result = pg_query($SSQL) or die ("Error in query: $SSQL. " . pg_error()); $row = pg_fetch_object($result); if ($row){ return $x; } return ""; } if (isset($screamer)){ $screamer=str_replace("\"",""",$screamer); } if (isset($sdate)){ $sdate=date('Ymd',strtotime($sdate)); } if(isset($SYNCH)){ $ssql="INSERT INTO screamersbackup ( Screamer, sdate, slink, weight ) "; $ssql=$ssql . "SELECT tblscreamers.screamer, tblscreamers.sdate, tblscreamers.slink,"; $ssql=$ssql . "tblscreamers.weight "; $ssql=$ssql . "FROM tblscreamers left JOIN screamersbackup "; $ssql=$ssql . "ON screamersbackup.sdate = tblscreamers.sdate "; $ssql=$ssql . "WHERE (((screamersbackup.sdate) Is Null))"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_error()); $ssql="INSERT INTO tblscreamers ( Screamer, sdate, slink, weight ) "; $ssql=$ssql . "SELECT screamersbackup.screamer, screamersbackup.sdate, screamersbackup.slink,"; $ssql=$ssql . "screamersbackup.weight "; $ssql=$ssql . "FROM screamersbackup left JOIN tblscreamers "; $ssql=$ssql . "ON tblscreamers.sdate = screamersbackup.sdate "; $ssql=$ssql . "WHERE (((tblscreamers.sdate) Is Null))"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_error()); } if(isset($UPD)){ if($id != ""){ $ssql="update tblscreamers set screamer='" . str_replace("'","''",$screamer) . "',slink='$slink',"; $ssql=$ssql . "sdate='$sdate',weight='$weight' "; $ssql=$ssql . "where id='$UPD'"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_error()); } else { $ssql="insert into tblscreamers (screamer, slink,sdate,weight) values "; $ssql=$ssql . "('$screamer','$slink','$sdate','$weight')"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_error()); } } $id=""; $screamer=""; $slink=""; $sdate=""; $weight="1"; $ssql="select count(*) as t from tblscreamers "; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_error()); $row = pg_fetch_object($result); $RCNT=$row->t; ?>
| The Way We Were | 2001-09-10 | $PREV=""; $bgc='WHITE'; $ssql = "select tblscreamers.id,slink,screamer,weight,sdate,tblscreamers.plink,tblwotsummary.plink as tlink,chapter from tblscreamers " . "LEFT JOIN tblwotsummary ON tblscreamers.id = tblwotsummary.plink " . "order by sdate "; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); //echo $ssql; while($row = pg_fetch_object($result)){ ?>||||
| echo $row->screamer ?> | } elseif($row->weight == 2) { ?>echo $row->screamer ?> | } else { ?>echo $row->screamer ?> | } ?> if(strtoupper($_COOKIE["rbname"]) == 'FRED'){ ?> if($row->tlink ==""){ ?> echo $row->sdate ?> |
}else{ ?>
echo $row->sdate ?> |
} ?>
}else{ ?>
echo $row->sdate ?> | } ?>