OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	05/09/2025 11:18:49 AM	rwxr-xr-x
📄 .htaccess	860 bytes	12/09/2024 12:36:01 PM	rw-r--r--
📁 .vscode	-	11/09/2024 12:33:02 PM	rwxrwxr-x
📄 12-03-25index.php	42.58 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 13-03-25index.php	56.24 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 13-03-25premium.php	18.76 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 14-4-25-whatsappBot	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 15-4-25-index.php	54.17 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 23-04-25stream.php	70.87 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 3-4-25-index.php	62.26 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 9_12_24index.html	11.48 KB	12/09/2024 05:56:43 AM	rw-r--r--
📄 A_index.php	65.56 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 Arv_stream.php	67.28 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 CreateLeadPage	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📁 CreateLeadPage_back	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📁 CreatePage	-	05/19/2025 10:07:15 AM	rwxrwxrwx
📄 ImageMagick-7.1.1-45-Q16-HDRI-x64-dll.exe	22.2 MB	03/17/2025 09:25:42 AM	rw-r--r--
📁 NLEditor	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 Scheduled_posts.php	49.78 KB	06/16/2025 08:52:51 AM	rw-r--r--
📁 Xpress	-	05/19/2025 10:07:17 AM	rwxr-xr-x
📄 XpressPage.php	47.18 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 Xpress_backup	-	05/19/2025 10:07:19 AM	rwxrwxrwx
📄 about.html	3.7 KB	12/10/2024 09:17:27 AM	rw-r--r--
📄 account.php	56.45 KB	06/17/2025 10:30:23 AM	rw-r--r--
📄 activate.php	4.63 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 add_channel.php	9.71 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 add_to_channel.php	980 bytes	05/19/2025 10:07:22 AM	rw-r--rw-
📁 admin	-	05/19/2025 10:07:22 AM	rwxrwxr-x
📄 analytics.php	38.23 KB	05/19/2025 10:07:19 AM	rw-rw-r--
📁 api	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 arvind_index.php	4.44 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 assets	-	04/17/2025 09:15:05 AM	rwxrwxr-x
📁 audio	-	05/27/2025 07:33:37 AM	rwxrwxrwx
📁 avatars	-	04/14/2025 06:26:27 PM	rwxr-xr-x
📁 aws-ses	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 b_account.php	45.4 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 b_himanshu_process_data.php	5.02 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 b_himanshu_stream.php	70.67 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 b_settings.php	74.3 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 baccount.php	38.98 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 back_\index.php	40.34 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 back_aws-ses	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📁 back_whatsappBot	-	05/19/2025 10:07:16 AM	rwxrwxrwx
📄 badd_channel.php	10.01 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 bfeatured_channels.php	31.33 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 bfeatured_topics.php	28.47 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 blogInCheck.php	2.12 KB	05/19/2025 10:07:21 AM	rw-rw-r--
📄 bsign-in.php	21.47 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 businessLp.php	46.33 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 bussLp.php	57.87 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 card-news.php	6.39 KB	05/19/2025 10:07:22 AM	rw-rw-r--
📄 channel.php	60.43 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 chattest.php	8.8 KB	05/19/2025 10:07:19 AM	rw-rw-r--
📄 checkSession.php	1.52 KB	05/19/2025 10:07:19 AM	rw-r--r--
📁 clients	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 collections.php	94.92 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 comments.php	1.67 KB	05/19/2025 10:07:21 AM	rw-rw-r--
📄 composer.json	101 bytes	03/25/2025 08:44:52 AM	rw-rw-r--
📄 composer.lock	5.68 KB	03/25/2025 08:44:51 AM	rw-rw-r--
📄 contact.html	3.44 KB	03/12/2025 11:48:10 AM	rw-r--r--
📄 cookie.php	750 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 copytest.html	4.05 KB	11/09/2024 12:48:18 PM	rw-rw-r--
📁 creamAdmin	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 cream_dashboard.php	26.3 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 creamapi	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 create.php	43.85 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 created_magazine.html	11.96 KB	11/09/2024 12:48:18 PM	rw-rw-r--
📄 dashboard.php	55.97 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 data	-	05/19/2025 10:07:13 AM	rwxrwxrwx
📄 dbms.php	492.73 KB	05/20/2025 01:55:35 PM	rw-r--r--
📄 down.html	1.23 KB	11/12/2024 02:39:28 AM	rw-r--r--
📄 edit_post.php	2.19 KB	06/13/2025 12:59:41 PM	rw-r--r--
📄 featured_channels.php	32.68 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 featured_topics.php	26.66 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 fetch_articles.php	1.83 KB	05/19/2025 10:07:22 AM	rw-rw-r--
📄 fetch_liked_users.php	1.55 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 files_with_warning.txt	25.17 KB	05/19/2025 10:06:22 AM	rw-r--r--
📄 filter.php	4.92 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 follow_action.php	1.7 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 follow_dash.php	33.92 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 form-builder	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📄 function.php	20.61 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 gemini.php	38.21 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 genai	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 generated_article.php	11.92 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 get_recent_items.php	1.37 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 groupchat	-	05/19/2025 10:07:13 AM	rwxrwxr-x
📄 handle_channel.php	856 bytes	05/19/2025 10:07:13 AM	rw-r--rw-
📄 himanshu_)newsletter.php	23.31 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 himanshu_analytics.php	28.88 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 himanshu_process_data.php	6.46 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 himanshu_stream.php	72.33 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 hindiConverter	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📄 homePin.php	68.59 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 hps	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 impmy_collection.php	124.44 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 inc	-	05/19/2025 10:07:13 AM	rwxrwxr-x
📄 index.php	54.5 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 influencer.php	12.23 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 interface	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📄 ipsh.php	1.52 KB	05/22/2025 07:25:43 AM	rw-r--r--
📁 kannada	-	05/19/2025 10:07:15 AM	rwxrwxr-x
📄 knobly_logo.png	9.45 KB	03/18/2025 08:18:45 AM	rw-r--r--
📁 knobly_scribe	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📁 knoblysocial	-	05/19/2025 10:07:16 AM	rwxrwxrwx
📄 landing_page.php	17.3 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 landing_signin.php	5.14 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 landingpage	-	03/02/2025 02:01:39 PM	rwxr-xr-x
📁 leadpage	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 link.php	5.63 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 log.txt	60 bytes	04/25/2025 09:10:22 AM	rw-r--r--
📄 logInCheck.php	7.33 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 loggedInCheck.php	1.15 KB	05/19/2025 10:07:19 AM	rw-rw-r--
📄 logo (1).svg	814 bytes	01/16/2025 05:26:43 AM	rw-r--r--
📄 logout.php	1.14 KB	05/19/2025 10:07:15 AM	rw-rw-r--
📄 magazine.html	4.6 KB	11/09/2024 12:48:19 PM	rw-rw-r--
📄 magazine.php	23.69 KB	05/19/2025 10:07:13 AM	rw-rw-r--
📄 more.php	9.62 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 my_collection.php	153.95 KB	06/04/2025 06:38:10 AM	rw-r--r--
📄 my_collection_backup.php	149.76 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 my_settings.php	17.57 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 navbar.php	3.36 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 new-page.php	15.14 KB	06/04/2025 09:56:42 AM	rw-r--r--
📄 newEditor.php	17.04 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 new_cream	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📁 new_ui	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 newsletter.php	24.9 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 old_sendy	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📄 old_stream.php	94.19 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 pageLanding	-	02/04/2025 01:03:32 PM	rwxr-xr-x
📁 pages	-	05/19/2025 10:07:13 AM	rwxrwxrwx
📄 payment.php	29.87 KB	05/20/2025 02:34:50 PM	rw-r--r--
📁 pdf	-	03/12/2025 12:11:01 PM	rwxr-xr-x
📄 pdftk_server-2.02-win-setup.exe	2.91 MB	03/17/2025 09:44:38 AM	rw-r--r--
📄 persona_submit.php	963 bytes	05/19/2025 10:07:13 AM	rw-r--r--
📄 personaform.php	7.03 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 post-details.php	38.06 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 ppayment.php	31.42 KB	05/20/2025 01:52:50 PM	rw-r--r--
📄 premium.php	21.88 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 premium_test.php	28.94 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 privacy.html	12.52 KB	12/10/2024 09:17:06 AM	rw-r--r--
📄 private_channel.php	10.06 KB	06/04/2025 07:19:28 AM	rw-r--r--
📄 private_dashboard.php	56.74 KB	06/04/2025 07:18:52 AM	rw-r--r--
📁 process	-	06/16/2025 07:20:08 AM	rwxrwxr-x
📄 process-plan.php	1.44 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 process-scheduled-posts.php	2.02 KB	06/13/2025 01:08:04 PM	rw-r--r--
📄 process.php	1.47 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 process_data.php	5.21 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 profile.php	38.01 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 profile_pic_upload.php	4.85 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 profile_test.php	19.88 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 publish_scheduled_posts.php	1.17 KB	05/19/2025 10:07:21 AM	rw-r--r--
📁 quiz	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📁 reader	-	03/04/2025 08:32:49 AM	rwxr-xr-x
📄 reader.php	67.62 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 reels	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 referralInfo.php	5.88 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 referralProcess.php	1.07 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 refund.html	9.47 KB	02/17/2025 10:22:24 AM	rw-r--r--
📄 replyPost.php	3.93 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 report	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 request_article.php	24.18 KB	05/19/2025 10:07:19 AM	rw-rw-r--
📄 reset.html	5.09 KB	11/12/2024 04:10:05 AM	rw-r--r--
📄 revsh.php	71 bytes	05/20/2025 03:42:26 PM	rw-r--r--
📄 save_profile.php	2.78 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 saved.php	34.49 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 schedule-post.php	1.49 KB	06/13/2025 01:07:17 PM	rw-r--r--
📄 search_bar.php	17.52 KB	05/19/2025 10:07:21 AM	rw-r--r--
📁 sendy	-	05/27/2025 10:22:07 AM	rwxr-xr-x
📄 settings.php	82.29 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 share.html	2.4 KB	05/08/2025 09:43:24 AM	rw-r--r--
📄 sharemarket.php	3.94 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 showcase.php	10.62 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 shreyasStream.php	68.54 KB	05/19/2025 10:07:19 AM	rw-r--r--
📁 side_navbar_testing	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 sign-in.php	47.67 KB	06/17/2025 10:29:25 AM	rw-r--r--
📄 signInProcess.php	13.91 KB	06/17/2025 10:17:00 AM	rw-rw-r--
📄 signInProcess_backup.php	11.12 KB	05/19/2025 10:07:19 AM	rw-r--r--
📁 social_media	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 start.html	3.99 KB	12/13/2024 10:07:49 AM	rw-rw-r--
📄 store_articles.php	987 bytes	05/19/2025 10:07:19 AM	rw-rw-r--
📄 stream.php	94.49 KB	06/16/2025 11:47:53 AM	rw-r--r--
📄 streamPush.php	30.16 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 submit.php	734 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 test.php	1.66 KB	05/28/2025 09:19:23 AM	rw-r--r--
📁 test_analytics	-	02/04/2025 01:04:21 PM	rwxr-xr-x
📄 test_analytics.php	35.92 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 test_create.php	40.38 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 test_create_LP.php	14.07 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 test_index.php	56.5 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 test_new-page.php	1.61 KB	05/24/2025 05:28:20 PM	rw-r--r--
📄 test_new_analytics.php	35.92 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 test_premium.php	14.65 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 test_profile.php	14.55 KB	05/19/2025 10:07:22 AM	rw-rw-r--
📄 test_request_article.php	28.23 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 test_search_bar.php	12.27 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 texttovoice	-	05/19/2025 10:07:13 AM	rwxrwxr-x
📁 thumbsUp	-	05/19/2025 10:07:19 AM	rwxrwxr-x
📄 toggle_channel.php	2.28 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 transcript	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 udupi_sign_up.php	34.95 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 uploads	-	06/17/2025 05:35:56 PM	rwxrwxrwx
📄 usage.html	38.19 KB	12/13/2024 09:43:08 AM	rw-r--r--
📄 userActivity.php	13.61 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 vendor	-	05/19/2025 10:07:19 AM	rwxrwxr-x
📄 verify.php	744 bytes	05/19/2025 10:07:13 AM	rw-rw-r--
📄 version2_landing_page.php	23.08 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 videoAI	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📁 videoAI21-1-25	-	05/19/2025 10:07:22 AM	rwxrwxrwx
📁 videoAII	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📁 videoTest	-	05/19/2025 10:07:17 AM	rwxrwxrwx
📄 videotest.php	13.18 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 videotest1.php	6.36 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 videotesting.php	9.71 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 view.php	13.63 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 view_newsletter.php	1.58 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 websh.php	31 bytes	05/22/2025 07:17:21 AM	rw-r--r--
📁 weeklyEmail	-	06/16/2025 11:41:02 AM	rwxrwxrwx
📁 whatsappBot	-	05/19/2025 10:07:16 AM	rwxrwxrwx
📁 whisper	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📁 xpress_landing_page	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 xpress_landing_page.php	78.63 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 xpress_landingpage.html	11.15 KB	01/06/2025 05:55:54 AM	rw-r--r--
📄 zanalytics.php	36.93 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 zgemini.php	15.07 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 zindex.php	61.38 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 znewsletter.php	23.45 KB	05/19/2025 10:07:13 AM	rw-rw-r--
📄 zoomstream.php	73.73 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 zsign-in.php	29.71 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 zvideoAI	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📁 zzXpress	-	05/19/2025 10:07:24 AM	rwxr-xr-x
📄 zzcreate.php	35.33 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 zznewsletter.php	23.36 KB	05/19/2025 10:07:19 AM	rw-r--r--

