<?php
/**
 * jobber job board platform
 *
 * @author     Filip C.T.E. <http://www.filipcte.ro> <me@filipcte.ro>
 * @license    You are free to edit and use this work, but it would be nice if you always referenced the original author ;)
 *             (see license.txt).
 */

    require_once 'config.php';
    require_once '_includes/simplepie.inc';
    require_once '_includes/class.FeedToDB.php';

    // select all feeds that are active
    $sql = 'SELECT * FROM feed_db WHERE is_active = 1';
    $result = $db->query($sql);
    while ($row = $result->fetch_assoc())
    {    
        if (isset($row['url']))
        {
            $url = $row['url'];
             
            $feed = new SimplePie();
            $todb = new FeedToDB();
            
            $data = array();
            
            $feed->set_feed_url($url);
            
            $success = $feed->init();
            
            $feed->handle_content_type();
             
            // default starting item
            $start = 0;
             
            // default number of items to display. 0 = all
            $length = 0; 
             
            // if single item, set start to item number and length to 1
            /*
            if(isset($_GET['item']))
            {
                    $start = $_GET['item'];
                    $length = 10;
            }
            */
             
            // set item link to script uri
            $link = $_SERVER['REQUEST_URI'];
             
            if ($success)
            {
                $type_id = $row['type_id'];
                $category_id = $row['category_id'];
                $company = $row['company'];
                $poster_email = $row['poster_email'];
                $database = $row['database'];
                    
                // loop through items
                foreach($feed->get_items($start,$length) as $key=>$item)
                {
                 
                        // set query string to item number
                        $queryString = '?item=' . $key;
                 
                        // if we're displaying a single item, set item link to itself and set query string to nothing
                        if(isset($_GET['item']))
                        {
                                $link = $item->get_link();
                                $queryString = '';        
                        }
                 
                        // display item title and date    
                        echo '<a href="' . $item->get_permalink() . '">' . $item->get_title() . '</a>';
                        echo ' <small>'.$item->get_date('j M Y, H:i:s O').'</small><br>';
                        echo ' <small>'.$item->get_content().'</small><br>';
                        echo ' <small>'.$item->get_permalink().'</small><br>';
                        echo '<br>';
                        
                        $permalink = $item->get_permalink();
                        
                        $title = get_title();
                        $rssdate = $item->get_date();
                        $content = addslashes(trim($item->get_description()));
                        
                        $location = get_location();
                        $url =  $permalink;
                        $desc =  strip_tags(trim($content));
                        
                        /*
                        echo "loc:" .$location ."<br/>";
                        echo "url:" .$url ."<br/>";
                        echo "desc:" .$desc ."<br/>";
                        */
                        
                        $data = array('database' => $database, 
                                    'type_id' => $type_id, 
                                    'category_id' => $category_id, 
                                    'title' => $title, 
                                    'description' => $desc, 
                                    'company' => $company,                        
                                    'url' => $url, 
                                    'location' => $location, 
                                    'created_on' => $rssdate,
                                    'poster_email' => $poster_email);
                                    
                        $todb->save($data);            
                        
                }
            }
            else
            {
            
                    // Check to see if there are more than zero errors (i.e. if there are any errors at all)
                    if ($feed->error())
                    {
                        // If so, start a <div> element with a classname so we can style it.
                        echo '<div class="sp_errors">' . "\r\n";

                            // ... and display it.
                            echo '<p>' . htmlspecialchars($feed->error()) . "</p>\r\n";

                        // Close the <div> element we opened.
                        echo '</div>' . "\r\n";
                    }
            
            }
        }
        
        echo "<strong>Feed upload for ". $row['database'] ." - ". $row['category_label'] ." completed.</strong><br /><br />";
    }    
?>

<?php
/**
 * jobber job board platform
 *
 * @author     RedJumpsuit <myredjumpsuit@gmail.com>
 * 
 * FeedToDB class handles feeding RSS/XML feed to MySQL
 * Thanks to SimplePie :)
 *
 */

class FeedToDB
{
    
    function __construct()
    { }
    
    public function save($data)
    {
    
        global $db;
    
        // category
        
        $dbname = $data['database'];
        $category_id = $data['category_id'];
        
        /*
        if (!is_numeric($category_id) && strstr($category_id, "|"))
        {
            $cats = array();
            $cats = explode("|", $category_id);
            
            $dbname = trim($cats[0]);
            $category_id = trim($cats[1]);
        }
        */
        
        $sqldup = 'SELECT * FROM '. $dbname.'.jobs WHERE url = "'. trim($data['url']) .'"';
        $resultdup = $db->query($sqldup);
        $rowdup = $resultdup->fetch_assoc();

        if (!$rowdup)
        {
            $sqlcity = 'SELECT id FROM '. $dbname.'.cities WHERE name LIKE "%'. $data['location'] .'%"';
            $resultcity = $db->query($sqlcity);
            $rowcity = $resultcity->fetch_assoc();
            
            if (is_numeric($rowcity['id']) && $rowcity['id'] > 0)
            {
                $city_id = $rowcity['id'];
                $outside_location = '';
            }
            else
            {
                $city_id = -1;
                $outside_location = $data['location'];
            }
        
                $sql = 'INSERT INTO '. $dbname.'.jobs (type_id, category_id, title, description, company, city_id, url, created_on, is_temp, is_active,
                    views_count, auth, outside_location, poster_email, apply_online)
                    VALUES (' . $data['type_id'] . ',
                         ' . $category_id . ',
                         "' . $data['title'] . '",
                         "' . $data['description'] . '",
                         "' . $data['company'] . '",
                         ' . $city_id . ',
                         "' . $data['url'] . '",
                         NOW(), 0, 1, 0, "' . md5(uniqid() . time()) . '", 
                         "' . $outside_location . '", "' . $data['poster_email'] . '", 0)';
        
                $db->query($sql);
        }
        else
        {
            echo "<strong>FAILED: This Job already exists! </strong><br /><br />";
        }
    }
?>

--
-- Table structure for table `feed_db`
--

CREATE TABLE IF NOT EXISTS `feed_db` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `database` varchar(255) NOT NULL,
  `is_active` int(4) NOT NULL DEFAULT '0',
  `type_id` int(4) NOT NULL,
  `category_id` int(4) NOT NULL,
  `category_label` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `poster_email` varchar(255) NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=333 ;

--
-- Dumping data for table `feed_db`
--

INSERT INTO `feed_db` (`id`, `database`, `is_active`, `type_id`, `category_id`, `category_label`, `company`, `poster_email`, `url`) VALUES
(1, 'yourdbname', 0, 0, 3, 'Name For The Incoming Rss Feed', 'company name where you get feed from', 'Email-needs-changing-If-left-out-use-apply-now-mod@localhost.com', 'http://www.example.com/anothejobberbaserssfeed/'),
(2, 'yourdbname', 0, 0, 45, 'Jobs for testers rss', 'jobberbase.com', '', 'http://www.example.com/anothejobberbaserssfeed1/');

(1, 'yourdbname', 0, 0, 3, 'Name For The Incoming Rss Feed', 'company name where you get feed from', 'Email-needs-changing-If-left-out-use-apply-now-mod@localhost.com', 'http://www.example.com/anothejobberbaserssfeed/'),
(2, 'yourdbname', 0, 0, 45, 'Jobs for testers rss', 'jobberbase.com', '', 'http://www.example.com/anothejobberbaserssfeed1/'),
(3, 'yourdbname', 0, 0, 45, 'Jobs for senior testers rss', 'jobberbase.com', '', 'http://www.example.com/anothejobberbaserssfeed2/');

<?php
/**
 * jobber job board platform
 *
 * @author     Filip C.T.E. <http://www.filipcte.ro> <me@filipcte.ro>
 * @license    You are free to edit and use this work, but it would be nice if you always referenced the original author ;)
 *             (see license.txt).
 */

    require_once 'config.php';
    require_once '_includes/simplepie.inc';
    require_once '_includes/class.FeedToDB.php';

    // select all feeds that are active
    $sql = 'SELECT * FROM feed_db WHERE is_active = 1';
    $result = $db->query($sql);
    while ($row = $result->fetch_assoc())
    {    
        if (isset($row['url']))
        {
            $url = $row['url'];
             
            $feed = new SimplePie();
            $todb = new FeedToDB();
            
            $data = array();
            
            $feed->set_feed_url($url);
            
            $success = $feed->init();
            
            $feed->handle_content_type();
             
            // default starting item
            $start = 0;
             
            // default number of items to display. 0 = all
            $length = 0; 
             
            // if single item, set start to item number and length to 1
            /*
            if(isset($_GET['item']))
            {
                    $start = $_GET['item'];
                    $length = 10;
            }
            */
             
            // set item link to script uri
            $link = $_SERVER['REQUEST_URI'];
             
            if ($success)
            {
                $type_id = $row['type_id'];
                $category_id = $row['category_id'];
                $company = $row['company'];
                $poster_email = $row['poster_email'];
                $database = $row['database'];
                    
                // loop through items
                foreach($feed->get_items($start,$length) as $key=>$item)
                {
                 
                        // set query string to item number
                        $queryString = '?item=' . $key;
                 
                        // if we're displaying a single item, set item link to itself and set query string to nothing
                        if(isset($_GET['item']))
                        {
                                $link = $item->get_link();
                                $queryString = '';        
                        }
                 
                        // display item title and date    
                        echo '<a href="' . $item->get_permalink() . '">' . $item->get_title() . '</a>';
                        echo ' <small>'.$item->get_date('j M Y, H:i:s O').'</small><br>';
                        echo ' <small>'.$item->get_content().'</small><br>';
                        echo ' <small>'.$item->get_permalink().'</small><br>';
                        echo '<br>';
                        
                        $permalink = $item->get_permalink();
                
                        $title = addslashes(trim($item->get_title()));
                        $rssdate = $item->get_date();
                        $content = addslashes(trim($item->get_description()));
                        
                        $location = trim(strip_tags($todb->get_string_between($content, "Location:", "<br />")));
                        $url =  $permalink;
                        $desc =  strip_tags(trim($content));
                        
                        /*
                        echo "loc:" .$location ."<br/>";
                        echo "url:" .$url ."<br/>";
                        echo "desc:" .$desc ."<br/>";
                        */
                        
                        $data = array('database' => $database, 
                                    'type_id' => $type_id, 
                                    'category_id' => $category_id, 
                                    'title' => $title, 
                                    'description' => $desc, 
                                    'company' => $company,                        
                                    'url' => $url, 
                                    'location' => $location, 
                                    'created_on' => $rssdate,
                                    'poster_email' => $poster_email);
                                    
                        $todb->save($data);            
                        
                }
            }
            else
            {
            
                    // Check to see if there are more than zero errors (i.e. if there are any errors at all)
                    if ($feed->error())
                    {
                        // If so, start a <div> element with a classname so we can style it.
                        echo '<div class="sp_errors">' . "\r\n";

                            // ... and display it.
                            echo '<p>' . htmlspecialchars($feed->error()) . "</p>\r\n";

                        // Close the <div> element we opened.
                        echo '</div>' . "\r\n";
                    }
            
            }
        }
        
        echo "<strong>Feed upload for ". $row['database'] ." - ". $row['category_label'] ." completed.</strong><br /><br />";
    }
?>

<?php
/**
 * jobber job board platform
 *
 * @author     RedJumpsuit <myredjumpsuit@gmail.com>
 * 
 * FeedToDB class handles feeding RSS/XML feed to MySQL
 * Thanks to SimplePie :)
 *
 */

class FeedToDB
{
    
    function __construct()
    { }
    
    public function save($data)
    {
    
        global $db;
    
        // category
        
        $dbname = $data['database'];
        $category_id = $data['category_id'];
        
        /*
        if (!is_numeric($category_id) && strstr($category_id, "|"))
        {
            $cats = array();
            $cats = explode("|", $category_id);
            
            $dbname = trim($cats[0]);
            $category_id = trim($cats[1]);
        }
        */
        
        $sqldup = 'SELECT * FROM '. $dbname.'.jobs WHERE url = "'. trim($data['url']) .'"';
        $resultdup = $db->query($sqldup);
        $rowdup = $resultdup->fetch_assoc();

        if (!$rowdup)
        {
            $sqlcity = 'SELECT id FROM '. $dbname.'.cities WHERE name LIKE "%'. $data['location'] .'%"';
            $resultcity = $db->query($sqlcity);
            $rowcity = $resultcity->fetch_assoc();
            
            if (is_numeric($rowcity['id']) && $rowcity['id'] > 0)
            {
                $city_id = $rowcity['id'];
                $outside_location = '';
            }
            else
            {
                $city_id = -1;
                $outside_location = $data['location'];
            }
        
                $sql = 'INSERT INTO '. $dbname.'.jobs (type_id, category_id, title, description, company, city_id, url, created_on, is_temp, is_active,
                    views_count, auth, outside_location, poster_email, apply_online)
                    VALUES (' . $data['type_id'] . ',
                         ' . $category_id . ',
                         "' . $data['title'] . '",
                         "' . $data['description'] . '",
                         "' . $data['company'] . '",
                         ' . $city_id . ',
                         "' . $data['url'] . '",
                         NOW(), 0, 1, 0, "' . md5(uniqid() . time()) . '", 
                         "' . $outside_location . '", "' . $data['poster_email'] . '", 0)';
        
                $db->query($sql);
        }
        else
        {
            echo "<strong>FAILED: This Job already exists! </strong><br /><br />";
        }
    }
    
    public function get_string_between($string, $start, $end)
    {
        $string = " ".$string;
        
        $ini = strpos($string,$start);
        
        if ($ini == 0) return "";
        
        $ini += strlen($start);   
        
        $len = strpos($string,$end,$ini) - $ini;
        
        return substr($string,$ini,$len);
        
    }

}
?>