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 = '';
}
