Those are stored in the usermeta table. For each user_id there are three meta_key values: aim yim jabber. You can retrieve those values with something like get_usermeta(1,’aim’) where 1 is the user_id.
It is in usermeta. AIM is with a meta_key of ‘aim’
oops, joe got there first…
I must be blind – I *do not* see this at all.
I’m in my database, looking at the usermeta table. I click “Browse” and I see places for my nickname, first name, last name, nickname, capabilities, rich editing, description, user level and autosave – but nothing for the Aim/Jabber stuff. I know it *should* be there, because I have stuff entered for it, and it’s definitely showing up, but I just do not see it.
(and I’m not looking to pull out from it – yet – I’m looking to insert into it 🙂 )
How bizarre – I’m looking at my other installations (I’ve got WP 2.0, 2.1, 2.2, 2.3 and WPMU), and the only version I see these meta values in is 2.0. 2.1+ and WPMU doesn’t seem to be showing it. That’s just odd…I wonder why?
EDIT: that’s on my localhost server – I’m checking my live, hosted server – and the same thing is happening there, too – I see it for 2.0, but not for my WPMU install or anything 2.1+
EDIT AGAIN: Even more bizarre – when I search the database for it, it find it right where you all say. For example, one of them I found was un the usermeta table, “umeta_ID” of 266. However when I go back and browser the actual table, it only goes up to umeta_ID of 262. 263-266 are not there.
This is just weird.
Ahhh…I’m an idiot! Now I see it.
Basically, what happened was, at some point, I had deleted a user from the database, which left a gap. When I added new info, MySQL does what it does and stuck it in the first available spot – in the old void left by the deletion. I found it in the middle of my table – rather than at the end, where I was expecting it.
Thanks guys 🙂
