Accidently Deleted My Spiders (How do I get them back?)

[Edifier]

I deleted the spiders on accident, you know where it tracks which spiders come to the site? Confused this for something else... How can I get them back? I probably have to re-enter the data myself, right? If so can someone post the spider names and ip addresses and whatever else I need here for me? Thanks!

[live627]

Go into phpMyAdmin, select your database, and execute the following SQL query:

Code Select Expand

INSERT INTO `smf_spiders` (`id_spider`, `spider_name`, `user_agent`, `ip_info`) VALUES
(1, 'Google', 'googlebot', ''),
(2, 'Google (Mobile)', 'Googlebot-Mobile', ''),
(3, 'Google (Image)', 'Googlebot-Image', ''),
(4, 'Google (AdSense)', 'Mediapartners-Google', ''),
(5, 'Google (Adwords)', 'AdsBot-Google', ''),
(6, 'Yahoo!', 'slurp', ''),
(7, 'Yahoo! (Mobile)', 'YahooSeeker/M1A1-R2D2', ''),
(8, 'Yahoo! (Image)', 'Yahoo-MMCrawler', ''),
(10, 'MSN (Mobile)', 'MSNBOT_Mobile', ''),
(11, 'MSN (Media)', 'msnbot-media', ''),
(12, 'MSN', 'msnbot', ''),
(13, 'Cuil', 'twiceler', ''),
(14, 'Ask', 'Teoma', ''),
(15, 'Baidu', 'Baiduspider', ''),
(16, 'Gigablast', 'Gigabot', ''),
(17, 'InternetArchive', 'ia_archiver-web.archive.org', ''),
(18, 'Alexa', 'ia_archiver', ''),
(19, 'Omgili', 'omgilibot', ''),
(20, 'EntireWeb', 'Speedy Spider', ''),
(9, 'Yahoo! (Image)', 'Yahoo-MMCrawler', ''),
(21, 'Google-SA', 'gsa-crawler', ''),
(22, 'Yahoo', 'yahoo', ''),
(23, 'Yahoo JP', 'Y!J', ''),
(24, 'DeadLinksChecker', 'link validator', ''),
(25, 'W3C Validator', 'W3C_Validator', ''),
(26, 'W3C CSSValidator', 'W3C_CSS_Validator', ''),
(27, 'W3C FeedValidator', 'FeedValidator', ''),
(28, 'W3C LinkChecker', 'W3C-checklink', ''),
(29, 'W3C mobileOK', 'W3C-mobileOK', ''),
(30, 'W3C P3PValidator', 'P3P Validator', ''),
(31, 'Bloglines', 'Bloglines', ''),
(32, 'Feedburner', 'Feedburner', ''),
(33, 'SnapBot', 'Snapbot', ''),
(34, 'Picsearch', 'psbot', ''),
(35, 'Websnapr', 'Websnapr', ''),
(36, 'AllTheWeb', 'FAST-WebCrawler', ''),
(37, 'Altavista', 'Scooter', ''),
(38, 'Asterias', 'asterias', ''),
(39, '192bot', '192.comAgent', ''),
(40, 'AbachoBot', 'ABACHOBot', ''),
(41, 'Abdcatos', 'abcdatos', ''),
(42, 'Acoon', 'Acoon', ''),
(43, 'Accoona', 'Accoona', ''),
(44, 'BecomeBot', 'BecomeBot', ''),
(45, 'BlogRefsBot', 'BlogRefsBot', ''),
(46, 'Daumoa', 'Daumoa', ''),
(47, 'DuckDuckBot', 'DuckDuckBot', ''),
(48, 'Exabot', 'Exabot', ''),
(49, 'Furl', 'Furlbot', ''),
(50, 'FyperSpider', 'FyberSpider', ''),
(51, 'Geona', 'GeonaBot', ''),
(52, 'GirafaBot', 'Girafabot', ''),
(53, 'GoSeeBot', 'GoSeeBot', ''),
(54, 'Ichiro', 'ichiro', ''),
(55, 'LapozzBot', 'LapozzBot', ''),
(56, 'Looksmart', 'WISENutbot', ''),
(57, 'Lycos', 'Lycos_Spider', ''),
(58, 'Majestic12', 'MJ12bot/v2', ''),
(59, 'MLBot', 'MLBot', ''),
(60, 'MSRBOT', 'msrbot', ''),
(61, 'MSR-ISRCCrawler', 'MSR-ISRCCrawler', ''),
(62, 'Naver', 'NaverBot', ''),
(63, 'Naver', 'Yeti', ''),
(64, 'NoxTrumBot', 'noxtrumbot', ''),
(65, 'OmniExplorer', 'OmniExplorer_Bot', ''),
(66, 'OnetSzukaj', 'OnetSzukaj', ''),
(67, 'ScrubTheWeb', 'Scrubby', ''),
(68, 'SearchSight', 'SearchSight', ''),
(69, 'Seeqpod', 'Seeqpod', ''),
(70, 'Shablast', 'ShablastBot', ''),
(71, 'SitiDiBot', 'SitiDiBot', ''),
(72, 'Slider', 'silk/1.0', ''),
(73, 'Sogou', 'Sogou', ''),
(74, 'Sosospider', 'Sosospider', ''),
(75, 'StackRambler', 'StackRambler', ''),
(76, 'SurveyBot', 'SurveyBot', ''),
(77, 'Touche', 'Touche', ''),
(78, 'Walhello', 'appie', ''),
(79, 'WebAlta', 'WebAlta', ''),
(80, 'Wisponbot', 'wisponbot', ''),
(81, 'YacyBot', 'yacybot', ''),
(82, 'YodaoBot', 'YodaoBot', ''),
(83, 'Charlotte', 'Charlotte', ''),
(84, 'DiscoBot', 'DiscoBot', ''),
(85, 'EnaBot', 'EnaBot', ''),
(86, 'Gaisbot', 'Gaisbot', ''),
(87, 'Kalooga', 'kalooga', ''),
(88, 'ScoutJet', 'ScoutJet', ''),
(89, 'TinEye', 'TinEye', ''),
(90, 'GSiteCrawler', 'GSiteCrawler', ''),
(91, 'HTTrack', 'HTTrack', ''),
(92, 'Wget', 'Wget', '');


[Edifier]

Thanks so much, just a quick question because I'm a noob with this kind of thing...

Do I enter this part to or do I start with where you began your list at 1? Do I put this: `smf_spiders` (`id_spider`, `spider_name`, `user_agent`, `ip_info`) VALUES?

[live627]

Just dump the whole thing. It's an export straight from my smf_spiders