Changeset 37 for system/statistic/known_mac.php

Timestamp:

Jan 31, 2008, 8:38:47 PM (17 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)
• statistic (modified) (1 prop)
• statistic/known_mac.php (modified) (3 diffs)

system/statistic/known_mac.php

@@ -1 @@
-<?
-include_once('/a/html/is/db.php');
-DB_Init('localhost','root','','statistic');
+<?php
+include_once('../html/global.php');
+$Database->select_db('statistic');
 
 while(1)
 {
-  DB_Delete('ip_conntrack', '1');
+  $Database->delete('ip_conntrack', '1');
   $File = fopen('/proc/net/arp', 'r');
   fgets($File);  // Title row
@@ -20 +20 @@
       if($Mac != '00:00:00:00:00:00')
       {
-        DB_Select('known_mac', '*', 'ip="'.$Ip.'" AND mac="'.$Mac.'" AND interface="'.$Interface.'"');
-        if(DB_NumRows() == 0) DB_Insert('known_mac', array('ip' => $Ip, 'mac' => $Mac, 'interface' => $Interface, 'first_time' => 'NOW()', 'last_time' => 'NOW()'));
-          else DB_Update('known_mac', 'ip="'.$Ip.'" AND mac="'.$Mac.'" AND interface="'.$Interface.'"', array('last_time' => 'NOW()'));
+        $DbResult = $Database->select('known_mac', '*', 'ip="'.$Ip.'" AND mac="'.$Mac.'" AND interface="'.$Interface.'"');
+        if($DbResult->num_rows == 0) $Database->insert('known_mac', array('ip' => $Ip, 'mac' => $Mac, 'interface' => $Interface, 'first_time' => 'NOW()', 'last_time' => 'NOW()'));
+          else $Database->update('known_mac', 'ip="'.$Ip.'" AND mac="'.$Mac.'" AND interface="'.$Interface.'"', array('last_time' => 'NOW()'));
       }
     }  
@@ -28 +28 @@
   }
   fclose($File);
-  DB_Query('OPTIMIZE TABLE known_mac');
+  $Database->query('OPTIMIZE TABLE known_mac');
   Sleep(50);  // ARP cache timeout = 60 seconds
 }