' . mysql_errno() . ': ' . mysql_error() . '
'; $status = false; } else if(!@mysql_select_db($db_name)) { echo '' . mysql_errno() . ': ' . mysql_error() . '
'; $status = false; } return $status; } function timeStamp($ts) { return substr($ts, 0, 4) . '-' . substr($ts, 4, 2) . '-' . substr($ts, 6, 2) . ' ' . substr($ts, 8, 2) . ':' . substr($ts, 10, 2) . ':' . substr($ts, 12); } //======================================================================================================== // Main //======================================================================================================== if(db_connect()) { $error = ''; header('Cache-control: private, no-cache, must-revalidate'); header('Expires: Sat, 01 Jan 2000 00:00:00 GMT'); header('Date: Sat, 01 Jan 2000 00:00:00 GMT'); header('Pragma: no-cache'); ?> Output '; $sql = "SELECT $fld_id FROM $tbl_name ORDER BY $fld_timestamp DESC LIMIT 1"; $id = mysql_result(mysql_query($sql), $fld_id) - $boxEntries; if($id > 0) { $sql = "DELETE FROM $tbl_name WHERE $fld_id<=$id"; if(!mysql_query($sql)) $error .= mysql_error() . '
'; } } ?>
$error
"; ?> "; } $sql = "SELECT * FROM $tbl_name ORDER BY $fld_timestamp DESC LIMIT $boxEntries"; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { $tstamp = timeStamp($row[$fld_timestamp]); $name = $row[$fld_name] ? htmlentities($row[$fld_name]) : '???'; $email = $row[$fld_email]; $text = htmlentities($row[$fld_text]); $text = str_replace($sm_code, $sm_img, $text); $bgcolor = ($bgcolor != '#FFFFFF') ? '#FFFFFF' : '#F6F6F6'; ?> > >
'; ?> :'; ?>