Latest post id and thread id on index page

[freakyshiat]

how can I do that?

thanks...

[g-force2k2]

there's a hack for something similar... try searching the hacks database or just the hacks list themselves

g-force2k2

[freakyshiat]

theres a hack that counts the posts in a thread, like what is installed at this site ; I guess I need a simple database query that will grab the latest post and thread id and output that on the index page

[g-force2k2]

open index.php

find:

// get total posts

under it add:

PHP Code:

// +++++++ Last Post Thread ID [ Start ] +++++++
$getid=$DB_site->query('SELECT threadid FROM thread ORDER BY lastpost DESC LIMIT 1');
$id=$getid[threadid];
$lastthread="<a href=\"showthread.php?s=$session[sessionhas]&threadid=$id">$id</a>";
// +++++++ Last Post Thread ID [ End ] +++++++ 


then in the forumhome template place [php]$lastthread[/php where you want it to appear... it'll display the number like you were looking for...

i think this'll work but not positive and not sure if this is what you were looking for?

g-force2k2

[freakyshiat]

yeah u have the right idea but its generating a blank index page when I add your code

[g-force2k2]

well i'll take a look and repost it in a few... you want the id number though yes? not the name? i'll test it... didn't try i yet...

g-force2k2

Edit: just saw i forgot to block out coding ;\ and you didn't get a parse error?

replace the coding i gave you with this instead:

PHP Code:

// +++++++ Last Post Thread ID [ Start ] +++++++
$getid=$DB_site->query('SELECT threadid FROM thread ORDER BY lastpost DESC LIMIT 1');
$id=$getid[threadid];
$lastthread="<a href=\"showthread.php?s=$session[sessionhas]&threadid=$id\">$id</a>";
// +++++++ Last Post Thread ID [ End ] +++++++ 


[Zzed]

Try this:

PHP Code:

$threadinfo=$DB_site->query_first("select thread.threadid, thread.title, lastpost, lastposter, post.postid from thread left join post on (post.\
threadid = thread.threadid) where forumid = $forumid order by postid desc limit 1;");
echo "<a href=\"showthread.php?s=$session[sessionhash]&postid=$threadinfo[postdid]#post$threadinfo[postid]\">$threadinfo[title]</a>"; 


[g-force2k2]

Zzed you forgot to block the quote at the end and i believe that Fazle wants the number not the name

g-force2k2

[Zzed]

LOL @ g-kforce2k2

And you spelled sessionhash as sessionhas.

[freakyshiat]

Zzed thanks for the help, but yeah I just want the number ; the latest threadid and postid.

g-force2k2, I added the new code but when I add the $lastthread in forumhome, no number comes up ; index page doesnt show up as blank anymore, but the threadid doesnt show up either