As version 2 uses a different database structure (for faster results, and more features).

Basically, we need to copy your old tables, and then install the new ones. After this we convert all the old data into the new tables.

If you have alot of records in MySQL, this could take some time... and I do mean awhile. One of my clients had close to 1 million records, this took about 5 hours for MySQL to do.

The good news is that MySQL seems to be pretty good at juggling its resources, so once you start the conversion, it takes care of the rest (even if this takes 5 hours!).

If anyone out there has a better way of doing this, please, please let me know!

As we will be renaming database tables, the best thing to do is stop visitor stats from tracking while we upgrade. I have made an easy and safe way of doing this.

Open up 'visitor_stats/visitor_stats.php'. On line 11 to 16, un-comment this section.

It will look like this (when un-commented):

// Use this when swapping from v1 to v2...
// To test if the upgrade was successfull without allowing others in, user the url: www.yourdomain.com/?vs_test=Y
if (empty($vs_test)) {
$vs_test=$vs_test;
$vsadmin="Y";
}

Now save and upload this file into your current '/visitor_stats/' directory.

Do a quick test by going to your website and making sure you aren't being tracked in Visitor Stat 1, or that there are no errors.

Start by renaming these tables (I use phpmyadmin):

• vistats_pages
• vistats_user

  TO

• vistats_pages2
• vistats_user2

  
  Don't worry about 'vistats_counter' as this hasn't changed.

  Again, do a quick test by visiting your website, to make sure nothing has stuffed up now that we've renamed the tables.

