chamilo /
chamilo-lms
| @@ 2475-2522 (lines=48) @@ | ||
| 2472 | ||
| 2473 | //only by professors when page is hidden |
|
| 2474 | if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) { |
|
| 2475 | if ($all_vers == '1') { |
|
| 2476 | if ($search_content == '1') { |
|
| 2477 | $sql = "SELECT * FROM ".$tbl_wiki." |
|
| 2478 | WHERE |
|
| 2479 | c_id = $course_id AND |
|
| 2480 | title LIKE '%".Database::escape_string($search_term)."%' OR |
|
| 2481 | content LIKE '%".Database::escape_string($search_term)."%' AND |
|
| 2482 | ".$groupfilter.$condition_session.""; |
|
| 2483 | //search all pages and all versions |
|
| 2484 | } else { |
|
| 2485 | $sql = "SELECT * FROM ".$tbl_wiki." |
|
| 2486 | WHERE |
|
| 2487 | c_id = $course_id AND |
|
| 2488 | title LIKE '%".Database::escape_string($search_term)."%' AND |
|
| 2489 | ".$groupfilter.$condition_session.""; |
|
| 2490 | //search all pages and all versions |
|
| 2491 | } |
|
| 2492 | } else { |
|
| 2493 | if ($search_content == '1') { |
|
| 2494 | $sql = "SELECT * FROM ".$tbl_wiki." s1 |
|
| 2495 | WHERE |
|
| 2496 | s1.c_id = $course_id AND |
|
| 2497 | title LIKE '%".Database::escape_string($search_term)."%' OR |
|
| 2498 | content LIKE '%".Database::escape_string($search_term)."%' AND |
|
| 2499 | id=( |
|
| 2500 | SELECT MAX(s2.id) |
|
| 2501 | FROM ".$tbl_wiki." s2 |
|
| 2502 | WHERE |
|
| 2503 | s2.c_id = $course_id AND |
|
| 2504 | s1.reflink = s2.reflink AND |
|
| 2505 | ".$groupfilter.$condition_session.")"; |
|
| 2506 | // warning don't use group by reflink because don't return the last version |
|
| 2507 | } else { |
|
| 2508 | $sql = "SELECT * FROM ".$tbl_wiki." s1 |
|
| 2509 | WHERE |
|
| 2510 | s1.c_id = $course_id AND |
|
| 2511 | title LIKE '%".Database::escape_string($search_term)."%' AND |
|
| 2512 | id = ( |
|
| 2513 | SELECT MAX(s2.id) |
|
| 2514 | FROM ".$tbl_wiki." s2 |
|
| 2515 | WHERE |
|
| 2516 | s2.c_id = $course_id AND |
|
| 2517 | s1.reflink = s2.reflink AND |
|
| 2518 | ".$groupfilter.$condition_session.")"; |
|
| 2519 | // warning don't use group by reflink because don't return the last version |
|
| 2520 | } |
|
| 2521 | } |
|
| 2522 | } else { |
|
| 2523 | if ($all_vers == '1') { |
|
| 2524 | if ($search_content == '1') { |
|
| 2525 | $sql = "SELECT * FROM ".$tbl_wiki." |
|
| @@ 2522-2571 (lines=50) @@ | ||
| 2519 | // warning don't use group by reflink because don't return the last version |
|
| 2520 | } |
|
| 2521 | } |
|
| 2522 | } else { |
|
| 2523 | if ($all_vers == '1') { |
|
| 2524 | if ($search_content == '1') { |
|
| 2525 | $sql = "SELECT * FROM ".$tbl_wiki." |
|
| 2526 | WHERE |
|
| 2527 | c_id = $course_id AND |
|
| 2528 | visibility=1 AND |
|
| 2529 | title LIKE '%".Database::escape_string($search_term)."%' OR |
|
| 2530 | content LIKE '%".Database::escape_string($search_term)."%' AND |
|
| 2531 | ".$groupfilter.$condition_session.""; |
|
| 2532 | //search all pages and all versions |
|
| 2533 | } else { |
|
| 2534 | $sql = "SELECT * FROM ".$tbl_wiki." |
|
| 2535 | WHERE |
|
| 2536 | c_id = $course_id AND |
|
| 2537 | visibility=1 AND |
|
| 2538 | title LIKE '%".Database::escape_string($search_term)."%' AND |
|
| 2539 | ".$groupfilter.$condition_session.""; |
|
| 2540 | //search all pages and all versions |
|
| 2541 | } |
|
| 2542 | } else { |
|
| 2543 | if ($search_content == '1') { |
|
| 2544 | $sql = "SELECT * FROM ".$tbl_wiki." s1 |
|
| 2545 | WHERE |
|
| 2546 | s1.c_id = $course_id AND |
|
| 2547 | visibility=1 AND |
|
| 2548 | title LIKE '%".Database::escape_string($search_term)."%' OR |
|
| 2549 | content LIKE '%".Database::escape_string($search_term)."%' AND |
|
| 2550 | id=( |
|
| 2551 | SELECT MAX(s2.id) |
|
| 2552 | FROM ".$tbl_wiki." s2 |
|
| 2553 | WHERE s2.c_id = $course_id AND |
|
| 2554 | s1.reflink = s2.reflink AND |
|
| 2555 | ".$groupfilter.$condition_session.")"; |
|
| 2556 | // warning don't use group by reflink because don't return the last version |
|
| 2557 | } else { |
|
| 2558 | $sql = "SELECT * FROM ".$tbl_wiki." s1 |
|
| 2559 | WHERE |
|
| 2560 | s1.c_id = $course_id AND |
|
| 2561 | visibility=1 AND |
|
| 2562 | title LIKE '%".Database::escape_string($search_term)."%' AND |
|
| 2563 | id = ( |
|
| 2564 | SELECT MAX(s2.id) FROM ".$tbl_wiki." s2 |
|
| 2565 | WHERE s2.c_id = $course_id AND |
|
| 2566 | s1.reflink = s2.reflink AND |
|
| 2567 | ".$groupfilter.$condition_session.")"; |
|
| 2568 | // warning don't use group by reflink because don't return the last version |
|
| 2569 | } |
|
| 2570 | } |
|
| 2571 | } |
|
| 2572 | ||
| 2573 | $result = Database::query($sql); |
|
| 2574 | ||
