To the esteemed Osclass Support Team,

Greetings,

I would like to bring to your attention an issue on the Osclass website. I am facing a problem when using the site in Arabic. The error appears in the pagination, where it does not switch between pages (from 1 to 2) correctly.

This error occurs only when the site is switched to the Arabic language, which affects the user experience and limits the ability to browse ads or content on the site.

I kindly request you to review this issue and resolve it as soon as possible.

Thank you for your cooperation.

https://epsilon.mb-themes.com/%d9%85%d8%b1%d9%83%d8%a8%d8%a7%d8%aa

https://dev7.abprofitrade.eu/ar/%d9%84%d9%84%d8%a8%d9%8a%d8%b9/2
« Last Edit: June 12, 2024, 03:12:40 PM by MB Themes »

Marked as best answer by هشام سدير on June 14, 2024, 06:09:53 PM
*

MB Themes

Re: Error in osclass - real_escape_string / mysqli_real_escape_string
« Reply #1 on: June 12, 2024, 03:11:53 PM »
It's quite interesting issue that is on Osclass probably for very long time.
Problem is that we use urlencode to pass category slug to mysql, that is wrong (chars are escaped).

Go to oc-includes/osclass/model/Category.php
around line 524, find:
Code: [Select]
$slug = urlencode($slug);
Replace it with:
Code: [Select]
$slug = $this->dao->connId->real_escape_string($slug);
$slug = urlencode(urldecode($slug));

« Last Edit: June 12, 2024, 03:24:29 PM by MB Themes »
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

Thank you, the problem has been solved

*

MB Themes

Thanks for feedback  :)
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots