Public feed #725392

lawlrus

public sql v1 · immutable
Raw Edit
·published 2007-10-04 11:33 UTC
rendered paste body
DROP TABLE IF EXISTS `sh`;CREATE TABLE `sh` (  `id` double DEFAULT NULL,  `ip` varchar(30) DEFAULT NULL,  `wwl` double DEFAULT NULL,  `rip` double DEFAULT NULL,  `vspam` double DEFAULT NULL,  `vshare` double DEFAULT NULL,  `vddos` double DEFAULT NULL,  `skr` double DEFAULT NULL,  `rddos` double DEFAULT NULL,  `mailer` double DEFAULT NULL,  `hdr` double DEFAULT NULL,  `fwl` double DEFAULT NULL,  `fc` double DEFAULT NULL,  `enc` double DEFAULT NULL,  `dec1` double DEFAULT NULL,  `crc` double DEFAULT NULL,  `av` double DEFAULT NULL,  `ana` double DEFAULT NULL);LOCK TABLES `sh` WRITE;INSERT INTO `sh` VALUES (165,'34.72.193.206',5,0,0,0,0,4.7,0,0,0,4.9,0,0,0,0,0,0),(133,'144.25.116.39',3.9,0,0,0,0,0,0,0,0,3.8,0,0,0,0,0,0),(132,'21.18.35.25',0,0,0,0,0,0,0,0,0,3.8,0,0,0,0,0,0),(131,'115.253.239.244',0,0,0,0,0,0,0,0,0,3.8,0,0,3.8,0,0,0),(130,'21.26.30.22',3.8,0,0,0,0,0,0,0,0,3.7,0,0,0,3.8,0,0),(137,'170.4.54.69',0,0,0,0,0,0,0,0,4,4,0,0,0,0,0,0),(136,'11.125.146.145',4,0,0,0,0,0,0,0,0,3.9,0,0,0,0,0,0),(135,'173.22.203.196',0,0,0,0,0,0,0,0,0,3.9,0,0,0,0,0,0),(134,'120.101.174.253',0,0,0,0,0,0,0,0,0,3.9,0,0,0,4,0,0),(139,'135.99.182.134',0,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0),(138,'45.68.137.16',0,0,0,0,0,0,0,0,0,4,0,4,4,0,0,0),(166,'252.115.199.40',0,0,0,0,0,0,0,0,0,5,0,0,0,0,4.9,4),(24,'242.133.164.81',0,0,0,0,0,0,0,0,0,0.8,0,0,0,0,0,0),(25,'162.51.129.169',1,0,0,0,0,0.8,0,0,0.8,0.9,0.8,0,0,1,0,0),(26,'71.136.63.190',0,0,0,0,0,0,0,0,0,1,0,0,1,0,0.6,0),(27,'109.198.68.77',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0),(20,'254.151.123.253',0,0,0,0,0,0,0,0,0,0.8,0,0,0,0,0,0),(21,'13.232.147.158',0,0,0,0,0,0,0,0,0,0.8,0,0,0,0,0,0),(22,'0.156.244.201',0,0,0,0,0,0,0,0,0,0.8,0,0,0,0,0,0),(23,'94.87.45.87',0.9,0,0,0,0,0,0,0.7,0,0.8,0,0,0,0,0.7,0),(160,'222.29.243.43',0,0,0,0,0,0,0,0,4.7,4.7,0,0,0,0,0,0),(28,'132.21.163.202',0,0,0.9,0,0,0,0,0,0.9,1,0,0,0,0,0,1),(29,'7.5.7.89',1.1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0),(161,'135.154.119.144',4.8,0,0,0,0,0,0,0,0,4.7,0,0,0,0,0,0),(4,'1.1.1.1',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(8,'136.208.245.59',0,0,0,0,0,0,0,0,0,0.5,0,0,0,0,0.3,0),(163,'174.58.255.90',4.9,0,0,0,0,0,0,0,0,4.8,4.8,0,0,0,0,0),(119,'213.104.0.229',3.5,0,0,0,0,3.5,0,0,0,3.4,0,0,0,0,3.4,0),(120,'171.3.251.17',3.6,0,0,0,0,0,0,0,0,3.5,0,3.5,3.5,3.5,0,0),(121,'26.223.183.134',0,0,0,0,0,0,0,0,0,3.6,0,0,0,3.7,0,0),(122,'137.0.218.12',0,0,0,0,0,0,0,0,3.7,3.6,0,0,0,0,0,0),(123,'254.206.104.178',0,0.7,0,0,0,0,0,0,0,3.6,0,0,0,0,0,0),(124,'103.13.127.196',0,0,0,0,0,0,0,0,0,3.6,3.6,0,0,0,0,0),(125,'209.222.239.129',0,0,0,0,0,0,0,0,0,3.6,0,0,0,0,0,0),(126,'249.85.70.54',0,0,0,0,0,3.7,0,0,0,3.6,0,0,0,0,0,0),(127,'96.37.77.96',3.7,0,0,0,0,0,0,0,0,3.6,0,0,0,0,3.6,0),(128,'160.7.44.55',0,0,0,0,0,0,0,0,0,3.7,0,0,0,0,0,0),(129,'188.40.32.42',0,0,0,0,0,0,0,0,0,3.7,0,0,0,0,0,0),(118,'127.115.164.138',3.4,0,0,0,0,0,0,0,3.4,3.3,0,0,0,0,0,3.5),(59,'152.158.115.148',0,0,0,0,0,0,0,2.2,0,2,2.2,0,0,0,0,0),(58,'193.198.230.16',0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0),(55,'19.188.239.174',0,0,0,0,0,0,0,0,0,1.8,0,0,0,0,2,0),(54,'189.23.124.7',1.9,0,0,0,0,0,0,0,1.9,1.8,0,0,0,0,0,0),(57,'105.133.13.108',0,0,2,1.9,0,2,0.6,0,0,2,0,0,0,0,0,0),(56,'255.33.234.33',2,0,0,0,0,0,0,2,0,1.9,0,0,0,2,0,0),(51,'101.133.111.159',1.8,0,0,0,0,1.9,0,0,0,1.7,1.4,0,0,0,0,0),(50,'112.43.79.120',0,0,0,0,0,0,0,1.5,0,1.7,0,0,0,0,0,0),(53,'203.103.59.47',0,0,0,0,0,0,0,1.7,1.7,1.8,0,0,0,0,0,0),(52,'206.146.24.93',0,0,1.7,0,0,0,0,0,0,1.7,2,0,0,0,0,2),(164,'169.244.20.135',0,0,0,0,0,0,0,4.9,0,4.9,0,0,0,5,0,0),(115,'51.176.101.166',3.3,0,0,0,0,0,0,0,0,3.2,0,0,3.2,0,0,0),(114,'200.60.183.92',0,0,0,0,0,0,0,3.3,0,3.2,0,0,0,0,0,0),(88,'238.176.102.3',0,0,0,0,0,0,0,0,0,2.7,0,0,0,2.7,0,0),(89,'101.52.91.79',0,0,0,2.6,0,0,0,0,0,2.7,0,0,0,0,2.8,0),(111,'236.155.42.129',0,0,0,0,0,0,0,0,0,3.2,0,0,0,0,0,0),(110,'82.82.41.237',0,0,0,0,0,0,0,0,0,3.2,0,0,0,0,0,0),(113,'172.0.47.201',0,0,0,0,0,0,0,0,0,3.2,0,0,0,0,0,0),(112,'241.105.225.118',0,0,0,0,0,0,0,0,0,3.2,3.5,0,0,0,0,0),(82,'2.158.124.111',0,0,0,0,0,0,0,0,2.6,2.6,0,0,0,0,0,0),(83,'12.69.38.5',0,0,0,0,0,0,0,0,0,2.6,2.6,0,0,0,2.5,0),(80,'160.88.2.49',0,0,2.6,0,0,0,0,2.6,0,2.6,0,0,0,0,0,0),(81,'114.198.119.21',0,0,0,0,0,0,0,0,0,2.6,0,0,2.4,2.6,0,0),(86,'80.77.237.134',2.8,0,0,0,0,0,0,0,0,2.7,0,0,0,0,0,0),(87,'15.35.62.224',0,0,0,0,0,0,0,0,0,2.7,0,0,0,0,0,2.7),(84,'118.41.15.227',2.7,0,0,0,0,0,0,0,0,2.6,0,0,0,0,0,0),(85,'96.154.255.246',0,0,0,2.8,0,0,0,0,0,2.7,0,0,0,0,0,0),(3,'246.185.15.208',0,0,0,0,0,0.2,0,0,0.2,0,0,0,0,0,0,0),(7,'124.191.123.222',0,0.5,0,0,0,0,0,0,0,0.5,0,0,0,0,0,0),(108,'140.243.173.181',0,0,0,0,0,0,0,0,0,3.1,0,3.2,0,0,0,0),(109,'189.63.250.247',3.2,0,3.2,0,0,0,0,0,0,3.1,0,0,0,0,0,0),(102,'67.247.218.237',0,0,0,0,0,3,0,0,0,2.9,0,0,0,0,0,0),(103,'113.113.217.204',0,0,0,0,0,0,0,0,0,2.9,3,0,0,0,0,0),(100,'68.152.119.206',0,0,0,0,0,0,0,0,3,2.9,0,2.5,0,0,0,0),(101,'220.204.61.152',0,0,0,0,0,0,0,0,0,2.9,0,0,0,2.9,0,0),(106,'34.170.166.53',0,0,0,0,0,0,0,0,0,3.1,0,0,0,0,3.1,3.2),(107,'58.231.184.217',0,0,0,0,0,3.2,0,0,0,3.1,0,0,0,3.1,0,0),(104,'64.223.252.221',0,0,3,0,0,0,0,0,0,2.9,0,0,0,0,0,3),(105,'121.15.223.76',0,0,0,0,0,0,0,0,0,3,0,3,3,0,0,0),(39,'214.172.152.188',0,0,0,0,0,0,0,0,0,1.3,0,0,0,0,0,0),(38,'120.92.153.170',0,0,0,0,0,0,0,0,0,1.3,0,0,0,0,0,0),(33,'42.7.239.13',1.2,0,0,0,0,0,0,0,1.1,1.1,0,0,0,1.1,0,0),(32,'127.0.0.1',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(31,'96.128.231.240',0,0,0,0,0,0.9,0,0,0,1,0,0,0,1.1,0.9,0),(30,'16.1.233.10',0,0,0,0,0,0,0,0,0,1.1,0,0,0,0,1.1,0),(37,'249.11.136.34',1.3,0,0,0,0,0,0,0,0,1.2,0,0,0,0,0,1.5),(36,'48.121.47.116',0,0,1.1,0,0,0,0,1.1,0,1.2,0,0,0,1.5,0,0),(35,'142.229.199.91',0,0,0,0,0,0,0,0,0,1.2,0,0,0,0,0,0),(34,'234.86.95.202',0,0,0,0,0,1.2,0,0,0,1.2,0,0,0,0,0,0),(60,'81.73.86.255',2.1,0,0,0,0,0,0,0,0,2,0,1,0,0,0,0),(61,'138.76.73.28',0,0,0,0,0,0,0,0,0,2,0,0,0,0,2,2),(62,'159.229.197.164',0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0),(63,'243.100.166.15',0,0,0,0,0,0,0,0,0,2,0,0,0,2,0,0),(64,'66.241.98.226',0,0,0,0,0,0,0,0,0,2.1,0,0,0,0,0,2.2),(65,'252.81.175.188',0,0,2.3,0,0,2.3,0,0,0,2.1,0,0,0,0,0,0),(66,'247.163.249.66',0,0,0,0,0,0,0,0,0,2.1,0,2,0,2.1,0,0),(67,'83.230.105.121',2.2,0,0,0,0,0,0,0,2.2,2.1,0,0,0,0,0,0),(68,'73.137.85.78',0,0,0,0,0,0,0,0,2.4,2.1,0,0,0,0,0,0),(69,'227.62.179.117',0,0,0,0,0,0,0,0,0,2.2,0,0,0,2.3,0,2.3),(0,'149.201.199.233',0,0.6,0,0,0,0,0,0,0,1.6,0,0,0,0,0,0),(2,'129.94.140.59',0,0,0.3,0,0,0,0,0.3,0,0,0,0,0,0.3,0,0),(162,'148.90.86.220',0,0,0,0,0,0,0,0,0,4.8,0,0,0,0,0,0),(6,'255.0.255.0',0.5,0,0,0,0,0,0,0,0,0,0,0,0,0.4,0,0),(99,'247.140.133.168',3.1,0,0,3,0,0,0,0,0,2.9,0,0,0,3,3,0),(98,'85.148.218.87',0,0,0,0,0,0,0,0,2.8,2.8,0,0,0,0,0,0),(91,'250.3.107.51',0,0,0,0,0,0,0,0,0,2.7,0,0,0,0,0,0),(90,'215.119.128.38',0,0,2.8,0,0,0,0,2,0,2.8,0,0,0,0,0,0),(93,'250.117.216.18',2.9,0,0,0,0,0,0,0,0,2.8,0,0,0,0,0,0),(92,'49.218.89.175',0,0,0,0,0,0,0,2.8,0,2.7,0,0,2.9,0,0,0),(95,'225.99.248.46',0,0,0,0,0,0,0,0,0,2.8,0,0,0,0,0,0),(94,'187.161.10.38',3,0,0,0,0,0,0,0,0,2.9,0,0,0,0,0,0),(97,'104.248.113.147',0,0,0,0,0,0,0,0,0,2.8,0,0,0,2.8,0,0),(96,'69.144.46.76',0,0,0,0,0,0,0,0,0,2,2.8,0,0,0,0,0),(11,'121.142.212.124',0,0,0,0,0,0.4,0,0.6,0.5,0.7,0,0,0,0.7,0,1),(10,'184.182.224.6',0,0,0.6,0,0,0,0,0,0,0.7,0,0,0,0,0,0),(13,'244.2.133.183',0.9,0,0.7,0.7,0,0,0,0,0,0.8,0,0,0,0,0,0),(12,'19.84.229.163',0.8,0,0,0,0.3,0,0,0,0,0.7,0,0,0,0,0,0),(15,'135.132.154.124',0,0,0,0,0,0,0,0,0,0.6,0,0,0,0,0.4,0),(14,'33.53.184.126',0,0,0,0,0,0,0,0,0,0.9,0,0,0,0.9,0,0),(17,'237.139.128.181',0,0,0,0,0,0,0.3,0,0,0.8,0,0,0,0,0,0),(16,'57.195.92.143',0,0,0.4,0,0,0,0,0.4,0.3,0.6,0,0,0,0,0,0),(19,'102.244.136.190',0,0,0,0,0,0,0,0,0,0.8,0,0,0,0,0,0),(18,'251.153.56.29',0,0,0,0,0,0.4,0,0,0.4,0.6,0,0,0,0,0,0.6),(117,'110.38.135.166',0,0,0,3.4,0,0,0,0,0,3.3,0,0,0,0,3.3,0),(116,'239.152.83.74',0,0,0,0,0,0,0,0,0,3.3,0,0,0,3.3,0,0),(151,'160.92.38.152',4.5,0,0,0,0,0,0,0,0,4.3,0,0,0,0,0,0),(150,'160.204.113.34',0,0,0,0,0,0,0,0,4.5,4.3,0,4.5,0,0,0,0),(153,'58.145.5.177',0,0,0,0,0,0,0,0,0,4.4,0,0,0,4.5,0,0),(152,'177.240.29.129',0,0,0,0,0,0,0,0,0,4.4,0,0,0,0,0,0),(155,'6.155.226.111',0,0,0,0,0,4.5,0,0,0,4.5,4.5,0,0,0,0,0),(154,'6.100.142.172',0,0,0,0,0,0,0,4.5,0,4.4,0,0,4.5,0,0,0),(157,'164.221.47.125',4.7,0,0,0,0,0,0,0,0,4.5,0,0,4.6,0,0,0),(156,'232.82.137.4',0,0,0,0,0,0,0,0,0,4.5,0,0,4.6,0,0,0),(159,'85.71.100.215',0,0,4.9,0,0,0,0,0,0,4.6,0,4.6,0,0,0,0),(158,'160.125.181.166',0,0,0,4.8,0,0,0,0,0,4.6,0,0,0,4.7,0,0),(48,'63.203.160.21',0,0,0,0,0,0,0,0,0,1.5,0,0,0,0,1.5,0),(49,'149.201.199.233',0,0.6,0,0,0,0,0,0,0,1.6,0,0,0,0,0,0),(46,'9.195.12.154',0,0,0,1.7,0,0,0,0,0,1.7,0,0,0,1.7,0,0),(47,'91.126.151.61',0,0,1.6,0,0,2,0,0,0,1.6,0,0,0,0,1.6,0),(44,'229.31.45.38',0,0,0,1.1,0,0,0,0,1.6,1.6,0,0,0,0,0,0),(45,'129.141.138.119',1.7,0,0,0,0.6,1.5,0,0,0,1.6,0,0,0,0,0,0),(42,'3.131.143.254',1.6,0,0,0,0,0,0,0,1.4,1.5,0,0,0,0,0,0),(43,'17.18.111.145',0,0,0,0,0,0,0,0,0,1.5,0,0,0,1.6,0,0),(40,'119.209.47.58',1.5,0.4,1.5,0,0,0,0,0,0,1.3,0,0,0,0,0,0),(41,'222.65.67.51',0,0,0,0,0,0,0,1.4,0,1.5,1,0,0,0,0,0),(1,'243.12.1.213',0,0,0.3,0,0,0,0,0.3,0,0,0,0,0,0.3,0,0),(5,'2.2.2.2',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.1),(9,'56.195.92.143',0.7,0,0,0.3,0,0,0,0,0,0.5,0.3,0,0,0.6,0,0),(146,'141.56.234.45',0,0,4.2,0,0,0,0,0,4.4,4.2,0,0,0,0,0,0),(147,'5.81.186.49',0,0,0,0,0,0,0,0,0,4.2,4.3,0,0,0,0,0),(144,'168.153.111.194',4.2,0,0,0,0,0,0,0,0,4.1,0,0,0,0,0,0),(145,'165.57.86.101',0,0,0,0,0,0,0,0,0,4.1,0,0,0,4.1,0,4.1),(142,'135.99.182.134',4.1,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0),(143,'81.58.195.224',0,0,0,0,0,0,0,0,0,4.1,0,4.3,0,0,0,0),(140,'9.224.178.70',0,0,4,4,0,4,0,4,0,4,4,0,0,0,4,4),(141,'152.11.194.106',0,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0),(148,'56.105.200.131',4.3,0,0,0,0,0,0,0,0,4.2,0,0,0,0,0,0),(149,'54.27.17.137',0,0,4.5,0,0,0,0,0,0,4.3,0,0,0,0,4.3,0),(77,'208.193.85.97',0,0,0,0,0,0,0,0,0,2.5,0,0,0,0,0,0),(76,'14.233.123.137',2.5,0,0,0,0,0,0,0,0,2.4,0,0,0,2.5,0,0),(75,'144.92.41.3',0,0,0,0,0,2.5,0,0,0,2.4,0,0,0,0,0,2.5),(74,'106.71.208.142',2.4,0,0,0,0,0,0,0,0,2.3,0,0,0,2.4,0,0),(73,'94.192.98.31',0,0,0,2.3,0,0,0,2.4,0,2.3,0,0,0,0,0,0),(72,'173.122.175.88',0,0,2.4,0,0,0,0,0,0,2.3,2.4,0,0,0,0,0),(71,'91.112.13.12',2.3,0,0,0,0,0,0,0,0,2.2,0,0,0,2.2,0,0),(70,'29.132.103.224',0,0,0,2.1,0,0,0,0,0,2.2,0,0,0,0,2.3,0),(79,'207.118.73.177',2.6,0,0,0,0,0,0,0,2.5,2.5,0,2.3,0,0,0,0),(78,'61.169.234.43',0,0,0,0,0,0,0,0,0,2.3,0,0,0,0,0,0);UNLOCK TABLES;