| @@ 1949-1957 (lines=9) @@ | ||
| 1946 | ||
| 1947 | // Ignore if we didn't find any course connection record in the last |
|
| 1948 | // hour. In this case it wouldn't be right to add a "fake" time record. |
|
| 1949 | if (Database::num_rows($result) > 0) { |
|
| 1950 | // Found the latest connection |
|
| 1951 | $row = Database::fetch_row($result); |
|
| 1952 | $courseAccessId = $row[0]; |
|
| 1953 | $sql = "DELETE FROM $courseTrackingTable WHERE course_access_id = $courseAccessId"; |
|
| 1954 | $result = Database::query($sql); |
|
| 1955 | ||
| 1956 | return $result; |
|
| 1957 | } |
|
| 1958 | ||
| 1959 | return false; |
|
| 1960 | } |
|
| @@ 5500-5508 (lines=9) @@ | ||
| 5497 | ) as t1 |
|
| 5498 | "; |
|
| 5499 | ||
| 5500 | if ($getCount) { |
|
| 5501 | $result = Database::query($sql); |
|
| 5502 | $count = 0; |
|
| 5503 | if (Database::num_rows($result)) { |
|
| 5504 | $rows = Database::fetch_array($result); |
|
| 5505 | $count = $rows['count']; |
|
| 5506 | } |
|
| 5507 | return $count; |
|
| 5508 | } |
|
| 5509 | ||
| 5510 | if (!empty($column) && !empty($direction)) { |
|
| 5511 | $column = str_replace('u.', '', $column); |
|