Where has he gone???

Sit yourselves down in here and have a chinwag about whatever takes your fancy.

Moderator: Dream17 Staff

User avatar
thomasp
Newbie
Posts: 16
Joined: Wed Jun 01, 2005 11:54 am

Where has he gone???

Post by thomasp » Tue Sep 20, 2005 8:15 pm

Where's FatWhitey, aka Ev gone?

I haven't seen him on the T17 forums or here in ages.....


Note: I'm posting this here, since I remember he had close links with this site :)

User avatar
Pooka
Staff Writer
Posts: 363
Joined: Mon Feb 28, 2005 8:57 pm
Location: London
Contact:

Post by Pooka » Tue Sep 20, 2005 9:14 pm

He left the Dream17 Staff team. I don't know why he's vanished from the forum scene though.
Superfrog: the best things in life are green.

User avatar
Squirminator2k
Dream17 Founder
Posts: 573
Joined: Mon Feb 28, 2005 2:07 pm
Location: Los Angeles, CA
Contact:

Post by Squirminator2k » Tue Sep 20, 2005 11:53 pm

I spoke to him on MSN a while back. He's doing okay, he seems to have changed a lot. He certainly seems a lot more upbeat...
PortsCenter - Gaming's forgotten history. A show all about unique video game ports.

User avatar
Zeor
Senior
Posts: 737
Joined: Thu May 26, 2005 3:21 am
Location: Science and Outer Space

Post by Zeor » Wed Sep 21, 2005 8:03 pm

Whoa. Maybe he got one of those... life thingies or something.
Zero72, Team17 Forum member (and former Cartoonist), June 2002 - June 2013.

Zeor TV - [fart noise]!

User avatar
thomasp
Newbie
Posts: 16
Joined: Wed Jun 01, 2005 11:54 am

Post by thomasp » Thu Sep 22, 2005 10:01 am

Meh, those "life" things are overrated.

eBay's got some good deals going though :)

User avatar
Cyclaws
Former Staffmember
Posts: 83
Joined: Wed Mar 02, 2005 12:33 pm
Location: London, England
Contact:

Post by Cyclaws » Thu Sep 22, 2005 4:19 pm

I used to have one, but I sold it a while ago.
Webmaster of WormsTournaments: http://www.wormstournaments.co.uk
Creator of my blog: http://www.kevinstreetonline.com
Worms Corrispondent for Dream17: cyclaws@dream17.info

User avatar
thomasp
Newbie
Posts: 16
Joined: Wed Jun 01, 2005 11:54 am

Post by thomasp » Fri Sep 23, 2005 4:30 pm

Cyclaws wrote:I used to have one, but I sold it a while ago.
*reports new admin for going off-topic*

*can't find report button*

*sulks*

User avatar
Pooka
Staff Writer
Posts: 363
Joined: Mon Feb 28, 2005 8:57 pm
Location: London
Contact:

Post by Pooka » Fri Sep 23, 2005 7:15 pm

Nobody stays *on* topic in this forum.
Superfrog: the best things in life are green.

User avatar
Zeor
Senior
Posts: 737
Joined: Thu May 26, 2005 3:21 am
Location: Science and Outer Space

Post by Zeor » Fri Sep 23, 2005 10:27 pm

Topic...?
Zero72, Team17 Forum member (and former Cartoonist), June 2002 - June 2013.

Zeor TV - [fart noise]!

User avatar
AndrewTaylor
Regular
Posts: 157
Joined: Tue Mar 01, 2005 11:01 am
Location: Leeds UK
Contact:

Post by AndrewTaylor » Fri Sep 23, 2005 10:39 pm

Yes please. Or a Fuse, if you've got one.

User avatar
Zeor
Senior
Posts: 737
Joined: Thu May 26, 2005 3:21 am
Location: Science and Outer Space

Post by Zeor » Sat Sep 24, 2005 9:48 am

Well, no, but I might be able to bring you some fudge from work next time somebody leaves 50 pounds of it on the floor for me to clean up.
Zero72, Team17 Forum member (and former Cartoonist), June 2002 - June 2013.

