View file system/modules/reviews.php

File size: 2.63Kb
<?php
/* 
	Appointment: Отзывы
	File: reviews.php 
	Author: likan
	Engine: LIKAN
*/
if(!defined('MOZG'))
	die('Hacking attempt!');

if($ajax == 'yes')
	NoAjaxQuery();

$act = $_GET['act'];

switch($act){
		
	//################### Добавление отзыва ###################//
	case "send":
		
		NoAjaxQuery();
		
		$text = textFilter($_POST['text']);
		
		if(isset($text) AND !empty($text) AND $logged){
			
			//Вставляем в базу
			$db->query("INSERT INTO `".PREFIX."_reviews` SET user_id = '{$user_info['user_id']}', text = '{$text}', date = '{$server_time}', approve = 1");
			
		}
		
		exit();
		
	break;
		
		//################### Вывод всех отзывов ###################//
		default:
		
			$limit_num = 25;
			if($_POST['page_cnt'] > 0) $page_cnt = intval($_POST['page_cnt']) * $limit_num;
			else $page_cnt = 0;
			
			//Если вызваны пред.
			if($page_cnt){
				
				NoAjaxQuery();
				
			}
			
			//Верх
			if(!$page_cnt){
			
				$tpl->load_template('reviews/main.tpl');
				
				if($logged){
					
					$tpl->set('[logged]','');
					$tpl->set('[/logged]','');
					$tpl->set_block("'\\[not-logged\\](.*?)\\[/not-logged\\]'si","");
					
				} else {
					
					$tpl->set('[not-logged]','');
					$tpl->set('[/not-logged]','');
					$tpl->set_block("'\\[logged\\](.*?)\\[/logged\\]'si","");
					
				}
				
				$tpl->compile('content');
			
			}
			
			//Выводим отзывы
			$sql_ = $db->super_query("SELECT tb1.user_id, text, date, tb2.user_search_pref, user_photo FROM `".PREFIX."_reviews` tb1, `".PREFIX."_users` tb2 WHERE tb1.user_id = tb2.user_id AND approve = '0' ORDER by `date` DESC LIMIT {$page_cnt}, {$limit_num}", 1);
			
			if($sql_){
			
				$tpl->load_template('reviews/review.tpl');
				
				foreach($sql_ as $row){
					
					$tpl->set('{name}', $row['user_search_pref']);
					$tpl->set('{user_id}', $row['user_id']);
					$tpl->set('{text}', stripslashes($row['text']));
					megaDate($row['date']);
					
					if($row['user_photo'])
						$tpl->set('{ava}', '/uploads/users/'.$row['user_id'].'/50_'.$row['user_photo']);
					else
						$tpl->set('{ava}', '{theme}/images/no_ava_50.png');
					
					$tpl->compile('content');
					
				}
				
				$num = count($sql_);
			
			}
			
			//Низ
			if($limit_num == $num AND !$page_cnt){
				
				$tpl->load_template('reviews/bottom.tpl');
				$tpl->compile('content');
				
			}
			
			//Если вызваны пред.
			if($page_cnt){
				
				AjaxTpl();
				
				exit();
				
			}
		
	}
	
$tpl->clear();
$db->free();
?>