"; // First we see if this database has already been installed if (@mysql_query("SELECT * FROM $SI_tables[stats]") || @mysql_query("SELECT * FROM $SI_tables[searchterms]")) { //--> added by J Cornelius for updating the shortstat table already installed if (!mysql_query("DESCRIBE $SI_tables[stats] language")) { echo "

We need to update the $SI_tables[stats] table...

"; $sql = "ALTER TABLE $SI_tables[stats] ADD language VARCHAR(5) NOT NULL default '' AFTER country"; if(mysql_query($sql)) { echo "

Update Successful... you can go about your merry way!

"; } else { echo "

Whoa! there was a slight problem....
".mysql_error()."

"; } } //--> end addition by J Cornelius else { echo "

The necessary tables already exist and were updated. This file should be removed from your server.

"; } } // If not we do it to it... else { $query = "CREATE TABLE $SI_tables[stats] ( id int(11) unsigned NOT NULL auto_increment, remote_ip varchar(15) NOT NULL default '', country varchar(50) NOT NULL default '', language VARCHAR(5) NOT NULL default '', domain varchar(255) NOT NULL default '', referer varchar(255) NOT NULL default '', resource varchar(255) NOT NULL default '', user_agent varchar(255) NOT NULL default '', platform varchar(50) NOT NULL default '', browser varchar(50) NOT NULL default '', version varchar(15) NOT NULL default '', dt int(10) unsigned NOT NULL default '0', UNIQUE KEY id (id) ) TYPE=MyISAM"; $query_search = "CREATE TABLE $SI_tables[searchterms] ( id int(11) unsigned NOT NULL auto_increment, searchterms varchar(255) NOT NULL default '', count int(10) unsigned NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM;"; if (@mysql_query($query) && @mysql_query($query_search)) { echo "

The necessary tables have been created successfully! Now remove this file from your server.

"; } else { echo "

The necessary tables could not be created. I know, I know, this isn't a very helpful error message...

"; } } ?>