View difference between Paste ID: GueeNrry and Bi7LScA1

 
-$directories = array();
+
 $host = 'localhost';
 $user = 'root';
-                new RecursiveDirectoryIterator($directory),
+$pass = 'password';
-                RecursiveIteratorIterator::CHILD_FIRST
+$database = 'google';
-            );
+
 $myiconnect = @mysqli_connect($host, $user, $pass, $database) or trigger_error(mysqli_connect_error(), E_USER_ERROR);
 
 /*
 
-		$dirname = basename(dirname($fullFileName));
+$directory = "/path/to/the/directory";
 $filenames = array();
-		if(is_dir($fullFileName) && $fileSPLObject->getFilename() != '.' && $fileSPLObject->getFilename() != '..') {
+$iterator = new DirectoryIterator($directory);
-		    //echo $filename . ' - ' . $file->getSize() . ' bytes <br/>' . "\n";
+foreach ($iterator as $fileinfo) {
     if ($fileinfo->isFile()) {
-			echo $dirname . ' ' . $fileSPLObject->getFilename() . "\n";
+        $filenames[] = (int)$fileinfo->getBasename('.jpg');
     }
 }
-		if (!in_array($dirname, $directories)) {
+sort($filenames);
 print_r($filenames);
-			//echo $dirname . "\n";
+
 
-			$directories[] = $dirname;
+ALTER TABLE  `labels` AUTO_INCREMENT =1
 */
 
 $directory = 'G:\\Research\\';
 $categories = array();
 
 $fileSPLObjects =  new RecursiveIteratorIterator(
-}
+  new RecursiveDirectoryIterator($directory),
   RecursiveIteratorIterator::CHILD_FIRST
 );
 try {
     foreach( $fileSPLObjects as $fullFileName => $fileSPLObject ) {
         //print $fullFileName . " " . $fileSPLObject->getFilename() . "\n";
 
 		$catname = basename(dirname($fullFileName));
 		$labelname = $fileSPLObject->getFilename();
 
 		if(is_dir($fullFileName) && $labelname != '.' && $labelname != '..') {
 		    //echo $labelname . ' - ' . $file->getSize() . ' bytes <br/>' . "\n";
 
 			//echo 'Cat: '. $catname . '    Tag: ' . $fileSPLObject->getFilename() . "\n";
 
 //	categories	label_categories	labels	label_item
 
 			if (!array_key_exists($catname, $categories)) {
 				$categories[$catname] = array();
 				echo $catname . "\n";
 				if (!$result = mysqli_query($myiconnect, 'INSERT INTO `' . $database . '`.`categories` ( `id` , `name` , `timestamp`) VALUES ( NULL, \'' . $catname . '\', CURRENT_TIMESTAMP);')) {
 					echo mysqli_error($myiconnect) . "\n";
 					$result = mysqli_query($myiconnect, 'SELECT `id` FROM `categories` WHERE `name` = \'' . $catname . '\' LIMIT 0, 1;');
 					$row = mysqli_fetch_array($result);
 					$cat_id = $row['id'];
 				}
 				else {
 					echo '   Category Added: ' . $catname . "\n";
 					$cat_id = mysqli_insert_id($myiconnect);
 				}
 
 			}
 
 			if (!in_array($labelname, $categories[$catname])) {
 				$categories[$catname][] = $labelname;
 
 				if (!$result = mysqli_query($myiconnect, 'INSERT INTO `' . $database . '`.`labels` ( `id` , `name` , `timestamp`) VALUES ( NULL, \'' . $labelname . '\', CURRENT_TIMESTAMP);')) {
 					echo mysqli_error($myiconnect) . "\n";
 					$result = mysqli_query($myiconnect, 'SELECT `id` FROM `labels` WHERE `name` = \'' . $labelname . '\' LIMIT 0, 1;');
 					$row = mysqli_fetch_array($result);
 					$label_id = $row['id'];
 				}
 				else {
 					echo '   Label Added: ' . $labelname . "\n";
 					$label_id = mysqli_insert_id($myiconnect);
 				}
 
 			}
 
 			if (!$result = mysqli_query($myiconnect, 'SELECT `category_id`, `label_id` FROM `label_categories` WHERE category_id=\'' . $cat_id . '\' AND label_id=\'' . $label_id . '\';')) {
 
 				if (mysqli_num_rows($result) == 0) {
 					$result = mysqli_query($myiconnect, 'INSERT INTO `' . $database . '`.`label_categories` ( `category_id` , `label_id` ) VALUES ( ' . $cat_id . ', \'' . $label_id . '\');');
 					echo '  Category/Label Added: ' . $catname . ' [' . $cat_id . ']   ' . $labelname . '[' . $label_id . ']' . "\n";
 				}
 
 			}
 
 		}
 
     }
 }
 catch (UnexpectedValueException $e) {
     printf("Directory [%s] contained a directory we can not recurse into", $directory);
 }
 
 print_r($categories);
 
 
 
 
 
 
 
 --
 -- Table structure for table `categories`
 --
 
 CREATE TABLE IF NOT EXISTS `categories` (
   `id` int(5) NOT NULL AUTO_INCREMENT,
   `name` varchar(25) NOT NULL,
   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`),
   UNIQUE KEY `name` (`name`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
 
 --
 -- Dumping data for table `categories`
 --
 
 INSERT INTO `categories` (`id`, `name`, `timestamp`) VALUES
 (1, 'Research', '2013-06-10 21:02:50'),
 (3, 'testing', '2013-06-10 21:03:38'),
 (4, 'Occupation', '2013-06-10 21:03:38'),
 (5, 'Behaviour', '2013-06-10 21:03:38'),
 (6, 'Interrogation', '2013-06-10 21:03:38'),
 (7, 'Conditioning', '2013-06-10 21:03:40'),
 (8, 'Conspiracy', '2013-06-10 21:03:40'),
 (9, 'Prism', '2013-06-10 21:03:40'),
 (10, '1763', '2013-06-10 21:03:40'),
 (11, 'New World Order', '2013-06-10 21:03:40'),
 (12, 'English', '2013-06-10 21:03:40'),
 (13, 'Math', '2013-06-10 21:03:41'),
 (14, 'Medical', '2013-06-10 21:03:41'),
 (15, 'Science', '2013-06-10 21:03:41'),
 (16, 'International', '2013-06-10 21:03:42'),
 (17, 'Canada', '2013-06-10 21:03:42'),
 (18, 'USA', '2013-06-10 21:03:42'),
 (19, 'California', '2013-06-10 21:03:42'),
 (20, 'Boston', '2013-06-10 21:03:42'),
 (21, 'Politics', '2013-06-10 21:03:42'),
 (22, 'Obama', '2013-06-10 21:03:42'),
 (23, '911', '2013-06-10 21:03:42'),
 (24, 'China', '2013-06-10 21:03:43'),
 (25, 'GMO', '2013-06-10 21:03:43'),
 (26, 'EU', '2013-06-10 21:03:43'),
 (27, 'Turkey', '2013-06-10 21:03:43'),
 (28, 'Illuminati', '2013-06-10 21:03:43'),
 (29, 'Religion', '2013-06-10 21:03:44');
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `labels`
 --
 
 CREATE TABLE IF NOT EXISTS `labels` (
   `id` int(5) NOT NULL AUTO_INCREMENT,
   `name` varchar(25) NOT NULL,
   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`),
   UNIQUE KEY `name` (`name`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=398 ;
 
 --
 -- Dumping data for table `labels`
 --
 
 INSERT INTO `labels` (`id`, `name`, `timestamp`) VALUES
 (1, 'Communication', '2013-06-10 21:02:50'),
 (2, 'Space', '2013-06-10 21:02:51'),
 (3, 'Disease', '2013-06-10 21:02:52'),
 (4, 'Concepts', '2013-06-10 21:02:53'),
 (5, 'Investment', '2013-06-10 21:02:54'),
 (6, 'HAARP', '2013-06-10 21:02:55'),
 (7, 'Mobile', '2013-06-10 21:02:56'),
 (8, 'Programming', '2013-06-10 21:02:57'),
 (9, 'Feminine Products', '2013-06-10 21:02:58'),
 (10, 'Racism', '2013-06-10 21:02:59'),
 (11, 'History', '2013-06-10 21:03:00'),
 (12, '95 percent', '2013-06-10 21:03:01'),
 (13, 'TV', '2013-06-10 21:03:03'),
 (14, 'CISPA', '2013-06-10 21:03:04'),
 (15, 'Dog', '2013-06-10 21:03:05'),
 (16, 'Extraterrestrial', '2013-06-10 21:03:06'),
 (17, 'Relationship', '2013-06-10 21:03:07'),
 (18, 'Fluoride', '2013-06-10 21:03:08'),
 (19, 'Stress', '2013-06-10 21:03:09'),
 (20, 'Baldness', '2013-06-10 21:03:10'),
 (21, 'PRISM', '2013-06-10 21:03:11'),
 (22, 'Aliens', '2013-06-10 21:03:12'),
 (23, 'Tear Gas', '2013-06-10 21:03:13'),
 (24, 'Titanic', '2013-06-10 21:03:14'),
 (25, 'Facebook', '2013-06-10 21:03:15'),
 (26, '98 Percent', '2013-06-10 21:03:17'),
 (27, 'Sun Gazing', '2013-06-10 21:03:18'),
 (55, 'New folder', '2013-06-10 21:03:38'),
 (56, 'testing', '2013-06-10 21:03:38'),
 (57, 'Light', '2013-06-10 21:03:38'),
 (58, 'Good Habits', '2013-06-10 21:03:38'),
 (59, 'Beef', '2013-06-10 21:03:38'),
 (60, 'Criminals', '2013-06-10 21:03:38'),
 (61, 'Christianity', '2013-06-10 21:03:38'),
 (62, 'Television', '2013-06-10 21:03:38'),
 (63, 'Reverse Engineer', '2013-06-10 21:03:38'),
 (64, 'Voluntaryism', '2013-06-10 21:03:38'),
 (65, 'Cannabis', '2013-06-10 21:03:38'),
 (66, 'Keanu Reeves', '2013-06-10 21:03:38'),
 (67, 'Sex Worker', '2013-06-10 21:03:38'),
 (68, 'Occupation', '2013-06-10 21:03:38'),
 (69, 'Martin Lurther King', '2013-06-10 21:03:38'),
 (70, 'Comprehension', '2013-06-10 21:03:38'),
 (71, 'Catholic', '2013-06-10 21:03:38'),
 (72, 'Human', '2013-06-10 21:03:38'),
 (73, 'Procrastination', '2013-06-10 21:03:38'),
 (74, 'Extroverts', '2013-06-10 21:03:38'),
 (75, 'Introverts', '2013-06-10 21:03:38'),
 (76, 'Behaviour', '2013-06-10 21:03:38'),
 (77, 'Conundrum', '2013-06-10 21:03:38'),
 (78, 'Edward Snowdon', '2013-06-10 21:03:38'),
 (79, 'Seven Deadly Sins', '2013-06-10 21:03:38'),
 (80, '100 Percent Fed Up', '2013-06-10 21:03:38'),
 (81, 'Cell Phones', '2013-06-10 21:03:38'),
 (82, 'Feudalism', '2013-06-10 21:03:38'),
 (83, 'Manipulation', '2013-06-10 21:03:38'),
 (84, 'Interrogation', '2013-06-10 21:03:38'),
 (85, 'Habits', '2013-06-10 21:03:38'),
 (86, 'Whistleblowing', '2013-06-10 21:03:38'),
 (87, 'Magnetic Field', '2013-06-10 21:03:38'),
 (88, 'Cult', '2013-06-10 21:03:38'),
 (89, 'Geomagnetic field', '2013-06-10 21:03:38'),
 (90, 'Teachers', '2013-06-10 21:03:38'),
 (91, 'Mainstream Media', '2013-06-10 21:03:38'),
 (92, 'Gun Prohibition', '2013-06-10 21:03:39'),
 (93, '6000 years old', '2013-06-10 21:03:39'),
 (94, 'AIDs', '2013-06-10 21:03:39'),
 (95, 'Amanda Bynes', '2013-06-10 21:03:39'),
 (96, 'Animal Abuse', '2013-06-10 21:03:39'),
 (97, 'Archaeologists', '2013-06-10 21:03:39'),
 (98, 'Astrology', '2013-06-10 21:03:39'),
 (99, 'Bees', '2013-06-10 21:03:39'),
 (100, 'Bill Gates', '2013-06-10 21:03:39'),
 (101, 'Bradley Manning', '2013-06-10 21:03:39'),
 (102, 'Cancer', '2013-06-10 21:03:40'),
 (103, 'McDonalds', '2013-06-10 21:03:40'),
 (104, 'Cartoon', '2013-06-10 21:03:40'),
 (105, 'Charity', '2013-06-10 21:03:40'),
 (106, 'Charts', '2013-06-10 21:03:40'),
 (107, 'Chemtrails', '2013-06-10 21:03:40'),
 (108, 'Chickens', '2013-06-10 21:03:40'),
 (109, 'China', '2013-06-10 21:03:40'),
 (110, 'Comedy', '2013-06-10 21:03:40'),
 (111, 'Computing', '2013-06-10 21:03:40'),
 (112, 'Conciousness', '2013-06-10 21:03:40'),
 (113, 'Abortion', '2013-06-10 21:03:40'),
 (114, 'IRS', '2013-06-10 21:03:40'),
 (115, 'Conditioning', '2013-06-10 21:03:40'),
 (116, 'The Gardasil Conspiracy', '2013-06-10 21:03:40'),
 (117, 'X-Box', '2013-06-10 21:03:40'),
 (119, '1763', '2013-06-10 21:03:40'),
 (120, '1764', '2013-06-10 21:03:40'),
 (121, '1773', '2013-06-10 21:03:40'),
 (122, '1775', '2013-06-10 21:03:40'),
 (123, '1776', '2013-06-10 21:03:40'),
 (124, 'New World Order', '2013-06-10 21:03:40'),
 (125, 'Conspiracy', '2013-06-10 21:03:40'),
 (126, 'Cosmetics', '2013-06-10 21:03:40'),
 (127, 'Countries', '2013-06-10 21:03:40'),
 (128, 'Criminal Procedures', '2013-06-10 21:03:40'),
 (129, 'Disinformation', '2013-06-10 21:03:40'),
 (130, 'dISNEY', '2013-06-10 21:03:40'),
 (131, 'Economics', '2013-06-10 21:03:40'),
 (133, 'English', '2013-06-10 21:03:40'),
 (134, 'Food', '2013-06-10 21:03:40'),
 (135, 'Forces', '2013-06-10 21:03:40'),
 (136, 'Fracking', '2013-06-10 21:03:40'),
 (137, 'Health', '2013-06-10 21:03:40'),
 (138, 'Ideas', '2013-06-10 21:03:40'),
 (139, 'Illusion', '2013-06-10 21:03:40'),
 (140, 'Influential Photos', '2013-06-10 21:03:40'),
 (141, 'Internet', '2013-06-10 21:03:40'),
 (142, 'Invention', '2013-06-10 21:03:41'),
 (143, 'Latin', '2013-06-10 21:03:41'),
 (144, 'Lucid-dreaming', '2013-06-10 21:03:41'),
 (145, 'Marijuana', '2013-06-10 21:03:41'),
 (146, 'Marketing', '2013-06-10 21:03:41'),
 (147, 'Pie', '2013-06-10 21:03:41'),
 (148, 'Math', '2013-06-10 21:03:41'),
 (149, 'Perscription Drugs', '2013-06-10 21:03:41'),
 (150, 'Psychedelic Medicines', '2013-06-10 21:03:41'),
 (151, 'Medical', '2013-06-10 21:03:41'),
 (152, 'Misconception', '2013-06-10 21:03:41'),
 (153, 'Moon Landing', '2013-06-10 21:03:41'),
 (154, 'Natural', '2013-06-10 21:03:41'),
 (155, 'Oreo', '2013-06-10 21:03:41'),
 (156, 'Parasite', '2013-06-10 21:03:41'),
 (157, 'Patents', '2013-06-10 21:03:41'),
 (158, 'Perspective', '2013-06-10 21:03:41'),
 (159, 'Philosophy', '2013-06-10 21:03:41'),
 (160, 'Police Brutality', '2013-06-10 21:03:41'),
 (161, 'Random', '2013-06-10 21:03:41'),
 (162, 'Rape', '2013-06-10 21:03:41'),
 (163, 'Revolutionary', '2013-06-10 21:03:41'),
 (164, 'Time', '2013-06-10 21:03:41'),
 (165, 'Bismuth', '2013-06-10 21:03:41'),
 (166, 'Science', '2013-06-10 21:03:41'),
 (167, 'Symbols', '2013-06-10 21:03:41'),
 (168, 'Systems', '2013-06-10 21:03:41'),
 (169, 'The Capitalist conspiracy', '2013-06-10 21:03:41'),
 (170, 'This-week-in-science', '2013-06-10 21:03:41'),
 (171, 'Thought patterns', '2013-06-10 21:03:41'),
 (172, 'Trends', '2013-06-10 21:03:41'),
 (173, 'Trolls', '2013-06-10 21:03:41'),
 (174, 'Tyrenny', '2013-06-10 21:03:41'),
 (175, 'UFO', '2013-06-10 21:03:41'),
 (176, 'Unknown', '2013-06-10 21:03:41'),
 (177, 'Vaccine', '2013-06-10 21:03:41'),
 (178, 'Virginity', '2013-06-10 21:03:41'),
 (179, 'Viruses', '2013-06-10 21:03:41'),
 (180, 'War on Drugs', '2013-06-10 21:03:41'),
 (181, 'Weapon', '2013-06-10 21:03:41'),
 (182, 'WebDev', '2013-06-10 21:03:41'),
 (183, 'Youth', '2013-06-10 21:03:41'),
 (184, 'Zionists', '2013-06-10 21:03:41'),
 (185, 'Repeating', '2013-06-10 21:03:41'),
 (186, 'Allegations', '2013-06-10 21:03:41'),
 (187, 'Confessions', '2013-06-10 21:03:41'),
 (188, 'Implications', '2013-06-10 21:03:41'),
 (189, 'Slavery', '2013-06-10 21:03:41'),
 (190, 'Sarcasm', '2013-06-10 21:03:41'),
 (191, 'Solutions', '2013-06-10 21:03:41'),
 (192, 'Ending', '2013-06-10 21:03:41'),
 (193, 'Chinese', '2013-06-10 21:03:41'),
 (194, 'Nestle', '2013-06-10 21:03:41'),
 (195, 'Anarchist', '2013-06-10 21:03:42'),
 (196, 'Domestic Violence', '2013-06-10 21:03:42'),
 (197, 'Critical Thinking', '2013-06-10 21:03:42'),
 (198, 'Awareness', '2013-06-10 21:03:42'),
 (199, 'Censorship', '2013-06-10 21:03:42'),
 (200, 'Empathy', '2013-06-10 21:03:42'),
 (201, 'JAVA', '2013-06-10 21:03:42'),
 (202, 'PHP', '2013-06-10 21:03:42'),
 (203, 'Greek', '2013-06-10 21:03:42'),
 (204, '2011 Voting Scandal', '2013-06-10 21:03:42'),
 (205, 'BC', '2013-06-10 21:03:42'),
 (206, 'Canada', '2013-06-10 21:03:42'),
 (207, 'Fascism', '2013-06-10 21:03:42'),
 (208, 'Journalists', '2013-06-10 21:03:42'),
 (209, 'FBI', '2013-06-10 21:03:42'),
 (210, 'Portugal', '2013-06-10 21:03:42'),
 (211, 'DOJ', '2013-06-10 21:03:42'),
 (212, 'Extorted', '2013-06-10 21:03:42'),
 (213, 'Florida', '2013-06-10 21:03:42'),
 (214, 'Alabama', '2013-06-10 21:03:42'),
 (215, 'Los Angeles', '2013-06-10 21:03:42'),
 (216, 'California', '2013-06-10 21:03:42'),
 (217, 'Milwakee', '2013-06-10 21:03:42'),
 (218, 'NSA', '2013-06-10 21:03:42'),
 (219, 'DHS', '2013-06-10 21:03:42'),
 (220, 'D.C', '2013-06-10 21:03:42'),
 (221, 'Arizona', '2013-06-10 21:03:42'),
 (222, 'Philidelphia', '2013-06-10 21:03:42'),
 (223, 'Bombing', '2013-06-10 21:03:42'),
 (224, 'Boston', '2013-06-10 21:03:42'),
 (225, 'Eric Holder', '2013-06-10 21:03:42'),
 (226, 'McCain', '2013-06-10 21:03:42'),
 (227, 'Ronald Reagan', '2013-06-10 21:03:42'),
 (228, 'Politics', '2013-06-10 21:03:42'),
 (229, 'Utah', '2013-06-10 21:03:42'),
 (230, 'infomocracy', '2013-06-10 21:03:42'),
 (231, 'Obama', '2013-06-10 21:03:42'),
 (232, 'FEMA', '2013-06-10 21:03:42'),
 (233, 'EPA', '2013-06-10 21:03:42'),
 (234, 'Gun Control', '2013-06-10 21:03:42'),
 (235, 'IRS Scandal', '2013-06-10 21:03:42'),
 (236, 'Charlie Veitch', '2013-06-10 21:03:42'),
 (237, 'ReThink911', '2013-06-10 21:03:42'),
 (238, '911', '2013-06-10 21:03:42'),
 (239, 'Nabraska', '2013-06-10 21:03:42'),
 (240, 'Freedom', '2013-06-10 21:03:42'),
 (241, 'Ohio', '2013-06-10 21:03:42'),
 (242, 'Colorado', '2013-06-10 21:03:42'),
 (243, 'NRA', '2013-06-10 21:03:42'),
 (244, 'Washington', '2013-06-10 21:03:42'),
 (245, 'Benghazi Scandal', '2013-06-10 21:03:42'),
 (246, 'Taxes', '2013-06-10 21:03:42'),
 (247, 'Oregon', '2013-06-10 21:03:42'),
 (248, 'USDA', '2013-06-10 21:03:42'),
 (249, 'Fox News', '2013-06-10 21:03:42'),
 (250, 'Iowa', '2013-06-10 21:03:42'),
 (251, 'FDA', '2013-06-10 21:03:42'),
 (252, 'TEApublician', '2013-06-10 21:03:42'),
 (253, 'Zuckerberge', '2013-06-10 21:03:42'),
 (254, 'Obamacare', '2013-06-10 21:03:42'),
 (255, 'Nasa', '2013-06-10 21:03:42'),
 (256, 'NYC', '2013-06-10 21:03:42'),
 (258, 'Donald Trump', '2013-06-10 21:03:42'),
 (259, 'Sanata Monica', '2013-06-10 21:03:42'),
 (260, 'Operation Mind Control', '2013-06-10 21:03:42'),
 (261, 'Kansas', '2013-06-10 21:03:42'),
 (262, 'GUNS', '2013-06-10 21:03:42'),
 (263, 'Sandy Hook', '2013-06-10 21:03:42'),
 (264, 'Secretary of Defence', '2013-06-10 21:03:42'),
 (265, 'Military', '2013-06-10 21:03:42'),
 (266, 'Tax-Payers', '2013-06-10 21:03:42'),
 (267, 'Pennsylvania', '2013-06-10 21:03:42'),
 (268, 'New Jersey', '2013-06-10 21:03:42'),
 (269, 'Oklahoma', '2013-06-10 21:03:42'),
 (270, 'Bush', '2013-06-10 21:03:42'),
 (271, 'Keneticut', '2013-06-10 21:03:42'),
 (272, 'Sharia Law', '2013-06-10 21:03:42'),
 (273, 'Maine', '2013-06-10 21:03:42'),
 (274, 'Connecticut', '2013-06-10 21:03:42'),
 (275, 'Head Start', '2013-06-10 21:03:42'),
 (276, 'Illinois', '2013-06-10 21:03:42'),
 (277, 'Patriot Act', '2013-06-10 21:03:43'),
 (279, 'Homeland Security', '2013-06-10 21:03:43'),
 (280, 'GOP', '2013-06-10 21:03:43'),
 (281, 'Vermont', '2013-06-10 21:03:43'),
 (282, 'Bill Clinton', '2013-06-10 21:03:43'),
 (283, 'USA', '2013-06-10 21:03:43'),
 (284, 'Hong Kong', '2013-06-10 21:03:43'),
 (286, 'Statistics', '2013-06-10 21:03:43'),
 (287, 'Pakistan', '2013-06-10 21:03:43'),
 (288, 'Russia', '2013-06-10 21:03:43'),
 (290, 'Chile', '2013-06-10 21:03:43'),
 (292, 'Wealthist', '2013-06-10 21:03:43'),
 (293, 'Israel', '2013-06-10 21:03:43'),
 (294, 'War', '2013-06-10 21:03:43'),
 (295, 'False Flag', '2013-06-10 21:03:43'),
 (296, 'Mexico', '2013-06-10 21:03:43'),
 (297, 'U.N', '2013-06-10 21:03:43'),
 (298, 'Japan', '2013-06-10 21:03:43'),
 (299, 'UK (old country)', '2013-06-10 21:03:43'),
 (300, 'Aspertame', '2013-06-10 21:03:43'),
 (301, 'Gene VI', '2013-06-10 21:03:43'),
 (302, 'New Tech', '2013-06-10 21:03:43'),
 (303, 'GMO', '2013-06-10 21:03:43'),
 (304, 'Monsanto', '2013-06-10 21:03:43'),
 (305, 'Martial Law', '2013-06-10 21:03:43'),
 (306, 'Occupy', '2013-06-10 21:03:43'),
 (307, 'Islam', '2013-06-10 21:03:43'),
 (308, 'Denmark', '2013-06-10 21:03:43'),
 (309, 'Non-GMO', '2013-06-10 21:03:43'),
 (310, 'El Salvador', '2013-06-10 21:03:43'),
 (311, 'BBC', '2013-06-10 21:03:43'),
 (312, 'EU', '2013-06-10 21:03:43'),
 (314, 'Brazil', '2013-06-10 21:03:43'),
 (315, 'Syria', '2013-06-10 21:03:43'),
 (316, 'Ankara', '2013-06-10 21:03:43'),
 (317, 'Turkey', '2013-06-10 21:03:43'),
 (318, 'NATO', '2013-06-10 21:03:43'),
 (319, 'WW3', '2013-06-10 21:03:43'),
 (320, 'Global Warming', '2013-06-10 21:03:43'),
 (321, 'Human Rights', '2013-06-10 21:03:43'),
 (322, 'Protocols', '2013-06-10 21:03:43'),
 (323, 'cARD', '2013-06-10 21:03:43'),
 (324, 'Bundy', '2013-06-10 21:03:43'),
 (325, 'Astor', '2013-06-10 21:03:43'),
 (326, 'Collins', '2013-06-10 21:03:43'),
 (327, 'DuPont', '2013-06-10 21:03:43'),
 (328, 'Freeman', '2013-06-10 21:03:43'),
 (329, 'Kennedy', '2013-06-10 21:03:43'),
 (330, 'Li', '2013-06-10 21:03:43'),
 (331, 'Onassis', '2013-06-10 21:03:43'),
 (332, 'Reynolds', '2013-06-10 21:03:43'),
 (333, 'Rockefeller', '2013-06-10 21:03:43'),
 (334, 'Rothschild', '2013-06-10 21:03:43'),
 (335, 'Russell', '2013-06-10 21:03:43'),
 (336, 'Van Duyn', '2013-06-10 21:03:43'),
 (337, 'Illuminati', '2013-06-10 21:03:43'),
 (338, 'Annonymous', '2013-06-10 21:03:43'),
 (339, 'Egypt', '2013-06-10 21:03:43'),
 (340, 'Government Beauracy', '2013-06-10 21:03:43'),
 (341, 'World Bank', '2013-06-10 21:03:43'),
 (342, 'TSA', '2013-06-10 21:03:43'),
 (343, 'Iraq', '2013-06-10 21:03:43'),
 (344, 'Agenda 21', '2013-06-10 21:03:43'),
 (345, 'Peru', '2013-06-10 21:03:43'),
 (346, 'Sovereign', '2013-06-10 21:03:43'),
 (347, 'Greece', '2013-06-10 21:03:43'),
 (348, 'Australia', '2013-06-10 21:03:43'),
 (349, 'Nevada', '2013-06-10 21:03:43'),
 (350, 'Operation Paperclip', '2013-06-10 21:03:43'),
 (351, 'Red Flag', '2013-06-10 21:03:43'),
 (352, 'FED', '2013-06-10 21:03:43'),
 (353, 'Cuba', '2013-06-10 21:03:43'),
 (354, 'South Korea', '2013-06-10 21:03:43'),
 (355, 'Philippines', '2013-06-10 21:03:43'),
 (356, 'Bilderberg Group', '2013-06-10 21:03:43'),
 (357, 'Kenya', '2013-06-10 21:03:43'),
 (359, 'Germany', '2013-06-10 21:03:43'),
 (360, 'Miss World Competition', '2013-06-10 21:03:43'),
 (362, 'International', '2013-06-10 21:03:43'),
 (363, 'LGBT', '2013-06-10 21:03:43'),
 (364, 'Impeach', '2013-06-10 21:03:43'),
 (365, 'Conterveries', '2013-06-10 21:03:44'),
 (366, 'psychology', '2013-06-10 21:03:44'),
 (367, 'Apocalypse', '2013-06-10 21:03:44'),
 (368, 'Self', '2013-06-10 21:03:44'),
 (369, 'Appearences', '2013-06-10 21:03:44'),
 (370, 'Positive', '2013-06-10 21:03:44'),
 (372, 'Moral', '2013-06-10 21:03:44'),
 (373, 'Obese', '2013-06-10 21:03:44'),
 (374, 'Muslim', '2013-06-10 21:03:44'),
 (375, 'Judism', '2013-06-10 21:03:44'),
 (376, 'Religion', '2013-06-10 21:03:44'),
 (377, 'Secrets of the universe', '2013-06-10 21:03:44'),
 (378, 'Atheism', '2013-06-10 21:03:44'),
 (379, 'Meaning of Life', '2013-06-10 21:03:44'),
 (380, 'Education', '2013-06-10 21:03:44'),
 (381, 'Pay Attention', '2013-06-10 21:03:44'),
 (382, 'Press', '2013-06-10 21:03:44'),
 (383, 'Memes', '2013-06-10 21:03:44'),
 (384, 'Soda Pop', '2013-06-10 21:03:44'),
 (385, 'Matrix', '2013-06-10 21:03:44'),
 (386, 'Advertising', '2013-06-10 21:03:44'),
 (387, 'Flu', '2013-06-10 21:03:44'),
 (388, 'Poverty', '2013-06-10 21:03:44'),
 (389, 'Exxon Mobil', '2013-06-10 21:03:44'),
 (390, 'Capitalism', '2013-06-10 21:03:44'),
 (391, '1 Percent', '2013-06-10 21:03:44'),
 (392, 'WikiLeaks', '2013-06-10 21:03:44'),
 (393, 'Skinning', '2013-06-10 21:03:44'),
 (394, 'Sex', '2013-06-10 21:03:44'),
 (395, 'Radical', '2013-06-10 21:03:44'),
 (396, 'Meditation', '2013-06-10 21:03:44'),
 (397, 'Social Media', '2013-06-10 21:03:44');
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `label_categories`
 --
 
 CREATE TABLE IF NOT EXISTS `label_categories` (
   `category_id` int(5) NOT NULL,
   `label_id` int(5) NOT NULL,
   KEY `category_id` (`category_id`),
   KEY `label_id` (`label_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Dumping data for table `label_categories`
 --
 
 INSERT INTO `label_categories` (`category_id`, `label_id`) VALUES
 (1, 1),
 (1, 2),
 (1, 3),
 (1, 4),
 (1, 5),
 (1, 6),
 (1, 7),
 (1, 8),
 (1, 9),
 (1, 10),
 (1, 11),
 (1, 12),
 (1, 13),
 (1, 14),
 (1, 15),
 (1, 16),
 (1, 17),
 (1, 18),
 (1, 19),
 (1, 20),
 (1, 21),
 (1, 22),
 (1, 23),
 (1, 24),
 (1, 25),
 (1, 26);
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `label_item`
 --
 
 CREATE TABLE IF NOT EXISTS `label_item` (
   `id` int(10) NOT NULL,
   `label_id` int(5) NOT NULL,
   `directory` text NOT NULL,
   `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Constraints for dumped tables
 --
 
 --
 -- Constraints for table `label_categories`
 --
 ALTER TABLE `label_categories`
   ADD CONSTRAINT `label_categories_ibfk_2` FOREIGN KEY (`label_id`) REFERENCES `labels` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
   ADD CONSTRAINT `label_categories_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;