基于PHP的SK免费的php在线客服系统源码.zip

/* SQLyog 企业版 - MySQL GUI v7.14 MySQL - 5.0.85-community-nt : Database - kefu ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`kefu` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `kefu`; /*Table structure for table `chatban` */ DROP TABLE IF EXISTS `chatban`; CREATE TABLE `chatban` ( `banid` int(11) NOT NULL auto_increment, `dtmcreated` datetime default '0000-00-00 00:00:00', `dtmtill` datetime default '0000-00-00 00:00:00', `address` varchar(255) default NULL, `comment` varchar(255) default NULL, `blockedCount` int(11) default '0', PRIMARY KEY (`banid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `chatban` */ LOCK TABLES `chatban` WRITE; UNLOCK TABLES; /*Table structure for table `chatconfig` */ DROP TABLE IF EXISTS `chatconfig`; CREATE TABLE `chatconfig` ( `id` int(11) NOT NULL auto_increment, `vckey` varchar(255) default NULL, `vcvalue` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; /*Data for the table `chatconfig` */ LOCK TABLES `chatconfig` WRITE; insert into `chatconfig`(`id`,`vckey`,`vcvalue`) values (1,'dbversion','1.6.0.3'),(2,'title','Your Company'),(3,'hosturl','http://localhost/'),(4,'logo',''),(5,'usernamepattern','{name}'),(6,'chatstyle','simplicity'),(7,'chattitle','Live Support'),(8,'geolink','http://api.hostip.info/get_html.php?ip={ip}'),(9,'geolinkparams','width=440,height=100,toolbar=0,scrollbars=0,location=0,status=1,menubar=0,resizable=1'),(10,'online_timeout','30'),(11,'max_uploaded_file_size','100000'),(12,'max_connections_from_one_host','10'),(13,'email',''),(14,'left_messages_locale','en'),(15,'sendmessagekey','center'),(16,'enableban','0'),(17,'enablessl','0'),(18,'forcessl','0'),(19,'usercanchangename','1'),(20,'enablegroups','0'),(21,'enablestatistics','1'),(22,'enablepresurvey','1'),(23,'surveyaskmail','0'),(24,'surveyaskgroup','1'),(25,'surveyaskmessage','0'),(26,'enablepopupnotification','0'); UNLOCK TABLES; /*Table structure for table `chatgroup` */ DROP TABLE IF EXISTS `chatgroup`; CREATE TABLE `chatgroup` ( `groupid` int(11) NOT NULL auto_increment, `vclocalname` varchar(64) NOT NULL, `vccommonname` varchar(64) NOT NULL, `vclocaldescription` varchar(1024) NOT NULL, `vccommondescription` varchar(1024) NOT NULL, PRIMARY KEY (`groupid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `chatgroup` */ LOCK TABLES `chatgroup` WRITE; UNLOCK TABLES; /*Table structure for table `chatgroupoperator` */ DROP TABLE IF EXISTS `chatgroupoperator`; CREATE TABLE `chatgroupoperator` ( `groupid` int(11) NOT NULL, `operatorid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `chatgroupoperator` */ LOCK TABLES `chatgroupoperator` WRITE; UNLOCK TABLES; /*Table structure for table `chatmessage` */ DROP TABLE IF EXISTS `chatmessage`; CREATE TABLE `chatmessage` ( `messageid` int(11) NOT NULL auto_increment, `threadid` int(11) NOT NULL, `ikind` int(11) NOT NULL, `agentId` int(11) NOT NULL default '0', `tmessage` text NOT NULL, `dtmcreated` datetime default '0000-00-00 00:00:00', `tname` varchar(64) default NULL, PRIMARY KEY (`messageid`) ) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8; /*Data for the table `chatmessage` */ LOCK TABLES `chatmessage` WRITE; insert into `chatmessage`(`messageid`,`threadid`,`ikind`,`agentId`,`tmessage`,`dtmcreated`,`tname`) values (1,1,3,0,'訪客來源頁面：http://localhost/epl-v10.html','2010-01-31 11:28:11',NULL),(2,1,4,0,'歡迎您使用線上即時客服，請稍待客服回應…','2010-01-31 11:28:11',NULL),(3,1,1,0,'fdsf','2010-01-31 11:28:41','訪客'),(4,1,6,0,'客服人員 Administrator 加入對談','2010-01-31 11:28:49',NULL),(5,1,7,0,'','2010-01-31 11:28:49',NULL),(6,1,2,1,'哈樓！歡迎來到線上即時客服。有什麼我可以幫您的嗎？','2010-01-31 11:28:57','Administrator'),(7,1,6,0,'訪客 離開對談','2010-01-31 11:31:08',NULL),(8,2,3,0,'访客来源页面：http://localhost/epl-v10.html','2010-01-31 12:47:00',NULL),(9,2,4,0,'欢迎您使用线上即时客服，请稍待客服回应…','2010-01-31 12:47:00',NULL),(10,2,6,0,'客服人员 Administrator 加入对谈','2010-01-31 12:47:08',NULL),(11,2,7,0,'/images/avatar/1.jpg','2010-01-31 12:47:08',NULL),(12,2,2,1,'您好，请问有什么我可以帮您吗？','2010-01-31 12:47:13','Administrator'),(13,2,1,0,'dfs','2010-01-31 12:47:27','访客'),(14,2,1,0,'你那个产品需要多少钱啊','2010-01-31 12:47:44','访客'),(15,2,2,1,'不知道','2010-01-31 12:47:53','Administrator'),(16,2,1,0,'那您知道什么啊？','2010-01-31 12:48:16','访客'),(17,2,2,1,'哈哈，你怎么样','2010-01-31 12:48:28','Administrator'),(18,2,1,0,'夺取','2010-01-31 12:48:52','访客'),(19,2,6,0,'客服人员 Administrator 将您转移给另一位客服，请稍后','2010-01-31 12:49:28',NULL),(20,2,1,0,'枯','2010-01-31 12:49:46','访客'),(21,2,6,0,'客服人员 Administrator 回到线上','2010-01-31 12:51:56',NULL),(22,2,7,0,'/images/avatar/1.jpg','2010-01-31 12:51:56',NULL),(23,2,3,0,'访客关闭视窗','2010-01-31 12:51:03',NULL),(24,2,6,0,'访客 JJ 更换客服 Administrator','2010-01-31 12:56:13',NULL),(25,2,7,0,'/images/avatar/2.jpg','2010-01-31 12:56:13',NULL),(26,2,2,2,'sd','2010-01-31 12:56:18','JJ'),(27,2,6,0,'访客再一次加入对谈','2010-01-31 12:57:10',NULL),(28,2,5,0,'客服人员发生连线问题，我们暂时将您移到等候区。抱歉让您等候。','2010-01-31 12:56:52',NULL),(29,2,6,0,'客服人员 JJ 回到线上','2010-01-31 13:01:53',NULL),(30,2,7,0,'/images/avatar/2.jpg','2010-01-31 13:01:53',NULL),(31,2,3,0,'访客关闭视窗','2010-01-31 12:57:51',NULL),(32,2,6,0,'访客再一次加入对谈','2010-01-31 13:02:22',NULL),(33,2,1,0,'fds','2010-01-31 13:02:27','访客'),(34,2,2,2,'110','2010-01-31 13:02:37','JJ'),(35,2,1,0,'dfsd','2010-01-31 13:02:47','访客'),(36,2,6,0,'访客将名称 访客 改成 王先生','2010-01-31 13:03:11',NULL),(37,2,1,0,'遥遥','2010-01-31 13:03:15','王先生'),(38,2,6,0,'客服人员 JJ 将您转移给另一位客服，请稍后','2010-01-31 13:03:40',NULL),(39,2,6,0,'访客 Administrator 更换客服 JJ','2010-01-31 13:04:02',NULL),(40,2,7,0,'/images/avatar/1.jpg','2010-01-31 13:04:02',NULL),(41,2,2,1,'ds','2010-01-31 13:04:45','Administrator'),(42,2,2,1,'您好，请问有什么我可以帮您吗？','2010-01-31 13:06:35','Administrator'),(43,2,6,0,'访客再一次加入对谈','2010-01-31 13:07:41',NULL),(44,2,5,0,'客服人员发生连线问题，我们暂时将您移到等候区。抱歉让您等候。','2010-01-31 13:07:22',NULL),(45,2,6,0,'访客 JJ 更换客服 Administrator','2010-01-31 13:08:18',NULL),(46,2,7,0,'/images/avatar/2.jpg','2010-01-31 13:08:18',NULL),(47,2,6,0,'访客再一次加入对谈','2010-01-31 13:08:27',NULL),(48,2,5,0,'客服人员发生连线问题，我们暂时将您移到等候区。抱歉让您等候。','2010-01-31 13:08:50',NULL),(49,2,6,0,'访客 Administrator 更换客服 JJ','2010-01-31 13:10:12',NULL),(50,2,7,0,'/images/avatar/1.jpg','2010-01-31 13:10:12',NULL),(51,2,6,0,'访客再一次加入对谈','2010-01-31 13:43:12',NULL),(52,2,5,0,'客服人员发生连线问题，我们暂时将您移到等候区。抱歉让您等候。','2010-01-31 13:10:53',NULL),(53,2,6,0,'客服人员 Administrator 回到线上','2010-01-31 13:43:38',NULL),(54,2,7,0,'/images/avatar/1.jpg','2010-01-31 13:43:38',NULL),(55,2,6,0,'访客 JJ 更换客服 Administrator','2010-01-31 13:44:06',NULL),(56,2,7,0,'/images/avatar/2.jpg','2010-01-31 13:44:06',NULL),(57,2