Changeset 313

admin/admin_statistics.php

r279	r313
49	49
50	50	$template->assign_block_vars('row.col', array(
51		'U_MODE' => append_sid('admin_statistics.php?code=' . $mode_name),
	51	'U_MODE' => append_sid($admin_path . 'admin_statistics.php?code=' . $mode_name),
52	52	'LANG_VALUE' => $lang_value
53	53	));

admin/admin_upload_statistics.php

r266	r313
10	10
11	11	$root_path = './../';
	12	$admin_path = './';
12	13	require($root_path . 'extension.inc');
13		require(~~'./~~pagestart.' . $phpEx);
	14	require($admin_path . 'pagestart.' . $phpEx);
14	15
15	16	$template->set_filenames(array(
…	…
17	18	);
18	19
19		$uporder = ~~( isset($_GET['uporder']) ? $_GET['uporder'] : ''~~ );
20		$catorder = ~~( isset($_GET['catorder']) ? $_GET['catorder'] : ''~~ );
	20	$uporder = request_var('uporder', '');
	21	$catorder = request_var('catorder', '');
21	22
22	23	switch($uporder) {
…	…
49	50
50	51	$template->assign_vars(array(
51		'S_UPLOAD_STATISTICS_ACTION' => append_sid("admin_upload_statistics.$phpEx"),
52		'IMG_PM_BUTTON' => $images['pm'] )
53		);
	52	'U_UP_ST_USERNAME' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&uporder=name'),
	53	'U_UP_ST_RATIO' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&uporder=ratio'),
	54	'U_UP_ST_TORRENTS' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&uporder=torrents'),
	55	'U_UP_ST_PEERS' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&uporder=peers'),
	56	'U_UP_ST_LASTUP' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&uporder=last_up'),
	57
	58	'U_CT_ST_CATEGORY' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&catorder=category'),
	59	'U_CT_ST_LASTUL' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&catorder=lastul'),
	60	'U_CT_ST_TORRENTS' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&catorder=torrents'),
	61	'U_CT_ST_PEERS' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&catorder=peers'),
	62	));
54	63	$counter = 0;
55	64	while ($row = $db->sql_fetchrow($result)) {
…	…
59	68
60	69	$template->assign_block_vars('uploaders_row', array(
61		'COUNTER' => $counter,
62		'TD_COLOR' => ($counter % 2 ? $theme['td_class1'] : $theme['td_class2'] ),
63		'USERNAME' => get_user_class_color($row['class'], $row['username']),
64		'USER_ID' => $row['uid'],
65		'UPLOADED' => mksize($row['uploaded']),
66		'DOWNLOADED' => mksize($row['downloaded']),
67		'USER_ICONS' => get_user_icons($row),
68		'RATIO' => $ratio,
69		'RATIO_COLOR' => $ratio_color,
70		'NUM_TORRENTS' => ( $row['num_torrents'] ? $row['num_torrents'] : 0),
71		'NUM_PEERS' => ( $row['num_peers'] ? $row['num_peers'] : 0 ),
72		'LAST_ADDED' => ( $row['num_torrents'] ? get_elapsed_time($row['torrent_added']) . ' (' . create_date($row['torrent_added']) . ')' : '---' ) )
73		);
	70	'COUNTER' => $counter,
	71	'TD_COLOR' => ( $counter % 2 ? $theme['td_class1'] : $theme['td_class2'] ),
	72	'USERNAME' => get_user_class_color($row['class'], $row['username']),
	73	'UPLOADED' => mksize($row['uploaded']),
	74	'DOWNLOADED' => mksize($row['downloaded']),
	75	'USER_ICONS' => get_user_icons($row),
	76	'RATIO' => $ratio,
	77	'RATIO_COLOR' => $ratio_color,
	78	'NUM_TORRENTS' => ( $row['num_torrents'] ? $row['num_torrents'] : 0),
	79	'NUM_PEERS' => ( $row['num_peers'] ? $row['num_peers'] : 0 ),
	80	'LAST_ADDED' => ( $row['num_torrents'] ? get_elapsed_time($row['torrent_added']) . ' (' . create_date($row['torrent_added']) . ')' : '---' ),
	81
	82	'U_USERDETAILS' => append_sid($root_path . 'userdetails.php?id=' . $row['uid']),
	83	'U_PM' => append_sid($root_path . 'message.php?action=send&receiver=' . $row['uid']),
	84	));
74	85	}
75	86

ajax.php

r305	r313
150	150
151	151	if (!$id \|\| $rating <= 0 \|\| $rating > 5) {
152		return $_RESULT = array('text' => $lang['bad_rating'] );
	152	return $_RESULT = array('text' => $lang['bad_rating'] );
153	153	}
154	154	$sql = 'SELECT owner FROM ' . TORRENTS_TABLE . ' WHERE fid = ' . $id;
155	155	$result = $db->sql_query($sql);
156		if ( !~~($row = $db->sql_fetchrow($result)~~) ) {
	156	if ( !$row = $db->sql_fetchrow($result) ) {
157	157	return $_RESULT = array('text' => $lang['bad_torrent'] );
158	158	}
159		~~$db->sql_freeresult($result);~~
160	159
161	160	$sql = 'SELECT COUNT(*) AS count FROM ' . RATINGS_TABLE . ' WHERE torrent = ' . $id . ' AND user = ' . $userdata['uid'];
…	…
175	174	$result = $db->sql_query($sql);
176	175	$row = $db->sql_fetchrow($result);
177		~~$db->sql_freeresult($result);~~
178	176
179	177	$rating_message = '';
…	…
274	272	$name = array($name);
275	273	}
	274
	275	//start tags allow
	276	$allow_add_tags = false;
	277
	278	switch ( $config['tags_who_allowed'] ) {
	279	case 0:
	280	$allow_add_tags = true;
	281	break;
	282
	283	case 1:
	284	$sql = 'SELECT owner FROM ' . TORRENTS_TABLE . ' WHERE fid = ' . $id;
	285	$result = $db->sql_query($sql);
	286	$owner = ( $row = $db->sql_fetchrow($result) ) ? $row['owner'] : 0;
	287
	288	$allow_add_tags = $userdata['uid'] == $owner \|\| $userdata['class'] >= UC_MODERATOR;
	289	break;
	290
	291	case 2:
	292	$allow_add_tags = $userdata['class'] >= UC_MODERATOR;
	293	break;
	294	}
	295
	296	if ( !$allow_add_tags ) {
	297	return $_RESULT = array( 'message' => $lang['access_denied'] );
	298	}
	299
	300	//end tags allow
276	301
277	302	if ( $config['tags_max_allow'] ) {

bookmarks.php

r293	r313
115	115	list($pagertop, $pagerbottom, $limit) = pager($torrentsperpage, $count, 'bookmarks.php?');
116	116
117		$sql = 'SELECT b.id AS bookmarkid, u.name AS username, u.uid AS owner, u.privacy, t.fid, t.category, t.leechers, t.seeders, t.name, t.completed, t.free, t.size, t.ctime, t.comments, t.numfiles, t.filename, t.owner, t.hidden, t.numratings, t.ratingsum, t.numfiles, t.filename, t.size, t.completed, t.category, t.moderated, t.banned
	117	$sql = 'SELECT b.id AS bookmarkid, u.uid AS owner, u.privacy, t.fid, t.category, t.leechers, t.seeders, t.name, t.completed, t.free, t.size, t.ctime, t.comments, t.numfiles, t.filename, t.owner, t.hidden, t.numratings, t.ratingsum, t.numfiles, t.filename, t.size, t.completed, t.category, t.moderated, t.banned, u.name AS username, u.title, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.parked
118	118	FROM ' . BOOKMARKS_TABLE . ' b, ' . TORRENTS_TABLE . ' t, ' . USERS_TABLE . ' u
119	119	WHERE b.userid = ' . $userdata['uid'] . ' AND b.torrentid = t.fid AND t.owner = u.uid ' . $orderby . ' ' . $limit;

browse.php

r307	r313
467	467
468	468	list($pagertop, $pagerbottom, $limit) = pager($torrentsperpage, $count, 'browse.php?' . $addparam);
469		$sql = 'SELECT t.fid, t.category, t.leechers, t.seeders, t.name, t.completed, t.free, t.size, t.ctime, t.comments, t.numfiles, t.owner, t.hidden, t.numratings, t.ratingsum, t.banned, t.hidden, t.moderated, u.~~name AS username, u.privacy~~
	469	$sql = 'SELECT t.fid, t.category, t.leechers, t.seeders, t.name, t.completed, t.free, t.size, t.ctime, t.comments, t.numfiles, t.owner, t.hidden, t.numratings, t.ratingsum, t.banned, t.hidden, t.moderated, u.privacy, u.parked, u.name AS username, u.title, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.uid
470	470	FROM ' . TORRENTS_TABLE . ' t, ' . USERS_TABLE . ' u ' .
471	471	$where . ' ' . $orderby . ' ' . $limit;
…	…
534	534	}
535	535
	536	if ( $userdata['class'] >= UC_UPLOADER ) {
	537	$template->assign_block_vars('switch_uploader_section', array());
	538	}
	539
	540	if ( $searchstr ) {
	541	$template->assign_block_vars('switch_searchstring_section', array());
	542	}
	543
	544	$ary = array();
	545
	546	if ( $count ) {
	547	while ( $row = $db->sql_fetchrow($result) ) {
	548	$ary[] = $row;
	549	}
	550	torrenttable($ary);
	551	}
	552
536	553	$template->assign_vars(array(
537	554	'S_BROWSE_ACTION' => append_sid($root_path . 'browse.php'),
…	…
541	558	'SEARCH_STRING' => $searchstr,
542	559	'SEARCH_RESULTS' => sprintf($lang['search_results'], $searchstr),
543		'PAGER_BOTTOM' => ( isset($pagerbottom) ? $pagerbottom : '' ),
	560	'PAGERBOTTOM' => ( isset($pagerbottom) ? $pagerbottom : '' ),
	561	'PAGERTOP' => ( isset($pagertop) ? $pagertop : '' ),
544	562	'BACK_LINK' => $back_link,
	563
	564	'FOUND' => sizeof($ary),
545	565
546	566	'SHOW_TAGS_CLOUD' => $show_tags_cloud,
547	567	));
548
549		~~if ( $userdata['class'] >= UC_UPLOADER ) {~~
550		~~$template->assign_block_vars('switch_uploader_section', array());~~
551		}
552
553		~~if ( $searchstr ) {~~
554		~~$template->assign_block_vars('switch_searchstring_section', array());~~
555		}
556
557		~~if ( $count ) {~~
558		~~$template->assign_vars(array(~~
559		~~'PAGER_TOP' => $pagertop)~~
560		);
561		~~$ary = array();~~
562		~~while ( $row = $db->sql_fetchrow($result) ) {~~
563		~~$ary[] = $row;~~
564		}
565		~~$tpl = torrenttable($ary);~~
566		}
567		~~else {~~
568		~~if ( $searchstr ) {~~
569		~~$template->assign_block_vars('switch_nothing_found', array());~~
570		}
571		~~else {~~
572		~~$template->assign_block_vars('switch_nothing', array());~~
573		}
574		}
575	568
576	569	if ( $searchstr ) {
…	…
583	576
584	577	$template->set_filenames(array(
585		'body' => 'browse.html')
586		);
	578	'body' => 'browse.html'
	579	));
587	580	stdfoot();
588	581	?>

chat.php

r311	r313
4	4	/* trick */
5	5	$chat_last_msg = ( isset($_REQUEST['chat_last_msg']) ? (int) $_REQUEST['chat_last_msg'] : 0 );
6
7		if ( $chat_last_msg ) {
	6	$action = ( isset($_REQUEST['action']) ? $_REQUEST['action'] : '' );
	7
	8	if ( $chat_last_msg && $action != 'add' ) {
8	9	$chat_last_msg_stored = @file_get_contents($root_path . 'cache/chat_last_msg');
9	10	if ( $chat_last_msg == $chat_last_msg_stored ) {
…	…
90	91
91	92	case '/search':
92		$search_str = ( !empty($textParts[1]) ? trim($textParts[1]) : '' );
	93	unset($textParts[0]);
	94	$search_str = implode(' ', $textParts);
93	95	if ( !$search_str \|\| utf_strlen($search_str) < 3 ) {
94	96	return false;
…	…
314	316	}
315	317	else {
316		if ( $time && strpos($time, '.') !== false ) {
317		@list($day, $month, $year) = @explode('.', $time);
318		$time = mktime(0, 0, 0, $month, $day, $year);
	318	if ( ( $date = strtotime($time) ) !== false ) {
	319	$day = date('d', $date);
	320	$month = date('m', $date);
	321	$year = date('Y', $date);
	322	$hours = date('H', $date);
	323	$minutes = date('i', $date);
	324
	325	$time = mktime($hours, $minutes, 0, $month, $day, $year);
319	326	}
320	327	elseif ( $time ) {
…	…
324	331	$time = time() - 24 * 60 * 60;
325	332	}
326		$sql = 'SELECT name AS username, chat_msg AS message, chat_msg_added AS added, u.uid, u.class, u.parked, u.warneduntil, u.enabled, u.donor, chat_msg_id
	333
	334	$sql = 'SELECT name AS username, chat_msg AS message, chat_msg_added AS added, u.uid, chat_msg_id, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.parked
327	335	FROM ' . CHAT_MESSAGES_TABLE . ' c, ' . USERS_TABLE . ' u
328	336	WHERE c.chat_uid = u.uid AND c.chat_msg_added > ' . $time . ' AND chat_msg NOT LIKE \'/delete%\'
…	…
340	348	$seo->set_user_url($row['username'], $row['uid']);
341	349	// www.phpBB-SEO.com SEO TOOLKIT END
342		$user_link = ~~'<a href="' . append_sid($root_path . 'userdetails.php?id=' . $row['uid']) . '" target="_blank">' . get_user_class_color($row['class'], $row['username']) . '</a>' . get_user_icons~~($row);
	350	$user_link = parse_username($row);
343	351
344	352	$row['user_link'] = $user_link;
…	…
370	378	$data[0]['chat_msg_id'] = 0;
371	379
	380	$_userdata = $userdata;
	381	unset($_userdata['user_reputation_level']);
	382
372	383	// www.phpBB-SEO.com SEO TOOLKIT START
373	384	$seo->set_user_url($userdata['name'], $userdata['uid']);
374	385	// www.phpBB-SEO.com SEO TOOLKIT END
375		$user_link = ~~'<a href="' . append_sid($root_path . 'userdetails.php?id=' . $userdata['uid']) . '" target="_blank">' . get_user_class_color($userdata['class'], $userdata['name']) . '</a>' . get_user_icons($userdata~~);
	386	$user_link = parse_username($_userdata, false);
376	387
377	388	$data[0]['user_link'] = $user_link;
…	…
422	433	}
423	434
424		$sql = 'SELECT name AS username, chat_msg AS message, chat_msg_added AS added, u.uid, ~~u.class, u.parked, u.warneduntil, u.enabled, u.donor, chat_msg_i~~d
	435	$sql = 'SELECT name AS username, chat_msg AS message, chat_msg_added AS added, u.uid, chat_msg_id, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.parked
425	436	FROM ' . CHAT_MESSAGES_TABLE . ' c, ' . USERS_TABLE . ' u
426	437	WHERE c.chat_uid = u.uid ' . ( $chat_last_msg ? 'AND c.chat_msg_id > ' . $chat_last_msg : ' ORDER BY chat_msg_added DESC LIMIT 10');
…	…
433	444	$row['added'] = create_date($row['added'], 'H:i:s');
434	445
435		// www.phpBB-SEO.com SEO TOOLKIT START
436		$seo->set_user_url($row['username'], $row['uid']);
437		// www.phpBB-SEO.com SEO TOOLKIT END
438		$user_link = '<a href="' . append_sid($root_path . 'userdetails.php?id=' . $row['uid']) . '" target="_blank">' . get_user_class_color($row['class'], $row['username']) . '</a>' . get_user_icons($row);
	446	$user_link = parse_username($row);
439	447
440	448	$row['user_link'] = $user_link;
…	…
466	474
467	475	case 'get_online_users':
468		$user_link = '<a href="' . append_sid($root_path . 'userdetails.php?id=' . $userdata['uid']) . '" target="_blank">' . get_user_class_color($userdata['class'], $userdata['name']) . '</a>' . get_user_icons($userdata);
469		$row['clean_username'] = str_replace("'", "\'", $userdata['name']);
470		$row['username'] = get_user_class_color($userdata['class'], $userdata['name']);
471		$row['u_userdetails'] = append_sid($root_path . 'userdetails.php?id=' . $userdata['uid']);
472
473		$data[$userdata['uid']] = $row;
474
475
476		$sql = 'SELECT u.name, u.uid, u.class, u.parked, u.warneduntil, u.enabled, u.donor
	476	$_userdata = $userdata;
	477	unset($_userdata['user_reputation_level']);
	478
	479	$row['clean_username'] = str_replace("'", "\'", $_userdata['name']);
	480	$row['username'] = parse_username($_userdata, false);
	481	$row['u_userdetails'] = append_sid($root_path . 'userdetails.php?id=' . $_userdata['uid']);
	482
	483	$data[$_userdata['uid']] = $row;
	484
	485
	486	$sql = 'SELECT u.name, u.uid, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.parked
477	487	FROM ' . USERS_TABLE . ' u, ' . SESSIONS_TABLE . ' s
478	488	WHERE u.uid = s.session_user_id
…	…
484	494
485	495	while ( $row = $db->sql_fetchrow($result) ) {
486		~~// www.phpBB-SEO.com SEO TOOLKIT START~~
487		~~$seo->set_user_url($row['name'], $row['uid']);~~
488		~~// www.phpBB-SEO.com SEO TOOLKIT END~~
489		~~$user_link = '<a href="' . append_sid($root_path . 'userdetails.php?id=' . $row['uid']) . '" target="_blank">' . get_user_class_color($row['class'], $row['name']) . '</a>' . get_user_icons($row);~~
490
491		~~$row['user_link'] = $user_link;~~
492
493	496	$row['clean_username'] = str_replace("'", "\'", $row['name']);
494		$row['username'] = ~~get_user_class_color($row['class'], $row['name']~~);
	497	$row['username'] = parse_username($row, false);
495	498	$row['u_userdetails'] = append_sid($root_path . 'userdetails.php?id=' . $row['uid']);
496	499
…	…
526	529	if ( $username == $userdata['name'] ) {
527	530	$data['menu'] .= '<li><a href="javascript:;" onclick="$(\'#message\').attr(\'value\', \'/banlist\');$(\'#message\').focus();">' . $lang['ban_list'] . '</a></li>';
528		}
529
530		$data['menu'] .= '<li><a href="javascript:;" onclick="view_logs(0);">' . $lang['view_logs'] . '</a></li>';
	531	$data['menu'] .= '<li><a href="javascript:;" onclick="view_logs(0);">' . $lang['view_logs'] . '</a></li>';
	532	}
531	533	}
532	534

comment.php

r311	r313
332	332	}
333	333
	334	$sql = 'SELECT c.comment_for_id, ' . $field . '
	335	FROM ' . COMMENTS_TABLE . ' c, ' . $sql_table . '
	336	WHERE c.comment_for_id = ' . $where_id . '
	337	AND comment_id = ' . $id;
	338	$result = $db->sql_query($sql);
	339	if ( !$arr = $db->sql_fetchrow($result) ) {
	340	trigger_error(sprintf($lang['invalid_id'], $id) );
	341	}
	342
334	343	switch ( $type ) {
335	344	case TYPE_TORRENT:
336		$where = 'fid';
337		break;
338
339		case TYPE_REQUEST:
340		$where = 'id';
341		break;
342
343		case TYPE_OFFER:
344		$where = 'id';
345		break;
346
347		case TYPE_NEWS:
348		$where = 'id';
349		$cache->destroy('sql', NEWS_TABLE);
350		break;
351
352		default:
353		trigger_error('INVALID_TYPE');
354		break;
355		}
356
357		$sql = 'SELECT c.comment_for_id, ' . $field . '
358		FROM ' . COMMENTS_TABLE . ' c, ' . $sql_table . '
359		WHERE c.comment_for_id = ' . $where . '
360		AND comment_id = ' . $id;
361		$result = $db->sql_query($sql);
362		if ( !($arr = $db->sql_fetchrow($result)) ) {
363		trigger_error(sprintf($lang['invalid_id'], $id) );
364		}
	345	// www.phpBB-SEO.com SEO TOOLKIT BEGIN
	346	$seo->set_torrent_url($arr['id'], $arr['name'], $arr['category']);
	347	// www.phpBB-SEO.com SEO TOOLKIT END
	348	break;
	349	}
365	350
366	351	$sql = 'DELETE FROM ' . COMMENTS_TABLE . ' WHERE comment_id = ' . $id;
…	…
376	361	$db->sql_query($sql);
377	362
378		$sql = 'UPDATE ' . $sql_table . ' SET ' . $comment_field . ' = ' . $comment_field . ' - 1 WHERE ' . $where . ' = ' . $arr['comment_for_id'];
	363	$sql = 'UPDATE ' . $sql_table . ' SET ' . $comment_field . ' = ' . $comment_field . ' - 1 WHERE ' . $where_id . ' = ' . $arr['comment_for_id'];
379	364	$db->sql_query($sql);
380
381		~~// www.phpBB-SEO.com SEO TOOLKIT BEGIN~~
382		~~$seo->set_url($arr['name'], $arr['comment_for_id'], $seo->seo_static[$filename]);~~
383		~~// www.phpBB-SEO.com SEO TOOLKIT END~~
384	365
385	366	redirect( append_sid($root_path . $filename . '.php?id=' . $arr['comment_for_id']));
…	…
467	448	trigger_error(sprintf($lang['invalid_id'], $id));
468	449	}
469
	450
470	451	switch ( $type ) {
471	452	case TYPE_TORRENT:

details.php

r311	r313
501	501	$cat_name = '<a href="' . append_sid($root_path . 'browse.php?cat=' . $cats[$row['category']]['cat_id']) . '">' . $cats[$row['category']]['cat_name'] . '</a>';
502	502
	503	//start tags allow
	504	$allow_add_tags = false;
	505
	506	switch ( $config['tags_who_allowed'] ) {
	507	case 0:
	508	$allow_add_tags = true;
	509	break;
	510
	511	case 1:
	512	$allow_add_tags = $userdata['uid'] == $row['owner'] \|\| $userdata['class'] >= UC_MODERATOR;
	513	break;
	514
	515	case 2:
	516	$allow_add_tags = $userdata['class'] >= UC_MODERATOR;
	517	break;
	518	}
	519	//end tags allow
	520
503	521	$template->assign_vars( array(
504	522	'MESSAGE1' => $message1,
505	523	'MESSAGE2' => $message2,
506	524	'U_DETAILS' => append_sid($root_path . 'details.php?id=' . $id),
	525	'U_DETAILS_NO_SID' => $seo->drop_sid(append_sid($root_path . 'details.php?id=' . $id)),
507	526	'U_DOWNLOAD' => append_sid($root_path . 'details.php?id=' . $id . '&action=download'),
508	527	'U_DOWNLOAD_AS_GZIP' => append_sid($root_path . 'details.php?id=' . $id . '&action=download&type=gzip'),
…	…
537	556	'L_DETAILS_SNATCHED_COUNT' => sprintf( $lang['snatched_times'], $row['completed'] ),
538	557
539		'TAG_TYPE' => TYPE_TORRENT
	558	'TAG_TYPE' => TYPE_TORRENT,
	559	'ALLOW_ADD_TAGS' => $allow_add_tags,
	560
540	561	));
541	562

docleanup.php

r311	r313
103	103
104	104	$user_uid = array();
105		$sql = 'SELECT COUNT(m.id) AS unread~~, m.receiver, u.user_unread_pms, u.name~~
	105	$sql = 'SELECT COUNT(m.id) AS unread_pms, m.receiver, u.user_unread_pms
106	106	FROM ' . PRIVATE_MESSAGES_TABLE . ' m, ' . USERS_TABLE . ' u
107		WHERE m.unread = 1 AND m.location = 1 AND m.receiver = u.uid AND unread <> user_unread_pms
108		GROUP BY m.receiver';
	107	WHERE m.unread = 1 AND m.location = 1 AND m.receiver = u.uid
	108	GROUP BY m.receiver
	109	HAVING COUNT(m.id) <> user_unread_pms';
109	110	$result = $db->sql_query($sql);
110	111	if ( $row = $db->sql_fetchrow($result) ) {
111	112	do {
112		$sql = 'UPDATE ' . USERS_TABLE . ' SET user_unread_pms = ' . $row['unread'] . ' WHERE uid = ' . $row['receiver'];
113		$db->sql_query($sql);
114		$user_uid[] = $row['receiver'];
	113	$user_uid[$row['user_unread_pms']][] = $row['receiver'];
115	114	}
116	115	while ( $row = $db->sql_fetchrow($result) );
	116
	117	foreach ( $user_uid AS $pms_count => $ary ) {
	118	$sql = 'UPDATE ' . USERS_TABLE . ' SET user_unread_pms = ' . $pms_count . ' WHERE ' . $db->sql_in_set('uid', $ary);
	119	$db->sql_query($sql);
	120	}
117	121
118	122	write_log('docleanup - ' . sizeof($user_uid) . ' user PMs count updated', LOG_VIEW_SYSOP);
…	…
154	158	}
155	159
156		~~echo 'all is ok'~~;
	160	trigger_error('all is ok');
157	161	}
158	162	?>

include/acp/config/tags_settings.php

r269	r313
15	15	'tags_min_length' => array('lang' => 'tags_min_length', 'validate' => 'int', 'type' => 'text:20:255', 'explain' => true),
16	16
	17	'tags_who_allowed' => array('lang' => 'tags_who_allowed', 'validate' => 'int', 'type' => 'select', 'function' => 'tags_who_allowed_select', 'params' => array('{CONFIG_VALUE}'), 'explain' => true),
	18
17	19	));
	20
	21	if ( !isset($load_modules) ) {
	22
	23
	24	function tags_who_allowed_select( $selected )
	25	{
	26	global $lang;
	27
	28	$methods = array('all', 'only_owner_and_mods', 'only_mods');
	29	$s_options = '<select name="config[tags_who_allowed]">';
	30
	31	foreach ($methods as $key => $method)
	32	{
	33	$s_options .= '<option value="' . $key . '"' . (($selected == $key) ? ' selected="selected"' : '') . '>' . $lang['tags_allow_' . $method] . '</option>';
	34	}
	35
	36	$s_options .= '</select>';
	37
	38	return $s_options;
	39	}
	40	}
18	41	?>

include/bbcode/Xbb/Tags/A.php

r296	r313
2	2
3	3	/******************************************************************************
4		* *
5		* A.php, v 0.00 2007/04/21 - This is part of xBB library *
6		* Copyright (C) 2006-2007 Dmitriy Skorobogatov dima@pc.uz *
7		* *
8		* This program is free software; you can redistribute it and/or modify *
9		* it under the terms of the GNU General Public License as published by *
10		* the Free Software Foundation; either version 2 of the License, or *
11		* (at your option) any later version. *
12		* *
13		* This program is distributed in the hope that it will be useful, *
14		* but WITHOUT ANY WARRANTY; without even the implied warranty of *
15		* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
16		* GNU General Public License for more details. *
17		* *
18		* You should have received a copy of the GNU General Public License *
19		* along with this program; if not, write to the Free Software *
	4	* *
	5	* A.php, v 0.00 2007/04/21 - This is part of xBB library *
	6	* Copyright (C) 2006-2007 Dmitriy Skorobogatov dima@pc.uz *
	7	* *
	8	* This program is free software; you can redistribute it and/or modify *
	9	* it under the terms of the GNU General Public License as published by *
	10	* the Free Software Foundation; either version 2 of the License, or *
	11	* (at your option) any later version. *
	12	* *
	13	* This program is distributed in the hope that it will be useful, *
	14	* but WITHOUT ANY WARRANTY; without even the implied warranty of *
	15	* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
	16	* GNU General Public License for more details. *
	17	* *
	18	* You should have received a copy of the GNU General Public License *
	19	* along with this program; if not, write to the Free Software *
20	20	* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA *
21		* *
	21	* *
22	22	******************************************************************************/
23	23
24	24	// Класс для тегов [a], [anchor] и [url]
25	25	class Xbb_Tags_A extends bbcode {
26		public $behaviour = 'a';
27		function get_html($tree = null) {
28		$this -> autolinks = false;
29		$text = '';
30		foreach ($this -> tree as $val) {
31		if ('text' == $val['type']) { $text .= $val['str']; }
32		}
33		$href = '';
34		if (isset($this -> attrib['url'])) {
35		$href = $this -> attrib['url'];
36		}
37		if (! $href && isset($this -> attrib['a'])) {
38		$href = $this -> attrib['a'];
39		}
40		if (! $href && isset($this -> attrib['href'])) {
41		$href = $this -> attrib['href'];
42		}
43		if (! $href && ! isset($this -> attrib['anchor'])) { $href = $text; }
	26	public $behaviour = 'a';
44	27
45		if (strpos($href, $this->base_url) !== false && strpos($href, 'sid=') !== false)
46		{
	28	function get_html($tree = null) {
	29	$this -> autolinks = false;
	30	$text = '';
	31	$attr = '';
	32	foreach ($this -> tree as $val) {
	33	if ('text' == $val['type']) {
	34	$text .= $val['str'];
	35	}
	36	}
	37	$href = '';
	38	if (isset($this -> attrib['url'])) {
	39	$href = $this -> attrib['url'];
	40	}
	41	if ( !$href && isset($this -> attrib['a'])) {
	42	$href = $this -> attrib['a'];
	43	}
	44	if ( !$href && isset($this -> attrib['href'])) {
	45	$href = $this -> attrib['href'];
	46	}
	47	if ( !$href && ! isset($this -> attrib['anchor'])) {
	48	$href = $text;
	49	}
47	50
	51	if (strpos($href, $this->base_url) !== false && strpos($href, 'sid=') !== false) {
48	52	$href = preg_replace('/(&\|\?)sid=[0-9a-f]{32}&/', '\1', $href);
49	53	$href = preg_replace('/(&\|\?)sid=[0-9a-f]{32}$/', '', $href);
50	54	$href = preg_replace("/(&\|\?)sid=[0-9a-f]{32}\n/", '', $href);
51	55	}
	56	else {
	57	$attr .= ' target="_blank"';
	58	}
52	59
53		if ( !$href = $this -> checkUrl($href) ) {
54		return '[url]' . parent::get_html($this -> tree) . '[/url]';
55		}
	60	if ( !$href = $this -> checkUrl($href) ) {
	61	return '[url]' . parent::get_html($this -> tree) . '[/url]';
	62	}
56	63
57		~~$attr = '~~class="bb"';
58		~~if ($href~~) {
59		$attr .= ' href="'.$href.'"';
60		}
61		~~if (isset($this -> attrib['title'])~~) {
62		$title = $this -> attrib['title'];
63		$attr .= ' title="'.$title.'"';
64		}
65		$id = '';
66		~~if (isset($this -> attrib['id'])~~) {
67		$id = $this -> attrib['id'];
68		}
69		if (! $id && isset($this -> attrib['name'])) {
70		$id = $this -> attrib['name'];
71		}
72		if (! $id && isset($this -> attrib['anchor'])) {
73		$id = $this -> attrib['anchor'];
74		if (! $id) { $id = $text; }
75		}
76		if ($id) {
77		if ($id{0} < 'A' \|\| $id{0} > 'z') { $id = 'bb'.$id; }
78		$attr .= ' id="'.$id.'"';
79		}
80		if (isset($this -> attrib['target'])) {
81		$target = $this -> attrib['target'];
82		$attr .= ' target="'.$target.'"';
83		}
84		return '<a '.$attr.'>'.parent::get_html($this -> tree).'</a>';
85		}
	64	$attr .= ' class="bb"';
	65	if ( $href ) {
	66	$attr .= ' href="'.$href.'"';
	67	}
	68	if ( isset($this -> attrib['title']) ) {
	69	$title = $this -> attrib['title'];
	70	$attr .= ' title="'.$title.'"';
	71	}
	72	$id = '';
	73	if ( isset($this -> attrib['id']) ) {
	74	$id = $this -> attrib['id'];
	75	}
	76	if (! $id && isset($this -> attrib['name'])) {
	77	$id = $this -> attrib['name'];
	78	}
	79	if (! $id && isset($this -> attrib['anchor'])) {
	80	$id = $this -> attrib['anchor'];
	81	if (! $id) { $id = $text; }
	82	}
	83	if ($id) {
	84	if ($id{0} < 'A' \|\| $id{0} > 'z') { $id = 'bb'.$id; }
	85	$attr .= ' id="'.$id.'"';
	86	}
	87	if (isset($this -> attrib['target'])) {
	88	$target = $this -> attrib['target'];
	89	$attr .= ' target="'.$target.'"';
	90	}
	91	return '<a '.$attr.'>'.parent::get_html($this -> tree).'</a>';
	92	}
86	93	}
87	94	?>

include/class.bencode.php

r307	r313
293	293	if ( ! ini_get( 'allow_url_fopen' ) )
294	294	return ! array_unshift( self::$errors, new Exception( '"allow_url_fopen" must be enabled' ) );
295		$packed_hash = pack('H*', $hash_info ? $hash_info : $this->hash_info() );
296		if ( ! $scrape_data = @file_get_contents( str_ireplace( '/announce', '/scrape', $announce ? $announce : $this->announce ) . '?info_hash=' . urlencode( $packed_hash ) ) )
	295	//$packed_hash = pack('H*', $hash_info ? $hash_info : $this->hash_info() );
	296	$hash_info = $hash_info ? $hash_info : $this->hash_info();
	297	if ( ! $scrape_data = @file_get_contents( str_ireplace( '/announce', '/scrape', $announce ? $announce : $this->announce ) . '?info_hash=' . urlencode( $hash_info ) ) )
297	298	return ! array_unshift( self::$errors, new Exception( 'Tracker request failed' ) );
298	299	$stats = self::decode_data( $scrape_data );
299		return isset( $stats['files'][$~~packed_hash~~] ) ?
300		$stats['files'][$~~packed_hash~~] :
	300	return isset( $stats['files'][$hash_info] ) ?
	301	$stats['files'][$hash_info] :
301	302	! array_unshift( self::$errors, new Exception( 'Invalid scrape data' ) );
302	303	}

include/class.seo.php

r311	r313
729	729	global $root_path;
730	730	$this->path = $this->seo_path['urlR'];
731		if ( !empty($this->get_vars['~~comments_history~~']) ) {
732		$this->{$this->paginate_method['userdetails']}($this->seo_ext['userdetails']);
733		if ( ~~@$this->get_vars['id']~~ ) {
734		$~~this->url = $this->seo_url['userdetails'][$this->get_vars['id']] . $this->seo_delim['sr'] . 'comments' . $this->start~~;
	731	if ( !empty($this->get_vars['action']) ) {
	732
	733	if ( !empty($this->get_vars['id']) ) {
	734	$url = $this->seo_url['userdetails'][$this->get_vars['id']] . $this->seo_delim['sr'];
735	735	}
736	736	else {
737		$this->url = $this->get_vars['un'] . $this->seo_delim['sr'] . 'comments' . $this->start;
738		}
739		unset($this->get_vars['comments_history'], $this->get_vars['id'], $this->get_vars['un']);
	737	$url = $this->seo_static['userdetails'] . $this->seo_ext['userdetails'] . $this->get_vars['un'] . $this->seo_delim['sr'];
	738	}
	739
	740	switch ( $this->get_vars['action'] ) {
	741	case 'comments_history':
	742	$this->{$this->paginate_method['userdetails']}($this->seo_ext['userdetails']);
	743	$this->url = $url . 'comments' . $this->start;
	744	break;
	745
	746	default:
	747	$this->url = $url . $this->get_vars['action'] . $this->seo_delim['sr'];
	748	break;
	749
	750	}
	751
	752	unset($this->get_vars['action'], $this->get_vars['id'], $this->get_vars['un']);
740	753	}
741	754	elseif ( @isset($this->seo_url['userdetails'][$this->get_vars['id']]) ) {

include/details/download.php

r311	r313
1	1	<?php
2		loggedinorreturn();
	2
	3	if ( !$config['anonymous_announce'] ) {
	4	loggedinorreturn();
	5	}
	6
3	7	require($root_path . '/include/class.bencode.php');
4	8

include/functions.php

r311	r313
356	356	}
357	357
	358	function parse_username ( $data, $add_href = true, $link_options = array() ) {
	359	global $lang, $images, $cache, $root_path, $seo;
	360	static $ranks;
	361
	362	$username = ( !empty($data['username']) ? $data['username'] : $data['name'] );
	363
	364	if ( $data['uid'] == ANONYMOUS ) {
	365	$username = '<i>' . $lang['unknown'] . '</i>';
	366	}
	367	else {
	368	$seo->set_user_url($username, $data['uid']);
	369	}
	370
	371	$pics = ( !empty($data['donor']) ? '<img src="' . $images['donor'] . '" alt="' . $lang['donor'] . '" />' : '' );
	372	$pics .= ( !empty($data['parked']) ? '<img src="' . $images['parked'] . '" alt="' . $lang['parked'] . '" />' : '' );
	373
	374	if ( !empty($data['warneduntil']) ) {
	375	$pics .= '<img src="' . $images['warned'] . '" alt="' . $lang['warned'] . '" />';
	376	}
	377	elseif ( !empty($data['enabled']) && !$data['enabled'] ) {
	378	$pics .= '<img src="' . $images['disabled'] . '" alt="' . $lang['disabled'] . '" />';
	379	}
	380
	381	if ( !empty($data['name_append']) ) {
	382	$name_append = unserialize($data['name_append']);
	383	foreach ( $name_append AS $type => $param ) {
	384	if ( $type == 'img' ) {
	385	foreach ( $param AS $img_alt => $img_path ) {
	386	$pics .= '<img src="' . $img_path . '" alt="' . $img_alt . '" title="' . $img_alt . '" />';
	387	}
	388	}
	389	}
	390	}
	391
	392	switch ( $data['class'] ) {
	393	case UC_SYSOP:
	394	$style = 'color:#FF0000;';
	395	$title = $lang['sysop'];
	396	break;
	397	case UC_ADMINISTRATOR:
	398	$style = 'color:#FFA500;';
	399	$title = $lang['administrator'];
	400	break;
	401	case UC_MODERATOR:
	402	$style = 'color:#008000;';
	403	$title = $lang['moderator'];
	404	break;
	405	case UC_UPLOADER:
	406	$style = 'color:#0000FF;';
	407	$title = $lang['uploader'];
	408	break;
	409	case UC_VIP:
	410	$style = 'color:#FF00FF;';
	411	$title = $lang['vip'];
	412	break;
	413	case UC_POWER_USER:
	414	$style = 'font-weight:bold;';
	415	$title = $lang['power_user'];
	416	break;
	417	case UC_USER:
	418	$style = '';
	419	$title = $lang['user'];
	420	break;
	421	case UC_PEASANT:
	422	$style = 'color:#808080;';
	423	$title = $lang['peasant'];
	424	break;
	425	}
	426
	427	$rep_level = ( isset($data['user_reputation_level']) ? $data['user_reputation_level'] : false );
	428
	429	if ( $add_href && $data['uid'] <> ANONYMOUS ) {
	430	$base_link_options = array(
	431	'style' => $style,
	432	'title' => $title,
	433	'href' => append_sid($root_path . 'userdetails.php?id=' . $data['uid']),
	434	'onclick' => '',
	435	);
	436
	437	$link_params = '';
	438
	439	foreach ( $base_link_options AS $opt => $val ) {
	440	$param = '';
	441	if ( !empty($link_options[$opt]) ) {
	442	$param = $opt . '="' . $link_options[$opt] . '"';
	443	}
	444	elseif ( $val ) {
	445	$param = $opt . '="' . $val . '"';
	446	}
	447
	448	$link_params .= ( $link_params ? ' ' : '' ) . $param;
	449	}
	450
	451	$ret_string = '<a ' . $link_params . '>' . $username . '</a>';
	452	}
	453	else {
	454	$ret_string = '<span' . ( $style ? ' style="' . $style . '"' : '' ) . ' title="' . $title . '">' . $username . '</span>';
	455	}
	456
	457	$ret_string .= ' ' . $pics;
	458
	459	if ( $rep_level !== false && $data['uid'] <> ANONYMOUS ) {
	460	if ( !isset($ranks) ) {
	461	$ranks = $cache->obtain_ranks();
	462	}
	463	$user_rank = ( isset($ranks[$data['user_rank_id']]['rank_name']) ? $ranks[$data['user_rank_id']]['rank_name'] : '' );
	464
	465	$ret_string .= ' <span class="' . ( $rep_level < 0 ? 'badUserResp' : 'goodUserResp' ) . '" title="' . $user_rank . ', ' . $lang['reputation'] . ': ' . $data['user_reputation'] . '"><a href="javascript:;" onclick="window.open(\'' . append_sid($root_path . 'userdetails.php?id=' . $data['uid'] . '&action=card') . '\', \'\', \'width=420,height=230,resizable=yes,scrollbars=yes,status=yes\')">' . $rep_level . '</a></span>';
	466	}
	467
	468	return $ret_string;
	469	}
	470
358	471	function get_user_class_color($class, $username) {
359	472	global $lang;
…	…
1357	1470	$time = ( time() - $config['online_time'] );
1358	1471
1359		$sql = "SELECT u.name, u.uid, u.class, u.parked, u.warneduntil, u.enabled, u.donor, s.session_logged_in, s.session_ip, s.session_user_id
	1472	$sql = "SELECT u.name, u.uid, u.class, u.parked, u.warneduntil, u.enabled, u.name_append, u.donor, s.session_logged_in, s.session_ip, s.session_user_id
1360	1473	FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
1361	1474	WHERE u.uid = s.session_user_id
…	…
1386	1499	// www.phpBB-SEO.com SEO TOOLKIT END
1387	1500
1388		$user_online_link = '<a href="' . append_sid($root_path . 'userdetails.php?id=' . $row['uid']) . '">' . ~~get_user_class_color($row['class'], $row['name']~~) . '</a>' . get_user_icons($row);
	1501	$user_online_link = '<a href="' . append_sid($root_path . 'userdetails.php?id=' . $row['uid']) . '">' . parse_username($row) . '</a>' . get_user_icons($row);
1389	1502	$online_userlist .= ( $online_userlist != '' ) ? ', ' . $user_online_link : $user_online_link;
1390	1503	}
…	…
1469	1582
1470	1583	'S_USER_IS_MOD' => ( $userdata['class'] >= UC_MODERATOR ) ? 1 : 0,
	1584
	1585	'CURRENT_USER_ID' => $userdata['uid'],
1471	1586
1472	1587	'CURRENT_USER_POINTS_LEVEL' => $userdata['user_reputation_level'],
…	…
1568	1683	$color = get_ratio_color($ratio);
1569	1684	$ratio = '<span style="color:' . $color . ';">' . $ratio . '</span>';
1570		$avatar_prefix = ( ( strpos($userdata['avatar'], 'user_avatar_' . $userdata['uid']) === false && strpos($userdata['avatar'], '/') !== false ) \|\| !$userdata['avatar'] ? '' : generate_base_url() . '/' . $config['avatar_path'] . '/' );
1571		$avatar = ( !$userdata['avatar'] ? $images['default_avatar'] : $avatar_prefix . $userdata['avatar'] );
	1685	$avatar = get_user_avatar($userdata['uid'], $userdata['avatar']);
1572	1686	$title = get_user_class_name($userdata['class']);
1573	1687
…	…
1593	1707	'CURRENT_USER_DOWNED' => $downed,
1594	1708	'CURRENT_USER_WARN_PANEL' => ( $userdata['class'] < UC_MODERATOR ? $lang['warns'] . ': ' . warn_panel($userdata['warn']) : '' ),
1595		'CURRENT_USER_NAME' => ~~get_user_class_color($userdata['class'], $userdata['name']~~),
	1709	'CURRENT_USER_NAME' => parse_username($userdata),
1596	1710	'CURRENT_USER_ICONS' => get_user_icons($userdata),
1597	1711	'S_CURRENT_TIME' => sprintf($lang['current_time'], '<span id="clock"> </span>'),
…	…
1714	1828	LEFT JOIN " . TOPICS_TABLE . " t ON t.topic_id = p.topic_id
1715	1829	WHERE f.forum_last_post_id = p.post_id
1716		ORDER BY t.topic_last_post_id DESC";
	1830	ORDER BY t.topic_last_post_time DESC";
1717	1831	$result = $db->sql_query($sql, 10 * 60);
1718	1832
…	…
1739	1853	AND t.forum_id=f.forum_id
1740	1854	AND f.forum_id IN (' . implode(', ', $auth_forums ) . ')
1741		ORDER BY t.topic_last_post_id DESC';
	1855	ORDER BY t.topic_last_post_time DESC';
1742	1856	$result = $db->sql_query_limit($sql, 10, 0, 10 * 60);
1743	1857
…	…
1951	2065	}
1952	2066
1953		return ( !empty($tracking[$type][$id]) ? $tracking[$type][$id] : $userdata['user_lastvisit'] );
	2067	$user_lastvisit = ( $userdata['session_logged_in'] ? $userdata['user_lastvisit'] : time() );
	2068
	2069	return ( !empty($tracking[$type][$id]) ? $tracking[$type][$id] : $user_lastvisit );
