vb.org Archive - vBindex v2.1

Page 60 of 162

« First

110

160

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)

- - vBindex v2.1 (https://vborg.vbsupport.ru/showthread.php?t=41916)

LightBringer

10-03-2002 06:21 PM

Ok, I have commented out the random quote hack code, and I am now receiving the following db error:

Quote:

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT * FROM thread WHERE open=1 AND thread.open<>10 AND visible=1 ORDER BY lastpost DESC LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Thursday 03rd of October 2002 01:21:14 PM
Script: http://www.brainphreeze.com/forums/forums/vbindex.php
Referer: http://www.brainphreeze.com/

NTLDR

10-03-2002 06:30 PM

Quote:

Originally posted by LightBringer
Ok, I have commented out the random quote hack code, and I am now receiving the following db error:

Sorry about the quote hack bit, I was sure I deleted that :rolleyes: Zip updated now.

Have you changed and submitted the options in the Admin CP?

LightBringer

10-03-2002 06:39 PM

Quote:

Originally posted by NTLDR

Sorry about the quote hack bit, I was sure I deleted that :rolleyes: Zip updated now.

Have you changed and submitted the options in the Admin CP?

Yup, I sure did. As long as I have the latest threads option turned off in the ACP, it pulls up the vbindex page.

I've also noticed that the news section isn't pulling the appropriate NEW posts. What it is pulling is the latest new post and all the replies associated with it. :/

You can see that on my site I have the news set to 5, but it's not pulling the 5 new posts as I stated.

http://www.brainphreeze.com/forums/vbindex.php

NTLDR

10-03-2002 06:49 PM

Thats strange. I have the exact same code as in the Zip file running here: http://www.thesistersthree.com/vbindex.php Which is working file and you can see.

You do only have one forumid specified for each forum in the ACP?

LightBringer

10-03-2002 06:52 PM

Quote:

You do only have one forumid specified for each forum in the ACP?

You bet. :)
If I set up that particular news forum so that there are no replies allowed, then it works fine, but as long as there are comments associated with the post, those comments show up as news items on the front page.

I'm not sure if that helps or not.

NTLDR

10-03-2002 07:51 PM

Quote:

Originally posted by LightBringer
If I set up that particular news forum so that there are no replies allowed, then it works fine, but as long as there are comments associated with the post, those comments show up as news items on the front page.

Thats a slight oversight on my part, the board I was testing with didn't have any replies in the threads. To use the new query reduced code will require an alteration to the thread table to store the first postid when a newthread is started.

After a load of thinking and testing I have come up with these changes you need to do.

[sql]ALTER TABLE thread ADD tpostid int( 10 ) unsigned DEFAULT '0' NOT NULL[/sql]

In newthread.php find:

PHP Code:


		
			
$postid=$DB_site->insert_id();

After it add:

PHP Code:


		
			
      if ($forumid=$newsforum) {

         $DB_site->query("UPDATE thread SET tpostid=$postid WHERE threadid=$threadid");

      }

This will only add the extra query when starting threads in the news forum, of course you can just add the query without the if to add it to all posts.

And upload the new vbindex.php that is attached. Just the threads to look into now.

groovesalad

10-04-2002 12:56 AM

so, anyone know where I can get the 1.3 version? The link doesn't work.

Valerie

10-04-2002 01:32 AM

Looks great! :D

LightBringer

10-04-2002 01:34 AM

Hey NTLDR, any comments about the template names by chance?

For instance: TWT's hack requires shoutbox_error.
Your hack requires: home_shoutbox_error.

There's a few others like this and I've renamed the those within the the new vbindex.php to match accordingly. Is this correct?

TheSaint-AeD

10-04-2002 10:56 AM

Perhaps it'd be better to update the first Post and prune this thread to the important Posts.

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

Page 60 of 162

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01891 seconds Memory Usage 1,745KB 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_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)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: