diff options
Diffstat (limited to 'ru')
| -rw-r--r-- | ru/kolo/api.php | 163 |
1 files changed, 163 insertions, 0 deletions
diff --git a/ru/kolo/api.php b/ru/kolo/api.php new file mode 100644 index 0000000..64dd35c --- /dev/null +++ b/ru/kolo/api.php @@ -0,0 +1,163 @@ +<?php + + $dbuser = "kolo"; + $dbhost = "localhost"; + $dbdb = "kolo"; + $dbpw = "kolo"; + $conn = new mysqli($dbhost, $dbuser, $dbpw, $dbdb); + header("Content-Type: application/json"); + if ($conn->connect_error) { + http_response_code(500); + exit('{"napaka":true,"obvestilo":"Napaka strežnika pri povezavi v podatkovno zbirko."}'); + } + $query = "CREATE TABLE IF NOT EXISTS kolesa ( + omogoceno INT, + ime VARCHAR(420), + admin VARCHAR(420) + ); + CREATE TABLE IF NOT EXISTS ljudje ( + ime VARCHAR(420) PRIMARY KEY, + izbranec VARCHAR(420), + kolo VARCHAR(420), + krneki VARCHAR(420) + )"; + $result = $conn->query($query); + var_dump($result); + var_dump($conn->error); + if (empty($_REQUEST['k'])) { + http_response_code(400); + exit ('{"napaka":true,"obvestilo":"Ne vem, na katero kolo se sklicuješ, ker manjka parameter k."}'); + } + switch ($_REQUEST['m']) { + case "r": /* registracija */ + if (empty($_REQUEST['i'])) { + http_response_code(400); + exit ('{"napaka":true,"obvestilo":"Ne vem, kako ti je ime, ker manjka parameter i"}'); + } + $stmt2 = $conn->prepare("SELECT omogoceno FROM `kolesa` WHERE `ime`=?"); + $stmt2->bind_param("s", $_REQUEST["k"]); + $stmt2->execute(); + $stmt2->bind_result($omogoceno); + $stmt2->fetch(); + if ($omogoceno != 0) { + http_response_code(400); + exit ('{"napaka":true,"obvestilo":"Ne morem registrirati novih ljudi, ker se je vrtenje koles že začelo.}'); + } + $stmt2->close(); + $stmt = $conn->prepare("INSERT INTO ljudje (ime, kolo) VALUES (?, ?) ON DUPLICATE KEY UPDATE `krneki`='123'"); + $stmt->bind_param("ss", $_REQUEST["i"], $_REQUEST["k"]); + $stmt->execute(); + $stmt->close(); + http_response_code(201); + exit ('{"napaka":false,"obvestilo":"Uporabnik registriran!"}'); + break; + case "z": /* zakleni kolo, omogoči vrtenje, naključno razporedi osebe */ + $stmt = $conn->prepare("SELECT admin FROM kolesa WHERE `ime`='?'"); + $stmt->bind_param("s", $_REQUEST["k"]); + $stmt->execute(); + $stmt->bind_result($admin_pass); + $stmt->fetch(); + if ($_REQUEST['g'] !== $admin_pass) { + http_response_code(400); + exit ('{"napaka":true,"obvestilo":"Ne bom zaklenil tega kolesa, ker + niste administrator."}'); + } + $stmt->close(); + $stmt = $conn->prepare("UPDATE kolesa SET `omogoceno`=1 WHERE `ime` = '?'"); + $stmt->bind_param("s", $_REQUEST["k"]); + $stmt->execute(); + $stmt->close(); + $stmt2 = $conn->prepare("SELECT ime FROM ljudje WHERE `kolo`=?"); + $stmt2->bind_param("s", $_REQUEST["k"]); + $stmt2->execute(); + $result = $stmt->get_result(); + $ljudje = $result->fetch_all(MYSQLI_ASSOC); + $ljudje2 = $ljudje; + shuffle($ljudje); + for ($i = 0; $i < sizeof($ljudje);) { + if ($ljudje[$i] == $ljudje2[$i]) { + shuffle($ljudje); + $i = 0; + continue; + } + $i++; + } + $stmt3 = $conn->prepare("UPDATE ljudje SET `izbranec`=? WHERE `ime`=?"); + for ($i = 0; $i < sizeof($ljudje); $i++) { + $stmt3->bind_param("ss", $ljudje[$i], $ljudje2[$i]); + $stmt3->execute(); + } + $stmt3->close(); + $stmt2->close(); + http_response_code(200); + exit ('{"napaka":false,"obvestilo":"uspešno zaklenil kolo."}'); + break; + case "u": /* srčni utrip */ + $r = array(); + $stmt2 = $conn->prepare("SELECT ime FROM ljudje WHERE `kolo`=?"); + $stmt2->bind_param("s", $_REQUEST["k"]); + $stmt2->execute(); + $result = $stmt->get_result(); + $ljudje = $result->fetch_all(MYSQLI_ASSOC); + $r["moznosti_na_kolesu"] = $ljudje; + $stmt = $conn->prepare("SELECT admin FROM kolesa WHERE `ime`=?"); + $stmt->bind_param("s", $_REQUEST["k"]); + $stmt->execute(); + $stmt->bind_result($admin_pass); + $stmt->fetch(); + if ($admin_pass === $_REQUEST["g"]) { + $r["si_administrator"] = true; + } else { + $r["si_administrator"] = false; + $r["si_administrator"] = false; + } + $stmt3 = $conn->prepare("SELECT omogoceno FROM `kolesa` WHERE `ime` = ?"); + $stmt3->bind_param("s", $_REQUEST["k"]); + $stmt3->execute(); + $stmt3->bind_result($omogoceno); + $stmt3->fetch(); + if ($omogoceno !== 1) { + $r["dovoli_vrtenje"] = false; + } else { + $r["dovoli_vrtenje"] = true; + } + $r["napaka"] = false; + $stmt2->close(); + $stmt->close(); + $stmt3->close(); + http_response_code(200); + exit (json_encode($r)); + break; + case "v": /* vrti */ + $stmt3 = $conn->prepare("SELECT omogoceno FROM `kolesa` WHERE `ime` = ?"); + $stmt3->bind_param("s", $_REQUEST["k"]); + $stmt3->execute(); + $stmt3->bind_result($omogoceno); + $stmt3->fetch(); + if ($omogoceno !== 1 /* a je vrtenje nedovoljeno */) { + http_response_code(400); + exit ('{"napaka":true,"obvestilo":"Ne morem vrteti, ker vrtenja še ni odobril administrator"}'); + } + if (empty($_REQUEST["i"])) { + http_response_code(400); + exit ('{"napaka":true,"obvestilo":"Ne morem vrteti, ker nimam vašega imena."}'); + } + $stmt2 = $conn->prepare("SELECT izbranec FROM `ljudje` WHERE `ime` = ?"); + $stmt2->bind_param("s", $_REQUEST["i"]); + $stmt2->execute(); + $stmt2->bind_result($izbranec); + $stmt2->fetch(); + $r["izbranec"] = $izbranec; + $r["napaka"] = false; + $stmt3->close(); + $stmt2->close(); + http_response_code(200); + exit(json_encode($r)); + break; + default: + http_response_code(400); + exit ('{"napaka":true,"obvestilo":"Ne vem, kaj hočeš,. ker je bila zahtevana napačna metoda, parameter m."}'); + break; + } + +?> |