
[2026-11-13 Fri 02:02:48] : *********************** START **************************
[2026-11-13 Fri 02:02:48] : select id, status_code from status_code where status='Active'
[2026-11-13 Fri 02:02:48] : Status Code Result: 2
[2026-11-13 Fri 02:02:48] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-13 Fri 02:02:48] : App Info Result: 4
[2026-11-13 Fri 02:02:48] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:48] : Batch ID: 2026-11-13 02:02:48#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-13 Fri 02:02:48] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:48] : Misc Test: 2026-11-13 02:02:48#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 02:02:48] : APP_VERSION
[2026-11-13 Fri 02:02:48] : 
[2026-11-13 Fri 02:02:48] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,2,'','2026-11-13 02:02:48#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-13','2026-11-13 02:02:48','2026-11-13 02:02:48','get-app-info.php')
[2026-11-13 Fri 02:02:48] : 1
[2026-11-13 Fri 02:02:48] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:48] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:48] : Misc Test: 2026-11-13 02:02:48#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 02:02:48] : APP_LAST_UPDATE
[2026-11-13 Fri 02:02:49] : 2026-11-05
[2026-11-13 Fri 02:02:49] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,5,'2026-11-05','2026-11-13 02:02:48#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-13','2026-11-13 02:02:48','2026-11-13 02:02:48','get-app-info.php')
[2026-11-13 Fri 02:02:49] : 1
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : Batch ID: 2026-11-13 02:02:48#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : Misc Test: 2026-11-13 02:02:48#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 02:02:49] : APP_VERSION
[2026-11-13 Fri 02:02:49] : 
[2026-11-13 Fri 02:02:49] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,2,'','2026-11-13 02:02:48#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-13','2026-11-13 02:02:48','2026-11-13 02:02:48','get-app-info.php')
[2026-11-13 Fri 02:02:49] : 1
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : Misc Test: 2026-11-13 02:02:48#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 02:02:49] : APP_LAST_UPDATE
[2026-11-13 Fri 02:02:49] : 2026-09-09
[2026-11-13 Fri 02:02:49] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,5,'2026-09-09','2026-11-13 02:02:48#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-13','2026-11-13 02:02:48','2026-11-13 02:02:48','get-app-info.php')
[2026-11-13 Fri 02:02:49] : 1
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : Batch ID: 2026-11-13 02:02:48#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : Misc Test: 2026-11-13 02:02:48#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 02:02:49] : APP_VERSION
[2026-11-13 Fri 02:02:49] : 
[2026-11-13 Fri 02:02:49] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,2,'','2026-11-13 02:02:48#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-13','2026-11-13 02:02:48','2026-11-13 02:02:48','get-app-info.php')
[2026-11-13 Fri 02:02:49] : 1
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:49] : Misc Test: 2026-11-13 02:02:48#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 02:02:49] : APP_LAST_UPDATE
[2026-11-13 Fri 02:02:50] : --00
[2026-11-13 Fri 02:02:50] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,5,'--00','2026-11-13 02:02:48#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-13','2026-11-13 02:02:48','2026-11-13 02:02:48','get-app-info.php')
[2026-11-13 Fri 02:02:50] : 1
[2026-11-13 Fri 02:02:50] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:50] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:50] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:50] : Batch ID: 2026-11-13 02:02:48#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-13 Fri 02:02:50] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:50] : Misc Test: 2026-11-13 02:02:48#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 02:02:50] : APP_VERSION
[2026-11-13 Fri 02:02:50] : 
[2026-11-13 Fri 02:02:50] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,2,'','2026-11-13 02:02:48#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-13','2026-11-13 02:02:48','2026-11-13 02:02:48','get-app-info.php')
[2026-11-13 Fri 02:02:50] : 1
[2026-11-13 Fri 02:02:50] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:50] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:50] : Misc Test: 2026-11-13 02:02:48#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 02:02:50] : APP_LAST_UPDATE
[2026-11-13 Fri 02:02:50] : --00
[2026-11-13 Fri 02:02:50] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,5,'--00','2026-11-13 02:02:48#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-13','2026-11-13 02:02:48','2026-11-13 02:02:48','get-app-info.php')
[2026-11-13 Fri 02:02:50] : 1
[2026-11-13 Fri 02:02:50] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:50] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 02:02:50] : Connection closed
[2026-11-13 Fri 02:02:50] : ************************ END ***************************
[2026-11-13 Fri 05:00:05] : *********************** START **************************
[2026-11-13 Fri 05:00:05] : select id, status_code from status_code where status='Active'
[2026-11-13 Fri 05:00:05] : Status Code Result: 2
[2026-11-13 Fri 05:00:05] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-13 Fri 05:00:05] : App Info Result: 4
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : Batch ID: 2026-11-13 05:00:05#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : Misc Test: 2026-11-13 05:00:05#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 05:00:05] : APP_VERSION
[2026-11-13 Fri 05:00:05] : 
[2026-11-13 Fri 05:00:05] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,2,'','2026-11-13 05:00:05#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-13','2026-11-13 05:00:05','2026-11-12 23:00:05','get-app-info.php')
[2026-11-13 Fri 05:00:05] : 1
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : Misc Test: 2026-11-13 05:00:05#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 05:00:05] : APP_LAST_UPDATE
[2026-11-13 Fri 05:00:05] : 2026-11-05
[2026-11-13 Fri 05:00:05] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,5,'2026-11-05','2026-11-13 05:00:05#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-13','2026-11-13 05:00:05','2026-11-12 23:00:05','get-app-info.php')
[2026-11-13 Fri 05:00:05] : 1
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : Batch ID: 2026-11-13 05:00:05#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : Misc Test: 2026-11-13 05:00:05#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 05:00:05] : APP_VERSION
[2026-11-13 Fri 05:00:05] : 
[2026-11-13 Fri 05:00:05] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,2,'','2026-11-13 05:00:05#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-13','2026-11-13 05:00:05','2026-11-12 23:00:05','get-app-info.php')
[2026-11-13 Fri 05:00:05] : 1
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : Misc Test: 2026-11-13 05:00:05#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 05:00:05] : APP_LAST_UPDATE
[2026-11-13 Fri 05:00:05] : 2026-09-09
[2026-11-13 Fri 05:00:05] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,5,'2026-09-09','2026-11-13 05:00:05#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-13','2026-11-13 05:00:05','2026-11-12 23:00:05','get-app-info.php')
[2026-11-13 Fri 05:00:05] : 1
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : Batch ID: 2026-11-13 05:00:05#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-13 Fri 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:05] : Misc Test: 2026-11-13 05:00:05#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 05:00:05] : APP_VERSION
[2026-11-13 Fri 05:00:06] : 
[2026-11-13 Fri 05:00:06] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,2,'','2026-11-13 05:00:05#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-13','2026-11-13 05:00:05','2026-11-12 23:00:05','get-app-info.php')
[2026-11-13 Fri 05:00:06] : 1
[2026-11-13 Fri 05:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:06] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:06] : Misc Test: 2026-11-13 05:00:05#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 05:00:06] : APP_LAST_UPDATE
[2026-11-13 Fri 05:00:06] : --00
[2026-11-13 Fri 05:00:06] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,5,'--00','2026-11-13 05:00:05#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-13','2026-11-13 05:00:05','2026-11-12 23:00:05','get-app-info.php')
[2026-11-13 Fri 05:00:06] : 1
[2026-11-13 Fri 05:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:06] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:06] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:06] : Batch ID: 2026-11-13 05:00:05#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-13 Fri 05:00:06] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:06] : Misc Test: 2026-11-13 05:00:05#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 05:00:06] : APP_VERSION
[2026-11-13 Fri 05:00:06] : 
[2026-11-13 Fri 05:00:06] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,2,'','2026-11-13 05:00:05#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-13','2026-11-13 05:00:05','2026-11-12 23:00:05','get-app-info.php')
[2026-11-13 Fri 05:00:06] : 1
[2026-11-13 Fri 05:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:06] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:06] : Misc Test: 2026-11-13 05:00:05#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 05:00:06] : APP_LAST_UPDATE
[2026-11-13 Fri 05:00:06] : --00
[2026-11-13 Fri 05:00:06] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,5,'--00','2026-11-13 05:00:05#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-13','2026-11-13 05:00:05','2026-11-12 23:00:05','get-app-info.php')
[2026-11-13 Fri 05:00:06] : 1
[2026-11-13 Fri 05:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:06] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 05:00:06] : Connection closed
[2026-11-13 Fri 05:00:06] : ************************ END ***************************
[2026-11-13 Fri 07:00:04] : *********************** START Send Deviation Alert**************************
[2026-11-13 Fri 07:00:04] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-13'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-12'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-13 Fri 07:00:04] : Total Record Fetch: 8
[2026-11-13 Fri 07:00:04] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-13 Fri 07:00:05] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: ó%Ô„\Ì_èyl. ]á«ò7÷ö¾'z§Ò^Ã<a‰âz0ÙWè•”€
,OÖuñ¿•8ZvàQºG§HÄ‚\3ÊÅcËñ¯­š¤ˆ?ÚÊŒ|õé¿½Õ¾—öÔj-ýà‰íÔË¾æ´ÝD�ƒý°„ÁþKÄcÐ4 ¢ad7"6ÎÀ=z‰{Md!Tp—Ú‘·\ô$$µ:5º¿·ö%ÄÅêaïæÇmõâ/{l‚p‘Ck§+±gx-/±¢Ñôˆåïi4€…"
ü=3s—·¾I¥–“­È™B� ûÝ¶˜"Ñ^ ÖÃÅ‹w™Ú@°Y*]-©ŸÅÊ-±ŒŽ2ÆôÐÓ"ÏÅ¬‰Æßc˜—ˆYûÒ²çá’C´}>j EZ±P@Ó×üñ#2e™þZ?gx`�+Ð�Ikb:V÷µX‡�H �Ÿp¡­Ùa¡<‹çœ2eÇ„§²r?ïÉ¹Ï221 pink.dnsnetservice.com closing connection

[2026-11-13 Fri 07:00:05] : Connection closed
[2026-11-13 Fri 07:00:05] : ************************ END ***************************
[2026-11-13 Fri 10:43:21] : *********************** START **************************
[2026-11-13 Fri 10:43:21] : select id, status_code from status_code where status='Active'
[2026-11-13 Fri 10:43:21] : Status Code Result: 2
[2026-11-13 Fri 10:43:21] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-13 Fri 10:43:21] : App Info Result: 4
[2026-11-13 Fri 10:43:21] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:21] : Batch ID: 2026-11-13 10:43:21#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-13 Fri 10:43:21] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:21] : Misc Test: 2026-11-13 10:43:21#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 10:43:21] : APP_VERSION
[2026-11-13 Fri 10:43:21] : 
[2026-11-13 Fri 10:43:21] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,2,'','2026-11-13 10:43:21#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-13','2026-11-13 10:43:21','2026-11-13 10:43:21','get-app-info.php')
[2026-11-13 Fri 10:43:21] : 1
[2026-11-13 Fri 10:43:21] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:21] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:21] : Misc Test: 2026-11-13 10:43:21#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 10:43:21] : APP_LAST_UPDATE
[2026-11-13 Fri 10:43:21] : 2026-11-05
[2026-11-13 Fri 10:43:21] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,5,'2026-11-05','2026-11-13 10:43:21#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-13','2026-11-13 10:43:21','2026-11-13 10:43:21','get-app-info.php')
[2026-11-13 Fri 10:43:21] : 1
[2026-11-13 Fri 10:43:21] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:21] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:21] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:21] : Batch ID: 2026-11-13 10:43:21#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-13 Fri 10:43:21] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:21] : Misc Test: 2026-11-13 10:43:21#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 10:43:21] : APP_VERSION
[2026-11-13 Fri 10:43:22] : 
[2026-11-13 Fri 10:43:22] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,2,'','2026-11-13 10:43:21#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-13','2026-11-13 10:43:21','2026-11-13 10:43:21','get-app-info.php')
[2026-11-13 Fri 10:43:22] : 1
[2026-11-13 Fri 10:43:22] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:22] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:22] : Misc Test: 2026-11-13 10:43:21#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 10:43:22] : APP_LAST_UPDATE
[2026-11-13 Fri 10:43:22] : 2026-09-09
[2026-11-13 Fri 10:43:22] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,5,'2026-09-09','2026-11-13 10:43:21#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-13','2026-11-13 10:43:21','2026-11-13 10:43:21','get-app-info.php')
[2026-11-13 Fri 10:43:22] : 1
[2026-11-13 Fri 10:43:22] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:22] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:22] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:22] : Batch ID: 2026-11-13 10:43:21#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-13 Fri 10:43:22] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:22] : Misc Test: 2026-11-13 10:43:21#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 10:43:22] : APP_VERSION
[2026-11-13 Fri 10:43:22] : *********************** START Data Parsing Error Checker**************************
[2026-11-13 Fri 10:43:22] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-13'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-13 Fri 10:43:22] : Total Record Fetch: 20
[2026-11-13 Fri 10:43:22] : 2026-11-13 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 02:02:48 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 02:02:48 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 02:02:48 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 02:02:48 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 10:43:21 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 02:02:48 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 10:43:21 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 02:02:48 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 10:43:21 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 02:02:48 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 10:43:21 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:22] : 2026-11-13 02:02:48 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:22] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-13 Fri 10:43:22] : Connection closed
[2026-11-13 Fri 10:43:22] : ************************ END ***************************
[2026-11-13 Fri 10:43:23] : *********************** START Send Deviation Alert**************************
[2026-11-13 Fri 10:43:23] : 
[2026-11-13 Fri 10:43:23] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,2,'','2026-11-13 10:43:21#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-13','2026-11-13 10:43:21','2026-11-13 10:43:21','get-app-info.php')
[2026-11-13 Fri 10:43:23] : 1
[2026-11-13 Fri 10:43:23] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:23] : Misc Test: 2026-11-13 10:43:21#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 10:43:23] : APP_LAST_UPDATE
[2026-11-13 Fri 10:43:23] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-13'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-12'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-13 Fri 10:43:23] : Total Record Fetch: 8
[2026-11-13 Fri 10:43:23] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-13 Fri 10:43:23] : *********************** START Send Deviation Alert**************************
[2026-11-13 Fri 10:43:23] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-13'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-12'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-13 Fri 10:43:23] : Total Record Fetch: 8
[2026-11-13 Fri 10:43:23] : <table width="200" border="1" cellspacing="0" cellpadding="0" style="border: 1px solid #000;font-family: Cambria, 'Hoefler Text', 'Liberation Serif', Times, 'Times New Roman', 'serif';font-size: 14px;">
  <tbody style="border: 1px solid #000;">
    <tr>
      <th style="width: 30px">SL</th>
      <th style="width: 180px">App Store</th>
      <th style="width: 300px">App Name</th>
	  <th style="width: 225px">App Organization</th>
	  <th style="width: 160px">App Status Type</th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #00FFFF">2026-11-13</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-12</span></th>
	  <th style="width: 160px">Deviation Status</th>
    </tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">1</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">4</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">5</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-09-09</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-09-09</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">6</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">7</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-11-05</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-11-05</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">8</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr></tbody></table>
[2026-11-13 Fri 10:43:23] : --00
[2026-11-13 Fri 10:43:23] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,5,'--00','2026-11-13 10:43:21#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-13','2026-11-13 10:43:21','2026-11-13 10:43:21','get-app-info.php')
[2026-11-13 Fri 10:43:23] : 1
[2026-11-13 Fri 10:43:23] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:23] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:23] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:23] : Batch ID: 2026-11-13 10:43:21#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-13 Fri 10:43:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:23] : Misc Test: 2026-11-13 10:43:21#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 10:43:23] : APP_VERSION
[2026-11-13 Fri 10:43:23] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: ñœ‚c–†Í8ô§p¯wÿè.¡R­9À›B'©$¨“ðÎ	3Fô·B%×ròf	zƒ@—U©˜¤H�"8…ÌÃU-OJ“ÞºÔSlèÁ~Ÿã•ß�ƒº¯ñ}ÛRA—�ÿüÆÏ±u»¦ËoãûÕ«÷•ÈúÊ§¥àË@í�+šCá�z'pœZŠàáRÑ/Xp~©ƒµí	ùì°&é"´ŒM‡)°7‰û&êÖd÷�cÇ¨ÁiKe±Ö„Ùnc‚�gp›„£ÉWìšÀ«Dÿ%G`€ü™QÜ>Ö÷¢øÍòKŠ—-Ûµ3[m¨¬VÐ»ˆœŽ=¥ •bâ:‘¿Ë�…}o?
*„Õ¹ø‡åí&VÃ—6ª1 E‚rSKG�O¢éŒ»¯u!¿û‘¢�¨§'‡-T 6‰s/–&ä¤þ´’³€j÷åPbXvþ¸%P“>¥tSX@-{D¹í±ä221 pink.dnsnetservice.com closing connection

[2026-11-13 Fri 10:43:23] : Connection closed
[2026-11-13 Fri 10:43:23] : ************************ END ***************************
[2026-11-13 Fri 10:43:23] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-13 Fri 10:43:23] : Connection closed
[2026-11-13 Fri 10:43:23] : ************************ END ***************************
[2026-11-13 Fri 10:43:24] : 
[2026-11-13 Fri 10:43:24] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,2,'','2026-11-13 10:43:21#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-13','2026-11-13 10:43:21','2026-11-13 10:43:21','get-app-info.php')
[2026-11-13 Fri 10:43:24] : 1
[2026-11-13 Fri 10:43:24] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:24] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:24] : Misc Test: 2026-11-13 10:43:21#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 10:43:24] : APP_LAST_UPDATE
[2026-11-13 Fri 10:43:24] : *********************** START Data Parsing Error Checker**************************
[2026-11-13 Fri 10:43:24] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-13'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-13 Fri 10:43:24] : --00
[2026-11-13 Fri 10:43:24] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,5,'--00','2026-11-13 10:43:21#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-13','2026-11-13 10:43:21','2026-11-13 10:43:21','get-app-info.php')
[2026-11-13 Fri 10:43:24] : 1
[2026-11-13 Fri 10:43:24] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:24] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:24] : Connection closed
[2026-11-13 Fri 10:43:24] : ************************ END ***************************
[2026-11-13 Fri 10:43:24] : Total Record Fetch: 23
[2026-11-13 Fri 10:43:24] : 2026-11-13 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 02:02:48 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 10:43:21 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 02:02:48 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 10:43:21 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 02:02:48 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 10:43:21 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 02:02:48 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 10:43:21 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 02:02:48 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 10:43:21 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 02:02:48 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 10:43:21 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 02:02:48 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 10:43:21 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : 2026-11-13 02:02:48 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:24] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-13 Fri 10:43:24] : Connection closed
[2026-11-13 Fri 10:43:24] : ************************ END ***************************
[2026-11-13 Fri 10:43:30] : *********************** START **************************
[2026-11-13 Fri 10:43:30] : select id, status_code from status_code where status='Active'
[2026-11-13 Fri 10:43:30] : Status Code Result: 2
[2026-11-13 Fri 10:43:30] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-13 Fri 10:43:30] : App Info Result: 4
[2026-11-13 Fri 10:43:30] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:30] : Batch ID: 2026-11-13 10:43:30#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-13 Fri 10:43:30] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:30] : Misc Test: 2026-11-13 10:43:30#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 10:43:30] : APP_VERSION
[2026-11-13 Fri 10:43:31] : 
[2026-11-13 Fri 10:43:31] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,2,'','2026-11-13 10:43:30#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-13','2026-11-13 10:43:30','2026-11-13 10:43:30','get-app-info.php')
[2026-11-13 Fri 10:43:31] : 1
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : Misc Test: 2026-11-13 10:43:30#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 10:43:31] : APP_LAST_UPDATE
[2026-11-13 Fri 10:43:31] : 2026-11-05
[2026-11-13 Fri 10:43:31] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,5,'2026-11-05','2026-11-13 10:43:30#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-13','2026-11-13 10:43:30','2026-11-13 10:43:30','get-app-info.php')
[2026-11-13 Fri 10:43:31] : 1
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : Batch ID: 2026-11-13 10:43:30#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : Misc Test: 2026-11-13 10:43:30#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 10:43:31] : APP_VERSION
[2026-11-13 Fri 10:43:31] : 
[2026-11-13 Fri 10:43:31] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,2,'','2026-11-13 10:43:30#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-13','2026-11-13 10:43:30','2026-11-13 10:43:30','get-app-info.php')
[2026-11-13 Fri 10:43:31] : 1
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : Misc Test: 2026-11-13 10:43:30#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 10:43:31] : APP_LAST_UPDATE
[2026-11-13 Fri 10:43:31] : 2026-09-09
[2026-11-13 Fri 10:43:31] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,5,'2026-09-09','2026-11-13 10:43:30#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-13','2026-11-13 10:43:30','2026-11-13 10:43:30','get-app-info.php')
[2026-11-13 Fri 10:43:31] : 1
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : Batch ID: 2026-11-13 10:43:30#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : Misc Test: 2026-11-13 10:43:30#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 10:43:31] : APP_VERSION
[2026-11-13 Fri 10:43:31] : *********************** START Data Parsing Error Checker**************************
[2026-11-13 Fri 10:43:31] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-13'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-13 Fri 10:43:31] : Total Record Fetch: 28
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:21 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 02:02:48 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:21 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 02:02:48 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:21 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 02:02:48 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:21 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 02:02:48 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:30 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:21 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 02:02:48 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:30 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:21 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 02:02:48 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:30 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:21 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 02:02:48 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:30 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 10:43:21 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : 2026-11-13 02:02:48 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:31] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-13 Fri 10:43:31] : Connection closed
[2026-11-13 Fri 10:43:31] : ************************ END ***************************
[2026-11-13 Fri 10:43:31] : 
[2026-11-13 Fri 10:43:31] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,2,'','2026-11-13 10:43:30#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-13','2026-11-13 10:43:30','2026-11-13 10:43:30','get-app-info.php')
[2026-11-13 Fri 10:43:31] : 1
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : Misc Test: 2026-11-13 10:43:30#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 10:43:31] : APP_LAST_UPDATE
[2026-11-13 Fri 10:43:31] : --00
[2026-11-13 Fri 10:43:31] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,5,'--00','2026-11-13 10:43:30#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-13','2026-11-13 10:43:30','2026-11-13 10:43:30','get-app-info.php')
[2026-11-13 Fri 10:43:31] : 1
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : Batch ID: 2026-11-13 10:43:30#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-13 Fri 10:43:31] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:31] : Misc Test: 2026-11-13 10:43:30#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 10:43:31] : APP_VERSION
[2026-11-13 Fri 10:43:32] : 
[2026-11-13 Fri 10:43:32] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,2,'','2026-11-13 10:43:30#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-13','2026-11-13 10:43:30','2026-11-13 10:43:30','get-app-info.php')
[2026-11-13 Fri 10:43:32] : 1
[2026-11-13 Fri 10:43:32] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:32] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:32] : Misc Test: 2026-11-13 10:43:30#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 10:43:32] : APP_LAST_UPDATE
[2026-11-13 Fri 10:43:32] : *********************** START Data Parsing Error Checker**************************
[2026-11-13 Fri 10:43:32] : *********************** START Send Deviation Alert**************************
[2026-11-13 Fri 10:43:32] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-13'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-12'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-13 Fri 10:43:32] : --00
[2026-11-13 Fri 10:43:32] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,5,'--00','2026-11-13 10:43:30#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-13','2026-11-13 10:43:30','2026-11-13 10:43:30','get-app-info.php')
[2026-11-13 Fri 10:43:32] : 1
[2026-11-13 Fri 10:43:32] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:32] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 10:43:32] : Connection closed
[2026-11-13 Fri 10:43:32] : ************************ END ***************************
[2026-11-13 Fri 10:43:32] : Total Record Fetch: 8
[2026-11-13 Fri 10:43:32] : <table width="200" border="1" cellspacing="0" cellpadding="0" style="border: 1px solid #000;font-family: Cambria, 'Hoefler Text', 'Liberation Serif', Times, 'Times New Roman', 'serif';font-size: 14px;">
  <tbody style="border: 1px solid #000;">
    <tr>
      <th style="width: 30px">SL</th>
      <th style="width: 180px">App Store</th>
      <th style="width: 300px">App Name</th>
	  <th style="width: 225px">App Organization</th>
	  <th style="width: 160px">App Status Type</th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #00FFFF">2026-11-13</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-12</span></th>
	  <th style="width: 160px">Deviation Status</th>
    </tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">1</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">4</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">5</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-09-09</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-09-09</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">6</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">7</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-11-05</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-11-05</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">8</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr></tbody></table>
[2026-11-13 Fri 10:43:32] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-13 Fri 10:43:32] : Connection closed
[2026-11-13 Fri 10:43:32] : ************************ END ***************************
[2026-11-13 Fri 10:43:33] : *********************** START Send Deviation Alert**************************
[2026-11-13 Fri 10:43:33] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-13'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-12'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-13 Fri 10:43:33] : Total Record Fetch: 8
[2026-11-13 Fri 10:43:33] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-13 Fri 10:43:33] : *********************** START Data Parsing Error Checker**************************
[2026-11-13 Fri 10:43:33] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-13'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-13 Fri 10:43:33] : Total Record Fetch: 32
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:30 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:21 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 02:02:48 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:30 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:21 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 02:02:48 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:30 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:21 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 02:02:48 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:30 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:21 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 02:02:48 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:30 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:21 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 02:02:48 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:30 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:21 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 02:02:48 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:30 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:21 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 02:02:48 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:30 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 10:43:21 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : 2026-11-13 02:02:48 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-13 Fri 10:43:33] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-13 Fri 10:43:33] : Connection closed
[2026-11-13 Fri 10:43:33] : ************************ END ***************************
[2026-11-13 Fri 10:43:33] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: <øU!“;z¤°ûÔ’#çŸ�':CJFŒ˜Ž³DHUø@Èø*˜�ÅÍ[8±¼­óHp &¦ø?•9û��>)“Üf(˜Œ,7ù­÷9ûN‹£Nùƒ_xMšì/‘±ë7dÞ¨é«ÐHùÐîv$N´^vk"¿¿1µOJIÞLr²îL¨öð3E>à09•{ø¨À¥^ŸBv~É6Áaó|Œ%* ¾§bä¦, ¨{€¾^M²úv´'®
}_õñ+"bŽðÌ-Ð.s~¦ô
”E+~E±²êÔÿŸ°#:@³ßŠ¨už*âœRl€ÏÉ¯Ø=�å0�.ƒøá�ÃÜ×\æÂxS}Ø°¹ƒ EMfŸÝ$BàŽ`tžÃeËE‹ÜÈ ¾L¯p›_¤"$ŸÅò(NT!fä§”XI#…CÃãmv‹¢§ˆO‡lóæ˜8C³@âÅ221 pink.dnsnetservice.com closing connection

