Changeset 37 for system/generators/iptables.php

Timestamp:

Jan 31, 2008, 8:38:47 PM (16 years ago)

Author:

george

Message:

Upraveno: Přepsán přístup k databázi přes třídu mysqli v systémové složce.
Odstraněno: Staré verze souborů a staré nepoužité soubory.

Location:

system

Files:

• . (modified) (1 prop)
• generators/iptables.php (modified) (4 diffs)

system/generators/iptables.php

@@ -1 @@
-<?
-include('global.php');
-include_once('../../html/is/db.php');
-DB_Init('localhost', 'root', '', 'is');
+<?php
+include_once('../../html/global.php');
 
 // Generate firewall rules
@@ -11 +9 @@
 
 // Blocking according IP address
-DB_Select('users', '*', 'inet = 0'); 
-while($User = DB_Row())
+$DbResult = $Database->select('users', '*', 'inet = 0'); 
+while($User = $DbResult->fetch_array())
 {
-  DB_Save();
-  DB_Select('hosts', '*', "block<2 AND MAC!='' AND user=".$User['id']);
-  while($Row = DB_Row())
+  $DbResult2 = $Database->select('hosts', '*', "block<2 AND MAC!='' AND user=".$User['id']);
+  while($Row = $DbResult2->fetch_array())
   {
     exec('iptables -t nat -A Block -s '.$Row['IP'].' -j Local');
   }
-  DB_Load();
 }
-DB_Select('users', '*', 'inet = 1'); 
-while($User = DB_Row())
+$DbResult = $Database->select('users', '*', 'inet = 1'); 
+while($User = $DbResult->fetch_array())
 {
-  DB_Save();
-  DB_Select('hosts','*',"block<2 AND MAC!='' AND vpn=1 AND user=".$User['id']);
-  while($Row = DB_Row())
+  $DbResult2 = $Database->select('hosts','*',"block<2 AND MAC!='' AND vpn=1 AND user=".$User['id']);
+  while($Row = $DbResult2->fetch_array())
   {
     exec('iptables -t nat -A Block -s '.$Row['IP'].' -j Local');
   }
-  DB_Load();
 }
 
 // Blocking according MAC address
-DB_Select('users', '*'); 
-while($User = DB_Row())
+$DbResult = $Database->select('users', '*'); 
+while($User = $DbResult->fetch_array())
 {
   //echo($User['fullname']."\n");
-  DB_Save();
-  DB_Select('hosts','*','block<2 AND MAC!="" AND user='.$User['id'].' ORDER BY id DESC');
-  while($Row = DB_Row())
+  $DbResult2 = $Database->select('hosts','*','block<2 AND MAC!="" AND user='.$User['id'].' ORDER BY id DESC');
+  while($Row = $DbResult2->fetch_array())
   {
     //echo(' '.$Row['name']." ".$Row['MAC']." ");
@@ -92 +85 @@
     //echo("\n");
   }
-  DB_Load();
 }
 
 // SMTP NAT port 25
-DB_Select('hosts', '*', 'name="MAIL"');
-$Row = DB_Row();
+$DbResult = $Database->select('hosts', '*', 'name="MAIL"');
+$Row = $DbResult->fetch_array();
 exec('iptables -t nat -A PreroutingDNAT -p tcp -m tcp --dport 25 -d 212.111.4.174 -j DROP');  
 exec('iptables -t nat -A PreroutingDNAT -p tcp -m tcp --dport 25 -d '.$Row['external_ip'].' -j DNAT --to-destination '.$Row['IP']);  
@@ -104 +96 @@
 
 // Local network NAT
-DB_Select('hosts', '*', 'name="GATE"');
-$Row = DB_Row();
+$DbResult = $Database->select('hosts', '*', 'name="GATE"');
+$Row = $DbResult->fetch_array();
 exec('iptables -t nat -A POSTROUTING -s 192.168.0.0/255.255.0.0 -o eth1 -j SNAT --to-source '.$Row['external_ip']);
 //exec('iptables -t nat -A POSTROUTING -s 10.0.0.0/255.0.0.0 -o eth1 -j SNAT --to-source '.$Row['external_ip']);