a:14:{s:6:"config";s:1630:"a:5:{s:10:"phpVersion";s:6:"8.0.30";s:10:"yiiVersion";s:8:"2.0.49.3";s:11:"application";a:8:{s:3:"yii";s:8:"2.0.49.3";s:4:"name";s:14:"My Application";s:7:"version";s:3:"1.0";s:8:"language";s:5:"en-US";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:6:"8.0.30";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:5:{s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-faker/src";}}s:26:"yiisoft/yii2-symfonymailer";a:3:{s:4:"name";s:26:"yiisoft/yii2-symfonymailer";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:18:"@yii/symfonymailer";s:84:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-symfonymailer/src";}}s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:81:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.6.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:74:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-gii/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.25.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-debug/src";}}}}";s:3:"log";s:24271:"a:1:{s:8:"messages";a:44:{i:0;a:6:{i:0;s:68:"Bootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1780670634.6155059337615966796875;i:4;a:0:{}i:5;i:2757424;}i:1;a:6:{i:0;s:33:"Bootstrap with yii\log\Dispatcher";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1780670634.61651611328125;i:4;a:0:{}i:5;i:2933536;}i:2;a:6:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1780670634.6165421009063720703125;i:4;a:0:{}i:5;i:2934336;}i:3;a:6:{i:0;s:44:"Bootstrap with yii\debug\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1780670634.6252269744873046875;i:4;a:0:{}i:5;i:4095960;}i:4;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1780670634.6290829181671142578125;i:4;a:0:{}i:5;i:4660008;}i:5;a:6:{i:0;s:42:"Bootstrap with yii\gii\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1780670634.6293380260467529296875;i:4;a:0:{}i:5;i:4684872;}i:28;a:6:{i:0;s:40:"Route requested: 'api/marketing/connect'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1780670634.6321170330047607421875;i:4;a:0:{}i:5;i:4922128;}i:29;a:6:{i:0;s:19:"Loading module: api";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1780670634.6321289539337158203125;i:4;a:0:{}i:5;i:4923760;}i:30;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `sm_cp`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6433069705963134765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6317392;}i:31;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_cpbroadcast_smcp";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1780670634.6433379650115966796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6320224;}i:36;a:6:{i:0;s:766:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.64719390869140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6417976;}i:39;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='c2b365ee30b69936407f9585647c98a4') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.65101909637451171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6760312;}i:42;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=7458";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.665318965911865234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6976880;}i:45;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `log_api`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6660621166229248046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7009224;}i:48;a:6:{i:0;s:770:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6667659282684326171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7018696;}i:51;a:6:{i:0;s:278:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/mk_connect', 1, '{\"project_id \":\"422\",\"sm_cp_id\":\"7490\",\"type\":\"1\"}', '2026-06-05 20:13:54', 7458, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6673190593719482421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7023544;}i:54;a:6:{i:0;s:35:"Route to run: api/marketing/connect";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1780670634.6704990863800048828125;i:4;a:0:{}i:5;i:7171352;}i:55;a:6:{i:0;s:80:"Running action: app\modules\api\controllers\MarketingController::actionConnect()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1780670634.671925067901611328125;i:4;a:0:{}i:5;i:7372472;}i:56;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='c2b365ee30b69936407f9585647c98a4') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6721251010894775390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:64;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7383632;}i:59;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=7458";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6833379268646240234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:64;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7396480;}i:62;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `report_offers`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.683763980865478515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:114;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7421168;}i:65;a:6:{i:0;s:782:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'report_offers' AND `kcu`.`TABLE_NAME` = 'report_offers'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.684413909912109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:114;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7436328;}i:68;a:6:{i:0;s:162:"INSERT INTO `report_offers` (`sm_cp_id`, `cp_id`, `offer_id`, `project_id`, `click_type`, `created_on`) VALUES (7458, 43245, NULL, NULL, 2, '2026-06-05 20:13:54')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6850988864898681640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:120;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7443480;}i:71;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `sm_cp_network`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.686049938201904296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7468008;}i:74;a:6:{i:0;s:782:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_cp_network' AND `kcu`.`TABLE_NAME` = 'sm_cp_network'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6866829395294189453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7480912;}i:77;a:6:{i:0;s:87:"SELECT * FROM `sm_cp_network` WHERE (`sm_cp_id`='7490') AND (`channelpartner_id`=43245)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6870710849761962890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7483144;}i:80;a:6:{i:0;s:73:"Failed to set unsafe attribute 'project_id ' in 'app\models\SmCpNetwork'.";i:1;i:8;i:2;s:33:"yii\base\Model::onUnsafeAttribute";i:3;d:1780670634.6874830722808837890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:189;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7486056;}i:81;a:6:{i:0;s:66:"Failed to set unsafe attribute 'type' in 'app\models\SmCpNetwork'.";i:1;i:8;i:2;s:33:"yii\base\Model::onUnsafeAttribute";i:3;d:1780670634.6874930858612060546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:189;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7487656;}i:82;a:6:{i:0;s:232:"INSERT INTO `sm_cp_network` (`sm_cp_id`, `channelpartner_id`, `request_sent`, `created_by`, `status`, `modified_date`, `joined_date`) VALUES (7490, 43245, '2026-06-05 20:13:54', 7458, 1, '2026-06-05 20:13:54', '2026-06-05 20:13:54')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6876490116119384765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:190;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7496752;}i:85;a:6:{i:0;s:44:"SHOW FULL COLUMNS FROM `notification_master`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6887969970703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:202;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7520808;}i:88;a:6:{i:0;s:794:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'notification_master' AND `kcu`.`TABLE_NAME` = 'notification_master'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6894359588623046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:202;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7534208;}i:91;a:6:{i:0;s:315:"INSERT INTO `notification_master` (`entity`, `sent_type`, `notify_type`, `status`, `landing`, `title`, `message`, `link`, `info`, `created_on`) VALUES (2, 2, 4, 2, 8, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '[]', '2026-06-05 20:13:54')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6899349689483642578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:212;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7545240;}i:94;a:6:{i:0;s:42:"SHOW FULL COLUMNS FROM `notification_list`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6915218830108642578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:217;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7567392;}i:97;a:6:{i:0;s:790:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'notification_list' AND `kcu`.`TABLE_NAME` = 'notification_list'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6921379566192626953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:217;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7580240;}i:100;a:6:{i:0;s:283:"INSERT INTO `notification_list` (`notification_id`, `sm_cp_id`, `title`, `message`, `link`, `created_on`, `status`) VALUES (293360, 7490, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '2026-06-05 20:13:54', 1)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.692634105682373046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:224;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7588384;}i:103;a:6:{i:0;s:70:"SELECT * FROM `sm_projects` WHERE (`status`=1) AND (`sm_cp_id`='7490')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.694221019744873046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7611376;}i:106;a:6:{i:0;s:36:"SHOW FULL COLUMNS FROM `sm_projects`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.694489955902099609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7618248;}i:109;a:6:{i:0;s:778:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_projects' AND `kcu`.`TABLE_NAME` = 'sm_projects'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6950609683990478515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7628200;}i:112;a:6:{i:0;s:102:"SELECT GROUP_CONCAT(DISTINCT location_id ORDER BY location_id) AS loc FROM `projects` WHERE `id`='422'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.696302890777587890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:294;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7702504;}i:115;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `channelpartner`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6970899105072021484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7745536;}i:118;a:6:{i:0;s:784:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'channelpartner' AND `kcu`.`TABLE_NAME` = 'channelpartner'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6983931064605712890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7792032;}i:121;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=43245";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.69906902313232421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7801480;}i:124;a:6:{i:0;s:84:"UPDATE `channelpartner` SET `location_id`='3,8,29,33,50,56,134,179' WHERE `id`=43245";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.69987392425537109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:309;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7828440;}i:127;a:6:{i:0;s:102:"Access to debugger is denied due to IP address restriction. The requesting IP address is 49.33.225.221";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1780670634.7171609401702880859375;i:4;a:0:{}i:5;i:9365400;}}}";s:9:"profiling";s:42908:"a:3:{s:6:"memory";i:11721824;s:4:"time";d:0.118423938751220703125;s:8:"messages";a:62:{i:32;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_cpbroadcast_smcp";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1780670634.6433470249176025390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6321728;}i:33;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_cpbroadcast_smcp";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1780670634.6448590755462646484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6368592;}i:34;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `sm_cp`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6448841094970703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6369192;}i:35;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `sm_cp`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6465930938720703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6412168;}i:37;a:6:{i:0;s:766:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6472170352935791015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6421216;}i:38;a:6:{i:0;s:766:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6480090618133544921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6423800;}i:40;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='c2b365ee30b69936407f9585647c98a4') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.65104007720947265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6761488;}i:41;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='c2b365ee30b69936407f9585647c98a4') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.66302394866943359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6769352;}i:43;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=7458";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.665361881256103515625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6978472;}i:44;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=7458";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.665709018707275390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6980096;}i:46;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `log_api`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.666079044342041015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7010592;}i:47;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `log_api`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.666677951812744140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7019200;}i:49;a:6:{i:0;s:770:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6668109893798828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7021560;}i:50;a:6:{i:0;s:770:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6671450138092041015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7023768;}i:52;a:6:{i:0;s:278:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/mk_connect', 1, '{\"project_id \":\"422\",\"sm_cp_id\":\"7490\",\"type\":\"1\"}', '2026-06-05 20:13:54', 7458, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6673309803009033203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7023896;}i:53;a:6:{i:0;s:278:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/mk_connect', 1, '{\"project_id \":\"422\",\"sm_cp_id\":\"7490\",\"type\":\"1\"}', '2026-06-05 20:13:54', 7458, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6684119701385498046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7025352;}i:57;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='c2b365ee30b69936407f9585647c98a4') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.67214107513427734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:64;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7384808;}i:58;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='c2b365ee30b69936407f9585647c98a4') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6830580234527587890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:64;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7391544;}i:60;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=7458";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.683351039886474609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:64;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7398072;}i:61;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=7458";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.68356990814208984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:64;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7399696;}i:63;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `report_offers`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6837770938873291015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:114;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7422536;}i:64;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `report_offers`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.68432903289794921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:114;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7431088;}i:66;a:6:{i:0;s:782:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'report_offers' AND `kcu`.`TABLE_NAME` = 'report_offers'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6844260692596435546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:114;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7439192;}i:67;a:6:{i:0;s:782:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'report_offers' AND `kcu`.`TABLE_NAME` = 'report_offers'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6849009990692138671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:114;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7441400;}i:69;a:6:{i:0;s:162:"INSERT INTO `report_offers` (`sm_cp_id`, `cp_id`, `offer_id`, `project_id`, `click_type`, `created_on`) VALUES (7458, 43245, NULL, NULL, 2, '2026-06-05 20:13:54')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.68511104583740234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:120;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7443832;}i:70;a:6:{i:0;s:162:"INSERT INTO `report_offers` (`sm_cp_id`, `cp_id`, `offer_id`, `project_id`, `click_type`, `created_on`) VALUES (7458, 43245, NULL, NULL, 2, '2026-06-05 20:13:54')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.685841083526611328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:120;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7445160;}i:72;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `sm_cp_network`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6860640048980712890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7469376;}i:73;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `sm_cp_network`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.68657398223876953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7485160;}i:75;a:6:{i:0;s:782:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_cp_network' AND `kcu`.`TABLE_NAME` = 'sm_cp_network'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6867229938507080078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7483776;}i:76;a:6:{i:0;s:782:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_cp_network' AND `kcu`.`TABLE_NAME` = 'sm_cp_network'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6869800090789794921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7485984;}i:78;a:6:{i:0;s:87:"SELECT * FROM `sm_cp_network` WHERE (`sm_cp_id`='7490') AND (`channelpartner_id`=43245)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6870810985565185546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7484408;}i:79;a:6:{i:0;s:87:"SELECT * FROM `sm_cp_network` WHERE (`sm_cp_id`='7490') AND (`channelpartner_id`=43245)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.687407970428466796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7486272;}i:83;a:6:{i:0;s:232:"INSERT INTO `sm_cp_network` (`sm_cp_id`, `channelpartner_id`, `request_sent`, `created_by`, `status`, `modified_date`, `joined_date`) VALUES (7490, 43245, '2026-06-05 20:13:54', 7458, 1, '2026-06-05 20:13:54', '2026-06-05 20:13:54')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6876599788665771484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:190;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7496904;}i:84;a:6:{i:0;s:232:"INSERT INTO `sm_cp_network` (`sm_cp_id`, `channelpartner_id`, `request_sent`, `created_by`, `status`, `modified_date`, `joined_date`) VALUES (7490, 43245, '2026-06-05 20:13:54', 7458, 1, '2026-06-05 20:13:54', '2026-06-05 20:13:54')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6886351108551025390625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:190;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7498360;}i:86;a:6:{i:0;s:44:"SHOW FULL COLUMNS FROM `notification_master`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.68881511688232421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:202;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7522200;}i:87;a:6:{i:0;s:44:"SHOW FULL COLUMNS FROM `notification_master`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.689323902130126953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:202;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7539136;}i:89;a:6:{i:0;s:794:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'notification_master' AND `kcu`.`TABLE_NAME` = 'notification_master'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6894481182098388671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:202;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7537072;}i:90;a:6:{i:0;s:794:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'notification_master' AND `kcu`.`TABLE_NAME` = 'notification_master'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6897170543670654296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:202;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7539280;}i:92;a:6:{i:0;s:315:"INSERT INTO `notification_master` (`entity`, `sent_type`, `notify_type`, `status`, `landing`, `title`, `message`, `link`, `info`, `created_on`) VALUES (2, 2, 4, 2, 8, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '[]', '2026-06-05 20:13:54')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6899468898773193359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:212;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7544344;}i:93;a:6:{i:0;s:315:"INSERT INTO `notification_master` (`entity`, `sent_type`, `notify_type`, `status`, `landing`, `title`, `message`, `link`, `info`, `created_on`) VALUES (2, 2, 4, 2, 8, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '[]', '2026-06-05 20:13:54')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6913220882415771484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:212;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7545864;}i:95;a:6:{i:0;s:42:"SHOW FULL COLUMNS FROM `notification_list`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6915500164031982421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:217;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7568784;}i:96;a:6:{i:0;s:42:"SHOW FULL COLUMNS FROM `notification_list`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6920020580291748046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:217;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7584576;}i:98;a:6:{i:0;s:790:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'notification_list' AND `kcu`.`TABLE_NAME` = 'notification_list'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6921489238739013671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:217;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7583104;}i:99;a:6:{i:0;s:790:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'notification_list' AND `kcu`.`TABLE_NAME` = 'notification_list'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.692409992218017578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:217;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7585312;}i:101;a:6:{i:0;s:283:"INSERT INTO `notification_list` (`notification_id`, `sm_cp_id`, `title`, `message`, `link`, `created_on`, `status`) VALUES (293360, 7490, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '2026-06-05 20:13:54', 1)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.69264507293701171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:224;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7588504;}i:102;a:6:{i:0;s:283:"INSERT INTO `notification_list` (`notification_id`, `sm_cp_id`, `title`, `message`, `link`, `created_on`, `status`) VALUES (293360, 7490, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '2026-06-05 20:13:54', 1)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6940009593963623046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:224;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7589960;}i:104;a:6:{i:0;s:70:"SELECT * FROM `sm_projects` WHERE (`status`=1) AND (`sm_cp_id`='7490')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.694232940673828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7612608;}i:105;a:6:{i:0;s:70:"SELECT * FROM `sm_projects` WHERE (`status`=1) AND (`sm_cp_id`='7490')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6944530010223388671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7614736;}i:107;a:6:{i:0;s:36:"SHOW FULL COLUMNS FROM `sm_projects`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6945450305938720703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7619616;}i:108;a:6:{i:0;s:36:"SHOW FULL COLUMNS FROM `sm_projects`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.694982051849365234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7629168;}i:110;a:6:{i:0;s:778:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_projects' AND `kcu`.`TABLE_NAME` = 'sm_projects'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6950719356536865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7631064;}i:111;a:6:{i:0;s:778:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_projects' AND `kcu`.`TABLE_NAME` = 'sm_projects'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6953179836273193359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7633272;}i:113;a:6:{i:0;s:102:"SELECT GROUP_CONCAT(DISTINCT location_id ORDER BY location_id) AS loc FROM `projects` WHERE `id`='422'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.696319103240966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:294;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7704064;}i:114;a:6:{i:0;s:102:"SELECT GROUP_CONCAT(DISTINCT location_id ORDER BY location_id) AS loc FROM `projects` WHERE `id`='422'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6967298984527587890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:294;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7705744;}i:116;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `channelpartner`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.697104930877685546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7746904;}i:117;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `channelpartner`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6979401111602783203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7828888;}i:119;a:6:{i:0;s:784:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'channelpartner' AND `kcu`.`TABLE_NAME` = 'channelpartner'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6984069347381591796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7794896;}i:120;a:6:{i:0;s:784:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'channelpartner' AND `kcu`.`TABLE_NAME` = 'channelpartner'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.698872089385986328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7797104;}i:122;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=43245";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.699080944061279296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7802928;}i:123;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=43245";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.69954204559326171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7818544;}i:125;a:6:{i:0;s:84:"UPDATE `channelpartner` SET `location_id`='3,8,29,33,50,56,134,179' WHERE `id`=43245";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6998860836029052734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:309;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7829656;}i:126;a:6:{i:0;s:84:"UPDATE `channelpartner` SET `location_id`='3,8,29,33,50,56,134,179' WHERE `id`=43245";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.7001988887786865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:309;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7830936;}}}";s:2:"db";s:41553:"a:1:{s:8:"messages";a:60:{i:34;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `sm_cp`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6448841094970703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6369192;}i:35;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `sm_cp`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6465930938720703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6412168;}i:37;a:6:{i:0;s:766:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6472170352935791015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6421216;}i:38;a:6:{i:0;s:766:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6480090618133544921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6423800;}i:40;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='c2b365ee30b69936407f9585647c98a4') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.65104007720947265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6761488;}i:41;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='c2b365ee30b69936407f9585647c98a4') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.66302394866943359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6769352;}i:43;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=7458";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.665361881256103515625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6978472;}i:44;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=7458";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.665709018707275390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6980096;}i:46;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `log_api`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.666079044342041015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7010592;}i:47;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `log_api`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.666677951812744140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7019200;}i:49;a:6:{i:0;s:770:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6668109893798828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7021560;}i:50;a:6:{i:0;s:770:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6671450138092041015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7023768;}i:52;a:6:{i:0;s:278:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/mk_connect', 1, '{\"project_id \":\"422\",\"sm_cp_id\":\"7490\",\"type\":\"1\"}', '2026-06-05 20:13:54', 7458, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6673309803009033203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7023896;}i:53;a:6:{i:0;s:278:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/mk_connect', 1, '{\"project_id \":\"422\",\"sm_cp_id\":\"7490\",\"type\":\"1\"}', '2026-06-05 20:13:54', 7458, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6684119701385498046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7025352;}i:57;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='c2b365ee30b69936407f9585647c98a4') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.67214107513427734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:64;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7384808;}i:58;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='c2b365ee30b69936407f9585647c98a4') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6830580234527587890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:64;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7391544;}i:60;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=7458";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.683351039886474609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:64;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7398072;}i:61;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=7458";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.68356990814208984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:64;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7399696;}i:63;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `report_offers`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6837770938873291015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:114;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7422536;}i:64;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `report_offers`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.68432903289794921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:114;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7431088;}i:66;a:6:{i:0;s:782:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'report_offers' AND `kcu`.`TABLE_NAME` = 'report_offers'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6844260692596435546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:114;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7439192;}i:67;a:6:{i:0;s:782:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'report_offers' AND `kcu`.`TABLE_NAME` = 'report_offers'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6849009990692138671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:114;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7441400;}i:69;a:6:{i:0;s:162:"INSERT INTO `report_offers` (`sm_cp_id`, `cp_id`, `offer_id`, `project_id`, `click_type`, `created_on`) VALUES (7458, 43245, NULL, NULL, 2, '2026-06-05 20:13:54')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.68511104583740234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:120;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7443832;}i:70;a:6:{i:0;s:162:"INSERT INTO `report_offers` (`sm_cp_id`, `cp_id`, `offer_id`, `project_id`, `click_type`, `created_on`) VALUES (7458, 43245, NULL, NULL, 2, '2026-06-05 20:13:54')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.685841083526611328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:120;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7445160;}i:72;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `sm_cp_network`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6860640048980712890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7469376;}i:73;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `sm_cp_network`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.68657398223876953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7485160;}i:75;a:6:{i:0;s:782:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_cp_network' AND `kcu`.`TABLE_NAME` = 'sm_cp_network'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6867229938507080078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7483776;}i:76;a:6:{i:0;s:782:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_cp_network' AND `kcu`.`TABLE_NAME` = 'sm_cp_network'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6869800090789794921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7485984;}i:78;a:6:{i:0;s:87:"SELECT * FROM `sm_cp_network` WHERE (`sm_cp_id`='7490') AND (`channelpartner_id`=43245)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6870810985565185546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7484408;}i:79;a:6:{i:0;s:87:"SELECT * FROM `sm_cp_network` WHERE (`sm_cp_id`='7490') AND (`channelpartner_id`=43245)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.687407970428466796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:124;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7486272;}i:83;a:6:{i:0;s:232:"INSERT INTO `sm_cp_network` (`sm_cp_id`, `channelpartner_id`, `request_sent`, `created_by`, `status`, `modified_date`, `joined_date`) VALUES (7490, 43245, '2026-06-05 20:13:54', 7458, 1, '2026-06-05 20:13:54', '2026-06-05 20:13:54')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6876599788665771484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:190;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7496904;}i:84;a:6:{i:0;s:232:"INSERT INTO `sm_cp_network` (`sm_cp_id`, `channelpartner_id`, `request_sent`, `created_by`, `status`, `modified_date`, `joined_date`) VALUES (7490, 43245, '2026-06-05 20:13:54', 7458, 1, '2026-06-05 20:13:54', '2026-06-05 20:13:54')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6886351108551025390625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:190;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7498360;}i:86;a:6:{i:0;s:44:"SHOW FULL COLUMNS FROM `notification_master`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.68881511688232421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:202;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7522200;}i:87;a:6:{i:0;s:44:"SHOW FULL COLUMNS FROM `notification_master`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.689323902130126953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:202;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7539136;}i:89;a:6:{i:0;s:794:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'notification_master' AND `kcu`.`TABLE_NAME` = 'notification_master'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6894481182098388671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:202;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7537072;}i:90;a:6:{i:0;s:794:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'notification_master' AND `kcu`.`TABLE_NAME` = 'notification_master'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6897170543670654296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:202;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7539280;}i:92;a:6:{i:0;s:315:"INSERT INTO `notification_master` (`entity`, `sent_type`, `notify_type`, `status`, `landing`, `title`, `message`, `link`, `info`, `created_on`) VALUES (2, 2, 4, 2, 8, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '[]', '2026-06-05 20:13:54')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6899468898773193359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:212;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7544344;}i:93;a:6:{i:0;s:315:"INSERT INTO `notification_master` (`entity`, `sent_type`, `notify_type`, `status`, `landing`, `title`, `message`, `link`, `info`, `created_on`) VALUES (2, 2, 4, 2, 8, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '[]', '2026-06-05 20:13:54')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6913220882415771484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:212;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7545864;}i:95;a:6:{i:0;s:42:"SHOW FULL COLUMNS FROM `notification_list`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6915500164031982421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:217;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7568784;}i:96;a:6:{i:0;s:42:"SHOW FULL COLUMNS FROM `notification_list`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6920020580291748046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:217;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7584576;}i:98;a:6:{i:0;s:790:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'notification_list' AND `kcu`.`TABLE_NAME` = 'notification_list'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6921489238739013671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:217;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7583104;}i:99;a:6:{i:0;s:790:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'notification_list' AND `kcu`.`TABLE_NAME` = 'notification_list'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.692409992218017578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:217;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7585312;}i:101;a:6:{i:0;s:283:"INSERT INTO `notification_list` (`notification_id`, `sm_cp_id`, `title`, `message`, `link`, `created_on`, `status`) VALUES (293360, 7490, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '2026-06-05 20:13:54', 1)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.69264507293701171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:224;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7588504;}i:102;a:6:{i:0;s:283:"INSERT INTO `notification_list` (`notification_id`, `sm_cp_id`, `title`, `message`, `link`, `created_on`, `status`) VALUES (293360, 7490, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '2026-06-05 20:13:54', 1)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6940009593963623046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:224;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7589960;}i:104;a:6:{i:0;s:70:"SELECT * FROM `sm_projects` WHERE (`status`=1) AND (`sm_cp_id`='7490')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.694232940673828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7612608;}i:105;a:6:{i:0;s:70:"SELECT * FROM `sm_projects` WHERE (`status`=1) AND (`sm_cp_id`='7490')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6944530010223388671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7614736;}i:107;a:6:{i:0;s:36:"SHOW FULL COLUMNS FROM `sm_projects`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6945450305938720703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7619616;}i:108;a:6:{i:0;s:36:"SHOW FULL COLUMNS FROM `sm_projects`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.694982051849365234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7629168;}i:110;a:6:{i:0;s:778:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_projects' AND `kcu`.`TABLE_NAME` = 'sm_projects'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6950719356536865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7631064;}i:111;a:6:{i:0;s:778:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sm_projects' AND `kcu`.`TABLE_NAME` = 'sm_projects'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6953179836273193359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:286;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7633272;}i:113;a:6:{i:0;s:102:"SELECT GROUP_CONCAT(DISTINCT location_id ORDER BY location_id) AS loc FROM `projects` WHERE `id`='422'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.696319103240966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:294;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7704064;}i:114;a:6:{i:0;s:102:"SELECT GROUP_CONCAT(DISTINCT location_id ORDER BY location_id) AS loc FROM `projects` WHERE `id`='422'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6967298984527587890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:294;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7705744;}i:116;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `channelpartner`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.697104930877685546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7746904;}i:117;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `channelpartner`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6979401111602783203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7828888;}i:119;a:6:{i:0;s:784:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'channelpartner' AND `kcu`.`TABLE_NAME` = 'channelpartner'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.6984069347381591796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7794896;}i:120;a:6:{i:0;s:784:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'channelpartner' AND `kcu`.`TABLE_NAME` = 'channelpartner'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.698872089385986328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7797104;}i:122;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=43245";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.699080944061279296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7802928;}i:123;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=43245";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670634.69954204559326171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:298;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7818544;}i:125;a:6:{i:0;s:84:"UPDATE `channelpartner` SET `location_id`='3,8,29,33,50,56,134,179' WHERE `id`=43245";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.6998860836029052734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:309;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7829656;}i:126;a:6:{i:0;s:84:"UPDATE `channelpartner` SET `location_id`='3,8,29,33,50,56,134,179' WHERE `id`=43245";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670634.7001988887786865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:102:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:309;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7830936;}}}";s:5:"event";s:12398:"a:64:{i:0;a:5:{s:4:"time";d:1780670634.6312530040740966796875;s:4:"name";s:13:"beforeRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:1;a:5:{s:4:"time";d:1780670634.63980197906494140625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:2;a:5:{s:4:"time";d:1780670634.644853115081787109375;s:4:"name";s:9:"afterOpen";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:3;a:5:{s:4:"time";d:1780670634.6630599498748779296875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:4;a:5:{s:4:"time";d:1780670634.6631109714508056640625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:5;a:5:{s:4:"time";d:1780670634.6632099151611328125;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:6;a:5:{s:4:"time";d:1780670634.6652090549468994140625;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:7;a:5:{s:4:"time";d:1780670634.6652228832244873046875;s:4:"name";s:12:"beforeUpdate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:8;a:5:{s:4:"time";d:1780670634.6657969951629638671875;s:4:"name";s:11:"afterUpdate";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:9;a:5:{s:4:"time";d:1780670634.6658980846405029296875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\LogApi";}i:10;a:5:{s:4:"time";d:1780670634.66718006134033203125;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\LogApi";}i:11;a:5:{s:4:"time";d:1780670634.66724300384521484375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\LogApi";}i:12;a:5:{s:4:"time";d:1780670634.667252063751220703125;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\LogApi";}i:13;a:5:{s:4:"time";d:1780670634.6684730052947998046875;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\LogApi";}i:14;a:5:{s:4:"time";d:1780670634.670586109161376953125;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:15;a:5:{s:4:"time";d:1780670634.6705949306488037109375;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\modules\api\ApiModule";}i:16;a:5:{s:4:"time";d:1780670634.6719100475311279296875;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"app\modules\api\controllers\MarketingController";}i:17;a:5:{s:4:"time";d:1780670634.671987056732177734375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:18;a:5:{s:4:"time";d:1780670634.683083057403564453125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:19;a:5:{s:4:"time";d:1780670634.683125019073486328125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:20;a:5:{s:4:"time";d:1780670634.6831419467926025390625;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:21;a:5:{s:4:"time";d:1780670634.6832768917083740234375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:22;a:5:{s:4:"time";d:1780670634.6832849979400634765625;s:4:"name";s:12:"beforeUpdate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:23;a:5:{s:4:"time";d:1780670634.6835858821868896484375;s:4:"name";s:11:"afterUpdate";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:24;a:5:{s:4:"time";d:1780670634.6837360858917236328125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"app\models\ReportOffers";}i:25;a:5:{s:4:"time";d:1780670634.6849410533905029296875;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"app\models\ReportOffers";}i:26;a:5:{s:4:"time";d:1780670634.6850368976593017578125;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"app\models\ReportOffers";}i:27;a:5:{s:4:"time";d:1780670634.6850450038909912109375;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"app\models\ReportOffers";}i:28;a:5:{s:4:"time";d:1780670634.6858708858489990234375;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"app\models\ReportOffers";}i:29;a:5:{s:4:"time";d:1780670634.6860129833221435546875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:30;a:5:{s:4:"time";d:1780670634.6874349117279052734375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"app\models\SmCpNetwork";}i:31;a:5:{s:4:"time";d:1780670634.6875131130218505859375;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"app\models\SmCpNetwork";}i:32;a:5:{s:4:"time";d:1780670634.68758392333984375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"app\models\SmCpNetwork";}i:33;a:5:{s:4:"time";d:1780670634.687592029571533203125;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"app\models\SmCpNetwork";}i:34;a:5:{s:4:"time";d:1780670634.688663005828857421875;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"app\models\SmCpNetwork";}i:35;a:5:{s:4:"time";d:1780670634.68877410888671875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:29:"app\models\NotificationMaster";}i:36;a:5:{s:4:"time";d:1780670634.6897590160369873046875;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:29:"app\models\NotificationMaster";}i:37;a:5:{s:4:"time";d:1780670634.689855098724365234375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:29:"app\models\NotificationMaster";}i:38;a:5:{s:4:"time";d:1780670634.6898620128631591796875;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:29:"app\models\NotificationMaster";}i:39;a:5:{s:4:"time";d:1780670634.69134998321533203125;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:29:"app\models\NotificationMaster";}i:40;a:5:{s:4:"time";d:1780670634.6914980411529541015625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:27:"app\models\NotificationList";}i:41;a:5:{s:4:"time";d:1780670634.6924469470977783203125;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:27:"app\models\NotificationList";}i:42;a:5:{s:4:"time";d:1780670634.69256591796875;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:27:"app\models\NotificationList";}i:43;a:5:{s:4:"time";d:1780670634.692573070526123046875;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:27:"app\models\NotificationList";}i:44;a:5:{s:4:"time";d:1780670634.6940290927886962890625;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:27:"app\models\NotificationList";}i:45;a:5:{s:4:"time";d:1780670634.6941559314727783203125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:46;a:5:{s:4:"time";d:1780670634.694469928741455078125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\models\SmProjects";}i:47;a:5:{s:4:"time";d:1780670634.6953461170196533203125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\models\SmProjects";}i:48;a:5:{s:4:"time";d:1780670634.69554996490478515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:49;a:5:{s:4:"time";d:1780670634.6970489025115966796875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:50;a:5:{s:4:"time";d:1780670634.6995639801025390625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\models\Channelpartner";}i:51;a:5:{s:4:"time";d:1780670634.699616909027099609375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\models\Channelpartner";}i:52;a:5:{s:4:"time";d:1780670634.6996390819549560546875;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\models\Channelpartner";}i:53;a:5:{s:4:"time";d:1780670634.6997940540313720703125;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\models\Channelpartner";}i:54;a:5:{s:4:"time";d:1780670634.699801921844482421875;s:4:"name";s:12:"beforeUpdate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\models\Channelpartner";}i:55;a:5:{s:4:"time";d:1780670634.700233936309814453125;s:4:"name";s:11:"afterUpdate";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\models\Channelpartner";}i:56;a:5:{s:4:"time";d:1780670634.7167530059814453125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Common";}i:57;a:5:{s:4:"time";d:1780670634.7167999744415283203125;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"app\modules\api\controllers\MarketingController";}i:58;a:5:{s:4:"time";d:1780670634.7168099880218505859375;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\modules\api\ApiModule";}i:59;a:5:{s:4:"time";d:1780670634.71681499481201171875;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:60;a:5:{s:4:"time";d:1780670634.716825962066650390625;s:4:"name";s:12:"afterRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:61;a:5:{s:4:"time";d:1780670634.7168331146240234375;s:4:"name";s:10:"beforeSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:62;a:5:{s:4:"time";d:1780670634.717175006866455078125;s:4:"name";s:12:"afterPrepare";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:63;a:5:{s:4:"time";d:1780670634.717237949371337890625;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:121:"a:3:{s:5:"start";d:1780670634.6007220745086669921875;s:3:"end";d:1780670634.7194080352783203125;s:6:"memory";i:11721824;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:4475:"a:3:{s:8:"messages";a:22:{i:6;a:6:{i:0;a:3:{s:4:"rule";s:3:"gii";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.6317980289459228515625;i:4;a:0:{}i:5;i:4905912;}i:7;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/<id:\w+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.631865024566650390625;i:4;a:0:{}i:5;i:4906664;}i:8;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.6319038867950439453125;i:4;a:0:{}i:5;i:4907416;}i:9;a:6:{i:0;a:3:{s:4:"rule";s:5:"debug";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.631916046142578125;i:4;a:0:{}i:5;i:4908488;}i:10;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.6319439411163330078125;i:4;a:0:{}i:5;i:4909240;}i:11;a:6:{i:0;a:3:{s:4:"rule";s:12:"cp_getbyrera";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.631966114044189453125;i:4;a:0:{}i:5;i:4909992;}i:12;a:6:{i:0;a:3:{s:4:"rule";s:11:"cp_createcp";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.6319758892059326171875;i:4;a:0:{}i:5;i:4910744;}i:13;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_create";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.6319849491119384765625;i:4;a:0:{}i:5;i:4911496;}i:14;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_detail";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.6319930553436279296875;i:4;a:0:{}i:5;i:4912248;}i:15;a:6:{i:0;a:3:{s:4:"rule";s:8:"ld_stats";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.632009029388427734375;i:4;a:0:{}i:5;i:4913000;}i:16;a:6:{i:0;a:3:{s:4:"rule";s:7:"ld_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.63201904296875;i:4;a:0:{}i:5;i:4913752;}i:17;a:6:{i:0;a:3:{s:4:"rule";s:11:"ld_listname";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.632028102874755859375;i:4;a:0:{}i:5;i:4915144;}i:18;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_update";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.6320359706878662109375;i:4;a:0:{}i:5;i:4915896;}i:19;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_delete";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.6320440769195556640625;i:4;a:0:{}i:5;i:4916648;}i:20;a:6:{i:0;a:3:{s:4:"rule";s:11:"ld_feedback";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.632051944732666015625;i:4;a:0:{}i:5;i:4917400;}i:21;a:6:{i:0;a:3:{s:4:"rule";s:10:"ld_monthly";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.632061004638671875;i:4;a:0:{}i:5;i:4918152;}i:22;a:6:{i:0;a:3:{s:4:"rule";s:8:"loc_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.632072925567626953125;i:4;a:0:{}i:5;i:4918904;}i:23;a:6:{i:0;a:3:{s:4:"rule";s:11:"locsub_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.63208103179931640625;i:4;a:0:{}i:5;i:4919656;}i:24;a:6:{i:0;a:3:{s:4:"rule";s:12:"locationlist";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.632090091705322265625;i:4;a:0:{}i:5;i:4920408;}i:25;a:6:{i:0;a:3:{s:4:"rule";s:7:"mk_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.6320970058441162109375;i:4;a:0:{}i:5;i:4921160;}i:26;a:6:{i:0;s:40:"Request parsed with URL rule: mk_connect";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1780670634.6321079730987548828125;i:4;a:0:{}i:5;i:4922440;}i:27;a:6:{i:0;a:3:{s:4:"rule";s:10:"mk_connect";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780670634.632111072540283203125;i:4;a:0:{}i:5;i:4922744;}}s:5:"route";s:21:"api/marketing/connect";s:6:"action";s:64:"app\modules\api\controllers\MarketingController::actionConnect()";}";s:7:"request";s:3075:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:9:{s:14:"content-length";s:2:"50";s:12:"content-type";s:31:"application/json; charset=UTF-8";s:15:"accept-encoding";s:4:"gzip";s:6:"apikey";s:32:"c2b365ee30b69936407f9585647c98a4";s:11:"channeltype";s:7:"Android";s:10:"connection";s:10:"Keep-Alive";s:4:"host";s:19:"api.cpbroadcast.com";s:10:"user-agent";s:13:"okhttp/4.10.0";s:7:"version";s:2:"35";}s:15:"responseHeaders";a:1:{s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:21:"api/marketing/connect";s:6:"action";s:64:"app\modules\api\controllers\MarketingController::actionConnect()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:4:"POST";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:3:{s:12:"Content Type";s:31:"application/json; charset=UTF-8";s:3:"Raw";s:50:"{"project_id ":"422","sm_cp_id":"7490","type":"1"}";s:7:"Decoded";a:3:{s:11:"project_id ";s:3:"422";s:8:"sm_cp_id";s:4:"7490";s:4:"type";s:1:"1";}}s:6:"SERVER";a:44:{s:14:"CONTENT_LENGTH";s:2:"50";s:12:"CONTENT_TYPE";s:31:"application/json; charset=UTF-8";s:21:"CONTEXT_DOCUMENT_ROOT";s:46:"/home/webprjlw/public_html/api.cpbroadcast.com";s:14:"CONTEXT_PREFIX";s:0:"";s:13:"DOCUMENT_ROOT";s:46:"/home/webprjlw/public_html/api.cpbroadcast.com";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:5:"HTTPS";s:2:"on";s:20:"HTTP_ACCEPT_ENCODING";s:4:"gzip";s:11:"HTTP_APIKEY";s:32:"c2b365ee30b69936407f9585647c98a4";s:16:"HTTP_CHANNELTYPE";s:7:"Android";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:9:"HTTP_HOST";s:19:"api.cpbroadcast.com";s:15:"HTTP_USER_AGENT";s:13:"okhttp/4.10.0";s:12:"HTTP_VERSION";s:2:"35";s:4:"PATH";s:13:"/bin:/usr/bin";s:16:"PHP_INI_SCAN_DIR";s:67:"/opt/cpanel/ea-php80/root/etc:/opt/cpanel/ea-php80/root/etc/php.d:.";s:12:"QUERY_STRING";s:0:"";s:14:"REDIRECT_HTTPS";s:2:"on";s:20:"REDIRECT_SSL_TLS_SNI";s:19:"api.cpbroadcast.com";s:15:"REDIRECT_STATUS";s:3:"200";s:18:"REDIRECT_UNIQUE_ID";s:27:"aiLgqi6ukNdSynSEnqYt_AAAAAY";s:12:"REDIRECT_URL";s:23:"/backend/web/mk_connect";s:11:"REMOTE_ADDR";s:13:"49.33.225.221";s:11:"REMOTE_PORT";s:5:"37212";s:14:"REQUEST_METHOD";s:4:"POST";s:14:"REQUEST_SCHEME";s:5:"https";s:11:"REQUEST_URI";s:23:"/backend/web/mk_connect";s:15:"SCRIPT_FILENAME";s:68:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/web/index.php";s:11:"SCRIPT_NAME";s:22:"/backend/web/index.php";s:11:"SERVER_ADDR";s:13:"65.254.80.108";s:12:"SERVER_ADMIN";s:29:"webmaster@api.cpbroadcast.com";s:11:"SERVER_NAME";s:19:"api.cpbroadcast.com";s:11:"SERVER_PORT";s:3:"443";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:11:"SSL_TLS_SNI";s:19:"api.cpbroadcast.com";s:2:"TZ";s:12:"Asia/Kolkata";s:9:"UNIQUE_ID";s:27:"aiLgqi6ukNdSynSEnqYt_AAAAAY";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1780670634.59224796295166015625;s:12:"REQUEST_TIME";i:1780670634;s:4:"argv";a:0:{}s:4:"argc";i:0;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:4:"user";s:2:"N;";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6a22e0aa98c05";s:3:"url";s:50:"https://api.cpbroadcast.com/backend/web/mk_connect";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:13:"49.33.225.221";s:4:"time";d:1780670634.59224796295166015625;s:10:"statusCode";i:200;s:8:"sqlCount";i:30;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:11721824;s:14:"processingTime";d:0.118423938751220703125;}s:10:"exceptions";a:0:{}}