All pastes #196028 Raw Edit

Stuff

public text v1 · immutable
·published 2006-10-10 07:43 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)
	{
		if (is_int($v) || is_bool($v))
		{
			$v = intval($v);
		}
		else if (is_float($v))
		{
			$v = floatval($v);
		}
		else if (is_string($v))
		{
			$v = str_replace('\"', '""', $v);
		}

		$sql_array[] = '`' . $k . '` = ' . $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');
	}
}