[github/wallabag/wallabag.git] / index.php

<?php
/**
 * poche, a read it later open source system
 *
 * @category   poche
 * @author     Nicolas Lœuillet <nicolas@loeuillet.org>
 * @copyright  2013
 * @license    http://www.wtfpl.net/ see COPYING file
 */

include dirname(__FILE__).'/inc/config.php';
$db = new db(DB_PATH);

$action = (isset ($_GET['action'])) ? htmlspecialchars($_GET['action']) : '';
$view   = (isset ($_GET['view'])) ? htmlspecialchars($_GET['view']) : '';
$id     = (isset ($_GET['id'])) ? htmlspecialchars($_GET['id']) : '';

switch ($action)
{
    case 'add':
        $url = (isset ($_GET['url'])) ? $_GET['url'] : '';
        if ($url == '')
            continue;

        $url    = html_entity_decode(trim($url));

        // We remove the annoying parameters added by FeedBurner and GoogleFeedProxy (?utm_source=...)
        // from shaarli, by sebsauvage
        $i=strpos($url,'&utm_source='); if ($i!==false) $url=substr($url,0,$i);
        $i=strpos($url,'?utm_source='); if ($i!==false) $url=substr($url,0,$i);
        $i=strpos($url,'#xtor=RSS-'); if ($i!==false) $url=substr($url,0,$i);

        $title  = $url;
        if (!preg_match('!^https?://!i', $url))
            $url = 'http://' . $url;

        $html = Encoding::toUTF8(get_external_file($url,15));
        if (isset($html) and strlen($html) > 0)
        {
            $r = new Readability($html, $url);
            if($r->init())
            {
                $title = $r->articleTitle->innerHTML;
            }
        }

        $query = $db->getHandle()->prepare('INSERT INTO entries ( url, title ) VALUES (?, ?)');
        $query->execute(array($url, $title));
        break;
    case 'delete':
        $sql_action     = "DELETE FROM entries WHERE id=?";
        $params_action  = array($id);
        break;
    default:
        break;
}

try
{
    # action query
    if (isset($sql_action))
    {
        $query = $db->getHandle()->prepare($sql_action);
        $query->execute($params_action);
    }
}
catch (Exception $e)
{
    die('query error : '.$e->getMessage());
}

switch ($view)
{
    case 'archive':
        $sql    = "SELECT * FROM entries WHERE is_read=? ORDER BY id desc";
        $params = array(-1);
        break;
    case 'fav' :
        $sql    = "SELECT * FROM entries WHERE is_fav=? ORDER BY id desc";
        $params = array(-1);
        break;
    default:
        $sql    = "SELECT * FROM entries WHERE is_read=? ORDER BY id desc";
        $params = array(0);
        $view = 'index';
        break;
}

# view query
try
{
    $query  = $db->getHandle()->prepare($sql);
    $query->execute($params);
    $entries = $query->fetchAll();
}
catch (Exception $e)
{
    die('query error : '.$e->getMessage());
}

?>
<!DOCTYPE html>
<!--[if lte IE 6]> <html class="no-js ie6 ie67 ie678" lang="en"> <![endif]-->
<!--[if lte IE 7]> <html class="no-js ie7 ie67 ie678" lang="en"> <![endif]-->
<!--[if IE 8]> <html class="no-js ie8 ie678" lang="en"> <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js" lang="en"> <!--<![endif]-->
<html>
    <head>
        <meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0">
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=10">
        <title>poche, a read it later open source system</title>
        <link rel="shortcut icon" type="image/x-icon" href="img/favicon.ico" />
        <link rel="apple-touch-icon-precomposed" sizes="144x144" href="img/apple-touch-icon-144x144-precomposed.png">
        <link rel="apple-touch-icon-precomposed" sizes="72x72" href="img/apple-touch-icon-72x72-precomposed.png">
        <link rel="apple-touch-icon-precomposed" href="img/apple-touch-icon-precomposed.png">
        <link rel="stylesheet" href="css/knacss.css" media="all">
        <link rel="stylesheet" href="css/style.css" media="all">
    </head>
    <body>
        <header>
            <h1><img src="img/logo.png" alt="logo poche" />poche</h1>
        </header>
        <div id="main">
            <ul id="links">
                <li><a href="index.php" <?php echo (($view == 'index') ? 'class="current"' : ''); ?>>home</a></li>
                <li><a href="?view=fav" <?php echo (($view == 'fav') ? 'class="current"' : ''); ?>>favorites</a></li>
                <li><a href="?view=archive" <?php echo (($view == 'archive') ? 'class="current"' : ''); ?>>archive</a></li>
                <li><a style="cursor: move" title="i am a bookmarklet, use me !" href="javascript:(function(){var%20url%20=%20location.href;var%20title%20=%20document.title%20||%20url;window.open('<?php echo url()?>?action=add&url='%20+%20encodeURIComponent(url),'_self');})();">poche it !</a></li>
            </ul>
            <div id="content">
                <ul id="entries">
                <?php
                $i = 1;
                foreach ($entries as $entry)
                {
                    ?>
                    <li id="entry-<?php echo $entry['id']; ?>" class="entrie mb2">
                        <span class="content">
                            <h2 class="h6-like">
                                <a href="readityourself.php?url=<?php echo urlencode($entry['url']); ?>"><?php echo $entry['title']; ?>
                            </h2>
                            <div class="tools">
                                <a title="toggle mark as read" class="tool archive <?php echo ( ($entry['is_read'] == '0') ? 'archive-off' : '' ); ?>" onclick="toggle_archive(<?php echo $entry['id']; ?>)"><span></span></a>
                                <a title="toggle favorite" class="tool fav <?php echo ( ($entry['is_fav'] == '0') ? 'fav-off' : '' ); ?>" onclick="toggle_favorite(this, <?php echo $entry['id']; ?>)"><span></span></a>
                                <a href="?action=delete&id=<?php echo $entry['id']; ?>" title="toggle delete" onclick="return confirm('Are you sure?')" class="tool delete"><span></span></a>
                            </div>
                        </span>
                    </li>
                <?php
                $i++;
                }
                ?>
                </ul>
            </div>
        </div>
        <footer class="mr2 mt3 smaller">
            <p><a href="https://twitter.com/getpoche" title="follow us on twitter">Follow @getpoche on twitter</a></p>
        </footer>
        <script type="text/javascript" src="js/jquery-1.9.1.min.js"></script>
        <script type="text/javascript" src="js/poche.js"></script>
    </body>
</html>
Commit	Line	Data
1a268ba7 NL	1	<?php
	2	/**
	3	* poche, a read it later open source system
	4	*
	5	* @category poche
	6	* @author Nicolas Lœuillet <nicolas@loeuillet.org>
	7	* @copyright 2013
	8	* @license http://www.wtfpl.net/ see COPYING file
	9	*/
	10
c594aedf	11	include dirname(__FILE__).'/inc/config.php';
c594aedf	12	$db = new db(DB_PATH);
1a268ba7 NL	13
1a268ba7 NL	14	$action = (isset ($_GET['action'])) ? htmlspecialchars($_GET['action']) : '';
386407c1	15	$view = (isset ($_GET['view'])) ? htmlspecialchars($_GET['view']) : '';
7eca3552	16	$id = (isset ($_GET['id'])) ? htmlspecialchars($_GET['id']) : '';
1a268ba7	17
386407c1	18	switch ($action)
386407c1	19	{
1a268ba7	20	case 'add':
24619534	21	$url = (isset ($_GET['url'])) ? $_GET['url'] : '';
386407c1	22	if ($url == '')
	23	continue;
	24
	25	$url = html_entity_decode(trim($url));
6c732e1c	26
	27	// We remove the annoying parameters added by FeedBurner and GoogleFeedProxy (?utm_source=...)
	28	// from shaarli, by sebsauvage
	29	$i=strpos($url,'&utm_source='); if ($i!==false) $url=substr($url,0,$i);
	30	$i=strpos($url,'?utm_source='); if ($i!==false) $url=substr($url,0,$i);
	31	$i=strpos($url,'#xtor=RSS-'); if ($i!==false) $url=substr($url,0,$i);
	32
386407c1	33	$title = $url;
	34	if (!preg_match('!^https?://!i', $url))
	35	$url = 'http://' . $url;
	36
24619534	37	$html = Encoding::toUTF8(get_external_file($url,15));
386407c1	38	if (isset($html) and strlen($html) > 0)
386407c1	39	{
24619534	40	$r = new Readability($html, $url);
386407c1	41	if($r->init())
386407c1	42	{
24619534	43	$title = $r->articleTitle->innerHTML;
	44	}
	45	}
	46
c594aedf	47	$query = $db->getHandle()->prepare('INSERT INTO entries ( url, title ) VALUES (?, ?)');
1a268ba7 NL	48	$query->execute(array($url, $title));
1a268ba7 NL	49	break;
1a268ba7	50	case 'delete':
386407c1	51	$sql_action = "DELETE FROM entries WHERE id=?";
386407c1	52	$params_action = array($id);
1a268ba7 NL	53	break;
	54	default:
	55	break;
	56	}
c4fb6f01	57
5917f419	58	try
	59	{
	60	# action query
386407c1	61	if (isset($sql_action))
386407c1	62	{
c594aedf	63	$query = $db->getHandle()->prepare($sql_action);
5917f419	64	$query->execute($params_action);
	65	}
	66	}
	67	catch (Exception $e)
	68	{
	69	die('query error : '.$e->getMessage());
	70	}
	71
386407c1	72	switch ($view)
386407c1	73	{
5917f419	74	case 'archive':
0772c48b	75	$sql = "SELECT * FROM entries WHERE is_read=? ORDER BY id desc";
5917f419	76	$params = array(-1);
	77	break;
	78	case 'fav' :
0772c48b	79	$sql = "SELECT * FROM entries WHERE is_fav=? ORDER BY id desc";
5917f419	80	$params = array(-1);
	81	break;
	82	default:
0772c48b	83	$sql = "SELECT * FROM entries WHERE is_read=? ORDER BY id desc";
5917f419	84	$params = array(0);
8784f095	85	$view = 'index';
5917f419	86	break;
	87	}
	88
	89	# view query
	90	try
	91	{
c594aedf	92	$query = $db->getHandle()->prepare($sql);
5917f419	93	$query->execute($params);
	94	$entries = $query->fetchAll();
	95	}
	96	catch (Exception $e)
	97	{
	98	die('query error : '.$e->getMessage());
	99	}
	100
1a268ba7 NL	101	?>
	102	<!DOCTYPE html>
	103	<!--[if lte IE 6]> <html class="no-js ie6 ie67 ie678" lang="en"> <![endif]-->
	104	<!--[if lte IE 7]> <html class="no-js ie7 ie67 ie678" lang="en"> <![endif]-->
	105	<!--[if IE 8]> <html class="no-js ie8 ie678" lang="en"> <![endif]-->
	106	<!--[if gt IE 8]><!--> <html class="no-js" lang="en"> <!--<![endif]-->
	107	<html>
	108	<head>
	109	<meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0">
	110	<meta charset="utf-8">
	111	<meta http-equiv="X-UA-Compatible" content="IE=10">
386407c1	112	<title>poche, a read it later open source system</title>
d6353f75	113	<link rel="shortcut icon" type="image/x-icon" href="img/favicon.ico" />
5a862b08	114	<link rel="apple-touch-icon-precomposed" sizes="144x144" href="img/apple-touch-icon-144x144-precomposed.png">
	115	<link rel="apple-touch-icon-precomposed" sizes="72x72" href="img/apple-touch-icon-72x72-precomposed.png">
	116	<link rel="apple-touch-icon-precomposed" href="img/apple-touch-icon-precomposed.png">
1a268ba7 NL	117	<link rel="stylesheet" href="css/knacss.css" media="all">
	118	<link rel="stylesheet" href="css/style.css" media="all">
	119	</head>
	120	<body>
5917f419	121	<header>
386407c1	122	<h1><img src="img/logo.png" alt="logo poche" />poche</h1>
5917f419	123	</header>
c594aedf	124	<div id="main">
5917f419	125	<ul id="links">
8784f095	126	<li><a href="index.php" <?php echo (($view == 'index') ? 'class="current"' : ''); ?>>home</a></li>
	127	<li><a href="?view=fav" <?php echo (($view == 'fav') ? 'class="current"' : ''); ?>>favorites</a></li>
	128	<li><a href="?view=archive" <?php echo (($view == 'archive') ? 'class="current"' : ''); ?>>archive</a></li>
ee55d616	129	<li><a style="cursor: move" title="i am a bookmarklet, use me !" href="javascript:(function(){var%20url%20=%20location.href;var%20title%20=%20document.title%20\|\|%20url;window.open('<?php echo url()?>?action=add&url='%20+%20encodeURIComponent(url),'_self');})();">poche it !</a></li>
5917f419	130	</ul>
c594aedf	131	<div id="content">
c594aedf	132	<ul id="entries">
5917f419	133	<?php
c594aedf	134	$i = 1;
386407c1	135	foreach ($entries as $entry)
386407c1	136	{
c594aedf	137	?>
	138	<li id="entry-<?php echo $entry['id']; ?>" class="entrie mb2">
	139	<span class="content">
	140	<h2 class="h6-like">
	141	<a href="readityourself.php?url=<?php echo urlencode($entry['url']); ?>"><?php echo $entry['title']; ?>
	142	</h2>
	143	<div class="tools">
	144	<a title="toggle mark as read" class="tool archive <?php echo ( ($entry['is_read'] == '0') ? 'archive-off' : '' ); ?>" onclick="toggle_archive(<?php echo $entry['id']; ?>)"><span></span></a>
	145	<a title="toggle favorite" class="tool fav <?php echo ( ($entry['is_fav'] == '0') ? 'fav-off' : '' ); ?>" onclick="toggle_favorite(this, <?php echo $entry['id']; ?>)"><span></span></a>
	146	<a href="?action=delete&id=<?php echo $entry['id']; ?>" title="toggle delete" onclick="return confirm('Are you sure?')" class="tool delete"><span></span></a>
	147	</div>
	148	</span>
	149	</li>
	150	<?php
	151	$i++;
5917f419	152	}
5917f419	153	?>
c594aedf	154	</ul>
7eca3552	155	</div>
5917f419	156	</div>
d08318e4	157	<footer class="mr2 mt3 smaller">
195db52a	158	<p><a href="https://twitter.com/getpoche" title="follow us on twitter">Follow @getpoche on twitter</a></p>
1a268ba7	159	</footer>
c594aedf	160	<script type="text/javascript" src="js/jquery-1.9.1.min.js"></script>
c594aedf	161	<script type="text/javascript" src="js/poche.js"></script>
5917f419	162	</body>
d08318e4	163	</html>