Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Details »»

Version: , by tubedogg tubedogg is offline
Developer Last Online: Dec 2016 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 03-25-2001 Last Update: Never Installs: 115
 
No support by the author.

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

It's my best work to date (if I do say so myself ) 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.


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).


This image shows the same as #2, except $tw is blank (allowing the table to compact and remove the empty space automatically).


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:
  1. $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 )
  2. $url > URL to your board - NO TRAILING SLASH! ( e.g. http://www.mysite.com/forums )
  3. $urlimg > URL to your board's images - NO TRAILING SLASH ( e.g. http://www.mysite.com/forums/images ).
  4. $maxthreads > max threads to show. will show less if $last24 or $last7 limits it to less results than this number
  5. $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.)
  6. $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.)
  7. $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)
  8. $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)
  9. $bc1 > first alt color (for the alternating colored rows)
  10. $bc2 > second alt color
  11. $hc > head background color (title, last poster, etc.)
  12. $lc > text link color
  13. $tc > text color
  14. $f > font face
  15. $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!
  16. $lastposter > show the "last poster" column? 1 = yes; 0 = no
  17. $views > show the view count for each thread? 1 = yes; 0 = no
  18. $replies > show the reply count for each thread? 1 = yes; 0 = no
  19. $lastpostdate > show the last post date and time for each thread? 1 = yes; 0 = no
  20. $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 ...)
  21. $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.
  22. $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.
  23. $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.
  24. $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.
  25. $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.
  26. $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.
  27. $cs > If you want a thin line around your cells, set this to 1 (or higher - experiment!). Set to 0 for no line.
  28. $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)
  29. $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.
  30. $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.):
<!--#include file="last10.php"-->

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

FEEDBACK WANTED! 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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #462  
Old 09-16-2003, 09:19 AM
mark99 mark99 is offline
 
Join Date: Oct 2002
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah I'd like this to work with vB3 as well, I changed the path to config.php all I get is this error message:

Quote:
MySQL reported this error while trying to retreive the info: Table 'db86213033.thread' doesn't exist
Reply With Quote
  #463  
Old 09-24-2003, 05:56 PM
The Geek's Avatar
The Geek The Geek is offline
 
Join Date: Sep 2003
Location: Behind you
Posts: 2,779
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Works a treat with vb3... just adjust the variables to point to the correct paths.
Reply With Quote
  #464  
Old 09-25-2003, 07:55 AM
mark99 mark99 is offline
 
Join Date: Oct 2002
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That doesn't help =), I've already done that - hence the above error even appearing in the first place. Can you attach your version or explain EXACTLY what you changed?
Reply With Quote
  #465  
Old 09-25-2003, 08:38 AM
mark99 mark99 is offline
 
Join Date: Oct 2002
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ah, found the problem! It's because I'm using a prefix ($tableprefix) of 'vb3_' in the database. You have to change all the query and table calls to thus include 'vb3_' before them.

I'm not quite sure how to add '$tableprefix' before each call without it merging into one line and confusing things. Otherwise it needs to be done manually, which is a pain.
Reply With Quote
  #466  
Old 09-25-2003, 12:55 PM
The Geek's Avatar
The Geek The Geek is offline
 
Join Date: Sep 2003
Location: Behind you
Posts: 2,779
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

To solve the prefix problem...

Try this (I am not where I can test the script... but it should work without any problems)
All it does is add $tableprefix before each table name in the From clause of each sql statement.

* edit - Like the true doofus I am... I did this and then read your post again... which clearly points out that you know all of this... but it should also point out where you were having problems *

For example....
PHP Code:
$sql="SELECT bob FROM fred where 1=2"
to
PHP Code:
$sql="SELECT bob FROM " $tableprefix "fred where 1=2"
------------------------------------------
open last10.php

