Importing Comments From flickr.com Into Pixelpost

#! /usr/bin/php
<!--?php 
# Connect to the database
$host     = "localhost";
$dbuser   = "MYSQL_PIXELPOST_USERID";
$dbpasswd = "MYSQL_PIXELPOST_PASSWD";
$database = "MYSQL_PIXELPOST_DB";
$connect  = mysql_connect($host, $dbuser, $dbpasswd) or die(mysql_error());
mysql_select_db($database,$connect) or die(mysql_error());
 
class FlickrRSSParser {
 
  # In Flickr's RSS file, all the information needed is contained in the &lt;item&gt; 
  # tags in the document. So the first global variable defined will be $insideitem, 
  # which will be set to true when entering an &lt;item&gt; tag and false when exiting one.
  var $insideitem  = false;
  var $tag         = "";
  var $title       = "";
  var $description = "";
  var $link        = "";
  var $pubdate     = "";
 
  # This function will be called by the XML parser whenever an opening tag is 
  # encountered
  # $parser will be passed a reference to the XML parser that is being used to 
  # parse the document
  # $tagName is the ALL-UPPERCASE (the PHP manual calls this 'case-folded')
  # version of the name of the opening tag that triggered the event
  # $attrs is an associative array of the attributes that are present in the tag
  # that triggered the event
  function startElement($parser, $tagName, $attrs) {
    if ($this-&gt;insideitem) {
      $this-&gt;tag = $tagName;
    } elseif ($tagName == "ITEM") {
      $this-&gt;insideitem = true;
    }
  }
 
  # $parser will be passed a reference to the XML parser that is being used to
  # parse the document
  # $tagName is the case-folded name of the closing tag that triggered the event
  function endElement($parser, $tagName) {
    if ($tagName == "ITEM") {
 
      # Image name: flickr.com displays the title as 'Comment on dsc_100-1234'
      # The filename is the 3rd array element
      $title        = htmlspecialchars(trim($this-&gt;title));
      $title        = explode(" ", $title);
      $filename     = $title[2];
 
      # Date/Time the comment was made (yyyy-mm-dd hh:mm:ss format)
      $pubdate      = htmlspecialchars(trim($this-&gt;pubdate));
      $pubdate      = strtotime($pubdate);
      $pubdate      = date("Y-m-d H:i:s", $pubdate);
 
      $paragraphs   = htmlspecialchars(trim($this-&gt;description));
      $paragraphs   = explode("&amp;lt;/p&amp;gt;", $paragraphs);
 
      # The description contains the link to comment-author's flickr profile and 
      # comment-author's name (first &lt;/p&gt;
&lt;p&gt; section)
      $paragraph0   = $paragraphs[0];
      $authorurl    = explode("&amp;quot;", $paragraph0);
      $author_url   = $authorurl[1];
 
      $authorname0  = explode("&amp;gt;", $paragraph0);
      $authorname1  = $authorname0[2];
      $authorname2  = explode("&amp;lt;", $authorname1);
      $author_name  = $authorname2[0];
 
      # The description also contains the comment-text (second &lt;/p&gt;
&lt;p&gt; section)
      # Basic substitutions are done, via ereg_replace(), to get the appropriate part
      # mysql_real_escape_string() is used to make sure comment_text is in MySQL friendly fashion
      $paragraph1   = $paragraphs[1];
      $commenttext  = explode("&amp;lt;p&amp;gt;", $paragraph1);
      $comment_text = $commenttext[1];
      $comment_text = ereg_replace("&amp;lt;br /&amp;gt;", "&lt;br&gt;\r\n", $comment_text);
      $comment_text = mysql_real_escape_string($comment_text);
 
      # The description also contains a link to image-thumbnail (second &lt;/p&gt;
&lt;p&gt; section)
      # but it's not required in this process - as such, it's ignored
 
      # flickr.com's IP address
      $flickr_ip    = gethostbyname('www.flickr.com');
 
      # Table structure for table `pixelpost_comments`
      #
      # CREATE TABLE IF NOT EXISTS `pixelpost_comments` (
      #   `id` int(11) NOT NULL auto_increment,
      #   `parent_id` int(11) NOT NULL default '0',
      #   `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
      #   `ip` varchar(20) NOT NULL default '',
      #   `message` text NOT NULL,
      #   `name` varchar(30) default NULL,
      #   `url` varchar(70) default NULL,
      #   `email` varchar(100) default NULL,
      #   `publish` char(3) NOT NULL default 'yes',
      #   `spaminess` float default NULL,
      #   `signature` varchar(55) default NULL,
      #   PRIMARY KEY  (`id`),
      #   KEY `parent_id` (`parent_id`)
      # ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
      #
      # To make sure that the comments from flickr.com are not duplicated,
      # add the following to 'pixelpost_comments' table - via command-line or
      # PHPMyAdmin.
      #
      # CREATE UNIQUE INDEX author_datetime ON `pixelpost_comments` (`name`,`datetime`);
      #

 
      # First, check if the flickr-image is in PIXELPOST database 
      # If exists, then get the corresponding POST ID (PARENT ID)
      $sql_q0       = "SELECT id, image FROM `MYSQL_DB`.`pixelpost_pixelpost` ";
      $sql_q0      .= "WHERE image='$filename.jpg' ORDER BY id DESC LIMIT 1 ";
      $result0      = mysql_query($sql_q0);
 
      # Proceed further, to make an entry into comments database, iff the
      # above query was successful
      if (!$result0) {
        die('Invalid query: ' . mysql_error());
      } else {
 
        while ($myrow = mysql_fetch_array($result0)) {
          $parent_id = $myrow['id'];
        }
 
        # Enter into the comments_table in database
        # INSERT IGNORE makes sure that duplicate entries, when exist, 
        # are ignored during insertion
        $sql_q1       = "INSERT IGNORE INTO `MYSQL_DB`.`pixelpost_comments` ";
        $sql_q1      .= "VALUES ('', '$parent_id', '$pubdate', '$flickr_ip', ";
        $sql_q1      .= "'$comment_text', '$author_name', '$author_url', ";
        $sql_q1      .= "'flickr@your-domain.com', 'yes', '', ''); ";
        $result1      = mysql_query($sql_q1);
 
        if (!$result1) {
          die('Invalid query: ' . mysql_error());
        }
 
        $this-&gt;title       = "";
        $this-&gt;description = "";
        $this-&gt;link        = "";
        $this-&gt;pubdate     = "";
        $this-&gt;insideitem  = false;
      }
    }
  }
 
  # $parser will be passed a reference to the XML parser that is being used to
  # parse the document
  # $data is a string of text appearing between XML tags in the document. 
  # The text between two tags will not necessarily trigger a single event. 
  # Blocks of text spread over multiple lines will cause one event per line, 
  # with each event being passed the $data for that line.
  function characterData($parser, $data) {
    if ($this-&gt;insideitem) {
      switch ($this-&gt;tag) {
        case "TITLE":
        $this-&gt;title .= $data;
        break;
        case "DESCRIPTION":
        $this-&gt;description .= $data;
        break;
        case "PUBDATE":
        $this-&gt;pubdate .= $data;
        break;
        case "LINK":
        $this-&gt;link .= $data;
        break;
      }
    }
  }
}
 
# Create an XML parser
# Just as one must create a database connection in PHP to interact with a database, 
# one must create an XML parser to read in an XML file. In this case, a reference to 
# the parser is stored in $xml_parser.
$xml_parser = xml_parser_create();
 
$rss_parser = new FlickrRSSParser();
 
xml_set_object($xml_parser,&amp;$rss_parser);
 
# This function specifies the functions that an XML parser should 
# use to process the events generated opening and closing tags. 
# In this case, the parser is the one stored in our $xml_parser variable, 
# while the functions are called startElement() and endElement()
 
xml_set_element_handler($xml_parser, "startElement", "endElement");
 
# This function specifies the function that the XML parser should use 
# to process character data appearing between tags in an XML document. 
# The function chosen to process character data is called characterData()
xml_set_character_data_handler($xml_parser, "characterData");
 
# Flickr's RSS Feed Comments URL must be entered here
$rss = "FLICKR_RSS_FEED_FOR_COMMENTS";
 
# Open the specified URL for reading
$fp = fopen($rss, "r")
  or die("Error reading RSS data.");
 
while ($data = fread($fp, 4096)) {
  # This function sends all or part of an XML document to the parser for it 
  # to process. The endOfDocument parameter should be set to true if the 
  # data marks the end of of XML document, or false if more of the document 
  # will follow in a subsequent call to xml_parse(). This allows the parser to 
  # correctly catch unclosed tags at the end of the document and so forth. 
  # In this case, the parser is once again $xml_parser. The $data variable 
  # (up to 4KB in size) retrieved from the file with fread() is passed as the 
  # data to be processed, while the feof() is used to determine whether 
  # PHP has reached the end of the XML file or not, thus providing the 
  # required endOfDocument parameter. If an error occurs in the parsing of 
  # the document, the error message is printed out along with the line of the 
  # file at which it occurs with xml_error_string, xml_get_error_code() and 
  # xml_get_current_line_number()
  xml_parse($xml_parser, $data, feof($fp))
    or die(sprintf("XML error: %s at line %d",
      xml_error_string(xml_get_error_code($xml_parser)),
      xml_get_current_line_number($xml_parser)));
}
 
fclose($fp);
 
# Although all memory resources are freed at the end of a PHP script, 
# one may wish to free up the memory used by the XML parser if the 
# script will perform other potentially memory-intensive tasks after it 
# parses the XML data. This function destroys the specified XML parser, 
# thus freeing up resources and memory it may have allocated for parsing.
xml_parser_free($xml_parser);
 
?-->