Customizing SMF > Tips and Tricks

Share user database for 2 (or more) different forums.

<< < (2/97) > >>

Elijah Bliss:
What if the second forum is located on another server?

[Unknown]:

--- Quote from: Elijah Bliss on September 12, 2004, 04:53:52 PM ---What if the second forum is located on another server?

--- End quote ---

Then it's nearly impossible... or you could just use one MySQL server still, but it would be horridly slow.

-[Unknown]

Spaceman-Spiff:
I didn't realize some queries use single quotes instead of double...


--- Quote from: Elijah Bliss on September 12, 2004, 04:53:52 PM ---What if the second forum is located on another server?

--- End quote ---
Usually webhosts don't allow remote database access. But if you own the server yourself, you can try to configure it to allow remote access.

[Unknown]:

--- Quote from: [Unknown] on September 12, 2004, 01:22:19 AM ---
--- Code: ---$qrycr = mysql_query('
SELECT membergroup, ACCTUSER
FROM smf_roster
WHERE ACCTUSER = \'' . $user_info['username'] . '\'');
--- End code ---

--- End quote ---


--- Quote from: Spaceman-Spiff on September 21, 2004, 01:48:17 AM ---I didn't realize some queries use single quotes instead of double...

--- End quote ---

None do currently in the SMF code base, that query is not from SMF.

-[Unknown]

Nic:
Firstly, thanks SO much for this post - it was exactly what I needed.  I now have two forums for two sub-domains on the same site using one member table, which is just what I wanted.  however, I did notice one thing (no biggy, but wondered if I could fix it).  If someone registers on one forum, the member count automatically adds another one on, but on the other forum it doesn't and I have to tell it to recount the totals.  it's not a big hassle at the moment, since both forums are just new and not many people are registering, but if the forums get bigger it could be annoying having to recount totals each time a new member joins.  Is there any way around this?

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version