помощь №100500

привет помоги раскидаться что и почему не пашет вот файл а та ниже таблица к нему , в общем это аукцион но он почему то не катит тупо нечего не высвечивает на сайте
..
ФАЙЛ

Осторожно, спойлер

PHP

elseif(isset($_GET['auction']))
{
echo "<table class='wdt msg-table'>";
echo "<tr><td align='left' style='vertical-align: top; width: 10%'><img src='/style/img/images/face-police.png'></td>";
echo "<td align='left' style='vertical-align: top'>Добро пожаловать на аукцион!</td></tr></table></td></tr></table>";


function otschet($time_const, $time_p) {



$time_v = ($time_const+$time_p-time());

if ($time_v > 3600)
$time_v = intval($time_v/3600).' час.';
else if ($time_v < 3600 && $time_v >=0)
$time_v = intval($time_v/60).' мин.';
else
$time_v = 'Закрыто';

return $time_v;

}


if(isset($_GET['id']) && intval($_GET['id'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `auction` WHERE `id` = '".intval($_GET['id'])."'"),0)!=0)
{

$auct = mysql_fetch_assoc(mysql_query("SELECT * FROM `auction` WHERE `id` = '".intval($_GET['id'])."' "));

$auct2 = mysql_fetch_assoc(mysql_query("SELECT * FROM `auction_st` WHERE `id_auction` = '".intval($_GET['id'])."' "));


if (isset($_POST['stavka']) && isset($user) && $auct['time']>$time-$auct2['time']) {

$st = intval($_POST['stavka']);

if ($st > $user['money'])
echo '<div class = "err">У вас нет столько баллов</div>';
else {

mysql_query("UPDATE `auction_st` SET `money` = '".($auct2['money']+$st)."', `id_user` = '".$user['id']."' WHERE `id_auction` = '".intval($_GET['id'])."' ");

$_SESSION['message'] = 'Принято. Ставка: '.$st.' балл.</div>';

header("Location: index.php?id=".$_GET['id']);

exit;

}
}
$us = mysql_fetch_assoc(mysql_query("SELECT `nick` FROM `user` WHERE `id` = '".$auct2['id_user']."' "));

echo '<div class = "mess">'.$auct['name'].'</div>';

if ($auct2['type'] == 'liders')
$type = 'Лидеры';
if ($auct2['type'] == 'gift')
$type = 'Подарки';
if ($auct2['type'] == 'ocenka')
$type = 'Оценка 5+';
if ($auct2['type'] == 'nevidimka')
$type = 'Невидимка';

echo '<div class = "nav2"><b>Тип:</b></а> '.$type.', на '.($auct2['time_st']/3600).' час.<br />';
echo '<b>Текущая ставка:</b> '.$auct2['money'].' балл. <a href="/info.php?id='.$auct2['id_user'].'">'.$us['nick'].'</a><br />


<b>У вас:</b> '.$user['money'].' балл.
<br />';

if ($auct['time']>$time-$auct2['time']) {
echo '<br /><form action = "index.php?id='.$_GET['id'].'" method = "POST">
<b>Ваша ставка:</b> 
<br />
<input name = "stavka" size = "10" value = "'.($auct2['money']+5).'">
<input type = "submit" value = "Ок">

<br />
</form>';
echo '<br />';
}
echo '<b>До закрытия:</b> '.otschet($auct['time'], $auct2['time']).'<br />

<b>Общее время:</b> '.($auct2['time']/3600).' час.<br />



</div>';

}





echo "<table class='wdt gray-table'>";
echo "<tr><td class='white td-cell' align='center' style='height:30px;'><form action ='/dev/gai.php' method='post'><input class='no-btn' type='submit' value='Назад'></form></td></tr></table>";
include_once '../sys/inc/tfoot.php';
}

ТАБЛИЦА БД

Осторожно, спойлер

CODE

--
-- Структура таблицы `auction`
--

CREATE TABLE IF NOT EXISTS `auction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gos_bb_one` varchar(4) NOT NULL DEFAULT 'A',
  `gos_bb_two` varchar(4) NOT NULL DEFAULT 'A',
  `gos_bb_free` varchar(4) NOT NULL DEFAULT 'A',
  `number` int(8) NOT NULL DEFAULT '111',
  `region` int(4) NOT NULL DEFAULT '1',
  `time_start` int(11) NOT NULL,
  `time_end` int(11) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

KpuTuK, нет.. вот полный

Осторожно, спойлер

PHP

<?
include_once '../sys/core/start.php';
include_once '../sys/core/compress.php';
include_once '../sys/core/sess.php';
include_once '../sys/core/home.php';
include_once '../sys/core/db_connect.php';
include_once '../sys/core/ipua.php';
include_once '../sys/core/fnc.php';
include_once '../sys/core/user.php';
include_once '../sys/inc/fnc_game.php';
include_once '../sys/inc/thead.php';
include_once '../sys/inc/uhead.php';
only_reg();



/* Выбор региона */
if(isset($_GET['number_select']))
{
/* Получение гос. номера */
if(isset($_GET['ok']) && intval($_GET['ok'])!=NULL && $user['money']>=2000 && mysql_result(mysql_query("SELECT COUNT(*) FROM `gos_region` WHERE `id` = '".intval($_GET['ok'])."'"),0)!=0)
{
$ok_region=mysql_fetch_array(mysql_query("SELECT * FROM `gos_region` WHERE `id`='".intval($_GET['ok'])."'"));
$cena_number=2000;
$number=rand(1,999);
$bb_one_rand=rand(1,12);
$bb_two_rand=rand(1,12);
$bb_free_rand=rand(1,12);


# генерим первую букву
if($bb_one_rand==1)
{
$bb_one_rand="A";
}
elseif($bb_one_rand==2)
{
$bb_one_rand="B";
}
elseif($bb_one_rand==3)
{
$bb_one_rand="E";
}
elseif($bb_one_rand==4)
{
$bb_one_rand="K";
}
elseif($bb_one_rand==5)
{
$bb_one_rand="M";
}
elseif($bb_one_rand==6)
{
$bb_one_rand="H";
}
elseif($bb_one_rand==7)
{
$bb_one_rand="O";
}
elseif($bb_one_rand==8)
{
$bb_one_rand="P";
}
elseif($bb_one_rand==9)
{
$bb_one_rand="C";
}
elseif($bb_one_rand==10)
{
$bb_one_rand="T";
}
elseif($bb_one_rand==11)
{
$bb_one_rand="Y";
}
elseif($bb_one_rand==12)
{
$bb_one_rand="X";
}


# генерим вторую букву
if($bb_two_rand==1)
{
$bb_two_rand="A";
}
elseif($bb_two_rand==2)
{
$bb_two_rand="B";
}
elseif($bb_two_rand==3)
{
$bb_two_rand="E";
}
elseif($bb_two_rand==4)
{
$bb_two_rand="K";
}
elseif($bb_two_rand==5)
{
$bb_two_rand="M";
}
elseif($bb_two_rand==6)
{
$bb_two_rand="H";
}
elseif($bb_two_rand==7)
{
$bb_two_rand="O";
}
elseif($bb_two_rand==8)
{
$bb_two_rand="P";
}
elseif($bb_two_rand==9)
{
$bb_two_rand="C";
}
elseif($bb_two_rand==10)
{
$bb_two_rand="T";
}
elseif($bb_two_rand==11)
{
$bb_two_rand="Y";
}
elseif($bb_two_rand==12)
{
$bb_two_rand="X";
}



# генерим третью букву
if($bb_free_rand==1)
{
$bb_free_rand="A";
}
elseif($bb_free_rand==2)
{
$bb_free_rand="B";
}
elseif($bb_free_rand==3)
{
$bb_free_rand="E";
}
elseif($bb_free_rand==4)
{
$bb_free_rand="K";
}
elseif($bb_free_rand==5)
{
$bb_free_rand="M";
}
elseif($bb_free_rand==6)
{
$bb_free_rand="H";
}
elseif($bb_free_rand==7)
{
$bb_free_rand="O";
}
elseif($bb_free_rand==8)
{
$bb_free_rand="P";
}
elseif($bb_free_rand==9)
{
$bb_free_rand="C";
}
elseif($bb_free_rand==10)
{
$bb_free_rand="T";
}
elseif($bb_free_rand==11)
{
$bb_free_rand="Y";
}
elseif($bb_free_rand==12)
{
$bb_free_rand="X";
}


if($user['money']>=$cena_number)
{
if($number<10)
{
mysql_query("UPDATE `garage` SET `gos_number` = '00$number', `gos_bb_one` = '$bb_one_rand', `gos_bb_two` = '$bb_two_rand', `gos_bb_free` = '$bb_free_rand', `gos_region` = '".$ok_region['region']."', `gos_region_transit` = '0' WHERE `id` = '".$mycar['id']."'");
}
elseif($number<100)
{
mysql_query("UPDATE `garage` SET `gos_number` = '0$number', `gos_bb_one` = '$bb_one_rand', `gos_bb_two` = '$bb_two_rand', `gos_bb_free` = '$bb_free_rand', `gos_region` = '".$ok_region['region']."', `gos_region_transit` = '0' WHERE `id` = '".$mycar['id']."'");
}
else
{
mysql_query("UPDATE `garage` SET `gos_number` = '$number', `gos_bb_one` = '$bb_one_rand', `gos_bb_two` = '$bb_two_rand', `gos_bb_free` = '$bb_free_rand', `gos_region` = '".$ok_region['region']."', `gos_region_transit` = '0' WHERE `id` = '".$mycar['id']."'");
}
mysql_query("UPDATE `user` SET `money` = '".($user['money']-$cena_number)."' WHERE `id` = '".$user['id']."' LIMIT 1");
$_SESSION['number_ok']=1;
header("Location: /dev/gai.php");
}
}



echo "<table class='wdt msg-table'><tr><td align='left' style='vertical-align: top; width: 10%'><img src='/style/img/images/face-police.png'></td>";
echo "<td align='left' style='vertical-align: top'>";
echo "Выберите регион для выдачи будующего гос. номера.</td></tr></table></td></tr></table>";


$q=mysql_query("SELECT * FROM `gos_region` ORDER BY `id` ASC");
while($post=mysql_fetch_array($q)){

echo "<table class='wdt gray-table' style='color: #FFFFFF;'>";
echo "<tr><td width='44px'>";
echo "<table class='number-table'>";
echo "<tr><td style='width: 20px;'></td>";
if($post['region']<10)
{
echo "<td style='width: 24px; text-align: center; color:#000000; font-family:tahoma' align='center'>0$post[region]</td></tr></table></td>";
}
else
{
echo "<td style='width: 24px; text-align: center; color:#000000; font-family:tahoma' align='center'>$post[region]</td></tr></table></td>";
}
echo "<td>$post[name]</td>";
echo "<td width='100px'><form action ='/dev/gai.php?number_select&ok=".$post['id']."' method='post'><input type='submit' class='wdt race-btn' value='Выбрать'/></form></td></tr>";
}


echo "<table class='wdt gray-table'>";
echo "<tr><td class='white td-cell' align='center' style='height:30px;'><form action ='/dev/gai.php' method='post'><input class='no-btn' type='submit' value='Назад'></form></td></tr></table>";
include_once '../sys/inc/tfoot.php';

}
















elseif(isset($_GET['auction']))
{
echo "<table class='wdt msg-table'>";
echo "<tr><td align='left' style='vertical-align: top; width: 10%'><img src='/style/img/images/face-police.png'></td>";
echo "<td align='left' style='vertical-align: top'>Добро пожаловать на аукцион!</td></tr></table></td></tr></table>";


function otschet($time_const, $time_p) {



$time_v = ($time_const+$time_p-time());

if ($time_v > 3600)
$time_v = intval($time_v/3600).' час.';
else if ($time_v < 3600 && $time_v >=0)
$time_v = intval($time_v/60).' мин.';
else
$time_v = 'Закрыто';

return $time_v;

}


if(isset($_GET['id']) && intval($_GET['id'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `auction` WHERE `id` = '".intval($_GET['id'])."'"),0)!=0)
{

$auct = mysql_fetch_assoc(mysql_query("SELECT * FROM `auction` WHERE `id` = '".intval($_GET['id'])."' "));

$auct2 = mysql_fetch_assoc(mysql_query("SELECT * FROM `auction_st` WHERE `id_auction` = '".intval($_GET['id'])."' "));


if (isset($_POST['stavka']) && isset($user) && $auct['time']>$time-$auct2['time']) {

$st = intval($_POST['stavka']);

if ($st > $user['money'])
echo '<div class = "err">У вас нет столько баллов</div>';
else {

mysql_query("UPDATE `auction_st` SET `money` = '".($auct2['money']+$st)."', `id_user` = '".$user['id']."' WHERE `id_auction` = '".intval($_GET['id'])."' ");

$_SESSION['message'] = 'Принято. Ставка: '.$st.' балл.</div>';

header("Location: index.php?id=".$_GET['id']);

exit;

}
}
$us = mysql_fetch_assoc(mysql_query("SELECT `nick` FROM `user` WHERE `id` = '".$auct2['id_user']."' "));

echo '<div class = "mess">'.$auct['name'].'</div>';

if ($auct2['type'] == 'liders')
$type = 'Лидеры';
if ($auct2['type'] == 'gift')
$type = 'Подарки';
if ($auct2['type'] == 'ocenka')
$type = 'Оценка 5+';
if ($auct2['type'] == 'nevidimka')
$type = 'Невидимка';

echo '<div class = "nav2"><b>Тип:</b></а> '.$type.', на '.($auct2['time_st']/3600).' час.<br />';
echo '<b>Текущая ставка:</b> '.$auct2['money'].' балл. <a href="/info.php?id='.$auct2['id_user'].'">'.$us['nick'].'</a><br />


<b>У вас:</b> '.$user['money'].' балл.
<br />';

if ($auct['time']>$time-$auct2['time']) {
echo '<br /><form action = "index.php?id='.$_GET['id'].'" method = "POST">
<b>Ваша ставка:</b> 
<br />
<input name = "stavka" size = "10" value = "'.($auct2['money']+5).'">
<input type = "submit" value = "Ок">

<br />
</form>';
echo '<br />';
}
echo '<b>До закрытия:</b> '.otschet($auct['time'], $auct2['time']).'<br />

<b>Общее время:</b> '.($auct2['time']/3600).' час.<br />



</div>';

}





echo "<table class='wdt gray-table'>";
echo "<tr><td class='white td-cell' align='center' style='height:30px;'><form action ='/dev/gai.php' method='post'><input class='no-btn' type='submit' value='Назад'></form></td></tr></table>";
include_once '../sys/inc/tfoot.php';
}



















else
{

if(isset($_SESSION['number_ok']))
{
echo "<table class='wdt msg-table'><tr><td align='left' style='vertical-align: top; width: 10%'><img src='/style/img/images/face-police.png'></td>";
echo "<td align='left' style='vertical-align: top'>";
echo "Вы получили новые гос.номера!</td></tr></table></td></tr></table>";
unset($_SESSION['number_ok']);
}
else
{
echo "<table class='wdt msg-table'><tr><td align='left' style='vertical-align: top; width: 10%'><img src='/style/img/images/face-police.png'></td>";
echo "<td align='left' style='vertical-align: top'>";
echo "Добро пожаловать в ГАИ.</td></tr></table></td></tr></table>";
}
echo "<table class='wdt brown-header'>";
echo "<tr><td align='left'>Гос. Авто Инспекция</td></tr></table>";

echo "<table class='wdt gray-table'>";
echo "<tr><td style='color: #FFFFFF;' align='left'>Ты можешь сменить свои номерные знаки за 2000 монет. Красивые номера ты сможешь купить на аукционе, о котором будет объявляться заранее.<br>";

if($mycar['gos_region']>0)
{
if($mycar['gos_region_transit']>0)
{
if($mycar['gos_region']<10)
{
echo "Твой номер: <img width='100' src='http://club2108.ru/numgen/index.php?num=$mycar[gos_bb_one]$mycar[gos_number]$mycar[gos_bb_two]$mycar[gos_bb_free]0$mycar[gos_region]&b=7' alt='number'><br/>";
}
else
{
echo "Твой номер: <img width='100' src='http://club2108.ru/numgen/index.php?num=$mycar[gos_bb_one]$mycar[gos_number]$mycar[gos_bb_two]$mycar[gos_bb_free]$mycar[gos_region]&b=7' alt='number'><br/>";
}
}
else
{
if($mycar['gos_region']<10)
{
echo "Твой номер: <img width='100' src='http://club2108.ru/numgen/index.php?num=$mycar[gos_bb_one]$mycar[gos_number]$mycar[gos_bb_two]$mycar[gos_bb_free]0$mycar[gos_region]&b=1' alt='number'><br/>";
}
else
{
echo "Твой номер: <img width='100' src='http://club2108.ru/numgen/index.php?num=$mycar[gos_bb_one]$mycar[gos_number]$mycar[gos_bb_two]$mycar[gos_bb_free]$mycar[gos_region]&b=1' alt='number'><br/>";
}
}
}
echo "<span style='line-height:35px;'>Стоимость: <img src='/style/img/icons/money.png' alt='coins'>2000</span>";
echo "<br><span style='line-height:20px;'>Авто: <span class='yellow'>$mycar[name]</span> <a class='orange' style='font-size:10pt;' href='/dev/change_car.php'>Сменить</a></span></td></tr></table>";

echo "<table class='wdt gray-table'>";
echo "<tr><td class='white td-cell' align='center' style='height: 30px; width: 50%; padding-right: 3px; padding-left: 6px;'>";
echo "<form action ='/dev/gai.php?number_select' method='post'><input type='submit' class='wdt race-btn' value='Сменить номер'/></form></td>";
echo "<td class='white td-cell' align='center' style='height: 30px; width: 50%; padding-left: 3px; padding-right: 6px;'>";
echo "<form action ='/dev/gai.php?auction' method='post'><input type='submit' class='wdt race-btn' value='Аукцион'/></form></td></tr></table>";

echo "<table class='wdt gray-table'>";
echo "<tr><td class='white td-cell' align='center' style='height:30px;'><form action ='/dev/map.php' method='post'><input class='no-btn' type='submit' value='Назад'></form></td></tr></table>";
include_once '../sys/inc/tfoot.php';
}
?>