1954	2070	}
1955	2071	?>

include/functions_check.php

r308	r313
222	222
223	223	function check_internet_speed( $internet_speed ) {
224		~~if ( $internet_speed == 48 * 1024 * 1024 \|\| $internet_speed == 100 * 1024 * 1024 ) {~~
225		~~return true;~~
226		}
227
228	224	for ( $i = 64; $i <= 1024; $i +=64 ) {
229	225	if ( $internet_speed == $i * 1024 ) {
…	…
231	227	}
232	228	}
233		for ( $i = 2; $i < 11; ++$i ) {
	229	for ( $i = 2; $i <= 101; ++$i ) {
	230	if ( $i > 10 ) {
	231	$i += 1;
	232	}
	233	if ( $i > 30 ) {
	234	$i += 3;
	235	}
234	236	if ( $internet_speed == $i * 1024 * 1024 ) {
235	237	return true;

include/functions_post.php

r311	r313
19	19	$last_read = get_tracking($type, $id);
20	20
21		$sql = 'SELECT c.comment_id, c.comment_text, c.comment_user, c.comment_added, c.comment_editedby, c.comment_editedat, c.comment_reputation, u.avatar, u.warneduntil, u.parked, u.name, u.title, u.class, u.donor, u.downloaded, u.uploaded, u.enabled, u2.name AS edited_by_username, u.birthday, u.gender, u.user_session_time, u.user_sig, u.privacy, u.user_reputation_level, u.user_rank_id
	21	$sql = 'SELECT c.comment_id, c.comment_text, c.comment_user, c.comment_added, c.comment_editedby, c.comment_editedat, c.comment_reputation, u.avatar, u.warneduntil, u.parked, u.name, u.title, u.class, u.donor, u.downloaded, u.uploaded, u.enabled, u2.name AS edited_by_username, u.birthday, u.gender, u.user_session_time, u.user_sig, u.privacy, u.user_reputation_level, u.user_rank_id, u.name_append, u.uid, u.user_reputation
22	22	FROM ' . COMMENTS_TABLE . ' c
23	23	LEFT JOIN ' . USERS_TABLE . ' u2 ON c.comment_editedby = u2.uid,
…	…
75	75	$u_report = '';
76	76	}
77		$avatar_prefix = ( ( strpos($row['avatar'], 'user_avatar_' . $row['comment_user']) === false && strpos($row['avatar'], '/') !== false ) \|\| !$row['avatar'] ? '' : generate_base_url() . '/' . $config['avatar_path'] . '/' );
78		$avatar = ( $userdata['avatars'] ? ( !$row['avatar'] ? $images['default_avatar'] : $avatar_prefix . $row['avatar'] ) : $images['default_avatar']);
	77	$avatar = get_user_avatar($row['uid'], $row['avatar']);
79	78
80	79	//$gender = ( !$row['gender'] ?'<img src="' . $images['male'] . '" alt="' . $lang['gender_male'] . '" />':'<img src="' . $images['female'] . '" alt="' . $lang['gender_female'] . '" />');
81	80	$age = get_age($row['birthday']);
82	81	//$report = ( $userdata['session_logged_in'] && $row['comment_user'] != $userdata['uid'] ? '<a href="' . append_sid('reports.php?action=comment&id=' . $row['comment_id']) . '" title="' . sprintf($lang['report_comment'], $row['comment_id']) . '">' . $lang['report'] . '</a>' : '' );
83		$user_online = ( $row['user_session_time'] > ( time() - $config['online_time'] ) ? sprintf($lang['user_online'], $~~row['name']) : sprintf($lang['user_offline'], $row['name']~~) );
	82	$user_online = ( $row['user_session_time'] > ( time() - $config['online_time'] ) ? sprintf($lang['user_online'], $username) : sprintf($lang['user_offline'], $username) );
84	83
85	84	if ( $row['user_sig'] && $config['allow_sig'] ) {
…	…
196	195	'COMM_ID' => $row['comment_id'],
197	196	'USER_ID' => $row['comment_user'],
198		'USERNAME' => ~~$username . get_user_icons~~($row),
	197	'USERNAME' => parse_username($row),
199	198	'TITLE' => $title,
200	199	'AVATAR' => $avatar,
…	…
228	227	'CURRENT_REPUTATION' => $row['comment_reputation'],
229	228	'CURRENT_REPUTATION_SHOW' => $current_reputation_show,
230
231		~~'USER_REPUTATION_LEVEL' => $row['user_reputation_level']~~
232	229	);
233	230
…	…
306	303	'CURRENT_REPUTATION_SHOW' => $ary['CURRENT_REPUTATION_SHOW'],
307	304
308		~~'USER_REPUTATION_LEVEL' => $ary['USER_REPUTATION_LEVEL'],~~
309
310	305	'USERLIST' => $userslist
311	306	));
…	…
342	337	}
343	338
344		$sql = 'SELECT c.comment_id, c.comment_text, c.comment_added, c.comment_editedby, c.comment_editedat, ~~u.name, u.title, u.uid AS user, u.avatar, u.class, u.enabled, u.warneduntil, u.donor, u.parked, u2.name AS edited_by_username, u.user_reputation_level, u.user_rank_id~~
	339	$sql = 'SELECT c.comment_id, c.comment_text, c.comment_added, c.comment_editedby, c.comment_editedat, c.comment_reputation, u.uid, u.avatar, u.warneduntil, u.parked, u.name, u.title, u.class, u.donor, u.downloaded, u.uploaded, u.enabled, u2.name AS edited_by_username, u.birthday, u.gender, u.user_session_time, u.user_sig, u.privacy, u.user_reputation_level, u.user_rank_id, u.name_append, u.user_reputation
345	340	FROM ' . COMMENTS_TABLE . ' c
346	341	LEFT JOIN ' . USERS_TABLE . ' u2 ON c.comment_editedby = u2.uid,
…	…
356	351	do {
357	352
358		if ( $row['user'] <> ANONYMOUS ) {
	353	if ( $row['uid'] <> ANONYMOUS ) {
	354	if ( ( $row['class'] == UC_VIP \|\| $row['privacy'] <> PRIVACY_LEVEL_LOW ) && ( $userdata['class'] < UC_MODERATOR && $userdata['uid'] != $row['comment_user'] ) ) {
	355	$ratio = '---';
	356	$uploaded = '---';
	357	$downloaded = '---';
	358	$ratio_color = '';
	359	}
	360	else {
	361	$ratio = get_ratio($row['uploaded'], $row['downloaded']);
	362	$ratio_color = get_ratio_color($ratio);
	363	$uploaded = mksize($row['uploaded']);
	364	$downloaded = mksize($row['downloaded']);
	365	}
359	366	$username = $row['name'];
360		$avatar_prefix = ( ( strpos($row['avatar'], 'user_avatar_' . $row['user']) === false && strpos($row['avatar'], '/') !== false ) \|\| !$row['avatar'] ? '' : generate_base_url() . '/' . $config['avatar_path'] . '/' );
361		$avatar = ($userdata['avatars'] ? ( !$row['avatar'] ? $images['default_avatar'] : $avatar_prefix . $row['avatar'] ) : $images['default_avatar']);
	367	$avatar = get_user_avatar($row['uid'], $row['avatar']);
362	368	$user_sig = ( isset($row['user_sig']) && $row['user_sig'] != '' && $config['allow_sig'] ) ? $row['user_sig'] : '';
363	369	if ( $user_sig ) {
…	…
373	379	}
374	380
	381	if ( $row['gender'] ) {
	382	$gender_img = $images['female'];
	383	$gender_text = $lang['gender_female'];
	384	}
	385	else {
	386	$gender_img = $images['male'];
	387	$gender_text = $lang['gender_male'];
	388	}
	389
	390	$age = get_age($row['birthday']);
	391
375	392	$title = ( $row['title'] ? $row['title'] . '<br />' : '' );
376	393	$title .= ( isset($ranks[$row['user_rank_id']]['rank_name']) ? $ranks[$row['user_rank_id']]['rank_name'] : '' );
…	…
382	399	$user_sig = '';
383	400	$title = '';
	401	$ratio = '';
	402	$ratio_color = '';
	403	$uploaded = '';
	404	$downloaded = '';
	405	$gender_text = '';
	406	$gender_img = '';
	407	$age = '';
384	408	}
385	409
…	…
390	414	// www.phpBB-SEO.com SEO TOOLKIT START
391	415	$seo->set_user_url($row['edited_by_username'], $row['comment_editedby']);
392		$seo->set_user_url($username, $row['u~~ser~~']);
	416	$seo->set_user_url($username, $row['uid']);
393	417	// www.phpBB-SEO.com SEO TOOLKIT END
394	418
…	…
408	432	}
409	433
	434	if ( $row['comment_reputation'] > 0 ) {
	435	$current_reputation_show = '+' . $row['comment_reputation'];
	436	}
	437	else {
	438	$current_reputation_show = $row['comment_reputation'];
	439	}
	440
410	441	$template->assign_block_vars('comments_table_row', array(
411		'U_USERDETAILS' => append_sid($root_path . 'userdetails.php?id=' . $row['u~~ser~~']),
	442	'U_USERDETAILS' => append_sid($root_path . 'userdetails.php?id=' . $row['uid']),
412	443	'U_COMMENT' => append_sid($root_path . 'comment.php?cid=' . $row['comment_id']),
413	444	'COMM_ID' => $row['comment_id'],
414		'USER_ID' => $row['u~~ser~~'],
415		'USERNAME' => ~~$username . get_user_icons~~($row),
	445	'USER_ID' => $row['uid'],
	446	'USERNAME' => parse_username($row),
416	447	'TITLE' => $title,
417	448	'AVATAR' => $avatar,
…	…
423	454	'MINI_POST_ALT' => $mini_post_alt,
424	455	'USER_REPUTATION_LEVEL' => $row['user_reputation_level'],
	456
	457	'UPLOADED' => htmlspecialchars($uploaded),
	458	'DOWNLOADED' => htmlspecialchars($downloaded),
	459
	460	'GENDER_IMAGE' => $gender_img,
	461	'GENDER_TEXT' => htmlspecialchars($gender_text),
	462	'AGE' => htmlspecialchars($age),
	463	'RATIO' => htmlspecialchars('<span style="color:' . $ratio_color . ';">' . $ratio . '</span>'),
	464
	465	'SIMPATY_TYPE' => SIMPATY_COMMENT,
	466	'CURRENT_REPUTATION' => $row['comment_reputation'],
	467	'CURRENT_REPUTATION_SHOW' => $current_reputation_show,
425	468	));
426	469

include/functions_selects.php

r293	r313
112	112	$l_megabits = utf_ucfirst(utf_strtolower($lang['megabytes']));
113	113
114		$select = '<select name="' . $select_name . '" id="' . $select_name . '">';
	114	$up_sp_select = '<select name="' . $select_name . '" id="' . $select_name . '">';
115	115
116	116	if ( !$default ) {
117		$select .= '<option value="">' . $lang['choose'] . '</option>';
	117	$up_sp_select .= '<option value="">' . $lang['choose'] . '</option>';
118	118	}
119	119	for ( $i = 64; $i <= 960; $i +=64 ) {
120	120	$n = $i * 1024;
121	121	$value = $i . ' ' . $l_kilobits . '/' . $lang['seconds_short'];
122		$select .= '<option value="' . $n . '"' . ( $default == $n ? ' selected="selected"' : '' ) . '>' . $value . '</option>';
123
124		}
125		for ( $i = 1; $i < 13; ++$i ) {
126		if ( $i == 11 ) {
127		$n = 48 * 1024 * 1024;
128		$value = 48 . ' ' . $l_megabits . '/' . $lang['seconds_short'];
129		$select .= '<option value="' . $n . '"' . ( $default == $n ? ' selected="selected"' : '' ) . '>' . $value . '</option>';
130		}
131		elseif ( $i == 12 ) {
132		$n = 100 * 1024 * 1024;
133		$value = 100 . ' ' . $l_megabits . '/' . $lang['seconds_short'];
134		$select .= '<option value="' . $n . '"' . ( $default == $n ? ' selected="selected"' : '' ) . '>' . $value . '</option>';
135		break;
136		}
137		else {
138		$n = $i * 1024 * 1024;
139		$value = $i . ' ' . $l_megabits . '/' . $lang['seconds_short'];
140		$select .= '<option value="' . $n . '"' . ( $default == $n ? ' selected="selected"' : '' ) . '>' . $value . '</option>';
141		}
142
143		}
144		$select .= '</select>';
145
146		return $select;
	122	$up_sp_select .= '<option value="' . $n . '"' . ( $default == $n ? ' selected="selected"' : '' ) . '>' . $value . '</option>';
	123
	124	}
	125	for ( $i = 1; $i < 101; ++$i ) {
	126	if ( $i > 10 ) {
	127	$i += 1;
	128	}
	129	if ( $i > 30 ) {
	130	$i += 3;
	131	}
	132	$n = $i * 1024 * 1024;
	133	$value = $i . ' ' . $l_megabits . '/' . $lang['seconds_short'];
	134	$up_sp_select .= '<option value="' . $n . '"' . ( $default == $n ? ' selected="selected"' : '' ) . '>' . $value . '</option>';
	135	}
	136	$up_sp_select .= '</select>';
	137
	138	return $up_sp_select;
147	139	}
148	140

include/functions_torrenttable.php

r311	r313
77	77	}
78	78
79		~~$template->assign_block_vars('torrent_table', array());~~
80
81	79	$moderator = $userdata['class'] >= UC_MODERATOR;
82	80
…	…
158	156	$slr_color = 'FF0000';
159	157	}
160		$username = ~~( $ary[$i]['owner'] ? '<a href="' . append_sid($root_path . 'userdetails.php?id=' . $ary[$i]['owner']) . '"><b>' . $ary[$i]['username'] . '</b></a>' : '<i>' . $lang['unknown'] . '</i>'~~);
	158	$username = parse_username($ary[$i]);
161	159
162	160	$tor_last_read = get_tracking(TYPE_TORRENT, $id);
…	…
178	176	$prev_added_day = create_date($ary[$i]['ctime'], 'Y-m-d');
179	177
180		$template->assign_block_vars('torrent~~_table.torrent~~s_table', array(
	178	$template->assign_block_vars('torrents_table', array(
181	179	'U_CATEGORY' => append_sid($root_path . 'browse.php?cat=' . $cat_id),
182	180	'U_DETAILS' => append_sid($root_path . 'details.php?id=' . $id . $highlight),

include/sessions.php

r308	r313
532	532	$userdata['tzoffset'] = number_format($config['board_timezone']);
533	533
534		$dir = opendir($root_path . 'languages');
	534	/* $dir = opendir($root_path . 'languages');
535	535	$lang_files = array();
536	536	while ( $file = readdir($dir) ) {
…	…
560	560	}
561	561	}
562		}
	562	}*/
563	563	}
564	564
…	…
1341	1341	}
1342	1342
	1343	function get_user_avatar ( $uid, $avatar ) {
	1344	global $config, $images, $root_path;
	1345
	1346	$avatar_prefix = ( ( strpos($avatar, 'user_avatar_' . $uid) === false && strpos($avatar, '/') !== false ) \|\| !$avatar ? '' : $root_path . $config['avatar_path'] . '/' );
	1347	$avatar = ( !$avatar ? $images['default_avatar'] : $avatar_prefix . $avatar );
	1348
	1349	return $avatar;
	1350
	1351	}
	1352
1343	1353	?>

js/ajax_common.js

r308	r313
13	13	}
14	14	req.caching = true;
15		req.open('GET', TRACKER_URL + '/ajax.php?action=viewhost&sid=' + SID, true);
	15	req.open('GET', TRACKER_URL + 'ajax.php?action=viewhost&sid=' + SID, true);
16	16	req.send({ ip: user_ip });
17	17	}
…	…
28	28	}
29	29	req.caching = false;
30		req.open('GET', TRACKER_URL + '/ajax.php?action=thanks&sid=' + SID, true);
	30	req.open('GET', TRACKER_URL + 'ajax.php?action=thanks&sid=' + SID, true);
31	31	req.send({ id: torrent_id });
32	32	}
…	…
45	45	}
46	46	req.caching = false;
47		req.open('GET', TRACKER_URL + '/ajax.php?action=sos&sid=' + SID, true);
	47	req.open('GET', TRACKER_URL + 'ajax.php?action=sos&sid=' + SID, true);
48	48	req.send({ id: torrent_id });
49	49	}
…	…
64	64	}
65	65	req.caching = false;
66		req.open('GET', TRACKER_URL + '/ajax.php?action=rating&sid=' + SID, true);
	66	req.open('GET', TRACKER_URL + 'ajax.php?action=rating&sid=' + SID, true);
67	67	req.send({ id: torrent_id, rating: rating });
68	68	}
…	…
82	82	}
83	83	req.caching = true;
84		req.open('GET', TRACKER_URL + '/cheaters.php?mode=show_data&sid=' + SID, true);
	84	req.open('GET', TRACKER_URL + 'cheaters.php?mode=show_data&sid=' + SID, true);
85	85	req.send({ user_id: user_id });
86	86	}
…	…
109	109
110	110	req.caching = true;
111		req.open('POST', TRACKER_URL + '/ajax.php?action=preview&sid=' + SID, true);
	111	req.open('POST', TRACKER_URL + 'ajax.php?action=preview&sid=' + SID, true);
112	112	req.send({ message: message, name: name, preview_type: preview_type });
113	113	}
…	…
128	128
129	129	req.caching = true;
130		req.open('POST', TRACKER_URL + '/ajax.php?action=edit_template_preview&sid=' + SID, true);
	130	req.open('POST', TRACKER_URL + 'ajax.php?action=edit_template_preview&sid=' + SID, true);
131	131	req.send({ template: template });
132	132	}
…	…
135	135	var div_content = '' + document.getElementById(type + '_row').innerHTML;
136	136	div_content.replace(/(^\s+)\|(\s+$)/g, "");
137		mode = ( mode == 'details' ? 'details.php' : 'userdetails.php' );
	137	if ( mode == 'details' ) {
	138	url = 'details.php?view=' + type;
	139	}
	140	else {
	141	url = 'userdetails.php?action=view_snatched&view=' + type + '&id=' + id;
	142	}
138	143
139	144	if ( div_content == ' ' \|\| div_content == "" ) {
140	145	req.onreadystatechange = function() {
141	146	if ( req.readyState == 1 ) {
142		document.getElementById(type + '_row').innerHTML = '<img src="' + TRACKER_URL + '/pic/loading_icon_small.gif" alt="" />';
	147	document.getElementById(type + '_row').innerHTML = '<img src="' + TRACKER_URL + 'pic/loading_icon_small.gif" alt="" />';
143	148	}
144	149	if ( req.readyState == 4 ) {
…	…
150	155	}
151	156	req.caching = true;
152		req.open('POST', TRACKER_URL + ~~'/' + mode + '?view=' + type~~ + '&sid=' + SID, true);
	157	req.open('POST', TRACKER_URL + url + '&sid=' + SID, true);
153	158	req.send( {id : id} );
154	159	}
…	…
173	178
174	179	req.caching = false;
175		req.open('POST', TRACKER_URL + '/simpaty.php?action=add&sid=' + SID, true);
	180	req.open('POST', TRACKER_URL + 'simpaty.php?action=add&sid=' + SID, true);
176	181	req.send({ targetid: targetid, type: type, state: state, current_reputation: currentReputation });
177	182	}

js/chat.js

