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: view.php

<!doctype html>
<?

error_reporting(E_ALL & ~E_WARNING);
ini_set('display_errors', '0');  // Hide errors from the browser

include 'inc/config.php';
// include 'conversations/functions.php';

$chat = [];

$id = isset($_GET["id"]) ? $_GET["id"] : '';
if ($id <> '') {
  $sql = "SELECT * FROM user_collection WHERE id=$id";
  $result = mysqli_query($db, $sql);
  $row = $result->fetch_assoc();
  $numRows = mysqli_num_rows($result);
  if ($numRows == 0) die();

// $serverName = "knoblycream.com";
  $serverName = $_SERVER['SERVER_NAME'];
  $collectionUserId = $row['user_id'];
  $sql = "SELECT subdomain,is_side_panel,side_panel_content FROM user WHERE id=$collectionUserId";
  $resultInner = mysqli_query($db, $sql);
  $rowInner = mysqli_fetch_assoc($resultInner);
  $userSubdomain = $rowInner['subdomain'];
  $userSidePanel = $rowInner['is_side_panel'];
  $userSidePanelContent = $rowInner['side_panel_content'];
  $userSidePanelContent = str_replace('<img src="data/', '<img src="https://' . $serverName . '/data/', $userSidePanelContent);

// $chat = fetch_messages($conn1, $id);
  // $chat = fetch_messages($db, $id);

$ip = getenv('HTTP_CLIENT_IP') ?: getenv('HTTP_X_FORWARDED_FOR') ?: getenv('HTTP_X_FORWARDED') ?: getenv('HTTP_FORWARDED_FOR') ?: getenv('HTTP_FORWARDED') ?: getenv('REMOTE_ADDR');
  $response = unserialize(file_get_contents('http://www.geoplugin.net/php.gp?ip=' . $ip));

if ($response === false) {
    $visitCity = '';
    $visitCountry = '';
  } else {
    $visitCity = $response['geoplugin_city'];
    $visitCountry = $response['geoplugin_countryName'];
  }
  $sql = "INSERT INTO metrics(article_id,ip,visit_city,visit_country,date_visited,category) VALUES($id,'$ip','$visitCity','$visitCountry',Now(), 'Anonymous')";
  mysqli_query($db, $sql);

$collectionURL = $row['url'];
  if ($collectionURL <> '') {
    header("Location: " . $collectionURL);
    die();
  }

$collectionTitle = $row['title'];
  $collectionDesc = $row['description'];

$collectionDesc = preg_replace('/<img[^>]+src="data\/([^"]+)"/', '<img src="https://' . $serverName . '/data/$1"', $collectionDesc);
  // $collectionDesc = str_replace('<img src="data/', '<img src="https://' . $serverName . '/data/', $collectionDesc);
  $collectionDesc = str_replace('\n', '<br>', $collectionDesc);
  $collectionDesc = str_replace('\\', '', $collectionDesc);
  $collectionShareUserId = $row['share_user_id'];
  $collectionPublisher = substr($collectionURL, strpos($collectionURL, ".") + 1);
  $collectionPublisher = ucfirst(strtok($collectionPublisher, '.'));
  if ($collectionPublisher == '') $collectionPublisher = 'Cream';
  $collectionDate = date('d M, Y', strtotime($row['date_added']));
  $collectionLink = 'https://' . $serverName . '/view/' . $id . '/' . createArticleURL($collectionTitle);
  $collectionImgCover = $row['cover_img'];
  $collectionIsReadMore = $row['is_read_more'];
  $collectionReadMoreTxt = $row['read_more_txt'];
  if ($collectionReadMoreTxt == '') $collectionReadMoreTxt = "Read More";

if ($collectionShareUserId <> '') {
    $sql = "SELECT full_name,company,website,news_title,news_logo FROM user WHERE id=$collectionShareUserId";
  } else {
    $sql = "SELECT full_name,company,website,news_title,news_logo FROM user WHERE id=$collectionUserId";
  }
  $result = mysqli_query($db, $sql);
  $row = mysqli_fetch_assoc($result);
  $user = $row['full_name'];
  $companyName = $row['company'];
  $website = strtolower($row['website']);
  $newsTitle = $row['news_title'];
  $newsLogo = $row['news_logo'];
  if (strpos($website, 'http') === false) $website = "http://$website";
?>
  <html lang="en">

<meta property="og:url" content="<?= $collectionLink ?>" />
    <meta property="og:type" content="website" />
    <meta property="og:title" content="<?= $collectionTitle ?>" />
    <meta property="og:description" content="<?= $collectionTitle ?>" />
    <? if ($collectionImgCover <> '') { ?>
      <meta property="og:image" content="https://<?= $serverName ?>/data/covers/<?= $collectionImgCover ?>" />
      <meta property="og:image:secure-url" itemprop="image" content="https://<?= $serverName ?>/data/covers/<?= $collectionImgCover ?>" />
    <? } else { ?>
      <meta property="og:image" content="https://<?= $serverName ?>/data/logos/<?= $newsLogo ?>" />
      <meta property="og:image:secure-url" itemprop="image" content="https://<?= $serverName ?>/data/logos/<?= $newsLogo ?>" />
    <? } ?>

<meta property="twitter:url" content="<?= $collectionLink ?>" />
    <meta name="twitter:card" content="summary" />
    <meta name="twitter:title" content="<?= $companyName ?>" />
    <meta name="twitter:description" content="" />
    <? if ($collectionImgCover <> '') { ?>
      <meta name="twitter:image" content="https://<?= $serverName ?>/data/covers/<?= $collectionImgCover ?>" />
    <? } else { ?>
      <meta name="twitter:image" content="https://<?= $serverName ?>/data/logos/<?= $newsLogo ?>" />
    <? } ?>

}

