Where has he gone???
Moderator: Dream17 Staff
Where has he gone???
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
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
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.
- Squirminator2k
- Dream17 Founder
- Posts: 573
- Joined: Mon Feb 28, 2005 2:07 pm
- Location: Los Angeles, CA
- Contact:
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.
- Cyclaws
- Former Staffmember
- Posts: 83
- Joined: Wed Mar 02, 2005 12:33 pm
- Location: London, England
- Contact:
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
Creator of my blog: http://www.kevinstreetonline.com
Worms Corrispondent for Dream17: cyclaws@dream17.info
- AndrewTaylor
- Regular
- Posts: 157
- Joined: Tue Mar 01, 2005 11:01 am
- Location: Leeds UK
- Contact:
- AndrewTaylor
- Regular
- Posts: 157
- Joined: Tue Mar 01, 2005 11:01 am
- Location: Leeds UK
- Contact:
- AndrewTaylor
- Regular
- Posts: 157
- Joined: Tue Mar 01, 2005 11:01 am
- Location: Leeds UK
- Contact:
- Squirminator2k
- Dream17 Founder
- Posts: 573
- Joined: Mon Feb 28, 2005 2:07 pm
- Location: Los Angeles, CA
- Contact:
Until Ev gets here, I declare this thread within the realsm of pointless banter.
Free fudge for all!
Free fudge for all!
PortsCenter - Gaming's forgotten history. A show all about unique video game ports.
- Cyclaws
- Former Staffmember
- Posts: 83
- Joined: Wed Mar 02, 2005 12:33 pm
- Location: London, England
- Contact:
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
Creator of my blog: http://www.kevinstreetonline.com
Worms Corrispondent for Dream17: cyclaws@dream17.info
- AndrewTaylor
- Regular
- Posts: 157
- Joined: Tue Mar 01, 2005 11:01 am
- Location: Leeds UK
- Contact:
- AndrewTaylor
- Regular
- Posts: 157
- Joined: Tue Mar 01, 2005 11:01 am
- Location: Leeds UK
- Contact:
Yeah, here it is, in viewtopic.php: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.
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";
- AndrewTaylor
- Regular
- Posts: 157
- Joined: Tue Mar 01, 2005 11:01 am
- Location: Leeds UK
- Contact:
Ah, I think this is the bit you should change:
Specifically, the ORDER BY line.
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'];