i can't make use of mod_lcr using Intra/Interstate rating, I am using svn: FreeSWITCH Version 1.0.trunk (16517)<div><br></div><div><div><br></div><div>lcr mysql table structure:</div><div><br></div><div><div>CREATE TABLE `lcr` (</div>
<div> `id` INT(11) NOT NULL AUTO_INCREMENT,</div><div> `digits` VARCHAR(15) DEFAULT NULL,</div><div> `rate` FLOAT(11,5) DEFAULT NULL,</div><div> `intrastate_rate` FLOAT(11,5) DEFAULT NULL,</div><div> `intralata_rate` FLOAT(11,5) DEFAULT NULL,</div>
<div> `carrier_id` INT(11) NOT NULL,</div><div> `lead_strip` INT(11) NOT NULL,</div><div> `trail_strip` INT(11) NOT NULL,</div><div> `prefix` VARCHAR(16) NOT NULL,</div><div> `suffix` VARCHAR(16) NOT NULL,</div><div>
`lcr_profile` VARCHAR(32) DEFAULT NULL,</div><div> `date_start` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00',</div><div> `date_end` DATETIME NOT NULL DEFAULT '2030-12-31 00:00:00',</div><div> `quality` FLOAT(10,6) NOT NULL,</div>
<div> `reliability` FLOAT(10,6) NOT NULL,</div><div> `cid` VARCHAR(32) NOT NULL DEFAULT '',</div><div> `enabled` TINYINT(1) NOT NULL DEFAULT '1',</div><div> PRIMARY KEY (`id`),</div><div> KEY `carrier_id` (`carrier_id`),</div>
<div> KEY `digits` (`digits`),</div><div> KEY `lcr_profile` (`lcr_profile`),</div><div> KEY `digits_profile_cid_rate` USING BTREE (`digits`),</div><div> CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`) REFERENCES `carriers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE</div>
<div>) ENGINE=INNODB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1</div><div><br></div><div><br></div><div><br></div></div><div><b>lcr_admin show profiles</b></div><div><br></div><div>Name: default</div><div> custom sql: SELECT l.digits, c.carrier_name, l.${lcr_rate_field}, cg.prefix AS gw_prefix, cg.suffix AS gw_suffix, l.lead_strip, l.trail_strip, l.prefix, l.suffix , cg.codec , l.cid FROM lcr l JOIN carriers c ON l.carrier_id=<a href="http://c.id">c.id</a> JOIN carrier_gateway cg ON <a href="http://c.id">c.id</a>=cg.carrier_id WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1' AND digits IN (${lcr_query_expanded_digits}) AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end ORDER BY digits DESC, ${lcr_rate_field}, quality DESC, reliability DESC, rand();</div>
<div> has %: false</div><div> has vars: true</div><div> has intrastate: true</div><div> has intralata: true</div><div> has npanxx: true</div><div> Reorder rate: enabled</div><div> Info in headers: disabled</div>
<div> Quote IN() List: disabled</div><div><br></div><div><br></div><div><br></div><div> </div><div><b>lc</b><b>r 617642 default</b> returns rate from the rate field table and not intra/inter state fields rates.</div>
<div><br></div><div><br></div><div>Any ideas? thanks!</div><div><br></div><div><br></div><div><br></div><div><br></div></div>