OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	03/31/2025 06:36:42 AM	rwxr-xr-x
📁 assets	-	03/26/2025 04:20:58 AM	rwxr-xr-x
📄 brss_feed_articles.php	4.8 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 brss_feed_store.php	3.77 KB	03/26/2025 03:47:57 AM	rw-r--r--
📁 css	-	03/26/2025 04:16:40 AM	rwxr-xr-x
📄 fetch_articles.html	317 bytes	03/26/2025 03:47:57 AM	rw-r--r--
📁 fonts	-	03/26/2025 04:06:52 AM	rwxr-xr-x
📁 images	-	03/26/2025 04:06:54 AM	rwxr-xr-x
📄 index.php	6.03 KB	03/26/2025 03:47:57 AM	rw-r--r--
📁 js	-	03/26/2025 04:06:54 AM	rwxr-xr-x
📄 l2.html	14.08 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 rss_feed_articles.php	3.86 KB	03/26/2025 03:47:57 AM	rw-r--r--
📄 rss_feed_store.php	3.76 KB	03/26/2025 03:47:57 AM	rw-r--r--
📁 scss	-	03/26/2025 04:16:40 AM	rwxr-xr-x
📄 test3.php	10.45 KB	03/26/2025 03:47:57 AM	rw-r--r--

Editing: brss_feed_articles.php

<?php

// Include SimplePie library
// require_once('/var/www/reader/inc/simplepie/autoloader.php');
require_once(__DIR__ . '/../inc/simplepie/autoloader.php');

// Database connection details
$host = '139.59.38.164'; // or your database host
$dbname = 'reader';
$username = 'root';
$password = 'newstart';

// Create a mysqli instance for database connection
$mysqli = new mysqli($host, $username, $password, $dbname);

// Check the connection
if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
}

// Fetch RSS feed URLs from the database
$sql = 'SELECT rss_id, rss_url FROM rss_feeds_url';
$result = $mysqli->query($sql);

// Check if the query was successful
if (!$result) {
    die('Query Error: ' . $mysqli->error);
}

// Loop through each RSS feed URL
while ($row = $result->fetch_assoc()) {

$feedUrl = $row['rss_url'];
    $feedId = $row['rss_id'];
    //echo $feedUrl . "<br>" . "<hr>" ;

// // Initialize SimplePie
    // $rss = new SimplePie\SimplePie();
    // $rss->set_feed_url($feedUrl);
    // $rss->init();
    // $rss->handle_content_type();
    //  // Disable caching
    //  $rss->enable_cache(false);

$rss = new SimplePie();
    $rss->set_feed_url($feedUrl);
    $rss->enable_cache(false);
    $rss->init();
    $rss->handle_content_type();

// Check for errors
    if ($rss->error()) {
        echo "Error fetching feed: " . $rss->error();
        continue;
    }

// Loop through each item in the RSS feed
    foreach ($rss->get_items() as $item) {
        $title = $mysqli->real_escape_string($item->get_title());
        $url = $mysqli->real_escape_string($item->get_permalink());
        $description = $mysqli->real_escape_string($item->get_description());
        $content = $mysqli->real_escape_string($item->get_content());
        $author = $mysqli->real_escape_string($item->get_author() ? $item->get_author()->get_name() : '');
        //echo $url . "<br>";

$image = '';

// // Handle enclosure tag
// if ($item->get_enclosure()) {
//     $image = $mysqli->real_escape_string($item->get_enclosure()->get_link());
// } else {
//     // Handle media:thumbnail tag
//     $namespaces = $item->get_namespaces(true);
//     if (isset($namespaces['media'])) {
//         $media_elements = $item->get_elements_by_tag_name('media:group');
//         if (!empty($media_elements)) {
//             $image = $mysqli->real_escape_string($media_elements[0]->get_attribute('url'));
//         }
//     }
// }
// 
// // Do something with the $image

// Handle enclosure tag
if ($item->get_enclosure()) {
    $image = $mysqli->real_escape_string($item->get_enclosure()->get_link());
    echo "encloser; " . $image . "<br>"; 
} else {
    // Handle media:thumbnail within media:group
    $namespaces = $item->get_namespaces(true);
    if (isset($namespaces['media'])) {
        $media_groups = $item->get_elements_by_tag_name('media:group');
        if (!empty($media_groups)) {
            // Find media:thumbnail within media:group
            $media_thumbnails = $media_groups[0]->get_elements_by_tag_name('media:thumbnail');
            if (!empty($media_thumbnails)) {
                $image = $mysqli->real_escape_string($media_thumbnails[0]->get_attribute('url'));
                echo "media; " . $image . "<br>"; 
            }
        }
    }
    else echo "not running nmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm";
}
        
        //$image = $mysqli->real_escape_string($item->get_enclosure() ? $item->get_enclosure()->get_link() : '');
        $date = $mysqli->real_escape_string($item->get_date('Y-m-d H:i:s'));

// Process categories
        $categories = $item->get_categories();
        if ($categories && is_array($categories)) {
            $categoryNames = array_map(function ($cat) {
                return htmlspecialchars($cat->get_label());
            }, $categories);
            $categoryString = implode(', ', $categoryNames);
        } else {
            $categoryString = ''; // Or you can set it to an empty string ''
        }

// Prepare SQL to insert article into the database
        $sql = 'INSERT IGNORE INTO rss_feeds_articles (feed_id, url, title, description, content, author, image, category, date) 
                VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)';
        $stmt = $mysqli->prepare($sql);
        $stmt->bind_param('issssssis', $feedId, $url, $title, $description, $content, $author, $image, $categoryString, $date);

// Execute the query
        if (!$stmt->execute()) {
            echo "Error inserting article: " . $stmt->error;
        }

$stmt->close();
    }
}

// Close the database connection
$mysqli->close();

echo "Articles Updated Successfully at ". date('Y-m-d H:i:s')."\n";