Обучение/Помощь новичкам | Рандом
Вытащил в общем то рандом с БТ
Так вот что в нем не так? Вытягивает шмотки только под id 1 и 2...
________
посл. ред. 10.08.2017 в 04:02; всего 1 раз(а); by xLife
<?
$w_chanse = rand(1,100);
$chanse = rand(1,100);
if($chanse < $w_chanse) {
$w = mysql_query('SELECT * FROM `item` WHERE `id` <49 ORDER BY RAND() LIMIT 1');
$w = mysql_fetch_array($w);
if(mysql_result(mysql_query('SELECT COUNT(*) FROM `inv` WHERE `place` = "0" AND `user` = "'.$user['id'].'"'),0) + 1 < 20) {
mysql_query('INSERT INTO `inv` (`user`,
`item`,
`bonus`,
`str`,
`vit`,
`agi`,
`def`) VALUES ("'.$user['id'].'",
"'.$w['id'].'",
"'.$w['bonus'].'",
"'.$w['str'].'",
"'.$w['vit'].'",
"'.$w['agi'].'",
"'.$w['def'].'")');
$w_id = mysql_insert_id();
$w = mysql_query('SELECT * FROM `inv` WHERE `id` = "'.$w_id.'"');
$w = mysql_fetch_array($w);
$item = mysql_query('SELECT * FROM `items` WHERE `id` = "'.$w['item'].'"');
$item = mysql_fetch_array($item);
mysql_query('UPDATE `inv` SET `quality` = '.$item['quality'].' WHERE `id` = '.$w_id);
?>
<div class="header-title">
<font color='red'>Новая вещь в <a href='/inv/bag/'><u>сумке</u></a>!</font><br/></div>
<?
switch($item['quality']) {
case 0:
$bonus = 0;
$quality = 'Простой';
$quality_color = "#908060";
break;
case 1:
$bonus = 5;
$quality = 'Обычный';
$quality_color = "#60c030";
break;
case 2:
$bonus = 10;
$quality = 'Редкий';
$quality_color = "#6090c0";
break;
case 3:
$bonus = 15;
$quality = 'Эпический';
$quality_color = "#c060f0";
break;
case 4:
$bonus = 20;
$quality = 'Легенарный';
$quality_color = "#f06000";
break;
case 5:
$bonus = 50;
$quality = 'Божественный';
$quality_color = "#909090";
break;
case 6:
$bonus = 65;
$quality = 'Сверх Божественный';
$quality_color = "#909090";
break;
}
?>
<div align='center'>
<table cellpadding='0' cellspacing='0'>
<tr>
<td><img src='/images/items/<?=$item['id']?>.png' alt='*'/></td>
<td valign='top' align='left' style='padding-left: 5px;'><a href='/item/<?=$w['id']?>/'><?=$item['name']?></a>
<br/>
<small><small>
<font style="color: <?=$quality_color?>"><?=$quality?> [<?=$w['bonus']?>/<?=$bonus?>]</font>
<?
if($user['w_'.$item['w']] != 0) {
$equip_item = mysql_query('SELECT * FROM `inv` WHERE `id` = "'.$user['w_'.$item['w']].'"');
$equip_item = mysql_fetch_array($equip_item);
if(($row['str'] + $w['vit'] + $w['agi'] + $w['def']) - ($equip_item['str'] + $equip_item['vit'] + $equip_item['agi'] + $equip_item['def']) > 0) {
?>
<font color='#30c030'>+<?=($w['str'] + $w['vit'] + $w['agi'] + $w['def']) - ($equip_item['_str'] + $equip_item['vit'] + $equip_item['agi'] + $equip_item['def'])?></font>
<?
}
}
else
{
?>
<font style="color: #30c030">+<?=($w['str'] + $w['vit'] + $w['agi'] + $w['def'])?></font>
<?
}
?>
</small></small></td></tr></table>
</div>
<?
}
}
?>
$w_chanse = rand(1,100);
$chanse = rand(1,100);
if($chanse < $w_chanse) {
$w = mysql_query('SELECT * FROM `item` WHERE `id` <49 ORDER BY RAND() LIMIT 1');
$w = mysql_fetch_array($w);
if(mysql_result(mysql_query('SELECT COUNT(*) FROM `inv` WHERE `place` = "0" AND `user` = "'.$user['id'].'"'),0) + 1 < 20) {
mysql_query('INSERT INTO `inv` (`user`,
`item`,
`bonus`,
`str`,
`vit`,
`agi`,
`def`) VALUES ("'.$user['id'].'",
"'.$w['id'].'",
"'.$w['bonus'].'",
"'.$w['str'].'",
"'.$w['vit'].'",
"'.$w['agi'].'",
"'.$w['def'].'")');
$w_id = mysql_insert_id();
$w = mysql_query('SELECT * FROM `inv` WHERE `id` = "'.$w_id.'"');
$w = mysql_fetch_array($w);
$item = mysql_query('SELECT * FROM `items` WHERE `id` = "'.$w['item'].'"');
$item = mysql_fetch_array($item);
mysql_query('UPDATE `inv` SET `quality` = '.$item['quality'].' WHERE `id` = '.$w_id);
?>
<div class="header-title">
<font color='red'>Новая вещь в <a href='/inv/bag/'><u>сумке</u></a>!</font><br/></div>
<?
switch($item['quality']) {
case 0:
$bonus = 0;
$quality = 'Простой';
$quality_color = "#908060";
break;
case 1:
$bonus = 5;
$quality = 'Обычный';
$quality_color = "#60c030";
break;
case 2:
$bonus = 10;
$quality = 'Редкий';
$quality_color = "#6090c0";
break;
case 3:
$bonus = 15;
$quality = 'Эпический';
$quality_color = "#c060f0";
break;
case 4:
$bonus = 20;
$quality = 'Легенарный';
$quality_color = "#f06000";
break;
case 5:
$bonus = 50;
$quality = 'Божественный';
$quality_color = "#909090";
break;
case 6:
$bonus = 65;
$quality = 'Сверх Божественный';
$quality_color = "#909090";
break;
}
?>
<div align='center'>
<table cellpadding='0' cellspacing='0'>
<tr>
<td><img src='/images/items/<?=$item['id']?>.png' alt='*'/></td>
<td valign='top' align='left' style='padding-left: 5px;'><a href='/item/<?=$w['id']?>/'><?=$item['name']?></a>
<br/>
<small><small>
<font style="color: <?=$quality_color?>"><?=$quality?> [<?=$w['bonus']?>/<?=$bonus?>]</font>
<?
if($user['w_'.$item['w']] != 0) {
$equip_item = mysql_query('SELECT * FROM `inv` WHERE `id` = "'.$user['w_'.$item['w']].'"');
$equip_item = mysql_fetch_array($equip_item);
if(($row['str'] + $w['vit'] + $w['agi'] + $w['def']) - ($equip_item['str'] + $equip_item['vit'] + $equip_item['agi'] + $equip_item['def']) > 0) {
?>
<font color='#30c030'>+<?=($w['str'] + $w['vit'] + $w['agi'] + $w['def']) - ($equip_item['_str'] + $equip_item['vit'] + $equip_item['agi'] + $equip_item['def'])?></font>
<?
}
}
else
{
?>
<font style="color: #30c030">+<?=($w['str'] + $w['vit'] + $w['agi'] + $w['def'])?></font>
<?
}
?>
</small></small></td></tr></table>
</div>
<?
}
}
?>
Так вот что в нем не так? Вытягивает шмотки только под id 1 и 2...
________
посл. ред. 10.08.2017 в 04:02; всего 1 раз(а); by xLife
XxxDIABLOxxX , нехрена не понял))