vb.org Archive - vBindex v2.1

Page 62 of 162

« First

112

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)

NTLDR

10-04-2002 06:42 PM

Try changing:

PHP Code:


		
			
    // active topics

    $threadsquery = $DB_site->query("SELECT threadid,forumid,title,postusername,lastposter,replycount,iconid FROM thread WHERE forumid!=$newsforum AND forumid!=$pollsforum ".$threadsql." AND visible=1 order by lastpost desc limit $numthreads");

To:

PHP Code:


		
			
    // active topics

    $threadsquery = $DB_site->query("SELECT threadid,forumid,title,postusername,lastposter,replycount,iconid FROM thread WHERE forumid!=$newsforum AND forumid!=$pollsforum AND forumid=X AND visible=1 order by lastpost desc limit $numthreads");

Instead. Note this won't hide and private forums.

If you wanted the 3 latest threads boxes you will want you would need to replace all the latest threads code and add extra templates to sperate them all up.

groovesalad

10-05-2002 03:03 AM

I don't understand this. Am I supposed to change my vbindex.php to index.php? If so, what am I supposed to do with my original index.php that my other .php files point to?

TECK	10-05-2002 06:00 AM

NTLDR, in your admin options queries, you have 2 option ID's with the same id...
just letting you know. cheers.

Chris M

10-05-2002 09:55 AM

Quote:

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT thread.*,threadpost.pagetext AS pagetext FROM thread LEFT JOIN post AS threadpost ON (thread.tpostid = threadpost.postid) WHERE forumid = '29' ORDER BY thread.dateline DESC LIMIT 10
mysql error: Unknown column 'thread.tpostid' in 'on clause'

mysql error number: 1054

Date: Saturday 05th of October 2002 06:50:20 AM
Script: http://www.darkblazes.com/forums/
Referer: http://www.darkblazes.com/forums/index.php?

I get that when I try and access the vBindex...

Satan

Chris M

10-05-2002 10:07 AM

I tried a fix, but now the post contents appear all wrong on the main page!!!

What is wrong?

Ive posted a screenshot below, and have reverted back a Version for now...

Satan

groovesalad

10-05-2002 02:14 PM

anyone? anyone? :)

Chris M

10-05-2002 03:05 PM

I found the changes that needed to be made...

Now I get no news on my main page!

Satan

NTLDR

10-05-2002 06:12 PM

Quote:

Originally posted by groovesalad
I don't understand this. Am I supposed to change my vbindex.php to index.php? If so, what am I supposed to do with my original index.php that my other .php files point to?

There is no need to change the filename unless you want to.

NTLDR

10-05-2002 06:15 PM

Quote:

Originally posted by hellsatan
I found the changes that needed to be made...

Now I get no news on my main page!

Satan

Satan, upload the attached script to your admin dir and and run it, this will add the postids of the first post in a thread to the thread table, this should fix the news issues with posts made prior to the upgrade :)

This will be integrated into the Update Counters bit in the final release ;)

NTLDR

10-05-2002 06:16 PM

Quote:

Originally posted by TECK
NTLDR, in your admin options queries, you have 2 option ID's with the same id...
just letting you know. cheers.

Thanks for letting me know TECK :)

All times are GMT. The time now is 03:19 AM.

Page 62 of 162

« First

112

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03673 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 (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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: