5 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
5 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
6 if (! $connect) { |
6 if (! $connect) { |
7 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
7 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
8 } |
8 } |
9 mysqli_set_charset($connect, "utf8" ); |
9 mysqli_set_charset($connect, "utf8" ); |
|
10 $sql = ""; |
10 |
11 |
11 $sql = "UPDATE `mon_ispindels` SET "; |
12 if (isset($_POST['beername']) && isset($_POST['beercode']) && isset($_POST['beeruuid'])) { |
12 $sql .= "beername='" . mysqli_real_escape_string($connect, $_POST['beername']); |
13 $sql = "UPDATE `mon_ispindels` SET "; |
13 $sql .= "', beercode='" . mysqli_real_escape_string($connect, $_POST['beercode']); |
14 $sql .= "beername='" . mysqli_real_escape_string($connect, $_POST['beername']); |
14 $sql .= "', beeruuid='" . mysqli_real_escape_string($connect, $_POST['beeruuid']); |
15 $sql .= "', beercode='" . mysqli_real_escape_string($connect, $_POST['beercode']); |
15 $sql .= "' WHERE node='" . $_POST['node'] . "';"; |
16 $sql .= "', beeruuid='" . mysqli_real_escape_string($connect, $_POST['beeruuid']); |
|
17 $sql .= "' WHERE uuid='" . $_POST['uuid'] . "';"; |
|
18 } else if (isset($_POST['mode'])) { |
|
19 $sql = "UPDATE `mon_ispindels` SET mode='" .$_POST['mode'] . "' WHERE uuid='" . $_POST['uuid'] . "';"; |
|
20 } |
16 |
21 |
17 $result = mysqli_query($connect, $sql); |
22 $result = mysqli_query($connect, $sql); |
18 if (! $result) { |
23 if (! $result) { |
19 syslog(LOG_NOTICE, "cmd_ispindel: result: ".mysqli_error($connect)); |
24 syslog(LOG_NOTICE, "cmd_ispindel: result: ".mysqli_error($connect)); |
20 } else { |
25 } else { |
21 syslog(LOG_NOTICE, "cmd_ispindel: updated record ".$_POST['node']); |
26 syslog(LOG_NOTICE, "cmd_ispindel: updated record ".$_POST['uuid']); |
22 } |
27 } |
23 echo $result; |
28 echo $result; |
24 ?> |
29 ?> |