This piece of Code on 1.1.11 has an error.. and I follow the parser intructions:.. any help?
This is in Load.php in my source folder
//BEGIN SMFShop IPM
//Set variable for LIMIT amount
$row = 0;
$max = $modSettings['ShopIpDisMax'];
//Begin database query
$request3 = db_query("
SELECT it.desc, it.image, it.category, inv.id
FROM {$db_prefix}shop_inventory AS inv, {$db_prefix}shop_items AS it
WHERE inv.ownerid = {$profile['ID_MEMBER']} AND inv.itemid = it.id
LIMIT $max", __FILE__, __LINE__);
//Start with an empty array
$profile['shopitems']['shopitems'] = array();
//Loop through all items
while ($row = mysql_fetch_assoc($request3))
{
// Add item to the array
$profile['shopitems']['shopitems'][] = array(
'image' => $row['image'],
'desc' => $row['desc'],
);
}
mysql_free_result($request3);
//END SMFShop IPM
Thanks