urlmanager.lib.php 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * This library provides functions for the access_url management.
  5. * Include/require it in your code to use its functionality.
  6. *
  7. * @package chamilo.library
  8. */
  9. /**
  10. * @package chamilo.library
  11. */
  12. class UrlManager
  13. {
  14. /**
  15. * Creates a new url access to Dokeos
  16. *
  17. * @author Julio Montoya <gugli100@gmail.com>,
  18. *
  19. * @param string The URL of the site
  20. * @param string The description of the site
  21. * @param int is active or not
  22. * @param int the user_id of the owner
  23. * @return boolean if success
  24. */
  25. public static function add($url, $description, $active)
  26. {
  27. $tms = time();
  28. $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  29. $sql = "INSERT INTO $table_access_url
  30. SET url = '".Database::escape_string($url)."',
  31. description = '".Database::escape_string($description)."',
  32. active = '".Database::escape_string($active)."',
  33. created_by = '".api_get_user_id()."',
  34. tms = FROM_UNIXTIME(".$tms.")";
  35. $result = Database::query($sql);
  36. return $result;
  37. }
  38. /**
  39. * Updates an URL access to Dokeos
  40. * @author Julio Montoya <gugli100@gmail.com>,
  41. *
  42. * @param int The url id
  43. * @param string The description of the site
  44. * @param int is active or not
  45. * @param int the user_id of the owner
  46. * @return boolean if success
  47. */
  48. public static function udpate($url_id, $url, $description, $active)
  49. {
  50. $url_id = intval($url_id);
  51. $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  52. $tms = time();
  53. $sql = "UPDATE $table_access_url
  54. SET url = '".Database::escape_string($url)."',
  55. description = '".Database::escape_string($description)."',
  56. active = '".Database::escape_string($active)."',
  57. created_by = '".api_get_user_id()."',
  58. tms = FROM_UNIXTIME(".$tms.")
  59. WHERE id = '$url_id'";
  60. $result = Database::query($sql);
  61. return $result;
  62. }
  63. /**
  64. * Deletes an url
  65. * @author Julio Montoya
  66. * @param int url id
  67. * @return boolean true if success
  68. * */
  69. public static function delete($id)
  70. {
  71. $id = intval($id);
  72. $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  73. $sql= "DELETE FROM $table_access_url WHERE id = ".$id;
  74. $result = Database::query($sql);
  75. return $result;
  76. }
  77. /**
  78. *
  79. * */
  80. public static function url_exist($url)
  81. {
  82. $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  83. $sql = "SELECT id FROM $table_access_url WHERE url = '".Database::escape_string($url)."' ";
  84. $res = Database::query($sql);
  85. $num = Database::num_rows($res);
  86. return $num;
  87. }
  88. /**
  89. *
  90. * */
  91. public static function url_id_exist($url)
  92. {
  93. $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  94. $sql = "SELECT id FROM $table_access_url WHERE id = '".Database::escape_string($url)."' ";
  95. $res = Database::query($sql);
  96. $num = Database::num_rows($res);
  97. return $num;
  98. }
  99. /**
  100. * This function get the quantity of URLs
  101. * @author Julio Montoya
  102. * @return int count of urls
  103. * */
  104. public static function url_count()
  105. {
  106. $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  107. $sql = "SELECT count(id) as count_result FROM $table_access_url";
  108. $res = Database::query($sql);
  109. $url = Database::fetch_array($res,'ASSOC');
  110. $result = $url['count_result'];
  111. return $result;
  112. }
  113. /**
  114. * Gets the id, url, description, and active status of ALL URLs
  115. * @author Julio Montoya
  116. * @return array
  117. * */
  118. public static function get_url_data()
  119. {
  120. $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  121. $sql = "SELECT id, url, description, active FROM $table_access_url ORDER BY id";
  122. $res = Database::query($sql);
  123. $urls = array ();
  124. while ($url = Database::fetch_array($res)) {
  125. $urls[] = $url;
  126. }
  127. return $urls;
  128. }
  129. /**
  130. * Gets the id, url, description, and active status of ALL URLs
  131. * @author Julio Montoya
  132. * @return array
  133. * */
  134. public static function get_url_data_from_id($url_id)
  135. {
  136. $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  137. $sql = "SELECT id, url, description, active FROM $table_access_url WHERE id = ".Database::escape_string($url_id);
  138. $res = Database::query($sql);
  139. $row = Database::fetch_array($res);
  140. return $row;
  141. }
  142. /** Gets the inner join of users and urls table
  143. * @author Julio Montoya
  144. * @param int access url id
  145. * @return array Database::store_result of the result
  146. * */
  147. public static function get_url_rel_user_data($access_url_id = null, $order_by = null)
  148. {
  149. $where = '';
  150. $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  151. $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
  152. if (!empty($access_url_id)) {
  153. $where ="WHERE $table_url_rel_user.access_url_id = ".Database::escape_string($access_url_id);
  154. }
  155. if (empty($order_by)) {
  156. $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';
  157. } else {
  158. $order_clause = $order_by;
  159. }
  160. $sql="SELECT u.user_id, lastname, firstname, username, official_code, access_url_id
  161. FROM $tbl_user u
  162. INNER JOIN $table_url_rel_user
  163. ON $table_url_rel_user.user_id = u.user_id
  164. $where $order_clause";
  165. $result=Database::query($sql);
  166. $users=Database::store_result($result);
  167. return $users;
  168. }
  169. /** Gets the inner join of access_url and the course table
  170. * @author Julio Montoya
  171. * @param int access url id
  172. * @return array Database::store_result of the result
  173. * */
  174. public static function get_url_rel_course_data($access_url_id='')
  175. {
  176. $where ='';
  177. $table_url_rel_course = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  178. $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  179. if (!empty($access_url_id))
  180. $where ="WHERE $table_url_rel_course.access_url_id = ".Database::escape_string($access_url_id);
  181. $sql="SELECT course_code, title, access_url_id
  182. FROM $tbl_course u
  183. INNER JOIN $table_url_rel_course
  184. ON $table_url_rel_course.course_code = code
  185. $where
  186. ORDER BY title, code";
  187. $result=Database::query($sql);
  188. $courses=Database::store_result($result);
  189. return $courses;
  190. }
  191. /** Gets the inner join of access_url and the session table
  192. * @author Julio Montoya
  193. * @param int access url id
  194. * @return array Database::store_result of the result
  195. * */
  196. public static function get_url_rel_session_data($access_url_id='')
  197. {
  198. $where ='';
  199. $table_url_rel_session = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);
  200. $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  201. if (!empty($access_url_id))
  202. $where ="WHERE $table_url_rel_session.access_url_id = ".Database::escape_string($access_url_id);
  203. $sql="SELECT id, name, access_url_id
  204. FROM $tbl_session u
  205. INNER JOIN $table_url_rel_session
  206. ON $table_url_rel_session.session_id = id
  207. $where
  208. ORDER BY name, id";
  209. $result=Database::query($sql);
  210. $sessions=Database::store_result($result);
  211. return $sessions;
  212. }
  213. /**
  214. * Sets the status of an URL 1 or 0
  215. * @author Julio Montoya
  216. * @param string lock || unlock
  217. * @param int url id
  218. * */
  219. public static function set_url_status($status, $url_id)
  220. {
  221. $url_table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  222. if ($status=='lock') {
  223. $status_db='0';
  224. }
  225. if ($status=='unlock') {
  226. $status_db='1';
  227. }
  228. if(($status_db=='1' OR $status_db=='0') AND is_numeric($url_id)) {
  229. $sql="UPDATE $url_table SET active='".Database::escape_string($status_db)."' WHERE id='".Database::escape_string($url_id)."'";
  230. $result = Database::query($sql);
  231. }
  232. }
  233. /**
  234. * Checks the relationship between an URL and a User (return the num_rows)
  235. * @author Julio Montoya
  236. * @param int user id
  237. * @param int url id
  238. * @return boolean true if success
  239. * */
  240. public static function relation_url_user_exist($user_id, $url_id) {
  241. $table_url_rel_user= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  242. $sql= "SELECT user_id FROM $table_url_rel_user WHERE access_url_id = ".Database::escape_string($url_id)." AND user_id = ".Database::escape_string($user_id)." ";
  243. $result = Database::query($sql);
  244. $num = Database::num_rows($result);
  245. return $num;
  246. }
  247. /**
  248. * Checks the relationship between an URL and a Course (return the num_rows)
  249. * @author Julio Montoya
  250. * @param int user id
  251. * @param int url id
  252. * @return boolean true if success
  253. * */
  254. public static function relation_url_course_exist($course_id, $url_id)
  255. {
  256. $table_url_rel_course= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  257. $sql= "SELECT course_code FROM $table_url_rel_course WHERE access_url_id = ".Database::escape_string($url_id)." AND course_code = '".Database::escape_string($course_id)."'";
  258. $result = Database::query($sql);
  259. $num = Database::num_rows($result);
  260. return $num;
  261. }
  262. /**
  263. * Checks the relationship between an URL and a Session (return the num_rows)
  264. * @author Julio Montoya
  265. * @param int user id
  266. * @param int url id
  267. * @return boolean true if success
  268. * */
  269. public static function relation_url_session_exist($session_id, $url_id) {
  270. $table_url_rel_session= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);
  271. $session_id = intval($session_id);
  272. $url_id = intval($url_id);
  273. $sql= "SELECT session_id FROM $table_url_rel_session WHERE access_url_id = ".Database::escape_string($url_id)." AND session_id = ".Database::escape_string($session_id);
  274. $result = Database::query($sql);
  275. $num = Database::num_rows($result);
  276. return $num;
  277. }
  278. /**
  279. * Add a group of users into a group of URLs
  280. * @author Julio Montoya
  281. * @param array of user_ids
  282. * @param array of url_ids
  283. * */
  284. public static function add_users_to_urls($user_list, $url_list) {
  285. $table_url_rel_user= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  286. $result_array=array();
  287. if (is_array($user_list) && is_array($url_list)){
  288. foreach ($url_list as $url_id) {
  289. foreach ($user_list as $user_id) {
  290. $count = UrlManager::relation_url_user_exist($user_id,$url_id);
  291. if ($count==0) {
  292. $sql = "INSERT INTO $table_url_rel_user
  293. SET user_id = ".Database::escape_string($user_id).", access_url_id = ".Database::escape_string($url_id);
  294. $result = Database::query($sql);
  295. if($result)
  296. $result_array[$url_id][$user_id]=1;
  297. else
  298. $result_array[$url_id][$user_id]=0;
  299. }
  300. }
  301. }
  302. }
  303. return $result_array;
  304. }
  305. /**
  306. * Add a group of courses into a group of URLs
  307. * @author Julio Montoya
  308. * @param array of course ids
  309. * @param array of url_ids
  310. * */
  311. public static function add_courses_to_urls($course_list,$url_list)
  312. {
  313. $table_url_rel_course= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  314. $result_array=array();
  315. if (is_array($course_list) && is_array($url_list)){
  316. foreach ($url_list as $url_id) {
  317. foreach ($course_list as $course_code) {
  318. $count = UrlManager::relation_url_course_exist($course_code,$url_id);
  319. if ($count==0) {
  320. $sql = "INSERT INTO $table_url_rel_course
  321. SET course_code = '".Database::escape_string($course_code)."', access_url_id = ".Database::escape_string($url_id);
  322. $result = Database::query($sql);
  323. if($result)
  324. $result_array[$url_id][$course_code]=1;
  325. else
  326. $result_array[$url_id][$course_code]=0;
  327. }
  328. }
  329. }
  330. }
  331. return $result_array;
  332. }
  333. /**
  334. * Add a group of sessions into a group of URLs
  335. * @author Julio Montoya
  336. * @param array of session ids
  337. * @param array of url_ids
  338. * */
  339. public static function add_sessions_to_urls($session_list,$url_list)
  340. {
  341. $table_url_rel_session= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);
  342. $result_array=array();
  343. if (is_array($session_list) && is_array($url_list)){
  344. foreach ($url_list as $url_id) {
  345. foreach ($session_list as $session_id) {
  346. $count = UrlManager::relation_url_session_exist($session_id,$url_id);
  347. if ($count==0) {
  348. $sql = "INSERT INTO $table_url_rel_session
  349. SET session_id = ".Database::escape_string($session_id).", access_url_id = ".Database::escape_string($url_id);
  350. $result = Database::query($sql);
  351. if($result)
  352. $result_array[$url_id][$session_id]=1;
  353. else
  354. $result_array[$url_id][$session_id]=0;
  355. }
  356. }
  357. }
  358. }
  359. return $result_array;
  360. }
  361. /**
  362. * Add a user into a url
  363. * @author Julio Montoya
  364. * @param user_id
  365. * @param url_id
  366. * @return boolean true if success
  367. * */
  368. public static function add_user_to_url($user_id, $url_id = 1) {
  369. $table_url_rel_user= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  370. if (empty($url_id)) $url_id = 1;
  371. $count = UrlManager::relation_url_user_exist($user_id,$url_id);
  372. $result = true;
  373. if (empty($count)) {
  374. $sql = "INSERT INTO $table_url_rel_user (user_id, access_url_id) VALUES ('".Database::escape_string($user_id)."', '".Database::escape_string($url_id)."') ";
  375. $result = Database::query($sql);
  376. }
  377. return $result;
  378. }
  379. public static function add_course_to_url($course_code, $url_id=1)
  380. {
  381. $table_url_rel_course= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  382. if (empty($url_id)) $url_id=1;
  383. $count = UrlManager::relation_url_course_exist($course_code,$url_id);
  384. if (empty($count)) {
  385. $sql = "INSERT INTO $table_url_rel_course
  386. SET course_code = '".Database::escape_string($course_code)."', access_url_id = ".Database::escape_string($url_id);
  387. $result = Database::query($sql);
  388. }
  389. return $result;
  390. }
  391. /**
  392. * Inserts a session to a URL (access_url_rel_session table)
  393. * @param int Session ID
  394. * @param int URL ID
  395. * @return bool True on success, false session already exists or insert failed
  396. */
  397. public static function add_session_to_url($session_id, $url_id = 1) {
  398. $table_url_rel_session= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);
  399. if (empty($url_id)) $url_id=1;
  400. $result = false;
  401. $count = UrlManager::relation_url_session_exist($session_id,$url_id);
  402. $session_id = intval($session_id);
  403. if (empty($count) && !empty($session_id)) {
  404. $url_id = intval($url_id);
  405. $sql = "INSERT INTO $table_url_rel_session
  406. SET session_id = ".Database::escape_string($session_id).", access_url_id = ".Database::escape_string($url_id);
  407. $result = Database::query($sql);
  408. }
  409. return $result;
  410. }
  411. /**
  412. * Deletes an url and user relationship
  413. * @author Julio Montoya
  414. * @param int user id
  415. * @param int url id
  416. * @return boolean true if success
  417. * */
  418. public static function delete_url_rel_user($user_id, $url_id) {
  419. $table_url_rel_user= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  420. $result = true;
  421. if (!empty($user_id) && !empty($url_id)) {
  422. $sql= "DELETE FROM $table_url_rel_user WHERE user_id = ".Database::escape_string($user_id)." AND access_url_id = ".Database::escape_string($url_id);
  423. $result = Database::query($sql);
  424. }
  425. return $result;
  426. }
  427. /**
  428. * Deletes an url and course relationship
  429. * @author Julio Montoya
  430. * @param char course code
  431. * @param int url id
  432. * @return boolean true if success
  433. * */
  434. public static function delete_url_rel_course($course_code, $url_id)
  435. {
  436. $table_url_rel_course= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  437. $sql= "DELETE FROM $table_url_rel_course WHERE course_code = '".Database::escape_string($course_code)."' AND access_url_id=".Database::escape_string($url_id)." ";
  438. $result = Database::query($sql);
  439. return $result;
  440. }
  441. /**
  442. * Deletes an url and session relationship
  443. * @author Julio Montoya
  444. * @param char course code
  445. * @param int url id
  446. * @return boolean true if success
  447. * */
  448. public static function delete_url_rel_session($session_id, $url_id) {
  449. $table_url_rel_session = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);
  450. $sql= "DELETE FROM $table_url_rel_session WHERE session_id = ".Database::escape_string($session_id)." AND access_url_id=".Database::escape_string($url_id)." ";
  451. $result = Database::query($sql,'ASSOC');
  452. return $result;
  453. }
  454. /**
  455. * Updates the access_url_rel_user table with a given user list
  456. * @author Julio Montoya
  457. * @param array user list
  458. * @param int access_url_id
  459. * */
  460. public static function update_urls_rel_user($user_list, $access_url_id) {
  461. $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  462. $sql = "SELECT user_id FROM $table_url_rel_user WHERE access_url_id = ".intval($access_url_id);
  463. $result = Database::query($sql);
  464. $existing_users = array();
  465. //Getting all users
  466. while($row = Database::fetch_array($result)){
  467. $existing_users[] = $row['user_id'];
  468. }
  469. //Adding users
  470. $users_added = array();
  471. foreach($user_list as $user_id_to_add) {
  472. if (!in_array($user_id_to_add, $existing_users)) {
  473. $result = UrlManager::add_user_to_url($user_id_to_add, $access_url_id);
  474. if ($result) {
  475. $users_added[] = $user_id_to_add;
  476. }
  477. }
  478. }
  479. $users_deleted = array();
  480. //deleting old users
  481. foreach($existing_users as $user_id_to_delete) {
  482. if (!in_array($user_id_to_delete, $user_list)) {
  483. $result = UrlManager::delete_url_rel_user($user_id_to_delete, $access_url_id);
  484. if ($result) {
  485. $users_deleted[] = $user_id_to_delete;
  486. }
  487. }
  488. }
  489. if (empty($users_added) && empty($users_deleted)) {
  490. return false;
  491. }
  492. return array('users_added' => $users_added, 'users_deleted' => $users_deleted);
  493. }
  494. /**
  495. * Updates the access_url_rel_course table with a given user list
  496. * @author Julio Montoya
  497. * @param array user list
  498. * @param int access_url_id
  499. * */
  500. public static function update_urls_rel_course($course_list,$access_url_id) {
  501. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  502. $table_url_rel_course = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  503. $sql = "SELECT course_code FROM $table_url_rel_course WHERE access_url_id=".intval($access_url_id);
  504. $result = Database::query($sql);
  505. $existing_courses = array();
  506. while($row = Database::fetch_array($result)){
  507. $existing_courses[] = $row['course_code'];
  508. }
  509. //adding courses
  510. foreach($course_list as $course_code) {
  511. if(!in_array($course_code, $existing_courses)) {
  512. UrlManager::add_course_to_url($course_code, $access_url_id);
  513. $course_info = api_get_course_info($course_code);
  514. CourseManager::update_course_ranking($course_info['real_id'], 0, $access_url_id);
  515. }
  516. }
  517. //deleting old courses
  518. foreach($existing_courses as $existing_course) {
  519. if(!in_array($existing_course, $course_list)) {
  520. UrlManager::delete_url_rel_course($existing_course,$access_url_id);
  521. $course_info = api_get_course_info($existing_course);
  522. CourseManager::update_course_ranking($course_info['real_id'], 0, $access_url_id);
  523. }
  524. }
  525. }
  526. /**
  527. * Updates the access_url_rel_session table with a given user list
  528. * @author Julio Montoya
  529. * @param array user list
  530. * @param int access_url_id
  531. * */
  532. public static function update_urls_rel_session($session_list,$access_url_id) {
  533. $table_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  534. $table_url_rel_session = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);
  535. $sql = "SELECT session_id FROM $table_url_rel_session WHERE access_url_id=".Database::escape_string($access_url_id);
  536. $result = Database::query($sql);
  537. $existing_sessions = array();
  538. while($row = Database::fetch_array($result)){
  539. $existing_sessions[] = $row['session_id'];
  540. }
  541. //adding users
  542. foreach($session_list as $session) {
  543. if(!in_array($session, $existing_sessions)) {
  544. if (!empty($session) && !empty($access_url_id)) {
  545. UrlManager::add_session_to_url($session, $access_url_id);
  546. }
  547. }
  548. }
  549. //deleting old users
  550. foreach($existing_sessions as $existing_session) {
  551. if(!in_array($existing_session, $session_list)) {
  552. if (!empty($existing_session) && !empty($access_url_id)) {
  553. UrlManager::delete_url_rel_session($existing_session,$access_url_id);
  554. }
  555. }
  556. }
  557. }
  558. public static function get_access_url_from_user($user_id) {
  559. $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  560. $table_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  561. $sql = "SELECT url, access_url_id FROM $table_url_rel_user url_rel_user INNER JOIN $table_url u
  562. ON (url_rel_user.access_url_id = u.id)
  563. WHERE user_id = ".Database::escape_string($user_id);
  564. $result = Database::query($sql);
  565. $url_list = Database::store_result($result,'ASSOC');
  566. return $url_list;
  567. }
  568. public static function get_access_url_from_session($session_id) {
  569. $table_url_rel_session = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);
  570. $table_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  571. $sql = "SELECT url, access_url_id FROM $table_url_rel_session url_rel_session INNER JOIN $table_url u
  572. ON (url_rel_session.access_url_id = u.id)
  573. WHERE session_id = ".Database::escape_string($session_id);
  574. $result = Database::query($sql);
  575. $url_list = Database::store_result($result);
  576. return $url_list;
  577. }
  578. /**
  579. *
  580. * */
  581. public static function get_url_id($url) {
  582. $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL);
  583. $sql = "SELECT id FROM $table_access_url WHERE url = '".Database::escape_string($url)."'";
  584. $result = Database::query($sql);
  585. $access_url_id = Database::result($result, 0, 0);
  586. return $access_url_id;
  587. }
  588. }