Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 05-23-2008, 01:54 AM
DarkGizmo DarkGizmo is offline
 
Join Date: Apr 2008
Location: NYC
Posts: 196
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vB integration

Ok what i want to do is have posts in a certain forum on my forums display as content on my main page, only the initial post of course..

So what i need to know is where do i SELECT from in vB's table structure? I am unfamiliar with it...also is there a log-in script i can use to integrate my logins and sessions into the main site so it says "Welcome NegativeSmoke (log out)" etc.... on my main page?
Reply With Quote
  #2  
Old 05-23-2008, 10:27 AM
JamesTalbot JamesTalbot is offline
 
Join Date: Dec 2004
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Both are indeed possible. For the first post in a thread all you need to do is query the post table and just specifcy what the threadid is. Alternatively if you wanted the most recent post or thread you would query the thread table and the post table and then order by DESC with a limit of 0,1. I think that answers your question, if not please say.

Your second question is also possible. If you want the logon box i believe you can just copy the HTML from the logon template and use that. The important thing is that the FORM ACTION points to the vBulletin Login File.

If you would like an example please say.

James
Reply With Quote
  #3  
Old 05-23-2008, 03:35 PM
DarkGizmo DarkGizmo is offline
 
Join Date: Apr 2008
Location: NYC
Posts: 196
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes would you be able to provide me with examples of the code(s) and such to use?

Also, would it be possible to provide me with the queries needed?

my template structure is vB_ for the database....so for example:
vB_posts

I'm new to using SQL and a new vB user as well, i have a guy offering to do it for me but i don't trust him enough with my information especially access to my database.....and since i paid for my vB license i don't want anyone else with my info..

I'd greatly appreciate it sir.

see right now i have my forums living at http://zeroboards.net, i plan on moving them to http://boards.zeroboards.net and having the main site live at http://zeroboards.net

I have a layout already made too.
Reply With Quote
  #4  
Old 05-24-2008, 04:46 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You shouldn't really delve into things you are not really confident with. I suggest some reading on basic PHP/MySQL, it would help in the long run.
Reply With Quote
  #5  
Old 05-24-2008, 02:01 PM
DarkGizmo DarkGizmo is offline
 
Join Date: Apr 2008
Location: NYC
Posts: 196
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Umm yeah i'm pretty sure i can do this i just need the basic set-up structure of things thats all. I'm unfamiliar with the table structure in vBulletin.
Reply With Quote
  #6  
Old 05-24-2008, 02:25 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Use phpmyadmin to view the database and table structure.
Reply With Quote
  #7  
Old 05-24-2008, 04:23 PM
DarkGizmo DarkGizmo is offline
 
Join Date: Apr 2008
Location: NYC
Posts: 196
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah will do.

Wouldn't it just be "SELECT FROM 'vB_post' WHERE 'forum ID=XXX' " ?
Reply With Quote
Reply

Thread Tools
Display Modes

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 12:24 PM.


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.04512 seconds
  • Memory Usage 2,208KB
  • Queries Executed 13 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete