Take: '.$pag_nums['to'].'
ALL GOODS:'.$goods_co['0'].'
Current Page:'.$current_page); $goods=mysql_query("SELECT * FROM project_goods WHERE cat='".addslashes($request['1'])."' AND (`sellscount`='0' OR `sales`<`sellscount`) LIMIT $pag_nums[from],$pag_nums[to]",$db); } else { $pag_nums=pag_nums($paginate,1,$goods_co['0']); $goods=mysql_query("SELECT * FROM project_goods WHERE cat='".addslashes($request['1'])."' AND (`sellscount`='0' OR `sales`<`sellscount`) LIMIT 0,$paginate",$db); } //GOODS LIST $gds=''; while($g=mysql_fetch_array($goods)) { $pic=explode('|',$g['pictures']); $decoded_pic_path = decode_str($pic[0],True); $anons=(mb_strlen($g['description'],'UTF-8')>15) ? trim(mb_substr($g['description'],0,15,'UTF-8')).'...':mb_substr($g['description'],0,15,'UTF-8'); $gds.='

'.mb_substr($g['tile'],0,22,'UTF-8').'

RUR '.$g['price'].'

'; } //PAGINATOR $last_page=(ceil($goods_co['0']/$paginate)); if(!empty($gds) AND $last_page>1) { $current_page=(($pag_nums['from']+$pag_nums['to'])/$paginate); $next_page=$current_page+1; $prev_page=$current_page-1; if(($prev_page-1)>1) { $lpag.="«"; } if($prev_page>1) { $lpag.="‹"; } if($current_page>1) { $lpag.="$prev_page"; } if($current_page<$last_page) { $rpag.="$next_page"; } if($next_page<$last_page) { $rpag.="›"; } if(($next_page+1)<$last_page) { $rpag.="»"; } } $cat['tile'] = iconv('windows-1251', 'utf-8', $cat['tile']); /*CALL TEMPLATE*/call_template('goods/cat_inside.html',$CONTEXT=Array( 'cat_tile'=>(mb_strlen($cat['tile'],'UTF-8')>15) ? trim(mb_substr($cat['tile'],0,15,'UTF-8')).'...':mb_substr($cat['tile'],0,15,'UTF-8'), 'cat_des'=>iconv('windows-1251','utf-8',$cat['des']), 'cat_id'=>$cat['id'], 'current_page'=>$current_page, 'paginator_l'=>$lpag, 'paginator_r'=>$rpag, 'cat_goods_list'=>(!empty($gds)) ? $gds:'В данной категории товаров не найдено!', )); break; case 'show_good'; /*VARS*/ $db = open_datebase_connection('DATEBASE#1'); $cat=mysql_fetch_array(mysql_query("SELECT * FROM project_categories WHERE id='".addslashes($request['1'])."'",$db)); $good=mysql_fetch_array(mysql_query("SELECT * FROM project_goods WHERE cat='".addslashes($request['1'])."' AND (`sellscount`='0' OR `sales`<`sellscount`) AND id='".addslashes($request['2'])."'",$db)); $owner=mysql_fetch_array(mysql_query("SELECT * FROM project_members WHERE id='".addslashes($good['owner'])."'",$db)); if(!$good) {$go_back=' Товар не найден, возвращаемся.';} else {$go_back='';} $pics=explode('|',$good['pictures']); foreach($pics as $key=>$path) { if(!empty($path)) { $slides.='

'; } } $comments=mysql_query("SELECT * FROM project_comments WHERE good='".$good['id']."'",$db); $cmz=''; while($comment=mysql_fetch_array($comments)) { $cmz.='

'.$comment['author'].''.$comment['comment_date'].'

'.$comment['text'].'

