public static function save_gifting_tool_permissions($parameters = null) { if (!isset($GLOBALS[TUNA_RW]) || !$GLOBALS[TUNA_RW] || $GLOBALS[TUNA_RW] instanceof Error) { $GLOBALS[TUNA_RW] = WBB_Database::load(TUNA_RO); } try { foreach ($parameters['product_id'] as $key => $value) { $sql = ' INSERT INTO `' . DB_TUNA . '`.`gifting_tool_permissions` '; $sql .= ' SET '; $sql .= ' `user_id` = "' . $GLOBALS[TUNA_RW]->escapeString($parameters['user_id']) . '" ,'; $sql .= ' `product_id` = "' . $GLOBALS[TUNA_RW]->escapeString($value) . '" ,'; $sql .= ' `start_date` = "' . $GLOBALS[TUNA_RW]->escapeString($parameters['start_date']) . '" ,'; $sql .= ' `end_date` = "' . $GLOBALS[TUNA_RW]->escapeString($parameters['end_date']) . '" ,'; $sql .= ' `creation` = NOW()'; $sql .= ' ON DUPLICATE KEY UPDATE'; $sql .= ' `start_date` = "' . $GLOBALS[TUNA_RW]->escapeString($parameters['start_date']) . '", '; $sql .= ' `end_date` = "' . $GLOBALS[TUNA_RW]->escapeString($parameters['end_date']) . '" '; if ($GLOBALS[TUNA_RW]->query($sql)) { TunaLog::info_log(__CLASS__, __FUNCTION__, $_SERVER['REMOTE_USER'], $parameters); } } if ($GLOBALS[TUNA_RW]->query($sql)) { TunaLog::info_log(__CLASS__, __FUNCTION__, $_SERVER['REMOTE_USER'], $parameters); } } catch (Error $e) { TunaLog::error_log(__CLASS__, __FUNCTION__, $_SERVER['REMOTE_USER'], $e->message); throw new Error((int) $e->http_code, $e->message); } }