$myfilter = " and (to_address=\"" . $luser . "\" or from_address=\"" . $luser . "\") "; // I don't know why the following line causes things to puke. :-( // $myfilter = " and (timestamp>(now() - interval 3 day)) and (to_address=\"".$luser."\" or from_address=\"".$luser."\") "; $refresh = luser_html_start("Message Listing"); $dbh = DB::connect(DB_DSN, true); if (DB::isError($dbh)) { die($dbh->getMessage()); } $sth = $dbh->query("\n SELECT\n DATE_FORMAT(timestamp, '%d/%m/%y %H:%i:%s') AS datetime,\n id AS id,\n from_address,\n to_address,\n subject,\n size,\n CASE WHEN isspam=1 THEN 'Y' ELSE 'N' END AS isspam,\n CASE WHEN ishighspam=1 THEN 'Y' ELSE 'N' END AS ishighspam,\n CASE WHEN isrblspam=1 THEN 'Y' ELSE 'N' END AS isrblspam,\n CASE WHEN spamwhitelisted=1 THEN 'Y' ELSE 'N' END AS iswhitelisted,\n sascore,\n CASE WHEN virusinfected=1 THEN 'Y' ELSE 'N' END AS virusinfected,\n CASE WHEN nameinfected=1 THEN 'Y' ELSE 'N' END AS nameinfected,\n CASE WHEN otherinfected=1 THEN 'Y' ELSE 'N' END AS otherinfected,\n report\n FROM\n maillog\n WHERE\n 1=1\n " . $myfilter . "\n ORDER BY \n date DESC, time DESC\n") or die("Error executing query: " . mysql_error()); //"); // or die("Error executing query: ".mysql_error()); // and to_address='*****@*****.**' //".$_SESSION["filter"]->CreateSQL()." // print_r($sth); $offset = intval($_REQUEST['offset']); $per_page = MAX_RESULTS; $pager = new DB_Pager($sth, $offset, $per_page); $data = $pager->build(); // Display table headings echo "<TABLE CLASS=\"mail\" BORDER=0 WIDTH=100% CELLSPACING=2 CELLPADDING=2>\n"; echo " <THEAD>\n"; // Previous page link // tgf - Don't show a Prev link on the first page. if ($data['current'] != '1') { printf('<TH ALIGN="CENTER"><A HREF="%s?offset=%d"><<Prev</A></TH>', sanitizeInput($_SERVER['PHP_SELF']), $data['prev']); } else { printf('<TH ALIGN="CENTER"> </TH>'); } echo " <TH COLSPAN=6>Showing records " . $data['from'] . " to " . $data['to'] . " of " . $data['numrows'] . "\n"; // Next page link // tgf - Don't show a Next link on the last page. if ($data['current'] != $data['numpages']) {
echo html_header("Proof Card"); echo '<div align="center"> ' . $render . ' </div>'; } elseif ($_GET["action"] == "Mistakes") { $intPropID = $_GET["propID"]; $sql = "SELECT * FROM property, area, state_of_trade, proptype, branch WHERE property.prop_ID = " . $intPropID . " AND "; $sql .= " property.area_id = area.area_ID AND property.state_of_trade_id = state_of_trade.state_ID "; $sql .= " AND property.type_id = proptype.type_ID "; $sql .= " AND property.Branch = branch.Branch_ID"; if (DB::isError($res = $con->query($sql))) { die(DB::errorMessage($res)); } $from = isset($_GET['from']) ? (int) $_GET['from'] : 0; $limit = 1; $pager = new DB_Pager($res, $from, $limit); $data = $pager->build(); if (DB::isError($data)) { die(DB::errorMessage($data)); } while ($row = $pager->fetchRow(DB_FETCHMODE_ASSOC)) { $pc = explode(" ", $row['Postcode']); $intOSX = $row["osx"]; $intOSY = $row["osy"]; $SQLTrans = "SELECT places.place_ID, places.place_type, places.place_title, places.place_desc, places.place_osx, places.place_osy, pl_type.pl_type_id, pl_type_title FROM places, pl_type WHERE (places.place_type = 1 OR places.place_type = 2) AND places.place_type = pl_type.pl_type_id ORDER BY sqrt((abs(places.place_osx-" . $intOSX . ")*abs(places.place_osx-" . $intOSX . "))+(abs(places.place_osy-" . $intOSY . ")*abs(places.place_osy-" . $intOSY . "))) LIMIT 1"; $rowTrans = $con->getRow($SQLTrans, DB_FETCHMODE_ASSOC); if (DB::isError($resTrans = $con->query($SQLTrans))) { die(DB::errorMessage($resTrans)); } $intTransType = $rowTrans['place_type']; $strTransType = $rowTrans['pl_type_title'];
function get($query, $from = 0, $class = "") { $res = $this->db->query($query); $pager = new DB_Pager($res, $from, $this->limit); $data = $pager->build(); if (DB::isError($data)) { return $this->raiseError(DB::errorMessage($data)); } if (!$data) { //return $this->raiseError("There were no results"); return $this->str_emptyresult; } if ($this->heading) { $this->table_Header($class); } $this->table_Body($pager, $from, $class); $this->table_Footer($class); if ($class) { $row1Style = array("class" => $class); if ($this->alternate_background) { $row2Style = array("class" => $class . $this->alternate_background_style); $this->table->altRowAttributes(1, $row1Style, $row2Style); } } return $this->meta_head($data) . "<br>" . $this->get_nav($data) . $this->table->toHTML() . $this->get_nav($data); }