Since no one replied.. i found out my own solution. I wrote 3 triggers to update the cc_sip_buddies table and enabled the realtime.
Trigger 1:
Code:
DELIMITER $$
USE `asterisk_a2b`$$
DROP TRIGGER /*!50032 IF EXISTS */ `trigg_insert_sip_credentials`$$
CREATE
/*!50017 DEFINER = 'root'@'localhost' */
TRIGGER `trigg_insert_sip_credentials` AFTER INSERT ON `cc_card`
FOR EACH ROW BEGIN
SELECT uipass INTO @uip FROM cc_card WHERE id = new.id;
SELECT useralias INTO @ualias FROM cc_card WHERE id = new.id;
SET @id = new.id;
UPDATE cc_sip_buddies SET NAME=@ualias, regexten=@ualias, secret=@uip, username=@ualias WHERE id_cc_card = @id;
END;
$$
DELIMITER ;
Trigger 2:
Code:
DELIMITER $$
USE `asterisk_a2b`$$
DROP TRIGGER /*!50032 IF EXISTS */ `trigg_upd_sip_credentials`$$
CREATE
/*!50017 DEFINER = 'root'@'localhost' */
TRIGGER `trigg_upd_sip_credentials` AFTER UPDATE ON `cc_card`
FOR EACH ROW BEGIN
SELECT uipass INTO @uip FROM cc_card WHERE id = new.id;
SELECT useralias INTO @ualias FROM cc_card WHERE id = new.id;
SET @id = new.id;
UPDATE cc_sip_buddies SET NAME=@ualias, regexten=@ualias, secret=@uip, username=@ualias WHERE id_cc_card = @id;
END;
$$
DELIMITER ;
Trigger 3:
Code:
DELIMITER $$
USE `asterisk_a2b`$$
DROP TRIGGER /*!50032 IF EXISTS */ `trigg_insert_sip_cred_2`$$
CREATE
/*!50017 DEFINER = 'root'@'localhost' */
TRIGGER `trigg_insert_sip_cred_2` BEFORE INSERT ON `cc_sip_buddies`
FOR EACH ROW BEGIN
SET @id = new.id_cc_card;
SELECT uipass INTO @uip FROM cc_card WHERE id = @id;
SELECT useralias INTO @ualias FROM cc_card WHERE id = @id;
SET NEW.name=@ualias;
SET NEW.username=@ualias;
SET NEW.secret=@uip;
SET NEW.regexten=@ualias;
END;
$$
DELIMITER ;
To link the SIP/IAX to the card, I enabled the linking from "Account Code" instead of Username. Here is the modification to the code,
Code:
In file, /admin/Public/form_data/FG_var_friend.inc (change the line 63 of 986)
$HD_Form -> AddViewElement(gettext("ACCOUNTCODE"), "accountcode", "12%", "center", "sort","", "30", "", "", "", "","linktocustomer");
MODERATORS: Please move this post from "Request" to "General" Section. I am sure lot of people may need this functionality as other billing systems do this.
Thanks
Thameem