[RESOLVED] XML from Burning Board

PaPPy

im trying to make a script to display XML of the latest posts on a burning board
particullay http://board.bitefight.org/

it should be easy espically cause the board offers this page: http://board.bitefight.org/search.php?action=24h
and thats 20 results of the last 24 hours (20 seems alot so 10 would do for now, if its doable leave as an option to change)

i know you can do a file_get_contents and all that jazz but i have no clue about the whole XML process

can someone help me out?

thanks,
PaPPy

PaPPy

/cry no luck anyone out there that can help out?

joelucas

Do you want xml as a raw xml file, or are you thinking of an RSS feed? Creating xml with php is fairly easy, first you want to set up your database statements and perform a query that returns the data your looking for. From there, you can just echo the results into a structured xml file. Just remember to put the xml headers in the file as well.

PaPPy

i would like to make a feed for other users to be able to use as they see fit

i forgot to state that this isnt on my site, the board is on someone elses site

PaPPy

i found some code that use to be used to pull new threads from matrix online
http://thematrixonline.station.sony.com

ive tried changing it around to work with what i need and no luck. i dont get any errors i just get the info i manually entered

<?PHP

// Cache settings.
$cachefile = "bf.cache";
$cachetime = 1800;


// Find out how long ago we cached.
$cachefile_created = (@file_exists($cachefile)) ? @filemtime($cachefile) : 0;
@clearstatcache();


if ((time() - $cachetime) > $cachefile_created) {
    // Cache is old or missing; rebuild it.
    $temp = build_dno_rss("http://board.bitefight.org/search.php?action=24h", "http://board.bitefight.org/search.php?action=24h");
    @unlink($cachefile);
    $fp = @fopen($cachefile, "w");
    @fwrite($fp, $temp);
    @fclose($fp);
}


// Make sure the agent knows we're sending XML, even though we're ".php".
header("Content-Type: application/xml; charset=ISO-8859-1");

// Send the XML.
@readfile($cachefile);


function build_dno_rss($mainURL, $newsURL) {
    global $cachetime;

    // Get the data.
    $data = file_get_contents($mainURL);
    $lines = array();
    $temp = explode("\n", $data);
    foreach($temp as $line) {
        if (trim($line) != "") {
            $lines[] = trim($line);
        }
    }


    // Header
    $now = date("D, d M Y H:i:s") ." GMT";
    $rss =
    "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>" .
    "<rss version=\"2.0\">" .
    "<channel>"  .
        "<title>Bite Fight RSS</title>" .
        "<description>Bite Fight's Forum</description>" .
        "<link>http://board.bitefight.org</link>" .
        "<language>en-us</language>" .
        "<generator>http://www.pappyspage.com</generator>" .
        "<lastBuildDate>$now</lastBuildDate>" .
        "<ttl>" .($cachetime / 60) ."</ttl>";

    // Parse out the news items.
    for ($i = 0; $i < count($lines); $i++) {
        if ($lines[$i] == '</span> <') {
            // Get the title.
            $title = "";
            do {
                $title .= " " .$lines[++$i];
            } while (substr($lines[$i], -4) != "</a>");
            $title = ereg_replace("&.*;", "", strip_tags(trim($title)));

            // Get the description.
            $i += 6;
            $description = "";
            do {
                $end = ereg("(.*)<a href=\"(.*)\"", $lines[++$i], $regs);
                if ($end) {
                    $description .= " " .$regs[1];
                    break;
                } else {
                    $description .= " " .$lines[$i];
                }
            } while (true);
            $description = strip_tags(trim($description));

            // Get the URL.
            $url = $newsURL .$regs[2];

            // Get the date.
            $i += 1;
            $date = ereg_replace(".*- (.*)</span><br />.*", "\\1", $lines[$i]);
            $dateParts = explode("/", $date);
            $pubDate = date("D, d M Y H:i:s", mktime(0, 0, 0, $dateParts[0], $dateParts[1], $dateParts[2])) ." PST";

            // Add item to the RSS.
            $rss .=
            "<item>" .
                "<title>" .EncodeXmlEntities($title) ."</title>" .
                "<link>" .EncodeXmlEntities($url) ."</link>" .
                "<guid>" .EncodeXmlEntities($url) ."</guid>" .
                "<description>" .EncodeXmlEntities($description) ."</description>" .
                "<pubDate>" .EncodeXmlEntities($pubDate) ."</pubDate>" .
            "</item>";
        }
    }

    // Footer.
    $rss .=
    "</channel>" .
    "</rss>";

    return $rss;
}


