chamilo /
chamilo-lms
| @@ 451-475 (lines=25) @@ | ||
| 448 | * @param array of url_ids |
|
| 449 | * @return array |
|
| 450 | * */ |
|
| 451 | public static function add_users_to_urls($user_list, $url_list) |
|
| 452 | { |
|
| 453 | $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
|
| 454 | $result_array = array(); |
|
| 455 | ||
| 456 | if (is_array($user_list) && is_array($url_list)){ |
|
| 457 | foreach ($url_list as $url_id) { |
|
| 458 | foreach ($user_list as $user_id) { |
|
| 459 | $count = UrlManager::relation_url_user_exist($user_id,$url_id); |
|
| 460 | if ($count==0) { |
|
| 461 | $sql = "INSERT INTO $table_url_rel_user |
|
| 462 | SET user_id = ".intval($user_id).", access_url_id = ".intval($url_id); |
|
| 463 | $result = Database::query($sql); |
|
| 464 | if ($result) { |
|
| 465 | $result_array[$url_id][$user_id] = 1; |
|
| 466 | } else { |
|
| 467 | $result_array[$url_id][$user_id] = 0; |
|
| 468 | } |
|
| 469 | } |
|
| 470 | } |
|
| 471 | } |
|
| 472 | } |
|
| 473 | ||
| 474 | return $result_array; |
|
| 475 | } |
|
| 476 | ||
| 477 | ||
| 478 | /** |
|
| @@ 637-664 (lines=28) @@ | ||
| 634 | * @param array of url_ids |
|
| 635 | * @return array |
|
| 636 | * */ |
|
| 637 | public static function add_sessions_to_urls($session_list, $url_list) |
|
| 638 | { |
|
| 639 | $table_url_rel_session = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
| 640 | $result_array = array(); |
|
| 641 | ||
| 642 | if (is_array($session_list) && is_array($url_list)) { |
|
| 643 | foreach ($url_list as $url_id) { |
|
| 644 | foreach ($session_list as $session_id) { |
|
| 645 | $count = UrlManager::relation_url_session_exist($session_id, $url_id); |
|
| 646 | ||
| 647 | if ($count == 0) { |
|
| 648 | $sql = "INSERT INTO $table_url_rel_session |
|
| 649 | SET |
|
| 650 | session_id = ".intval($session_id).", |
|
| 651 | access_url_id = ".intval($url_id); |
|
| 652 | $result = Database::query($sql); |
|
| 653 | if ($result) { |
|
| 654 | $result_array[$url_id][$session_id] = 1; |
|
| 655 | } else { |
|
| 656 | $result_array[$url_id][$session_id] = 0; |
|
| 657 | } |
|
| 658 | } |
|
| 659 | } |
|
| 660 | } |
|
| 661 | } |
|
| 662 | ||
| 663 | return $result_array; |
|
| 664 | } |
|
| 665 | ||
| 666 | /** |
|
| 667 | * Add a user into a url |
|
