• Welcome to Simple Machines Community Forum. Please login or sign up.
October 21, 2021, 09:58:39 PM

News:

Wondering if this will always be free?  See why free is better.


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

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

Previous topic - Next topic

Angelotus


Darkness_

they are using the same whole DB.
Only the domain is different xxxxxx.com & zzzzzzz.com

Session DB is that somewhere else then the forum DB?

Angelotus

If it uses the whole db, why? Why not redirect one domain to the other???

Darkness_

The home domain wil be the forum
and the second domain is the index of smf media gallery.

My forums name is amenna
and for the part of se media gallery it wil be
amennArt that's the reason why sharing the whole database.

But I want it to be like if you log out at Amenna (forum) the user wil be logged out of AmennArt to

onscene.co.uk

have followed this to the letter but now when i click onto the second forum, it is giving me

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

any idea's what i've not done right???
On Scene UK

cdr_hayalet

Quote from: bburg5 on February 14, 2009, 04:23:25 PM
I tried the change and get nowhere. Just errors. I deleted the second forum and reloaded it to the same database with different prefix.

This is what I have-
Main Forum prefix-   $db_prefix = 'main';
Second Forum prefix-   $db_prefix = 'main_';

I changed the second forum to read $db_prefix = 'main'; but get an error in phpmyadmin stating it already exsists. Is this not what I am supposed to do?

I just want to get the second forum to mirror the main forum tables without getting so you do not have to reg. for both forums.

It apperas that I am making this more difficult than it should be...

Thanks
ups,bro attention your prefix.It must be like that "main1_"  and "main_2"
i advise you to make it from begging.It will be more easy for you.

cdr_hayalet

Quote from: TheDisturbedOne on February 17, 2009, 12:27:22 PM
Does anybody know if this will work if I bridge a 1.1.8 with a 2.0 RC 1?
i dont think it is gonna work.Cause their data tables are very diffirent.

azn_romeo_4u

I'm starting to work on this new on two brand new forums.  I'm using two different domains

http://www.mydragonica.net [nofollow] and http://www.lunaheroes.com  both mmorpg's.  SMF seems to be the best for sharing users and db's so i am going with smf

I hope this succeeds even a little bit.

Mraza

hello i was able to install 2nd forum and share only members, membergroups, themes and attachments tables but i can't find these syntex :
{$db_prefix}im_recipients
{$db_prefix}instant_messages

