Файл: m/new_goods.php
Строк: 32
<?php
/*Автор - TheAlex(Саня)
Все права принадлежат компании CreaWap)*/
$time=time()-864000;
$con=mysql_num_rows(mysql_query("SELECT * FROM `shop_goods`"));
$cnm=mysql_num_rows(mysql_query("SELECT * FROM `shop_goods` WHERE `time`>".$time.""));
echo '<div class="title"><a href="/m">Магазин</a> ('.$con.' <font color="red">+ '.$cnm.'</font>)</div>';
$good = mysql_query("SELECT * FROM `shop_goods` ORDER BY `id` DESC LIMIT 0, 3");
while($g = mysql_fetch_assoc($good))
{
$g['description']=substr($g['description'], 0, 200);
$g['description']=rtrim($g['description'], "!,.-");
echo '<div class="podmenu">';
if(mysql_num_rows(mysql_query("SELECT * FROM `shop_screen` WHERE `goods`='".$g['id']."'"))==0){
echo '<img src="/images/m/no-scrin.gif" rel="lightbox" alt="*" class="image" align="left" style="margin: 1px 8px 0px 0px; width: 70px; height: 70px;">';
}else{
$scr=mysql_result(mysql_query("SELECT `img` FROM `shop_screen` WHERE `goods`='".$g['id']."' LIMIT 1"), 0);
echo '<img src="/files/m/scr/'.$scr.'" rel="lightbox" alt="*" class="image" align="left" style="margin: 1px 8px 0px 0px; width: 70px; height: 70px;">';
}
echo '<a href="/m/tovar.php?id='.$g['id'].'">'.$g['name'].'</a> (<b><font color="green">'.$g['price'].' р.</font></b>)<br/>
'.$g['description'].'...<br/>';
if(mysql_num_rows(mysql_query("SELECT * FROM `shop_buy` WHERE `id_goods`='".$g['id']."'"))<$g['amount']){
if($user['id']!=$g['id_us']){
echo '<a href="/m/buy.php?id='.$g['id'].'"><img src="/images/m/dollar.png"></a>';
}
}
if($user['id']!=$g['id_us']){
echo '<a href="/m/tovar.php?id='.$g['id'].'&cart"><img src="/images/m/cart.png"></a>';
}
echo '<br/><br/><br/></div>';
}
?>