ASCard/save_unit_prep.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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
<?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');

	$index  = isset($_GET["index"]) ? $_GET["index"] : "";
	$desc   = isset($_GET["desc"]) ? $_GET["desc"] : "";
	$value  = isset($_GET["value"]) ? $_GET["value"] : "";

	$currentRound = isset($_GET["currentRound"]) ? $_GET["currentRound"] : "";
	$gameid = isset($_GET["gameid"]) ? $_GET["gameid"] : "";

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

	if (!empty($index)) {
		echo "SAVING DATA...<br>\r\n";

		echo "CurrentRound: ".$currentRound;

		echo "index: " . $index . "<br>\r\n";
		echo "desc:  " . $desc  . "<br>\r\n";
		echo "value: " . $value . "<br>\r\n";
		echo "<br>\r\n";

		if ($desc == "ENGN_PREP") {
			$sql = "UPDATE asc_unitstatus SET crit_engine_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "FCTL_PREP") {
			$sql = "UPDATE asc_unitstatus SET crit_fc_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "MP_PREP") {
			$sql = "UPDATE asc_unitstatus SET crit_mp_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "WPNS_PREP") {
			$sql = "UPDATE asc_unitstatus SET crit_weapons_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "CV_ENGN_PREP") {
			$sql = "UPDATE asc_unitstatus SET crit_CV_engine_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "CV_FCTL_PREP") {
			$sql = "UPDATE asc_unitstatus SET crit_CV_firecontrol_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "CV_WPNS_PREP") {
			$sql = "UPDATE asc_unitstatus SET crit_CV_weapons_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "CV_MOTVA_PREP") {
			$sql = "UPDATE asc_unitstatus SET crit_CV_motiveA_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "CV_MOTVB_PREP") {
			$sql = "UPDATE asc_unitstatus SET crit_CV_motiveB_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "CV_MOTVC_PREP") {
			$sql = "UPDATE asc_unitstatus SET crit_CV_motiveC_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "HT_PREP") {
			$sql = "UPDATE asc_unitstatus SET heat_PREP=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		if ($desc == "HT_PREP_ENGINEHIT") {
			$sql = "UPDATE asc_unitstatus SET heat_PREP_ENGINEHIT=".$value." WHERE unitid=".$index." AND round=".$currentRound." AND gameid=".$gameid.";";
		}
		echo $sql;

		if (mysqli_query($conn, $sql)) {
			echo "<br>\r\n";
			echo "Record (asc_assign) updated successfully\r\n";
			mysqli_commit($conn);
		} else {
			echo "<br>\r\n";
			echo "Error (asc_assign) updating record: ".mysqli_error($conn)."\r\n";
		}
	}
	echo "</p>\r\n";
	echo "</body>\r\n";
	echo "</html>\r\n";
?>