All pastes #196024 Raw Edit

Anonymous

public text v1 · immutable
·published 2006-10-10 07:39 UTC
rendered paste body
function update_stats($user_id, $stats)
{
	if (!is_array($stats))
		trigger_error('$stats must be an array', E_USER_ERROR);

	$sql_array = array();
	foreach ($stats as $k=>$v)
	{
		$sql_array[] = '`' . $k . '` = ' . intval($v);
	}

	global $db;
	$sql = "UPDATE bet_users_stats SET " . implode(', ', $sql_array) . " WHERE user_id = " . intval($user_id);
	if (!$db->sql_query($sql))
	{
		trigger_error('ERROR: Unable to update stats');
	}
}