<?php
//error_reporting(E_ALL);
//ini_set('display_errors','On');

$db_connection = mysql_connect ('localhost','gandcouser','Gw18capOn85Df') or die (mysql_error());
$db_select = mysql_select_db ('simongodefroy_gandcodatab') or die (mysql_error());


//resolve page identifier and check args
$uriArray = explode("/",$_SERVER['REQUEST_URI']);
$argRoot = array_search('digest', $uriArray);

$client = $uriArray[$argRoot+1];
$client = preg_replace("/[^a-zA-Z0-9]/", "", $client);

if ($_GET['searchtext']) {
	$searchtext = preg_replace("/[^a-zA-Z0-9.@']/", "", $_GET['searchtext']);
	header ("Location: /digest/$client/search/$searchtext");
    exit();
}


$type = $uriArray[$argRoot+2];
$type = preg_replace("/[^a-zA-Z0-9]/", "", $type);

$data = $uriArray[$argRoot+3];
$data = preg_replace("/[^a-zA-Z0-9]/", "", $data);


while (!$clientData) {
	$query = "SELECT * FROM digest_subscribers WHERE id = '$client'";
	$result = @mysql_query ($query) or die (mysql_error());    	
	$clientData = mysql_fetch_array($result);
    if (!$clientData) $client = 'default';
    $previous_link = "/digest/$client/previous";
    $upcoming_link = "/digest/$client/upcoming";
    $intro = str_replace(array('{link_previous}','{link_upcoming}'),array($previous_link,$upcoming_link),$clientData['intro']);
    }




$pmonth = strtotime("last month");
$prevmonth = date('F Y', $pmonth);
$pm = date('n', $pmonth);
$py = date('Y', $pmonth);
$cm = date('n');
$cy = date('Y');
$cmonth = date('F Y');

$tweets = '';
$c = 1;

switch ($type) {
	case 'previoussearchtext' :
    	header ("Location: /digest/$client/previous");
   		exit();
        break;
	case 'upcoming' :
    	$query = "SELECT *, DATE_FORMAT(created_at,'%W %e %M at %l:%i%p') AS 'twitdtime' FROM twitter WHERE rating = '5' AND text LIKE('%#sg%') AND YEAR(created_at) = '$cy' AND MONTH(created_at) = '$cm' AND link_url IS NOT NULL ORDER BY created_at ASC";
    	$titletext = 'Upcoming ('. $cmonth .')';
        $intro = str_replace(array('{link_previous}','{link_upcoming}'),array($previous_link,$upcoming_link),$clientData['basic_intro']);
        break;
    case 'search' :
    	$query = "SELECT *, DATE_FORMAT(created_at,'%W %e %M at %l:%i%p') AS 'twitdtime' FROM twitter WHERE (text LIKE('%$data%') OR link_title LIKE('%$data%') OR link_description LIKE('%$data%') OR link_keywords LIKE('%$data%') OR link_url LIKE('%$data%') ) AND link_url IS NOT NULL ORDER BY created_at ASC";
    	$titletext = "Search: $data";
        $intro = str_replace(array('{link_previous}','{link_upcoming}'),array($previous_link,$upcoming_link),$clientData['basic_intro']);
        break;
    case 'year' :
    	$sy = substr($data,0,4);
        $query = "SELECT *, DATE_FORMAT(created_at,'%W %e %M at %l:%i%p') AS 'twitdtime' FROM twitter WHERE rating = '5' AND text LIKE('%#sg%') AND YEAR(created_at) = '$sy' AND link_url IS NOT NULL ORDER BY created_at ASC";
    		$titletext = 'Digest for the year '. $sy;
        	$intro = str_replace(array('{link_previous}','{link_upcoming}'),array($previous_link,$upcoming_link),$clientData['basic_intro']);
    	break;
    
    case 'previous' :
    	if ($data) {
        	$sy = substr($data,0,4);
        	$sm = substr($data,-2);
        	$smonth = date('F Y', strtotime("$sy-$sm-01"));
    		$query = "SELECT *, DATE_FORMAT(created_at,'%W %e %M at %l:%i%p') AS 'twitdtime' FROM twitter WHERE rating = '5' AND text LIKE('%#sg%') AND YEAR(created_at) = '$sy' AND MONTH(created_at) = '$sm' AND link_url IS NOT NULL ORDER BY created_at ASC";
    		$titletext = 'Digest for the month '. $smonth;
        	$intro = str_replace(array('{link_previous}','{link_upcoming}'),array($previous_link,$upcoming_link),$clientData['basic_intro']);
            } else {
            $query = "SELECT YEAR(created_at) as 'pyear', MONTH(created_at) as 'pmonth', DATE_FORMAT(created_at,'%M') AS 'fmonth' FROM twitter WHERE text LIKE('%#sg%') AND link_url IS NOT NULL GROUP BY YEAR(created_at), MONTH(created_at) ORDER BY created_at DESC";
    		$intro = '';
            $titletext = 'Digest archive';
            }
        break;
    default :
    	$query = "SELECT *, DATE_FORMAT(created_at,'%W %e %M at %l:%i%p') AS 'twitdtime' FROM twitter WHERE rating = '5' AND text LIKE('%#sg%') AND YEAR(created_at) = '$py' AND MONTH(created_at) = '$pm' AND link_url IS NOT NULL AND link_processed = '1' ORDER BY created_at ASC";
    	$titletext = $prevmonth;
        break;
}