Zeor TV - [fart noise]!

User avatar
thomasp
Newbie
Posts: 16
Joined: Wed Jun 01, 2005 11:54 am

Post by thomasp » Sat Sep 24, 2005 10:34 am

AAAAAAARRRRRRRRRRGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!!!

SPAM!!!

I think I'll go hide in T17's fanart forum

User avatar
AndrewTaylor
Regular
Posts: 157
Joined: Tue Mar 01, 2005 11:01 am
Location: Leeds UK
Contact:

Post by AndrewTaylor » Sat Sep 24, 2005 1:38 pm

thomasp wrote:SPAM!!!
I'd prefer a Fuse.

User avatar
AndrewTaylor
Regular
Posts: 157
Joined: Tue Mar 01, 2005 11:01 am
Location: Leeds UK
Contact:

Post by AndrewTaylor » Sat Sep 24, 2005 3:57 pm

You've said that before. I'll believe it when I see it.

User avatar
Squirminator2k
Dream17 Founder
Posts: 573
Joined: Mon Feb 28, 2005 2:07 pm
Location: Los Angeles, CA
Contact:

Post by Squirminator2k » Sat Sep 24, 2005 4:10 pm

Until Ev gets here, I declare this thread within the realsm of pointless banter.

Free fudge for all!
PortsCenter - Gaming's forgotten history. A show all about unique video game ports.

User avatar
Cyclaws
Former Staffmember
Posts: 83
Joined: Wed Mar 02, 2005 12:33 pm
Location: London, England
Contact:

Post by Cyclaws » Sat Sep 24, 2005 6:22 pm

I really love the server's clock.
Webmaster of WormsTournaments: http://www.wormstournaments.co.uk
Creator of my blog: http://www.kevinstreetonline.com
Worms Corrispondent for Dream17: cyclaws@dream17.info

User avatar
AndrewTaylor
Regular
Posts: 157
Joined: Tue Mar 01, 2005 11:01 am
Location: Leeds UK
Contact:

Post by AndrewTaylor » Sat Sep 24, 2005 7:51 pm

Yeah. Could you hack the forum script or something to order posts by post_id instead of by time?

User avatar
Pooka
Staff Writer
Posts: 363
Joined: Mon Feb 28, 2005 8:57 pm
Location: London
Contact:

Post by Pooka » Sat Sep 24, 2005 8:26 pm

OMFG WTF LOL HAX0RZ ETC.0R!
Superfrog: the best things in life are green.

User avatar
AndrewTaylor
Regular
Posts: 157
Joined: Tue Mar 01, 2005 11:01 am
Location: Leeds UK
Contact:

Post by AndrewTaylor » Sat Sep 24, 2005 10:10 pm

Yeah, here it is, in viewtopic.php:

Code: Select all

				$sql = "SELECT p.post_id
					FROM " . POSTS_TABLE . " p, " . SESSIONS_TABLE . " s,  " . USERS_TABLE . " u
					WHERE s.session_id = '$session_id'
						AND u.user_id = s.session_user_id
						AND p.topic_id = $topic_id
						AND p.post_time >= u.user_lastvisit
					ORDER BY p.post_time ASC
					LIMIT 1";
I bet if you switched "ORDER BY p.post_time ASC" to "ORDER BY p.post_id ASC" it'd order them right. It'd mess it up if you merged threads, but since phpbb doesn't have that feature I'm not worried.

User avatar
AndrewTaylor
Regular
Posts: 157
Joined: Tue Mar 01, 2005 11:01 am
Location: Leeds UK
Contact:

Post by AndrewTaylor » Sat Sep 24, 2005 11:42 pm

Ah, I think this is the bit you should change:

Code: Select all

$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_sitename, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*,  pt.post_text, pt.post_subject, pt.bbcode_uid
	FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt
	WHERE p.topic_id = $topic_id
		$limit_posts_time
		AND pt.post_id = p.post_id
		AND u.user_id = p.poster_id
	ORDER BY p.post_time $post_time_order
	LIMIT $start, ".$board_config['posts_per_page'];
Specifically, the ORDER BY line.

Post Reply