chrishayes - Posts

Return to advanced search

Re: Finding topic $start from a phpBB post number

You are brilliant! I must have missed that link.

I've adapted the code and just taken the functions that generate the topic page links. It works flawlessly! Thank you :D
by chrishayes
Tue Mar 16, 2010 7:06 pm
 
Forum: phpBB2 Forum
Topic: Finding topic $start from a phpBB post number
Replies: 8
Views: 2155

Re: Finding topic $start from a phpBB post number

Does anybody have any idea on how to do this?
by chrishayes
Tue Mar 16, 2010 6:24 pm
 
Forum: phpBB2 Forum
Topic: Finding topic $start from a phpBB post number
Replies: 8
Views: 2155

Re: Finding topic $start from a phpBB post number

This is the current SQL in the index.php: $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( " . FORUMS_TABLE . " f LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id ) LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.p...
by chrishayes
Sun Mar 14, 2010 2:18 pm
 
Forum: phpBB2 Forum
Topic: Finding topic $start from a phpBB post number
Replies: 8
Views: 2155

Re: Finding topic $start from a phpBB post number

Thank you for your reply. I've looked at the today-yesturday mod, however it does not seem to change the link, only the date. The code that I need to change is as follows in the index.php: $last_post .= '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $forum_data[$...
by chrishayes
Sun Mar 14, 2010 2:15 pm
 
Forum: phpBB2 Forum
Topic: Finding topic $start from a phpBB post number
Replies: 8
Views: 2155

Re: Finding topic $start from a phpBB post number

Basically, what I'm trying to do is to eliminate the duplicate post pages and have links to the correct topic pages (with a $start variable) if the topic spans over 1 page. I have managed to do this in the topic pages (the mini-post icons) by using this code: if ($start == 0) { $mini_post_url = appe...
by chrishayes
Sat Mar 13, 2010 6:08 pm
 
Forum: phpBB2 Forum
Topic: Finding topic $start from a phpBB post number
Replies: 8
Views: 2155

Finding topic $start from a phpBB post number

I am trying to configure my phpBB installation to find the topic start number from the postid. This currently works with the following code: The SQL: $join_sql_table = ( empty($post_id) ) ? '' : ", " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2 "; $join_sql = ( empty($po...
by chrishayes
Sat Mar 13, 2010 6:03 pm
 
Forum: phpBB2 Forum
Topic: Finding topic $start from a phpBB post number
Replies: 8
Views: 2155

Return to advanced search