<?php
// table.php
require_once "functions.php";
require_once "header.php";
$text_list = getTextData();
//var_dump($car_list);
$emailtable = getEmailData();
//kas kasutaja tahab kustutada
// kas aadressireal on ?delete=??!??!?!
if (isset($_GET["delete"])) {
// saadan kaasa id, mida kustutada
deletePost($_GET["delete"]);
}
?>
<table border=1 align="center" >
<tr>
<th>ID</th>
<th>user_id</th>
<th>text</th>
</tr>
<?php
// iga massiivis olema elemendi kohta
// count($car_list) - massiivi pikkus
for ($i = 0; $i < count($text_list); $i++) {
// $i = $i +1; sama mis $i += 1; sama mis $i++;
// tavaline rida
echo "<tr>";
echo "<td>" . $text_list[$i]->post_kd . "</td>";
function moveFile($file)
{
if (strlen($file['name']) == 0 && $file['size'] == 0 && strlen($file['tmp_name']) == 0) {
return array();
}
$lnk = "";
$maxFileSize = $_POST['MAX_FILE_SIZE'];
$ifFileExists = $_POST['IF_FILE_EXISTS'];
//replace,noreplace
$fileAct = $_POST['FILE_ACTION'];
//create,replace,delete
$storeTxtToDB = $_POST['TEXT_EXTRACTION'];
//true,false,yes,no
$storeType = "fs";
$storePath = "attachments/";
if (strlen($file['src']) == 0) {
$file['src'] = "fs#attachments/";
}
if (strpos($file['src'], "fs#") === 0) {
$storePath = substr($file['src'], 3);
$storeType = "fs";
if (strlen($storePath) <= 0) {
$storePath = "attachments/";
}
} elseif (strpos($file['src'], "db#") === 0) {
$storePath = substr($file['src'], 3);
$storeType = "db";
if (strlen($storePath) <= 0) {
$storePath = _dbtable("files");
}
} else {
$file['src'] = "fs#attachments/";
$storePath = substr($file['src'], 3);
$storeType = "fs";
if (strlen($storePath) <= 0) {
$storePath = "attachments/";
}
}
$exts = explode(".", $file['name']);
if (count($exts) > 1) {
$ext = $exts[count($exts) - 1];
} else {
$ext = "";
}
$fname = substr($file['name'], 0, strlen($file['name']) - strlen($ext));
if (strpos($fname, ".") === strlen($fname) - 1) {
$fname = substr($fname, 0, strlen($fname) - 1);
}
if ($storeType == "fs") {
$newName = md5(rand() * time()) . "-" . str_replace(" ", "_", $fname);
$targetPath = APPROOT . APPS_USERDATA_FOLDER . "{$storePath}/{$newName}.{$ext}";
$targetPath = str_replace("//", "/", $targetPath);
if (!file_exists(dirname($targetPath))) {
mkdir(dirname($targetPath), 0777, true);
chmod(dirname($targetPath), 0777);
}
if (!file_exists(dirname($targetPath))) {
return array("Error" => "Failed To Create TargetPath Folder.");
}
if (file_exists($targetPath)) {
if ($ifFileExists == "replace") {
unlink($targetPath);
} elseif ($ifFileExists == "noreplace") {
return array("Error" => "File Exists At The Target.");
}
}
if ($fileSize < $maxFileSize) {
if (@move_uploaded_file($file['tmp_name'], $targetPath)) {
return str_replace("//", "/", "{$storePath}/{$newName}.{$ext}");
} else {
return array("Error" => "Failed To Move File To Destination.");
}
} else {
return array("Error" => "File Size Is More Then Max.");
}
} elseif ($storeType == "db") {
$date = date("Y-m-d");
$usr = getUserInfo();
$defData['date'] = $date;
$defData['time'] = date('H:i:s');
$defData['doc'] = $date;
$defData['doe'] = $date;
$defData['datestamp'] = date('Y-m-d H:i:s');
$defData['username'] = $usr['SESS_USER_NAME'];
$defData['userid'] = $usr['SESS_USER_ID'];
$defData['privilegeid'] = $_SESSION['SESS_PRIVILEGE_ID'];
$defData['scanBy'] = $_SESSION['SESS_USER_ID'];
$defData['site'] = SITENAME;
$fileName = $file['name'];
$fileType = $file['type'];
$fileSize = $file['size'];
$fileData = "";
$meta = "";
$txtData = "";
if (isset($_POST['tags'])) {
$tags = $_POST['tags'];
} else {
$tags = "";
}
if (isset($_POST['remarks'])) {
$remarks = $_POST['remarks'];
} else {
$remarks = "";
}
if ($fileSize < $maxFileSize) {
$fileData = file_get_contents($file['tmp_name']);
$fileData = mysql_real_escape_string($fileData);
if ($storeTxtToDB || $storeTxtToDB == "true") {
$txtData = getTextData($fileData, $fileType);
}
} else {
return array("Error" => "File Size Is More Then Max.");
}
if (strpos("#" . $storePath, $GLOBALS["DBCONFIG"]["DB_SYSTEM"]) == 1) {
$sysDb = true;
} else {
$sysDb = false;
}
$insertQuery = "INSERT INTO {$storePath} ";
$insertQuery .= "(datestamp,title,txt_data,file_name,file_data,file_type,file_size,remarks,tags,meta,site,userid,doc,doe) VALUES ";
$insertQuery .= "('{$defData['datestamp']}','{$fname}',\"{$txtData}\",'{$fileName}',\"{$fileData}\",'{$fileType}','{$fileSize}','{$remarks}','{$tags}',";
$insertQuery .= "'{$meta}','{$defData['site']}','{$defData['userid']}','{$defData['doc']}','{$defData['doe']}')";
//echo $insertQuery;
$a = _dbQuery($insertQuery, $sysDb);
if ($a) {
return _db($sysDb)->insert_id();
}
return array("Error" => "Error In MySQL Query.");
}
return array("Error" => "StorageType Not Supported.");
}
