$db->query($query); /*-------------------*/ $tby->table_begin(); $tby->table_row_begin(); $tby->table_head_column_begin(); echo "<b>" . $t->translate("Name") . "</b>\n"; $tby->table_head_column_next(); echo "<b>" . $t->translate("Homepage") . "</b>\n"; $tby->table_head_column_end(); $tby->table_head_column(" "); $tby->table_head_column(" "); $tby->table_row_next(); while ($db->next_record()) { /*----------*/ if ($db->f("license_name") == "" || $db->f("license_name") == null) { $tby->table_body_column(" "); } else { $tby->table_body_column($db->f("license_name")); } if ($db->f("license_url") == "" || $db->f("license_url") == null) { $tby->table_body_column(" "); } else { $tby->table_body_column_begin($db->f("license_url")); echo "<a href=\"" . $db->f("license_url") . "\" target=\"_blank\">" . $db->f("license_url") . "</a>\n"; $tby->table_body_column_end(); } /*----------*/ $tby->table_body_column_begin(); echo "<b><a href='" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("action" => "change", "id" => $db->f("license_id"), "name" => $db->f("license_name"), "ourl" => $db->f("license_url"))) . "'>" . $t->translate("Change") . "</a></b>"; /*----------*/ $tby->table_body_column_next();
} else { // TABLE /*------------------------------------------------------- BOX tbllicense */ $bx->box_begin(); $bx->box_title($t->translate("Select Keywords of Solution")); $bx->box_body_begin(); /*---------------------------------------------------------- whole Table */ $query = "SELECT * FROM tblkeyword WHERE solutions_id='{$solu_id}' ORDER BY keyword_text"; $db->query($query); /*-------------------*/ $tby->table_begin(); $tby->table_row_begin(); while ($db->next_record()) { /*----------*/ if ($db->f("keyword_text") == "" || $db->f("keyword_text") == null) { $tby->table_body_column(" "); } else { $tby->table_body_column($db->f("keyword_text")); } /*----------*/ $tby->table_body_column_begin(); echo "<b><a href='" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("action" => "change", "id" => $db->f("keyword_id"), "solu_id" => $solu_id)) . "'>" . $t->translate("Change") . "</a></b>"; echo "</td>"; /*----------*/ $tby->table_body_column_next(); echo "<b><a href='" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("action" => "delete", "id" => $db->f("keyword_id"), "solu_id" => $solu_id)) . "'>" . $t->translate("Delete") . "</a></b>"; $tby->table_body_column_end(); $tby->table_row_end(); /*----------*/ } if ($db->num_rows() > 0) {
/*-----------------------------------------------------------------------*/ $bx->box_begin(); $bx->box_title($t->translate("Change Language")); $bx->box_body_begin(); /*-----------------------------------------------------------------------*/ echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>"; $tbw->table_begin(); $tbw->table_row_begin(); $tbw->table_body_column_begin(); echo "<b>" . $t->translate("Language") . ":</b>"; $tbw->table_body_column_next(2); echo "<input type='text' size='40' maxlength='128' name='name' value='{$name}'>"; $tbw->table_body_column_end(); // buttons $tbw->table_row_next(); $tbw->table_body_column(""); $tbw->table_body_column_begin(); echo "<input type='hidden' name='id' value='{$id}'>"; echo "<input type='hidden' name='action' value='db_change'>"; echo "<input type='submit' value='" . $t->translate("Change") . "'>"; $tbw->table_body_column_end(); echo "</form>"; /*==========*/ echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>"; $tbw->table_body_column_begin(); echo "<input type='hidden' name='action' value=''>"; echo "<input type='submit' value='" . $t->translate("Back") . "'>"; $tbw->table_body_column_end(); $tbw->table_row_end(); echo "</form>"; /*----------*/
} else { // TABLE /*------------------------------------------------------- BOX tbllicense */ $bx->box_begin(); $bx->box_title($t->translate("Provide Document of Solution")); $bx->box_body_begin(); /*---------------------------------------------------------- whole Table */ $query = "SELECT * FROM tbldocument WHERE solutions_id='{$solu_id}' ORDER BY document_title"; $db->query($query); /*-------------------*/ $tby->table_begin(); $tby->table_row_begin(); while ($db->next_record()) { /*----------*/ if ($db->f("document_title") == "" || $db->f("document_title") == null) { $tby->table_body_column(" "); } else { $tby->table_body_column($db->f("document_title")); } /*----------*/ $tby->table_body_column_begin(); echo "<b><a href='" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("action" => "change", "id" => $db->f("document_id"), "solu_id" => $solu_id)) . "'>" . $t->translate("Change") . "</a></b>"; echo "</td>"; /*----------*/ $tby->table_body_column_next(); echo "<b><a href='" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("action" => "delete", "id" => $db->f("document_id"), "solu_id" => $solu_id)) . "'>" . $t->translate("Delete") . "</a></b>"; $tby->table_body_column_end(); $tby->table_row_end(); /*----------*/ } if ($db->num_rows() > 0) {
echo "<b>" . $t->translate("Type") . "</b>\n"; $tby->table_head_column_next(); echo "<b>" . $t->translate("Name") . "</b>\n"; $tby->table_head_column_next(); echo "<b>" . $t->translate("Version") . "</b>\n"; $tby->table_head_column_next(); echo "<b>" . $t->translate("Homepage") . "</b>\n"; $tby->table_head_column_next(); echo "<b>" . $t->translate("License") . "</b>\n"; $tby->table_head_column_end(); $tby->table_head_column(" "); $tby->table_head_column(" "); $tby->table_row_next(); while ($db->next_record()) { if ($db->f("componenttype_name") == "" || $db->f("componenttype_name") == null) { $tby->table_body_column(" "); } else { $tby->table_body_column($t->translate($db->f("componenttype_name"))); } if ($db->f("component_name") == "" || $db->f("component_name") == null) { $tby->table_body_column(" "); } else { $tby->table_body_column($db->f("component_name")); } if ($db->f("component_version") == "" || $db->f("component_version") == null) { $tby->table_body_column(" "); } else { $tby->table_body_column($db->f("component_version")); } if ($db->f("component_url") == "" || $db->f("component_url") == null) { $tby->table_body_column(" ");
$bx->box_begin(); $bx->box_title($t->translate("Select Languages of Solution")); $bx->box_body_begin(); /*---------------------------------------------------------- whole Table */ $query = "SELECT * FROM tbllanguage, tblsolutionslanguage "; $query .= "WHERE solutions_id='{$solu_id}' "; $query .= "AND tblsolutionslanguage.language_id=tbllanguage.language_id "; $query .= "ORDER BY language_name"; $db->query($query); /*-------------------*/ $tby->table_begin(); $tby->table_row_begin(); while ($db->next_record()) { /*----------*/ if ($db->f("language_name") == "" || $db->f("language_name") == null) { $tby->table_body_column(" "); } else { $tby->table_body_column($t->translate($db->f("language_name"))); } /*----------*/ $tby->table_body_column_next(); echo "<b><a href='" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("action" => "change", "lang_id" => $db->f("solutionslanguage_id"), "solu_id" => $solu_id)) . "'>" . $t->translate("Change") . "</a></b>"; /*----------*/ $tby->table_body_column_next(); echo "<b><a href='" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("action" => "delete", "lang_id" => $db->f("solutionslanguage_id"), "solu_id" => $solu_id)) . "'>" . $t->translate("Delete") . "</a></b>"; $tby->table_body_column_end(); $tby->table_row_end(); /*----------*/ } $tby->table_end(); /*-------------------*/