Multiple forums, One database, Shared PM, Points..

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/60422?pagenum=1
05 November 2025, 16:44

Topic


ILLHILL
Multiple forums, One database, Shared PM, Points..
09 December 2005, 15:58


I did a search on this and found a start, posted by Richard:

to have 2 forums share a database, you just need to change 2 lines in the config.asp file of the second forum:

forum #1's config.asp:

strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"

forum #2's config.asp:

strTablePrefix = "FORUM2_"
strMemberTablePrefix = "FORUM2_"

Doing it this way, you can use the same database for both forums. No data will be shared between each of them.
If you want to share the Members table then:

forum #2's config.asp:

strTablePrefix = "FORUM2_"
strMemberTablePrefix = "FORUM_"


I applied this, only to bump into this:

Microsoft JET Database Engine error '80040e37'

The Microsoft Jet database engine cannot find the input table or query 'FORUM2_PM'. Make sure it exists and that its name is spelled correctly.
inc_header.asp, line 183


So, basically the forum is checking for the Forum2_PM field,
which doesn't exist. I want things like Users, PM's, amount of posts,
points and active users all loaded from Forum 1's database, then
have things as categories and in-forumposts load from Forum2 fields.
Anyway I can trick the forum/database into believing that some of the
Forum2 fields are Forum_ fields? So, in that way you can send a PM
in forum1, which will also be readable in Forum2, 3, 4, etc and with
that turning a one-time registration into some sort of "Forum Passport" ?
Any help would be appreciated cause I expect to bump into this
error a couple of times with different fields, so any solution is
welcome, maybe a Config2.asp file in which fields are specified to
be shared fields or forum only fields?
*help*

Thanks in advance!
bigsmile
D<

 

Replies ...


laser
09 December 2005, 16:24


So you're using this option ?
If you want to share the Members table then:

forum #2's config.asp:

strTablePrefix = "FORUM2_"
strMemberTablePrefix = "FORUM_"

If so, you could use strMemberTablePrefix as the prefix on your PM table (and other mod tables that you want to share, but it might be easier to create this in both config.asp files :

strSharedTablePrefix = "FORUM_"

Then go through all your mod's that you want to share and make sure they reference the SharedTable prefix instead of the Table prefix.<
ILLHILL
09 December 2005, 18:20


Any example on how that would look and what I have to look for in the files?
Appreciate it!
Dominic<
laser
10 December 2005, 00:29


No example, but if you want to share the PM's, I would add the strSharedTablePrefix value and then search for :

strTablePrefix & "PM

and change to

strSharedTablePrefix & "PM

or maybe just search for "PM

Basically what you're doing is a lot like the sharing members option, but naming the variable something more generic. <
ILLHILL
10 December 2005, 16:17


Seems to work perfectly, updating the last bits and had to download the dbase to add some
tables.
Thanks very much for the help Laser!
Greets & thanks,

Dominic<
laser
10 December 2005, 16:55


np's, glad it worked for you smile<
© 2000-2021 Snitz™ Communications