phpBB.de

Code: Alles auswählen

			// get the 10 random users and their avatars
			$sql = 'SELECT user_id, username, user_colour, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height 
				FROM ' . USERS_TABLE . "
				WHERE user_type <> 2
				AND user_avatar <> ''
				AND user_inactive_time = 0 
				ORDER BY RAND() LIMIT 10";
			$result = $db->sql_query($sql);

			while ($row = $db->sql_fetchrow($result))
			{
				$last_avatar_url = append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $row['user_id']);
				$last_avatar = '<a href="' . $last_avatar_url . '">' . get_user_avatar($row['user_avatar'], $row['user_avatar_type'], $row['user_avatar_width'], $row['user_avatar_height']) . '</a>';
				
				// Assign index specific vars
				$template->assign_block_vars('random_members', array(
					'RANDOM_USERNAME'	=> get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
					'RANDOM_AVATAR'	=> $last_avatar,
				));
			}
			$db->sql_freeresult($result);

Code: Alles auswählen

AND user_avatar <> ''

Code: Alles auswählen

ORDER BY RAND() LIMIT 10";

Code: Alles auswählen

<!-- BEGIN random_members -->
			        <td>
				  	  <table border="0" width="120">
				        <tr align="center" height="65" >
						  <td width="120" height="100" >{random_members.RANDOM_AVATAR}
						  </td>
						</tr>
						<tr align="center" valign="bottom">
					  	  <td>{random_members.RANDOM_USERNAME}
					  	  </td>
						</tr>
				  	  </table>
					</td>
				  <!-- END random_members -->

Code: Alles auswählen

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);