dozent_get_discussion_by_id( $discussion_ID )


Parameters

$discussion_ID

(Required)


Return

(array|object|void|null) Get any discussion by ID, either any main question or it's could be a discussion reply.


Source

File: includes/core-functions.php

2332
2333
2334
2335
2336
2337
2338
2339
2340
2341
2342
2343
2344
2345
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
2358
2359
2360
2361
2362
2363
2364
function dozent_get_discussion_by_id($discussion_ID)
{
    global $wpdb;
 
    $questions = $wpdb->get_row("SELECT
    comments.comment_ID,
    comments.comment_post_ID,
    comments.comment_author,
    comments.comment_date,
    comments.comment_date_gmt,
    comments.comment_content,
    comments.comment_approved as comment_status,
    comments.comment_parent,
    comments.user_id,
    course_id_meta.meta_value as course_ID,
    course.post_title as course_title,
    lecture.ID as lecture_ID,
    lecture.post_title as lecture_title,
    comment_user.display_name as user_display_name,
    comment_user.user_nicename as user_nicename,
    (SELECT COUNT(replies.comment_ID) FROM {$wpdb->comments} replies WHERE replies.comment_parent = comments.comment_ID ) reply_count
     
    FROM {$wpdb->comments} comments
    LEFT JOIN {$wpdb->postmeta} course_id_meta ON comments.comment_post_ID = course_id_meta.post_id AND course_id_meta.meta_key = '_dozent_course_id'
    LEFT JOIN {$wpdb->posts} course ON course_id_meta.meta_value = course.ID
    LEFT JOIN {$wpdb->posts} lecture ON comments.comment_post_ID = lecture.ID
    LEFT JOIN {$wpdb->users} comment_user ON user_id = comment_user.ID
     
    WHERE 1 = 1 AND comments.comment_ID = {$discussion_ID} AND comments.comment_type = 'dozent_discussion'
    ORDER BY comments.comment_date ;");
 
    return $questions;
}