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); }