/** * 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]; }