escape(get_query_var('paged'));
}
$total_comment = $wpdb->get_var("select count(comment_ID) from $wpdb->comments where comment_approved='1' and user_id=".$current_user->ID);
$pagess = ceil($total_comment / $perpage);
$offset = $perpage*($paged-1);
$results = $wpdb->get_results("select $wpdb->comments.comment_ID,$wpdb->comments.comment_post_ID,$wpdb->comments.comment_content,$wpdb->comments.comment_date,$wpdb->posts.post_title from $wpdb->comments left join $wpdb->posts on $wpdb->comments.comment_post_ID = $wpdb->posts.ID where $wpdb->comments.comment_approved='1' and $wpdb->comments.user_id=".$current_user->ID." order by $wpdb->comments.comment_date DESC limit $offset,$perpage");
if($results){
?>
get_var("SELECT count(ID) FROM $wpdb->posts WHERE post_author=".$current_user->ID." and post_status='publish' and post_type='post'");
$perpage = 10;
$pagess = ceil($totallists / $perpage);
if (!get_query_var('paged')) {
$paged = 1;
}else{
$paged = $wpdb->escape(get_query_var('paged'));
}
$offset = $perpage*($paged-1);
$results = $wpdb->get_results("SELECT * FROM $wpdb->posts where post_author=".$current_user->ID." and post_status='publish' and post_type='post' order by post_date DESC limit $offset,$perpage");
?>
get_var("SELECT count(ID) FROM $wpdb->posts WHERE post_author=".$current_user->ID." and post_status='publish' and post_type='qa_post'");
$perpage = 10;
$pagess = ceil($totallists / $perpage);
if (!get_query_var('paged')) {
$paged = 1;
}else{
$paged = $wpdb->escape(get_query_var('paged'));
}
$offset = $perpage*($paged-1);
$lists = $wpdb->get_results("SELECT * FROM $wpdb->posts where post_author=".$current_user->ID." and post_status='publish' and post_type='qa_post' order by post_date DESC limit $offset,$perpage");
?>
get_var("SELECT count(ID) FROM $wpdb->posts WHERE post_author=".$current_user->ID." and post_status='publish' and post_type='question'");
$perpage = 10;
$pagess = ceil($totallists / $perpage);
if (!get_query_var('paged')) {
$paged = 1;
}else{
$paged = $wpdb->escape(get_query_var('paged'));
}
$offset = $perpage*($paged-1);
$lists = $wpdb->get_results("SELECT * FROM $wpdb->posts where post_author=".$current_user->ID." and post_status='publish' and post_type='question' order by post_date DESC limit $offset,$perpage");
?>
get_var("SELECT count(ID) FROM $wpdb->posts WHERE post_author=".$current_user->ID." and post_status='publish' and post_type='answer'");
$perpage = 10;
$pagess = ceil($totallists / $perpage);
if (!get_query_var('paged')) {
$paged = 1;
}else{
$paged = $wpdb->escape(get_query_var('paged'));
}
$offset = $perpage*($paged-1);
$lists = $wpdb->get_results("SELECT * FROM $wpdb->posts where post_author=".$current_user->ID." and post_status='publish' and post_type='answer' order by post_date DESC limit $offset,$perpage");
?>
escape(get_query_var('paged'));
}
$total_collect = $wpdb->get_var("select count(ID) from ".$wpdb->prefix."collects where user_id=".$current_user->ID);
$pagess = ceil($total_collect / $perpage);
$offset = $perpage*($paged-1);
$results = $wpdb->get_results("select * from ".$wpdb->prefix."collects where user_id=".$current_user->ID." order by create_time DESC limit $offset,$perpage");
if($results){
?>
get_var("select mobile from $wpdb->users where ID=".$current_user->ID);
?>
暂无评论!
暂无记录!
暂无记录!
暂无记录!
-
ID); setup_postdata($post);?>
暂无记录!
暂无收藏!
注意事项:
- 请务必修改成你正确的邮箱地址,以便于忘记密码时用来重置密码。
- 获取验证码时,邮件发送时间有时会稍长,请您耐心等待。
comment_content;?>
文章:post_title;?>