$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'); } }
$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 {
$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", "");
} 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 {