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)

tubedogg 07-04-2001 01:08 PM

OK but what about the post table? There's a username column - what's in that column for posts by unregistered users?

Oystein 07-04-2001 01:13 PM

in table post, username is either:
1. registered username (like mine "Oystein")
2. unregistered username (always "Uregistrert bruker")

The unreg. username is the same as I've edited in the file where it was written as "Unregistered" originally.

tubedogg 07-04-2001 01:38 PM

OK I think I have it figured out. Try the one attached to this message and see if it works.

Rename it to last10.php. The config file hasn't changed so you can just upload this one.

dareen 07-04-2001 09:26 PM

it was working great until a imported my ubb posts i got this error
-----------------------------
MySQL reported this error while trying to retreive the info: The table 'SQL3c86e_0' is full
----------------------------

any help?

Oystein 07-05-2001 07:01 AM

Quote:

Originally posted by tubedogg
OK I think I have it figured out. Try the one attached to this message and see if it works.

Rename it to last10.php. The config file hasn't changed so you can just upload this one.

Whatever you did, it worked... just tested, and now the unregistered users posts are shown..

but (!) Replies are not shown :p I guess you changed a bit too much :-)

Edit: Forget this last one... but you had written $replyword instead of $threads[replycount]. But I just changed it, so now it works.

Thanks a lot for helping out. Actually it means a lot :-)

JJR512 07-08-2001 03:38 AM

Can someone help me with some adjustments to this hack...Here's what I'd like. Instead of showing the Last Poster, I'd like to see the Thread Starter...and instead of showing the text of the last reply, I'd like to see the text of the first (opening) message of the thread. And I'd like for the output to be sorted in order of when the threads were originally posted, not by when the last reply was.

Thanks in advance!

dost 07-08-2001 12:19 PM

You are lucky JJR512 :D, I did all the changes you wanted eventhough I know nothing about php and mysql because I guess tubedogg was a little bit busy :rolleyes:

Code:

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

to
PHP Code:

// te base WHERE statement
$wheresql "WHERE thread.postusername=user.username AND thread.open!='10'"

and
Code:

// ooh a query!
$query = "SELECT thread.lastpost,thread.title,thread.lastposter,thread.replycount,thread.views,user.userid,thread.threadid,thread.forumid$fsel,thread.iconid FROM thread,user$ftitle $wheresql ORDER BY thread.$ob $obdir LIMIT $maxthreads";

to
PHP Code:

// ooh a query!
$query "SELECT thread.dateline,thread.title,thread.postusername,thread.replycount,thread.views,user.userid,thread.threadid,thread.forumid$fsel,thread.iconid FROM thread,user$ftitle $wheresql ORDER BY thread.$ob $obdir LIMIT $maxthreads"

and
Code:

$fd = date($fdt,$threads[lastpost]);
PHP Code:

$fd date($fdt,$threads[dateline]); 

Also in the config file, don't forget to change $ob to dateline. Like:
$ob = "dateline"
I hope that helps. Please remind me if I have forgotten some parts because I modified the code a lot so it's hard to track the changes I have made.

gmyachtsman 07-09-2001 10:24 PM

I have this hack working nicely on my front page, and I am trying to also ad the hack to a page (citysailor.com) on a different server that doesn't support PHP.

I tried using the full path to the last10.php and last10config.php files in my include statement like this:

<!--#include virtual="http:// http://www.harborsailing.com/public_.../last10_ny.php"-->

But I am getting this error:

[an error occurred while processing this directive]

I might be missing something really simple --- any ideas how to make it work?

Steve Machol 07-10-2001 03:52 AM

I just installed this for testing and it's absolutely great! Good job Kevin!

One slight problem though. Some of the message icons show broken images, although the images are fine in the actual forum and thread displays. Here's the URL:

http://130.94.168.29/last10/last10.php

Any idea how to fix?

P.S. It appears the last10 script is adding icon15.gif and icon16.gif whch don't exist. Where did it get these icons from? They're not in the messages or forumdisplay. :confused:

Steve Machol 07-10-2001 06:57 PM

I've determined that the problem with the message icons occurs whenever an icon is used that was not part of the orginal distribution (icons 1-14.)


All times are GMT. The time now is 08:06 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.01777 seconds
  • Memory Usage 1,743KB
  • 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
  • (3)bbcode_code_printable
  • (3)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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