$block1->form = "cuserD";
$block1->openForm("../users/viewclientuser.php#" . $block1->form . "Anchor");
if ($error != "") {
$block1->headingError($strings["errors"]);
$block1->contentError($error);
}
$block1->heading($strings["client_user"]);
$block1->openPaletteIcon();
if ($_SESSION['profilSession'] == "0" || $_SESSION['profilSession'] == "1") {
$block1->paletteIcon(0, "remove", $strings["delete"]);
$block1->paletteIcon(1, "edit", $strings["edit"]);
}
$block1->paletteIcon(2, "export", $strings["export"]);
$block1->closePaletteIcon();
$block1->openContent();
$block1->contentTitle($strings["user_details"]);
$block1->contentRow($strings["user_name"], $userDetail->mem_login[0]);
$block1->contentRow($strings["full_name"], $userDetail->mem_name[0]);
$block1->contentRow($strings["organization"], $userDetail->mem_org_name[0]);
$block1->contentRow($strings["email"], $userDetail->mem_email_work[0]);
$block1->contentRow($strings["work_phone"], $userDetail->mem_phone_work[0]);
$block1->contentRow($strings["home_phone"], $userDetail->mem_phone_home[0]);
$block1->contentRow($strings["mobile_phone"], $userDetail->mem_mobile[0]);
$block1->contentRow($strings["fax"], $userDetail->mem_fax[0]);
$block1->contentRow($strings["comments"], nl2br($userDetail->mem_comments[0]));
$block1->contentRow($strings["account_created"], createDate($userDetail->mem_created[0], $_SESSION['timezoneSession']));
$block1->contentTitle($strings["information"]);
$tmpquery = "SELECT tas.id FROM " . $tableCollab["tasks"] . " tas LEFT OUTER JOIN " . $tableCollab["projects"] . " pro ON pro.id = tas.project WHERE tas.assigned_to = '" . $userDetail->mem_id[0] . "' AND tas.status IN(0,2,3) AND pro.status IN(0,2,3)";
compt($tmpquery);
$valueTasks = $countEnregTotal;
$block1->contentRow($strings["tasks"], $valueTasks);
}
$bodyCommand = "onLoad=\"document.assignment_commentForm.acomm.focus();\"";
include '../themes/' . THEME . '/header.php';
$tmpquery = "WHERE tas.id = '{$task}'";
$taskDetail = new request();
$taskDetail->openTasks($tmpquery);
$tmpquery = "WHERE pro.id = '" . $taskDetail->tas_project[0] . "'";
$projectDetail = new request();
$projectDetail->openProjects($tmpquery);
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/listprojects.php?", $strings["projects"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../tasks/listtasks.php?project=" . $projectDetail->pro_id[0], $strings["tasks"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../tasks/viewtask.php?id=" . $taskDetail->tas_id[0], $taskDetail->tas_name[0], in));
$blockPage->itemBreadcrumbs($strings["assignment_comment"]);
$blockPage->closeBreadcrumbs();
$block1 = new block();
$block1->form = "assignment_comment";
$block1->openForm("../tasks/assignmentcomment.php?action=update&id={$id}&task={$task}&" . session_name() . "=" . session_id());
if ($error != "") {
$block1->headingError($strings["errors"]);
$block1->contentError($error);
}
$block1->heading($strings["assignment_comment"]);
$block1->openContent();
$block1->contentTitle($strings["assignment_comment_info"]);
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["task"] . " :</td><td>" . $taskDetail->tas_name[0] . "</td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["comments"] . " :</td><td><input style=\"width: 400px;\" maxlength=\"128\" size=\"44\" name=\"acomm\"></input></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"submit\" name=\"Save\" value=\"" . $strings["save"] . "\"></td></tr>";
$block1->closeContent();
$block1->closeForm();
include '../themes/' . THEME . '/footer.php';
$breadcrumbs[] = $strings["add_task_time"];
require_once "../themes/" . THEME . "/header.php";
//--- content ---
$tmpquery1 = "SELECT sum(hours) FROM " . $tableCollab['tasks_time'];
$blockPage = new block();
$blockPage->bornesNumber = "1";
// get actual time for task
$taskActualTime = new request();
$actualTime = $taskActualTime->getTaskTime($id);
$block1 = new block();
$block1->form = "saT";
$block1->openForm("../tasks/addtasktime.php?id={$id}&project=" . $projectDetail->pro_name[0] . "&action=add#" . $block1->form . "Anchor");
$block1->heading($strings["add_task_time"] . " : " . $taskDetail->tas_name[0]);
$block1->heading_close();
$block1->openContent();
$block1->contentTitle($strings["info"]);
$block1->contentRow($strings["project"], $projectDetail->pro_name[0]);
$block1->contentRow($strings["tasks"], $taskDetail->tas_name[0]);
$block1->contentRow($strings["description"], nl2br($taskDetail->tas_description[0]));
$block1->contentRow($strings["estimated_time"], $taskDetail->tas_estimated_time[0] . " " . $strings["hours"]);
$block1->contentRow($strings["actual_time"], $actualTime . " " . $strings["hours"]);
$block1->contentTitle($strings["add_task_time"]);
$tmpquery = "WHERE tea.project = '" . $projectDetail->pro_id[0] . "' ORDER BY mem.name";
$projmem = new request();
$projmem->openTeams($tmpquery);
$comptProjmem = count($projmem->tea_mem_id);
echo "\r\n\t<tr class='odd'>\r\n\t <td valign='top' class='leftvalue'>" . $strings['owner'] . " :</td>\r\n\t <td><select name='owner'>";
// get project team listing for owner select lists, default to logged user
for ($i = 0; $i < $comptProjmem; $i++) {
$clientUser = '';
if ($projmem->tea_mem_profil[$i] == '3') {
// successful insert
$msgLabel = '<b>' . $strings['success'] . '</b> : ' . $strings['hours_updated'];
}
}
$tmpquery1 = "SELECT sum(hours) FROM " . $tableCollab['meetings_time'];
$blockPage = new block();
$blockPage->bornesNumber = "1";
// get actual time for meeting
$meetingActualTime = new request();
$actualTime = $meetingActualTime->getMeetingTime($id);
$block1 = new block();
$block1->form = "saM";
$block1->openForm("../meetings/addmeetingtime.php?id={$id}&project=" . $projectDetail->pro_name[0] . "&action=add#" . $block1->form . "Anchor");
$block1->headingForm($strings["add_meeting_time"] . " : " . $meetingDetail->mee_name[0]);
$block1->openContent();
$block1->contentTitle($strings["info"]);
$block1->contentRow($strings["project"], $projectDetail->pro_name[0]);
$block1->contentRow($strings["meetings"], $meetingDetail->mee_name[0]);
$block1->contentRow($strings["me_agenda"], nl2br($meetingDetail->mee_agenda[0]));
$block1->contentRow($strings["actual_time"], $actualTime . " " . $strings["hours"]);
$block1->contentTitle($strings["add_meeting_time"]);
$tmpquery = "WHERE tea.project = '" . $projectDetail->pro_id[0] . "' ORDER BY mem.name";
$projmem = new request();
$projmem->openTeams($tmpquery);
$comptProjmem = count($projmem->tea_mem_id);
echo "\r\n<tr class='odd'>\r\n <td valign='top' class='leftvalue'>" . $strings['owner'] . " :</td>\r\n <td><select name='owner'>";
// get project team listing for owner select lists, default to logged user
for ($i = 0; $i < $comptProjmem; $i++) {
$clientUser = '';
if ($projmem->tea_mem_profil[$i] == '3') {
$clientUser = '******' . $strings['client_user'] . ')';
} else {
echo text('Internal_Error');
}
break;
}
$topblock->headingForm_close();
$topblock->block_close();
echo "<BR>";
}
$block1 = new block();
$block1->headingForm(text('administration'));
// Language Selection Form
$block1->form = "langsel";
$block1->openForm("../administration/edit_language.php?offset=" . $offset);
$block1->openContent();
$block1->contentTitle(text('language_intro'));
echo "<TR><TD ALIGN='center'>";
// build up language select list
asort($langValue);
reset($langValue);
$select = "";
foreach ($langValue as $key => $language) {
$select .= "<option value='" . $key . "'" . ($sellang == $key ? " SELECTED" : "") . ">" . $language . "</option>";
}
echo text("Choose_Language") . ": <SELECT name='sellang' onChange='submit();'>" . $select . "</SELECT>";
echo "</TD></TR>";
$block1->closeContent();
$block1->closeForm();
// Label Add Form
$block1->form = "langadd";
$block1->openForm("../administration/edit_language.php?action=add&offset=" . $offset);
if ($teamMember == "true" && $idSession == $noteDetail->note_owner[0]) {
$block1->openPaletteIcon();
$block1->paletteIcon(0, "remove", $strings["delete"]);
//$block1->paletteIcon(1,"export",$strings["export"]);
if ($sitePublish == "true") {
$block1->paletteIcon(2, "add_projectsite", $strings["add_project_site"]);
$block1->paletteIcon(3, "remove_projectsite", $strings["remove_project_site"]);
}
$block1->paletteIcon(4, "edit", $strings["edit"]);
$block1->closePaletteIcon();
}
if ($projectDetail->pro_org_id[0] == "1") {
$projectDetail->pro_org_name[0] = $strings["none"];
}
$block1->openContent();
$block1->contentTitle($strings["info"]);
$block1->contentRow($strings["project"], $blockPage->buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], in));
if ($noteDetail->note_topic[0] != "") {
$block1->contentRow($strings["topic"], $topicNote[$noteDetail->note_topic[0]]);
}
$block1->contentRow($strings["subject"], $noteDetail->note_subject[0]);
$block1->contentRow($strings["date"], $noteDetail->note_date[0]);
$block1->contentRow($strings["owner"], $blockPage->buildLink($noteDetail->note_mem_email_work[0], $noteDetail->note_mem_login[0], mail));
$block1->contentRow($strings["description"], nl2br($noteDetail->note_description[0]));
$idPublish = $noteDetail->note_published[0];
if ($sitePublish == "true") {
$block1->contentRow($strings["published"], $statusPublish[$idPublish]);
}
$block1->closeContent();
$block1->closeForm();
if ($teamMember == "true" && $idSession == $noteDetail->note_owner[0]) {
include '../includes/messages.php';
$blockPage->messagebox($msgLabel);
}
if ($enableHelpSupport == "true") {
$tmpquery = "WHERE sr.status = '0'";
$listNewRequests = new request();
$listNewRequests->openSupportRequests($tmpquery);
$comptListNewRequests = count($listNewRequests->sr_id);
$tmpquery = "WHERE sr.status = '1'";
$listOpenRequests = new request();
$listOpenRequests->openSupportRequests($tmpquery);
$comptListOpenRequests = count($listOpenRequests->sr_id);
$tmpquery = "WHERE sr.status = '2'";
$listCompleteRequests = new request();
$listCompleteRequests->openSupportRequests($tmpquery);
$comptListCompleteRequests = count($listCompleteRequests->sr_id);
$block1 = new block();
$block1->form = "help";
if ($error != "") {
$block1->headingError($strings["errors"]);
$block1->contentError($error);
}
$block1->heading($strings["support_requests"]);
$block1->openContent();
$block1->contentTitle($strings["information"]);
$block1->contentRow($strings["new_requests"], "{$comptListNewRequests} - " . $blockPage->buildLink("../support/support.php?action=new", $strings["manage_new_requests"], in) . "<br/><br/>");
$block1->contentRow($strings["open_requests"], "{$comptListOpenRequests} - " . $blockPage->buildLink("../support/support.php?action=open", $strings["manage_open_requests"], in) . "<br/><br/>");
$block1->contentRow($strings["closed_requests"], "{$comptListCompleteRequests} - " . $blockPage->buildLink("../support/support.php?action=complete", $strings["manage_closed_requests"], in) . "<br/><br/>");
$block1->closeContent();
}
include '../themes/' . THEME . '/footer.php';
$block1->openForm("");
if ($error != "") {
$block1->headingError($strings["errors"]);
$block1->contentError($error);
}
$block1->headingForm($strings["support_request"] . " : " . $requestDetail->sr_subject[0]);
if ($teamMember == "true" || $_SESSION['profilSession'] == "0") {
$block1->openPaletteIcon();
$block1->paletteIcon(0, "edit", $strings["edit_status"]);
$block1->paletteIcon(1, "remove", $strings["delete"]);
$block1->closePaletteIcon();
} else {
$block1->headingForm_close();
}
$block1->openContent();
$block1->contentTitle($strings["info"]);
$comptSupStatus = count($requestStatus);
for ($i = 0; $i < $comptSupStatus; $i++) {
if ($requestDetail->sr_status[0] == $i) {
$status = $requestStatus[$i];
}
}
$comptPri = count($priority);
for ($i = 0; $i < $comptPri; $i++) {
if ($requestDetail->sr_priority[0] == $i) {
$requestPriority = $priority[$i];
}
}
$block1->contentRow($strings["project"], buildLink("../projects/viewproject.php?id=" . $requestDetail->sr_project[0], $requestDetail->sr_pro_name[0], LINK_INSIDE));
$block1->contentRow($strings["subject"], $requestDetail->sr_subject[0]);
$block1->contentRow($strings["priority"], $requestPriority);
require_once "../themes/" . THEME . "/header.php";
// start the first block
$block1 = new block();
$block1->form = "xwbT";
$block1->openForm("../reports/projectbreakdown.php#" . $block1->form . "Anchor");
$block1->openContent();
$block1->sorting("projects", $sortingUser->sor_projects[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "pro.name", 2 => "org.name", 3 => "pro.status"));
// $query = " WHERE pro.status = 1 ";
$tmpquery = "{$query} ORDER BY {$block1->sortingValue}";
// $tmpquery = $query;
$listProjects = new request();
$listProjects->openProjects($tmpquery);
$comptListProjects = count($listProjects->pro_id);
$block0 = new block();
$block0->openContent();
$block0->contentTitle($strings["report_results"]);
if ($comptListProjects == "0") {
$block1->contentRow("", "0 " . $strings["matches"] . "<br>" . $strings["no_results_report"]);
}
if ($comptListProjects == "1") {
$block1->contentRow("", "1 " . $strings["match"]);
}
if ($comptListProjects > "1") {
$block1->contentRow("", $comptListProjects . " " . $strings["matches"]);
}
$block0->closeContent();
/*
$block1->openPaletteIcon();
$block1->paletteIcon(0,"export",$strings["export"]);
$block1->closePaletteIcon();
**
** -----------------------------------------------------------------------------
** Please refer to license, copyright, and credits in README.TXT
**
** -----------------------------------------------------------------------------
** FILE: license.php
**
** DESC: Screen: print GNU/GPL license
**
** HISTORY:
** 2003-10-23 - added new document info
** -----------------------------------------------------------------------------
** TO-DO:
**
** =============================================================================
*/
$checkSession = "false";
include_once '../includes/library.php';
$notLogged = "true";
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs(" ");
$blockPage->closeBreadcrumbs();
$block1 = new block();
$block1->heading($setTitle . " : License");
$block1->openContent();
$block1->contentTitle("License");
$block1->contentRow("", "<pre>" . recupFile("../docs/copying.txt") . "</pre>");
$block1->closeContent();
include '../themes/' . THEME . '/footer.php';
}
$blockPage = new block();
$blockPage->bornesNumber = "1";
$block1 = new block();
//Form
$block1->form = "TaskTime_{$form_type}";
$popup_addon = "";
if ($window == "popup") {
$popup_addon = "?window=popup";
}
$block1->openForm("{$form_type}.php{$popup_addon}");
//--- title ------
$block1->heading($title_type);
$block1->heading_close();
$block1->openContent();
$block1->contentTitle("Données");
//$block1->contentRow("Test", "tmp");
//*** Client ***
//$tmpquery = "WHERE tea.project = '" . $projectDetail->pro_id[0] . "' ORDER BY org.name";
$tmpquery = " ORDER BY org.name";
$clients = new request();
$clients->openOrganizations($tmpquery);
$comptClients = count($clients->org_id);
echo "\n\t<tr class='odd'>\n\t <td valign='top' class='leftvalue'>" . $strings['clients'] . " :</td>\n\t <td><select name='client_id' onChange='this.form.submit()'>";
// get Clients listing
for ($i = 0; $i < $comptClients; $i++) {
$selected = "";
if ($client_id == $clients->org_id[$i]) {
$selected = " selected";
}
echo "<option value='" . $clients->org_id[$i] . "'" . $selected . ">" . $clients->org_name[$i] . "{$clientUser}</option>";
$langDefault = 'en';
}
} else {
$langDefault = 'en';
}
} else {
$langDefault = 'en';
}
}
require_once '../languages/lang_' . $langDefault . '.php';
$block1 = new block();
$block1->headingForm('NetOffice : Error');
$block1->openContent();
if ($_GET['type'] == 'myserver') {
if ($databaseType == 'mysql') {
$block1->contentTitle('MySQL Error');
}
$block1->contentRow('', $strings['error_server']);
}
if ($_GET['type'] == 'mydatabase') {
if ($databaseType == 'mysql') {
$block1->contentTitle('MySQL Error');
}
$block1->contentRow('', $strings['error_database']);
}
if ($_GET['type'] == 'phpversion') {
$block1->contentTitle('PHP Version Error');
$block1->contentRow('', $strings['error_phpversion']);
}
$block1->closeContent();
$block1->headingForm_close();
}
}
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../administration/admin.php?", $strings["administration"], in));
$blockPage->itemBreadcrumbs($strings["edit_settings"]);
$blockPage->closeBreadcrumbs();
if ($msg != "") {
include '../includes/messages.php';
$blockPage->messagebox($msgLabel);
}
$block1 = new block();
$block1->heading($strings["edit_settings"]);
$block1->openContent();
$block1->contentTitle("General");
$block1->form = "settings";
$block1->openForm("../administration/updatesettings.php?action=generate&" . session_name() . "=" . session_id());
if (substr($ftpRoot, -1) == "/") {
$ftpRoot = substr($ftpRoot, 0, -1);
}
$tablePrefix = substr($tableCollab["projects"], 0, -8);
echo "\t<input value='{$tablePrefix}' name='tablePrefixNew' type='hidden' />\n\t\t<input value='{$databaseType}' name='databaseTypeNew' type='hidden' />\n\t\t<input value='" . MYSERVER . "' name='myserverNew' type='hidden' />\n\t\t<input value='" . MYLOGIN . "' name='myloginNew' type='hidden' />\n\t\t<input value='" . MYPASSWORD . "' name='mypasswordNew' type='hidden' />\n\t\t<input value='" . MYDATABASE . "' name='mydatabaseNew' type='hidden' />\n\t\t<input value='" . $tablePrefix . "assignments' name='table_assignments' type='hidden' />\n\t\t<input value='" . $tablePrefix . "calendar' name='table_calendar' type='hidden' />\n\t\t<input value='" . $tablePrefix . "files' name='table_files' type='hidden' />\n\t\t<input value='" . $tablePrefix . "logs' name='table_logs' type='hidden' />\n\t\t<input value='" . $tablePrefix . "members' name='table_members' type='hidden' />\n\t\t<input value='" . $tablePrefix . "notes' name='table_notes' type='hidden' />\n\t\t<input value='" . $tablePrefix . "notifications' name='table_notifications' type='hidden' />\n\t\t<input value='" . $tablePrefix . "organizations' name='table_organizations' type='hidden' />\n\t\t<input value='" . $tablePrefix . "posts' name='table_posts' type='hidden' />\n\t\t<input value='" . $tablePrefix . "projects' name='table_projects' type='hidden' />\n\t\t<input value='" . $tablePrefix . "reports' name='table_reports' type='hidden' />\n\t\t<input value='" . $tablePrefix . "sorting' name='table_sorting' type='hidden' />\n\t\t<input value='" . $tablePrefix . "tasks' name='table_tasks' type='hidden' />\n\t\t<input value='" . $tablePrefix . "teams' name='table_teams' type='hidden' />\n\t\t<input value='" . $tablePrefix . "topics' name='table_topics' type='hidden' />\n\t\t<input value='" . $tablePrefix . "phases' name='table_phases' type='hidden' />\n\t\t<input value='" . $tablePrefix . "support_requests' name='table_support_requests' type='hidden' />\n\t\t<input value='" . $tablePrefix . "support_posts' name='table_support_posts' type='hidden' />\n\t\t<input value='" . $tablePrefix . "subtasks' name='table_subtasks' type='hidden' />\n\t\t<input value='" . $tablePrefix . "updates' name='table_updates' type='hidden' />\n\t\t<input value='" . $tablePrefix . "bookmarks' name='table_bookmarks' type='hidden' />\n\t\t<input value='" . $tablePrefix . "bookmarks_categories' name='table_bookmarks_categories' type='hidden' />\n\t\t<input value='" . $tablePrefix . "invoices' name='table_invoices' type='hidden' />\n\t\t<input value='" . $tablePrefix . "invoices_items' name='table_invoices_items' type='hidden' />\n\t\t<input value='" . $tablePrefix . "services' name='table_services' type='hidden' />\n\t\t<input value='" . $tablePrefix . "newsdeskcomments' name='table_newsdeskcomments' type='hidden' />\n\t\t<input value='" . $tablePrefix . "newsdeskposts' name='table_newsdeskposts' type='hidden' />\n\n<input value=\"{$loginMethod}\" name=\"loginMethodNew\" type=\"hidden\">";
if ($version == $versionNew) {
if ($versionOld == "") {
$versionOld = $version;
}
echo "<input value=\"{$versionOld}\" name=\"versionOldNew\" type=\"hidden\">";
} else {
echo "<input value=\"{$version}\" name=\"versionOldNew\" type=\"hidden\">";
}
**
** HISTORY:
** 2003-10-23 - added new document info
** -----------------------------------------------------------------------------
** TO-DO:
** move to the render engine
**
** =============================================================================
*/
$checkSession = "true";
include_once '../includes/library.php';
if ($profilSession != "0") {
headerFunction('../general/permissiondenied.php?' . session_name() . '=' . session_id());
exit;
}
$setTitle .= " : DB Administraton";
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../administration/admin.php?", $strings["administration"], in));
$blockPage->itemBreadcrumbs($strings["database"] . " " . MYDATABASE);
$blockPage->closeBreadcrumbs();
$block1 = new block();
$block1->heading($strings["database"] . " " . MYDATABASE);
$block1->openContent();
$block1->contentTitle("Backup database");
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>\n<form method=\"post\" action=\"../includes/phppgadmin/db_dump.php\">View dump (schema) of database<br/>\n<table>\n <tr>\n <td>\n <input type=\"radio\" name=\"what\" value=\"structure\">Structure only </td>\n <td>\n <input type=\"checkbox\" name=\"drop\" value=\"1\">Add 'drop table' </td>\n <td colspan=\"2\">\n <input type=\"submit\" value=\"Go\">\n </td>\n </tr>\n <tr>\n <td>\n <input type=\"radio\" name=\"what\" value=\"data\" checked>Structure and data </td>\n <td>\n <input type=\"checkbox\" name=\"asfile\" value=\"sendit\">send </td>\n </tr>\n</table>\n<input type=\"hidden\" name=\"server\" value=\"1\">\n<input type=\"hidden\" name=\"db\" value=\"" . MYDATABASE . "\">\n<input type=\"hidden\" name=\"table\" value=\"y_updates\">\n</form>\n" . $blockPage->buildLink("http://phppgadmin.sourceforge.net", "phpPgAdmin", powered) . "</a></td></tr>";
$block1->contentTitle("Restore database from sql file");
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>\n <form method=\"post\" action=\"../includes/phpmyadmin/read_dump.php\" enctype=\"multipart/form-data\">\n <input type=\"hidden\" name=\"is_js_confirmed\" value=\"0\" />\n <input type=\"hidden\" name=\"lang\" value=\"en\" />\n <input type=\"hidden\" name=\"server\" value=\"1\" />\n <input type=\"hidden\" name=\"db\" value=\"" . MYDATABASE . "\" />\n <input type=\"hidden\" name=\"pos\" value=\"0\" />\n <input type=\"hidden\" name=\"goto\" value=\"db_details.php\" />\n <input type=\"hidden\" name=\"zero_rows\" value=\"Your SQL-query has been executed successfully\" />\n <input type=\"hidden\" name=\"prev_sql_query\" value=\"\" /><br />\n Location of sql file :<br />\n <div style=\"margin-bottom: 5px\">\n <input type=\"file\" name=\"sql_file\" /><br />\n </div>\n \n <input type=\"submit\" name=\"SQL\" value=\"Go\" />\n </form>\n" . $blockPage->buildLink("http://phpwizard.net/projects/phpMyAdmin", "phpMyAdmin", powered) . "</a>\n</td></tr>\n</table>\n</td></tr>";
$block1->closeContent();
include '../themes/' . THEME . '/footer.php';
}
header("Location: ../users/listusers.php?msg=delete");
exit;
}
//--- header -----
$breadcrumbs[] = buildLink("../administration/admin.php?", $strings["administration"], LINK_INSIDE);
$breadcrumbs[] = buildLink("../users/listusers.php?", $strings["user_management"], LINK_INSIDE);
$breadcrumbs[] = $strings["delete_users"];
require_once "../themes/" . THEME . "/header.php";
//--- content -----
$block1 = new block();
$block1->form = "user_delete";
$block1->openForm("../users/deleteusers.php?action=delete");
$block1->headingForm($strings["delete_users"]);
$block1->openContent();
$block1->contentTitle($strings["delete_following"]);
$id = str_replace("**", ",", $id);
$tmpquery = "WHERE mem.id IN({$id}) ORDER BY mem.name";
$listMembers = new request();
$listMembers->openMembers($tmpquery);
$comptListMembers = count($listMembers->mem_id);
for ($i = 0; $i < $comptListMembers; $i++) {
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>" . $listMembers->mem_login[$i] . " (" . $listMembers->mem_name[$i] . ")</td></tr>";
}
$tmpquery = "SELECT pro.id FROM " . $tableCollab["projects"] . " pro WHERE pro.owner IN({$id})";
compt($tmpquery);
$totalProjects = $countEnregTotal;
$tmpquery = "SELECT tas.id FROM " . $tableCollab["tasks"] . " tas WHERE tas.assigned_to IN({$id})";
compt($tmpquery);
$totalTasks = $countEnregTotal;
$block1->contentTitle($strings["reassignment_user"]);
$block6->openRow($listNotes->note_id[$i]);
$block6->checkboxRow($listNotes->note_id[$i]);
$block6->cellRow(buildLink("../notes/viewnote.php?id=" . $listNotes->note_id[$i], $listNotes->note_subject[$i], LINK_INSIDE));
if ($comptTopic != "0") {
$block6->cellRow($topicNote[$listNotes->note_topic[$i]]);
}
$block6->cellRow($listNotes->note_date[$i]);
$block6->cellRow(buildLink($listNotes->note_mem_email_work[$i], $listNotes->note_mem_login[$i], LINK_MAIL));
if ($sitePublish == "true") {
$block6->cellRow($statusPublish[$idPublish]);
}
$block6->closeRow();
}
$block6->closeResults();
$block6->bornesFooter("6", $blockPage->bornesNumber, "", "searchfor={$searchfor}&heading={$heading}");
$block6->closeToggle();
$block3->headingForm_close();
$block6->closeFormResults();
/*$block6->openPaletteScript();
$block6->paletteScript(0,"export","../projects/exportproject.php?languageSession=" . $_SESSION['languageSession'] . "&type=project","false,true,false",$strings["export"]);
$block6->closePaletteScript($comptListNotes,$listNotes->note_id);*/
}
$block7 = new block();
$block7->form = "search";
$block7->openForm("../search/createsearch.php?action=search");
$block7->openContent();
$block7->contentTitle($strings["enter_keywords"]);
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">* " . $strings["search_for"] . " :</td><td><input value=\"{$searchfor}\" type=\"text\" name=searchfor style=\"width: 200px;\" size=\"30\" maxlength=\"64\">\n<select name=\"heading\">\n\t\t<option selected value=\"ALL\" {$selectedAll}>" . $strings["all_content"] . "</option>\n\t\t<option value=\"notes\" {$selectedNotes}>" . $strings["notes"] . "</option>\n\t\t<option value=\"organizations\" {$selectedOrganizations}>" . $strings["organizations"] . "</option>\n\t\t<option value=\"projects\" {$selectedProjects}>" . $strings["projects"] . "</option>\n\t\t<option value=\"tasks\" {$selectedTasks}>" . $strings["tasks"] . "</option>\n\t\t<option value=\"discussions\" {$selectedDiscussions}>" . $strings["discussions"] . "</option>\n\t\t<option value=\"members\" {$selectedMembers}>" . $strings["users"] . "</option>\n</select>\n</td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"submit\" name=\"Save\" value=\"" . $strings["search"] . "\"></td></tr>";
$block7->closeContent();
$block7->closeForm();
require_once "../themes/" . THEME . "/footer.php";
$block1->form = "user_edit";
$block1->openForm("../users/edituser.php?id={$id}&action=update#" . $block1->form . "Anchor");
}
if ($error != "") {
$block1->headingError($strings["errors"]);
$block1->contentError($error);
}
if ($id == "") {
$block1->headingForm($strings["add_user"]);
}
if ($id != "") {
$block1->headingForm($strings["edit_user"] . " : " . $detailUser->mem_login[0]);
}
$block1->openContent();
if ($id == "") {
$block1->contentTitle($strings["enter_user_details"]);
}
if ($id != "") {
$block1->contentTitle($strings["edit_user_details"]);
}
$block1->contentRow($strings["user_name"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"16\" type=\"text\" name=\"un\" value=\"{$un}\"><input type=\"hidden\" name=\"unOld\" value=\"{$un}\">");
$block1->contentRow($strings["full_name"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"64\" type=\"text\" name=\"fn\" value=\"{$fn}\">");
$block1->contentRow($strings["title"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"128\" type=\"text\" name=\"tit\" value=\"{$tit}\">");
$block1->contentRow($strings["email"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"128\" type=\"text\" name=\"em\" value=\"{$em}\">");
$block1->contentRow($strings["work_phone"], "<input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"wp\" value=\"{$wp}\">");
$block1->contentRow($strings["home_phone"], "<input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"hp\" value=\"{$hp}\">");
$block1->contentRow($strings["mobile_phone"], "<input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"mp\" value=\"{$mp}\">");
$block1->contentRow($strings["fax"], "<input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"fax\" value=\"{$fax}\">");
$block1->contentRow($strings["comments"], "<textarea style=\"width: 350px; height: 60px;\" name=\"c\" cols=\"45\" rows=\"5\">{$c}</textarea>");
if ($id == "") {
$block1->contentTitle($strings["enter_password"]);
if ($error != '') {
$block1->headingError($strings['errors']);
$block1->contentError($error);
}
// case add project
if ($id == '') {
$block1->headingForm($strings['add_project']);
} else {
if ($cpy == 'true') {
$block1->headingForm($strings['copy_project'] . ' : ' . $projectDetail->pro_name[0]);
} else {
$block1->headingForm($strings['edit_project'] . ' : ' . $projectDetail->pro_name[0]);
}
}
$block1->openContent();
$block1->contentTitle($strings['details']);
echo '<tr class="odd"><td valign="top" class="leftvalue">' . $strings['name'] . ' :</td><td><input size="44" value="';
// case copy project
if ($cpy == 'true') {
echo $strings['copy_of'];
}
echo "{$pn}\" style=\"width: 400px\" name=\"pn\" maxlength=\"100\" type=\"text\"></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings['priority'] . ' :</td><td><select name="pr">';
$comptPri = count($priority);
for ($i = 0; $i < $comptPri; $i++) {
if ($projectDetail->pro_priority[0] == $i) {
echo '<option value="' . $i . '" selected>' . $priority[$i] . '</option>';
} else {
echo '<option value="' . $i . '">' . $priority[$i] . '</option>';
}
}
echo "</select></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings['description'] . " :</td><td><textarea rows=\"10\" style=\"width: 400px; height: 160px;\" name=\"d\" cols=\"47\">{$d}</textarea></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings['url_dev'] . " :</td><td><input size=\"44\" value=\"{$url_dev}\" style=\"width: 400px\" name=\"url_dev\" maxlength=\"100\" type=\"text\"></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings['url_prod'] . " :</td><td><input size=\"44\" value=\"{$url_prod}\" style=\"width: 400px\" name=\"url_prod\" maxlength=\"100\" type=\"text\"></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings['owner'] . " :</td><td><select name=\"pown\">";
<?php
// $Revision: 1.7 $
/* vim: set expandtab ts=4 sw=4 sts=4: */
/**
* $Id: license.php,v 1.7 2004/12/23 16:17:19 madbear Exp $
*
* Copyright (c) 2003 by the NetOffice developers
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
$checkSession = false;
require_once '../includes/library.php';
$pageSection = 'license';
$notLogged = true;
require_once '../themes/' . THEME . '/header.php';
$block1 = new block();
$block1->headingForm('NetOffice : License');
$block1->openContent();
$block1->contentTitle('License');
$buf = "<div class=license>";
$buf .= recupFile('../docs/copying.txt');
$buf .= "</div>";
$block1->contentRow('', $buf);
$block1->closeContent();
$block1->headingForm_close();
require_once '../themes/' . THEME . '/footer.php';
$blockPage->messagebox($msgLabel);
}
$block1 = new block();
if ($id != "") {
$block1->form = "invoice";
$block1->openForm("../invoicing/editinvoice.php?id={$id}&action=update&" . session_name() . "=" . session_id() . "#" . $block1->form . "Anchor");
}
if ($error != "") {
$block1->headingError($strings["errors"]);
$block1->contentError($error);
}
if ($id != "") {
$block1->heading($strings["edit_invoice"] . " : " . $detailInvoice->inv_id[0]);
}
$block1->openContent();
$block1->contentTitle($strings["details"]);
$block1->contentRow($strings["header_note"], "<textarea rows=\"10\" style=\"width: 400px; height: 100px;\" name=\"header_note\" cols=\"47\">{$header_note}</textarea>");
$block1->contentRow($strings["footer_note"], "<textarea rows=\"10\" style=\"width: 400px; height: 100px;\" name=\"footer_note\" cols=\"47\">{$footer_note}</textarea>");
$tmpquery = "WHERE invitem.invoice = '{$id}' AND invitem.active = '1' ORDER BY invitem.position ASC";
$listInvoicesItems = new request();
$listInvoicesItems->openInvoicesItems($tmpquery);
$comptListInvoicesItems = count($listInvoicesItems->invitem_id);
$selectStatus = "<select name=\"st\">";
$comptSta = count($invoiceStatus);
if ($detailInvoice->inv_status[0] == "0") {
$begin = "0";
} else {
$begin = "1";
}
for ($i = 0; $i < $comptListInvoicesItems; $i++) {
if ($listInvoicesItems->invitem_completed[$i] == "0") {
$breadcrumbs[] = buildLink("../clients/listclients.php?", $strings["clients"], LINK_INSIDE);
$breadcrumbs[] = buildLink("../clients/viewclient.php?id=" . $clientDetail->org_id[0], $clientDetail->org_name[0], LINK_INSIDE);
$breadcrumbs[] = $strings["add_client_user"];
$bodyCommand = "onLoad=\"document.client_user_addForm.un.focus();\"";
require_once "../themes/" . THEME . "/header.php";
//--- content ---
$block1 = new block();
$block1->form = "client_user_add";
$block1->openForm("../users/addclientuser.php?organization={$organization}&action=add");
if ($error != "") {
$block1->headingError($strings["errors"]);
$block1->contentError($error);
}
$block1->headingForm($strings["add_client_user"]);
$block1->openContent();
$block1->contentTitle($strings["enter_user_details"]);
$block1->contentRow($strings["user_name"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"16\" type=\"text\" name=\"un\" value=\"{$un}\">");
$block1->contentRow($strings["full_name"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"64\" type=\"text\" name=\"fn\" value=\"{$fn}\">");
$block1->contentRow($strings["title"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"64\" type=\"text\" name=\"tit\" value=\"{$tit}\">");
$selectOrganization = "<select name=\"clod\">";
$tmpquery = "WHERE org.id != '1' ORDER BY org.name";
$listOrganizations = new request();
$listOrganizations->openOrganizations($tmpquery);
$comptListOrganizations = count($listOrganizations->org_id);
for ($i = 0; $i < $comptListOrganizations; $i++) {
if ($organization == $listOrganizations->org_id[$i]) {
$selectOrganization .= "<option value=\"" . $listOrganizations->org_id[$i] . "\" selected>" . $listOrganizations->org_name[$i] . "</option>";
} else {
$selectOrganization .= "<option value=\"" . $listOrganizations->org_id[$i] . "\">" . $listOrganizations->org_name[$i] . "</option>";
}
}
$mail->AddAddress($userDetail->mem_email_work[0], $userDetail->mem_name[0]);
$mail->Send();
$mail->ClearAddresses();
// redirect to login page with message
header('Location: ../general/login.php?msg=emailpwd');
exit;
} else {
$error = $strings['no_email'];
}
}
$send = 'on';
}
$notLogged = true;
$bodyCommand = 'onLoad="document.sendForm.loginForm.focus();"';
require_once '../themes/' . THEME . '/header.php';
$block1 = new block();
$block1->form = 'send';
$block1->openForm('../general/sendpassword.php?action=send');
if ($error != '') {
$block1->headingError($strings['errors']);
$block1->contentError($error);
}
$block1->headingForm('NetOffice : ' . $strings['password']);
$block1->openContent();
$block1->contentTitle($strings['enter_login']);
$block1->contentRow('* ' . $strings['user_name'], '<input style="width: 125px" maxlength="16" size="16" value="' . $loginForm . '" type="text" name="loginForm">');
$block1->contentRow('', '<input type="submit" name="send" value="' . $strings['send'] . '">');
$block1->closeContent();
$block1->headingForm_close();
$block1->closeForm();
require_once '../themes/' . THEME . '/footer.php';
$block3->closeFormResults();
}
}
// Update file Block
if ($fileDetail->mat_owner[0] == $_SESSION['idSession']) {
$block4 = new block();
$block4->form = "filedetails";
echo "<a name=\"filedetailsAnchor\"></a>";
echo "<form accept-charset=\"UNKNOWN\" method=\"POST\" action=\"../meetings/viewfile.php?action=update&id=" . $fileDetail->mat_id[0] . "#filedetailsAnchor\" name=\"filedetailsForm\" enctype=\"multipart/form-data\"><input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"100000000\"><input type=\"hidden\" name=\"maxCustom\" value=\"" . $projectDetail->pro_upload_max[0] . "\">";
if ($error4 != "") {
$block4->headingError($strings["errors"]);
$block4->contentError($error4);
}
$block4->headingForm($strings["ifc_update_file"]);
$block4->openContent();
$block4->contentTitle($strings["details"]);
echo "\r\n\t<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"></td><td class=\"odd\">" . $strings["version_increm"] . "<br>\r\n\t<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n\t<tr><td align=\"right\">0.01</td><td width=\"30\" align=\"right\"><input name=\"change_file_version\" type=\"radio\" value=\"0.01\"></td></tr>\r\n\t<tr><td align=\"right\">0.1</td><td width=\"30\" align=\"right\"><input name=\"change_file_version\" type=\"radio\" value=\"0.1\" checked></td></tr>\r\n\t<tr><td align=\"right\">1.0</td><td width=\"30\" align=\"right\"><input name=\"change_file_version\" type=\"radio\" value=\"1.0\"></td></tr>\r\n\t</table>\r\n\t</td></tr>";
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["status"] . " :</td><td><select name=\"statusField\">";
$comptSta = count($statusFile);
for ($i = 0; $i < $comptSta; $i++) {
if ($i == "2") {
echo "<option value=\"{$i}\" selected>{$statusFile[$i]}</option>";
} else {
echo "<option value=\"{$i}\">{$statusFile[$i]}</option>";
}
}
echo "</select></td></tr>";
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">* " . $strings["upload"] . " :</td><td><input size=\"44\" style=\"width: 400px\" name=\"upload\" type=\"FILE\"></td></tr>\r\n\t<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["comments"] . " :</td><td><textarea rows=\"3\" style=\"width: 400px; height: 50px;\" name=\"c\" cols=\"43\">{$c}</textarea></td></tr>\r\n\t<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"SUBMIT\" value=\"" . $strings["ifc_update_file"] . "\"></td></tr>";
$block4->closeContent();
$block4->headingForm_close();
$block4->closeFormResults();
require_once "../teams/noti_removeprojectteam.php";
}
header("Location: ../projects/viewprojectsite.php?id={$project}&msg=removeClientToSite");
exit;
}
//--- header ---
$breadcrumbs[] = buildLink("../projects/listprojects.php?", $strings["projects"], LINK_INSIDE);
$breadcrumbs[] = buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], LINK_INSIDE);
$breadcrumbs[] = buildLink("../projects/viewprojectsite.php?id=" . $projectDetail->pro_id[0], $strings["project_site"], LINK_INSIDE);
$breadcrumbs[] = $strings["remove_team_client"];
require_once "../themes/" . THEME . "/header.php";
//--- content ----
$block1 = new block();
$block1->form = "crM";
$block1->openForm("../teams/deleteclientusers.php?project={$project}&action=delete&id={$id}");
$block1->headingForm($strings["remove_team_client"]);
$block1->openContent();
$block1->contentTitle($strings["remove_team_info"]);
$id = str_replace("**", ",", $id);
$tmpquery = "WHERE mem.id IN({$id}) ORDER BY mem.name";
$listMembers = new request();
$listMembers->openMembers($tmpquery);
$comptListMembers = count($listMembers->mem_id);
for ($i = 0; $i < $comptListMembers; $i++) {
$block1->contentRow("#" . $listMembers->mem_id[$i], $listMembers->mem_login[$i] . " (" . $listMembers->mem_name[$i] . ")");
}
$block1->contentRow("", "<input type=\"SUBMIT\" value=\"" . $strings["delete"] . "\"> <input type=\"BUTTON\" value=\"" . $strings["remove"] . "\" onClick=\"history.back();\">");
$block1->closeContent();
$block1->headingForm_close();
$block1->closeForm();
require_once "../themes/" . THEME . "/footer.php";
$id = str_replace('**', ',', $id);
$tmpquery1 = 'DELETE FROM ' . $tableCollab['bookmarks'] . ' WHERE id IN(' . $id . ')';
connectSql($tmpquery1);
header('Location: ../bookmarks/listbookmarks.php?view=my&msg=delete');
exit;
}
//--- header ---
$breadcrumbs[] = buildLink('../bookmarks/listbookmarks.php?view=all', $strings['bookmarks'], LINK_INSIDE);
$breadcrumbs[] = $strings['delete_bookmarks'];
$pageSection = 'bookmarks';
require_once '../themes/' . THEME . '/header.php';
//--- content ------
$block1 = new block();
$block1->form = 'saP';
$block1->openForm('../bookmarks/deletebookmarks.php?action=delete&id=' . $id);
$block1->headingForm($strings['delete_bookmarks']);
$block1->openContent();
$block1->contentTitle($strings['delete_following']);
$id = str_replace('**', ',', $id);
$tmpquery = 'WHERE boo.id IN(' . $id . ') ORDER BY boo.name';
$listBookmarks = new request();
$listBookmarks->openBookmarks($tmpquery);
$comptListBookmarks = count($listBookmarks->boo_id);
for ($i = 0; $i < $comptListBookmarks; $i++) {
$block1->contentRow('#' . $listBookmarks->boo_id[$i], $listBookmarks->boo_name[$i]);
}
$block1->contentRow('', '<input type="submit" name="delete" value="' . $strings['delete'] . '"> <input type="button" name="cancel" value="' . $strings['cancel'] . '" onClick="history.back();">');
$block1->closeContent();
$block1->headingForm_close();
$block1->closeForm();
require_once '../themes/' . THEME . '/footer.php';
$bodyCommand = 'onLoad="document.adminDForm.cn.focus();"';
$pageSection = 'admin';
require_once '../themes/' . THEME . '/header.php';
//---- content -------
$blockPage = new block();
$block1 = new block();
echo '<a name="' . $block1->form . 'Anchor"></a>';
echo '<form accept-charset="UNKNOWN" method="POST" action="../administration/mycompany.php?action=update" name="adminDForm" enctype="multipart/form-data">';
echo '<input type="hidden" name="MAX_FILE_SIZE" value="100000000">';
if ($error != '') {
$block1->headingError($strings['errors']);
$block1->contentError($error);
}
$block1->headingForm($strings['company_details']);
$block1->openContent();
$block1->contentTitle($strings['company_info']);
$block1->contentRow($strings['name'], '<input size="44" value="' . $cn . '" style="width: 400px" name="cn" maxlength="100" type="TEXT">');
$block1->contentRow($strings['address'], '<textarea rows="3" style="width: 400px; height: 50px;" name="add" cols="43">' . $add . '</textarea>');
$block1->contentRow($strings['phone'], '<input size="32" value="' . $wp . '" style="width: 250px" name="wp" maxlength="32" type="TEXT">');
$block1->contentRow($strings['url'], '<input size="44" value="' . $url . '" style="width: 400px" name="url" maxlength="2000" type="TEXT">');
$block1->contentRow($strings['email'], '<input size="44" value="' . $email . '" style="width: 400px" name="email" maxlength="2000" type="TEXT">');
$block1->contentRow($strings['comments'], '<textarea rows="3" style="width: 400px; height: 50px;" name="c" cols="43">' . $c . '</textarea>');
$block1->contentRow($strings['logo'] . $blockPage->printHelp('mycompany_logo'), '<input size="44" style="width: 400px" name="upload" type="file">');
if (file_exists('../logos_clients/1.' . $clientDetail->org_extension_logo[0])) {
$block1->contentRow('', '<img src="../logos_clients/1.' . $clientDetail->org_extension_logo[0] . '" border="0" alt="' . $clientDetail->org_name[0] . '"><input name="extensionOld" type="hidden" value="' . $clientDetail->org_extension_logo[0] . '"> <input name="logoDel" type="checkbox" value="on"> ' . $strings['delete']);
}
$block1->contentRow('', '<input type="SUBMIT" value="' . $strings['save'] . '">');
$block1->closeContent();
$block1->headingForm_close();
$block1->closeForm();
require_once '../themes/' . THEME . '/footer.php';
// $block1->paletteIcon(2,"export",$strings["export"]);
if ($sitePublish == "true") {
$block1->paletteIcon(3, "add_projectsite", $strings["add_project_site"]);
$block1->paletteIcon(4, "remove_projectsite", $strings["remove_project_site"]);
}
$block1->paletteIcon(5, "edit", $strings["edit"]);
$block1->paletteIcon(6, "timelog", $strings["loghours"]);
$block1->closePaletteIcon();
} else {
$block1->headingToggle_close();
}
if ($projectDetail->pro_org_id[0] == "1") {
$projectDetail->pro_org_name[0] = $strings["none"];
}
$block1->openContent();
$block1->contentTitle($strings["info"]);
$block1->contentRow($strings["project"], buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], LINK_INSIDE));
$block1->contentRow($strings["organization"], $projectDetail->pro_org_name[0]);
$block1->contentRow($strings["created"], createDate($meetingDetail->mee_created[0], $_SESSION['timezoneSession']));
$block1->contentRow($strings["modified"], createDate($meetingDetail->mee_modified[0], $_SESSION['timezoneSession']));
$block1->contentTitle($strings["details"]);
$block1->contentRow($strings["name"], $meetingDetail->mee_name[0]);
$block1->contentRow($strings['meeting_id'], $meetingDetail->mee_id[0]);
$idStatus = $meetingDetail->mee_status[0];
$idPriority = $meetingDetail->mee_priority[0];
$idPublish = $meetingDetail->mee_published[0];
$block1->contentRow($strings["status"], $status[$idStatus]);
$block1->contentRow($strings["priority"], $priority[$idPriority]);
if ($meetingDetail->mee_date[0] <= $date && $idStatus != 1) {
$block1->contentRow($strings["date"], "<b>" . $meetingDetail->mee_date[0] . "</b>");
} else {
}
if ($comptListProjects > "1") {
$blockPage->contentRow("", $comptListProjects . " " . $strings["matches"]);
}
$block0->closeContent();
$block0->block_close();
if ($comptListProjects != "0") {
for ($j = 0; $j < $comptListProjects; $j++) {
$projectTitle = $listProjects->pro_name[$j];
$projectId = $listProjects->pro_id[$j];
$projectPriority = $listProjects->pro_priority[$j];
$blockProject = new block();
$blockProject->headingForm(buildLink("../projects/viewproject.php?id=" . $projectId, $projectTitle, LINK_INSIDE));
$blockProject->openContent();
// correct order????
$blockProject->contentTitle($strings["details"]);
$blockProject->contentRow($strings["priority"], "<img src=\"../themes/" . THEME . "/gfx_priority/" . $projectPriority . ".gif\" alt=\"\"> " . $priority[$projectPriority]);
$blockProject->contentRow($strings["created"], createDate($listProjects->pro_created[$j], $_SESSION['timezoneSession']));
$blockProject->contentRow($strings["modified"], createDate($listProjects->pro_modified[$j], $_SESSION['timezoneSession']));
if ($listProjects->pro_org_id[$j] == "1") {
$blockProject->contentRow($strings["organization"], $strings["none"]);
} else {
$blockProject->contentRow($strings["organization"], buildLink("../clients/viewclient.php?id=" . $listProjects->pro_org_id[$j], $listProjects->pro_org_name[$j], LINK_INSIDE));
}
$blockProject->contentRow($strings["status"], $status[$listProjects->pro_status[$j]]);
$queryTask = " WHERE tas.project = '{$projectId}'";
$tmpqueryTask = "{$queryTask} ORDER BY tas.due_date";
$blockProject->closeContent();
$blockProject->heading_close();
$listTasks = new request();
$listTasks->openTasks($tmpqueryTask);
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/listprojects.php?", $strings["projects"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], in));
if ($task != "0") {
$blockPage->itemBreadcrumbs($blockPage->buildLink("../tasks/listtasks.php?project=" . $projectDetail->pro_id[0], $strings["tasks"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../tasks/viewtask.php?id=" . $taskDetail->tas_id[0], $taskDetail->tas_name[0], in));
}
$blockPage->itemBreadcrumbs($strings["unlink_files"]);
$blockPage->closeBreadcrumbs();
if ($msg != "") {
include '../includes/messages.php';
$blockPage->messagebox($msgLabel);
}
$block1 = new block();
$block1->form = "saC";
$block1->openForm("../linkedcontent/deletefiles.php?project={$project}&task={$task}&action=delete&id={$id}&sendto={$sendto}&" . session_name() . "=" . session_id());
$block1->heading($strings["unlink_files"]);
$block1->openContent();
$block1->contentTitle($strings["delete_following"]);
$id = str_replace("**", ",", $id);
$tmpquery = "WHERE fil.id IN({$id}) ORDER BY fil.name";
$listFiles = new request();
$listFiles->openFiles($tmpquery);
$comptListFiles = count($listFiles->fil_id);
for ($i = 0; $i < $comptListFiles; $i++) {
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>" . $listFiles->fil_name[$i] . "</td></tr>";
}
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"SUBMIT\" value=\"" . $strings["delete"] . "\"> <input type=\"BUTTON\" value=\"" . $strings["cancel"] . "\" onClick=\"history.back();\"></td></tr>";
$block1->closeContent();
$block1->closeForm();
include '../themes/' . THEME . '/footer.php';
exit('<br/><b>PANIC! <br/> Error during the update of the database.</b><br/> Error: ' . mssql_get_last_message());
}
}
}
headerFunction("../administration/admin.php?msg=update&" . session_name() . "=" . session_id());
}
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../administration/admin.php?", $strings["administration"], in));
$blockPage->itemBreadcrumbs($strings["edit_database"]);
$blockPage->closeBreadcrumbs();
$block1 = new block();
$block1->heading($strings["edit_database"]);
$block1->openContent();
$block1->contentTitle("Details");
$block1->form = "settings";
$block1->openForm("../administration/updatedatabase.php?action=generate&" . session_name() . "=" . session_id());
if ($version == $versionNew) {
if ($versionOld == "") {
$versionOld = $version;
}
echo "<input value=\"{$versionOld}\" name=\"versionOldNew\" type=\"hidden\">";
} else {
echo "<input value=\"{$version}\" name=\"versionOldNew\" type=\"hidden\">";
}
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>Old version {$versionOld}<br/>";
$comptUpdateDatabase = count($updateDatabase);
for ($i = 0; $i < $comptUpdateDatabase; $i++) {
if ($versionOld < $updateDatabase[$i]) {
echo "<input type=\"checkbox\" value=\"1\" name=\"dumpVersion[{$updateDatabase[$i]}]\" checked>{$updateDatabase[$i]}";