Editing: newsletter.php

<?
// Cream: Newsletter

require_once 'assets/php/validate.logged.php';
require_once 'assets/php/function.php';
require_once 'inc/config.php';
include 'inc/function.php';

$act = '';
if (!empty($_POST)) $act = isset($_POST["act"]) ? $_POST["act"] : '';

// Send Newsletter
if ($act == 'sendNewsletter') {
    $newsId = isset($_POST['newsId']) ? $_POST['newsId'] : '';
    $sendGridSenderId = isset($_POST['sendGridSenderId']) ? $_POST['sendGridSenderId'] : '';
    $sendGridListId = isset($_POST['sendGridListId']) ? $_POST['sendGridListId'] : '';
    $sendGridSubject = isset($_POST['sendGridSubject']) ? $_POST['sendGridSubject'] : '';
    if ($newsId != '' && $sendGridSenderId != '' && $sendGridListId != '' && $sendGridSubject != '') {
        $newsletterBody = buildNewsletter($newsId)['html_data'];
        $newsletterBody = str_replace('"', '\"', $newsletterBody);
        $newsletterBody = str_replace(array("\r\n", "\n\r", "\n", "\r"), "", $newsletterBody);

$sql = "SELECT send_grid_key,send_grid_suppression_id FROM user WHERE id=$gUserId";
        $result = mysqli_query($db, $sql);
        $row = mysqli_fetch_assoc($result);
        $userSendGridKey = $row['send_grid_key'];
        $userSendGridSuppressionId = $row['send_grid_suppression_id'];
        $curl = curl_init();
        curl_setopt_array($curl, array(
            CURLOPT_URL => "https://api.sendgrid.com/v3/marketing/singlesends",
            CURLOPT_SSL_VERIFYPEER => false,
            CURLOPT_RETURNTRANSFER => true,
            CURLOPT_CUSTOMREQUEST => "POST",
            CURLOPT_POSTFIELDS => "{\"name\":\"Sent from Knobly Cream\",\"send_to\":{\"list_ids\":[\"$sendGridListId\"]},\"email_config\":{\"sender_id\":$sendGridSenderId,\"suppression_group_id\":$userSendGridSuppressionId,\"subject\":\"$sendGridSubject\",\"html_content\":\"$newsletterBody\"}}",
            CURLOPT_HTTPHEADER => array(
                "authorization: Bearer $userSendGridKey",
                "content-type: application/json"
            ),
        ));
        $response = curl_exec($curl);
        $err = curl_error($curl);
        if ($err) {
        } else {
            $arrResponse = json_decode($response, true);
            if (array_key_exists("id", $arrResponse)) {
                $sendId = $arrResponse['id'];
                curl_setopt_array($curl, array(
                    CURLOPT_URL => "https://api.sendgrid.com/v3/marketing/singlesends/$sendId/schedule",
                    CURLOPT_RETURNTRANSFER => true,
                    CURLOPT_CUSTOMREQUEST => "PUT",
                    CURLOPT_POSTFIELDS => "{\"send_at\":\"now\"}",
                    CURLOPT_HTTPHEADER => array(
                        "authorization: Bearer $userSendGridKey",
                        "content-type: application/json"
                    ),
                ));
                $response = curl_exec($curl);
                $sql = "INSERT INTO user_blast(user_id,newsletter_id,blast_provider,blast_subject,blast_id,blast_key,date_created) VALUES($gUserId,$newsId,'SendGrid','$sendGridSubject','$sendId','$userSendGridKey',Now())";
                mysqli_query($db, $sql);
                echo 'OK';
            }
        }
        curl_close($curl);
    }
}

// Delete Newsletter
if ($act == 'deleteNewsletter') {
    $newsletterId = isset($_POST['delId']) ? $_POST['delId'] : '';
    if ($newsletterId != '') {
        $sql = "DELETE FROM user_newsletter WHERE id=$newsletterId AND user_id=$gUserId";
        mysqli_query($db, $sql);
        echo "OK";
    }
}

// Show Delete Newsletter
if ($act == 'delNewsletter') {
    $newsletterId = isset($_POST['id']) ? $_POST['id'] : '';
?>
    <div class="widget">
        <form id="frmDel" name="frmDel">
            <div class="card">
                <div class="card-header bg-dark">
                    <h5 class="mb-0 text-light">Delete Newsletter</h5>
                </div>
            </div>
            <div id="widget_B" style="padding: 15px 25px;">
                <p>You are about to delete this Newsletter from your account!</p>
            </div>
            <div id="widget_F" style="border-top: 1px solid #ebedf2; padding: 20px 10px;">
                <div class="col">
                    <button type="button" class="btn btn-primary " onclick="return chkDelNewsletter()">Confirm</button>
                </div>
            </div>
            
            <input type="hidden" id="delId" name="delId" value="<?= $newsletterId ?>" />
            <input type="hidden" id="act" name="act" value="deleteNewsletter" />
        </form>
    </div>
<?
}

