От къде и защо излиза грешката :? :@

B

b0nb0n40

Registered
ето това е кода:
PHP: 
<?php
session_start();
$sesusername = $_SESSION['name'];
$query = mysql_query("SELECT * FROM users WHERE name = '$sesusername'");
$my = mysql_fetch_array($query);
$namepro = $my['namepro'];

if($namepro == '1') {
if($_SESSION['name'])
{
?>
<h2 class='stranicamenu'><center>АвтоPro</center></h2>


<table cellpadding="0" cellspacing="0"><tbody><tr>
</td></tr><tr><td width="700"><center><tbody><tr><td><div class="text">
<table><tbody><tr><td>


   
  </table><table width="705" border="0">
<center>
<?
$session = $_SESSION['name'];
if($session==NULL){
echo "Не си логнат за да продаваш колата си!";
exit;
}

$page=htmlspecialchars($_GET['what']);
$codec=mysql_fetch_array(mysql_query("SELECT sellcars, cars, money FROM users WHERE name='$session'"));
$sellcars=$codec['sellcars'];
$cars=$codec['cars'];
$money=$codec['money'];

if(!$page){

if ($sellcars >= 100)
{
echo "<a href='index.php?a=autopro&what=sell'><span style='padding: 0px 3px; color: white; background-color: red; font-weight: bolder; font-size: 15px;'>Продай колицата за</span><span style='padding: 0px 3px; color: white; background-color: green; font-weight: bolder; font-size: 15px;'> <b>$sellcars</b> пари.</span></font></a>";
}
elseif ($sellcars == 0)
{
echo "Първата кола с която те пуска не може да се продаде.";
}}

elseif($page=='sell') {
$newmoney=$sellcars+$money;
$krai=mysql_query("UPDATE users SET money='$newmoney', sellcars=0, cars=0 WHERE name='$session'");
echo "<meta http-equiv=refresh content=2;url='index.php?a=autopro'><span style='padding: 0px 3px; color: white; background-color: green; font-weight: bolder; font-size: 15px;'>Колата ти е продадена успешно.</span>";
}
else {
echo "Не се прави на хакерче :)";
}
?>
</center>


<tbody><tr>

    <td width="946" bgcolor="#464646"><div class="style3" align="center">Кола</div></td>
    <td width="225" bgcolor="#464646"><div class="style3" align="center">Цена</div></td>
    <td width="1" bgcolor="#464646"><div class="style3" align="center">Бързина</div></td>
    <td width="1" bgcolor="#464646"><div class="style3" align="center">Ускорение</div></td>
    <td width="1" bgcolor="#464646"><div class="style3" align="center">Стабилност</div></td>
    <td width="85" bgcolor="#464646"><div class="style3" align="center">Виж</div></td>
    <td width="590" bgcolor="#464646"><div class="style3" align="center">Купи</div></td>
	<td width="190" bgcolor="#464646"><div class="style3" align="center">Изисквания</div></td>
  </tr>

<? 
$session = $_SESSION['name']; 
$s = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE name='$name'")); 
if ( $s[cars] != '2755' ) { 
if($session == null){ 
echo 'logg! '; 
}else{ 
if ( isset($_POST[btn55]) ) 
{ 

if ($s['money']>1110000) 
{ if($s['drivercar']>2){
$q = mysql_query("UPDATE users SET money=money-1110000 ,cars=2755 ,speed=630 ,acceleration=669 ,stability=599 ,sellcars=555000 WHERE name='$name'") or die(mysql_error()); 
if ($q) echo '<font class="actively"><center>Ти успешно закупи колата.</font></center>'; 
else echo 'no'; } 
   else { echo 'Нивото ти на бизнесмен е ниско!'; }
 }  
else { echo 'Нямаш достатъчно пари!'; } 

} 
else 
{ 
echo '
    <td bgcolor="#8a8a8a"><div style="padding-left: 5px;" align="left"><span class="style2">Ferrari Enzo</span></div></td>
    <td bgcolor="#757575"> <div align="center"><strong>1,110,000 $</strong></div></td>
    <td bgcolor="#646464"><div class="style4" align="center">630</div></td>
    <td bgcolor="#4f4f4f"><div class="style4" align="center">669</div></td>
	<td bgcolor="#444444"><div class="style4" align="center">599</div></td>'; 
	?>
<?php
echo"<td bgcolor=\"#66cc00\"><div align=\"center\"><strong><a href=\"javascript:void(0);\" onclick=\"window.open('racing/ferrari-enzo-wallpapers.jpg', '', 'width=320, height=250');\">Тук</a></strong></div></td>";
?>
<?php
if($s['money']>=1110000)
if($s['drivercar'] > 2)
echo '<td bgcolor="#3a3a3a"><div align="center"><form action="" method="post"><input type="submit" name="btn55" value="Купи"></form><strong></strong></div></td>';
else echo '<td bgcolor="#323232"><div align="center"><form action="" method="post"><input type="button" disabled="disabled" name="btn55" value="Купи"></form><strong></strong></div></td>';
else { if($s['drivercar'] < 3)
echo '';
echo '<td bgcolor="#323232"><div align="center"><font color=red>Нямаш пари!</form><strong></strong></div></td>'; }
{
echo '<td bgcolor="#262626"><div class="style4" align="center"><a href="index.php?a=skills"><u>3 к. шофьор</a></u></div></td><tr>';
}
} }} else echo ' ';
?>






<? 
$session = $_SESSION['name']; 
$s = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE name='$name'")); 
if ( $s[cars] != '2805' ) { 
if($session == null){ 
echo 'logg! '; 
}else{ 
if ( isset($_POST[btn56]) ) 
{ 

if ($s['money']>1215000) 
{ if($s['drivercar']>2){
$q = mysql_query("UPDATE users SET money=money-1215000 ,cars=2805 ,speed=650 ,acceleration=675 ,stability=600 ,sellcars=607500 WHERE name='$name'") or die(mysql_error()); 
if ($q) echo '<font class="actively"><center>Ти успешно закупи колата.</font></center>'; 
else echo 'no'; } 
   else { echo 'Нивото ти на бизнесмен е ниско!'; }
 }  
else { echo 'Нямаш достатъчно пари!'; } 

} 
else 
{ 
echo '
    <td bgcolor="#8a8a8a"><div style="padding-left: 5px;" align="left"><span class="style2">Cadillac Cien</span></div></td>
    <td bgcolor="#757575"> <div align="center"><strong>1,215,000 $</strong></div></td>
    <td bgcolor="#646464"><div class="style4" align="center">650</div></td>
    <td bgcolor="#4f4f4f"><div class="style4" align="center">675</div></td>
	<td bgcolor="#444444"><div class="style4" align="center">600</div></td>'; 
	?>
<?php
echo"<td bgcolor=\"#66cc00\"><div align=\"center\"><strong><a href=\"javascript:void(0);\" onclick=\"window.open('racing/cadillac-cien.jpg', '', 'width=320, height=250');\">Тук</a></strong></div></td>";
?>
<?php
if($s['money']>=1215000)
if($s['drivercar'] > 2)
echo '<td bgcolor="#3a3a3a"><div align="center"><form action="" method="post"><input type="submit" name="btn56" value="Купи"></form><strong></strong></div></td>';
else echo '<td bgcolor="#323232"><div align="center"><form action="" method="post"><input type="button" disabled="disabled" name="btn56" value="Купи"></form><strong></strong></div></td>';
else { if($s['drivercar'] < 3)
echo '';
echo '<td bgcolor="#323232"><div align="center"><font color=red>Нямаш пари!</form><strong></strong></div></td>'; }
{
echo '<td bgcolor="#262626"><div class="style4" align="center"><a href="index.php?a=skills"><u>3 к. шофьор</a></u></div></td><tr>';
}
} }} else echo ' ';
?>









<? 
$session = $_SESSION['name']; 
$s = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE name='$name'")); 
if ( $s[cars] != '2855' ) { 
if($session == null){ 
echo 'logg! '; 
}else{ 
if ( isset($_POST[btn57]) ) 
{ 

if ($s['money']>1400500) 
{ if($s['drivercar']>2){
$q = mysql_query("UPDATE users SET money=money-1400500 ,cars=2855 ,speed=665 ,acceleration=684 ,stability=610 ,sellcars=700250 WHERE name='$name'") or die(mysql_error()); 
if ($q) echo '<font class="actively"><center>Ти успешно закупи колата.</font></center>'; 
else echo 'no'; } 
   else { echo 'Нивото ти на бизнесмен е ниско!'; }
 }  
else { echo 'Нямаш достатъчно пари!'; } 

} 
else 
{ 
echo '
    <td bgcolor="#8a8a8a"><div style="padding-left: 5px;" align="left"><span class="style2">Porsche Carrera Gt</span></div></td>
    <td bgcolor="#757575"> <div align="center"><strong>1,400,500 $</strong></div></td>
    <td bgcolor="#646464"><div class="style4" align="center">665</div></td>
    <td bgcolor="#4f4f4f"><div class="style4" align="center">684</div></td>
	<td bgcolor="#444444"><div class="style4" align="center">610</div></td>'; 
	?>
<?php
echo"<td bgcolor=\"#66cc00\"><div align=\"center\"><strong><a href=\"javascript:void(0);\" onclick=\"window.open('racing/porsche_carrera.jpg', '', 'width=320, height=250');\">Тук</a></strong></div></td>";
?>
<?php
if($s['money']>=1400500)
if($s['drivercar'] > 2)
echo '<td bgcolor="#3a3a3a"><div align="center"><form action="" method="post"><input type="submit" name="btn57" value="Купи"></form><strong></strong></div></td>';
else echo '<td bgcolor="#323232"><div align="center"><form action="" method="post"><input type="button" disabled="disabled" name="btn57" value="Купи"></form><strong></strong></div></td>';
else { if($s['drivercar'] < 3)
echo '';
echo '<td bgcolor="#323232"><div align="center"><font color=red>Нямаш пари!</form><strong></strong></div></td>'; }
{
echo '<td bgcolor="#262626"><div class="style4" align="center"><a href="index.php?a=skills"><u>3 к. шофьор</a></u></div></td><tr>';
}
} }} else echo ' ';
?>






<? 
$session = $_SESSION['name']; 
$s = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE name='$name'")); 
if ( $s[cars] != '2905' ) { 
if($session == null){ 
echo 'logg! '; 
}else{ 
if ( isset($_POST[btn58]) ) 
{ 

if ($s['money']>1890000) 
{ if($s['drivercar']>2){
$q = mysql_query("UPDATE users SET money=money-1890000 ,cars=2905 ,speed=664 ,acceleration=700 ,stability=616 ,sellcars=945000 WHERE name='$name'") or die(mysql_error()); 
if ($q) echo '<font class="actively"><center>Ти успешно закупи колата.</font></center>'; 
else echo 'no'; } 
   else { echo 'Нивото ти на бизнесмен е ниско!'; }
 }  
else { echo 'Нямаш достатъчно пари!'; } 

} 
else 
{ 
echo '
    <td bgcolor="#8a8a8a"><div style="padding-left: 5px;" align="left"><span class="style2">Lamborghini Reventon</span></div></td>
    <td bgcolor="#757575"> <div align="center"><strong>1,890,000 $</strong></div></td>
    <td bgcolor="#646464"><div class="style4" align="center">664</div></td>
    <td bgcolor="#4f4f4f"><div class="style4" align="center">700</div></td>
	<td bgcolor="#444444"><div class="style4" align="center">616</div></td>'; 
	?>
<?php
echo"<td bgcolor=\"#66cc00\"><div align=\"center\"><strong><a href=\"javascript:void(0);\" onclick=\"window.open('racing/Lamborghini_Reventon.jpg', '', 'width=320, height=250');\">Тук</a></strong></div></td>";
?>
<?php
if($s['money']>=1890000)
if($s['drivercar'] > 2)
echo '<td bgcolor="#3a3a3a"><div align="center"><form action="" method="post"><input type="submit" name="btn58" value="Купи"></form><strong></strong></div></td>';
else echo '<td bgcolor="#323232"><div align="center"><form action="" method="post"><input type="button" disabled="disabled" name="btn58" value="Купи"></form><strong></strong></div></td>';
else { if($s['drivercar'] < 3)
echo '';
echo '<td bgcolor="#323232"><div align="center"><font color=red>Нямаш пари!</form><strong></strong></div></td>'; }
{
echo '<td bgcolor="#262626"><div class="style4" align="center"><a href="index.php?a=skills"><u>3 к. шофьор</a></u></div></td><tr>';
}
} }} else echo ' ';
?>




<? 
$session = $_SESSION['name']; 
$s = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE name='$name'")); 
if ( $s[cars] != '2955' ) { 
if($session == null){ 
echo 'logg! '; 
}else{ 
if ( isset($_POST[btn59]) ) 
{ 

if ($s['money']>2000000) 
{ if($s['drivercar']>2){
$q = mysql_query("UPDATE users SET money=money-2000000 ,cars=2955 ,speed=675 ,acceleration=680 ,stability=623 ,sellcars=1000000 WHERE name='$name'") or die(mysql_error()); 
if ($q) echo '<font class="actively"><center>Ти успешно закупи колата.</font></center>'; 
else echo 'no'; } 
   else { echo 'Нивото ти на бизнесмен е ниско!'; }
 }  
else { echo 'Нямаш достатъчно пари!'; } 

} 
else 
{ 
echo '
    <td bgcolor="#8a8a8a"><div style="padding-left: 5px;" align="left"><span class="style2">Maybach</span></div></td>
    <td bgcolor="#757575"> <div align="center"><strong>2,000,000 $</strong></div></td>
    <td bgcolor="#646464"><div class="style4" align="center">675</div></td>
    <td bgcolor="#4f4f4f"><div class="style4" align="center">680</div></td>
	<td bgcolor="#444444"><div class="style4" align="center">623</div></td>'; 
	?>
<?php
echo"<td bgcolor=\"#66cc00\"><div align=\"center\"><strong><a href=\"javascript:void(0);\" onclick=\"window.open('racing/maybach .jpg', '', 'width=320, height=250');\">Тук</a></strong></div></td>";
?>
<?php
if($s['money']>=2000000)
if($s['drivercar'] > 2)
echo '<td bgcolor="#3a3a3a"><div align="center"><form action="" method="post"><input type="submit" name="btn59" value="Купи"></form><strong></strong></div></td>';
else echo '<td bgcolor="#323232"><div align="center"><form action="" method="post"><input type="button" disabled="disabled" name="btn59" value="Купи"></form><strong></strong></div></td>';
else { if($s['drivercar'] < 3)
echo '';
echo '<td bgcolor="#323232"><div align="center"><font color=red>Нямаш пари!</form><strong></strong></div></td>'; }
{
echo '<td bgcolor="#262626"><div class="style4" align="center"><a href="index.php?a=skills"><u>3 к. шофьор</a></u></div></td><tr>';
}
} }} else echo ' ';
?>









<? 
$session = $_SESSION['name']; 
$s = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE name='$name'")); 
if ( $s[cars] != '3005' ) { 
if($session == null){ 
echo 'logg! '; 
}else{ 
if ( isset($_POST[btn60]) ) 
{ 

if ($s['money']>2560000) 
{ if($s['drivercar']>2){
$q = mysql_query("UPDATE users SET money=money-2560000 ,cars=3005 ,speed=720 ,acceleration=730 ,stability=650 ,sellcars=1280000 WHERE name='$name'") or die(mysql_error()); 
if ($q) echo '<font class="actively"><center>Ти успешно закупи колата.</font></center>'; 
else echo 'no'; } 
   else { echo 'Нивото ти на бизнесмен е ниско!'; }
 }  
else { echo 'Нямаш достатъчно пари!'; } 

} 
else 
{ 
echo '
    <td bgcolor="#8a8a8a"><div style="padding-left: 5px;" align="left"><span class="style2">Bugatti Veyron</span></div></td>
    <td bgcolor="#757575"> <div align="center"><strong>2,560,000 $</strong></div></td>
    <td bgcolor="#646464"><div class="style4" align="center">720</div></td>
    <td bgcolor="#4f4f4f"><div class="style4" align="center">730</div></td>
	<td bgcolor="#444444"><div class="style4" align="center">650</div></td>'; 
	?>
<?php
echo"<td bgcolor=\"#66cc00\"><div align=\"center\"><strong><a href=\"javascript:void(0);\" onclick=\"window.open('racing/bugatti-veyron.jpg', '', 'width=320, height=250');\">Тук</a></strong></div></td>";
?>
<?php
if($s['money']>=2560000)
if($s['drivercar'] > 2)
echo '<td bgcolor="#3a3a3a"><div align="center"><form action="" method="post"><input type="submit" name="btn60" value="Купи"></form><strong></strong></div></td>';
else echo '<td bgcolor="#323232"><div align="center"><form action="" method="post"><input type="button" disabled="disabled" name="btn60" value="Купи"></form><strong></strong></div></td>';
else { if($s['drivercar'] < 3)
echo '';
echo '<td bgcolor="#323232"><div align="center"><font color=red>Нямаш пари!</form><strong></strong></div></td>'; }
{
echo '<td bgcolor="#262626"><div class="style4" align="center"><a href="index.php?a=skills"><u>3 к. шофьор</a></u></div></td><tr>';
}
} }} else echo ' ';
?>















</div></td></tr></tbody></table>
</div></td></tr></tbody></center> </td></tr><tr><td width="100%" height="54"></td></tr></tbody></table><br>

<?
}
else
{
echo "Не си логнат.";
}
}
if($namepro == '0') {
echo '<b><font color="#feef01">Трябва да си PRO</font></b>';
}
?>
Дава ето тази грешка
Unknown column 'sellcars' in 'field list'
Ето това ми е DB
Код: 
CREATE TABLE IF NOT EXISTS `ban` (
`id_ban` int(11) NOT NULL,
`ip` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `bgtop` (
`ip` varchar(33) default NULL,
`ctime` varchar(33) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;



CREATE TABLE IF NOT EXISTS `daltochka` (
`title` varchar(255) NOT NULL default 'Untitled Message',
`message` text NOT NULL,
`touser` varchar(255) NOT NULL default '',
`douser` varchar(255) NOT NULL,
`from` varchar(255) NOT NULL default '',
`unread` varchar(255) NOT NULL default 'unread',
`date` date NOT NULL default '0000-00-00',
`id` int(15) NOT NULL auto_increment,
`reply` varchar(15) NOT NULL default 'no',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9843 ;



CREATE TABLE IF NOT EXISTS `dragip` (
`id` int(255) NOT NULL auto_increment,
`viewcount` varchar(255) NOT NULL default '0',
`drag_id` int(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;





CREATE TABLE IF NOT EXISTS `firms` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(11) NOT NULL,
`avatar` varchar(255) default '0',
`description` varchar(255) NOT NULL,
`boss` varchar(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `forumtutorial_posts` (
`postid` bigint(20) NOT NULL auto_increment,
`author` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`post` mediumtext NOT NULL,
`showtime` varchar(255) NOT NULL default '',
`realtime` bigint(20) NOT NULL default '0',
`lastposter` varchar(255) NOT NULL default '',
`numreplies` bigint(20) NOT NULL default '0',
`parentid` bigint(20) NOT NULL default '0',
`lastrepliedto` bigint(20) NOT NULL default '0',
PRIMARY KEY (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=126 ;



CREATE TABLE IF NOT EXISTS `forum_messages` (
`mID` int(11) NOT NULL auto_increment,
`mDate` text NOT NULL,
`mUser` text NOT NULL,
`mUser_id` int(11) NOT NULL,
`mSubject` text NOT NULL,
`mBody` text NOT NULL,
`mBelong` int(11) NOT NULL default '0',
`mChildren` int(11) NOT NULL default '0',
`mAdmin` smallint(1) NOT NULL default '0',
`mThread` int(11) NOT NULL default '0',
PRIMARY KEY (`mID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;



CREATE TABLE IF NOT EXISTS `frends` (
`id` int(11) NOT NULL auto_increment,
`uid` varchar(255) NOT NULL,
`fid` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `invs` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(11) NOT NULL,
`fname` varchar(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `links` (
`id` int(11) NOT NULL auto_increment,
`links` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL,
`text` text NOT NULL,
`author` varchar(11) NOT NULL default 'Admin',
PRIMARY KEY (`id`),
FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `novineshta` (
`id` int(11) NOT NULL auto_increment,
`zaglavie` varchar(255) NOT NULL,
`avtor` varchar(255) NOT NULL,
`idd` varchar(255) NOT NULL,
`content` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;



CREATE TABLE IF NOT EXISTS `pmessages` (
`title` varchar(255) NOT NULL default 'Untitled Message',
`message` text NOT NULL,
`touser` varchar(255) NOT NULL default '',
`from` varchar(255) NOT NULL default '',
`unread` varchar(255) NOT NULL default 'unread',
`date` date NOT NULL default '0000-00-00',
`id` int(15) NOT NULL auto_increment,
`reply` varchar(15) NOT NULL default 'no',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6490 ;



CREATE TABLE IF NOT EXISTS `raceip` (
`id` int(255) NOT NULL auto_increment,
`race_id` int(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3244 ;


CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(11) NOT NULL,
`namepro` varchar(11) NOT NULL default '0',
`namecolor` varchar(255) NOT NULL default 'ffffff',
`adminlvl` varchar(11) default '0',
`avatar` varchar(255) NOT NULL default 'images/avatars/0.gif',
`description` varchar(255) NOT NULL,
`age` varchar(11) NOT NULL,
`city` varchar(30) NOT NULL,
`skype` varchar(30) NOT NULL,
`timestamp` text NOT NULL,
`time` varchar(255) NOT NULL,
`pass` varchar(60) character set cp1251 collate cp1251_bulgarian_ci NOT NULL default '',
`mail` varchar(60) NOT NULL,
`lvl` tinyint(2) NOT NULL default '0',
`exp` int(11) NOT NULL default '0',
`money` int(11) NOT NULL default '10000',
`speed` int(255) NOT NULL default '46',
`acceleration` int(255) NOT NULL default '47',
`stability` int(255) NOT NULL default '47',
`power` int(11) NOT NULL default '25',
`points` int(11) NOT NULL default '1',
`cars` int(11) NOT NULL default '55',
`credits` int(11) NOT NULL default '10',
`training` int(11) default '10',
`weaponr` int(5) NOT NULL default '0',
`weaponl` int(5) NOT NULL default '0',
`weapong` int(5) NOT NULL default '0',
`bonus_turbo` int(11) NOT NULL default '0',
`bonus_nitrous` int(11) NOT NULL default '0',
`bonus_wheels` int(11) NOT NULL default '0',
`bonus_spoilers` int(11) NOT NULL default '0',
`bonus_generation` int(11) NOT NULL default '0',
`bonus_dampers` int(11) NOT NULL default '0',
`bonus_abs` int(11) NOT NULL default '0',
`wins` int(11) NOT NULL default '0',
`loses` int(11) NOT NULL default '0',
`drivercar` tinyint(1) NOT NULL default '0',
`fighter` tinyint(1) NOT NULL default '0',
`killer` tinyint(1) NOT NULL default '0',
`busy` tinyint(1) NOT NULL default '0',
`attacked` int(11) NOT NULL default '0',
`level` tinyint(1) NOT NULL default '0',
`jobs` int(11) NOT NULL default '0',
`nrg` int(3) NOT NULL default '100',
`maxnrg` int(3) NOT NULL default '100',
`bank` int(11) NOT NULL default '0',
`sex` varchar(11) character set cp1251 collate cp1251_bulgarian_ci NOT NULL default 'male',
`firm` varchar(11) default NULL,
`ip` varchar(244) default NULL,
`ban` int(22) default NULL,
`bandsc` varchar(255) NOT NULL default 'neqsna',
`sellcars` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `mail` (`mail`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=657 ;



CREATE TABLE IF NOT EXISTS `usersip` (
`id` int(11) NOT NULL,
`users_id` int(11) NOT NULL,
`ip` varchar(60) NOT NULL,
`time` int(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `vesnik` (
`id` int(11) NOT NULL auto_increment,
`zaglavie` varchar(255) NOT NULL,
`avtor` varchar(255) NOT NULL,
`idd` varchar(255) NOT NULL,
`content` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;



CREATE TABLE IF NOT EXISTS `workip` (
`id` int(255) NOT NULL auto_increment,
`work_id` int(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1601 ;



CREATE TABLE IF NOT EXISTS `podarakip` (
`id` int(32) NOT NULL auto_increment,
`podarak_id` varchar(233) NOT NULL,
`ip` varchar(233) NOT NULL,
`time` varchar(233) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
Благодаря предварително :)
 
Прегледах заявките в които има sellcars и те вадят само от таблица users.
Дал си структурата на users и ясно се вижда че има поле sellcars.
На кой ред ти дава грешката поне ?
И също провери в таблицата users да не би без да искаш да си изтрил полето sellcars или да не се е добавило заради някакъв проблем.
 
Липсва ти таблицата Sellcars потарси в форума откадето си изтеглил системата :P
 
Откога

Unknown column 'sellcars' in 'field list'
Увеличете...

Означава че я няма таблицата ?
Ако не си на ясно този проблем казва че колона/поле с име sellcars не съществува в списъка с колони/полета на таблицата ( в случая users ).

;)
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе