urlmanager.lib.php 20 KB

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