one question:
if i add this:
PHP Code:
// START USENET HACK
ORDER BY seq, dateline $postorder
// END USENET HACK
to showthread, the postorder istn't correct. i use the latest release.
why do you use this function in newnews.pl:
PHP Code:
sub order_local_posts {
my $posts = db_fetch("SELECT threadid,postid,dateline FROM post WHERE isusenetpost=0 AND ord=0");
while (my $post = $posts->fetchrow_hashref()) {
my $countposts = db_fetch("SELECT COUNT(*) FROM post WHERE threadid = $post->{threadid} AND dateline < $post->{dateline}");
my $ord = $countposts->fetchrow_array;
$countposts->finish;
db_execute("UPDATE post SET ord=$ord, seq=$ord+1 WHERE postid = $post->{postid}");
} $posts->finish;
}
it counts all posts and update the seq-field. but wgy?? if a member post to a forum, the post is added with seq = 0 and the post is displayed in the middle of the thread. so i removed the "order by seq".
please help, thanx in advance.