vb.org Archive

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)

Marco van Herwaarden 11-21-2005 03:02 AM

This is a vB2 modification. Please use a mod for the version you are using.

MamboCube 05-02-2006 08:09 PM

i get this error

MySQL reported this error while trying to retreive the info: Table '****_database.thread' doesn't exist

anyone know how to fix it?

sbardy 06-04-2006 10:22 AM

Quote:

Originally Posted by MamboCube
i get this error

MySQL reported this error while trying to retreive the info: Table '****_database.thread' doesn't exist

anyone know how to fix it?

me too!!! please help us!!:bunny:

MamboCube 06-04-2006 10:49 AM

is it because of the table prefix?

maybe it should be ****_database.vb3_thread

i will try it now

MamboCube 06-04-2006 11:05 AM

ok, i seem to have ap roblem connecting to my database now,

i get the error message

"Can't select database"

anyone know why this is?
___________________________________________

nevermind that, just looked at the thread and found the link at the top,

but now i get this error message:

"MySQL reported this error while trying to retreive the info: 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 '' at line 1"

MamboCube 06-04-2006 11:30 AM

yeh, it was the prefix,
i had to go through last10.php adding my table prefix to all the mysql stuff, is there a quicker way to do this that i have missed?

sbardy 06-04-2006 01:51 PM

Quote:

Originally Posted by MamboCube
is it because of the table prefix?

maybe it should be ****_database.vb3_thread

i will try it now

I have the same problem...have you solved it?

peterska2 06-04-2006 01:56 PM

This modification DOES NOT work with vBulletin 3.5.4

Please locate an alternative modification for use with versions 3.0.0 - 3.5.4

Thank you.

sbardy 06-04-2006 01:59 PM

ok....:( please help me here https://vborg.vbsupport.ru/showthread.php?t=117349

MamboCube 06-05-2006 06:29 AM

Quote:

Originally Posted by peterska2
This modification DOES NOT work with vBulletin 3.5.4

Please locate an alternative modification for use with versions 3.0.0 - 3.5.4

Thank you.

seems to be working fine for me, and im running 3.5.4, i just had to go through last10.php and add my table prefix to the mysql info

e.g.

Code:

// the base WHERE statement
$wheresql = "WHERE thread.lastposter=user.username AND thread.open!='10'";

i have now changed to

Code:

// the base WHERE statement
$wheresql = "WHERE vb3_thread.lastposter=vb3_user.username AND vb3_thread.open!='10'";

i did that for everything in last10.php and it worked

sbardy, im pretty sure this is all u have to do to get urs working

MamboCube 06-05-2006 07:42 AM

ok, u know the last post date & time, well i want the time to be in a different class,

how would i do this?

---------------------------------------------

no matter, done it

sbardy 06-05-2006 09:41 AM

nothing...same problem I tried :(

twitch 06-05-2006 01:26 PM

<a href="https://vborg.vbsupport.ru/showthread.php?t=113214" target="_blank">Just use this</a>, its much easier

sbardy 06-05-2006 04:55 PM

I want also forum title near latest forum threads, I'm trying invain to build my own script please help me http://www.vbulletin.com/forum/showt...1&goto=newpost

Ryan McBain 09-20-2006 03:40 AM

fixed it

ben07 10-30-2006 05:02 AM

Is there a preview of one with the title and message?

MissKalunji 10-30-2006 10:41 AM

Quote:

Originally Posted by ben07
Is there a preview of one with the title and message?

i run mine with just the title

BUT YOU can customize this to look THE WAY you want

www.dancehallareaz.com here you can see it with just the title

www.dhazlinkup.com (using rss feed using title as well) but you're the one who customize to look and retrieve whateva you want date...member name..etc etc

ben07 10-31-2006 04:39 AM

I was hoping if it was possible to modifty in this way

http://img213.imageshack.us/img213/8...ppleasefn4.jpg

Including the messages the post content contains? I've been looking at samples and they are all title based.

MissKalunji 10-31-2006 12:32 PM

Read the description of the hack....

Quote:

$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
You can customize it easily just a little html!

and you can also use a portal that will do that automatically

or like i told you before rss feed

http://www.vbulletin.com/forum/showthread.php?t=159044

A simple research usually answers ALL of your questions Good Luck

letsjoy 01-08-2007 06:13 PM

thanksssssssssss

xBhp 01-24-2007 06:46 AM

I had recently upgraded PHP to version 5.1 when i started getting this error : Fatal error: Call to a member function unlock_tables() on a non-object in /home/xbhp1/public_html/talkies/includes/functions.php on line 4998

Page : http://www.xbhp.com/last10re.php

Please help!

djjeffa 01-25-2007 10:48 AM

can this be used on a page on a domin othere then the one you have vb on?


All times are GMT. The time now is 04:30 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01634 seconds
  • Memory Usage 1,765KB
  • 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
  • (2)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (22)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