.panelContent img {
        width: auto;
        height: auto;
        max-width: 100%;
      }
    </style>
    <style>
      .conversations {
        max-height: 300px;
        overflow-y: scroll;
      }

.comments-section {
        margin-top: 40px;
        margin-bottom: 80px;
        margin-left: 90px;
        margin-right: 90px;

}

.comment-form {
        margin-bottom: 20px;
      }

.comment-form textarea {
        width: 100%;
        height: 100px;
        margin-bottom: 10px;
      }

.comment {
        width: fit-content;
        margin-bottom: 20px;
        padding: 10px 20px;
        /* border: 1px solid #ccc; */
        box-shadow: 0 0 10px rgba(0, 0, 0, 0.2);
        border-radius: 5px;
      }

.comment .author {
        font-weight: bold;
      }

.conversation-form {
        display: flex;
        width: 100%;
        column-gap: 8px;
        justify-content: left;
        margin: 10px 0px;
        margin-bottom: 20px;
      }

.comment-text {
        border-radius: 6px;
        padding: 5px 10px;
        width: 80%;
        height: 40px;
      }

.conversation-btn {
        border-radius: 5px;

}

.author span {
        padding-left: 10px;
      }

.login-redirect {
        display: flex;
        justify-content: center;
        max-width: 100%;

}

.login-redirect span {
        border: 0.2px solid black;
        padding: 8px 16px;
        border-radius: 10px;
        margin: 10px 20px;
        width: 600px;
        display: flex;
        justify-content: center;
      }

.login-redirect a:hover {
        text-decoration: none;
        color: #000;
      }

.login-redirect span:hover {
        background-color: #d9d9e18f;
      }

</style>
  </head>

<? if ($newsLogo <> '' && $user <> '' && $companyName <> '') { ?>
        <header class="blog-header py-3 border-bottom">
          <div class="row flex-nowrap justify-content-between align-items-center">
            <div class="col-8 pt-1">
              <? if ($newsLogo <> '') { ?>
                <a class="text-muted" href="<?= $website ?>"><img class="mx-auto" width="256px" src="https://<?= $serverName ?>/data/logos/<?= $newsLogo ?>" /></a>
              <? } ?>
              <h6 class="mt-1" style="color:#9e9e9e"><?= $user ?> | <?= $companyName ?></h6>
            </div>
            <div class="col-4 text-right">
            </div>
          </div>
        </header>
      <? } ?>