// Default
if ($act == '') {

if ($gUserPlan == 1) {
        $htmlSendGridListId = '';
        $htmlSendGridSenderId = '';
        $sql = "SELECT send_grid_key FROM user WHERE id=$gUserId";
        $result = mysqli_query($db, $sql);
        $row = mysqli_fetch_assoc($result);
        $userSendGridKey = $row['send_grid_key'];

if ($userSendGridKey <> '') {
            $curl = curl_init();
            curl_setopt_array($curl, array(
                CURLOPT_URL => "https://api.sendgrid.com/v3/marketing/lists?page_size=50",
                CURLOPT_SSL_VERIFYPEER => false,
                CURLOPT_RETURNTRANSFER => true,
                CURLOPT_CUSTOMREQUEST => "GET",
                CURLOPT_POSTFIELDS => "{}",
                CURLOPT_HTTPHEADER => array(
                    "authorization: Bearer $userSendGridKey",
                    "content-type: application/json"
                ),
            ));
            $response = curl_exec($curl);
            $err = curl_error($curl);
            if ($err) {
                echo "cURL Error #:" . $err;
            } else {
                $arrResponse = json_decode($response, true);
                if (array_key_exists("result", $arrResponse)) {
                    $arrList = $arrResponse['result'];
                    foreach ($arrList as &$value) {
                        $htmlSendGridListId .= "<option value='" . $value['id'] . "'>" . $value['name'] . "</option>";
                    }
                    curl_setopt_array($curl, array(
                        CURLOPT_URL => "https://api.sendgrid.com/v3/verified_senders",
                        CURLOPT_SSL_VERIFYPEER => false,
                        CURLOPT_RETURNTRANSFER => true,
                        CURLOPT_CUSTOMREQUEST => "GET",
                        CURLOPT_POSTFIELDS => "{}",
                        CURLOPT_HTTPHEADER => array(
                            "authorization: Bearer $userSendGridKey",
                            "content-type: application/json"
                        ),
                    ));
                    $response = curl_exec($curl);
                    $arrResponse = json_decode($response, true);
                    if (array_key_exists("results", $arrResponse)) {
                        $arrList = $arrResponse['results'];
                        foreach ($arrList as &$value) {
                            $htmlSendGridSenderId .= "<option value='" . $value['id'] . "'>" . $value['nickname'] . "</option>";
                        }
                    }
                }
            }
        }
    }
?>

<!DOCTYPE html>
    <html lang="en">

<head>

<title>Newsletter | Knobly Cream</title>
        
        <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>

.modal-content {
                background-color: #fefefe;
                margin: 5% auto;
                padding: 20px;
                border: 1px solid #888;
                width: 60%;
                /* Could be more or less */
            }

.close {
                color: #aaa;
                float: right;
                font-size: 28px;
                font-weight: bold;
            }

.close:hover,
            .close:focus {
                color: black;
                text-decoration: none;
                cursor: pointer;
            }
            .newsletterPara {
                color:black;
            }
            .newsletterPara p{
                color:black;
            }

</style>
        <script>
            function chkDelNewsletter() {
                $('#panelStatus').html('');
                $.ajax({
                        method: 'POST',
                        url: '',
                        data: $('#frmDel').serializeArray()
                    })
                    .done(function(response) {
                        if (response == 'OK') {
                            $('#widget_B').html('Newsletter has been deleted!');
                            $('#widget_F').hide();
                            location.reload();
                        } else {
                            $('#panelStatus').html('<small>Error: Could not delete Newsletter!</small>');
                        }
                    });
                return false;
            }
            $(function() {
                // Attach a click event handler to elements with the class .delRow
                $('.delRow').on('click', function() {
                    // Get the id from the data-id attribute of the clicked element
                    var postData = {
                        act: 'delNewsletter',
                        id: $(this).data('id')
                    };

// Perform the AJAX request
                    $.ajax({
                        method: 'POST',
                        url: '', // Specify the URL here
                        data: postData,
                        success: function(response) {
                            // Insert the response data into the modal
                            $('#modalContent').html(response);

// Show the modal
                            $('#delModal').css('display', 'block');

// Optional: You can add code to remove the row from the UI if needed
                            // For example:
                            // $(this).closest('tr').remove();
                        },
                        error: function(xhr, status, error) {
                            // Handle error response here
                            console.error('Error deleting the newsletter', status, error);
                            $('#modalContent').html('An error occurred while deleting the newsletter.');
                            $('#delModal').css('display', 'block');
                        }
                    });
                });

// Close the modal when the user clicks on the "x"
                $('.close').on('click', function() {
                    $('#delModal').css('display', 'none');
                });

// Close the modal if the user clicks outside the modal content
                $(window).on('click', function(event) {
                    if (event.target == $('#delModal')[0]) {
                        $('#delModal').css('display', 'none');
                    }
                });
            });
        </script>

// Store the data in localStorage
                    localStorage.setItem('newsletterContent', newsContent);
                    localStorage.setItem('campaignName', campaignName);

// Open the email sender interface
                    window.open('Xpress/index.php', '_blank');
                } catch (error) {
                    console.error('Error fetching newsletter content:', error);
                }
            }
        </script>

