Вход Регистрация
Файл: backup_fzrf 2/system/modules/apps.php
Строк: 253
<?php
/*========================================= 
    Appointment: Игры
    File: apps.php 
    Author: Sergei Pavlenko 
    Engine: People Engine Cms
    Copyright: People Design Group (с) 2014
    e-mail: info@vxas.ru
    URL: http://www.vxas.ru/
    Данный код защищен авторскими правами
===========================================*/

if(!defined('MOZG'))
    die(
'Hacking attempt!');

if(
$logged){
    
$act $_GET['act'];
    
$user_id $user_info['user_id'];
    
    switch(
$act){
        
//* Страница приложения *//
        
        
case "view":
            
            
NoAjaxQuery();
            
            
$id intval($_POST['id']);
            
//* Выводим данные о игре *//
            
            
$row $db->super_query("SELECT id, title, poster, descr, traf FROM `".PREFIX."_games` WHERE id = '{$id}'");
            
            
$tpl->load_template('apps/view.tpl');
            
            if(
$row){
            
                if(
$row['poster']) $tpl->set('{poster}'"/uploads/apps/{$row['id']}/{$row['poster']}");
                else 
$tpl->set('{poster}'"/uploads/no_app.gif");
                        
                
$tpl->set('{title}'stripslashes($row['title']));
                
$tpl->set('{descr}'stripslashes($row['descr']));

                if(
$row['traf']) $tpl->set('{traf}''Игру '.newGram($row['traf'], 'установил''установили''установили'true).' '.newGram($row['traf'], 'человек''человека''человек'));
                else 
$tpl->set('{traf}''Пока никто не установил эту игру');
                        
                
$tpl->set('{app-id}'$row['id']);
                
//* Выводим скрины *//
                
                
$sql_imgs $db->super_query("SELECT file FROM `".PREFIX."_games_files` WHERE game_id = '{$row['id']}' AND type = 'scrin'"1);
                
                if(
$sql_imgs){
                    
                    
$ci 0;

                    
$tpl->set('{m-poster-1}''');
                    
$tpl->set('{m-poster-2}''');
                    
$tpl->set('{m-poster-3}''');
                    
$tpl->set('{m-poster-4}''');
                    
$tpl->set('[poster]''');
                    
$tpl->set('[/poster]''');
                    
                    foreach(
$sql_imgs as $row_img){

                        
$ci++;
                        
                        
$tpl->set("{poster-{$ci}}""/uploads/apps/{$row['id']}/{$row_img['file']}");
                        
                        if(
$ci == 1$opacity 1;
                        else 
$opacity 0.5;
                        
                        
$tpl->set("{m-poster-{$ci}}""<img src="/uploads/apps/{$row['id']}/m{$row_img['file']}" width="145" height="90" id="apmpos{$ci}" onClick="apps.gallery({$ci}, this.id)" style="opacity:{$opacity}" />");                
                        
                    }
                    
                    
                    
                } else {
                
                    
$tpl->set_block("'\[poster](.*?)\[/poster]'si","");
                    
$tpl->set_block("'\{m-poster-(.*?)\}'si","");
                    
                }
                
                
$tpl->set('[yes-game]''');
                
$tpl->set('[/yes-game]''');
                
$tpl->set_block("'\[no-game](.*?)\[/no-game]'si","");
                
            } else {
            
                
$tpl->set('[no-game]''');
                
$tpl->set('[/no-game]''');
                
$tpl->set_block("'\[yes-game](.*?)\[/yes-game]'si","");
                
            }
            
            
$tpl->compile('content');
            
            
            
AjaxTpl();
            
            exit();
            
        break;
        
//* Запуск приложения *// 
        
        
case "start":
        
            
$id intval($_GET['id']);

//* Выводим данные о игре *//
            
            
$row $db->super_query("SELECT title, poster, flash, traf, width, height FROM `".PREFIX."_games` WHERE id = '{$id}'");
            
            if(
$row){
            
                
$metatags['title'] = stripslashes($row['title']);
                
//* Проверка на существование игры у пользователя *//
                
                
$checkMy $db->super_query("SELECT COUNT(*) AS cnt FROM `".PREFIX."_games_users` WHERE user_id = '{$user_id}' AND game_id = '{$id}'");
                
//* Автоматическая установка *//
                
                
if(!$checkMy['cnt']){
                
                    
$db->query("INSERT INTO `".PREFIX."_games_users` SET user_id = '{$user_id}', game_id = '{$id}', setdate = '{$server_time}', lastdate = '{$server_time}'");
                    
//* Обновляем кол-во участников у игры *//
                    
                    
$db->query("UPDATE `".PREFIX."_games` SET traf = traf+1 WHERE id = '{$id}'");
                    
//* Вставляем событие в ленту активности "установил" *//
                    
                    
$db->query("INSERT INTO `".PREFIX."_games_activity` SET user_id = '{$user_id}', game_id = '{$id}', date = '{$server_time}', action = '1'");
                    
                } else {
                
                    
$db->query("UPDATE `".PREFIX."_games_users` SET lastdate = '{$server_time}' WHERE user_id = '{$user_id}' AND game_id = '{$id}'");
                        
//* Вставляем событие в ленту активности "запуск" *//
                    
                    
$rowActivity $db->super_query("SELECT date FROM `".PREFIX."_games_activity` WHERE user_id = '{$user_id}' AND game_id = '{$id}'");
                    
$lastUP $rowActivity['date'] + 3600;
                    
                    if(
$lastUP <= $server_time)
                        
$db->query("INSERT INTO `".PREFIX."_games_activity` SET user_id = '{$user_id}', game_id = '{$id}', date = '{$server_time}', action = '2'");
                    
                }
                

                
$tpl->load_template('apps/start.tpl');
                
                if(
$row['poster']) $tpl->set('{poster}'"/uploads/apps/{$id}/{$row['poster']}");
                else 
$tpl->set('{poster}'"/uploads/no_app.gif");
                    
                
$tpl->set('{title}'stripslashes($row['title']));
                
$tpl->set('{swf}'"/uploads/apps/{$id}/{$row['flash']}");
                
$tpl->set('{app-id}'$id);
                
                if(
$row['traf']) $tpl->set('{traf}'newGram($row['traf'], 'участник''участника''участников'));
                else 
$tpl->set('{traf}''Нет участников');
                
                if(!
$row['width']) $row['width'] = 795;
                if(!
$row['height']) $row['height'] = 495;
                
                
$tpl->set('{width}'$row['width']);
                
$tpl->set('{height}'$row['height']);
                
                
$tpl->compile('content');
            
            } else
                
msgbox('''Игра не найдена.''info_2');
            
        break;
        
//* Удаление игры из своего списка *//
        
        
case "mydel":
            
            
NoAjaxQuery();
            
            
$id intval($_POST['id']);
            
//* Проверка на существование игры у пользователя *//
            
            
$checkMy $db->super_query("SELECT COUNT(*) AS cnt FROM `".PREFIX."_games_users` WHERE user_id = '{$user_id}' AND game_id = '{$id}'");
            
            if(
$checkMy['cnt']){
            
                
$db->query("DELETE FROM `".PREFIX."_games_users` WHERE user_id = '{$user_id}' AND game_id = '{$id}'");
                
//* Обновляем кол-во участников у игры *//
                
                
$db->query("UPDATE `".PREFIX."_games` SET traf = traf-1 WHERE id = '{$id}'");
                    
            }
            
            exit();
            
        break;
            
//* Результат поиска по играм *//
        
        
case "search":
            
            
NoAjaxQuery();
            
            
$query_games $db->safesql(strip_data($_POST['query_games']));
            
//* Заменяем пробелы на проценты чтоб поиск был точнее *//            
            
            
$query_games strtr($query_games, array(' ' => '%'));

            if(isset(
$query_games) AND !empty($query_games)){
                
                
$lastid intval($_POST['lastid']);
                if(
$lastid$sql_where "AND id > '{$lastid}'";
                
                
$sql_ $db->super_query("SELECT id, title, poster, traf FROM `".PREFIX."_games` WHERE title LIKE '%{$query_games}%' {$sql_where} ORDER by `date` ASC LIMIT 0, 20"1);
                
                if(
$sql_){
                        
                    
$tpl->load_template('apps/search.tpl');
                    foreach(
$sql_ as $row){
                        
                        if(
$row['poster']) $tpl->set('{poster}'"/uploads/apps/{$row['id']}/{$row['poster']}");
                        else 
$tpl->set('{poster}'"/uploads/no_app.gif");
                            
                        
$tpl->set('{title}'stripslashes($row['title']));

                        if(
$row['traf']) $tpl->set('{traf}'newGram($row['traf'], 'участник''участника''участников'));
                        else 
$tpl->set('{traf}''Нет участников');
                            
                        
$tpl->set('{app-id}'$row['id']);
                            
                        
$tpl->compile('content');
                            
                    }
                    
                    if(!
$lastid){
                    
                        
$tpl->load_template('apps/search_but.tpl');
                        
$cnt count($sql_);
                
                        if(
$cnt == 20){
                            
$tpl->set('[but]''');
                            
$tpl->set('[/but]''');
                        } else
                            
$tpl->set_block("'\[but](.*?)\[/but]'si","");
                            
                        
$tpl->compile('content');
                    
                    }

                } else
                    if(!
$lastid)
                        
