summaryrefslogtreecommitdiff
path: root/www/reorder.php
diff options
context:
space:
mode:
authorIan C <ianc@noddybox.co.uk>2018-07-07 13:26:02 +0000
committerIan C <ianc@noddybox.co.uk>2018-07-07 13:26:02 +0000
commit62d926e022aaf35be029f20568e55533caee3bf7 (patch)
tree58b4dcb2de9f91f7af0f1b5893cea5aa07d7a4ea /www/reorder.php
parent9bd1ad2bfb807d7714e17112a9dc51f2416a1e6c (diff)
Added up/down links to reorder entries.
Diffstat (limited to 'www/reorder.php')
-rw-r--r--www/reorder.php75
1 files changed, 75 insertions, 0 deletions
diff --git a/www/reorder.php b/www/reorder.php
new file mode 100644
index 0000000..375ee62
--- /dev/null
+++ b/www/reorder.php
@@ -0,0 +1,75 @@
+<?php
+
+/*
+ PassMan - simple password manager
+ Copyright (C) 2018 Ian Cowburn
+
+ This program is free software: you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation, either version 3 of the License, or
+ (at your option) any later version.
+
+ This program 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 General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program. If not, see <http://www.gnu.org/licenses/>.
+*/
+
+require 'config.php';
+require 'common.php';
+
+$result = array();
+
+try
+{
+ $db = ConnectDB();
+
+ $from_id = $_REQUEST["from_id"];
+ $to_id = $_REQUEST["to_id"];
+ $from_display = 0;
+ $to_display = 0;
+
+ $cmd = $db->prepare("SELECT display FROM pm_store ".
+ "WHERE id = :id");
+ $cmd->bindParam(":id", $from_id);
+ $cmd->execute();
+
+ $data = $cmd->fetch();
+
+ $from_display = $data["display"];
+
+ $cmd->bindParam(":id", $to_id);
+ $cmd->execute();
+
+ $data = $cmd->fetch();
+
+ $to_display = $data["display"];
+
+ $from_update = $db->prepare("UPDATE pm_store SET display = :to_display " .
+ "WHERE id = :from_id");
+ $from_update->bindParam(":to_display", $to_display);
+ $from_update->bindParam(":from_id", $from_id);
+ $from_update->execute();
+
+ $to_update = $db->prepare("UPDATE pm_store SET display = :from_display " .
+ "WHERE id = :to_id");
+ $to_update->bindParam(":from_display", $from_display);
+ $to_update->bindParam(":to_id", $to_id);
+ $to_update->execute();
+
+ $result["status"] = true;
+
+ $db = null;
+}
+catch(PDOException $e)
+{
+ $result["error"] = "DB error:" . $e->getMessage();
+}
+
+header("Content-type:application/json");
+echo json_encode($result);
+
+?>