News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

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

Started by Spaceman-Spiff, September 03, 2004, 09:14:44 PM

Previous topic - Next topic

Stef001

SMF 2.0.2 | SimplePortal 2.3.5

Eudemon

no, the avatar problem still remains
it kinda make sense tho, cuz the directory for avatar is different
for example, the directory of first forum's avatar is .../public_html/avatars
and the second forum specifies the same directory, but they're different folders with different files in ur server
unless u first share that db and then change the second forum avatar directory to make it point to the first forum

haven't test it, not sure if it works

Stef001

What you said works, perfect. Many many thanks.

Stef.
SMF 2.0.2 | SimplePortal 2.3.5

Arantor

If only it were that simple. The reason that you have issues is because some of the data is stored in the attachments table, and you are strongly not recommended to share THAT between two forums.

Stef001

I have shared the attachment table, why is that not recommendated.
Also i have point the avatar directory to the same directory.
SMF 2.0.2 | SimplePortal 2.3.5

Arantor

Attachments are shared by message id.

An attachment on message 1 on one forum will appear on the other. It won't work properly, but it'll still appear.

Stef001

Sh**, i hoped that i solved the problem.
I have tested and its true, the attachment from one forum shows up in that other forum.

Is there no solution for it??

Stef.
SMF 2.0.2 | SimplePortal 2.3.5

Arantor

Um... not sharing avatars, or moving the entire avatar saving system outside of the attachment table.

Stef001

I am going to try to move the entire avatar system.
But not tonight.
If i can make that i share offcourse.

Thanks for the help.
SMF 2.0.2 | SimplePortal 2.3.5

Eudemon

i don't share attachment table tho

note: by default avatars are uploaded to the attachment directory
in this case the new uploads on second forum still goes to the second forum's attachment directory
you can change that under avatar settings
make that one point to the first forum's avatar directory, see if it works

Arantor

And there's still an entry in the attachments table *regardless* of whether you use the same folder or not...

luuuciano

Using this aproach: http://www.simplemachines.org/community/index.php?topic=16190.msg2523327#msg2523327

What happens when 2.0 final appears (did you hear the thunder?)?

It will be too complicated to update it? (suppose you have 10 forums sharing tables in that way...)
No me agradan los foros que no te dejan borrar TU PROPIO usuario, como por ejemplo smfsimple.com.
E incluso te mandan emails no solicitados, de los cuales, quizá, no puedas escapar porque NO te dejan posibilidad a deshabilitarlos (a menos que NO te tengan en su lista negra).

luuuciano

Wich problem will have if I share the settings table too?

A lot of mods store settings there... Im trying to not use too many mods, but 3/4 of the regular 15 mods I use are storing settings there (or, a few, uses their own tables)

No me agradan los foros que no te dejan borrar TU PROPIO usuario, como por ejemplo smfsimple.com.
E incluso te mandan emails no solicitados, de los cuales, quizá, no puedas escapar porque NO te dejan posibilidad a deshabilitarlos (a menos que NO te tengan en su lista negra).

mkmeister

I would definitely NOT share the settings table. There may be many settings that are unique to each forum installation (paths, domains, etc).

luuuciano

#394
Mmmmm, what about if I want to share avatars... and deactivate attachments (I mean files, attached to posts... to avoid issues of files being shared between boards)
It will be ok to share the attachements table, so users will be able to upload avatars and see them in all the forums?

(and all the forums using the same paths for uploaded avatars, I guess...)
No me agradan los foros que no te dejan borrar TU PROPIO usuario, como por ejemplo smfsimple.com.
E incluso te mandan emails no solicitados, de los cuales, quizá, no puedas escapar porque NO te dejan posibilidad a deshabilitarlos (a menos que NO te tengan en su lista negra).

Hj Ahmad Rasyid Hj Ismail

Quote from: luuuciano on May 10, 2011, 04:37:23 PM
Mmmmm, what about if I want to share avatars... and deactivate attachments (I mean files, attached to posts... to avoid issues of files being shared between boards)
It will be ok to share the attachements table, so users will be able to upload avatars and see them in all the forums?

(and all the forums using the same paths for uploaded avatars, I guess...)
I honestly dont think it'll work...

Stef001

Quote from: luuuciano on May 10, 2011, 04:37:23 PM
Mmmmm, what about if I want to share avatars... and deactivate attachments (I mean files, attached to posts... to avoid issues of files being shared between boards)
It will be ok to share the attachements table, so users will be able to upload avatars and see them in all the forums?

(and all the forums using the same paths for uploaded avatars, I guess...)

I did it that way and it works.

Stef.
SMF 2.0.2 | SimplePortal 2.3.5

luuuciano

#397
mmm nevermind, I will have to share it as it storing a lot of user options...

So, I will have to think how to change things in the template, based in each subdomain?...
at least the logo image... mmmm

By mistake I have shared the themes table (then I realized that I need different themes in each forum)

so... how to undone:
CREATE VIEW forum2STAFE_themes AS SELECT * FROM shared_themes;
How to break/destroy a view? it is like a simlink, right?

the old table was renamed to forum2STAFE_themes_OLD...
No me agradan los foros que no te dejan borrar TU PROPIO usuario, como por ejemplo smfsimple.com.
E incluso te mandan emails no solicitados, de los cuales, quizá, no puedas escapar porque NO te dejan posibilidad a deshabilitarlos (a menos que NO te tengan en su lista negra).

luuuciano

Mmmmm, I will have several subforums... eahc one in his subdomain... sharing tables... but, I want to be able to show different adsense banners in each forum... so... I will have to not whare the themes table?

I will loose all the user theme settings... and customs profile fields (those fields are stored in that table...)

Any idea?
No me agradan los foros que no te dejan borrar TU PROPIO usuario, como por ejemplo smfsimple.com.
E incluso te mandan emails no solicitados, de los cuales, quizá, no puedas escapar porque NO te dejan posibilidad a deshabilitarlos (a menos que NO te tengan en su lista negra).

Hj Ahmad Rasyid Hj Ismail

Use subforums mod available at portamx.com. It is however build for SMF 2.0 RC3 and will never be updated until SMF 2.0 turn gold.

Advertisement: