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:24308:"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:1780670682.0716440677642822265625;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:1780670682.072598934173583984375;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:1780670682.0726110935211181640625;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:1780670682.0806119441986083984375;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:1780670682.084022045135498046875;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:1780670682.084249019622802734375;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:1780670682.086719989776611328125;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:1780670682.0867269039154052734375;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:1780670682.09702301025390625;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:1780670682.097053050994873046875;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:1780670682.09992694854736328125;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:1780670682.103188037872314453125;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:1780670682.1213729381561279296875;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:1780670682.1221210956573486328125;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:1780670682.1228930950164794921875;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 \":\"411\",\"sm_cp_id\":\"6984\",\"type\":\"1\"}', '2026-06-05 20:14:42', 7458, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.123467922210693359375;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:1780670682.1262309551239013671875;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:1780670682.1275188922882080078125;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:1780670682.127716064453125;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:1780670682.1388111114501953125;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:1780670682.1392281055450439453125;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:1780670682.1400229930877685546875;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:14:42')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.14060306549072265625;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:1780670682.1417610645294189453125;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:1780670682.1424210071563720703125;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`='6984') AND (`channelpartner_id`=43245)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.142816066741943359375;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:1780670682.14414310455322265625;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:1780670682.144153118133544921875;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 (6984, 43245, '2026-06-05 20:14:42', 7458, 1, '2026-06-05 20:14:42', '2026-06-05 20:14:42')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1442940235137939453125;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:1780670682.1455059051513671875;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:1780670682.146213054656982421875;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:14:42')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1467120647430419921875;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:1780670682.148581981658935546875;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:1780670682.149239063262939453125;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 (293361, 6984, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '2026-06-05 20:14:42', 1)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1497309207916259765625;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`='6984')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.151712894439697265625;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:1780670682.1519930362701416015625;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:7618264;}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:1780670682.15256500244140625;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:7628216;}i:112;a:6:{i:0;s:135:"SELECT GROUP_CONCAT(DISTINCT location_id ORDER BY location_id) AS loc FROM `projects` WHERE `id` IN ('400', '401', '405', '411', '413')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1537210941314697265625;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:7704376;}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:1780670682.1544721126556396484375;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:7745744;}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:1780670682.155673980712890625;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:7792240;}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:1780670682.1561601161956787109375;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:7801688;}i:124;a:6:{i:0;s:92:"UPDATE `channelpartner` SET `location_id`='3,8,29,33,50,56,128,134,176,179' WHERE `id`=43245";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1568748950958251953125;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:7829088;}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:1780670682.172871112823486328125;i:4;a:0:{}i:5;i:9365448;}}}";s:9:"profiling";s:42974:"a:3:{s:6:"memory";i:11722472;s:4:"time";d:0.1166169643402099609375;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:1780670682.09706211090087890625;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:1780670682.098081111907958984375;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:1780670682.098104953765869140625;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:1780670682.099339008331298828125;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:1780670682.0999510288238525390625;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:1780670682.1005070209503173828125;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:1780670682.103209018707275390625;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:1780670682.1192109584808349609375;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:1780670682.121428966522216796875;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:1780670682.12180995941162109375;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:1780670682.12213802337646484375;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:1780670682.1228039264678955078125;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:1780670682.122931957244873046875;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:1780670682.1232979297637939453125;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 \":\"411\",\"sm_cp_id\":\"6984\",\"type\":\"1\"}', '2026-06-05 20:14:42', 7458, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1234810352325439453125;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 \":\"411\",\"sm_cp_id\":\"6984\",\"type\":\"1\"}', '2026-06-05 20:14:42', 7458, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.124291896820068359375;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:1780670682.1277310848236083984375;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:1780670682.138555049896240234375;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:1780670682.138823032379150390625;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:1780670682.1390628814697265625;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:1780670682.1392419338226318359375;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:1780670682.1399281024932861328125;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:1780670682.1400349140167236328125;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:1780670682.1404149532318115234375;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:14:42')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.140614986419677734375;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:14:42')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.141580104827880859375;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:1780670682.1417748928070068359375;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:1780670682.14231395721435546875;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:1780670682.142447948455810546875;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:1780670682.1427299976348876953125;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`='6984') AND (`channelpartner_id`=43245)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.142826080322265625;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`='6984') AND (`channelpartner_id`=43245)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1440699100494384765625;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 (6984, 43245, '2026-06-05 20:14:42', 7458, 1, '2026-06-05 20:14:42', '2026-06-05 20:14:42')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1443059444427490234375;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 (6984, 43245, '2026-06-05 20:14:42', 7458, 1, '2026-06-05 20:14:42', '2026-06-05 20:14:42')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1453330516815185546875;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:1780670682.145536899566650390625;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:1780670682.1461029052734375;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:1780670682.1462249755859375;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:1780670682.14649105072021484375;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:14:42')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1467239856719970703125;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:14:42')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1483829021453857421875;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:1780670682.1485950946807861328125;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:1780670682.14910793304443359375;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:1780670682.149250030517578125;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:1780670682.1495130062103271484375;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 (293361, 6984, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '2026-06-05 20:14:42', 1)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1497418880462646484375;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 (293361, 6984, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '2026-06-05 20:14:42', 1)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1515080928802490234375;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`='6984')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1517250537872314453125;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`='6984')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1519489288330078125;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:7614752;}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:1780670682.152017116546630859375;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:7619632;}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:1780670682.152473926544189453125;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:7629184;}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:1780670682.152576923370361328125;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:7631080;}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:1780670682.1528260707855224609375;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:7633288;}i:113;a:6:{i:0;s:135:"SELECT GROUP_CONCAT(DISTINCT location_id ORDER BY location_id) AS loc FROM `projects` WHERE `id` IN ('400', '401', '405', '411', '413')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1537380218505859375;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:7704960;}i:114;a:6:{i:0;s:135:"SELECT GROUP_CONCAT(DISTINCT location_id ORDER BY location_id) AS loc FROM `projects` WHERE `id` IN ('400', '401', '405', '411', '413')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1541659832000732421875;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:7706688;}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:1780670682.1544868946075439453125;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:7747112;}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:1780670682.155250072479248046875;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:7829096;}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:1780670682.1556890010833740234375;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:7795104;}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:1780670682.1559889316558837890625;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:7797312;}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:1780670682.156169891357421875;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:7803136;}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:1780670682.156507015228271484375;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:7818752;}i:125;a:6:{i:0;s:92:"UPDATE `channelpartner` SET `location_id`='3,8,29,33,50,56,128,134,176,179' WHERE `id`=43245";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.156896114349365234375;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:7830304;}i:126;a:6:{i:0;s:92:"UPDATE `channelpartner` SET `location_id`='3,8,29,33,50,56,128,134,176,179' WHERE `id`=43245";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1572740077972412109375;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:7831600;}}}";s:2:"db";s:41621:"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:1780670682.098104953765869140625;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:1780670682.099339008331298828125;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:1780670682.0999510288238525390625;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:1780670682.1005070209503173828125;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:1780670682.103209018707275390625;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:1780670682.1192109584808349609375;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:1780670682.121428966522216796875;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:1780670682.12180995941162109375;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:1780670682.12213802337646484375;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:1780670682.1228039264678955078125;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:1780670682.122931957244873046875;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:1780670682.1232979297637939453125;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 \":\"411\",\"sm_cp_id\":\"6984\",\"type\":\"1\"}', '2026-06-05 20:14:42', 7458, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1234810352325439453125;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 \":\"411\",\"sm_cp_id\":\"6984\",\"type\":\"1\"}', '2026-06-05 20:14:42', 7458, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.124291896820068359375;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:1780670682.1277310848236083984375;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:1780670682.138555049896240234375;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:1780670682.138823032379150390625;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:1780670682.1390628814697265625;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:1780670682.1392419338226318359375;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:1780670682.1399281024932861328125;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:1780670682.1400349140167236328125;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:1780670682.1404149532318115234375;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:14:42')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.140614986419677734375;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:14:42')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.141580104827880859375;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:1780670682.1417748928070068359375;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:1780670682.14231395721435546875;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:1780670682.142447948455810546875;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:1780670682.1427299976348876953125;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`='6984') AND (`channelpartner_id`=43245)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.142826080322265625;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`='6984') AND (`channelpartner_id`=43245)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1440699100494384765625;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 (6984, 43245, '2026-06-05 20:14:42', 7458, 1, '2026-06-05 20:14:42', '2026-06-05 20:14:42')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1443059444427490234375;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 (6984, 43245, '2026-06-05 20:14:42', 7458, 1, '2026-06-05 20:14:42', '2026-06-05 20:14:42')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1453330516815185546875;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:1780670682.145536899566650390625;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:1780670682.1461029052734375;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:1780670682.1462249755859375;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:1780670682.14649105072021484375;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:14:42')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1467239856719970703125;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:14:42')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1483829021453857421875;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:1780670682.1485950946807861328125;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:1780670682.14910793304443359375;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:1780670682.149250030517578125;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:1780670682.1495130062103271484375;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 (293361, 6984, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '2026-06-05 20:14:42', 1)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1497418880462646484375;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 (293361, 6984, 'CP Interest Alert!', 'A CP just viewed your project details.\nConnect now to engage and convert the opportunity.', '', '2026-06-05 20:14:42', 1)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1515080928802490234375;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`='6984')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1517250537872314453125;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`='6984')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1519489288330078125;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:7614752;}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:1780670682.152017116546630859375;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:7619632;}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:1780670682.152473926544189453125;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:7629184;}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:1780670682.152576923370361328125;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:7631080;}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:1780670682.1528260707855224609375;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:7633288;}i:113;a:6:{i:0;s:135:"SELECT GROUP_CONCAT(DISTINCT location_id ORDER BY location_id) AS loc FROM `projects` WHERE `id` IN ('400', '401', '405', '411', '413')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1537380218505859375;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:7704960;}i:114;a:6:{i:0;s:135:"SELECT GROUP_CONCAT(DISTINCT location_id ORDER BY location_id) AS loc FROM `projects` WHERE `id` IN ('400', '401', '405', '411', '413')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780670682.1541659832000732421875;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:7706688;}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:1780670682.1544868946075439453125;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:7747112;}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:1780670682.155250072479248046875;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:7829096;}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:1780670682.1556890010833740234375;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:7795104;}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:1780670682.1559889316558837890625;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:7797312;}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:1780670682.156169891357421875;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:7803136;}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:1780670682.156507015228271484375;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:7818752;}i:125;a:6:{i:0;s:92:"UPDATE `channelpartner` SET `location_id`='3,8,29,33,50,56,128,134,176,179' WHERE `id`=43245";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.156896114349365234375;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:7830304;}i:126;a:6:{i:0;s:92:"UPDATE `channelpartner` SET `location_id`='3,8,29,33,50,56,128,134,176,179' WHERE `id`=43245";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780670682.1572740077972412109375;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:7831600;}}}";s:5:"event";s:12382:"a:64:{i:0;a:5:{s:4:"time";d:1780670682.0859720706939697265625;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:1780670682.0938670635223388671875;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:1780670682.0980761051177978515625;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:1780670682.1192529201507568359375;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:1780670682.1193039417266845703125;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:1780670682.11937999725341796875;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:1780670682.12127399444580078125;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:1780670682.121285915374755859375;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:1780670682.1218860149383544921875;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:1780670682.121984004974365234375;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:1780670682.12333202362060546875;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:1780670682.12339496612548828125;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:1780670682.123403072357177734375;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:1780670682.1243419647216796875;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:1780670682.1262969970703125;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:1780670682.126306056976318359375;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:1780670682.1275050640106201171875;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:1780670682.127582073211669921875;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:1780670682.138576984405517578125;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:1780670682.138616085052490234375;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:1780670682.1386311054229736328125;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:1780670682.138751983642578125;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:1780670682.138760089874267578125;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:1780670682.1390779018402099609375;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:1780670682.1392040252685546875;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:1780670682.140450954437255859375;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:1780670682.1405429840087890625;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:1780670682.140551090240478515625;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:1780670682.1416079998016357421875;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:1780670682.141726016998291015625;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:1780670682.144095897674560546875;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:1780670682.1441729068756103515625;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:1780670682.1442310810089111328125;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:1780670682.144237995147705078125;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:1780670682.145359039306640625;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:1780670682.1454830169677734375;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:1780670682.1465399265289306640625;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:1780670682.1466350555419921875;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:1780670682.1466419696807861328125;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:1780670682.1484100818634033203125;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:1780670682.1485579013824462890625;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:1780670682.14955997467041015625;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:1780670682.1496639251708984375;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:1780670682.149672031402587890625;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:1780670682.1515419483184814453125;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:1780670682.1516540050506591796875;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:1780670682.1519730091094970703125;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:1780670682.15285396575927734375;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:1780670682.153048992156982421875;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:1780670682.1544330120086669921875;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:1780670682.1565380096435546875;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:1780670682.1565930843353271484375;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:1780670682.1566131114959716796875;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:1780670682.1567840576171875;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:1780670682.1567919254302978515625;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:1780670682.1573030948638916015625;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:1780670682.1724889278411865234375;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:1780670682.1725471019744873046875;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:1780670682.1725559234619140625;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:1780670682.1725618839263916015625;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:1780670682.1725709438323974609375;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:1780670682.1725780963897705078125;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:1780670682.1728839874267578125;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:1780670682.172956943511962890625;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:119:"a:3:{s:5:"start";d:1780670682.05826091766357421875;s:3:"end";d:1780670682.1751461029052734375;s:6:"memory";i:11722472;}";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:1780670682.0864078998565673828125;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:1780670682.0864670276641845703125;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:1780670682.0865008831024169921875;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:1780670682.086513042449951171875;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:1780670682.086555004119873046875;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:1780670682.086566925048828125;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:1780670682.086575984954833984375;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:1780670682.08658599853515625;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:1780670682.086594104766845703125;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:1780670682.086605072021484375;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:1780670682.0866138935089111328125;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:1780670682.0866229534149169921875;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:1780670682.0866310596466064453125;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:1780670682.086638927459716796875;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:1780670682.08664798736572265625;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:1780670682.086656093597412109375;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:1780670682.08666706085205078125;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:1780670682.0866758823394775390625;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:1780670682.0866920948028564453125;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:1780670682.086699962615966796875;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:1780670682.08671092987060546875;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:1780670682.0867140293121337890625;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:3073:"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 ":"411","sm_cp_id":"6984","type":"1"}";s:7:"Decoded";a:3:{s:11:"project_id ";s:3:"411";s:8:"sm_cp_id";s:4:"6984";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:"aiLg2flgOjGQAhR_xkDCQwAAAAI";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:"37230";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:"aiLg2flgOjGQAhR_xkDCQwAAAAI";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1780670682.050952911376953125;s:12:"REQUEST_TIME";i:1780670682;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:"6a22e0da13c8f";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:1780670682.050952911376953125;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:11722472;s:14:"processingTime";d:0.1166169643402099609375;}s:10:"exceptions";a:0:{}}