urlmanager.lib.php 20 KB

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