function DeleteSubmittedItem($ItemId)
{
StartAccessToDB();
$request = "DELETE FROM jh_submitted_items WHERE Id={$ItemId}";
$reqResult = mysql_query($request);
if (!$reqResult) {
$result = "SQL Error in {$request}: " . mysql_error();
} else {
$result = "";
}
EndAccessToDB();
return $result;
}
function GetLoggedUserId()
{
StartAccessToDB();
$LoggedUserName = GetLoggedUserName();
if ($LoggedUserName == "") {
$result = -1;
} else {
$userInfos = GetUserInfos($LoggedUserName);
if (is_array($userInfos)) {
$result = $userInfos["Id"];
} else {
$result = -1;
}
}
EndAccessToDB();
return $result;
}
<?php
require_once "data_access.php";
require_once "utils.php";
StartAccessToDB();
// -----------------------------------------------------------
// Add the CanUpload field in jh_users
// -----------------------------------------------------------
$request = "ALTER TABLE `jh_users` " . "ADD `CanUpload` ENUM('Y', 'N') DEFAULT 'N' NOT NULL AFTER `IsAdmin`";
$reqResult = mysql_query($request);
if (!$reqResult) {
die($request . ": " . mysql_error());
}
$request = "UPDATE `jh_users` " . "SET CanUpload = 'Y' " . "WHERE IsPower = 'Y' OR IsAdmin = 'Y'";
$reqResult = mysql_query($request);
if (!$reqResult) {
die($request . ": " . mysql_error());
}
echo "Update successful";
EndAccessToDB();
function ProcessDtx($filename, $projectId)
{
StartAccessToDB();
$lines = file($filename);
$msg = "processing " . $filename . "<br>";
$unitname = basename($filename);
// Delete the existing unit (if any)
$msg .= "deleting previous values for {$unitname}, if any...<br>";
$deleteResult = DeleteUnitAndItemsByUnitName($unitname);
if ($deleteResult != "") {
$msg .= "Error while removing previous values: " . $deleteResult;
} else {
$msg .= "Success<br>";
$unitId = -1;
$index = 0;
while ($index < count($lines)) {
$curline = rtrim($lines[$index]);
if (HasPrefix($curline, '##Package:')) {
$package = substr($curline, strpos($curline, ':') + 2);
$msg .= "found package: {$package}<br>";
}
if (HasPrefix($curline, '##Status:')) {
$status = substr($curline, strpos($curline, ':') + 2);
$msg .= "found status: {$status}<br>";
}
if (HasPrefix($curline, '@@')) {
$msg .= "found item: {$curline} - ";
if ($unitId == -1) {
$msg .= "Adding unit <a href=\"unit.php?Name={$unitname}\">{$unitname}</a> - ";
$unitId = AddUnit($unitname, "", "", $package, $status, $projectId, GetLoggedUserId());
if (is_string($unitId)) {
$msg .= $unitId . "<br>";
$unitId = -1;
}
}
if ($unitId != -1) {
$msg .= ProcessItem($lines, $index, $unitId);
}
}
$index++;
}
}
// delete the file, we don't need it anymore
unlink($filename);
EndAccessToDB();
return $msg;
}
