ASCard/save_command_data.php at master · ClanWolf/ASCard · GitHub

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
<?php

	//	ini_set('display_errors', 1);
	//	ini_set('display_startup_errors', 1);
	//	error_reporting(E_ALL);

	date_default_timezone_set('Europe/Berlin');

	session_start();

	require('./logger.php');
	require_once('./db.php');

	$commandid = isset($_GET["commandid"]) ? filter_var($_GET['commandid'], FILTER_VALIDATE_INT) : "";
	$newcommandname = isset($_GET["newcommandname"]) ? $_GET["newcommandname"] : "";
	$newcommandtype = isset($_GET["newcommandtype"]) ? $_GET["newcommandtype"] : "";
	$newcommandfaction = isset($_GET["newcommandfaction"]) ? $_GET["newcommandfaction"] : "";
	$newcommandbackground = isset($_GET["newcommandbackground"]) ? $_GET["newcommandbackground"] : "";

	echo "<!DOCTYPE html>\n";
	echo "<html lang='en'>\n";
	echo "<body>\n";
	echo "<p style='font-family:Arial,sans-serif;font-size:14px;color:yellow;'>\n";

	echo "CommandId:          ".$commandid."<br>";
	echo "New command name:   ".$newcommandname."<br>";
	echo "New command type:   ".$newcommandtype."<br>";
	echo "New faction:        ".$newcommandfaction."<br>";
	echo "Command background: ".$newcommandbackground."<br>";

	echo "Saving Command info...";

	if (!empty($newcommandname)) {
		$sql = "UPDATE asc_command SET commandname='".$newcommandname."',type='".$newcommandtype."',factionid=".$newcommandfaction.",commandbackground='".$newcommandbackground."' WHERE commandid=".$commandid.";";
		echo "<br><br>".$sql;

		if (mysqli_query($conn, $sql)) {
			echo "<br><br>Command updated successfully.";
			mysqli_commit($conn);

			echo "<script>top.window.location = './gui_select_unit.php'</script>";
			die('ERROR 3');
		} else {
			echo "<br><br>ERROR while updating command: " . mysqli_error($conn);
		}
	}

	echo "</p>\n";
	echo "</body>\n";
	echo "</html>\n";
?>