@@ 2864-2875 (lines=12) @@ | ||
2861 | $sessionIsCoach = Database::store_result($result); |
|
2862 | } |
|
2863 | ||
2864 | if (!empty($session_id)) { |
|
2865 | $sql = "SELECT DISTINCT id, name, access_start_date, access_end_date |
|
2866 | FROM $session_table |
|
2867 | WHERE session.id_coach = '".$userId."' AND id = '$session_id' |
|
2868 | ORDER BY access_start_date, access_end_date, name"; |
|
2869 | $result = Database::query($sql); |
|
2870 | if (!empty($sessionIsCoach)) { |
|
2871 | $sessionIsCoach = array_merge($sessionIsCoach , Database::store_result($result)); |
|
2872 | } else { |
|
2873 | $sessionIsCoach = Database::store_result($result); |
|
2874 | } |
|
2875 | } |
|
2876 | ||
2877 | return (count($sessionIsCoach) > 0); |
|
2878 | } |
@@ 1362-1376 (lines=15) @@ | ||
1359 | } |
|
1360 | ||
1361 | $path = Database::escape_string($path); |
|
1362 | if (!empty($courseId) && !empty($path)) { |
|
1363 | $sql = "SELECT id FROM $table |
|
1364 | WHERE |
|
1365 | c_id = $courseId AND |
|
1366 | path LIKE BINARY '$path' AND |
|
1367 | session_id = $sessionId |
|
1368 | LIMIT 1"; |
|
1369 | ||
1370 | $result = Database::query($sql); |
|
1371 | if (Database::num_rows($result)) { |
|
1372 | $row = Database::fetch_array($result); |
|
1373 | ||
1374 | return intval($row['id']); |
|
1375 | } |
|
1376 | } |
|
1377 | ||
1378 | return false; |
|
1379 | } |