Phunky

arrr should have known redalt.com would have done it 🙂

thank you

Ive bitten the bullet and just used $wpdb->query() and made it insert into the DB myself.

But i’ve come across a very strange issuse, below is the code im using to update the details of a user.


$wpdb->query("UPDATE wp_users SET user_url='$_GET[website]' WHERE ID='$_GET[id]'");
$wpdb->query("UPDATE wp_users SET user_email='$_GET[email]' WHERE ID='$_GET[id]'");
# update/create usermeta
$username = explode(' ',$_REQUEST[username]);
update_usermeta($_REQUEST[id],'first_name',$username[0]);
update_usermeta($_REQUEST[id],'last_name',$username[1]); update_usermeta($_REQUEST[id],'user_telephone',$_REQUEST[telephone]);
update_usermeta($_REQUEST[id],'user_company',$_REQUEST[company]); update_usermeta($_REQUEST[id],'user_addr1',$_REQUEST[address1]); update_usermeta($_REQUEST[id],'user_addr2',$_REQUEST[address2]); update_usermeta($_REQUEST[id],'user_city',$_REQUEST[city]); update_usermeta($_REQUEST[id],'user_postcode',$_REQUEST[postcode]); update_usermeta($_REQUEST[id],'user_country',$_REQUEST[country]);


Now the user_email and user_url at the top (one’s using $wpdb->query ) will only update if one of the usermeta feilds have been altered. If you just attempt to update the email or url on there own it just ignores it and refuses to update even tho it passes the query!

This really has got me confused!

Sorted it, i would seem that my userProfile plugin i was writing was creating a user_email feild within wp_userMeta (via update_usermeta)instead of updating the user_email feild in wp_user.

It would seem that ive the same feild exists WP does not like it and instead pulls back nothing :S

Hmmmm it would seem using the above code effects functions such as get_the_author();

This is bad :/ hmmm looks like ill just pull back the data with a custom $wpdb->query instead, will be a lot simpler as its only a list anyways!