PHP return_datetime Examples

Example #1

File: rss_new_other.php Project: kumarsivarajan/ctrl-dock

    include $language_file;
} else {
    die("Language-File not found: " . $language_file);
}
$db = mysql_connect($mysql_server, $mysql_user, $mysql_password) or die('Could not connect: ' . mysql_error());
mysql_select_db($mysql_database, $db);
$sql = "SELECT * FROM other WHERE (other_ip_address <> '' AND ";
$sql .= "other_first_timestamp > '" . adjustdate(0, 0, -$other_detected) . "000000') ORDER BY other_ip_address";
$result = mysql_query($sql, $db);
$bgcolor = "#FFFFFF";
echo '<rss version="2.0">' . "\n";
echo '<channel>' . "\n";
echo '<image>' . "\n";
echo '<url>' . $sitename . 'favicon.ico</url>' . "\n";
echo '</image>' . "\n";
echo '<title>' . $sitename . '</title>' . "\n";
echo '<link>' . $sitebaseurl . '</link>' . "\n";
echo '<description>' . $sitedescription . '</description>' . "\n";
if ($myrow = mysql_fetch_array($result)) {
    // system.php?other=&view=other_system&
    do {
        echo '<item>' . "\n";
        echo "<guid isPermaLink=\"false\">openauditnewsys-" . $myrow["other_ip_address"] . "</guid>\n";
        echo '<title>' . $myrow["other_network_name"] . '</title>' . "\n";
        echo '<link>' . $sitebaseurl . 'system.php?other=' . $myrow["other_id"] . '&amp;view=other_system</link>' . "\n";
        echo '<description>' . $myrow["other_network_name"] . ' ' . ip_trans($myrow["other_ip_address"]) . ' ' . return_datetime($myrow["other_first_timestamp"]) . '</description>' . "\n";
        echo '</item>' . "\n";
    } while ($myrow = mysql_fetch_array($result));
}
echo '</channel>' . "\n";
echo '</rss>' . "\n";

Example #2

File: rss_new_systems.php Project: kumarsivarajan/ctrl-dock

if (is_file($language_file)) {
    include $language_file;
} else {
    die("Language-File not found: " . $language_file);
}
$db = mysql_connect($mysql_server, $mysql_user, $mysql_password) or die('Could not connect: ' . mysql_error());
mysql_select_db($mysql_database, $db);
$sql = "SELECT system_name, net_ip_address, system_uuid, system_first_timestamp FROM system ";
$sql .= "WHERE system_first_timestamp > '" . adjustdate(0, 0, -$system_detected) . "000000' ORDER BY system_name";
$result = mysql_query($sql, $db);
$bgcolor = "#FFFFFF";
echo '<rss version="2.0">' . "\n";
echo '<channel>' . "\n";
echo '<image>' . "\n";
echo '<url>' . $sitename . 'favicon.ico</url>' . "\n";
echo '</image>' . "\n";
echo '<title>' . $sitename . '</title>' . "\n";
echo '<link>' . $sitebaseurl . '</link>' . "\n";
echo '<description>' . $sitedescription . '</description>' . "\n";
if ($myrow = mysql_fetch_array($result)) {
    do {
        echo '<item>' . "\n";
        echo "<guid isPermaLink=\"false\">openauditnewsys-" . $myrow["system_uuid"] . "</guid>\n";
        echo '<title>' . $myrow["system_name"] . '</title>' . "\n";
        echo '<link>' . $sitebaseurl . 'system.php?pc=' . $myrow["system_uuid"] . '&amp;view=summary</link>' . "\n";
        echo '<description>' . $myrow["system_name"] . ' ' . ip_trans($myrow["net_ip_address"]) . ' ' . return_datetime($myrow["system_first_timestamp"]) . '</description>' . "\n";
        echo '</item>' . "\n";
    } while ($myrow = mysql_fetch_array($result));
}
echo '</channel>' . "\n";
echo '</rss>' . "\n";