chamilo /
chamilo-lms
| @@ 470-494 (lines=25) @@ | ||
| 467 | * @param array of url_ids |
|
| 468 | * @return array |
|
| 469 | * */ |
|
| 470 | public static function add_users_to_urls($user_list, $url_list) |
|
| 471 | { |
|
| 472 | $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
|
| 473 | $result_array = array(); |
|
| 474 | ||
| 475 | if (is_array($user_list) && is_array($url_list)){ |
|
| 476 | foreach ($url_list as $url_id) { |
|
| 477 | foreach ($user_list as $user_id) { |
|
| 478 | $count = UrlManager::relation_url_user_exist($user_id,$url_id); |
|
| 479 | if ($count==0) { |
|
| 480 | $sql = "INSERT INTO $table_url_rel_user |
|
| 481 | SET user_id = ".intval($user_id).", access_url_id = ".intval($url_id); |
|
| 482 | $result = Database::query($sql); |
|
| 483 | if ($result) { |
|
| 484 | $result_array[$url_id][$user_id] = 1; |
|
| 485 | } else { |
|
| 486 | $result_array[$url_id][$user_id] = 0; |
|
| 487 | } |
|
| 488 | } |
|
| 489 | } |
|
| 490 | } |
|
| 491 | } |
|
| 492 | ||
| 493 | return $result_array; |
|
| 494 | } |
|
| 495 | ||
| 496 | ||
| 497 | /** |
|
| @@ 656-683 (lines=28) @@ | ||
| 653 | * @param array of url_ids |
|
| 654 | * @return array |
|
| 655 | * */ |
|
| 656 | public static function add_sessions_to_urls($session_list, $url_list) |
|
| 657 | { |
|
| 658 | $table_url_rel_session = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
| 659 | $result_array = array(); |
|
| 660 | ||
| 661 | if (is_array($session_list) && is_array($url_list)) { |
|
| 662 | foreach ($url_list as $url_id) { |
|
| 663 | foreach ($session_list as $session_id) { |
|
| 664 | $count = UrlManager::relation_url_session_exist($session_id, $url_id); |
|
| 665 | ||
| 666 | if ($count == 0) { |
|
| 667 | $sql = "INSERT INTO $table_url_rel_session |
|
| 668 | SET |
|
| 669 | session_id = ".intval($session_id).", |
|
| 670 | access_url_id = ".intval($url_id); |
|
| 671 | $result = Database::query($sql); |
|
| 672 | if ($result) { |
|
| 673 | $result_array[$url_id][$session_id] = 1; |
|
| 674 | } else { |
|
| 675 | $result_array[$url_id][$session_id] = 0; |
|
| 676 | } |
|
| 677 | } |
|
| 678 | } |
|
| 679 | } |
|
| 680 | } |
|
| 681 | ||
| 682 | return $result_array; |
|
| 683 | } |
|
| 684 | ||
| 685 | /** |
|
| 686 | * Add a user into a url |
|
