Home arrow Forum User and CB Avatar sync
  Welcome, Guest. Please login or register.
Did you miss your activation email?
October 13, 2008, 07:43:37 PM
Home New Posts Search Calendar


Login with username, password and session length
+  Joomla Forum
|-+  Joomla Hacks
| |-+  Joomla-SMF Forum Support
| | |-+  Joomla-SMF 2.0.x (Moderators: -Wolverine, kai920)
| | | |-+  User and CB Avatar sync
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] 2 Go Down Print
Author Topic: User and CB Avatar sync  (Read 3271 times)
Tom
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 23


View Profile
User and CB Avatar sync
« on: September 08, 2006, 02:58:34 AM »

ahh, I didn't read well enough.  My bridge gives you the option to sync usernames or realnames, both for the initial installation sync and for the synchronizations that occur when new users register.

Again thanks for the replies on this...I'm a little lost now (not hard! Wink)

I've installed JSMF 2.0 and its awesome, installed a breeze!

However, the Real Names are still showing.  I've used the sync option and it says its all synced fine (if I look in SMF backend it actually lists all of my members usernames and then their real names next to them)...So it all looks good.

However, Real Names are being used on the posts rather than the Usernames.  Is this something the sync is meant to convert (keeping in mind I used the old SMF converter script to pull all the threads over from Joomlaboard into SMF)...Or do I need a custom solution to get SMF to use the Usernames?

I can see the Usernames there so SMF sees them its just not using them...I thought there might have been an option with SMF itself to use the Usernames rather than Real Name but couldnt see one.

Sorry to be a pain with this!
Logged
Tom
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 23


View Profile
User and CB Avatar sync
« Reply #1 on: September 08, 2006, 07:40:50 PM »

The Who's Online module is working fine and displaying usernames.

Its odd, even newly registered members "real names" are being used on new posts, rather than Usernames.
Logged
Tom
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 23


View Profile
User and CB Avatar sync
« Reply #2 on: September 11, 2006, 05:32:46 AM »

Anyone?  Huh
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +375/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
User and CB Avatar sync
« Reply #3 on: September 11, 2006, 08:30:48 AM »

understand that the real name or username is set when you synchronize.  So if a member is already in both db tables then performing a synchronization will not work for that member.

The question is if a new user registered shows username or real name.
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
Tom
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 23


View Profile
User and CB Avatar sync
« Reply #4 on: September 12, 2006, 08:01:12 AM »

Thanks again for the reply Wolverine.

I didn't actually get the "sync username" and "sync real name" options initially...I got the "VERIFY" option which when clicked didn't produce any errors. 

I reinstalled now and actually see the correct options.

I've clicked "sync usernames" and it produces the following error:

Joomla/Mambo[0] / SMF[673] inserted Failed :

Is this a problem?  673 being the number of members I have on this particular Joomla install.  However, the users seem to be ported over the forum fine as I can see them all there.

EDIT:  Ive tried the converter script again...Seems I am getting closer to fixing this.  One thing I am hoping you can shed some light on...

After running the script it works as it should bringing everything over, but it seems to knock out the avatar setup.

The avatar/pic the user chose in CB was displayed on the forum, but now the avatar in the forum is broke, its looking at:

http://www.************.com/smf/avatars/62.gif

Instead of at CB.

Unsure why its removed whatever was there that was connecting the avatar with CB.  When clicking on View Profile in SMF though, it does go to the users CB profile.
« Last Edit: September 12, 2006, 12:10:46 PM by Tom » Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +375/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
User and CB Avatar sync
« Reply #5 on: September 13, 2006, 08:06:03 AM »

welllllllllll..... thats because I haven't added avatar sync when you click sync unames or sync realnames.  Tongue  I simply ran out of time and wanted to get JSMF 2.0 Beta out before I started job searching(got laid off).  You are running 2.0 right(even though this is in the 1.1.x forum)?  That will be the first thing I fix in the next version.  I will also probably make the avatar sync functionality separate as well for users like you who have already sync'd their avatars.
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
Tom
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 23


View Profile
Re: User and CB Avatar sync
« Reply #6 on: September 13, 2006, 01:35:03 PM »

What I meant was, when installing the bridge and not using the converter, the url's of avatars were automatically pointing toward CB's avatar folder...Even if the image was not there/broke image.  After running the converter it was pointing at SMF's avatar directory.

