MyBB Community Forums

Full Version: synchronize users
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello I have a very large forum and the wiki section keeps growing and the forum is very long. I thought the forum to share and provide a forum to share in my room only for the wiki. is there a way to synchronize users new members and one login?
What wiki software are you using? I think there is a mediawiki bridge.
(2010-10-09, 05:30 PM)Mark.M Wrote: [ -> ]What wiki software are you using? I think there is a mediawiki bridge.


any software, it's a category forum. I want create another forum in subdomain or in a path with same user but i dont know how to syncro new user.
I think this is what you're looking for - http://community.mybb.com/thread-15007.html
I know it but i dont like because it's more work to trasfer topic in page...
it s possibile syncro user with another board?
(2010-10-10, 09:39 AM)eleweb Wrote: [ -> ]...it s possible syncro user with another board?

Possible, "Yes", easy "No, but gets easier over time"

#
Sync your users with another MyBB board

1) Download the latest version of SQLyog Job Agent (SJA) for Linux
http://code.google.com/p/sqlyog/downloads/list

2) Look at sample file ' sja-sample2.php '

3) Edit out
<tunnelinfo type="http">
<url>http://www.yourdomain.com/SQLyogTunnel.php</url>
</tunnelinfo>
...unless you need to use a http tunnel.

4) Modify the sja-sample2.php for your databases, host, etc.
Also modify this part
<tables all="no">
<table>
<name>`columns_priv`</name>
<columns all="yes" />
</table>
<table>
<name>`db`</name>
<columns all="no">
<column>`Host`</column>
<column>`Db`</column>
<column>`User`</column>
</columns>
</table>
<table>
<name>`host`</name>
<columns all="yes" />
<sqlwhere>host like '%%'</sqlwhere></table>
</tables>

Change to (for example)

<tables all="no">
<table>
<name>`mybb_users`</name>
<columns all='no'>
<column>language</column>
<column>longlastip</column>
<column>longregip</column>
<column>lastip</column>
<column>regip</column>
<column>referrer</column>
<column>awayreason</column>
<column>returndate</column>
<column>awaydate</column>
<column>away</column>
<column>ignorelist</column>
<column>buddylist</column>
<column>dst</column>
<column>timezone</column>
<column>timeformat</column>
<column>dateformat</column>
<column>showavatars</column>
<column>showsigs</column>
<column>remember</column>
<column>hideemail</column>
<column>birthdayprivacy</column>
<column>birthday</column>
<column>msn</column>
<column>yahoo</column>
<column>aim</column>
<column>icq</column>
<column>website</column>
<column>regdate</column>
<column>usertitle</column>
<column>displaygroup</column>
<column>additionalgroups</column>
<column>usergroup</column>
<column>avatardimensions</column>
<column>avatar</column>
<column>email</column>
<column>salt</column>
<column>password</column>
<column>username</column>
<column>uid</column>
</columns>
</table>
</tables>
**

** Avoid syncing some columns like 'postnum', 'lastvisit', 'lastpost', etc.

EDIT:
<column>avatardimensions</column>
<column>avatar</column>
^^^
Avatars:
A) Edit out that (small) section to avoid syncing avatars,
...or...
B) Use rsync to sync the ( ./upload/avatars/) files, while this tut helps sync the database part.


Cron job

10,30,50 * * * * "/var/scripts/sja/sja" "/var/scripts/sja/mydomain.com.xml" >/dev/null 2>&1

Now you can Sync your users with another MyBB board Smile

thank you so much! Big Grin
(2010-10-16, 01:01 PM)eleweb Wrote: [ -> ]thank you so much! Big Grin

You are welcome, enjoy. Smile