two sites ... one nuke_users table??????????

Theme Guru Joined: Nov 01, 2003 Posts: 1006

I was asked a question today by a site visitor that I do not know the answer to. I have decided to ask here and hopefully cover all bases for him.

He currently has a 7.5 nuke site.

He would like to create a subdomain site.

He would like for both sites to run off the same nuke_users table.

He does not want to just have the users transfered.

He wants to have it where when the subdomain is created. It is populated with the same nuke_users table. Therefore, when someone should sign up on one site they will actually be signed up on both.

He wants the sites to be totally independent of content , blocks, modules, etc.

I do not believe this can be done and if it can then how???

As always any help would be greatly appreciated.

Thank you, Jaded

registered · Posted: Tue Mar 15, 2005 4:14 pm

I don't see how that is possible at all.

You would have to have a total control server, I would think.

You would have to use a script that would have one site update the other sites user list any time someone new signs up.

Like I said, they would probably need root access on the box.

I may be all wet on this but I don't think so.

Posted: Wed Mar 16, 2005 1:24 am

They can create a second set of db tables on the same database, for the second site he should create all tables except for users and temp_users, these new tables of course need a different prefix so that they can both exist on the same database, the only difference when setting it up is that $prefix on the new site's config.php file should be that of the newly created tables, $user_prefix should be that of the other site's $prefix.

Posted: Wed Mar 16, 2005 6:33 am

thank you Chat, you always know!

Posted: Wed Mar 16, 2005 8:21 am

Chat

Posted: Wed Mar 16, 2005 9:49 am

To further explain:

The existing site remains untouched, no changes required, let's assume these are the settings on the existing site's config.php:

$dbhost = "localhost";
$dbuname = "db uname";
$dbpass = "db pass";
$dbname = "db name";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "SdFk*fa28367-dm56w69.3a2fDS+e9";
$gfx_chk = 0;
$subscription_url = "";

It uses nuke as its $prefix, assuming the new site will use sub as its $prefix, you would edit its config/php as follows:

$dbhost = "localhost";
$dbuname = "db uname";
$dbpass = "db pass";
$dbname = "db name";
$prefix = "sub";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "SdFk*fa28367-dm56w69.3a2fDS+e9";
$gfx_chk = 0;
$subscription_url = "";

New Member Joined: Jun 08, 2005 Posts: 6

So,

Could you technically revert this option? Do the opposite?

I mean, could you have two identical sites content-wise, with two different user bases by swapping prefix and user prefix?

ie:

Quote:

The existing site remains untouched, no changes required, let's assume these are the settings on the existing site's config.php:

$dbhost = "localhost";
$dbuname = "db uname";
$dbpass = "db pass";
$dbname = "db name";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "SdFk*fa28367-dm56w69.3a2fDS+e9";
$gfx_chk = 0;
$subscription_url = "";

It uses nuke as its $prefix, assuming the new site will use differentusers as its $user_prefix, you would edit its config/php as follows:

$dbhost = "localhost";
$dbuname = "db uname";
$dbpass = "db pass";
$dbname = "db name";
$prefix = "nuke";
$user_prefix = "differentusers";
$dbtype = "MySQL";
$sitekey = "SdFk*fa28367-dm56w69.3a2fDS+e9";
$gfx_chk = 0;
$subscription_url = "";

Would that work?

Posted: Wed Jun 08, 2005 7:44 pm

You could try and find out if no problems arise.

Posted: Fri Jun 10, 2005 3:24 pm

I just might... Smile

Thanks!

Client Joined: Jul 18, 2003 Posts: 977

Very cool. i wanted to do this a while ago and I think I even asked about a year ago... this is awesome... and no one has had any problems with it?

registered · Posted: Wed Nov 23, 2005 8:24 pm

Well there are some problems with sharing the users table, mostly with the forums.

Users will only have one user profile, one signature, one avatar, one post count. Also, they may have problems when visiting the forums since the latest visit date is stored in that table. It won't properly show the latest unread posts on one forum, when you've visited the other forum.

It's quite cool to do though, I do this on my sites.