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);
}
}
