CSGORankMeWeb icon indicating copy to clipboard operation
CSGORankMeWeb copied to clipboard

Invalid JSON Response

Open 3GaNwO opened this issue 4 years ago • 1 comments

DataTables warning: table id=LeaderBoardTable - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

I had this working for a split second but for whatever reason I am getting this error now when I try and goto the leaderboards.

I have all the database tables which I will provide a pic of it.

database tables

I can't seem to figure out the issue.

I look into the developer tools and I also see an error about allowing right clicking and I have no idea how to fix this one either

"allow right click processing https://xyz.org/rankme/leaderboards.php"

I had to fix a couple things because my site is secure so I had to make sure the fonts being used was also on a secure page (simple fix)

I hope y'all can help I can't seem to figure out where to go next to fix the issues

3GaNwO avatar Oct 23 '21 19:10 3GaNwO

Hi sir, this is quick fix for your problem. (DataTables cant see special characters ( I Had problem with this character: • )

Go into control/leaderboard/leaderboardGrab.php

Create new function after $primaryKey; `function clean($string) { $string = preg_replace('/[^A-Za-z0-9-]/', ' ', $string); // Removes special chars.

return preg_replace('/-+/', '-', $string); // Replaces multiple hyphens with single one. }`

Then in columns, replace array( 'db' => 'name', 'dt' => 0 ), with array( 'db' => 'name', 'dt' => 0, 'formatter' => function($d, $row){ $name = clean($row['name']); return $name; } ), I'll leave you attach of this fix. leaderboardGrab.txt Just replace .txt with .php

musoviich avatar Jun 15 '22 07:06 musoviich