r311	r313
36	36
37	37	function parse_answer ( data ) {
	38	var new_msg = 0;
38	39	for( var i=0; i < data.length; i++ ) {
39	40	var exploded = data[i].message.split(' ');
…	…
57	58	}
58	59
	60	++new_msg;
	61
59	62	$('#daddy-shoutbox-list').append(prepare(data[i]));
60	63	if ( data[i].chat_msg_id != 0 ) {
…	…
65	68	$('#daddy-shoutbox-list').animate({ scrollTop: "+=1000" });
66	69
67		return i;
	70	return new_msg;
68	71	}
69	72
…	…
91	94	function refresh() {
92	95	clearTimeout(timeoutID);
93		$('#loading').attr('innerHTML', '<img src="' + TRACKER_URL + 'pic/~~pic/~~loading_icon_small.gif" />');
	96	$('#loading').attr('innerHTML', '<img src="' + TRACKER_URL + 'pic/loading_icon_small.gif" />');
94	97
95	98	$.ajax({

languages/lang_english/lang_js.php

r310	r313
22	22	'js_email_validate_invalid' => 'Email введен неверно',
23	23
24		'js_enter_start_log_date' => 'Введите дату (в формате dd.mm.YY) начала показа логов',
	24	'js_enter_start_log_date' => 'Введите дату (в формате dd.mm.YY H:i) начала показа логов',
25	25	'js_chat_new_messages' => 'Новое сообщение в чате! :: ' . $config['sitename'],
26	26

languages/lang_russian/lang_js.php

r310	r313
22	22	'js_email_validate_invalid' => 'Email введен неверно',
23	23
24		'js_enter_start_log_date' => 'Введите дату (в формате dd.mm.YY) начала показа логов',
	24	'js_enter_start_log_date' => 'Введите дату (в формате dd.mm.YY H:i) начала показа логов',
25	25	'js_chat_new_messages' => 'Новое сообщение в чате! :: ' . $config['sitename'],
26	26

languages/lang_russian/lang_main.php

r308	r313
14	14	'lang_faq_copyright' => 'Перевод основной части FAQ с английского: <a href="mailto:zyt@mail333.com">zyto</a>. Специально для StreamZone. Декабрь 2005г<br />
15	15	Перевод части про форматы файлов выполнил freewood<br />
16		Перевод части про видеоформаты взят с сайта sharereactor, часть перевода выполнил <a href="http://streamzone.ru/tracker/userdetails.php?id=745">gamerko</a><br />
17		Корректировку всех частей FAQ выполнил <a href="http://streamzone.ru/tracker/userdetails.php?id=35234">M2D</a><br />
	16	Перевод части про видеоформаты взят с сайта sharereactor, часть перевода выполнил <a href="http://streamzone.org/tracker/userdetails.php?id=745">gamerko</a><br />
	17	Корректировку всех частей FAQ выполнил <a href="http://streamzone.org/tracker/userdetails.php?id=35234">M2D</a><br />
18	18	Дополнял все переводы Nafania',
19	19
…	…
336	336	'releases' => 'Новинки', //альтернативный вариант - Релизы
337	337	'archive' => 'Архив', //имеется ввиду архив Новинок
338		'details' => 'Детали', //Детали Новинок
	338	'details' => 'Детали торрента', //Детали Новинок
339	339	'talk_at_forum' => 'Обсудить на форуме',
340	340	'no_releases' => 'Нет новинок',
…	…
436	436	'owner_cant_thanks' => 'Вы не можете ставить Спасибо на своем торренте',
437	437	'sos_sended' => 'Запрос о помощи послан!',
438		'download' => 'Скачать',
	438	'download' => 'Скачать торрент',
439	439	'add_to_bookmarks' => 'добавить в закладки',
440	440	'add_to_index' => 'добавить на главную',
…	…
512	512	'delete_after_answer' => 'Удалить сообщение после ответа',
513	513	'save_pm_at_outbox' => 'Сохранить сообщение в отправленных',
514		'send' => '~~Посла~~ть',
	514	'send' => 'Отправить',
515	515	'goto' => 'Перейти',
516	516	'sender' => 'Отправитель',

message.php

r300	r313
660	660
661	661	}
662		if ( $unread_pms <> $userdata['user_unread_pms'] && $mailbox != PM_SENTBOX ) {
663		$sql = 'UPDATE ' . USERS_TABLE . ' SET user_unread_pms = ' . $unread_pms . ' WHERE uid = ' . $userdata['uid'];
664		$db->sql_query($sql);
665		}
	662	//if ( $unread_pms <> $userdata['user_unread_pms'] && $mailbox != PM_SENTBOX ) {
	663	// $sql = 'UPDATE ' . USERS_TABLE . ' SET user_unread_pms = ' . $unread_pms . ' WHERE uid = ' . $userdata['uid'];
	664	// $db->sql_query($sql);
	665	//}
666	666	}
667	667

phpBB2/includes/functions.php

r305	r313
847	847	function get_unread_topics($user_id = false, $sql_extra = '', $sql_sort = '', $sql_limit = 1001)
848	848	{
849		global $config, $db, $user;
850
851		$user_id = ($user_id === false) ? (int) $user~~->data['user_~~id'] : (int) $user_id;
	849	global $config, $db, $userdata;
	850
	851	$user_id = ($user_id === false) ? (int) $userdata['uid'] : (int) $user_id;
852	852
853	853	// Data array we're going to return

phpBB2/index.php

r307	r313
151	151	{
152	152	case 'postgresql':
153		$sql = "SELECT f.*, p.post_time, p.post_username, u.name AS username, u.uid
	153	$sql = "SELECT f.*, p.post_time, p.post_username, u.name AS username, u.uid, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.parked
154	154	FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
155	155	WHERE p.post_id = f.forum_last_post_id
…	…
168	168
169	169	case 'oracle':
170		$sql = "SELECT f.*, p.post_time, p.post_username, u.name AS username, u.uid
	170	$sql = "SELECT f.*, p.post_time, p.post_username, u.name AS username, u.uid, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.parked
171	171	FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
172	172	WHERE p.post_id = f.forum_last_post_id(+)
…	…
176	176
177	177	default:
178		$sql = "SELECT f.*, p.post_time, p.post_username, u.name AS username, u.uid, t.topic_title, t.topic_id, u.class
	178	$sql = "SELECT f.*, p.post_time, p.post_username, u.name AS username, u.uid, t.topic_title, t.topic_id, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.parked
179	179	FROM ((( " . FORUMS_TABLE . " f
180	180	LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
…	…
412	412	$last_post_time = "<b>" . $lang['added'] . "</b>: " . create_date($forum_data[$j]['post_time']);
413	413	$last_post = $last_post_time . '<br />';
414		$last_post .= ( $forum_data[$j]['uid'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? "<b>" . $lang['poster'] . "</b>: " . $forum_data[$j]['post_username'] : "<b>" . $lang['poster']. "</b>: " . $lang['guest']) : "<b>" . $lang['poster'] . "</b>: " . ~~get_user_class_color($forum_data[$j]['class'],$forum_data[$j]['username'~~]);
	414	$last_post .= ( $forum_data[$j]['uid'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? "<b>" . $lang['poster'] . "</b>: " . $forum_data[$j]['post_username'] : "<b>" . $lang['poster']. "</b>: " . $lang['guest']) : "<b>" . $lang['poster'] . "</b>: " . parse_username($forum_data[$j]);
415	415	//$last_post .= "<br /><b>" . $lang['topic'] . '</b>: <a href="' . append_sid($root_path . "phpbb2.php?page=viewtopic&" . POST_TOPIC_URL . '=' . $forum_data[$j]['topic_id']) . '">' . $forum_data[$j]['topic_title'] . '</a>';
416	416	$last_post .= "<br /><b>" . $lang['topic'] . '</b>: <a href="%s">' . $forum_data[$j]['topic_title_stripped'] . '</a>';

phpBB2/search.php

r307	r313
59	59	$sort_by = request_var('sort_by', 0);
60	60
61		if ( isset($_POST['search_terms']) )
62		{
63		$search_terms = ( $_POST['search_terms'] == 'all' ) ? 1 : 0;
64		}
65		else
66		{
67		$search_terms = 0;
68		}
69
70		if ( isset($_POST['search_fields']) )
71		{
72		$search_fields = ( $_POST['search_fields'] == 'all' ) ? 1 : 0;
73		}
74		else
75		{
76		$search_fields = 0;
77		}
78
79
80		if ( isset($_POST['sort_dir']) )
81		{
82		$sort_dir = ( $_POST['sort_dir'] == 'DESC' ) ? 'DESC' : 'ASC';
83		}
84		else
85		{
86		$sort_dir = 'DESC';
87		}
88
89		if ( !empty($_POST['search_time']) \|\| !empty($_GET['search_time']))
90		{
91		$search_time = time() - ( ( ( !empty($_POST['search_time']) ) ? intval($_POST['search_time']) : intval($_GET['search_time']) ) * 86400 );
92		$topic_days = (!empty($_POST['search_time'])) ? intval($_POST['search_time']) : intval($_GET['search_time']);
93		}
94		else
95		{
96		$search_time = 0;
97		$topic_days = 0;
98		}
99
100		$start = ( isset($_GET['start']) ) ? intval($_GET['start']) : 0;
101		$start = ($start < 0) ? 0 : $start;
	61	$search_terms = request_var('search_terms', '');
	62	$search_terms = ( $search_terms == 'all' ? 1 : 0 );
	63
	64	$search_fields = request_var('search_fields', '');
	65	$search_fields = ( $search_fields == 'all' ? 1 : 0 );
	66
	67	$sort_dir = request_var('sort_dir', '');
	68	$sort_dir = ( $sort_dir == 'DESC' ? 'desc' : 'asc' );
	69
	70	$search_time = request_var('search_time', 0);
	71	$search_time = ( $search_time ? time() - $search_time * 86400 : 0 );
	72
	73	$topic_days = $search_time;
	74
	75	$start = request_var('start', 0);
102	76
103	77	$sort_by_types = array($lang['sort_time'], $lang['sort_post_subject'], $lang['sort_topic_title'], $lang['sort_author'], $lang['sort_forum']);
104	78
105		//
106		// encoding match for workaround
107		//
108		$multibyte_charset = 'utf-8, big5, shift_jis, euc-kr, gb2312';
	79	$split_search = array();
109	80
110	81	//
…	…
132	103	$search_results = '';
133	104	// Topic search MOD
134		$tid = ~~( isset($_POST['topic_id']) ? intval($_POST['topic_id']) : ( isset($_GET['topic_id']) ? intval($_GET['topic_id']) : 0 )~~ );
	105	$tid = request_var('topic_id', 0);
135	106	// Topic search MOD
136	107
…	…
260	231	$synonym_array = @file($root_path . 'languages/lang_' . $config['default_lang'] . '/search_synonyms.txt');
261	232
262		~~$split_search = array();~~
263	233	$stripped_keywords = ( STRIP ? stripslashes($search_keywords) : $search_keywords );
264	234	$split_search = split_words(clean_words('search', $stripped_keywords, $stopword_array, $synonym_array), 'search');
…	…
707	677	if ( $show_results == 'posts' )
708	678	{
709		$sql = "SELECT pt.post_text, pt.post_subject, p., f.forum_id, f.forum_name, t., u.name AS username, u.uid
710		FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt
	679	$sql = "SELECT pt.post_text, pt.post_subject, p., f.forum_id, f.forum_name, t., u.name AS username, u.uid, c.cat_id, c.cat_title, f2.forum_id AS p_forum_id, f2.forum_name AS p_forum_name
	680	FROM " . FORUMS_TABLE . " f LEFT JOIN " . FORUMS_TABLE . " f2 ON ( f.forum_parent = f2.forum_id ),
	681	" . FORUM_CATEGORIES_TABLE . " c, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt
711	682	WHERE p.post_id IN ($search_results)
712	683	AND pt.post_id = p.post_id
713	684	AND f.forum_id = p.forum_id
714	685	AND p.topic_id = t.topic_id
715		AND p.poster_id = u.uid";
	686	AND p.poster_id = u.uid
	687	AND f.cat_id = c.cat_id";
716	688	}
717	689	else
718	690	{
719		$sql = "SELECT t.*, f.forum_id, f.forum_name, u.name AS username, u.uid, u2.name as user2, u2.uid as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
720		FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
	691	$sql = "SELECT t.*, f.forum_id, f.forum_name, u.name AS username, u.uid, u2.name as user2, u2.uid as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, c.cat_id, c.cat_title, f2.forum_id AS p_forum_id, f2.forum_name AS p_forum_name
	692	FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f LEFT JOIN " . FORUMS_TABLE . " f2 ON ( f.forum_parent = f2.forum_id )," . FORUM_CATEGORIES_TABLE . " c, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
721	693	WHERE t.topic_id IN ($search_results)
722	694	AND t.topic_poster = u.uid
…	…
724	696	AND p.post_id = t.topic_first_post_id
725	697	AND p2.post_id = t.topic_last_post_id
726		AND u2.uid = p2.poster_id";
	698	AND u2.uid = p2.poster_id
	699	AND f.cat_id = c.cat_id";
727	700	}
728	701
…	…
889	862
890	863	// www.phpBB-SEO.com SEO TOOLKIT BEGIN
	864	$seo->set_url($searchset[$i]['cat_id'], $searchset[$i]['cat_title'], $seo->seo_static['forum_cat']);
	865
	866	if ( !empty($searchset[$i]['p_forum_id']) ) {
	867	$seo->set_parent($searchset[$i]['p_forum_id'], $seo->seo_static['forum'], $searchset[$i]['cat_id'], $seo->seo_static['forum_cat']);
	868	$seo->set_url($searchset[$i]['p_forum_name'], $searchset[$i]['p_forum_id'], $seo->seo_static['forum']);
	869	$seo->set_parent($forum_id, $seo->seo_static['forum'], $searchset[$i]['p_forum_id'], $seo->seo_static['forum']);
	870	}
	871	else {
	872	$seo->set_parent($forum_id, $seo->seo_static['forum'], $searchset[$i]['cat_id'], $seo->seo_static['forum_cat']);
	873	}
891	874	$seo->set_url($searchset[$i]['forum_name'], $forum_id, $seo->seo_static['forum']);
	875
892	876	$seo->set_parent($topic_id, $seo->seo_static['topic'], $forum_id, $seo->seo_static['forum']);
893	877	$seo->set_url($topic_title, $topic_id, $seo->seo_static['topic']);

phpBB2/viewforum.php

r307	r313
154	154	// First users, then groups ... broken into two queries
155	155	//
156		$sql = "SELECT u.uid, u.name AS username, u.class
	156	$sql = "SELECT u.uid, u.name AS username, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.parked
157	157	FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g, " . USERS_TABLE . " u
158	158	WHERE aa.forum_id = $forum_id
…	…
169	169	while( $row = $db->sql_fetchrow($result) )
170	170	{
171		// www.phpBB-SEO.com SEO TOOLKIT START
172		$seo->set_user_url($row['username'], $row['uid']);
173		// www.phpBB-SEO.com SEO TOOLKIT END
174		$moderators[] = '<a href="' . append_sid($root_path . 'userdetails.php?id=' . $row['uid']) . '">' . get_user_class_color($row['class'], $row['username']) . '</a>';
	171	$moderators[] = parse_username($row);
175	172	}
176	173
…	…
245	242	// on each viewforum page ...
246	243	//
247		$sql = "SELECT t.*, u.name AS username, u.uid, u2.name AS user2, u2.uid AS id2, p.post_time, p.post_username, u~~.class AS class1, u2.class AS class2~~
	244	$sql = "SELECT t.*, u.name AS username, u.uid, u2.name AS user2, u2.uid AS id2, p.post_time, p.post_username, u2.class AS class2, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.parked
248	245	FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2
249	246	WHERE t.forum_id = $forum_id
…	…
271	268	// for this forum
272	269	//
273		$sql = "SELECT t.*, u.name AS username, u.uid, u2.name AS user2, u2.uid as id2, u~~.class AS class1, u2.class AS class2, p.post_username, p2.post_username AS post_username2, p2.post_time~~
	270	$sql = "SELECT t.*, u.name AS username, u.uid, u2.name AS user2, u2.uid as id2, u2.class AS class2, p.post_username, p2.post_username AS post_username2, p2.post_time, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.parked
274	271	FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
275	272	WHERE t.forum_id = $forum_id
…	…
554	551	// www.phpBB-SEO.com SEO TOOLKIT END
555	552
556		$topic_author = ($topic_rowset[$i]['uid'] == ANONYMOUS ) ? (($topic_rowset[$i]['post_username'] != '' ) ? $topic_rowset[$i]['post_username'] : $lang['guest'] ) : ~~'<a href="' . append_sid($root_path . 'userdetails.php?id=' . $topic_rowset[$i]['uid']) . '">' . get_user_class_color($topic_rowset[$i]['class1'],$topic_rowset[$i]['username']) . '</a>'~~;
	553	$topic_author = ($topic_rowset[$i]['uid'] == ANONYMOUS ) ? (($topic_rowset[$i]['post_username'] != '' ) ? $topic_rowset[$i]['post_username'] : $lang['guest'] ) : parse_username($topic_rowset[$i]);
557	554
558	555	$first_post_time = create_date($topic_rowset[$i]['topic_time']);

phpBB2/viewtopic.php

r307	r313
445	445
446	446	$sql_array = array();
447		$sql_array['SELECT'] = 'u.name AS username, u.uid, u.user_posts, u.email, u.user_session_time, u.user_lastvisit, p.*, pt.post_text, pt.post_subject, u.gender, u.birthday, u.warneduntil, u.parked, u.donor, u.added AS user_regdate, u.uploaded, u.downloaded, u.avatar AS user_avatar, u.icq AS user_icq, u.msn, u.aim AS user_aim, u.yahoo AS user_yim, u.skype AS user_skype, u.title AS user_rank, u.privacy, u.class AS user_class, u.enabled, u.user_sig, u.user_reputation_level, u.user_rank_id';
	447	$sql_array['SELECT'] = 'u.name AS username, u.uid, u.user_posts, u.email, u.user_session_time, u.user_lastvisit, p.*, pt.post_text, pt.post_subject, u.gender, u.birthday, u.warneduntil, u.parked, u.donor, u.added AS user_regdate, u.uploaded, u.downloaded, u.avatar AS user_avatar, u.icq AS user_icq, u.msn, u.aim AS user_aim, u.yahoo AS user_yim, u.skype AS user_skype, u.title AS user_rank, u.privacy, u.class AS user_class, u.enabled, u.user_sig, u.user_reputation_level, u.user_rank_id, u.class, u.name_append, u.user_reputation';
448	448	$sql_array['FROM'] = array(
449	449	POSTS_TABLE => 'p',
…	…
460	460	$sql_array = array();
461	461	if ( $forum_topic_data['topic_first_post_sticky'] && $start ) {
462		$sql_array['SELECT'] = 'u.name AS username, u.uid, u.user_posts, u.email, u.user_session_time, u.user_lastvisit, p.*, pt.post_text, pt.post_subject, u.gender, u.birthday, u.warneduntil, u.parked, u.donor, u.added AS user_regdate, u.uploaded, u.downloaded, u.avatar AS user_avatar, u.icq AS user_icq, u.msn, u.aim AS user_aim, u.yahoo AS user_yim, u.skype AS user_skype, u.title AS user_rank, u.privacy, u.class AS user_class, u.enabled, u.user_sig, u.user_reputation_level, u.user_rank_id';
	462	$sql_array['SELECT'] = 'u.name AS username, u.uid, u.user_posts, u.email, u.user_session_time, u.user_lastvisit, p.*, pt.post_text, pt.post_subject, u.gender, u.birthday, u.warneduntil, u.parked, u.donor, u.added AS user_regdate, u.uploaded, u.downloaded, u.avatar AS user_avatar, u.icq AS user_icq, u.msn, u.aim AS user_aim, u.yahoo AS user_yim, u.skype AS user_skype, u.title AS user_rank, u.privacy, u.class AS user_class, u.enabled, u.user_sig, u.user_reputation_level, u.user_rank_id, u.class, u.name_append, u.user_reputation';
463	463	$sql_array['FROM'] = array(
464	464	POSTS_TABLE => 'p',
…	…
1342	1342	'ROW_CLASS' => $row_class,
1343	1343	'POSTER_NAME' => $poster,
	1344	'POSTER_NAME_PARSED' => parse_username($postrow[$i], true, array('href'=>'javascript:;', 'onclick'=>'ins(\'' . $poster . '\');')),
1344	1345	'POSTER_ICONS' => $user_icons,
1345	1346	// [begin] Extended Quick Reply Form mod

rules.php

r241	r313
35	35
36	36	$template->assign_vars(array(
37		'S_EDITED_TIME' => sprintf($lang['rules_edited_at'], ~~gmdate($config['default_dateformat'],~~ (filemtime($root_path . 'languages/lang_' . ( $userdata['session_logged_in'] ? $userdata['language'] : $config['default_lang']) . '/' . $lang_file)))))
	37	'S_EDITED_TIME' => sprintf($lang['rules_edited_at'], create_date((filemtime($root_path . 'languages/lang_' . ( $userdata['session_logged_in'] ? $userdata['language'] : $config['default_lang']) . '/' . $lang_file)))))
38	38	);
39	39	//��

signup.php

r307	r313
347	347	'user_rank_id' => $user_rank_id,
348	348	'user_reputation_level' => $user_reputation_level,
	349
	350	'name_append' => '',
349	351	);
350	352

sql.sql

r307	r313
738	738	`search_id` int(11) unsigned NOT NULL DEFAULT '0',
739	739	`session_id` varchar(32) DEFAULT NULL,
740		`search_array` ~~text~~,
	740	`search_array` LONGTEXT,
741	741	`search_time` int(11) DEFAULT '0',
742	742	PRIMARY KEY (`search_id`),
…	…
1775	1775	`uid` int(10) unsigned NOT NULL DEFAULT '0',
1776	1776	`name` varchar(40) DEFAULT NULL,
	1777	`name_append` text NOT NULL,
1777	1778	`pass` varchar(32) DEFAULT NULL,
1778	1779	`secret` blob,

templates/admin/admin_upload_statistics.tpl

r197	r313
2	2	{L_TOTAL_UPLOADERS}
3	3	<table cellspacing="2" cellpadding="4" border="0" align="center" class="forumline">
4		<tr>
5		<td class="row2">#</td>
6		<td class="row2"><a href="{S_UPLOAD_STATISTICS_ACTION}&act=upstats&uporder=name#upstats">{L_USERNAME}</a></td>
7		<td class="row2">{L_UPLOADED} / {L_DOWNLOADED}</td>
8		<td class="row2"><a href="{S_UPLOAD_STATISTICS_ACTION}&act=upstats&uporder=ratio#upstats">{L_RATIO}</a></td>
9		<td class="row2"><a href="{S_UPLOAD_STATISTICS_ACTION}&act=upstats&uporder=torrents#upstats">{L_TORRENTS}</a></td>
10		<td class="row2"><a href="{S_UPLOAD_STATISTICS_ACTION}&act=upstats&uporder=peers#upstats">{L_PEERS}</a></td>
11		<td class="row2"><a href="{S_UPLOAD_STATISTICS_ACTION}&act=upstats&uporder=last_up#upstats">{L_LAST_TORRENT_ADDED}</a></td>
12		<td class="row2">{L_PM}</td>
13		</tr>
14		<!-- BEGIN uploaders_row -->
15		<tr>
16		<td class="{uploaders_row.TD_COLOR}">{uploaders_row.COUNTER}</td>
17		<td class="{uploaders_row.TD_COLOR}"><a href="{TRACKER_URL}/userdetails.php?id={uploaders_row.USER_ID}">{uploaders_row.USERNAME}</a>{uploaders_row.USER_ICONS}</td>
18		<td class="{uploaders_row.TD_COLOR}">{uploaders_row.UPLOADED} / {uploaders_row.DOWNLOADED}</td>
19		<td class="{uploaders_row.TD_COLOR}"><span style="color:{uploaders_row.RATIO_COLOR}">{uploaders_row.RATIO}</span></td>
20		<td class="{uploaders_row.TD_COLOR}"><!-- IF uploaders_row.NUM_TORRENTS == 0 --><span style="color:#FF0000;"><!-- ENDIF -->{uploaders_row.NUM_TORRENTS} {L_TORRENTS}<!-- IF uploaders_row.NUM_TORRENTS == 0 --></span><!-- ENDIF --></td>
21		<td class="{uploaders_row.TD_COLOR}"><!-- IF uploaders_row.NUM_PEERS == 0 --><span style="color:#FF0000;"><!-- ENDIF -->{uploaders_row.NUM_PEERS} {L_PEERS}<!-- IF uploaders_row.NUM_PEERS == 0 --></span><!-- ENDIF --></td>
22		<td class="{uploaders_row.TD_COLOR}">{uploaders_row.LAST_ADDED}</td>
23		<td class="{uploaders_row.TD_COLOR}"><a href="{TRACKER_URL}/message.php?action=send&receiver={uploaders_row.USER_ID}"><img src="{IMG_PM_BUTTON}" alt="" /></a></td>
24		</tr>
25		<!-- END uploaders_row -->
	4	<tr>
	5	<td class="row2">#</td>
	6	<td class="row2"><a href="{U_UP_ST_USERNAME}#upstats">{L_USERNAME}</a></td>
	7	<td class="row2">{L_UPLOADED} / {L_DOWNLOADED}</td>
	8	<td class="row2"><a href="{U_UP_ST_RATIO}#upstats">{L_RATIO}</a></td>
	9	<td class="row2"><a href="{U_UP_ST_TORRENTS}#upstats">{L_TORRENTS}</a></td>
	10	<td class="row2"><a href="{U_UP_ST_PEERS}#upstats">{L_PEERS}</a></td>
	11	<td class="row2"><a href="{U_UP_ST_LASTUP}#upstats">{L_LAST_TORRENT_ADDED}</a></td>
	12	<td class="row2">{L_PM}</td>
	13	</tr>
	14
	15	<!-- BEGIN uploaders_row -->
	16
	17	<tr class="{uploaders_row.TD_COLOR}">
	18	<td>{uploaders_row.COUNTER}</td>
	19	<td><a href="{uploaders_row.U_USERDETAILS}">{uploaders_row.USERNAME}</a>{uploaders_row.USER_ICONS}</td>
	20	<td>{uploaders_row.UPLOADED} / {uploaders_row.DOWNLOADED}</td>
	21	<td><span style="color:{uploaders_row.RATIO_COLOR}">{uploaders_row.RATIO}</span></td>
	22	<td><!-- IF uploaders_row.NUM_TORRENTS == 0 --><span style="color:#FF0000;"><!-- ENDIF -->{uploaders_row.NUM_TORRENTS} {L_TORRENTS}<!-- IF uploaders_row.NUM_TORRENTS == 0 --></span><!-- ENDIF --></td>
	23	<td><!-- IF uploaders_row.NUM_PEERS == 0 --><span style="color:#FF0000;"><!-- ENDIF -->{uploaders_row.NUM_PEERS} {L_PEERS}<!-- IF uploaders_row.NUM_PEERS == 0 --></span><!-- ENDIF --></td>
	24	<td>{uploaders_row.LAST_ADDED}</td>
	25	<td><a href="{uploaders_row.U_PM}"><img src="{TEMPLATE_IMAGE_PM}" alt="" /></a></td>
	26	</tr>
	27
	28	<!-- END uploaders_row -->
	29
26	30	</table>
27	31
28	32	<h1><a name="upstatcats">{L_CATEGORIES_ACTIVITY}</a></h1>
	33
29	34	<table cellspacing="2" cellpadding="4" border="0" align="center" class="forumline">
30		<tr>
31		<td class="row2"><a href="{S_UPLOAD_STATISTICS_ACTION}&act=upstats&catorder=category#upstatcats">{L_TYPE}</a></td>
32		<td class="row2"><a href="{S_UPLOAD_STATISTICS_ACTION}&act=upstats&catorder=lastul#upstatcats">{L_LAST_TORRENT_ADDED}</a></td>
33		<td class="row2"><a href="{S_UPLOAD_STATISTICS_ACTION}&act=upstats&catorder=torrents#upstatcats">{L_TORRENTS}</a></td>
34		<td class="row2">%</td>
35		<td class="row2"><a href="{S_UPLOAD_STATISTICS_ACTION}&act=upstats&catorder=peers#upstatcats">{L_PEERS}</a></td>
36		<td class="row2">%</td>
37		</tr>
38		<!-- BEGIN cats_row -->
39		<tr>
40		<td class="{cats_row.TD_COLOR}">{cats_row.CAT_NAME}</td>
41		<td class="{cats_row.TD_COLOR}">{cats_row.LAST_UP}</td>
42		<td class="{cats_row.TD_COLOR}">{cats_row.NUM_TORRENTS}</td>
43		<td class="{cats_row.TD_COLOR}">{cats_row.TORRENTS_PERCENT}</td>
44		<td class="{cats_row.TD_COLOR}">{cats_row.NUM_PEERS}</td>
45		<td class="{cats_row.TD_COLOR}">{cats_row.PEERS_PERCENT}</td>
46		<!-- END cats_row -->
	35	<tr>
	36	<td class="row2"><a href="{U_CT_ST_CATEGORY}#upstatcats">{L_TYPE}</a></td>
	37	<td class="row2"><a href="{U_CT_ST_LASTUL}#upstatcats">{L_LAST_TORRENT_ADDED}</a></td>
	38	<td class="row2"><a href="{U_CT_ST_TORRENTS}#upstatcats">{L_TORRENTS}</a></td>
	39	<td class="row2">%</td>
	40	<td class="row2"><a href="{U_CT_ST_PEERS}#upstatcats">{L_PEERS}</a></td>
	41	<td class="row2">%</td>
	42	</tr>
	43
	44	<!-- BEGIN cats_row -->
	45
	46	<tr class="{cats_row.TD_COLOR}">
	47	<td>{cats_row.CAT_NAME}</td>
	48	<td>{cats_row.LAST_UP}</td>
	49	<td>{cats_row.NUM_TORRENTS}</td>
	50	<td>{cats_row.TORRENTS_PERCENT}</td>
	51	<td>{cats_row.NUM_PEERS}</td>
	52	<td>{cats_row.PEERS_PERCENT}</td>
	53
	54	</tr>
	55
	56	<!-- END cats_row -->
	57
47	58	</table>

templates/bithdtv/browse.html

r308	r313
55	55	</form>
56	56
57		<!-- BEGIN switch_searchstring_section -->
	57	<!-- IF SEARCH_STRING -->
	58
58	59	<h1>{SEARCH_RESULTS}</h1>
59		<!-- END switch_searchstring_section -->
60		<!-- BEGIN switch_nothing_found -->
61		<h1>{L_NOTHING_FOUND}</h1>
62		{L_TRY_CHANGE_SEARCH}
63		<!-- END switch_nothing_found -->
64		<!-- BEGIN switch_nothing -->
65		<h1>{L_NOTHING_FOUND}</h1>
66		<!-- END switch_nothing -->
67		<table align=center cellpadding=5>
68		<tr>
69		<td class=pager>{PAGER_TOP}</td>
70		</tr>
71		</table>
	60
	61	<!-- ENDIF -->
	62
	63	<!-- IF FOUND -->
72	64
73	65	<!-- INCLUDE torrents_table.html -->
74	66
75		<table align=center cellpadding=5>
76		<tr>
77		<td class=pager>{PAGER_BOTTOM}</td>
78		</tr>
79		</table>
	67	{PAGERBOTTOM}
	68
	69	<!-- ELSE -->
	70
	71	<h1>{L_NOTHING_FOUND}</h1>
	72	{L_TRY_CHANGE_SEARCH}
	73
	74	<!-- ENDIF -->
80	75
81	76	<!-- INCLUDE overall_footer.html -->

templates/bithdtv/comments_table.html

r311	r313
19	19	<td align="left">
20	20	<a id="comm{comments_table_row.COMM_ID}"></a><a href="{comments_table_row.U_COMMENT}"><img src="{comments_table_row.MINI_POST_IMG}" width="12" height="9" border="0" alt="{comments_table_row.MINI_POST_ALT}" />#{comments_table_row.COMM_ID}</a> {L_FROM}
21		<!-- IF comments_table_row.USER_ID --><a href="{comments_table_row.U_USERDETAILS}"><!-- ENDIF --><b>{comments_table_row.USERNAME}</b><!-- IF comments_table_row.USER_ID --></a><!-- ENDIF -->
22
23		<!-- IF comments_table_row.USER_ID -->
24
25		<span class="<!-- IF comments_table_row.USER_REPUTATION_LEVEL < 0 -->badUserResp<!-- ELSE -->goodUserResp<!-- ENDIF -->">{comments_table_row.USER_REPUTATION_LEVEL}</span>
26		<!-- ENDIF -->
	21	{comments_table_row.USERNAME}
27	22	{L_POSTED_AT}{comments_table_row.POST_TIME}
28	23	</td>

templates/bithdtv/forum/viewtopic_body.tpl

r269	r313
67	67	<tr>
68	68	<td align="left" valign="top" class="{postrow.ROW_CLASS}">
69		<span class="name"><a name="{postrow.U_POST_ID}"></a><b><a href="javascript:void(0);" onclick="javascript:ins('{postrow.POSTER_NAME}');">{postrow.POSTER_NAME}{postrow.POSTER_ICONS}</a></b></span>
70		<span class="<!-- IF postrow.USER_REPUTATION_LEVEL < 0 -->badUserResp<!-- ELSE -->goodUserResp<!-- ENDIF -->">{postrow.USER_REPUTATION_LEVEL}</span>
	69	<span class="name"><a name="{postrow.U_POST_ID}"></a><b><a href="javascript:;" onclick="javascript:ins('{postrow.POSTER_NAME}');">{postrow.POSTER_NAME_PARSED}</a></b></span>
71	70	<br />
72	71	<span class="postdetails">{postrow.POSTER_RANK}<br />

templates/bithdtv/overall_header.html

r308	r313
90	90	<table cellpadding="4" cellspacing="1" border="0" width="852">
91	91	<tr>
92		<td>{L_HELLO}<a href="{U_USERDETAILS_LINK}">{CURRENT_USER_NAME}</a> {CURRENT_USER_ICONS}
93
94		<span class="<!-- IF CURRENT_USER_POINTS_LEVEL < 0 -->badUserResp<!-- ELSE -->goodUserResp<!-- ENDIF -->">{CURRENT_USER_POINTS_LEVEL}</span>
95		<!-- IF CURRENT_USER_RANK_NAME --> [{CURRENT_USER_RANK_NAME}]<!-- ENDIF -->, {L_REPUTATION}: {CURRENT_USER_POINTS}
	92	<td>
	93	{CURRENT_USER_NAME}<!-- IF CURRENT_USER_RANK_NAME --> [{CURRENT_USER_RANK_NAME}]<!-- ENDIF -->, {L_REPUTATION}: {CURRENT_USER_POINTS}
96	94	[<a href="{U_LOGOUT}">{L_LOGOUT}</a>]<br />
97	95

templates/bithdtv/tags_view_form.html

r305	r313
33	33	<!-- END tags_row -->
34	34
35		<!-- IF S_USER_LOGGED_IN -->
	35	<!-- IF S_USER_LOGGED_IN && ALLOW_ADD_TAGS -->
36	36
37	37	[<a href="javascript:;" onclick="show_prompt('{TAG_TYPE}', '{ID}')">{L_ADD_TAG}</a>]

templates/bithdtv/torrents_table.html

r308	r313
1		~~<!-- BEGIN torrent_table -->~~
2	1
3	2	<!-- IF S_FORM_ACTION -->
…	…
32	31	<!-- BEGIN torrents_table -->
33	32
34		<!-- IF torrent~~_table.torrent~~s_table.ADDED_DAY -->
	33	<!-- IF torrents_table.ADDED_DAY -->
35	34	<tr>
36		<td class="detail" colspan="15" align="left" style="padding:10px;font-size:11pt;font-weight:bold;">{L_ADDED} {torrent~~_table.torrent~~s_table.ADDED_DAY}</td>
	35	<td class="detail" colspan="15" align="left" style="padding:10px;font-size:11pt;font-weight:bold;">{L_ADDED} {torrents_table.ADDED_DAY}</td>
37	36	</tr>
38	37	<!-- ENDIF -->
39	38
40	39	<tr>
41		<td class=detail align=center><p><a href='{torrent~~_table.torrents_table.U_DOWNLOAD}'><img src="{TEMPLATE_PATH}/images/download.gif" /></a></p><p style='padding-top: 2px;'></p><p style='padding-top: 2px;'><a href={torrent_table.~~torrents_table.U_ADD_BOOKMARK}><img src={TEMPLATE_PATH}/images/bookmark.gif border=0></a></p></td>
42		<td class=detail align=center style="padding: 0px"><a href="{torrent~~_table.torrent~~s_table.U_CATEGORY}">
	40	<td class=detail align=center><p><a href='{torrents_table.U_DOWNLOAD}'><img src="{TEMPLATE_PATH}/images/download.gif" /></a></p><p style='padding-top: 2px;'></p><p style='padding-top: 2px;'><a href={torrents_table.U_ADD_BOOKMARK}><img src={TEMPLATE_PATH}/images/bookmark.gif border=0></a></p></td>
	41	<td class=detail align=center style="padding: 0px"><a href="{torrents_table.U_CATEGORY}">
43	42
44		<!-- IF torrent~~_table.torrent~~s_table.CAT_PIC -->
45		<img src="{ROOT_PATH}pic/categories/{torrent~~_table.torrents_table.CAT_PIC}" alt="{torrent_table.torrents_table.CAT_NAME}" title="{torrent_table.~~torrents_table.CAT_NAME}" />
	43	<!-- IF torrents_table.CAT_PIC -->
	44	<img src="{ROOT_PATH}pic/categories/{torrents_table.CAT_PIC}" alt="{torrents_table.CAT_NAME}" title="{torrents_table.CAT_NAME}" />
46	45	<!-- ELSE -->
47		{torrent~~_table.torrent~~s_table.CAT_NAME}
	46	{torrents_table.CAT_NAME}
48	47	<!-- ENDIF -->
49	48	</a></td>
50	49
51		<td {torrent~~_table.torrent~~s_table.HIDDEN_COLOR}class=detail align=left>
	50	<td {torrents_table.HIDDEN_COLOR}class=detail align=left>
52	51
53		<!-- IF torrent~~_table.torrent~~s_table.MODERATED == false -->
	52	<!-- IF torrents_table.MODERATED == false -->
54	53	<span style="color:red;font-size:15px;font-weight:900;text-decoration:blink;"> ! </span>
55	54	<!-- ENDIF -->
56	55
57		<a href="{torrent~~_table.torrents_table.U_DETAILS}"><b>{torrent_table.~~torrents_table.DISPNAME}</b></a>
	56	<a href="{torrents_table.U_DETAILS}"><b>{torrents_table.DISPNAME}</b></a>
58	57
59		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_FREE_ICON -->
60		<img src="{torrent~~_table.torrent~~s_table.TORRENT_FREE_ICON}" alt="{L_FREE}" title="{L_FREE}" />
	58	<!-- IF torrents_table.TORRENT_FREE_ICON -->
	59	<img src="{torrents_table.TORRENT_FREE_ICON}" alt="{L_FREE}" title="{L_FREE}" />
61	60	<!-- ENDIF -->
62	61
63		<!-- IF torrent~~_table.torrent~~s_table.NEW -->
	62	<!-- IF torrents_table.NEW -->
64	63	<strong><span style="color: #990000">{L_NEW_TORRENT}</span></strong>
65	64	<!-- ENDIF -->
66	65
67		<!-- IF torrent~~_table.torrent~~s_table.CAT_NAME_DISPLAY -->
68		<br /><i>{torrent~~_table.torrent~~s_table.CAT_NAME_DISPLAY}</i>
	66	<!-- IF torrents_table.CAT_NAME_DISPLAY -->
	67	<br /><i>{torrents_table.CAT_NAME_DISPLAY}</i>
69	68	<!-- ENDIF -->
70	69
71	70	</td>
72		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}class=detail align="center"><b><a href="{torrent_table.torrents_table.U_DETAILS_FILELIST}">{torrent_table.~~torrents_table.NUMFILES}</a></b></td>
73		<td {torrent~~_table.torrent~~s_table.HIDDEN_COLOR}class=detail align="center">
	71	<td {torrents_table.HIDDEN_COLOR}class=detail align="center"><b><a href="{torrents_table.U_DETAILS_FILELIST}">{torrents_table.NUMFILES}</a></b></td>
	72	<td {torrents_table.HIDDEN_COLOR}class=detail align="center">
74	73
75		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_COMMENTS -->
76		<b><a href="{torrent~~_table.torrents_table.U_COMMENTS}">{torrent_table.~~torrents_table.TORRENT_COMMENTS}</a></b>
	74	<!-- IF torrents_table.TORRENT_COMMENTS -->
	75	<b><a href="{torrents_table.U_COMMENTS}">{torrents_table.TORRENT_COMMENTS}</a></b>
77	76	<!-- ELSE -->
78	77	0
…	…
82	81
83	82	<!-- IF L_TTL -->
84		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}class=detail align="center">{torrent_table.~~torrents_table.TTL}</td>
	83	<td {torrents_table.HIDDEN_COLOR}class=detail align="center">{torrents_table.TTL}</td>
85	84	<!-- ENDIF -->
86	85
87	86	<!-- IF L_WAIT -->
88		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}class=detail align="center">{torrent_table.~~torrents_table.WAITTIME}</td>
	87	<td {torrents_table.HIDDEN_COLOR}class=detail align="center">{torrents_table.WAITTIME}</td>
89	88	<!-- ENDIF -->
90	89
91		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}class=detail align=center>{torrent_table.~~torrents_table.SIZE}</td>
92		<td {torrent~~_table.torrent~~s_table.HIDDEN_COLOR}class=detail align=center>
	90	<td {torrents_table.HIDDEN_COLOR}class=detail align=center>{torrents_table.SIZE}</td>
	91	<td {torrents_table.HIDDEN_COLOR}class=detail align=center>
93	92
94		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_COMPLETED -->
95		<a href="{torrent~~_table.torrents_table.U_SNATCHED}">{torrent_table.~~torrents_table.TORRENT_COMPLETED}</a>
	93	<!-- IF torrents_table.TORRENT_COMPLETED -->
	94	<a href="{torrents_table.U_SNATCHED}">{torrents_table.TORRENT_COMPLETED}</a>
96	95	<!-- ELSE -->
97	96	0
…	…
100	99
101	100	</td>
102		<td {torrent~~_table.torrent~~s_table.HIDDEN_COLOR}class="detail" align=center><span class="white">
	101	<td {torrents_table.HIDDEN_COLOR}class="detail" align=center><span class="white">
103	102
104		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_SEEDERS -->
105		<a href="{torrent~~_table.torrents_table.U_PEERLIST}#seeders"><span style="color:{torrent_table.torrents_table.SLR_COLOR};font-weight:bold;">{torrent_table.~~torrents_table.TORRENT_SEEDERS}</span></a>
	103	<!-- IF torrents_table.TORRENT_SEEDERS -->
	104	<a href="{torrents_table.U_PEERLIST}#seeders"><span style="color:{torrents_table.SLR_COLOR};font-weight:bold;">{torrents_table.TORRENT_SEEDERS}</span></a>
106	105	<!-- ELSE -->
107	106	<span style="color:red">0</span>
…	…
109	108
110	109	</span></td>
111		<td {torrent~~_table.torrent~~s_table.HIDDEN_COLOR}class="detail" align=center><span class="white">
	110	<td {torrents_table.HIDDEN_COLOR}class="detail" align=center><span class="white">
112	111
113		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_LEECHERS -->
114		<a href="{torrent~~_table.torrents_table.U_PEERLIST}#leechers"><strong>{torrent_table.~~torrents_table.TORRENT_LEECHERS}</strong></a>
	112	<!-- IF torrents_table.TORRENT_LEECHERS -->
	113	<a href="{torrents_table.U_PEERLIST}#leechers"><strong>{torrents_table.TORRENT_LEECHERS}</strong></a>
115	114	<!-- ELSE -->
116	115	0
117	116	<!-- ENDIF --></span></td>
118	117
119		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}class=detail align=center>{torrent_table.~~torrents_table.USERNAME}</td>
	118	<td {torrents_table.HIDDEN_COLOR}class=detail align=center>{torrents_table.USERNAME}</td>
120	119
121		<!-- IF torrent~~_table.torrent~~s_table.BOOKMARK_ID -->
122		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}class=detail align="center"><input type="checkbox" name="delbookmark[]" value="{torrent_table.torrents_table.BOOKMARK_ID}" id="bookmark_{torrent_table.~~torrents_table.ID}" /></td>
	120	<!-- IF torrents_table.BOOKMARK_ID -->
	121	<td {torrents_table.HIDDEN_COLOR}class=detail align="center"><input type="checkbox" name="delbookmark[]" value="{torrents_table.BOOKMARK_ID}" id="bookmark_{torrents_table.ID}" /></td>
123	122	<!-- ENDIF -->
124	123
125	124	<!-- IF CAN_MODERATE -->
126		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}class=detail align="center"><input type="checkbox" name="torrent_id[]" value="{torrent_table.torrents_table.ID}" id="torrent_id_{torrent_table.~~torrents_table.ID}" /></td>
	125	<td {torrents_table.HIDDEN_COLOR}class=detail align="center"><input type="checkbox" name="torrent_id[]" value="{torrents_table.ID}" id="torrent_id_{torrents_table.ID}" /></td>
127	126	<!-- ENDIF -->
128	127
…	…
144	143	</form>
145	144	<!-- ENDIF -->
146
147		~~<!-- END torrent_table -->~~

templates/main/browse.html

r308	r313
57	57	</fieldset>
58	58	</form>
59		<!-- BEGIN switch_searchstring_section -->
	59
	60	<!-- IF SEARCH_STRING -->
	61
60	62	<h1>{SEARCH_RESULTS}</h1>
61		<!-- END switch_searchstring_section -->
62		<!-- BEGIN switch_nothing_found -->
63		<h1>{L_NOTHING_FOUND}</h1>
64		{L_TRY_CHANGE_SEARCH}
65		<!-- END switch_nothing_found -->
66		<!-- BEGIN switch_nothing -->
67		<h1>{L_NOTHING_FOUND}</h1>
68		<!-- END switch_nothing -->
69		{PAGER_TOP}
	63
	64	<!-- ENDIF -->
	65
	66	<!-- IF FOUND -->
70	67
71	68	<!-- INCLUDE torrents_table.html -->
72	69
73		{PAGER_BOTTOM}
	70	{PAGERBOTTOM}
	71
	72	<!-- ELSE -->
	73
	74	<h1>{L_NOTHING_FOUND}</h1>
	75	{L_TRY_CHANGE_SEARCH}
	76
	77	<!-- ENDIF -->
74	78
75	79	<!-- INCLUDE overall_footer.html -->

templates/main/comments_table.html

r311	r313
24	24	<tr>
25	25	<td class="message_head" >
26		<!-- IF comments_table_row.USER_ID --><a href="{comments_table_row.U_USERDETAILS}"><!-- ENDIF --><b>{comments_table_row.USERNAME}</b><!-- IF comments_table_row.USER_ID --></a><!-- ENDIF -->
27
28		<!-- IF comments_table_row.USER_ID -->
29
30		<span class="<!-- IF comments_table_row.USER_REPUTATION_LEVEL < 0 -->badUserResp<!-- ELSE -->goodUserResp<!-- ENDIF -->">{comments_table_row.USER_REPUTATION_LEVEL}</span>
31
32		<!-- ENDIF -->
	26	{comments_table_row.USERNAME}
33	27
34	28	<br />

templates/main/forum/viewtopic_body.tpl

r269	r313
68	68	<td align="left" valign="top" class="{postrow.ROW_CLASS}">
69	69	<span class="name"><a name="{postrow.U_POST_ID}"></a>
70		<b><a href="javascript:void(0);" onclick="javascript:ins('{postrow.POSTER_NAME}');">{postrow.POSTER_NAME}{postrow.POSTER_ICONS}</a></b></span>
71		<span class="<!-- IF postrow.USER_REPUTATION_LEVEL < 0 -->badUserResp<!-- ELSE -->goodUserResp<!-- ENDIF -->">{postrow.USER_REPUTATION_LEVEL}</span>
	70	<b>{postrow.POSTER_NAME_PARSED}</b></span>
72	71	<br />
73	72	<span class="postdetails">{postrow.POSTER_RANK}<br />

templates/main/main.css

r308	r313
1269	1269	background:#09C;
1270	1270	border:1px solid #069;
1271		color:#FFF;
	1271	color:#FFF !important;
1272	1272	padding:0 3px;
1273	1273	}
…	…
1276	1276	background:#069;
1277	1277	border:1px solid #036;
1278		color:#FFF;
	1278	color:#FFF !important;
1279	1279	padding:0 3px;
	1280	}
	1281
	1282	.badUserResp a, .goodUserResp a {
	1283	color:#FFF !important;
1280	1284	}
1281	1285

templates/main/overall_header.html

r308	r313
31	31
32	32	<div id="userbar">
33		<span class="left">{L_HELLO}<a href="{U_USERDETAILS_LINK}"><b>{CURRENT_USER_NAME}</b></a> {CURRENT_USER_ICONS}
34
35		<span class="<!-- IF CURRENT_USER_POINTS_LEVEL < 0 -->badUserResp<!-- ELSE -->goodUserResp<!-- ENDIF -->">{CURRENT_USER_POINTS_LEVEL}</span>
36		<!-- IF CURRENT_USER_RANK_NAME --> [{CURRENT_USER_RANK_NAME}]<!-- ENDIF -->, {L_REPUTATION}: {CURRENT_USER_POINTS}
	33	<span class="left">{L_HELLO}{CURRENT_USER_NAME}<!-- IF CURRENT_USER_RANK_NAME --> [{CURRENT_USER_RANK_NAME}]<!-- ENDIF -->, {L_REPUTATION}: {CURRENT_USER_POINTS}
37	34	[<a href="{U_LOGOUT}">{L_LOGOUT}</a>]<br />{L_RATIO}: {CURRENT_USER_RATIO}
38	35

templates/main/tags_view_form.html

r305	r313
33	33	<!-- END tags_row -->
34	34
35		<!-- IF S_USER_LOGGED_IN -->
	35	<!-- IF S_USER_LOGGED_IN && ALLOW_ADD_TAGS -->
36	36
37	37	[<a href="javascript:;" onclick="show_prompt('{TAG_TYPE}', '{ID}')">{L_ADD_TAG}</a>]

templates/main/torrents_table.html

r308	r313
1		~~<!-- BEGIN torrent_table -->~~
2	1
3	2	<!-- IF S_FORM_ACTION -->
…	…
23	22	<th><a href="{U_SORT_8}" class="white">{L_SNATCHED}</a></th>
24	23	<th><span class="nowrap"><a href="{U_SORT_9}" class="white">{L_SEEDS_SHORT}</a>\|<a href="{U_SORT_10}" class="white">{L_LEECHS_SHORT}</a></span></th>
	24
	25	<!-- IF S_USER_LOGGED_IN -->
	26
25	27	<th><a href="{U_SORT_11}" class="white">{L_UPPED}</a></th>
	28
	29	<!-- ENDIF -->
26	30
27	31	<!-- IF S_FORM_ACTION -->
…	…
35	39	<!-- BEGIN torrents_table -->
36	40
37		<!-- IF torrent~~_table.torrent~~s_table.ADDED_DAY -->
	41	<!-- IF torrents_table.ADDED_DAY -->
38	42	<tr>
39		<td colspan="15" align="left" style="padding:10px;font-size:1.2em;font-weight:bold;">{L_ADDED} {torrent~~_table.torrent~~s_table.ADDED_DAY}</td>
	43	<td colspan="15" align="left" style="padding:10px;font-size:1.2em;font-weight:bold;">{L_ADDED} {torrents_table.ADDED_DAY}</td>
40	44	</tr>
41	45	<!-- ENDIF -->
…	…
43	47	<tr>
44	48	<td align="center">
45		<a href="{torrent~~_table.torrent~~s_table.U_DOWNLOAD}"><img src="{TEMPLATE_PATH}/images/download.gif" alt="{L_DOWNLOAD}" title="{L_DOWNLOAD}" /></a><br /><br />
46		<a href="{torrent~~_table.torrent~~s_table.U_ADD_BOOKMARK}"><img src="{TEMPLATE_PATH}/images/bookmark.gif" alt="{L_ADD_TO_BOOKMARKS}" title="{L_ADD_TO_BOOKMARKS}" /></a>
	49	<a href="{torrents_table.U_DOWNLOAD}"><img src="{TEMPLATE_PATH}/images/download.gif" alt="{L_DOWNLOAD}" title="{L_DOWNLOAD}" /></a><br /><br />
	50	<a href="{torrents_table.U_ADD_BOOKMARK}"><img src="{TEMPLATE_PATH}/images/bookmark.gif" alt="{L_ADD_TO_BOOKMARKS}" title="{L_ADD_TO_BOOKMARKS}" /></a>
47	51	</td>
48	52
49		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}><a href="{torrent_table.~~torrents_table.U_CATEGORY}">
	53	<td {torrents_table.HIDDEN_COLOR}><a href="{torrents_table.U_CATEGORY}">
50	54
51		<!-- IF torrent~~_table.torrent~~s_table.CAT_PIC -->
52		<img src="{ROOT_PATH}pic/categories/{torrent~~_table.torrents_table.CAT_PIC}" alt="{torrent_table.torrents_table.CAT_NAME}" title="{torrent_table.~~torrents_table.CAT_NAME}" />
	55	<!-- IF torrents_table.CAT_PIC -->
	56	<img src="{ROOT_PATH}pic/categories/{torrents_table.CAT_PIC}" alt="{torrents_table.CAT_NAME}" title="{torrents_table.CAT_NAME}" />
53	57	<!-- ELSE -->
54		{torrent~~_table.torrent~~s_table.CAT_NAME}
	58	{torrents_table.CAT_NAME}
55	59	<!-- ENDIF -->
56	60
57	61	</a></td>
58	62
59		<td {torrent~~_table.torrent~~s_table.HIDDEN_COLOR}align="left">
	63	<td {torrents_table.HIDDEN_COLOR}align="left">
60	64
61		<!-- IF ~~torrent_table.torrents_table.MODERATED == false~~ -->
	65	<!-- IF not torrents_table.MODERATED -->
62	66	<span style="color:red;font-size:15px;font-weight:900;text-decoration:blink;"> ! </span>
63	67	<!-- ENDIF -->
64	68
65		<a href="{torrent~~_table.torrents_table.U_DETAILS}"><b>{torrent_table.~~torrents_table.DISPNAME}</b></a>
	69	<a href="{torrents_table.U_DETAILS}"><b>{torrents_table.DISPNAME}</b></a>
66	70
67		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_FREE_ICON -->
68		<img src="{torrent~~_table.torrent~~s_table.TORRENT_FREE_ICON}" alt="{L_FREE}" title="{L_FREE}" />
	71	<!-- IF torrents_table.TORRENT_FREE_ICON -->
	72	<img src="{torrents_table.TORRENT_FREE_ICON}" alt="{L_FREE}" title="{L_FREE}" />
69	73	<!-- ENDIF -->
70	74
71		<!-- IF torrent~~_table.torrent~~s_table.NEW -->
	75	<!-- IF torrents_table.NEW -->
72	76	<strong><span style="color: #990000">{L_NEW_TORRENT}</span></strong>
73	77	<!-- ENDIF -->
74	78
75		<!-- IF torrent~~_table.torrent~~s_table.CAT_NAME_DISPLAY -->
76		<br /><i>{torrent~~_table.torrent~~s_table.CAT_NAME_DISPLAY}</i>
	79	<!-- IF torrents_table.CAT_NAME_DISPLAY -->
	80	<br /><i>{torrents_table.CAT_NAME_DISPLAY}</i>
77	81	<!-- ENDIF -->
78	82
79	83	</td>
80		<td {torrent_table.torrents_table.HIDDEN_COLOR}align="center"><a href="{torrent_table.torrents_table.U_DETAILS_FILELIST}"><b>{torrent_table.torrents_table.NUMFILES}</b></a></td>
81		<td {torrent_table.torrents_table.HIDDEN_COLOR}align="center">
	84	<td {torrents_table.HIDDEN_COLOR}align="center">
	85	<!-- IF S_USER_LOGGED_IN --><a href="{torrents_table.U_DETAILS_FILELIST}"><!-- ENDIF --><b>{torrents_table.NUMFILES}</b><!-- IF S_USER_LOGGED_IN --></a><!-- ENDIF -->
	86	</td>
	87	<td {torrents_table.HIDDEN_COLOR}align="center">
82	88
83		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_COMMENTS -->
84		<b><a href="{torrent~~_table.torrents_table.U_COMMENTS}">{torrent_table.~~torrents_table.TORRENT_COMMENTS}</a></b>
	89	<!-- IF torrents_table.TORRENT_COMMENTS -->
	90	<b><a href="{torrents_table.U_COMMENTS}">{torrents_table.TORRENT_COMMENTS}</a></b>
85	91	<!-- ELSE -->
86	92	0
…	…
89	95
90	96	</td>
91		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}align="center">{torrent_table.~~torrents_table.RATING}</td>
	97	<td {torrents_table.HIDDEN_COLOR}align="center">{torrents_table.RATING}</td>
92	98
93	99	<!-- IF L_TTL -->
94		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}align="center">{torrent_table.~~torrents_table.TTL}</td>
	100	<td {torrents_table.HIDDEN_COLOR}align="center">{torrents_table.TTL}</td>
95	101	<!-- ENDIF -->
96	102
97	103	<!-- IF L_WAIT -->
98		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}align="center">{torrent_table.~~torrents_table.WAITTIME}</td>
	104	<td {torrents_table.HIDDEN_COLOR}align="center">{torrents_table.WAITTIME}</td>
99	105	<!-- ENDIF -->
100	106
101		<td {torrent~~_table.torrents_table.HIDDEN_COLOR}align="center">{torrent_table.~~torrents_table.SIZE}</td>
102		<td {torrent~~_table.torrent~~s_table.HIDDEN_COLOR}align="center">
	107	<td {torrents_table.HIDDEN_COLOR}align="center">{torrents_table.SIZE}</td>
	108	<td {torrents_table.HIDDEN_COLOR}align="center">
103	109
104		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_COMPLETED -->
105		<~~a href="{torrent_table.torrents_table.U_SNATCHED}">{torrent_table.torrents_table.TORRENT_COMPLETED}</a~~>
	110	<!-- IF torrents_table.TORRENT_COMPLETED -->
	111	<!-- IF S_USER_LOGGED_IN --><a href="{torrents_table.U_SNATCHED}"><!-- ENDIF -->{torrents_table.TORRENT_COMPLETED}<!-- IF S_USER_LOGGED_IN --></a><!-- ENDIF -->
