Latest news on the index (invision function)

[Eagle Creek]

I did.. Forum 35..

/*
// Example of how to include a seperate file:

ob_start();
include('yourheader.html');
$your_code = ob_get_contents();
ob_end_clean();

// Now place a reference to $your_code where you want the resulting HTML to be displayed.
// This will most likely be the header or footer template.
*/
$getnews = $DB_site->query_first("SELECT threadid, title ".TABLE_PREFIX."thread WHERE forumid=35 ORDER BY lastpost DESC LIMIT 1");

Gives:

Database error in vBulletin 3.0.4:

Invalid SQL: SELECT threadid, title thread WHERE forumid=35 ORDER BY lastpost DESC LIMIT 1
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE forumid=35 ORDER BY lastpost DESC LIMIT 1' at line 1

mysql error number: 1064

Date: Thursday 12th of May 2005 02:30:33 PM
Script: http://www.antispywareoffensief.nl/f...e&pp=60&page=1
Referer: http://www.antispywareoffensief.nl/f...e&pp=60&page=1
Username: Admin
IP Address: *

[cinq]

<a href="https://vborg.vbsupport.ru/showpost.php?p=652555&postcount=6" target="_blank">Sorry try the code again</a>

[Eagle Creek]

Whaha, I will. Hang on a sec .

http://www.antispywareoffensief.nl/forum/index.php?

(and with this one, can I select more forums? (I dont need that currently; just interested)

THANKS ALOT!

Uuuhm.. I have another little question. Would this format be possible:


Latest news: TOPICTITLE (date - time)

"Latest News: 'Thanks cinq (12-05-2005; 14:55)'"

?

[cinq]

Great

Yes you can, just use this :

PHP Code:

$getnews = $DB_site->query_first("SELECT threadid, title FROM ".TABLE_PREFIX."thread WHERE (forumid=X OR forumid=X OR forumid=X) ORDER BY lastpost DESC LIMIT 1"); 


Note the OR forumid=X portions. Just add more if you need to and replace the Xs with the respective forumids of those forums you want to check.

[Eagle Creek]

Originally Posted by cinq

Great

Yes you can, just use this :

PHP Code:

$getnews = $DB_site->query_first("SELECT threadid, title FROM ".TABLE_PREFIX."thread WHERE (forumid=X OR forumid=X OR forumid=X) ORDER BY lastpost DESC LIMIT 1"); 


Note the OR forumid=X portions. Just add more if you need to and replace the Xs with the respective forumids of those forums you want to check.

Coool! Thx!

And my Q about date time? Is that much more work?

[cinq]

PHP Code:

$getnews = $DB_site->query_first("SELECT threadid, title, lastpost FROM ".TABLE_PREFIX."thread WHERE (forumid=X OR forumid=X OR forumid=X) ORDER BY lastpost DESC LIMIT 1"); 
$lastpostdateline = vbdate($vboptions['dateformat'],$getnews['lastpost'],true); 


Forumhome template put this :

Latest news: <a href="showthread.php?t=$getnews[threadid]">$getnews[title]</a> - $lastpostdateline

[Eagle Creek]

Hmm... You changed something.

title FROM ".TABLE_PREFIX.
==>
title, lastpost FROM ".TABLE_PREFIX.


Why did you do that?

http://www.antispywareoffensief.nl/forum/index.php

YOU MADE AN EAGLE HAPPY!


Thank you so much! If there's something I can do for you call me!

[cinq]

That is to capture last post datetime for that thread

[Eagle Creek]

Originally Posted by cinq

That is to capture last post datetime for that thread

Ok.. But when I have the following situation:

I post new thread (1) 3 PM
someone replys to that one 3.5 PM
I post new thread (2) 4 PM
someone replys to first one 4.5 PM


Thread 1 will be displayed at the index, isnt it?

[Eagle Creek]

Is it possible to look only at the post date of the FIRST post?

Because when people now react on a two day old post it shows up on the index and it looks like a recent post..