vb.org Archive - vBindex v2.1

So it would, I don't know what I was thinking. Currently you can't get the forum title up, you'd need to do a left join on the forum table to get it I expect.

Buddha

12-06-2002 04:01 PM

hey ntldr, i've found a little quirk, and am hoping you can help me with it.
so far, everything's going great. got both styles done and the site's running beautifully... however...
:)
i have some forums set up with moderation queues, because the content appears elswhere on the site (pages i've created using vbindex). i don't want potentially offensive or inappropriate matter appearing on those pages (very unprofessional), so i set up the moderation queue. this obviously works in the forum... posts made by regular users in these moderated forums don't appear in the forum until i pass em through... however they do appear right away on vbindex.
this is not good.
any thoughts?

NTLDR

12-06-2002 04:03 PM

Check the news and threads queries have AND visible=1 in the WHERE clause, I may have missed it out by mistake ;)

Buddha

12-06-2002 04:08 PM

nope, it's not there.
where do i put it?

Quote:

$newsquery=$newsquery=$DB_site->query("SELECT thread.*,threadpost.pagetext AS pagetext FROM thread LEFT JOIN post AS threadpost ON (thread.tpostid = threadpost.postid) WHERE forumid = '$newsforum' ORDER BY thread.dateline DESC LIMIT $newsposts");

thanks for the quick reply.

ukliam

12-06-2002 04:17 PM

Quote:

Originally posted by NTLDR
You would need to add the PHP from that hack to the vbindex.php file and any HTML to the relevent template.

Got my other problem sorted but this is all I could see in the thread on the mini calendar hack.

I have put the code in the vbindex.php file but the calendar just gets displayed at the top of the page.

I know I am not doing it right and I just need to know where in the file I should be putting the code and how to call it from a template.

Cheers

Sean

NTLDR

12-06-2002 04:23 PM

Quote:

Originally posted by Buddha
nope, it's not there.
where do i put it?

PHP Code:


		
			
$newsquery=$newsquery=$DB_site->query("SELECT thread.*,threadpost.pagetext AS pagetext FROM thread LEFT JOIN post AS threadpost ON (thread.tpostid = threadpost.postid) WHERE forumid = '$newsforum' AND thread.visible='1' ORDER BY thread.dateline DESC LIMIT $newsposts");

That should do it ;)

Buddha

12-06-2002 04:29 PM

nope.
giving me a db error.

ukliam

12-06-2002 04:29 PM

Think I have worked it out... :D

NTLDR

12-06-2002 04:38 PM

Quote:

Originally posted by Buddha
nope.
giving me a db error.

OK give it a try now, I changed the code (put thread.visible instead).

mv540

12-06-2002 05:07 PM

aaaheeemmm excuse guys hate to break up the party for a second but about 10 posts back i had a question... :ermm:

Any ideas..???

here is the question:
(post #1169)

I would like to know how to add more areas on the portal so that i can add more/other info manually....

for example..in the middle i have news and on either end i have the navigations...i would like to add more boxes to fill it up abit with information..

Please answer in detail for i am very new at this...let me know step by step where to go and what to do

Thanks

I~

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

Page 118 of 162

118

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02431 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 (1)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 (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: