function GetProductInfo($id,$line=null,$paramfunc = null)
{
global $par;
if ($line == null){
$sql = "SELECT * FROM $par->objectstable WHERE id=$id AND hide=0";
$res = mysql_query($sql);
$line = mysql_fetch_array($res,MYSQL_ASSOC);
}
$url = GetSeoUrl('tovar',$line['id'],$line);
$instr = '(-1';
$tmp = explode(":",$line["colors"]);
foreach ($tmp as $value) {
if($value!="")
$instr.=",".$value;
}
$instr.= ")";
$sql3 = "SELECT * FROM $par->fotorobjtable WHERE `title` IN $instr AND hide=0 GROUP BY `title` ORDER BY prior";
$res3 = mysql_query($sql3);
while ($line3 = mysql_fetch_array($res3,MYSQL_ASSOC)){
$color = (int)$line3['title'];
$sql4 = "SELECT * FROM $par->colorstable WHERE `id`=$color AND hide=0";
$res4 = mysql_query($sql4);
$line4 = mysql_fetch_array($res4, MYSQL_ASSOC);
$colors[] = array('id' => $line4['id'], 'color' => $line4['color']);
}
if (isset($colors) && !empty($colors))
$active_color = strval($colors[0]['id']);
$parent = $line['id'];
$sql2 = "SELECT * FROM $par->fotorobjtable WHERE `reportid`=$parent";
if (isset($active_color))
$sql2 .= " AND `title`='$active_color'";
$sql2 .= " ORDER by prior";
$res2 = mysql_query($sql2);
while ($line2 = mysql_fetch_array($res2,MYSQL_ASSOC)){
$img[] = img_check("products/product_",$line2['id']);
}
$size = size_explode($line['id']);
if (isset($colors) && !empty($colors))
$productitem = array('id' => $line['id'], 'artikul' => $line['artikul'], 'url' => $url, 'title' => $line['title'], 'text' => $line['text'], 'price' => $line['price'], 'colors' => $colors, 'size' => $size);
else
$productitem = array('id' => $line['id'], 'artikul' => $line['artikul'], 'url' => $url, 'title' => $line['title'], 'text' => $line['text'], 'price' => $line['price'], 'size' => $size);
$productitem['img'] = $img;
return $productitem;
}
function GetArticlesItem($id,$line=null,$params=null)
{
global $par,$varsline;
if($line==null)
{
$sql="SELECT * FROM $par->news2table WHERE `id`=$id AND `hide`=0";
$res = mysql_query($sql);
$line = mysql_fetch_array($res,MYSQL_ASSOC);
}
$line = LangProcess($line);
if(isset($line['titleh1']) && $line['titleh1']!='') $line['title']=$line['titleh1']; else $line['title']=$line['title'];
$line['item_url'] = GetSeoUrl('articles',$line['id'],$line);
$line['img'] = img_check("articles/article_",$line['id']);
return $line;
}
$sql2 = "SELECT title, color FROM $par->colorstable WHERE id=$item[color]";
$res2 = mysql_query($sql2);
if ($line2 = mysql_fetch_array($res2,MYSQL_ASSOC)){
$sql3 = "SELECT id FROM fotorobj WHERE title=$item[color] AND reportid=$item[id]";
$res3 = mysql_query($sql3);
$line3 = mysql_fetch_array($res3,MYSQL_ASSOC);
$img = img_check("products/product_",$line3['id']);
$compare_arr[] = array('id' => $line['id'], 'url' => $url, 'title' => $line['title'], 'price' => $line['price'], 'img' => $img, 'count' => $item['count'], 'color' => $line2['title'], 'color_code' => $line2['color'], 'length' => $item['length'], 'breadth' => $item['breadth']);
}
else{
$sql3 = "SELECT id FROM fotorobj WHERE reportid=$item[id]";
$res3 = mysql_query($sql3);
$line3 = mysql_fetch_array($res3,MYSQL_ASSOC);
$img = img_check("products/product_",$line3['id']);
$compare_arr[] = array('id' => $line['id'], 'url' => $url, 'title' => $line['title'], 'price' => $line['price'], 'img' => $img, 'count' => $item['count'], 'length' => $item['length'], 'breadth' => $item['breadth']);
}
}
}
}
if(isset($_SESSION['loguserid'])){
$user_id = (int)$_SESSION['loguserid'];
$sql = "SELECT * FROM users WHERE id=$user_id";
$res = mysql_query($sql);
$log_user = mysql_fetch_array($res, MYSQL_ASSOC);
}
$headerarr['basket_valuta'] = 'руб.';
$cat_arr = Array();
$sql="SELECT * FROM $par->categorytable WHERE `hide`=0 ORDER by prior";
$res = mysql_query($sql);
while($line = mysql_fetch_array($res,MYSQL_ASSOC)){
$img = img_check("cat/cat_",$line['id']);
$url = GetSeoUrl('cat',$line['id'],$line);
$line = LangProcess($line);
$cat_arr[] = Array('title'=>$line['title'],'img'=>$img,'url'=>$url);
}
$_logic['cat_arr'] = $cat_arr;
///////////////////
$slider_arr = Array();
$sql="SELECT * FROM $par->news1table WHERE `hide`=0 ORDER by prior";
$res = mysql_query($sql);
while($line = mysql_fetch_array($res,MYSQL_ASSOC)){
$img = img_check("novelty/slide_novelty_",$line['id']);
$url = GetSeoUrl('novelty',$line['id'],$line);
$line = LangProcess($line);
$slider_arr[] = Array('title'=>$line['title'],'img'=>$img,'caption'=>$line['caption'],'url'=>$url,'left'=>$line['position-left'],'right'=>$line['position-right'],'top'=>$line['position-top'],'bottom'=>$line['position-bottom']);
}
$_logic['slider_arr'] = $slider_arr;
}
$act = $_REQUEST['act'];
if ($act == "select_color"){
if (isset($_REQUEST['id']))
$id = $_REQUEST['id'];
if (isset($_REQUEST['parent']))
$parent = $_REQUEST['parent'];
else
exit();
$active_color = $id;
$sql2 = "SELECT * FROM $par->fotorobjtable WHERE `reportid`=$parent AND `title`='$active_color' ORDER by prior";
$res2 = mysql_query($sql2);
while ($line2 = mysql_fetch_array($res2,MYSQL_ASSOC)){
$img[] = img_check("products/product_",$line2['id']);
}
$i = 0;
$reply = "";
$reply = "<div class='product_slider'>";
foreach ($img as $key => $item) {
$i++;
$reply .=
"
<div data-slick-index='$i'>
<img src='$item' />
</div>
";
}
$reply .= "</div>";
}
$_logic['gallery_arr'] = $gallery_arr;
$sql2 = "SELECT COUNT(id) AS ccc FROM $par->fototable WHERE `hide`=0 AND (`tip`=$_SESSION[thema] OR `tip`=1)";
$linkstr = GetSeoUrl('gallery',0);
$_logic['content']['pagerarr']=GetPager($sql2,$linkstr,$newsinpage);
}else{
$gallery_arr=Array();
$sql="SELECT * FROM $par->fototable WHERE `hide`=0 AND `id`=$id";
$res = mysql_query($sql);
if($line = mysql_fetch_array($res,MYSQL_ASSOC)){
$fotos = Array();
$sql2="SELECT * FROM $par->fotortable WHERE `reportid`=$line[id] order by prior";
$res2 = mysql_query($sql2);
while($line2 = mysql_fetch_array($res2,MYSQL_ASSOC)){
$fname = img_check("gallery_sm_",$line2['id']);
$fnamebig = img_check("gallery_bg_",$line2['id']);
$fotos[] = Array('fname'=>$fname,'fnamebig'=>$fnamebig,'title'=>$line2['title']);
}
$line['title'] = titleh1_check($line);
$_logic['gallery_arr'] = Array('title'=>$line['title'],'fotos'=>$fotos,'backurl'=>GetSeoUrl($act,0));
}
//debug($_logic['gallery_arr']);
}
?>
<?
$_logic['pageitem']=Array();
$sql = "SELECT * FROM $par->topmenutable WHERE url='/contacts'";
$res = mysql_query($sql);
$line = mysql_fetch_array($res,MYSQL_ASSOC);
$line = LangProcess($line);
if(isset($line['titleh1']) && $line['titleh1']!='') $line['title']=$line['titleh1']; else $line['title']=$line['title'];
$line['text'] = ReplaceSeolinks($line['text']);
$_logic['pageitem'] = $line;
if ($act=='contacts'){
$stores = array();
$sql = "SELECT * FROM $par->storestable WHERE hide=0";
$res = mysql_query($sql);
while ($line = mysql_fetch_array($res, MYSQL_ASSOC)){
$img = img_check("stores/store_",$line['id']);
$stores[] = array('title' => $line['title'], 'img' => $img, 'address' => $line['address'], 'lng' => $line['lng'], 'lat' => $line['lat'], 'zoom' => $line['zoom'], 'phones' => $line['phones'], 'email' => $line['email'], 'work_time' => $line['work_time']);
}
}
?>
<?php
$cat_arr = array();
$sql = "SELECT * FROM {$par->categorytable} WHERE `hide`=0 ORDER by prior";
$res = mysql_query($sql);
while ($line = mysql_fetch_array($res, MYSQL_ASSOC)) {
$img = img_check("cat/cat_", $line['id']);
$url = GetSeoUrl('cat', $line['id'], $line);
$line = LangProcess($line);
$cat_arr[] = array('id' => $line['id'], 'title' => $line['title'], 'img' => $img, 'url' => $url);
}
$_logic['cat_arr'] = $cat_arr;
