SQL error with last version

Hi,
With the last version, the query executed in the
——————————————————————
public function get_user_course_item( LP_User_Items_Filter $filter, bool $force_cache = false ) {
——————————————————————-
was wrong.

I think the bold part was correct now:

if ( $filter->parent_id ) {
$WHERE .= $this->wpdb->prepare(‘ AND parent_id = %d’, $filter->parent_id );
}

if ( $filter->ref_id ) {
$WHERE .= $this->wpdb->prepare(‘ AND ref_id = %d’, $filter->ref_id );
$WHERE .= $this->wpdb->prepare(‘ AND item_type = %s’, LP_COURSE_CPT );
}

$query = $this->wpdb->prepare(
“SELECT user_item_id, user_id, item_id, item_type, status, graduation, ref_id, ref_type, start_time, end_time, parent_id
FROM $this->tb_lp_user_items
$WHERE AND item_id = %d AND user_id = %d ORDER BY user_item_id DESC
LIMIT 1
“,
$filter->item_id,
$filter->user_id
);

• This topic was modified 3 years, 2 months ago by yenyen87.