<?php
require_once '../config.php';
bsession_life(SESSION_PATH);
require_once '../db.php';
require_once '../class/BLogin.php';
require_once '../class/BCrud.php';
$OBLogin = new BLogin($bfurn_db);
$OBLogin->login_protect();
$OBCrud = new BCrud($bfurn_db);
switch ($_REQUEST["section"]) {
case "db_privilege":
switch ($_REQUEST["crud"]) {
case "read":
$qry_sel = "SELECT * FROM `privilege`";
echo json_encode($OBCrud->read($qry_sel));
break;
}
break;
case "user":
switch ($_REQUEST["crud"]) {
case "create":
$username = $bfurn_db->quote(strtolower($_REQUEST["username"]));
$password = $bfurn_db->quote(get_enc_password($_REQUEST["password"], ENC_PASSWORD));
$iduser_group = $_REQUEST["iduser_group"];
$fullname = $bfurn_db->quote($_REQUEST["fullname"]);
$email = $bfurn_db->quote(!empty($_REQUEST["email"]) ? $_REQUEST["email"] : strtolower($_REQUEST["username"]) . '@' . $_SERVER["HTTP_HOST"]);
$qry_ins = "INSERT INTO `user`(`username`,`password`,iduser_group,email,fullname)\n\t\t\tVALUES({$username},{$password},{$iduser_group},{$email},{$fullname})";
echo json_encode($OBCrud->create($qry_ins));
break;
case "read":
<?php
require_once '../config.php';
bsession_life(SESSION_PATH);
require_once '../db.php';
require_once '../class/BLogin.php';
require_once '../class/BCrud.php';
$OBLogin = new BLogin($bfurn_db);
$OBLogin->login_protect();
$OBCrud = new BCrud($bfurn_db);
switch ($_REQUEST["crud"]) {
case "read":
echo json_encode($OBCrud->read("SELECT * FROM config", "SELECT COUNT(`key`) FROM config"));
break;
case "update":
$json_request = file_get_contents('php://input');
$json = json_decode($json_request);
echo json_encode($OBCrud->update("UPDATE `config` SET `value`='{$json->value}' WHERE `key`='{$json->key}' LIMIT 1"));
break;
}
