Example #1
0
<?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();
Example #2
0
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;
}
Example #3
0
}
// -----------------------------------------------------------
// 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());
}