Osclass Support Forums

Osclass theme support => Veronika Osclass Responsive Theme => Topic started by: mixradu on January 29, 2017, 11:22:50 PM

Title: Ajax DELETED listing
Post by: mixradu on January 29, 2017, 11:22:50 PM

Hello, ajax in listing recomendation still show a "deteled" listing

Title: Re: Ajax DELETED listing
Post by: MB Themes on January 30, 2017, 08:22:41 AM

@mixradu
You need to be more specific, not sure what or where is problem from your description.

Title: Re: Ajax DELETED listing
Post by: mixradu on January 30, 2017, 02:45:03 PM

Quote from: frosticek on January 30, 2017, 08:22:41 AM

@mixradu
You need to be more specific, not sure what or where is problem from your description.

Enter in lannonce then search for "financement pour" and click the first recomendation you will be redirected to an 404 page.

Title: Re: Ajax DELETED listing
Post by: MB Themes on January 30, 2017, 03:02:25 PM

@mixradu
Oh I thought ajax is removing something :)
in contact.php find:

Code: [Select]

        WHERE d.fk_c_locale_code = '" . osc_current_user_locale() . "' AND (s_title LIKE '%" . $pattern . "%' OR s_description LIKE '%" . $pattern . "%')
replace with:

Code: [Select]

WHERE d.fk_c_locale_code = '" . osc_current_user_locale() . "' AND (s_title LIKE '%" . $pattern . "%' OR s_description LIKE '%" . $pattern . "%') AND b_active = 1 AND b_enabled = 1 AND b_spam = 0

Title: Re: Ajax DELETED listing
Post by: mixradu on January 30, 2017, 03:09:41 PM

Quote from: frosticek on January 30, 2017, 03:02:25 PM

@mixradu
Oh I thought ajax is removing something :)
in contact.php find:

Code: [Select]

        WHERE d.fk_c_locale_code = '" . osc_current_user_locale() . "' AND (s_title LIKE '%" . $pattern . "%' OR s_description LIKE '%" . $pattern . "%')
replace with:

Code: [Select]

WHERE d.fk_c_locale_code = '" . osc_current_user_locale() . "' AND (s_title LIKE '%" . $pattern . "%' OR s_description LIKE '%" . $pattern . "%') AND b_active = 1 AND b_enabled = 1 AND b_spam = 0

Thanks, fast, short and best awnser like always :)