Help, please?

I run a VERY high traffic site. I love the idea of including recent content from my message boards on my homepage.

However, running another query to the DB can be a system resource "eater." Has anyone thought of creating a version of this hack that would query ever "X" minutes and write the results to a txt file?

This way, the same effect is achieved (basically), and connections to the database is reduced.

Give me your thoughts. If enough people are interested, I may look into doing it (with my limited skillset).

Thanks,

*b*

Hi,

I really like the script - Thanks.

However, when mySQL is down it can bring normal page loading to a standstill - If there anything that I could add which would only exectue the script if mySQL was working ok.

Thanks in advance.

Tubedogg,

your script is, um, really nice. :D

I am concerned that I cannot change the font size/color, or type. It just doesn't show any changes in Netscape 4.7 for mac and minumal changes in IE (cannot change font color, but can change font size and type in IE)

Is there some solution for this? Otherwise, it is a really cool script, and I'd really like to use it.

Kevin,

I configured everything and followed your instructions, but I couldn't get it to work. When I used <!--#include file="/community/boards/admin/last10.php"-->, it said "there has been an error in processing this directive". So I tried <!--#include virtual="/community/boards/admin/last10.php"--> and it says:
I am trying to run this on a .shtml page with SSI. I have had to use .htm to get my other SSIs to work, what can I do here? :(

Where are you actually calling it from? Like what directory does it reside in? The admin directory?

Assuming yes, you should leave $path blank since config.php is in the same directory.

Yes, both .php files are in the /admin folder, with the config.php file. What do I need to do?

Just set
$path="";
in last10config.php. :)

Maybe we misunderstood each other, but it didn't work:

tubedogg and all,

This is a marvelous hack and works like a charm :) Thank you.

Maybe I missed it in this long thread.

Could this script be modified to insert topics/threads and such on another server? My vB is on one dedicated server and I would like to use this script to insert topics/threads on my other site which is on another dedicated server?

I don't want to be a mooch so if you would prefer to do this for money I understand and respect that. Just email me with a quote.

Natch, their would be a performance/load hit but I can live with that.