|
Revision 7232, 0.8 kB
(checked in by p_lindheimer, 4 years ago)
|
module that allows a post answer agi script to be fired from a ringgroup, along with an agi script that will work with sugarcrm to triger CRM popup information based on CID and the DID that was called. The module is generalize so that new agi scripts can be introduced for other similar functionality
|
| Line | |
|---|
| 1 |
<?php |
|---|
| 2 |
|
|---|
| 3 |
global $db; |
|---|
| 4 |
global $amp_conf; |
|---|
| 5 |
|
|---|
| 6 |
$sql = " |
|---|
| 7 |
CREATE TABLE IF NOT EXISTS `cidpopup` ( |
|---|
| 8 |
`type` VARCHAR( 30 ) NOT NULL , |
|---|
| 9 |
`id` VARCHAR( 30 ) NOT NULL , |
|---|
| 10 |
`postagi` INTEGER( 255 ) NOT NULL , |
|---|
| 11 |
PRIMARY KEY ( `type` , `id` ) |
|---|
| 12 |
)"; |
|---|
| 13 |
|
|---|
| 14 |
$check = $db->query($sql); |
|---|
| 15 |
if(DB::IsError($check)) { |
|---|
| 16 |
die_freepbx("Can not create cidpopup table\n"); |
|---|
| 17 |
} |
|---|
| 18 |
|
|---|
| 19 |
$autoincrement = (($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3")) ? "AUTOINCREMENT":"AUTO_INCREMENT"; |
|---|
| 20 |
$sql = "CREATE TABLE IF NOT EXISTS `cidpopup_instance` ( |
|---|
| 21 |
`cidpopup_id` INTEGER NOT NULL PRIMARY KEY $autoincrement, |
|---|
| 22 |
`description` VARCHAR( 50 ) , |
|---|
| 23 |
`ipaddr` VARCHAR( 80 ) , |
|---|
| 24 |
`popup_script` VARCHAR( 255 ) |
|---|
| 25 |
)"; |
|---|
| 26 |
|
|---|
| 27 |
$check = $db->query($sql); |
|---|
| 28 |
if(DB::IsError($check)) { |
|---|
| 29 |
die_freepbx("Can not create cidpopup_instance table\n"); |
|---|
| 30 |
} |
|---|
| 31 |
|
|---|
| 32 |
?> |
|---|
