function add_request($lat = '', $lon = '', $acc = '', $sname = '', $ip, $battery = 0, $charging = 0, $provider = '', $bearing = -1, $speed = -1, $time = '', $deviceid = '', $subscriberid = '')
{
global $mysqli, $verbose;
$sid = get_secret($sname);
$query = "\n INSERT INTO\n requests (latitude, longitude, accuracy, sid, rip, battery, charging, provider, bearing, speed, time, deviceid, subscriberid)\n values ('{$lat}', '{$lon}', '{$acc}', '{$sid}', '{$ip}', '{$battery}', '{$charging}', '{$provider}', '{$bearing}', '{$speed}', '{$time}', '{$deviceid}', '{$subscriberid}')\n ";
if ($verbose) {
print 'get_secret' . $query;
}
$result = mysqli_query($mysqli, $query) or die('Err add_request!');
return true;
}
function __construct($conn_name)
{
try {
$conn = get_secret($conn_name);
$h = $conn["server"];
$t = $conn["db"];
$u = $conn["user"];
$p = $conn["pass"];
$this->dbh = new PDO("mysql:host={$h};dbname={$t}", $u, $p);
} catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
exit;
}
}
function get_secret()
{
global $secrets;
// Если указать слишком большое кол-во карт возможно зацикливание
$chars = str_split('0123456789');
unset($secret);
for ($i = 0; $i < 16; $i++) {
$secret .= $chars[mt_rand(0, count($chars) - 1)];
}
if (in_array($secret, $secrets)) {
return get_secret();
} else {
$secrets[] = $secret;
return $secret;
}
}
function get_cache_secret()
{
return get_secret("cachekey");
}
public function admin_account_post()
{
$datas = $this->input->post();
//$this->response(["datas"=>$datas], 200);
//die();
//if(!isset $datas['email'] or !isset $datas['password'] or !isset $datas['why']){
// $this->response(['title'=>'Erreur', 'message'=>'vous n\'avez pas précisé les informations requises'], 400);
//}
if ($datas['why'] === "") {
$this->response(['title' => 'Erreur', 'message' => 'Vous devez préciser les raisons pour lesquelles vous souhaitez obtenir un compte admin okaoka'], 400);
}
$this->load->helper('email');
if (!valid_email($datas['email'])) {
$this->response(['title' => 'Erreur', 'message' => 'Votre email est invalide, merci de le vérifier'], 400);
}
$this->db->where('email', $datas['email']);
$is_admin = $this->db->get('admin');
if (count($is_admin->result()) >= 1) {
$this->response(['title' => 'Erreur', 'message' => 'Votre email existe déjà, si vous avez perdu votre mot de passe, merci de demander un nouveau mot de passe, sinon connectez-vous.'], 400);
}
$this->load->helper('oauth');
$insert = array("email" => $datas['email'], "password" => sha1($datas['password']), "token" => get_token(), "why" => $datas['why'], "is_valid" => 0, 'created' => date("Y-m-d H:i:s"), 'updated' => date("Y-m-d H:i:s"), "access" => get_access(), "secret" => get_secret());
$this->db->insert('admin', $insert);
$user_id = $this->db->insert_id();
$this->db->where('id', $user_id);
$user = $this->db->get('admin');
//unset($user['password']);
$this->response(array("title" => "Account", "message" => "Votre compte à bien été créé et est en attente de validation par nos administrateurs. Vous recevrez prochainement un email confirmant votre inscription. Merci et à boentôt.", "user_infos" => $user), REST_Controller::HTTP_OK);
}
