[wp-hackers] Sharing Users/authentication

[Jamie Holly]

The prefixes are used in MU. For example user X might have different
capabilities on one blog than the other. The capabilities are stored as
{tableprefix}_{blogid}_capabilities, so it would be something like
wp_1_capabilities. 



Jamie Holly
http://www.intoxination.net
1.513.252.2919 | Skype:intoxination


>-----Original Message-----
>From: wp-hackers-bounces at lists.automattic.com [mailto:wp-hackers-
>bounces at lists.automattic.com] On Behalf Of Stephen Rider
>Sent: Saturday, August 25, 2007 12:27 PM
>To: wp-hackers at lists.automattic.com
>Subject: Re: [wp-hackers] Sharing Users/authentication
>
>CORRECTION:
>
>They aren't field names:  They are data in the "meta_key" field.
>Nonetheless my question stands:
>
>IS there any legitimate use for the table-prefix to be repeated
>here?  Would WordPress lose anything by removing the table prefixes
>from these two fields?
>
>Stephen
>
>On Aug 25, 2007, at 11:20 AM, Stephen Rider wrote:
>
>> The problem appears to be the "wp_capabilities" and "wp_user_level"
>> fields in the wp_usermeta table.  WordPress needs these field names
>> to match the active table prefix.
>>
>> So, when I use the define()s to point to the other blog's user and
>> usermeta tables, it sees the wrong prefix in this field and hits an
>> error.
>>
>>
>> ALSO:  Should it be considered a bug that the field names have the
>> prefix hard-coded into them?  This seems like unnecessary
>> duplication of information to me, which is a database design no-no.
>>
>_______________________________________________
>wp-hackers mailing list
>wp-hackers at lists.automattic.com
>http://lists.automattic.com/mailman/listinfo/wp-hackers