WordPress.org
Get WordPress

Plugin Directory

Changeset 1103349


Ignore:
Timestamp:
03/02/2015 03:04:30 PM (11 years ago)
Author:
activehelper
Message:
  • Support Domain visitors grouping.
  • Support Country visitors grouping.
  • Support Visitors IP/Hostname filtering.
  • Core Update.
  • Core Security update.
  • Other small improvements and bug fixes.
Location:
activehelper-livehelp
Files:
6 edited

Legend:

Unmodified
Added
Removed

  • activehelper-livehelp/trunk/activehelper-livehelp.php

    r1003856 r1103349  
    77Plugin URI: http://www.activehelper.com
    88Description: 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.8.0
     9Version: 3.9.0
    1010Author: ActiveHelper Inc
    1111Author URI: http://www.activehelper.com
    … …  
    807807                                ' . __('Version : ', 'activehelper_livehelp') . '
    808808                            </td><td class="b">
    809                                 ' . __('3.8.0', 'activehelper_livehelp') . '
     809                                ' . __('3.9.0', 'activehelper_livehelp') . '
    810810                            </td></tr></tbody></table>
    811811                            <table><tbody><tr><td class="first t">

  • activehelper-livehelp/trunk/readme.txt

    r1003856 r1103349  
    33Tags: wordpress livechat,  live chat, live help, live support, customer service, wordpress plugin, livechat plugin, visitor tracking, visitor chat, floating
    44Requires at least: 3.2
    5 Tested up to: 4.0
    6 Stable tag: 3.8.0
     5Tested up to: 4.1.1
     6Stable tag: 3.9.0
    77
    88Powerful Live Chat Plugin for WordPress.
    … …  
    318318* Other small improvements and bug fixes.
    319319
     320= 3.9.0 =
     321* Support Domain visitors grouping.
     322* Support Country visitors grouping.
     323* Support Visitors IP/Hostname filtering.
     324* Core Update.
     325* Core Security update.
     326* Other small improvements and bug fixes.
     327
     328
    320329Upgrade:
    321330Before to make any upgrade of the ActiveHelper LiveHelp Server is necessary to follow a couple steps in order to avoid loss the working configuration:
    … …  
    507516* Core Security update.
    508517* Other small improvements and bug fixes.
     518
     519= 3.9.0 =
     520* Support Domain visitors grouping.
     521* Support Country visitors grouping.
     522* Support Visitors IP/Hostname filtering.
     523* Core Update.
     524* Core Security update.
     525* Other small improvements and bug fixes.

  • activehelper-livehelp/trunk/server/services/login.php

    r1003856 r1103349  
    1919     $_REQUEST['USERNAME'] = '';
    2020  } else $_REQUEST['USERNAME'] = htmlspecialchars( (string) $_REQUEST['USERNAME'], ENT_QUOTES );
     21 
    2122  if (!isset($_REQUEST['PASSWORD']))
    2223  {
    2324     $_REQUEST['PASSWORD'] = '';
    2425  } else $_REQUEST['PASSWORD'] = htmlspecialchars( (string) $_REQUEST['PASSWORD'], ENT_QUOTES );
     26
    2527  if (!isset($_REQUEST['ACCOUNT']))
    2628  {
    2729     $_REQUEST['ACCOUNT'] = '';
    2830  } else $_REQUEST['ACCOUNT'] = htmlspecialchars( (string) $_REQUEST['ACCOUNT'], ENT_QUOTES );
     31
    2932  if (!isset($_REQUEST['SERVER']))
    3033  {
    3134     $_REQUEST['SERVER'] = '';
    3235  } else $_REQUEST['SERVER'] = htmlspecialchars( (string) $_REQUEST['SERVER'], ENT_QUOTES );
     36
    3337  if (!isset($_REQUEST['LANGUAGE']))
    3438  {
    … …  
    3640  } else $_REQUEST['LANGUAGE'] = htmlspecialchars( (string) $_REQUEST['LANGUAGE'], ENT_QUOTES );
    3741
     42// New parameters
     43
     44  if (!isset($_REQUEST['DEVICE']))
     45  {
     46     $_REQUEST['DEVICE'] = '';
     47  } else $_REQUEST['DEVICE'] = htmlspecialchars( (string) $_REQUEST['DEVICE'], ENT_QUOTES );
     48
     49  if (!isset($_REQUEST['DEVICE_ID']))
     50  {
     51     $_REQUEST['DEVICE_ID'] = '';
     52  } else $_REQUEST['DEVICE_ID'] = htmlspecialchars( (string) $_REQUEST['DEVICE_ID'], ENT_QUOTES );
     53
     54
    3855  $login_timeout = 20;
    39 
    4056  $language = $_REQUEST['LANGUAGE'];
    4157  define('LANGUAGE_TYPE', $language);
    … …  
    86102   $current_account    = $_REQUEST['ACCOUNT'];
    87103   $operator_schedule  = $row['schedule'];
     104   $operator_device    = $_REQUEST['DEVICE'];
     105   $operator_device_id = $_REQUEST['DEVICE_ID'];
     106   
    88107
    89108 //Verifica el schedule
    … …  
    170189
    171190   // Update operator session to database
    172    $query = "UPDATE " . $table_prefix . "users SET `datetime` = NOW(), `refresh` = NOW(), `status` = '0' WHERE `id` = '$operator_login_id'";
     191   $query = "UPDATE " . $table_prefix . "users SET `datetime` = NOW(), `refresh` = NOW(), `status` = '0' , `device` = '$operator_device' , `device_id` = '$operator_device_id'   WHERE `id` = '$operator_login_id'";
    173192
    174193   $SQL->miscquery($query);

  • activehelper-livehelp/trunk/server/services/visitors.php

    r1003856 r1103349  
    181181            case "standard":
    182182               {
    183                   $query = "SELECT r.id As rid, s.id As sid, s.active, s.username, r.ipaddress, r.url, r.title, r.number_pages, ".
     183                  $query = "SELECT r.id As rid, s.id As sid, s.active, s.username, r.ipaddress, r.url, SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(r.url, '://', -1),'/',1),'www.', -1) as domain,  r.title , r.number_pages, ".
    184184                           "(UNIX_TIMESTAMP(r.refresh) - UNIX_TIMESTAMP(r.datetime)) AS `sitetime`, (UNIX_TIMESTAMP(r.refresh) - ".
    185                            "UNIX_TIMESTAMP(r.request)) AS `pagetime` FROM " . $table_prefix . "requests AS r LEFT JOIN ".
     185                           "UNIX_TIMESTAMP(r.request)) AS `pagetime` , r.country FROM " . $table_prefix . "requests AS r LEFT JOIN ".
    186186                           "(select id, request, active, username, department, rating from ".$table_prefix."sessions order by id desc) AS s on r.id = s.request WHERE DATE_FORMAT(r.datetime, '%Y-%m-%d') = '$date' AND `status` = '0' AND".
    187187                           " `active` in (-1, -3) and id_domain in (" . $domains_set . ") " . ($visitorId == "" ? "": "And r.id=" .
    … …  
    224224            case "standard":
    225225               {
    226                   $query = "SELECT r.id As rid, s.id As sid, s.active, s.username, r.ipaddress, r.url, r.title, r.number_pages, ".
     226                  $query = "SELECT r.id As rid, s.id As sid, s.active, s.username, r.ipaddress, r.url , SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(r.url, '://', -1),'/',1),'www.', -1) as domain , r.title, r.number_pages, ".
    227227                  "(UNIX_TIMESTAMP(r.refresh) - UNIX_TIMESTAMP(r.datetime)) AS `sitetime`, (UNIX_TIMESTAMP(r.refresh) - UNIX_TIMESTAMP".
    228                   "(r.request)) AS `pagetime` FROM " . $table_prefix . "requests AS r LEFT JOIN " .$table_prefix."sessions AS s on r.id = s.request".
     228                  "(r.request)) AS `pagetime` , r.country  FROM " . $table_prefix . "requests AS r LEFT JOIN " .$table_prefix."sessions AS s on r.id = s.request".
    229229                  " WHERE  r.refresh > SUBTIME(NOW(), '45')  AND r.status = '0' and ".
    230230                  "r.id_domain in (".$domains_set . ") " . ($visitorId == "" ? "": "And r.id=" . $visitorId) .
    … …  
    281281               $current_request_resolution = $row['resolution'];
    282282               $current_request_current_page = $row['url'];
     283               $current_request_current_domain = $row['domain'];               
    283284               $current_request_current_page_title = $row['title'];
    284285               $current_request_referrer = $row['referrer'];
    285 
    286 
     286         
    287287
    288288                if($current_request_referrer == 'Direct Visit / Bookmark'){
    … …  
    460460<TimeOnSite><?php echo($current_request_sitetime);?></TimeOnSite>
    461461<TimeOnPage><?php echo($current_request_pagetime);?></TimeOnPage>
     462<Country><?php echo($current_request_country);?></Country>
     463<CurrentDomain><?php echo(xmlinvalidchars($current_request_current_domain));?></CurrentDomain>
    462464<?php
    463465               }

  • activehelper-livehelp/trunk/sources/livehelp_lib-install.php

    r1003856 r1103349  
    22/**
    33 * @package ActiveHelper Live Help
    4  * @Version 3.7.0
     4 * @Version 3.9.0
    55 */
    66
    … …  
    469469            `initial_time` time DEFAULT NULL,
    470470            `final_time` time DEFAULT NULL,
     471            `device` varchar(20) DEFAULT NULL,
     472            `device_id` varchar(60) DEFAULT NULL,
    471473            PRIMARY KEY  (`id`),
    472474            UNIQUE KEY `uk_users_username` (`username`)
    … …  
    946948 if ($database_version == "3.7.0") {                 
    947949       $database_version = "3.8.0";     
    948      }           
     950     }
     951
     952if ($database_version == "3.8.0") {
     953     
     954      $table_name = $wpdb->prefix . "livehelp_users";
     955
     956     $sql = "CREATE TABLE $table_name (
     957             id bigint(20) NOT NULL auto_increment,
     958             username varchar(50) NOT NULL default '',
     959             password varchar(100) NOT NULL default '',
     960             firstname varchar(50) NOT NULL default '',
     961             lastname varchar(50) NOT NULL default '',
     962             email varchar(50) NOT NULL default '',
     963             department varchar(100) NOT NULL default '',
     964             datetime datetime NOT NULL default '0000-00-00 00:00:00',
     965             refresh datetime NOT NULL default '0000-00-00 00:00:00',
     966             disabled int(1) NOT NULL default '0',
     967             privilege int(1) NOT NULL default '0',
     968             photo varchar(10) DEFAULT NULL,
     969             status bigint(20) NOT NULL default '0',
     970             answers int(1) NOT NULL default '1',
     971             schedule int(1) DEFAULT '0',
     972             initial_time time DEFAULT NULL,
     973             final_time time DEFAULT NULL,
     974             device varchar(20) DEFAULT NULL,
     975             device_id varchar(60) DEFAULT NULL,
     976             PRIMARY KEY  (id),
     977             UNIQUE KEY  uk_users_username (username)
     978             );";
     979       
     980             dbDelta( $sql );     
     981             $database_version = "3.9.0";
     982     
     983   }
     984     
    949985   
    950986 }
Note: See TracChangeset for help on using the changeset viewer.