course_home.ajax.php 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. <?php
  2. /**
  3. * This class response to the Ajax calls
  4. *
  5. */
  6. require_once '../global.inc.php';
  7. $action = $_GET['a'];
  8. switch ($action) {
  9. case 'set_visibility':
  10. if(api_is_allowed_to_edit(null,true)) {
  11. $tool_table = Database::get_course_table(TABLE_TOOL_LIST);
  12. $tool_id = Security::remove_XSS($_GET["id"]);
  13. $tool_info = api_get_tool_information($tool_id);
  14. $tool_visibility = $tool_info['visibility'];
  15. $tool_image = $tool_info['image'];
  16. $new_image = str_replace('.gif','_na.gif',$tool_image);
  17. $requested_image = ($tool_visibility == 0 ) ? $tool_image : $new_image;
  18. $requested_clase = ($tool_visibility == 0 ) ? 'visible' : 'invisible';
  19. $requested_message = ($tool_visibility == 0 ) ? 'is_active' : 'is_inactive';
  20. $requested_view = ($tool_visibility == 0 ) ? 'visible.gif' : 'invisible.gif';
  21. $requested_visible = ($tool_visibility == 0 ) ? 1 : 0;
  22. $requested_view = ($tool_visibility == 0 ) ? 'visible.gif' : 'invisible.gif';
  23. $requested_visible = ($tool_visibility == 0 ) ? 1 : 0;
  24. //HIDE AND REACTIVATE TOOL
  25. if ($_GET["id"]==strval(intval($_GET["id"]))) {
  26. /* -- session condition for visibility
  27. if (!empty($session_id)) {
  28. $sql = "select session_id FROM $tool_table WHERE id='".$_GET["id"]."' AND session_id = '$session_id'";
  29. $rs = Database::query($sql,__FILE__,__LINE__);
  30. if (Database::num_rows($rs) > 0) {
  31. $sql="UPDATE $tool_table SET visibility=$requested_visible WHERE id='".$_GET["id"]."' AND session_id = '$session_id'";
  32. } else {
  33. $sql_select = "select * FROM $tool_table WHERE id='".$_GET["id"]."'";
  34. $res_select = Database::query($sql_select,__FILE__,__LINE__);
  35. $row_select = Database::fetch_array($res_select);
  36. $sql = "INSERT INTO $tool_table(name,link,image,visibility,admin,address,added_tool,target,category,session_id)
  37. VALUES('{$row_select['name']}','{$row_select['link']}','{$row_select['image']}','0','{$row_select['admin']}','{$row_select['address']}','{$row_select['added_tool']}','{$row_select['target']}','{$row_select['category']}','$session_id')";
  38. }
  39. } else $sql="UPDATE $tool_table SET visibility=$requested_visible WHERE id='".$_GET["id"]."'";
  40. */
  41. $sql="UPDATE $tool_table SET visibility=$requested_visible WHERE id='".$_GET["id"]."'";
  42. Database::query($sql,__FILE__,__LINE__);
  43. }
  44. /*
  45. -----------------------------------------------------------
  46. HIDE
  47. -----------------------------------------------------------
  48. */
  49. /* if(isset($_GET['visibility']) && $_GET['visibility']==0) // visibility 1 -> 0
  50. {
  51. if ($_GET["id"]==strval(intval($_GET["id"]))) {
  52. $sql="UPDATE $tool_table SET visibility=0 WHERE id='".intval($_GET["id"])."'";
  53. Database::query($sql,__FILE__,__LINE__);
  54. }
  55. }
  56. /*
  57. -----------------------------------------------------------
  58. REACTIVATE
  59. -----------------------------------------------------------
  60. */
  61. /* elseif(isset($_GET['visibility'])&& $_GET['visibility']==1) // visibility 0,2 -> 1
  62. {
  63. if ($_GET["id"]==strval(intval($_GET["id"]))) {
  64. Database::query("UPDATE $tool_table SET visibility=1 WHERE id='".intval($_GET["id"])."'",__FILE__,__LINE__);
  65. }
  66. }
  67. */
  68. $response_data = array(
  69. 'image' => $requested_image,
  70. 'tclass' => $requested_clase,
  71. 'message' => $requested_message,
  72. 'view' => $requested_view
  73. );
  74. print(json_encode($response_data));
  75. exit;
  76. }
  77. break;
  78. default:
  79. echo '';
  80. }
  81. ?>