and i cant find the updateSettings(array in subs.php     ...please any help

Edit: and when i post on my second forum i can see the topic has been posted but when i click to show the content i  got this error "This topic doesn't exist on this board. " and in my forum stats i got this :

Latest Post: "" ( )

Edit: More discussion at here
Signature:
Old Software Engineers Never Dies, They Just Log Out...
! ! ! ! ! 5 Best Movies Thread ! ! ! ! !

Nimras

Okay so if i just want it so people registeret are on all forums, with username and password so they dont have to rereg everywhere and only has to upload avy and make a sig one place and it is updated everywhere, the rest are managed purely by each forum them self from themes to the other settings.

And also i dont want the other forums to see a user is online as a guest or as the user them self unless they are logged in on that very forum would i need to do much beside these few changes?? as i want each forum to handle their own mods and so on it is just users and their sig plus avy i want to share, post counts, what they have access to is managed individual by each forum meaning if they reg and log into a forum they dont have access to they wont get it.

Mraza

Quote from: Nimras on June 22, 2009, 12:14:27 PM
Okay so if i just want it so people registeret are on all forums, with username and password so they dont have to rereg everywhere and only has to upload avy and make a sig one place and it is updated everywhere, the rest are managed purely by each forum them self from themes to the other settings.

And also i dont want the other forums to see a user is online as a guest or as the user them self unless they are logged in on that very forum would i need to do much beside these few changes?? as i want each forum to handle their own mods and so on it is just users and their sig plus avy i want to share, post counts, what they have access to is managed individual by each forum meaning if they reg and log into a forum they dont have access to they wont get it.
you need to share  members, membergroups, themes and attachments tables. for this in your Source directory find these tables and change it to your first forum prefix ..for example if your prefix is smf1_ so for members find  " {$db_prefix}members " and change it to " smf1_members" without quotes and so on...
Signature:
Old Software Engineers Never Dies, They Just Log Out...
! ! ! ! ! 5 Best Movies Thread ! ! ! ! !

Nimras

June 22, 2009, 06:55:28 PM #231 Last Edit: June 22, 2009, 06:59:25 PM by Nimras
Quote from: mraza on June 22, 2009, 05:44:26 PM
Quote from: Nimras on June 22, 2009, 12:14:27 PM
Okay so if i just want it so people registeret are on all forums, with username and password so they dont have to rereg everywhere and only has to upload avy and make a sig one place and it is updated everywhere, the rest are managed purely by each forum them self from themes to the other settings.

And also i dont want the other forums to see a user is online as a guest or as the user them self unless they are logged in on that very forum would i need to do much beside these few changes?? as i want each forum to handle their own mods and so on it is just users and their sig plus avy i want to share, post counts, what they have access to is managed individual by each forum meaning if they reg and log into a forum they dont have access to they wont get it.
you need to share  members, membergroups, themes and attachments tables. for this in your Source directory find these tables and change it to your first forum prefix ..for example if your prefix is smf1_ so for members find  " {$db_prefix}members " and change it to " smf1_members" without quotes and so on...

Also when i only want users to reg one time then they can log in every where, the sig and avy are shared. REST should not be shared. Themes, groups and so on. only thing that is are the users so they can log in everywhere and dont have to reg every forum and set up avy and sig all place. Everything else i want to be not shared, ranks member groups and so on should not be shared what they have of rank and membergroup or access in forum a should not be shared with forum b there he can have another rank and membergroup access, as said only thing i want for easier work is that login and reg means they are able to login everywhere when registret and their sig and avy are shared so they dont have to redo that, but every thing else from other settings and post counts what ever does not follow over. offcourse a permban one place follow over but i mean i want everything else to be strictly for the other forums.

As we will make a flash intro where registrering and loging in can be done from and then they can move to a forum or read more hence i want this. if you get me??

Tyilanmenyn

Can someone plz make an simple small guide on how to do this with 2.0 RC1-1?

Mraza

Quote from: Tyilanmenyn on June 24, 2009, 08:10:37 AM
Can someone plz make an simple small guide on how to do this with 2.0 RC1-1?
In few days i will make a complete guide for this....just hold on ;)
Signature:
Old Software Engineers Never Dies, They Just Log Out...
! ! ! ! ! 5 Best Movies Thread ! ! ! ! !

Nimras

Quote from: mraza on June 25, 2009, 03:39:00 PM
Quote from: Tyilanmenyn on June 24, 2009, 08:10:37 AM
Can someone plz make an simple small guide on how to do this with 2.0 RC1-1?
In few days i will make a complete guide for this....just hold on ;)

Good but if i just want all users to log in once and reg once to have access to all areas plus setup sig and avy one place for it to be everywhere and then nothing else should be shared as i want each forum to be 100% on their own with mods, rights and groups would that be possible easy??

Tyilanmenyn

Quote from: mraza on June 25, 2009, 03:39:00 PM
Quote from: Tyilanmenyn on June 24, 2009, 08:10:37 AM
Can someone plz make an simple small guide on how to do this with 2.0 RC1-1?
In few days i will make a complete guide for this....just hold on ;)

Once you're done, let me know :)
Thanks in advance

Özgür

So Long

ѕησω

What file is this step in?

Show unread may not work when moving from one forum to another
You should edit in the templates and replace the link to "action=unread" to "action=unread;all;start=0". What this does is show all unread posts by that user.
"The Book of Arantor, 17:3-5
  And I said unto him, thy database query shalt always be sent by the messenger of $smcFunc
  And $smcFunc shall protect you against injections and evil
  And so it came to pass that mysql_query was declared deprecated and even though he says he is not dead yet, the time was soon to come to pass when mysql_query shall be gone and no more."

_Anthony_

Quote from: Daydreamer on July 05, 2009, 08:40:23 PM
How can share smileys ?
If I'm not mistaken you would probably have to have the images on both forums.

Arantor

No good deed goes unpunished
All helpful urges should be circumvented

Advertisement: