| Author |
Message |
Shorty
MD user level 5


Joined: Jan 10, 2006
Posts: 149
Member
|
 Posted:
Feb 05, 2006 - 12:25 PM |
|
| Post subject: Several sites using the same user DB. Possible? If so how? |
I have ordered a proper host for my site and my plan it so have subdomains in categories gamer-family-cars-nightlife
I`m gonna set up a complete mdpro site for each but i wanna have it so that they use the same user database. which means if you register at one you register all. However, i want a complete new site for each. new template, new menues, block etc etc. a completely different site.
How will i set it up so that it uses the same DB? I looked at the mutisite module but if i got it right i cant use that one. Or?
Shorty |
|
|
|
 |
Seb
MD Staff


Joined: Nov 24, 2003
Posts: 283
Location: Birmingham, UK
bannato
|
 Posted:
Feb 05, 2006 - 12:50 PM |
|
|
|
|
 |
Shorty
MD user level 5


Joined: Jan 10, 2006
Posts: 149
bannato
|
 Posted:
Feb 05, 2006 - 02:09 PM |
|
|
thats a complete system right and not just a module? i wanna stick to the basic mdpro as it`s easier to get support that way.
If i could jsut make the userdb joined i`b be happy.
The different categories are gonna be subdomains so i`ll just link them on the frontpage of the standard site and they work independent of eachother exept the user db. So you can login on eny of them and register one then you are registered at all.
Is this really hard doing?
Shorty |
|
|
|
 |
Seb
MD Staff


Joined: Nov 24, 2003
Posts: 283
Location: Birmingham, UK
bannato
|
 Posted:
Feb 05, 2006 - 02:36 PM |
|
|
It is a complete system, but MDChannels is based on MDPro so support is more or less the same (Pete, tell me if I'm wrong here)
I don't know if it handle subdomains, but it seems the easiest way of doing things. The idea of MDChannels is that all "channels" share the same DB, but content and appearance is targeted and can be customized for each channel.
If you hack MDPro so users can share the same DB accross different sites, I'm not sure you will get support anyway as it would mean that you have a customized version and as such we won't be able to reproduce potential bugs that your hack may create. |
_________________ French Support Manager
http://www.maxdevfrance.com |
|
|
 |
Shorty
MD user level 5


Joined: Jan 10, 2006
Posts: 149
bannato
|
 Posted:
Feb 08, 2006 - 07:42 AM |
|
|
ok i`ve read about the mdchannel and have understood that the channels are base on user groups instead of what i`m looking for.
Still looking for a way to have completely different and independent sites with the same user DB. Any other ideas please...
Shorty |
|
|
|
 |
Shorty
MD user level 5


Joined: Jan 10, 2006
Posts: 149
bannato
|
 Posted:
Feb 08, 2006 - 08:06 AM |
|
|
i found out i can use miltisites maby afterall. Xan someone help me setting this up? I read the tutorial and that won`t work for me as stated in requirements. Can someone help me setting this up on a non virtual host without apache server access?
I can just install the newest mdpro completely first right? The mutisite can be doen after the initial install...
Shorty |
|
|
|
 |
Shorty
MD user level 5


Joined: Jan 10, 2006
Posts: 149
bannato
|
 Posted:
Feb 09, 2006 - 09:48 AM |
|
|
ok, i`ve been working with the multisite module for w while now and doesn`t think that is what i wanna do.
I made 3 subdomains and with my standard one it looks like this:
root on my ftp
alesundportalen.net
familie.alesundportalen.net
gamer.alesundportalen.net
bilogmotor.alesundportalen.net
Now, if i do the complete install of mdpro on all of them with their own table prefix on the same database like this
original first:
md_
md_fm_
md_gm_
md_bm_
Now how can i make them read from the same user table? can i just drop the user table in the subdomains prefix and it automatically reads from the md_ prefix?
Please help me on this.....
Shorty |
|
|
|
 |
Shorty
MD user level 5


Joined: Jan 10, 2006
Posts: 149
bannato
|
 Posted:
Feb 09, 2006 - 08:11 PM |
|
|
from what i`ve figured out these (bolow) are the user tables right?
| Code:
|
$user_data = $prefix . '_user_data';
$pntable['user_data'] = $user_data;
$pntable['user_data_column'] = array ('uda_id' => $user_data . '.pn_uda_id',
'uda_propid' => $user_data . '.pn_uda_propid',
'uda_uid' => $user_data . '.pn_uda_uid',
'uda_value' => $user_data . '.pn_uda_value');
$user_perms = $prefix . '_user_perms';
$pntable['user_perms'] = $user_perms;
$pntable['user_perms_column'] = array ('pid' => $user_perms . '.pn_pid',
'uid' => $user_perms . '.pn_uid',
'sequence' => $user_perms . '.pn_sequence',
'realm' => $user_perms . '.pn_realm',
'component' => $user_perms . '.pn_component',
'instance' => $user_perms . '.pn_instance',
'level' => $user_perms . '.pn_level',
'bond' => $user_perms . '.pn_bond');
|
So if i use them in the subdomains i`ll be ok i think.
Anyone, and i mean anyone at all have any thoughts on that?
Shorty |
|
|
|
 |
ifteba
MDBooster


Joined: Dec 22, 2003
Posts: 204
Location: Bangladesh
bannato
|
 Posted:
Feb 09, 2006 - 08:32 PM |
|
|
I never worked with multisites before. I know MDPro has multisite modules [ I think]. But anyways, I would install MDPro to subdomain editing the md-config file manually and that make themes to fit whatever I want to show all of those subdomain sites. As you know with autotheme you can create unlimited blocks.
For example,
for main site I would use blocks from 1-11 than I would create extra blocks using autotheme commands and use them for other subdomains sites.
By doing this I guess site might load lil bit slow but it should work. As while site loading it will check all the db tables.
I am not sure if I described well enough to understand. |
|
|
|
 |
NateM
MD user level 5


Joined: June 18, 2005
Posts: 165
bannato
|
 Posted:
Feb 09, 2006 - 11:22 PM |
|
|
Well, could you do something like this? If you were to create multiple user tables for the different sites like so:
md_
md_fm_
Then, you go back and change the user table prefix in the first install from _user_data to _fm_user_data, or something like that? As long as the prefixes follow one another, they should be able to use the same user table as long as you change the individual prefixes for each installs to match each other. I've never done anything like this, so I'm not really sure, but it might be worth trying. |
|
|
|
 |
whazoo
MDBooster


Joined: Feb 05, 2006
Posts: 34
Location: Chicago
bannato
|
 Posted:
Feb 09, 2006 - 11:47 PM |
|
|
wouldnt a user_table =
option in the config.php be great? |
|
|
|
 |
Shorty
MD user level 5


Joined: Jan 10, 2006
Posts: 149
bannato
|
 Posted:
Feb 10, 2006 - 04:41 AM |
|
|
| whazoo wrote: |
wouldnt a user_table =
option in the config.php be great? |
please continue. i might make a personal_config.php as the config calls on that before going to md-config but i don`t know how to do this.
I just installed the mdpro on a subdomain without any problems under prefix md_gm (gamer). i wonder what would happen if i just changed the prefix to the same as the other one means md. they would just crash maby.
Anyway, i need to redirect some tables in the md_gm to the standard one. Anyone know how to do this.
I found the tables i think as i posted abowe, the user tables i mean. Those i need to be read from md_gm..... does anyone know how to make a personal_config.php? |
|
|
|
 |
Shorty
MD user level 5


Joined: Jan 10, 2006
Posts: 149
bannato
|
 Posted:
Feb 11, 2006 - 12:16 AM |
|
|
ok heres my next little thing i ca`t figure out.
This is my md-config.php in the subdomain which i made the array:
| Code:
|
$pnconfig['prefix'] = array(
'default' => 'md_gm.',
'_faqanswer' => 'md.',
'_group_membership' => 'md.',
'_group_perms' => 'md.',
'_groups' => 'md.',
'_message' => 'md.',
'_priv_msgs' => 'md.',
'_priv_msgs_outbox' => 'md.',
'_stats_date' => 'md.',
'_stats_hour' => 'md.',
'_stats_month' => 'md.',
'_stats_week' => 'md.',
'_user_data' => 'md.',
'_user_perms' => 'md.',
'_user_property' => 'md.',
'_users' => 'md.',
'_users_delrequest' => 'md.',
'_admin_lite_group' => 'md.',
'_admin_lite_group_members' => 'md.',
'_users_modrequest' => 'md.',
);
$pnconfig['encoded'] = '1';
|
i now get this:
| Code:
|
|
Session initialization failed
|
i cannot figure out whats wrong with that? is there anyone that can see the error?
Shorty |
|
|
|
 |
PeteBest
MD user level 5


Joined: Oct 06, 2003
Posts: 4845
bannato
|
 Posted:
Feb 11, 2006 - 01:28 AM |
|
|
Why are you trying to put the prefix as an array? That won't work, as the prefix isn't expected to be an array. So throughout the code you'll just get array_table, not the actual prefix, as you haven't selected something in the array.
You really need to read the MultiSite Tutorial to get a basic understanding of the functionality and practical use of multisites, as hacking and trying to put the prefix as an array isn't how it works! |
_________________ Retired from official MAXdev duties |
|
|
 |
Shorty
MD user level 5


Joined: Jan 10, 2006
Posts: 149
bannato
|
 Posted:
Feb 11, 2006 - 01:43 AM |
|
|
that tutorial has been updated since i last read trough it! Now it looks great and this looks like exactly what i need.
I tried to do a personl_config.php defining the prefixes but that tutorial does the trick. Maby i`ll finally get it right.  |
|
|
|
 |
|
|