Version 3.7.0: ( November 7, 2023 )
==================================================================
UPDATES: ------------------------------------------------------------------
+ The previously "pro/unbranded" option that was released in 2017 has now been included as a
selectable config option to remove the powered by sales syntax link directly from the installation rather
then needing to download and install a special version of files. You can now select to not
show the powered by links by selecting that option in the generate html or department settings.
+ Changed all PHP calls to each() which is a depreciated in php 8 to foreach():
// changed this code which will error out in php 8:
while (list($key, $val) = each($what)) { }
// to this code which works:
foreach ($what as $key => $val) { }
+ added missing 3rd parameter of response code to the function header() calls and lower cased the
function name from Header() to header() as of php 8 it is required.
+ added default values for undefined variables as a result of no result sql statements that
because of no results never populated a results associative array and thus caused errors in php 8.
+ added if condition to check for ghost sessions upon loading the user info if the user has not been
inserted yet to prevent null value array errors.
+ added default value for global value of $hide to be "N" to prevent undefined error also referenced
script defined array since in php 8 you can not change global values of $_GET array.
+ changed the browser_info class to the more updated Browser class. replaced class/browser_info.php
with new class class/Browser.php+ the hour parameter is required now as of php 8 and must be cast as
a int so updated all mktime() calls.+ the CTabBox class was throwing errors when trying to include
files so moved the include file statements to data.php file.+ the generate HTML function on the live
help department was referencing the rows of the department by an associative array instead of ordered
array so the references was throwing undefined errors. this is fixed.
FILES CHANGED: ------------------------------------------------------------------
ALL OF THEM.
DATABASE ALTERATIONS:------------------------------------------------------------------
NONE
Version 3.6.2: (Released: February 17, 2017 )
================================================================== + Fixed SQL injection vulerabilty with variables $aftertime and $typeof. replace all >'$aftertime' WITH >'".intval($aftertime)."' added if statment at time that if $typeof != "writediv" ) then $typeof=""; + Fixed window size problem with template bubble_window + Fixed issue with chat sound not playing when someone is requesting a chatFILES CHANGED: ------------------------------------------------------------------ setup.php, iphone/functions.php, functions.php, livehelp_js.php admin_users_refresh.php, admin_users_xmlhttp.php, themes/bubble_window/windowsize.php, themes/bubble_window/chat_window.php , themes/bubble_window/chat_windowlarge.php, departments.php, admin_chat_bot.phpDATABASE ALTERATIONS:------------------------------------------------------------------ NONE Version 3.6.1: (Released: June 21, 2016 ) ================================================================== + Added new leads tab to keep track of generated leads. + Added ability to send layer invites when offline to pro-actively gather lead information from visitors even when operators are offline. FILES CHANGED: ------------------------------------------------------------------ setup.php, autolead.php, functions.php, autoinvite.php, navigation.php send.php, sendemail.php, createemail.php, leads.php, admin.php, layer_invites/layer-Help_buttonoffline.txt, layer_invites/layer-Help_buttonoffline.gif DATABASE ALTERATIONS:------------------------------------------------------------------ ALTER TABLE `livehelp_autoinvite` ADD `offline` INT( 1 ) NOT NULL DEFAULT '0' CREATE TABLE IF NOT EXISTS `livehelp_leads` ( `id` int(8) NOT NULL AUTO_INCREMENT, `email` varchar(90) NOT NULL, `phone` varchar(90) NOT NULL, `source` varchar(45) NOT NULL, `status` varchar(10) NOT NULL, `firstname` varchar(40) NOT NULL, `lastname` varchar(40) NOT NULL, `date_entered` int(8) NOT NULL, PRIMARY KEY (`id`), KEY `email` (`email`,`source`,`status`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 CREATE TABLE IF NOT EXISTS `livehelp_emails` ( `id` int(8) NOT NULL AUTO_INCREMENT, `fromemail` varchar(60) NOT NULL, `subject` varchar(60) NOT NULL, `bodyof` text NOT NULL, `notes` varchar(255) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 CREATE TABLE IF NOT EXISTS `livehelp_emailque` ( `id` int(8) NOT NULL AUTO_INCREMENT, `messageid` int(8) NOT NULL, `towho` varchar(60) NOT NULL, `dateof` int(8) NOT NULL, PRIMARY KEY (`id`), KEY `messageid` (`messageid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 Version 3.5.4: (Released: May 28, 2016 ) ================================================================== + updated graphics to include new logo of Sales Syntax. + Added tab for linking user database for CRM management. + Added ability for support tickets. + added tab for lead management and added wall for operators to see posts. FILES CHANGED: ------------------------------------------------------------------ setup.php, config_cslh.php, class/mysql_db.php, class/mysqli_db.php, mobile/mysql_db.php, mobile/mysqli_db.php, images/logo.jpg. images/loginbk.jpg Version 3.5.3: (Released: March 30, 2016 ) ================================================================== + converted the depreciated mysql functions to mysqli functions for support for php 4+ Version 3.5.2: (Released: December 2, 2015 ) ================================================================== + added HTML5 support for audio tag and made this option default for all new installations. should allow audio to play without quicktime for the latest browsers. code still includes option to use embed tags for older browsers. Version 3.5.1: (Released: November 28, 2015 ) ================================================================== + new website transition and security updates are being made from our new domain salessyntax.net rather then from craftysyntax.com or cslh.com . Version 3.4.7: (Released: August 15, 2013 ) ================================================================== + Added the CRM features for gathering customer data from visitors to website even when offline. Version 3.4.6: (Released: April 23, 2013 ) ================================================================== + UNBRANDED RELEASE OF 3.4.4 Version 3.4.5: (Released: April 23, 2013 ) ================================================================== + MOBILE RELEASE OF 3.4.4 Version 3.4.4: (Released: April 23, 2013 ) ================================================================== SECURITY RELEASE UPDATE: Two very minor security issues were discovered in Sales Syntax Live Help. The Patch for both of these is detailed below. Both of these security issues are VERY MINOR. The admin.php can not be accessed by the public so the remote file vulnerabiy can only be exploited by operators which makes it very hard to exploit. Additonally it is not executed code so not remote code can be run on the server. The full path disclosure allows hackers to see the full path to your installation but nothing more. This has been fixed as well. 1) Remote File Include : admin.php if(!(isset($UNTRUSTED['page']))){ $UNTRUSTED['page'] = "scratch.php"; } http://localhost/path/admin.php?page=[RFI] 2) Full Path Disclosure: xmlhttp.php Dork: inurl:"/xmlhttp.php" Notice: Undefined index: whattodo PATCH FOR ABOVE: 1) Open up admin.php and update line #45 to be: add these lines after line #38: $page = "scratch.php";if($UNTRUSTED['page']=="scratch.php"){ $page = "scratch.php"; }if($UNTRUSTED['page']=="mastersettings.php"){ $page = "mastersettings.php"; }if($UNTRUSTED['page']=="help.php"){ $page = "help.php"; }if($UNTRUSTED['page']=="edit_layer.php"){ $page = "edit_layer.php"; }if($UNTRUSTED['page']=="edit_smile.php"){ $page = "edit_smile.php"; }if($UNTRUSTED['page']=="operators.php"){ $page = "operators.php"; }if($UNTRUSTED['page']=="departments.php"){ $page = "departments.php"; }if($UNTRUSTED['page']=="data.php"){ $page = "data.php"; }if($UNTRUSTED['page']=="modules.php"){ $page = "modules.php"; }2) Open up xmlhttp.php and change line #52: if(empty($UNTRUSTED['whattodo'])){ $UNTRUSTED['whattodo'] = ""; } remove line #53: $whattodo = ""; FILES CHANGED: ------------------------------------------------------------------ setup.php, xmlhttp.php, admin.php, navigation.php, Version 3.4.1: (Released: January 19, 2013 ) ================================================================== + Fixed bug with bar graphs for visitors sometimes showing double + Fixed issue with version number showing older version FILES CHANGED: ------------------------------------------------------------------ setup.php, data_visits.php, livehelp_js.php, navigation.php, Version 3.3.8: (Released: August 5, 2012 ) ================================================================== + Fixed bug with missing the department parameter for the paging on page visits + Fixed cross site scripting vunerability with livehelp_js.php FILES CHANGED: ------------------------------------------------------------------ setup.php, data_visits.php, livehelp_js.php, navigation.php, Version 3.3.8: (Released: June 2, 2012 ) ================================================================== + NO-link back RELEASE OF 3.3.6 Version 3.3.7: (Released: June 2, 2012 ) ================================================================== + MOBILE RELEASE OF 3.3.6 Version 3.3.6: (Released: June 2, 2012 ) ================================================================== + fixed Bug with adding a new operator and the display name showing a md5 string rather then the username upon first creation of the operator. + Set resource limits to OFF by default. Max requests can be set in settings if choosen to . + added number of requests to admin's list of users. FILES CHANGED: ------------------------------------------------------------------ setup.php, operators.php DATABASE ALTERATIONS:------------------------------------------------------------------ None.Version 3.3.5: (Released: May 29, 2012 ) ================================================================== + NO-link back RELEASE OF 3.3.3 Version 3.3.4: (Released: May 29, 2012 ) ================================================================== + MOBILE RELEASE OF 3.3.3 Version 3.3.3: (Released: May 29, 2012 ) ================================================================== + fixed issue with visitor data in the "data" tab showing double date bars due to the departments not being separated out.. + fixed short-hand php code marker ' 1334161349] ( 1146 : Table 'tropical_help.livehelp_sessions' doesn't exist ) + FIXED issue with external chat windows staying open even if the visitor closes the chat session. If the chat session is closed the admin external window closes as well now instead of staying open as before. + Added displayname so that oparators can have a name that is different then their login for the chat.. for example username "csyntax" display name "Eric" this makes it so multiple operators with the same name can log in. + added the ability to look up the geo-location of the ip address in the details for the chat. + made the generated html code XHTML 1.0 Transitional Valid for W3C FILES CHANGED: ------------------------------------------------------------------ setup.php, external_bot.php, external_frameset.php, operators.php, details.php functions.php, invite.php DATABASE ALTERATIONS: ------------------------------------------------------------------ ALTER TABLE `livehelp_users` ADD `displayname` VARCHAR( 42 ) NOT NULL AFTER `username` Version 3.2.2: (Released: April 4, 2012 ) ================================================================== + SPECIAL NO-BACKLINK VERSION OF Sales Syntax. Version 3.2.1: (Released: April 4, 2012 ) ================================================================== + FIXED helper files for application working on windows servers windows hosted live help installations were not able to work using the mobile app intil this version 3.2.0 + MOBILE RELEASE OF 3.2.0 Version 3.2.0: (Released: April 4, 2012 ) ================================================================== + FIXED client_visitors.php ( upgraded to version 2.5.9) + FIXED BUG: with undefined variables pageurl and page http://www.salessyntax.net/support/viewtopic.php?t=661 + ADDED indexes to users and sessions table to speed up chat + FIXED time zone issue settings now shows time in geo-location rather then number. + Removed Dynamic Layer Object library (coded in 1999) and replaced it with simple W3C standard layer moving layers helps with load time. + FIXED helper files for iphone application working on windows servers windows hosted live help installations were not able to work using the iphone app intil this version 3.2.0 + UPDATED Portuguese (Brazil) language file FILES CHANGED: ------------------------------------------------------------------ setup.php, client_visitors.php, lang/lang-Portuguese_Brazilian.php mastersettings.php, ALL FILES in the iphone direcory ALL files in the /mobile diretory livehelp_js.php, image.php, livehelp.php ALL files in the themes/* DATABASE ALTERATIONS: ------------------------------------------------------------------ ALTER TABLE `livehelp_users` ADD INDEX ( `expires` ) ALTER TABLE `livehelp_users` ADD INDEX ( `sessionid` ) ALTER TABLE `livehelp_sessions` ADD INDEX ( `expires` ) Version 3.2.0: (Released: April 4, 2012 ) ================================================================== + FIXED client_visitors.php ( upgraded to version 2.5.9) + FIXED BUG: with undefined variables pageurl and page http://www.salessyntax.net/support/viewtopic.php?t=661 + ADDED indexes to users and sessions table to speed up chat + FIXED time zone issue settings now shows time in geo-location rather then number. + Removed Dynamic Layer Object library (coded in 1999) and replaced it with simple W3C standard layer moving layers helps with load time. + FIXED helper files for iphone application working on windows servers windows hosted live help installations were not able to work using the iphone app intil this version 3.2.0 + UPDATED Portuguese (Brazil) language file FILES CHANGED: ------------------------------------------------------------------ setup.php, client_visitors.php, lang/lang-Portuguese_Brazilian.php mastersettings.php, ALL FILES in the iphone direcory ALL files in the /mobile diretory livehelp_js.php, image.php, livehelp.php ALL files in the themes/* DATABASE ALTERATIONS: ------------------------------------------------------------------ ALTER TABLE `livehelp_users` ADD INDEX ( `expires` ) ALTER TABLE `livehelp_users` ADD INDEX ( `sessionid` ) ALTER TABLE `livehelp_sessions` ADD INDEX ( `expires` ) Version 3.1.11: (Released: March 25, 2012 ) ================================================================== + SPECIAL NO-BACKLINK VERSION OF Sales Syntax. Version 3.1.10: (Released: March 25, 2012 ) ================================================================== + MOBILE RELEASE OF 3.1.9 Version 3.1.9: (Released: March 25, 2012 ) ================================================================== + FIXED BUG: problem with generatting multiple department live help icons on the same webpage has been fixed + FIXED BUG: department showing defualt online / offline image rather then department specific icons + ADDED ability to generate powered by credit links for dark background websites rather then light colorered ones. + ADDED javascript Check to be sure the DIV layer for Sales Syntax exists before trying to write to it. This was causing javascript on some sites to fail. + FIXED bug with default value of hidding chat icon when not online not being read. ONly the value from generate HTML was being used. FILES CHANGED: ------------------------------------------------------------------ setup.php, livehelp_js.php, htmltags.php, image.php visitor_common.php, admin.php DATABASE ALTERATIONS: ------------------------------------------------------------------ NONE Version 3.1.8: (Released: March 8, 2012 ) 1:02am Hawaii Time.-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ + Removed "Powered by Sales Syntax" links from client side of chat on all themes + Removed the "Powered by Sales Syntax" from the live chat icon + Removed the "Donation page" that shows every 10th login on the site + UNBRANDED RELEASE OF 3.1.7 Version 3.1.7: (Released: March 8, 2012 ) 1:01am Hawaii Time-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ + Fixed SQL error with Unknown column 'displayname' in 'field list' caused by missing database field. + Fixed issue with some phones not being able to "click on" the input boxes for phone number on settings page. + MOBILE RELEASE OF 3.1.6 Version 3.1.6: (Released: March 8, 2012 ) 1:00am Hawaii Time================================================================== + The ability to generate the HTML code so that the Live help is loaded Asynchronously. This saves page load time as now webpages no longer need to wait for the live help icon in order to be loaded. Re-generation of html code is needed for this option. + Updated the Live Client file from version 2.5.2 to the latest 2.5.7 to allow additional features for the windows application. + Added options to change the sounds for: New Visitors sound, Incoming Chat Request, Typing message. All sounds are customizable by operator so each operator can have a different chat sound. You can add your own sounds for the system by simply uploading new wav files to the "sounds/" directory. + Fixed bug with timezones of non whole number values like 3.3 and 5.3 . The time offsett value for the program in settings now works for these timezones : 'America/Caracas' => -4.30, 'America/St_Johns' => -3.30, 'Asia/Tehran' => 3.30, 'Asia/Kolkata' => 5.30, 'Asia/Katmandu' => 5.45, 'Asia/Rangoon' => 6.30, 'Australia/Darwin' => 9.30 + Added the current page the live chat is on when the leave a message request is made. + Added Option from the generate HTML page to choose to not show the leave a message icon when offline. Also added option on using tables or Div tags. + Fixed issue with urltohelpimage having quotes in the query string preventing the department number being passed to it . + Fixed issue with new visitors to the site not alerting the sound file of new visitors IF alert of visitors is checked. (not recommended to have on if you have a lot of visitors to your site) FILES CHANGED: ------------------------------------------------------------------ setup.php, operators.php, navigation.php, navigation.php, htmltags.php department_function.php, admin_common.php, admin_chat_bot.php, admin_users_refresh.php, livehelp_js.php, leavemessage.phph, image.php (it is best to upload ALL the files except config.php for the upgrade) DATABASE ALTERATIONS: ------------------------------------------------------------------ ALTER TABLE `livehelp_users` ADD `alertchat` VARCHAR( 45 ) NOT NULL DEFAULT '' ALTER TABLE `livehelp_users` ADD `alerttyping` VARCHAR( 45 ) NOT NULL DEFAULT 'sounds/typing.wav' ALTER TABLE `livehelp_users` ADD `alertinsite` VARCHAR( 45 ) NOT NULL DEFAULT '' ALTER TABLE `livehelp_config` CHANGE `offset` `offset` FLOAT( 8, 2 ) NOT NULL DEFAULT '0' Version 3.1.5: (Released: August 9, 2011 ) -================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ + MOBILE RELEASE OF 3.1.4 Version 3.1.4: (Released: August 9, 2011 ) ================================================================== + FIXED BUG with quicktime crashing the sound alert for typing and alerts of new visitors. + Fixed security issue with pageurl Cross Site Scripting. http://secunia.com/advisories/45287/ Really MINOR security issue that only effects the end user not the operator.. NOT A THREAT.. but still needed to be fixed because of being listed as a secuirity issue in secunia. + fixed size issue in the bubble_window and vanilla templates that was causing the photo to show below the textarea.. FILES CHANGED: ------------------------------------------------------------------ livehelp.php, setup.php, xmlhttp.php, admin_chat_bot.php external_top.php, external_chat_xmlhttp.php, external_bot.php, admin_rooms.php, admin_users_refresh.php DATABASE ALTERATIONS: ------------------------------------------------------------------ NONE Version 3.1.3: (Released: March 21, 2011 ) -================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ + MOBILE RELEASE OF 3.1.2 ( furture releases from here will be of their own package to avoid confusion ) + Added ability to set the timeout time of the mobile app from "CS Settings" + Added ability to add/edit can reply messages from app + fixed issue with non short hand php tag in live.php ----------------------------------------------------------------~- Version 3.1.2: (Released: March 21, 2011 ) ================================================================== + Fixed issue with non short hand php tag in live.php + added missing brown tab image in template files + Updated iphone text message and fixed issue with logging into mobile version from iphone version from the text message . + Fixed issue with operator image in template "vanilla" sometimes causing the chat input box to be pushed down and causing the chat input box not to be visable. + added more features for iphone app in the server helper files such as ability to set the timeout of the mobile app, ability to add/edit can reply messages etc.. FILES CHANGED: ------------------------------------------------------------------ iphone/*, gc.php, setup.php, login.php, user_connect.php, image.php DATABASE ALTERATIONS: ------------------------------------------------------------------ Version 3.1.1: (Released: February 13, 2011 ) -================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ + MOBILE RELEASE OF 3.1.0 + Added ability to end chat from the mobile app + Added log out and help buttons to the main chat page. - Added missing /iphone/mobile/exit.jpg images - Fixed issue with the keypad when typing message hiding the input box preventing your from seeing what your typing ----------------------------------------------------------------~- Version 3.1.0: (Released: February 11, 2011 ) ================================================================== + Added Support for iphone.. there are now helping files in the installation for when you buy the iphone application buy it today: http://www.salessyntax.net/iphone.php + Fixed Bug with livehelp_operator_history being over-run with action='Started Chatting' OR action='Stopped Chatting' entries + Fixed PHP Fatal error: Call to a member function fetchRow() on a non-object in gc.php on line 357 ( called only 1 in 100 calls to gc ) FILES CHANGED: ------------------------------------------------------------------ iphone/*, gc.php, setup.php, operators_history.php, admin_chat_bot.php DATABASE ALTERATIONS: ------------------------------------------------------------------ Version 3.0.9: (Released: February 3, 2011 ) -================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - MOBILE RELEASE OF 3.0.8 ----------------------------------------------------------------~- Version 3.0.8: (Released: February 3, 2011 ) ==================================================================+ Fixed PHP Fatal error: Call to a member function fetchRow() on a non-object in gc.php on line 357 + Fixed Bug with livehelp_operator_history being over-run with action='Started Chatting' OR action='Stopped Chatting' entries + Fixed Bug with the characters of : + = & # not being translated and showing as *plus* *equal* newline *amp* in the text of the chat. + Fixed Bug with date() function causing warning with PHP 5 + Added setting in master settings to set the sequence of chat colors for backgrounds of channels as well as chat colors. + fixed issue with the sound playing when a chat request comes in stopping the operator from being able to chat. + made typing preview window 300 pixels in width rather then 400 to get rid of horizontal scroll bar in external chat window. + Added Option to send an auto invite based on operator that is online. This now allows you to create separate layer invites custom to the operator that is online and have that invite only show when they are online. + fixed bug with changing auto invite from pop up to layer. + Added Departments to Keywords and Referers so that they are tracked by department. + Added config option for top and left pixels to fload the layer invite message to + Added config option for amount of time to stay online when not fully active for mobile and web program. you can now log in using the mobile app then close the browser and wait up to 8 hours before your auto logged out from no activity. FILES CHANGED: ------------------------------------------------------------------ ALL OF THEM!! DATABASE ALTERATIONS: ------------------------------------------------------------------ ALTER TABLE `livehelp_config` ADD `chatcolors` text NULL; ALTER TABLE `livehelp_config` ADD `floatxy` VARCHAR( 42 ) NOT NULL DEFAULT '200|160' ALTER TABLE `livehelp_config` ADD `sessiontimeout` INT( 8 ) NOT NULL DEFAULT '60' ALTER TABLE `livehelp_autoinvite` ADD `user_id` int(10) DEFAULT '0' NOT NULL ALTER TABLE `livehelp_autoinvite` ADD `socialpane` CHAR( 1 ) DEFAULT 'N' NOT NULL ALTER TABLE `livehelp_autoinvite` ADD `excludemobile` CHAR( 1 ) DEFAULT 'N' NOT NULL ALTER TABLE `livehelp_autoinvite` ADD `onlymobile` CHAR( 1 ) DEFAULT 'N' NOT NULL ALTER TABLE `livehelp_users` ADD `firstdepartment` INT( 11 ) DEFAULT '0' NOT NULL ALTER TABLE `livehelp_keywords_daily` ADD `department` INT( 11 ) DEFAULT '0' NOT NULL , ADD INDEX ( `department` ) ALTER TABLE `livehelp_keywords_monthly` ADD `department` INT( 11 ) DEFAULT '0' NOT NULL , ADD INDEX ( `department` ) ALTER TABLE `livehelp_referers_daily` ADD `department` INT( 11 ) DEFAULT '0' NOT NULL , ADD INDEX ( `department` ) ALTER TABLE `livehelp_referers_monthly` ADD `department` INT( 11 ) DEFAULT '0' NOT NULL , ADD INDEX ( `department` ) ALTER TABLE `livehelp_visits_daily` ADD `department` INT( 11 ) DEFAULT '0' NOT NULL , ADD INDEX ( `department` ) ALTER TABLE `livehelp_visits_monthly` ADD `department` INT( 11 ) DEFAULT '0' NOT NULL , ADD INDEX ( `department` ) Version 3.0.7: (Released: January 13, 2011 1-13-11 ) -================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - MOBILE RELEASE OF 3.0.6 ----------------------------------------------------------------~- Version 3.0.6: (Released: January 13, 2011 1-13-11) ================================================================== + Fixed issue with missing template variables for choose department + Fixed issue with missing template variables for q & a page. + Fixed issue with missing cellphone notification e-mail for mobile version + Fixed template colors and chat backgrounds have set colors now. FILES CHANGED: ------------------------------------------------------------------ wentaway.php,user_connect.php,user_qa.php, choosedepartment.php, wentaway.php, livehelp.php, setup.php but best upload ALL FILES.. EXCEPT config.php DATABASE ALTERATIONS: ------------------------------------------------------------------ none. Version 3.0.5: (Released: January 11, 2011 1-11-11 ) 11:11pm HST-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - MOBILE RELEASE OF 3.0.4 ------------------------------------------------------------------ Version 3.0.4: (Released: January 11, 2011 1-11-11) 11:11pm HST================================================================== + First STABLE release of the 3.x.x version.. updated all links to show this as stable.. + changed default theme to "classic" for upgrades "vanilla" for new installs to make upgrade easy.. FILES CHANGED: ------------------------------------------------------------------ ALL FILES.. best upload everything except config.php DATABASE ALTERATIONS: ------------------------------------------------------------------ none. Version 3.0.3: (Released: January 4, 2011 1-4-11 ) **! BETA RELEASE !**-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - MOBILE RELEASE OF 3.0.2 Version 3.0.2: (Released: January 4, 2011 1-4-11) **! BETA RELEASE !**================================================================== + changed default theme to "vanilla" and default to not show operator image in template to make upgrades from 2.x.x more closer in looks.. added link to template library. + Fixed bug with Wrong Datatypes in /mobile/xmlhttp.php + Added theme-options.php file to themes to set defualt pop-up window size as well as the default colors of the background of the chat window. + made it mode clear in operator edit on having operator image as part of the template of as included in the chat text. + Added color options for themes such as background color and header color changable in department settings FILES CHANGED: ------------------------------------------------------------------ livehelp_js.php, livehelp.php, /mobile/xmlhttp.php, setup.php. themes/*/windowsize.php DATABASE ALTERATIONS: ------------------------------------------------------------------ none. Version 3.0.1: (Released: November 9, 2010) **! BETA RELEASE !**-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - MOBILE RELEASE OF 3.0.0 Version 3.0.0: (Released: November 9, 2010) **! BETA RELEASE !**-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - FIXED bug with setting the window size of the chat window. - removed frameset structure of chat window and replaced with iframes and DIVS . Added different skin options for the chat window are now possible. the "Tabs" from the 2.x.x. releases are not not used. - added option to have operator image in chat window template. - added mobile variables to database but version 3.0.1 has the mobile features.. you can download it at: http://www.salessyntax.net/mobile.php FILES CHANGED: ------------------------------------------------------------------ user_questions.php, functions.php, xmlhttp.php, wentaway.php, visitor_common.php, admin_connect.php, operators.php, style.php, admin_users_refresh.php, user_connect.php leavemessage.php, department_function.php, livehelp.php, setup.php, livehelp_js.php, user_bot.php , themes/* DATABASE ALTERATIONS: ------------------------------------------------------------------ ALTER TABLE `livehelp_config` ADD `showoperator` CHAR( 1 ) NOT NULL DEFAULT 'Y' ALTER TABLE `livehelp_config` ADD `theme` VARCHAR( 42 ) NOT NULL DEFAULT 'bubble_window' ALTER TABLE `livehelp_departments` ADD `theme` VARCHAR( 45 ) NOT NULL DEFAULT 'bubble_window' ALTER TABLE `livehelp_users` ADD `useimage` CHAR( 1 ) NOT NULL DEFAULT 'N' ALTER TABLE `livehelp_users` ADD `cellphone` VARCHAR( 255 ) NOT NULL DEFAULT '' ALTER TABLE `livehelp_users` ADD `ismobile` BIGINT(14) DEFAULT '0' ALTER TABLE `livehelp_users` ADD `lastcalled` bigint(14) NOT NULL default '0' ALTER TABLE `livehelp_users` ADD `cell_invite` CHAR(1) NOT NULL DEFAULT 'N' Version 2.16.8: (Released: November 20, 2009)================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - FIXED issue with google Chrome dropping chat sessions if the customer does not type anything for 3 minutes. - FIXED error reporting such as date() function warnings etc by setting error reporting to "error_reporting(0);" - Added option to Log out on the chat screen on admin. - added "shadowed" list of chatters/clients for operators that transfer chats to other operators not in the same department and remain chatting to that client. - Updated auto-login using "member services" link to auto log operator into cslh.com support forms and member services. FILES CHANGED: ------------------------------------------------------------------------- setup.php, admin_users_refresh.php, admin_actions.php, functions.php security.php, xmlhttp.php, admin_chat_bot.php, livehelp_js.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- none. but BE SURE you have the database changs from version 2.16.4 ! Version 2.16.7: (Released: November 18, 2009)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - FIXED bug in transfering clients to different departments not refreshing and changing the departement.. - FIXED bug with operators that are not in the same department as eachother being able to see and chat with eachother.. FILES CHANGED: ------------------------------------------------------------------------- setup.php, admin_users_refresh.php, admin_actions.php, functions.php xmlhttp.php, DATABASE ALTERATIONS: -------------------------------------------------------------------------- none. but BE SURE you have the database changs from version 2.16.4 ! Version 2.16.6: (Released: November 11, 2009)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - FIXED endless reload bug with the list of users frame getting stuck with reload requests from the bottom frame... - Aligned top the powered by logo for the end session page. - added some help links. - added new layer invite. FILES CHANGED: ------------------------------------------------------------------------- setup.php, functions.php, admin_common.php, xmlhttp.php visitor_common.php, security_functions.php, helpwindow.php admin_users_refresh.php, login.php, admin_chat_bot.php, admin_image.php, admin_users_xmlhttp.php ( it is a better idea to just upload all the files except config.php ) DATABASE ALTERATIONS: -------------------------------------------------------------------------- none. but BE SURE you have the database changs from version 2.16.4 ! Version 2.16.5: (Released: November 10, 2009)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - FIXED Google Chrome bug!!!! fixed issue with Google Chrome not working on the operators side of the chat. - Changed the way the chatting tabs refreshed from being controled at the list of users frame to the admin chat frame.. It now runs a LOT smoother on showing/hiding chat tabs. - Added option to RE-invite a visitor who has closed or stopped a chat session. - FIXED issue with if a second chat request comes in the tab is not selected by default. ( The double tab frame refresh problem ) - Added option to Hide visior sessions in Ajax mode.. - For some really strange reason some characers such as "£" would get incoded as "£" added a replace to remove any Acirc that is before an idenitiy - FIXED issue with servers that do not allow the specification of sessionid name not showing the chat text on the clients side of the chat.. FILES CHANGED: ------------------------------------------------------------------------- setup.php, gc.php, functions.php, admin_common.php, xmlhttp.php visitor_common.php, security_functions.php, helpwindow.php admin_users_refresh.php, login.php, admin_chat_bot.php, admin_image.php, admin_users_xmlhttp.php, DATABASE ALTERATIONS: -------------------------------------------------------------------------- none. but BE SURE you have the database changs from version 2.16.4 ! Version 2.16.4: (Released: November 7, 2009)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Added a lot more color/background customization options in the departments settings pages. Operators can now change the color, backrounds and style of both the top, bottom and chat frames. - The layer invite now floats in faster.. it also will keep floating into the visitors side if the visitor browses to a new page. - FILES CHANGED: ------------------------------------------------------------------------- setup.php, livehelp_js.php, image.php, colorchange.php, departments.php department_function.php, user_top.php, user_bot.php , user_chat_zmlhttp.php, user_questions.php, user_connect.php, leavemessage.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- ALTER TABLE `livehelp_departments` ADD `botbackground` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `topbackground` ALTER TABLE `livehelp_departments` ADD `midbackground` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `topbackground` ALTER TABLE `livehelp_departments` ADD `topbackcolor` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `midbackground` ALTER TABLE `livehelp_departments` ADD `midbackcolor` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `midbackground` ALTER TABLE `livehelp_departments` ADD `botbackcolor` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `midbackcolor` Version 2.16.3: (Released: October 28, 2009)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - The layer invite now slides into view rather then just appearing out of the blue.. - Fixed hopfully forever the issue with browser_info.php file giving errors. ALSO FIXED THE ISSUE WITH browser_info.php showing the UA of the operator not the visitor - shortent the timeout time to end chat sessions from 5 minutes to 2 minutes and 30 seconds.. if a chatter closes the chat window and goes away the chat now disapears in 2 minutes and 30 seconds from the operators side rather then 5 minutes... - changed the default values of busy message due to mode security not liking "20%" - changed default of chat to AJAX instead of "auto" since "auto" sometimes has problems in google crome. - added option to skip the "busy message" and send the chater directly to leave a message if no operator answers the chat by the timeout time.. - Fixed issue with cocurrent messages sent at the exact same time by both client and visitor sometimes not showing. FILES CHANGED: ------------------------------------------------------------------------- setup.php, user_bot.php, functions.php, admin_chat_bot.php, external_bot.php, gc.php, department_function.php, offline.php livehelp_js.php, xmlhttp.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- none Version 2.16.2: (Released: October 21, 2009)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - fixed php 5.3.0+ issue with split() function not being DEPRECATED changed all of them to explode() FILES CHANGED: ------------------------------------------------------------------------- setup.php, external_bot.php, functions.php, image.php, invite.php, layer.php, leavemessage.php, xmlhttp.php, admin_actions.php, admin_chat_bot.php, admin_image.php, admin_users_refresh.php, admin_users_xmlhttp.php, client_visitors.php, data_clean.php data_keywords.php, data_messages.php, data_paths.php, data_referers.php data_transcripts.php, data_users.php, data_users.php, data_visits.php edit_quick.php, edit_smile.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- none Version 2.16.1: (Released: October 19, 2009)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Fixed error with php version 4 and the class/browser_info.php as well as extra space at the end of the file that sometimes caused errors. - added option in settings to not use cookies for paranoid people. - added navigation option for fire fox add-on - updated client_visitors.php to version 2.5.2 - added - added optional typing sound when the customer (chatter) hits the sent button after typing FILES CHANGED: ------------------------------------------------------------------------- setup.php, mastersettings.php, navigation.php , class/browser_info.php client_visitors.php, admin_chat_xmlhttp.php, external_top.php , external_bot.php, external_chat_xmlhttp.php, external_frameset.php, typing.wav, admin_rooms.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- ALTER TABLE `livehelp_config` ADD `usecookies` CHAR( 1 ) NOT NULL DEFAULT 'Y' ALTER TABLE `livehelp_users` ADD `typing_alert` CHAR( 1 ) NOT NULL DEFAULT 'N'; Version 2.16.0: (Released: October 8, 2009)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - fixed issue with tabs on top of the users chat not selecting correctly. - tabs are now default off (deprecated feature but still supported in 2.x.x tabs shown on the top users side will not be in version 3.x.x ). - Added smtp_port option to master settings to set port - All passwords are now encripted .. no more plain text passwords - replaced browser info script with php 5.3.0+ version. - fixed php 5.3.0+ issue with ereg errors.. replaced with preg OMG there was a lot of them to change!! - FIXED issue with $_REQUEST array causing the chat not to work for clients side of the chat if cookie vars contain vars that mod_security does not like. - added new feature of easy changable header images.. also added cleaner default one. - New administrative interface which has a simplier admin and contains our offical logo. - New Member services section FILES CHANGED: ------------------------------------------------------------------------- EVERY FILE.. best upload the whole thing .. except config.php !! DATABASE ALTERATIONS: -------------------------------------------------------------------------- ALTER TABLE livehelp_modules_dep ADD isactive char(1) NOT NULL default 'N' UPDATE livehelp_departments set colorscheme='default' ALTER TABLE `livehelp_config` ADD `topframeheight` INT( 8 ) NOT NULL ,ADD `topbackground` VARCHAR( 156 ) NOT NULL UPDATE livehelp_user SET password=md5(password) Version 2.15.0: (Released: August 20, 2008)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Fixed SQL injection vulnerability (thanks to GulfTech Security Research) - Fixed Cross Site Scripting vulnerabilty with "department" in livehelp_js.php (see http://secunia.com/advisories/31340/ ) - Removed hard coded width 142px from generated HTML section.. - updated spanish lang file to use charset "ISO-8859-1" - Fixed issue with operator channels sometimes getting crossed with multiple operators are chatting (3+) - Fixed issue with being able to re-name operators. - Fixed issues noted by "exdiogene" : a) ablity to login with URI instead of filling the login form b) Problems with the international characters not properly displayed. c) Added Charset to operator settings to allow different charsets for operators. (Use new Charset type dropmenu in list of users online) d) Added more language conversions for users list in admin. - "Live help only" users can no longer change monitor settings. - Fixed Issue with messages that are sent at the exact same second as another person being lost in the chat and not shown. - Added option to transfer a user to an Operator rather then to a department. - Updated the admin list of users and chaters to have the option of - using ajax rather then refreshing. New Ajax users list type dropmenu FILES CHANGED: ------------------------------------------------------------------------- admin_users_refresh.php, xmlhttp.php, admin_users_xmlhttp.php, user_chat_xmlhttp.php, admin_chat_xmlhttp.php, admin_chat_bot.php admin_actions.php, functions.php, admin_image.php, htmltags.php, is_xmlhttp.php, autoinvite.php, helpwindow.php, live.php, admin_common.php, config_cslh.php, setup.php, mastersettings.php, security_functions.php, is_flush.php, livehelp_js.php, admin_users.php lang/lang-*.php files DATABASE ALTERATIONS: -------------------------------------------------------------------------- none Version 2.14.6: (Released: March 1, 2008)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Fixed Minor Cross Site Scripting vulnerabilties in livehelp.php, user_questions.php, lostsheep.php, and leavemessage.php - Added scrolling to department choice page. - added ability to re-name visitor ip addreses from admin. - when listing transcripts it now defaults to showing all deparments unless the user looking at the transcripts does not have access to all transcripts. - Updated online Docs FILES CHANGED: ------------------------------------------------------------------------- livehelp.php, setup.php, leavemesssage.php, livehelp_js.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- none Version 2.14.5: (Released: September 1, 2007)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ another minor release to fix some small details of the 2.14.x release series .. - Fixed Issue with broken tab graphics on tabs with long names. had a bit of e-mail reuarding this issue.. it is fixed now sorry it took so long.. - Fixed Issue with time sometimes being very large such as: Duration: 48693 hrs 38 min 26 sec - Added click highlighting to the html code.. and changed it from a image link to a text link.. FILES CHANGED: ------------------------------------------------------------------------- setup.php, htmltags.php, livehelp_js.php, user_top.php, functions.php images/*/left-tab.gif,images/*/right-tab.gif, images/*/left-tab-on.gif,images/*/right-tab-on.gif, functions.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- none Version 2.14.4: (Released: July 1, 2007)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ minor release to fix some small details of the new 2.14.x release series .. it is all good now :-) - fixed "whatissaid" javascript issue. - Added try catch javascript for xmlhttp requests result .innerlayer calls this fixs the IE issue of sometimes saying "null is not an object" FILES CHANGED: ------------------------------------------------------------------------- setup.php, mastersettings.php, user_chat_refresh.php, external_chat_xmlhttp.php, admin_connect.php, admin_chat_xmlhttp.php, user_chat_xmlhttp.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- ALTER TABLE `livehelp_config` ADD `smtp_portnum` int( 10 ) NOT NULL default '25' Version 2.14.3: (Released: June 14, 2007)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Upgraded the LC2 server file to version 2.5 - Fixed wrong navigation.css files in white,yellow and brown designs - Added Close mysql connection to the close of the session to try to avoid many sleeping mysql connections. - Fixed tabs in the data section to match color scheme. - Added htmlspecialchars to all textarea fields to avoid html conflicts FILES CHANGED: ------------------------------------------------------------------------- user_questions.php, user_chat_refresh.php, external_chat_xmlhttp.php, admin_connect.php, admin_chat_xmlhttp.php, admin_chat_refresh.php, admin_chat_flush.php, user_chat_flush.php, client_visitors.php, setup.php, user_questions.php, department_functions.php Version 2.14.2: (Released: June 12, 2007)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Updated the CSS of the tabs so that they are a lot easier to custom change the design of. now you only need to change 4 images rather then 12. - Added charset encoding to the xmlhttp request response which should solve the unknown character problem !! - Fixed mod_security issue with leaveamessage.php - Changed all the lang files from utf-8 to native lang charsets if you have trouble with encoding change charset in the lang/lang-[yourlanguage].php file. - Added ability to use external SMTP server to send e-mail using smtp host, username and password. FILES CHANGED: ------------------------------------------------------------------------- xmlhttp.php, user_chat_xmlhttp.php, admin_chat_xmlhttp.php, admin_options.php, user_top.php, functions.php, navigation.php, admin_rooms.php, setup.php, lang/lang-*.php files (a lot of images in images/* were changed too) DATABASE ALTERATIONS: -------------------------------------------------------------------------- ALTER TABLE `livehelp_config` ADD `smtp_host` VARCHAR( 255 ) NOT NULL default ''ALTER TABLE `livehelp_config` ADD `smtp_username` VARCHAR( 60 ) NOT NULL default ''ALTER TABLE `livehelp_config` ADD `smtp_password` VARCHAR( 60 ) NOT NULL default ''ALTER TABLE `livehelp_config` ADD `owner_email` VARCHAR( 255 ) NOT NULL default '' Version 2.14.1: (Released: June 6, 2007)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Sessions are now stored in the database rather then using the session file. - Fixed issue with No chat icon showing when NO auto invites are set to active.. - Fixed issue with missing attribute of type="text/javascript" for users side of chat which caused problems in some version of IE (sometimes??) - Sessions are now enabled by defualt now on chat icon.. This should help with the "0 page visit" and [ip address]_1 _2 people... - added some more try and catch statments to ajax calls in chat to avoid javascript errors during chat due to unloaded divs.. - re-programmed the xmlhttp request to not use the @if (@_jscript_version >= 5) conditional and it now just uses try catch which solves some of the IE 6 errors. FILES CHANGED: ------------------------------------------------------------------------- All of them changed. DATABASE ALTERATIONS: -------------------------------------------------------------------------- CREATE TABLE `livehelp_sessions` ( `session_id` varchar(100) NOT NULL default '', `session_data` text NOT NULL, `expires` int(11) NOT NULL default '0', PRIMARY KEY (`session_id`) ) TYPE=MyISAM; Version 2.14.0: (Released: May 22, 2007)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Fixed Mac Browser "white space line" issue and auto invite not working for Safari browsers. - Fixed missing "view" array element in language files. - Fixed problem with default value for text and blob fields preventing install on newer mysql versions. - Fixed upgrade issue with auto-increment field {the get_identity() error} - Fixed valign on q&a mod so that the question folders are aligned to the top.. - The scratch space now does NOT allow html characters to prevent operators from causing havic - Fixed "keep getting logged out" error by deprecating match ip to session feature and deprecating option not to use sessions.. - deprecated flush() and refresh default chat modes... They still exist in the installation but are only used if AJAX fails which because of browsers these days that is doubtful.. This Fixes some users "white screen" chat problems and users shooting selfs in foot. FILES CHANGED: ------------------------------------------------------------------------- All of them changed... but most important is mastersettings.php, navigation.php, qa.php, user_qa.php, livehelp.php and lang-swedish.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- None ... Version 2.13.1: (Released: November 27, 2006)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Fixed javascript error with script tag which was preventing the chat from working in Internet Explorer 7.0 - Fixed auto invite for none-department generated code. - Fixed undefined variable in hide/show departments. FILES CHANGED: ------------------------------------------------------------------------- is_xmlhttp.php, setup.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- None. Version 2.13.0: (Released: November 15, 2006)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Added a basic chat request queue system by adding a new section in the list of users called "Chat Requests" with list of chat requests waiting for an operator with time of the request listed next to the user. - Re-arranged " Chatting Users" section to be ordered by operator and then list which chats that operator is currently involved in below their operator name. - Updated Operator History page to show Total time monitoring traffic, total time logged in and total time chatting. - Added links in Operator history page to transcripts of the chats - Added option to re-name ipaddress usernames for active chat sessions where no questions are asked before the chat. - updated "chat colors" window to show the usernames of the chatters with the color of their text. - Fixed Bug with non-department generated code always showing live help as offline. - Fixed Issue with mod_security and requests with the string "http://" or "https://" inside the querystring for page and referer values. - Fixed max int issue with incrementing timestamp value by one.. - Fixed issue with the usernames for operators being changed to operatorname_1 , operatorname_2 , using the windows client - Fixed paging issue with department transcripts (bug #1589448 ) FILES CHANGED: ------------------------------------------------------------------------- admin_users_refresh.php, user_questions.php, user_connect.php, user_chat_flush.php, livehelp.php, gc.php , logout.php, navigation.php, livehelp_js.php, data_transcripts.php, functions.php, visitor_common.php, operators_history.php, images.php , admin_chat_bot.php, admin_actions.php, setup.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- None. Version 2.12.9: (Released: May 1, 2006)-================================================================== CHANGE OVERVIEW: ------------------------------------------------------------------ - Fixed Insecure smilies when using HTTPS mode for chat. - Removed "|" character from transfered title and referer pages as it seemed to cause some servers not to show the online/offline image.. - Generated HTML code (non-javascript) now opens in a new window. - fixed bug with commas in converted urls - added fix for mod_security with questions marks in query string. - Added option to hide selected departments from department listing page. - Fixed bug with closed session page always showing the default departments header. - increase default wait time for time out from 1 minute to 5 minutes. - Fixed Extra space that appears at the bottom of image when no "powered by" image is selected. - Added additional support for Windows application via client_visitors.php - Added links to new Windows App and New Support Packages in overview index. - Limited the sizes of the title, referer and url in the javascript query to live help to fix problem with long SEO title tags overflowing the page request. FILES CHANGED: ------------------------------------------------------------------------- navigation.php, livehelp_js.php, setup.php, wentaway.php, choosedepartment.php, departments.php, visitor_common.php, image.php, user_bot.php, functions.php, external_bot.php, admin_chat_bot.php, htmltags.php, client_visitors.php , gc.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- ALTER TABLE `livehelp_departments` ADD `visible` INT( 1 ) DEFAULT '1' NOT NULL ; Version 2.12.8: (Released: February 28, 2006)=================================================================== CHANGE OVERVIEW: ---------------------------------------------------------------------- - Added ability to Track PATH a visitors have taken on site. You can now track where people go from any selected page and what percentage of the traffic goes to that page. - Added ability to invite based on time online - Added options in Department settings to enable or disable smilies for visitors window. - Admin now defaults to use PHP sessions rather then cookies. Helps with some users not being able to log in. - Re-named "XML HTTP" to "AJAX" .. seems this has become the buzz word for XML HTTP requests.. It is the same thing I have been doing for 3 years just named different these days. - Added Fix for https secure operator chats giving secure/insecure notice errors when logging in. - Canned messages are now appended to currently typed text rather then replacing the text. - Fixed spacing issues with answers to questions on beinging of chat. - Added support for special norwegian letters for xml http requests. - fixed some small spelling errors.. - fixed issue with $ signs in the password... - added langage file for Portuguese_Portugal - fixed javascript error with undefined object. - Added option to filter query string requsts for modsecurity.. Also title, referer and page name are all filtered for non-printable chars. - added more filters for email headers to avoid spam attacks. - Added notices on tracking referers and page visits from generate html page. FILES CHANGED: ------------------------------------------------------------------------- department_function.php, setup.php, departments.php, user_bot.php, mastersettings.php, data_visits.php, htmltags.php, data_paths.php, data_clean.php, admin_users_refresh.php, functions.php, livehelp_js.php, data.php, visitor_common.php, user_questions.php, security_functions.php, lostsheep.php, leavemessage.php,user_chat_xmlhttp.php, admin_chat_xmlhttp.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- CREATE TABLE `livehelp_paths_firsts` ( `id` int(11) unsigned NOT NULL auto_increment, `visit_recno` int(11) unsigned NOT NULL default '0', `exit_recno` int(11) unsigned NOT NULL default '0', `dateof` int(8) NOT NULL default '0', `visits` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `visit_recno` (`visit_recno`,`dateof`,`visits`)) TYPE=MyISAM AUTO_INCREMENT=1 ;CREATE TABLE `livehelp_paths_monthly` ( `id` int(11) unsigned NOT NULL auto_increment, `visit_recno` int(11) unsigned NOT NULL default '0', `exit_recno` int(11) unsigned NOT NULL default '0', `dateof` int(8) NOT NULL default '0', `visits` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `visit_recno` (`visit_recno`,`dateof`,`visits`)) TYPE=MyISAM AUTO_INCREMENT=1 ;ALTER TABLE `livehelp_departments` ADD `smiles` CHAR( 1 ) NOT NULL DEFAULT 'Y'; Version 2.12.7: (Released: December 2, 2005)============================================================================ CHANGE OVERVIEW: --------------------------------------------------------------------------- - Added check to prevent/remove duplicate sessions with same sessionID. - Fixed undefined notices in data_messages. - charset bug with having UTF-8 (I guess I can not win) seems to work for me now. - added missing html tag for charset on admin_chat_bot.php and external_bot.php FILES CHANGED: ------------------------------------------------------------------------- setup.php, functions.php, data_messages.php, lang/lang-*.php, admin_chat_bot.php and external_bot.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- No database alterations. Version 2.12.6: (Released: November 16, 2005)============================================================================ CHANGE OVERVIEW: --------------------------------------------------------------------------- - Fixed minor HTML Insertion problem with users Questions - Fixed another charset bug with typing preview not showing correctly for characters like " å ä ö " etc... and jsut showing " ? ? ? " Also changed default encoding to UTF-8 - Fixed extra slash in the path to the live help online image and leave a message image. - When Hide icon when not online is enabled there is no longer the 2X6 transparent gif showing.. nothing appears. - Added option to not focus for external chat windows. - Count of current visitors online is now increased to the count of visitors active in the past 4 minutes rather then last 2 minutes. - Charset on copyright fixed. FILES CHANGED: ------------------------------------------------------------------------- almost all the files had changes in this release... it would be best to replace all files. DATABASE ALTERATIONS: -------------------------------------------------------------------------- No database alterations. Version 2.12.5: (Released: September 30, 2005)============================================================================ CHANGE OVERVIEW: --------------------------------------------------------------------------- - Fixed charset bug with typing preview not showing correctly for some languages (was showing encoded chars like %02%0s etc..) - Fixed bug where if non-department specific code is generated the javascript icon was sometimes showing offline rather then online due to program picking status of the operators from the default department rather then any department. - Fixed issue with sound alert playing multiple times when more then one visitors shows up or more then one chat request was made at the same time. - Added ability for operators with non-admin access to change their own password/details. - Removed unneeded javascript from Dynamic Dyo libraries. - Update all translation files - Added 2 new layer invites - Fixed 2 images on brown color template that were incorrect. - Expanded the layer invite size to allow bigger layer images to be used. It was clipping them before. - Type of view was not being passed for the paging links for data referers this is fixed. - When a new department is created all users with admin access are now auto added to that department. - Added ability for visitor to be notified that the operator is currently typing text WITHOUT the full text preview option. - added number of hidden visitors for operators to see number of visitors outside their own department that are online. - Limited permissions so that Operators can only view transcripts and messages of the Departments that they belong to in the data tab. - Fixed bug with new departments being created without a e-mail box but having e-mail required.. also fixed SQL error on auto creating e-mail if e-mail functions are enabled but no e-mail field exists. - Added "Restricted" and "Live Help Only" access option for operators who should only see "live help" and "data" (which is "Restricted") or only see the Live Help tab and nothing else which is "Live Help only" - fixed image type error in functions.php for non-gif images. FILES CHANGED: -------------------------------------------------------------------------- lang/lang-*.php, functions.php, modules.php, navigation.php, admin_options.php, departments.php, operators.php, login.php, scratch.php, data.php, admin_common.php, leavemessage.php, livehelp_js.php, department_function.php, data_transcripts.php, csv.php, data_messages.php, external_bot.php, admin_chat_bot.php admin_users_refresh.php, external_chat_xmlhttp.php, image.php, setup.php, user_chat_xmlhttp.php, admin_chat_xmlhttp.php, visitor_common.php, user_bot.php , xmlhttp.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- ALTER TABLE `livehelp_users` CHANGE `showtype` `showtype` INT( 10 ) DEFAULT '1' NOT NULL Version 2.12.4: (Released: August 27, 2005)============================================================================ CHANGE OVERVIEW: -------------------------------------------------------------------------- - Updated setup to auto detect old version and upgrade easy without re-inputting anything. (See UPGRADE.txt ) - Updated Translations for : Spanish, French, Portuguese Brazilian, German, Italian, and Swedish. - Fixed issue with Path slashes being the wrong way for WINDOWS hosted users this caused layer invites, smilies, and languages to not work on windows servers. - removed name from "From:" header in leaveamessage which was causing some IIS servers to hickup. - If no department is specified all operators can now see the visitor. - Changed choose a department page to have online/offline "lights" layout - Fixed issue with loosing session ID if using PHP version 4.1.0 or earlier. - Added top header graphics to session closed and choose department pages. - Added Ability to order the listing of departments on the choose a department page. - Fixed Ability to send invites based on page currently visiting. - Added ability to collapse list of chatters the same way as visitors. FILES CHANGED: -------------------------------------------------------------------------- lang/lang-Spanish.php , lang/lang-French.php ,lang/lang-Portuguese_Brazilian.php , lang/lang-German.php ,lang/lang-Swedish.php , functions.php, choosedepartment.php, leaveamessage.php, setup.php, config_cslh.php smile.php, admin_common.php, autoinvite.php, edit_layer.php, edit_smile.php layer.php, mastersettings.php, departments.php , department_function.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- ALTER TABLE `livehelp_departments` ADD `ordering` INT( 5 ) UNSIGNED DEFAULT '0' NOT NULL Version 2.12.3: (Released: August 7, 2005)============================================================================ CHANGE OVERVIEW: --------------------------------------------------------------------------- - Fixed XML HTTP to not use POST requests for older browsers( caused white screens or non-responsive chats for users using old browsers including Netscape 6 and some AOL browsers. XHTML now uses GET requests rather then POST requests. - Fixed bug with updating existing image maps and having them update in the database. - Fixed bug with French Language file which stopped chat from working. - Fixed some updefined indexes in the keyword archiving function. - If not sending messages by e-mail on the leave a messages option you can now not require the e-mail field. - Updated the way that sound was embeded for alerting of chats to use bgsound if Ie or opera - changed the Interval to 2 seconds rather then 3 seconds for update requests in the chat. FILES CHANGED: -------------------------------------------------------------------------- external_frameset.php, functions.php, external_chat_xmlhttp.php admin_chat_xmlhttp.php, user_chat_xmlhttp.php, setup.php leavemessage.php, login.php, image.php, edit_layer.php, admin_users_refresh.php, javascript/xmlhttp.js DATABASE ALTERATIONS: -------------------------------------------------------------------------- No database alterations. Version 2.12.2: (Released: July 10, 2005)============================================================================ CHANGE OVERVIEW: -------------------------------------------------------------------------- - Fixed bug where if a user has two different pages open monitored by Sales Syntax the page visits no longer get into a loop between the two different pages opened. - The clear screen icon on client side of chat now works :-) - small issue with animated arrows on admin navigation is fixed. - Updated default values on installation to have '0' rather then now() for bigint fields in livehelp_users which solves some mysql installation issues. - Fixed issue with cut off username php field in advanced options. - Fixed bug with [+] sign on the data tabs not working for earlier months - Erase transcripts via clean-up tab now works. - Referer and Page visit tracking is default 'N' (Off) in setup.php - Updated Language files to include more text - The number of pings was off by a factor of 2 so pinging the visitor was being done twice as long then set. This is fixed. FILES CHANGED: --------------------------------------------------------------------------data_functions.php , data_clean.php , navigation.php , data_messages.phpdata_referers.php , data_users.php , data_transcripts.php , image.phpdata_visits.php , gc.php , livehelp_js.php , htmltags.php setup.php DATABASE ALTERATIONS: -------------------------------------------------------------------------- Added a index on page in livehelp_visit_track and In the installation livehelp_users fields lastaction and chataction havebeen changed to default '0' rather then default now() this I believe onlychanges new installations as old installs seem to have auto turned the now()into 0. Also changed the defaults for tracking, reftracking, and keywordtrack to 'N' :ALTER TABLE `livehelp_visit_track` ADD INDEX ( `page` ) lastaction BIGINT(14) DEFAULT '0' chataction BIGINT(14) DEFAULT '0' `tracking` char(1) NOT NULL default 'N', `reftracking` char(1) NOT NULL default 'N', `keywordtrack` char(1) NOT NULL default 'N', Version 2.12.1: (Released: June 22, 2005)============================================================================ CHANGE OVERVIEW: -------------------------------------------------------------------------- - Fixed a SQL problem with the keyword tracking sql queries. For a quick fix to version 2.12.0 find line #1434 in functions.php and change it from: $keywords = str_replace("'","",$keywords); to $keywords = filter_sql(str_replace("'","",$keywords)); - converted a few short hand php tags "close_connection() - one too many parameters in identiy() function call which was causing Windows servers to not know the function identity() - repeating auto invite message fixed. UPDATES: - auto-invite messages sent to the client are now cleared before chat session begins. - Added resource limits for number of times to ping visitor to save resources. - added options in code generation to control pinging, php sessions and using hostip sessions. version 2.9.4: (Released: 11-08-04)====================================== BUG FIXES: - Undefined variable in operators.php when creating a new operator is fixed. - If a chat session is stopped using the new checkbox method the channels were not deleted.. this is fixed. - fixed issue with refresh mode not showing the connecting page. - If the department was set to not ask questions upon the chat request the user was just getting the connecting page. this is fixed. - In the page visit foot prints the first page visited was being counted twice this is fixed. - fixed bug with when creating a new department the module selections and ordering not getting saved. UPDATES: - Changed the way the continous mode refreshes so that it does not refresh unless it has been inactive for more then 300 seconds. - Removed DHTML image height and width so that the DTHML invite image can be any size - A bunch of minor changes were made such as ip address showing in the auto invite, changing the html code generator to place the code in a textarea rather then html box, too much buffering in the chat pages when nothing is being said, scroll up on chat always scrolling when nothing is being said, etc... FEATURES: - Added Javascript pinging to open chat to tell if the client closes the chat. if a client closes the chat window the operator now knows within a minute that the client has closed the chat box (will shorten the time in a later release) - added ability to add checkboxes to help request and leave a message. - Added German translation. - Added ability to transfer a chat session to another department. version 2.9.3: (Released: 10-28-04)====================================== BUG FIXES: - Fixed javascript error which occured when layer invite was shown and closed and then the visitor clicked on the live help icon. - Separated out the code that displays the messages from the DHTML layer code this helped fix the issue with messages disapearing if a writelayer is deleted at the same time a message is inserted.. - Auto invite messages not marked as Active were being shown to the visitors. this has been fixed so that only active auto invite options are shown. - There was a refresh issue with operators being able to talk to eachother.. This is fixed. - Operators who are not part of a department now no longer see chatters in that department unless they are transfered to their department. - User is Typing messages with the "
" string are now omited. Happens when javascript monitoring sends the text right before it is submitted. - When offline is selected in the chat monitor, the auto invite is now turned off for that user. - Windows timestamp field is different then unix timestamp this caused some installations to have the session close for a chatting user right after it opened. This is fixed. - Livehelp_channels table was not getting cleaned of old channels.. this is fixed.. - If no operator answers a call after the time limit for a call to be ansered is reached the client is not redirected to the offline tab.. this is fixed. - Fixed bug with txt-db-api offset value due to missing default value field 9 in livehelp_questions. UPDATES: - added a frame break on the live help box to avoid double frames.. - the "user is typing" feature now does not show messages typed by self. (the client does not see his/her own typing and you do not see your own typing) - If two operators answer the same call then the second operator gets a message that the call has already been answered and if they would like to join the chat or not. FEATURES: - added chat color to the grayed out tabs of the users who are not chatting. - add option to hide operator typing from clients - Changed "Entered Chat" to Operator greeting defined by operators. - Added ability to and a photo of the operator to the greeting. version 2.9.2: (Released: 10-11-04)================= BUG FIXES: - On the leave a message page the hidden input variable for department was missing this caused departments other then the default department not to work correctly. This is fixed. - Chat messages posted within a second of eachother sometimes were not shown becuase the messages were being shown by timestamp. The messages are now shown by auto id and timestamp to fix this. - sound for the alert of a visitor was not working in version 2.9.1 . it is fixed. FEATURES: - Added Dutch translation. - Fields can be marked as Required in the leave a message module and chat request. version 2.9.1: (Released: 10-06-04)================= BUG FIXES: - On some servers SQL queries could not contain multiple queries in one sql command.. This prevented livehelp_questions from being created and some people not able to install version 2.9.0. This is fixed in this version. - javascript error with moving DHTML layer fixed. - if an operator creates a new user and then logs in as that new user using the same session that they were using before both users used to share the same session. this has been fixed as log as you log out. UPDATES: - Changed default settings in install to include e-mail and message as default for questions and Default to leavemessage.php for default to when offline setting. - Added ability to change the text shown at the top of leave a message page under department settings. - Added Spanish and Portuguese_Brazilian translations. version 2.9.0: (Released: 10-02-04)================= BUG FIXES: - Issue with visitors from same network sharing sessions is fixed. - Fixed bug with monthly totals for the previous month being added to current months total in the referers tables. Also fixed string issue with selecting months on the data pages. - Special HTML characters are now escaped on the operators side unless checkbox to allow HTML is checked. Solves issue with some text "dissapearing" if it happens to - Imagemap in departments settings page is now used. It was hardcoded to the default imagemap before so it did not matter what was entered. - If two javascript live help icons are placed on the same HTML page they used to share the same department id. This is fixed. UPDATES: - Changed connecting image to not look like the user is downloading something. - Solved issue with online/offline image being cached and incorrect status icon to the cached user on some browsers. - Added SessionID to user table to identify the user rather then just using the ip address and hostname. - Code comments and format have been changed to use PHPDocumentor please see: http://www.phpdoc.org/ - converted short hand php tags to long hand.. (close_connect();version 1.5: (Released: 05-02-03)================= - Added Manual installation directions and sql dump of initial database for users who have a hard time running the setup. - changed livehelp.js to use a global webpath var that is easily changed at the top of the file. - Fixed the issue with the text area not getting selected if the window focus is called. - Fixed issue with color staying Red for the users rather then alternating to a new color. - Had to remove the txt-db-api database option until I have a chance to fully de-bug it. - did a little bit of general code cleaning version 1.4: (Released: 05-01-03)================= - Auto focus to textarea box after submitting message - Auto select last person who was sent a message for send to: - Auto Submit send when Return is pressed. - Auto focus chat window when they type something. This way you can minmize the window and so something else while they type. - fixed issue with user end chat not scrolling to absolute bottom of page. - Added a Clear button to clear out the chat screen. - fixed version field type (should be float) in config also fixed upgrade script. version 1.3: (Released: 04-30-03)================= - combined chatting users and current visitors frames into one frame. Tried to use DHTML to now have to re-load the users frame but as it turns out IE does not like to load two frames infinitly at the same time.. WTF.. I have the code there but commented out. - added a field to `livehelp_config` ADD `use_flush ` VARCHAR( 10 ) DEFAULT 'YES' NOT NULL ; - fixed upgrade in setup.php so that older version users can upgrade to new version. - added support for non-flush() servers. Servers that insist on buffering the output until the entire page is loaded... - When you click on log out it marks your status now as offline.. - ================= ================= ================= ================= version 1.2: (Released: 04-28-03)================= - As it turns out The HTTP Authentication hooks in PHP are only available when it is running as an Apache module and is hence not available in the CGI version which was causing internal server error on a few peoples installations. I re-programmed user_access.php to use a cookie login. - get_magic_quotes_gpc is now used instead of get_ini to see if the user has magic quotes on or off and a new extraction is used in config.php to extract the global vars and add slashes. (I like magic quotes) - Added a LOG OUT button to allow operators to close the admin. - took out javascript alert for new user in chat and replaced with java sound wav. - added referer to the details of the user.. I will make it look better in a later version... - Fixed issue with leave a messsage window always poping up if the user was requested for a chat then went away and then came back again when the operator was not around.. - added additional check in setup to make sure users with txt-db-api can write to their text database.================= ================= ================= ================= version 1.1: (Released: 04-27-03)================= - Added installation directions and change log txt files. - Added support for new $_POST $_GET and $_COOKIE that replace the $HTTP_*_VARS in newer versions of php. - Created a new field in livehelp_operator_channels table called "bgcolor" of type varchar (10). This field allows me to color code the users to allow it to be easier to separate the chatting users.. - Fixed bug with the leave a message script where the e-mail from address was not being sent. - Fixed bug with users entering in the same username or name as an already exisiting user. - Fixed issue with the "new user in chat" prompt showing before the user enters their name if ask for name option is selected. - magic quotes for words with apostrophes - If user selects not to have the leave the message option on and no one is online the credit line remained. Took that image out if leave a message is not enabled.================= ================= ================= ================= version 1.0: (Released: 04-21-03)================= - This was the first release of the program everything was new :-)