$results = @mysql_query ($query) or die (mysql_error());


if (($type == 'previous') && (!$data)) {
	$tweets = "<form><input type='text' name='searchtext' class='search' /><input type='submit' class='search-button' value='SEARCH' /></form><ul class='archive'>";
    while($row = mysql_fetch_array($results)) {
    
     $tweets.= "<li><a href='/digest/$client/previous/$row[pyear]" . sprintf("%02d", $row['pmonth']) . "'>$row[pyear] - $row[fmonth]</a></li>";
    
    }
    $tweets .= "</ul>";
} else {


while($row = mysql_fetch_array($results)){
	
	$tweet = $row['text'];
	$tweet = str_replace(array('"','“','”','#sg','RT'),array('','','','',''),$tweet);
	
	$tlinks = '';
	preg_match_all('/@(\w+)(?::)?/', $tweet, $profiles);
	//foreach ($profiles[1] as $value) {
	//	$tlinks .= '<a href="http://www.twitter.com/' . $value . '"  title="' . $value . ' tweeted this"><img src="http://img.tweetimag.es/i/' . $value . '_n"/></a>';
	//}
	//$tlinks = ($tlinks == '' ) ? '<a href="http://www.twitter.com/madmutt" title="madmutt tweeted this"><img src="http://img.tweetimag.es/i/madmutt_n"/></a>' : $tlinks;
	
    
	$tweet = preg_replace('!https?://[\S]+!','',$tweet);
	$tweet = preg_replace('/@(\w+)(?::)?/','<a href="http://www.twitter.com/\1">@\1</a>',$tweet);
	$tweet = preg_replace("/[#]+([A-Za-z0-9-_]+)/", "<a href=\"http://twitter.com/search?q=%23\\1\" target=\"_blank\">\\0</a>", $tweet );
    $title = $row['link_title'];
	$displayLink = str_replace('http://','',$row['link_url']);
    $tweets.= "<li><a name='$c'></a>
	<p class='tweet'><a href='$row[link_url]'>" . str_replace(array('','',''),array('&lsquo;','&rsquo;','&ndash;'),$title) . "</a></p>
	<p class='description'>" . str_replace(array('','',''),array('&lsquo;','&rsquo;','&ndash;'),$row['link_description']) . "</p>
	<div class='fulltweet clearfix'><div class='thumbs'>$tlinks</div><div class='fttext'>$tweet <a href='$row[link_url]'>$displayLink</a> <span class='datetime'>tweeted on $row[twitdtime]</span></div></div>
	</li>";
	$c++;
	
}

if (!$tweets) {
	$tweets = "<p class='error'>Sorry! I cannot find any articles that match your search criteria.</p>";
} else {
	$tweets = "<ol class='tweetlist'>$tweets</ol>";
}

}


?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta http-equiv="expires" content="0">
<title>Simon Godefroy - Twitter Digest: <?=$titletext?></title>
<link href="/css/digest.css" rel="stylesheet" type="text/css" />
</head>

<body>
<a name="top"></a>
<div class="header-container">
	<div class="header-content clearfix">
    <div class="header-links"><b>Simon Godefroy</b><br/><a href="mailto:simon@godefroy.co">simon@godefroy.co</a><br/>follow me on Twitter <a href="http://www.twitter.com/madmutt">@madmutt</a></div>
    
    <a href="http://godefroy.co"><img src="/images/digest_logo.png" alt="Godefroy &amp; co." class="logo" border="0"/></a>
    </div>
</div>
<div class="main-container">
<div class="main-content">
<div class="top-menu">
<ul class="main-menu">
	<li><a href="/digest/<?=$client?>">Current digest - <?=$prevmonth?></a></li><li><a href="/digest/<?=$client?>/previous">Previous digests and search</a></li><li><a href="/digest/<?=$client?>/upcoming">Upcoming articles - <?=$cmonth?></a></li>
</ul>
</div>
<h1>Mental Health, Law, Social Work digest<br />
    <b><?=$titletext?></b></h1>
<div class="intro"><?=$intro?></div>

<?=$tweets?>

<p class="smaller"><a href="#top">back to top</a></p>
<div class="bottom-menu">
<ul class="main-menu">
	<li><a href="/digest/<?=$client?>">Current digest - <?=$prevmonth?></a></li><li><a href="/digest/<?=$client?>/previous">Previous digests and search</a></li><li><a href="/digest/<?=$client?>/upcoming">Upcoming articles - <?=$cmonth?></a></li>
</ul>
</div>
<div class='footer'><p>&copy;<?=date('Y');?> Original article authors. All other trademarks and copyrights are the property of their respective owners.</p><p>Feed curated by Simon Godefroy, site design and technology: <a href='http://www.tomodomo.net'>Tomodomo</a></p></div>
</div>
</div>
</body>
</html>