display_avatar_name();
display_skill($_SESSION['id_nabz']);
?>
</td>
<td id="td_secondcol"><!-- Second line --!>
<?php
if ($item_cat != NULL) {
echo 'Pour abreuver votre lapin vous disposez de :';
} else {
echo 'Vous ne disposez d\'aucun produit pour abreuver votre lapin :( ';
}
?>
<?php
//display each product as in the rabbit store
foreach ($item_cat as $value) {
$infos_product = infos_product($value);
echo '<table id=\'table_product_profile\'><tbody><tr>';
echo '<td>';
echo '<img src=' . PATH_IMAGE_STORE . $infos_product['product_image'] . '>' . '<br \\>';
echo $infos_product['product_name'] . '<br \\>';
echo $infos_product['product_description'] . '<br \\>';
echo '</td>';
echo '<td>';
//health
echo "<img id=\"img_skill\" src=\"" . PATH_IMAGE_RESSOURCE . "health.png\">";
echo ' ' . '+' . $infos_product['prdct_health_pt'] . '<br \\>';
//angry
echo "<img id=\"img_skill\" src=\"" . PATH_IMAGE_RESSOURCE . "food.png\">";
echo ' ' . '+' . $infos_product['prdct_angry_pt'] . '<br \\>';
//thearth
echo "<img id=\"img_skill\" src=\"" . PATH_IMAGE_RESSOURCE . "drink.png\">";
$index = $infos_product['product_id'][$i];
$form_buy[$index] = new Form('form_buy' . $index);
$form_buy[$index]->method('POST');
$form_buy[$index]->add('Submit', 'submit')->value("Ajouter au panier");
$form_buy[$index]->bound($_POST);
//construct a array with the product_id
array_push($tbx_index, $index);
}
}
//end of for loop in cat
$error_buy = array();
$msg_confirm = array();
foreach ($tbx_index as $value) {
//which product user wants to buy
if ($form_buy[$value]->is_valid($_POST)) {
$infos_product_tobuy = infos_product($value);
//Dont have enough money in the account
if (user_balance($_SESSION['id']) < $infos_product_tobuy['product_price']) {
$error_buy[] = "Solde insuffisant pour acheter cet objet, vous pouvez recharger votre compte dans la partie Banque";
} elseif (uniq_prdct_in_cart($value, $_SESSION['id']) != 0) {
add_product_incart($value, $_SESSION['id']);
$msg_confirm[] = "Achat effectué avec succès, vous disposiez déjà de ce produit dans votre inventaire, votre achat s'est ajouté à votre stock déjà existant";
} else {
buy_product($value, $_SESSION['id']);
$msg_confirm[] = "Achat effectué avec succès, le produit a été ajouté a votre inventaire.";
}
//end of user_balance
}
}
//end of foreach
include PATH_VIEW . 'view_store.php';
function add_product_incart($prdct_id, $usr_id)
{
$pdo = PDO2::getInstance();
//Find initial quantity
$query = $pdo->prepare("SELECT product_quantity 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();
$result = $query->fetch(PDO::FETCH_ASSOC);
$prdct_qty = $result['product_quantity'];
//Soustract a element in the store
$query = $pdo->prepare("UPDATE tbl_products SET product_quantity = IF( (product_quantity -1)<0,0,(product_quantity - 1)) WHERE product_id = :id_product");
$query->bindValue(":id_product", $prdct_id);
$query->execute();
//Add new quantity of product in the cart
$query = $pdo->prepare("UPDATE tbl_cart SET product_quantity = :new_quantity WHERE user_id = :id_user AND product_id = :id_product");
$infos_product_tobuy = infos_product($prdct_id);
$query->bindValue(":id_user", $usr_id);
$query->bindValue(":id_product", $prdct_id);
$query->bindValue(":new_quantity", $infos_product_tobuy['product_portion'] + $prdct_qty);
$query->execute();
//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($usr_id) - $infos_product_tobuy['product_price']);
$query->bindValue(":id_user", $usr_id);
$query->execute();
}
function use_product($id_product, $id_nabz)
{
$pdo = PDO2::getInstance();
$query = $pdo->prepare("UPDATE tbl_rabbit_skill SET skill_angry = IF( (skill_angry + :skill_angry)>100,100,(skill_angry + :skill_angry)) ,skill_thirst = IF( (skill_thirst + :skill_thirst)>100,100,(skill_thirst + :skill_thirst)),skill_health = IF( (skill_health + :skill_health)>100,100,(skill_health + :skill_health)) WHERE rabbit_id = :id_nabz");
$infos_product = infos_product($id_product);
$pt_angry = $infos_product['prdct_angry_pt'];
$pt_thirst = $infos_product['prdct_thirst_pt'];
$pt_health = $infos_product['prdct_health_pt'];
$query->bindValue(':skill_angry', $pt_angry);
$query->bindValue(':skill_thirst', $pt_thirst);
$query->bindValue(':skill_health', $pt_health);
$query->bindValue(':id_nabz', $id_nabz);
$query->execute();
return $query->rowCount() == 1;
}
