166
Items / Re: Item Transfers.
« on: June 01, 2006, 02:05:55 pm »
Any time!
P.S> Are you stalking me?
P.S> Are you stalking me?
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
);
$result = db_query("SELECT ID_MEMBER
FROM {$db_prefix}members
WHERE memberName = '{$_POST['membername']}'", __FILE__, __LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$newowner = $row['ID_MEMBER'];
$result = db_query("SELECT ownerid, itemid
FROM {$db_prefix}shop_inventory
WHERE id = '{$_POST['giftid']}'", __FILE__, __LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$itemid = $row['itemid'];
if ($row['ownerid'] !== $ID_MEMBER) {
die($txt['shop_use_others_item']);
}
$pmfrom = array(
'id' => '1',
'name' => 'Clucky',
'username' => 'Clucky'
else {
$result = db_query("UPDATE {$db_prefix}shop_inventory
SET ownerid = $newowner
WHERE id = '{$_POST['giftid']}'", __FILE__, __LINE__); <---- Line 1007
$context['shop_buy_message'] = "Item succesfully transfered!";
$result = db_query("SELECT name
FROM {$db_prefix}shop_items
WHERE id = {$itemid}", __FILE__, __LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$name = $row['name'];
$result = db_query("SELECT memberName
FROM {$db_prefix}members
WHERE ID_MEMBER = {$ID_MEMBER}", __FILE__, __LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$target = $row['memberName'];
$pmfrom = array(
'id' => '1',
'name' => 'Clucky',
'username' => 'Clucky'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = '82'' at line 3
File: /home/www/forum.technodragon.net/Sources/shop/Shop.php
Line: 1007