106	112	<!-- ELSE -->
107	113	0
…	…
110	116
111	117	</td>
112		<td {torrent~~_table.torrent~~s_table.HIDDEN_COLOR}align="center">
	118	<td {torrents_table.HIDDEN_COLOR}align="center">
113	119
114		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_SEEDERS -->
115		<~~a href="{torrent_table.torrents_table.U_PEERLIST}#seeders"><span style="color:{torrent_table.torrents_table.SLR_COLOR};font-weight:bold;">{torrent_table.torrents_table.TORRENT_SEEDERS}</span></a~~>
	120	<!-- IF torrents_table.TORRENT_SEEDERS -->
	121	<!-- IF S_USER_LOGGED_IN --><a href="{torrents_table.U_PEERLIST}#seeders"><!-- ENDIF --><span style="color:{torrents_table.SLR_COLOR};font-weight:bold;">{torrents_table.TORRENT_SEEDERS}</span><!-- IF S_USER_LOGGED_IN --></a><!-- ENDIF -->
116	122	<!-- ELSE -->
117	123	<span style="color:red">0</span>
…	…
120	126	\|
121	127
122		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_LEECHERS -->
123		<~~a href="{torrent_table.torrents_table.U_PEERLIST}#leechers"><strong>{torrent_table.torrents_table.TORRENT_LEECHERS}</strong></a~~>
	128	<!-- IF torrents_table.TORRENT_LEECHERS -->
	129	<!-- IF S_USER_LOGGED_IN --><a href="{torrents_table.U_PEERLIST}#leechers"><!-- ENDIF --><strong>{torrents_table.TORRENT_LEECHERS}</strong><!-- IF S_USER_LOGGED_IN --></a><!-- ENDIF -->
124	130	<!-- ELSE -->
125	131	0
…	…
127	133
128	134	</td>
129		~~<td {torrent_table.torrents_table.HIDDEN_COLOR}align="center">{torrent_table.torrents_table.USERNAME}</td>~~
130	135
131		<!-- IF torrent_table.torrents_table.BOOKMARK_ID -->
132		<td {torrent_table.torrents_table.HIDDEN_COLOR}align="center"><input type="checkbox" name="delbookmark[]" value="{torrent_table.torrents_table.BOOKMARK_ID}" id="bookmark_{torrent_table.torrents_table.ID}" /></td>
	136	<!-- IF S_USER_LOGGED_IN -->
	137	<td {torrents_table.HIDDEN_COLOR}align="center">{torrents_table.USERNAME}</td>
	138	<!-- ENDIF -->
	139
	140	<!-- IF torrents_table.BOOKMARK_ID -->
	141	<td {torrents_table.HIDDEN_COLOR}align="center"><input type="checkbox" name="delbookmark[]" value="{torrents_table.BOOKMARK_ID}" id="bookmark_{torrents_table.ID}" /></td>
133	142	<!-- ENDIF -->
134	143
135	144	<!-- IF CAN_MODERATE -->
136		<td {torrent~~_table.torrents_table.HIDDEN_COLOR} align="center"><input type="checkbox" name="torrent_id[]" value="{torrent_table.torrents_table.ID}" id="torrent_id_{torrent_table.~~torrents_table.ID}" /></td>
	145	<td {torrents_table.HIDDEN_COLOR} align="center"><input type="checkbox" name="torrent_id[]" value="{torrents_table.ID}" id="torrent_id_{torrents_table.ID}" /></td>
137	146	<!-- ENDIF -->
138	147
…	…
157	166	</form>
158	167	<!-- ENDIF -->
159
160		~~<!-- END torrent_table -->~~

templates/reflection/browse.html

r308	r313
39	39	</fieldset>
40	40	</form>
41		<!-- BEGIN switch_searchstring_section -->
42		<h1 align="center">{SEARCH_RESULTS}</h1>
43		<!-- END switch_searchstring_section -->
44		<!-- BEGIN switch_nothing_found -->
45		<h1 align="center">{L_NOTHING_FOUND}</h1>
46		{L_TRY_CHANGE_SEARCH}
47		<!-- END switch_nothing_found -->
48		<!-- BEGIN switch_nothing -->
49		<h1 align="center">{L_NOTHING_FOUND}</h1>
50		<!-- END switch_nothing -->
51		{PAGER_TOP}
	41
	42	<!-- IF SEARCH_STRING -->
	43
	44	<h1>{SEARCH_RESULTS}</h1>
	45
	46	<!-- ENDIF -->
	47
	48	<!-- IF FOUND -->
52	49
53	50	<!-- INCLUDE torrents_table.html -->
54	51
55		{PAGER_BOTTOM}
	52	{PAGERBOTTOM}
	53
	54	<!-- ELSE -->
	55
	56	<h1>{L_NOTHING_FOUND}</h1>
	57	{L_TRY_CHANGE_SEARCH}
	58
	59	<!-- ENDIF -->
56	60
57	61	<!-- INCLUDE overall_footer.html -->

templates/reflection/comments_table.html

r311	r313
20	20	<div class="commentLeftPart">
21	21	<a name="comm{comments_table_row.COMM_ID}"></a>
22		<!-- IF comments_table_row.USER_ID --><a href="{comments_table_row.U_USERDETAILS}"><!-- ENDIF --><b>{comments_table_row.USERNAME}</b><!-- IF comments_table_row.USER_ID --></a><!-- ENDIF -->
23
24		<!-- IF comments_table_row.USER_ID -->
25
26		<span class="<!-- IF comments_table_row.USER_REPUTATION_LEVEL < 0 -->badUserResp<!-- ELSE -->goodUserResp<!-- ENDIF -->">{comments_table_row.USER_REPUTATION_LEVEL}</span>
27
28		<!-- ENDIF -->
	22	{comments_table_row.USERNAME}
29	23
30	24	<br />

templates/reflection/forum/viewtopic_body.tpl

r269	r313
68	68	<!-- BEGIN postrow -->
69	69	<tr>
70		<td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}" id="{postrow.U_POST_ID}"></a><b>~~{postrow.POSTER_NAME}~~</b></span>
	70	<td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}" id="{postrow.U_POST_ID}"></a><b><a href="javascript:;" onclick="javascript:ins('{postrow.POSTER_NAME}');">{postrow.POSTER_NAME_PARSED}</a></b></span>
71	71	<span class="<!-- IF postrow.USER_REPUTATION_LEVEL < 0 -->badUserResp<!-- ELSE -->goodUserResp<!-- ENDIF -->">{postrow.USER_REPUTATION_LEVEL}</span>
72	72	<br /><span class="postdetails">{postrow.POSTER_RANK}

templates/reflection/overall_header.html

r308	r313
87	87	<p>
88	88	<span class="header">{L_MY_PROFILE}</span>
89		{L_HELLO}<a href="{U_USERDETAILS_LINK}"><b>{CURRENT_USER_NAME}</b></a> {CURRENT_USER_ICONS}
90
91		<span class="<!-- IF CURRENT_USER_POINTS_LEVEL < 0 -->badUserResp<!-- ELSE -->goodUserResp<!-- ENDIF -->">{CURRENT_USER_POINTS_LEVEL}</span>
92		<!-- IF CURRENT_USER_RANK_NAME --> [{CURRENT_USER_RANK_NAME}]<!-- ENDIF -->, {L_REPUTATION}: {CURRENT_USER_POINTS}
	89	{L_HELLO}{CURRENT_USER_NAME}<!-- IF CURRENT_USER_RANK_NAME --> [{CURRENT_USER_RANK_NAME}]<!-- ENDIF -->, {L_REPUTATION}: {CURRENT_USER_POINTS}
93	90	[<a href="{U_LOGOUT}">{L_LOGOUT}</a>]<br />
94	91

templates/reflection/tags_view_form.html

r305	r313
33	33	<!-- END tags_row -->
34	34
35		<!-- IF S_USER_LOGGED_IN -->
	35	<!-- IF S_USER_LOGGED_IN && ALLOW_ADD_TAGS -->
36	36
37	37	[<a href="javascript:;" onclick="show_prompt('{TAG_TYPE}', '{ID}')">{L_ADD_TAG}</a>]

templates/reflection/torrents_table.html

r308	r313
1		~~<!-- BEGIN torrent_table -->~~
2	1
3	2	<!-- IF S_FORM_ACTION -->
…	…
27	26	<!-- BEGIN torrents_table -->
28	27
29		<!-- IF torrent~~_table.torrent~~s_table.ADDED_DAY -->
	28	<!-- IF torrents_table.ADDED_DAY -->
30	29	<div class="torrentsBlock">
31		<div style="padding:10px;font-size:1.2em;font-weight:bold;">{L_ADDED} {torrent~~_table.torrent~~s_table.ADDED_DAY}</div>
	30	<div style="padding:10px;font-size:1.2em;font-weight:bold;">{L_ADDED} {torrents_table.ADDED_DAY}</div>
32	31	</div>
33	32
…	…
37	36	<div class="torrentsTitle">
38	37
39		<!-- IF torrent~~_table.torrent~~s_table.MODERATED == false -->
	38	<!-- IF torrents_table.MODERATED == false -->
40	39	<span style="color:red;font-size:15px;font-weight:900;text-decoration:blink;"> ! </span>
41	40	<!-- ENDIF -->
42	41
43		<a href="{torrent~~_table.torrents_table.U_DETAILS}"><strong>{torrent_table.~~torrents_table.DISPNAME}</strong></a>
	42	<a href="{torrents_table.U_DETAILS}"><strong>{torrents_table.DISPNAME}</strong></a>
44	43
45		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_FREE_ICON -->
46		<img src="{torrent~~_table.torrent~~s_table.TORRENT_FREE_ICON}" alt="{L_FREE}" title="{L_FREE}" />
	44	<!-- IF torrents_table.TORRENT_FREE_ICON -->
	45	<img src="{torrents_table.TORRENT_FREE_ICON}" alt="{L_FREE}" title="{L_FREE}" />
47	46	<!-- ENDIF -->
48	47
49		<!-- IF torrent~~_table.torrent~~s_table.NEW -->
	48	<!-- IF torrents_table.NEW -->
50	49	<strong><span style="color: #990000">{L_NEW_TORRENT}</span></strong>
51	50	<!-- ENDIF -->
52	51
53	52	</div>
54		<p><a href="{torrent~~_table.torrent~~s_table.U_CATEGORY}">
	53	<p><a href="{torrents_table.U_CATEGORY}">
55	54
56		<!-- IF torrent~~_table.torrent~~s_table.CAT_PIC -->
57		<img src="{ROOT_PATH}pic/categories/{torrent~~_table.torrents_table.CAT_PIC}" alt="{torrent_table.torrents_table.CAT_NAME}" title="{torrent_table.~~torrents_table.CAT_NAME}" class="torrentsImg" />
	55	<!-- IF torrents_table.CAT_PIC -->
	56	<img src="{ROOT_PATH}pic/categories/{torrents_table.CAT_PIC}" alt="{torrents_table.CAT_NAME}" title="{torrents_table.CAT_NAME}" class="torrentsImg" />
58	57	<!-- ELSE -->
59		{torrent~~_table.torrent~~s_table.CAT_NAME}
	58	{torrents_table.CAT_NAME}
60	59	<!-- ENDIF -->
61	60
62	61	</a>
63	62
64		<!-- IF torrent~~_table.torrent~~s_table.CAT_NAME_DISPLAY -->
65		{L_TYPE}: {torrent~~_table.torrent~~s_table.CAT_NAME_DISPLAY},
	63	<!-- IF torrents_table.CAT_NAME_DISPLAY -->
	64	{L_TYPE}: {torrents_table.CAT_NAME_DISPLAY},
66	65	<!-- ENDIF -->
67	66
68		{L_ADDED}: {torrent~~_table.torrents_table.ADDED}, {L_UPPED}: {torrent_table.~~torrents_table.USERNAME}, {L_COMMENTS}:
	67	{L_ADDED}: {torrents_table.ADDED}, {L_UPPED}: {torrents_table.USERNAME}, {L_COMMENTS}:
69	68
70		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_COMMENTS -->
71		<b><a href="{torrent~~_table.torrents_table.U_COMMENTS}">{torrent_table.~~torrents_table.TORRENT_COMMENTS}</a></b>
	69	<!-- IF torrents_table.TORRENT_COMMENTS -->
	70	<b><a href="{torrents_table.U_COMMENTS}">{torrents_table.TORRENT_COMMENTS}</a></b>
72	71	<!-- ELSE -->
73	72	0
…	…
75	74
76	75	<br />
77		{L_RATING} {torrent~~_table.torrents_table.RATING}, {L_FILES}: <a href="{torrent_table.torrents_table.U_DETAILS_FILELIST}"><b>{torrent_table.torrents_table.NUMFILES}</b></a>, {L_SIZE} {torrent_table.~~torrents_table.SIZE},
	76	{L_RATING} {torrents_table.RATING}, {L_FILES}: <a href="{torrents_table.U_DETAILS_FILELIST}"><b>{torrents_table.NUMFILES}</b></a>, {L_SIZE} {torrents_table.SIZE},
78	77
79	78	{L_SNATCHED}:
80	79
81		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_COMPLETED -->
82		<a href="{torrent~~_table.torrents_table.U_SNATCHED}">{torrent_table.~~torrents_table.TORRENT_COMPLETED}</a> {L_TIMES}
	80	<!-- IF torrents_table.TORRENT_COMPLETED -->
	81	<a href="{torrents_table.U_SNATCHED}">{torrents_table.TORRENT_COMPLETED}</a> {L_TIMES}
83	82	<!-- ELSE -->
84	83	0
…	…
86	85	{L_PEERS}:
87	86
88		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_SEEDERS -->
89		<a href="{torrent~~_table.torrents_table.U_PEERLIST}#seeders"><span style="color:{torrent_table.torrents_table.SLR_COLOR};font-weight:bold;">{torrent_table.~~torrents_table.TORRENT_SEEDERS}</span></a>
	87	<!-- IF torrents_table.TORRENT_SEEDERS -->
	88	<a href="{torrents_table.U_PEERLIST}#seeders"><span style="color:{torrents_table.SLR_COLOR};font-weight:bold;">{torrents_table.TORRENT_SEEDERS}</span></a>
90	89	<!-- ELSE -->
91	90	<span style="color:red">0</span>
…	…
94	93	\|
95	94
96		<!-- IF torrent~~_table.torrent~~s_table.TORRENT_LEECHERS -->
97		<a href="{torrent~~_table.torrents_table.U_PEERLIST}#leechers"><strong>{torrent_table.~~torrents_table.TORRENT_LEECHERS}</strong></a>
	95	<!-- IF torrents_table.TORRENT_LEECHERS -->
	96	<a href="{torrents_table.U_PEERLIST}#leechers"><strong>{torrents_table.TORRENT_LEECHERS}</strong></a>
98	97	<!-- ELSE -->
99	98	0
…	…
101	100
102	101	<!-- IF L_TTL -->
103		{L_TTL}: {torrent~~_table.torrent~~s_table.TTL}
	102	{L_TTL}: {torrents_table.TTL}
104	103	<!-- ENDIF -->
105	104
106	105	<!-- IF L_WAIT -->
107		{L_WAIT}: {torrent~~_table.torrent~~s_table.WAITTIME}
	106	{L_WAIT}: {torrents_table.WAITTIME}
108	107	<!-- ENDIF -->
109	108
110		<!-- IF torrent~~_table.torrent~~s_table.BOOKMARK_ID -->
111		<input type="checkbox" name="delbookmark[]" value="{torrent~~_table.torrents_table.BOOKMARK_ID}" id="bookmark_{torrent_table.~~torrents_table.ID}" />
	109	<!-- IF torrents_table.BOOKMARK_ID -->
	110	<input type="checkbox" name="delbookmark[]" value="{torrents_table.BOOKMARK_ID}" id="bookmark_{torrents_table.ID}" />
112	111	<!-- ENDIF -->
113	112
114	113	<!-- IF CAN_MODERATE -->
115		<input type="checkbox" name="torrent_id[]" value="{torrent~~_table.torrents_table.ID}" id="torrent_id_{torrent_table.~~torrents_table.ID}" />
	114	<input type="checkbox" name="torrent_id[]" value="{torrents_table.ID}" id="torrent_id_{torrents_table.ID}" />
116	115	<!-- ENDIF -->
117	116	</p>
…	…
133	132	</form>
134	133	<!-- ENDIF -->
135
136		~~<!-- END torrent_table -->~~

userdetails.php

r311	r313
9	9	loggedinorreturn();
10	10
11		function maketable( $row )
12		{
13		global $config, $lang, $template, $db, $images, $user, $userdata, $cats, $root_path;
14		global $seo;
15
16		for ( $i = 0; $i < sizeof( $row ); ++$i ) {
17		if ( ( $user['class'] == UC_VIP \|\| $user['privacy'] <> PRIVACY_LEVEL_LOW ) && ( $userdata['class'] < UC_MODERATOR && $userdata['uid'] != $user['uid'] ) ) {
18		$ratio = '---';
19		$uploaded = '---';
20		$downloaded = '---';
21		} else {
22		$ratio = get_ratio ( $row[$i]['uploaded'], $row[$i]['downloaded'] );
23		$uploaded = mksize( $row[$i]['uploaded'] );
24		$downloaded = mksize( $row[$i]['downloaded'] );
25		}
26		if ( isset( $config['ttl'] ) && ( $config['ttl'] > 0 ) ) {
27		$ttl = floor( ( ( $config['ttl'] * 60 * 60 * 24 ) - ( time() - $row[$i]['added'] ) ) / 3600 );
28		$ttl .= '<br />' . ( $ttl == 1? $lang['hour']: $lang['hours'] );
29		}
30
31		$cat_id = $row[$i]['category'];
32		$cat_parent_id = ( isset($cats[$cats[$cat_id]['cat_parent']]['cat_id']) ? $cats[$cats[$cat_id]['cat_parent']]['cat_id'] : 0 );
33
34		// www.phpBB-SEO.com SEO TOOLKIT BEGIN
35		if ( $cat_parent_id ) {
36		$seo->set_url($cats[$cat_parent_id]['cat_name'], $cat_parent_id, $seo->seo_static['browse']);
37		$seo->set_parent($cat_id, $seo->seo_static['browse'], $cat_parent_id, $seo->seo_static['browse']);
38		}
39
40		$seo->set_url($cats[$cat_id]['cat_name'], $cat_id, $seo->seo_static['browse']);
41
42		$seo->set_parent($row[$i]['fid'], $seo->seo_static['details'], $cat_id, $seo->seo_static['browse']);
43
44		$seo->set_url(censor_text($row[$i]['torrentname']), $row[$i]['fid'], $seo->seo_static['details']);
45		// www.phpBB-SEO.com SEO TOOLKIT END
46
47		$template->assign_block_vars( 'now_torrents_row_seeding_leeching', array(
48		'U_DETAILS' => append_sid( $root_path . 'details.php?id=' . $row[$i]['fid'] ),
49		'U_PEERLIST' => append_sid( $root_path . 'details.php?id=' . $row[$i]['fid'] . '&view=peerlist' ),
50		'CAT_PIC' => $cats[$row[$i]['category']]['cat_pic'],
51		'CAT_NAME' => $cats[$row[$i]['category']]['cat_name'],
52		'ID' => $row[$i]['torrent'],
53		'NAME' => $row[$i]['torrentname'],
54		'FREE_ICON' => get_free_icon($row[$i]['free']),
55		'RATIO' => $ratio,
56		'RATIO_COLOR' => get_ratio_color( $ratio ),
57		'TTL' => ( isset( $ttl ) ? $ttl : '' ),
58		'SIZE' => mksize($row[$i]['size']),
59		'UPLOADED' => $uploaded,
60		'DOWNLOADED' => $downloaded,
61		'SEEDERS' => $row[$i]['seeders'],
62		'LEECHERS' => $row[$i]['leechers'] )
63		);
64		}
65		}
66
67		$view = request_var('view', '');
68
69		if ( $view ) {
70		if ( !$userdata['hiddentorrents'] && $userdata['class'] < UC_MODERATOR ) {
71		$wherea[] = 't.hidden = 0';
72		}
73		if ( $userdata['class'] < UC_ADMINISTRATOR ) {
74		$wherea[] = 't.banned = 0';
75		}
76		$where = ( isset( $wherea ) ? ' AND ' . implode( ' AND ', $wherea ) : '' );
77		$cats = $cache->obtain_cats();
78
79		require ( $root_path . 'include/ajax.php' );
80		$JsHttpRequest = new JsHttpRequest();
81		$db->sql_return_on_error( true );
82
83		$id = request_var('id', 0);
84
85		$sql = 'SELECT uid, privacy, status, class FROM ' . USERS_TABLE . ' u WHERE u.uid = ' . $id;
86		$result = $db->sql_query( $sql );
87		if ( !( $user = $db->sql_fetchrow( $result ) ) \|\| !$id ) {
88		return $_RESULT = array( 'tpl' => sprintf( $lang['invalid_id'], $id ) );
89		}
90		$db->sql_freeresult();
91
92		if ( !$user['status'] ) {
93		return $_RESULT = array( 'tpl' => $lang['pending_user'] );
94		}
95
96		if ( $user['privacy'] == PRIVACY_LEVEL_HIGH && $userdata['class'] < UC_MODERATOR && $id <> $userdata['uid'] ) {
97		return $_RESULT = array( 'tpl' => $lang['access_denied'] );
98		}
99
100		switch ( $view ) {
101		case 'uploaded_torrents':
102		$template->set_filenames(
103		array( 'uploaded_torrents_tpl' => 'userdetails_uploaded_torrents.html'
104		));
105		$sql = 'SELECT t.fid, t.name, t.seeders, t.leechers, t.category, t.ctime, t.free, t.ratingsum, t.numratings, s.uploaded
106		FROM ' . TORRENTS_TABLE . ' t LEFT JOIN ' . SNATCHED_TABLE . ' s ON ( t.fid = s.torrentid AND t.owner = s.userid )
107		WHERE t.owner = ' . $id . '
108		' . $where . '
109		GROUP BY t.fid
110		ORDER BY t.name';
111		$result = $db->sql_query( $sql );
112		if ( $row = $db->sql_fetchrow( $result ) ) {
113		do {
114		$added = create_date($row['ctime']);
115
116		// www.phpBB-SEO.com SEO TOOLKIT BEGIN
117		$seo->set_torrent_url($row['fid'], $row['name'], $row['category']);
118		// www.phpBB-SEO.com SEO TOOLKIT END
119
120		$uploaded = ( !empty($row['uploaded']) ? $row['uploaded'] : 0 );
121
122		$template->assign_block_vars('uploaded_torrents_row', array(
123		'U_DETAILS' => append_sid($root_path . 'details.php?id=' . $row['fid'] ),
124		'U_PEERLIST' => append_sid($root_path . 'details.php?id=' . $row['fid'] . '&view=peerlist' ),
125		'CAT_PIC' => $cats[$row['category']]['cat_pic'],
126		'CAT_NAME' => $cats[$row['category']]['cat_name'],
127		'ID' => $row['fid'],
128		'NAME' => $row['name'],
129		'FREE_ICON' => get_free_icon($row['free']),
130		'SEEDERS' => $row['seeders'],
131		'LEECHERS' => $row['leechers'],
132		'ADDED' => $added,
133		'UPLOADED' => ( $user['privacy'] <> PRIVACY_LEVEL_LOW && $userdata['class'] < UC_MODERATOR && $userdata['uid'] <> $id ? '---' : mksize($uploaded) )
134		));
135		}
136		while ( $row = $db->sql_fetchrow($result) );
137		}
138		$db->sql_freeresult();
139
140		$tpl = $template->assign_display( 'uploaded_torrents_tpl' );
141
142		return $_RESULT = array( 'tpl' => $tpl );
143		break;
144
145		case 'seeding_torrents':
146		case 'leeching_torrents':
147		$where = ' AND ' . ( $view == 'seeding_torrents' ? '`left` = 0' : ' `left` <> 0' );
148		$template->set_filenames( array( 'seeding_leeching_torrents_tpl' => 'userdetails_seeding_leeching_torrents.html' ) );
149		$sql = 'SELECT p.fid, p.left, p.uploaded, p.downloaded, t.name AS torrentname, t.free, t. size, t.category, t.seeders, t.leechers, t.ctime
150		FROM ' . PEERS_TABLE . ' p, ' . TORRENTS_TABLE . ' t
151		WHERE p.uid = ' . $id . '
152		AND p.fid = t.fid
153		' . ( defined( 'USE_XBTT' ) ? ' AND p.active = 1 ' : '' ) . '
154		' . $where;
155		$result = $db->sql_query( $sql );
156
157		$ary = array();
158		if ( $row = $db->sql_fetchrow( $result ) ) {
159		do {
160		$ary[] = $row;
161		} while ( $row = $db->sql_fetchrow( $result ) );
162		maketable( $ary );
163		}
164		$db->sql_freeresult();
165
166		$tpl = $template->assign_display( 'seeding_leeching_torrents_tpl' );
167
168		return $_RESULT = array( 'tpl' => $tpl );
169		break;
170
171		case 'completed_torrents':
172		if ( $userdata['class'] < UC_MODERATOR && $userdata['uid'] <> $id ) {
173		return $_RESULT = array( 'tpl' => $lang['access_denied'] );
174		}
175
176		$template->set_filenames( array( 'completed_torrents_tpl' => 'userdetails_completed_torrents.html' ) );
177
178		$sql = 'SELECT t.fid, t.name, t.category, t.free, t.seeders, t.leechers, s.uploaded, s.downloaded
179		FROM ' . SNATCHED_TABLE . ' s, ' . TORRENTS_TABLE . ' t
180		WHERE s.completedat <> 0
181		AND s.userid = ' . $id . '
182		AND s.torrentid = t.fid
183		' . $where . '
184		ORDER BY t.name';
185		$result = $db->sql_query( $sql );
186		if ( $row = $db->sql_fetchrow( $result ) ) {
187		do {
188		$ratio = get_ratio( $row['uploaded'], $row['downloaded'] );
189		$ratio_color = get_ratio_color( $ratio );
190
191		// www.phpBB-SEO.com SEO TOOLKIT BEGIN
192		$seo->set_torrent_url($row['fid'], $row['name'], $row['category']);
193		// www.phpBB-SEO.com SEO TOOLKIT END
194
195		$template->assign_block_vars( 'downloaded_torrents_row', array(
196		'U_DETAILS' => append_sid($root_path . 'details.php?id=' . $row['fid'] ),
197		'U_PEERLIST' => append_sid( $root_path . 'details.php?id=' . $row['fid'] . '&view=peerlist' ),
198		'RATIO' => ( $user['privacy'] <> PRIVACY_LEVEL_LOW && $userdata['class'] < UC_MODERATOR && $userdata['uid'] <> $id ? '---' : $ratio ),
199		'RATIO_COLOR' => $ratio_color,
200		'CAT_PIC' => $cats[$row['category']]['cat_pic'],
201		'CAT_NAME' => $cats[$row['category']]['cat_name'],
202		'ID' => $row['fid'],
203		'NAME' => $row['name'],
204		'FREE_ICON' => get_free_icon($row['free']),
205		'SEEDERS' => $row['seeders'],
206		'LEECHERS' => $row['leechers'],
207		'UPLOADED' => ( $user['privacy'] <> PRIVACY_LEVEL_LOW && $userdata['class'] < UC_MODERATOR && $userdata['uid'] <> $id ? '---' : mksize( $row['uploaded'] ) ),
208		'DOWNLOADED' => ( $user['privacy'] <> PRIVACY_LEVEL_LOW && $userdata['class'] < UC_MODERATOR && $userdata['uid'] <> $id ? '---' : mksize( $row['downloaded'] ) )
209		));
210		}
211		while ( $row = $db->sql_fetchrow( $result ) );
212		}
213		$db->sql_freeresult();
214
215		$tpl = $template->assign_display( 'completed_torrents_tpl' );
216
217		return $_RESULT = array( 'tpl' => $tpl );
218		break;
219
220		case 'helped_torrents':
221		if ( $userdata['class'] < UC_MODERATOR && $userdata['uid'] <> $id ) {
222		return $_RESULT = array( 'tpl' => $lang['access_denied'] );
223		}
224
225		$template->set_filenames( array( 'helped_torrents_tpl' => 'userdetails_helped_torrents.html' ) );
226		$sql = 'SELECT t.fid, t.name, t.category, t.seeders, t.leechers, t.free, s.uploaded, s.downloaded
227		FROM ' . SNATCHED_TABLE . ' s, ' . TORRENTS_TABLE . ' t
228		WHERE s.uploaded > 0
229		AND s.downloaded < t.size
230		AND s.userid= ' . $id . '
231		AND t.owner != ' . $id . '
232		AND t.fid = s.torrentid
233		' . $where . '
234		ORDER BY t.name';
235		$result = $db->sql_query( $sql );
236		if ( $row = $db->sql_fetchrow( $result ) ) {
237		do {
238		$ratio = get_ratio( $row['uploaded'], $row['downloaded'] );
239		$ratio_color = get_ratio_color( $ratio );
240
241		// www.phpBB-SEO.com SEO TOOLKIT BEGIN
242		$seo->set_torrent_url($row['fid'], $row['name'], $row['category']);
243		// www.phpBB-SEO.com SEO TOOLKIT END
244
245		$template->assign_block_vars( 'helped_torrents_row', array(
246		'U_DETAILS' => append_sid($root_path . 'details.php?id=' . $row['fid'] ),
247		'U_PEERLIST' => append_sid( $root_path . 'details.php?id=' . $row['fid'] . '&view=peerlist' ),
248		'RATIO' => ( $user['privacy'] <> PRIVACY_LEVEL_LOW && $userdata['class'] < UC_MODERATOR && $userdata['uid'] <> $id ? '---' : $ratio ),
249		'RATIO_COLOR' => $ratio_color,
250		'CAT_PIC' => $cats[$row['category']]['cat_pic'],
251		'CAT_NAME' => $cats[$row['category']]['cat_name'],
252		'ID' => $row['fid'],
253		'NAME' => $row['name'],
254		'FREE_ICON' => get_free_icon($row['free']),
255		'SEEDERS' => $row['seeders'],
256		'LEECHERS' => $row['leechers'],
257		'UPLOADED' => ( $user['privacy'] <> PRIVACY_LEVEL_LOW && $userdata['class'] < UC_MODERATOR && $userdata['uid'] <> $id ? '---' : mksize( $row['uploaded'] ) )
258		));
259		}
260		while ( $row = $db->sql_fetchrow($result) );
261		}
262		$db->sql_freeresult();
263
264		$tpl = $template->assign_display( 'helped_torrents_tpl' );
265
266		return $_RESULT = array( 'tpl' => $tpl );
267		break;
268		}
269
270		gc();
271		}
272
	11	$action = request_var('action', '');
273	12	$id = request_var('id', 0);
274	13	$username = request_var('un', '');
…	…
281	20	trigger_error( sprintf( $lang['invalid_id'], $id ) );
282	21	}
283		~~$db->sql_freeresult();~~
284
285		~~$id = $user['uid'];~~
286	22
287	23	if ( !$user['status'] ) {
…	…
289	25	}
290	26
	27	$id = $user['uid'];
291	28	$seo->set_user_url($user['name'], $id);
292	29
293		if ( isset( $_GET['comments_history'] ) ) {
294		$from_is = COMMENTS_TABLE . ' c
295		LEFT JOIN ' . TORRENTS_TABLE . ' t ON c.comment_for_id = t.fid
296		LEFT JOIN ' . REQUESTS_TABLE . ' r ON c.comment_for_id = r.id
297		LEFT JOIN ' . OFFERS_TABLE . ' o ON c.comment_for_id = o.id';
298
299		$where_is = 'c.comment_user = ' . $id;
300		$order_is = 'c.comment_id DESC';
301
302		$sql = 'SELECT COUNT(*) AS count
303		FROM ' . COMMENTS_TABLE . '
304		WHERE comment_user = ' . $id;
305		$result = $db->sql_query( $sql );
306		$count = ( $row = $db->sql_fetchrow( $result ) ) ? $row['count'] : 0;
307
308		$url = 'userdetails.php?id=' . $id . '&comments_history=1&';
309
310		list( $pagertop, $pagerbottom, $limit ) = pager( $config['posts_per_page'], $count, $url );
311
312		$subject = '<a href="' . append_sid($root_path . 'userdetails.php?id=' . $id) . '"><b>' . $user['name'] . '</b></a>' . get_user_icons( $user, true );
313
314		$sql = "SELECT t.name, t.category AS t_category, c.comment_id, c.comment_for_id, c.comment_added, c.comment_text, c.comment_type, r.request AS request_name, o.name AS offer_name, r.id AS request_id, o.id AS offer_id
315		FROM $from_is
316		WHERE c.comment_user = " . $id . "
317		ORDER BY $order_is $limit";
318		$result = $db->sql_query( $sql );
319
320		$template->assign_vars( array(
321		'SUBJECT' => sprintf( $lang['history_comments'], $subject ),
322		'PAGERTOP' => $pagertop,
323		'PAGERBOTTOM' => $pagerbottom
324		));
325
326		$bb_code = new bbcode();
327		$cats = $cache->obtain_cats();
328
329		if ( $row = $db->sql_fetchrow( $result ) ) {
330		do {
331		// make sure the line doesn't wrap
332		$torrent = split_string( $row['name'], 48 );
333		$request = split_string( $row['request_name'], 48 );
334		$offer = split_string( $row['offer_name'], 48 );
335		$added = create_date($row['comment_added']);
336
337		switch ( $row['comment_type'] ) {
338		case TYPE_TORRENT:
339
340		$cat_id = $row['t_category'];
341		$cat_parent_id = ( isset($cats[$cats[$cat_id]['cat_parent']]['cat_id']) ? $cats[$cats[$cat_id]['cat_parent']]['cat_id'] : 0 );
342
343		// www.phpBB-SEO.com SEO TOOLKIT BEGIN
344		if ( $cat_parent_id ) {
345		$seo->set_url($cats[$cat_parent_id]['cat_name'], $cat_parent_id, $seo->seo_static['browse']);
346		$seo->set_parent($cat_id, $seo->seo_static['browse'], $cat_parent_id, $seo->seo_static['browse']);
347		}
348
349		$seo->set_url($cats[$cat_id]['cat_name'], $cat_id, $seo->seo_static['browse']);
350		$seo->set_parent($row['comment_for_id'], $seo->seo_static['details'], $cat_id, $seo->seo_static['browse']);
351		$seo->set_url(censor_text($row['name']), $row['comment_for_id'], $seo->seo_static['details']);
352		// www.phpBB-SEO.com SEO TOOLKIT END
353
354		$name = $lang['torrent'];
355		$link = '<a href="' . append_sid($root_path . 'details.php?id=' . $row['comment_for_id'] ) . '#startcomments">' . $torrent . '</a>';
356		break;
357
358		case TYPE_OFFER:
359		$name = $lang['request'];
360		$link = '<a href="' . append_sid( 'requests.php?id=' . $row['comment_for_id'] ) . '#startcomments">' . $request . '</a>';
361		break;
362
363		case TYPE_REQUEST:
364		$name = $lang['offer'];
365		$link = '<a href="' . append_sid( 'offers.php?id=' . $row['comment_for_id'] ) . '#startcomments">' . $offer . '</a>';
366		break;
367		}
368
369		$bb_code->parse($row['comment_text']);
370		$comment_text = $bb_code->get_html();
371		$comment_text = censor_text($comment_text);
372
373		$template->assign_block_vars( 'viewcomm_row', array(
374		'ADDED' => $added,
375		'NAME' => $name,
376		'LINK' => $link,
377		'U_COMMENT' => append_sid($root_path . 'comment.php?cid=' . $row['comment_id']),
378		'COMMENT_ID' => $row['comment_id'],
379		'BODY' => $comment_text
380		));
381		}
382		while ( $row = $db->sql_fetchrow( $result ) );
383
384		stdhead( sprintf( $lang['history_comments'], $user['name'] ) );
385		$template->set_filenames(array(
386		'body' => 'userhistory.html'
387		));
388		stdfoot();
389		}
390		else {
391		trigger_error( $lang['nothing_found'] );
392		}
393		} else {
394		if ( isset( $_GET['delete_dead'] ) && ( $id == $userdata['uid'] ) ) {
395		$deadtime = ( time() - floor( $config['announce_interval'] + 60 ) );
396		$sql = 'SELECT p.fid, `left`, t.seeders
397		FROM ' . PEERS_TABLE . ' p, ' . TORRENTS_TABLE . ' t
398		WHERE p.fid = t.fid
399		AND p.mtime < ' . $deadtime . '
400		AND p.uid = ' . $userdata['uid'] .
401		( defined('USE_XBTT') ? ' AND active = 0' : '' );
402		$db->sql_query( $sql );
403		if ( $row = $db->sql_fetchrow( $result ) ) {
404		do {
405		$sql = 'DELETE FROM ' . PEERS_TABLE . ' WHERE fid = ' . $row['fid'] . ' AND uid = ' . $userdata['uid'] . ' LIMIT 1';
406		$db->sql_query( $sql );
407		$sql = 'UPDATE ' . TORRENTS_TABLE . ' SET ' . ( $row['left'] ? 'leechers = leechers - 1' : 'seeders = seeders - 1' ) . ( $row['seeders'] == 1 && !$row['left'] ? ', visible = 0' : '' ) . ' WHERE fid = ' . $row['fid'];
408		$db->sql_query( $sql );
409		} while ( $row = $db->sql_fetchrow( $result ) );
410		}
411		}
	30	$files = array();
	31	if ( $dir = opendir($root_path . 'include/userdetails/') ) {
	32	while ( false !== ($file = readdir($dir)) ) {
	33	if ( $file != '.' && $file != '..' ) {
	34	$file = substr($file, 0, strpos($file, '.php'));
	35	$files[] = $file;
	36	}
	37	}
	38	}
	39
	40	if ( $action ) {
	41	if ( in_array($action, $files) ) {
	42	require_once($root_path . 'include/userdetails/' . $action . '.php');
	43	}
	44	}
	45
	46
412	47	$sql = 'SELECT COUNT(*) AS comments_count FROM ' . COMMENTS_TABLE . ' WHERE comment_user = ' . $id;
413	48	$result = $db->sql_query( $sql );
…	…
542	177	}
543	178	}
544		$avatar_prefix = ( ( strpos($user['avatar'], 'user_avatar_' . $id) === false && strpos($user['avatar'], '/') !== false ) \|\| !$user['avatar'] ? '' : generate_base_url() . '/' . $config['avatar_path'] . '/' );
545	179
546	180	if ( !isset($ranks) ) {
…	…
569	203	$template->assign_vars( array(
570	204	'U_EDIT_ACCOUNT' => ( $userdata['class'] >= UC_MODERATOR && $user['class'] < $userdata['class'] ? append_sid( 'modtask.php?action=editacc&id=' . $id ) : '' ),
571		'U_DELETE_DEAD_CONNECTONS' => ( $id == $userdata['uid'] ? append_sid( ~~'userdetails.php?id=' . $id . '&delete_dead=1~~' ) : '' ),
	205	'U_DELETE_DEAD_CONNECTONS' => ( $id == $userdata['uid'] ? append_sid($root_path . 'userdetails.php?' . ( $username ? 'un=' . $username : 'id=' . $id ) . '&action=delete_dead' ) : '' ),
572	206	'S_UPLOADED_TORRENTS_DESCR' => ( $uploaded_tor_count ? sprintf( $lang['uploaded_torrents_descr'], $uploaded_tor_count ) : '' ),
573	207	'S_SEEDING_NOW_DESCR' => ( $seeding_tor_count ? sprintf( $lang['seeding_now_descr'], $seeding_tor_count ) : '' ),
…	…
606	240	'YAHOO' => $user['yahoo'],
607	241	'SKYPE' => $user['skype'],
608		'AVATAR' => ~~$avatar_prefix . $user['avatar']~~,
	242	'AVATAR' => get_user_avatar($id, $user['avatar']),
609	243	'CLASS' => get_user_class_name( $user['class'] ),
610	244	'TITLE' => $user['title'],
…	…
613	247	'AGE' => $age,
614	248	'BIRTHDAY' => $user['birthday'],
615		'COMMENTS' => ( $user['comments_count'] ? '<a href="' . append_sid($root_path . 'userdetails.php?~~id=' . $id . '&comments_history=1~~' ) . '">' . $user['comments_count'] . '</a>' : 0 ),
	249	'COMMENTS' => ( $user['comments_count'] ? '<a href="' . append_sid($root_path . 'userdetails.php?' . ( $username ? 'un=' . $username : 'id=' . $id ) . '&action=comments_history' ) . '">' . $user['comments_count'] . '</a>' : 0 ),
616	250	'FORUM_POSTS' => ( $user['user_posts'] ? '<a href="' . append_sid($root_path . 'phpbb2.php?page=search&search_author=' . $user['name']) . '">' . $user['user_posts'] . '</a>' : 0 ),
617	251	'USER_SIGNATURE' => censor_text( $user_sig ),
…	…
656	290	));
657	291	stdfoot();
658		}
	292
659	293	?>

Navigation

Legend:

Download in other formats: