public function closeWork($workID)
{
global $DE_GLOBALS_WORK_CLOSED;
global $DE_GLOBALS_WORK_NEW;
global $DE_GLOBALS_WORK_TASKONTASK;
$currentTimeStamp = get_currentPHPTimestamp();
$success = execute_sqlUpdate("WORKS", array(work_status => $DE_GLOBALS_WORK_CLOSED, work_closedDate => $currentTimeStamp), array(workID => $workID));
// Appear in List any tasks having $workID as 'afterCompletionID'
$success = execute_sqlUpdate("WORKS", array(work_status => $DE_GLOBALS_WORK_NEW), array(afterCompletionID => $workID, work_status => $DE_GLOBALS_WORK_TASKONTASK));
}
public function newMessage($fromUid, $toUid, $messageInBase64)
{
$success = execute_sqlInsert('tbl_DirectMessages', array('to_uid' => $toUid, 'from_uid' => $fromUid, 'msg_base64' => base64_encode(htmlentities(base64_decode($messageInBase64), ENT_QUOTES)), 'msg_plain' => base64_decode($messageInBase64), 'msgtime' => get_currentPHPTimestamp()));
}
<?php
include_once "include_db.php";
include_once "include_functions.php";
checkUserSessionandCookie();
$username = $_SESSION["uname"];
$workid = @$_POST["fileupload_workid"];
$uploadname = basename($_FILES['uploadedfile']['name']);
$ruri = @$_POST["fileupload_requestURI"];
$tmp_uploadedOn = get_currentPHPTimestamp();
$tmp = getDirectorySize($target_path);
$currentsize = $tmp['size'];
$maxallowed = $_SESSION["pkgSpaceMb"] * 1024 * 1024;
// convert Mb into bytes
if ($currentsize > $maxallowed) {
echo "<h1>You do not have enough free space for uploading any new files ! </h1>";
exit;
}
Task_LogSystemComment($workid, "<B>{$username}</B> has uploaded file '{$uploadname}' {$thisfilesize}");
logUserEvent('Uploaded attachment to ' . $workid);
$fp = fopen($_FILES['uploadedfile']['tmp_name'], 'r');
$fp_size = filesize($_FILES['uploadedfile']['tmp_name']);
$somefile = bin2hex(fread($fp, $fp_size));
$success = execute_sqlInsert('attachments', array('workid' => $workid, 'uploadname' => $uploadname, 'uploadedby' => $username, 'filecontent' => $somefile, 'filesize' => $fp_size, 'uploadedOn' => $tmp_uploadedOn));
header("Location: " . $ruri);
function execute_sqlQuery($someQuery)
{
global $DEVELOPMENT_MODE;
global $GLOBAL_STRICT_NOLOGGING_QUERIES;
if ($DEVELOPMENT_MODE) {
$should_Log = !$GLOBAL_STRICT_NOLOGGING_QUERIES;
} else {
if ($GLOBAL_STRICT_NOLOGGING_QUERIES) {
$should_Log = false;
} else {
global $GLOBAL_LOG_QUERIES;
// is this an actions.php like page with update queuries
if ($GLOBAL_LOG_QUERIES) {
// even in actions.php ignore logging select queries
$should_Log = strtolower(substr(trim($someQuery), 0, 6)) != 'select';
} else {
$should_Log = false;
}
}
}
if ($should_Log) {
$ts = get_currentPHPTimestamp();
$username = $_SESSION["uname"];
global $GLOBAL_requestid;
$r = mysql_query("insert into `whm_logs`.`queryLog` ( `querystring`, `queryuser`, `querytime`, `requestid`) values ( '" . mysql_real_escape_string($someQuery) . "', '{$username}', '{$ts}', '{$GLOBAL_requestid}')");
}
return mysql_query($someQuery);
}
