how did they manage to do this...

[karmanis]

---> Elite Trader

I am talking about the multiple "lastpost" for a specific forum.

I want to put such a "Last 10 posts/threads" in my forumdisplay template to be shown at the right of each forum categorized in my board, as a collumn next to Threads and Posts...instead of the single Last Post collumn.

Is there any known hack that manages such a thing ?

If I use includes pointing to posted php hacks, I wouldnt be able to dynamically specify which forum's last posts I want to show. It must be a way to associate the last posts with the forum's id, using the variables already loaded in forumdisplay, but I dont know php to add such functionality...

any help is much appreciated !



(yes... that link demonstrates a modified vb !!!)

[Zzed]

Use the following query:

select threadid, title from thread where forumid=XX order by lastpost desc limit 10;

Where XX is the forum number in question. And you will get the last 10 threads in forum XX.

And you can use the threadid to create the link to the actual thread.

[karmanis]

Unfortunately my knowledge of php/sql is very limited. However, I managed to found the following related information...

in forumdisplay_forumbit_level2_post template I can see:

<td bgcolor="{secondaltcolor}"><normalfont>$forum[replycount]</normalfont></td>
<td bgcolor="{firstaltcolor}"><normalfont>$forum[threadcount]</normalfont></td>
<td bgcolor="{secondaltcolor}"><smallfont>$forum[lastpostinfo]</smallfont></td>
<td bgcolor="{firstaltcolor}"><smallfont>$forum[moderators]</smallfont></td>



so I am looking to modify the "lastpostinfo" variable .. which is defined in forumdisplay.php :

// dates
if ($forum['lastpost']>0) {
$forum['lastpostdate']=vbdate($dateformat,$forum['lastpost']);
$forum['lastposttime']=vbdate($timeformat,$forum['lastpost']);
eval("\$forum['lastpostinfo'] = \"".gettemplate('forumhome_lastpostby')."\";");
} else {
$forum['lastpostinfo']='Never';
}


But how exactly should I place the query here ? Could you help me with this please ?

many thanks !


(PS. Is it possible to modify the query to be applied for all the childforums of the specified forumid ??? )

[karmanis]

Ok, what I have done so far is to place this code in forumdisplay.php, inside makeforumbit function ..

PHP Code:

//my last posts
        $lastmsgs = $DB_site->query("SELECT threadid,title
                                FROM thread
                                WHERE forumid = 6 ORDER BY lastpost DESC limit 10");

        while($thislast=$DB_site->fetch_array($lastmsgs)) {
                $lastmsgsid = "$thislast[threadid]";
                $lastmsgstitle = "$thislast[title]";
                eval("\$showlastposts = \"".gettemplate('forumhome_lastmsgstemp')."\";");
        }


//my last posts -end 


However, there are two issues:

1) I don't know what variable to use to apply this code dynamically to each forum that is categorized in forumslist. Above, I have placed forumid=6 temporarily. I tried the variable $forum[forumid] but it doesn't bring me the right forum. What I want is to place a variable that in each cycle of the makeforumbit WHILE statement (that calculates the code for each single categorized forum in forumdisplay), that variable will get the specific forum and all it's childforums (subforums, subcategories).


2)my second problem is that the code above displays only the last result of the table generated. I tried to parse the results table with the while statement I have placed in the code, but it does not work. The "forumhome_lastmsgstemp" that you can see simply contains:

<a href="showthread.php?s=$session[sessionhash]&threadid=$lastmsgsid">$lastmsgstitle</a>

how can I make an evaluation function that will keep all the results of the table ? It seems impossible to me since for each result I have to call the template that generates html (the link), and how to store html inside php to keep all the lastposts links ???


I desperately need your expertise :cross-eyed:

[karmanis]

for those that didn't follow the link, here is a screenshot of the functionality I am trying to describe...

[Dean C]

I had a long discussion with some people in the vBulletin.org chat room about displaying the last x posts for each forum instead of only one. If anyone actually codes this and has it working i'd be most curious to see how they went about it

- miSt

[karmanis]

No insights at all ?

I am sure that there exist at least 5 hackers here in vb.org for whom this functionality achievement is a matter of minutes!

And the good news is that this hack has already been coded in elitetrader.com/vb , so it is technically possible. The problem is that we can't get it from them since they are a commercial site.

Any willing experts ?

thank you sooo much

[karmanis]

I have made a Hack Request in this thread , posting some code that would achieve the core part of the discussed functionality.

The problem that remains is how to store the results for the last5posts in a table and show them alltogether in html format when the variable is triggered by templates in forumdisplay section. The code is working when just using an echo function, but we need to find a trick to have the results in a html table.

I don't believe that there are no php coders here that could manage to do this!

Please, take a look at the thread stated above and share your wiseness, to embody this valuable functionality in vb


many thanks for any insights