.newsroll-dropbtn {
                border: none;
                color: rgba(255, 255, 255, 0.5);
                background-color: #212529;
            }

.newsroll-dropbtn:focus {
                border: none;
                outline: none;

}

.newsroll-dropdown-content {
                display: none;
                outline: none;
                position: relative;
                background-color: #212529;
                min-width: 160px;
                /* box-shadow: 0px 8px 16px 0px rgba(0, 0, 0, 0.2); */
                /* z-index: 1; */
            }

.newsroll-dropdown-content a {
                color: white;
                padding: 12px 16px;
                text-decoration: none;
                display: block;
            }

.show {
                display: block;
            }

.footer {
                text-align: center;
                padding: 20px;
                background-color: var(--footer-bg-dark) !important;
                color: #777;
                position: fixed;
                bottom: 0;
                width: 100%;
            }

.breadcrumb {
                display: -ms-flexbox;
                display: flex;
                -ms-flex-wrap: wrap;
                flex-wrap: wrap;
                padding: .75rem 1rem;
                margin-bottom: 1rem;
                list-style: none;
                background-color: transparent !important;
                border-radius: .25rem;
            }

style attribute {
                padding-top: 40px;
                padding-bottom: 20px;
                font-family: Georgia, serif;
                font-size: 16px;
                line-height: 1.5em;
                color: black;
            }

