phpBB.de

Code: Alles auswählen

$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";

Code: Alles auswählen

$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 DESC
LIMIT 1";

Code: Alles auswählen

// This rather complex gaggle of code handles querying for topics but
// also allows for direct linking to a post (and the calculation of which
// page the post is on and the correct display of viewtopic)

$join_sql_table = (!$post_id) ? '' : ", " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2 ";
$join_sql = (!$post_id) ? "t.topic_id = $topic_id" : "p.post_id = $post_id AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= $post_id";
$count_sql = (!$post_id) ? '' : ", COUNT(p2.post_id) AS prev_posts";
 
$order_sql = (!$post_id) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC";

Code: Alles auswählen

// This rather complex gaggle of code handles querying for topics but
// also allows for direct linking to a post (and the calculation of which
// page the post is on and the correct display of viewtopic)

$join_sql_table = (!$post_id) ? '' : ", " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2 ";
$join_sql = (!$post_id) ? "t.topic_id = $topic_id" : "p.post_id = $post_id AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= $post_id";
$count_sql = (!$post_id) ? '' : ", COUNT(p2.post_id) AS prev_posts";
 
$order_sql = (!$post_id) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id DESC";

Code: Alles auswählen

######################################################## 
## Mod Title: posts_sort_newest_first 
## Mod Version: 1.0 
## Author: Tomas Rejdal <t-o-m@seznam.cz> 
## http://www.metroweb.cz 
## 
## 
## Installation Level: easy 
## Installation Time: 2 Minutes 
## Files To Edit: viewtopic.php 
## Include File: 
############################################################## 
## This MOD is released under the GPL License. 
## Intellectual Property is retained by the MOD Author(s) listed above 
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/ 
############################################################## 
## Authors Notes: compatible for vs. 2.0.4 - 2.0.13 
## 
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 

# 
#--- [ OPEN ] -------- 
# 

viewtopic.php 

# 
#-- [ FIND ]---- 
# 
# (line 195) 

if ( !empty($post_id) ) 
{ 
$start = floor(($forum_topic_data['prev_posts'] - 1) / $board_config['posts_per_page']) * $board_config['posts_per_page']; 
} 

# 
#---- [ REPLACE WITH ]----- 
# 

// 
// Decide how to order the post display 
// 
if ( !empty($HTTP_POST_VARS['postorder']) || !empty($HTTP_GET_VARS['postorder']) ) 
{ 
$post_order = (!empty($HTTP_POST_VARS['postorder'])) ? $HTTP_POST_VARS['postorder'] : $HTTP_GET_VARS['postorder']; 
$post_time_order = ($post_order == "desc") ? "DESC" : "ASC"; 
} 
else 
{ 
$post_order = ( $userdata['user_post_sort'] == TRUE ) ? 'asc' : 'desc'; 
$post_time_order = ( $userdata['user_post_sort'] == TRUE ) ? 'ASC' : 'DESC'; 
} 

if(!empty($post_id) ) 
{ 
$posts_before = ( $post_order == 'desc' )? (($forum_topic_data['topic_replies'] + 1) - $forum_topic_data['prev_posts']) : ($forum_topic_data['prev_posts'] - 1); 
$start = floor( $posts_before / $board_config['posts_per_page']) * $board_config['posts_per_page']; 
} 

# 
#-- [ FIND ]---- 
# 
# (line 373) 

if ( $post_time_order == 'ASC' ) 

# 
#---- [ REPLACE WITH ]----- 
# 

if ( $post_time_order == 'DESC' ) 

# 
#--- [ DELETE ] -------- 
# 
# (line 358) 

// 
// Decide how to order the post display 
// 
if ( !empty($HTTP_POST_VARS['postorder']) || !empty($HTTP_GET_VARS['postorder']) ) 
{ 
$post_order = (!empty($HTTP_POST_VARS['postorder'])) ? $HTTP_POST_VARS['postorder'] : $HTTP_GET_VARS['postorder']; 
$post_time_order = ($post_order == "asc") ? "ASC" : "DESC"; 
} 
else 
{ 
$post_order = 'asc'; 
$post_time_order = 'ASC'; 
} 

# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM