CREATE TABLE `traffic` (
  `ID` int( 10 ) unsigned NOT NULL auto_increment,
  `Day` datetime NOT NULL default '0000-00-00 00:00:00',
  `FromIP` char( 15 ) NOT NULL default '',
  `SPort` int( 10 ) unsigned NOT NULL default '0',
  `X12` char( 7 ) NOT NULL default '',
  `X3` int( 10 ) unsigned NOT NULL default '0',
  `X4` int( 10 ) unsigned NOT NULL default '0',
  `DPort` int( 10 ) unsigned NOT NULL default '0',
  `Bytes` int( 10 ) unsigned NOT NULL default '0',
  `IFace` char( 10 ) NOT NULL default '',
  `RouterID` int( 10 ) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM; 

INSERT INTO traffic (`ID`,`Day`,`FromIP`,`SPort`,`X12`,`X3`,`X4`,`DPort`,`Bytes`,`IFace`,`RouterID`) VALUES ('', \'$Date\', '$Row[0]', '$Row[4]', '$Dst[0].$Dst[1]', '$Dst[2]', '$Dst[3]', '$Row[5]', '$Row[3]', '', '$Routers{$ip}')

SELECT `Day`,`X12`,`X3`,`X4`,SUM(`Bytes`),`FromIP` FROM `traffic` WHERE (`Day` LIKE '$cur_date_full%' AND (`X12`=\'$net_prefix\' OR `X12`='192.168' OR `X12`='194.67')) GROUP BY `X3`,`X4`,`FromIP`

SELECT `Day`,`X12`,`X3`,`X4`,`SPort`,SUM(`Bytes`),`FromIP` FROM `traffic` WHERE (`Day` LIKE '$cur_date_full%' AND (`X12`=\'$net_prefix\' OR `X12`='192.168' OR `X12`='194.67') AND `SPort`='80') GROUP BY `X3`,`X4`,`FromIP`

SELECT `Day`,`X12`,`X3`,`X4`,`SPort`,SUM(`Bytes`),`FromIP` FROM `traffic` WHERE (`Day` LIKE '$cur_date_full%' AND (`X12`=\'$net_prefix\' OR `X12`='192.168' OR `X12`='194.67') AND `SPort`='110') GROUP BY `X3`,`X4`,`FromIP`

SELECT `Day`,`FromIP`,SUM(`Bytes`),`FromIP` FROM `traffic` WHERE (`Day` LIKE '$cur_date_full%' AND (`FromIP` LIKE \'$net_prefix.%\' OR `FromIP` LIKE '192.168.' OR `FromIP` LIKE '194.67.181.')) GROUP BY `FromIP`

SELECT `Day`,`FromIP`,`DPort`,SUM(`Bytes`),`FromIP` FROM `traffic` WHERE (`Day` LIKE '$cur_date_full%' AND (`FromIP` LIKE \'$net_prefix.%\' OR `FromIP` LIKE '192.168.0.%' OR `FromIP` LIKE '194.67.181.%') AND `DPort`='25') GROUP BY `FromIP`

  KEY `Day_X1234` (`Day`,`X12`,`X3`,`X4`),
  KEY `Day_FromIP` (`Day`,`FromIP`)