vb.org Archive - Last post on forum home, working version

Page 12 of 39

« First

Last »

Show 40 post(s) from this thread on one page

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

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

- - Last post on forum home, working version (https://vborg.vbsupport.ru/showthread.php?t=28561)

Omero

02-22-2002 11:49 AM

PPN btw im still running my "modified" version of your hack. Could you come up with the final version, even if that means an added query, as I did? I would love to see your version instead of my crappy mod :)

bigmo

03-12-2002 08:30 PM

After installing the hack I get these errors if I try to post, to reply and to update froum info:

Database error in vBulletin 2.2.4:

Invalid SQL: SELECT forumid,threadcount,replycount,parentlist,parentid ,lastpost,lastposter,lasttitle FROM forum WHERE INSTR(CONCAT(',',parentlist,','),',10,')>0
mysql error: Unknown column 'lasttitle' in 'field list'

mysql error number: 1054

Date: Tuesday 12th of March 2002 11:29:33 PM
Script: http://64.239.47.216/vb/vb/postings.php
Referer: http://64.239.47.216/vb/postings.php...d&threadid=186

Some ideas ???

THX for help

So long...
BigMo

Mystics

03-12-2002 08:35 PM

Quote:

Originally posted by bigmo
Some ideas ???

Just read the Instructions from the beginning ;)

Quote:

first thing to do is to run this mysql query :P
ALTER TABLE `forum` ADD `lasttitle` VARCHAR(100) NOT NULL AFTER `lastposter`

You need phpMyAdmin (for example) to run this Query.

Scott MacVicar

03-12-2002 08:48 PM

Sorry i never posted the changes..
here they are

look for

PHP Code:


		
			
      if (!$hideprivateforums) {

        $forumperms['canview']=1;

      }

above it add

PHP Code:


		
			
$trueperm['canview'] = $forumperms['canview'];

now use

PHP Code:


		
			
          if($trueperm['canview']) {

            $forum['lasttitle']=unhtmlspecialchars($forum['lasttitle']);

            if (strlen($forum['lasttitle']) > 30) {

              $forum['lasttitle'] = substr($forum['lasttitle'], 0, 28);

              $forum['lasttitle'] .= '..';

            }

          }

i've updated the main file now.

inetd

03-13-2002 03:13 AM

In what file it is necessary to make these changes?

bigmo

03-13-2002 09:04 AM

@Mystics

Hihi...sorry I didnt see it...

THX

@ppn

Quote:

i've updated the main file now.

Where can I get these main file ???

Scott MacVicar

03-13-2002 10:28 AM

index.php and forumdisplay.php and look at the very first post for the main hack file :)

bigmo

03-13-2002 12:11 PM

what is the diference betwen vb_last_title.txt and vb_last_title_new.txt ??

Scott MacVicar

03-13-2002 02:57 PM

the vb_last_title_new.txt was by Omero, though it runs an extra query for each forums, I'll go remove it in a minute.
Anyway my version doesn't run the extra query and is therefore ideal :P

TWTCommish

03-13-2002 03:00 PM

Therefore ideal? Hardly. I find mine are always getting mucked up...moved threads, deleted threads, stuff like that. There is definitely something to be said for another query here or there if it helps keep the integrity of the last post display.

All times are GMT. The time now is 08:44 PM.

Page 12 of 39

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02568 seconds Memory Usage 1,744KB 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_php_printable (3)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
Messages: