API tools faq
paste
Advertisement
barryd

Recursive Directory Lister (isDir) - Cat / Tag2

barryd
Jun 10th, 2013
68
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 22.13 KB | None | 0 0
raw download clone embed print report diff
  1.  
  2.  
  3. $host = 'localhost';
  4. $user = 'root';
  5. $pass = 'password';
  6. $database = 'google';
  7.  
  8. $myiconnect = @mysqli_connect($host, $user, $pass, $database) or trigger_error(mysqli_connect_error(), E_USER_ERROR);
  9.  
  10. /*
  11.  
  12. $directory = "/path/to/the/directory";
  13. $filenames = array();
  14. $iterator = new DirectoryIterator($directory);
  15. foreach ($iterator as $fileinfo) {
  16.     if ($fileinfo->isFile()) {
  17.         $filenames[] = (int)$fileinfo->getBasename('.jpg');
  18.     }
  19. }
  20. sort($filenames);
  21. print_r($filenames);
  22.  
  23.  
  24. ALTER TABLE  `labels` AUTO_INCREMENT =1
  25. */
  26.  
  27. $directory = 'G:\\Research\\';
  28. $categories = array();
  29.  
  30. $fileSPLObjects =  new RecursiveIteratorIterator(
  31.   new RecursiveDirectoryIterator($directory),
  32.   RecursiveIteratorIterator::CHILD_FIRST
  33. );
  34. try {
  35.     foreach( $fileSPLObjects as $fullFileName => $fileSPLObject ) {
  36.         //print $fullFileName . " " . $fileSPLObject->getFilename() . "\n";
  37.  
  38.         $catname = basename(dirname($fullFileName));
  39.         $labelname = $fileSPLObject->getFilename();
  40.  
  41.         if(is_dir($fullFileName) && $labelname != '.' && $labelname != '..') {
  42.             //echo $labelname . ' - ' . $file->getSize() . ' bytes <br/>' . "\n";
  43.  
  44.             //echo 'Cat: '. $catname . '    Tag: ' . $fileSPLObject->getFilename() . "\n";
  45.  
  46. //  categories  label_categories    labels  label_item
  47.  
  48.             if (!array_key_exists($catname, $categories)) {
  49.                 $categories[$catname] = array();
  50.                 echo $catname . "\n";
  51.                 if (!$result = mysqli_query($myiconnect, 'INSERT INTO `' . $database . '`.`categories` ( `id` , `name` , `timestamp`) VALUES ( NULL, \'' . $catname . '\', CURRENT_TIMESTAMP);')) {
  52.                     echo mysqli_error($myiconnect) . "\n";
  53.                     $result = mysqli_query($myiconnect, 'SELECT `id` FROM `categories` WHERE `name` = \'' . $catname . '\' LIMIT 0, 1;');
  54.                     $row = mysqli_fetch_array($result);
  55.                     $cat_id = $row['id'];
  56.                 }
  57.                 else {
  58.                     echo '   Category Added: ' . $catname . "\n";
  59.                     $cat_id = mysqli_insert_id($myiconnect);
  60.                 }
  61.  
  62.             }
  63.  
  64.             if (!in_array($labelname, $categories[$catname])) {
  65.                 $categories[$catname][] = $labelname;
  66.  
  67.                 if (!$result = mysqli_query($myiconnect, 'INSERT INTO `' . $database . '`.`labels` ( `id` , `name` , `timestamp`) VALUES ( NULL, \'' . $labelname . '\', CURRENT_TIMESTAMP);')) {
  68.                     echo mysqli_error($myiconnect) . "\n";
  69.                     $result = mysqli_query($myiconnect, 'SELECT `id` FROM `labels` WHERE `name` = \'' . $labelname . '\' LIMIT 0, 1;');
  70.                     $row = mysqli_fetch_array($result);
  71.                     $label_id = $row['id'];
  72.                 }
  73.                 else {
  74.                     echo '   Label Added: ' . $labelname . "\n";
  75.                     $label_id = mysqli_insert_id($myiconnect);
  76.                 }
  77.  
  78.             }
  79.            
  80.             if (!$result = mysqli_query($myiconnect, 'SELECT `category_id`, `label_id` FROM `label_categories` WHERE category_id=\'' . $cat_id . '\' AND label_id=\'' . $label_id . '\';')) {
  81.            
  82.                 if (mysqli_num_rows($result) == 0) {
  83.                     $result = mysqli_query($myiconnect, 'INSERT INTO `' . $database . '`.`label_categories` ( `category_id` , `label_id` ) VALUES ( ' . $cat_id . ', \'' . $label_id . '\');');
  84.                     echo '  Category/Label Added: ' . $catname . ' [' . $cat_id . ']   ' . $labelname . '[' . $label_id . ']' . "\n";
  85.                 }
  86.            
  87.             }
  88.  
  89.         }
  90.  
  91.     }
  92. }
  93. catch (UnexpectedValueException $e) {
  94.     printf("Directory [%s] contained a directory we can not recurse into", $directory);
  95. }
  96.  
  97. print_r($categories);
  98.  
  99.  
  100.  
  101.  
  102.  
  103.  
  104.  
  105. --
  106. -- Table structure for table `categories`
  107. --
  108.  
  109. CREATE TABLE IF NOT EXISTS `categories` (
  110.   `id` int(5) NOT NULL AUTO_INCREMENT,
  111.   `name` varchar(25) NOT NULL,
  112.   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  113.   PRIMARY KEY (`id`),
  114.   UNIQUE KEY `name` (`name`)
  115. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
  116.  
  117. --
  118. -- Dumping data for table `categories`
  119. --
  120.  
  121. INSERT INTO `categories` (`id`, `name`, `timestamp`) VALUES
  122. (1, 'Research', '2013-06-10 21:02:50'),
  123. (3, 'testing', '2013-06-10 21:03:38'),
  124. (4, 'Occupation', '2013-06-10 21:03:38'),
  125. (5, 'Behaviour', '2013-06-10 21:03:38'),
  126. (6, 'Interrogation', '2013-06-10 21:03:38'),
  127. (7, 'Conditioning', '2013-06-10 21:03:40'),
  128. (8, 'Conspiracy', '2013-06-10 21:03:40'),
  129. (9, 'Prism', '2013-06-10 21:03:40'),
  130. (10, '1763', '2013-06-10 21:03:40'),
  131. (11, 'New World Order', '2013-06-10 21:03:40'),
  132. (12, 'English', '2013-06-10 21:03:40'),
  133. (13, 'Math', '2013-06-10 21:03:41'),
  134. (14, 'Medical', '2013-06-10 21:03:41'),
  135. (15, 'Science', '2013-06-10 21:03:41'),
  136. (16, 'International', '2013-06-10 21:03:42'),
  137. (17, 'Canada', '2013-06-10 21:03:42'),
  138. (18, 'USA', '2013-06-10 21:03:42'),
  139. (19, 'California', '2013-06-10 21:03:42'),
  140. (20, 'Boston', '2013-06-10 21:03:42'),
  141. (21, 'Politics', '2013-06-10 21:03:42'),
  142. (22, 'Obama', '2013-06-10 21:03:42'),
  143. (23, '911', '2013-06-10 21:03:42'),
  144. (24, 'China', '2013-06-10 21:03:43'),
  145. (25, 'GMO', '2013-06-10 21:03:43'),
  146. (26, 'EU', '2013-06-10 21:03:43'),
  147. (27, 'Turkey', '2013-06-10 21:03:43'),
  148. (28, 'Illuminati', '2013-06-10 21:03:43'),
  149. (29, 'Religion', '2013-06-10 21:03:44');
  150.  
  151. -- --------------------------------------------------------
  152.  
  153. --
  154. -- Table structure for table `labels`
  155. --
  156.  
  157. CREATE TABLE IF NOT EXISTS `labels` (
  158.   `id` int(5) NOT NULL AUTO_INCREMENT,
  159.   `name` varchar(25) NOT NULL,
  160.   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  161.   PRIMARY KEY (`id`),
  162.   UNIQUE KEY `name` (`name`)
  163. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=398 ;
  164.  
  165. --
  166. -- Dumping data for table `labels`
  167. --
  168.  
  169. INSERT INTO `labels` (`id`, `name`, `timestamp`) VALUES
  170. (1, 'Communication', '2013-06-10 21:02:50'),
  171. (2, 'Space', '2013-06-10 21:02:51'),
  172. (3, 'Disease', '2013-06-10 21:02:52'),
  173. (4, 'Concepts', '2013-06-10 21:02:53'),
  174. (5, 'Investment', '2013-06-10 21:02:54'),
  175. (6, 'HAARP', '2013-06-10 21:02:55'),
  176. (7, 'Mobile', '2013-06-10 21:02:56'),
  177. (8, 'Programming', '2013-06-10 21:02:57'),
  178. (9, 'Feminine Products', '2013-06-10 21:02:58'),
  179. (10, 'Racism', '2013-06-10 21:02:59'),
  180. (11, 'History', '2013-06-10 21:03:00'),
  181. (12, '95 percent', '2013-06-10 21:03:01'),
  182. (13, 'TV', '2013-06-10 21:03:03'),
  183. (14, 'CISPA', '2013-06-10 21:03:04'),
  184. (15, 'Dog', '2013-06-10 21:03:05'),
  185. (16, 'Extraterrestrial', '2013-06-10 21:03:06'),
  186. (17, 'Relationship', '2013-06-10 21:03:07'),
  187. (18, 'Fluoride', '2013-06-10 21:03:08'),
  188. (19, 'Stress', '2013-06-10 21:03:09'),
  189. (20, 'Baldness', '2013-06-10 21:03:10'),
  190. (21, 'PRISM', '2013-06-10 21:03:11'),
  191. (22, 'Aliens', '2013-06-10 21:03:12'),
  192. (23, 'Tear Gas', '2013-06-10 21:03:13'),
  193. (24, 'Titanic', '2013-06-10 21:03:14'),
  194. (25, 'Facebook', '2013-06-10 21:03:15'),
  195. (26, '98 Percent', '2013-06-10 21:03:17'),
  196. (27, 'Sun Gazing', '2013-06-10 21:03:18'),
  197. (55, 'New folder', '2013-06-10 21:03:38'),
  198. (56, 'testing', '2013-06-10 21:03:38'),
  199. (57, 'Light', '2013-06-10 21:03:38'),
  200. (58, 'Good Habits', '2013-06-10 21:03:38'),
  201. (59, 'Beef', '2013-06-10 21:03:38'),
  202. (60, 'Criminals', '2013-06-10 21:03:38'),
  203. (61, 'Christianity', '2013-06-10 21:03:38'),
  204. (62, 'Television', '2013-06-10 21:03:38'),
  205. (63, 'Reverse Engineer', '2013-06-10 21:03:38'),
  206. (64, 'Voluntaryism', '2013-06-10 21:03:38'),
  207. (65, 'Cannabis', '2013-06-10 21:03:38'),
  208. (66, 'Keanu Reeves', '2013-06-10 21:03:38'),
  209. (67, 'Sex Worker', '2013-06-10 21:03:38'),
  210. (68, 'Occupation', '2013-06-10 21:03:38'),
  211. (69, 'Martin Lurther King', '2013-06-10 21:03:38'),
  212. (70, 'Comprehension', '2013-06-10 21:03:38'),
  213. (71, 'Catholic', '2013-06-10 21:03:38'),
  214. (72, 'Human', '2013-06-10 21:03:38'),
  215. (73, 'Procrastination', '2013-06-10 21:03:38'),
  216. (74, 'Extroverts', '2013-06-10 21:03:38'),
  217. (75, 'Introverts', '2013-06-10 21:03:38'),
  218. (76, 'Behaviour', '2013-06-10 21:03:38'),
  219. (77, 'Conundrum', '2013-06-10 21:03:38'),
  220. (78, 'Edward Snowdon', '2013-06-10 21:03:38'),
  221. (79, 'Seven Deadly Sins', '2013-06-10 21:03:38'),
  222. (80, '100 Percent Fed Up', '2013-06-10 21:03:38'),
  223. (81, 'Cell Phones', '2013-06-10 21:03:38'),
  224. (82, 'Feudalism', '2013-06-10 21:03:38'),
  225. (83, 'Manipulation', '2013-06-10 21:03:38'),
  226. (84, 'Interrogation', '2013-06-10 21:03:38'),
  227. (85, 'Habits', '2013-06-10 21:03:38'),
  228. (86, 'Whistleblowing', '2013-06-10 21:03:38'),
  229. (87, 'Magnetic Field', '2013-06-10 21:03:38'),
  230. (88, 'Cult', '2013-06-10 21:03:38'),
  231. (89, 'Geomagnetic field', '2013-06-10 21:03:38'),
  232. (90, 'Teachers', '2013-06-10 21:03:38'),
  233. (91, 'Mainstream Media', '2013-06-10 21:03:38'),
  234. (92, 'Gun Prohibition', '2013-06-10 21:03:39'),
  235. (93, '6000 years old', '2013-06-10 21:03:39'),
  236. (94, 'AIDs', '2013-06-10 21:03:39'),
  237. (95, 'Amanda Bynes', '2013-06-10 21:03:39'),
  238. (96, 'Animal Abuse', '2013-06-10 21:03:39'),
  239. (97, 'Archaeologists', '2013-06-10 21:03:39'),
  240. (98, 'Astrology', '2013-06-10 21:03:39'),
  241. (99, 'Bees', '2013-06-10 21:03:39'),
  242. (100, 'Bill Gates', '2013-06-10 21:03:39'),
  243. (101, 'Bradley Manning', '2013-06-10 21:03:39'),
  244. (102, 'Cancer', '2013-06-10 21:03:40'),
  245. (103, 'McDonalds', '2013-06-10 21:03:40'),
  246. (104, 'Cartoon', '2013-06-10 21:03:40'),
  247. (105, 'Charity', '2013-06-10 21:03:40'),
  248. (106, 'Charts', '2013-06-10 21:03:40'),
  249. (107, 'Chemtrails', '2013-06-10 21:03:40'),
  250. (108, 'Chickens', '2013-06-10 21:03:40'),
  251. (109, 'China', '2013-06-10 21:03:40'),
  252. (110, 'Comedy', '2013-06-10 21:03:40'),
  253. (111, 'Computing', '2013-06-10 21:03:40'),
  254. (112, 'Conciousness', '2013-06-10 21:03:40'),
  255. (113, 'Abortion', '2013-06-10 21:03:40'),
  256. (114, 'IRS', '2013-06-10 21:03:40'),
  257. (115, 'Conditioning', '2013-06-10 21:03:40'),
  258. (116, 'The Gardasil Conspiracy', '2013-06-10 21:03:40'),
  259. (117, 'X-Box', '2013-06-10 21:03:40'),
  260. (119, '1763', '2013-06-10 21:03:40'),
  261. (120, '1764', '2013-06-10 21:03:40'),
  262. (121, '1773', '2013-06-10 21:03:40'),
  263. (122, '1775', '2013-06-10 21:03:40'),
  264. (123, '1776', '2013-06-10 21:03:40'),
  265. (124, 'New World Order', '2013-06-10 21:03:40'),
  266. (125, 'Conspiracy', '2013-06-10 21:03:40'),
  267. (126, 'Cosmetics', '2013-06-10 21:03:40'),
  268. (127, 'Countries', '2013-06-10 21:03:40'),
  269. (128, 'Criminal Procedures', '2013-06-10 21:03:40'),
  270. (129, 'Disinformation', '2013-06-10 21:03:40'),
  271. (130, 'dISNEY', '2013-06-10 21:03:40'),
  272. (131, 'Economics', '2013-06-10 21:03:40'),
  273. (133, 'English', '2013-06-10 21:03:40'),
  274. (134, 'Food', '2013-06-10 21:03:40'),
  275. (135, 'Forces', '2013-06-10 21:03:40'),
  276. (136, 'Fracking', '2013-06-10 21:03:40'),
  277. (137, 'Health', '2013-06-10 21:03:40'),
  278. (138, 'Ideas', '2013-06-10 21:03:40'),
  279. (139, 'Illusion', '2013-06-10 21:03:40'),
  280. (140, 'Influential Photos', '2013-06-10 21:03:40'),
  281. (141, 'Internet', '2013-06-10 21:03:40'),
  282. (142, 'Invention', '2013-06-10 21:03:41'),
  283. (143, 'Latin', '2013-06-10 21:03:41'),
  284. (144, 'Lucid-dreaming', '2013-06-10 21:03:41'),
  285. (145, 'Marijuana', '2013-06-10 21:03:41'),
  286. (146, 'Marketing', '2013-06-10 21:03:41'),
  287. (147, 'Pie', '2013-06-10 21:03:41'),
  288. (148, 'Math', '2013-06-10 21:03:41'),
  289. (149, 'Perscription Drugs', '2013-06-10 21:03:41'),
  290. (150, 'Psychedelic Medicines', '2013-06-10 21:03:41'),
  291. (151, 'Medical', '2013-06-10 21:03:41'),
  292. (152, 'Misconception', '2013-06-10 21:03:41'),
  293. (153, 'Moon Landing', '2013-06-10 21:03:41'),
  294. (154, 'Natural', '2013-06-10 21:03:41'),
  295. (155, 'Oreo', '2013-06-10 21:03:41'),
  296. (156, 'Parasite', '2013-06-10 21:03:41'),
  297. (157, 'Patents', '2013-06-10 21:03:41'),
  298. (158, 'Perspective', '2013-06-10 21:03:41'),
  299. (159, 'Philosophy', '2013-06-10 21:03:41'),
  300. (160, 'Police Brutality', '2013-06-10 21:03:41'),
  301. (161, 'Random', '2013-06-10 21:03:41'),
  302. (162, 'Rape', '2013-06-10 21:03:41'),
  303. (163, 'Revolutionary', '2013-06-10 21:03:41'),
  304. (164, 'Time', '2013-06-10 21:03:41'),
  305. (165, 'Bismuth', '2013-06-10 21:03:41'),
  306. (166, 'Science', '2013-06-10 21:03:41'),
  307. (167, 'Symbols', '2013-06-10 21:03:41'),
  308. (168, 'Systems', '2013-06-10 21:03:41'),
  309. (169, 'The Capitalist conspiracy', '2013-06-10 21:03:41'),
  310. (170, 'This-week-in-science', '2013-06-10 21:03:41'),
  311. (171, 'Thought patterns', '2013-06-10 21:03:41'),
  312. (172, 'Trends', '2013-06-10 21:03:41'),
  313. (173, 'Trolls', '2013-06-10 21:03:41'),
  314. (174, 'Tyrenny', '2013-06-10 21:03:41'),
  315. (175, 'UFO', '2013-06-10 21:03:41'),
  316. (176, 'Unknown', '2013-06-10 21:03:41'),
  317. (177, 'Vaccine', '2013-06-10 21:03:41'),
  318. (178, 'Virginity', '2013-06-10 21:03:41'),
  319. (179, 'Viruses', '2013-06-10 21:03:41'),
  320. (180, 'War on Drugs', '2013-06-10 21:03:41'),
  321. (181, 'Weapon', '2013-06-10 21:03:41'),
  322. (182, 'WebDev', '2013-06-10 21:03:41'),
  323. (183, 'Youth', '2013-06-10 21:03:41'),
  324. (184, 'Zionists', '2013-06-10 21:03:41'),
  325. (185, 'Repeating', '2013-06-10 21:03:41'),
  326. (186, 'Allegations', '2013-06-10 21:03:41'),
  327. (187, 'Confessions', '2013-06-10 21:03:41'),
  328. (188, 'Implications', '2013-06-10 21:03:41'),
  329. (189, 'Slavery', '2013-06-10 21:03:41'),
  330. (190, 'Sarcasm', '2013-06-10 21:03:41'),
  331. (191, 'Solutions', '2013-06-10 21:03:41'),
  332. (192, 'Ending', '2013-06-10 21:03:41'),
  333. (193, 'Chinese', '2013-06-10 21:03:41'),
  334. (194, 'Nestle', '2013-06-10 21:03:41'),
  335. (195, 'Anarchist', '2013-06-10 21:03:42'),
  336. (196, 'Domestic Violence', '2013-06-10 21:03:42'),
  337. (197, 'Critical Thinking', '2013-06-10 21:03:42'),
  338. (198, 'Awareness', '2013-06-10 21:03:42'),
  339. (199, 'Censorship', '2013-06-10 21:03:42'),
  340. (200, 'Empathy', '2013-06-10 21:03:42'),
  341. (201, 'JAVA', '2013-06-10 21:03:42'),
  342. (202, 'PHP', '2013-06-10 21:03:42'),
  343. (203, 'Greek', '2013-06-10 21:03:42'),
  344. (204, '2011 Voting Scandal', '2013-06-10 21:03:42'),
  345. (205, 'BC', '2013-06-10 21:03:42'),
  346. (206, 'Canada', '2013-06-10 21:03:42'),
  347. (207, 'Fascism', '2013-06-10 21:03:42'),
  348. (208, 'Journalists', '2013-06-10 21:03:42'),
  349. (209, 'FBI', '2013-06-10 21:03:42'),
  350. (210, 'Portugal', '2013-06-10 21:03:42'),
  351. (211, 'DOJ', '2013-06-10 21:03:42'),
  352. (212, 'Extorted', '2013-06-10 21:03:42'),
  353. (213, 'Florida', '2013-06-10 21:03:42'),
  354. (214, 'Alabama', '2013-06-10 21:03:42'),
  355. (215, 'Los Angeles', '2013-06-10 21:03:42'),
  356. (216, 'California', '2013-06-10 21:03:42'),
  357. (217, 'Milwakee', '2013-06-10 21:03:42'),
  358. (218, 'NSA', '2013-06-10 21:03:42'),
  359. (219, 'DHS', '2013-06-10 21:03:42'),
  360. (220, 'D.C', '2013-06-10 21:03:42'),
  361. (221, 'Arizona', '2013-06-10 21:03:42'),
  362. (222, 'Philidelphia', '2013-06-10 21:03:42'),
  363. (223, 'Bombing', '2013-06-10 21:03:42'),
  364. (224, 'Boston', '2013-06-10 21:03:42'),
  365. (225, 'Eric Holder', '2013-06-10 21:03:42'),
  366. (226, 'McCain', '2013-06-10 21:03:42'),
  367. (227, 'Ronald Reagan', '2013-06-10 21:03:42'),
  368. (228, 'Politics', '2013-06-10 21:03:42'),
  369. (229, 'Utah', '2013-06-10 21:03:42'),
  370. (230, 'infomocracy', '2013-06-10 21:03:42'),
  371. (231, 'Obama', '2013-06-10 21:03:42'),
  372. (232, 'FEMA', '2013-06-10 21:03:42'),
  373. (233, 'EPA', '2013-06-10 21:03:42'),
  374. (234, 'Gun Control', '2013-06-10 21:03:42'),
  375. (235, 'IRS Scandal', '2013-06-10 21:03:42'),
  376. (236, 'Charlie Veitch', '2013-06-10 21:03:42'),
  377. (237, 'ReThink911', '2013-06-10 21:03:42'),
  378. (238, '911', '2013-06-10 21:03:42'),
  379. (239, 'Nabraska', '2013-06-10 21:03:42'),
  380. (240, 'Freedom', '2013-06-10 21:03:42'),
  381. (241, 'Ohio', '2013-06-10 21:03:42'),
  382. (242, 'Colorado', '2013-06-10 21:03:42'),
  383. (243, 'NRA', '2013-06-10 21:03:42'),
  384. (244, 'Washington', '2013-06-10 21:03:42'),
  385. (245, 'Benghazi Scandal', '2013-06-10 21:03:42'),
  386. (246, 'Taxes', '2013-06-10 21:03:42'),
  387. (247, 'Oregon', '2013-06-10 21:03:42'),
  388. (248, 'USDA', '2013-06-10 21:03:42'),
  389. (249, 'Fox News', '2013-06-10 21:03:42'),
  390. (250, 'Iowa', '2013-06-10 21:03:42'),
  391. (251, 'FDA', '2013-06-10 21:03:42'),
  392. (252, 'TEApublician', '2013-06-10 21:03:42'),
  393. (253, 'Zuckerberge', '2013-06-10 21:03:42'),
  394. (254, 'Obamacare', '2013-06-10 21:03:42'),
  395. (255, 'Nasa', '2013-06-10 21:03:42'),
  396. (256, 'NYC', '2013-06-10 21:03:42'),
  397. (258, 'Donald Trump', '2013-06-10 21:03:42'),
  398. (259, 'Sanata Monica', '2013-06-10 21:03:42'),
  399. (260, 'Operation Mind Control', '2013-06-10 21:03:42'),
  400. (261, 'Kansas', '2013-06-10 21:03:42'),
  401. (262, 'GUNS', '2013-06-10 21:03:42'),
  402. (263, 'Sandy Hook', '2013-06-10 21:03:42'),
  403. (264, 'Secretary of Defence', '2013-06-10 21:03:42'),
  404. (265, 'Military', '2013-06-10 21:03:42'),
  405. (266, 'Tax-Payers', '2013-06-10 21:03:42'),
  406. (267, 'Pennsylvania', '2013-06-10 21:03:42'),
  407. (268, 'New Jersey', '2013-06-10 21:03:42'),
  408. (269, 'Oklahoma', '2013-06-10 21:03:42'),
  409. (270, 'Bush', '2013-06-10 21:03:42'),
  410. (271, 'Keneticut', '2013-06-10 21:03:42'),
  411. (272, 'Sharia Law', '2013-06-10 21:03:42'),
  412. (273, 'Maine', '2013-06-10 21:03:42'),
  413. (274, 'Connecticut', '2013-06-10 21:03:42'),
  414. (275, 'Head Start', '2013-06-10 21:03:42'),
  415. (276, 'Illinois', '2013-06-10 21:03:42'),
  416. (277, 'Patriot Act', '2013-06-10 21:03:43'),
  417. (279, 'Homeland Security', '2013-06-10 21:03:43'),
  418. (280, 'GOP', '2013-06-10 21:03:43'),
  419. (281, 'Vermont', '2013-06-10 21:03:43'),
  420. (282, 'Bill Clinton', '2013-06-10 21:03:43'),
  421. (283, 'USA', '2013-06-10 21:03:43'),
  422. (284, 'Hong Kong', '2013-06-10 21:03:43'),
  423. (286, 'Statistics', '2013-06-10 21:03:43'),
  424. (287, 'Pakistan', '2013-06-10 21:03:43'),
  425. (288, 'Russia', '2013-06-10 21:03:43'),
  426. (290, 'Chile', '2013-06-10 21:03:43'),
  427. (292, 'Wealthist', '2013-06-10 21:03:43'),
  428. (293, 'Israel', '2013-06-10 21:03:43'),
  429. (294, 'War', '2013-06-10 21:03:43'),
  430. (295, 'False Flag', '2013-06-10 21:03:43'),
  431. (296, 'Mexico', '2013-06-10 21:03:43'),
  432. (297, 'U.N', '2013-06-10 21:03:43'),
  433. (298, 'Japan', '2013-06-10 21:03:43'),
  434. (299, 'UK (old country)', '2013-06-10 21:03:43'),
  435. (300, 'Aspertame', '2013-06-10 21:03:43'),
  436. (301, 'Gene VI', '2013-06-10 21:03:43'),
  437. (302, 'New Tech', '2013-06-10 21:03:43'),
  438. (303, 'GMO', '2013-06-10 21:03:43'),
  439. (304, 'Monsanto', '2013-06-10 21:03:43'),
  440. (305, 'Martial Law', '2013-06-10 21:03:43'),
  441. (306, 'Occupy', '2013-06-10 21:03:43'),
  442. (307, 'Islam', '2013-06-10 21:03:43'),
  443. (308, 'Denmark', '2013-06-10 21:03:43'),
  444. (309, 'Non-GMO', '2013-06-10 21:03:43'),
  445. (310, 'El Salvador', '2013-06-10 21:03:43'),
  446. (311, 'BBC', '2013-06-10 21:03:43'),
  447. (312, 'EU', '2013-06-10 21:03:43'),
  448. (314, 'Brazil', '2013-06-10 21:03:43'),
  449. (315, 'Syria', '2013-06-10 21:03:43'),
  450. (316, 'Ankara', '2013-06-10 21:03:43'),
  451. (317, 'Turkey', '2013-06-10 21:03:43'),
  452. (318, 'NATO', '2013-06-10 21:03:43'),
  453. (319, 'WW3', '2013-06-10 21:03:43'),
  454. (320, 'Global Warming', '2013-06-10 21:03:43'),
  455. (321, 'Human Rights', '2013-06-10 21:03:43'),
  456. (322, 'Protocols', '2013-06-10 21:03:43'),
  457. (323, 'cARD', '2013-06-10 21:03:43'),
  458. (324, 'Bundy', '2013-06-10 21:03:43'),
  459. (325, 'Astor', '2013-06-10 21:03:43'),
  460. (326, 'Collins', '2013-06-10 21:03:43'),
  461. (327, 'DuPont', '2013-06-10 21:03:43'),
  462. (328, 'Freeman', '2013-06-10 21:03:43'),
  463. (329, 'Kennedy', '2013-06-10 21:03:43'),
  464. (330, 'Li', '2013-06-10 21:03:43'),
  465. (331, 'Onassis', '2013-06-10 21:03:43'),
  466. (332, 'Reynolds', '2013-06-10 21:03:43'),
  467. (333, 'Rockefeller', '2013-06-10 21:03:43'),
  468. (334, 'Rothschild', '2013-06-10 21:03:43'),
  469. (335, 'Russell', '2013-06-10 21:03:43'),
  470. (336, 'Van Duyn', '2013-06-10 21:03:43'),
  471. (337, 'Illuminati', '2013-06-10 21:03:43'),
  472. (338, 'Annonymous', '2013-06-10 21:03:43'),
  473. (339, 'Egypt', '2013-06-10 21:03:43'),
  474. (340, 'Government Beauracy', '2013-06-10 21:03:43'),
  475. (341, 'World Bank', '2013-06-10 21:03:43'),
  476. (342, 'TSA', '2013-06-10 21:03:43'),
  477. (343, 'Iraq', '2013-06-10 21:03:43'),
  478. (344, 'Agenda 21', '2013-06-10 21:03:43'),
  479. (345, 'Peru', '2013-06-10 21:03:43'),
  480. (346, 'Sovereign', '2013-06-10 21:03:43'),
  481. (347, 'Greece', '2013-06-10 21:03:43'),
  482. (348, 'Australia', '2013-06-10 21:03:43'),
  483. (349, 'Nevada', '2013-06-10 21:03:43'),
  484. (350, 'Operation Paperclip', '2013-06-10 21:03:43'),
  485. (351, 'Red Flag', '2013-06-10 21:03:43'),
  486. (352, 'FED', '2013-06-10 21:03:43'),
  487. (353, 'Cuba', '2013-06-10 21:03:43'),
  488. (354, 'South Korea', '2013-06-10 21:03:43'),
  489. (355, 'Philippines', '2013-06-10 21:03:43'),
  490. (356, 'Bilderberg Group', '2013-06-10 21:03:43'),
  491. (357, 'Kenya', '2013-06-10 21:03:43'),
  492. (359, 'Germany', '2013-06-10 21:03:43'),
  493. (360, 'Miss World Competition', '2013-06-10 21:03:43'),
  494. (362, 'International', '2013-06-10 21:03:43'),
  495. (363, 'LGBT', '2013-06-10 21:03:43'),
  496. (364, 'Impeach', '2013-06-10 21:03:43'),
  497. (365, 'Conterveries', '2013-06-10 21:03:44'),
  498. (366, 'psychology', '2013-06-10 21:03:44'),
  499. (367, 'Apocalypse', '2013-06-10 21:03:44'),
  500. (368, 'Self', '2013-06-10 21:03:44'),
  501. (369, 'Appearences', '2013-06-10 21:03:44'),
  502. (370, 'Positive', '2013-06-10 21:03:44'),
  503. (372, 'Moral', '2013-06-10 21:03:44'),
  504. (373, 'Obese', '2013-06-10 21:03:44'),
  505. (374, 'Muslim', '2013-06-10 21:03:44'),
  506. (375, 'Judism', '2013-06-10 21:03:44'),
  507. (376, 'Religion', '2013-06-10 21:03:44'),
  508. (377, 'Secrets of the universe', '2013-06-10 21:03:44'),
  509. (378, 'Atheism', '2013-06-10 21:03:44'),
  510. (379, 'Meaning of Life', '2013-06-10 21:03:44'),
  511. (380, 'Education', '2013-06-10 21:03:44'),
  512. (381, 'Pay Attention', '2013-06-10 21:03:44'),
  513. (382, 'Press', '2013-06-10 21:03:44'),
  514. (383, 'Memes', '2013-06-10 21:03:44'),
  515. (384, 'Soda Pop', '2013-06-10 21:03:44'),
  516. (385, 'Matrix', '2013-06-10 21:03:44'),
  517. (386, 'Advertising', '2013-06-10 21:03:44'),
  518. (387, 'Flu', '2013-06-10 21:03:44'),
  519. (388, 'Poverty', '2013-06-10 21:03:44'),
  520. (389, 'Exxon Mobil', '2013-06-10 21:03:44'),
  521. (390, 'Capitalism', '2013-06-10 21:03:44'),
  522. (391, '1 Percent', '2013-06-10 21:03:44'),
  523. (392, 'WikiLeaks', '2013-06-10 21:03:44'),
  524. (393, 'Skinning', '2013-06-10 21:03:44'),
  525. (394, 'Sex', '2013-06-10 21:03:44'),
  526. (395, 'Radical', '2013-06-10 21:03:44'),
  527. (396, 'Meditation', '2013-06-10 21:03:44'),
  528. (397, 'Social Media', '2013-06-10 21:03:44');
  529.  
  530. -- --------------------------------------------------------
  531.  
  532. --
  533. -- Table structure for table `label_categories`
  534. --
  535.  
  536. CREATE TABLE IF NOT EXISTS `label_categories` (
  537.   `category_id` int(5) NOT NULL,
  538.   `label_id` int(5) NOT NULL,
  539.   KEY `category_id` (`category_id`),
  540.   KEY `label_id` (`label_id`)
  541. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  542.  
  543. --
  544. -- Dumping data for table `label_categories`
  545. --
  546.  
  547. INSERT INTO `label_categories` (`category_id`, `label_id`) VALUES
  548. (1, 1),
  549. (1, 2),
  550. (1, 3),
  551. (1, 4),
  552. (1, 5),
  553. (1, 6),
  554. (1, 7),
  555. (1, 8),
  556. (1, 9),
  557. (1, 10),
  558. (1, 11),
  559. (1, 12),
  560. (1, 13),
  561. (1, 14),
  562. (1, 15),
  563. (1, 16),
  564. (1, 17),
  565. (1, 18),
  566. (1, 19),
  567. (1, 20),
  568. (1, 21),
  569. (1, 22),
  570. (1, 23),
  571. (1, 24),
  572. (1, 25),
  573. (1, 26);
  574.  
  575. -- --------------------------------------------------------
  576.  
  577. --
  578. -- Table structure for table `label_item`
  579. --
  580.  
  581. CREATE TABLE IF NOT EXISTS `label_item` (
  582.   `id` int(10) NOT NULL,
  583.   `label_id` int(5) NOT NULL,
  584.   `directory` text NOT NULL,
  585.   `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  586.   PRIMARY KEY (`id`)
  587. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  588.  
  589. --
  590. -- Constraints for dumped tables
  591. --
  592.  
  593. --
  594. -- Constraints for table `label_categories`
  595. --
  596. ALTER TABLE `label_categories`
  597.   ADD CONSTRAINT `label_categories_ibfk_2` FOREIGN KEY (`label_id`) REFERENCES `labels` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  598.   ADD CONSTRAINT `label_categories_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!