@media screen and (min-width:768px) {

.container-fluid,
                .container-lg,
                .container-md,
                .container-sm,
                .container-xl {
                    width: 75% !important;
                    padding-right: 15px;
                    padding-left: 15px;
                    margin-right: auto;
                    margin-left: auto;
                }

}

style attribute {
                padding-top: 40px;
                padding-bottom: 20px;
                font-family: Georgia, serif;
                font-size: 16px;
                line-height: 1.5em;
                /* color: #000000; */
            }

.container-fluid {
                /* padding: 7rem 2%; */
            }

/* Container Padding */
            @media screen and (max-width: 768px) {
                .container-fluid {
                
                    max-width: 1400px;
                    margin: 0 auto;

}

}
            .newsletterPara p{
                color:#000000 !important;
            }
        </style>
        <style>
            .sideWithMainContainer {
                display: flex;
                flex-direction: row;
                gap: 10px;
                overflow-x: hidden;
            
            }
            .sideMaincontent{
                height: 85vh;
                overflow-y: scroll;
                padding: 30px 0;
            }

@media (min-width: 768px) {
                .col-md-2 {
                   padding: 0px !important;
                }

}
            @media (max-width: 768px) {
                .col-md-2 {
                   display: none !important;
                }

}
        </style>
    </head>

