function makeOrders($config)
{
$conn = new connection($config);
$allegroConn = new ALLEGRO();
$sandbox_auctions = $conn->query("SELECT auction_id FROM allegro WHERE sandbox = TRUE;");
$production_auctions = $conn->query("SELECT auction_id FROM allegro WHERE sandbox = FALSE;");
$sandbox_orders = GetAuctionDetails($allegroConn, CleanData($sandbox_auctions->fetchAll(), 'auction_id'), $allegroConn->sandbox);
$production_orders = GetAuctionDetails($allegroConn, CleanData($production_auctions->fetchAll(), 'auction_id'), $allegroConn->production);
$orders = array_merge($sandbox_orders, $production_orders);
print "<pre>";
//print_r($orders);
print "</pre>";
foreach ($orders as $order) {
if (CheckIfRecordExist($order->order_id, $conn)) {
/*Record already exist*/
} else {
$conn->query("\n INSERT INTO client(city , postal_code ,email , address , nick , name)\n VALUES(\n '" . $order->client->city . "',\n '" . $order->client->postal_code . "',\n '" . $order->client->email . "',\n '" . $order->client->address . "',\n '" . $order->client->nick . "',\n '" . $order->client->name . "');");
$clientID = $conn->conn->lastInsertId();
$conn->query("\n INSERT INTO orders VALUES (\n '" . $order->order_id . "',\n 1,\n " . $clientID . ",\n '" . $order->date . "',\n '" . $order->message . "',\n '" . $order->delivery . "',\n " . $order->amount . "\n );\n ");
print $conn->error;
}
}
}
<?php
function CleanData($data)
{
if (get_magic_quotes_gpc()) {
$data = stripslashes($data);
}
$data = str_replace("\n", '', trim($data));
$data = str_replace("\r", '', $data);
return $data;
}
$name = CleanData($_POST['name']);
$email = CleanData($_POST['email']);
$feedback = CleanData($_POST['feedback']);
$toaddress = "*****@*****.**";
$subject = "Booking Inquiry";
$mailcontent = "Name: " . $name . "\n" . "E-mail: " . $email . "\n" . "Comments: " . $feedback . "\n";
$fromaddress = "From: " . $name . "<" . $email . ">";
mail($toaddress, $subject, $mailcontent, $fromaddress);
header("Location: ../thankyou.php");
die;
?>
if (isset($_SERVER["argv"][3])) {
$optparam1 = $_SERVER["argv"][3];
} else {
$optparam1 = NULL;
}
// Second Optional Parameter
if (isset($_SERVER["argv"][4])) {
$optparam2 = $_SERVER["argv"][4];
} else {
$optparam2 = NULL;
}
// Third Optional Parameter
if (isset($_SERVER["argv"][5])) {
$optParam3 = $_SERVER["argv"][5];
} else {
$optParam3 = NULL;
}
// fourth Optional Parameter
if (isset($_SERVER["argv"][6])) {
$optParam4 = $_SERVER["argv"][6];
} else {
$optParam4 = NULL;
}
// ---
// --- Operation Handling now
if ($operation == "cleandata") {
// Run Parser only
CleanData($optparam1, $optparam2, $optParam3, $optParam4);
}
// ---
// ---
