From 5834625948e21672afb15783ad2463133d58d1a2 Mon Sep 17 00:00:00 2001
From: root <root@debian.(none)>
Date: Fri, 19 Nov 2010 22:08:40 +0100
Subject: [PATCH] little bookmakr system

---
 bookmarks/README           |  12 ++++
 bookmarks/config.php       |  10 ++++
 bookmarks/db_structure.sql |   9 +++
 bookmarks/edit.png         | Bin 0 -> 3326 bytes
 bookmarks/index.php        | 116 +++++++++++++++++++++++++++++++++++++
 5 files changed, 147 insertions(+)
 create mode 100644 bookmarks/README
 create mode 100644 bookmarks/config.php
 create mode 100644 bookmarks/db_structure.sql
 create mode 100644 bookmarks/edit.png
 create mode 100644 bookmarks/index.php

diff --git a/bookmarks/README b/bookmarks/README
new file mode 100644
index 0000000..0eaf9f6
--- /dev/null
+++ b/bookmarks/README
@@ -0,0 +1,12 @@
+A simple Script to manage your Bookmarks without any third-party hoster eg. xmarks, apple etc.
+
+All you need is this script a MySQL Database and one table in it.
+
+Create your own subdomain and protect it with the htaccess file and your can now access and manage
+your Bookmarks everywhere.
+
+Independent to a browser or location.
+
+AND your data is where YOU know. Not in a cloud without security. You control it and decide where and who has access.
+
+copyright 2010 Johannes 'Banana' Keßler
diff --git a/bookmarks/config.php b/bookmarks/config.php
new file mode 100644
index 0000000..de91638
--- /dev/null
+++ b/bookmarks/config.php
@@ -0,0 +1,10 @@
+<?php
+/**
+ * database configuration file
+ * alter to reflect your DB settings
+ */
+define('DB_HOST','localhost');
+define('DB_NAME','bookmarks');
+define('DB_USER','user');
+define('DB_PASS','test');
+?>
diff --git a/bookmarks/db_structure.sql b/bookmarks/db_structure.sql
new file mode 100644
index 0000000..d010c50
--- /dev/null
+++ b/bookmarks/db_structure.sql
@@ -0,0 +1,9 @@
+CREATE TABLE `bookmarks` (
+  `id` int(10) NOT NULL AUTO_INCREMENT,
+  `category` varchar(128) DEFAULT NULL,
+  `title` varchar(128) DEFAULT NULL,
+  `link` varchar(255) DEFAULT NULL,
+  `date_added` int(10) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `link` (`link`)
+) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
diff --git a/bookmarks/edit.png b/bookmarks/edit.png
new file mode 100644
index 0000000000000000000000000000000000000000..f4232c67819035ab59a66f8addb5cd1922b3c6e7
GIT binary patch
literal 3326
zcmb7H2{@E%8y=IL5GA{>vGiYIHezNlj3~-ZSz?Yc^BI#dGiJ%yx3p1~&f&CJqV>>b
zsT83isZa?=Waoq;k|WChp*nT`^Z(cN&vngw-}AlCbKm!SKi~UY*Bo+n-nLp=O&SJ+
zt#+`tb%(C#rLUwo3?>4IJzN8Wi8e4iz4_iwjsz+@6iK1613{!PlmlhKU=~(F4uu*5
z@_|5*&R|(0CT>?F00zwx;kDTb?Znvv1~cp<xu8d+vnMq&go>vjtccPULIMO33i2s{
zFqFyS5rmeAWn2Puzw{V|0G3nuA(jZz5+UI2<O*zIb3woai7}$0jm-cPQzRCLHN~46
z0#0leK;m!#G#0?3(PjV!M=&-eY&HeHd=Nxwz=BH)BDmXb{lW-EmWW_JpF=>Q!o$On
z;l@ZdmyW{V@pu#(i^5`!pbR5k1dC4*8nJjfOAsp<wjhtnWpMZmh;#{)637<tEfEN4
z9r(H(3dfy659af}QLuPljDsvh2`L;D28l*-mvc~mtNh<J-zU?k-*PzuE^~PUG%5;Y
zf}tRb&x1HHE8q~}iXMU&80f*L@Rt+56$diebVweJLFI!qKAXx83IahS4P54eY6(tI
zOK226#TKfxL_ikfjnEh)EY=f)CZJ6T7!w0DhJZ#ddjwd}s01n(r106?CC|RN<^hJS
zL@OpT8AKN*V=u@BJi{qm8atd9!mvOs*$J(zR4qqe%PdfTLtSE_{nd%@m`F_ik4#HV
zAuuT{x+OwrL<55;0wy0poG7dYoG3I9fZ9lb?x-8|b%Z4I<sVQ;WeRwZJRpe81w2A2
zykG{44kghkkqj32PeQ-4E(`s;uqClPLEs*c`bFCE%V<NP|0tBmpt4!KAJM<r6~v_M
zWed3fWtI0;W9UC>{D$(i%K)DZtn~Ruz?JB$vgOTuFMMeuD{t-pZ}{DdONSE=1V#Y=
z(R$#YRQzD+U#u&s-<?88%E~k7bVIWR^=-I7!ME`QvY?s7g@(^tQMYF>n8Z5=Tast6
z*pm~FQg(VNADG=))abQg&wN9TX|J`!{&-S<@kViptYeP0*KV(YC&YiSYT5cmOG5iS
zS^+-l$2lVhe`w20c2@9gK>w?M-md)0%lVgW;d{DyO-3%N$>ggcZ>n;u%Rdm)qRQGQ
zW<AuOkc6YH7e9C34xg9TCXQPPC-dWGPR7loz=t|Iyib_1$)huojC&8}-QBt>cpKL!
zCVNIyM$T-qjQU_$d%AIOZhFKnzJH-P&Y_BO;qZg1sM(La;l~ara;5#FY}7=bFE{;X
zOx))Mc$K?~oSe;teUWohVC@ysS=btz)5_~bQ;%(Q`M~bE<L`Uy-Y;`?DeFr|%gN+*
z<hwxu`C6)~4uyq<j87kD4&BMcg%#vA%{C%saV=i5VFyJd5j&0Nok_B(y=5;C?@+Mp
zGnst-{QOyZkVw>-J!uNV(+YxB)34|Zr8`?@Sv3U1-(*jj46b$Vndqs`L;BrJ-#hWj
z|ATklZ^2jH|CJQ;({-lLHGI?urqugSSyokY!EUE0h8*jy`a+@`<4tFI)qDR}2dX}i
z#iWudcq1n&`gdd_FAY121M5glEyEYQhHCUh5}+aNBVH%3Q8~Vo1UKKFA0~yR>qseF
z<N`@XbvIcTJcg`I#E;4-8>(>HRLCy^viBwF+*3n3#=0#uK5eKUc#x(Yr=n9g_xaO&
z_Q;Gj_VHLLaR<gVJ7Q;Peb>9|p)YssIcIqC0lDN{#Lsny`k0sfDzKs5w*<Y>YBJ=R
zU~8NJ*RlNyXIM9$m*rLLodGLhb>HH@es-2Ps}Xn#&pT&zjk>M8{fIOgtHP6f575)^
zZ@15#$RD~}vG<MdwVYq8b)2Hf=Z0KD;3fshJ9G;`UASnM@*a<oOGbAwinU#<TuZb1
z{d@+GNLOx1ltozEI!t{Gcs`R-d)!PBxSvqN*&h|(^!b==3{%H6!&m8GI_z--EkjrT
z+5P~(XZJ2_P7tv(m}Th%zQh^grrJcs@7Gk!_vYp&1?t&dEw_ppFX^r7+4L$Z@%1YI
z(Wu!twW#!Fp5T{=HBadcu|1U$#{PGrj~{q<Iy!`Cp;X)^-Qk_6l&(~FLZ{J5uBnhe
zJ^X~xoNIaDsHVATdhdDE;w};0un_oKQE*aui>uV{1$HUVGWB*Gjvi^s`AHkk9n2dY
ztIU86ikc+U`WMm-$(1<Eh^aFc>!&nlCd7%0wY@1e18axwWM%tk+{~2PI%)q_3hOHz
zs6SE`Hc;QbwR+GiEA8Bs<a&K|S!AcmDLmKgl=5Yt(sL~LOLWJ8-DRfu+T*(qao-@=
z<07F?MYKjli+kc)ALNI<vX5Wo0Ob50Y!+LCzad?cd4c!JK44Ci?p&>x*}~)NZ(Bdo
z*{B|+@N}S|vrR?vxca3k5lAZ_-q)C%K3AHsnWWm_;MudDd1fno9pSFj{rpUv<YTpN
z^d8+B5%_6d=A?;nx<g=plN35tq@Yl0Xmm7WX!5lVR<F+c%);fu)eE$%hzgRA@qV{L
zyRyWrtF@xTF}d@rvEpl!<YkI0GiqS@2;7TFs-~hP*5&96<)kdDBg%&|VKYTHj&_wl
zJh(U@A0_e3gw=k7)!i8Toc$CqQFwT~DBKw=^16bgZ+=M+d-R52@W(2vBjO5t|3Uh+
z@VbA-gN^t$q4Shv&sH(X9=)nr(FsN7?&3BNwbgS@D(!6J5m_|g@)0@*@^4?>n9yb`
zp*~iINi4V(DIG9Xlvrm&ZnraM5mfmzIf;3xMY}F-_qyzdKh@lGI@tVV!~j-nSVM$c
z{-XA`Z0Z1@?_%)EOf}Z9vjp7HSsv0}%NuE$Nz=0IyrmvJJLumkzg-Z`wy?oTHdb^Y
zMm1t|r89)xgW}RT#28;po{rpLH!;0uT;gck6?LNHVl027|3aw6r}C2ATs{&=Y_ZhR
z29=YVDhT-77!1ZOw?@N=XgAf7@KaUf4ClJc?TobX-iw<Z`*LJj3=;bjQ(a^P%Hroa
zL-nrB)0x*eeRsKGyd!?qvHqoZZ=^Y$c@w>BZXo`qFCS^Gz(xG2tPD2zG?%UFuq|nM
z7nZA6TIej+x&?k!&R2ctT|<P-5!1Jc8aa151rYw#Ld+rF%}6|!j8*BZEBN`fy3A|1
z-^nJiKdjBf6l)8-n*21|59$UBp313Gubafgjr}2IpJ1Ea;c&QY+Ha%VfwZyf5vjj}
zpX)VyWeVsW_c`KqEt_ZbQ?a4@1>P0W9qV^c+vn6}T1YLI`(R#juwmCOy>PhdKFwHo
zoBU_f)(V)Cq&uuwY=ia9y`x5LxR2YkhfB{oi`_p1oAOR~oZRaTg9km)P%L|wN|ha|
zyE%~OEGAih`9yj-wjw|*)h~d{cWY9szObz=nXt}P-WCzNX<F-E5iIAuIew8`d+E96
znzfZ=S}P{4uAL{hJA9KhCw{8?z&`zTziL#hXFC?lm*Cp#3;e_Ta-<I?ILK}o&~pTo
zl~Y=FA%V1%>y2Z38=4nKni)(QSxxi!N#YCiq_bGMeSYl?CjJ&BQt)SM?dhUNW2SZS
zR@JkDTSjOsL6x*i>b$<6j-SE!(e~|S3<H~(HlxSWFCv(Y16-}K=UzR#^311hxsI{>
z#~+(1e>NA3Hj$6Dsa0)I9oI_A)|7BD_y{)R*s^a67jz1e;sU9Yi#{sN=j!9m|EW9G
lrTb@Ut8Y!J)*`)eQKYYV8{X3~dHHXPgPpVOWt)J+e*<;Ia>D=s

literal 0
HcmV?d00001

diff --git a/bookmarks/index.php b/bookmarks/index.php
new file mode 100644
index 0000000..c855926
--- /dev/null
+++ b/bookmarks/index.php
@@ -0,0 +1,116 @@
+<?php
+/**
+ * boomark management
+ */
+
+/**
+ * display any error we have
+ */
+ini_set('error_reporting',-1);
+ini_set('display_errors',true);
+
+# load the config file
+require('./config.php');
+# db connection
+$db_con = mysql_connect(DB_HOST,DB_USER,DB_PASS) OR die('Can not connect to SQL server');
+$db_sel = mysql_select_db(DB_NAME,$db_con) OR die('Can not select database');
+
+# process the add
+if(isset($_POST['sub']['submitNew'])) {
+	$link = trim($_POST['new']['link']);
+	$title = trim($_POST['new']['title']);
+	$cat = trim($_POST['new']['category']);
+	if(!empty($link) && !empty($title) && !empty($cat)) {
+		$query = mysql_query("INSERT INTO `bookmarks` 
+								SET `category` = '".mysql_escape_string($cat)."',
+									`title` = '".mysql_escape_string($title)."',
+									`link` = '".mysql_escape_string($link)."',
+									`date_added` = '".time()."'");
+		if($query !== false) {
+			header("Location: index.php");
+		}
+		else {
+			echo "not saved";
+		}
+	}
+}
+elseif(isset($_POST['sub']['submitEdit']) && isset($_GET['edit']) && !empty($_GET['edit'])) {
+# process edit
+	$link = trim($_POST['new']['link']);
+	$title = trim($_POST['new']['title']);
+	$cat = trim($_POST['new']['category']);
+	if(!empty($link) && !empty($title) && !empty($cat)) {
+		$query = mysql_query("UPDATE `bookmarks` 
+								SET `category` = '".mysql_escape_string($cat)."',
+									`title` = '".mysql_escape_string($title)."',
+									`link` = '".mysql_escape_string($link)."'
+								WHERE `id` = '".mysql_escape_string($_GET['edit'])."'");
+		if($query !== false) {
+			header("Location: index.php");
+		}
+		else {
+			echo "not saved";
+		} 
+	}
+}
+
+# get the bookmarks
+$bookmarks = array();
+$query = mysql_query('SELECT * FROM `bookmarks` ORDER BY `category`,`title`');
+if(mysql_num_rows($query) > 0) {
+	while($result = mysql_fetch_assoc($query)) {
+		$bookmarks[$result['id']] = $result;
+	}
+}
+?>
+<html>
+	<head>
+		<title>Bookmarks for myself</title>
+		<style type="text/css">
+			img {
+				border: 0;
+				padding: 0;
+				margin: 0;
+			}
+		</style>
+	</head>
+	<body>
+	<?php if(isset($_GET['edit']) && !empty($_GET['edit'])) { ?>
+	<form method="post" action="">
+		Link:<br />
+		<input type="text" name="new[link]" size="60" value="<?php echo $bookmarks[$_GET['edit']]['link']; ?>" /><br />
+		Titel:<br />
+		<input type="text" name="new[title]" value="<?php echo $bookmarks[$_GET['edit']]['title']; ?>" size="60" /><br />
+		Kategorie:<br />
+		<input type="text" name="new[category]" value="<?php echo $bookmarks[$_GET['edit']]['category']; ?>" size="60" /><br />
+		<button type="submit" title="Speichern" name="sub[submitEdit]">Speichern</button>
+	</form>
+	<?php } else { ?>
+	<form method="post" action="">
+		Link:<br />
+		<input type="text" name="new[link]" size="60" value="" /><br />
+		Titel:<br />
+		<input type="text" name="new[title]" value="" size="60" /><br />
+		Kategorie:<br />
+		<input type="text" name="new[category]" value="" size="60" /><br />
+		<button type="submit" title="Speichern" name="sub[submitNew]">Speichern</button>
+	</form>
+	<?php
+	}
+	# display the bookmark
+	if(!empty($bookmarks)) {
+		$cat = false;
+		foreach($bookmarks as $entry) {
+			if($cat != $entry['category']) {
+				if(!empty($cat)) echo '</ul>';
+				echo '<h2>'.$entry['category'].'</h2>';
+				echo '<ul>';
+				$cat = $entry['category'];
+			}
+			echo '<li><a href="'.$entry['link'].'">'.$entry['title'].'</a> | <a href="index.php?edit='.$entry['id'].'" title="edit"><img src="edit.png" width="16" alt="edit" /></a></li>';
+		}
+		echo '</ul>';
+	}
+?>
+	</body>
+</html>
-- 
2.39.5