Help Center Live Setup

Installing Database

"); echo(".. Dropping table ".$DB_prefix."canned if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."canned`"); echo(".. Creating table ".$DB_prefix."canned
"); mysql_query("CREATE TABLE `".$DB_prefix."canned` (`id` int(255) NOT NULL auto_increment,`department` varchar(255) default NULL, `operator` varchar(255) default NULL, `subject` varchar(255) NOT NULL default '', `message` text NOT NULL, PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."chat
"); echo(".. Dropping table ".$DB_prefix."chat if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."chat`"); echo(".. Creating table ".$DB_prefix."chat
"); mysql_query("CREATE TABLE `".$DB_prefix."chat` (`id` int(255) NOT NULL auto_increment,`chatid` varchar(255) NOT NULL default '', `author` varchar(255) NOT NULL default '', `message` text NOT NULL, `time` varchar(255) NOT NULL default '0', `x` char(1) NOT NULL default '', `operator` int(1) NOT NULL default '0', `guest` int(1) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."departments
"); echo(".. Dropping table ".$DB_prefix."departments if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."departments`"); echo(".. Creating table ".$DB_prefix."departments
"); mysql_query("CREATE TABLE `".$DB_prefix."departments` (`id` int(255) NOT NULL auto_increment, `department` varchar(255) NOT NULL default '', `operator` varchar(255) default NULL, `email` varchar(255) NOT NULL default '', `poll` int(255) default NULL, PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."faqs
"); echo(".. Dropping table ".$DB_prefix."faqs if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."faqs`"); echo(".. Creating table ".$DB_prefix."faqs
"); mysql_query("CREATE TABLE `".$DB_prefix."faqs` (`id` int(255) NOT NULL auto_increment, `topicid` int(255) NOT NULL default '0', `subject` varchar(255) NOT NULL default '', `message` text NOT NULL, PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."footprints
"); echo(".. Dropping table ".$DB_prefix."footprints if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."footprints`"); echo(".. Creating table ".$DB_prefix."footprints
"); mysql_query("CREATE TABLE `".$DB_prefix."footprints` (`id` int(255) NOT NULL auto_increment, `chatid` varchar(255) NOT NULL default '', `page` text NOT NULL, `time` int(255) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."hotpages
"); echo(".. Dropping table ".$DB_prefix."hotpages if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."hotpages`"); echo(".. Creating table ".$DB_prefix."hotpages
"); mysql_query("CREATE TABLE `".$DB_prefix."hotpages` (`id` int(255) NOT NULL auto_increment, `page` text NOT NULL, PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."icons
"); echo(".. Dropping table ".$DB_prefix."icons if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."icons`"); echo(".. Creating table ".$DB_prefix."icons
"); mysql_query("CREATE TABLE `".$DB_prefix."icons` (`id` int(255) NOT NULL auto_increment, `department` varchar(255) default NULL, `status` int(1) default NULL, `name` varchar(255) NOT NULL default '', `image` blob NOT NULL, `size` varchar(255) NOT NULL default '0', `type` varchar(255) NOT NULL default '', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."operators
"); echo(".. Dropping table ".$DB_prefix."operators if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."operators`"); echo(".. Creating table ".$DB_prefix."operators
"); mysql_query("CREATE TABLE `".$DB_prefix."operators` (`id` int(255) NOT NULL auto_increment, `operator` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', `firstname` varchar(255) NOT NULL default '', `lastname` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `level` int(1) NOT NULL default '0', `time` int(255) NOT NULL default '0', `autosave` int(1) NOT NULL default '1', `status` int(1) NOT NULL default '0', `sounds` int(1) NOT NULL default '1', `imageblob` blob NOT NULL, `imagetype` varchar(255) NOT NULL default '', `usepic` int(1) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."responses
"); echo(".. Dropping table ".$DB_prefix."responses if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."responses`"); echo(".. Creating table ".$DB_prefix."responses
"); mysql_query("CREATE TABLE `".$DB_prefix."responses` (`id` int(255) NOT NULL auto_increment, `ticketid` int(255) NOT NULL default '0', `author` int(1) NOT NULL default '0', `time` varchar(255) NOT NULL default '', `message` text NOT NULL, PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."session
"); echo(".. Dropping table ".$DB_prefix."session if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."session`"); echo(".. Creating table ".$DB_prefix."session
"); mysql_query("CREATE TABLE `".$DB_prefix."session` (`id` int(255) NOT NULL auto_increment, `chatid` varchar(255) NOT NULL default '', `department` varchar(255) default NULL, `operator` varchar(255) default NULL, `guest` varchar(255) NOT NULL default '', `alert` varchar(20) NOT NULL default '', `poll` int(11) NOT NULL default '0', `timeo` int(255) NOT NULL default '0', `timeg` int(255) NOT NULL default '0', `typeo` int(255) NOT NULL default '0', `typeg` int(255) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."sounds
"); echo(".. Dropping table ".$DB_prefix."sounds if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."sounds`"); echo(".. Creating table ".$DB_prefix."sounds
"); mysql_query("CREATE TABLE `".$DB_prefix."sounds` (`id` int(255) NOT NULL auto_increment, `operator` varchar(255) NOT NULL default '', `sound` varchar(255) NOT NULL default '', `time` int(255) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."system
"); echo(".. Dropping table ".$DB_prefix."system if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."system`"); echo(".. Creating table ".$DB_prefix."system
"); mysql_query("CREATE TABLE `".$DB_prefix."system` (`id` int(255) NOT NULL auto_increment, `operator` varchar(255) NOT NULL default '', `chatid` varchar(255) NOT NULL default '', `time` int(255) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."tickets
"); echo(".. Dropping table ".$DB_prefix."tickets if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."tickets`"); echo(".. Creating table ".$DB_prefix."tickets
"); mysql_query("CREATE TABLE `".$DB_prefix."tickets` (`id` int(255) NOT NULL auto_increment, `username` varchar(255) NOT NULL default '', `operator` varchar(255) default NULL, `department` varchar(255) default NULL, `subject` varchar(255) NOT NULL default '', `status` int(1) NOT NULL default '0', `urgency` int(1) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."topics
"); echo(".. Dropping table ".$DB_prefix."topics if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."topics`"); echo(".. Creating table ".$DB_prefix."topics
"); mysql_query("CREATE TABLE `".$DB_prefix."topics` (`id` int(255) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `sort` int(255) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."traffic
"); echo(".. Dropping table ".$DB_prefix."traffic if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."traffic`"); echo(".. Creating table ".$DB_prefix."traffic
"); mysql_query("CREATE TABLE `".$DB_prefix."traffic` (`id` int(255) NOT NULL auto_increment, `chatid` varchar(255) NOT NULL default '', `ip` varchar(255) NOT NULL default '', `hostname` varchar(255) NOT NULL default '', `referrer` text NOT NULL, `time` int(255) NOT NULL default '0', `requests` int(255) NOT NULL default '0', `visits` int(255) NOT NULL default '1', `start` int(255) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."transcripts
"); echo(".. Dropping table ".$DB_prefix."transcripts if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."transcripts`"); echo(".. Creating table ".$DB_prefix."transcripts
"); mysql_query("CREATE TABLE `".$DB_prefix."transcripts` (`id` int(255) NOT NULL auto_increment, `chatid` varchar(255) NOT NULL default '', `operator` varchar(255) NOT NULL default '', `department` varchar(255) NOT NULL default '', `guest` varchar(255) NOT NULL default '', `hostname` varchar(255) NOT NULL default '', `time` varchar(255) NOT NULL default '', `transcript` text NOT NULL, PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); echo("Attempting to create table ".$DB_prefix."users
"); echo(".. Dropping table ".$DB_prefix."users if it exists
"); mysql_query("DROP TABLE IF EXISTS `".$DB_prefix."users`"); echo(".. Creating table ".$DB_prefix."users
"); mysql_query("CREATE TABLE `".$DB_prefix."users` (`id` int(255) NOT NULL auto_increment, `username` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `firstname` varchar(255) NOT NULL default '', `lastname` varchar(255) NOT NULL default '', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error()); echo("Success!

"); ?>

Continue