$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';
if ($_SESSION['profilSession'] == 1 or $_SESSION['profilSession'] == 5 or $_SESSION['idSession'] == $listMeetingTimes->mti_owner[$i]) { $block2->openRow($listMeetingTimes->mti_id[$i]); $block2->checkboxRow($listMeetingTimes->mti_id[$i], 'true'); $block2->cellRow($listMeetingTimes->mti_mem_name[$i]); $block2->cellRow($listMeetingTimes->mti_date[$i]); $block2->cellRow($listMeetingTimes->mti_hours[$i]); $block2->cellRow($listMeetingTimes->mti_created[$i]); $block2->cellRow($listMeetingTimes->mti_modified[$i]); // truncate large comments to keep the display clean $comments = $listMeetingTimes->mti_comments[$i]; $lenComm = 40; if (strLen($comments) > $lenComm) { $comments = substr($listMeetingTimes->mti_comments[$i], 0, $lenComm) . ' ...'; } $block2->cellRow($comments); $block2->closeRow(); } } $block2->closeResults(); $block2->bornesFooter("1", $blockPage->bornesNumber, "", "id={$id}"); } else { $block2->noresults(); } $block2->closeContent(); $block2->headingForm_close(); $block2->closeFormResults(); $block2->openPaletteScript(); $block2->paletteScript(0, "remove", "../meetings/deletemeetingtime.php?meeting={$id}", "false,true,true", $strings["delete"]); $block2->paletteScript(1, "edit", "../meetings/editmeetingtime.php?meeting={$id}", "false,true,false", $strings["edit"]); $block2->closePaletteScript($comptListMeetingTimes, $listMeetingTimes->mti_id); require_once "../themes/" . THEME . "/footer.php";
} // 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 "../themes/" . THEME . "/footer.php";
$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); $comptListTasks = count($listTasks->tas_id); $blockProject->openResults("false"); $blockProject->labels($labels = array(0 => $strings["task"], 1 => $strings["priority"], 2 => $strings["status"], 3 => $strings["due_date"], 4 => $strings["completed"], 5 => $strings["assigned_to"], 6 => $strings["published"]), "true"); if ($comptListProjects != "0") { for ($i = 0; $i < $comptListTasks; $i++) { if ($listTasks->tas_due_date[$i] == "--" or $listTasks->tas_due_date[$i] == "") { $listTasks->tas_due_date[$i] = $strings["none"]; } $idStatus = $listTasks->tas_status[$i]; $idPriority = $listTasks->tas_priority[$i]; $idPublished = $listTasks->tas_published[$i]; $complValue = $listTasks->tas_completion[$i] > 0 ? $listTasks->tas_completion[$i] . "0 %" : $listTasks->tas_completion[$i] . " %";
$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";
$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(); $block1->openPaletteScript(); $block1->paletteScript(0,"export","../reports/exportcompleted.php?s_date2=$s_date2&","true,false,false",$strings["export"]); $block1->closePaletteScript($comptListOrganizations,$listOrganizations->org_id); */ // set up the header string $headerString = $strings['project_breakdown']; $headerString .= ': ' . ($comptListProjects == 1 ? "{$comptListProjects} {$strings['match']}" : "{$comptListProjects} {$strings['matches']}"); $block1->heading($headerString); $block1->heading_close(); if ($comptListProjects != "0") {
$p->set_var('VALUE_estimated_end_date', date("Y/m/d", mktime(0, 0, 0, date("m"), date("d") + 1, date("Y")))); $p->parse('output', 'task'); echo $p->finish($p->get_var('output')); } else { $block = new block(); $msg = 'permissiondenied'; include "includes/messages.php"; $block->messagebox($msgLabel); if ($listTasks->parent_task[$i] == 0) { $block->heading($strings["addTask"]); } else { $block->heading($strings["addSubtask"]); } $block->openContent(); $block->contentRow('', '<input type="button" name="goback" value="' . $strings['back'] . '" onClick="history.back();">'); $block->closeContent(); $block->closeForm(); } echo COM_siteFooter(); exit; break; case 'view': // View Task $uid = $_USER[uid]; $taskrec = DB_fetchArray(DB_query("SELECT * FROM {$_TABLES['prj_tasks']} WHERE tid={$id}")); $result = DB_query("SELECT pid, name FROM {$_TABLES['prj_projects']} WHERE pid={$taskrec['pid']}"); list($pid, $name) = DB_fetchArray($result); //need to use the new permissions on this project here $ownertoken = getTaskToken($id, $uid, "{$_TABLES['prj_task_users']}", "{$_TABLES['prj_tasks']}"); $membertoken = prj_getProjectPermissions($pid, $uid, $id); //
function upgrade2_4() { include "../languages/help_en.php"; $setTitle = "PhpCollab Upgrade"; $blank = "true"; include "../themes/" . THEME . "/block.class.php"; include '../themes/' . THEME . '/header.php'; //Get this file.. $script = "upgrade.php"; $step = getParameter('step'); if (empty($step)) { $step = 1; } // Create new block and start the breadcrumbs $blockPage = new block(); $blockPage->openBreadcrumbs(); $blockPage->itemBreadcrumbs("<a href='../installation/{$script}'>Upgrade</a>"); //Content block $block1 = new block(); if ($step == 1) { $blockPage->itemBreadcrumbs("License"); $blockPage->closeBreadcrumbs(); $block1->heading("License"); $block1->openContent(); $block1->contentTitle(" "); echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>\n \t<pre>"; include "../docs/copying.txt"; echo "</pre>\n \t</td></tr>"; } elseif ($step == 2) { $myError = null; $blockPage->itemBreadcrumbs("<a href='../installation/{$script}?step=1'>License</a>"); $blockPage->itemBreadcrumbs("Check DB"); $blockPage->closeBreadcrumbs(); $block1->heading("Checking Database..."); $block1->openContent(); $block1->contentTitle("Database Requirements..."); echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>\n We are currently checking the database to see if it needs to be updated... <br /><br /><b>Please wait...</b><br />\n \t</td></tr>"; flush(); echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>"; if (checkDatabase($myError)) { echo "<br />Database looks <font style='color: green'>good</font>. We are continuing the conversion...<br /><br />"; echo "<br />Continue on to <a href='../installation/{$script}?step=3&redirect=true'>Step 3</a>.<br /><br /><b>MAKE SURE SETTINGS.PHP IS WRITEABLE!!!</b><Br /><br />"; } else { echo "<fieldset><legend style='font-weight: bold;font-size: large;padding: 5px;color: #ff3300'>"; echo "Error...</legend>"; echo "Sorry we could not upgrade your database at this time.. you will have to reinstall or do a manual upgrade..."; if (!empty($myError)) { echo "<pre>{$myError}</pre>"; } echo "</fieldset>"; } echo "</td></tr>"; } elseif ($step == 3) { $myError = null; $blockPage->itemBreadcrumbs("<a href='../installation/{$script}?step=1'>License</a>"); $blockPage->itemBreadcrumbs("<a href='../installation/{$script}?step=2'>Check DB</a>"); $blockPage->itemBreadcrumbs("Conversion"); $blockPage->closeBreadcrumbs(); $block1->heading("Conversion and update"); $block1->openContent(); $block1->contentTitle("Checking Settings.php..."); echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>\n We are making sure that settings.php is writeable, we can not continue if it's not writeable. <br /><br /><b>Please wait...</b><br />\n \t</td></tr>"; flush(); echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>"; //TODO: Check file $settingsFile = dirname(realpath(__FILE__)) . "/../includes/settings.php"; unset($goon); $goon = false; clearstatcache(); if (!is_writable($settingsFile)) { echo "<fieldset><legend style='font-weight: bold;font-size: large;padding: 5px;color: #ff3300'>"; echo "Error...</legend>"; echo "Your settings file is not writeable. You need to either <b>chmod 666</b> the file or <b>chmod o+w</b> the file. Hit refresh to recheck."; if (!empty($myError)) { echo "<pre>{$myError}</pre>"; } echo "</fieldset>"; } else { echo "<br />Okay your settings.php file looks good, we are going to continue.<br />"; $goon = true; } echo "<br /></td></tr>"; if ($goon) { //Next $block1->contentTitle("Converting..."); echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>\n We are now upgrading your database and writting the config file. <br /><br /><b>Please wait...</b><br />\n \t</td></tr>"; flush(); echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>"; if (convertDB()) { echo "<br />Writting out new settings file..."; rewriteConfig($settingsFile, '2.5'); //Reload the Config so we can use the root include $settingsFile; echo "<b> done</b><br /><br />"; echo "<br /><B>Congratulations... if there was no error writting the file, you are done.<br />Click <a href=\"../\">here</a> to login."; echo "<br><B>MAKE SURE TO DELETE UPGRADE.PHP!"; echo "</td></tr>"; echo "<h3>If you are upgrading from 2.4 to the latest version, please re-run this upgrade script to perform additi</h3>"; } } } $block1->closeContent(); $stepNext = $step + 1; if ($step < "2") { echo "<form name='license' action='../installation/{$script}?step=2&redirect=true' method='post'><center><a href=\"javascript:document.license.submit();\"><br /><b>Step {$stepNext}</b></a><br /><br /></center></form><br/>"; } $footerDev = "false"; include '../themes/' . THEME . '/footer.php'; //FOR DEBUG **** exit; // ----------------------- }