/dashboard/fusioncharts/export-handlers/php-export-handler/admin/editRule.php

https://gitlab.com/Ihor11/practice_yaware · PHP · 134 lines · 132 code · 2 blank · 0 comment · 13 complexity · 5b4cb6ae79294add7e9d307f06792b5a MD5 · raw file 

    

  1. <?php
    2. 

  2. 	ini_set('display_errors',1); 
    3. 

  3. 	error_reporting(E_ALL);
    4. 

  4. 	include('includes/config.php'); 
    5. 

  5. 	include('writehtaccess.php'); 
    6. 

  6. 	if(!isset($_POST['id']) &&  isset($_GET['id']) &&  !empty($_GET['id']))
    7. 

  7. 	{
    8. 

  8. 		$paramToPass = array();
    9. 

  9. 		$selectQry = "select * from ipRules where id=" . trim(addslashes($_GET['id']));
    10. 

  10. 		$selectRes = mysql_query($selectQry);
    11. 

  11. 		$selectRow = mysql_fetch_assoc($selectRes);
    12. 

  12. 		if(mysql_num_rows($selectRes) > 0)
    13. 

  13. 		{
    14. 

  14. 			$paramToPass['id'] = $selectRow['id'];
    15. 

  15. 			$paramToPass['ip'] = $selectRow['ip'];
    16. 

  16. 			$paramToPass['reason'] = $selectRow['reason'] ;
    17. 

  17. 			showForm("Edit", "", $paramToPass);
    18. 

  18. 		}
    19. 

  19. 		else
    20. 

  20. 		{
    21. 

  21. 		?>
    22. 

  22. 			<script>
    23. 

  23. 					 parent.location.reload(true);
    24. 

  24. 				</script>
    25. 

  25. 		<?php 
    26. 

  26. 		}
    27. 

  27. 		
    28. 

  28. 		
    29. 

  29. 	}
    30. 

  30. 	else if( trim(addslashes($_POST["id"]))!="" &&  trim(addslashes($_POST["ip"]))!="")
    31. 

  31. 	{
    32. 

  32. 		$editStatement = "update exportServerDb.ipRules  set ip = '".trim(addslashes($_POST["ip"])) ."',reason = '".trim(addslashes($_POST["reason"]))."' where id=".trim(addslashes($_POST["id"]));
    33. 

  33. 		if(mysql_query($editStatement))
    34. 

  34. 		{
    35. 

  35. 			$paramToPass = array();
    36. 

  36. 			$selectQry = "select * from ipRules where id=" . trim(addslashes($_POST['id']));
    37. 

  37. 			$selectRes = mysql_query($selectQry);
    38. 

  38. 			$selectRow = mysql_fetch_assoc($selectRes);
    39. 

  39. 			if(mysql_num_rows($selectRes) > 0)
    40. 

  40. 			{
    41. 

  41. 				$paramToPass['id'] = $selectRow['id'];
    42. 

  42. 				$paramToPass['ip'] = $selectRow['ip'];
    43. 

  43. 				$paramToPass['reason'] = $selectRow['reason'] ;				
    44. 

  44. 			}
    45. 

  45. 			showForm("Edit", "Edited Successfully!",$paramToPass);
    46. 

  46. 			writeHtaccess();
    47. 

  47. 		?>
    48. 

  48. 			<script>
    49. 

  49. 				 parent.location.reload(true);
    50. 

  50. 			</script>
    51. 

  51. 		<?php 
    52. 

  52. 		}
    53. 

  53. 		else
    54. 

  54. 		{
    55. 

  55. 			$paramToPass = array();
    56. 

  56. 			$selectQry = "select * from ipRules where id=" . trim(addslashes($_POST['id']));
    57. 

  57. 			$selectRes = mysql_query($selectQry);
    58. 

  58. 			$selectRow = mysql_fetch_assoc($selectRes);
    59. 

  59. 			if(mysql_num_rows($selectRes) > 0)
    60. 

  60. 			{
    61. 

  61. 				$paramToPass['id'] = $selectRow['id'];
    62. 

  62. 				$paramToPass['ip'] = $selectRow['ip'];
    63. 

  63. 				$paramToPass['reason'] = $selectRow['reason'] ;				
    64. 

  64. 			}
    65. 

  65. 			showForm("Edit", "Error Occurred!", $paramToPass);
    66. 

  66. 		}
    67. 

  67. 	}
    68. 

  68. 	else if ( trim(addslashes($_POST["ip"]))=="")
    69. 

  69. 	{
    70. 

  70. 		$paramToPass = array();
    71. 

  71. 		$selectQry = "select * from ipRules where id=" . trim(addslashes($_POST['id']));
    72. 

  72. 		$selectRes = mysql_query($selectQry);
    73. 

  73. 		$selectRow = mysql_fetch_assoc($selectRes);
    74. 

  74. 		if(mysql_num_rows($selectRes) > 0)
    75. 

  75. 		{
    76. 

  76. 			$paramToPass['id'] = $selectRow['id'];
    77. 

  77. 			$paramToPass['ip'] = $selectRow['ip'];
    78. 

  78. 			$paramToPass['reason'] = $selectRow['reason'] ;				
    79. 

  79. 		}
    80. 

  80. 		showForm("Edit", "Ip cann't be Null", $paramToPass);
    81. 

  81. 	?>
    82. 

  82. 		<script>
    83. 

  83. 		//	 parent.location.reload(true);
    84. 

  84. 		</script>
    85. 

  85. 	<?php 
    86. 

  86. 	}
    87. 

  87. 	
    88. 

  88. 	
    89. 

  89. 	function showForm($mode,$msg,$params = array())
    90. 

  90. 	{
    91. 

  91. 	
    92. 

  92. 		?>
    93. 

  93. 			
    94. 

  94. 			<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    95. 

  95. 			<html xmlns="http://www.w3.org/1999/xhtml">
    96. 

  96. 			<head>
    97. 

  97. 			<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    98. 

  98. 			<title><?php echo $mode;?> CIDR/IP</title>
    99. 

  99. 			<link href="bootstrap/css/bootstrap.min.css" type="text/css" rel="stylesheet" />
    100. 

  100. 			<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.1/jquery.min.js"></script>
    101. 

  101. 			<script src="bootstrap/js/bootstrap.min.js"></script>
    102. 

  102. 			</head>
    103. 

  103. 			<body>
    104. 

  104. 			<div class="container">
    105. 

  105. 			<div style="color:red;text-align:center;"><?php echo $msg;?></div>
    106. 

  106. 			<h3 style="text-align:center;"><?php echo $mode;?> CIDR/IP to the Banlist</h3>
    107. 

  107. 			<form class="form-horizontal" action="editRule.php" method="post">
    108. 

  108. 				<div class="control-group">
    109. 

  109. 				<label class="control-label" for="ip">CIDR/IP to disallow</label>
    110. 

  110. 				<div class="controls">
    111. 

  111. 				  <input type="text" id="ip" name ="ip"  class="span2" value="<?php echo $params['ip']?>">
    112. 

  112. 				  
    113. 

  113. 				</div>
    114. 

  114. 			  </div>
    115. 

  115. 			  
    116. 

  116. 			  <div class="control-group">
    117. 

  117. 				<label class="control-label" for="reason">Reason</label>
    118. 

  118. 				<div class="controls">
    119. 

  119. 				  <textarea rows="3" id="reason" class="span4" name="reason"><?php echo $params['reason']?></textarea>
    120. 

  120. 				</div>
    121. 

  121. 			  </div>
    122. 

  122. 			  <div class="control-group">
    123. 

  123. 				<div class="controls">      
    124. 

  124. 					<input type="hidden" name="id" id="id" value="<?php echo $params['id']?>">
    125. 

  125. 				  <button type="submit" name="submit" class="btn btn-primary">Submit</button>
    126. 

  126. 				</div>
    127. 

  127. 			  </div>
    128. 

  128. 			</form>
    129. 

  129. 			</div>
    130. 

  130. 			</body>
    131. 

  131. 			</html>
    132. 

  132. 		<?php 
    133. 

  133. 	}
    134.