# # Table structure for table `vistats_customer` # CREATE TABLE vistats_customer ( user_id int(25) NOT NULL default '0', user_visit int(10) NOT NULL default '1', customer_time int(10) default NULL, customer_id int(10) default NULL, customer_url varchar(255) default NULL, customer_order int(10) default NULL, customer_order_url varchar(255) default NULL, customer_total decimal(10,2) default NULL, KEY user_id (user_id), KEY customer_time (customer_time), KEY customer_id (customer_id), KEY user_visit (user_visit) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_customer_items` # CREATE TABLE vistats_customer_items ( order_id int(10) default NULL, user_id int(25) default NULL, item_time int(10) default NULL, item_qty int(10) default NULL, item_name varchar(255) default NULL, item_price decimal(10,2) default NULL, KEY order_id (order_id,user_id), KEY item_time (item_time) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_referrer` # CREATE TABLE vistats_referrer ( referrer_user_id int(25) NOT NULL default '0', referrer_visit_id int(25) NOT NULL default '1', referrer_se enum('Y','N') NOT NULL default 'N', referrer_start_time int(10) default NULL, referrer_page varchar(255) NOT NULL default 'Home', referrer_page_name varchar(255) NOT NULL default 'Home', referrer_page_link varchar(255) NOT NULL default '', referrer_page_from varchar(255) NOT NULL default 'Direct Request', referrer_name varchar(120) default NULL, referrer_short_url varchar(200) default NULL, referrer_keywords varchar(100) default NULL, KEY referrer_user_id (referrer_user_id), KEY referrer_visit_id (referrer_visit_id), KEY referrer_se (referrer_se), KEY referrer_start_time (referrer_start_time), KEY referrer_short_url (referrer_short_url) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_robot` # CREATE TABLE vistats_robot ( user_id int(25) NOT NULL auto_increment, robot_name varchar(255) default NULL, robot_language varchar(255) NOT NULL default '', robot_country varchar(255) default NULL, robot_first_visit int(10) default '0', user_last_visit int(10) default NULL, robot_computer varchar(255) default NULL, robot_browser varchar(255) default NULL, robot_os varchar(255) default NULL, robot_agent varchar(255) default NULL, robot_ip varchar(20) default NULL, comment text, PRIMARY KEY (user_id), UNIQUE KEY user_id (user_id), KEY user_first_visit (robot_first_visit), KEY user_last_visit (user_last_visit), KEY user_ip (robot_ip), FULLTEXT KEY user_name (robot_name) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_robot_pages` # CREATE TABLE vistats_robot_pages ( page_user_id int(25) NOT NULL default '0', page_visit_id int(25) NOT NULL default '1', page_visit_order int(25) NOT NULL default '1', page_start_time int(10) default NULL, page_finish_time int(10) default NULL, page_total_time varchar(35) default NULL, page varchar(255) NOT NULL default '', page_name varchar(255) NOT NULL default '', page_link varchar(255) NOT NULL default '', page_from varchar(255) NOT NULL default '', page_to varchar(255) NOT NULL default '', KEY page (page), KEY page_user_id (page_user_id), KEY page_visit_id (page_visit_id), KEY page_visit_order (page_visit_order), KEY page_start_time (page_start_time), KEY page_finish_time (page_finish_time), KEY page_name (page_name), FULLTEXT KEY page_from (page_from) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_robot_tracked` # CREATE TABLE vistats_robot_tracked ( robot_id int(6) NOT NULL auto_increment, robot_ua varchar(16) default NULL, robot_name varchar(200) default NULL, robot_comments text, robot_ip varchar(20) default NULL, robot_is_spam enum('Y','N') NOT NULL default 'N', robot_viewsite enum('Y','N') NOT NULL default 'Y', PRIMARY KEY (robot_id), UNIQUE KEY robot_id (robot_id), KEY robot_ua (robot_ua), KEY robot_ip (robot_ip), KEY robot_viewsite (robot_viewsite), KEY robot_is_spam (robot_is_spam), FULLTEXT KEY robot_ua_2 (robot_ua) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_search_engines` # CREATE TABLE vistats_search_engines ( se_id int(8) NOT NULL auto_increment, se_name varchar(50) NOT NULL default '', se_url varchar(255) NOT NULL default '', se_query varchar(15) NOT NULL default '', KEY se_id (se_id,se_query), FULLTEXT KEY se_url (se_url) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_user` # CREATE TABLE vistats_user ( user_id int(25) NOT NULL auto_increment, user_name varchar(255) default NULL, user_language varchar(255) default NULL, user_country varchar(255) default NULL, user_first_visit int(10) default NULL, user_last_visit int(10) default NULL, user_computer varchar(255) default NULL, user_browser varchar(255) default NULL, user_os varchar(255) default NULL, user_agent varchar(255) default NULL, user_ip varchar(20) default NULL, comment text, PRIMARY KEY (user_id), UNIQUE KEY user_id (user_id), KEY user_first_visit (user_first_visit), KEY user_last_visit (user_last_visit), KEY user_ip (user_ip), FULLTEXT KEY user_name (user_name), FULLTEXT KEY user_country (user_country), FULLTEXT KEY user_country_2 (user_country) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_user_block` # CREATE TABLE vistats_user_block ( blocked_id int(10) NOT NULL default '0', blocked_name varchar(120) default NULL, blocked_date int(10) default NULL, KEY blocked_id (blocked_id,blocked_date) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_user_flag` # CREATE TABLE vistats_user_flag ( flag_user_id int(25) default NULL, flag_user_visit int(10) NOT NULL default '1', flag_time int(10) default NULL, flag varchar(255) default NULL, KEY flag_user_id (flag_user_id,flag_time), KEY flag_user_visit (flag_user_visit) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_user_pages` # CREATE TABLE vistats_user_pages ( page_user_id int(25) NOT NULL default '0', page_visit_id int(25) NOT NULL default '1', page_visit_order int(25) NOT NULL default '1', page_start_time int(10) default NULL, page_finish_time int(10) default NULL, page_total_time varchar(35) default NULL, page varchar(255) NOT NULL default 'Home', page_name varchar(255) NOT NULL default 'Home', page_link varchar(255) default NULL, page_from varchar(255) NOT NULL default 'Direct Request', page_to varchar(255) default NULL, KEY page (page), KEY page_user_id (page_user_id), KEY page_visit_id (page_visit_id), KEY page_visit_order (page_visit_order), KEY page_start_time (page_start_time), KEY page_finish_time (page_finish_time), KEY page_name (page_name), FULLTEXT KEY page_from (page_from) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `vistats_user_pages_type` # CREATE TABLE vistats_user_pages_type ( user_id int(25) NOT NULL default '0', visit_id int(25) NOT NULL default '1', visit_order int(25) NOT NULL default '1', start_time int(10) default NULL, type varchar(255) NOT NULL default '', page varchar(255) default NULL, page_name varchar(255) default NULL, page_link varchar(255) default NULL, KEY page (type), KEY page_user_id (user_id), KEY page_visit_id (visit_id), KEY page_visit_order (visit_order), KEY page_start_time (start_time), KEY page_name (page_name) ) TYPE=MyISAM; # -------------------------------------------------------- # # Dumping data for table `vistats_robot_tracked` # INSERT INTO vistats_robot_tracked VALUES (3, 'scooter', 'Scooter', 'Altavista\'s robot. www.altavista.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (6, 'googlebot', 'Google', 'Google\'s robot. www.google.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (7, 'slurp', 'Slurp', 'Inktomi\'s robot (supplies results to HotBot , MSN Search, Overture, About.com)', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (8, 'webmoose', 'Webmoose', 'MSN.com\'s robot. www.msn.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (9, 'gulliver', 'Gulliver', 'Northern Light\'s robot. www.northernlight.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (10, 'lycos', 'Lycos', 'Lycos\'s robot. www.lycos.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (11, 'wombat', 'Wombat', 'WebWombat\'s robot (Australian only). www.webwombat.com.au', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (12, 'infoseek', 'Infoseek', 'Info Seek\'s robot. www.infoseek.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (13, 'askjeeves', 'Askjeeves', 'AskJeeves\'s robot. www.askjeeves.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (14, 'freecrawl', 'Free Crawl', 'Euroseek\'s robot (comes in multiple languages). www.euroseek.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (16, 'robozilla', 'Robozilla', 'DMOZ\'s Directory link checker robot. www.dmoz.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (17, 'zyborg', 'ZyBorg', 'WiseNut\'s robot. www.wisenutbot.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (18, 'Gigabot', 'Gigabot', 'Gigabot\'s robot. www.gigablast.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (19, 'Ask Jeeves/Teoma', 'Ask Jeeves/Teoma', 'Ask Jeeves/Teoma. www.teoma.com, www.askjeeves.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (20, 'grub-client', 'Grub', 'Looksmart Grub client robot. www.grub.org', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (21, 'linkwalker', 'Linkwalker', 'SevenTwentyFour link checker robot. www.seventwentyfour.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (22, 'ia_archiver', 'Internet Archive', 'Alexa & WayBackMachine\'s robot (archives websites). www.archive.org', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (23, 'TurnitinBot', 'TurnitinBot', 'Anti-Plagiarism robot. www.turnitin.com', NULL, 'N', 'Y'); INSERT INTO vistats_robot_tracked VALUES (30, 'atSpider', 'atSpider', 'Email Collector/Spam', '', 'Y', 'N'); INSERT INTO vistats_robot_tracked VALUES (31, 'autoemailspider', 'autoemailspider', 'Email Collector/Spam', NULL, 'Y', 'N'); INSERT INTO vistats_robot_tracked VALUES (32, 'cherrypicker', 'cherrypicker', 'Email Collector/Spam', NULL, 'Y', 'N'); INSERT INTO vistats_robot_tracked VALUES (33, 'DSurf', 'DSurf', 'Email Collector/Spam', NULL, 'Y', 'N'); INSERT INTO vistats_robot_tracked VALUES (34, 'DTS Agent', 'DTS Agent', 'Email Collector/Spam', NULL, 'Y', 'N'); INSERT INTO vistats_robot_tracked VALUES (35, 'EliteSys Entry', 'EliteSys Entry', 'Email Collector/Spam', NULL, 'Y', 'N'); INSERT INTO vistats_robot_tracked VALUES (36, 'EmailCollector', 'EmailCollector', 'Email Collector/Spam', NULL, 'Y', 'N'); INSERT INTO vistats_robot_tracked VALUES (37, 'EmailSiphon', 'EmailSiphon', 'Email Collector/Spam', NULL, 'Y', 'N'); INSERT INTO vistats_robot_tracked VALUES (38, 'EmailWolf', 'EmailWolf', 'Email Collector/Spam', NULL, 'Y', 'N'); INSERT INTO vistats_robot_tracked VALUES (39, 'Mail Sweeper', 'Mail Sweeper', 'Email Collector/Spam', NULL, 'Y', 'N'); INSERT INTO vistats_robot_tracked VALUES (42, 'msnbot', 'MSN Robot', 'MSNBot is a prototype web-crawling robot developed by MSN Search (http://search.msn.com/). It collects documents from the web to build a searchable index.', NULL, 'N', 'Y'); # # Dumping data for table `vistats_search_engines` # INSERT INTO vistats_search_engines VALUES (1, '4Anything', 'app.4anything.com', 'query'); INSERT INTO vistats_search_engines VALUES (2, '7Metasearch', '7metasearch.com', 'q'); INSERT INTO vistats_search_engines VALUES (3, '7Search', '7search.com', 'qu'); INSERT INTO vistats_search_engines VALUES (4, 'About', 'about.com', 'terms'); INSERT INTO vistats_search_engines VALUES (5, 'AllTheWeb', 'alltheweb.com', 'q'); INSERT INTO vistats_search_engines VALUES (6, 'Altavista Austria', 'at.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (7, 'Altavista Australia', 'au.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (8, 'Altavista Belgium (French)', 'be-fr.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (9, 'Altavista Belgium (Dutch)', 'be-nl.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (10, 'Altavista Brazil', 'br.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (11, 'Altavista Canada (English)', 'ca-en.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (12, 'Altavista Canada (French)', 'ca-fr.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (13, 'Altavista Switzerland (German)', 'ch-de.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (14, 'Altavista Switzerland (French)', 'ch-fr.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (15, 'Altavista Czech Republic', 'cz.altavista.com', 'p'); INSERT INTO vistats_search_engines VALUES (16, 'Altavista Germany', 'de.altavista.com', 'p'); INSERT INTO vistats_search_engines VALUES (17, 'Altavista Denmark', 'dk.altavista.com', 'p'); INSERT INTO vistats_search_engines VALUES (18, 'Altavista Spain', 'es-es.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (19, 'Altavista Finland', 'fi.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (20, 'Altavista France', 'fr.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (21, 'Altavista Health', 'health.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (22, 'Altavista Hungary', 'hu.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (23, 'Altavista Ireland', 'ie.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (24, 'Altavista India', 'in.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (25, 'Altavista Italy', 'it.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (26, 'Altavista Korea (South)', 'kr.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (27, 'Altavista Mexico', 'mx.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (28, 'Altavista Netherlands', 'nl.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (29, 'Altavista Norway', 'no.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (30, 'Altavista New Zealand', 'nz.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (31, 'Altavista Portugal', 'pt.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (32, 'Altavista Sweden', 'se.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (33, 'Altavista United Kingdom', 'uk.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (34, 'Altavista Listings', 'listings.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (35, 'Altavista Raging Search', 'ragingsearch.altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (36, 'Altavista', 'altavista.com', 'q'); INSERT INTO vistats_search_engines VALUES (37, 'Altavista Poland', 'altavista.onet.pl', 'q'); INSERT INTO vistats_search_engines VALUES (38, 'AOL', 'aolsearch.aol.com', 'query'); INSERT INTO vistats_search_engines VALUES (39, 'AOL Tv', 'aoltvsearch.aol.com', 'query'); INSERT INTO vistats_search_engines VALUES (40, 'AOL Australia', 'aolsearch.aol.com.au', 'query'); INSERT INTO vistats_search_engines VALUES (41, 'AOL Brasil', 'aolbusca.aol.com.br', 'query'); INSERT INTO vistats_search_engines VALUES (42, 'AOL Canada', 'aolsearch.aol.ca', 'query'); INSERT INTO vistats_search_engines VALUES (43, 'AOL Japan', 'aol.goo.ne.jp', 'MT'); INSERT INTO vistats_search_engines VALUES (44, 'AOL UK', 'aolsearch.aol.co.uk', 'query'); INSERT INTO vistats_search_engines VALUES (45, 'AOL Netfind', 'aolfind.aol.com', 'query'); INSERT INTO vistats_search_engines VALUES (46, 'AOL Netfind Germany', 'aolfind.aol.de', 'query'); INSERT INTO vistats_search_engines VALUES (47, 'Ask Jeeves UK', 'askjeeves.co.uk', 'ask'); INSERT INTO vistats_search_engines VALUES (48, 'Ask Jeeves', 'askjeeves.com', 'ask'); INSERT INTO vistats_search_engines VALUES (49, 'Ask Jeeves Kids', 'askjeeveskids.co.uk', 'ask'); INSERT INTO vistats_search_engines VALUES (50, 'Atomica', 'lookup.atomica.com', 's'); INSERT INTO vistats_search_engines VALUES (51, 'ATT News', 'dailynews.att.net', 'qry'); INSERT INTO vistats_search_engines VALUES (52, 'Austria', 'finder.austria.com', 'query'); INSERT INTO vistats_search_engines VALUES (53, 'Bellsouth', 'home.bellsouth.net', 'Keywords'); INSERT INTO vistats_search_engines VALUES (54, 'Biglobe Japan', 'cgi.search.biglobe.ne.jp', 'q'); INSERT INTO vistats_search_engines VALUES (55, 'Blueyonder', 'bbsearch.blueyonder.co.uk', 'q'); INSERT INTO vistats_search_engines VALUES (56, 'Bol (Brazil)', 'miner.bol.com.br', 'q'); INSERT INTO vistats_search_engines VALUES (57, 'BlueWin Switzerland', 'av-de.bluewin.ch', 'q'); INSERT INTO vistats_search_engines VALUES (58, 'BZZ Russia', 'bzz.ru', 'query'); INSERT INTO vistats_search_engines VALUES (59, 'Catloga (France)', 'fr.web.caloga.com', 'q'); INSERT INTO vistats_search_engines VALUES (60, 'Chopstix', 'au.chopstix.net', 'search'); INSERT INTO vistats_search_engines VALUES (61, 'Compuserve', 'cissearch.compuserve.com', 'sTerm'); INSERT INTO vistats_search_engines VALUES (62, 'Curryguide', 'fastsearch.curryguide.com', 'query'); INSERT INTO vistats_search_engines VALUES (63, 'DirectHit/Ask Jeeves', 'askuk.directhit.com', 'qry'); INSERT INTO vistats_search_engines VALUES (64, 'DirectHit/Britannica', 'britannica.directhit.com', 'qry'); INSERT INTO vistats_search_engines VALUES (65, 'DirectHit/Comet', 'comet.directhit.com', 'qry'); INSERT INTO vistats_search_engines VALUES (66, 'DirectHit/Dictionary', 'dictionary.directhit.com', 'qry'); INSERT INTO vistats_search_engines VALUES (67, 'DirectHit/Megadirectory', 'megadirectory.directhit.com', 'qry'); INSERT INTO vistats_search_engines VALUES (68, 'DirectHit/MSN', 'msn.directhit.com', 'qry'); INSERT INTO vistats_search_engines VALUES (69, 'DirectHit/Systema', 'systema.directhit.com', 'qry'); INSERT INTO vistats_search_engines VALUES (70, 'DirectHit/Webster', 'webster.directhit.com', 'qry'); INSERT INTO vistats_search_engines VALUES (71, 'DirectHit', 'directhit.com', 'qry'); INSERT INTO vistats_search_engines VALUES (72, 'Open Directory Project', 'dmoz.org', 'search'); INSERT INTO vistats_search_engines VALUES (73, 'Dogpile', 'dogpile.com', 'q'); INSERT INTO vistats_search_engines VALUES (74, 'Dreamx', 'm3.dreamx.net', 'query'); INSERT INTO vistats_search_engines VALUES (75, 'Earthlink', 'goto.earthlink.net', 'Keywords'); INSERT INTO vistats_search_engines VALUES (76, 'Education World', 'db.education-world.com', 'queryText'); INSERT INTO vistats_search_engines VALUES (77, 'Elsitio', 'buscador.elsitio.com', 'palabras'); INSERT INTO vistats_search_engines VALUES (78, 'Elmundo Spain', 'ariadna.elmundo.es', 'q'); INSERT INTO vistats_search_engines VALUES (79, 'Espotting', 'affiliate.espotting.com', 'keyword'); INSERT INTO vistats_search_engines VALUES (80, 'Eureka', 'eureka.com', 'q'); INSERT INTO vistats_search_engines VALUES (81, 'Excite Austria', 'excite.at', 'search'); INSERT INTO vistats_search_engines VALUES (82, 'Excite Australia', 'excite.com.au', 'search'); INSERT INTO vistats_search_engines VALUES (83, 'Excite Chinese', 'excite.ch', 'search'); INSERT INTO vistats_search_engines VALUES (84, 'Excite Canada', 'excite.ca', 'search'); INSERT INTO vistats_search_engines VALUES (85, 'Excite Germany', 'excite.de', 'search'); INSERT INTO vistats_search_engines VALUES (86, 'Excite Denmark', 'excite.dk', 'search'); INSERT INTO vistats_search_engines VALUES (87, 'Excite Spain', 'excite.es', 'search'); INSERT INTO vistats_search_engines VALUES (88, 'Excite France', 'excite.fr', 'search'); INSERT INTO vistats_search_engines VALUES (89, 'Excite Italy', 'excite.it', 'search'); INSERT INTO vistats_search_engines VALUES (90, 'Excite Japan', 'excite.co.jp', 'search'); INSERT INTO vistats_search_engines VALUES (91, 'Excite UK', 'excite.co.uk', 'search'); INSERT INTO vistats_search_engines VALUES (92, 'Findia', 'findia.net', 'query'); INSERT INTO vistats_search_engines VALUES (93, 'Go/Infoseek', 'infoseek.go.com', 'qt'); INSERT INTO vistats_search_engines VALUES (94, 'Google Directory', 'directory.google.com', 'q'); INSERT INTO vistats_search_engines VALUES (95, 'Google/Gotonet', 'gotonet.google.com', 'q'); INSERT INTO vistats_search_engines VALUES (96, 'Google Groups', 'groups.google.com', 'q'); INSERT INTO vistats_search_engines VALUES (97, 'Google Images', 'images.google.com', 'q'); INSERT INTO vistats_search_engines VALUES (98, 'Google', 'google.com', 'q'); INSERT INTO vistats_search_engines VALUES (99, 'Google WAP', 'wap.google.com', 'q'); INSERT INTO vistats_search_engines VALUES (100, 'Google (Austria)', 'google.at', 'q'); INSERT INTO vistats_search_engines VALUES (101, 'Google (Australia)', 'google.com.au', 'q'); INSERT INTO vistats_search_engines VALUES (102, 'Google (Peru)', 'google.com.pe', 'q'); INSERT INTO vistats_search_engines VALUES (103, 'Google (India)', 'google.co.in', 'q'); INSERT INTO vistats_search_engines VALUES (104, 'Google (United Arab Emirates)', 'google.ae', 'q'); INSERT INTO vistats_search_engines VALUES (105, 'Google (Belgium)', 'google.be', 'q'); INSERT INTO vistats_search_engines VALUES (106, 'Google (Canada)', 'google.ca', 'q'); INSERT INTO vistats_search_engines VALUES (107, 'Google (Chile)', 'google.cl', 'q'); INSERT INTO vistats_search_engines VALUES (108, 'Google (Cocos (Keeling) Islands)', 'google.cc', 'q'); INSERT INTO vistats_search_engines VALUES (109, 'Google (Switzerland)', 'google.ch', 'q'); INSERT INTO vistats_search_engines VALUES (110, 'Google (Costa Rica)', 'google.co.cr', 'q'); INSERT INTO vistats_search_engines VALUES (111, 'Google (Israel)', 'google.co.il', 'q'); INSERT INTO vistats_search_engines VALUES (112, 'Google (Japan)', 'google.co.jp', 'q'); INSERT INTO vistats_search_engines VALUES (113, 'Google (South Korea)', 'google.co.kr', 'q'); INSERT INTO vistats_search_engines VALUES (114, 'Google (New Zealand)', 'google.co.nz', 'q'); INSERT INTO vistats_search_engines VALUES (115, 'Google (Thailand)', 'google.co.th', 'q'); INSERT INTO vistats_search_engines VALUES (116, 'Google (United Kingdom)', 'google.co.uk', 'q'); INSERT INTO vistats_search_engines VALUES (117, 'Google (Argentina)', 'google.com.ar', 'q'); INSERT INTO vistats_search_engines VALUES (118, 'Google (Brasil)', 'google.com.br', 'q'); INSERT INTO vistats_search_engines VALUES (119, 'Google (Greece)', 'google.com.gr', 'q'); INSERT INTO vistats_search_engines VALUES (120, 'Google (Poland)', 'google.com.pl', 'q'); INSERT INTO vistats_search_engines VALUES (121, 'Google (Russia)', 'google.com.ru', 'q'); INSERT INTO vistats_search_engines VALUES (122, 'Google (Germany)', 'google.de', 'q'); INSERT INTO vistats_search_engines VALUES (123, 'Google (Mexico)', 'google.com.mx', 'q'); INSERT INTO vistats_search_engines VALUES (124, 'Google (Micronesia)', 'google.fm', 'q'); INSERT INTO vistats_search_engines VALUES (125, 'Google (France)', 'google.fr', 'q'); INSERT INTO vistats_search_engines VALUES (126, 'Google (Ireland)', 'google.ie', 'q'); INSERT INTO vistats_search_engines VALUES (127, 'Google (Italy)', 'google.it', 'q'); INSERT INTO vistats_search_engines VALUES (128, 'Google (Liechtenstein)', 'google.li', 'q'); INSERT INTO vistats_search_engines VALUES (129, 'Google (Lithuania)', 'google.lt', 'q'); INSERT INTO vistats_search_engines VALUES (130, 'Google (Latvia)', 'google.lv', 'q'); INSERT INTO vistats_search_engines VALUES (131, 'Google (Netherlands)', 'google.nl', 'q'); INSERT INTO vistats_search_engines VALUES (132, 'Google (Portugal)', 'google.pt', 'q'); INSERT INTO vistats_search_engines VALUES (133, 'Google (Portugal/English)', 'pesquisa.google.pt', 'q'); INSERT INTO vistats_search_engines VALUES (134, 'Google (Singapore)', 'google.com.sg', 'q'); INSERT INTO vistats_search_engines VALUES (135, 'Google (British Virgin Islands)', 'google.vg', 'q'); INSERT INTO vistats_search_engines VALUES (136, 'Goto', 'goto.com', 'Keywords'); INSERT INTO vistats_search_engines VALUES (137, 'Hananet', 'dxm4.hananet.net', 'query'); INSERT INTO vistats_search_engines VALUES (138, 'Hanafos', 'hanafos.com', 'query'); INSERT INTO vistats_search_engines VALUES (139, 'Hispatvista', 'buscar.hispavista.com', 'cadena'); INSERT INTO vistats_search_engines VALUES (140, 'HotBot', 'click.hotbot.com', 'query'); INSERT INTO vistats_search_engines VALUES (141, 'ICQ/Google', 'google.icq.com', 'q'); INSERT INTO vistats_search_engines VALUES (142, 'Infospace', 'kevxml.infospace.com', 'qkw'); INSERT INTO vistats_search_engines VALUES (143, 'IOL Italy', 'arianna-internazionale.iol.it', 'B1'); INSERT INTO vistats_search_engines VALUES (144, 'IOL Israel', 'find.iol.co.il', 'q'); INSERT INTO vistats_search_engines VALUES (145, 'IPoinc Hong Kong', 'ipoinc.com.hk', 'terms'); INSERT INTO vistats_search_engines VALUES (146, 'IXQuick', 'ixquick.com', 'query'); INSERT INTO vistats_search_engines VALUES (147, 'Job.com', 'job.com', 'Keywords'); INSERT INTO vistats_search_engines VALUES (148, 'Kolumbus Finland', 'kolumbus.fi', 'q'); INSERT INTO vistats_search_engines VALUES (149, 'Kvasir (Norway)', 'kvasir.sol.no', 'q'); INSERT INTO vistats_search_engines VALUES (150, 'Libero', 'arianna.libero.it', 'query'); INSERT INTO vistats_search_engines VALUES (151, 'LinkSynergy', 'click.linksynergy.com', 'q'); INSERT INTO vistats_search_engines VALUES (152, 'LookSmart (CNN)', 'cnn.looksmart.com', 'key'); INSERT INTO vistats_search_engines VALUES (153, 'LookSmart (CNNFN)', 'cnnfn.looksmart.com', 'key'); INSERT INTO vistats_search_engines VALUES (154, 'Lycos', 'home.lycos.com', 'query'); INSERT INTO vistats_search_engines VALUES (155, 'Lycos/Hotbot Directory', 'dir.hotbot.lycos.com', 'MT'); INSERT INTO vistats_search_engines VALUES (156, 'Lycos/Hotbot', 'hotbot.lycos.com', 'MT'); INSERT INTO vistats_search_engines VALUES (157, 'Lycos/Lycospro', 'lycospro.lycos.com', 'query'); INSERT INTO vistats_search_engines VALUES (158, 'LycosAsia India', 'in.lycosasia.com', 'query'); INSERT INTO vistats_search_engines VALUES (159, 'LycosAsia Malaysia', 'my.lycosasia.com', 'query'); INSERT INTO vistats_search_engines VALUES (160, 'Lycos Italy', 'cerca.lycos.it', 'query'); INSERT INTO vistats_search_engines VALUES (161, 'Lycos Spain', 'buscador.lycos.es', 'query'); INSERT INTO vistats_search_engines VALUES (162, 'Lycos/Google Korea (South)', 'google.lycos.co.kr', 'q'); INSERT INTO vistats_search_engines VALUES (163, 'Lycos Russia', 'poisk.lycos.co.ru', 'query'); INSERT INTO vistats_search_engines VALUES (164, 'Mamma', 'mamma.com', 'query'); INSERT INTO vistats_search_engines VALUES (165, 'Metacrawler', 'metacrawler.com', 'general'); INSERT INTO vistats_search_engines VALUES (166, 'Mirago', 'mirago.com', 'qry'); INSERT INTO vistats_search_engines VALUES (167, 'MSN Search', 'auto.search.msn.com', 'q'); INSERT INTO vistats_search_engines VALUES (168, 'MSN Canada (French)', 'fr.ca.search.msn.com', 'q'); INSERT INTO vistats_search_engines VALUES (169, 'MSN', 'search.msn.com', 'MT,q'); INSERT INTO vistats_search_engines VALUES (170, 'MyNet', 'arama.mynet.com', 'q'); INSERT INTO vistats_search_engines VALUES (171, 'NANA Israel', 'crawler.nana.co.il', 'string'); INSERT INTO vistats_search_engines VALUES (172, 'NANA Israel (English)', 'english.nana.co.il', 'string'); INSERT INTO vistats_search_engines VALUES (173, 'Naver', 'meta.naver.com', 'query'); INSERT INTO vistats_search_engines VALUES (174, 'NBCI', 'nbci.com', 'keyword'); INSERT INTO vistats_search_engines VALUES (175, 'NetBul', 'kapi.netbul.com', 'keyword'); INSERT INTO vistats_search_engines VALUES (176, 'Netscape/Excite Australia', 'excite.au.netscape.com', 'search'); INSERT INTO vistats_search_engines VALUES (177, 'Netscape/Excite Germany', 'excite.de.netscape.com', 'search'); INSERT INTO vistats_search_engines VALUES (178, 'Netscape/Excite France', 'excite.fr.netscape.com', 'search'); INSERT INTO vistats_search_engines VALUES (179, 'Netscape/Excite UK', 'excite.uk.netscape.com', 'search'); INSERT INTO vistats_search_engines VALUES (180, 'Netscape (Directory)', 'directory.netscape.com', 'search'); INSERT INTO vistats_search_engines VALUES (181, 'Netscape/Google', 'google.netscape.com', 'query,q'); INSERT INTO vistats_search_engines VALUES (182, 'Netscape NetBusiness', 'netbusiness.netscape.com', 'searchString'); INSERT INTO vistats_search_engines VALUES (183, 'Netscape', 'netscape.com', 'search'); INSERT INTO vistats_search_engines VALUES (184, 'Netscape Online', 'netscapeonline.co.uk', 'query'); INSERT INTO vistats_search_engines VALUES (185, 'Northernlight', 'northernlight.com', 'qr'); INSERT INTO vistats_search_engines VALUES (186, 'Nomade France', 'ink.nomade.fr', 'MT'); INSERT INTO vistats_search_engines VALUES (187, 'New Net', 'eps.new.search.new.net', 'Keywords'); INSERT INTO vistats_search_engines VALUES (188, 'Opasia Denmark', 'find.opasia.dk', 'q'); INSERT INTO vistats_search_engines VALUES (189, 'OZU Spain', 'buscador.ozu.es', 'q'); INSERT INTO vistats_search_engines VALUES (190, 'Passagen Sweden', 'evreka.passagen.se', 'q'); INSERT INTO vistats_search_engines VALUES (191, 'Search.com', 'search.com', 'q'); INSERT INTO vistats_search_engines VALUES (192, 'Searchopolis', 'searchopolis.com', 'request'); INSERT INTO vistats_search_engines VALUES (193, 'Snap', 'snap.com', 'keyword'); INSERT INTO vistats_search_engines VALUES (194, 'StarMedia', 'buscaweb.starmedia.com', 'query'); INSERT INTO vistats_search_engines VALUES (195, 'Superonline', 'arama.superoneline.com', 'query'); INSERT INTO vistats_search_engines VALUES (196, 'Spray/Lycos Sweden', 'lycos.spray.se', 'query'); INSERT INTO vistats_search_engines VALUES (197, 'Spray/Lycossvar Sweden', 'lycossvar.spray.se', 'query'); INSERT INTO vistats_search_engines VALUES (198, 'Suomi24 Finland', 'evreka.suomi24.fi', 'q'); INSERT INTO vistats_search_engines VALUES (199, 'Terra (Brasil)', 'busca.terra.com.br', 'query'); INSERT INTO vistats_search_engines VALUES (200, 'Terra (Spain)', 'buscador.terra.es', 'Claus'); INSERT INTO vistats_search_engines VALUES (201, 'Tiscalinet', 'janas.tiscalinet.it', 'query'); INSERT INTO vistats_search_engines VALUES (202, 'T-Online (Germany)', 'brisbane.t-online.de', 'q'); INSERT INTO vistats_search_engines VALUES (203, 'UOL Argentina', 'buscar.uol.com.ar', 'q'); INSERT INTO vistats_search_engines VALUES (204, 'Virgilio/Google', 'virgilio.it', 'qs'); INSERT INTO vistats_search_engines VALUES (205, 'Virgilio/Altavista', 'virgilio.it', 'qs'); INSERT INTO vistats_search_engines VALUES (206, 'Virgilio', 'virgilio.it', 'qs'); INSERT INTO vistats_search_engines VALUES (207, 'Ya', 'buscador.ya.com', 'item'); INSERT INTO vistats_search_engines VALUES (208, 'Yahoo', 'yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (209, 'Yahoo/Busca Brasil', 'br.busca.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (210, 'Yahoo/Google Argentina', 'ar.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (211, 'Yahoo/Google Asia', 'asia.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (212, 'Yahoo/Google Brasil', 'br.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (213, 'Yahoo/Google Canada', 'ca.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (214, 'Yahoo/Google China', 'cn.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (215, 'Yahoo/Google Germany', 'de.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (216, 'Yahoo/Google Denmark', 'dk.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (217, 'Yahoo/Google Spain', 'es.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (218, 'Yahoo/Google France', 'fr.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (219, 'Yahoo/Google Hong Kong (English)', 'hke.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (220, 'Yahoo/Google India', 'in.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (221, 'Yahoo/Google Italy', 'it.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (222, 'Yahoo/Google Mexico', 'mx.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (223, 'Yahoo/Google Sweden', 'se.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (224, 'Yahoo/Google Singapore', 'sg.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (225, 'Yahoo/Google United Kingdom', 'uk.google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (226, 'Yahoo Search Asia', 'asia.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (227, 'Yahoo Search Australia', 'au.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (228, 'Yahoo Search Canada', 'ca.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (229, 'Yahoo Search Germany', 'de.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (230, 'Yahoo Search Denmark', 'dk.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (231, 'Yahoo Search France', 'fr.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (232, 'Yahoo Search India', 'in.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (233, 'Yahoo Search Mexico', 'mx.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (234, 'Yahoo Search Norway', 'no.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (235, 'Yahoo Search Sweden', 'se.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (236, 'Yahoo Search Singapore', 'sg.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (237, 'Yahoo Search United Kingdom', 'uk.search.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (238, 'Yahoo/Google', 'google.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (239, 'Yahoo Chinese', 'chinese.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (240, 'Yahoo Spanish', 'espanol.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (241, 'Yahoo Advanced Search', 'av.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (242, 'Yahoo Inktomi Singapore', 'sg.ink.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (243, 'Yahoo Inktomi United Kingdom', 'uk.ink.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (244, 'Yahoo Inktomi', 'ink.yahoo.com', 'p'); INSERT INTO vistats_search_engines VALUES (245, 'Weather underground', 'autobrand.wunderground.com', 'q,search'); INSERT INTO vistats_search_engines VALUES (246, 'Weather underground (Dutch)', 'dutch.wunderground.com', 'search'); INSERT INTO vistats_search_engines VALUES (247, 'Walla Israel', 'find.walla.co.il', 'q'); INSERT INTO vistats_search_engines VALUES (248, 'Web Agri (France)', 'moteur.web-agri.fr', 'SearchString'); INSERT INTO vistats_search_engines VALUES (249, 'WWW Finland', 'haku2.wwww.fi', 'word'); INSERT INTO vistats_search_engines VALUES (250, 'Google (Philippines)', 'google.com.ph', 'q'); INSERT INTO vistats_search_engines VALUES (251, 'Google (Spain)', 'google.es', 'q'); INSERT INTO vistats_search_engines VALUES (252, 'Google (Nepal)', 'google.com.np', 'q'); INSERT INTO vistats_search_engines VALUES (253, 'Ask Jeeves', 'web.ask.com', 'q'); INSERT INTO vistats_search_engines VALUES (254, 'Google (Hong Kong)', 'google.com.hk', 'q'); INSERT INTO vistats_search_engines VALUES (255, 'Google (Malaysia)', 'google.com.my', 'q'); INSERT INTO vistats_search_engines VALUES (256, 'Google (Denmark)', 'google.dk', 'q'); INSERT INTO vistats_search_engines VALUES (257, 'Google (Azerbaijan)', 'google.az', 'q'); INSERT INTO vistats_search_engines VALUES (258, 'Google (Turkey)', 'google.com.tr', 'q'); INSERT INTO vistats_search_engines VALUES (259, 'Google (Poland)', 'google.pl', 'q'); INSERT INTO vistats_search_engines VALUES (266, 'Google (Colombia)', 'google.com.co', 'q'); INSERT INTO vistats_search_engines VALUES (267, 'Google (Finland)', 'google.fi', 'q'); INSERT INTO vistats_search_engines VALUES (263, 'Google (Sweden)', 'google.se', 'q'); INSERT INTO vistats_search_engines VALUES (268, 'Google (Turkey)', 'google.com.tr', 'q'); INSERT INTO vistats_search_engines VALUES (269, 'Google (Romania)', 'google.ro', 'q'); INSERT INTO vistats_search_engines VALUES (270, 'Google (Panama)', 'google.com.pa', 'q'); INSERT INTO vistats_search_engines VALUES (271, 'Google (Nicaragua)', 'google.com.ni', 'q'); INSERT INTO vistats_search_engines VALUES (272, 'Google (Slovakia)', 'google.sk', 'q'); You can just copy all the text from this box and paste it into your 'Run SQL Query' box in PHPmyAdmin.

If you can't copy and paste this into your 'Run SQL Query' box because it's too big, please use the text file 'Visitor Stats 2 mysql import.txt' found in the '/readme/' folder.