public static function createEmptyFile(WOOOF $wo, $fileName)
{
$fullFilename = $wo->getConfigurationFor('absoluteFilesRepositoryPath') . $wo->randomString(40);
while (file_exists($fullFilename)) {
$fullFilename = $wo->getConfigurationFor('absoluteFilesRepositoryPath') . $wo->randomString(40);
}
$result = touch($fullFilename);
if ($result === FALSE) {
$wo->logError(self::_ECP . "0001 createEmptyFile: External File was not created by the file system.");
return true;
}
$newId = $wo->db->getNewId('__externalFiles');
$result = $wo->db->query('insert into __externalFiles ' . '(id, entryDate, fileName, originalFileName) values ' . '(' . $newId . ', ' . $wo->getCurrentDateTime() . ', ' . $fullFilename . ', ' . $wo->cleanUserInput($fileName) . ')');
if ($result === FALSE) {
return FALSE;
}
}
';
if (isset($_FILES['file'])) {
if ($_FILES['file']['type'] == 'image/jpeg' || $_FILES['file']['type'] == 'image/png' || $_FILES['file']['type'] == 'image/gif' || $_FILES['file']['type'] == 'application/octet' || $_FILES['file']['type'] == 'application/pdf' || $_FILES['file']['type'] == 'application/x-pdf') {
$prefix = $wo->randomString(20);
$fileInfo = pathinfo($_FILES['file']['name']);
if (($_FILES['file']['type'] == 'application/octet' || $_FILES['file']['type'] == 'application/pdf' || $_FILES['file']['type'] == 'application/x-pdf') && $fileInfo['extension'] != 'pdf' && $fileInfo['extension'] != 'PDF') {
echo $_FILES['file']['type'] . ' ' . $fileInfo['extension'] . ' BAD file type. File deleted.<br/><br/>';
unlink($_FILES['file']['tmp_name']);
exit;
}
$insertId = $wo->db->getNewId($tableName);
$maxR = $wo->db->query('select max(ord) from ' . $tableName);
$max = $wo->db->fetchRow($maxR);
$max = $max[0] + 10;
if (!isset($_POST['entry_date'])) {
$entryDate = WOOOF::getCurrentDateTime();
} else {
$entryDate = $wo->cleanUserInput($_POST['entry_date']);
}
if (file_exists($table->getTableName() . '.prePictureUploadOperations.inc.php')) {
require $wo->getConfigurationFor($siteBasePath) . $wo->getConfigurationFor('adminIncludesDirectory') . $table->getTableName() . '.prePictureUploadOperations.inc.php';
}
if ($_FILES['file']['type'] == 'application/octet' || $_FILES['file']['type'] == 'application/pdf' || $_FILES['file']['type'] == 'application/x-pdf') {
$isPDF = ', isPDF=\'1\'';
} else {
$isPDF = ', isPDF=\'0\'';
}
move_uploaded_file($_FILES['file']['tmp_name'], $siteBasePath . $imagesRelativePath . $prefix . $_FILES['file']['name']);
//WOOOF::cropCenterOfPicture($siteBasePath . $imagesRelativePath . $prefix . $_FILES['file']['name'], $siteBasePath . $imagesRelativePath . $prefix .'thumb_' . $_FILES['file']['name'], 120, 77);
WOOOF::cropPictureAndResize($siteBasePath . $imagesRelativePath . $prefix . $_FILES['file']['name'], $siteBasePath . $imagesRelativePath . $prefix . 'thumb_' . $_FILES['file']['name'], 280, 180);
$wo->db->query('insert into ' . $tableName . ' set ' . $columnName . '=\'' . $wo->db->escape($prefix . $_FILES['file']['name']) . '\', ' . $remoteIdColumn . ' = \'' . $_POST['itemId'] . '\', objectId=\'' . $_POST['table'] . '\', id = \'' . $insertId . '\', entryDate=\'' . $entryDate . '\', description=\'' . $wo->cleanUserInput($_POST['description']) . '\', description_en=\'' . $wo->cleanUserInput($_POST['description_en']) . '\', ord=\'' . $max . '\', thumbnail=\'' . $wo->cleanUserInput($prefix . 'thumb_' . $_FILES['file']['name']) . '\' ' . $isPDF);
<?php
$__isAdminPage = true;
$__actualPath = dirname($_SERVER['SCRIPT_FILENAME']);
$__actualPath = dirname($__actualPath);
require_once $__actualPath . '/setup.inc.php';
$requestedAction = 'signOut';
$pageLocation = '1';
$pageTitle = 'Log out.';
$wo = new WOOOF(FALSE);
$wo->invalidateSession();
$wo->db->commit();
header('Location: index.php?' . $wo->getCurrentDateTime());
exit;
{
$menuOutput .= fetchSubmenus($mI);
}
*/
$menuOutput .= ' </ul>
';
if (isset($activateFirstMenu) && $activateFirstMenu == true) {
$menuAClass = 'selected';
} else {
$menuAClass = 'menuLink';
}
$menuOutput = ' <div class="menuItem"><a href="administration.php?tm=' . WOOOF::getCurrentDateTime() . '" class="' . $menuAClass . '">Home</a></div>
';
$mR = $wo->db->query('select * from __tableMetaData where appearsInAdminMenu=\'1\' and tableName not in (\'__tableMetaData\', \'__columnMetaData\') ');
while ($m = $wo->db->fetchAssoc($mR)) {
if (isset($addressItems[1]) && $addressItems[1] == $m['id']) {
$menuAClass = 'selected';
} else {
$menuAClass = 'menuLink';
}
$menuOutput .= '<div class="menuItem"><a href="administration.php?__address=1_' . $m['id'] . '&action=read" class="' . $menuAClass . '">' . $m['description'] . '</a></div>';
}
if (basename($_SERVER['SCRIPT_FILENAME']) == 'optionManagement.php') {
$optClass = 'selected';
} else {
$optClass = 'menuLink';
}
$menuOutput .= ' <div class="menuItem"><a href="optionManagement.php?tm=' . WOOOF::getCurrentDateTime() . '" class="' . $optClass . '">Options</a></div>
<div class="menuItem"><a href="backUpDataBase.php?tm=' . WOOOF::getCurrentDateTime() . '" class="menuLink">DB Backup</a></div>
<div class="menuItem"><a href="logOut.php?tm=' . WOOOF::getCurrentDateTime() . '" class="menuLink">Log Out</a></div>
';
<?php
$__isSiteBuilderPage = true;
$__actualPath = dirname($_SERVER['SCRIPT_FILENAME']);
$__actualPath = dirname($__actualPath);
require_once $__actualPath . '/setup.inc.php';
$requestedAction = 'edit';
$pageLocation = '1';
$wo = new WOOOF();
$tm = WOOOF::getCurrentDateTime();
$database = $wo->db->getDatabaseName();
$table = trim($wo->db->escape($_GET["table"]));
$content = '<br/><a href="dbManager.php#' . $table . '" class="normalTextCyan">Back to Main Page</a><br/><br/>';
$result = $wo->db->query("show indexes from `{$table}`");
$content .= "<h3>Database Indexes for [{$table}]</h3>";
$content .= "<table width=\"100%\" border=\"0\" cellspacing=\"1\" align=\"left\" bgcolor=\"#FFFFFF\"><tr bgcolor=\"#000000\" class=\"normal_text_yellow\"><td>Table</td><td>Non_unique</td><td>Key_name</td><td>Seq_in_index</td><td>Column_name</td><td>Collation</td><td>Cardinality</td><td>Sub_part</td><td>Packed</td><td>Null</td><td>Index_type</td><td>Comment</td></tr>";
while ($row = $wo->db->fetchAssoc($result)) {
$content .= "<tr bgcolor=\"#000000\" class=\"normal_text_cyan\"><td>{$row["Table"]}</td><td>{$row["Non_unique"]}</td><td>{$row["Key_name"]}</td><td>{$row["Seq_in_index"]}</td><td>{$row["Column_name"]}</td><td>{$row["Collation"]}</td><td>{$row["Cardinality"]}</td><td>{$row["Sub_part"]}</td><td>{$row["Packed"]}</td><td>{$row["Null"]}</td><td>{$row["Index_type"]}</td><td>{$row["Comment"]}</td></tr>\n";
}
$content .= "</table>";
$content .= "<br><br><br><br>";
$content .= "<h3>Indexes in MetaData not already in the DB for Table [" . $_GET["table"] . "]</h3>";
ob_start();
$res2 = WOOOF_MetaData::buildIndexesForTable($wo, $database, $table, false);
if ($res2 !== FALSE) {
$content .= '<br>' . implode("<br>", $res2);
} else {
$content .= '<br>' . '<h2>Error</h2>' . $wo->getErrorsAsStringAndClear();
}
ob_end_clean();
$content .= '
public static function exportMetaDataAux(WOOOF $wo, $justTheMetaData = false, $justThisTable = '', $exportType = 'FILE')
{
$tablesArray = array();
$columnsArray = array();
$wherClause1 = "where 1=1 ";
$justThisTable = trim($wo->db->escape($justThisTable));
$wherClause1 .= $justTheMetaData ? " and tableName in ( '__tableMetaData', '__columnMetaData' ) " : ($wo->hasContent($justThisTable) ? " and tableName = '{$justThisTable}' " : '');
$wherClause2 = $justTheMetaData ? ", __tableMetaData t where t.id = c.tableId and t.tableName in ( '__tableMetaData', '__columnMetaData' ) " : ($wo->hasContent($justThisTable) ? ", __tableMetaData t where t.id = c.tableId and t.tableName = '{$justThisTable}' " : '');
$tmdResults = $wo->db->query("select * from __tableMetaData {$wherClause1} order by tableName");
if ($tmdResults === FALSE) {
return false;
}
while (($tmdRow = $wo->db->fetchAssoc($tmdResults)) !== NULL) {
$tablesArray[] = $tmdRow;
}
$cmdResults = $wo->db->query("select c.* from __columnMetaData c {$wherClause2} order by c.tableId, c.ordering, c.name");
if ($cmdResults === FALSE) {
return false;
}
while (($cmdRow = $wo->db->fetchAssoc($cmdResults)) !== NULL) {
$columnsArray[] = $cmdRow;
}
$retArray = array('version' => self::$version, 'tables' => $tablesArray, 'columns' => $columnsArray);
if ($exportType == 'FILE') {
// save to file as JSON in debugLogPath
$fullFileName = $wo->getConfigurationFor('debugLogPath') . 'mdExp_' . $wo->getCurrentDateTime() . $justThisTable . '.json';
$succ = file_put_contents($fullFileName, json_encode($retArray));
return $succ === FALSE ? FALSE : $fullFileName;
}
if ($exportType == 'ARRAY') {
return $retArray;
} else {
return json_encode($retArray);
}
}
private function prepareDefaultDateTime()
{
if ($this->defaultValue == '@@@empty@@@') {
$date['year'] = '';
$date['month'] = '';
$date['day'] = '';
$date['hour'] = '';
$date['minute'] = '';
$date['second'] = '';
} else {
if ($this->defaultValue == '0' || $this->defaultValue == '00000000000000') {
// Antonis
$date['year'] = '';
$date['month'] = '';
$date['day'] = '';
$date['hour'] = '';
$date['minute'] = '';
$date['second'] = '';
//$date = WOOOF::breakDateTime($this->defaultValue);
} else {
$this->defaultValue = WOOOF::getCurrentDateTime();
$date = WOOOF::breakDateTime($this->defaultValue);
}
}
return $date;
}