// Encode the XML special characters into their entity equivalents.
function EncodeXmlEntities($str) {
    return str_replace(
        array ('&',     '"',      "'",       '<',     '>' ),
        array ('&amp;', '&quot;', '&apos;' , '&lt;' , '&gt;' ),
        $str
    );
}

?>

if somoene can show me my mistakes or write something that works with what i need. id appricate it very much

joelucas

foreach($temp as $line) {
if (trim($line) != "") {
$lines[] = trim($line);
}
}

I would rewrite this code as:

foreach($temp as $k=>$v){
if(trim($v)!=''){
$lines[$k]=trim($v);
}
}

right after that snippet, I would then add:
print_r($lines);

And see the contents of that array, make sure it's building right. I think that's your problem, that array's not actually populating with any data.

PaPPy

ty for the example will try when i get home

well that made it out a lot of data
my example here:
http://pappyspage.com/test/bf.php

dont exactly know what all of it means, nor what to do with it

<?PHP

// Cache settings.
$cachefile = "bf.cache";
$cachetime = 1800;


// Find out how long ago we cached.
$cachefile_created = (@file_exists($cachefile)) ? @filemtime($cachefile) : 0;
@clearstatcache();


if ((time() - $cachetime) > $cachefile_created) {
    // Cache is old or missing; rebuild it.
    $temp = build_dno_rss("http://board.bitefight.org/search.php?action=24h", "http://board.bitefight.org/search.php?action=24h");
    @unlink($cachefile);
    $fp = @fopen($cachefile, "w");
    @fwrite($fp, $temp);
    @fclose($fp);
}


// Make sure the agent knows we're sending XML, even though we're ".php".
header("Content-Type: application/xml; charset=ISO-8859-1");

// Send the XML.
@readfile($cachefile);


function build_dno_rss($mainURL, $newsURL) {
    global $cachetime;

    // Get the data.
    $data = file_get_contents($mainURL);
    $lines = array();
    $temp = explode("\n", $data);
    foreach($temp as $k=>$v){

if(trim($v)!=''){
$lines[$k]=trim($v);
}
}
print_r($lines);

    // Header
    $now = date("D, d M Y H:i:s") ." GMT";
    $rss =
    "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>" .
    "<rss version=\"2.0\">" .
    "<channel>"  .
        "<title>Bite Fight RSS</title>" .
        "<description>Bite Fight's Forum</description>" .
        "<link>http://board.bitefight.org</link>" .
        "<language>en-us</language>" .
        "<generator>http://www.pappyspage.com</generator>" .
        "<lastBuildDate>$now</lastBuildDate>" .
        "<ttl>" .($cachetime / 60) ."</ttl>";

    // Parse out the news items.
    for ($i = 0; $i < count($lines); $i++) {
        if ($lines[$i] == '</span> <') {
            // Get the title.
            $title = "";
            do {
                $title .= " " .$lines[++$i];
            } while (substr($lines[$i], -4) != "</a>");
            $title = ereg_replace("&.*;", "", strip_tags(trim($title)));

            // Get the description.
            $i += 6;
            $description = "";
            do {
                $end = ereg("(.*)<a href=\"(.*)\"", $lines[++$i], $regs);
                if ($end) {
                    $description .= " " .$regs[1];
                    break;
                } else {
                    $description .= " " .$lines[$i];
                }
            } while (true);
            $description = strip_tags(trim($description));

            // Get the URL.
            $url = $newsURL .$regs[2];

            // Get the date.
            $i += 1;
            $date = ereg_replace(".*- (.*)</span><br />.*", "\\1", $lines[$i]);
            $dateParts = explode("/", $date);
            $pubDate = date("D, d M Y H:i:s", mktime(0, 0, 0, $dateParts[0], $dateParts[1], $dateParts[2])) ." PST";

            // Add item to the RSS.
            $rss .=
            "<item>" .
                "<title>" .EncodeXmlEntities($title) ."</title>" .
                "<link>" .EncodeXmlEntities($url) ."</link>" .
                "<guid>" .EncodeXmlEntities($url) ."</guid>" .
                "<description>" .EncodeXmlEntities($description) ."</description>" .
                "<pubDate>" .EncodeXmlEntities($pubDate) ."</pubDate>" .
            "</item>";
        }
    }

    // Footer.
    $rss .=
    "</channel>" .
    "</rss>";

    return $rss;
}


// Encode the XML special characters into their entity equivalents.
function EncodeXmlEntities($str) {
    return str_replace(
        array ('&',     '"',      "'",       '<',     '>' ),
        array ('&amp;', '&quot;', '&apos;' , '&lt;' , '&gt;' ),
        $str
    );
}

?>

just edited in the suggested code to display whats going on

PaPPy

still no luck anyone around to help get this working?

PaPPy

ok ive dropped all the code above and gone to what i know best, modifing the code below to get it to do what i want

what i did was elimate all table lines but the first entry, in order to figure things out and work from there

so this code works and pulls out the data i need and echos it
ex: http://pappyspage.com/test/bitefight.php

but i need to run this through all 20 items on the page. and that is the thing i am horrible at, looping. if someone can modify my code to echo out all 20 lines to look like the above link, i think i can do the RSS/XML from there on out

<?

$level="1";              //Do you want to show your level? 0 For no 1 for yes
$gold="1";               //Do you want to show how much gold you have? 0 for no 1 for yes
$booty="1";              //Do you want to show how much booty you've earned? 0 for no 1 for yes
$victories="1";          //Do you want to show your victories? 0 for no 1 for yes
$goldcap="1";            //Do you want to show how much gold you have captured? 0 for no 1 for yes
$damage="1";             //Do you want to show how much damaged you've caused? 0 for no 1 for yes
define('CACHE_FILE', 'bitetest.html'); // Where we store a local copy of the feed for caching purposes(can change)
$result = file_get_contents(CACHE_FILE);      // Use cache (html code from our cache file)


//Get thred number
$levelb = '&nbsp;<a href="thread.php?threadid=';
$levele = '&amp;goto=lastpost">';


if ( ( $pos1 = strpos ( $result, $levelb ) ) !== false  and $level =="1")
{
    $result1 = substr ( $result, ( $len1 = ( $pos1 + strlen ( $levelb ) ) ), ( strpos ( $result, $levele, $len1 ) - $len1 ) );

}
//Get thred number

//Get date
$tgoldb = '<td align="right" nowrap="nowrap"><span class="smallfont"><b>';
$tgolde = '</b>';

if ( ( $pos2 = strpos ( $result, $tgoldb ) ) !== false  and $gold =="1")
{
    $result2 = substr ( $result, ( $len2 = ( $pos2 + strlen ( $tgoldb ) ) ), ( strpos ( $result, $tgolde, $len2 ) - $len2 ) );

}
//Get date

//Get forum
$bootyb = '<br />Forum:';
$bootye = '</a>';

if ( ( $pos3 = strpos ( $result, $bootyb ) ) !== false  and $booty =="1")
{
    $result3 = substr ( $result, ( $len3 = ( $pos3 + strlen ( $bootyb ) ) ), ( strpos ( $result, $bootye, $len3 ) - $len3 ) );

}
//Get forum

//Get time
$victoriesb = '<span class="time">';
$victoriese = '</span>';

if ( ( $pos4 = strpos ( $result, $victoriesb ) ) !== false  and $victories =="1")
{
    $result4 = substr ( $result, ( $len4 = ( $pos4 + strlen ( $victoriesb ) ) ), ( strpos ( $result, $victoriese, $len4 ) - $len4 ) );

}
//Get time

//Get poster
$goldcapb = 'by <b>';
$goldcape = '</a>';

if ( ( $pos5 = strpos ( $result, $goldcapb ) ) !== false  and $goldcap =="1")
{
    $result5 = substr ( $result, ( $len5 = ( $pos5 + strlen ( $goldcapb ) ) ), ( strpos ( $result, $goldcape, $len5 ) - $len5 ) );
//Get poster

//Get 
}

$damageb = '</span>
  <a';
$damagee = '</a>';

if ( ( $pos6 = strpos ( $result, $damageb ) ) !== false  and $damage =="1")
{
    $result6 = substr ( $result, ( $len6 = ( $pos6 + strlen ( $damageb ) ) ), ( strpos ( $result, $damagee, $len6 ) - $len6 ) );


}
//Get 



$strip1 = strip_tags($result1);
$strip2 = strip_tags($result2);
$strip3 = strip_tags($result3);
$strip4 = strip_tags($result4);
$strip5 = strip_tags($result5);
$result6 = '<a' .$result6;
$strip6 = strip_tags($result6);

echo $strip1;
echo '<br>';
echo $strip2;
echo '<br>';
echo $strip3;
echo '<br>';
echo $strip4;
echo '<br>';
echo $strip5;
echo '<br>';
echo $strip6;
echo '<br>';

?>

some of the variable names are from the other script but i can obviously change that later, i just want to get something working and then ill find toon the crap out of it later

PaPPy

im sure this isnt the best way to do this but heck it works
if yall want to help me clean up the code
cool but if not im considering this fixed

i recieved help and ideas from my good old friend wh1tedr4gon

here is my final code

<?
//Created by PaPPy & Wh1teDr4gon
//Created on May 14th 2006
header("Content-Type: application/xml; charset=ISO-8859-1");


function EncodeXmlEntities($str) {
        return str_replace(
            array ('&',     '"',      "'",       '<',     '>' ),
            array ('&amp;', '&quot;', '&apos;' , '&lt;' , '&gt;' ),
            $str
        );
    }


define('CACHE_TIME', 5 * 60);       // Cache time in seconds (5 mins)
define('CACHE_FILE', 'bf.cache'); // Where we store a local copy of the feed for caching purposes(can change)


if (time() - filemtime(CACHE_FILE) < CACHE_TIME)  // Is our cache file new enough to use?
{
    $result = file_get_contents(CACHE_FILE);      // Use cache (html code from our $destination)

} else {
    // Cache expired, download new copy, and grab its contents ($result)



$result = file_get_contents('http://board.bitefight.org/search.php?action=24h');


$fp= fopen(CACHE_FILE, 'w');							     //Dump html source code to cachfile
fwrite ($fp, $result); 								     //Dump html source code to cachfile
fclose($fp);									     //Dump html source code to cachfile

}


$now = date("D, d M Y H:i:s") ." EST";
$rss =
        "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>" .
        "<rss version=\"2.0\">" .
        "<channel>"  .
            "<title>Bite Fight RSS</title>" .
            "<description>Bite Fight's Forum</description>" .
            "<link>http://board.bitefight.org</link>" .
            "<language>en-us</language>" .
            "<generator>http://www.pappyspage.com</generator>" .
            "<lastBuildDate>$now</lastBuildDate>" .
            "<ttl>" .(CACHE_TIME / 60) ."</ttl>";






for($i=0;$i<20;$i++)

{


//Get thred number
$thrednumb = '&nbsp;<a href="thread.php?threadid=';
$thrednume = '&amp;goto=lastpost';


if ( ( $pos1 = strpos ( $result, $thrednumb ) ) !== false)
{
    $result1 = substr ( $result, ( $len1 = ( $pos1 + strlen ( $thrednumb ) ) ), ( strpos ( $result, $thrednume, $len1 ) - $len1 ) );


}
//Get thred number

//Get date
$postdateb = '<td align="right" nowrap="nowrap"><span class="smallfont"><b>';
$postdatee = '</b>';

if ( ( $pos2 = strpos ( $result, $postdateb ) ) !== false)
{
    $result2 = substr ( $result, ( $len2 = ( $pos2 + strlen ( $postdateb ) ) ), ( strpos ( $result, $postdatee, $len2 ) - $len2 ) );

}
//Get date

//Get forum
$forumnameb = '<br />Forum:';
$forumnamee = '</a>';

if ( ( $pos3 = strpos ( $result, $forumnameb ) ) !== false)
{
    $result3 = substr ( $result, ( $len3 = ( $pos3 + strlen ( $forumnameb ) ) ), ( strpos ( $result, $forumnamee, $len3 ) - $len3 ) );

}
//Get forum

//Get time
$posttimeb = '<span class="time">';
$posttimee = '</span>';

if ( ( $pos4 = strpos ( $result, $posttimeb ) ) !== false)
{
    $result4 = substr ( $result, ( $len4 = ( $pos4 + strlen ( $posttimeb ) ) ), ( strpos ( $result, $posttimee, $len4 ) - $len4 ) );

}
//Get time

//Get poster
$posterb = 'by <b>';
$postere = '</a>';

if ( ( $pos5 = strpos ( $result, $posterb ) ) !== false)
{
    $result5 = substr ( $result, ( $len5 = ( $pos5 + strlen ( $posterb ) ) ), ( strpos ( $result, $postere, $len5 ) - $len5 ) );
//Get poster

//Get subject
}

$postsubb = '</span>
  <a';
$postsube = '</a>';

if ( ( $pos6 = strpos ( $result, $postsubb ) ) !== false)
{
    $result6 = substr ( $result, ( $len6 = ( $pos6 + strlen ( $postsubb ) ) ), ( strpos ( $result, $postsube, $len6 ) - $len6 ) );


}
//Get subject

$result = str_replace($thrednumb . $result1 . $thrednume, '~', $result);
$result = str_replace($postdateb . $result2 . $postdatee, '~~', $result);
$result = str_replace($forumnameb . $result3 . $forumnamee, '~~~', $result);
$result = str_replace($posttimeb . $result4 . $posttimee, '~~~~', $result);
$result = str_replace($posterb . $result5 . $postere, '~~~~~', $result);
$result = str_replace($postsubb . $result6 . $postsube, '~~~~~~', $result);


$strip1 = strip_tags($result1);
$strip2 = strip_tags($result2);
$strip3 = strip_tags($result3);
$strip4 = strip_tags($result4);
$strip5 = strip_tags($result5);
$result6 = '<a' .$result6;
$strip6 = strip_tags($result6);

$strip1 = "http://board.bitefight.org/thread.php?threadid=" .$strip1. "&goto=lastpost";
$descr = $strip5 . " posted about '" . $strip6 . "' in the " . $strip3 . " forums.";





            $rss .=
            "<item>" .
                "<title>" .EncodeXmlEntities($strip6) ."</title>" .
                "<link>" .EncodeXmlEntities($strip1) ."</link>" .
                "<guid>" .EncodeXmlEntities($strip1) ."</guid>" .
                "<description>" .EncodeXmlEntities($descr) ."</description>" .
                "<pubDate>" .EncodeXmlEntities($strip2) . " @ " . EncodeXmlEntities($strip4) . " GMT(+1)" . "</pubDate>" .
            "</item>";

}

    // Footer.
    $rss .=
    "</channel>" .
    "</rss>";

    echo $rss;


?>

what i did was find the values of the first line, extracted it and then replaced them with ~'s. then looped so next time it searched it would come down to the next line of data to extract from

ran into a lot of problems but worked them out

thanks for all the help