OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	05/09/2025 11:18:49 AM	rwxr-xr-x
📄 .htaccess	860 bytes	03/26/2025 03:47:46 AM	rw-r--r--
📁 .vscode	-	03/26/2025 03:47:57 AM	rwxr-xr-x
📁 CreateLeadPage	-	03/26/2025 04:16:47 AM	rwxr-xr-x
📄 ImageMagick-7.1.1-45-Q16-HDRI-x64-dll.exe	22.2 MB	03/26/2025 03:47:54 AM	rw-r--r--
📁 Xpress	-	03/26/2025 04:21:24 AM	rwxr-xr-x
📄 XpressPage.php	47.13 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 about.html	3.26 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 account.php	47.77 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 activate.php	2.19 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 add_channel.php	9.7 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 add_to_channel.php	980 bytes	03/26/2025 03:47:46 AM	rw-r--r--
📁 admin	-	03/26/2025 04:16:40 AM	rwxr-xr-x
📄 analytics.php	37.71 KB	03/26/2025 03:47:46 AM	rw-r--r--
📁 assets	-	03/26/2025 04:16:41 AM	rwxr-xr-x
📁 audio	-	03/26/2025 03:48:03 AM	rwxr-xr-x
📄 businessLp.php	46.33 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 bussLp.php	57.87 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 card-news.php	6.2 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 channel.php	36.21 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 chattest.php	8.66 KB	03/26/2025 03:47:46 AM	rw-r--r--
📁 clients	-	03/26/2025 03:48:03 AM	rwxr-xr-x
📄 collections.php	94.62 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 comments.php	1.67 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 composer.json	65 bytes	03/26/2025 03:47:46 AM	rw-r--r--
📄 composer.lock	4.03 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 contact.html	3.01 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 cookie.php	750 bytes	03/26/2025 03:47:46 AM	rw-r--r--
📄 copytest.html	4.04 KB	03/26/2025 03:47:46 AM	rw-r--r--
📁 creamAdmin	-	03/26/2025 04:07:42 AM	rwxr-xr-x
📄 cream_dashboard.php	25.87 KB	03/26/2025 03:47:46 AM	rw-r--r--
📁 creamapi	-	03/26/2025 03:48:04 AM	rwxr-xr-x
📄 create.php	42.93 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 created_magazine.html	11.96 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 dashboard.php	55.52 KB	03/26/2025 03:47:46 AM	rw-r--r--
📁 data	-	03/26/2025 04:16:48 AM	rwxr-xr-x
📄 down.html	829 bytes	03/26/2025 03:47:46 AM	rw-r--r--
📁 education-podcasts	-	03/31/2025 06:36:42 AM	rwxr-xr-x
📁 featured_channels	-	03/26/2025 03:48:04 AM	rwxr-xr-x
📄 featured_channels.php	32.48 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 featured_topics.php	26.59 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 fetch_articles.php	1.83 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 fetch_liked_users.php	1.55 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 filter.php	4.91 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 follow_action.php	1.75 KB	03/26/2025 03:47:46 AM	rw-r--r--
📄 follow_dash.php	33.76 KB	03/26/2025 03:47:46 AM	rw-r--r--
📁 form-builder	-	03/26/2025 03:48:04 AM	rwxr-xr-x
📄 function.php	20.61 KB	03/26/2025 03:47:47 AM	rw-r--r--
📁 genai	-	03/26/2025 04:20:06 AM	rwxr-xr-x
📄 generated_article.php	11.86 KB	03/26/2025 03:47:47 AM	rw-r--r--
📄 get_recent_items.php	1.37 KB	03/26/2025 03:47:47 AM	rw-r--r--
📄 handle_channel.php	856 bytes	03/26/2025 03:47:47 AM	rw-r--r--
📁 hindiConverter	-	03/26/2025 04:15:50 AM	rwxr-xr-x
📄 homePin.php	68.38 KB	03/26/2025 03:47:47 AM	rw-r--r--
📁 hps	-	03/26/2025 03:48:05 AM	rwxr-xr-x
📄 impmy_collection.php	124.17 KB	03/26/2025 03:47:47 AM	rw-r--r--
📁 inc	-	03/26/2025 04:15:50 AM	rwxr-xr-x
📄 index.php	30.55 KB	03/26/2025 03:47:48 AM	rw-r--r--
📄 index1.php	61.34 KB	03/26/2025 03:47:50 AM	rw-r--r--
📄 influencer.php	11.72 KB	03/26/2025 03:47:54 AM	rw-r--r--
📁 interface	-	03/26/2025 03:48:05 AM	rwxr-xr-x
📁 kannada	-	03/26/2025 04:20:06 AM	rwxr-xr-x
📄 knobly_logo.png	9.45 KB	03/26/2025 03:47:54 AM	rw-r--r--
📄 landing_page.php	17.27 KB	03/26/2025 03:47:54 AM	rw-r--r--
📄 landing_signin.php	5.11 KB	03/26/2025 03:47:54 AM	rw-r--r--
📁 leadpage	-	03/26/2025 04:15:53 AM	rwxr-xr-x
📄 link.php	5.63 KB	03/26/2025 03:47:54 AM	rw-r--r--
📄 logInCheck.php	4.41 KB	03/26/2025 03:47:55 AM	rw-r--r--
📄 loggedInCheck.php	1.15 KB	03/26/2025 03:47:54 AM	rw-r--r--
📄 logo (1).svg	814 bytes	03/26/2025 03:47:55 AM	rw-r--r--
📄 logout.php	503 bytes	03/26/2025 03:47:55 AM	rw-r--r--
📄 magazine.html	4.46 KB	03/26/2025 03:47:55 AM	rw-r--r--
📄 magazine.php	23.57 KB	03/26/2025 03:47:55 AM	rw-r--r--
📄 more.php	9.21 KB	03/26/2025 03:47:55 AM	rw-r--r--
📄 my_collection.php	153.03 KB	03/26/2025 03:47:55 AM	rw-r--r--
📄 my_settings.php	17.44 KB	03/26/2025 03:47:55 AM	rw-r--r--
📄 navbar.php	3.36 KB	03/26/2025 03:47:55 AM	rw-r--r--
📄 new-page.php	10.46 KB	03/26/2025 03:47:55 AM	rw-r--r--
📄 newEditor.php	17.04 KB	03/26/2025 03:47:55 AM	rw-r--r--
📄 newsletter.php	24.31 KB	03/26/2025 03:47:55 AM	rw-r--r--
📁 pageLanding	-	03/26/2025 04:20:07 AM	rwxr-xr-x
📁 pages	-	03/26/2025 04:15:53 AM	rwxr-xr-x
📄 payment.php	29.86 KB	03/26/2025 03:47:55 AM	rw-r--r--
📁 pdf	-	03/26/2025 03:48:06 AM	rwxr-xr-x
📄 pdftk_server-2.02-win-setup.exe	2.91 MB	03/26/2025 03:47:56 AM	rw-r--r--
📄 post-details.php	37.75 KB	03/26/2025 03:47:55 AM	rw-r--r--
📄 premium.php	21.79 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 privacy.html	12.1 KB	03/26/2025 03:47:56 AM	rw-r--r--
📁 process	-	03/26/2025 03:48:11 AM	rwxr-xr-x
📄 process-plan.php	1.44 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 process.php	1.52 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 process_data.php	5.02 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 profile.php	37.8 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 profile_pic_upload.php	4.83 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 profile_test.php	19.78 KB	03/26/2025 03:47:56 AM	rw-r--r--
📁 reels	-	03/26/2025 04:20:08 AM	rwxr-xr-x
📄 refund.html	9.04 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 replyPost.php	3.93 KB	03/26/2025 03:47:56 AM	rw-r--r--
📁 report	-	03/26/2025 03:48:11 AM	rwxr-xr-x
📄 request_article.php	22.76 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 reset.html	4.7 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 save_profile.php	2.78 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 saved.php	34.28 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 saved_posts.php	49.25 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 search_bar.php	16.95 KB	03/26/2025 03:47:56 AM	rw-r--r--
📁 sendy	-	03/26/2025 04:21:20 AM	rwxr-xr-x
📄 settings.php	81.93 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 sharemarket.php	3.88 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 showcase.php	10.34 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 signInProcess.php	13.83 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 signInProcess_backup.php	11.18 KB	03/26/2025 03:47:56 AM	rw-r--r--
📁 social_media	-	03/26/2025 04:16:12 AM	rwxr-xr-x
📄 start.html	3.99 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 store_articles.php	1.04 KB	03/26/2025 03:47:56 AM	rw-r--r--
📄 stream.php	62.31 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 streamPush.php	29.82 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 streamb.php	40.75 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 streambb.php	47.34 KB	03/26/2025 03:47:57 AM	rw-r--r--
📁 texttovoice	-	03/26/2025 03:48:13 AM	rwxr-xr-x
📁 thumbsUp	-	03/26/2025 03:48:13 AM	rwxr-xr-x
📄 toggle_channel.php	2.28 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 udupi_sign_up.php	34.5 KB	03/26/2025 03:47:57 AM	rw-r--r--
📁 uploads	-	03/26/2025 04:06:46 AM	rwxr-xr-x
📄 usage.html	37.76 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 userActivity.php	9.79 KB	03/26/2025 03:47:57 AM	rw-r--r--
📁 vendor	-	03/26/2025 04:20:23 AM	rwxr-xr-x
📄 verify.php	744 bytes	03/26/2025 03:47:57 AM	rw-r--r--
📄 view.php	13.36 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 view_newsletter.php	1.58 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 xpress_landing_page.php	78.63 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 xpress_landingpage.html	11.15 KB	03/26/2025 03:47:57 AM	rw-r--r--

