show_errors(); $google_values = get_option('kd_author_advertising'); $base_prefix = $wpdb->base_prefix; $table_name = $base_prefix . "author_advertising"; if(isset($_POST['update_kd_googleauthor'])) { $user_advertising = $wpdb->escape($_POST['user_google']); $user_advertising = ltrim($user_advertising); $user_advertising = rtrim($user_advertising); $user_custom1 = $wpdb->escape($_POST['custom1']); $user_custom1 = ltrim($user_custom1); $user_custom1 = rtrim($user_custom1); $user_custom2 = $wpdb->escape($_POST['custom2']); $user_custom2 = ltrim($user_custom2); $user_custom2 = rtrim($user_custom2); $user_custom3 = $wpdb->escape($_POST['custom3']); $user_custom3 = ltrim($user_custom3); $user_custom3 = rtrim($user_custom3); $user_custom4 = $wpdb->escape($_POST['custom4']); $user_custom4 = ltrim($user_custom4); $user_custom4 = rtrim($user_custom4); $user_custom5 = $wpdb->escape($_POST['custom5']); $user_custom5 = ltrim($user_custom5); $user_custom5 = rtrim($user_custom5); $user_custom6 = $wpdb->escape($_POST['custom6']); $user_custom6 = ltrim($user_custom6); $user_custom6 = rtrim($user_custom6); $google_id = $wpdb->get_var("SELECT author_advertising FROM $table_name WHERE author_id=$user_ID"); if(!$google_id) { $user_exists = $wpdb->get_var("SELECT author_id FROM $table_name WHERE author_id=$user_ID"); if(!$user_exists){ $wpdb->query("INSERT INTO $table_name (author_id, author_advertising, author_custom1, author_custom2, author_custom3, author_custom4, author_custom5, author_custom6) VALUES ('$user_ID', '$user_advertising', '$user_custom1', '$user_custom2', '$user_custom3', '$user_custom4', '$user_custom5', '$user_custom6')"); }} $wpdb->query("UPDATE $table_name SET author_advertising='$user_advertising', author_custom1='$user_custom1', author_custom2='$user_custom2', author_custom3='$user_custom3', author_custom4='$user_custom4', author_custom5='$user_custom5', author_custom6='$user_custom6' WHERE author_id='$user_ID'"); } $user_details = $wpdb->get_row("SELECT * FROM $table_name WHERE author_id = '$user_ID'"); $google_id = $user_details->author_advertising; $user_custom1 = $user_details->author_custom1; $user_custom2 = $user_details->author_custom2; $user_custom3 = $user_details->author_custom3; $user_custom4 = $user_details->author_custom4; $user_custom5 = $user_details->author_custom5; $user_custom6 = $user_details->author_custom6; ?>
Per inserire e modificare i tuoi codici Adsense clicca qui!
"; } add_action("edit_user_profile", "kd_authoredit_profile", 2, 1); ?>