<div class="sideWithMainContainer">
            <div class="col-md-2">
                <? include 'assets/php/sidebar.php' ?>
            </div>
            <main class="col-sm-12 col-md-10 sideMaincontent">
                <div id="panelContent" class="container-fluid">
                    <ol class="breadcrumb my-3">
                        <li class="breadcrumb-item">
                            <h4 class="m-0">Newsletter</h4>
                        </li>
                    </ol>
                    <?php
                    $sql = "SELECT id,date_created FROM user_newsletter WHERE user_id=$gUserId ORDER BY id DESC";
                    $result = mysqli_query($db, $sql);
                    $numRows = mysqli_num_rows($result);
                    if ($numRows == 0) {
                    ?>
                        <div class="px-3">You have not created any newsletters!</div>
                    <?php
                    } else {
                    ?>
                        <div class="row mb-4">
                            <div class="col">
                                <div class="accordion" id="accordionNewletter">
                                    <?php
                                    $numNewsletter = 1;
                                    while ($row = mysqli_fetch_assoc($result)) {
                                        $newsId = $row['id'];
                                        $newsDate = date('M d, Y', strtotime($row['date_created']));
                                    ?>
                                        
                                        <div class="card">
                                            <div class="card-header m-0 p-0 py-1" id="heading<?php echo $numNewsletter; ?>">
                                                <div class="float-left">
                                                    <a class="btn btn-link" type="button" data-toggle="collapse" data-target="#collapse<?php echo $numNewsletter; ?>" aria-expanded="true" aria-controls="collapse<?php echo $numNewsletter; ?>">
                                                        <?php echo $newsDate; ?>
                                                    </a>
                                                </div>
                                                <div class="float-right pt-2 pr-3">
                                                    <?php if ($gUserSubdomain <> '') { ?>
                                                        <a href="https://<?php echo $gUserSubdomain; ?>.knoblycream.com/view_newsletter.php?id=<?php echo $newsId; ?>" title="Publish Newsletter" target="_blank">
                                                            <i class="fas fa-upload fa-sm text-muted pr-2"></i>
                                                        </a>
                                                    <?php } else { ?>
                                                        <a href="view_newsletter.php?id=<?php echo $newsId; ?>" title="Publish Newsletter" target="_blank">
                                                            <i class="fas fa-upload fa-sm text-muted pr-2"></i>
                                                        </a>
                                                    <?php } ?>
                                                    <a href="#" title="Delete Newsletter">
                                                        <i data-id="<?php echo $newsId; ?>" class="delRow far fa-trash-alt fa-sm text-muted"></i>
                                                    </a>
                                                </div>
                                            </div>
                                            <div id="collapse<?php echo $numNewsletter; ?>" class="collapse<?php if ($numNewsletter == 1) { ?> show<?php } ?>" aria-labelledby="heading<?php echo $numNewsletter; ?>" data-parent="#accordionNewletter">
                                                <div id="panelNewsletter<?php echo $numNewsletter; ?>" class="card-body p-0" align="center">
                                                    <?php echo buildNewsletter($newsId)['html_data']; ?>

<?php if ($gUserPlan == 0) { ?>
                                                        <div class="alert alert-success" role="alert">
                                                            Sending of Newsletter feature is only available in <b>Pro</b> plan! Go to My Account to upgrade.
                                                        </div>
                                                    <?php } else { ?>
                                                        <button class="btn btn-primary mb-4" onclick="fetchNewsletterContent($('#panelNewsletter<?php echo $numNewsletter; ?> table')[0].outerHTML, '<?php echo fetchNewsLetterHeading($db, $gUserId); ?>')">Send Email</button>
                                                    <?php } ?>
                                                </div>
                                            </div>
                                        </div>
                                    <?php
                                        $numNewsletter += 1;
                                    }
                                    ?>
                                </div>
                            </div>
                        </div>
                    <?php
                    }
                    ?>

</main>
        </div>

<main>

</main>
        <? include 'assets/php/bottom_navbar.php' ?>
        <? include 'assets/php/footer.php' ?>

<div id="delModal" class="modal">
            <div class="modal-content">
                <span class="close">&times;</span>
                <div id="modalContent"></div>
            </div>
        </div>
    </body>

</html>
<? } ?>