upload_1GB.php

<?
$Purchase = "1GiB of upload";
$UserID = $LoggedUser['ID'];
$Cost = 1300;

$DB->query("
  SELECT BonusPoints
  FROM users_main
  WHERE ID = $UserID");
if ($DB->has_results()) {
  list($Points) = $DB->next_record();

  if ($Points >= $Cost) {
    $DB->query("
      UPDATE users_main
      SET BonusPoints = BonusPoints - $Cost,
          Uploaded    = Uploaded + 1073741824
      WHERE ID = $UserID");
    $DB->query("
      UPDATE users_info
      SET AdminComment = CONCAT('".sqltime()." - Purchased 1GiB upload from the store\n\n', AdminComment)
      WHERE UserID = $UserID");
    $Cache->delete_value('user_info_heavy_'.$UserID);
    $Cache->delete_value('user_stats_'.$UserID);
    $Worked = true;
  } else {
    $Worked = false;
    $ErrMessage = "Not enough points";
  }
}

View::show_header('Store'); ?>
<div class="thin">
  <h2 id="general">Purchase <?print $Worked?"Successful":"Failed"?></h2>
  <div class="box pad" style="padding: 10px 10px 10px 20px;">
    <p><?print $Worked?("You purchased ".$Purchase):("Error: ".$ErrMessage)?></p>
    <p><a href="/store.php">Back to Store</a></p>
  </div>
</div>
<? View::show_footer(); ?>