From 62d926e022aaf35be029f20568e55533caee3bf7 Mon Sep 17 00:00:00 2001
From: Ian C <ianc@noddybox.co.uk>
Date: Sat, 7 Jul 2018 13:26:02 +0000
Subject: Added up/down links to reorder entries.

---
 www/reorder.php | 75 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 75 insertions(+)
 create mode 100644 www/reorder.php

(limited to 'www/reorder.php')

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);
+
+?>
-- 
cgit v1.2.3