Live Helper Chat Adding MySQL table for Twilio

 Live Helper Chat Adding MySQL table for Twilio

https://github.com/LiveHelperChat/twilio

1. Pasts the Twilio extension to your Live Helper Chat web server extension folder.

2. Copy extension/twilio/settings.ini.default.php to extension/twilio/settings.ini.php

3. Login into phpAdmin and select the Live Helper Chat DB, Click the SQL tab, copy two lines below then click Go


CREATE TABLE `lhc_twilio_chat` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `chat_id` bigint(20) unsigned NOT NULL, `phone` varchar(35) NOT NULL, `ctime` int(11) NOT NULL, `utime` int(11) NOT NULL, `tphone_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `phone_utime` (`phone`,`utime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `lhc_twilio_phone` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `phone` varchar(35) NOT NULL, `base_phone` varchar(35) NOT NULL, `originator` varchar(35) NOT NULL, `account_sid` varchar(35), `auth_token` varchar(35), `dep_id` int(11) unsigned NOT NULL, `chat_timeout` int(11) unsigned NOT NULL, `responder_timeout` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `phone` (`phone`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

4. Enable the extension in settings/settings.ini.php

'extensions' =>
      array (
        'twilio'
      ),
5. Clear cache from the setting.

Comments

Popular posts from this blog

Extracting and using a modified VMWare Player BIOS or UEFI firmware

Activate Synology Active Backup for Business for DSM 6

Windows 11 internet/account bypass