2 or more site share same user database

Posted: Fri Apr 11, 2003 12:15 am

Is it possible that 2 or more site can share one user database?

by just changing the prefix and user prefix in the config?

Posted: Fri Apr 11, 2003 2:38 am

Hello,

I have 3 domains (.org, .net and .com) the only way .net & .com are sharing .org database is because I have .net & .com as parked domains with my host under the .org account which is used as my primary domain.

(.net & .com) are used by partners to offer my members free website (.net) and free email (.com). Although I don't think they could share the same database if I had .net or .com hosted by another company or the same company under another database name (ie: .org database name foxy) if .com database name was foxyfem I think it would be a conflict to call something from foxy database whereas .com database would be foxyfem. Of course thats my unprofessional thought.

Posted: Fri Apr 11, 2003 3:53 am

I was talking about the site are host under the same server and using the same database with difference prefix, name "nuke" and "abc".

I would like the site using prefix "abc" to use the user data in the prefix "nuke" instead of "abc". So that both share the same user.

how to do it any advise? Rolling Eyes

Posted: Fri Apr 11, 2003 4:29 am

Hello,

All three of my domains are hosted by the same company utilizing the same server. If I contacted my host and said I want .com to share .org database I think they would say impossible because .com has its own database name (foxyfem) and .org has its own database name (foxy). Now if I want .com to share .org database (in which it does) its because I have .com parked under the .org account. Maybe your host will allow it but most hosts give each domain their own database.

www.whatever.com can not use data from www.whatever.org database (utilizing the same server), if thats the case I'd be able to use nukecops.com database files if I were using the same server their using (major security risk).

My host will give me as many databases as I need for my website. (ie: if i needed an extra database for .com I would have it but not with the same database name as .org)

addendum: Now someone please correct me if I'm wrong but that appear to be a major security risk for two domains to share the same database unless the situation is like mine (.com is a parked domain not utilized at all other than by my registra for the MX record only).

Posted: Fri Apr 11, 2003 8:46 am

2 difference wedsite is possible to use the same database for your info.

You could have www.abc.com and www.abc.net running in the same database "abc" as long the server host are the same. Mean If you have only one wedsite (abc.com) with database, and the others one(abc.net) do not have, if both are having the same server host it is possible that abc.net can use the abc.com database by using 2 difference prefix in one database. That depend on yours hosting server.

Now back to my question, I have try with the both site set to the same user prefix in the same database, it seen working, but have problem with log out, but what worry me is it will create unforseen problem and error later.

Do any one have try and have success without problem? Rolling Eyes

Posted: Fri Apr 11, 2003 9:30 am

Hello,

If www.abc.net is utilizing www.abc.com database apparently www.abc.net is parked at www.abc.com account. They can't be two different accounts. (ie: if you go to www.mydomain.com it will appear that you're at mydomain.com but in reality you're at www.mydomain.org because mydomain.com is parked at www.mydomain.org)

If you succeed at it please share with me how you did it under two different accounts www.abc.net utilizing www.abc.com database without one or the other being a parked domain (virtually non existence).

If a hacker tamper with www.abc.net database I guess they can kill two birds with one stone abc.net & abc.com since they're both using the same database. major security risk

Sergeant Joined: Feb 27, 2003 Posts: 94

You can, I did saw someone doing it:
You have to set it up like this:
Config.php for site 1:

Code:

$dbname = "nuke_nuke";
$prefix = "nuke";
$user_prefix = "nuke";

Config.php for site 2

Code:

$dbname = "nuke_nuke";
$prefix = "nuke2";
$user_prefix = "nuke";

In fact the $dbname and the $user_prefix need to be the same.
Then open includes/constants.php (for the two sites) and find this

Code:

