* * @author Double Bastion LLC * * @license GNU AGPL version 3 or any later version * * This program 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 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 AFFERO GENERAL PUBLIC LICENSE for more details. * * You should have received a copy of the GNU Affero General Public * License along with this program. If not, see . * */ session_start(); define('ACCESSCONST', TRUE); if (($_SESSION['loggedtorspanel'] == true) && ($_SESSION['userrole'] == 'superadmin')) { require('db-connect.php'); // Insert new button data into the database if (isset($_POST['userrole']) && isset($_POST['username']) && isset($_POST['nameonbutton']) && isset($_POST['buttonurl'])) { $ordno = $_POST['ordno']; $dbid = $_POST['dbid']; $userrole = $_POST['userrole']; $username = $_POST['username']; $nameonbutton = $_POST['nameonbutton']; $buttonurl = $_POST['buttonurl']; $imgname = $_POST['imgname']; if (($userrole != '') && ($username != '') && ($nameonbutton != '') && ($buttonurl != '')) { if ($dbid == '') { try { $query1 = $mysqli->prepare("INSERT INTO buttons (orderno, userrole, username, nameonbutton, buttonurl, imgname) VALUES (?, ?, ?, ?, ?, ?)"); $query1->bind_param("isssss", $ordno, $userrole, $username, $nameonbutton, $buttonurl, $imgname); $query1->execute(); $query1->close(); $messageonsave = "The button has been added successfully !"; } catch(mysqli_sql_exception $e) { $messageonsave = "An error occurred when adding the button. Please check your input data !!!"; } } else { try { if ($imgname != '') { $query2 = $mysqli->prepare("UPDATE buttons SET orderno=?, nameonbutton=?, buttonurl=?, imgname=? WHERE id=?"); $query2->bind_param("isssi", $ordno, $nameonbutton, $buttonurl, $imgname, $dbid); $query2->execute(); $query2->close(); } else { $query3 = $mysqli->prepare("UPDATE buttons SET orderno=?, nameonbutton=?, buttonurl=? WHERE id=?"); $query3->bind_param("issi", $ordno, $nameonbutton, $buttonurl, $dbid); $query3->execute(); $query3->close(); } $messageonsave = "The button has been updated successfully !"; } catch(mysqli_sql_exception $e) { $messageonsave = "An error occurred when updating button data. Please check your input data !"; } } } else { $messageonsave = "Error. Please check your input data !"; } } $result = array( 'messageonsave' => $messageonsave ); echo json_encode($result); } elseif (empty($_SESSION['loggedtorspanel'])) { header("Location: panel-login.php"); } elseif (($_SESSION['loggedtorspanel'] == true) && ($_SESSION['userrole'] != 'superadmin')) { header("Location: index.php"); } ?>