[mccode] Crystal Market - Buy Amount of Crystals, Not All

hobbes · November 2, 2008

Here's a script for the Crystal Market that allows you to buy a certain amount of crystals rather than all of them at once (as in the stock mccode). I am sure many experienced scripters can update this to make it more simple, but it works and I haven't had any problems with it.

First things first, open your cmarket.php and add the following case statement at the top:

case "get":

get_crystals();

break;

Here are the edited crystal_buy and crystal_get functions that I am using. Place these in your cmarket.php script.

This one is an edited version of the crystal_buy function. You can replace the whole function with this one.

function crystal_buy()

{

global $db,$ir,$c,$userid,$h;

$q=$db->query("SELECT * FROM crystalmarket cm WHERE cmID={$_GET['ID']}");

//non-existant crystals

if(!$db->num_rows($q))

{

print "Error, either these crystals do not exist, or they have already been bought.

";

$h->endpage();

exit;

}

$r=$db->fetch_row($q);

//crystal price

$price=$r['cmPRICE'] / $r['cmQTY'];

$id=($_GET['ID']);

print

"How many crystals would you like to buy?

You can buy a maximum of {$r['cmQTY']} crystals for $ \$".number_format($price)." each.

<form name='buy' action='cmarket.php?action=get&ID={$id}' method='post'>

<input type='int' name='qty' class='texta' size='8'>

<input type='submit' value='Buy Crystals'>

</form>";

}

And the new function, get_crystals:

function get_crystals()

{

global $db,$ir,$c,$userid,$h;

$q=$db->query("SELECT * FROM crystalmarket cm WHERE cmID={$_GET['ID']}");

//non-existant tokens

if(!$db->num_rows($q))

{

print "Error, either these crystals do not exist, or they have already been bought.

";

$h->endpage();

exit;

}

$r=$db->fetch_row($q);

$id=($_GET['ID']);

$qty=($_POST['qty']);

$price=($r ['cmPRICE'] / $r['cmQTY']);

$total=($qty * $price);

$cmprice=($r['cmPRICE'] - $total);

$cmqty=($r['cmQTY'] - $qty);

//not enough money

if($total > $ir['money'])

{

die("You do not have enough money to purchase {$qty} crystals.");

}

if(!is_numeric($qty))

{

die('Your quantity must be numeric! (and no white spaces)');

}

if(!isset($qty))

{

die('You must enter how many crystals you would like to purchase.');

}

if($qty > $r['cmQTY'])

{

die('There are not that may crystals available to purchase');

}

$db->query("UPDATE users SET crystals=crystals+{$qty} where userid=$userid");

$db->query("UPDATE crystalmarket SET cmQTY={$cmqty} WHERE cmID={$id}");

$db->query("UPDATE crystalmarket SET cmPRICE={$cmprice} WHERE cmID={$id}");

if($cmqty < 1)

{

$db->query("DELETE FROM crystalmarket WHERE cmID={$id}");

}

$db->query("UPDATE users SET money=money-{$total} where userid=$userid");

$db->query("UPDATE users SET money=money+{$total} where userid={$r['cmADDER']}");

$db->query("INSERT INTO clogs VALUES('',$userid,{$r['cmADDER']},{$qty},{$total},unix_timestamp());",$c);

event_add($r['cmADDER'],"{$ir['username']} bought {$qty} crystals from the market for \$".number_format($total).".",$c);

print "You bought the {$qty} crystals from the market for \$".number_format($total).".";

}

My version is slightly different as I use something other than crystals, but I have edited it down to a pure mccode stock substitute.

This is my first php script post on CE, so be nice. :roll:

Zero-Affect · November 3, 2008