define('AUTH_ACCESS_TABLE', $user_prefix.'_bbauth_access');
define('BANLIST_TABLE', $user_prefix.'_bbbanlist');
define('CATEGORIES_TABLE', $user_prefix.'_bbcategories');
define('CONFIG_TABLE', $user_prefix.'_bbconfig');
define('DISALLOW_TABLE', $user_prefix.'_bbdisallow');
define('FORUMS_TABLE', $user_prefix.'_bbforums');
define('GROUPS_TABLE', $user_prefix.'_bbgroups');
define('POSTS_TABLE', $user_prefix.'_bbposts');
define('POSTS_TEXT_TABLE', $user_prefix.'_bbposts_text');
define('PRIVMSGS_TABLE', $user_prefix.'_bbprivmsgs');
define('PRIVMSGS_TEXT_TABLE', $user_prefix.'_bbprivmsgs_text');
define('PRIVMSGS_IGNORE_TABLE', $user_prefix.'_bbprivmsgs_ignore');
define('PRUNE_TABLE', $user_prefix.'_bbforum_prune');
define('RANKS_TABLE', $user_prefix.'_bbranks');
define('SEARCH_TABLE', $user_prefix.'_bbsearch_results');
define('SEARCH_WORD_TABLE', $user_prefix.'_bbsearch_wordlist');
define('SEARCH_MATCH_TABLE', $user_prefix.'_bbsearch_wordmatch');
define('SESSIONS_TABLE', $user_prefix.'_bbsessions');
define('SMILIES_TABLE', $user_prefix.'_bbsmilies');
define('THEMES_TABLE', $user_prefix.'_bbthemes');
define('THEMES_NAME_TABLE', $user_prefix.'_bbthemes_name');
define('TOPICS_TABLE', $user_prefix.'_bbtopics');
define('TOPICS_WATCH_TABLE', $user_prefix.'_bbtopics_watch');
define('USER_GROUP_TABLE', $user_prefix.'_bbuser_group');
define('USERS_TABLE', $user_prefix.'_users');
define('WORDS_TABLE', $user_prefix.'_bbwords');
define('VOTE_DESC_TABLE', $user_prefix.'_bbvote_desc');
define('VOTE_RESULTS_TABLE', $user_prefix.'_bbvote_results');
define('VOTE_USERS_TABLE', $user_prefix.'_bbvote_voters');

and change it too

Code:

define('AUTH_ACCESS_TABLE', $prefix.'_bbauth_access');
define('BANLIST_TABLE', $prefix.'_bbbanlist');
define('CATEGORIES_TABLE', $prefix.'_bbcategories');
define('CONFIG_TABLE', $prefix.'_bbconfig');
define('DISALLOW_TABLE', $prefix.'_bbdisallow');
define('FORUMS_TABLE', $prefix.'_bbforums');
define('GROUPS_TABLE', $prefix.'_bbgroups');
define('POSTS_TABLE', $prefix.'_bbposts');
define('POSTS_TEXT_TABLE', $prefix.'_bbposts_text');
define('PRIVMSGS_TABLE', $prefix.'_bbprivmsgs');
define('PRIVMSGS_TEXT_TABLE', $prefix.'_bbprivmsgs_text');
define('PRIVMSGS_IGNORE_TABLE', $prefix.'_bbprivmsgs_ignore');
define('PRUNE_TABLE', $prefix.'_bbforum_prune');
define('RANKS_TABLE', $prefix.'_bbranks');
define('SEARCH_TABLE', $prefix.'_bbsearch_results');
define('SEARCH_WORD_TABLE', $prefix.'_bbsearch_wordlist');
define('SEARCH_MATCH_TABLE', $prefix.'_bbsearch_wordmatch');
define('SESSIONS_TABLE', $prefix.'_bbsessions');
define('SMILIES_TABLE', $prefix.'_bbsmilies');
define('THEMES_TABLE', $prefix.'_bbthemes');
define('THEMES_NAME_TABLE', $prefix.'_bbthemes_name');
define('TOPICS_TABLE', $prefix.'_bbtopics');
define('TOPICS_WATCH_TABLE', $prefix.'_bbtopics_watch');
define('USER_GROUP_TABLE', $prefix.'_bbuser_group');
define('USERS_TABLE', $user_prefix.'_users');
define('WORDS_TABLE', $prefix.'_bbwords');
define('VOTE_DESC_TABLE', $prefix.'_bbvote_desc');
define('VOTE_RESULTS_TABLE', $prefix.'_bbvote_results');
define('VOTE_USERS_TABLE', $prefix.'_bbvote_voters');

You have to do this otherwise your forumtables will be shared too.
I only tested it one time so please let me know if you find some bugs

Bye,
Mighty_Y

Posted: Fri Apr 11, 2003 9:49 am

Mighty Y, If I did that for .org, .net & .com then some wannabe hacker come along tamper will my database, would it effect all of my domains?

If I have nuke_users under .org how would nuke_users be shared with .com without me copying the nuke_users file to nuke2_users?

Sergeant Joined: Feb 27, 2003 Posts: 94

I have forgotten to say something:
You must have your 3 sites on the same server using the same database.
And then you have to install nuke 3 times into that same database and then you have to do the instructions as I said above.

Please repley again if this was not the answer on your question

Posted: Fri Apr 11, 2003 10:16 am

Install nuke 3 times, park domains under one account, install nuke 3 times, park domains under one account (lazy mode) I'll keep my other two domains parked under my one account and everybody share everything with one installation.

Note: I'll like to see the website that utilize Mighty Y's method. I can signup on one site and have access to both sites. Wow!

Sergeant Joined: Feb 27, 2003 Posts: 94

There is one (I helped to set it up) but he is still working on it. For someone interested to know who has a website like that it is ConKien on Nukemods and Portedmods.