$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();
/*-------------------*/
