Hi Bob,
i did now truyed your solution, but still no success. Please find my code below added as PHP action to IPN success_ action[pre]$db = JFactory::getDbo();
$query = $db->getQuery(true);[br]$fields = array([br] $db->quoteName("quantity") . " = quantity - 1"[br]);[br]$conditions = array([br] $db->quoteName("name") . " = '".$this->data['item_name']."'", [br]);[br]$query->update($db->quoteName("#__rewards"))->set($fields)->where($conditions);[br]$db->setQuery($query);[br]$result = $db->execute();[/pre]
This code works well by adding directly into joomla template file but wont be executed inside of IPN success_ section.
I did also tryed to set real name isteand of
$this->data['item_name']
Next codes was also truyed:
UPDATE ssi_rewards SET quantity = 'quantity - 1' WHERE name = '".$this->data['item_name']."';
UPDATE ssi_rewards SET quantity = 'quantity - 1' WHERE name = 'Aufkleber, rund, ca. 9,5 cm'";
$db->query("UPDATE ssi_rewards SET quantity = 'quantity - 1' WHERE name = 'Aufkleber, rund, ca. 9,5 cm'");
All didn't have success.
Any ideas what im doing wrong?
PS. My biggest problem is time pressure - this project have to go Live tomorrow...
Thanks[br]Alex