if ($address != '1') { $security = $wo->db->getSecurityPermitionsForLocationAndUser($address, $userData['id']); if (!isset($security[$action]) || $security[$action] != true) { //die('Δεν έχετε την απαιτούμενη έγκριση ασφάλειας για να προβείτε σε αυτή την ενέργεια. Θα πρέπει να κάνετε login με άλλο λογαριασμό για να προχωρήσετε.<br/>Αυτό το σφάλμα μπορεί να συμβεί επίσης αν ζητήσετε μια ενέργεια που δεν έχει οριστεί.'); $wo->handleShowStopperError('You are not authorised for this action. Please login with an admin account.'); } else { $addressItems = explode('_', $address); if (count($addressItems) < 2 || $addressItems[0] != '1') { //$wo->reportError('Η διεύθυνση που δώσατε είναι εσφαλμένη. Δεν βρέθηκε το κατάλληλο descriptor.'); $wo->handleShowStopperError('Wrong authorisation location.'); } $table = new WOOOF_dataBaseTable($wo->db, '', $addressItems[1]); if ($action == 'read' && count($addressItems) == 2) { if ($table->getAdminPresentation() == '4') { $table2 = new WOOOF_dataBaseTable($wo->db, $table->getGroupedByTable()); if (!isset($_GET[$table->getLocalGroupColumn()]) || $_GET[$table->getLocalGroupColumn()] == '') { if ($table2->getOrderingColumnForListings() != '') { $orderBy = $table2->getOrderingColumnForListings(); } else { $orderBy = 'id'; } $table2->getResult('', $orderBy, '', 1); $_GET[$table->getLocalGroupColumn()] = $table2->resultRows[0]['id']; } else { $_GET[$table->getLocalGroupColumn()] = $wo->cleanUserInput($_GET[$table->getLocalGroupColumn()]); } foreach ($table2->columns as $key => $value) { $column = $value->getColumnMetaData(); if ($column['appearsInLists']) { $columnsToShow = $column['name']; }
$path = '<div id="pathDivision"><a href="improvedTree.php?__address=1_' . $table->getTableId() . '&action=read">' . $table->getTableDescription() . '</a>' . $path . '</div>'; $additionLabel = 'Προσθήκη υπομενού στο "' . $actualRow[$columnsToShow] . '"'; } if (isset($actualRow['id']) && trim($actualRow['categoryHandling']) != '') { $content = $path . '<div class="listTitle">"' . $actualRow[$columnsToShow] . '" είναι σελίδα. Στις σελίδες δεν μπορείτε να προσθέσετε υπομενού ή άρθρα.</div>'; } else { if (count($addressItems) == 2) { $wooofParent = '-1'; } else { $wooofParent = $addressItems[2]; } $content = $path . '<div class="listTitle"><a href="administration.php?action=edit&__address=1_' . $addressItems[1] . '_&wooofParent=' . $wooofParent . '">' . $additionLabel . ' <img src="images/add.png" alt="Create new item" border="0" align="top"></a></div>'; $htmlFragment = '<li class="normalTreeItemLevel@@@level@@@">@@@' . $columnsToShow . '@@@ @@@activation@@@<a href="administration.php?__address=1_@@@tableId@@@_@@@id@@@&action=edit"><img border="0" align="top" alt="edit" src="images/edit.png"></a>@@@upDown@@@ <a href="javascript:confirmDelete(\'administration.php?__address=1_@@@tableId@@@_@@@id@@@&action=delete\');"><img border="0" align="top" alt="Delete" src="images/delete.png"></a> @@@subItems@@@</li>'; if (count($addressItems) == 2) { $whereClauses[$table->getLocalGroupColumn()] = '-1'; } else { $whereClauses[$table->getLocalGroupColumn()] = $addressItems[2]; } $table->getResult($whereClauses, $table->getOrderingColumnForListings()); $output = '<ul class="treeLevel1"> '; for ($i = 0; $i < count($table->resultRows) / 2; $i++) { if ($table->getHasActivationFlag()) { if ($table->resultRows[$i]['active'] == '1') { $activation = '<a href="administration.php?action=deactivate&__address=1_' . $table->getTableId() . '_' . $table->resultRows[$i]['id'] . '" class="catOn">Active</a>'; } else { $activation = '<a href="administration.php?action=activate&__address=1_' . $table->getTableId() . '_' . $table->resultRows[$i]['id'] . '" class="catOff">Inactive</a>'; } } else { $activation = '';
/** * * @param array $row * @param string $subtableName * @param string $optionsTable * @return boolean */ public function updateSubtableFromPostCheckBoxes($row, $subtableName, $optionsTable) { $sT = new WOOOF_dataBaseTable($this->dataBase, $subtableName); if ($sT->constructedOk === FALSE) { return FALSE; } $sTId = $sT->getTableId(); $res = $this->dataBase->query('delete from ' . $sT->getTableName() . ' where ' . $sT->getLocalGroupColumn() . '=\'' . $row[$sT->getRemoteGroupColumn()] . '\''); if ($res === FALSE) { return FALSE; } if (isset($_POST[$sTId])) { $oT = new WOOOF_dataBaseTable($this->dataBase, $optionsTable); $oT->getResult(''); for ($n = 0; $n < count($sT->columns) / 2; $n++) { $columnMetaData = $sT->columns[$n]->getColumnMetaData(); if ($columnMetaData['valuesTable'] == $oT->getTableName()) { $presentationColumn = $columnMetaData['name']; } } while (list($key, $val) = each($_POST[$sTId])) { $res = $this->dataBase->query('insert into ' . WOOOF::$instance->cleanUserInput($sT->getTableName()) . ' (id,' . WOOOF::$instance->cleanUserInput($sT->getLocalGroupColumn()) . ',' . WOOOF::$instance->cleanUserInput($presentationColumn) . ') values (\'' . $this->dataBase->getNewId($sT->getTableName()) . '\',\'' . WOOOF::$instance->cleanUserInput($row[$sT->getRemoteGroupColumn()]) . '\',\'' . WOOOF::$instance->cleanUserInput($val) . '\')'); if ($res === FALSE) { return FALSE; } } } return TRUE; }
$presentationDefault[5] = ''; $presentationDefault[$table->getAdminPresentation()] = ' selected'; $tableName = $table->getTableName(); $orderingColumnForListings = $table->getOrderingColumnForListings(); $appearsInAdminMenu = $table->getAppearsInAdminMenu(); if ($appearsInAdminMenu == '1') { $appearsInAdminMenu = ' checked'; } else { $appearsInAdminMenu = ''; } $adminItemsPerPage = $table->getAdminItemsPerPage(); $adminListMarkingCondition = $table->getAdminListMarkingCondition(); $adminListMarkedStyle = $table->getAdminListMarkedStyle(); $groupedByTable = $table->getGroupedByTable(); $remoteGroupColumn = $table->getRemoteGroupColumn(); $localGroupColumn = $table->getLocalGroupColumn(); $tablesGroupedByThis = $table->getTablesGroupedByThis(); $hasActivationFlag = $table->getHasActivationFlag(); $columnForMultipleTemplates = $table->getColumnForMultipleTemplates(); $dbEngine = $table->getDbEngine(); if ($hasActivationFlag == '1') { $hasActivationFlag = ' checked'; } else { $hasActivationFlag = ''; } $availableForSearching = $table->getAvailableForSearching(); if ($availableForSearching == '1') { $availableForSearching = ' checked'; } else { $availableForSearching = ''; }