So after beating on this a while and trying to figure out how to do this with the least amount of change to the way things currently work it would seem that the simple answer is to go in and change all the places in the AST_VDhopper script where it has "list_id IN()" and add a gmt restriction right behind it. So as an example you would currently see the list_id's in the where part of your sql statement this way
- Code: Select all
and list_id IN('4000','998','4001') and {GMT STUFF}
My thought is that if you change it to the code I have below you will effectively pull the gmt's you don't want out of the list before you apply the campaign gmt's
- Code: Select all
((list_id IN('4000') AND gmt_offset_now NOT IN(GMT's you don't want)) OR (list_id IN('998') AND gmt_offset_now NOT IN(GMT's you don't want)) OR list_id IN('4001')) and {GMT STUFF}
In this case we have 4000 and 998 pulling out GMT's. The GMT list would be all the ones it is not time for and then you would have 4001 acting the way things currently work with the campaign. This would mean that you would never have a situation where you would dial outside the time set by the campaign, because you are taking out the GMT's you don't want then using the campaign setting to cut it down further.
As for setting it I planned on using the same drop-down as the campaign has.
Of course at this point I have done little testing and no real coding so if anyone has a better/faster/slicker idea let me know.
ViciBox5.x86_64-5.0.3.preload from .iso upgraded to 13.1 | VERSION: 2.10-444c BUILD: 150129-0828 | 1.8.32.2-vici | Dual Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel twin quad core 3Ghz Xeon chips | 32gb of RAM