[wp-hackers] SMF Integrator (A WordPress 2.2.2 Plugin)

[Stephane Daury]

Thanks for the details Curt.

I'm more of a PostgreSQL guy, and I was surprised to see that views  
only made it into MySQL at version 5.
The MySQL stuff I do not being as advanced as my PostgreSQL stuff, I  
had never really noticed they weren't there. :)

Stephane







On Aug 27, 2007, at 08:33, Curt Woodard wrote:

>> Quick questions, by curiosity:
>> - are you using updatable views?
>
> No, the view isn't updatable. This is because, in the view, I'm
> changing the table header to match that of WordPress so that it's a
> mirror of the users table. MySQL doesn't allow updatable views that do
> this, for obvious reasons. One of those reasons being: SMF and WP
> store dates differently. SMF stores them as unix timestamps while WP
> stores them as datetime. So I had to use a MySQL function to
> translate.
>
> Now, I *could* make it updatable and find a way to change the result
> of database queries into a form that WP uses, but that would require
> hacking the core files, which we don't really want to do. If WP were
> written so that you could override ANY function, then this wouldn't be
> an issue, but that would require hacking WP as well at this point...
> :)
>
>> - are they 1 to 1 views or linking to multiple joined tables?
>>
>> Stephane
>
> The view is 1-to-1 without joining to other tables. This is because
> SMF has all of it's user information in the members table, unlike
> WordPress's users and usermeta tables.
>
> I went ahead and kept the usermeta table because it stores stuff that
> is WordPress specific from plug-ins and the like.
>
> Which reminds me, I need to check compatibility with a few of the
> plugins that I use, like the LJ cross-poster. It might be a good idea
> to somehow hack that plugin so that it's user-specific and can be
> turned off on a user-by-user basis... No need to have JimmyBob posting
> to my Live Journal, eh? Though, I could change that to a
> community-based LJ and have people post that way... I'll have to see.
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers