loaddata.php patch

[yellperil]

I had an issue with loaddata.php

patch loaddata.php < patch.txt

save between SNIP (but do not include SNIP as patch.txt, Or find the - lines and replace them with + lines.
===> SNIP <===
--- loaddata.php.original.broken 2017-08-02 00:56:32.000000000 +0930
+++ loaddata.php.fixed 2017-08-08 15:47:37.000000000 +0930
@@ -75,10 +75,10 @@

$query = 'SELECT *, date_format(lastvisit, "%d/%m/%Y") as lastvisit FROM '.$mydb_tablename ;
$queryCount = 'SELECT count(id) as nb FROM '.$mydb_tablename;

-$totalUnfiltered =$mysqli->query($queryCount)->fetch_row()[0];
-$total = $totalUnfiltered;

+//m3f $totalUnfiltered =$mysqli->query($queryCount)->fetch_row()[0];
+//m3f $total = $totalUnfiltered;
+$totalUnfiltered =$mysqli->query($queryCount)->fetch_row();
+$total = $totalUnfiltered[0];

/* SERVER SIDE /
/ If you have set serverSide : true in your Javascript code, $_GET contains 3 additionnal parameters : page, filter, sort
@@ -98,7 +98,9 @@
$filter = $_GET['filter'];
$query .= ' WHERE name like "%'.$filter.'%" OR firstname like "%'.$filter.'%"';
$queryCount .= ' WHERE name like "%'.$filter.'%" OR firstname like "%'.$filter.'%"';

• $total =$mysqli->query($queryCount)->fetch_row()[0];
  +//m3f $total =$mysqli->query($queryCount)->fetch_row()[0];

• $totalUnfiltered =$mysqli->query($queryCount)->fetch_row();
• $total = $totalUnfiltered[0];
  }

if ( isset($_GET['sort']) && $_GET['sort'] != "" )
===> SNIP <===