Zdravím,
Potřebuju přepsat ( Opravit ) 2 scripty a za pomoc dám Battlefield 3 ( protože mi padá ).
Co to má Dělat ?
Koupit to co je zadané a odebrat kredity, pridat zaznam do tabulky a zaznam o nakupu do druhe tabulky
Co to Dělá ?
Kupuje to vždy jen poslední Záznam
Objednat.php
<?php
mysql_query("SET NAMES 'UTF8'");
$nakupovani = mysql_query("SELECT * FROM `balicky`");
while ($nakup = mysql_fetch_assoc($nakupovani))
{
echo "
<table class='tablesorter'> <div class='divider'></div> <h2>{$nakup['nazev']}</h2>
<form action='koupit.php' method='post'>
<tr><td>Obsah: </td><td>{$nakup['obsah']}</td></tr>
<tr><td><font color='red'>Cena: </td><td>{$nakup['cena']} kreditů</td></tr>
<tr><td><font color='red'>Koupit Pro: </td><td>";
//Select Postavy z Acc
mysql_select_db($dbname_characters) or DIE('Database name is not available!');
$vyber_postav = mysql_query("SELECT * FROM `characters` WHERE account = '{$_SESSION['id']}'");
echo " <select name='postava'>";
while ($postavy = mysql_fetch_assoc($vyber_postav))
{
echo "
<option value='{$postavy['guid']}'>{$postavy['name']}</option>
</select></td>";
}
echo " </tr>
<tr><td></td><td>
<input type='hidden' name='p' value='objednat' />
<input type='hidden' name='polozka' value='{$nakup['nazev']}' />
<input type='hidden' name='cena' value='{$nakup['cena']}' />
<input type='hidden' name='pack' value='{$nakup['id']}' />
<input type='submit' value='Objednat!' /></td></tr>";
mysql_select_db($dbname_realmd) or DIE('Database name is not available!');
}
echo " </table>
</form>
</p>
</div>
</body>
</html>";
?>
Koupit.php
<?php
mysql_query("SET NAMES 'UTF8'");
$vyber_kreditu = mysql_query("SELECT * FROM account WHERE username = '{$_SESSION['username']}'");
while ($uprava_kreditu = mysql_fetch_assoc($vyber_kreditu)){
if($uprava_kreditu['kredit'] >= $_POST['cena']){
//Vypocet kreditů
$odecteni_ceny = $uprava_kreditu['kredit'] - $_POST['cena'];
mysql_query("UPDATE account SET kredit = '{$odecteni_ceny}' WHERE id = '{$_SESSION['id']}'") or die("MySQL ERROR: ".mysql_error());
mysql_query("INSERT INTO balicky_nakup (acc, postava, balicek, cena, stav) VALUES ('{$_SESSION['id']}', '{$_POST['postava']}', '{$_POST['pack']}', '{$_POST['cena']}', '0')") or die("MySQL ERROR: ".mysql_error());
mysql_query("INSERT INTO vypis (acc, polozka, kredit, typ) VALUES ('{$_SESSION['id']}', 'Nakup Itemu <b>{$_POST['polozka']}</b>', '{$_POST['cena']}', 'Nakup')") or die("MySQL ERROR: ".mysql_error());
echo "Zakoupil jsi <b><font color='green'> {$_POST['polozka']} </b></font>Pro Postavu <font color='green'></b> {$_POST['postava']} </b></font> Za <font color='red'></b> {$_POST['cena']} </b></font><br> Tvůj Zůstatek Kreditů je $odecteni_ceny.";
}else{
echo "<center><font color='red'><b>Nedostatek Kreditu</font></b></center>";
}
}
echo " </table>
</form>
</p>
</div>
</body>
</html>";
?>