[Sharg]

04-14-03 at 10:05 AM KuraFire said this in Post #84
Actually, you can do it without the newthread.php modification and the mysql database modification. Instead, you can use this hack WITHOUT MODIFYING ANYTHING to your site. Just open newsportal.php from the hack, and use this query at the start:

PHP Code:

SELECT thread.threadid as tid, thread.title as ttitle, 
thread.replycount as treply, thread.postusername as user, 
thread.postuserid as userid, thread.dateline as dateline, 
post.pagetext as pagetext, MIN(p.postid) as postid 
FROM thread 
LEFT JOIN post USING (threadid) 
WHERE forumid=$newsforum 
GROUP BY thread.threadid 
ORDER BY thread.threadid DESC 
LIMIT $newslimit 


That should work fine, and you don't have to modify any files or your database anymore, with that query.

Hello, what do you mean exactly when you say to run this query at the start of the file ? Should we siply copy past this, and where ?

Thanks in advance,
Shart