www/cmd_ispindel.php

changeset 578
e75ce5bbda73
parent 570
c8a20234d7e7
child 593
e0230bf4ac3f
equal deleted inserted replaced
577:b4bfed3684d0 578:e75ce5bbda73
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 ?>

mercurial