Да имаш право 35 пъти на ден

racer

Registered
Здравейте от ново ! ще може ли да направите кода да не е на минути а максимум 35 състезания за деня благодаря предварително ето ви кода

Код:
<?php
if($_SESSION['name']) {

$name = $_SESSION['name'];
$qq=mysql_query("SELECT * FROM `users` WHERE `name` = '$name'") or die(mysql_error());
$row=mysql_fetch_array($qq);
$nr=$row['nrg'];
if ($nr < 11)
{
echo "<table class='nqkvo_kool2' width='56%' align='center'>
<td class='nqkvo_kool2' rowspan='4' width='5%' align='center'>
<img src='images/task_error.gif' width='33' border='0' height='33'>
</td>
<td width='50%' align='center'><span style='font-weight: bold;'>Нямаш достатачно енергия !<br>Зареди от <a href='index.php?a=rest'>ТУК</a></span></td>
</table>";
}
else
{


$user_id = $_GET['id'];
$query = "SELECT * FROM `users` WHERE `id`='$user_id'";
$result = mysql_query($query) OR die(mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC) OR die(mysql_error());
$cars1 = $row['cars'];

if($cars1 < 1) {
echo "<table class='nqkvo_kool2' width='56%' align='center'>
<td class='nqkvo_kool2' rowspan='4' width='5%' align='center'>
<img src='images/task_error.gif' width='33' border='0' height='33'>
</td>
<td width='50%' align='center'><span style='font-weight: bold;'>Този играч няма кола, и не може да се състезаваш срещу него.!</span></td>
</table>";
}
else {
//Ако $cars e по-голямо от 50 кода, който ще се изпълнява!


$cars2 = $my['cars'];
if ($cars2 < 1)
{
echo "<table class='nqkvo_kool2' width='56%' align='center'>
<td class='nqkvo_kool2' rowspan='4' width='5%' align='center'>
<img src='images/task_error.gif' width='33' border='0' height='33'>
</td>
<td width='50%' align='center'><span style='font-weight: bold;'>Трябва да имаш кола за да може да правиш DRAG !</span></td>
</table>";
}
else
{

if(isset($_GET['id'])) {
$name = $_SESSION['name'];
$id = htmlspecialchars($_GET['id']);
$time = time();
$sqla = "SELECT * FROM users WHERE name = '$name'";
$sqld = "SELECT * FROM users WHERE id = '$id'";
$doa = mysql_query($sqla);
$dod = mysql_query($sqld);
$rowa = mysql_fetch_array($doa);
$rowd = mysql_fetch_array($dod);
$victimname = $rowd['name'];
$attackername = $rowa['name'];
$speed = $row['speed'];
$acceleration = $row['acceleration'];
$stability = $row['stability'];
$bonus_turbo = $row['bonus_turbo'];
$bonus_nitrous = $row['bonus_nitrous'];
$bonus_wheels = $row['bonus_wheels'];
$bonus_spoilers = $row['bonus_spoilers'];
$bonus_generation = $row['bonus_generation'];
$bonus_dampers = $row['bonus_dampers'];
$bonus_abs = $row['bonus_abs'];
$power = $row['power'];
$att = ((($rowa['power'] * (1 + ($rowa['fighter'] * 0.1))) + ($rowa['speed'] + $rowa['acceleration'] + $rowa['stability'] + $rowa['bonus_turbo'] + $rowa['bonus_nitrous'] + $rowa['bonus_wheels'] + $rowa['bonus_spoilers'] + $rowa['bonus_generation'] + $rowa['bonus_dampers'] + $rowa['bonus_abs'])) * (1 + ($rowa['killer'] * 0.1))) * ($ba / 100);
$def = ((($rowd['power'] * (1 + ($rowd['fighter'] * 0.1))) + ($rowd['speed'] + $rowd['acceleration'] + $rowd['stability'] + $rowd['bonus_turbo'] + $rowd['bonus_nitrous'] + $rowd['bonus_wheels'] + $rowd['bonus_spoilers'] + $rowd['bonus_generation'] + $rowd['bonus_dampers'] + $rowd['bonus_abs'])) * (1 + ($rowd['killer'] * 0.1))) * ($bd / 100);

$ip=$_SERVER['REMOTE_ADDR'];
$time = time() +300;
$query2=mysql_query("SELECT * FROM `raceip` WHERE `race_id` = '$id'") or die(mysql_error());
$row2=mysql_num_rows($query2);
$row3=mysql_fetch_array($query2);

if ($row2 >= 1 )
{
$ends = $row3['time'];
$now = time();
$end = $ends - $now;


echo "<table class='nqkvo_kool2' width='36%' align='center'>
<td class='nqkvo_kool2' rowspan='4' width='5%' align='center'>
<img src='images/task_error.gif' width='33' border='0' height='33'>
</td>
<td width='50%' align='center'><span style='font-weight: bold;'>Този играч е в бокса и ще може да правиш драг срещу него след:</b><center><b><div id='bxx' ></div></b></center>";
$r=$end;
?>
<script type="text/javascript">
v=new Date();
var bxx=document.getElementById('bxx');
function t(){
n=new Date();
ss=<?php echo $r; ?>;
s=ss-Math.round((n.getTime()-v.getTime())/1000.);
m=0;
h=0;
if(s<0){
bxx.innerHTML='Готово - вече може да се състезаваш отново!';
}else{
if(s>59){m=Math.floor(s/60);s=s-m*60;}
if(m>59){h=Math.floor(m/60);m=m-h*60;}
if(s<10){s="0"+s}
if(m<10){m="0"+m}
bxx.innerHTML=h+':'+m+':'+s+'';}
window.setTimeout("t();",999);
}
window.onload=t;

</script>
<?
}
else
{
$ba = rand(80, 120);
$bd = rand(80, 120);
$att = ((($rowa['power'] * (1 + ($rowa['fighter'] * 0.1))) + ($rowa['speed'] + $rowa['acceleration'] + $rowa['stability'] + $rowa['bonus_turbo'] + $rowa['bonus_nitrous'] + $rowa['bonus_wheels'] + $rowa['bonus_spoilers'] + $rowa['bonus_generation'] + $rowa['bonus_dampers'] + $rowa['bonus_abs'])) * (1 + ($rowa['killer'] * 0.1))) * ($ba / 100);
$def = ((($rowd['power'] * (1 + ($rowd['fighter'] * 0.1))) + ($rowd['speed'] + $rowd['acceleration'] + $rowd['stability'] + $rowd['bonus_turbo'] + $rowd['bonus_nitrous'] + $rowd['bonus_wheels'] + $rowd['bonus_spoilers'] + $rowd['bonus_generation'] + $rowd['bonus_dampers'] + $rowd['bonus_abs'])) * (1 + ($rowd['killer'] * 0.1))) * ($bd / 100);

$insert=mysql_query("INSERT INTO `raceip` (`id`, `race_id`, `ip`, `time`) VALUES ('', '$id', '$ip', '$time')") or die(mysql_error());

if ($insert)
{
echo "";
}

if($rowa['name'] == $rowd['name']) { echo "<table class='nqkvo_kool2' width='56%' align='center'>
<td class='nqkvo_kool2' rowspan='4' width='5%' align='center'>
<img src='images/task_error.gif' width='33' border='0' height='33'>
</td>
<td width='50%' align='center'><span style='font-weight: bold;'>Не може да се състезавате срещу себе си!</span></td>
</table>"; }
else if(mysql_num_rows($dod) < 1) { echo "Друг играч се е състезавал срещу него.!"; }
else if($att > $def && $rowa['nrg'] >= 10) {
$money = ($rowd['money']*0.01);
$power = ($rowd['power']*0.01);
$money1 = $rowa['money'] + ($rowd['money']*0.01);
$money2 = $rowd['money'] - ($rowd['money']*0.01);
$power1 = $rowa['power'] + ($rowd['power']*0.01);
$power2 = $rowd['power'] - ($rowd['power']*0.01);
$query1 = "UPDATE users SET money = '$money1', power = '$power1', wins = wins + 1, nrg = nrg - 10 WHERE name = '$name'";
$query2 = "UPDATE users SET money = '$money2', power = '$power2', loses = loses + 1 WHERE id = '$id'";
$do = mysql_query("INSERT INTO `pmessages` ( `title` , `message` , `touser` , `from` , `unread` ,
`date`, `reply`) VALUES
('Атака $attackername', 'Вие бяхте атакуван от $attackername и <b>Загубихте</b> $money пари и $power опит.', '$victimname', 'Системата',
'unread', NOW(), 'yes')");
mysql_query($query1);
mysql_query($query2);
echo "<table class='nqkvo_kool' width='36%' align='center'>
<td class='nqkvo_kool' rowspan='4' width='5%' align='center'>
<img src='images/task_done.gif' width='33' border='0' height='33'>
</td>
<td width='50%' align='center'><span style='font-weight: bold;'>Вие спечелихте състезанието!<br><br>Спечелихте $power <img src='images/attempt.gif'> и $money <img src='images/money.gif'></span></td>
</table>"; }

else if($att < $def && $rowa['nrg'] >= 10) {
$money = ($rowa['money']*0.01);
$power = ($rowa['power']*0.01);
$money1 = $rowd['money'] + ($rowa['money']*0.01);
$money2 = $rowa['money'] - ($rowa['money']*0.01);
$power1 = $rowd['power'] + ($rowa['power']*0.01);
$power2 = $rowa['power'] - ($rowa['power']*0.01);
$query1 = "UPDATE users SET money = '$money1', power = '$power1', wins = wins + 1 WHERE id = '$id'";
$query2 = "UPDATE users SET money = '$money2', power = '$power2', loses = loses + 1, nrg = nrg - 10 WHERE name = '$name'";
$query3 = "INSERT INTO pmessages VALUES ('Атака $attackername', 'Вие бяхте атакуван от $attackername и <b>Спечелихте</b> $money пари и $power опит.', '$victimname', 'Системата', 'unread', 'NOW()', '', 'no')";
$do = mysql_query("INSERT INTO `pmessages` ( `title` , `message` , `touser` , `from` , `unread` ,
`date`, `reply`) VALUES
('Атака $attackername', 'Вие бяхте атакуван от $attackername и <b>Спечелихте</b> $money пари и $power опит.', '$victimname', 'Системата',
'unread', NOW(), 'yes')");
mysql_query($query1);
mysql_query($query2);
echo "<table class='nqkvo_kool2' width='36%' align='center'>
<td class='nqkvo_kool2' rowspan='4' width='5%' align='center'>
<img src='images/task_error.gif' width='33' border='0' height='33'>
</td>
<td width='50%' align='center'><span style='font-weight: bold;'>Загубихте $power <img src='images/attempt.gif'> и $money <img src='images/money.gif'></span></td>
</table>";}}} else {
echo "<form action='' method='POST'>Име:<br>"
."<input type='text' name='name'><br>"
."<input type='submit' name='submit' value='Търси'></form>";}
if(isset($_POST['submit'])) {
$victim = htmlspecialchars($_POST['name']);
$time = time();
$sql = "SELECT id FROM users WHERE name LIKE '$victim'";
$do = mysql_query($sql); $row = mysql_fetch_array($do); $id = $row['id'];
echo "<br><a href=?a=battle&id=$id>Състезавай се срещу $victim</a>"; }}}}} else { echo 'Не си логнат'; } ?>
 
Трябва да имаш поле в таблицата където се записват резултатите. Примерно sastezaniq и селд всяко състезание си я ъпдейтваш и правиш после един if($sastezaniq >= 35){ echo "Не можеш да се състезаваш повече"; } else { //кода ти }



Дай си структурата на базата и ще се опитам да ти го направя :)
 
-- --------------------------------------------------------
--
-- Table structure for table `ban`
--

CREATE TABLE IF NOT EXISTS `ban` (
`id_ban` int(11) NOT NULL,
`ip` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ban`
--

INSERT INTO `ban` (`id_ban`, `ip`) VALUES
(1, '94.156.137.67');

-- --------------------------------------------------------

--
-- Table structure for table `bgtop`
--

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

--
-- Dumping data for table `bgtop`
--


-- --------------------------------------------------------

--
-- Table structure for table `daltochka`
--

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 ;

--
-- Dumping data for table `daltochka`
--


-- --------------------------------------------------------

--
-- Table structure for table `dragip`
--

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 ;

--
-- Dumping data for table `dragip`
--


-- --------------------------------------------------------

--
-- Table structure for table `firms`
--

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 ;

--
-- Dumping data for table `firms`
--


-- --------------------------------------------------------

--
-- Table structure for table `forumtutorial_posts`
--

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 ;

--
-- Dumping data for table `forumtutorial_posts`
--


-- --------------------------------------------------------

--
-- Table structure for table `forum_messages`
--

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 ;

--
-- Dumping data for table `forum_messages`
--

INSERT INTO `forum_messages` (`mID`, `mDate`, `mUser`, `mUser_id`, `mSubject`, `mBody`, `mBelong`, `mChildren`, `mAdmin`, `mThread`) VALUES
(1, '28/03/2010', 'ching', 2282, 'Äî àäìèíà!!!Çà ñìñ-ñè!!!Âàæíî!!!', 'Èñêàì äà ïîïèòàì àäìèíà çàùî êàòî ïóñíàõ ñìñ çà 400 000 ïàðè íå ãè ïîëó÷èõ,à ïîëó÷èõ ñàìî òîâà-"Âàøèÿò êîä å íåâàëèäåí.Îáúðíåòå ñå êúì àäìèíèñòðàòîðà íà ñàèòà."Ñúùîòî ïèøåøå è ñëåä êàòî ïðîáâàõ 3 ïúòè äà ñòàíà ïðî-ïàê ìè èçïèñâàøå ñúùîòî.Ìîëÿ àäìèíà äà îáúðíå âíèìàíèå íà Ïîñòà Ìè è äà ïîëó÷à òîâà çà êîåòî ñúì ïóñíàë ñìñ-è.', 0, 2, 0, 2),
(2, '28/03/2010', 'tuning318', 759, 'Íîâà âåðñèÿ íà gorata | gorata. net16. net/', 'Íîâà âåðñèÿ íà gorata | gorata. net16. net/', 0, 2, 0, 6),
(3, '30/03/2010', 'Mrafkata', 1, 'n/a', 'Äà òå ïîïèòàì ïðåäè êîëêî âðåìå ñè ïðàòèë ÑÌÑ-òå ?', 1, 0, 0, 2),
(4, '30/03/2010', 'killer90', 2155, 'KLASACIQ!?', 'ZA6TO KLASACIQTA E VE4E PO TO4KI A NE PO POBEDI?VTORI VYPROS:ZA6TO NE MOGA DA SI KA4VAM UMENIQTA?KAKVO DA PRAVQ SYBIRAM TO4KI NE KA4VAM NIKAKVO NIVO?', 0, 1, 0, 2),
(5, '31/03/2010', 'poisont', 2210, 'n/a', 'vlez v umeniq tam ti pshe kato sane stao ti svetla zvezda cakash i gotovo', 4, 0, 0, 2),
(6, '31/03/2010', 'poisont', 2210, 'n/a', 've4e stava\r\n', 1, 0, 0, 2),
(7, '31/03/2010', 'poisont', 2210, 'iskate li neshto novo v saita', 'ako iskate neshto novo imam hack za zrak prodavam za edna to4ka pak trqbva da mi napishe', 0, 2, 0, 2),
(8, '31/03/2010', 'poisont', 2210, 'n/a', 'kakvo e tova gorata gorata', 2, 0, 0, 6),
(9, '31/03/2010', 'poisont', 2210, 'ikate li hack', 'hacka e za edna to4ka na mene kris 2708 i poisohacka e za pari davati pari po 200', 0, 0, 0, 3),
(10, '01/04/2010', 'Loading', 265, 'plsss', 'posetete me tuk http://emotewar.info/=Loading ', 0, 0, 0, 1),
(11, '01/04/2010', 'Loading', 265, 'plsss', 'posetete me tuk http://emotewar.info/=Loading ', 0, 0, 0, 2),
(12, '01/04/2010', 'Loading', 265, 'plsss', 'posetete me tuk http://emotewar.info/=Loading ', 0, 0, 0, 3),
(13, '01/04/2010', 'Loading', 265, 'plsss', 'posetete me tuk http://emotewar.info/=Loading ', 0, 0, 0, 4),
(14, '01/04/2010', 'Loading', 265, 'plsss', 'posetete me tuk http://emotewar.info/=Loading ', 0, 0, 0, 5),
(15, '01/04/2010', 'Loading', 265, 'plsss', 'posetete me tuk http://emotewar.info/=Loading ', 0, 0, 0, 6),
(16, '02/04/2010', 'vasko.124', 1880, 'pro', 'noje da teglish podaryka si sled 2 4asa ane sled 5 4asa :):):):):):P:P:P:P:D:D', 0, 0, 0, 1),
(17, '02/04/2010', 'kris 2708', 944, 'n/a', 'blagodarq za haka poisont mersi mnogo\r\n', 7, 0, 0, 2),
(18, '03/04/2010', 'h0use_musii', 1265, 'do admina za sms i te ', 'pratih za 0,50 lv i mi se poqvi tova MIMIWKLE no ne za4ita koda pravilen pomogni afmin', 0, 0, 0, 2),
(19, '03/04/2010', 'kris 2708', 944, 'sms ', 'partih esemes i tam pisheshe zabravih koda ob4e kda go napisah na edin nestava da me zashtitava dadoh mo koda pak ne stava', 0, 0, 0, 4),
(20, '05/04/2010', 'biskooo', 866, 'n/a', 'i az tova pitam spamari takiva', 2, 0, 0, 6),
(21, '06/04/2010', 'stefan10', 661, '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@', '4al de\r\n', 0, 0, 0, 5),
(22, '09/04/2010', 'boi4o', 2330, 'vlezte pls ', 'http://zvyn.com/vote/boi4o95-349.html ', 0, 1, 0, 1),
(23, '09/04/2010', 'boi4o', 2330, 'vlezte pls', 'http://zvyn.com/vote/boi4o95-349.html ', 0, 0, 0, 5),
(24, '09/04/2010', 'boi4o', 2330, 'vlezte pls', 'http://zvyn.com/vote/boi4o95-349.html ', 0, 0, 0, 6),
(25, '09/04/2010', 'boi4o', 2330, 'vlezte pls', 'http://zvyn.com/vote/boi4o95-349.html ', 0, 0, 0, 4),
(26, '09/04/2010', 'boi4o', 2330, 'vlezte pls', 'http://zvyn.com/vote/boi4o95-349.html ', 0, 0, 0, 3),
(27, '09/04/2010', 'boi4o', 2330, 'vlezte pls', 'http://zvyn.com/vote/boi4o95-349.html ', 0, 0, 0, 2),
(28, '09/04/2010', 'desislav_vn', 2106, 'do koga e sezona ', 'pls kajete mi do koga e sezona pls', 0, 3, 0, 2),
(29, '11/04/2010', 'killer90', 2155, 'n/a', 'i az se interesuvam ot tova koga e kraq na sezona? ', 28, 0, 0, 2),
(30, '13/04/2010', 'dan1el', 417, 'n/a', 'az iskam hack', 7, 0, 0, 2),
(31, '14/04/2010', 'vasko.124', 1880, 'n/a', 'i az a shte se triqt li registraciitre', 28, 0, 0, 2),
(32, '18/04/2010', 'niki095', 69, 'prodavam si profila', 'nqkoi ako go iska dami pi6e LS ', 0, 0, 0, 1),
(33, '18/04/2010', 'asdftyy', 682, '!!!', 'http://emotewar.info/ !!!', 0, 0, 0, 1),
(34, '18/04/2010', 'asdftyy', 682, '!!!!', 'http://emotewar.info/', 0, 0, 0, 1),
(35, '18/04/2010', 'asdftyy', 682, 'àñäô', 'http://emotewar.info/', 0, 0, 0, 1),
(36, '18/04/2010', 'asdftyy', 682, '123', 'http://emotewar.info/', 0, 0, 0, 1),
(37, '18/04/2010', 'asdftyy', 682, 'õàõ', 'http://emotewar.info/', 0, 0, 0, 1),
(38, '18/04/2010', 'asdftyy', 682, 'Ðåãèñòúð òóê !', 'http://emotewar.info/', 0, 0, 0, 1),
(39, '18/04/2010', 'asdftyy', 682, 'http://emotewar.info/', 'http://emotewar.info/', 0, 0, 0, 1),
(40, '18/04/2010', 'asdftyy', 682, 'http://emotewar.info/', 'http://emotewar.info/', 0, 0, 0, 1),
(41, '18/04/2010', 'asdftyy', 682, 'http://emotewar.info/', 'http://emotewar.info/', 0, 0, 0, 1),
(42, '18/04/2010', 'asdftyy', 682, 'http://emotewar.info/', 'http://emotewar.info/', 0, 1, 0, 1),
(43, '20/04/2010', 'ALBERT', 190, 'n/a', 'http://zvyn.com/vote/GoolDy-2465.html', 22, 0, 0, 1),
(44, '26/04/2010', 'zidan_avas', 2616, 'n/a', 'haide da se saiozim\r\n', 42, 0, 0, 1),
(45, '26/04/2010', 'killer90', 2155, 'n/a', 'ehoo admna nqma li da otgovori6 minaha 3 sedmici ot kakto e pusnata temata mai qvno samo ni lyje6 a?', 28, 0, 0, 2),
(46, '11/05/2010', 'mecho kuh', 2673, 'xD', 'admine nemoga da namerq pravilata na igrata i nemoga da q razbera :S', 0, 0, 0, 2),
(47, '14/05/2010', 'g', 2684, 'g', 'g', 0, 2, 0, 3),
(48, '14/05/2010', 'g', 2684, 'n/a', 'g', 47, 0, 0, 3),
(49, '14/05/2010', 'g', 2684, 'n/a', 'ggggf\r\nggggf\r\nggggf\r\n\r\nggggf\r\nggggf\r\nggggf\r\n\r\nggggf\r\nggggf\r\nggggf', 47, 0, 0, 3),
(50, '23/05/2010', 'h0use_musii', 1265, 'vlezte molq vi', 'http://77mafia.info/l.php?id=98', 0, 0, 0, 6);

-- --------------------------------------------------------

--
-- Table structure for table `frends`
--

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 ;

--
-- Dumping data for table `frends`
--


-- --------------------------------------------------------

--
-- Table structure for table `invs`
--

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 ;

--
-- Dumping data for table `invs`
--


-- --------------------------------------------------------

--
-- Table structure for table `links`
--

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 ;

--
-- Dumping data for table `links`
--


-- --------------------------------------------------------

--
-- Table structure for table `news`
--

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 ;

--
-- Dumping data for table `news`
--


-- --------------------------------------------------------

--
-- Table structure for table `novineshta`
--

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 ;

--
-- Dumping data for table `novineshta`
--

INSERT INTO `novineshta` (`id`, `zaglavie`, `avtor`, `idd`, `content`) VALUES
(1, 'novo', 'poisont', '2210', 'iskam da slojite po hubavi koli da imat tuning i ti mesto da kopuvash shte q utungovash'),
(2, 'dda', 'kris 2708', '944', 'sasaglasen sam sas poisont'),
(3, 'ðàíãîâå', 'qqq', '1436', 'ìîæå â ñúþçèòå äà ñëîæèòå ðàíãîâå:÷ëåí,çàìåñòíèê øåô è äðóãè.ìîæå äà ñëîæèòå è îïèñàíèå è äà ìîæå äà ñå âíàñÿò ïàðè è äàñè òåãëèò àêî èìàø íóæäà íàïðèìåð äà òåãëèø ìàêñèìóì äî 2500 ïëñ íàïðàâåòå ãî'),
(4, 'ako moje ', 'djonka', '78', 'pove4e naprimer svobodni to4ki '),
(5, 'novo1', 'simsoneca', '2350', 'az iskam da slojite pove4e koli i tuning\r\n'),
(6, 'koli', 'niki095', '69', 'az iskam da si li4i tuninga na kolite :P i da ima da raboti6 nqkade da zima6 pove4e $'),
(8, 'Áàíêà', 'Jamaeca98', '2516', 'Àç ïðåäëàãàì â áàíêàòà äà èìà äà òåãëèì ïàðè.Êîãàòî âêàðàìå íÿêàêâè ïàðè âúâ áàíêàòà äà ñå óâèëè÷àâàò.Äà ñòàíå êàòî íà æèâî.');

-- --------------------------------------------------------

--
-- Table structure for table `pmessages`
--

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 ;

--
-- Dumping data for table `pmessages`
--


-- --------------------------------------------------------

--
-- Table structure for table `raceip`
--

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 ;

--
-- Dumping data for table `raceip`
--


-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `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,
`sellcars` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `mail` (`mail`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=646 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `namepro`, `namecolor`, `adminlvl`, `avatar`, `description`, `age`, `city`, `skype`, `timestamp`, `time`, `pass`, `mail`, `lvl`, `exp`, `money`, `speed`, `acceleration`, `stability`, `power`, `points`, `cars`, `credits`, `training`, `weaponr`, `weaponl`, `weapong`, `bonus_turbo`, `bonus_nitrous`, `bonus_wheels`, `bonus_spoilers`, `bonus_generation`, `bonus_dampers`, `bonus_abs`, `wins`, `loses`, `drivercar`, `fighter`, `killer`, `busy`, `attacked`, `level`, `jobs`, `nrg`, `maxnrg`, `bank`, `sex`, `firm`, `ip`, `ban`) VALUES
(645, 'Admindawdwa', '0', 'ffffff', '0', 'images/avatars/0.gif', '\r\nsfaasas', '8', '', '', '1275207255', '', 'a9cb31e46976451f4af7b16cfd000ef2', 'saasfsa@abv.bg', 0, 5, 10006, 46, 47, 47, 27, 1, 55, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 80, 100, 0, 'male', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `usersip`
--

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;

--
-- Dumping data for table `usersip`
--


-- --------------------------------------------------------

--
-- Table structure for table `vesnik`
--

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 ;

--
-- Dumping data for table `vesnik`
--


-- --------------------------------------------------------

--
-- Table structure for table `workip`
--

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 ;

--
-- Dumping data for table `workip`
--

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 ;
 
Значи направи си ново поле в users примерно duel

Във файла ти за състезания правиш една заявка след като се състезава
mysql_query(UPDATE users SET duel=duel+1 WHERE name="$name");

ПП: Ако не можеш ми дай кода на файла за състезанията
 

Back
Горе