| @@ 1909-1917 (lines=9) @@ | ||
| 1906 | ||
| 1907 | // Ignore if we didn't find any course connection record in the last |
|
| 1908 | // hour. In this case it wouldn't be right to add a "fake" time record. |
|
| 1909 | if (Database::num_rows($result) > 0) { |
|
| 1910 | // Found the latest connection |
|
| 1911 | $row = Database::fetch_row($result); |
|
| 1912 | $courseAccessId = $row[0]; |
|
| 1913 | $sql = "DELETE FROM $courseTrackingTable WHERE course_access_id = $courseAccessId"; |
|
| 1914 | $result = Database::query($sql); |
|
| 1915 | ||
| 1916 | return $result; |
|
| 1917 | } |
|
| 1918 | ||
| 1919 | return false; |
|
| 1920 | } |
|
| @@ 5131-5139 (lines=9) @@ | ||
| 5128 | ) as t1 |
|
| 5129 | "; |
|
| 5130 | ||
| 5131 | if ($getCount) { |
|
| 5132 | $result = Database::query($sql); |
|
| 5133 | $count = 0; |
|
| 5134 | if (Database::num_rows($result)) { |
|
| 5135 | $rows = Database::fetch_array($result); |
|
| 5136 | $count = $rows['count']; |
|
| 5137 | } |
|
| 5138 | return $count; |
|
| 5139 | } |
|
| 5140 | ||
| 5141 | if (!empty($column) && !empty($direction)) { |
|
| 5142 | $column = str_replace('u.', '', $column); |
|