Една таблица

haus · 17 Октомври 2010

Искам да попитам може ли някои да направи таблицата race ето го кода

Код:

<?php include( "head.php" ); ?>

<h1>Състезание</h1>
<br>
<?
if($session->logged_in){
$name = htmlspecialchars(addslashes($_POST['race'])); 
$sqlquerya = "SELECT * from `users` where `username`='$name'";
$queryresulta = mysql_query($sqlquerya)
or die ("error");
while ($raw = mysql_fetch_array($queryresulta))
{

$totalmoshtnost = $session->mosht + $session->addmosht;
$totalupravlenie = $session->upravlenie + $session->addupravlenie;
$totalaero = $session->aero + $session->addaero;
$obshto = $totalmoshtnost + $totalupravlenie + $totalaero;

$totalmoshtnost1 = $raw[mosht] + $raw[addmosht];
$totalupravlenie1 = $raw[upravlenie] + $raw[addupravlenie];
$totalaero1 = $raw[aero] + $raw[addaero];
$obshto1 = $totalmoshtnost1 + $totalupravlenie1 + $totalaero1;
$obshtorace = $session->racetotal + $session->raceadd;
?>
<center>
<?php
if($session->raceday > $obshtorace-1) {
?>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавате защото са ви изчерпани състезанията за деня.
<?php
}
else
{
if($raw[money] < 50) {
?>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавате защото вашия противник няма какво да заложи.
<?php
}
else
{

$newtime = time ()-7200;
$query1 = "SELECT * FROM `race` WHERE `ip`='$name' AND `get_id`='$session->username' AND `time`>'$newtime'";
$result1=mysql_query($query1);
if (mysql_num_rows($result1)>0)
{
?>
<img src="images/error.bmp" border="0"><br><br>
Вие вече сте се състезавали с този потребител.<br>
Опитайте пак след 2 часа.
<?php
}
else
{
$time = time();
$sql3 = "INSERT INTO `race` VALUES('$session->username', '$name', '$time' );";
if(mysql_query($sql3) != "")
{

if($obshto > $obshto1) {

$nums = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowa = mysql_fetch_array($nums)) {
$raceday = $rowa[raceday]+1;
$raceday;
$money = $rowa[money]+round(0.12*$raw[money]);
$money;
$win = $rowa[win]+1;
$win;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET win='$win' where username='$session->username'";
mysql_query($sql);
}

$numsa = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowb = mysql_fetch_array($numsa)) {
$zag = $rowb[zag]+1;
$zag;
$sql1 = "UPDATE `users` SET zag='$zag' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/ok.png" border="0"><br><br>
Вие спечелихте това състезание.<br>
Печелите <b><?php echo "".round(0.12*$raw[money]).""; ?></b> $
<?php
}


if($obshto == $obshto1) {

$nums = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowa = mysql_fetch_array($nums)) {
$raceday = $rowa[raceday]+1;
$raceday;
$money = $rowa[money]+round(0.12*$raw[money]);
$money;
$win = $rowa[win]+1;
$win;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET win='$win' where username='$session->username'";
mysql_query($sql);
}

$numsa = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowb = mysql_fetch_array($numsa)) {
$zag = $rowb[zag]+1;
$zag;
$sql1 = "UPDATE `users` SET zag='$zag' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/ok.png" border="0"><br><br>
Вие спечелихте това състезание.<br>
Печелите <b><?php echo "".round(0.12*$raw[money]).""; ?></b> $
<?php
}


if($obshto < $obshto1) {

$numf = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowf = mysql_fetch_array($numf)) {
$raceday = $rowf[raceday]+1;
$raceday;
$money = $rowf[money]-round(0.10*$rowf[money]);
$money;
$zag = $rowf[zag]+1;
$zag;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET zag='$zag' where username='$session->username'";
mysql_query($sql);
}

$numsd = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowd = mysql_fetch_array($numsd)) {
$win = $rowd[win]+1;
$win;
$sql1 = "UPDATE `users` SET win='$win' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/error.bmp" border="0"><br><br>
Изглежда че се изправихте срещу сериозен противник<br> и загубихте състезанието.<br>
Губите <b><?php echo "".round(0.10*$session->money).""; ?></b> $
<?php
}
}
}
?>
</center>

<?php

}
}
}
}
else
{
?>
<center>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавали преди да сте си влезнали в акаунта.<br>
</center>
<?php
}

?>

<?php include( "foot.php" ); ?>

IzKuFeLiQqQqQ · 17 Октомври 2010

CREATE TABLE `users` {
`username` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
`raceday` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
`money` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
`zag` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
`win` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
}ENGINE=MyISAM;

CREATE TABLE `race` {
`ip` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
`time` datetime NOT NULL,
}ENGINE=MyISAM;

:idea: :idea: :idea: :idea:

haus · 17 Октомври 2010

SQL заявка:

CREATE TABLE `race` { `ip` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`time` datetime NOT NULL ,
} ENGINE = MYISAM

MySQL отговори: Документация
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{
`ip` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
`time' at line 1

Fakeheal · 17 Октомври 2010

CREATE TABLE `users` (
`username` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
`raceday` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
`money` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
`zag` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
`win` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
)ENGINE=MyISAM;

CREATE TABLE `race` (
`ip` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
`time` datetime NOT NULL,
)ENGINE=MyISAM;

IzKuFeLiQqQqQ · 17 Октомври 2010

я само ми кажи тая дата каква

примерно
постнато на 17.10.2010 10:30ч
или
постато преди 3:10ч
или как

@fake само не разбрах къде е разликата с моята таблица.. :!:

PapaSmurf · 17 Октомври 2010

Може би скобите?

IzKuFeLiQqQqQ · 17 Октомври 2010

а да наистина

не съм им обърнал внимание... извинявам се

haus · 17 Октомври 2010

Пак дава грешка

Грешка

SQL заявка:

CREATE TABLE `race` (
`ip` varchar( 250 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`time` datetime NOT NULL ,
) ENGINE = MYISAM

MySQL отговори: Документация
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')ENGINE=MyISAM' at line 4

qazxsw · 17 Октомври 2010

Код:

CREATE TABLE `users` ( 
`username` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL, 
`raceday` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL, 
`money` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL, 
`zag` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL, 
`win` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL
)ENGINE=MyISAM; 

CREATE TABLE `race` ( 
`ip` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL, 
`time` datetime NOT NULL
)ENGINE=MyISAM;

Е така трябва да стане

ЕДИТ:

Тествах го и работи така

haus · 17 Октомври 2010

Сега стана но като правя състезание ми изкарва това

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\2\racewin.php on line 47

qazxsw · 17 Октомври 2010

Пробвай така:

Код:

<?php include( "head.php" ); ?>

<h1>Състезание</h1>
<br>
<?
if($session->logged_in){
$name = htmlspecialchars(addslashes($_POST['race']));
$sqlquerya = "SELECT * from `users` where `username`='$name'";
$queryresulta = mysql_query($sqlquerya)
or die ("error");
while ($raw = mysql_fetch_array($queryresulta))
{

$totalmoshtnost = $session->mosht + $session->addmosht;
$totalupravlenie = $session->upravlenie + $session->addupravlenie;
$totalaero = $session->aero + $session->addaero;
$obshto = $totalmoshtnost + $totalupravlenie + $totalaero;

$totalmoshtnost1 = $raw[mosht] + $raw[addmosht];
$totalupravlenie1 = $raw[upravlenie] + $raw[addupravlenie];
$totalaero1 = $raw[aero] + $raw[addaero];
$obshto1 = $totalmoshtnost1 + $totalupravlenie1 + $totalaero1;
$obshtorace = $session->racetotal + $session->raceadd;
?>
<center>
<?php
if($session->raceday > $obshtorace-1) {
?>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавате защото са ви изчерпани състезанията за деня.
<?php
}
else
{
if($raw[money] < 50) {
?>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавате защото вашия противник няма какво да заложи.
<?php
}
else
{

$newtime = time ()-7200;
$query1 = "SELECT * FROM `race` WHERE `ip`='$name' AND `get_id`='$session->username' AND `time`>'$newtime'";
$result1=mysql_query($query1);
$ifsomething = mysql_num_rows($result1);
if ($ifsomething > 0)
{
?>
<img src="images/error.bmp" border="0"><br><br>
Вие вече сте се състезавали с този потребител.<br>
Опитайте пак след 2 часа.
<?php
}
else
{
$time = time();
$sql3 = "INSERT INTO `race` VALUES('$session->username', '$name', '$time' );";
if(mysql_query($sql3) != "")
{

if($obshto > $obshto1) {

$nums = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowa = mysql_fetch_array($nums)) {
$raceday = $rowa[raceday]+1;
$raceday;
$money = $rowa[money]+round(0.12*$raw[money]);
$money;
$win = $rowa[win]+1;
$win;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET win='$win' where username='$session->username'";
mysql_query($sql);
}

$numsa = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowb = mysql_fetch_array($numsa)) {
$zag = $rowb[zag]+1;
$zag;
$sql1 = "UPDATE `users` SET zag='$zag' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/ok.png" border="0"><br><br>
Вие спечелихте това състезание.<br>
Печелите <b><?php echo "".round(0.12*$raw[money]).""; ?></b> $
<?php
}


if($obshto == $obshto1) {

$nums = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowa = mysql_fetch_array($nums)) {
$raceday = $rowa[raceday]+1;
$raceday;
$money = $rowa[money]+round(0.12*$raw[money]);
$money;
$win = $rowa[win]+1;
$win;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET win='$win' where username='$session->username'";
mysql_query($sql);
}

$numsa = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowb = mysql_fetch_array($numsa)) {
$zag = $rowb[zag]+1;
$zag;
$sql1 = "UPDATE `users` SET zag='$zag' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/ok.png" border="0"><br><br>
Вие спечелихте това състезание.<br>
Печелите <b><?php echo "".round(0.12*$raw[money]).""; ?></b> $
<?php
}


if($obshto < $obshto1) {

$numf = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowf = mysql_fetch_array($numf)) {
$raceday = $rowf[raceday]+1;
$raceday;
$money = $rowf[money]-round(0.10*$rowf[money]);
$money;
$zag = $rowf[zag]+1;
$zag;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET zag='$zag' where username='$session->username'";
mysql_query($sql);
}

$numsd = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowd = mysql_fetch_array($numsd)) {
$win = $rowd[win]+1;
$win;
$sql1 = "UPDATE `users` SET win='$win' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/error.bmp" border="0"><br><br>
Изглежда че се изправихте срещу сериозен противник<br> и загубихте състезанието.<br>
Губите <b><?php echo "".round(0.10*$session->money).""; ?></b> $
<?php
}
}
}
?>
</center>

<?php

}
}
}
}
else
{
?>
<center>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавали преди да сте си влезнали в акаунта.<br>
</center>
<?php
}

?>

<?php include( "foot.php" ); ?>

haus · 18 Октомври 2010

Пак същото а искам да ви кажа че аз си имам таблицата USER

IzKuFeLiQqQqQ · 18 Октомври 2010

Код:

	<?php include( "head.php" ); ?>

<h1>Състезание</h1>
<br>
<?
if($session->logged_in){
$name = htmlspecialchars(addslashes($_POST['race']));
$sqlquerya = "SELECT * from `users` where `username`='$name'";
$queryresulta = mysql_query($sqlquerya)
or die ("error");
while ($raw = mysql_fetch_array($queryresulta))
{

$totalmoshtnost = $session->mosht + $session->addmosht;
$totalupravlenie = $session->upravlenie + $session->addupravlenie;
$totalaero = $session->aero + $session->addaero;
$obshto = $totalmoshtnost + $totalupravlenie + $totalaero;

$totalmoshtnost1 = $raw[mosht] + $raw[addmosht];
$totalupravlenie1 = $raw[upravlenie] + $raw[addupravlenie];
$totalaero1 = $raw[aero] + $raw[addaero];
$obshto1 = $totalmoshtnost1 + $totalupravlenie1 + $totalaero1;
$obshtorace = $session->racetotal + $session->raceadd;
?>
<center>
<?php
if($session->raceday > $obshtorace-1) {
?>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавате защото са ви изчерпани състезанията за деня.
<?php
}
else
{
if($raw[money] < 50) {
?>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавате защото вашия противник няма какво да заложи.
<?php
}
else
{

$newtime = time ()-7200;
$query1 = "SELECT * FROM `race` WHERE `ip`='$name' AND `get_id`='$session->username' AND `time`>'$newtime'";
$result1=mysql_query("$query1"");
$ifsomething = mysql_num_rows($result1);
if ($ifsomething > 0)
{
?>
<img src="images/error.bmp" border="0"><br><br>
Вие вече сте се състезавали с този потребител.<br>
Опитайте пак след 2 часа.
<?php
}
else
{
$time = time();
$sql3 = "INSERT INTO `race` VALUES('$session->username', '$name', '$time' );";
if(mysql_query($sql3) != "")
{

if($obshto > $obshto1) {

$nums = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowa = mysql_fetch_array($nums)) {
$raceday = $rowa[raceday]+1;
$raceday;
$money = $rowa[money]+round(0.12*$raw[money]);
$money;
$win = $rowa[win]+1;
$win;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET win='$win' where username='$session->username'";
mysql_query($sql);
}

$numsa = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowb = mysql_fetch_array($numsa)) {
$zag = $rowb[zag]+1;
$zag;
$sql1 = "UPDATE `users` SET zag='$zag' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/ok.png" border="0"><br><br>
Вие спечелихте това състезание.<br>
Печелите <b><?php echo "".round(0.12*$raw[money]).""; ?></b> $
<?php
}


if($obshto == $obshto1) {

$nums = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowa = mysql_fetch_array($nums)) {
$raceday = $rowa[raceday]+1;
$raceday;
$money = $rowa[money]+round(0.12*$raw[money]);
$money;
$win = $rowa[win]+1;
$win;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET win='$win' where username='$session->username'";
mysql_query($sql);
}

$numsa = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowb = mysql_fetch_array($numsa)) {
$zag = $rowb[zag]+1;
$zag;
$sql1 = "UPDATE `users` SET zag='$zag' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/ok.png" border="0"><br><br>
Вие спечелихте това състезание.<br>
Печелите <b><?php echo "".round(0.12*$raw[money]).""; ?></b> $
<?php
}


if($obshto < $obshto1) {

$numf = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowf = mysql_fetch_array($numf)) {
$raceday = $rowf[raceday]+1;
$raceday;
$money = $rowf[money]-round(0.10*$rowf[money]);
$money;
$zag = $rowf[zag]+1;
$zag;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET zag='$zag' where username='$session->username'";
mysql_query($sql);
}

$numsd = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowd = mysql_fetch_array($numsd)) {
$win = $rowd[win]+1;
$win;
$sql1 = "UPDATE `users` SET win='$win' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/error.bmp" border="0"><br><br>
Изглежда че се изправихте срещу сериозен противник<br> и загубихте състезанието.<br>
Губите <b><?php echo "".round(0.10*$session->money).""; ?></b> $
<?php
}
}
}
?>
</center>

<?php

}
}
}
}
else
{
?>
<center>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавали преди да сте си влезнали в акаунта.<br>
</center>
<?php
}

?>

<?php include( "foot.php" ); ?>

:idea: :idea: :idea:

haus · 18 Октомври 2010

сега дава това

Parse error: syntax error, unexpected '"' in C:\AppServ\www\2\racewin.php on line 46

IzKuFeLiQqQqQ · 18 Октомври 2010

Код:

	<?php include( "head.php" ); ?>

<h1>Състезание</h1>
<br>
<?
if($session->logged_in){
$name = htmlspecialchars(addslashes($_POST['race']));
$sqlquerya = "SELECT * from `users` where `username`='$name'";
$queryresulta = mysql_query($sqlquerya)
or die ("error");
while ($raw = mysql_fetch_array($queryresulta))
{

$totalmoshtnost = $session->mosht + $session->addmosht;
$totalupravlenie = $session->upravlenie + $session->addupravlenie;
$totalaero = $session->aero + $session->addaero;
$obshto = $totalmoshtnost + $totalupravlenie + $totalaero;

$totalmoshtnost1 = $raw[mosht] + $raw[addmosht];
$totalupravlenie1 = $raw[upravlenie] + $raw[addupravlenie];
$totalaero1 = $raw[aero] + $raw[addaero];
$obshto1 = $totalmoshtnost1 + $totalupravlenie1 + $totalaero1;
$obshtorace = $session->racetotal + $session->raceadd;
?>
<center>
<?php
if($session->raceday > $obshtorace-1) {
?>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавате защото са ви изчерпани състезанията за деня.
<?php
}
else
{
if($raw[money] < 50) {
?>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавате защото вашия противник няма какво да заложи.
<?php
}
else
{

$newtime = time ()-7200;
$query1 = "SELECT * FROM `race` WHERE `ip`='$name' AND `get_id`='$session->username' AND `time`>'$newtime'";
$result1=mysql_query("$query1");
$ifsomething = mysql_num_rows($result1);
if ($ifsomething > 0)
{
?>
<img src="images/error.bmp" border="0"><br><br>
Вие вече сте се състезавали с този потребител.<br>
Опитайте пак след 2 часа.
<?php
}
else
{
$time = time();
$sql3 = "INSERT INTO `race` VALUES('$session->username', '$name', '$time' );";
if(mysql_query($sql3) != "")
{

if($obshto > $obshto1) {

$nums = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowa = mysql_fetch_array($nums)) {
$raceday = $rowa[raceday]+1;
$raceday;
$money = $rowa[money]+round(0.12*$raw[money]);
$money;
$win = $rowa[win]+1;
$win;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET win='$win' where username='$session->username'";
mysql_query($sql);
}

$numsa = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowb = mysql_fetch_array($numsa)) {
$zag = $rowb[zag]+1;
$zag;
$sql1 = "UPDATE `users` SET zag='$zag' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/ok.png" border="0"><br><br>
Вие спечелихте това състезание.<br>
Печелите <b><?php echo "".round(0.12*$raw[money]).""; ?></b> $
<?php
}


if($obshto == $obshto1) {

$nums = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowa = mysql_fetch_array($nums)) {
$raceday = $rowa[raceday]+1;
$raceday;
$money = $rowa[money]+round(0.12*$raw[money]);
$money;
$win = $rowa[win]+1;
$win;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET win='$win' where username='$session->username'";
mysql_query($sql);
}

$numsa = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowb = mysql_fetch_array($numsa)) {
$zag = $rowb[zag]+1;
$zag;
$sql1 = "UPDATE `users` SET zag='$zag' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/ok.png" border="0"><br><br>
Вие спечелихте това състезание.<br>
Печелите <b><?php echo "".round(0.12*$raw[money]).""; ?></b> $
<?php
}


if($obshto < $obshto1) {

$numf = mysql_query("SELECT * FROM `users` WHERE `username`='$session->username'");
while ($rowf = mysql_fetch_array($numf)) {
$raceday = $rowf[raceday]+1;
$raceday;
$money = $rowf[money]-round(0.10*$rowf[money]);
$money;
$zag = $rowf[zag]+1;
$zag;
$sql2 = "UPDATE `users` SET raceday='$raceday' where username='$session->username'";
mysql_query($sql2);
$sql1 = "UPDATE `users` SET money='$money' where username='$session->username'";
mysql_query($sql1);
$sql = "UPDATE `users` SET zag='$zag' where username='$session->username'";
mysql_query($sql);
}

$numsd = mysql_query("SELECT * FROM `users` WHERE `username`='$name'");
while ($rowd = mysql_fetch_array($numsd)) {
$win = $rowd[win]+1;
$win;
$sql1 = "UPDATE `users` SET win='$win' where username='$name'";
mysql_query($sql1);
}
?>
<img src="images/error.bmp" border="0"><br><br>
Изглежда че се изправихте срещу сериозен противник<br> и загубихте състезанието.<br>
Губите <b><?php echo "".round(0.10*$session->money).""; ?></b> $
<?php
}
}
}
?>
</center>

<?php

}
}
}
}
else
{
?>
<center>
<img src="images/error.bmp" border="0"><br><br>
Не може да се състезавали преди да сте си влезнали в акаунта.<br>
</center>
<?php
}

?>

<?php include( "foot.php" ); ?>

:idea:

haus · 18 Октомври 2010

Пак същото като преди

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\2\racewin.php on line 47

haus · 19 Октомври 2010

Ще ми помогне ли някои

Една таблица

haus

Registered

IzKuFeLiQqQqQ

Registered

haus

Registered

Fakeheal

Super Moderator

IzKuFeLiQqQqQ

Registered

PapaSmurf

Registered

IzKuFeLiQqQqQ

Registered

haus

Registered

qazxsw

Registered

haus

Registered

qazxsw

Registered

haus

Registered

IzKuFeLiQqQqQ

Registered

haus

Registered

IzKuFeLiQqQqQ

Registered

haus

Registered

haus

Registered