vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   question regarding good practice for potential integration (https://vborg.vbsupport.ru/showthread.php?t=314096)

iPenguin02 09-02-2014 07:29 PM

question regarding good practice for potential integration
 
Before install vbulletin I was wondering about what's a good rule on setting up SQL for potential integration in the future.

Should I create a separate SQL database for each script? For example vbulletin, RSS feed, and ecommerce have there on SQL database? Or put them in the same database with a prefix to distinguish which is which.

I notice you can set a cookie prefix, should each script have its own prefix or one for all would work?

Thank you in advance for your input.

RichieBoy67 09-02-2014 08:12 PM

It depends on the size but I normally just use a different prefix for scripts unless very large and in that case I would use a separate database.

I am not sure what scripts your are going to use that require a cookie prefix but if they are going to allow members log in then they should use the same.

iPenguin02 09-02-2014 08:24 PM

Quote:

Originally Posted by RichieBoy67 (Post 2513543)
It depends on the size but I normally just use a different prefix for scripts unless very large and in that case I would use a separate database.

I am not sure what scripts your are going to use that require a cookie prefix but if they are going to allow members log in then they should use the same.

I do not imagine getting huge, but i do want to plan for the future. If i were to make different databases how hard would it be to integrate them? by integrate i meant to use the same login / information.

Im not sure about the cookies. I know vbulleti allows you to create a prefix, but tiny rss doesn't. haven't looked into an ecommerce yet, but would that be a problem what some you can set a prefix with others you cannot?

RichieBoy67 09-02-2014 09:49 PM

I am a little confused as to what you are trying to do. If you could be more specific as to scripts I may be able to help more.

iPenguin02 09-02-2014 10:09 PM

Sorry, let me try my best. I want to make it possible for users to be able to log into each script using the same login information, so they only have to register once.

Should I create separate databases for each script? One for Vbulletin, one for Tiny Tiny RSS, and one for wordpress.

Or

Create one database and have each script use its own prefix?

RichieBoy67 09-02-2014 10:55 PM

You do not need an rss script with Vbulletin really. It has one built in.

Are you integrating WordPress into Vbulletin? If so I would keep them on the same database with different prefix. otherwise I would use a separate database with a separate database username and password.


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01062 seconds
  • Memory Usage 1,719KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete