vb.org Archive - Last XX Posts on non-vB page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Last XX Posts on non-vB page (https://vborg.vbsupport.ru/showthread.php?t=12324)

Works great! I'm using vBulletin 2.2.6 and have the last (5) posts displaying on my homepage at wildtexas.com.

I'm getting this error whenever i call up last10.php in my browser:

PHP Code:


		
			
Can't select database

and that is all it says... how can i resolve this?

Thanks in Advance :D

thanks for the great hack!

is it possible to add a "reply" or "comment" button so users can click on it to reply to a post from the display?

I put this on my Xoops site. it kept returning a blank page in the block until I removed the <? and ?> , this tip might be usefull to someone putting the call "<? include("last10.php"); ?>" in an Xoops block.

thanks.

Is it possible to edit this hack to NOT show thread that are in a PRIVATE FORUM?

I've got this running on a beta site for my personal site.. but it shows threads from ALL forums...even the private ones.. which I can't have.

Please lemme know.

Aceman
http://www.scifi-meshes.com/tk421/ <--- working beta.

Put the private forum's ids in the exclude option in last10config.php

[QUOTE]Originally posted by Mist
I'm getting this error whenever i call up last10.php in my browser:

PHP Code:

Can't select database

and that is all it says... how can i resolve this?

Thanks in Advance :D

Can somebody help me get this hack so that it highlights the latest threads within 24 hours a different color?

I am only using the hack 6 times on my frontpage :p but this would really really help me. I don't know much about php, but I know how to follow instructions. :D

If somebody could help me I would greatly appreciate it.

Thanks!

I'm getting the same error as MIST (Can't select database) can anyone help me?

so if I want to put link the latest post out in my normal html index page. I will have to put this code where I want the link to be?

<? include("last10.php"); ?>
To include it on a server-parsed page (.shtml, .shtm, .ssi, etc.):


and where do I upload these files to? domain.com/forums/ ?
???
thanks

damn has any one got this to work on vb index.php? Because I got it to work but cant call the php file ? can some one help me out?

Does anybody know how to get this hack so that when you click on the titles it takes you to the first post in that thread and not down the page SOMEWHERE in the thread?

I know this shouldn't that hard to fix and was hoping somebody here would be kind enough to help me out on this.

Thanks for any help you can provide.

Quote:

Originally posted by kaost451
damn has any one got this to work on vb index.php? Because I got it to work but cant call the php file ? can some one help me out?

Yes. Firefly helped me out with this one, it's a modification to code posted a few months back here by wajones.

First, put this in your phpinclude template:

PHP Code:


		
			
function getLast10() {

    global $last10;

    ob_start(); 

    include_once('./last10.php');

    $last10 = ob_get_contents(); 

    ob_end_clean();

}

getLast10();

Now, in the last10.php script itself, comment the following out (it's near the top)

PHP Code:


		
			
require("$path/config.php");

$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Can't open connection to MySQL");

mysql_select_db($dbname) or die("Can't select database");

Now just stick the variable $last10 wherever you want it in your templates, including the forumhome (index) and you are set.

Note that if you want to use this script in more than one place - say, one on your vb index (or it's own template, like I do) and one on your non-vb home page - you will want to use two instances of it. I renamed one last5.php and use it for my front page minus the change I outlined above.

thank you so much works GREAT!!!!!!

Hey tubb, nice hack but I'm using frames on the main site where I'm showing this. Is there a way I can make the links open in a new window?

Quote:

Originally posted by ForKmaN
Hey tubb, nice hack but I'm using frames on the main site where I'm showing this. Is there a way I can make the links open in a new window?

Edit the actual top10.php file. Look for the html code that links to showthread.php. It'll be regular html with some php code around it. Change it from <a href= to whatever you want: target_new, etc, just like you would normally. The only thing you want to make sure you do with PHP is escape your quotes - ie, do quotes like this: /"/

i've had this hack installed for ages but now on my new server with same PHP 4.1.2 version i notice these errors in my error_log

i have 2 copies of last10.php and last10chitchat.php included on the same page i.e. http://www.eva2000.com/forum/ and 1 copy included at http://bubblegumcrisis2040.com/forum/

Code:

[Sat Aug 10 14:03:23 2002] [error] PHP Warning:  Use of undefined constant lastpost - assumed 'lastpost' in /home/username/public_html/last10.php on line 188

[Sat Aug 10 14:03:23 2002] [error] PHP Warning:  Use of undefined constant title - assumed 'title' in /home/username/public_html/last10.php on line 181

[Sat Aug 10 14:03:23 2002] [error] PHP Warning:  Use of undefined constant title - assumed 'title' in /home/username/public_html/last10.php on line 185

[Sat Aug 10 14:03:23 2002] [error] PHP Warning:  Use of undefined constant lastpost - assumed 'lastpost' in /home/username/public_html/last10.php on line 188

[Sat Aug 10 14:03:23 2002] [error] PHP Warning:  Undefined variable:  fsel in /home/username/public_html/last10chitchat.php on line 111

[Sat Aug 10 14:03:23 2002] [error] PHP Warning:  Undefined variable:  ftitle in /home/username/public_html/last10chitchat.php on line 111

[Sat Aug 10 14:03:23 2002] [error] PHP Warning:  Undefined variable:  counter in /home/username/public_html/last10chitchat.php on line 175

[Sat Aug 10 14:03:23 2002] [error] PHP Warning:  Use of undefined constant title - assumed 'title' in /home/username/public_html/last10chitchat.php on line 181

[Sat Aug 10 14:03:23 2002] [error] PHP Warning:  Use of undefined constant title - assumed 'title' in /home/username/public_html/last10chitchat.php on line 182

[Sat Aug 10 14:03:23 2002] [error] PHP Warning:  Use of undefined constant lastpost - assumed 'lastpost' in /home/username/public_html/last10chitchat.php on line 188

any ideas ?

When in doubt, escape your variables (i.e. put '' around them). Looks like PHP is interpreting the html as php code to me.

I've edited the hell out of this hack (got it to work with my CSS styles, got rid of queries I wasn't using, etc) and that was usually the problem I had when weird errors popped up.

If you check the html output of the script in a vaildator I bet you will find the same thing. I catch a lot of minor errors that way.

Wonderful hack! Thanks! :D

thank you this works well...I used the suggestion noted in a previous post to use vb templates to show a page called activetoday.php and it uses only 6 queries! :)

just notice one issue though; i have my board set so that unregistered users can post and it does not pull these posts...not sure if it's just anyone who's unregistered or those who dont put a name and posts as "unregistered".

any suggestions on how i might correct this?

thanks for the hack!

is it possible to have also the name of the category beside the title?

Quote:

Originally posted by tubedogg
UPDATED! Not a new version number, but a bug fix.
Fixed another bug with using forum titles and included forums. :o
New update: *Actually* fixed the bug with the forums this time. :)
------------------------------------------------------------------------------------

It's my best work to date (if I do say so myself :D) and I think you'll like it and like all the configuration you can do.

This image shows the script with all of the columns on, and parsing [code], smilies, and the post icon, as well as showing the forum title before the thread title.
http://www.bigdoggslair.com/vbhacks/last10/l10-1.jpg

This image shows the script with all the columns off except $lastpostdate, and the $tw (table width) set to 600, and $showdate set to 0 (to just show the last post time).
http://www.bigdoggslair.com/vbhacks/last10/l10-2.jpg

This image shows the same as #2, except $tw is blank (allowing the table to compact and remove the empty space automatically).
http://www.bigdoggslair.com/vbhacks/last10/l10-3.jpg

Hack version: 1.0.1

Changes since version 1.0.0: Fixed small bug.

Changes since version 0.1.0: Parses [ b], [ i], [ u], [ code], and [ quote] within the "last post". Displays the icon of the post, or the thread if there is no post icon. Parses smilies. New option to convert new lines to <br> so the post appears as the author wrote it (note: may cause problems if there are large breaks in posts).

Changes since version 0.0.2: New option to show the text of the last post of a thread (also option to limit the number of characters of the post displayed). New option to set the table width, as a percent, a number of pixels, or just let the table size naturally. New option to show just the time of the last post, instead of the date *and* the time. New option to show a thin line around the cells (cell spacing).

Changes since version 0.0.1: Include only specific forums, or set to allow all forums except certain excluded forums. New option to display a "Last post date" column with the last post date and time, formatted with your board's date & time setting. Fixed a bug with font and font size. Split the config into a separate file to make editing easier.

For version: v2 betas 3, 4, 5, RC1, RC2.

Files needed: last10.php, last10config.php (see attached zip file).

Files to edit: last10config.php (see attached zip file).

Possible file locations: Anywhere, as long as the relative path to config.php and the URL to your board are correct. Also, you must put last10.php and last10config.php in the same directory!

Instructions
1] Unzip the files last10.php and last10config.php to your hard drive.
2] Open last10config.php in an ASCII text editor, such as Notepad (Windows), SimpleText (Mac), EditPlus, UltraEdit, TextPad, etc. (DO NOT use WYSIWYG HTML editors such as FrontPage, HotDog, DreamWeaver, etc. They will in all likelyhood screw up the file! I will not be able to support you if you edit the file in one of these programs.)
3] Edit the variables at the top. These are:
$path > path to your config.php file (usually in the /admin directory) - NO TRAILING SLASH! and DO NOT PUT config.php at the end of it! ( e.g. forums/admin )

$url > URL to your board - NO TRAILING SLASH! ( e.g. http://www.mysite.com/forums )

$urlimg > URL to your board's images - NO TRAILING SLASH ( e.g. http://www.mysite.com/forums/images ).

$maxthreads > max threads to show. will show less if $last24 or $last7 limits it to less results than this number

$ob > determines the sort order of the list. replycount and views are numbers, lastposter is a name, title is the name of the thread, and lastpost is the last posts' date. set to one of the following: replycount , views , lastposter , title , lastpost (lastpost is most popular. it's the thread most recently replied to, then the second-to-last most recent, etc.)

$obdir > set to "desc" or "asc". which direction to sort? "desc" goes from bottom to top (9 to 1, z to a, etc.). "asc" goes top to bottom (1 to 9, a to z, etc.)

$last24 > set to 1 to limit the possible results to the last 24 hours; 0 for no limit (must set this to 0 if $last7 is set to 1)

$last7 > set to 1 to limit the possible results to the last 7 days; 0 for no limit (must set this to 0 if $last24 is set to 1)

$bc1 > first alt color (for the alternating colored rows)

$bc2 > second alt color

$hc > head background color (title, last poster, etc.)

$lc > text link color

$tc > text color

$f > font face

$fs > font size in points. 6 is on the small side, 10 on the large side. Put only a number in this - no "pt", "pts", or anything else!

$lastposter > show the "last poster" column? 1 = yes; 0 = no

$views > show the view count for each thread? 1 = yes; 0 = no

$replies > show the reply count for each thread? 1 = yes; 0 = no

$lastpostdate > show the last post date and time for each thread? 1 = yes; 0 = no

$len > maximum number of characters of the title to show. e.g. if the title is 60 characters and this is set to 25, only the first 25 characters of the title will be shown (followed by ...)

$excludeforums > List certain forums to be excluded. Best used if you have a large number of forums you *do* want included and only a few that you want excluded. List them separated by commas, but without spaces - e.g. 1,2,3,4 - and DO NOT fill in both this and $includeforums! Use one or the other.

$includeforums > List certain forums to be included. Best used if you have a small number of forums that you want included and a large number you want excluded. List them separated by commas, but without spaces - e.g. 1,2,3,4 - and DO NOT fill in both this and $excludeforums! Use one or the other.

$showmessages > If you want to show the last post of the thread as well, set this to 1. You can limit the number of characters displayed in $lplen below.

$lplen > If you specify a number here, any post that has more than $lplen number of characters will be reduced to this number and "..." added to the end of it. If you don't want to use this feature, leave it blank e.g. "" - remember though that if $showmessages is set to 0, this won't do anything.

$tw > If you want to specify the width of the table, you can set it as a percent e.g. 95% or as a number of pixels e.g. 300 or just leave it blank and the table will size itself.

$showdate > If you want to show the date *and* the time, set this to 1. If you want to just show the time, set this to 0.

$cs > If you want a thin line around your cells, set this to 1 (or higher - experiment!). Set to 0 for no line.

$nb > if you want breaks in text to appear as such, set this to 1. otherwise set it to 0 (this may cause problems if there are large breaks in the text)

$showforumtitle > if you want to show the forum title, linked to that forum, for each thread also (forum title: thread title) then set this to 1. otherwise set it to 0.

$showicon > if you want to show the icon the author chose for their post, set this to 1. otherwise set it to 0.

4] Upload both last10.php and last10config.php to your website. You can include last10.php as follows. To include it on a PHP-parsed page (.php, .php3, .phtml, etc.):
<? include("last10.php"); ?>
To include it on a server-parsed page (.shtml, .shtm, .ssi, etc.):


Instructions are also included in the zip file (last10.txt).

FEEDBACK WANTED! :D Likes/dislikes/modification requests all gladly accepted!

Please DO NOT contact me via IM or PM about this hack. Post your problem/question here and I will try to help you.

No problems with 2.2.6?

Thank you.

Quote:

Originally posted by pdatoon
is it possible to have also the name of the category beside the title?

yes, but if you have them turned on, it conflicts if you have another post hack installed on the same page. You can see it here: http://www.3dNewz.com The top links to the latest 6 threads on the forumz are the ones that cause a problem if you change the setting to show the catagory the post is in. The 6 latest posts is another hack, it's not this one, but all the ones down the side of the page are this hack.

I think I've almost got this hack to work, but I'm being denied access to MySQL. Here is the error I'm getting:

Quote:

Warning: Access denied for user: 'warfarehq@localhost' (Using password: NO) in /home/www/warfarehq/forums/admin/last10.php on line 14

Warning: MySQL Connection Failed: Access denied for user: 'warfarehq@localhost' (Using password: NO) in /home/www/warfarehq/forums/admin/last10.php on line 14
Can't open connection to MySQL

Can anyone help? Thanks.

sorry to be a pain but for some reason im getting this

Quote:

X-Powered-By: PHP/4.1.2 Connection: close Content-Type: text/html
Warning: Access denied for user: 'httpd@localhost' (Using password: NO) in /../affiliate- review.com/last10.php on line 14

Warning: MySQL Connection Failed: Access denied for user: 'httpd@localhost' (Using password: NO) in /......./affiliate-review.com/last10.php on line 14
Can't open connection to MySQL

Is it possible to modify this for use with polls also?

Kjetilpa

Is it possible to use this on a non-VB page on another server?
I share a board with another site. The site is hosted on their server, I'm attempting to have the last posts shown on a non-VB page on MY server.. Is this possible?

thanks.

does anyone know why im getting this

X-Powered-By: PHP/4.1.2 Connection: close Content-Type: text/html

at http://www.affiliate-review.com

i cant seem to find the code in last10.php

any help would be appreciated :):)`

Quote:

Originally posted by Cell Block
Is it possible to use this on a non-VB page on another server?
I share a board with another site. The site is hosted on their server, I'm attempting to have the last posts shown on a non-VB page on MY server.. Is this possible?

thanks.

Try https://vborg.vbsupport.ru/showthrea...threadid=39023

fonz, looks like it may be the path to your config.php file. The scripts can't open the connection to MySQL. Try the options in the link in my previous post if you're still having probs.

Darren.

Why is everyone early on in this thread set as a guest?

Odd!

~veedee

Quote:

Originally posted by veedee
Why is everyone early on in this thread set as a guest?

Odd!

~veedee

Because this thread originated from when the hacks section was over at vB.com, when the threads/posts got moved not all the users re-registered and not all the posts/threads got updated with a username. Hence many guest posts here ;)

Ahh righty!!

This is my effort so far.

http://www.visordown.com/forums/last10.php

What's up..anyone know?

you have set the path wrong, it should be ./admin/config.php for you.

Ahh ok I searched for another post that said I should replace something in my last10.php file so I did it was this code

PHP Code:


		
			
$servername="xxx"; // hostname or ip of server

$dbusername="xxx"; // username of your database server

$dbpassword="xxx"; // password of your database server

$dbname="xxx"; // name of database

It now works great - thanks for your help! :D

I'm new to all this hacking i get this error message what am i doing wrong

Warning: Unable to access /admin in /home/virtual/site10/fst/var/www/html/forum/last10.php on line 13

Fatal error: Failed opening required '/admin' (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site10/fst/var/www/html/forum/last10.php on line 13

Quote:

Originally posted by veedee
Ahh ok I searched for another post that said I should replace something in my last10.php file so I did it was this code

PHP Code:

$servername="xxx"; // hostname or ip of server $dbusername="xxx"; // username of your database server $dbpassword="xxx"; // password of your database server $dbname="xxx"; // name of database

It now works great - thanks for your help! :D

Yup, I had to do this too, but now it works awesome! Let me be the 10,345,763rd person to say thanks to tube for the kick-ass script!

The only problem with it I see is it displays the post times as server time, not local time. Is there any way to fix this? I looked as much as I could through this monstrously long thread for an answer, but I didn't see one.

Thanks again, and keep up the good work.

See it in action at http://badass.icestorm.com :nervous:

Fatal error: Failed opening required '/www/eroweb/admin/config.php' (include_path='.:/usr/local/lib/php') in /home/www/eroweb/last10.php on line 13

i am getting this error please help

I have a question. How do I make the Thread Titles and the number of views, replies etc. bold? What do I have to change and in what file? I think it would look much nicer if the text were bold.

Thanks!

Here it is on my site as a test www.fusionarena.com/newindex.php

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02222 seconds Memory Usage 1,872KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (6)bbcode_php_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: