All pastes #365761 Raw Edit

Untitled

public php v1 · immutable
#365761 ·published 2007-02-21 05:43 UTC
rendered paste body
/** * Gets the image and name of the awards for a user, or group of users * * @parameter	$user_id	mixed	An array or int of user id(s). * @return					mixed	The data for the user(s) */function get_awards_data($user_id){	global $db;	$where_sql = ( is_array($user_id) ) ? ('au.user_id IN (' . implode(',', $user_id) . ')') : ('au.user_id = ' . (int) $user_id);		if ( (is_array($user_id) && sizeof($user_id) < 1) || empty($user_id) )	{		return false;	}		$sql = $db->sql_build_query('SELECT', array(		'SELECT'	=> 'au.user_id, a.award_image, a.award_name',		'FROM'		=> array(AWARDS_USERS_TABLE => 'au', AWARDS_TABLE => 'a'),		'WHERE'		=> $where_sql,			'AND'	=> 'au.award_id = a.award_id',		'ORDER_BY'	=> 'a.award_name')	);	$result = $db->sql_query($sql);		$resultset = array();	while ( $row = $db->sql_fetchrow($result) )	{		$resultset[ $row['user_id'] ] = $row;	}		$db->sql_freeresult($result);		return ( is_array($user_id) ) ? $resultset : $resultset[$user_id];}