[2026-11-13 Fri 10:43:33] : Connection closed
[2026-11-13 Fri 10:43:33] : ************************ END ***************************
[2026-11-13 Fri 22:43:00] : *********************** START **************************
[2026-11-13 Fri 22:43:00] : select id, status_code from status_code where status='Active'
[2026-11-13 Fri 22:43:00] : Status Code Result: 2
[2026-11-13 Fri 22:43:00] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-13 Fri 22:43:00] : App Info Result: 4
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : Batch ID: 2026-11-13 22:43:00#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : Misc Test: 2026-11-13 22:43:00#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 22:43:00] : APP_VERSION
[2026-11-13 Fri 22:43:00] : 
[2026-11-13 Fri 22:43:00] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,2,'','2026-11-13 22:43:00#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-13','2026-11-13 22:43:00','2026-11-13 22:43:00','get-app-info.php')
[2026-11-13 Fri 22:43:00] : 1
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : Misc Test: 2026-11-13 22:43:00#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 22:43:00] : APP_LAST_UPDATE
[2026-11-13 Fri 22:43:00] : 2026-11-05
[2026-11-13 Fri 22:43:00] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,5,'2026-11-05','2026-11-13 22:43:00#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-13','2026-11-13 22:43:00','2026-11-13 22:43:00','get-app-info.php')
[2026-11-13 Fri 22:43:00] : 1
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : Batch ID: 2026-11-13 22:43:00#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : Misc Test: 2026-11-13 22:43:00#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 22:43:00] : APP_VERSION
[2026-11-13 Fri 22:43:00] : 
[2026-11-13 Fri 22:43:00] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,2,'','2026-11-13 22:43:00#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-13','2026-11-13 22:43:00','2026-11-13 22:43:00','get-app-info.php')
[2026-11-13 Fri 22:43:00] : 1
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : Misc Test: 2026-11-13 22:43:00#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 22:43:00] : APP_LAST_UPDATE
[2026-11-13 Fri 22:43:00] : 2026-09-09
[2026-11-13 Fri 22:43:00] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,5,'2026-09-09','2026-11-13 22:43:00#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-13','2026-11-13 22:43:00','2026-11-13 22:43:00','get-app-info.php')
[2026-11-13 Fri 22:43:00] : 1
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : Batch ID: 2026-11-13 22:43:00#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-13 Fri 22:43:00] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:00] : Misc Test: 2026-11-13 22:43:00#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 22:43:00] : APP_VERSION
[2026-11-13 Fri 22:43:01] : 
[2026-11-13 Fri 22:43:01] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,2,'','2026-11-13 22:43:00#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-13','2026-11-13 22:43:00','2026-11-13 22:43:00','get-app-info.php')
[2026-11-13 Fri 22:43:01] : 1
[2026-11-13 Fri 22:43:01] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:01] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:01] : Misc Test: 2026-11-13 22:43:00#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 22:43:01] : APP_LAST_UPDATE
[2026-11-13 Fri 22:43:01] : --00
[2026-11-13 Fri 22:43:01] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,5,'--00','2026-11-13 22:43:00#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-13','2026-11-13 22:43:00','2026-11-13 22:43:00','get-app-info.php')
[2026-11-13 Fri 22:43:01] : 1
[2026-11-13 Fri 22:43:01] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:01] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:01] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:01] : Batch ID: 2026-11-13 22:43:00#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-13 Fri 22:43:01] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:01] : Misc Test: 2026-11-13 22:43:00#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-13 Fri 22:43:01] : APP_VERSION
[2026-11-13 Fri 22:43:01] : 
[2026-11-13 Fri 22:43:01] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,2,'','2026-11-13 22:43:00#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-13','2026-11-13 22:43:00','2026-11-13 22:43:00','get-app-info.php')
[2026-11-13 Fri 22:43:01] : 1
[2026-11-13 Fri 22:43:01] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:01] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:01] : Misc Test: 2026-11-13 22:43:00#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-13 Fri 22:43:01] : APP_LAST_UPDATE
[2026-11-13 Fri 22:43:01] : --00
[2026-11-13 Fri 22:43:01] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,5,'--00','2026-11-13 22:43:00#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-13','2026-11-13 22:43:00','2026-11-13 22:43:00','get-app-info.php')
[2026-11-13 Fri 22:43:01] : 1
[2026-11-13 Fri 22:43:01] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:01] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-13 Fri 22:43:01] : Connection closed
[2026-11-13 Fri 22:43:01] : ************************ END ***************************