Ripristino Bot spiders

[metal master]

Per un mio errore ho cancellato usando il file manage bots.php,la lista di tutti i bot e spider ed ora non trovo il file.

Come posso fare per ripristinarli di nuovo?

Grazie.

[Haku]

Scarica il pacchetto 3.0.9 (se la versione che usi segnata nel tuo profilo è giusta) e ripristini il file.

[metal master]

Quale file?

Praticamente ieri ho utilizzato lo script di pony99ca (manage_bots.php) che aggiorna i bot.
Ora non so che pasticcio ho combinato,ma se vado in acp nei gruppi mi vede tutti e 276 i bot,nelle tabelle del database sono tutti presenti,ma alla voce "bot" in sistema mi vede solo questi

[metal master]

Ah dimenticavo: mi hanno consigliato di utilizzare questa query

Codice: Seleziona tutto

    INSERT INTO phpbb_bots (bot_id, bot_active, bot_name, user_id, bot_agent, bot_ip) VALUES (1, 1, 'AdsBot [Google]', 3, 'AdsBot-Google', ''),(2, 1, 'Alexa [Bot]', 4, 'ia_archiver', ''),(3, 1, 'Alta Vista [Bot]', 5, 'Scooter/', ''),(4, 1, 'Ask Jeeves [Bot]', 6, 'Ask Jeeves', ''),(5, 1, 'Baidu [Spider]', 7, 'Baiduspider+(', ''),(6, 1, 'Exabot [Bot]', 8, 'Exabot/', ''),(7, 1, 'FAST Enterprise [Crawler]', 9, 'FAST Enterprise Crawler', ''),(8, 1, 'FAST WebCrawler [Crawler]', 10, 'FAST-WebCrawler/', ''),(9, 1, 'Francis [Bot]', 11, 'http://www.neomo.de/', ''),(10, 1, 'Gigabot [Bot]', 12, 'Gigabot/', ''),(11, 1, 'Google Adsense [Bot]', 13, 'Mediapartners-Google', ''),(12, 1, 'Google Desktop', 14, 'Google Desktop', ''),(13, 1, 'Google Feedfetcher', 15, 'Feedfetcher-Google', ''),(14, 1, 'Google [Bot]', 16, 'Googlebot', ''),(15, 1, 'Heise IT-Markt [Crawler]', 17, 'heise-IT-Markt-Crawler', ''),(16, 1, 'Heritrix [Crawler]', 18, 'heritrix/1.', ''),(17, 1, 'IBM Research [Bot]', 19, 'ibm.com/cs/crawler', ''),(18, 1, 'ICCrawler - ICjobs', 20, 'ICCrawler - ICjobs', ''),(19, 1, 'ichiro [Crawler]', 21, 'ichiro/', ''),(20, 1, 'Majestic-12 [Bot]', 22, 'MJ12bot/', ''),(21, 1, 'Metager [Bot]', 23, 'MetagerBot/', ''),(22, 1, 'MSN NewsBlogs', 24, 'msnbot-NewsBlogs/', ''),(23, 1, 'MSN [Bot]', 25, 'msnbot/', ''),(24, 1, 'MSNbot Media', 26, 'msnbot-media/', ''),(25, 1, 'NG-Search [Bot]', 27, 'NG-Search/', ''),(26, 1, 'Nutch [Bot]', 28, 'http://lucene.apache.org/nutch/', ''),(27, 1, 'Nutch/CVS [Bot]', 29, 'NutchCVS/', ''),(28, 1, 'OmniExplorer [Bot]', 30, 'OmniExplorer_Bot/', ''),(29, 1, 'Online link [Validator]', 31, 'online link validator', ''),(30, 1, 'psbot [Picsearch]', 32, 'psbot/0', ''),(31, 1, 'Seekport [Bot]', 33, 'Seekbot/', ''),(32, 1, 'Sensis [Crawler]', 34, 'Sensis Web Crawler', ''),(33, 1, 'SEO Crawler', 35, 'SEO search Crawler/', ''),(34, 1, 'Seoma [Crawler]', 36, 'Seoma [SEO Crawler]', ''),(35, 1, 'SEOSearch [Crawler]', 37, 'SEOsearch/', ''),(36, 1, 'Snappy [Bot]', 38, 'Snappy/1.1 ( http://www.urltrends.com/ )', ''),(37, 1, 'Steeler [Crawler]', 39, 'http://www.tkl.iis.u-tokyo.ac.jp/~crawler/', ''),(38, 1, 'Synoo [Bot]', 40, 'SynooBot/', ''),(39, 1, 'Telekom [Bot]', 41, 'crawleradmin.t-info@telekom.de', ''),(40, 1, 'TurnitinBot [Bot]', 42, 'TurnitinBot/', ''),(41, 1, 'Voyager [Bot]', 43, 'voyager/1.0', ''),(42, 1, 'W3 [Sitesearch]', 44, 'W3 SiteSearch Crawler', ''),(43, 1, 'W3C [Linkcheck]', 45, 'W3C-checklink/', ''),(44, 1, 'W3C [Validator]', 46, 'W3C_*Validator', ''),(45, 1, 'WiseNut [Bot]', 47, 'http://www.WISEnutbot.com', ''),(46, 1, 'YaCy [Bot]', 48, 'yacybot', ''),(47, 1, 'Yahoo MMCrawler [Bot]', 49, 'Yahoo-MMCrawler/', ''),(48, 1, 'Yahoo Slurp [Bot]', 50, 'Yahoo! DE Slurp', ''),(49, 1, 'Yahoo [Bot]', 51, 'Yahoo! Slurp', ''),(50, 1, 'YahooSeeker [Bot]', 52, 'YahooSeeker/', ''),(51, 1, 'FaceBook [Linkcheck]', 162, 'facebookexternalhit/1.1', ''),(52, 1, 'Java [Bad bot]', 166, 'Java/', ''),(53, 1, 'Thumbshots [Capture]', 167, 'thumbshots-de-Bot', ''),(54, 1, 'Susie [Sync]', 168, '!Susie', ''),(55, 1, 'Google Ads', 169, 'AdsBot-Google', ''),(56, 1, 'Google Python URL fetcher', 170, 'Python-urllib/', ''),(57, 1, 'Google Search Appliance', 171, 'gsa', ''),(58, 1, 'Yahoo! SpiderMan', 172, 'SpiderMan', ''),(59, 1, 'Yahoo! Mindset', 173, 'Yahoo! Mindset', ''),(60, 1, 'Yahoo! Blogs', 174, 'Yahoo-Blogs', ''),(61, 1, 'Yahoo! Feed Seeker', 175, 'YahooFeedSeeker', ''),(62, 1, 'Yahoo! Multimedia', 176, 'Yahoo-MM', ''),(63, 1, 'Yahoo! Test', 177, 'Yahoo-Test', ''),(64, 1, 'Yahoo! VerticalCrawler', 178, 'Yahoo-VerticalCrawler', ''),(65, 1, 'Fast PartnerSite', 179, 'Fast PartnerSite Crawler', ''),(66, 1, 'Fast Crawler Gold', 180, 'Fast Crawler Gold Edition', ''),(67, 1, 'FAST FirstPage retriever', 181, 'FAST FirstPage retriever', ''),(68, 1, 'FAST MetaWeb', 182, 'FAST MetaWeb Crawler', ''),(69, 1, 'Yahoo! Search Marketing', 183, 'crawlx', ''),(70, 1, 'Walhello', 184, 'appie', ''),(71, 1, 'GeoBot', 185, 'GeoBot/version', ''),(72, 1, 'suchpad', 186, 'http://www.suchpad.de/bot/', ''),(73, 1, 'Insuranco', 187, 'InsurancoBot', ''),(74, 1, 'Xaldon', 188, 'Xaldon WebSpider', ''),(75, 1, 'Cosmix [Bot]', 189, 'cfetch/', ''),(76, 1, 'Esperanza [Bot]', 190, 'EsperanzaBot', ''),(77, 1, 'EliteSys', 191, 'EliteSys SuperBot/', ''),(78, 1, 'MP3-Bot [Bot]', 192, 'MP3-Bot', ''),(79, 1, 'genie', 193, 'genieBot (', ''),(80, 1, 'g2', 194, 'g2Crawler', ''),(81, 1, 'GBSpider', 195, 'GBSpider v', ''),(82, 1, 'Picsearch', 196, 'psbot/', ''),(83, 1, 'PlantyNet [Bot]', 197, 'PlantyNet_WebRobot_V', ''),(84, 1, 'Twiceler', 198, 'Twiceler www.cuill.com/robots.html', ''),(85, 1, 'IPG', 199, 'internet-provider-guenstig.de-Bot', ''),(86, 1, 'WissenOnline', 200, 'WissenOnline-Bot', ''),(87, 1, '24spider [Spider]', 201, '24spider-Robot', ''),(88, 1, 'Zerx', 202, 'zerxbot/', ''),(89, 1, 'LinkWalker', 203, 'LinkWalker', ''),(90, 1, 'Exabot', 204, 'Exabot/', ''),(91, 1, 'Jyxobot', 205, 'Jyxobot/', ''),(92, 1, 'Tbot', 206, 'Tbot/', ''),(93, 1, 'Findexa [Crawler]', 207, 'Findexa Crawler (', ''),(94, 1, 'ISC Systems iRc Search', 208, 'ISC Systems iRc Search', ''),(95, 1, 'IRLbot', 209, 'http://irl.cs.tamu.edu/crawler', ''),(96, 1, 'Mirago', 210, 'HeinrichderMiragoRobot (', ''),(97, 1, 'Sygol', 211, 'SygolBot', ''),(98, 1, 'WWWeasel', 212, 'WWWeasel Robot v', ''),(99, 1, 'Naver', 213, 'nhnbot@naver.com', ''),(100, 1, 'MMSWeb [Bot]', 214, 'http://www.mmsweb.at/bot.html', ''),(101, 1, 'Hogsearch', 215, 'oegp v. ', ''),(102, 1, 'Kraehe', 216, '-DIE-KRAEHE- META-SEARCH-ENGINE/', ''),(103, 1, 'Vagabondo', 217, 'http://webagent.wise-guys.nl/', ''),(104, 1, 'Nimble', 218, 'NimbleCrawler', ''),(105, 1, 'Bunnybot [Bot]', 219, 'powered by www.buncat.de', ''),(106, 1, 'Boitho', 220, 'boitho.com-dc/', ''),(107, 1, 'Scumbot', 221, 'Scumbot/', ''),(108, 1, 'GeigerzaehlerBot', 222, 'http://www.geigerzaehler.org/bot.html', ''),(109, 1, 'Orbiter', 223, 'http://www.dailyorbit.com/bot.htm', ''),(110, 1, 'ASPseek [Bot]', 224, 'ASPseek/', ''),(111, 1, 'Crawler Search [Crawler]', 225, '.Crawler-Search.de', ''),(112, 1, 'Singingfish Asterias', 226, 'Asterias', ''),(113, 1, 'NetResearchServer', 227, 'NetResearchServer/', ''),(114, 1, 'OrangeSpider', 228, 'OrangeSpider', ''),(115, 1, 'McSeek', 229, 'powered by www.McSeek.de', ''),(116, 1, 'Accoona', 230, 'Accoona-AI-Agent/', ''),(117, 1, 'Webmeasurement', 231, 'webmeasurement-bot,', ''),(118, 1, '123spider [Spider]', 232, '123spider-Bot', ''),(119, 1, 'Cometrics [Bot]', 233, 'cometrics-bot,', ''),(120, 1, 'Houxou', 234, 'HouxouCrawler/', ''),(121, 1, 'Ocelli', 235, 'Ocelli/', ''),(122, 1, 'EchO!', 236, 'EchO!/', ''),(123, 1, 'Gigablast', 237, 'gigablast.com/', ''),(124, 1, 'SurveyBot', 238, 'SurveyBot/', ''),(125, 1, 'Marvin Medhunt', 239, 'Marvin', ''),(126, 1, 'InfoSeek SideWinder', 240, 'Infoseek SideWinder/', ''),(127, 1, 'InternetSeer', 241, 'InternetSeer', ''),(128, 1, 'Rambler', 242, 'StackRambler/', ''),(129, 1, 'Vestris Alkaline', 243, 'AlkalineBOT/', ''),(130, 1, 'Robozilla', 244, 'Robozilla/', ''),(131, 1, 'Openfind', 245, 'openfind.com', ''),(132, 1, 'Diggit! [Bot]', 246, 'Digger/', ''),(133, 1, 'Become', 247, 'become.com/', ''),(134, 1, 'NetSprint', 248, 'NetSprint', ''),(135, 1, 'Szukacz', 249, 'szukacz', ''),(136, 1, 'Gooro', 250, 'Gooru-WebSpider', ''),(137, 1, 'Onet', 251, 'OnetSzukaj', ''),(138, 1, 'Inktomi', 252, 'Inktomi', ''),(139, 1, 'Kraehe [Metasuche]', 253, '-DIE-KRAEHE- META-SEARCH-ENGINE/', ''),(140, 1, 'SnapPreview [bot]', 254, 'SnapPreviewBot', ''),(141, 1, 'XML Sitemap Generator [bot]', 255, 'XML Sitemaps Generator', ''),(142, 1, 'Google Sitemap [bot]', 256, 'GSMA/', ''),(143, 1, 'Larbin [bot]', 257, 'larbin_2.6.3', ''),(144, 1, 'Seznam [Bot]', 258, 'SeznamBot', ''),(145, 1, 'Indy Library [Bot]', 259, 'Indy Library', ''),(146, 1, 'Crawler0.1 [Crawler]', 260, 'Crawler0.1', ''),(147, 1, 'VoilaBot [Bot]', 261, 'VoilaBot', ''),(148, 1, 'Sogou [Bot]', 262, 'Sogou web spider', ''),(149, 1, 'MWI [bot]', 263, 'MWI-UCE-Checker', ''),(150, 1, 'Lycos [spider]', 264, 'Lycos_Spider_', ''),(151, 1, 'Speedy [spider]', 265, 'Speedy Spider', ''),(152, 1, 'Pagebull', 266, 'Pagebull', ''),(153, 1, 'panscient [spider]', 267, 'panscient.com', ''),(154, 1, 'libwww-perl', 268, 'libwww-perl', ''),(155, 1, 'SBIder [bot]', 269, 'SBIder/', ''),(156, 1, 'PHP version tracker', 270, 'PHP version tracker', ''),(157, 1, 'hbtronix [spider]', 271, 'hbtronix.spider', ''),(158, 1, 'over-zealus [bot]', 272, 'Opera/5.0 (Windows NT 4.0;US)', ''),(159, 1, 'HP Web PrintSmart', 273, 'HP Web PrintSmart', ''),(160, 1, 'NetworkedBlogs [Linkcheck]', 340, '', '67.228.87.83'),(161, 1, 'Ciricadoforum [RSS Bot]', 450, '', '212.227.101.211,87.106.69.47'),(162, 1, 'eDintorni', 501, 'eDintorni crawler', ''),(164, 1, 'PostRank', 535, 'PostRank/2.0', ''),(165, 1, 'Twitter [Bot]', 536, 'Twitterbot/0.1', ''),(166, 1, 'Twitter [Feed]', 538, 'TwitterFeed 3', ''),(167, 1, 'Tweetmeme [Bot]', 539, 'TweetmemeBot', ''),(168, 1, 'Omgili [Bot]', 542, 'omgilibot/0.3', ''),(169, 1, 'Technorati [Bot]', 544, 'Technoratibot/8.1', ''),(170, 1, 'Microsoft Bing/WinHttp [Bot]', 588, 'WinHttp', ''),(171, 1, 'Microsoft Bing [Bot]', 589, 'bingbot/2.0', ''),(172, 1, 'Topsy [Bot]', 590, 'Butterfly/1.0', ''),(173, 1, 'Bing [Bot]', 605, 'bingbot/', ''),(174, 1, 'Twitterbot [Bot]', 769, 'Twitterbot/1.0', ''),(175, 1, 'Ezooms [Bot]', 773, 'Ezooms/1.0', ''),(176, 1, 'Synthesio [Bot]', 776, 'Synthesio', ''),(177, 1, 'Trovatore [Bot]', 777, 'IlTrovatore', ''),(178, 1, 'Twitturly [Bot]', 778, 'Twitturly', ''),(179, 1, 'Wikiwix [Bot]', 779, 'wikiwix-bot-3.0', ''),(180, 1, 'PycURL [Bot]', 780, 'PycURL/', ''),(181, 1, 'PostRank [Bot]', 781, 'PostRank/', ''),(182, 1, 'Robots.txt Validator [Bot]', 782, 'Robots.txt Validator', ''),(183, 1, 'Ruby [Bot]', 783, 'Ruby/', ''),(184, 1, 'SearchHippo [Bot]', 784, 'Fluffy the spider', ''),(185, 1, 'Seznam Screenshot [Bot]', 785, 'Seznam screenshot-generator', ''),(186, 1, 'Snap Shots Preview [Bot]', 786, 'SnapPreviewBot', ''),(187, 1, 'Gooro [Spider]', 787, 'Gooru-WebSpider', ''),(188, 1, 'Google Web Preview [Crawler]', 788, 'Google Web Preview', ''),(189, 1, 'HMSEbot [SpamBot]', 789, 'HMSEbot', ''),(190, 1, 'HP Web PrintSmart [Bot]', 790, 'HP Web PrintSmart', ''),(191, 1, 'ImageShack [Bot]', 791, 'ImageShack Image Fetcher', ''),(192, 1, 'Internet Archive [Bot]', 792, 'archive.org_bot', ''),(193, 1, 'Brandwatch [Bot]', 793, 'magpie-crawler', ''),(194, 1, 'Brandwatch Jakarta [Bot]', 794, 'Jakarta Commons', '80.82.139'),(195, 1, 'Google Search Appliance [Crawler]', 796, 'gsa-crawler', '');

