roles[0]; wpsp_topbar(); wpsp_sidebar(); wpsp_body_start(); $teacher_table=$wpdb->prefix."wpsp_teacher"; $class_table=$wpdb->prefix."wpsp_class"; $users_table=$wpdb->prefix."users"; $sid = intval(get_current_user_id()); //$tinfo = $wpdb->get_row("select teacher.*,user.user_email from $teacher_table teacher LEFT JOIN $users_table user ON user.ID=teacher.wp_usr_id where teacher.wp_usr_id='".esc_sql($sid)."'"); $tinfo = $wpdb->get_row($wpdb->prepare("SELECT teacher.*,user.user_email FROM $teacher_table teacher LEFT JOIN $users_table user ON user.ID=teacher.wp_usr_id WHERE teacher.wp_usr_id = %d",$sid)); if( !empty( $stinfo ) ) { $loc_avatar=get_user_meta($sid,'simple_local_avatar',true); $img_url= $loc_avatar ? sanitize_text_field($loc_avatar['full']) : WPSP_PLUGIN_URL.'img/default_avtar.jpg'; } $student_table = $wpdb->prefix."wpsp_student"; $class_table = $wpdb->prefix."wpsp_class"; $users_table = $wpdb->prefix."users"; if($current_user_role == 'student'){ //$stinfo = $wpdb->get_row("select * from $student_table where wp_usr_id='".esc_sql($sid)."'"); $stinfo = $wpdb->get_row($wpdb->prepare("SELECT * FROM $student_table WHERE wp_usr_id = %d",$sid)); $loc_avatar=get_user_meta($sid,'simple_local_avatar',true); $img_url= $loc_avatar ? $loc_avatar['full'] : WPSP_PLUGIN_URL.'img/default_avtar.jpg'; } if($current_user_role == 'parent'){ //$stinfo = $wpdb->get_row("select * from $student_table where parent_wp_usr_id='".esc_sql($sid)."'"); $stinfo = $wpdb->get_row($wpdb->prepare("SELECT * FROM $student_table WHERE parent_wp_usr_id = %d",$sid)); $loc_avatar=get_user_meta($sid,'simple_local_avatar',true); $img_url= $loc_avatar ? $loc_avatar['full'] : WPSP_PLUGIN_URL.'img/default_avtar.jpg'; } ?>