Esempio n. 1
0
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit;
}
if (isset($_GET['action'])) {
    if ($_GET['action'] == "new") {
        if ($_GET['processed'] == 1) {
            $packageid = $_POST['packageid'];
            $packageid = $mysqli->real_escape_string($packageid);
            $packagename = $_POST['packagename'];
            $packagename = $mysqli->real_escape_string($packagename);
            $cost = $_POST['cost'];
            $cost = $mysqli->real_escape_string($cost);
            $email = $_POST['email'];
            $email = $mysqli->real_escape_string($email);
            $newkey = get_new_key();
            $transid = mt_rand();
            $insertkey = "INSERT INTO `activationkeys` (`ID`, `transid`, `activationkey`, `used`, `type`, `package`) VALUES (NULL, '" . $transid . "', '" . $newkey . "', '0', '" . $packageid . "', '" . $packagename . "');";
            $result = $mysqli->query($insertkey) or die($mysqli->error . __LINE__);
            $inserttrans = "INSERT INTO `notifications` (`ID`, `item_name`, `item_number`, `payment_status`, `payment_amount`, `payment_currency`, `transaction_id`, `receiver_email`, `payer_email`) VALUES (NULL, '" . $packagename . "', '" . $packageid . "', 'MANUAL', '" . $cost . "', 'USD', '" . $transid . "', 'MANUAL', '" . $email . " ');";
            $result2 = $mysqli->query($inserttrans) or die($mysqli->error . __LINE__);
        }
        echo '
   <form class="form-horizontal" action="dash.php?action=new&processed=1" method="post">
<fieldset>

<!-- Form Name -->
<legend>Add new key</legend>

<!-- Text input-->
<div class="form-group">
Esempio n. 2
0
 }
 /* make your connection */
 $sql = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
 if (mysqli_connect_errno()) {
     $error = "Failed to connect to MySQL: " . mysqli_connect_error();
     file_put_contents($file, $error, FILE_APPEND | LOCK_EX);
 }
 $trans = "INSERT INTO notifications VALUES( DEFAULT, '{$item_name}','{$item_number}','{$payment_status}','{$payment_amount}','{$payment_currency}','{$txn_id}','{$receiver_email}','{$payer_email}')";
 if ($sql->query($trans)) {
     $status = "[" . date("m.d.y H:i:s") . "] A new transaction has been added with the `id` of {$sql->insert_id}.\n";
     file_put_contents($file, $status, FILE_APPEND | LOCK_EX);
 } else {
     $status = "[" . date("m.d.y H:i:s") . "] -ERROR- There was a problem:<br />{$query}<br />{$sql->error}\n";
     file_put_contents($file, $status, FILE_APPEND | LOCK_EX);
 }
 $key = get_new_key();
 $addcode = 'INSERT INTO activationkeys VALUES(DEFAULT, "' . $txn_id . '", "' . $key . '", "0", "' . $item_number . '", "' . $item_name . '")';
 if ($sql->query($addcode)) {
     $status = "[" . date("m.d.y H:i:s") . "] A new key has been added with the `id` of {$sql->insert_id}.\n";
     file_put_contents($file, $status, FILE_APPEND | LOCK_EX);
 } else {
     $status = "[" . date("m.d.y H:i:s") . "] -ERROR- There was a problem:<br />{$query}<br />{$sql->error}\n";
     file_put_contents($file, $status, FILE_APPEND | LOCK_EX);
 }
 $status = "[" . date("m.d.y H:i:s") . "] End of notification \n";
 file_put_contents($file, $status, FILE_APPEND | LOCK_EX);
 /* close our connection */
 $sql->close();
 // Email messages
 $keyemail = '
 <html>