OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	04/17/2025 09:15:05 AM	rwxrwxr-x
📄 11-02-25navbar.php	23.94 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 12-03-25social_navbar.php	25.06 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 29-01-2025function.php	24.17 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 3-21-25-validate.logged.php	2.08 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 3-4-25function.php	29.26 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 PHPMailer	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📄 arvind_go_backbar.php	3.01 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 backfunction.php	24.17 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 backup-navbar.php	27.29 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 backupnavbar.php	21.23 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 bemerge_stream.php	3.75 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 blockAccount.php	2.23 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 bnavbar.php	35.82 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 bottom_navbar.php	6.67 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 bvalidate.logged.php	1.06 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 common.js	48.26 KB	06/16/2025 08:09:52 AM	rw-rw-r--
📄 config.php	9.37 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 db_config.php	3.43 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 db_connect.php	296 bytes	05/19/2025 10:07:15 AM	rw-rw-r--
📄 db_gallery.php	294 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 delete_account.php	3.5 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 edit_post.php	3.18 KB	06/13/2025 01:02:54 PM	rw-r--r--
📄 event_scrollbar.php	4.7 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 footer.php	1.12 KB	05/19/2025 10:07:15 AM	rw-rw-r--
📄 function.php	38.66 KB	06/05/2025 12:05:13 PM	rw-r--r--
📄 getEditContent.php	860 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 go_backbar.php	2.32 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 handler.php	3.51 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 indexFooter.php	1.05 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 mail.php	2.67 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 navbar.php	22.77 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 new_social_navbar.php	1.07 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 new_social_sidebar.php	5.59 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 process_data.php	3.87 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 readert_validate.logged.php	481 bytes	05/19/2025 10:07:15 AM	rw-rw-r--
📄 report_account.php	1.42 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 report_stream.php	2.08 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 savePost.php	2.38 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 sidebar.php	19.67 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 siginupProcess.php	5.24 KB	05/19/2025 10:07:15 AM	rw-rw-r--
📁 simplepie	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📄 social_navbar.php	26.04 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 stream_post_handler.php	3.68 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 validate.logged-status.php	424 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 validate.logged.php	1.31 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 vvalidate.logged.php	1.01 KB	05/19/2025 10:07:15 AM	rw-rw-r--

Editing: config.php

<?
ini_set('display_startup_errors', 1);

$servername = "127.0.0.1";
$dbname = "cream";
$username = "creamx";
$password = "CreamDev@2025";

/*
$servername = "localhost";
$dbname = "cream";
$username = "root";
$password = "1234";
*/

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;

require dirname(__FILE__) . '/PHPMailer/Exception.php';
require dirname(__FILE__) . '/PHPMailer/PHPMailer.php';
require dirname(__FILE__) . '/PHPMailer/SMTP.php';

$db = new mysqli($servername, $username, $password, $dbname);
if ($db->connect_error) {
   die("Connection failed: " . $db->connect_error);
}
mysqli_query($db, "SET NAMES utf8");
mysqli_query($db, "SET time_zone = '+5:30'");

function sendEmail($toName, $toEmail, $toEmailCC, $emailSubject, $emailBody)
{
   $mail = new PHPMailer(true);
   try {
      $mail->isSMTP();

//   $mail->setFrom('donotreply@knoblycream.com', 'Knobly Cream');
      //   $mail->Username   = 'AKIARWSGL3TOGXCYQJVY';
      //   $mail->Password   = 'BIj9DvNM3uX+cckSX4So50fqln6DEhie6dMJpe3AjzqK';
      //   $mail->Host       = 'email-smtp.ap-south-1.amazonaws.com';

//   $mail->setFrom('cream@knobly.com', 'Knobly Cream');
      //   $mail->Username   = '16486ca9-f4d0-4d09-9739-b48a16a8586e';
      //   $mail->Password   = '16486ca9-f4d0-4d09-9739-b48a16a8586e';
      //   $mail->Host       = 'smtp.postmarkapp.com';
      //   $mail->addCustomHeader('X-PM-Message-Stream', 'outbound');

$mail->setFrom('donotreply@knobly.com', 'Knobly Cream');
      $mail->Host       = 'smtp.gmail.com';
      $mail->Username   = 'donotreply@knobly.com';
      $mail->Password   = 'ipmhstdrbkwfhcna';

$mail->Port       = 587;
      $mail->SMTPAuth   = true;
      $mail->SMTPSecure = 'tls';
      if ($toEmail != '') {
         $arrEmail = explode(',', $toEmail);
         foreach ($arrEmail as $value) {
            $mail->addAddress(trim($value));
         }
      }
      //$mail->addAddress($toEmail, $toName);
      if ($toEmailCC != '') {
         $arrCC = explode(',', $toEmailCC);
         foreach ($arrCC as $value) {
            $mail->addCC(trim($value));
         }
      }
      $mail->addBCC('chiranjeev@gmail.com');
      $mail->isHTML(true);
      $mail->Subject = $emailSubject;
      $mail->Body    = $emailBody;
      $mail->send();
   } catch (Exception $e) {
      echo 'Message could not be sent.';
      echo 'Mailer Error: ' . $mail->ErrorInfo;
   }
}

function buildNewsletter($newsId)
{
   $returnHTML = '';
   $returnMETA = '';
   $metaCoverImg = '';
   $metaTitle = '';
   $metaDesc = '';

global $db;
   $sql = "SELECT A.*,B.company,B.news_title,B.news_logo,B.subdomain FROM user_newsletter A INNER JOIN user B ON A.user_id=B.id WHERE A.id=$newsId";
   $result = mysqli_query($db, $sql);
   $row = mysqli_fetch_assoc($result);
   $userSubdomain = $row['subdomain'];
   $companyName = $row['company'];
   $newsTitle = $row['news_title'];
   $newsLogo = $row['news_logo'];
   $newsDate = $row['date_created'];
   $newsArticles = $row['article_id'];
   $arrArticles = explode(',', $newsArticles);
   $returnHTML .= '<table border="0" cellpadding="0" cellspacing="0" width="100%" style="max-width:650px;border:1px solid #ccc;margin:30px 0;">';
   $returnHTML .= '<tr>';
   $returnHTML .= ' <td style="width:40px"></td>';
   $returnHTML .= ' <td style="padding-top:20px" align="center">';
   $returnHTML .= '  <img src="https://www.knoblycream.com/data/logos/' . $newsLogo . '" width="150" /><br>';
   $returnHTML .= '  <div style="font-size:20px;font-family:Helvetica,Arial,sans-serif;">' . $newsTitle . '</div>';
   $returnHTML .= '  <div style="font-size:13px;font-family:Helvetica,Arial,sans-serif;">' . date('M d, Y') . ' | Publisher: ' .  $companyName . '</div>';
   $returnHTML .= ' </td>';
   $returnHTML .= ' <td style="width:40px"></td>';
   $returnHTML .= '</tr>';
   $returnHTML .= '<tr>';
   $returnHTML .= ' <td></td>';
   $returnHTML .= ' <td style="padding-top:40px;padding-bottom:20px;font-family:Georgia,serif;font-size:16px;line-height:1.5em;" align="left">';
   foreach ($arrArticles as $nl) {
      if ($nl <> '') {
         $sql = "SELECT * FROM user_collection WHERE id=$nl";
         $result = mysqli_query($db, $sql);
         $numRows = mysqli_num_rows($result);
         if ($numRows > 0) {
            $row = mysqli_fetch_assoc($result);
            $artId = $row['id'];
            $artTitle = $row['title'];
            $artDesc = $row['description'];

if ($userSubdomain <> '') {
               $artURL = 'https://' . $userSubdomain . '.knoblycream.com/view/' . $artId . '/' . createArticleURL($artTitle);
               $artDesc = str_replace('<img src="data/posts/', '<img src="https://' . $userSubdomain . '.knoblycream.com/data/posts/', $artDesc);
            } else {
               $artURL = 'https://www.knoblycream.com/view/' . $artId . '/' . createArticleURL($artTitle);
               $artDesc = str_replace('<img src="data/posts/', '<img src="https://www.knoblycream.com/data/posts/', $artDesc);
            }

$artDesc = str_replace("\\n", "<br>", $artDesc);
            $artDesc = stripslashes($artDesc);

$artCoverImg = $row['cover_img'];
            $artIsReadMore = $row['is_read_more'];
            $artReadMoreTxt = $row['read_more_txt'];
            if ($artReadMoreTxt == '') $artReadMoreTxt = "Read More";

if ($metaCoverImg == '') $metaCoverImg = $artCoverImg;
            if ($metaTitle == '') $metaTitle = $artTitle;
            if ($metaDesc == '') $metaDesc = $artDesc;

$returnHTML .= '  <div style="padding-bottom:40px">';
            if ($artCoverImg <> '') {
               $returnHTML .= '  <div style="padding-bottom:10px"><a href="' . $artURL . '" target="_blank"><img src="https://www.knoblycream.com/data/covers/' . $artCoverImg . '" style="max-width:650px" width="100%" /></a></div>';
            }
            $returnHTML .= '   <div style="padding-bottom:10px;font-size:14pt;"><a href="' . $artURL . '" target="_blank"><strong>' . $artTitle . '</strong></a></div>';
            $returnHTML .= '   <span style="font-weight:400">' . $artDesc . '</span>';
            if ($artIsReadMore <> '') {
               if ($userSubdomain <> '') {
                  $returnHTML .= '   <center><a href="https://' . $userSubdomain . '.knoblycream.com/more.php?id=' . $nl . '" target="_blank"><div style="display:inline-block;font-size:0.75em;margin-top:10px;padding:8px 15px;background-color:#ffc107;border-radius:5px;text-decoration:none;">' . $artReadMoreTxt . '</div></a></center>';
               } else {
                  $returnHTML .= '   <center><a href="https://www.knoblycream.com/more.php?id=' . $nl . '" target="_blank"><div style="display:inline-block;font-size:0.75em;margin-top:10px;padding:8px 15px;background-color:#ffc107;border-radius:5px;text-decoration:none;">' . $artReadMoreTxt . '</div></a></center>';
               }
            }
            $returnHTML .= '   <br clear="all">';
            $returnHTML .= '  </div>';
         }
      }
   }

$returnHTML .= ' </td>';
   $returnHTML .= ' <td></td>';
   $returnHTML .= '</tr>';
   $returnHTML .= '<tr>';
   $returnHTML .= ' <td></td>';
   $returnHTML .= ' <td align="center">';
   $returnHTML .= '  Powered by <a href="https://www.knoblycream.com/"><img src="https://www.knoblycream.com/assets/img/logo.black.png" width="100" align="middle" style="padding-bottom:10px"></a><br><br>';
   $returnHTML .= ' </td>';
   $returnHTML .= ' <td></td>';
   $returnHTML .= '</tr>';
   $returnHTML .= '</table>';

$collectionLink = 'https://' . $_SERVER['SERVER_NAME'] . '/newsletter.php?id=' . $newsId;
   $returnMETA .= '<meta property="og:url" content=' . $collectionLink . ' />';
   $returnMETA .= '<meta property="og:type" content="website" />';
   $returnMETA .= '<meta property="og:title" content=' . $metaTitle . ' />';
   $returnMETA .= '<meta property="og:description" content=' . htmlspecialchars($metaDesc) . ' />';
   $returnMETA .= '<meta property="og:image" content="https://' . $_SERVER['SERVER_NAME'] . '/data/covers/' . $metaCoverImg . '" />';
   $returnMETA .= '<meta property="og:image:secure-url" itemprop="image" content="https://' . $_SERVER['SERVER_NAME'] . '/data/covers/' . $metaCoverImg . '" />';

$returnMETA .= '<meta property="twitter:url" content="' . $collectionLink . '" />';
   $returnMETA .= '<meta name="twitter:card" content="summary" />';
   $returnMETA .= '<meta name="twitter:title" content="' . $metaTitle . '" />';
   $returnMETA .= '<meta name="twitter:description" content="' . htmlspecialchars($metaDesc) . '" />';
   $returnMETA .= '<meta name="twitter:image" content="https://' . $_SERVER['SERVER_NAME'] . '/data/logos/' . $metaCoverImg . '" />';

return ['meta_tag' => $returnMETA, 'html_data' => $returnHTML];
}