comparison: www/cmd_ispindel.php
www/cmd_ispindel.php
- changeset 680
- 0bb48333d133
- parent 679
- 48f8f3fce7c0
- child 681
- 7ed5c380e21b
equal
deleted
inserted
replaced
| 679:48f8f3fce7c0 | 680:0bb48333d133 |
|---|---|
| 1 <?php | |
| 2 require_once('config.php'); | |
| 3 | |
| 4 #Connect to the database | |
| 5 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | |
| 6 if (! $connect) { | |
| 7 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
| 8 } | |
| 9 mysqli_set_charset($connect, "utf8" ); | |
| 10 $sql = ""; | |
| 11 | |
| 12 if (isset($_POST['beername']) && isset($_POST['beercode']) && isset($_POST['beeruuid'])) { | |
| 13 $sql = "UPDATE `mon_ispindels` SET "; | |
| 14 $sql .= "beername='" . mysqli_real_escape_string($connect, $_POST['beername']); | |
| 15 $sql .= "', beercode='" . mysqli_real_escape_string($connect, $_POST['beercode']); | |
| 16 $sql .= "', beeruuid='" . mysqli_real_escape_string($connect, $_POST['beeruuid']); | |
| 17 $sql .= "', og_gravity=0 WHERE uuid='" . $_POST['uuid'] . "';"; | |
| 18 } else if (isset($_POST['mode'])) { | |
| 19 $sql = "UPDATE `mon_ispindels` SET mode='" .$_POST['mode'] . "' WHERE uuid='" . $_POST['uuid'] . "';"; | |
| 20 } else { | |
| 21 syslog(LOG_NOTICE, "cmd_ispindel: unknown POST"); | |
| 22 } | |
| 23 | |
| 24 $result = mysqli_query($connect, $sql); | |
| 25 if (! $result) { | |
| 26 syslog(LOG_NOTICE, "cmd_ispindel: result: ".mysqli_error($connect)); | |
| 27 } | |
| 28 echo $result; | |
| 29 ?> |
