function maintain_angry()
{
$pdo = PDO2::getInstance();
$query = $pdo->prepare("UPDATE tbl_rabbit_skill SET skill_angry = skill_angry - :maintain_value");
$query->bindValue(":maintain_value", 10);
return $pdo->execute();
}
function ajouter_user_dans_bd($firstname, $lastname, $username, $password, $repassword, $email)
{
$bdd = PDO2::getInstance();
$bothSame = $bdd->prepare("SELECT nom_utilisateur FROM membres WHERE nom_utilisateur = ':user'");
$bothSame->bindParam(':user', $username);
$bothSame->execute();
if ($bothSame->rowCount() > 0) {
echo 'Désolé l\'utilisateur que vous essayer de prendre est déjàutilisé dans la base de données' . 'Veuillez en choisir un autre.';
} else {
$req = $bdd->prepare('INSERT INTO membres(prenom, nom_famille, nom_utilisateur, mot_de_passe, adresse_email, date_inscription) VALUES(:firstname,:lastname,:utilisateur, :password, :email, NOW()');
$req->bindValue(':firstname', $firstname);
$req->bindValue(':lastname', $lastname);
$req->bindValue(':utilisateur', $username);
$req->bindValue(':password', $password);
$req->bindValue(':email', $email);
//$req->bindValue(':date', date('Y-m-d H:i:s'));
if ($req->execute()) {
return $pdo->lastInsertId();
}
$select = $bdd->query('SELECT * FROM membres');
while ($donnees = $select->fetch()) {
$_SESSION['utilisateur'] = $donnees['nom_utilisateur'];
}
$select->closeCursor();
}
}
function lire_infos_utilisateur($id_utilisateur)
{
$pdo = PDO2::getInstance();
$requete = $pdo->prepare("SELECT nom_utilisateur, mot_de_passe, adresse_email, date_inscription, hash_validation\n FROM membres\n WHERE\n id = :id_utilisateur");
$requete->bindValue(':id_utilisateur', $id_utilisateur);
return $requete->execute() ? $requete->fetch(PDO::FETCH_ASSOC) : false;
}
public function retrouver_mess_forum($forum)
{
$connexion = PDO2::getInstance();
$requete_select_forum = $requete_tous_message = "SELECT * FROM message WHERE forum_ForumID = {$id_forum}";
$db = $connexion->query($requete_tous_titres);
$resultat = $db->fetchAll(PDO::FETCH_ASSOC);
return $resultat;
}
function ajouter_membre_dans_bdd($nom_utilisateur, $mdp, $adresse_email, $hash_validation)
{
$pdo = PDO2::getInstance();
$requete = $pdo->prepare("INSERT INTO membres SET\n nom_utilisateur = :nom_utilisateur,\n mot_de_passe = :mot_de_passe,\n adresse_email = :adresse_email,\n hash_validation = :hash_validation,\n date_inscription = NOW()");
$requete->bindValue(':nom_utilisateur', $nom_utilisateur);
$requete->bindValue(':mot_de_passe', $mdp);
$requete->bindValue(':adresse_email', $adresse_email);
$requete->bindValue(':hash_validation', $hash_validation);
return $requete->execute() ? $pdo->lastInsertId() : $requete->errorInfo();
}
public static function getInstance()
{
if (!isset(self::$_instance)) {
try {
self::$_instance = new PDO(SQL_DSN, SQL_USERNAME, SQL_PASSWORD);
} catch (PDOException $e) {
echo $e;
}
}
return self::$_instance;
}
public static function getInstance()
{
if (!isset(self::$_instance)) {
try {
self::$_instance = new PDO(SQL_DSN, SQL_USERNAME, SQL_PASSWORD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
} catch (PDOException $e) {
echo $e;
}
}
return self::$_instance;
}
function user_has_nabz($usr_nabz)
{
$pdo = PDO2::getInstance();
$query = $pdo->prepare("SELECT rabbit_id FROM tbl_rabbit WHERE rabbit_usr_id = :user_id");
$query->bindValue(":user_id", $usr_nabz);
$query->execute();
if ($result = $query->fetch(PDO::FETCH_ASSOC)) {
$query->closeCursor();
return $result['rabbit_id'];
}
return false;
}
public static function getInstance()
{
if (!isset(self::$_instance)) {
try {
self::$_instance = new PDO(SQL_DSN, SQL_USERNAME, SQL_PASSWORD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
} catch (Exception $e) {
echo 'Problem connecting to the database.';
exit;
}
}
return self::$_instance;
}
/**
* Permet d'acquérir l'objet PDO.
* S'il n'existe pas il sera créé.
*
* @return PDO2, le seul objet de la présente classe.
*/
public static function getInstance()
{
if (!isset(self::$_instance)) {
try {
// constants disponible dans le fichier ./global/config.php
self::$_instance = new PDO(SQL_DSN, SQL_USERNAME, SQL_PASSWORD);
} catch (PDOException $e) {
// TODO attention il ne faudrait pas afficher d'info ici
echo $e;
}
}
return self::$_instance;
}
function get_serial_and_token($id_nabz)
{
$pdo = PDO2::getInstance();
$query = $pdo->prepare("SELECT rabbit_serial, rabbit_token FROM tbl_rabbit WHERE rabbit_id = :id_nabz", array(PDO::ATTR_CURSOR, PDO::CURSOR_SCROLL));
$query->bindValue(":id_nabz", $id_nabz);
$query->execute();
$tbx = array();
while ($row = $query->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) {
$tbx['rabbit_serial'] = $row[0];
$tbx['rabbit_token'] = $row[1];
}
//$tbx is an array with all the informations of a product
return $tbx;
}
public static function getInstance()
{
if (!isset(self::$_instance)) {
try {
self::$_instance = new PDO('mysql:host=localhost;dbname=a-bime', 'root', 'root');
//self::$_instance = new PDO('mysql:host=5.39.82.228;dbname=bde', 'alex', 'lameretrappe');
self::$_instance->exec('SET NAMES utf8');
self::$_instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo $e;
}
}
return self::$_instance;
}
function add_member_in_db($username, $password, $email_addr, $hash_validation)
{
$pdo = PDO2::getInstance();
$query = $pdo->prepare("INSERT INTO tbl_user SET user_pseudo = :username, user_pass = :password, user_mail = :email_addr, hash_validation = :hash_validation, user_balance = :CASH_START, user_lastconnect = NOW()");
$query->bindValue(":username", $username);
$query->bindValue(":password", $password);
$query->bindValue(":email_addr", $email_addr);
$query->bindValue(":hash_validation", $hash_validation);
$query->bindValue(":CASH_START", CASH_START);
if ($query->execute()) {
return $pdo->lastInsertId();
}
print_r($query->errorInfo());
return $query->errorInfo();
}
function buy_ticket($id_user, $number, $ticket_price)
{
$pdo = PDO2::getInstance();
//Change usr_id column in number row in the table tbl_numbers
$query = $pdo->prepare("UPDATE tbl_numbers SET usr_id = :usr_id WHERE id = :number");
$query->bindValue(":usr_id", $id_user);
$query->bindValue(":number", $number);
$query->execute();
print_r($query->errorInfo());
//Update the balance of the account
$query = $pdo->prepare("UPDATE tbl_user SET user_balance = :new_balance WHERE user_id = :id_user");
$query->bindValue(":new_balance", user_balance($id_user) - $ticket_price);
$query->bindValue(":id_user", $id_user);
$query->execute();
print_r($query->errorInfo());
update_jackpot();
}
public function get_tous_mess_dans_forum($id_forum)
{
$bdd = PDO2::getInstance();
if ($id_forum == 1) {
$req = $bdd->query('SELECT * FROM message WHERE forum_ForumID=1');
$forum = $req->fetchAll();
} else {
if ($id_forum == 2) {
$req = $bdd->query('SELECT * FROM message WHERE forum_ForumID=2');
$forum = $req->fetchAll();
} else {
if ($id_forum == 3) {
$req = $bdd->query('SELECT * FROM message WHERE forum_ForumID=3');
$forum = $req->fetchAll();
}
}
}
return $forum;
}
protected function UpdateQuery($table, $data)
{
$pdo = PDO2::getInstance();
$params = [];
$fields = [];
$id = [];
foreach ($data as $key => $val) {
$params[':' . $key . ''] = $val;
array_push($fields, $key . '=:' . $key);
if ($key[0]) {
array_push($id, $key . '=:' . $key);
}
}
$id = array_slice($fields, 0, 1);
$fields = array_slice($fields, 1);
$sql = "UPDATE " . $table . " SET " . implode(', ', $fields) . " WHERE " . implode('', $id) . "";
$stmt = $pdo->prepare($sql);
$stmt = $stmt->execute($params);
return $stmt;
}
function widget($args, $instance)
{
extract($args);
/** This filter is documented in wp-includes/default-widgets.php */
$title = apply_filters('widget_title', empty($instance['title']) ? '' : $instance['title'], $instance, $this->id_base);
/* $text = apply_filters( 'widget_text', empty( $instance['text'] ) ? '' : $instance['text'], $instance );
echo $before_widget;
if ( !empty( $title ) ) { echo $before_title . $title . $after_title; } */
?>
<!--
<div class="textwidget"><?php
/*echo !empty( $instance['filter'] ) ? wpautop( $text ) : $text; */
?>
</div>
--><?php
/* echo $after_widget;*/
include WP_PLUGIN_URL . '/manage-maps/PDO.php';
?>
<style>
html, body {
height: 100%;
margin: 0px;
padding: 0px
}
#map-canvas {
height: 254px !important;
width: 352px !important;
}
#panel {
position: absolute;
top: 5px;
left: 50%;
margin-left: -180px;
z-index: 5;
background-color: #fff;
padding: 5px;
border: 1px solid #999;
}
</style>
<?php
echo $title;
?>
<script src="https://maps.googleapis.com/maps/api/js?v=3.exp"></script>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.0/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.11.0/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css">
<script>
var directionsDisplay;
var directionsService = new google.maps.DirectionsService();
var map;
function initialize() {
directionsDisplay = new google.maps.DirectionsRenderer();
var chicago = new google.maps.LatLng(-23.6824124, -46.5952992);
var mapOptions = {
zoom: 6,
center: chicago
}
map = new google.maps.Map(document.getElementById('map-canvas'), mapOptions);
<?php
$pdo = new PDO2();
$conn = $pdo->conn();
$object = $pdo->showlist($conn);
while ($data = mysql_fetch_array($object)) {
?>
jQuery.get( "http://maps.googleapis.com/maps/api/geocode/json", {
address: "<?php
echo utf8_decode($data['endereco']);
?>
, <?php
echo $data['numero'];
?>
- <?php
echo utf8_decode($data['bairro']);
?>
- <?php
echo utf8_decode($data['estado']);
?>
"
}, function(data){
console.log(data);
var marker = new google.maps.Marker({
position: data.results[0].geometry.location,
map: map,
title: data.results[0].formatted_address
});
google.maps.event.addListener(marker, 'click', function () {
jQuery("#end").val(data.results[0].formatted_address);
});
});
<?php
}
?>
directionsDisplay.setMap(map);
}
function calcRoute() {
var start = document.getElementById('start').value;
var end = document.getElementById('end').value;
var waypts = [];
var checkboxArray = document.getElementById('waypoints');
for (var i = 0; i < checkboxArray.length; i++) {
if (checkboxArray.options[i].selected == true) {
waypts.push({
location:checkboxArray[i].value,
stopover:true});
}
}
var request = {
origin: start,
destination: end,
waypoints: waypts,
optimizeWaypoints: true,
travelMode: google.maps.TravelMode.DRIVING
};
directionsService.route(request, function(response, status) {
if (status == google.maps.DirectionsStatus.OK) {
directionsDisplay.setDirections(response);
var route = response.routes[0];
var summaryPanel = document.getElementById('directions_panel');
summaryPanel.innerHTML = '';
// For each route, display summary information.
jQuery('#end').css('color','#000')
for (var i = 0; i < route.legs.length; i++) {
var routeSegment = i + 1;
summaryPanel.innerHTML += '<b>Route Segment: ' + routeSegment + '</b><br>';
summaryPanel.innerHTML += route.legs[i].start_address + ' to ';
summaryPanel.innerHTML += route.legs[i].end_address + '<br>';
for(var x=0; x < route.legs[i].steps.length; x++)
{
summaryPanel.innerHTML += route.legs[i].steps[x].instructions +' '+ route.legs[i].steps[x].distance.text + '<br />'
}
summaryPanel.innerHTML += route.legs[i].distance.text + '<br><br>';
}
} else { jQuery('#end').css('color','red')}
});
}
google.maps.event.addDomListener(window, 'load', initialize);
</script>
</head>
<body>
<div id="map-canvas"></div>
<div id="control_panel" style="float:right;width:30%;text-align:left;padding-top:20px">
<div style="margin-left: -215px;border-width:2px;">
<b>Filial:</b>
<select id="start" style="width: 100%;">
<option value="">Selecione...</option>
<?php
$pdo = new PDO2();
$conn = $pdo->conn();
$object = $pdo->showlist($conn);
while ($data = mysql_fetch_array($object)) {
echo '<option value="' . utf8_decode($data['endereco']) . ', ' . utf8_decode($data['numero']) . ' - ' . utf8_decode($data['bairro']) . ' - ' . utf8_decode($data['cidade']) . '
">' . utf8_decode($data['endereco']) . ', ' . utf8_decode($data['numero']) . ' - ' . utf8_decode($data['bairro']) . ' - ' . utf8_decode($data['cidade']) . '</option>';
}
?>
</select>
<br>
<!-- <b>Waypoints:</b> <br>-->
<!-- <i>(Ctrl-Click for multiple selection)</i> <br>-->
<select multiple id="waypoints" style="display: none; width: 100%;">
<option value="montreal, quebec">Montreal, QBC</option>
<option value="toronto, ont">Toronto, ONT</option>
<option value="chicago, il">Chicago</option>
<option value="winnipeg, mb">Winnipeg</option>
<option value="fargo, nd">Fargo</option>
<option value="calgary, ab">Calgary</option>
<option value="spokane, wa">Spokane</option>
</select>
<br>
<b>End:</b>
<!-- <select id="end">
<option value="R. Lucimar Fernandes Dantas - Jardim Santa Rosa, Ferraz de Vasconcelos - SP, República Federativa do Brasil">Rua Lucimar Fernandes Dantas</option>
<option value="Seattle, WA">Seattle, WA</option>
<option value="San Francisco, CA">San Francisco, CA</option>
<option value="Los Angeles, CA">Los Angeles, CA</option>
</select> -->
<input type="text" name="end" id="end" value="" style="width: 100%; margin-bottom: 3px;"/>
<br>
<input type="submit" onclick="calcRoute();">
</div>
<div id="directions_panel" style="margin-left:-215px;background-color:#FFEE77;"></div>
</div>
</body>
<script type="text/javascript">
jQuery(function() {
function carregarNoMapa(endereco) {
jQuery.get( "http://maps.googleapis.com/maps/api/geocode/json", {
address: endereco }, function(data){
console.log(data);
}
);
}
$("#end").blur(function() {
if($(this).val() != "")
carregarNoMapa($(this).val());
});
// var availableTags = [
// "ActionScript",
// "AppleScript",
// "Asp",
// "BASIC",
// "C",
// "C++",
// "Clojure",
// "COBOL",
// "ColdFusion",
// "Erlang",
// "Fortran",
// "Groovy",
// "Haskell",
// "Java",
// "JavaScript",
// "Lisp",
// "Perl",
// "PHP",
// "Python",
// "Ruby",
// "Scala",
// "Scheme"
// ];
// jQuery( "#end" ).autocomplete({
// source: availableTags
// });
});
</script>
<?php
}
function up_lastconnect($id_user)
{
$pdo = PDO2::getInstance();
$query = $pdo->prepare("UPDATE tbl_user SET user_lastconnect = NOW() WHERE user_id = :id_user");
$query->bindValue(":id_user", $id_user);
return $query->execute();
}
function delete_product_incart($id_product)
{
$pdo = PDO2::getInstance();
$quantity = display_quantity($id_product, $_SESSION['id']);
$query = $pdo->prepare("DELETE FROM tbl_cart WHERE product_id = :id_product");
$query->bindValue(':id_product', $id_product);
$query->execute();
return $query->rowCount() == 1;
}
public function getEntityPosition(array $filterClauses = array(), array $orderClauses = array())
{
$pdo = PDO2::getInstance();
$requete = $pdo->prepare("\n\t\t\t\tSET @rownum=0\n\t\t\t\t");
$requete->execute();
$where = "";
if (count($filterClauses) > 0) {
foreach ($filterClauses as $key => $value) {
$where[] = $value[0] . "= :" . $value[0];
}
$where = implode(" AND ", $where);
$where = " WHERE " . $where;
}
$order = "";
if (count($orderClauses) > 0) {
foreach ($orderClauses as $key => $value) {
$order[] = $value[0] . " " . $value[1];
}
$order = implode(", ", $order);
$order = " ORDER BY " . $order;
}
$requete = $pdo->prepare("\n\t\t\t\tSELECT num\n\t\t\t\tFROM(\n\t\t\t\tSELECT @rownum:=@rownum+1 as num, id\n\t\t\t\tFROM " . static::getTable() . "\n\t\t\t\t" . $where . "\n\t\t\t\t" . $order . "\n\t\t) e\n\t\t\t\tWHERE id=:id\n\t\t");
$requete->bindValue(':id', $this->getId(), PDO::PARAM_STR);
if (count($filterClauses) > 0) {
foreach ($filterClauses as $key => $value) {
$requete->bindValue(":" . $value[0], $value[1]);
}
}
$requete->execute();
if ($position = $requete->fetch()) {
return $position['num'];
} else {
return false;
//print_r($requete->errorInfo());
}
}
public static function deleteSkillForProject($skill_id, $project_id)
{
$pdo = PDO2::getInstance();
$requete = $pdo->prepare("\n\t\t\t\tDELETE FROM asso_projects_skills\n\t\t\t\tWHERE id_project=:id_project\n\t\t\t\tAND id_skill= :id_skill\n\t\t\t\t");
$requete->bindValue(':id_project', $project_id);
$requete->bindValue(':id_skill', $skill_id);
if ($requete->execute()) {
return true;
} else {
return false;
//print_r($requete->errorInfo());
}
}
function uniq_prdct_in_cart($prdct_id, $usr_id)
{
$pdo = PDO2::getInstance();
$query = $pdo->prepare("SELECT cart_id FROM tbl_cart WHERE user_id = :id_user AND product_id = :id_product");
$query->bindValue(":id_user", $usr_id);
$query->bindValue(":id_product", $prdct_id);
$query->execute();
if ($result = $query->fetch(PDO::FETCH_ASSOC)) {
$query->closeCursor();
return $result['cart_id'];
}
return false;
}
function main_manage_maps()
{
$pdo = new PDO2();
$conn = $pdo->conn();
if (isset($_POST['endereco']) && isset($_POST['action']) == 'add') {
$get = $_POST;
$message = $pdo->insert($conn, $get);
if ($message != '') {
echo $message = "<h1>Inserido com sucesso</h1>";
} else {
echo $message;
}
} else {
if ($_GET['action'] == 'delete') {
$pdo->delete($_GET['id'], $conn);
echo "<h1>Deletado com sucesso</h1>";
}
}
echo "\n <h1>Cadastro de Endereços</h1>\n <form action='admin.php?page=manage-maps' method='post'>\n <div class='admin_manage_maps'>\n <table>\n <tr>\n <th>Cep</th>\n <th>Endereço</th>\n <th>Numero</th>\n </tr>\n <tr>\n <td><input type='text' value='' name='cep'/></td>\n <td><input type='text' value='' name='endereco'/></td>\n <td><input type='text' value='' name='numero' /></td>\n </tr>\n <tr>\n <th>Bairro</th>\n <th>Cidade</th>\n <th>Estado</th>\n </tr>\n <tr>\n <td><input type='text' value='' name='bairro' /></td>\n <td><input type='text' value='' name='cidade' /></td>\n <td><input type='text' value='' name='estado'/></td>\n </tr>\n <tr>\n <td><input type='submit' value='Cadastrar'/></td>\n <input type='hidden' name='action' value='add' />\n <input type='hidden' name='page' value='manage-maps' />\n </tr>\n </table>\n </div>\n </form>\n ";
//show list data in base
$object = $pdo->showlist($conn);
?>
<table width='100%'>
<tr>
<th>Cep</th>
<th>Endereço</th>
<th>Número</th>
<th>Bairro</th>
<th>Cidade</th>
<th>Estado</th>
<th>Deletar</th>
</tr>
<?php
while ($data = mysql_fetch_array($object)) {
?>
<tr>
<td class="row-title"><?php
echo utf8_decode($data['cep']);
?>
</td>
<td class="row-title"><?php
echo utf8_decode($data['endereco']);
?>
</td>
<td class="row-title"><?php
echo utf8_decode($data['numero']);
?>
</td>
<td class="row-title"><?php
echo utf8_decode($data['bairro']);
?>
</td>
<td class="row-title"><?php
echo utf8_decode($data['cidade']);
?>
</td>
<td class="row-title"><?php
echo utf8_decode($data['estado']);
?>
</td>
<td class="row-title"><a href='admin.php?page=manage-maps&action=delete&id=<?php
echo utf8_decode($data['id']);
?>
'>[X]</a></td>
</tr>
<?php
}
//endwhile
echo "</table>";
}
<?php require_once 'pdo2.class.php'; $bdd = PDO2::getInstance(); $query = "INSERT INTO " . PREFIX_TABLE . "_lines VALUES(:nom, :prix, :qte, :tva)";
/**
* Va chercher tous les messages de la table message qui sont du membre
* qui détient l'id idMembre.
* @param $idMembre - l'id du membre
* @return array - un array d'objets messages du membre qui a l'id $idMembre
*/
function getMessagesMembre($idMembre)
{
$pdo = PDO2::getInstance();
$requete = $pdo->prepare("SELECT * FROM message WHERE membres_id = :idMembre ORDER BY forum_ForumID, horoDate DESC");
$requete->bindValue(':idMembre', $idMembre);
$requete->execute();
if ($reponse = $requete->fetchAll(PDO::FETCH_ASSOC)) {
$requete->closeCursor();
}
$arrayMessages = array();
foreach ($reponse as $message) {
$messageObj = new Message($message['messageID'], $message['texte'], $message['horoDate'], NULL, $message['parent_messageID'], $idMembre, $message['forum_ForumID']);
$arrayMessages[] = $messageObj;
}
return $arrayMessages;
}
function init_bingo()
{
$pdo = PDO2::getInstance();
$query = $pdo->prepare("UPDATE tbl_numbers SET usr_id = 0 WHERE usr_id >0");
$query->execute();
//Init jackpot on the txt_file
update_bingo_jackpot(0);
}