'; } @session_start(); if(isset($_SESSION['id']) AND isset($_SESSION['hash']) AND $user=mysql_fetch_array(mysql_query("SELECT * FROM `project_members` WHERE id='".$_SESSION['id']."' AND hash='".$_SESSION['hash']."'",$db)) OR $user['ip']==$_SERVER['REMOTE_ADDR'] AND $user['ip']==0) { $comment_form=' '; $send_mesBTN='href="/messages/write_to/{{owner_login}}"'; } else { $comment_form=' '; $send_mesBTN='onclick="alert(\'Авторизуйтесь, что бы отправлять личные сообщения!\');"'; } $zipINFO=' Информация о архиве:
Размер: '.filesize_get($good['zip']); $cat['tile'] = iconv('windows-1251', 'utf-8', $cat['tile']); /*CALL TEMPLATE*/call_template('goods/good_inside.html',$CONTEXT=Array( 'good_tile'=>(mb_strlen($good['tile'],'UTF-8')>15) ? trim(mb_substr($good['tile'],0,15,'UTF-8')).'...':mb_substr($good['tile'],0,15,'UTF-8'), 'good_id'=>$good['id'], 'cat_tile'=>(mb_strlen($cat['tile'],'UTF-8')>15) ? trim(mb_substr($cat['tile'],0,15,'UTF-8')).'...':mb_substr($cat['tile'],0,15,'UTF-8'), 'cat_id'=>$cat['id'], 'slides'=>$slides, 'send_mes_ONCLICK'=>$send_mesBTN, 'good_full_tile'=>$good['tile'], 'owner_login'=>$good['owner_login'], 'good_price'=>$good['price'], 'good_des'=>wordwrap($good['description'], 79, '
'), 'good_zip_info'=>$zipINFO, 'good_sales'=>$good['sales'], 'pos_rews'=>$good['pos_rews'], 'neg_rews'=>$good['neg_rews'], 'owner_pos_rews'=>$owner['positive_reviews'], 'owner_neg_rews'=>$owner['negative_reviews'], 'owner_id'=>$owner['id'], 'comments'=>$cmz, 'comment_form'=>$comment_form, 'go_back'=>$go_back, )); break; case 'filter_goods'; $input=$_POST['data']; if(is_integer((int) $input['price']['from']) AND (is_integer((int) $input['price']['to']) OR $input['price']['to']=='') AND is_integer((int) $input['pos_rews']['from']) AND (is_integer((int) $input['pos_rews']['to']) OR $input['pos_rews']['to']=='') AND is_integer((int) $input['neg_rews']['from']) AND (is_integer((int) $input['neg_rews']['to']) OR $input['neg_rews']['to']=='') AND is_integer((int) $input['sales']['from']) AND (is_integer((int) $input['sales']['to']) OR $input['sales']['to']=='') AND (is_integer((int) $input['cat']) OR $input['cat']=='all')) { //All NICE, LETS GO //Составляем фильтр BEGIN $filter['price_from']=($input['price']['from']<0) ? 0:$input['price']['from']; $filter['price_to']=($input['price']['to']<=0) ? 9999999999:$input['price']['to']; $filter['pos_rews_from']=($input['pos_rews']['from']<0) ? 0:$input['pos_rews']['from']; $filter['pos_rews_to']=($input['pos_rews']['to']<=0) ? 9999999999:$input['pos_rews']['to']; $filter['pos_neg_from']=($input['neg_rews']['from']<0) ? 0:$input['neg_rews']['from']; $filter['pos_neg_to']=($input['neg_rews']['to']<=0) ? 9999999999:$input['neg_rews']['to']; $filter['sales_from']=($input['sales']['from']<0) ? 0:$input['sales']['from']; $filter['sales_to']=($input['sales']['to']<=0) ? 9999999999:$input['sales']['to']; $filter['cat']=( ($input['cat']=='all' OR $input['cat'] == '') ? '':"AND cat='$input[cat]'" ); //Составляем фильтр END $SFilter_query=sprintf("SELECT * FROM project_goods WHERE price>=%d AND price<=%d AND pos_rews>=%d AND pos_rews<=%d AND neg_rews>=%d AND neg_rews<=%d AND sales>=%d AND sales<=%d AND (`sellscount`='0' OR `sales`<`sellscount`) %s", $filter['price_from'],$filter['price_to'],$filter['pos_rews_from'],$filter['pos_rews_to'],$filter['pos_neg_from'],$filter['pos_neg_to'],$filter['sales_from'],$filter['sales_to'],$filter['cat']); $db = open_datebase_connection('DATEBASE#1'); $GG_by_filter=mysql_query($SFilter_query,$db); if($GG_by_filter) { //GetGoodsByFilter Ready $gds=''; while($g=mysql_fetch_array($GG_by_filter)) { $pic=explode('|',$g['pictures']); $decoded_pic_path = decode_str($pic[0],True); $anons=(mb_strlen($g['description'],'UTF-8')>15) ? trim(mb_substr($g['description'],0,15,'UTF-8')).'...':mb_substr($g['description'],0,15,'UTF-8'); $gds.='

'.$g['tile'].'

'.$g['owner_login'].'

RUR '.$g['price'].'

'; } /*CALL TEMPLATE*/call_template('goods/filter.html',$CONTEXT=Array( 'ShowGoodsByFilter'=>(empty($gds)) ? 'Ничего не найдено!':$gds, )); } else exit(''.iconv('utf-8','windows-1251','Произошла ошибка, пожалуйста, повторите попытку!')); } else { //Voodoo, break; exit(''.iconv('utf-8','windows-1251','Неправильно переданы параметры поиска, пожалуйста, повторите попытку!')); } break; default; echo 'Error!
Function '.$function_name.' does not exist!'; break; }