public static function setSettings($id, array $values)
{
// build parameters
$parameters = array();
foreach ($values as $key => $value) {
$parameters[] = $id;
$parameters[] = $key;
$parameters[] = serialize($value);
}
// build the query
$query = 'INSERT INTO profiles_settings(profile_id, name, value)
VALUES';
$query .= rtrim(str_repeat('(?, ?, ?), ', count($values)), ', ') . ' ';
$query .= 'ON DUPLICATE KEY UPDATE value = VALUES(value)';
FrontendModel::getContainer()->get('database')->execute($query, $parameters);
}