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";
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 & 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