コード例 #1
0
ファイル: perevod.php プロジェクト: skypach/skypach.ru
            $sql_rate = $db->super_query("SELECT author_user_id, for_user_id, rate_date, num, user_name, user_lastname, user_photo FROM `" . PREFIX . "_user_perevod` ur left join `" . PREFIX . "_users` u on u.user_id = ur.author_user_id WHERE for_user_id = '{$user_id}' LIMIT {$page_cnt},{$limit_rate}", 1);
            //var_dump($sql_rate);
            if ($sql_rate) {
                $c = 0;
                foreach ($sql_rate as $sql_list) {
                    if ($sql_list['user_photo']) {
                        $ava = '/uploads/users/' . $sql_list['author_user_id'] . '/50_' . $sql_list['user_photo'];
                    } else {
                        $ava = 'templates/Default/images/no_ava_50.png';
                    }
                    $temp_list .= '
						<div class="rate_block">
							<a href="/u' . $sql_list['author_user_id'] . '" onClick="Page.Go(this.href); return false"><img src="' . $ava . '" width="50" height="50" /></a>
							<a href="/u' . $sql_list['author_user_id'] . '" onClick="Page.Go(this.href); return false"><b>' . $sql_list['user_name'] . ' ' . $sql_list['user_lastname'] . '</b></a>
							<div class="profile_ratingview">+' . $sql_list['num'] . '</div>
							<div class="rate_date">' . megaDateNoTpl($sql_list['rate_date']) . '</div>
						</div>' . "\n";
                    $c++;
                }
                if ($c > 5 and !$_POST['page_cnt']) {
                    $tpl->set('{users}', $temp_list);
                    $tpl->set('[prev]', '');
                    $tpl->set('[/prev]', '');
                    $tpl->compile('content');
                } else {
                    if ($c < 5 and !$_POST['page_cnt']) {
                        $tpl->set('{users}', $temp_list);
                        $tpl->set_block("'\\[prev\\](.*?)\\[/prev\\]'si", "");
                        $tpl->compile('content');
                    }
                }
コード例 #2
0
             $sql_query = false;
         }
     }
 }
 if ($sql_query) {
     $sql_ = $db->super_query($sql_query, 1);
     $i = 1;
     if ($sql_) {
         foreach ($sql_ as $row) {
             $i++;
             //Если критерий поиск "по видеозаписям"
             if ($type == 2) {
                 $ava = $row['photo'];
                 $img_width = 100;
                 $row['user_search_pref'] = $row['title'];
                 $countr = 'Добавлено ' . megaDateNoTpl(strtotime($row['add_date']), 1, 1);
                 $row['user_id'] = 'video' . $row['owner_user_id'] . '_' . $row['id'] . '" onClick="videos.show(' . $row['id'] . ', this.href, location.href); return false';
                 //Если критерий поиск "по сообществам"
             } else {
                 if ($type == 4) {
                     if ($row['photo']) {
                         $ava = '/uploads/groups/' . $row['id'] . '/50_' . $row['photo'];
                     } else {
                         $ava = '/templates/' . $config['temp'] . '/images/no_ava_50.png';
                     }
                     $img_width = 50;
                     $row['user_search_pref'] = $row['title'];
                     $countr = $row['traf'] . ' ' . gram_record($row['traf'], 'groups_users');
                     if ($row['adres']) {
                         $row['user_id'] = $row['adres'];
                     } else {
コード例 #3
0
ファイル: public.php プロジェクト: skypach/skypach.ru
     $tpl->set('[no-status]', '');
     $tpl->set('[/no-status]', '');
 }
 $tpl->set('{web}', $row['web']);
 if ($row['web']) {
     $tpl->set('[web]', '');
     $tpl->set('[/web]', '');
 } else {
     $tpl->set_block("'\\[web\\](.*?)\\[/web\\]'si", "");
 }
 //Видеозаписи
 if ($row['videos_num']) {
     $sql_videos = $db->super_query("SELECT id, title, photo, add_date, comm_num, owner_user_id, public_id FROM `" . PREFIX . "_videos` WHERE public_id = '{$row['id']}' ORDER by `add_date` DESC LIMIT 0, 2", 1, "groups/video{$row['id']}");
     foreach ($sql_videos as $row_video) {
         $row_video['title'] = stripslashes($row_video['title']);
         $date_video = megaDateNoTpl(strtotime($row_video['add_date']));
         $comm_num = $row_video['comm_num'] . ' ' . gram_record($row_video['comm_num'], 'comments');
         $videos .= "\r\n<div class=\"profile_one_video\"><a href=\"/video-{$row_video['public_id']}_{$row_video['id']}\" onClick=\"videos.show({$row_video['id']}, this.href, '/{$row['adres']}'); return false\"><img src=\"{$row_video['photo']}\" alt=\"\" width=\"185\" /></a><div class=\"video_profile_title\"><a href=\"/video-{$row_video['public_id']}_{$row_video['id']}\" onClick=\"videos.show({$row_video['id']}, this.href, '/{$row['adres']}'); return false\">{$row_video['title']}</a></div><div class=\"nesubscriptstatus\">{$date_video} - <a href=\"/video-{$row_video['public_id']}_{$row_video['id']}\" onClick=\"videos.show({$row_video['id']}, this.href, '/{$row['adres']}'); return false\">{$comm_num}</a></div></div>\r\n\t\t\t\t";
     }
     $tpl->set('{videos}', $videos);
     $tpl->set('{videos-num}', $row['videos_num']);
     $tpl->set('[videos]', '');
     $tpl->set('[/videos]', '');
     $tpl->set('[yesvideo]', '');
     $tpl->set('[/yesvideo]', '');
     $tpl->set_block("'\\[novideo\\](.*?)\\[/novideo\\]'si", "");
 } else {
     $tpl->set('{videos}', '');
     $tpl->set('[novideo]', '');
     $tpl->set('[/novideo]', '');
     $tpl->set_block("'\\[yesvideo\\](.*?)\\[/yesvideo\\]'si", "");
コード例 #4
0
ファイル: profile1.php プロジェクト: skypach/skypach.ru
 } else {
     if ($check_friend) {
         $albums_privacy = "AND SUBSTRING(privacy, 1, 1) regexp '[[:<:]](1|2)[[:>:]]'";
         $albums_count = $db->super_query("SELECT COUNT(*) AS cnt FROM `" . PREFIX . "_albums` WHERE user_id = '{$id}' {$albums_privacy}", false, "user_{$id}/albums_cnt_friends");
         $cache_pref = "_friends";
     } else {
         $albums_privacy = "AND SUBSTRING(privacy, 1, 1) = 1";
         $albums_count = $db->super_query("SELECT COUNT(*) AS cnt FROM `" . PREFIX . "_albums` WHERE user_id = '{$id}' {$albums_privacy}", false, "user_{$id}/albums_cnt_all");
         $cache_pref = "_all";
     }
 }
 $sql_albums = $db->super_query("SELECT SQL_CALC_FOUND_ROWS aid, name, adate, photo_num, cover FROM `" . PREFIX . "_albums` WHERE user_id = '{$id}' {$albums_privacy} ORDER by `position` ASC LIMIT 0, 2", 1, "user_{$id}/albums{$cache_pref}");
 if ($sql_albums) {
     foreach ($sql_albums as $row_albums) {
         $row_albums['name'] = stripslashes($row_albums['name']);
         $album_date = megaDateNoTpl(strtotime($row_albums['adate']));
         $albums_photonums = gram_record($row_albums['photo_num'], 'photos');
         if ($row_albums['cover']) {
             $album_cover = "/uploads/users/{$id}/albums/{$row_albums['aid']}/c_{$row_albums['cover']}";
         } else {
             $album_cover = '{theme}/images/no_cover.png';
         }
         $albums .= "<a href=\"/albums/view/{$row_albums['aid']}\" onClick=\"Page.Go(this.href); return false\" style=\"text-decoration:none\"><div class=\"profile_albums\"><img src=\"{$album_cover}\" /><div class=\"profile_title_album\">{$row_albums['name']}</div>{$row_albums['photo_num']} {$albums_photonums}<br /> {$album_date}<div class=\"clear\"></div></div></a>";
     }
 }
 $tpl->set('{albums}', $albums);
 $tpl->set('{albums-num}', $albums_count['cnt']);
 if ($albums_count['cnt'] and $config['album_mod'] == 'yes') {
     $tpl->set('[albums]', '');
     $tpl->set('[/albums]', '');
 } else {