Now this is amusing......

[Kamal]

was looking for how many women are on the forums and I didnt realize so many of the peeps we thought were men are actually on the wrong side of the road....

http://www.mercuryserver.com/forums/profile.php?mode=buddy&sub=memberlist&filter=username&comp=IN&order=user_gender&sort=DESC

-e-

[tiddles]

Re: Now this is amusing......

SELECT DISTINCT 
				u.*,
(CASE WHEN i.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_my_friend_virt,
i.buddy_visible AS user_my_visible_virt,
(CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_my_ignore_virt,
(CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_friend_virt,
b.buddy_visible AS user_visible_virt,
(CASE WHEN b.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_ignore_virt,
(CASE WHEN (u.user_id = 93 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (1 = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR (1 = 2 AND 0 = 1) ) ) ) )) THEN (CASE WHEN u.user_session_time >= (1095341731-300) THEN 1 ELSE 0 END) ELSE '' END) AS user_online_virt,
u.username AS username_virt,
(CASE WHEN (u.user_id = 93 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (1 = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR (1 = 2 AND 0 = 1) ) ) ) )) THEN u.user_regdate ELSE '' END) AS user_regdate_virt,
(CASE WHEN (u.user_id = 93 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (1 = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR (1 = 2 AND 0 = 1) ) ) ) )) THEN u.user_lastvisit ELSE '' END) AS user_lastvisit_virt,
(CASE WHEN (u.user_id = 93 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (1 = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR (1 = 2 AND 0 = 1) ) ) ) )) THEN u.user_posts ELSE '' END) AS user_posts_virt,
(CASE WHEN (u.user_id = 93 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR (1 = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR (1 = 2 AND 0 = 1) ) ) ) )) THEN r.rank_title ELSE '' END) AS user_rank_title_virt,
(CASE WHEN (u.user_id = 93 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 0 <> 1 ) AND u.user_allow_real = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewreal = 1 OR (1 = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewreal = 2 OR (1 = 2 AND 0 = 1) ) ) ) )) THEN u.user_flag ELSE '' END) AS user_flag_virt,
(CASE WHEN (u.user_id = 93 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 0 <> 1 ) AND u.user_allow_real = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewreal = 1 OR (1 = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewreal = 2 OR (1 = 2 AND 0 = 1) ) ) ) )) THEN u.user_flag_province ELSE '' END) AS user_flag_province_virt,
u.user_points AS user_points_virt,
				1 AS user_generic_display,
(CASE WHEN (u.user_id = 93 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 0 <> 1 ) AND u.user_allow_real = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewreal = 1 OR (1 = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewreal = 2 OR (1 = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_real_display,
(CASE WHEN (u.user_id = 93 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (1 = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR (1 = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_viewonline_display,
(CASE WHEN (u.user_id = 93 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR (1 = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR (1 = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_webdisplay_display
			FROM ((((
phpbb_users AS u)
LEFT JOIN phpbb_buddy AS i ON i.user_id=93 AND i.buddy_id=u.user_id)
LEFT JOIN phpbb_buddy AS b ON b.user_id=u.user_id AND b.buddy_id=93)
LEFT JOIN phpbb_ranks AS r ON (u.user_rank > 0 AND r.rank_special <> 0 AND r.rank_id = u.user_rank) OR (u.user_rank = 0 AND r.rank_special = 0 AND u.user_posts >= r.rank_min AND u.user_posts < r.rank_max))
			WHERE u.user_id <> -1
			ORDER BY

:ROFLMAO: :ROFLMAO:

[mixu]

Re: Now this is amusing......

Am I suppposed to get a general error page?

[arielus]

is all i got too :P

[skahound]

Just plain gibberish! We'll just have to ask for all the hotties to identify themselves.

[Kamal]

really ?? I click on the link and seems to work fine for me......

-e-

[tiddles]

where is the option to sort the memberlist by gender?

[skahound]

really ?? I click on the link and seems to work fine for me......

-e-

Keep braggin! You apparently have the golden schlong around here!

[Kamal]

Go to memberlist, click on the yello arrow next to User fields list, choose gender, click update, when the page appears, on the list of members, click on the yellow arrow next to gender and you're golden

-e-

[mixu]

Re: Now this is amusing......

42 of the female species - is that right?

1 DreamGirlie
2 chlo? harris
3 STLChristy
4 dawnx
5 HoneyBearKelly
6 ubiqe
7 Thorin
8 Trancelucent One
9 SilverFoxx
10 diskk
11 Silicone Soul
12 very*
13 chanty
14 energizerbunny
15 sharon
16 ReTrOGurLe
17 viv
18 Pebbles
19 ladyhayley
20 Szofibo
21 dusk
22 headrushmusic
23 MinkySlack
24 catalina
25 s.bella.k
26 dimax
27 ale18
28 CrazyMadFlyGirl
29 littleannie
30 psyrel
31 Villu
32 Ariel Cybana
33 pakita
34 adia
35 hear_my_name
36 angelitam
37 lilyashes
38 Echo of Silence
39 gordi
40 Baby*doll
41 brandie
42 patots

[Jibgolly]

not sure if dawnx counts.

[influx]

Re: Now this is amusing......

42 out of 2000 ain't bad...


pssssshh! it's a frickin' sausage fest up in here!!

[beto]

Ouch...

[refine]

Re: Now this is amusing......

how about a women of MS calendar? :P