[metal master]

Strana sta cosa: nei gruppi li vede tutti e 276,nelle tabelle del database sono presenti,ma se vado in spider/robots in sistema nell'acp mi vede solo quella lista

Secondo voi e' normale?
Probabilmente si ripopolera' quando i bot non attivi nella lista torneranno a sniffare nel forum?

[metal master]

Ragazzi sapete come posso ripristinare la tabella dei bot come era in origine?

[Haku]

Non fate così tanti doppi post, portate pazienza e risponderemo alle vostre domande.

Per riportare tutto alla normalità, fai il procedimento inverso della MOD (non la ho mai vista e quindi non saprei come è), e per quanto riguarda il togliere i Bot dal database, basta eliminare le relative tabelle (?), stando attento ovviamente a non eliminare quelli di default di phpBB.

Inoltre, credo non vengano visualizzati in ACP per due motivi:
- La MOD non prevede nessuna visualizzazione in ACP
- Qualche modifica per l'ACP non andata a buon fine

[metal master]

Ho provato ad utilizzare lo script in maniera inversa: li ho tolti e poi li ho aggiunti tutti e la tabella spider/robots pare che si sia ripopolata di nuovo con tutti i bot.


Grazie per l'aiuto

[Haku]

Di nulla.
A disposizione

[Carlo]

Bastava cercare nel forum.

Tempo fa creati uno script PHP per ripristinare tutti i bot.
Se non sbaglio, anche l'STK contiene una funzione apposita.