$tpl->result['content'] = '<div class="info_center" style="padding-top:125px;padding-bottom:125px">По запросу <b>'.$query_games.'</b> не найдено ни одной игры.</div>';
            
                
AjaxTpl();
                
            }
                
            exit();
            
        break;
        
//* Загрузка игр *//
        
        
case "add":
        
//* Вывод страницы загрузки *//
            
            
if ($_SERVER['REQUEST_METHOD'] == 'GET' || $_POST['ajax'] == 'yes') {
            
//* Удаляем все файлы, загруженные в прошлый раз *//
                
                
$files $db->super_query("SELECT file, type FROM `".PREFIX."_games_ver_files` WHERE game_id = 0 AND user_id = {$user_info['user_id']}"1);
                if (
count($files)) {
                    foreach (
$files as $item) {
                        @
unlink(ROOT_DIR.'/uploads/apps/temp/'.$user_info['user_id'].'/'.$item['file']);
                        if (
$item['type'] == 'scrin') {
                            @
unlink(ROOT_DIR.'/uploads/apps/temp/'.$user_info['user_id'].'/m'.$item['file']);
                        }
                    }
                    
$db->query("DELETE FROM `".PREFIX."_games_ver_files` WHERE game_id = 0 AND user_id = {$user_info['user_id']}");
                }
                
$tpl->load_template('apps/add.tpl');
                
$tpl->compile('content');
                
//* Загрузка профиля *//
            
            
} else if ($_POST['add_act'] == 'upload') {
            
//* Получаем данные о файле *//
                
                
$image_tmp $_FILES['uploadfile']['tmp_name'];
                
//* Оригинальное название для определения формата *//                
                
                
$image_name totranslit($_FILES['uploadfile']['name']);
                
//* Имя файла *//                
                
                
$image_rename substr(md5($server_time+rand(1,100000)), 020);

//* Размер файла *//
                
                
$image_size $_FILES['uploadfile']['size'];
                
//* Формат файла *//                
                
                
$type end(explode("."$image_name)); 
                
                
$max_size 1024 5000;
                
//* Проверка размера *//
                
                
if($image_size <= $max_size){
                    
//* Разришенные форматы *//
                    
                    
$allowed_files explode(', ''jpg, jpeg, jpe, png, gif');
                    
//* Проверяем если, формат верный то пропускаем *//
                    
                    
if(in_array(strtolower($type), $allowed_files)){
                            
                        
$res_type strtolower('.'.$type);
                        
                        
$upDir ROOT_DIR.'/uploads/apps/temp/'.$user_info['user_id'].'/';
                        
//* Если нет папок, то создаём их *//
                        
                        
if(!is_dir($upDir)){ 
                            @
mkdir($upDir0777);
                            @
chmod($upDir0777);
                        }
                        
                        
$rImg $upDir.$image_rename.$res_type;
                        
                        if(
move_uploaded_file($image_tmp$rImg)){
                            
//* Подключаем класс для фотографий *//
                                
                                
include_once ENGINE_DIR.'/classes/images.php';
                                
//* Создание маленькой копии *//
                                
                                
$tmb = new thumbnail($rImg);
                                
$tmb->size_auto('75x75');
                                
$tmb->jpeg_quality('100');
                                
$tmb->save($rImg);
                                
                                
$sql_ $db->super_query("SELECT file FROM `".PREFIX."_games_ver_files` WHERE user_id = '{$user_info['user_id']}' AND type = 'poster' AND game_id = '0'"1);
                                
                                if(
$sql_){
                                
                                    foreach(
$sql_ as $row){
                                    
                                        @
unlink($upDir.$row['file']);
                                        
                                    }
                                    
                                    
$db->query("DELETE FROM `".PREFIX."_games_ver_files` WHERE user_id = '{$user_info['user_id']}' AND type = 'poster' AND game_id = '0'");
                                        
                                }

//* Читаем хеш *//
                                
                                
$app_hash $db->safesql($_SESSION['apps_hash']);
                                
//* Вставляем в базу *//
                                
                                
$db->query("INSERT INTO `".PREFIX."_games_ver_files` SET file = '{$image_rename}{$res_type}', hash = '{$app_hash}', type = 'poster', user_id = '{$user_info['user_id']}'");
                                
                                die(
$user_info['user_id'].'/'.$image_rename.$res_type);
                        }
                    } else
                        die(
'2');
                } else
                    die(
'1');
                    
//* Загрузка файла игры *//
            
            
} else if ($_POST['add_act'] == 'upload_swf') {
            
//* Получаем данные о файле *//
                
                
$image_tmp $_FILES['uploadfile']['tmp_name'];
                
//* Оригинальное название для определения формата *//                
                
                
$image_name totranslit($_FILES['uploadfile']['name']);
                
//* Имя файла *//                
                
                
$image_rename substr(md5($server_time+rand(1,100000)), 020);
                
//* Размер файла *//                
                
                
$image_size $_FILES['uploadfile']['size'];
                
//* Формат файла *//                
                
                
$type end(explode("."$image_name));
                
                
$max_size = ( 1024 5000 ) * 20;
                
//* Проверка размера *//
                
                
if($image_size <= $max_size){

//* Проверяем если, формат верный то пропускаем *//
                    
                    
if(strtolower($type) == 'swf'){
                            
                        
$res_type strtolower('.'.$type);

                        
$upDir ROOT_DIR.'/uploads/apps/temp/'.$user_info['user_id'].'/';
                        
//* Если нет папок, то создаём их *//
                        
                        
if(!is_dir($upDir)){ 
                            @
mkdir($upDir0777);
                            @
chmod($upDir0777);
                        }
                        
                        
$rImg $upDir.$image_rename.$res_type;
                        
                        if(
move_uploaded_file($image_tmp$rImg)){
                            
//* Выводим пред. загруженные swf и удаляем их *//
                                
                                
$sql_ $db->super_query("SELECT file FROM `".PREFIX."_games_ver_files` WHERE user_id = '{$user_info['user_id']}' AND type = 'swf' AND game_id = '0'"1);
                                
                                if(
$sql_){
                                
                                    foreach(
$sql_ as $row){
                                    
                                        @
unlink($upDir.$row['file']);
                                        
                                    }
                                    
                                    
$db->query("DELETE FROM `".PREFIX."_games_ver_files` WHERE user_id = '{$user_info['user_id']}' AND type = 'swf' AND game_id = '0'");
                                    
                                }
                                
//* Читаем хеш *//
                                
                                
$app_hash $db->safesql($_SESSION['apps_hash']);
                                
//* Вставляем в базу *//
                                
                                
$db->query("INSERT INTO `".PREFIX."_games_ver_files` SET file = '{$image_rename}{$res_type}', hash = '{$app_hash}', type = 'swf', user_id = '{$user_info['user_id']}'");
                            
                        }
                    } else
                        die(
'2');
                } else
                    die(
'1');
                    
//* Загрузка скрина *//
            
            
} else if ($_POST['add_act'] == 'upload_scrin') {
            
//* Получаем данные о файле *//
                
                
$image_tmp $_FILES['uploadfile']['tmp_name'];
                
//* Оригинальное название для определения формата *//                
                
                
$image_name totranslit($_FILES['uploadfile']['name']);
                
//* Имя файла *//                
                
                
$image_rename substr(md5($server_time+rand(1,100000)), 020);
                
//* Размер файла *//                
                
                
$image_size $_FILES['uploadfile']['size'];
                
//* формат файла *//                
                
                
$type end(explode("."$image_name));
                
                
$max_size 1024 5000;
                
//* Проверка размера *//
                
                
if($image_size <= $max_size){
                    
//* Разришенные форматы *//
                    
                    
$allowed_files explode(', ''jpg, jpeg, jpe, png, gif');
                    
//* Проверяем если, формат верный то пропускаем *//
                    
                    
if(in_array(strtolower($type), $allowed_files)){
                            
                        
$res_type strtolower('.'.$type);
                        
                        
$upDir ROOT_DIR.'/uploads/apps/temp/'.$user_info['user_id'].'/';
                        
//* Если нет папок, то создаём их *//
                        
                        
if(!is_dir($upDir)){ 
                            @
mkdir($upDir0777);
                            @
chmod($upDir0777);
                        }
                        
                        
$rImg $upDir.$image_rename.$res_type;
                        
//* Читаем хеш *//
                        
                        
$app_hash $db->safesql($_SESSION['apps_hash']);
                        
//* Считаем кол-вол загруженных скринов *//
                        
                        
$cnRow $db->super_query("SELECT COUNT(*) AS cnt FROM `".PREFIX."_games_ver_files` WHERE user_id = {$user_info['user_id']} AND type = 'scrin'");

                        if(
$cnRow['cnt'] <= 3){
                        
                            if(
move_uploaded_file($image_tmp$rImg)){
                                
//* Подключаем класс для фотографий *//
                                    
                                    
include_once ENGINE_DIR.'/classes/images.php';
                                    
//* Создание 607х376 *//
                                    
                                    
$tmb = new thumbnail($rImg);
                                    
$tmb->size_auto('607x376');
                                    
$tmb->jpeg_quality('100');
                                    
$tmb->save($rImg);
                                    
//* Создание 145х90 *//
                                    
                                    
$tmb = new thumbnail($rImg);
                                    
$tmb->size_auto('145x90');
                                    
$tmb->jpeg_quality('100');
                                    
$tmb->save($upDir.'m'.$image_rename.$res_type);
                                    
                                    
$rowHash $db->super_query("SELECT hash FROM `".PREFIX."_games_ver_files` WHERE game_id = '{$id}'");
                                    
//* Вставляем в базу *//
                                    
                                    
$db->query("INSERT INTO `".PREFIX."_games_ver_files` SET file = '{$image_rename}{$res_type}', hash = '{$rowHash['hash']}', type = 'scrin', user_id = '{$user_info['user_id']}', game_id = '{$id}'");
                                    
                                    die(
$user_info['user_id'].'/m'.$image_rename.$res_type);
                                        
                            }
                        } else
                            die(
'3');
                    } else
                        die(
'2');
                } else
                    die(
'1');
                    
//* Удаление файла *//
            
            
} else if ($_POST['add_act'] == 'del') {
                
$file $db->safesql(strip_tags($_POST['file']));
                
                
$row $db->super_query("SELECT file, type FROM `".PREFIX."_games_ver_files` WHERE file = '{$file}'");
                
                if(
$row['file']){
                    
                    
$upDir ROOT_DIR.'/uploads/apps/temp/'.$user_info['user_id'].'/';
                    
                    if (
$row['type'] == 'scrin') {
                        @
unlink($upDir.$row['file']);
                        @
unlink($upDir.'m'.$row['file']);
                    } else {
                        @
unlink($upDir.$row['file']);
                    }
                    
                    
$db->query("DELETE FROM `".PREFIX."_games_ver_files` WHERE file = '{$file}'");
                }
                
//* Добавление в базу данных *//
            
            
} else if ($_POST['add_act'] == 'send') {
                
$title textFilter($_POST['title'], falsetrue);
                
$descr textFilter($_POST['descr']);
                
$width intval($_POST['width']);
                
$height intval($_POST['height']);
                
//* Читаем хеш *//
                
                
$app_hash $db->safesql($_SESSION['apps_hash']);
                
                if(isset(
$title) AND !empty($title)){
                    
//* Выводим файлы *//
                    
                    
$sql_ $db->super_query("SELECT file, type FROM `".PREFIX."_games_ver_files` WHERE hash = '{$app_hash}' AND user_id = '{$user_info['user_id']}'"1);
                    
                    if(
$sql_){
                    
                        foreach(
$sql_ as $row){
                            
                            if(
$row['type'] == 'poster'$poster .= $row['file'];
                            
                            if(
$row['type'] == 'swf'$swf .= $row['file'];
                            
                        }
                        
//* Всталвяем игру в базу *//
                        
                        
$db->query("INSERT INTO `".PREFIX."_games_ver` SET title = '{$title}', descr = '{$descr}', poster = '{$poster}', flash = '{$swf}', date = '{$server_time}', width = '{$width}', height = '{$height}'");
                        
$id $db->insert_id();
                        
//* Создаем папку игры в uploads *//
                        
                        
$gameDir ROOT_DIR.'/uploads/apps/for_ver/'.$id.'/';
                        @
mkdir($gameDir0777);
                        @
chmod($gameDir0777);
                        
//* Временная директория *//
                        
                        
$upDir ROOT_DIR.'/uploads/apps/temp/'.$user_info['user_id'].'/';
                        
//* Копируем файлы из временной папки в новую папку игры *//
                        
                        
foreach($sql_ as $row){
                            
                            if(
$row['type'] == 'scrin'){
                            
                                @
copy($upDir.'m'.$row['file'], $gameDir.'m'.$row['file']);
                                @
unlink($upDir.'m'.$row['file']);
                                
                                @
copy($upDir.$row['file'], $gameDir.$row['file']);
                                @
unlink($upDir.$row['file']);
                                
                            } else {
                            
                                @
copy($upDir.$row['file'], $gameDir.$row['file']);
                                @
unlink($upDir.$row['file']);
                                
                            }
                            
                        }
                        
//* Обновляем ID в таблице _games_files *//
                        
                        
$db->query("UPDATE `".PREFIX."_games_ver_files` SET game_id = '{$id}' WHERE game_id = 0 AND user_id = '{$user_info['user_id']}'");
                        
                        
$tpl->load_template('apps/message.tpl');
                        
$tpl->set('{message}''Игра отправлена на модерацию!');
                        
$tpl->set('{error}''');
                        
$tpl->compile('info');
                    } else
                        
$tpl->load_template('apps/message.tpl');
                        
$tpl->set('{message}''Заполните все поля!');
                        
$tpl->set('{error}'' add_error');
                        
$tpl->compile('info');
                    
                } else
                    
$tpl->load_template('apps/message.tpl');
                    
$tpl->set('{message}''Заполните все поля!');
                    
$tpl->set('{error}'' add_error');
                    
$tpl->compile('info');
            }

            break;

//* Главная страница игр *//
        
        
default:
            
            
$metatags['title'] = 'Игры';
            
//* Если вызвана подгрузка *//
            
            
if($_POST['doload'])
                
                
NoAjaxQuery();

            
$limit_news 20;
            
$limit_news_old 5;

            if(
$_POST['page_cnt'] > 0$page_cnt intval($_POST['page_cnt']) * $limit_news;
            else 
$page_cnt 0;

            if(
$_POST['page_cnt_old'] > 0$page_cnt_old intval($_POST['page_cnt_old']) * $limit_news_old;
            else 
$page_cnt_old 0;
                
//* Выводим популярные *//
            
            
if($_POST['doload'] != 2){
            
                
$sql_popular $db->super_query("SELECT id, title, poster, traf FROM `".PREFIX."_games` ORDER by `traf` DESC LIMIT {$page_cnt}{$limit_news}"1);
                
                if(
$sql_popular){
                    
                    
$tpl->load_template('apps/game.tpl');
                    foreach(
$sql_popular as $row_popular){
                    
                        if(
$row_popular['poster']) $tpl->set('{poster}'"/uploads/apps/{$row_popular['id']}/{$row_popular['poster']}");
                        else 
$tpl->set('{poster}'"/uploads/no_app.gif");
                        
                        
$tpl->set('{title}'stripslashes($row_popular['title']));

                        if(
$row_popular['traf']) $tpl->set('{traf}'newGram($row_popular['traf'], 'участник''участника''участников'));
                        else 
$tpl->set('{traf}''Нет участников');
                        
                        
$tpl->set('{app-id}'$row_popular['id']);
                        
$tpl->set('{type}''pop');
                        
                        
$tpl->compile('pop_games');
                        
                    }
                
                }
            
            }
            
//* Выводим новые *//
            
            
if($_POST['doload'] != 2){
            
                
$sql_new $db->super_query("SELECT id, title, poster, traf FROM `".PREFIX."_games` ORDER by `date` DESC LIMIT {$page_cnt}{$limit_news}"1);
                
                if(
$sql_new){
                    
                    
$tpl->load_template('apps/game.tpl');
                    foreach(
$sql_new as $row_new){
                    
                        if(
$row_new['poster']) $tpl->set('{poster}'"/uploads/apps/{$row_new['id']}/{$row_new['poster']}");
                        else 
$tpl->set('{poster}'"/uploads/no_app.gif");
                        
                        
$tpl->set('{title}'stripslashes($row_new['title']));

                        if(
$row_new['traf']) $tpl->set('{traf}'newGram($row_new['traf'], 'участник''участника''участников'));
                        else 
$tpl->set('{traf}''Нет участников');
                        
                        
$tpl->set('{app-id}'$row_new['id']);
                        
$tpl->set('{type}''new');
                        
                        
$tpl->compile('new_games');
                        
                    }
                
                }
            
            }
            
//* Выводим "Мои игры" *//
            
            
if(!$_POST['doload'] OR $_POST['doload'] == 2){
            
                
$sql_my $db->super_query("SELECT tb1.game_id, tb2.title, traf, poster FROM `".PREFIX."_games_users` tb1, `".PREFIX."_games` tb2 WHERE tb1.game_id = tb2.id AND tb1.user_id = '{$user_id}' ORDER by `lastdate` DESC LIMIT {$page_cnt_old}{$limit_news_old}"1);
                
                if(
$sql_my){
                    
                    
$tpl->load_template('apps/my.tpl');
                    foreach(
$sql_my as $row_my){
                    
                        if(
$row_my['poster']) $tpl->set('{poster}'"/uploads/apps/{$row_my['game_id']}/{$row_my['poster']}");
                        else 
$tpl->set('{poster}'"/uploads/no_app.gif");
                        
                        
$tpl->set('{title}'stripslashes($row_my['title']));

                        if(
$row_my['traf']) $tpl->set('{traf}'newGram($row_my['traf'], 'участник''участника''участников'));
                        else 
$tpl->set('{traf}''Нет участников');
                        
                        
$tpl->set('{app-id}'$row_my['game_id']);
                        
$tpl->set('{type}''new');
                        
                        
$tpl->compile('my_games');
                        
                    }
                
                } else
                    if(!
$_POST['doload'])
                        
$tpl->result['my_games'] = '<div class="info_center" style="width:220px;padding-top:125px;padding-bottom:100px">Здесь будут отображаться последние игры,<br /> которые Вы посещали.</div>';
                
            }
            
//* Выводим "Активность друзей" *//
            
            
if(!$_POST['doload'] OR $_POST['doload'] == 2){
                
                
$myFrList mozg_cache("user_{$user_id}/friends");
                
$expListFr explode('|'$myFrList);
                
$sqlFRlist = array();
                foreach(
$expListFr as $frId){
                    
                    
$frId str_replace('u'''$frId);
                    
                    if(
$frId$sqlFRlist[] = $frId;
                    
                }
                
                
$sqlFRlist implode(', '$sqlFRlist);

                if(
$sqlFRlist){
                
                    
$sql_acti $db->super_query("
                            SELECT
                                tb1.user_id, game_id, tb1.date, action, tb2.user_search_pref, user_photo, user_sex, tb3.title, poster
                            FROM
                                `"
.PREFIX."_games_activity` tb1,
                                `"
.PREFIX."_users` tb2,
                                `"
.PREFIX."_games` tb3
                            WHERE
                                tb1.user_id IN (
{$sqlFRlist}
                            AND
                                tb1.user_id = tb2.user_id
                            AND
                                tb1.game_id = tb3.id
                            ORDER
                                by `date` DESC
                            LIMIT 
{$page_cnt_old}{$limit_news_old}
                        "
1);
                    
                    if(
$sql_acti){
                                                
                        
$tpl->load_template('apps/activity.tpl');
                        foreach(
$sql_acti as $row_acti){
                            
                            if(
$row_acti['poster']) $tpl->set('{poster}'"/uploads/apps/{$row_acti['game_id']}/{$row_acti['poster']}");
                            else 
$tpl->set('{poster}'"/uploads/no_app.gif");
                            
                            if(
$row_acti['user_photo']) $tpl->set('{ava}'"/uploads/users/{$row_acti['user_id']}/50_{$row_acti['user_photo']}");
                            else 
$tpl->set('{ava}'"{theme}/images/no_ava_50.png");
                            
                            
megaDate($row_acti['date']);
                            
                            if(
$row_acti['user_sex'] == 2){
                                
$sXtxt 'запустила';
                                
$sXtxt2 'установила';
                            } else {
                                
$sXtxt 'запустил';
                                
$sXtxt2 'установил';
                            }
                            
                            if(
$row_acti['action'] == 1$tpl->set('{type}'$sXtxt2);
                            else 
$tpl->set('{type}'$sXtxt);
                            
                            
$tpl->set('{rand}'$row_acti['date']);
                            
                            
$tpl->set('{title}'stripslashes($row_acti['title']));
                            
$tpl->set('{name}'$row_acti['user_search_pref']);
                            
$tpl->set('{user-id}'$row_acti['user_id']);
                            
$tpl->set('{app-id}'$row_acti['game_id']);
                            
                            
$tpl->compile('activity');
                            
                        }
                        
                    } else
                        if(!
$_POST['doload'])
                            
$tpl->result['activity'] = '<div class="info_center" style="width:220px;padding-top:125px;padding-bottom:100px">Здесь будет отображаться активность<br /> Ваших друзей в разделе игр.</div>';
                        
                } else
                    if(!
$_POST['doload'])
                        
$tpl->result['activity'] = '<div class="info_center" style="width:220px;padding-top:125px;padding-bottom:100px">Здесь будет отображаться активность<br /> Ваших друзей в разделе игр.</div>';
                
            }
            
            if(!
$_POST['doload']){
            
                
$tpl->load_template('apps/main.tpl');
                
$tpl->set('{pop_games}'$tpl->result['pop_games']);
                
$tpl->set('{new_games}'$tpl->result['new_games']);
                
$tpl->set('{my_games}'$tpl->result['my_games']);
                
$tpl->set('{activity}'$tpl->result['activity']);
                
                
$cntMy count($sql_my);
                
$cntActi count($sql_acti);
                
$cntPop count($sql_popular);
                
$cntNew count($sql_new);
                
                if(
$cntMy == OR $cntActi == 5){
                    
$tpl->set('[but-preload]''');
                    
$tpl->set('[/but-preload]''');
                } else
                    
$tpl->set_block("'\[but-preload](.*?)\[/but-preload]'si","");
                
                if(
$cntPop == 20 OR $cntNew == 20){
                    
$tpl->set('[but-preload-2]''');
                    
$tpl->set('[/but-preload-2]''');
                } else
                    
$tpl->set_block("'\[but-preload-2](.*?)\[/but-preload-2]'si","");
                
                
$tpl->compile('content');
            
            }

//* Если вызвана подгрузка *//
            
            
if($_POST['doload']){
                
                if(
$_POST['doload'] == 2)
                    
$tpl->result['content'] = $tpl->result['my_games'].'||'.$tpl->result['activity'];
                else
                    
$tpl->result['content'] = $tpl->result['pop_games'].'||'.$tpl->result['new_games'];
                
                
AjaxTpl();
                
                exit();
                
            }
            break;
    }
    
    
$tpl->clear();
    
$db->free();
    
} else {
    
$user_speedbar $lang['no_infooo'];
    
msgbox(''$lang['not_logged'], 'info');
}

?>
Онлайн: 1
Реклама