Changeset 1365879
- Timestamp:
- 03/07/2016 02:36:05 PM (10 years ago)
- Location:
- activehelper-livehelp/trunk
- Files:
-
- 22 added
- 15 edited
-
activehelper-livehelp.php (modified) (3 diffs)
-
readme.txt (modified) (4 diffs)
-
server/agents/0/i18n/jp (added)
-
server/domains/0/i18n/jp (added)
-
server/domains/0/i18n/jp/pictures (added)
-
server/domains/0/i18n/jp/pictures/chat_banner.gif (added)
-
server/domains/0/i18n/jp/pictures/initiate_dialog.gif (added)
-
server/domains/0/i18n/jp/pictures/logo.jpg (added)
-
server/domains/0/i18n/jp/pictures/offline.gif (added)
-
server/domains/0/i18n/jp/pictures/online.gif (added)
-
server/domains/0/i18n/jp/pictures/send.gif (added)
-
server/domains/0/i18n/jp/pictures/send_hover.gif (added)
-
server/frames.php (modified) (2 diffs)
-
server/i18n/ge (added)
-
server/i18n/ge/lang_guest_ge.php (added)
-
server/i18n/ge/lang_service_ge.php (added)
-
server/i18n/ge/pictures (added)
-
server/i18n/ge/pictures/connecting.gif (added)
-
server/i18n/jp (added)
-
server/i18n/jp/lang_guest_jp.php (added)
-
server/i18n/jp/lang_service_jp.php (added)
-
server/i18n/jp/pictures (added)
-
server/i18n/jp/pictures/connecting.gif (added)
-
server/import/constants.php (modified) (1 diff)
-
server/import/functions.php (modified) (1 diff)
-
server/import/status.php (modified) (4 diffs)
-
server/index.php (modified) (5 diffs)
-
server/push-notify-msg.php (added)
-
server/push-notify.php (added)
-
server/refresher.php (modified) (2 diffs)
-
server/send.php (modified) (4 diffs)
-
server/services/send.php (modified) (3 diffs)
-
server/services/users.php (modified) (4 diffs)
-
sources/livehelp_agents.php (modified) (1 diff)
-
sources/livehelp_domains.php (modified) (1 diff)
-
sources/livehelp_lib-install.php (modified) (6 diffs)
-
sources/livehelp_server-settings.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
activehelper-livehelp/trunk/activehelper-livehelp.php
r1250404 r1365879 7 7 Plugin URI: http://www.activehelper.com 8 8 Description: Provide superior service by real time chat with your website visitors and interact them through your website. Create a more efficient connection with your website visitors, increase your sales and customer satisfaction. 9 Version: 3.9.69 Version: 4.0.0 10 10 Author: ActiveHelper Inc 11 11 Author URI: http://www.activehelper.com … … 807 807 ' . __('Version : ', 'activehelper_livehelp') . ' 808 808 </td><td class="b"> 809 ' . __(' 3.9.6', 'activehelper_livehelp') . '809 ' . __('4.0.0', 'activehelper_livehelp') . ' 810 810 </td></tr></tbody></table> 811 811 <table><tbody><tr><td class="first t"> … … 842 842 ' . __('Copyright', 'activehelper_livehelp') . ' 843 843 </td><td class="b"> 844 ' . __('Copyright © 2010 - 201 2. Activehelper - 2010 - 2014- All Rights Reserved', 'activehelper_livehelp') . '844 ' . __('Copyright © 2010 - 2016. Activehelper - 2010 - 2016 - All Rights Reserved', 'activehelper_livehelp') . ' 845 845 </td></tr></tbody></table> 846 846 </div> -
activehelper-livehelp/trunk/readme.txt
r1250404 r1365879 3 3 Tags: wordpress livechat, live chat, live help, live support, chat plugin, visitor tracking, visitor chat, phone live chat 4 4 Requires at least: 3.2 5 Tested up to: 4. 3.16 Stable tag: 3.9.65 Tested up to: 4.4.2 6 Stable tag: 4.0.0 7 7 8 8 Wordpress Live Chat plugin. Manage all your wordpress sites from your desktop or mobile. … … 12 12 Live Chat - Live chat plugin software. Worpress Live chat allows to engage website visitors to contact you in real-time to your computer desktop or mobile device. 13 13 14 The ActiveHelper Live Chat Plugin is available for WordPress 3.2x, to 4. 3x.14 The ActiveHelper Live Chat Plugin is available for WordPress 3.2x, to 4.4x. 15 15 16 16 WordPress Live Chat Plugin is the most affordable and scalable Live Chat. ActiveHelper Live Chat System is perfect for small and medium WordPress sites. Answer Live chats from any location, Desktop and mobile are included, Windows and Mac, IOS and Android too. … … 349 349 * Other small improvements and bug fixes. 350 350 351 = 4.0.0 = 352 * Push Notification support for the mobile app. 353 * Support Wordpress 4.4.x 354 * Enhanced mobile support. 355 * Japanese Language Included. 356 * Core Update. 357 * Core Security update. 358 * Other small improvements and bug fixes. 359 351 360 352 361 Upgrade: … … 564 573 * Enhanced mobile support. 565 574 * Other small improvements and bug fixes. 575 576 = 4.0.0 = 577 * Push Notification support for the mobile app. 578 * Support Wordpress 4.4.x 579 * Enhanced mobile support. 580 * Japanese Language Included. 581 * Core Update. 582 * Core Security update. 583 * Other small improvements and bug fixes. -
activehelper-livehelp/trunk/server/frames.php
r1239830 r1365879 75 75 76 76 // Query to see if panel/Operators are Online 77 $query = "SELECT UNIX_TIMESTAMP(`datetime`) AS `datetime` FROM " . $table_prefix . "users WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`refresh`)) < '$connection_timeout' AND `status` = '1'"; 77 $query = "SELECT UNIX_TIMESTAMP(`datetime`) AS `datetime` FROM " . $table_prefix . "users WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`refresh`)) < '$connection_timeout' and device_id ='' and `status` = '1'"; 78 if ($departments == true && $department != '') { $query .= " AND department LIKE '%$department%'"; } 79 $query .= " union " ; 80 81 $query .= "SELECT UNIX_TIMESTAMP(`datetime`) AS `datetime` FROM " . $table_prefix . "users WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`refresh`)) < '$connection_timeout_mobile' and device_id <>'' and `status` = '1'"; 78 82 if ($departments == true && $department != '') { $query .= " AND department LIKE '%$department%'"; } 79 83 $row = $SQL->selectquery($query); … … 147 151 // Add session details 148 152 $query = "INSERT INTO " . $table_prefix . "sessions (`request`, `username`, `datetime`, `email`, `phone` , `company`, `server`, `department`, `refresh`, `language`, rating, id_domain , id_agent) VALUES ('$request_id', '$username', NOW(), '$email', '$phone', '$company', '$current_host', '$department', NOW(), '".LANGUAGE_TYPE."', -1, $domain_id, $agent_id)"; 149 // echo("query2: " . $query);150 151 //exit('Termina... 2');152 153 $login_id = $SQL->insertquery($query); 153 154 } -
activehelper-livehelp/trunk/server/import/constants.php
r726722 r1365879 13 13 14 14 $install_directory = $server_directory."/".$eserverName; 15 $push_api_path = "http://s99.velaio.com/pushapi/"; 15 16 16 17 // Set advanced settings, ie. timers 17 18 18 19 $connection_timeout = 60; 20 $connection_timeout_mobile = 43200; 19 21 $keep_alive_timeout = 30; 20 22 $guest_login_timeout= 60; -
activehelper-livehelp/trunk/server/import/functions.php
r1003856 r1365879 191 191 { 192 192 $departments_sql = departmentsSQL($current_department); 193 $query = "SELECT DISTINCT (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`datetime`)) AS `display` FROM " . $table_prefix . "sessions WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`refresh`)) < '$timeout' AND active = '0' AND $departments_sql"; 193 $query = "SELECT DISTINCT (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`datetime`)) AS `display` FROM " . $table_prefix . "sessions WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`refresh`)) < '$timeout' AND active = '0' AND $departments_sql"; 194 194 195 } 195 196 else -
activehelper-livehelp/trunk/server/import/status.php
r878815 r1365879 113 113 if ($status_enabled == true) { 114 114 115 /* Verificar si hay agentes mobiles conectados y determinar cual es el tipo de refresco que se debe usar */ 116 115 117 $num_support_available_users = 0; 116 118 $num_support_hidden_users = 0; … … 123 125 $SQL->miscquery($query); 124 126 } 125 // Counts the total number of support users within each Online/Offline/BRB/Away status mode 126 $query = "SELECT DISTINCT `status`, count(`id`) FROM " . $table_prefix . "users WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`refresh`)) < '$connection_timeout' And id in (" . $users_set . ")"; 127 128 // Counts the total number of support users within each Online/Offline/BRB/Away status mode *** New Query in order to support Push notifications *** 129 $query = "SELECT DISTINCT `status`, count(`id`) FROM " . $table_prefix . "users WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`refresh`)) < '$connection_timeout' and device_id ='' and id in (" . $users_set . ")"; 127 130 128 131 if($department != '' && $departments && $agent_id ==0) … … 135 138 { $query .= " and `answers`='2' and `id`= $agent_id"; } 136 139 140 $query .=" union "; 141 142 $query .= "SELECT DISTINCT `status`, count(`id`) FROM " . $table_prefix . "users WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`refresh`)) < '$connection_timeout_mobile' and device_id <> '' and id in (" . $users_set . ")"; 143 144 if($department != '' && $departments && $agent_id ==0) 145 { $query .= " and `answers`='1' and `department` LIKE '%$department%'"; } 146 else 147 if($agent_id ==0) 148 { $query .= " and `answers`='1' "; } 149 else 150 if($agent_id !=0) 151 { $query .= " and `answers`='2' and `id`= $agent_id"; } 152 153 137 154 /* error_log("department:".$department."\n", 3, "status.log"); 138 155 error_log("departments:".$departments."\n", 3, "status.log"); … … 140 157 error_log("$query:".$query."\n", 3, "status.log"); 141 158 */ 142 159 143 160 if($userid != '') { $query .= " AND id <> " . $userid; } 144 161 $query .= " GROUP BY `status`"; -
activehelper-livehelp/trunk/server/index.php
r1250404 r1365879 123 123 124 124 // Count available departments 125 $query = "SELECT DISTINCT u.department FROM " . $table_prefix . "users u, " . $table_prefix . "domain_user du WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(u.refresh)) < '$connection_timeout' and u.status = '1' and u.id = du.id_user And du.id_domain = " . $domain_id; 125 $query = "SELECT DISTINCT u.department FROM " . $table_prefix . "users u, " . $table_prefix . "domain_user du WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(u.refresh)) < '$connection_timeout' and device_id ='' and u.status = '1' and u.id = du.id_user And du.id_domain = " . $domain_id; 126 127 $query .= " union " ; 128 129 $query .= "SELECT DISTINCT u.department FROM " . $table_prefix . "users u, " . $table_prefix . "domain_user du WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(u.refresh)) < '$connection_timeout_mobile' and device_id <>'' and u.status = '1' and u.id = du.id_user And du.id_domain = " . $domain_id; 126 130 $rows = $SQL->selectall($query); 127 131 … … 130 134 } 131 135 } 132 } 136 } 133 137 134 138 // User Recognition Auto Start … … 168 172 // Checks if any users in user table are online 169 173 if ($error == '') { 170 $query = "SELECT u.id FROM " . $table_prefix . "users u, " . $table_prefix . "domain_user du WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(u.refresh)) < '$connection_timeout' ANDu.status = '1' And du.id_user = u.id And du.id_domain = ".$domain_id;174 $query = "SELECT u.id FROM " . $table_prefix . "users u, " . $table_prefix . "domain_user du WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(u.refresh)) < '$connection_timeout' and device_id ='' and u.status = '1' And du.id_user = u.id And du.id_domain = ".$domain_id; 171 175 if ($department != '' && $departments == true && $agent_id ==0) 172 176 { $query .= " and `answers`=1 and department LIKE '%$department%'"; } … … 177 181 if ( $agent_id !=0) 178 182 { $query .= " and `answers`=2 and u.id=" .$agent_id; } 183 184 $query .= " union " ; 185 186 $query .= "SELECT u.id FROM " . $table_prefix . "users u, " . $table_prefix . "domain_user du WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(u.refresh)) < '$connection_timeout_mobile' and device_id <>'' and u.status = '1' And du.id_user = u.id And du.id_domain = ".$domain_id; 187 if ($department != '' && $departments == true && $agent_id ==0) 188 { $query .= " and `answers`=1 and department LIKE '%$department%'"; } 189 else 190 if ($agent_id ==0) 191 { $query .= " and `answers`=1 "; } 192 else 193 if ( $agent_id !=0) 194 { $query .= " and `answers`=2 and u.id=" .$agent_id; } 195 179 196 180 197 $row = $SQL->selectquery($query); … … 620 637 { $query .= " and `answers`='2' and `id`= $agent_id"; } 621 638 639 640 $query .= " union " ; 641 642 $query.= "SELECT DISTINCT u.department FROM " . $table_prefix . "users u, " . $table_prefix . "domain_user du WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(u.refresh)) < '$connection_timeout_mobile' and device_id <>'' and u.status = '1' And u.id = du.id_user And du.id_domain = " . $domain_id; 622 643 644 if($agent_id ==0) 645 { $query .= " and `answers`='1' "; } 646 else 647 if($agent_id !=0) 648 { $query .= " and `answers`='2' and `id`= $agent_id"; } 649 623 650 $rows = $SQL->selectall($query); 624 651 -
activehelper-livehelp/trunk/server/refresher.php
r1003856 r1365879 113 113 $query = "SELECT `active`, `datetime`, (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`datetime`)) AS `waiting` FROM " . $table_prefix . "sessions WHERE `id` = '$guest_login_id'"; 114 114 $row = $SQL->selectquery($query); 115 116 //error_log("Accept Chat Request : " . $query ."\n" , 3 ,"refresher.log"); 117 115 118 if (is_array($row)) { 116 119 $active = $row['active']; 117 120 $datetime = $row['datetime']; 118 121 $waiting = $row['waiting']; 119 } 120 121 122 $session = array(); 123 122 } 123 124 $query = "SELECT id FROM " . $table_prefix ."users u WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(u.refresh)) < '$connection_timeout_mobile' and ". 125 " device_id <>'' and u.status = '1' "; 126 127 $mobile_agents_count =0; 128 129 // error_log("Mobile Agents Available : " . $query ."\n" , 3 ,"refresher.log"); 130 131 $mobile_agents_count = $SQL->selcount($query); 132 133 if ($mobile_agents_count > 0) { 134 135 // error_log("Psuh Agents : " . $mobile_agents_count ."\n" , 3 ,"refresher.log"); 136 include('push-notify.php'); 137 138 } 139 140 $session = array(); 124 141 125 142 $session1 = array(); … … 271 288 $lan = $session['LANGUAGE']; 272 289 273 #error_log("domain : " . $domain_id . " languaje : " . $lan, 3, "languaje.log");290 //error_log("domain : " . $domain_id . " languaje : " . $lan, 3, "languaje.log"); 274 291 275 292 $query = "select `welcome_message` from " . $table_prefix . "languages_domain where id_domain = $domain_id and code = '$lan'"; -
activehelper-livehelp/trunk/server/send.php
r1003856 r1365879 57 57 $query = "INSERT INTO " . $table_prefix . "administration (`user`, `username`, `datetime`, `message`, `align`, `status`, `id_domain`) VALUES('$operator_login_id', '$current_username', NOW(), '$message', '1', '1', '$id_domain')"; 58 58 $SQL->insertquery($query); 59 59 60 } 60 61 else { 61 62 $query = "INSERT INTO " . $table_prefix . "messages (`session`, `username`, `datetime`, `message`, `align`, `status`, `id_domain`) VALUES('$id', '$current_username', NOW(), '$message', '1', '1', '$id_domain')"; 62 63 $SQL->insertquery($query); 64 65 63 66 } 64 67 } … … 71 74 $query = "INSERT INTO " . $table_prefix . "messages ( `session`, `username`, `datetime`, `message`, `align`, `status`, `id_domain`) VALUES ( '$id', '$current_username', NOW(), '$response', '1', '1', '$id_domain')"; 72 75 $SQL->insertquery($query); 76 77 78 73 79 } 74 80 if ($command != '') { … … 109 115 } 110 116 $SQL->insertquery($query); 117 111 118 } 112 119 … … 139 146 $query = "INSERT INTO " . $table_prefix . "messages (`session`, `username`, `datetime`, `message`, `align`, `id_domain`) VALUES ('$guest_login_id', '$guest_username', NOW(), '$message', '1', '$id_domain')"; 140 147 $SQL->insertquery($query); 148 149 //error_log("SQL Insert 5: " . $query ."\n" , 3 ,"send.log"); 150 include('push-notify-msg.php'); 151 141 152 if($SQL->db_error != "") { 142 153 ?> -
activehelper-livehelp/trunk/server/services/send.php
r553176 r1365879 163 163 $message = addslashes($message); 164 164 165 166 165 167 if (!$staff) 166 168 { … … 169 171 " `datetime`, `message`, `align`, `status`, id_domain, id_user) VALUES( '$to',". 170 172 " '$operator_name', NOW(), '$message', '1', $type, $id_domain, $operator_login_id)"; 171 173 172 174 173 175 $id = $SQL->insertquery($query); … … 193 195 $result = '1'; 194 196 } 195 } 197 198 199 200 } 201 196 202 } 197 203 -
activehelper-livehelp/trunk/server/services/users.php
r1003856 r1365879 91 91 $query = "UPDATE " . $table_prefix . "sessions SET `active` = '$operator_login_id', `id_user` = '$operator_login_id' WHERE `id` = '$login_id'"; 92 92 $SQL->miscquery($query); 93 94 95 96 97 93 } 98 94 } … … 135 131 elseif ($action == 'Hidden' || $action == 'Offline') 136 132 { 133 137 134 // Update the username, password and change to hidden mode 138 $query = "UPDATE " . $table_prefix . "users SET `refresh` = NOW(), `status` = '0' WHERE `id` = '$operator_login_id'"; 135 //$query = "UPDATE " . $table_prefix . "users SET `refresh` = NOW(), `status` = '0' WHERE `id` = '$operator_login_id'"; 136 // new query for push notifications 137 $query = "UPDATE " . $table_prefix . "users SET `refresh` = NOW(), `status` = '0' , device ='' , device_id = '' WHERE `id` = '$operator_login_id'"; 139 138 $SQL->miscquery($query); 140 139 … … 304 303 305 304 if ($indicator_type == 1) { 305 306 306 if ($departments == true && $current_department !='') 307 307 { 308 309 308 310 $sql = departmentsSQL($current_department); 309 311 $query = "SELECT DISTINCT `id`, `username`, email, language, request FROM " . $table_prefix . "sessions WHERE (UNIX_TIMESTAMP(NOW())". … … 338 340 } 339 341 342 //error_log("SQL Chat request pending :".$query."\n", 3, "users.log"); 340 343 341 344 if($sessions_set != ""){ -
activehelper-livehelp/trunk/sources/livehelp_agents.php
r959998 r1365879 1037 1037 'et' => __('Estonian', 'activehelper_livehelp'), 1038 1038 'lv' => __('Latvian', 'activehelper_livehelp'), 1039 'ge' => __('Georgian', 'activehelper_livehelp'), 1039 'ge' => __('Georgian', 'activehelper_livehelp'), 1040 'jp' => __('Japanese', 'activehelper_livehelp'), 1040 1041 ); 1041 1042 -
activehelper-livehelp/trunk/sources/livehelp_domains.php
r959998 r1365879 211 211 'lv' => __('Latvian', 'activehelper_livehelp'), 212 212 'ge' => __('Georgian', 'activehelper_livehelp'), 213 'jp' => __('Japanese', 'activehelper_livehelp'), 213 214 214 215 ); -
activehelper-livehelp/trunk/sources/livehelp_lib-install.php
r1250404 r1365879 2 2 /** 3 3 * @package ActiveHelper Live Help 4 * @Version 3.9.64 * @Version 4.0.0 5 5 */ 6 6 … … 69 69 70 70 $install_directory = $server_directory."/".$eserverName; 71 $push_api_path = "http://s99.velaio.com/pushapi/"; 71 72 72 73 // Set advanced settings, ie. timers 73 74 74 75 $connection_timeout = 60; 76 $connection_timeout_mobile = 43200; 75 77 $keep_alive_timeout = 30; 76 78 $guest_login_timeout= 60; … … 249 251 INSERT INTO wp_livehelp_languages VALUES ('lv', 'Latvian', 'utf-8'); 250 252 INSERT INTO wp_livehelp_languages VALUES ('ge', 'Georgian', 'utf-8'); 253 INSERT INTO wp_livehelp_languages VALUES ('jp', 'Japanese', 'utf-8'); 251 254 252 255 CREATE TABLE IF NOT EXISTS `wp_livehelp_languages_domain` ( … … 268 271 `status` int(1) NOT NULL default '0', 269 272 `id_user` bigint(20) default '-1', 273 `delivered` int(1) DEFAULT '0', 270 274 PRIMARY KEY (`id`), 271 275 KEY `idx_session` (`session`) … … 470 474 `final_time` time DEFAULT NULL, 471 475 `device` varchar(20) DEFAULT NULL, 472 `device_id` varchar( 60) DEFAULT NULL,476 `device_id` varchar(200) DEFAULT NULL, 473 477 PRIMARY KEY (`id`), 474 478 UNIQUE KEY `uk_users_username` (`username`) … … 990 994 $database_version = "3.9.6"; 991 995 } 996 997 998 if ($database_version == "3.9.6") { 999 1000 $table_name = $wpdb->prefix . "livehelp_languages"; 1001 $sql ="INSERT INTO $table_name VALUES ('jp', 'Japanese', 'utf-8')"; 1002 dbDelta($sql); 1003 1004 $table_name = $wpdb->prefix . "livehelp_users"; 1005 1006 $sql = "CREATE TABLE $table_name ( 1007 `id` bigint(20) NOT NULL auto_increment, 1008 `username` varchar(50) NOT NULL default '', 1009 `password` varchar(100) NOT NULL default '', 1010 `firstname` varchar(50) NOT NULL default '', 1011 `lastname` varchar(50) NOT NULL default '', 1012 `email` varchar(50) NOT NULL default '', 1013 `department` varchar(100) NOT NULL default '', 1014 `datetime` datetime NOT NULL default '0000-00-00 00:00:00', 1015 `refresh` datetime NOT NULL default '0000-00-00 00:00:00', 1016 `disabled` int(1) NOT NULL default '0', 1017 `privilege` int(1) NOT NULL default '0', 1018 `photo` varchar(10) DEFAULT NULL, 1019 `status` bigint(20) NOT NULL default '0', 1020 `answers` int(1) default '1', 1021 `schedule` int(1) DEFAULT '0', 1022 `initial_time` time DEFAULT NULL, 1023 `final_time` time DEFAULT NULL, 1024 `device` varchar(20) DEFAULT NULL, 1025 `device_id` varchar(200) DEFAULT NULL, 1026 PRIMARY KEY (`id`), 1027 UNIQUE KEY `uk_users_username` (`username`) 1028 ); "; 1029 1030 dbDelta( $sql ); 1031 1032 1033 $table_name = $wpdb->prefix . "livehelp_messages"; 1034 1035 $sql = "CREATE TABLE $table_name ( 1036 `id` bigint(20) NOT NULL auto_increment, 1037 `session` bigint(20) NOT NULL default '0', 1038 `username` varchar(30) NOT NULL default '', 1039 `datetime` datetime NOT NULL default '0000-00-00 00:00:00', 1040 `message` text NOT NULL, 1041 `id_domain` bigint(20) default NULL, 1042 `align` int(1) NOT NULL default '0', 1043 `status` int(1) NOT NULL default '0', 1044 `id_user` bigint(20) default '-1', 1045 `delivered` int(1) DEFAULT '0', 1046 PRIMARY KEY (`id`), 1047 KEY `idx_session` (`session`) 1048 ); "; 1049 1050 dbDelta( $sql ); 1051 1052 $database_version = "4.0.0"; 1053 } 992 1054 } 993 1055 -
activehelper-livehelp/trunk/sources/livehelp_server-settings.php
r925841 r1365879 147 147 </td></tr></tbody></table> 148 148 149 149 150 <table style="margin-top: 1.5ex;"><thead><tr><th style="font-size: 12px; font-weight: normal; text-align: left;"> 150 151 <label for="keep_alive_timeout">' . __('Keep Alive Timeout (sec)', 'activehelper_livehelp') . '</label>
Note: See TracChangeset
for help on using the changeset viewer.