<?php require_once "data_access.php"; require_once "utils.php"; StartAccessToDB(); $unitsInfos = GetUnitsInProject(12); foreach ($unitsInfos as $unitInfos) { echo "Unit: " . $unitInfos["Name"] . "<br>"; $unit_tmpInfos_request = "SELECT * FROM jh_units_tmp WHERE Name=\"" . $unitInfos["Name"] . "\""; $unit_tmpInfos_res = mysql_query($unit_tmpInfos_request); if (!$unit_tmpInfos_res) { die($unit_tmpInfos_request . "<br>" . mysql_error()); } else { $unit_tmpInfos = mysql_fetch_array($unit_tmpInfos_res, MYSQL_ASSOC); $update_request = "UPDATE jh_units SET Author=\"" . EscapeCharsForMySQL($unit_tmpInfos["Author"]) . "\" " . "WHERE Id=" . $unitInfos["Id"]; echo $update_request . "<br>"; if (!mysql_query($update_request)) { die($update_request . "<br>" . mysql_error()); } echo "<br>"; } } EndAccessToDB();
function AddSubmittedItem($item_id, $unit_id, $name, $summary, $description, $return_value, $see_also_list, $parameters, $extras, $jvcl_info) { if ($name == "") { return "The Name of the item cannot be empty"; } StartAccessToDB(); $request = mysql_query("INSERT INTO jh_submitted_items SET " . "CreatedOn=NOW(), " . "ItemId=\"{$item_id}\", " . "UnitId=\"{$unit_id}\", " . "Name=\"" . EscapeCharsForMySQL(trim($name)) . "\", " . "Summary=\"" . EscapeCharsForMySQL($summary) . "\", " . "Description=\"" . EscapeCharsForMySQL($description) . "\", " . "ReturnValue=\"" . EscapeCharsForMySQL($return_value) . "\", " . "SeeAlsoList=\"" . EscapeCharsForMySQL($see_also_list) . "\", " . "Parameters=\"" . EscapeCharsForMySQL($parameters) . "\", " . "Extras=\"" . EscapeCharsForMySQL($extras) . "\", " . "JVCLInfo=\"" . EscapeCharsForMySQL($jvcl_info) . "\""); if (!$request) { $result = mysql_error(); } else { $result = ""; } EndAccessToDB(); return $result; }
} // ----------------------------------------------------------- // Fill in the Description and Author columns // ----------------------------------------------------------- $request = "SELECT UnitId, Author, Summary, Description " . "FROM jh_items " . "WHERE Name LIKE '%.pas'"; $reqResult = mysql_query($request); if (!$reqResult) { die(mysql_error()); } while ($row = mysql_fetch_array($reqResult, MYSQL_ASSOC)) { $desc = $row["Summary"]; if ($desc != "" && $row["Description"] != "") { $desc .= "<br>\r\n" . $row["Description"]; } $desc = EscapeCharsForMySQL($desc); $author = EscapeCharsForMySQL($row["Author"]); $request2 = "UPDATE jh_units " . "SET Author=\"" . $author . "\", " . " Description=\"" . $desc . "\" " . "WHERE Id=" . $row["UnitId"] . ""; echo $request2 . "<br>"; $reqResult2 = mysql_query($request2); if (!$reqResult2) { die($request2 . ": " . mysql_error()); } } // ----------------------------------------------------------- // Delete the ".pas" items in jh_items // ----------------------------------------------------------- $request = "DELETE FROM jh_items " . "WHERE Name LIKE '%.pas'"; $reqResult = mysql_query($request); if (!$reqResult) { die($request . ": " . mysql_error()); }