Looking for Confuser - Code help?

Keydet · Sep 9, 2013

Hello, been trying to track down confuser as I am attempting to integrate SMFShop and LA a little more. Wanted SMFShop to handle rare, limited edition items and basically to put the item in the player's LA inventory when used.

Confuser, if you see this, trying to take the purchase script and integrate it into SMFShops OnUse() function

// ###############################################################################
// PURCHASE ITEM
// ###############################################################################

function PurchaseItem()
{
global $DB, $user_info, $forum_info_arr;

if(!$user_info['logged_in'])
{
DisplayMessage('You must be logged in under you forum to purchase items.', true);
DisplayItems();
return;
}

$item_id = $_GET['item_id'];
if(!is_numeric($item_id)) {
echo 'Error: Invalid item id';
exit;
}
// get item info
$item = $DB->query_first("SELECT * FROM {items} WHERE item_id = $item_id");

// make sure the user hasn't already purchased this item
if($itempurchased = $DB->query_first("SELECT item_id FROM {items_purchased} WHERE item_id = $item_id AND user_id = $user_info[user_id]"))
{
$error_message = 'You have already purchased this item.';
}

if(isset($error_message))
{
DisplayMessage($error_message, true);
DisplayItems();
}
else // no errors, lets continue
{
// insert item into items purchased table
$DB->query("INSERT INTO {items_purchased} (item_id, pack_id, group_id, user_id, points_spent, purchase_date)
VALUES ($item[item_id], $item[pack_id], $item[group_id], $user_info[user_id], $item[cost], " . TIME_NOW . ")");

// update item purchase count
$DB->query("UPDATE {items} SET purchase_count = purchase_count + 1 WHERE item_id = $item[item_id]");

$DB->query("UPDATE ".$forum_info_arr['forum_table_prefix'] . "members SET money = money - $item[cost] WHERE ID_MEMBER = $user_info[user_id]");

$points_remaining = $user_info['points'] - $item['cost'];

echo '<script type="text/javascript">
document.getElementById("points_remaining").innerHTML = "' . $points_remaining . '";
</script>';

DisplayMessage('Item Purchased!');
DisplayItems($purchased_item_id = $item['item_id']);
}
}
Click to expand...

Pretty sure it just has to include this code, but having a hard time integrating it.

confuser · Jan 1, 2014

Its been a while but are you still having trouble?

ogreman · Jan 1, 2014

Welcome back, Confuser.

Log in

Looking for Confuser - Code help?

Keydet Ogre Newling

confuser Big Brute The Pit

ogreman Ogre In Charge Staff Member GameOgre Admin

Share This Page