urlmanager.lib.php 21 KB

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