Chase-san · December 12, 2015 02:49
diff --git a/chibichan.php b/chibichan.php
 <?php /* Copyright(c) 2013 Robert Maupin. Released under the ZLIB License. */
 date_default_timezone_set('GMT');
 define('DB','chan.db');
 $max_image_size_kb = 1024*1024;
 $thumbnail_size = 150;
 $thumbnail_quality = 70;
 $db = new PDO('sqlite:'.DB, 0, 0, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
 function query($sql, $params = NULL) {
  global $db;
 	$s = $db->prepare($sql);
 	$s->execute(array_values((array) $params));
 	return $s;
 }
 function ext($id) {
 	$ex=query('SELECT e FROM i WHERE i=?',$id)->fetch(PDO::FETCH_NUM);
 	return $ex[0];
 }
 if(!is_file(DB)) {
 	/* (I)mage: (I)D, FILE (M)D5, (E)xtension
 	 * (T)ags: Image (I)D, (T)ext
 	 */
 	query('CREATE TABLE i (i INTEGER PRIMARY KEY,m BLOB(16) UNIQUE ON CONFLICT ROLLBACK,e TEXT)');
 	query('CREATE TABLE t (i INTEGER,t TEXT(32),PRIMARY KEY (i, t))');
 }
 function insert($table,$data) {
 	global $db;
 	query("INSERT INTO $table(" . join(',', array_keys($data)) . ')VALUES('
 		. str_repeat('?,', count($data)-1). '?)', $data);
 	return $db->lastInsertId();
 }
 function tags($id) {
 	return query('SELECT t FROM t WHERE i=?',$id)->fetchAll(PDO::FETCH_COLUMN);
 }
 if(count($_FILES) > 0) {
 	extract($_FILES['file']);
 	list($w,$h,$type)=getimagesize($tmp_name);
 	if(!$type||$type>3||filesize($tmp_name)>$max_image_size_kb) exit();
 	$fex=strlen($ext=image_type_to_extension($type,false))==4?'jpg':$ext;
 	$id=insert('i',array('m'=>$md5=md5_file($tmp_name),'e'=>$fex));
 	if($id < 1) exit();
 	insert('t',array('i'=>$id,'t'=>'untagged'));
 	move_uploaded_file($tmp_name,$n="img/$id.$fex");
 	$i=call_user_func('imagecreatefrom'.$ext,$n);
 	$s=$thumbnail_size;$r=$w/$h;$tw=$r<1?floor($s*$r):$s;$th=$r<1?$s:floor($s/$r);
 	$t=imagecreatetruecolor($tw,$th);
 	imagecopyresampled($t,$i,0,0,0,0,$tw,$th,$w,$h);
 	imagejpeg($t,"tmb/$id.jpg",$thumbnail_quality);
 	imagedestroy($t);
 	echo $id;
 	exit();
 }
 $post = isset($_GET['post']) ? $_GET['post']+0 : false;
 if($post<0)$post=false;
 else {
 	$utags = isset($_GET['utags']) ? $_GET['utags'] : false;
 	if($utags) {
 		$tags=tags($post);
 		$utags=explode(' ',$utags);
 		$remove=array_diff($tags,$utags);
 		if(($c=count($remove)) > 0)
 			query('DELETE FROM t WHERE i = ? AND t IN (?'.str_repeat(',?',$c-1).')',
 				array_merge(array($post),$remove));
 		$add=array_diff($utags,$tags);
 		if(count($add) > 0)
 		foreach($add as $t)
 			insert('t',array('i'=>$post,'t'=>$t));
 		header('Location: ?post='.$post);
 		exit();
 	}
 }
 $del = isset($_GET['del']) ? $_GET['del']+0 : false;
 if($del<0)$del=false;
 if($del) {
 	//delete the images and database entries
 	$ex=ext($del);
 	unlink("img/$del.$ex");
 	unlink("tmb/$del.jpg");
 	query('DELETE FROM t WHERE i = ?',$del);
 	query('DELETE FROM i WHERE i = ?',$del);
 	header('Location: index.php');
 	exit();
 }
 $tags = isset($_GET['tags']) ? trim($_GET['tags']) : false;
 if(strlen($tags)<1)$tags=false;
 ?><!DOCTYPE html><html><head><meta charset="UTF-8" /><title>chibichan</title>
 <style type="text/css">form,h3,figure { margin: 0; padding: 0 }
 #thumb > figure {display: inline-block;vertical-align:middle;text-align:center;padding: 10px}
 img {padding:2px;border:1px solid transparent} img:hover {border:1px solid #ddd}
 header > form, header > h3 {display: inline-block;padding-right: 2em}
 body { font-family: "Arial", "Helvetica", sans-serif; } a { color: #669 }</style>
 <?php if(!$post) { ?><script type="text/javascript">var d = document.documentElement;
 d.ondragover=function(){return false;};
 d.ondragend=function(){return false;};
 d.ondrop=function(e){
 	e.preventDefault();
 	var fd=new FormData();
 	fd.append('file', e.dataTransfer.files[0]);
 	var x=new XMLHttpRequest();
 	x.onreadystatechange=function() {
 		if(x.readyState != 4)
 			return;
 		if(x.responseText === 'ERR')
 			location.reload();
 		else
 			location.replace('?post='+x.responseText);
 	};
 	x.open('POST','index.php',false);
 	x.send(fd);
 	return false;
 };</script><?php } ?></head><body>
 <header><h3><a href="index.php">Chibichan</a></h3><form action="." method="get"><label>Search: </label>
 <input type="text" name="tags" <?php if($tags) echo 'value="'.$tags.'"'; ?>><input style="display:none" type="submit" value="Update"></form></header><?php
 if($post) {
 	echo '<section id="post">';
 	$ex=ext($post);
 	echo '<figure><img src="img/'."$post.$ex".'" alt=""></figure>';
 	$tags=implode(' ',tags($post));
 	echo '<form action="." method="get"><label>Tags: </label><input type="hidden" name="post" value="'.$post.'">'
 		.'<input type="text" name="utags" value="'.$tags.'"><input style="display:none" type="submit" value="Update"></form>'
 		.'<form action="." method="get"><input type="hidden" name="del" value="'.$post.'"><input type="submit" value="Delete"></form>';
 	echo '</section>';
 } else {
 	echo '<section id="thumb">';
 	$imgs=false;
 	if($tags) {
 		$tags = explode(' ',$tags);
 		$count = count($tags);
 		$imgs = query('SELECT i FROM t WHERE t IN ('
 			. str_repeat('?,',$count-1).'?) GROUP BY i HAVING count(distinct t) = '.$count.' ORDER BY i DESC',$tags)->fetchAll(PDO::FETCH_COLUMN);
 	} else {
 		$imgs = query('SELECT i FROM i ORDER BY i DESC')->fetchAll(PDO::FETCH_COLUMN);
 	}
 	foreach($imgs as $i)
 		echo '<figure><a href="?post='.$i.'"><img src="tmb/'.$i.'.jpg" alt=""></a></figure>';
 	echo '</section>';
 }
 ?></body></html>
	<?php /* Copyright(c) 2013 Robert Maupin. Released under the ZLIB License. */
	date_default_timezone_set('GMT');
	define('DB','chan.db');
	$max_image_size_kb = 1024*1024;
	$thumbnail_size = 150;
	$thumbnail_quality = 70;
	$db = new PDO('sqlite:'.DB, 0, 0, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
	function query($sql, $params = NULL) {
	global $db;
	$s = $db->prepare($sql);
	$s->execute(array_values((array) $params));
	return $s;
	}
	function ext($id) {
	$ex=query('SELECT e FROM i WHERE i=?',$id)->fetch(PDO::FETCH_NUM);
	return $ex[0];
	}
	if(!is_file(DB)) {
	/* (I)mage: (I)D, FILE (M)D5, (E)xtension
	* (T)ags: Image (I)D, (T)ext
	*/
	query('CREATE TABLE i (i INTEGER PRIMARY KEY,m BLOB(16) UNIQUE ON CONFLICT ROLLBACK,e TEXT)');
	query('CREATE TABLE t (i INTEGER,t TEXT(32),PRIMARY KEY (i, t))');
	}
	function insert($table,$data) {
	global $db;
	query("INSERT INTO $table(" . join(',', array_keys($data)) . ')VALUES('
	. str_repeat('?,', count($data)-1). '?)', $data);
	return $db->lastInsertId();
	}
	function tags($id) {
	return query('SELECT t FROM t WHERE i=?',$id)->fetchAll(PDO::FETCH_COLUMN);
	}
	if(count($_FILES) > 0) {
	extract($_FILES['file']);
	list($w,$h,$type)=getimagesize($tmp_name);
	if(!$type\|\|$type>3\|\|filesize($tmp_name)>$max_image_size_kb) exit();
	$fex=strlen($ext=image_type_to_extension($type,false))==4?'jpg':$ext;
	$id=insert('i',array('m'=>$md5=md5_file($tmp_name),'e'=>$fex));
	if($id < 1) exit();
	insert('t',array('i'=>$id,'t'=>'untagged'));
	move_uploaded_file($tmp_name,$n="img/$id.$fex");
	$i=call_user_func('imagecreatefrom'.$ext,$n);
	$s=$thumbnail_size;$r=$w/$h;$tw=$r<1?floor($s*$r):$s;$th=$r<1?$s:floor($s/$r);
	$t=imagecreatetruecolor($tw,$th);
	imagecopyresampled($t,$i,0,0,0,0,$tw,$th,$w,$h);
	imagejpeg($t,"tmb/$id.jpg",$thumbnail_quality);
	imagedestroy($t);
	echo $id;
	exit();
	}
	$post = isset($_GET['post']) ? $_GET['post']+0 : false;
	if($post<0)$post=false;
	else {
	$utags = isset($_GET['utags']) ? $_GET['utags'] : false;
	if($utags) {
	$tags=tags($post);
	$utags=explode(' ',$utags);
	$remove=array_diff($tags,$utags);
	if(($c=count($remove)) > 0)
	query('DELETE FROM t WHERE i = ? AND t IN (?'.str_repeat(',?',$c-1).')',
	array_merge(array($post),$remove));
	$add=array_diff($utags,$tags);
	if(count($add) > 0)
	foreach($add as $t)
	insert('t',array('i'=>$post,'t'=>$t));
	header('Location: ?post='.$post);
	exit();
	}
	}
	$del = isset($_GET['del']) ? $_GET['del']+0 : false;
	if($del<0)$del=false;
	if($del) {
	//delete the images and database entries
	$ex=ext($del);
	unlink("img/$del.$ex");
	unlink("tmb/$del.jpg");
	query('DELETE FROM t WHERE i = ?',$del);
	query('DELETE FROM i WHERE i = ?',$del);
	header('Location: index.php');
	exit();
	}
	$tags = isset($_GET['tags']) ? trim($_GET['tags']) : false;
	if(strlen($tags)<1)$tags=false;
	?><!DOCTYPE html><html><head><meta charset="UTF-8" /><title>chibichan</title>
	<style type="text/css">form,h3,figure { margin: 0; padding: 0 }
	#thumb > figure {display: inline-block;vertical-align:middle;text-align:center;padding: 10px}
	img {padding:2px;border:1px solid transparent} img:hover {border:1px solid #ddd}
	header > form, header > h3 {display: inline-block;padding-right: 2em}
	body { font-family: "Arial", "Helvetica", sans-serif; } a { color: #669 }</style>
	<?php if(!$post) { ?><script type="text/javascript">var d = document.documentElement;
	d.ondragover=function(){return false;};
	d.ondragend=function(){return false;};
	d.ondrop=function(e){
	e.preventDefault();
	var fd=new FormData();
	fd.append('file', e.dataTransfer.files[0]);
	var x=new XMLHttpRequest();
	x.onreadystatechange=function() {
	if(x.readyState != 4)
	return;
	if(x.responseText === 'ERR')
	location.reload();
	else
	location.replace('?post='+x.responseText);
	};
	x.open('POST','index.php',false);
	x.send(fd);
	return false;
	};</script><?php } ?></head><body>
	<header><h3><a href="index.php">Chibichan</a></h3><form action="." method="get"><label>Search: </label>
	<input type="text" name="tags" <?php if($tags) echo 'value="'.$tags.'"'; ?>><input style="display:none" type="submit" value="Update"></form></header><?php
	if($post) {
	echo '<section id="post">';
	$ex=ext($post);
	echo '<figure><img src="img/'."$post.$ex".'" alt=""></figure>';
	$tags=implode(' ',tags($post));
	echo '<form action="." method="get"><label>Tags: </label><input type="hidden" name="post" value="'.$post.'">'
	.'<input type="text" name="utags" value="'.$tags.'"><input style="display:none" type="submit" value="Update"></form>'
	.'<form action="." method="get"><input type="hidden" name="del" value="'.$post.'"><input type="submit" value="Delete"></form>';
	echo '</section>';
	} else {
	echo '<section id="thumb">';
	$imgs=false;
	if($tags) {
	$tags = explode(' ',$tags);
	$count = count($tags);
	$imgs = query('SELECT i FROM t WHERE t IN ('
	. str_repeat('?,',$count-1).'?) GROUP BY i HAVING count(distinct t) = '.$count.' ORDER BY i DESC',$tags)->fetchAll(PDO::FETCH_COLUMN);
	} else {
	$imgs = query('SELECT i FROM i ORDER BY i DESC')->fetchAll(PDO::FETCH_COLUMN);
	}
	foreach($imgs as $i)
	echo '<figure><a href="?post='.$i.'"><img src="tmb/'.$i.'.jpg" alt=""></a></figure>';
	echo '</section>';
	}
	?></body></html>