Replacing strings from an RSS feed

[Baldwin238]

Ok.. This is going to fairly long and complicated (at least for me).

The long and short of it....I am taking a feed and putting it onto my site at (

http://www.absolutelyfreerolls.com/php_free.php),

The feed (or a portion of it) is here:

- <tournament>
  <time>12:15 AM</time> 
  <type>No Limit Texas Holdem</type> 
  <payout>$50</payout> 
  <sitename>Absolute Poker</sitename> 
  <sitelink>[URL unfurl="true"]http://www.xxxx.com/fclick/fclick.php?fid=absolute</sitelink>[/URL] 
  </tournament>
- <tournament>
  <time>12:50 AM</time> 
  <type>No Limit Texas Holdem</type> 
  <payout>$1250</payout> 
  <sitename>Party Poker</sitename> 
  <sitelink>[URL unfurl="true"]http://www.xxxx.com/fclick/fclick.php?fid=partypoker</sitelink>[/URL] 
  </tournament>
- <tournament>
  <time>01:00 AM</time> 
  <type>No Limit Texas Holdem</type> 
  <payout>$1000</payout> 
  <sitename>Gaming Club Poker</sitename> 
  <sitelink>[URL unfurl="true"]http://www.xxxx.com/fclick/fclick.php?fid=gamingclub2</sitelink>[/URL] 
  </tournament>

The sections where it says <sitelink> I want to add to my site, but with MY referral links in it. The ones currently there are for a different site.

Can I do an if..then statement with a replace function in there as well? I am an .asp person and am not sure ow to even go about STARTING this. The code I have on my site to get the feed as it is now is...

<?php 
$file = '[URL unfurl="true"]http://www.freerolls.net/feed.php';[/URL] 
require_once('xml.parser.class.php'); 

$xml = new xml_parser_class(); 
$xml->parseFile($file); 
$tree = $xml->getTree(); 
unset($xml); 

print '<table border="0" cellpadding="2" cellspacing="0" width="" class="tm">';
print '<tr class="caption"><td>Time (Eastern)</td><td>Payouts</td><td>Site</td></tr>';

$i = 0;
foreach($tree['freerolls']['tournament'] as $k)
{
   $i++;
   print '<tr class="'.(!($i%2)?'rl':'rd').'">';
   print '<td>'.$k['time']['value'].'</td>';
   print '<td>'.$k['payout']['value'].'</td>';
   print '<td>'.$k['sitename']['value'].'</td>';
   print '</tr>';
}
print '</table>';

?>

Any suggestions would be greatly appreciated!

Jeff Baldwin

http://www.absolutelyfreerolls.com

http://www.golf.jbaldwin.net

 

[DRJ478]

Of course, you can manipulate the content in any way. A simple string manipulation for the links should solve your problem.

You can access the URL as $k['sitelink']['value']. Describe your referral link and we'll help you on the way.

 

[Baldwin238]

My referral link is different for every different ['sitelink'] as the original one is as well. An example of one my links would be:

[URL unfurl="true"]http://www.example_ref_link.com/main.asp?host=a_77a_11221b_2320[/URL]

This link would of course change being dependant on the [sitename]. Would I need to start a mySQL database of all my links? Making them, for example,

[URL unfurl="true"]http://www.absolutelyfreerolls.com/ref/refclick.php?fid=example_ref_link[/URL]

Or am I getting too far ahead of myself?


Jeff Baldwin

http://www.absolutelyfreerolls.com

http://www.golf.jbaldwin.net

 

[DRJ478]

How many different sites are there?
If it is a manageable number you could keep them in a flat file. If the number is larger, a database solution is recommendable.

But, if I understand correctly, above the only substitution I see is that the new URL has the GET parameter fid as hostname and an attached GET parameter host=a_....
If that is the only thing that needs to be translated, there is no need for a datafile or database.

$URL = "[URL unfurl="true"]http://www.absolutelyfreerolls.com/ref/refclick.php?fid=example_ref_link";[/URL]
$analyzedURL = parse_url($URL);
# $analyzedURL['query'] holds fid=example_ref_link
preg_match("/fid=(\w*)/",$analyzedURL['query'],$reflink);
print_r($reflink);
$newURL = "[URL unfurl="true"]http://www.".$reflink[/URL][1].".com/main.asp?host=a_77a_11221b_2320";
echo("Before: $URL<br />");
echo("After : $newURL");

 

[Baldwin238]

I think we've deviated from what I was originally asking. The feed is from another site/author. The [sitelink] data in the feed is for his own links. I want those to be replaced with my links. So far I have about 25 different links, with the possibilty of adding more in the future. Every link is completely different. I was thinking of setting up a database which holds MY links and an ID:

TABLE NAME: reflinks
======================================================
| ID | LINKS |
======================================================
|absolute |

http://www.xxx.com/main.asp?host=a_77a_aa

|
|pokerCS |

http://www.yyy.com/987458754678709560/

|
|titan |

http://www.zzz.com/click/xxxx/8y7458745/

|
======================================================

Then using the url below to pull the link from the database:

[URL unfurl="true"]http://www.absolutelyfreerolls.com/reflinks.php?fid=absolute[/URL]

I guess my main question is..how do I replace the FEED AUTHOR's [sitelink] with my own links from the table? I think I understand how, I just dont know how to implement it?

Jeff Baldwin

http://www.absolutelyfreerolls.com

http://www.golf.jbaldwin.net

 

[DRJ478]

The steps are:
1. Find the record in the table that corresponds to the original link.
2. Print the proprietary link from the record into the desired space.

The basic steps how to connect, query, and retrieve data from a MySQL server are described in faq434-3850