Ъпдейт

freboy · 28 Февруари 2010

Защо не ъпдейтва?
Вместо да ги ъпдейтва то ги заменя :twisted:

Код:

<?php
if($_SESSION['name']) {
$name = $_SESSION['name'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$att = '100'; $cost = '15000';}
if($id == 2){$att = '1000'; $cost = '100000';}
if($id == 3){$att = '2500'; $cost = '200000';}
if($id == 4){$att = '5000'; $cost = '400000';}
if($id == 5){$att = '10000'; $cost = '750000';}
if($id == 6){$att = '25000'; $cost = '1750000';}
if($id == 7){$att = '50000'; $cost = '3000000';}
if($id == 8){$att = '75000'; $cost = '5000000';}
$sql = "SELECT * FROM users WHERE name = '$name'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['money'] < $cost) { echo 'Нямаш достатъчно пари'; } else {
$money = ($my['money'] - $cost);
$sql = "UPDATE users SET money = '$money', weaponr = '$att' WHERE name = '$name'";
if(mysql_query($sql)) { echo 'Покупката е успешна'; }}} else { ?>
<br> <center> <b>
<a href="?a=belo&id=1">Куфар - 100 <img src="images/stats/2.png" border="0" /> - 15000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=2">Часовник - 1000 <img src="images/stats/2.png" border="0" /> - 100000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=3">Слънчеви очила - 2500 <img src="images/stats/2.png" border="0" /> - 200000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=4">Мобилен телефон - 5000 <img src="images/stats/2.png" border="0" /> - 400000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=5">Хендсфри - 10000 <img src="images/stats/2.png" border="0" /> - 750000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=6">Ролекс - 25000 <img src="images/stats/2.png" border="0" /> - 1750000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=7">Кредитна карта - 50000 <img src="images/stats/2.png" border="0" /> - 3000000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=8">Лаптоп - 75000 <img src="images/stats/2.png" border="0" /> - 5000000 <img src="images/stats/1.png" border="0" /> </a><br /> </b> </center>
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?>

Nihtewalk · 28 Февруари 2010

Ъпдейта не е ли равно на: замяна на старата стойност с нова

slideR · 28 Февруари 2010

<?php
if($_SESSION['name']) {
$name = $_SESSION['name'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$att = '100'; $cost = '15000';}
if($id == 2){$att = '1000'; $cost = '100000';}
if($id == 3){$att = '2500'; $cost = '200000';}
if($id == 4){$att = '5000'; $cost = '400000';}
if($id == 5){$att = '10000'; $cost = '750000';}
if($id == 6){$att = '25000'; $cost = '1750000';}
if($id == 7){$att = '50000'; $cost = '3000000';}
if($id == 8){$att = '75000'; $cost = '5000000';}
$sql = "SELECT * FROM users WHERE name = '$name'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['money'] < $cost) { echo 'Нямаш достатъчно пари'; } else {
$money = ($my['money'] - $cost);
$sql = "UPDATE users SET money = '$money' AND weaponr = '$att' WHERE name = '$name'";
if(mysql_query($sql)) { echo 'Покупката е успешна'; }}} else { ?>
 <center> 
<a href="?a=belo&id=1">Куфар - 100 <img src="images/stats/2.png" border="0" /> - 15000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=2">Часовник - 1000 <img src="images/stats/2.png" border="0" /> - 100000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=3">Слънчеви очила - 2500 <img src="images/stats/2.png" border="0" /> - 200000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=4">Мобилен телефон - 5000 <img src="images/stats/2.png" border="0" /> - 400000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=5">Хендсфри - 10000 <img src="images/stats/2.png" border="0" /> - 750000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=6">Ролекс - 25000 <img src="images/stats/2.png" border="0" /> - 1750000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=7">Кредитна карта - 50000 <img src="images/stats/2.png" border="0" /> - 3000000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=8">Лаптоп - 75000 <img src="images/stats/2.png" border="0" /> - 5000000 <img src="images/stats/1.png" border="0" /> </a> </center>
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?>

DeathGuard_ · 28 Февруари 2010

Добавих ти or die(mysql_error()); кажи дали ти изкарва грешки. И когато имаш множество условия използвай elseif а не само иф-ове

Код:

<?php
if($_SESSION['name']) {
$name = $_SESSION['name'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$att = '100'; $cost = '15000';}
elseif($id == 2){$att = '1000'; $cost = '100000';}
elseif($id == 3){$att = '2500'; $cost = '200000';}
elseif($id == 4){$att = '5000'; $cost = '400000';}
elseif($id == 5){$att = '10000'; $cost = '750000';}
elseif($id == 6){$att = '25000'; $cost = '1750000';}
elseif($id == 7){$att = '50000'; $cost = '3000000';}
elseif($id == 8){$att = '75000'; $cost = '5000000';}
$sql = "SELECT * FROM users WHERE name = '$name'";
$do = mysql_query($sql) or die(mysql_error());
$my = mysql_fetch_array($do);
if($my['money'] < $cost) { echo 'Нямаш достатъчно пари'; } else {
$money = $my['money'] - $cost;
$sql = mysql_query("UPDATE users SET money = '$money', weaponr = '$att' WHERE name = '$name'") or die(mysql_error());
if($sql) { echo 'Покупката е успешна'; }}} else { ?>
<br> <center> <b>
<a href="?a=belo&id=1">Куфар - 100 <img src="images/stats/2.png" border="0" /> - 15000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=2">Часовник - 1000 <img src="images/stats/2.png" border="0" /> - 100000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=3">Слънчеви очила - 2500 <img src="images/stats/2.png" border="0" /> - 200000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=4">Мобилен телефон - 5000 <img src="images/stats/2.png" border="0" /> - 400000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=5">Хендсфри - 10000 <img src="images/stats/2.png" border="0" /> - 750000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=6">Ролекс - 25000 <img src="images/stats/2.png" border="0" /> - 1750000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=7">Кредитна карта - 50000 <img src="images/stats/2.png" border="0" /> - 3000000 <img src="images/stats/1.png" border="0" /> </a><br />
<a href="?a=belo&id=8">Лаптоп - 75000 <img src="images/stats/2.png" border="0" /> - 5000000 <img src="images/stats/1.png" border="0" /> </a><br /> </b> </center>
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?>

nicito · 28 Февруари 2010

Ако съм те разбрал правилно ти трябва:

Код:

$sql = mysql_query("UPDATE users SET money = money + '$money', weaponr = weaponr + '$att' WHERE name = '$name'") or die(mysql_error());

freboy · 1 Март 2010

Няма промяна

RIP · 1 Март 2010

<?php
if($_SESSION['name']) {
$name = $_SESSION['name'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$att = '100'; $cost = '15000';}
if($id == 2){$att = '1000'; $cost = '100000';}
if($id == 3){$att = '2500'; $cost = '200000';}
if($id == 4){$att = '5000'; $cost = '400000';}
if($id == 5){$att = '10000'; $cost = '750000';}
if($id == 6){$att = '25000'; $cost = '1750000';}
if($id == 7){$att = '50000'; $cost = '3000000';}
if($id == 8){$att = '75000'; $cost = '5000000';}
$sql = "SELECT * FROM users WHERE name = '$name'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['money'] < $cost) { echo 'Нямаш достатъчно пари'; } else {
$money = ($my['money'] - $cost);
$power = ($my['power'] + $att);
$sql = "UPDATE users SET money = '$money', weaponr = '$power' WHERE name = '$name'";
if(mysql_query($sql)) { echo 'Покупката е успешна'; }}} else { ?>
 <center> 
<a href="?a=belo&id=1">Куфар - 100 <img src="images/stats/2.png" border="0" /> - 15000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=2">Часовник - 1000 <img src="images/stats/2.png" border="0" /> - 100000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=3">Слънчеви очила - 2500 <img src="images/stats/2.png" border="0" /> - 200000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=4">Мобилен телефон - 5000 <img src="images/stats/2.png" border="0" /> - 400000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=5">Хендсфри - 10000 <img src="images/stats/2.png" border="0" /> - 750000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=6">Ролекс - 25000 <img src="images/stats/2.png" border="0" /> - 1750000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=7">Кредитна карта - 50000 <img src="images/stats/2.png" border="0" /> - 3000000 <img src="images/stats/1.png" border="0" /> </a> 
<a href="?a=belo&id=8">Лаптоп - 75000 <img src="images/stats/2.png" border="0" /> - 5000000 <img src="images/stats/1.png" border="0" /> </a> </center>
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?>

Готов си.

Ъпдейт

freboy

Registered

Nihtewalk

Registered

slideR

Registered

DeathGuard_

Registered

nicito

Registered

freboy

Registered

RIP

Registered