It seems to work fine if I change the URL in the SMF admin, point it at the CB Pic/Avatar folder, get the user to reupload the avatar and bingo...Working Smiley

I've got a freelance php/mysql coder to take a look at the Real Name issue, he seems to think he can write a little script that will convert the Real Name to Username.

Sorry if it seemed I was badgering you...I didn't mean to come across like that and do appreciate your help Smiley 

I'll be making a donation for the bridge shortly...Least I can do for all your help really Smiley
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +375/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: User and CB Avatar sync
« Reply #7 on: September 13, 2006, 02:28:45 PM »

I didnt' feel you were badgering... simply helping me make the bridge better.  Wink  The sql script should be pretty straight forward, update smf_members set realName = (select memberName from smf_members sub where smf_members.memberName = sub.memberName)

Any donations are as always, greatly appreciated!  Grin
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
Tom
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 23


View Profile
Re: User and CB Avatar sync
« Reply #8 on: September 13, 2006, 05:37:52 PM »

Smiley Thank you and glad to hear.

And wow thank you for that query tip (you can see I really am not well versed in mysql!)

I tried to run that and it keep coming back with

#1093 - You can't specify target table 'smf_members' for update in FROM clause

Sooo...I took a stab and just ran:

UPDATE smf_members SET realName=memberName

This, amazingly worked right off and all the Real Names are corrected!

Can you just clarify, was running my query ok?  its alot more simple than your own, so unsure if it would have broken something!

T.
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +375/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: User and CB Avatar sync
« Reply #9 on: September 13, 2006, 08:08:50 PM »

hmmmm, ya, it seems I was trying the hard way.  If you see it working then chances are it is dead on.  Good to know.
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
Tom
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 23


View Profile
Re: User and CB Avatar sync
« Reply #10 on: September 14, 2006, 11:04:47 AM »

Cool Smiley

Everything working great now.  One slight problem that has cropped up, since signatures don't work (if updated in CB) yet and a user tries to update their signature in CB...It reverts their username back to Real Name.

I've not been able to establish whether updating other aspects of their profile will result in a revert of the username to real name...I'll test later.

I guess possibly a temp fix will be to have the query run every 30 minutes or something.

T.
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +375/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: User and CB Avatar sync
« Reply #11 on: September 14, 2006, 11:38:56 AM »

no, the fix would be to either adjust the user update from CB so that that doesn't happen or run the same username/realname query on the joomla user table as well.
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
Tom
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 23


View Profile
Re: User and CB Avatar sync
« Reply #12 on: September 15, 2006, 11:33:49 PM »

When I run the same query (with slight alternation) on the Joomla Users table, it converts the real names to Usernames in the Joomla members table...That I dont mind too much...However when it does this is breaks the login.  Users are unable to login.

The other solution you said...I am unsure how to stop CB directly from altering this.  I posted a thread on their forum but no reply yet.
« Last Edit: September 15, 2006, 11:37:53 PM by Tom » Logged
Tom
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 23


View Profile
Re: User and CB Avatar sync
« Reply #13 on: September 22, 2006, 08:07:43 PM »

After playing around with it abit more it still seems to break the login and users are unable to login at all when converting the Real Name field in Joomla to usernames.

Would it cause any issue if I was to set up the query to run every *insert number of minutes* to fix this issue?  Is it likely to break anything in the bridge?

Thanks,

T.
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +375/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: User and CB Avatar sync
« Reply #14 on: September 25, 2006, 10:37:03 AM »

So you want to disable Real Names altogether in Joomla?  You could probably write a CB plugin to register on the event onBeforeRegistration and then change the realname to the username.  Don't write something that runs every X minutes, that is a bad move. 

The CB forums should be good help in writing this plugin.
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
Pages: [1] 2 Go Up Print 
« previous next »
Jump to:  



Login with username, password and session length

Powered by MySQL Powered by PHP Joomla Forum | Powered by SMF 1.1 RC1.
© 2001-2005, Lewis Media. All Rights Reserved.
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!

Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved.
Terms of Use
Joomla Hacks



Joomla Hacks
German Lang French Lang Italian Lang Spanish Lang Japanese Lang Chinese Lang
Search Contact About Advertise Blogs Topsites Submit News Register Login