<?php
  
  //define the delicious account information we need
  define('DELICIOUS_USERNAME','username');
  define('DELICIOUS_PASSWORD','password');
  
  //mysql database information
  define('MYSQL_HOST','localhost');
  define('MYSQL_DATABASE','delicious_summary2');
  define('MYSQL_USERNAME','delicious_sql');
  define('MYSQL_PASSWORD','password');
  
  //bring in Snoopy goodness
  include('lib/Snoopy.class.php');
  //get rid of error Notices because Snoopy produces some
  error_reporting(E_ERROR | E_WARNING | E_PARSE);
  
  //also bring in the del.icio.us Mashups PHP library we made
  include('lib/delicious_mashups.inc.php');
  
  //bring in Sajax goodness
  require("lib/Sajax.php");
  
  //create the MySQL Database Connection
  $link\; =\; mysql\_connect(MYSQL\_HOST,MYSQL\_USERNAME,MYSQL\_PASSWORD)\; or\; die(mysql\_error());\; @mysql\_select\_db(MYSQL\_DATABASE)\; or\; die(mysql\_error());$//first let’s fill linkroll_data
  $linkroll\_data\; =\; array();$//start by seeing if the first (and only) row in the linkroll table has a 
  //time_retrieved that is in the last hour   
  linkroll_cache_query = "select count(*) from linkroll where time_retrieved > date_sub(now(), interval 1 hour)";
  $linkroll\_cache\_result\; =\; mysql\_query($linkroll_cache_query);
  //if a count was returned, we should use cache and NOT make an api call
  if (mysql_result($linkroll\_cache\_result,0)\; >=\; 1)\; \{$//use the linkroll cache
      linkroll_data = get_last_cached_data('linkroll');
  } else {
      //no cache so time to update our cache with a new data fetched from the api
      do_api_call('/posts/recent?','count=20');
      //if status is 200 then create the cache and use $api\_return\; for\; our\; data.$
      //otherwise, fetch the cache data instead.
      if (api_return['status'] == 200)
      {
          $add\_cache\_query\; =\; sprintf(\; "insert\; into\; linkroll\; (time\_retrieved,serialized\_data\_array)\; values\; (now(),\text{'}$\%s')",
              mysql_real_escape_string(serialize(api_return))
              );
          mysql_query($add\_cache\_query)\; or\; die(mysql\_error());$linkroll_data = $api\_return;\; \}\; else\; \{$//otherwise, force using the cache
          linkroll_data = get_last_cached_data('linkroll');
      }
  }
  
  //next let’s fill $tagroll\_data\; with\; the\; tags\; for\; this\; user\; for\; our\; tagroll$
  //using the API
  tagroll_data = array();
  //start by seeing if the first (and only) row in the tagroll table has a
  // time_retrieved that is in the last hour   
  $tagroll\_cache\_query\; =\; "select\; count(*)\; from\; tagroll\; where\; time\_retrieved\; >\; date\_sub(now(),\; interval\; 1\; hour)";$tagroll_cache_result = mysql_query($tagroll\_cache\_query);$//if a count was returned, we should use cache and NOT make an api call
  if (mysql_result(tagroll_cache_result,0) >= 1) {
      //use the tagroll cache
      $tagroll\_data\; =\; get\_last\_cached\_data(\text{'}tagroll\text{'});\; \}\; else\; \{$//no cache so time to update our cache with a new data fetched from the api
      do_api_call('/tags/get');
      //if status is 200 then create the cache and use api_return for our data.
      //otherwise, fetch the cache data instead.
      if ($api\_return[\text{'}status\text{'}]\; ==\; 200)\; \{$add_cache_query = sprintf(
              "insert into tagroll (time_retrieved,serialized_data_array) values 
              (now(),'\%s')",
              mysql_real_escape_string(serialize($api\_return))\; );\; mysql\_query($add_cache_query) or die(mysql_error());
          $tagroll\_data\; =$api_return;
      } else {
          //otherwise, force using the cache
          $tagroll\_data\; =\; get\_last\_cached\_data(\text{'}tagroll\text{'});\; \}\; \}$//this function will grab the links for a particular tag, whether from
  //cache or a del.icio.us API call
  function get_tag_linkroll(tag) {
      global $api\_return;$//tag_linkroll_data with be filled with the 20 latest posted bookmarks
      //under tag
      $tag\_linkroll\_data\; =\; array();$//check for cache like with the normal linkroll but also query on the tag name
      tag_linkroll_cache_query = "select * from tag_linkroll where time_retrieved > date_sub(now(), interval 1 hour) and tag='".mysql_real_escape_string($tag)."\text{'}";$tag_linkroll_cache_result = mysql_query($tag\_linkroll\_cache\_query);$//if a row was returned, we should use cache and NOT make an api call
      if (mysql_num_rows(tag_linkroll_cache_result) >= 1) {
          //use the tag linkroll cache
          $tag\_linkroll\_data\; =\; get\_last\_cached\_data(\text{'}tag\_linkroll\text{'},$tag);
      } else {
          //no cache so time to update our cache with a new data fetched from the api
          do_api_call('/posts/recent?',"count=20&tag=".$tag);$//if status is 200 then create the cache and use api_return for our data.
          //otherwise, fetch the cache data instead.        
          if ($api\_return[\text{'}status\text{'}]\; ==\; 200)\; \{$add_cache_query = sprintf(
                  "insert into tag_linkroll 
                     (time_retrieved,serialized_data_array,tag)
                     values (now(),'\%s','\%s')",
                  mysql_real_escape_string(serialize($api\_return)),\; mysql\_real\_escape\_string($tag)
                  );
              mysql_query($add\_cache\_query)\; or\; die(mysql\_error());$tag_linkroll_data = $api\_return;\; \}\; else\; \{$//otherwise, force using the cache
              tag_linkroll_data = get_last_cached_data('tag_linkroll',$tag);\; \}\; \}$//return the list with proper html formatting
      posts = $tag\_linkroll\_data[0][\text{'}children\text{'}];$html = "<em>selected tag: $tag$</em>";
      html .= "<ul>";
      foreach ($posts\; as$post)
      {
          $html\; .=\; "$<li><a href=\"".post['attributes']['HREF']."\">".
          $post[\text{'}attributes\text{'}][\text{'}DESCRIPTION\text{'}]."$</a></li>";
          if (isset(post['attributes']['EXTENDED']))
              $html\; .=\; "$<p>".post['attributes']['EXTENDED']."</p>";
      }
      $html\; .=\; "$</ul>";
      return html;
  }
  
  //this shared function fetches the last cached data for a given table
  function get_last_cached_data($table,$tag = '')
  {
      //grab the newest cached item from $table$
      if (tag != '') {
          $query\; =\; "select\; serialized\_data\_array\; from$table where tag =  '".mysql_real_escape_string($tag)."\text{'}\; order\; by\; time\_retrieved\; desc\; limit\; 1";\; \}\; else\; \{$query = "select serialized_data_array from $table\; order\; by\; time\_retrieved\; desc\; limit\; 1";\; \}$result = mysql_query($query);$row = mysql_fetch_row($result);$//unserialize the data array and return it
      return unserialize(row[0]);
  }
  
  //initalize sajax and export the get_tag_linkroll function
  sajax_init();
  sajax_export("get_tag_linkroll");
  sajax_handle_client_request();
  
  ?>
  </?xml version="1.0" encoding="UTF-8"/?>
  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  <head>
  <title><?php echo DELICIOUS_USERNAME; ?>'s del.icio.us Summary Page</title>
  <link href="stylesheet.css" rel="stylesheet" type="text/css" />
  <script>
  <?php
  //this brings in all the javascript SAJAX needs to do its thing
  sajax_show_javascript();
  ?>
  //called when you click a tag in the tag-cloud
  function get_tag_linkroll(tag) {
             document.getElementById("tag_linkroll").innerHTML = "<em>Fetching linkroll. Please wait....</em>";
             x_get_tag_linkroll(tag, get_tag_linkroll_cb);
  }
  //x_get_tag_linkroll callback
  function get_tag_linkroll_cb(result) {
      document.getElementById("tag_linkroll").innerHTML = result;
  }
  </head>
  <body>
      
  <h1 id="header"><?php echo DELICIOUS_USERNAME; ?>'s del.icio.us Summary Page</h1>
  
  <div id="center_col">
  <div class="col_banner">My Tags</div>
  <div style="text-align: justify">
  <?php
      //pull all of the tags and their count out of the data array first
      //and put it into a k => v array, where v = an array of all tags w/ that count
      $tag\_counts\; =\; array();$tags = $tagroll\_data[0][\text{'}children\text{'}];\; foreach\; ($tags as $tag)$tag_counts[$tag[\text{'}attributes\text{'}][\text{'}COUNT\text{'}]][]\; =$tag['attributes']['TAG'];
      //sort tags by counts
      ksort($tag\_counts);$//remove groups of tags from tag_counts with a count of 3 or below
      for ($i\; =\; 1;$i <= 3; $i++)\; \{\; if\; (isset($tag_counts["$i"]))\; unset($tag_counts["$i"]);\; \}$//get the smallest count going
      smallest_count = array_shift(array_keys($tag\_counts));$//get the largest count going
      largest_count = array_pop(array_keys($tag\_counts));$//determine the difference between them
      count_difference = $largest\_count\; -$smallest_count;
      $count\_distribution\; =$count_difference / 3; //3 different sub-sizes
      //create a new array of all tag names, sorted, as keys with counts as values
      $tag\_values\; =\; array();\; foreach\; ($tag_counts as $count\; =>$tags_in_count){
          foreach ($tags\_in\_count\; as$tag_name)
              $tag\_values[$tag_name] = $count;\; \}\; ksort($tag_values);
      //now go through $tag\_values\; and\; output\; them\; with\; the\; according\; classes$
      foreach (tag_values as $tag\_name\; =>$tag_count)
      {
          if ($tag\_count\; ==$largest_count)
              echo "<span class=\"largest_tag\"> ";
          elseif ($tag\_count\; ==$smallest_count)
              echo "<span class=\"smallest_tag\"> ";
          elseif ($tag\_count\; >$smallest_count + ($count\_distribution\; *\; 2))\; echo\; "$<span class=\"large_tag\"> ";
          elseif (tag_count > $smallest\_count\; +$count_distribution)
              echo "<span class=\"medium_tag\"> ";
          else
              echo "<span class=\"small_tag\"> ";
          echo "<a href=\"#\" onClick=\"get_tag_linkroll('".$tag\_name."\text{'});\; return\; false;\backslash ">".$tag_name."</a>";
          echo " </span>";
      }
  ?>
  </div>
  </div>
  
  <div id="left_col">
  <div class="col_banner">My Latest Bookmarks</div>
  <?php
      //list recent posts (linkroll)
      $posts\; =$linkroll_data[0]['children'];
      echo "<ul>";
      foreach ($posts\; as$post)
      {
          echo "<li><a href=\"".$post[\text{'}attributes\text{'}][\text{'}HREF\text{'}]."\backslash ">".$post['attributes']['DESCRIPTION']."</a></li>";
          if (isset($post[\text{'}attributes\text{'}][\text{'}EXTENDED\text{'}]))\; echo\; "$<p>".post['attributes']['EXTENDED']."</p>";
      }
      echo "</ul>";
  ?>
  </div>
  
  <div id="right_col">
      <div class="col_banner">Browse by Tag</div>
      <div id="tag_linkroll">
          <p>&laquo; Click a tag in the column to the left to view my bookmarks for
          it here.</p>
      </div>
  </div>
  
  </body>
  </html>
  <?php
  //close the database connection since we won't need it past this point
  mysql_close($link);\; ?>$