BiTel

CREATE TABLE log_session_1_201108 (
  id int(11) NOT NULL AUTO_INCREMENT,
...
  PRIMARY KEY (id),
...
);

<?php
  $day = "08";
  $db_host = "IP";
  $db_database = "bgbilling";
  $db_user     = "root";
  $db_password = "PASS";
  $db_connect=mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
  mysql_select_db($db_database,$db_connect) or die(mysql_error());
  $table = 'log_server_3_201108';
  $mass = '';
  $query = mysql_query("SELECT * FROM `$table` WHERE `requests` LIKE '\n$day %'") or die(mysql_error());
  while($r = mysql_fetch_array($query)){
      $id = $r[0];
      $requests = $r[1];
      if (strpos($requests, 'Acct-Session-Time')){
   $requests = explode ("\n", $requests);
   $start = 0;
   foreach ($requests as $key => $val){
     if ($start == 1){
      if (trim($val) != ''){
        $temp = explode('=',$val);
        if (isset($temp[1]))
        if ((trim($temp[0]) != 'CHAP-Password') or (trim($temp[1]) != ''))
      $attrib[$id][trim($temp[0])] = $temp[1];
      }
      else{
        $start = 0;
      }
     }
     if (ereg("([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $val, $regs)) $attrib[$id]['date'] = $val;
     if (strpos($val, 'Attributes') !== false) $start = 1;
   }
      }
  }
/////////////////////////////////////////////////////////////////////////////////////////////
    $table2 = 'log_session_3_201108';
  foreach ($attrib as $key => $val){
      $q = mysql_query("SELECT * FROM user_alias_3 WHERE login_alias = '{$val['User-Name']}'");
      if (mysql_num_rows($q) > 0 ) {
   $r = mysql_fetch_array($q);
   $lid = $r[0];
   $login_name = $r[1];
      }
      else{
      }

if ($val['NAS-IP-Address'] == "94.X.X.X"){
$nas_id = "8";
}
elseif ($val['NAS-IP-Address'] == "94.X.X.X")
{
$nas_id = "3";
}
elseif ($val['NAS-IP-Address'] == "95.X.X.X")
{
$nas_id = "11";
}
elseif ($val['NAS-IP-Address'] == "94.X.X.X")
{
$nas_id = "1";
}
elseif ($val['NAS-IP-Address'] == "94.100.88.2")
{
$nas_id = "10";
}
elseif ($val['NAS-IP-Address'] == "94.100.90.30")
{
$nas_id = "9";
}
      $nas_por = $val['NAS-Port'];
      $session_id = $val['Acct-Session-Id'];
      $session_start = '2011-08-'.$val['date'];
      $day = explode(' ', $val['date']);
      $time = @explode(':', $day[1]);
      $session_stop = date("Y-m-d H:i:s", mktime($time[0], $time[1], $time[2], 8, $day[0], 2011) + $val['Acct-Session-Time']);
      $session_time = $val['Acct-Session-Time'];
      $session_cost = 0.00000;
      $from_number = $val['Calling-Station-Id'];
      $to_number = '';
      $input_octets = $val['Acct-Input-Octets'];
      $output_octets = $val['Acct-Output-Octets'];
      $status = 1;
      $lr = $key;
      $ipaddr =  $val['Framed-IP-Address'];
      $sid_time = 13;
      $fake = 0;
      mysql_query("INSERT INTO $table2 SET
           id = '',
           lid = '$lid',
           nas_id = '$nas_id',
           nas_port = '$nas_por',
           session_id = '$session_id',
           session_start = '$session_start',
           session_stop = '$session_stop',
           session_time = '$session_time',
           session_cost = '$session_cost',
           from_number = '$from_number',
           to_number = '$to_number',
           input_octets = '$input_octets',
           output_octets = '$output_octets',
           status = '$status',
           lr = '$lr',
           ipaddr =  INET_ATON('$ipaddr'),
           login_name = '$login_name',
           sid_time = '$sid_time',
           fake = '$fake'
         ");
  }
?>