Example #1
0
 while ($db->next_record()) {
     $db_appid = $db->f("appid");
     $db2 = new DB_SourceWell();
     $db2->query("SELECT * FROM history WHERE appid='{$db_appid}' ORDER BY creation_his DESC");
     $db2_exists = $db2->next_record();
     $db_modification = $db->f("modification");
     $db2_creation_his = $db2->f("creation_his");
     if ($db_modification != $db2_creation_his) {
         $timestamp = mktimestamp($db_modification);
         $title = "<b><a href=\"" . htmlentities($sess->url("appbyid.php") . $sess->add_query(array("id" => $db->f(appid)))) . "\">" . $db->f(name) . "</a> (" . $db->f(appid) . ")</b>";
         $bx->box_begin();
         $bx->box_title($title);
         $body = "Modification date: " . timestr($timestamp) . "\n";
         $timestamp = mktimestamp($db2_creation_his);
         $body .= "<br>History date: " . timestr($timestamp) . "\n";
         $bx->box_body($body);
         switch ($action) {
             case "check":
                 if ($db2_exists) {
                     $action2 = "update";
                 } else {
                     $action2 = "insert";
                 }
                 $title = "<a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("action" => $action2, "id" => $db_appid))) . "\"><img src=\"images/recycled.png\" border=0 alt=\"" . $t->translate("Update") . "\"></a>\n";
                 $bx->box_title($title);
                 break;
             case "update":
                 $db3 = new DB_SourceWell();
                 $db3->query("UPDATE software SET modification='{$db2_creation_his}' WHERE appid='{$db_appid}'");
                 $timestamp = mktimestamp($db2_creation_his);
                 $title = "Modification date is updated to " . timestr($timestamp) . "\n";
Example #2
0
require "./include/cuslib.inc";
require "./include/cmtlib.inc";
$bx = new box("100%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
$bs = new box("100%", $th_strip_frame_color, $th_strip_frame_width, $th_strip_title_bgcolor, $th_strip_title_font_color, $th_strip_title_align, $th_strip_body_bgcolor, $th_strip_body_font_color, $th_strip_body_align);
?>

<!-- content -->
<table BORDER=0 CELLSPACING=10 CELLPADDING=0 WIDTH="100%" >
<tr width=80% valign=top><td>
<?php 
$bx->box_begin();
$title = $t->translate("Open Source Enterprises, Services, Products and Solutions");
$bx->box_title($title);
$text = "<ul>\n" . "<li><b><a href=\"" . $sess->url("enterprises.php") . "\">" . $t->translate("Enterprises") . "</a></b>\n" . "<br>" . $t->translate("including Profile and Links to further Information") . "\n" . "<li><b><a href=\"" . $sess->url("contacts.php") . "\">" . $t->translate("Contacts") . "</a></b>\n" . "<br>" . $t->translate("including Address, Phone, Email, Homepage, etc.") . "\n" . "<li><b><a href=\"" . $sess->url("services.php") . "\">" . $t->translate("Services") . "</a></b>\n" . "<br>" . $t->translate("including Consulting, Education &amp; Training, Projects, Support, etc.") . "\n" . "<li><b><a href=\"" . $sess->url("products.php") . "\">" . $t->translate("Products") . "</a></b>\n" . "<br>" . $t->translate("including Software, Hardware, Books, Accessories, etc.") . "\n" . "<li><b><a href=\"" . $sess->url("solutions.php") . "\">" . $t->translate("Solutions") . "</a></b>\n" . "<br>" . $t->translate("created by Enterprises for Customers") . "\n" . "<li><b><a href=\"" . $sess->url("customers.php") . "\">" . $t->translate("Customers") . "</a></b>\n" . "<br>" . $t->translate("of Enterprises") . "\n" . "<li><b><a href=\"" . $sess->url("news.php") . "\">" . $t->translate("News") . "</a></b>\n" . "<br>" . $t->translate("provided by Enterprises") . "\n" . "<li><b><a href=\"" . $sess->url("comments.php") . "\">" . $t->translate("Comments") . "</a></b>\n" . "<br>" . $t->translate("about Enterprises by Users") . "\n" . "</ul>\n";
$bx->box_body($text);
$bx->box_end();
// News
$cnt = 0;
$query = newquery(0);
$db->query($query);
if ($db->num_rows() > 0) {
    while ($db->next_record()) {
        newshow($db, admin($db));
    }
}
?>

</td><td width=20%>
<?php 
// Recent News at the right column