/**
* delete all preferences for a user in all projects
* returns true if the prefs were successfully deleted
*
* It is far more efficient to delete them all in one query than to
* call user_pref_delete() for each one and the code is short so that's
* what we do
* @param integer $p_user_id A valid user identifier.
* @return void
*/
function user_pref_delete_all($p_user_id)
{
user_ensure_unprotected($p_user_id);
$t_query = 'DELETE FROM {user_pref} WHERE user_id=' . db_param();
db_query($t_query, array($p_user_id));
user_pref_clear_cache($p_user_id);
}
/**
* delete all preferences for a user in all projects
* returns true if the prefs were successfully deleted
*
* It is far more efficient to delete them all in one query than to
* call user_pref_delete() for each one and the code is short so that's
* what we do
* @param int $p_user_id
* @return true
*/
function user_pref_delete_all( $p_user_id ) {
$c_user_id = db_prepare_int( $p_user_id );
user_ensure_unprotected( $p_user_id );
$t_user_pref_table = db_get_table( 'user_pref' );
$query = 'DELETE FROM ' . $t_user_pref_table . ' WHERE user_id=' . db_param();
db_query_bound( $query, Array( $c_user_id ) );
user_pref_clear_cache( $p_user_id );
# db_query errors on failure so:
return true;
}
function user_pref_delete_all($p_user_id)
{
$c_user_id = db_prepare_int($p_user_id);
user_ensure_unprotected($p_user_id);
$t_user_pref_table = config_get('mantis_user_pref_table');
$query = "DELETE FROM {$t_user_pref_table}\r\n\t\t\t\t WHERE user_id='{$c_user_id}'";
db_query($query);
user_pref_clear_cache($p_user_id);
# db_query() errors on failure so:
return true;
}
