Before we start, you must have access to a MySQL database on the website your website is hosted, and PHP running. To check if you have PHP & MySQL see the website faq's.

Unzip the Visitor Stats zip file and place the folder that is created ('visitor_stats'*) in your website's root directory.

* Visitor Stats will NOT WORK if you rename the folder or have the folder outside of the root directory

In this file all the generic settings for Visitor Stats are contained, and its a good idea to read through each one thoroughly.

To set your timezone, replace the "en-au" on line 13 with your country code, a list of these can be found here (under the heading 'Internet').

You can also change what country you are on line 18, but please ensure that "TZ=" remains.
E.g. "TZ=Australia/Sydney" or "TZ=India".

If this doesn't change your timezone, try using"GMT-9" or "GMT+10" etc

To test if your timezone change is successfull (and if you don't have the Web Counter installed, see bottom of page), type in your filename followed by '?show_timezone=Y'.
E.g. index.php?show_timezone=Y

Fill in your MySQL database settings such as DB_USER, DB_PASSWORD etc. on line 21 to 27.

You should also change the VS_SITENAME to a descriptive name of your site (e.g. yari_website) and VS_URL to your domain name (e.g. www.visitor-stats.com).

# # Table structure for table `vistats_counter` # CREATE TABLE vistats_counter ( id int(11) NOT NULL auto_increment, user_id int(11) default NULL, time int(15) default NULL, PRIMARY KEY (id), UNIQUE KEY id (id), KEY time (time), KEY user_id (user_id) ) TYPE=MyISAM; # -------------------------------------------------------- # # 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 (278, 'Google (Guatemala)', 'google.com.gt', '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'); INSERT INTO `vistats_search_engines` VALUES (273, 'Google (Dominican Republic)', 'google.com.do', 'q'); INSERT INTO `vistats_search_engines` VALUES (274, 'Google (American Samoa)', 'google.as', 'q'); INSERT INTO `vistats_search_engines` VALUES (275, 'Google (Venezuela)', 'google.co.ve', 'q'); INSERT INTO `vistats_search_engines` VALUES (276, 'Google (Puerto Rico)', 'google.com.pr', 'q'); INSERT INTO `vistats_search_engines` VALUES (277, 'Google (Hungary)', 'google.co.hu', 'q'); INSERT INTO `vistats_search_engines` VALUES (279, 'Google (Vietnam)', 'google.com.vn', 'q'); INSERT INTO `vistats_search_engines` VALUES (280, 'Search (msn)', 'search.msn.com', 'q'); INSERT INTO `vistats_search_engines` VALUES (281, 'Google (Australia) ()', 'Google (Australia)', 'q'); INSERT INTO `vistats_search_engines` VALUES (282, 'WebSearch (COM)', 'WebSearch.COM.AU', 'q'); INSERT INTO `vistats_search_engines` VALUES (283, 'WebSearch (Australia SE)', 'WebSearch.COM.AU', '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.