Changeset 31375 for extensions/BanIP/admin.php

Timestamp:

Feb 28, 2016, 5:06:58 PM (8 years ago)

Author:

ddtddt

Message:

[extensions] - BanIP - add delete all

File:

• extensions/BanIP/admin.php (modified) (2 diffs)

extensions/BanIP/admin.php

@@ -92 +92 @@
 }  
 
-if (isset($_POST['submitaddipban2'])) {
-        $query = 'UPDATE ' . BANIP_TABLE .' SET ip= "'.$_POST['inserip'].'" WHERE id = '.$_POST['invisibleID'].';';
-        $result = pwg_query($query);
-        $_SESSION['page_infos'] = array(l10n('Ip ban update'));
+if (isset($_POST['submitdeleteall'])) {
+        $query = 'DELETE FROM ' . BANIP_TABLE . ';';
+    pwg_query($query);
         redirect($admin_base_url);
 }
@@ -111 +110 @@
 
 if (isset($_POST['submitaddipban'])) {
-        $query = 'INSERT INTO ' . BANIP_TABLE .'(ip) VALUES ("' . $_POST['inserip'] . '");';
-        $result = pwg_query($query);
-        $_SESSION['page_infos'] = array(l10n('Ip ban insert'));
-        redirect($admin_base_url);
-}
-                
-        
+  $plage= explode(".", $_POST['inserip']);
+  if(count($plage)!=4)
+        {
+          $_SESSION['page_errors'] = array(l10n('This Isn\'t an IP'));
+          redirect($admin_base_url);
+        }
+  if($plage[3]=='*')
+        {
+          $query = 'SELECT COUNT(*) AS verif_exist FROM ' . BANIP_TABLE . ' WHERE ip = \'' . $_POST['inserip'] . '\';';
+          $result = pwg_query($query);
+      $exist=pwg_db_fetch_array($result);
+          if($exist['verif_exist']>0)
+                {
+                  $_SESSION['page_errors'] = array(l10n('Range IP already banned'));
+                  redirect($admin_base_url);
+                }
+        }
+  $ipaddinrange=$plage[0].".".$plage[1].".".$plage[2].".*";
+  $query = 'SELECT COUNT(*) AS verif_exist FROM ' . BANIP_TABLE . ' WHERE ip = \'' . $ipaddinrange . '\';';
+  $result = pwg_query($query);
+  $exist=pwg_db_fetch_array($result);
+  if($exist['verif_exist']>0)
+        {
+          $_SESSION['page_errors'] = array(l10n('IP is in a range banned'));
+          redirect($admin_base_url);
+        }
+  $query = 'SELECT COUNT(*) AS verif_exist FROM ' . BANIP_TABLE . ' WHERE ip = \'' . $_POST['inserip'] . '\';';
+  $result = pwg_query($query);
+  $exist=pwg_db_fetch_array($result);
+  if($exist['verif_exist']>0)
+        {
+          $_SESSION['page_errors'] = array(l10n('IP already banned'));
+          redirect($admin_base_url);
+        }
+  if($plage[3]=='*')
+    {
+          $oldip=$plage[0].".".$plage[1].".".$plage[2].".";
+          $query = 'DELETE FROM ' . BANIP_TABLE . ' WHERE ip LIKE "' . $oldip . '%";';
+    pwg_query($query);
+          $_SESSION['page_infos'] = array(l10n('Range Ip ban insert'));
+        }
+  else
+    {
+          $_SESSION['page_infos'] = array(l10n('Ip ban insert'));
+        }
+  $query = 'INSERT INTO ' . BANIP_TABLE .'(ip) VALUES ("' . $_POST['inserip'] . '");';
+  $result = pwg_query($query);
+  redirect($admin_base_url);
+}
+
+if (isset($_POST['submitaddipban2'])) {
+  $plage= explode(".", $_POST['inserip']);
+  if(count($plage)!=4)
+        {
+          $_SESSION['page_errors'] = array(l10n('This Isn\'t an IP'));
+          redirect($admin_base_url);
+        }
+  if($plage[3]=='*')
+        {
+          $query = 'SELECT COUNT(*) AS verif_exist FROM ' . BANIP_TABLE . ' WHERE ip = \'' . $_POST['inserip'] . '\';';
+          $result = pwg_query($query);
+      $exist=pwg_db_fetch_array($result);
+          if($exist['verif_exist']>0)
+                {
+                  $_SESSION['page_errors'] = array(l10n('Range IP already banned'));
+                  redirect($admin_base_url);
+                }
+        }
+  $ipaddinrange=$plage[0].".".$plage[1].".".$plage[2].".*";
+  $query = 'SELECT COUNT(*) AS verif_exist FROM ' . BANIP_TABLE . ' WHERE ip = \'' . $ipaddinrange . '\';';
+  $result = pwg_query($query);
+  $exist=pwg_db_fetch_array($result);
+  if($exist['verif_exist']>0)
+        {
+          $_SESSION['page_errors'] = array(l10n('IP is in a range banned'));
+          redirect($admin_base_url);
+        }
+  $query = 'SELECT COUNT(*) AS verif_exist FROM ' . BANIP_TABLE . ' WHERE ip = \'' . $_POST['inserip'] . '\';';
+  $result = pwg_query($query);
+  $exist=pwg_db_fetch_array($result);
+  if($exist['verif_exist']>0)
+        {
+          $_SESSION['page_errors'] = array(l10n('IP already banned'));
+          redirect($admin_base_url);
+        }
+  if($plage[3]=='*')
+    {
+          $oldip=$plage[0].".".$plage[1].".".$plage[2].".";
+          $query = 'DELETE FROM ' . BANIP_TABLE . ' WHERE ip LIKE "' . $oldip . '%";';
+    pwg_query($query);
+          $_SESSION['page_infos'] = array(l10n('Range Ip ban update'));
+        }
+  else
+    {
+          $_SESSION['page_infos'] = array(l10n('Ip ban update'));
+        }
+  $query = 'UPDATE ' . BANIP_TABLE .' SET ip= "'.$_POST['inserip'].'" WHERE id = '.$_POST['invisibleID'].';';
+  $result = pwg_query($query);
+  redirect($admin_base_url);
+}
+
         break;
 }