<div class="row mt-3 pb-5">
        <div class="panelContent col-12 col-md pb-3">
          <h1><?= $collectionTitle ?></h1>
          <h6 style="color:#9e9e9e"><?= $collectionDate ?></h6>
          <? if ($collectionImgCover <> '') { ?>
            <div class="my-2"><img src="https://<?= $serverName ?>/data/covers/<?= $collectionImgCover ?>" /></div>
          <? } ?>
          <p><?= $collectionDesc ?></p>
          <? if ($collectionIsReadMore <> '') { ?>
            <center>
              <a href="https://<?= $serverName ?>/more.php?id=<?= $id ?>" target="_blank">
                <div class="btn btn-warning py-2"><?= $collectionReadMoreTxt ?></div>
              </a>
            </center>
            <br>
          <? } ?>
          <? if ($newsLogo <> '' && $user <> '' && $companyName <> '') { ?>
            <p class="small" style="color:#189eb5;">Publisher: <?= $user ?> | <?= $companyName ?></p>
          <? } ?>
        </div>

<? if ($userSidePanel == 1) { ?>
          <div style="width:300px;"><?= $userSidePanelContent ?></div>
        <? } ?>

</div>

<div class="login-redirect">
      <span><a href="/signup.html?type=login&article_Id=<?= $id ?>">Login to Give your comment</a></span>
    </div>

</div>

<div class="container fixed-bottom pb-3" style="background-color:#fff">
      <div class="row no-gutters" style="border-top:1px solid #eb5e31">
        <div class="col mt-2 text-right">
          <small>Powered by</small> <a href="https://www.knoblycream.com/" target="_blank"><img src="/assets/img/logo.black.png" width="100" /></a>
        </div>
      </div>
    </div>

</body>

// Refresh the page
      location.reload();
    }

function sendMessage(article_id, user_name) {

var messageText = $('#comment-text1').val().trim();
      var now = new Date(); // Get current date and time in user's local time zone

var posted_on = now.getFullYear() + '-' +
        ('0' + (now.getMonth() + 1)).slice(-2) + '-' +
        ('0' + now.getDate()).slice(-2) + ' ' +
        ('0' + now.getHours()).slice(-2) + ':' +
        ('0' + now.getMinutes()).slice(-2) + ':' +
        ('0' + now.getSeconds()).slice(-2); // Format as 'YYYY-MM-DD HH:MM:SS'

if (messageText === '') {
        return;
      }

$.ajax({
        url: 'conversations/save_conversations.php',
        method: 'POST',
        data: {
          article_id: article_id,
          user_id: user_id,
          message: messageText,
          posted_on: posted_on
        },
        success: function(response) {
          // Handle the response
          alert('Message sent successfully!');
          console.log(response); // Log response to console
          location.reload(); // Reload the page after successful message post
        },
        error: function(xhr, status, error) {
          // Handle errors
          console.error(xhr.responseText);
        }
      });
    }

function saveComments(comments) {
      localStorage.setItem('comments', JSON.stringify(comments));
    }

function addComment() {
      const text = $('#comment-text').val();
      // const author = $('#comment-author').val();
      const author = '<?php echo $user_name; ?>';

if (!text || !author) {
        alert('Please enter your name and comment.');
        return;
      }

const comments = getComments();
      comments.push({
        text: text,
        author: author,
        date: new Date().toLocaleString()
      });
      saveComments(comments);

$('#comment-text').val('');
      $('#comment-author').val('');
      renderComments();
    }

function renderComments() {
      const comments = getComments();
      const commentsDiv = $('#comments');

comments.forEach(comment => {
        const commentDiv = $('<div></div>').addClass('comment');
        commentDiv.html(`
            <div class="author">${comment.author} <span style="font-size: 0.8em; color: #555;">${comment.date}</span></div>
            <div class="text">${comment.text}</div>
            `);
        commentsDiv.append(commentDiv);
      });
    }

$(document).ready(renderComments);
  </script>

</html>
<? } ?>