I realize I may not be the best but here is the code
[code]
Train
<?php
if(isset($_POST['archers'])) {
$amount = $_POST['amount'];
$att = $amount * 3;
$def = $amount * 8;
$food = $amount * 20;
$copper = $amount * 20;
$silver = $amount * 20;
if($kvar['$food'] >= $food && $kvar['copper'] >= $copper && $kvar['silver'] >= $silver){
mysqli_query($conn, "UPDATE kingdom SET food = food - '$food' WHERE kname='$kingdom'");
mysqli_query($conn, "UPDATE kingdom SET copper = copper - '$copper' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE kingdom SET silver = silver - '$silver' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET archers = archers + '$amount' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET attack = attack + '$att' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET defense = defense + '$def' WHERE kname='$kingdom");
}elseif ($kvar['$food'] < $food && $kvar['copper'] < $copper && $kvar['silver'] < $silver){
echo "Sorry, you do not have enough resources to train your troops";
}
}
if(isset($_POST['pawns'])) {
$amount = $_POST['amount'];
$att = $amount * 1;
$def = $amount * 1;
$food = $amount * 15;
$copper = $amount * 15;
$silver = $amount * 15;
if ($kvar['$food'] >= $food && $kvar['copper'] >= $copper && $kvar['silver'] >= $silver) {
mysqli_query($conn, "UPDATE kingdom SET food = food - '$food' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE kingdom SET copper = copper - '$copper' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE kingdom SET silver = silver - '$silver' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET pawns = pawns + '$amount' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET attack = attack + '$att' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET defense = defense + '$def' WHERE kname='$kingdom");
} elseif ($kvar['$food'] < $food && $kvar['copper'] < $copper && $kvar['silver'] < $silver) {
echo "Sorry, you do not have enough resources to train your troops";
}
}
if (isset($_POST['knights'])) {
$amount = $_POST['amount'];
$att = $amount * 15;
$def = $amount * 15;
$food = $amount * 50;
$copper = $amount * 50;
$silver = $amount * 50;
if ($kvar['$food'] >= $food && $kvar['copper'] >= $copper && $kvar['silver'] >= $silver) {
mysqli_query($conn, "UPDATE kingdom SET food = food - '$food' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE kingdom SET copper = copper - '$copper' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE kingdom SET silver = silver - '$silver' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET knights = knights + '$amount' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET attack = attack + '$att' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET defense = defense + '$def' WHERE kname='$kingdom");
} elseif ($kvar['$food'] < $food && $kvar['copper'] < $copper && $kvar['silver'] < $silver) {
echo "Sorry, you do not have enough resources to train your troops";
}
}
if (isset($_POST['foots'])) {
$amount = $_POST['amount'];
$att = $amount * 5;
$def = $amount * 5;
$food = $amount * 17;
$copper = $amount * 17;
$silver = $amount * 17;
if ($kvar['$food'] >= $food && $kvar['copper'] >= $copper && $kvar['silver'] >= $silver) {
mysqli_query($conn, "UPDATE kingdom SET food = food - '$food' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE kingdom SET copper = copper - '$copper' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE kingdom SET silver = silver - '$silver' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET foots = foots + '$amount' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET attack = attack + '$att' WHERE kname='$kingdom");
mysqli_query($conn, "UPDATE army SET defense = defense + '$def' WHERE kname='$kingdom");
} elseif ($kvar['$food'] < $food && $kvar['copper'] < $copper && $kvar['silver'] < $silver) {
echo "Sorry, you do not have enough resources to train your troops";
}
}
[/code]
I really do not see an issue here, but there is one. So there's that and yeah yeah i need to use prepared statements , but I probably never actually use them