Editing: influencer.php

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

function showInfluencerBio($db, $userId)
{
    $sql = "SELECT influencer_about FROM user WHERE id = ?";
    $about = "";

if ($stmt = $db->prepare($sql)) {
        $stmt->bind_param("i", $userId);
        $stmt->execute();
        $stmt->bind_result($about);
        if ($stmt->fetch()) {
            return $about;
        } else {
            return null;
        }
        $stmt->close();
    } else {
        return "Error preparing statement: " . $db->error;
    }
}

function showOpinionNum($db, $userId)
{
    $sql = "SELECT COUNT(*) AS count FROM user_collection WHERE user_id = $userId";
    $result = $db->query($sql);
    $data = $result->fetch_assoc();
    return $data['count'];
}

function check_influencer($db, $userId)
{
    $sql = "SELECT is_influencer FROM user WHERE id = $userId";
    $result = $db->query($sql);

if (!$result) {
        // Handle query failure
        error_log("Database query failed: " . $db->error);
        return false;
    }

$data = $result->fetch_assoc();
    if ($data['is_influencer'] == 1) {
        return true;
    } else {
        return false;
    }
}

function build_image_url($data)
{
    return "https://knoblycream.com/data/covers/" . $data;
}

function show_influencer_articles($db, $userId)
{

if (check_influencer($db, $userId)) {
        $sql = "SELECT uc.id, uc.url, uc.title, uc.description, uc.cover_img, uc.date_added, u.subdomain
        FROM user_collection uc 
        INNER JOIN user_landing ul ON ul.article_id = uc.id 
        INNER JOIN user u ON u.id = uc.user_id
        WHERE uc.user_id = $userId ORDER BY ul.id DESC";
        $result = $db->query($sql);

if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) { ?>
                <div class="col-md-4">
                    <div class="card mb-4 news-item card-content">
                        <div class="card-body">
                            <?php if (!empty($row['cover_img'])) { ?>
                                <img src="<?= build_image_url($row['cover_img']) ?>" alt="Cover Image" class="img-fluid">
                            <?php } ?>
                            <h5 class="card-title"><?= htmlspecialchars($row['title']) ?></h5>
                            <?php
                            // Get the description and limit it to 50 words
                            $description = strip_tags($row['description']); // Remove HTML tags
                            $description = trim($description); // Trim leading/trailing spaces
                            $description = preg_replace('/\s+/', ' ', $description); // Replace multiple spaces with a single space

// Split the description into words
                            $descriptionWords = explode(' ', $description);

// Check if there are more than 50 words
                            if (count($descriptionWords) > 50) {
                                // Limit to the first 50 words and append "..."
                                $description = implode(' ', array_slice($descriptionWords, 0, 50)) . '...';
                            } else {
                                // If there are 50 or fewer words, use the whole description
                                $description = implode(' ', $descriptionWords);
                            }
                            ?>
                            <p class="card-text"><?= $description ?></p>
                            <p class="card-text"><strong>Date Added: </strong><?= htmlspecialchars($row['date_added']) ?></p>
                            <a href="<?= build_article_url($row['id'], $row['title'], $row['subdomain']) ?>" target="_blank">Read More</a>
                        </div>
                    </div>
                </div>
            <?
            }
        } else {
            ?>
            <p style="text-align: center;">No data available.</p>
        <?
        }
    } else {
        ?>
        <p style="text-align: center;">User is not an influencer.</p>
<?
    }
}

if (isset($_GET['infId'])) {
    $userId = $_GET['infId'];
    if (!(check_influencer($db, $userId))) {
        http_response_code(500);
        exit();
    }
} else {
    // Set HTTP response code to 500 (Internal Server Error)
    http_response_code(500);
    // Optionally, you can add a message or log the error
    // echo "Internal Server Error: infId is missing.";
    // Stop further script execution
    exit();
}

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

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Influencer Data</title>
    <link href="assets/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="assets/css/all.min.css">
    <link href="assets/css/bootstrap-icons.min.css" rel="stylesheet">
    <script src="assets/js/jquery-3.6.0.min.js"></script>

.card,
        .modal-content {
            background-color: #1c1c1c !important;
            color: white !important;
            border: none;
            margin-bottom: 20px;
            transition: transform 0.3s;
        }

.card:hover {
            transform: scale(1.05);
        }

.card img {
            max-height: 200px;
            object-fit: cover;
        }

.modal-content {
            background-color: #1c1c1c;
            color: white;
        }

.modal-body {
            padding: 20px;
        }

.morewithlike i {
            color: #a3a2a2;
            border: none;
            padding: 0;
        }

.morewithlike button::after {
            border-color: pink;
            /* Ensure no outline when focused */
            border: none;
            outline: none;

}

.profile_card {
            padding: 20px 50px;
            color: black !important;
            background-color: #fff !important;
            min-height: max-content;
            background-color: #fff;
            gap: 30px
        }

.card-body {
            color: black !important;
            background-color: #fff !important;
            min-height: 275px;
        }

#news-container .text-white {
            --bs-text-opacity: 1;
            color: #141414 !important;
        }

.modal-content {
            background-color: var(--bg-color-light) !important;
            color: var(--bg-color-dark) !important;
            border: none;
            margin-bottom: 20px;
            transition: transform 0.3s;
        }

.opinion_count {
            font-size: 30px;
            height: auto;
        }

.opinion-text {
            display: flex;
            align-items: end;
            padding: 0 2px;
            margin-bottom: 0 !important;
        }

@media screen and (max-width: 600px) {
            .profile_card {
                padding: 0px 0px;
                color: black !important;
                background-color: #fff !important;
                min-height: max-content;
                background-color: #fff;
                gap: 10px;
                display: flex;
                flex-direction: column;
            }

.opinion_count {
                font-size: medium;
                height: auto;
            }

.opinion-text {
                display: flex;
                /* gap: 12px; */
                align-items: center;
                margin: 0 4px;
            }

.opinion_nameWithBio {
                display: flex;
                align-items: center;
            }

}
    </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>

<body>

<?php include 'assets/php/social_navbar.php' ?>

<div class="sideWithMainContainer">
        <div class="col-md-2">
            <? include 'assets/php/sidebar.php' ?>
        </div>
        <div class="container  sideMaincontent">
            <div class=" col-md-12 mb-2">
                <div class=" profile_card d-flex align-items-center" style="width: 100%; ">
                    
                    <div class="avatar me-2" style="width: 100px; height:auto">
                        <a href="profile.php?userId=<?= $userId ?>">
                            <img src="<?= viewProfilePic($db, $userId) ?>" alt="Default Image" class="img-fluid rounded-circle" onerror="this.onerror=null; this.src='assets/img/default.png';">
                        </a>
                    </div>

<div class="opinion_nameWithBio" style="width: 75%;">
                        <h3><?= showUserName($db, $userId); ?></h3>
                        <p class="card-text"><?= showInfluencerBio($db, $userId) ?></p>

</div>
                    <div class="Total_Opinions" style="width:fit-content; display:flex">
                        <span class="opinion_count" id="totalOpinionsCount"><?= showOpinionNum($db, $userId) ?></span>
                        <p class="opinion-text"> Opinion</p>
                    </div>
                </div>

</div>

<div class="card-container row" id="news-container" style="width:100%">

<? show_influencer_articles($db, $userId) ?>

</div>
        </div>
    </div>
    <? include 'assets/php/bottom_navbar.php' ?>

</body>

</html>