tail Posted October 22, 2009 Share Posted October 22, 2009 I have a counter on my site that tracks hits, IP's, etc. into a mySQL database. It also includes the date in the entry. The code I'm using, that's not working, to try and retrieve the amount of hits in the last 7 days is: $hitsWeek = mysql_result(mysql_query("SELECT SUM(`hits`) FROM `stats` WHERE `date` > '$time-604800' GROUP BY `date`"),0); However, I'm getting this error: Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 10 in /var/www/main.php on line 50 Can anybody help me out with this? It's been stumping me for two days. Quote Link to comment Share on other sites More sharing options...
lemmin Posted October 22, 2009 Share Posted October 22, 2009 I think the variables you are comparing are of different types. What type is your date column? If it is datetime, you can use (NOW() - INTERVAL 1 WEEK) for the minimum date. I think that is the syntax, you might want to check the documentation: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add Quote Link to comment Share on other sites More sharing options...
tail Posted October 22, 2009 Author Share Posted October 22, 2009 The date column is UNIX time which is why I am extracting 604800 seconds (one week) Quote Link to comment Share on other sites More sharing options...
lemmin Posted October 23, 2009 Share Posted October 23, 2009 Oh, I didn't even realize you were using mysql_result(). I'm pretty sure that error just means that no results were returned (since you are using result 0). Check the data that you have and make the dates exist that you are looking for. Quote Link to comment Share on other sites More sharing options...
tail Posted October 24, 2009 Author Share Posted October 24, 2009 I flipped the ">" to a "<". The result came up as 8. However, I did the code but changed the time to a month (2629744 sec), and got the same result. These numbers do not reflect the information in the database. Here is the current code which returns "8": $time = mktime('0','0','0',date('m'),date('d'),date('y')); $hitsWeek = mysql_result(mysql_query("SELECT SUM(`hits`) FROM `stats` WHERE `date` < '$time-604800' GROUP BY `date`"),0); $hitsMonth = mysql_result(mysql_query("SELECT SUM(`hits`) FROM `stats` WHERE `date` > '$time-2629744' GROUP BY `date`"),0); Any help is much appreciated! Quote Link to comment Share on other sites More sharing options...
Philip Posted October 24, 2009 Share Posted October 24, 2009 I think it's because you have the value in quotes, thus not parsing the time. You can use UNIX_TIMESTAMP(): $hitsWeek = mysql_result(mysql_query("SELECT SUM(`hits`) FROM `stats` WHERE `date` < UNIX_TIMESTAMP() - 604800 GROUP BY `date`"),0); $hitsMonth = mysql_result(mysql_query("SELECT SUM(`hits`) FROM `stats` WHERE `date` > UNIX_TIMESTAMP() - 2629744 GROUP BY `date`"),0); Quote Link to comment Share on other sites More sharing options...
tail Posted October 24, 2009 Author Share Posted October 24, 2009 $hitsWeek still comes up as 8 but $hitsMonth comes up as 23. These are not correct values though. Any other reasons the code may not be working? Quote Link to comment Share on other sites More sharing options...
Philip Posted October 24, 2009 Share Posted October 24, 2009 Instead of just getting the result straight from the query, why not try to look at your results (use a while loop) and see exactly what you are retrieving from the db. Quote Link to comment Share on other sites More sharing options...
tail Posted October 24, 2009 Author Share Posted October 24, 2009 I just used an if statement. It was much easier that way. $query = "SELECT `hits`,`date`,`ip` FROM `stats`"; $result = mysql_query($query); $hitsWeek=0; $hitsMonth=0; while ($r=mysql_fetch_array($result)) { if ($r['date'] > $time-604800) { $hitsWeek = $hitsWeek + $r['hits']; } if ($r['date'] > $time-2629744) { $hitsMonth = $hitsMonth + $r['hits']; } } Quote Link to comment Share on other sites More sharing options...
tail Posted October 25, 2009 Author Share Posted October 25, 2009 Is there a way to do this using sql? Or do I have to have PHP sort through the results? Quote Link to comment Share on other sites More sharing options...
Philip Posted October 25, 2009 Share Posted October 25, 2009 You should be able to do it via SQL, let me make a database with sample data and find the correct way. Quote Link to comment Share on other sites More sharing options...
tail Posted October 31, 2009 Author Share Posted October 31, 2009 How's it coming? Quote Link to comment Share on other sites More sharing options...
xtopolis Posted October 31, 2009 Share Posted October 31, 2009 Can you dump your table and sample data instead? Quote Link to comment Share on other sites More sharing options...
tail Posted October 31, 2009 Author Share Posted October 31, 2009 -- phpMyAdmin SQL Dump -- version 3.1.2deb1ubuntu0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 31, 2009 at 01:02 AM -- Server version: 5.0.75 -- PHP Version: 5.2.6-3ubuntu4.2 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `counter` -- CREATE DATABASE `counter` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `counter`; -- -------------------------------------------------------- -- -- Table structure for table `stats` -- CREATE TABLE IF NOT EXISTS `stats` ( `id` int(11) NOT NULL auto_increment, `ip` varchar(15) NOT NULL, `date` varchar(10) NOT NULL default '0', `hits` int(10) NOT NULL default '1', `online` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=692 ; -- -- Dumping data for table `stats` -- INSERT INTO `stats` (`id`, `ip`, `date`, `hits`, `online`) VALUES (1, '67.81.64.58', '1238299200', 2, '1238383090'), (2, '173.3.254.115', '1238299200', 2, '1238354313'), (3, '72.30.142.246', '1238299200', 1, '1238360710'), (4, '66.249.70.250', '1238299200', 1, '1238373089'), (5, '67.195.37.183', '1238299200', 1, '1238374361'), (6, '72.130.28.234', '1238299200', 1, '1238385489'), (7, '67.81.64.58', '1238385600', 1, '1238388098'), (8, '67.195.37.183', '1238385600', 5, '1238417565'), (9, '72.30.142.246', '1238385600', 11, '1238426909'), (10, '64.55.144.24', '1238385600', 2, '1238413510'), (11, '72.30.142.246', '1238644800', 20, '1238728383'), (12, '66.249.70.250', '1238385600', 1, '1238426934'), (13, '70.18.93.35', '1238472000', 1, '1238524170'), (14, '72.30.142.246', '1238472000', 1, '1238543224'), (15, '64.55.144.20', '1238472000', 4, '1238516565'), (16, '173.3.254.115', '1238472000', 8, '1238550366'), (17, '67.195.37.183', '1238472000', 3, '1238557614'), (18, '93.158.149.32', '1238472000', 1, '1238551636'), (19, '67.81.64.58', '1238558400', 3, '1238632843'), (20, '72.30.142.246', '1238558400', 6, '1238613373'), (21, '67.195.37.183', '1238558400', 5, '1238629560'), (22, '66.249.71.85', '1238558400', 28, '1238639128'), (23, '70.18.93.35', '1238558400', 9, '1238589496'), (24, '64.55.144.23', '1238558400', 5, '1238597192'), (25, '70.18.93.157', '1238558400', 1, '1238603721'), (26, '66.249.66.84', '1238558400', 1, '1238598759'), (27, '64.55.144.20', '1238558400', 6, '1238599422'), (28, '64.55.144.24', '1238558400', 2, '1238604963'), (29, '173.3.254.115', '1238558400', 7, '1238617495'), (30, '92.48.193.55', '1238558400', 1, '1238620887'), (31, '66.249.65.18', '1238558400', 1, '1238628149'), (32, '67.195.37.183', '1238644800', 8, '1238703073'), (33, '70.18.93.157', '1238644800', 2, '1238689996'), (34, '64.55.144.12', '1238644800', 8, '1238675754'), (35, '64.55.144.11', '1238644800', 4, '1238681225'), (36, '66.249.71.85', '1238644800', 1, '1238725900'), (37, '67.195.37.183', '1238731200', 2, '1238742690'), (38, '72.30.142.246', '1238731200', 14, '1238798689'), (39, '70.18.93.157', '1238731200', 14, '1238783379'), (40, '67.81.64.58', '1238990400', 1, '1239031611'), (41, '74.6.22.168', '1238990400', 13, '1239076273'), (42, '70.18.93.157', '1238990400', 3, '1239039543'), (43, '173.3.254.115', '1238990400', 1, '1239056179'), (44, '67.195.37.186', '1238990400', 14, '1239075043'), (45, '67.195.37.186', '1239076800', 16, '1239162591'), (46, '66.249.66.106', '1239076800', 1, '1239082133'), (47, '74.6.22.168', '1239076800', 19, '1239106884'), (48, '70.18.93.157', '1239076800', 7, '1239122815'), (49, '74.6.22.160', '1239076800', 9, '1239140278'), (50, '64.55.144.39', '1239076800', 1, '1239114765'), (51, '64.55.144.23', '1239076800', 2, '1239122304'), (52, '67.195.37.186', '1239163200', 5, '1239211712'), (53, '74.6.22.160', '1239163200', 41, '1239246912'), (54, '70.18.93.157', '1239163200', 10, '1239215483'), (55, '64.55.144.23', '1239163200', 1, '1239201734'), (56, '64.55.144.40', '1239163200', 1, '1239207079'), (57, '67.195.37.97', '1239163200', 1, '1239216780'), (58, '173.3.254.115', '1239163200', 3, '1239228831'), (59, '173.54.3.61', '1239163200', 1, '1239227335'), (60, '66.249.71.79', '1239163200', 1, '1239236206'), (61, '74.6.22.160', '1239249600', 33, '1239330382'), (62, '66.249.71.79', '1239249600', 1, '1239255789'), (63, '70.18.93.157', '1239249600', 7, '1239297532'), (64, '64.55.144.23', '1239249600', 1, '1239282929'), (65, '93.158.149.32', '1239249600', 1, '1239315304'), (66, '74.6.22.160', '1239336000', 13, '1239374493'), (67, '74.6.18.228', '1239336000', 14, '1239420285'), (68, '74.6.18.228', '1239422400', 17, '1239505458'), (69, '66.249.71.79', '1239422400', 2, '1239503879'), (70, '67.81.43.94', '1239422400', 1, '1239506231'), (71, '74.6.18.228', '1239508800', 12, '1239565746'), (72, '74.6.18.217', '1239595200', 5, '1239618589'), (73, '127.0.0.1', '1240027200', 1, '1240069375'), (74, '67.81.74.110', '1240027200', 2, '1240069964'), (75, '67.80.25.147', '1240027200', 1, '1240085183'), (76, '74.6.18.217', '1240027200', 2, '1240111695'), (77, '67.81.39.200', '1240027200', 1, '1240107474'), (78, '74.6.18.217', '1240113600', 14, '1240186142'), (79, '66.249.71.169', '1240113600', 1, '1240126206'), (80, '93.158.149.32', '1240113600', 1, '1240180073'), (81, '74.6.18.217', '1240200000', 14, '1240279870'), (82, '64.55.144.43', '1240200000', 1, '1240227119'), (83, '70.18.93.157', '1240200000', 12, '1240249453'), (84, '66.249.71.169', '1240286400', 3, '1240336978'), (85, '74.6.18.217', '1240286400', 17, '1240365360'), (86, '70.18.93.157', '1240286400', 9, '1240330560'), (87, '74.6.18.217', '1240372800', 9, '1240449859'), (88, '74.6.17.173', '1240372800', 1, '1240394345'), (89, '70.18.93.157', '1240372800', 4, '1240421215'), (90, '64.55.144.41', '1240372800', 1, '1240413703'), (91, '93.158.149.32', '1240459200', 1, '1240461613'), (92, '74.6.18.217', '1240459200', 32, '1240544051'), (93, '70.18.93.157', '1240459200', 11, '1240511480'), (94, '74.6.18.217', '1240545600', 12, '1240610637'), (95, '70.18.93.157', '1240545600', 12, '1240594375'), (96, '74.6.18.217', '1240632000', 15, '1240716868'), (97, '74.105.164.91', '1240632000', 1, '1240691083'), (98, '93.158.149.32', '1240632000', 1, '1240700094'), (99, '72.79.112.218', '1240632000', 2, '1240711811'), (100, '92.48.193.55', '1240632000', 1, '1240712364'), (101, '173.3.254.115', '1240718400', 1, '1240719712'), (102, '74.6.18.217', '1240718400', 9, '1240793275'), (103, '74.105.164.91', '1240718400', 6, '1240785596'), (104, '74.6.18.217', '1240804800', 27, '1240877863'), (105, '70.18.93.157', '1240804800', 2, '1240854168'), (106, '64.55.144.39', '1240804800', 1, '1240845190'), (107, '64.55.144.11', '1240804800', 1, '1240849130'), (108, '74.6.18.217', '1240891200', 13, '1240974222'), (109, '70.18.93.157', '1240891200', 5, '1240932180'), (110, '64.55.144.26', '1240891200', 1, '1240935993'), (111, '173.3.254.115', '1240891200', 1, '1240951042'), (112, '74.6.18.217', '1240977600', 20, '1241032549'), (113, '70.18.93.157', '1240977600', 3, '1241019628'), (114, '72.30.65.27', '1240977600', 2, '1241055050'), (115, '72.30.65.27', '1241064000', 34, '1241150219'), (116, '66.249.67.72', '1241064000', 1, '1241077667'), (117, '70.18.93.157', '1241064000', 11, '1241110928'), (118, '64.55.144.26', '1241064000', 1, '1241095008'), (119, '68.197.99.68', '1241064000', 1, '1241141204'), (120, '72.30.65.27', '1241150400', 30, '1241236319'), (121, '66.249.67.72', '1241150400', 1, '1241170054'), (122, '70.18.93.157', '1241150400', 9, '1241199248'), (123, '72.79.112.218', '1241150400', 1, '1241208308'), (124, '72.30.65.27', '1241214998', 1, '1241214998'), (125, '67.81.79.160', '1241215663', 1, '1241215663'), (126, '74.105.164.91', '1241150400', 1, '1241220903'), (127, '72.30.65.27', '1241236800', 9, '1241301007'), (128, '74.105.164.91', '1241236800', 3, '1241297313'), (129, '66.249.67.72', '1241236800', 1, '1241321652'), (130, '72.30.65.25', '1241323200', 9, '1241404083'), (131, '93.158.149.32', '1241323200', 1, '1241353812'), (132, '74.105.164.91', '1241323200', 3, '1241395221'), (133, '72.79.112.218', '1241323200', 2, '1241376336'), (134, '72.30.65.25', '1241409600', 11, '1241483252'), (135, '70.18.93.157', '1241409600', 14, '1241460599'), (136, '64.55.144.39', '1241409600', 1, '1241454457'), (137, '212.117.188.207', '1241409600', 2, '1241494488'), (138, '194.38.128.45', '1241409600', 1, '1241494487'), (139, '170.223.0.55', '1241409600', 1, '1241494924'), (140, '72.30.65.25', '1241496000', 13, '1241579504'), (141, '70.18.93.157', '1241496000', 15, '1241547778'), (142, '64.55.144.40', '1241496000', 1, '1241527629'), (143, '173.3.254.115', '1241496000', 1, '1241565895'), (144, '72.30.65.25', '1241582400', 8, '1241668096'), (145, '70.18.93.157', '1241582400', 10, '1241628244'), (146, '64.55.144.40', '1241582400', 1, '1241617404'), (147, '64.55.144.41', '1241582400', 1, '1241620802'), (150, '92.48.193.55', '1241668800', 1, '1241676880'), (149, '74.105.164.91', '1241582400', 1, '1241656326'), (151, '70.18.93.157', '1241668800', 15, '1241716625'), (152, '72.30.65.25', '1241668800', 15, '1241745852'), (153, '64.55.144.39', '1241668800', 1, '1241712851'), (154, '67.81.103.62', '1241668800', 2, '1241750215'), (155, '74.105.164.91', '1241668800', 3, '1241741638'), (156, '173.3.254.115', '1241668800', 1, '1241746383'), (157, '72.30.65.25', '1241755200', 20, '1241796465'), (158, '70.18.93.157', '1241755200', 12, '1241807075'), (159, '64.55.144.41', '1241755200', 1, '1241787202'), (160, '74.6.22.90', '1241755200', 3, '1241796889'), (161, '74.6.18.232', '1241755200', 2, '1241800763'), (162, '72.30.142.237', '1241755200', 2, '1241812050'), (163, '74.125.75.17', '1241755200', 4, '1241815998'), (164, '67.81.74.110', '1241755200', 1, '1241818853'), (165, '74.6.17.156', '1241755200', 2, '1241821102'), (166, '72.30.79.114', '1241755200', 1, '1241833361'), (167, '72.30.65.48', '1241755200', 1, '1241837842'), (168, '72.30.79.96', '1241841600', 23, '1241925779'), (169, '92.48.193.55', '1241841600', 1, '1241844122'), (170, '74.105.164.91', '1241841600', 2, '1241906276'), (171, '67.81.103.62', '1241841600', 1, '1241925248'), (172, '74.105.164.91', '1241928000', 1, '1241930339'), (173, '93.158.149.32', '1241928000', 1, '1241934468'), (174, '67.81.74.110', '1241928000', 1, '1241934516'), (175, '72.30.79.96', '1241928000', 1, '1241937905'), (176, '72.30.79.126', '1241928000', 15, '1241995096'), (177, '173.54.10.213', '1241928000', 3, '1241975178'), (178, '67.81.103.62', '1241928000', 3, '1242001520'), (179, '173.3.254.115', '1241928000', 1, '1241986416'), (180, '72.30.79.126', '1242014400', 27, '1242095648'), (181, '74.222.3.186', '1242014400', 1, '1242028197'), (182, '70.18.93.157', '1242014400', 14, '1242064510'), (183, '173.3.254.115', '1242014400', 1, '1242085164'), (184, '67.81.103.62', '1242014400', 1, '1242091435'), (185, '68.197.99.125', '1242014400', 1, '1242093602'), (186, '72.30.79.126', '1242100800', 18, '1242160409'), (187, '70.18.93.157', '1242100800', 24, '1242153115'), (188, '67.81.103.62', '1242100800', 2, '1242174181'), (189, '74.6.18.219', '1242100800', 2, '1242175784'), (190, '74.105.164.91', '1242100800', 1, '1242168435'), (191, '173.3.254.115', '1242100800', 1, '1242181601'), (192, '74.6.18.219', '1242187200', 9, '1242261878'), (193, '93.158.149.32', '1242187200', 1, '1242195491'), (194, '70.18.93.157', '1242187200', 14, '1242235358'), (195, '64.55.144.26', '1242187200', 1, '1242223360'), (196, '64.55.144.39', '1242187200', 1, '1242234267'), (197, '67.81.75.195', '1242187200', 1, '1242262146'), (198, '67.81.103.62', '1242187200', 1, '1242266160'), (199, '74.105.164.253', '1242273600', 1, '1242292799'), (200, '74.6.18.219', '1242273600', 20, '1242359174'), (201, '70.18.93.157', '1242273600', 23, '1242327118'), (202, '64.55.144.41', '1242273600', 2, '1242318987'), (203, '64.55.144.26', '1242273600', 1, '1242316166'), (204, '67.81.103.62', '1242273600', 2, '1242343294'), (205, '74.6.18.219', '1242360000', 21, '1242438570'), (206, '74.105.164.91', '1242360000', 3, '1242424688'), (207, '74.6.22.160', '1242360000', 1, '1242376927'), (208, '70.18.93.157', '1242360000', 18, '1242411065'), (209, '64.55.144.11', '1242360000', 1, '1242392895'), (210, '72.30.142.177', '1242360000', 1, '1242399651'), (211, '93.158.149.32', '1242360000', 1, '1242426440'), (212, '67.81.72.80', '1242446400', 1, '1242448974'), (213, '74.6.18.219', '1242446400', 16, '1242499228'), (214, '67.81.103.62', '1242446400', 1, '1242450881'), (215, '68.197.217.51', '1242446400', 2, '1242509492'), (216, '72.30.142.171', '1242446400', 4, '1242519821'), (217, '67.81.74.110', '1242532800', 1, '1242571631'), (218, '72.30.142.171', '1242532800', 15, '1242616264'), (219, '74.105.164.91', '1242532800', 3, '1242616963'), (220, '72.30.142.171', '1242619200', 2, '1242627296'), (221, '72.30.78.216', '1242619200', 19, '1242700097'), (222, '70.18.93.157', '1242619200', 16, '1242670945'), (223, '64.55.144.11', '1242619200', 1, '1242649961'), (224, '68.197.217.51', '1242619200', 1, '1242671988'), (225, '93.158.149.32', '1242619200', 1, '1242680336'), (226, '72.30.78.216', '1242705600', 20, '1242790700'), (227, '70.18.93.157', '1242705600', 10, '1242759418'), (228, '74.105.164.91', '1242705600', 1, '1242742989'), (229, '173.54.9.129', '1242705600', 1, '1242787172'), (230, '72.30.78.216', '1242792000', 7, '1242851891'), (231, '70.18.93.157', '1242792000', 16, '1242843801'), (232, '64.55.144.11', '1242792000', 1, '1242837292'), (233, '74.105.164.91', '1242792000', 1, '1242862889'), (234, '67.81.74.110', '1242792000', 1, '1242864004'), (235, '76.2.65.251', '1242792000', 1, '1242864020'), (236, '67.81.74.110', '1242878400', 1, '1242879229'), (237, '72.20.109.62', '1242878400', 4, '1242882512'), (238, '72.30.78.216', '1242878400', 10, '1242960610'), (239, '70.18.93.157', '1242878400', 9, '1242927593'), (240, '64.55.144.26', '1242878400', 1, '1242923541'), (241, '72.30.78.216', '1242964800', 15, '1243043749'), (242, '70.18.93.157', '1242964800', 12, '1243017332'), (243, '64.55.144.11', '1242964800', 1, '1242992913'), (244, '173.70.205.89', '1242964800', 1, '1243031185'), (245, '67.81.103.62', '1242964800', 2, '1243048670'), (246, '72.30.78.216', '1243051200', 10, '1243120259'), (247, '173.70.205.89', '1243051200', 2, '1243123892'), (248, '24.0.83.172', '1243051200', 1, '1243119696'), (249, '71.225.41.233', '1243051200', 1, '1243130888'), (250, '67.81.74.110', '1243137600', 1, '1243177355'), (251, '71.225.41.233', '1243137600', 1, '1243184834'), (252, '72.30.78.216', '1243137600', 5, '1243211543'), (253, '173.54.8.127', '1243137600', 1, '1243216044'), (254, '68.197.217.51', '1243224000', 3, '1243293903'), (255, '72.30.78.216', '1243224000', 23, '1243306043'), (256, '67.81.74.110', '1243224000', 2, '1243264506'), (257, '24.0.83.172', '1243224000', 1, '1243271005'), (258, '72.30.78.216', '1243310400', 31, '1243396006'), (259, '70.18.93.157', '1243310400', 17, '1243359928'), (260, '64.55.144.43', '1243310400', 1, '1243346309'), (261, '64.55.144.11', '1243310400', 1, '1243357098'), (262, '195.190.13.226', '1243310400', 12, '1243366734'), (263, '68.197.217.51', '1243310400', 1, '1243380432'), (264, '74.105.27.2', '1243310400', 1, '1243389936'), (265, '72.30.78.216', '1243396800', 23, '1243474257'), (266, '70.18.93.157', '1243396800', 13, '1243447044'), (267, '64.55.144.26', '1243396800', 1, '1243435831'), (268, '74.105.164.253', '1243396800', 1, '1243478264'), (269, '72.30.78.216', '1243483200', 7, '1243553536'), (270, '93.158.145.27', '1243483200', 1, '1243507017'), (271, '70.18.93.157', '1243483200', 19, '1243534916'), (272, '64.55.144.41', '1243483200', 1, '1243510882'), (273, '64.55.144.42', '1243483200', 2, '1243527268'), (274, '64.55.144.40', '1243483200', 1, '1243516801'), (275, '67.81.98.40', '1243483200', 1, '1243528300'), (276, '67.81.103.62', '1243483200', 1, '1243560357'), (277, '72.30.78.216', '1243569600', 8, '1243641137'), (278, '70.18.93.157', '1243569600', 17, '1243617937'), (279, '64.55.144.41', '1243569600', 1, '1243599584'), (280, '67.81.103.62', '1243569600', 2, '1243632049'), (281, '64.55.144.40', '1243569600', 1, '1243620619'), (282, '66.249.71.219', '1243569600', 1, '1243648040'), (283, '72.30.78.216', '1243656000', 10, '1243736988'), (284, '93.158.145.27', '1243742400', 1, '1243764886'), (285, '67.81.103.62', '1243742400', 2, '1243815208'), (286, '173.54.3.208', '1243742400', 1, '1243799626'), (287, '72.30.78.216', '1243742400', 2, '1243807619'), (288, '66.249.71.219', '1243828800', 1, '1243828934'), (289, '70.18.93.157', '1243828800', 18, '1243880174'), (290, '72.30.78.216', '1243828800', 8, '1243914009'), (291, '64.55.144.43', '1243828800', 1, '1243869716'), (292, '67.81.103.62', '1243828800', 1, '1243900392'), (293, '72.30.78.216', '1243915200', 16, '1243999156'), (294, '70.18.93.157', '1243915200', 18, '1243966006'), (295, '64.55.144.42', '1243915200', 1, '1243950530'), (296, '217.98.8.17', '1243915200', 1, '1243974436'), (297, '221.11.44.5', '1243915200', 1, '1243978089'), (298, '70.18.93.157', '1244001600', 13, '1244052817'), (299, '64.55.144.41', '1244001600', 1, '1244033173'), (300, '72.30.78.216', '1244001600', 13, '1244080893'), (301, '67.81.103.62', '1244001600', 2, '1244081067'), (302, '192.168.1.150', '1244001600', 1, '1244073318'), (303, '72.30.78.216', '1244088000', 21, '1244171955'), (304, '93.158.145.27', '1244088000', 1, '1244112948'), (305, '70.18.93.157', '1244088000', 19, '1244139765'), (306, '64.55.144.42', '1244088000', 2, '1244127202'), (307, '72.30.78.216', '1244174400', 25, '1244258626'), (308, '89.149.226.14', '1244174400', 1, '1244182493'), (309, '70.18.93.157', '1244174400', 11, '1244225470'), (310, '64.55.144.26', '1244174400', 1, '1244218371'), (311, '64.55.144.11', '1244174400', 1, '1244223286'), (312, '67.81.103.62', '1244174400', 2, '1244238785'), (313, '66.249.68.131', '1244174400', 1, '1244236162'), (314, '72.30.78.216', '1244260800', 21, '1244345238'), (315, '67.81.103.62', '1244260800', 6, '1244347159'), (316, '92.48.193.55', '1244260800', 1, '1244280919'), (317, '93.158.145.27', '1244260800', 1, '1244289947'), (318, '74.105.168.74', '1244260800', 2, '1244343070'), (319, '208.122.4.142', '1244260800', 1, '1244324557'), (320, '67.81.74.110', '1244260800', 1, '1244324621'), (341, '38.117.180.242', '1244433600', 1, '1244484576'), (322, '210.19.78.131', '1244347200', 1, '1244386757'), (323, '89.149.226.14', '1244347200', 1, '1244386766'), (324, '74.105.168.74', '1244347200', 3, '1244415330'), (325, '88.109.177.199', '1244347200', 1, '1244390231'), (326, '67.81.74.110', '1244347200', 1, '1244390338'), (327, '24.247.189.227', '1244347200', 1, '1244391494'), (328, '70.49.138.165', '1244347200', 2, '1244393782'), (329, '128.30.52.70', '1244347200', 7, '1244398360'), (330, '128.30.52.72', '1244347200', 2, '1244398064'), (331, '67.81.103.62', '1244347200', 2, '1244420666'), (332, '65.12.230.11', '1244347200', 1, '1244408468'), (333, '210.1.208.129', '1244347200', 1, '1244420129'), (334, '173.54.3.148', '1244347200', 2, '1244422486'), (335, '69.123.14.234', '1244347200', 1, '1244424800'), (336, '67.81.74.110', '1244433600', 1, '1244433646'), (337, '74.6.18.219', '1244433600', 25, '1244519908'), (338, '70.18.93.157', '1244433600', 15, '1244484541'), (339, '82.44.4.148', '1244433600', 1, '1244463725'), (340, '64.55.144.42', '1244433600', 1, '1244466368'), (342, '67.81.103.62', '1244433600', 3, '1244510040'), (343, '64.244.140.11', '1244433600', 1, '1244496235'), (344, '70.106.94.161', '1244433600', 1, '1244508457'), (345, '67.81.74.110', '1244520000', 1, '1244520077'), (346, '74.6.18.219', '1244520000', 32, '1244605938'), (347, '72.30.81.174', '1244520000', 1, '1244528017'), (348, '94.197.208.148', '1244520000', 1, '1244534673'), (349, '78.148.15.192', '1244520000', 1, '1244537427'), (350, '70.18.93.157', '1244520000', 14, '1244569376'), (351, '64.56.65.44', '1244520000', 1, '1244552905'), (352, '92.48.193.55', '1244520000', 1, '1244555803'), (353, '67.81.103.62', '1244520000', 3, '1244599678'), (354, '74.6.18.219', '1244606400', 19, '1244692155'), (355, '70.18.93.157', '1244606400', 17, '1244657646'), (356, '64.55.144.40', '1244606400', 2, '1244643904'), (357, '67.81.103.62', '1244606400', 4, '1244679772'), (358, '93.158.145.27', '1244606400', 1, '1244661522'), (359, '67.81.74.110', '1244606400', 1, '1244665554'), (360, '173.32.13.241', '1244606400', 1, '1244667767'), (361, '62.1.235.137', '1244606400', 1, '1244677382'), (362, '74.6.18.219', '1244692800', 13, '1244778055'), (363, '68.62.167.90', '1244692800', 1, '1244699854'), (364, '70.18.93.157', '1244692800', 30, '1244742547'), (365, '64.55.144.42', '1244692800', 1, '1244731978'), (366, '64.55.144.41', '1244692800', 1, '1244733837'), (367, '64.55.144.39', '1244692800', 1, '1244734389'), (368, '67.81.78.13', '1244692800', 2, '1244752803'), (369, '74.105.117.253', '1244692800', 1, '1244752907'), (370, '67.81.77.151', '1244692800', 1, '1244759562'), (371, '67.81.103.62', '1244692800', 1, '1244760302'), (372, '74.6.18.219', '1244779200', 12, '1244838891'), (373, '220.233.181.76', '1244779200', 1, '1244792759'), (374, '70.18.93.157', '1244779200', 9, '1244824519'), (375, '64.55.144.11', '1244779200', 5, '1244825003'), (376, '64.55.144.40', '1244779200', 3, '1244818048'), (377, '64.55.144.42', '1244779200', 1, '1244813760'), (378, '64.55.144.41', '1244779200', 2, '1244818545'), (379, '64.55.144.26', '1244779200', 2, '1244829803'), (380, '64.55.144.43', '1244779200', 1, '1244830626'), (381, '192.168.1.150', '1244865600', 1, '1244913286'), (382, '67.81.74.110', '1244865600', 2, '1244922991'), (383, '173.54.11.229', '1244865600', 1, '1244925729'), (384, '74.105.168.74', '1244865600', 1, '1244940329'), (385, '64.55.144.11', '1245038400', 1, '1245065355'), (386, '70.18.93.157', '1245038400', 6, '1245084108'), (387, '64.55.144.43', '1245038400', 1, '1245065888'), (388, '64.55.144.26', '1245038400', 1, '1245071964'), (389, '64.55.144.39', '1245038400', 1, '1245072411'), (390, '64.55.144.42', '1245038400', 1, '1245076320'), (391, '192.168.1.150', '1245038400', 1, '1245112213'), (392, '67.81.74.110', '1245038400', 1, '1245112226'), (393, '64.55.144.11', '1245124800', 3, '1245158656'), (394, '64.55.144.42', '1245124800', 2, '1245155204'), (395, '64.55.144.40', '1245124800', 2, '1245165352'), (396, '67.81.103.62', '1245124800', 2, '1245202160'), (397, '74.105.117.253', '1245124800', 2, '1245199008'), (398, '67.81.74.110', '1245124800', 1, '1245208534'), (399, '74.105.117.253', '1245211200', 3, '1245273118'), (400, '70.18.93.157', '1245211200', 3, '1245253682'), (401, '64.55.144.39', '1245211200', 1, '1245246983'), (402, '64.55.144.43', '1245211200', 1, '1245257338'), (403, '64.55.144.11', '1245211200', 1, '1245259547'), (404, '67.81.103.62', '1245211200', 1, '1245269589'), (405, '70.18.93.157', '1245297600', 3, '1245329661'), (406, '64.55.144.43', '1245297600', 2, '1245334814'), (407, '64.55.144.40', '1245297600', 3, '1245340753'), (408, '64.55.144.26', '1245297600', 1, '1245327981'), (409, '64.55.144.42', '1245297600', 2, '1245345754'), (410, '64.55.144.11', '1245297600', 1, '1245334236'), (411, '67.81.103.62', '1245297600', 2, '1245370242'), (412, '64.55.144.40', '1245384000', 3, '1245428700'), (413, '70.18.93.157', '1245384000', 1, '1245414948'), (414, '64.55.144.41', '1245384000', 1, '1245414985'), (415, '64.55.144.11', '1245384000', 1, '1245431382'), (416, '67.81.103.62', '1245384000', 2, '1245465126'), (417, '68.230.252.131', '1245470400', 1, '1245525038'), (418, '67.81.103.62', '1245470400', 4, '1245556255'), (419, '74.105.27.170', '1245470400', 3, '1245554006'), (420, '74.105.27.170', '1245556800', 2, '1245635353'), (421, '67.81.74.110', '1245556800', 2, '1245633597'), (422, '67.81.103.62', '1245556800', 1, '1245638359'), (423, '64.55.144.26', '1245643200', 2, '1245675604'), (424, '67.81.103.62', '1245643200', 5, '1245727364'), (425, '70.18.93.157', '1245643200', 2, '1245685260'), (426, '64.55.144.40', '1245643200', 1, '1245682602'), (427, '64.55.144.42', '1245729600', 2, '1245769347'), (428, '64.55.144.11', '1245729600', 1, '1245770468'), (429, '70.18.93.157', '1245729600', 1, '1245770830'), (430, '67.81.103.62', '1245729600', 3, '1245804935'), (431, '74.105.27.170', '1245729600', 2, '1245808782'), (432, '70.18.93.157', '1245816000', 2, '1245845551'), (433, '64.55.144.41', '1245816000', 1, '1245845571'), (434, '64.55.144.40', '1245816000', 1, '1245847714'), (435, '67.81.103.62', '1245816000', 3, '1245895569'), (436, '67.81.74.110', '1245816000', 1, '1245863462'), (437, '74.105.168.74', '1245816000', 1, '1245873488'), (438, '74.105.117.253', '1245816000', 1, '1245891422'), (439, '192.168.1.150', '1245816000', 1, '1245891936'), (440, '67.81.103.62', '1245902400', 5, '1245987063'), (441, '70.18.93.157', '1245902400', 1, '1245930236'), (442, '64.55.144.43', '1245902400', 1, '1245933965'), (443, '67.81.78.47', '1245902400', 1, '1245936825'), (444, '67.81.103.62', '1245988800', 4, '1246062496'), (445, '74.105.168.74', '1245988800', 1, '1246039985'), (446, '67.81.103.62', '1246075200', 1, '1246161330'), (447, '74.105.168.74', '1246161600', 2, '1246216503'), (448, '67.81.103.62', '1246161600', 3, '1246244468'), (449, '67.81.103.62', '1246248000', 4, '1246334063'), (450, '67.81.103.62', '1246334400', 2, '1246420417'), (451, '74.105.168.74', '1246334400', 1, '1246398265'), (452, '67.81.103.62', '1246420800', 4, '1246500959'), (453, '67.81.103.62', '1246507200', 6, '1246593026'), (454, '72.63.233.156', '1246680000', 1, '1246713397'), (455, '67.81.103.62', '1246766400', 2, '1246849621'), (456, '67.81.74.110', '1246852800', 1, '1246854265'), (457, '67.81.103.62', '1246852800', 3, '1246933006'), (458, '67.81.103.62', '1247025600', 1, '1247107178'), (459, '173.54.9.57', '1247025600', 1, '1247109905'), (460, '67.81.103.62', '1247112000', 1, '1247196769'), (461, '67.81.103.62', '1248667200', 5, '1248750309'), (462, '67.81.103.62', '1248753600', 1, '1248805059'), (463, '67.81.103.62', '1248840000', 1, '1248894989'), (464, '67.81.103.62', '1248926400', 1, '1248926815'), (465, '67.81.103.62', '1249012800', 2, '1249097633'), (466, '67.81.103.62', '1249185600', 1, '1249189612'), (467, '98.109.84.152', '1249185600', 1, '1249228552'), (468, '173.70.205.151', '1249272000', 1, '1249333446'), (469, '67.81.103.62', '1249272000', 1, '1249353993'), (470, '68.197.216.80', '1249358400', 1, '1249417520'), (471, '67.81.103.62', '1249531200', 1, '1249617092'), (472, '67.81.103.62', '1249876800', 1, '1249877154'), (473, '67.81.103.62', '1250136000', 2, '1250144730'), (474, '192.168.1.150', '1250654400', 1, '1250656800'), (475, '67.81.103.62', '1250654400', 2, '1250734349'), (476, '67.81.103.62', '1250740800', 1, '1250796142'), (477, '67.81.103.62', '1250827200', 1, '1250910403'), (478, '67.81.103.62', '1251000000', 1, '1251084262'), (479, '67.81.103.62', '1251432000', 1, '1251445030'), (480, '192.168.1.150', '1252123200', 1, '1252167930'), (481, '70.18.93.157', '1252382400', 6, '1252430949'), (482, '199.79.170.215', '1252382400', 1, '1252421749'), (483, '70.18.93.157', '1252468800', 4, '1252512505'), (484, '74.115.1.22', '1252468800', 1, '1252511562'), (485, '199.79.168.215', '1252555200', 1, '1252557169'), (486, '70.18.93.157', '1252555200', 3, '1252606090'), (487, '74.115.0.2', '1252555200', 1, '1252590853'), (488, '74.115.0.10', '1252555200', 1, '1252597637'), (489, '199.79.170.215', '1252555200', 1, '1252605159'), (490, '67.81.77.151', '1252555200', 1, '1252630381'), (491, '70.18.93.157', '1252641600', 6, '1252692775'), (492, '74.115.1.23', '1252641600', 1, '1252669704'), (493, '74.115.0.2', '1252641600', 1, '1252689227'), (494, '67.81.103.62', '1252728000', 1, '1252813721'), (495, '70.18.93.157', '1252900800', 4, '1252944287'), (496, '74.115.0.10', '1252900800', 1, '1252931748'), (497, '70.18.93.157', '1252987200', 4, '1253029287'), (498, '67.81.98.141', '1252987200', 1, '1253057616'), (499, '150.250.123.30', '1252987200', 1, '1253057664'), (500, '199.79.170.215', '1253073600', 1, '1253078165'), (501, '70.18.93.157', '1253073600', 4, '1253123458'), (502, '74.115.1.6', '1253073600', 1, '1253101683'), (503, '70.18.93.157', '1253160000', 7, '1253205273'), (504, '74.115.0.10', '1253160000', 1, '1253205558'), (505, '199.79.168.215', '1253160000', 1, '1253236594'), (506, '199.79.170.215', '1253246400', 2, '1253321010'), (507, '70.18.93.157', '1253246400', 5, '1253288519'), (508, '74.115.1.22', '1253246400', 1, '1253276790'), (509, '68.197.102.215', '1253246400', 2, '1253328401'), (510, '199.79.170.215', '1253332800', 3, '1253405187'), (511, '199.79.168.215', '1253332800', 1, '1253405384'), (512, '173.54.13.236', '1253419200', 1, '1253464170'), (513, '69.115.207.253', '1253419200', 1, '1253470484'), (514, '199.79.168.215', '1253419200', 1, '1253477963'), (515, '70.18.93.157', '1253505600', 2, '1253540066'), (516, '74.115.1.23', '1253505600', 1, '1253548058'), (517, '74.115.0.10', '1253505600', 1, '1253555463'), (518, '74.115.0.2', '1253505600', 1, '1253557222'), (519, '70.18.93.157', '1253592000', 3, '1253633955'), (520, '74.115.0.10', '1253592000', 2, '1253623170'), (521, '74.115.1.23', '1253592000', 1, '1253623723'), (522, '74.115.1.6', '1253592000', 1, '1253627280'), (523, '173.54.3.161', '1253592000', 1, '1253652008'), (524, '67.81.44.204', '1253592000', 1, '1253668745'), (525, '70.18.93.157', '1253678400', 9, '1253731131'), (526, '74.115.1.6', '1253678400', 2, '1253727954'), (527, '74.115.1.23', '1253678400', 1, '1253716566'), (528, '67.81.44.204', '1253678400', 2, '1253764389'), (529, '67.81.69.33', '1253764800', 3, '1253837802'), (530, '70.18.93.157', '1253764800', 15, '1253817373'), (531, '74.115.1.23', '1253764800', 2, '1253808032'), (532, '74.115.1.5', '1253764800', 1, '1253805360'), (533, '67.81.44.204', '1253764800', 2, '1253844191'), (534, '70.18.93.157', '1253851200', 14, '1253901572'), (535, '74.115.1.6', '1253851200', 3, '1253901453'), (536, '74.115.1.23', '1253851200', 1, '1253889486'), (537, '74.115.0.10', '1253851200', 1, '1253892432'), (538, '74.115.1.7', '1253851200', 2, '1253899888'), (539, '74.115.1.22', '1253851200', 1, '1253896061'), (540, '67.81.64.53', '1253851200', 1, '1253916768'), (541, '67.81.69.33', '1253851200', 1, '1253922596'), (542, '67.81.44.204', '1253937600', 2, '1253989752'), (543, '173.63.127.223', '1253937600', 1, '1253984069'), (544, '67.81.69.33', '1253937600', 1, '1254002210'), (545, '96.242.220.41', '1253937600', 1, '1254017903'), (546, '67.81.37.253', '1254024000', 1, '1254072150'), (547, '67.81.39.81', '1254024000', 1, '1254073964'), (548, '67.81.74.110', '1254024000', 1, '1254084852'), (549, '67.81.44.204', '1254024000', 2, '1254090235'), (550, '98.113.168.45', '1254024000', 1, '1254103775'), (551, '98.113.168.45', '1254110400', 1, '1254110614'), (552, '67.81.75.195', '1254110400', 1, '1254111643'), (553, '67.81.74.110', '1254110400', 3, '1254191923'), (554, '70.18.93.157', '1254110400', 1, '1254144777'), (555, '67.81.44.204', '1254110400', 4, '1254189684'), (556, '70.18.93.157', '1254196800', 9, '1254243821'), (557, '74.115.1.23', '1254196800', 1, '1254231529'), (558, '67.81.74.110', '1254196800', 3, '1254256959'), (559, '67.81.44.204', '1254196800', 4, '1254279025'), (560, '74.115.0.10', '1254283200', 2, '1254322551'), (561, '74.115.1.7', '1254283200', 1, '1254315314'), (562, '70.18.93.157', '1254283200', 15, '1254334574'), (563, '74.115.1.6', '1254283200', 1, '1254324489'), (564, '67.82.97.57', '1254283200', 1, '1254347638'), (565, '67.81.44.204', '1254283200', 2, '1254363033'), (566, '67.81.44.204', '1254369600', 5, '1254455254'), (567, '70.18.93.157', '1254369600', 12, '1254421914'), (568, '67.81.69.33', '1254369600', 1, '1254410367'), (569, '74.115.1.5', '1254369600', 1, '1254415615'), (570, '67.81.39.61', '1254369600', 2, '1254428319'), (571, '67.81.78.76', '1254369600', 1, '1254438587'), (572, '67.81.64.53', '1254369600', 1, '1254439847'), (573, '67.82.97.57', '1254369600', 2, '1254449661'), (574, '70.18.93.157', '1254456000', 15, '1254507666'), (575, '74.115.1.6', '1254456000', 1, '1254490094'), (576, '74.115.1.23', '1254456000', 1, '1254493854'), (577, '74.115.1.7', '1254456000', 1, '1254498071'), (578, '74.115.0.2', '1254456000', 1, '1254498345'), (579, '67.81.69.33', '1254456000', 2, '1254523854'), (580, '67.81.39.61', '1254456000', 2, '1254537520'), (581, '67.81.44.204', '1254456000', 1, '1254540290'), (582, '67.81.69.33', '1254542400', 4, '1254627137'), (583, '67.81.44.204', '1254542400', 1, '1254592450'), (584, '67.81.44.204', '1254628800', 5, '1254714989'), (585, '67.81.39.61', '1254628800', 2, '1254708538'), (586, '67.81.69.33', '1254628800', 1, '1254680685'), (587, '70.18.93.157', '1254715200', 16, '1254767342'), (588, '74.115.1.23', '1254715200', 3, '1254756848'), (589, '67.81.69.33', '1254715200', 2, '1254773614'), (590, '67.81.39.61', '1254715200', 3, '1254792356'), (591, '67.81.44.204', '1254715200', 2, '1254800988'), (592, '67.81.74.110', '1254801600', 1, '1254802149'), (593, '70.18.93.157', '1254801600', 14, '1254853114'), (594, '74.115.1.22', '1254801600', 1, '1254832036'), (595, '74.115.0.10', '1254801600', 1, '1254838115'), (596, '74.115.1.6', '1254801600', 2, '1254843675'), (597, '74.115.1.7', '1254801600', 1, '1254851837'), (598, '67.81.39.61', '1254801600', 1, '1254880727'), (599, '67.81.44.204', '1254801600', 1, '1254883557'), (600, '67.81.69.33', '1254888000', 1, '1254913216'), (601, '70.18.93.157', '1254888000', 16, '1254936703'), (602, '74.115.1.6', '1254888000', 2, '1254934592'), (603, '70.18.93.7', '1254888000', 2, '1254918656'), (604, '67.81.39.61', '1254888000', 2, '1254948729'), (605, '35.11.231.17', '1254888000', 1, '1254963926'), (606, '67.81.44.204', '1254888000', 1, '1254971897'), (607, '127.0.0.1', '1254974400', 1, '1255014857'), (608, '70.18.93.157', '1254974400', 6, '1255025638'), (609, '74.115.1.6', '1254974400', 1, '1255016650'), (610, '74.115.0.10', '1254974400', 1, '1255023814'), (611, '67.81.39.61', '1254974400', 1, '1255042282'), (612, '67.81.44.204', '1254974400', 2, '1255045687'), (613, '70.18.93.157', '1255060800', 6, '1255111825'), (614, '74.115.0.10', '1255060800', 2, '1255108882'), (615, '74.115.1.23', '1255060800', 1, '1255107344'), (616, '67.81.44.204', '1255060800', 2, '1255133823'), (617, '67.81.39.61', '1255060800', 1, '1255143748'), (618, '67.81.44.204', '1255147200', 1, '1255202017'), (619, '67.81.44.204', '1255233600', 3, '1255316068'), (620, '67.81.64.53', '1255233600', 2, '1255303084'), (621, '67.81.44.204', '1255320000', 3, '1255385083'), (622, '70.18.93.157', '1255320000', 11, '1255371073'), (623, '74.115.1.5', '1255320000', 1, '1255361631'), (624, '74.115.1.23', '1255320000', 1, '1255364923'), (625, '67.81.39.61', '1255320000', 2, '1255395687'), (626, '70.18.93.157', '1255406400', 9, '1255448258'), (627, '74.115.1.23', '1255406400', 1, '1255434826'), (628, '74.115.0.2', '1255406400', 1, '1255439610'), (629, '67.81.64.53', '1255406400', 1, '1255480029'), (630, '67.81.39.61', '1255406400', 1, '1255486294'), (631, '67.81.74.224', '1255406400', 2, '1255491689'), (632, '67.81.44.204', '1255406400', 2, '1255491906'), (633, '70.18.93.157', '1255492800', 3, '1255527790'), (634, '74.115.1.5', '1255492800', 1, '1255544347'), (635, '74.115.1.7', '1255492800', 2, '1255544754'), (636, '67.81.39.61', '1255492800', 1, '1255562390'), (637, '67.81.64.53', '1255492800', 1, '1255565003'), (638, '70.18.93.157', '1255579200', 8, '1255628842'), (639, '67.81.44.204', '1255579200', 9, '1255663285'), (640, '67.82.97.57', '1255579200', 2, '1255648534'), (641, '67.81.44.204', '1255665600', 2, '1255751262'), (642, '70.18.93.157', '1255665600', 16, '1255717327'), (643, '74.115.0.10', '1255665600', 1, '1255706375'), (644, '74.115.0.2', '1255665600', 1, '1255707201'), (645, '74.115.1.7', '1255665600', 2, '1255712894'), (646, '173.54.13.236', '1255665600', 1, '1255742147'), (647, '67.81.44.204', '1255752000', 4, '1255811746'), (648, '71.172.234.189', '1255838400', 1, '1255871927'), (649, '67.81.44.204', '1255838400', 1, '1255916343'), (650, '70.18.93.157', '1255924800', 19, '1255975028'), (651, '74.115.1.5', '1255924800', 2, '1255964002'), (652, '67.81.39.61', '1255924800', 2, '1256006957'), (653, '68.197.103.27', '1255924800', 1, '1256004397'), (654, '70.18.93.157', '1256011200', 13, '1256058685'), (655, '128.180.218.227', '1256011200', 1, '1256077329'), (656, '67.81.44.204', '1256011200', 1, '1256095606'), (657, '70.18.93.157', '1256097600', 11, '1256144231'), (658, '74.115.1.5', '1256097600', 2, '1256134864'), (659, '74.115.0.2', '1256097600', 2, '1256138301'), (660, '70.18.93.157', '1256184000', 9, '1256234937'), (661, '74.115.0.2', '1256184000', 4, '1256233993'), (662, '67.81.44.204', '1256184000', 2, '1256265573'), (663, '70.18.93.157', '1256270400', 18, '1256321533'), (664, '74.115.1.23', '1256270400', 1, '1256301809'), (665, '67.81.44.204', '1256270400', 2, '1256329467'), (666, '67.81.44.204', '1256356800', 6, '1256442676'), (667, '70.18.93.157', '1256356800', 1, '1256395971'), (668, '67.82.99.205', '1256443200', 6, '1256518105'), (669, '67.81.44.204', '1256443200', 4, '1256526567'), (670, '67.81.44.204', '1256529600', 4, '1256601798'), (671, '70.18.93.157', '1256529600', 14, '1256581532'), (672, '67.81.39.61', '1256529600', 1, '1256589162'), (673, '67.82.99.205', '1256529600', 1, '1256592691'), (674, '70.18.93.157', '1256616000', 9, '1256667667'), (675, '74.115.1.23', '1256616000', 1, '1256653580'), (676, '67.82.99.205', '1256616000', 1, '1256654213'), (677, '204.75.252.20', '1256616000', 2, '1256669368'), (678, '74.105.27.138', '1256616000', 1, '1256673337'), (679, '67.81.44.204', '1256616000', 2, '1256695572'), (680, '70.18.93.157', '1256702400', 10, '1256752391'), (681, '74.115.0.10', '1256702400', 1, '1256741348'), (682, '74.115.1.22', '1256702400', 1, '1256748286'), (683, '67.81.44.204', '1256702400', 1, '1256784073'), (684, '70.18.93.157', '1256788800', 14, '1256840064'), (685, '74.115.1.5', '1256788800', 2, '1256820626'), (686, '74.115.1.23', '1256788800', 1, '1256827499'), (687, '67.81.44.204', '1256788800', 2, '1256873217'), (688, '67.82.99.205', '1256788800', 1, '1256857312'), (689, '70.18.93.157', '1256875200', 21, '1256926593'), (690, '70.18.93.155', '1256875200', 1, '1256917195'), (691, '69.125.223.174', '1256875200', 1, '1256952347'); Quote Link to comment Share on other sites More sharing options...
Philip Posted October 31, 2009 Share Posted October 31, 2009 I should have seen this earlier, d'oh! Don't use group by. -- One day: SELECT SUM(`hits`) FROM `stats` WHERE `date` > UNIX_TIMESTAMP()-86400; -- One Week: SELECT SUM(`hits`) FROM `stats` WHERE `date` > UNIX_TIMESTAMP()-604800; -- One Month (well, 4 weeks... 28 days) SELECT SUM(`hits`) FROM `stats` WHERE `date` > UNIX_TIMESTAMP()-2419200; I'd strongly suggest changing the format of your db to use MySQL's date/time fields, that way you can be more accurate (do exactly the last month) Quote Link to comment Share on other sites More sharing options...
tail Posted November 1, 2009 Author Share Posted November 1, 2009 Thank you very much Phillip! Regarding changing to date/time fields, would that require modification to any PHP code? Quote Link to comment Share on other sites More sharing options...
Philip Posted November 1, 2009 Share Posted November 1, 2009 Yes, a little bit. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.