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