summaryrefslogtreecommitdiffstats
path: root/apps/bookmarks/ajax/delBookmark.php
blob: bf1611fe5c1fff4d6dda7ce6155fd53bfd8d3251 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<?php

/**
* ownCloud - bookmarks plugin
*
* @author Arthur Schiwon
* @copyright 2011 Arthur Schiwon blizzz@arthur-schiwon.de
* 
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE
* License as published by the Free Software Foundation; either 
* version 3 of the License, or any later version.
* 
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU AFFERO GENERAL PUBLIC LICENSE for more details.
*  
* You should have received a copy of the GNU Lesser General Public 
* License along with this library.  If not, see <http://www.gnu.org/licenses/>.
* 
*/

//no apps or filesystem
$RUNTIME_NOSETUPFS=true;

require_once('../../../lib/base.php');

// We send json data
header( "Content-Type: application/jsonrequest" );

// Check if we are a user
if( !OC_User::isLoggedIn()){
	echo json_encode( array( "status" => "error", "data" => array( "message" => "Authentication error" )));
	exit();
}

$params=array(
	htmlspecialchars_decode($_GET["url"]),
	OC_User::getUser()
	);

$query = OC_DB::prepare("
	SELECT id FROM *PREFIX*bookmarks 
	WHERE url LIKE ?
		AND user_id = ?
	");

$id = $query->execute($params)->fetchOne();

$query = OC_DB::prepare("
	DELETE FROM *PREFIX*bookmarks
	WHERE id = $id
	");
	
$result = $query->execute();


$query = OC_DB::prepare("
	DELETE FROM *PREFIX*bookmarks_tags
	WHERE bookmark_id = $id
	");
	
$result = $query->execute();
// var_dump($params);

echo json_encode( array( "status" => "success", "data" => array()));