[wp-hackers] Sharing Users/authentication

[Sabin Iacob]

Jacob Santos wrote:
> No, the defines replace the default WordPress table names, if they are 
> defined. Does not include the prefix with the constant, so the name 
> has to be the full custom table name.
>
> If you want to define the user, you can do so by another method. I 
> want to say by creating the WordPress cookie or by writing your own 
> User API function in a plugin.
>
> Can you explain more by what you mean of 'MySQL view'?


you know, like "create view my_users as select * from 
other_database.wp_users;"

to the OP: you may get around with authentication (which is a read-only 
process), but you won't be able to change user details, because mysql 
devs didn't think something like (sqlite code)

create trigger my_users_update instead of update on my_users
begin
update other_database.wp_users set user_login = new.user_login, [...] 
where id = old.id;
end

would be useful (it's scheduled for 5.2, AFAIR)