Advertisement
terorama

rssloader / gqueries.sql

Aug 21st, 2012
252
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 5.63 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `gqueries` (
  2.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  3.   `name` VARCHAR(255) NOT NULL,
  4.   `http_query` VARCHAR(2000) NOT NULL,
  5.   PRIMARY KEY  (`id`)
  6. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=85 ;
  7.  
  8. --
  9. -- Дамп данных таблицы `gqueries`
  10. --
  11.  
  12. INSERT INTO `gqueries` (`id`, `name`, `http_query`) VALUES
  13. (55, 'test', 'test'),
  14. (56, 'test', 'test'),
  15. (57, 'Look At Me', 'http://www.lookatme.ru/mag/recent.atom'),
  16. (58, 'lookatme', 'http://www.lookatme.ru/mag/recent.atom'),
  17. (59, 'yandblog1', 'http://blogs.yandex.ru/search.rss?cat=theme'),
  18. (60, 'deviantart', 'http://backend.deviantart.com/rss.xml?q=boost:popular meta:all max_age:8h'),
  19. (61, 'rbcmain', 'http://static.feed.rbc.ru/rbc/internal/rss.rbc.ru/rbc.ru/mainnews.rss'),
  20. (62, 'bashorg', 'http://bash.im/rss/'),
  21. (63, 'afisha', 'http://feeds.feedburner.com/afisha_daily'),
  22. (64, 'afisha3', 'http://feeds.feedburner.com/afisha_cinema'),
  23. (65, 'lookatme3', 'http://www.lookatme.ru/my/popular.atom'),
  24. (66, 'bbc', 'http://wsrss.bbc.co.uk/russian/index.xml'),
  25. (67, 'rosbalt', 'http://feeds.feedburner.com/rosbalt?format=xml'),
  26. (68, 'gazeta', 'http://www.gazeta.ru/export/rss/lenta.xml'),
  27. (69, 'newsru', 'http://feeds.newsru.com/com/www/news/big'),
  28. (70, 'vesti', 'http://www.vesti.ru/vesti.rss'),
  29. (71, 'lookatme4', 'http://www.lookatme.ru/looks/recent.atom'),
  30. (72, 'jqueryforum', 'http://forum.jquery.com/feed'),
  31. (73, 'concerts', 'http://actionlist.ru/rss/'),
  32. (74, 'terorama', 'http://twitter.com/statuses/user_timeline/terorama.rss?count=500'),
  33. (75, 'zztest', 'http://kimdm79.hostenko.com/examples/phpnew/picport/parser.php?regexp8=span%5B%5E%3E%5Dclass%3D(%5B%22''%5D)mark%5B%5E%5C1%5D*%3F%5C1.*%3Fhref%3D(%5B%22''%5D)(%5B%5E%5C2%5D*%3F)%5C2&url8=http%3A%2F%2Ffotki.yandex.ru%2Fusers%2Fgeparda%2F&formstr8=%3Cli%3E%243%3C%2Fli%3E%09%09+%0A%09%09+&submit=true&nta'),
  34. (76, 'fishki1', 'http://kimdm79.hostenko.com/examples/phpnew/picport/parser.php?regexp8=fotocontext.*%3Fimg.*%3Fsrc%3D(%5B''%22%5D)(%5B%5E%5C1%5D*%3F)%5C1&url8=http%3A%2F%2Ffishki.net%2Fcomment.php%3Fid%3D80951&formstr8=%3Cli%3E%3Cimg+src%3D%22%242%22+%2F%3E%3C%2Fli%3E%09%09+%0A%09%09+&submit=true&nta'),
  35. (77, 'fyand3', 'http://kimdm79.hostenko.com/examples/phpnew/picport/parser.php?regexp8=div%5Cs*class%3D%22image%22.*%3F%3Cimg.*%3Fsrc%3D(%5B%22''%5D)(%5B%5E%5C1%5D*%3F)%5C1&url8=http%3A%2F%2Ffotki.yandex.ru%2Fusers%2Fkitsunesama5%2Fviewed%2F&formstr8=%3Cli%3E%3Cimg+src%3D%22%242%22%3E%3C%2Fli%3E%09%09+%0A%09%09+&submit=true&nta'),
  36. (78, 'ellf4', 'http://kimdm79.hostenko.com/examples/phpnew/picport/parser.php?regexp8=%3C%5B%5E%3E%5D*img%5B%5E%3E%5D*src%3D(%5B%22''%5D)(%5B%5E%5C1%3E%5D*posts%5B%5E%5C1%3E%5D*)%5C1%5B%5E%3E%5D*title%5B%5E%3E%5D*%3E&url8=http%3A%2F%2Fwww.ellf.ru%2Fphotographers%2F31538-dzhejms-xyuston-i-ego-tvorchestvo-25-foto.html&formstr8=%3Cli%3E%3Cimg+src%3D%22%242%22%3E%3C%2Fli%3E&submit=true&nta'),
  37. (79, 'yand_mov5', 'http://kimdm79.hostenko.com/examples/phpnew/picport/parser.php?regexp8=class%3D%22film%22.*%3F%3C%5Cs*a%5B%5E%3E%5D*href%3D(%5B''%22%5D)(%5B%5E%5C1%3E%5D*)%5C1%5B%5E%3E%5D*%3E(%5B%5E%3C%5D*)&url8=http%3A%2F%2Fblogs.yandex.ru%2Frating%2Fcinema%2F&formstr8=%3Cli%3E%3Ca+href%3D%22%242%22+target%3D%22_blank%22%3E%243%3C%2Fa%3E%3C%2Fli%3E&submit=true&nta'),
  38. (80, 'ellf_new5', 'http://kimdm79.hostenko.com/examples/phpnew/picport/parser.php?regexp8=%3Cdiv%5B%5E%3E%5D*class%3D%5B%22''%5Dpost%5B%22''%5D.*%3F%3Ch2%3E.*%3F%3Ca%5B%5E%3E%5D*href%3D(%5B''%22%5D)(%5B%5E(%5C1)%5D*%3F)%5C1%7CABC%7C%3Cdiv%5Cs*align%3D%5B%22''%5Dcenter%5B''%22%5D%5Cs*%3E.*%3F%3Cimg%5B%5E%3E%5D*src%3D(%5B%22''%5D)(%5B%5E(%5C1)%5D*)%5C1&url8=http%3A%2F%2Fwww.ellf.ru%2Fpage%2F3%2F&formstr8=%3Cli%3E%3Cimg+src%3D%22%242%22+%2F%3E%3C%2Fli%3E%09%09+%0A%09%09+&submit=true&nta'),
  39. (81, 'ellf_new6', 'http://kimdm79.hostenko.com/examples/phpnew/picport/parser.php?regexp8=%3Cdiv%5B%5E%3E%5D*class%3D%5B%22''%5Dpost%5B%22''%5D.*%3F%3Ch2%3E.*%3F%3Ca%5B%5E%3E%5D*href%3D(%5B''%22%5D)(%5B%5E(%5C1)%5D*%3F)%5C1%7CABC%7C%3Cdiv%5Cs*align%3D%5B%22''%5Dcenter%5B''%22%5D%5Cs*%3E.*%3F%3Cimg%5B%5E%3E%5D*src%3D(%5B%22''%5D)(%5B%5E(%5C1)%5D*)%5C1&url8=http%3A%2F%2Fwww.ellf.ru%2Fpage%2F4%2F&formstr8=%3Cli%3E%3Cimg+src%3D%22%242%22+%2F%3E%3C%2Fli%3E%09%09+%0A%09%09+&submit=true&nta'),
  40. (82, 'ellf_new7', 'http://kimdm79.hostenko.com/examples/phpnew/picport/parser.php?regexp8=%3Cdiv%5B%5E%3E%5D*class%3D%5B%22''%5Dpost%5B%22''%5D.*%3F%3Ch2%3E.*%3F%3Ca%5B%5E%3E%5D*href%3D(%5B''%22%5D)(%5B%5E(%5C1)%5D*%3F)%5C1%7CABC%7C%3Cdiv%5Cs*align%3D%5B%22''%5Dcenter%5B''%22%5D%5Cs*%3E.*%3F%3Cimg%5B%5E%3E%5D*src%3D(%5B%22''%5D)(%5B%5E(%5C1)%5D*)%5C1&url8=http%3A%2F%2Fwww.ellf.ru%2Fpage%2F5%2F&formstr8=%3Cli%3E%3Cimg+src%3D%22%242%22+%2F%3E%3C%2Fli%3E%09%09+%0A%09%09+&submit=true&nta'),
  41. (83, 'ellf_new8', 'http://kimdm79.hostenko.com/examples/phpnew/picport/parser.php?regexp8=%3Cdiv%5B%5E%3E%5D*class%3D%5B%22''%5Dpost%5B%22''%5D.*%3F%3Ch2%3E.*%3F%3Ca%5B%5E%3E%5D*href%3D(%5B''%22%5D)(%5B%5E(%5C1)%5D*%3F)%5C1%7CABC%7C%3Cdiv%5Cs*align%3D%5B%22''%5Dcenter%5B''%22%5D%5Cs*%3E.*%3F%3Cimg%5B%5E%3E%5D*src%3D(%5B%22''%5D)(%5B%5E(%5C1)%5D*)%5C1&url8=http%3A%2F%2Fwww.ellf.ru%2Fpage%2F6%2F&formstr8=%3Cli%3E%3Cimg+src%3D%22%242%22+%2F%3E%3C%2Fli%3E%09%09+%0A%09%09+&submit=true&nta'),
  42. (84, 'ellf_new9', 'http://kimdm79.hostenko.com/examples/phpnew/picport/parser.php?regexp8=%3Cdiv%5B%5E%3E%5D*class%3D%5B%22''%5Dpost%5B%22''%5D.*%3F%3Ch2%3E.*%3F%3Ca%5B%5E%3E%5D*href%3D(%5B''%22%5D)(%5B%5E(%5C1)%5D*%3F)%5C1%7CABC%7C%3Cdiv%5Cs*align%3D%5B%22''%5Dcenter%5B''%22%5D%5Cs*%3E.*%3F%3Cimg%5B%5E%3E%5D*src%3D(%5B%22''%5D)(%5B%5E(%5C1)%5D*)%5C1&url8=http%3A%2F%2Fwww.ellf.ru%2Fpage%2F7%2F&formstr8=%3Cli%3E%3Cimg+src%3D%22%242%22+%2F%3E%3C%2Fli%3E%09%09+%0A%09%09+&submit=true&nta');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement