 |
/
// revised 2006-01-20
require('breaking.config.php');
$breaking_normal = FALSE;
$breaking_update = FALSE;
$link = mysql_connect($mysql_host);
if ( ! $link ) die ("Couldn't connect to MySQL");
@mysql_select_db($mysql_database,$link);
// DETERMINE PERIOD_DATE, 24 HOURS AGO
$today = date('ymdHis');
$p1_query = "select date_add('" . $today . "' , interval -24 hour)";
$p1_result = mysql_query($p1_query);
while ($p_row = mysql_fetch_row($p1_result)) {
foreach ($p_row as $field) $period_date = $field;
}
// DETERMINE PERIOD_MONTH, 2 MONTHS AGO
$p2_query = "select date_add('" . $today . "' , interval -2 month)";
$p2_result = mysql_query($p2_query);
while ($p2_row = mysql_fetch_row($p2_result)) {
foreach ($p2_row as $field) $period_month = $field;
}
// SEARCH BREAKING, 24 HOURS AGO, PRIORITY 0, 3, & 4
$nonurgent_query = "select * from breaking where date >= '" . $period_date . "' and priority = '3' and visible = 'Yes' order by date desc";
$results = mysql_query($nonurgent_query);
$numrows = mysql_num_rows($results);
// DISPLAY BREAKING
if ($numrows >= 1) {
while ($a_row = mysql_fetch_array($results)) {
if ($a_row['priority'] == '0') { // Leadart priority
$head = strtoupper($a_row['headline']);
$breaking_normal .= <<» |
$head | | \r\n
NonUrgent_Bulletin;
} else if ($a_row['priority'] == '3' || $a_row['priority'] == '4') { // Routine and brief priority, respectively
$breaking_normal .= <<» |
$a_row[headline] | \r\n
NonUrgent_Standard;
}
}
}
// CLOSE MYSQL CONNECTION
mysql_close($link);
$link = mysql_connect($mysql_host);
if ( ! $link ) die ("Couldn't connect to MySQL");
@mysql_select_db($mysql_database,$link);
// DETERMINE PERIOD_DATE, 24 HOURS AGO
$today = date('ymdHis');
$p1_query = "select date_add('" . $today . "' , interval -24 hour)";
$p1_result = mysql_query($p1_query);
while ($p_row = mysql_fetch_row($p1_result)) {
foreach ($p_row as $field) $period_date = $field;
}
// DETERMINE PERIOD_MONTH, 2 MONTHS AGO
$p2_query = "select date_add('" . $today . "' , interval -2 month)";
$p2_result = mysql_query($p2_query);
while ($p2_row = mysql_fetch_row($p2_result)) {
foreach ($p2_row as $field) $period_month = $field;
}
// SEARCH UPDATES, 24 HOURS AGO, PRIORITY 0, 4
$nonurgent_query = "select * from breaking where date >= '" . $period_date . "' and priority = '4' and visible='Yes' order by date desc";
$results = mysql_query($nonurgent_query);
$numrows = mysql_num_rows($results);
// DISPLAY UPDATES
if ($numrows >= 1) {
while ($a_row = mysql_fetch_array($results)) {
if ($a_row['priority'] == '4') { // brief priority
$breaking_update .= <<» |
$a_row[headline] | \r\n
NonUrgent_Standard;
}
}
}
// CLOSE MYSQL CONNECTION
mysql_close($link);
if ($breaking_normal || $breaking_update) {
$breakingupdate = <<
 |
\r\n
Breaking_Update;
$breakingupdate .= "
$breaking_normal\r\n
$breaking_update\r\n";
$breakingupdate .= <<
\r\n
Breaking_Update2;
echo $breakingupdate;
} else {
echo "";
}
?>
Hawaii News
Features
Sports
Business
Editorial
 |
| |
/
// revised 2006-01-20
error_reporting(0);
require('breaking.config.php');
$breaking_urgent = FALSE;
// CONNECT TO MySQL
$link = mysql_connect($mysql_host);
if ( ! $link ) die ("");
@mysql_select_db($mysql_database,$link);
// DETERMINE PERIOD_DATE, 24 HOURS AGO
$today = date('ymdHis');
$p1_query = "select date_add('" . $today . "' , interval -24 hour)";
$p1_result = mysql_query($p1_query);
while ($p_row = mysql_fetch_row($p1_result)) {
foreach ($p_row as $field) $period_date = $field;
}
// DETERMINE PERIOD_MONTH, 2 MONTHS AGO
$p2_query = "select date_add('" . $today . "' , interval -2 month)";
$p2_result = mysql_query($p2_query);
while ($p2_row = mysql_fetch_row($p2_result)) {
foreach ($p2_row as $field) $period_month = $field;
}
// SEARCH URGENT, 24 HOURS AGO, PRIORITY 0, 3, & 4
$urgent_query = "select * from breaking where date >= '" . $period_date . "' and priority <= '2' and visible='Yes' order by priority, date desc";
$results = mysql_query($urgent_query);
$numrows = mysql_num_rows($results);
// DISPLAY URGENT
if ($numrows >= 1) {
while ($a_row = mysql_fetch_array($results)) {
if ($a_row['priority'] == '0' || $a_row['priority'] == '1') {
$head = $a_row['headline'];
$breaking_urgent .= <<< Urgent_Bulletin
| » |
$head | \r\n
Urgent_Bulletin;
} elseif ($a_row['priority'] == '2') {
$breaking_urgent .= <<< Urgent_Standard
| » |
$a_row[headline] | \r\n
Urgent_Standard;
}
}
}
// CLOSE MYSQL CONNECTION
mysql_close($link);
if ($breaking_urgent) {
$breakingurgent = <<
|
Breaking_Urgent;
$breakingurgent .= "
$breaking_urgent\r\n
";
$breakingurgent .= <<
Breaking_Urgent;
echo $breakingurgent;
} else {
echo "";
}
error_reporting(E_ALL);
?>
 |
June Watanabe |  |
S-B Photographers |  |
John Berger |  |
Betty Shimabukuro |  |
Erika Engle |  |
Cynthia Oi |
|
|
|
|
