Wordpress experts - use another DB for members? - GoFuckYourself.com

fusionx · 10-10-2008, 03:06 PM

Does anyone have any info on using a membership table from another DB for WordPress?

I have a links directory with a blog, and I want them to share a DB for members, eg, you log into one you log into both..

Not sure how possible this is..

GigoloShawn · 10-10-2008, 03:08 PM

It's pretty easy.

Code:

define('CUSTOM_USER_TABLE', 'wp2_users');
define('CUSTOM_USER_META_TABLE', 'wp2_usermeta');

woj · 10-10-2008, 03:19 PM

Quote:

Originally Posted by GigoloShawn

It's pretty easy.

Code:

define('CUSTOM_USER_TABLE', 'wp2_users');
define('CUSTOM_USER_META_TABLE', 'wp2_usermeta');

probably will need a bit more to make it work with a different script...

FlexxAeon · 10-10-2008, 03:29 PM

yeah u gotta make sure the user tables line up, that the headers don't conflict, etc

search support forums on wordpress site - it's been done many times over but quite a few factors are involved

fusionx · 10-10-2008, 03:36 PM

there's also routines needed to handle cookie creation, etc.. I'd imagine..

GrouchyAdmin · 10-10-2008, 03:37 PM

Quote:

Originally Posted by GigoloShawn

It's pretty easy.

Code:

define('CUSTOM_USER_TABLE', 'wp2_users');
define('CUSTOM_USER_META_TABLE', 'wp2_usermeta');

That's all you need for using a different table on the same SQL server between WordPress installs these days.

If you're sharing with a different script, obviously you'll have to have someone roll it for you.

cryptie · 10-10-2008, 08:13 PM

you cannot share cookies cross-domain without some serious hacking :p

however, you can easily have them login twice in both sites.

note in shawns example, you must be using the same database,

10-10-2008, 03:06 PM	#1
fusionx Confirmed User Industry Role: Join Date: Nov 2003 Location: Olongapo City, Philippines Posts: 4,618	Wordpress experts - use another DB for members? Does anyone have any info on using a membership table from another DB for WordPress? I have a links directory with a blog, and I want them to share a DB for members, eg, you log into one you log into both.. Not sure how possible this is..

10-10-2008, 03:08 PM	#2
GigoloShawn Confirmed User Join Date: Oct 2007 Location: No longer with Star Marketing Group. Posts: 700	It's pretty easy. Code: define('CUSTOM_USER_TABLE', 'wp2_users'); define('CUSTOM_USER_META_TABLE', 'wp2_usermeta'); __________________ I no longer represent TrafficGigolos, please contact Justin or Rebecca with any issues.

10-10-2008, 03:29 PM	#4
FlexxAeon Confirmed User Industry Role: Join Date: May 2003 Posts: 3,765	yeah u gotta make sure the user tables line up, that the headers don't conflict, etc search support forums on wordpress site - it's been done many times over but quite a few factors are involved __________________ flexx [dot] aeon [at] gmail

10-10-2008, 08:13 PM	#7
cryptie Confirmed User Join Date: Jul 2007 Location: Montreal Posts: 114	you cannot share cookies cross-domain without some serious hacking :p however, you can easily have them login twice in both sites. note in shawns example, you must be using the same database, __________________ Signature coming soon! Just as soon as my first site goes live! ETA this weekend

10-10-2008, 03:36 PM	#5
fusionx Confirmed User Industry Role: Join Date: Nov 2003 Location: Olongapo City, Philippines Posts: 4,618	there's also routines needed to handle cookie creation, etc.. I'd imagine..