find
PHP 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"
and change to
PHP 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 " $tableprefix "thread,user$ftitle $wheresql ORDER BY thread.$ob $obdir LIMIT $maxthreads"
find
PHP Code:
$dtf mysql_query("SELECT value FROM setting WHERE varname='dateformat' OR varname='timeformat' OR varname='timeoffset' ORDER BY varname"); 
and change to
PHP Code:
$dtf mysql_query("SELECT value FROM " $tableprefix "setting WHERE varname='dateformat' OR varname='timeformat' OR varname='timeoffset' ORDER BY varname"); 
find
PHP Code:
$query0 "SELECT pagetext,postid,dateline,iconid FROM post WHERE threadid='$threads[threadid]' ORDER BY dateline DESC LIMIT 1"
and change to
PHP Code:
$query0 "SELECT pagetext,postid,dateline,iconid FROM " $tableprefix "post WHERE threadid='$threads[threadid]' ORDER BY dateline DESC LIMIT 1"
find
PHP Code:
$smilies mysql_query("SELECT smilietext,smiliepath FROM smilie"); 
change to
PHP Code:
$smilies mysql_query("SELECT smilietext,smiliepath " $tableprefix "FROM smilie"); 
In theory... that should sort it out.

toodles
Reply With Quote
  #467  
Old 09-28-2003, 12:58 AM
dontpanic dontpanic is offline
 
Join Date: Jun 2003
Posts: 145
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is there some way that this hack can be modified such that users who do not permissions to see a post normally cannot see them via this hack?

As an example. I have forums for my moderators that registered users cannot see. On the page this hack produces, they can see the threads...but obviously not access them. I am looking to filter the threads to remove them from displaying on this list based on user group.

Make sense?

Thanks and great hack!

Oh yeah..if I missed this somewhere in the last 31 pages, sorry!
Reply With Quote
  #468  
Old 10-03-2003, 10:02 AM
Ripster Ripster is offline
 
Join Date: Oct 2003
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi, thanksd for the hack - exactly what I was looking for

One request - is it possible to not display 'Thread title' in the table? My site have a graphic above the forum links so this extra text is redundant. It has probably been answered somewhere in the thread but there's alot of stuff to plough through there!

Here's an illustration of what I mean, rhs of the page...

http://www.ripnet-uk.com

TIA for any help
Reply With Quote
  #469  
Old 10-07-2003, 10:50 AM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

everytime i try and work with this hack, i get this, someone please help me

LAST10CONFIG
PHP Code:
<?
//...........Last X Posts v1.0.2...........\\
//......by Kevin ([email="kevin@tubescan.com)......"]kevin@tubescan.com)......\\[/email]
// For vBulletin version 2 (betas 3, 4, 5, RC1, RC2)
// (c) 2001 Jelsoft Enterprises, Ltd.
// vBulletin.com thread: [url="http://www.vbulletin.com/forum/showthread.php?threadid=12324"]http://www.vbulletin.com/forum/showthread.php?threadid=12324[/url]
//////// CONFIG EXPLANATION //////////
//
// a] $path > path to your config.php file (usually in the /admin directory) - NO TRAILING SLASH! ( e.g. forums/admin ) and DO NOT PUT config.php ON THE END OF THIS PATH OR THE SCRIPT WILL NOT WORK!!!!
// b] $url > URL to your board - NO TRAILING SLASH! ( e.g. [url="http://www.mysite.com/forums"]http://www.mysite.com/forums[/url] )
//  c] $urlimg > URL to your board's images - NO TRAILING SLASH ( e.g. [url="http://www.mysite.com/forums/images"]http://www.mysite.com/forums/images[/url] )
// d] $maxthreads > max threads to show. will show less if $last24 or $last7 limits it to less results than this number
// e] $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.)
// f] $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.) leave this set to "desc" if you use lastpost for $ob or it will not work correctly!
// g] $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)
// h] $last7 > set to 1 to limit the possible results to the last 24 hours; 0 for no limit (must set this to 0 if $last24 is set to 1)
// i] $bc1 > first alt color (for the alternating colored rows)
// j] $bc2 > second alt color
// k] $hc > head background color (title, last poster, etc.)
// l] $lc > text link color
// m] $tc > text color
// n] $f > font face
// o] $fs > font size in points - 8 is normal, 6 is on the small side, 10 on the large side. play around with it. :) just put a number here - no pt, pts, or anything!
// p] $lastposter > show the "last poster" column? 1 = yes; 0 = no
// q] $views > show the view count for each thread? 1 = yes; 0 = no
// r] $replies > show the reply count for each thread? 1 = yes; 0 = no
//  s] $lastpostdate > show the last post date and time for each thread? 1 = yes; 0 = no
// t] $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 ...)
//  u] $excludeforums > if you want to exclude certain forums from having their threads displayed, this is the place to enter their numbers. separate more than 1 number with commas, NO SPACES! e.g. 1,2,3,4 (note: $excludeforums and $includeforums are mutually exclusive, meaning DO NOT USE BOTH AT THE SAME TIME! only fill one or the other in with numbers!)
//  v] $includeforums > if you just want to use certain forums (instead of a whole list, or instead of excluding 10 of 12 forums or something similar), put their numbers here. separate more than one number with commas NO SPACES e.g. 1,2,3,4 (note: $excludeforums and $includeforums are mutually exclusive, meaning DO NOT USE BOTH AT THE SAME TIME! only fill one or the other in with numbers!)
//  w] $showmessages > if you want to show the text of the last post in each thread as well, set this to "1". set this to "0" if you don't.
//  x] $lplen > the maximum length of post to allow. if the post is longer than this, it will be shortened to this many characters and "..." added. if $showmessages is set to 0, this won't do anything.
//  y] $tw > the width of the table holding the information. can be a percent ( e.g. 95% ) or a number of pixels ( e.g. 300 ). leave blank if you want the table to be sized naturally.
//  z] $showdate > if you enable the "last post date" column and would like the date shown for each post as well as the time, set this to 1. if you have a busy board and all of posts are going to be from the current day, or if you set $last24 to 1, then you can set this to 0. if the last posts are likely to be spread over multiple days (for small boards, etc.) then you might want to set this to 1.
// aa] $cs > if you want to show a thin line around the cells (see the first example on the vBulletin.com thread referenced above) then set this to "1" (or higher - experiment with it!) otherwise set it to 0.
// ab] $showicon > if you want to show the icon the author chose for their post, set this to 1. otherwise set it to 0.
// ac] $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.
// ad] $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)
//
////// END CONFIG EXPLANATION ////////
/////////////// CONFIG ///////////////
// 
$path = "../forums/admin"; // path to your config.php file (usually in the /admin directory) - NO TRAILING SLASH! Do not include "config.php"
$url = "[url="http://www.ebslive.com/forums"]http://www.ebslive.com/forums[/url]"; // URL to your board - NO TRAILING SLASH!
$urlimg = "[url="http://www.ebslive.com/forums/images"]http://www.ebslive.com/forums/images[/url]"; // URL to your board's images - NO TRAILING SLASH!
$maxthreads = "25"; // max threads to show. will show less if $last24 or $last7 limits it to less results than this number
$ob = "lastpost"; // 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 = "desc"; // 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.). if you use lastpost for $ob, leave this set to desc or it will not work correctly!
$last24 = "0"; // 1 = last 24 hours; 0 = all (must set this to 0 if $last7 is set to 1)
$last7 = "0"; // 1 = last 7 days; 0 = all (must set this to 0 if $last24 is set to 1)
$bc1 = "#ECF2FA"; // first alt color
$bc2 = "#ECF2FA"; // second alt color
$hc = "#ECF2FA"; // head background color
$lc = "#4F6BAO"; // link color
$tc = "#4F6BAO"; // text color
$f = "Tahoma"; // font face
$fs = "8"; // font size in points - 8 is normal, 6 is on the small side, 10 on the large side. play around with it. :)
$lastposter = "1"; // show last poster? 1 = yes; 0 = no
$views = "0"; // show view count? 1 = yes; 0 = no
$replies = "0"; // show reply count? 1 = yes; 0 = no
$lastpostdate = "0"; // show last post date and time? 1 = yes; 0 = no
$len = 25; // 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 = "20,17,18"; // if you want to exclude a forum, put it's ID here. more than one, seperate them with commas, NO SPACES! e.g. 1,2,3,4
$includeforums = ""; // if you only want to include certain forums, put their ids here. separate more than one with commas, NO SPACES! e.g. 1,2,3,4
$showmessages = "0"; // show the text of the last post too? 1 = yes; 0 = no
$lplen = "300"; // character length of last post text (if $showmessages is set to 0 this won't do anything).
$tw = "95%"; // width of the table that shows the info, in either a percent ( e.g. 95% ) or in pixels ( e.g. 300 ). leave blank if you want the table to be sized naturally
$showdate = "0"; // show the date, as well as the time? if the posts that show up in the list are likely to all be from today (or you set $last24 to "1"), you can set this to 0. if the posts are spread over multiple days, you probably want this set to 1.
$cs = "0"; // this is the cellspacing. 1 makes a thin line around the cells. 0 makes no line.
$showicon = "0"; // shows the posts' icon next to the post
$showforumtitle = "0"; // shows the forum title (linked to that forum) next to the thread title
$nb = "0"; // do you want breaks in text to appear as such? this may cause problems if there are large breaks in the text
//
///////////// END CONFIG /////////////
?>
and heres the last10.php i can't see nothing wrong with either
PHP Code:
<?
//...........Last X Posts v1.0.5...........\\
//......by Kevin ([email="kevin@tubescan.com)......"]kevin@tubescan.com)......\\[/email]
// For vBulletin version 2 (betas 3, 4, 5, RC1, RC2, RC3)
// (c) 2001 Jelsoft Enterprises, Ltd.
// vBulletin.com thread: [url="http://www.vbulletin.com/forum/showthread.php?threadid=12324"]http://www.vbulletin.com/forum/showthread.php?threadid=12324[/url]
// let's get connected
require("incl/last10config.php");
$db=mysql_connect($host,$user,$password) or die("Can't open connection to MySQL");
mysql_select_db($database) or die("Can't select database");
$hfs = $fs+2;
$fs .= "pt";
$hfs .= "pt";
if ($tw == "") {
 $twt = "";
} else {
 $twt = "width="$tw"";
}
if ($cs == "") {
 $cs = 0;
}
// start up our table, decide whether to show
echo("<table border=0 cellpadding=3 cellspacing=$cs width=150 align=center><tr bgcolor="$hc">\n");
if ($showicon == "1") {
 echo("<td>&nbsp;</td>");
}
echo("<td style="font-family:$f; font-size:$hfs; color:$tc;" width="75"><b><nobr>Thread Title</nobr></b></td>\n");
// the last poster column,
if ($lastposter == "1") {
 echo("<td style="font-family:$f; font-size:$hfs; color:$tc;" align="center" width="75"><b><nobr>Last Poster</nobr></b></td>\n");
}
echo("</tr>\n");
// the base WHERE statement
$wheresql = "WHERE thread.lastposter=user.username AND thread.open!='10'";
// we can't have both the last 24 hours *and* the last 7 days, so error out if needed
if ($last24 == "1" && $last7 == "1") {
 print("Error: \$last24 and \$last7 are both set to 1. Please change one of them to 0.");
 exit;
}
// otherwise we're gonna find out which one it is
// last 24
if ($last24 == "1") {
 $time = time()-86400;
 $wheresql .= " AND thread.lastpost>'$time'";
}
// last 7
if ($last7 == "1") {
 $time = time()-604800;
 $wheresql .= " AND thread.lastpost>'$time'";
}
// are we trying to exclude *and* include forums? if so, error out
if ($excludeforums != "" && $includeforums != "") {
 print("Error: \$includeforums and \$excludeforums are both set with numbers. Please remove the numbers from <b>one</b> of these two to proceed.");
 exit;
}
// otherwise figure out which one we're using
// include forums
if ($includeforums == "" or $includeforums <= "0") {
 $quarter = "no";
} else {
 $incfid = explode(",",$includeforums); $i = 0; $a = count($incfid);
 if ($a > 1) {
  $wheresql .= " AND (thread.forumid='$incfid[0]'";
  ++$i;
  while ($i < $a) {
   $wheresql .= " OR thread.forumid='$incfid[$i]'"; ++$i;
  }
  $wheresql .= ")";
 } else {
  $wheresql .= " AND thread.forumid='$incfid[$i]'";
 }
}
// or exclude forums
if ($excludeforums == "" or $excludeforums <= "0") {
 $quarter = "no";
} else {
 $excfid = explode(",",$excludeforums); $i = 0; $a = count($excfid);
 while ($i < $a) {
  $wheresql .= " AND thread.forumid!='$excfid[$i]'"; ++$i;
 }
}
if ($showforumtitle == "1") {
 $ftitle = ",forum";
 $fsel = ",forum.title AS ftitle";
 $wheresql .= " AND thread.forumid=forum.forumid";
}
// 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";
// let's get the info
$tr = mysql_query($query) or die("MySQL reported this error while trying to retreive the info: ".mysql_error());
$dtf = mysql_query("SELECT value FROM setting WHERE varname='dateformat' OR varname='timeformat' OR varname='timeoffset' ORDER BY varname");
$df = mysql_result($dtf,0,0);
$tf = mysql_result($dtf,1,0);
$tof = mysql_result($dtf,2,0);
if ($showdate == "1") {
 $fdt = "$df $tf";
} else {
 $fdt = "$tf";
}
$cols = 1;
// let's display the info
while ($threads = mysql_fetch_array($tr)) { 
 // are we going to show the message too?
 if ($showmessages == "1") {
  $query0 = "SELECT pagetext,postid,dateline,iconid FROM post WHERE threadid='$threads[threadid]' ORDER BY dateline DESC LIMIT 1";
  $lastpost = mysql_query($query0) or die("MySQL reported this error while trying to retrieve the last post info: ".mysql_error());
  while ($lastpost1 = mysql_fetch_array($lastpost)) {
   $lastpostshort = $lastpost1[pagetext];
   $postii = $lastpost1[iconid];
  }
  if (strlen($lastpostshort) > $lplen) {
   $lastpostshort = substr($lastpostshort,0,$lplen);
   $lastpostshort .= "...";
  }
  $smilies = mysql_query("SELECT smilietext,smiliepath FROM smilie");
  while ($smiles = mysql_fetch_array($smilies)) {
   $lastpostshort = str_replace($smiles[smilietext],"<img src="".$url."/".$smiles[smiliepath]."" border=0>",$lastpostshort);
  }
  if ($nb == "1") {
   $lastpostshort = nl2br($lastpostshort);
  }
  $lastpostshort = str_replace("[i]","<i>",$lastpostshort);
  $lastpostshort = str_replace("[/i]","</i>",$lastpostshort);
  $lastpostshort = str_replace("[u]","<u>",$lastpostshort);
  $lastpostshort = str_replace("[/u]","</u>",$lastpostshort);
  $lastpostshort = str_replace("[b]","<b>",$lastpostshort);
  $lastpostshort = str_replace("[/b]","</b>",$lastpostshort);
  $lastpostshort = str_replace("[quote]","<br>quote:<br><hr> ",$lastpostshort);
  $lastpostshort = str_replace("[/quote]"," <hr><br>\n",$lastpostshort);
  $lastpostshort = str_replace("[I]","<i>",$lastpostshort);
  $lastpostshort = str_replace("[/I]","</i>",$lastpostshort);
  $lastpostshort = str_replace("[U]","<u>",$lastpostshort);
  $lastpostshort = str_replace("[/U]","</u>",$lastpostshort);
  $lastpostshort = str_replace("[B]","<b>",$lastpostshort);
  $lastpostshort = str_replace("[/B]","</b>",$lastpostshort);
  $lastpostshort = str_replace("[QUOTE]","<br>quote:<br><hr> ",$lastpostshort);
  $lastpostshort = str_replace("[/QUOTE]"," <hr><br>\n",$lastpostshort);
  $lastpostshort = str_replace("[CODE]","<br>code:<br><hr> ",$lastpostshort);
  $lastpostshort = str_replace("[/CODE]"," <hr><br>\n",$lastpostshort);
  $lastpostshort = str_replace("[code]","<br>code:<br><hr> ",$lastpostshort);
  $lastpostshort = str_replace("[/code]"," <hr><br>\n",$lastpostshort);
  $lastpostshort = str_replace("[img]","",$lastpostshort);
  $lastpostshort = str_replace("[/img]","",$lastpostshort);
  $lastpostshort = str_replace("[img]https://vborg.vbsupport.ru/[/img]","",$lastpostshort);
  $lastpostshort = str_replace("[url]","",$lastpostshort);
  $lastpostshort = str_replace("[/url]","",$lastpostshort);
  $lastpostshort = str_replace("[URL]","",$lastpostshort);
  $lastpostshort = str_replace("[/URL]","",$lastpostshort);
 }
 // thanks to kier for this idea to do the alternating row colors
 if (($counter++ % 2) != 0) {
  $bc=$bc1;
 } else {
  $bc=$bc2;
 }
 // if the title is more than $len characters, we need to cut it off and add ... to the end
 if (strlen($threads[title]) > $len) { 
  $title = substr($threads[title],0,$len);
  $title .= "...";
 } else { 
  $title = $threads[title];
 }
 // convert the date to a format readable by non-unix geeks :)
 $fd = date($fdt,$threads[lastpost]);
 // display everything in a nice table. in the future we're gonna try to do this so others can format the data, but this is sufficient for now
 echo("<tr>");
 if ($showicon == "1") {
  echo("<td bgcolor="$bc">");
  if ($postii != "0" && $postii != "") {
   echo("<img src="$urlimg/icons/icon$postii.gif" border="0">");
  }
  if (($postii == "0" || $postii == "") && $threads[iconid] != "0" && $threads[iconid] != "") {
   echo("<img src="$urlimg/icons/icon$threads[iconid].gif" border="0">");
  }
  if (($postii == "0" || $postii == "") && ($threads[iconid] == "0" || $threads[iconid] == "")) {
   echo("&nbsp;");
  }
  echo("</td>");
  ++$cols;
 }
 echo("<td bgcolor="$bc" style="font-family:$f; font-size:$fs; color:$tc;"><nobr>");
 if ($showforumtitle == "1") {
  echo("<a href="$url/forumdisplay.php?forumid=$threads[forumid]" style="color: $lc;">$threads[ftitle]</a>: ");
 }
 echo("<a href="$url/showthread.php?threadid=$threads[threadid]&goto=newpost" style="color: $lc;" title="$threads[title]">$title</a></nobr></td>\n");
 // last poster column?
 if ($lastposter == "1") {
  echo("<td bgcolor="$bc" style="font-family:$f; font-size:$fs; color:$tc;" align="center"><a href="$url/member.php?action=getinfo&userid=$threads[userid]" style="color: $lc;">$threads[lastposter]</a></td>\n");
  ++$cols;
 }
 // the last post date & time column,
 if ($lastpostdate == "1") {
  echo("<td bgcolor="$bc" style="font-family:$f; font-size:$fs; color:$tc;" align="center">$fd</td>\n");
  ++$cols;
 }
 // views column?
 if ($views == "1") {
  echo("<td bgcolor="$bc" style="font-family:$f; font-size:$fs; color:$tc;" align="center">$threads[views]</td>\n");
  ++$cols;
 }
 // replies column?
 if ($replies == "1") {
  echo("<td bgcolor="$bc" style="font-family:$f; font-size:$fs; color:$tc;" align="center">$threads[replycount]</td>\n");
  ++$cols;
 }
 echo("</tr>");
 // are we showing the last post?
 if ($showmessages == "1") {
  echo("<tr bgcolor="$bc"><td colspan="$cols" style="font-family:$f; font-size:$fs; color:$tc;" align="left">\n");
  echo("<table border=0 cellpadding=4 cellspacing=0 width="100%">\n");
  echo("<tr bgcolor="$bc"><td style="font-family:$f; font-size:$fs; color:$tc;" align="right" valign="top"><b><nobr>Last Post:</nobr></b></td>\n");
  echo("<td style="font-family:$f; font-size:$fs; color:$tc;" align="left" width="100%">$lastpostshort</td></tr>\n");
  echo("</table></td>\n");
 }
 $fd = "";
}
// close it all up
echo("</tr></table>");
// bye!
?>
Reply With Quote
  #470  
Old 10-07-2003, 06:26 PM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

still in need of dyer help with this :happysad:
Reply With Quote
  #471  
Old 10-11-2003, 05:01 PM
mark99 mark99 is offline
 
Join Date: Oct 2002
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Perhaps if you explained exactly what your problem is?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:20 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05694 seconds
  • Memory Usage 2,430KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (12)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete