Как ще стане статистиката правилно?

qnkov · 3 Януари 2012

Позлвам php melody, която отчита
Online members
Total members
Videos total
и т.н... Но понеже съм маханл регистрацията, как да направя статистиката просто да отчита при Online Members , не регистрирани потребители, а просто хора отворили сайта, по ИП да ги брои или нещо такова и да премахна Total members (което ще е колко са регнати)
Предполагам от functions.php на сайта се бърка това.

Ето го кода. Ако е от това, някой ще може ли да го направи както го искам или не е от тук? Под името "stats" търсете.

PHP:

<?php
// +------------------------------------------------------------------------+
// | PHP Melody version 1.6.6 ( www.phpsugar.com )
// +------------------------------------------------------------------------+
// | PHP Melody IS NOT FREE SOFTWARE
// | If you have downloaded this software from a website other
// | than www.phpsugar.com or if you have received
// | this software from someone who is not a representative of
// | phpSugar, you are involved in an illegal activity.
// | ---
// | In such case, please contact: support@phpsugar.com.
// +------------------------------------------------------------------------+
// | Developed by: phpSugar (www.phpsugar.com) / support@phpsugar.com
// | Copyright: (c) 2004-2011 PhpSugar.com. All rights reserved.
// +------------------------------------------------------------------------+

function db_connect(){
	global $db_host, $db_user, $db_pass, $db_name;
	$connection = @mysql_connect($db_host, $db_user, $db_pass);
	if(!$connection)  
		return false;
	$db = @mysql_select_db($db_name, $connection);
	@mysql_query('SET NAMES utf8');
	@mysql_query('SET CHARACTER SET utf8');
	@mysql_query('SET COLLATION_CONNECTION="utf8_general_ci"');
	@mysql_query("SET @@global.sql_mode='MYSQL40'");
	if(!$db) { return false; }
	return $connection;
}

function magicSlashes($strString){
	return secure_sql($strString);
}

function safename($title)
{
	// replaces every unwanted character form a string with a dash "-"
	$title = str_replace("&", "and", $title);
	$arrStupid = array('feat.', 'feat', '.com', '(tm)', ' ', '*', "'s", '"', ",", ":", ";", "@", "#", "(", ")", "?", "!", "_", "$", "+", "=", "|", "'", '/', "~", "`s", "`", "\\", "^", "[", "]", "{", "}", "<", ">", "%", "");
	
	$title = htmlentities($title);
	$title = preg_replace('/&([a-zA-Z])(.*?);/', '$1', $title); // get rid of html entities
	$title = strtolower("$title");
	$title = str_replace(".", "", $title);
	$title = str_replace($arrStupid, "-", $title);
	$flag = 1;
	while ($flag)
	{
		$newtitle = str_replace("--", "-", $title);
		if ($title != $newtitle)
		{
			$flag = 1;
		}
		else
			$flag = 0;
		$title = $newtitle;
	}
	$len = strlen($title);
	if ($title[$len - 1] == "-")
	{
		$title = substr($title, 0, $len - 1);
	}
	return $title;
}



function fewchars($s, $lenght) 
{
	$str_to_count = html_entity_decode($s);
	if (mb_strlen($str_to_count, "UTF-8" ) <= $lenght)
	{
		return $s;
	}

	$s2 = mb_substr($str_to_count, 0, $lenght - 3, "UTF-8")."...";

	return $s2;
} 

function smarty_fewchars($params, &$smarty)
{
	if (empty($params['s']))
		return '';
	if (empty($params['length']))
		$params['length'] = 255;
	
	return fewchars($params['s'], $params['length']);
}

function list_categories($parent = 0, $selected) {
	
	$sql = "SELECT * FROM pm_categories ORDER BY position ASC";

	$result = mysql_query($sql);
	$categories_array = array();
	while($row = mysql_fetch_assoc($result))
	{
		$categories_array[$row['id']] = $row;
	}
	
	$cats = '';	
	foreach($categories_array as $cat_id => $cat_arr)
	{
		if($cat_arr['parent_id'] == 0)
		{
			//	subcategories
			$subcats_count = 0;
			$subcats = '';
			$subcats_ul_class = 'hidden_li';
			
			foreach($categories_array as $cat_id2 => $subcat_arr)
			{	
				if($subcat_arr['parent_id'] == $cat_id && ($cat_id2 != $cat_id))
				{
					$subcats_count++;
					
					if(_SEOMOD == 1) 
					{
						$caturl = _URL."/browse-".$subcat_arr['tag']."-videos-1-date.html";
					}
					else
					{
						$caturl = _URL."/category.php?cat=".$subcat_arr['tag'];
					}
					if($subcat_arr['id'] == $selected)
					{
						$subcats .= "<li class=\"selectedsubcat\"><a href=\"".$caturl."\">".$subcat_arr['name']."</a></li>";
						// display parent category as 'selected'
						$selected = $subcat_arr['parent_id'];
						// change 
						$subcats_ul_class = 'visible_li';
					}
					else
					{
						$subcats .= "<li><a href=\"".$caturl."\">".$subcat_arr['name']."</a></li>";
					}
				}
			}

			//	href
			if(_SEOMOD == 1) 
			{
				$caturl = _URL."/browse-".$cat_arr['tag']."-videos-1-date.html";
			}
			else
			{
				$caturl = _URL."/category.php?cat=".$cat_arr['tag'];
			}
			//	li
			$li_item = "";
			if($cat_arr['id'] == $selected)
			{
				$li_item .= '<li class="selectedcat"';
			}
			else
			{
				$li_item .= '<li';
			}
			$li_item .= '><a href="'.$caturl.'">'.$cat_arr['name'].'</a>';
			
			if($subcats_count > 0)
			{
				$li_item .= '<ul class="'.$subcats_ul_class.'">'.$subcats.'</ul>';
			}
			$li_item .= '</li>';
			//	append 
			$cats .= $li_item;
		}
	}
	//	wrapper
	$cats = '<ul id="ul_categories">'.$cats.'</ul>';
	return $cats;
}


function list_subcategories($parent = '0', $selected) 
{
	if ($parent == '')
	{
		return '';
	}

	$subcategories = '';
	$url = '';
	
	$sql = "SELECT * 
			FROM pm_categories 
			WHERE parent_id = '". $parent ."' 
			ORDER BY position ASC";
	$result = @mysql_query($sql);
	if ( ! $result)
	{
		return '';
	}
	while ($row = mysql_fetch_assoc($result))
	{
		if (_SEOMOD == 1)
		{
			$url = _URL."/browse-".$row['tag']."-videos-1-date.html";
		}
		else
		{
			$url = _URL."/category.php?cat=".$row['tag'];
		}
		
		$subcategories .= ($row['id'] == $selected) ? '<li class="selectedcat">' : '<li>';
		$subcategories .= '<a href="'. $url .'">'. $row['name'] .' ('. $row['total_videos'] .')</a>';
		$subcategories .= '</li>';
		
	}
	return $subcategories;
}

function top_videos($sortby = "views", $limit = 7)
{
	global $config;

	$sql	= '';
	$query	= '';

	if ('' == $sortby)
	{
		$mode = 'views';
	}
	if ('' == $limit)
	{
		$limit = 7;
	}
	
	switch ($sortby)
	{
		default:
		case 'views':
		
			$sql = "SELECT * 
					FROM pm_videos 
					ORDER BY site_views DESC  
					LIMIT ".$limit;
		break;
		
		case 'rating':
		
			if (count_entries('pm_ratings', '', '') >= $limit)
			{
				$uniq_ids = '';
				$sql = "SELECT id, total_value/total_votes AS Score 
						FROM pm_ratings 
						WHERE total_votes >= (SELECT AVG(total_votes) 
											  FROM pm_ratings) 
						ORDER BY Score DESC 
						LIMIT ". $limit;

				$query 	=  @mysql_query($sql);
				if ( ! $query)
				{
					return '';
				}
				$total_results 	= @mysql_num_rows($query);
				$ratings 		= array();
				
				while ($row = mysql_fetch_assoc($query))
				{
					$uniq_ids .= "'". $row['id'] ."', ";
					$ratings[ $row['id'] ] = $row['Score'];
				}
				$uniq_ids = substr($uniq_ids, 0, -2);
				@mysql_free_result($query);
			
				if ($total_results < $limit)
				{
					$new_limit = $limit - $total_results;
					
					$sql = "SELECT id, total_value/total_votes AS Score 
						FROM pm_ratings 
						WHERE id NOT IN(". $uniq_ids .") 
						ORDER BY Score DESC 
						LIMIT ". $new_limit;
						
					$query =  @mysql_query($sql);
					$total_results 	= @mysql_num_rows($query);
					if ($total_results > 0)
					{
						$uniq_ids .= ', ';
						while ($row = mysql_fetch_assoc($query))
						{
							$uniq_ids .= "'". $row['id'] ."', ";
							$ratings[ $row['id'] ] = $row['Score'];
						}
						$uniq_ids = substr($uniq_ids, 0, -2);
					}
					
					@mysql_free_result($query);
				}

				$sql = "SELECT * 
						FROM pm_videos 
						WHERE uniq_id IN (".$uniq_ids.")";

				$query = @mysql_query($sql);
				if ( ! $query)
				{
					return '';
				}
				while ($row = @mysql_fetch_assoc($query))
				{
					$videos[ $row['uniq_id'] ] = $row;
				}
				
				/*
				 *	Output
				 */
				$results = '';	
				$i = 1;

				foreach ($ratings as $uniq_id => $score)
				{
					$results .= '<div class="item">';
					$results .= '<a href="'. makevideolink($videos[ $uniq_id ]['uniq_id'], $videos[ $uniq_id ]['artist'], $videos[ $uniq_id ]['video_title']) .'">';
					$results .= '<img src="'. show_thumb($videos[ $uniq_id ]['uniq_id']) .'" 
								alt="'. $videos[ $uniq_id ]['video_title'] .'" 
								class="imag" width="72" height="53" align="left" /></a>';
					$results .= '<span class="';
					$results .= ($i % 2 == 0) ? 'artist_name' : 'artist_name_1';
					$results .= '">'. fewchars($videos[ $uniq_id ]['artist'], 29) .'</span>';
					$results .= '<a href="'. makevideolink($videos[ $uniq_id ]['uniq_id'], $videos[ $uniq_id ]['artist'], $videos[ $uniq_id ]['video_title']) .'" class="song_name" 
								title="'. str_replace('"', '"', $videos[ $uniq_id ]['video_title']) .'">
								'. fewchars($videos[ $uniq_id ]['video_title'], 25) .'</a>';
					$results .= '</div>';
					$i++;
				}
				return $results;
			}
			else
			{
				$sql = "SELECT * 
					FROM pm_videos 
					ORDER BY site_views DESC  
					LIMIT ".$limit;
			}
		break;
		case "chart":
			$sql = "SELECT pm_videos.*, pm_chart.uniq_id 
					FROM pm_chart JOIN pm_videos ON (pm_chart.uniq_id = pm_videos.uniq_id) 
					ORDER BY pm_chart.views DESC 
					LIMIT ".$limit;
		
		break;
	}
	
	$query = @mysql_query($sql);
	if ( ! $query)
	{
		return '';
	}
	
	$results = '';	
	$i = 1;
	while ($row = mysql_fetch_assoc($query))
	{
		$results .= '<div class="item">';
		$results .= '<a href="'. makevideolink($row['uniq_id'], $row['artist'], $row['video_title']) .'">';
		$results .= '<img src="'. show_thumb($row['uniq_id']) .'" 
					alt="'. $row['video_title'] .'" 
					class="imag" width="72" height="53" align="left" /></a>';
		$results .= '<span class="';
		$results .= ($i % 2 == 0) ? 'artist_name' : 'artist_name_1';
		$results .= '">'. fewchars($row['artist'], 90) .'</span>';
		$results .= '<a href="'. makevideolink($row['uniq_id'], $row['artist'], $row['video_title']) .'" class="song_name" 
					title="'. str_replace('"', '"', $row['video_title']) .'">
					'. fewchars($row['video_title'], 30) .'</a>';
		$results .= '</div>';
		$i++;
	}
	return $results;
}

function request_video($unique_id = '', $page = "detail", $autoplay = false)
{
	global $config;
	
	$old_src_id = 0;
	$video 		= array();
	
	if($unique_id == '')
	{
		return 0;
	}
	
	if(ctype_alnum($unique_id) === false)
	{
		return 0;
	}
	
	$unique_id = secure_sql($unique_id);
	
	$sql = "SELECT pm_videos.*, pm_videos_urls.mp4, pm_videos_urls.direct 
			FROM pm_videos 
			LEFT JOIN pm_videos_urls 
				   ON (pm_videos.uniq_id = pm_videos_urls.uniq_id) 
			WHERE pm_videos.uniq_id = '". $unique_id ."'";

	$result =  @mysql_query($sql);
	if ( ! $result)
	{
		return 0;
	}
	
	if (mysql_num_rows($result) > 0)
	{
		$video = mysql_fetch_assoc($result);
	}
	else
	{
		return 0;
	}
	
	mysql_free_result($result);
	
	$sql = "SELECT * 
			FROM pm_ratings 
			WHERE id = '". $unique_id ."'";
	$result =  @mysql_query($sql);
	if ( ! $result)
	{
		$video['rating'] = 0;
	}
	
	if (mysql_num_rows($result) > 0)
	{
		$row = mysql_fetch_assoc($result);
		mysql_free_result($result);
		
		$video['rating'] = round($row['total_value'] / $row['total_votes'], 1);
	}
	
	$video['artist'] 		= stripslashes($video['artist']);
	$video['video_title']	= stripslashes($video['video_title']);
	$video['added']			= time_since($video['addded']);
	$video['submitted']		= ($video['submitted'] == 'bot') ? 'admin' : $video['submitted'];
	
	$video_sources = fetch_video_sources();
	
	$video['video_player']	= $config['video_player'];
	
	if ($video['source_id'] == 3)
	{
		$config['video_player'] = 'jwplayer';
		$video['video_player'] = 'jwplayer';
	}
	
	switch ($config['video_player'])
	{
		case 'jwplayer':
		case 'flvplayer':
	
			if ($video_sources[ $video['source_id'] ]['flv_player_support'] == 0 || 
				$video_sources[ $video['source_id'] ]['user_choice'] == 'embed')
			{
				$video['video_player']	= 'embed';
			}

		break;
		
		case 'embed':
			
			if ($video_sources[ $video['source_id'] ]['embed_player_support'] == 0)
			{
				$video['video_player']	= 'flvplayer';
			}
			
		break;
	}
	
	if ($video['source_id'] == 0)
	{
		$sql = "SELECT * 
				FROM pm_embed_code 
				WHERE uniq_id = '". $video['uniq_id'] ."'";

		$result = mysql_query($sql);
		$row = mysql_fetch_assoc($result);
		mysql_free_result($result);
		
		$video['video_player'] = 'embed';
		$video['embed_code'] = $row['embed_code'];
	}
	
	if ($video['source_id'] == 1 || $video['source_id'] == 2)
	{
		$ext = strtolower(array_pop(explode('.', $video['url_flv'])));
		$old_src_id = $video['source_id'];
		switch ($ext)
		{
			case 'mov':
			case '3gp':
			case '3g2':
			case 'm4a':
			//case 'm4v':
				
				$video['video_player']  = 'embed';
				$video['source_id'] 	= $video_sources['quicktime']['source_id'];
				$video['url_flv'] = _URL .'/videos.php?vid='. $video['uniq_id'];
				
			break;
			
			case 'wmv':
			case 'asf':
			case 'wma':
				
				$video['video_player']  = 'embed';
				$video['source_id'] 	= $video_sources['windows media player']['source_id'];
				$video['url_flv'] = _URL .'/videos.php?vid='. $video['uniq_id'];
				//$video['url_flv'] = _VIDEOS_DIR . $video['url_flv'];
				
			break;
			
			case 'mp3':
				
				$video['video_player']  = 'embed';
				$video['source_id'] = $video_sources['mp3']['source_id'];
				$video['url_flv'] = _URL .'/videos.php?vid='. $video['uniq_id'];
			
			break;
			
			case 'mkv':
			case 'divx':
			case 'avi':
				
				$video['video_player']  = 'embed';
				$video['source_id'] 	= $video_sources['divx']['source_id'];
				$video['url_flv'] = _URL .'/videos.php?vid='. $video['uniq_id'];
				
			break;
		}
	}
	
	if ($video['source_id'] == $video_sources['mp3']['source_id'])
	{
		$video['url_flv'] = _URL .'/videos.php?vid='. $video['uniq_id'];
		$video['video_player']  = 'embed';
	}
	
	if ($video['source_id'] == 3 && $video['direct'] == '')
	{
		$video['direct'] = 'http://www.youtube.com/watch?v='. $video['yt_id'];
	}
	
	if ($video['yt_thumb'] != '')
	{
		if (strpos($video['yt_thumb'], 'http') !== false)
		{
			$video['preview_image'] = $video['yt_thumb'];
		}
		else
		{
			$video['preview_image'] = _THUMBS_DIR . $video['yt_thumb'];
		}
	}
	
	if ($video['video_player'] == 'embed')
	{
		if ($video['source_id'] > 0)
		{
			$embed_code = $video_sources[ $video['source_id'] ]['embed_code'];
		}
		else
		{
			$embed_code = $video['embed_code'];
		}
		
		if ($video['source_id'] == $video_sources['sevenload']['source_id'] && strlen($video['yt_id']) > 7)
		{
			$video['yt_id'] = substr($video['yt_id'], 0, 7);
		}
		
		$embed_code = str_replace("%%yt_id%%", $video['yt_id'], $embed_code);
		$embed_code = str_replace("%%player_bgcolor%%", _BGCOLOR, $embed_code);
		$embed_code = str_replace("%%player_timecolor%%", _TIMECOLOR, $embed_code);
		$video['url_flv'] = str_replace("&", "&", $video['url_flv']);
		$embed_code = str_replace("%%url_flv%%", $video['url_flv'], $embed_code);
		$embed_code = str_replace("%%direct%%", $video['direct'], $embed_code);
		$embed_code = str_replace("%%use_hq_vids%%", $config['use_hq_vids'], $embed_code);
		$embed_code = str_replace("%%yt_thumb%%", $video['preview_image'], $embed_code);
		
		
		if ($autoplay == true)	//	Override autoplay
		{
			$embed_code = str_replace("%%player_autoplay%%", '1', $embed_code);
		}
		else
		{
			if ($page == 'embed')
			{
				$embed_code = str_replace("%%player_autoplay%%", '0', $embed_code);
			}
			else
			{
				$embed_code = str_replace("%%player_autoplay%%", $config['player_autoplay'], $embed_code);
			}
		}
		
		if ($video['source_id'] == 17 && $video['direct'] != '')	//	trilulilu.ro
		{
			$temp = '';
			$temp = rtrim($video['direct'], "/");
			$temp = str_replace(array('http://', 'www.'), "", $temp);
			
			@preg_match('/^trilulilu\.ro\/(.*?)\/([a-zA-Z0-9]+)$/i', $temp, $matches);
			$embed_code = str_replace("%%username%%", $matches[1], $embed_code);
		}
		
		$embed_code = str_replace( array("\n", "\r", "'"), array(' ', ' ', '"'), $embed_code);
		
		switch ($page)
		{
			case 'index':
				
				$embed_code = str_replace("%%player_w%%", _PLAYER_W_INDEX, $embed_code);
				$embed_code = str_replace("%%player_h%%", _PLAYER_H_INDEX, $embed_code);
				$embed_code = str_replace("%%player_wmode%%", 'transparent', $embed_code);
				
			break;
			
			case 'favorites':
				
				$embed_code = str_replace("%%player_w%%", _PLAYER_W_FAVS, $embed_code);
				$embed_code = str_replace("%%player_h%%", _PLAYER_H_FAVS, $embed_code);
				$embed_code = str_replace("%%player_wmode%%", 'transparent', $embed_code);
				
			break;
			
			case 'embed':
				
				$embed_code = str_replace("%%player_w%%", _PLAYER_W_EMBED, $embed_code);
				$embed_code = str_replace("%%player_h%%", _PLAYER_H_EMBED, $embed_code);
				$embed_code = str_replace("%%player_wmode%%", 'window', $embed_code);
							
			break; 
			
			default:
			case 'detail':
			
				$embed_code = str_replace("%%player_w%%", _PLAYER_W, $embed_code);
				$embed_code = str_replace("%%player_h%%", _PLAYER_H, $embed_code);
				$embed_code = str_replace("%%player_wmode%%", 'window', $embed_code);
				
			break;
		}		
		
		$embed_code = str_replace("%%site_url%%", _URL, $embed_code);
		
		$video['embed_code'] = $embed_code;
		
		if ($old_src_id > 0)
		{
			$video['source_id'] = $old_src_id;
		}
	}
	
	$video['site_views_formatted'] = pm_number_format($video['site_views']);
	
	return $video;
}

function update_view_count($video_id) // @since 1.6.5
{
	$updated = false;
	$session_list = array();
	$cookie_list = array();

	$fn_encode = 'base64_encode'; //(function_exists('gzcompress')) ? 'gzcompress' : 'base64_encode';
	$fn_decode = 'base64_decode'; //(function_exists('gzuncompress')) ? 'gzuncompress' : 'base64_decode';

	if ($_COOKIE['watched_video_list'])
	{
		$cookie_list = (array) explode(',', $fn_decode($_COOKIE['watched_video_list']));
	}

	if ( ! in_array('watched', $_SESSION))
	{
		@session_register('watched');
	}
	
	$session_list = (array) unserialize($_SESSION['watched']);

	$list = array_merge($cookie_list, $session_list);

	if ( ! in_array($video_id, $list))
	{
		$sql = "UPDATE pm_videos 
				SET site_views = site_views+1, 
					lastwatched = '". time() ."' 
				WHERE id = '". $video_id ."'";
		$result = @mysql_query($sql);
		$session_list[] = $cookie_list[] = $video_id;
		$_SESSION['watched'] = serialize($session_list);
		@setcookie('watched_video_list', $fn_encode(implode(',', $cookie_list)), time() + 86400, COOKIE_PATH); // keep for 24 hours
		$updated = true;
	}
	return $updated;
}

function list_videos($how = 'added', $limit = '5') { // newest, top views, etc etc etc

	$query = mysql_query("SELECT * FROM pm_videos ORDER BY $how DESC LIMIT $limit");
	$result = '';	
	while($row = mysql_fetch_array($query)) {
		
		$results .= "
		<div class=\"item\">
		<a href=\"". makevideolink($row['uniq_id'], $row['artist'], $row['video_title']) ."\"><img src=\"".show_thumb($row['uniq_id'])."\" alt=\"".$row['video_title']."\" class=\"imag\" width=\"107\" height=\"72\" /></a>
		<a href=\"". makevideolink($row['uniq_id'], $row['artist'], $row['video_title']) ."\" class=\"song_name\">
		<span class=\"artist_name\">".fewchars($row['artist']." - ".$row['video_title'], 30)."</span>
		</a>
		<span class=\"item_views\">". pm_number_format($row['site_views']) ." views</span>
		</div>";
	
	}
	return $results;
}

function show_more($what_kind = 'related', $categories = '1', $limit = 5) 
{ 
	global $lang;
	
	$categories	= secure_sql( trim($categories) );
	$query	= '';
	$result	= '';
	$sql	= '';
	
	if($what_kind != 'related' && $what_kind != 'same_artist' && $what_kind != 'best_in_category')
		$what_kind = 'related';		//	default value
	
	switch($what_kind)
	{
		case 'related':
			$sql = "SELECT * 
					FROM pm_videos 
					WHERE category = '".$categories."' 
					ORDER BY RAND() 
					LIMIT ".$limit;
		break;
		
		case 'same_artist':
			$sql = "SELECT * 
					FROM pm_videos 
					WHERE artist='".$categories."' 
					ORDER BY added DESC 
					LIMIT ".$limit;
		break;
		
		case 'best_in_category':
			if(strstr($categories, ",")) 
			{
				$temp = explode(",", $categories);
				$categories = trim($temp[0]);
			}
			$sql = "SELECT pm_videos.*, pm_ratings.*
					FROM pm_videos 
					JOIN pm_ratings ON ( pm_videos.uniq_id = pm_ratings.id ) 
					WHERE (category LIKE '%,$categories,%' 
						   OR category LIKE '%,$categories' 
						   OR category LIKE '$categories,%' 
						   OR category LIKE '$categories')
					ORDER BY total_votes DESC , total_value DESC 
					LIMIT ".$limit;
		break;
	}

	$query = @mysql_query($sql);
	
	// backup 
	if (mysql_num_rows($query) == 0 && $what_kind == 'best_in_category')
	{
		$sql = "SELECT * 
				FROM pm_videos 
				WHERE category = '".$categories."' 
				ORDER BY site_views DESC  
				LIMIT ".$limit;
		$query = @mysql_query($sql);
	}
	
	$result = '';
	if(@mysql_num_rows($query) > 0)
	{
		while($row = mysql_fetch_array($query))
		{
			$results .= "
			<div class=\"item\">
			<a href=\"".makevideolink($row['uniq_id'], $row['artist'], $row['video_title'])."\"><img src=\"".show_thumb($row['uniq_id'])."\" alt=\"".$row['video_title']."\" class=\"imag\" width=\"116\" height=\"87\" /></a>
			<span class=\"artist_name\">".$row['artist']."</span>
			<a href=\"".makevideolink($row['uniq_id'], $row['artist'], $row['video_title'])."\" class=\"song_name\">".$row['video_title']."</a>
			</div>";
		}
		mysql_free_result($query);
	}
	else
	{
		$results .= "
			<div class=\"item\">
			".$lang['top_videos_msg1']."
			</div>";
	}
	
	return $results;
}

function get_catid($tag) {
	$query = mysql_query("SELECT id FROM pm_categories WHERE tag = '".$tag."'");
	$result = mysql_fetch_array($query);
	$id = $result['id'];
	
	return (!id) ? false : $id;
}
function get_catname($tag) {
	$q = mysql_query("SELECT * FROM pm_categories WHERE tag = '".$tag."'");
	$r = mysql_fetch_array($q);
	return $r['name'];
}


function getheaders($url,$format=0) {
   $url_info=parse_url($url);
   $port = isset($url_info['port']) ? $url_info['port'] : 80;
   $fp=fsockopen($url_info['host'], $port, $errno, $errstr, 30);
   if($fp) {
	   if(!$url_info['path']){
					 $url_info['path'] = "/";
				 }
				 if($url_info['path'] && !$url_info['host']){
					$url_info['host'] = $url_info['path'];
					$url_info['path'] = "/";
				 }
				 if( $url_info['host'][(strlen($url_info['host'])-1)] == "/" ){
					$url_info['host'][(strlen($url_info['host'])-1)] = "";
				 }
				 if(!$url_array[scheme]){
					 $url_array[scheme] = "http"; //we always use http links
					}
				 $head = "HEAD ".@$url_info['path'];
				 if( $url_info['query'] ){
					 $head .= "?".@$url_info['query'];
					}
	   $head .= " HTTP/1.0\r\nHost: ".@$url_info['host']."\r\n\r\n";
				 fputs($fp, $head);
	   while(!feof($fp)) {
		   if($header=trim(fgets($fp, 1024))) {
			   if($format == 1) {
				   $h2 = explode(':',$header);
				   // the first element is the http header type, such as HTTP/1.1 200 OK,
				   // it doesn't have a separate name, so we have to check for it.
				   if($h2[0] == $header) {
					   $headers['status'] = $header;
				   }
				   else {
					   $headers[strtolower($h2[0])] = trim($h2[1]);
				   }
			   }
			   else {
				   $headers[] = $header;
			   }
		   }
	   }
	   return $headers;
   }
   else {
	   return false;
   }
}

function make_youtube_player($y_id, $length, $width = '496', $height = '401', $auto_play = '1') {
	//	@deprecated
}

function make_youtube_player2($uniq_id, $name, $width = 496, $height = 401, $auto_play = 'false') {	
	//	@deprecated
}

function generate_embed_code($uniq_id = '')
{
	$embed_code = '';
	$backlink 	= '';
	
	if ($uniq_id == '')
		return '';
	
	$video = request_video($uniq_id, 'embed', true);

	if ( ! is_array($video))
	{
		return '';
	}
	
	$embed_code = "";
	$embed_code .= '<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"';
	$embed_code .= ' codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"';
	$embed_code .= ' width="'. _PLAYER_W_EMBED .'" height="'. _PLAYER_H_EMBED . '"';
	$embed_code .= '>';
	$embed_code .= '<param name="scale" value="noscale" />';
	$embed_code .= '<param name="allowFullScreen" value="true" />';
	$embed_code .= '<param name="allowScriptAccess" value="always" />';
	$embed_code .= '<param name="allowNetworking" value="all" />';
	$embed_code .= '<param name="bgcolor" value="#'. _BGCOLOR .'" />';
	
	if ($video['video_player'] == 'flvplayer')
	{
		// object params
		$embed_code .= '<param name="movie" value="'. _URL .'/fpembed-'. $video['uniq_id'] .'.swf" />';
 
		// embed tag
		$embed_code .= '<embed src="'. _URL .'/fpembed-'. $video['uniq_id'] .'.swf';
		$embed_code .= '" width="'. _PLAYER_W_EMBED .'" height="'. _PLAYER_H_EMBED . '"';
		$embed_code .= ' scale="noscale" bgcolor="#'. _BGCOLOR .'"';
		$embed_code .= ' type="application/x-shockwave-flash" allowFullScreen="true" allowScriptAccess="always" ';
		$embed_code .= ' allowNetworking="all" pluginspage="http://www.macromedia.com/go/getflashplayer" wmode="window">';
		$embed_code .= '</embed>';
		$embed_code .= '</object>';
	}
	else if ($video['video_player'] == 'jwplayer')
	{
		$jw_flashvars = '';
		if ($video['source_id'] == 3)
		{
			$jw_flashvars .= '&file='. urlencode($video['direct']);
			$jw_flashvars .= '&type=youtube';
		}
		else
		{
			$jw_flashvars .= '&file='. urlencode(_URL ."/videos.php?vid=". $video['uniq_id']);
			$jw_flashvars .= '&type=video';
		}
		$jw_flashvars .= '&config='. urlencode(_URL ."/jwembed.xml");
		
		// object params
		$embed_code .= '<param name="movie" value="'. _URL .'/jwplayer.swf" />';
		$embed_code .= '<param name="flashVars" value="'. $jw_flashvars .'" />';
		
		// embed tag
		$embed_code .= '<embed src="'. _URL .'/jwplayer.swf" ';
		$embed_code .= ' width="'. _PLAYER_W_EMBED .'" height="'. _PLAYER_H_EMBED . '"';
		$embed_code .= ' scale="noscale" bgcolor="'. _BGCOLOR .'"';
		$embed_code .= ' type="application/x-shockwave-flash" allowFullScreen="true" ';
		$embed_code .= ' allowScriptAccess="always" wmode="window" ';
		$embed_code .= ' flashvars="'. $jw_flashvars .'">';
		$embed_code .= '</embed>';
		$embed_code .= '</object>';
	}
	else
	{
		// overwrite
		$embed_code = $video['embed_code'];	
	}

	$backlink = '<p style="margin:3px 0px;"><a href="'. makevideolink($video['uniq_id'], $video['artist'], $video['video_title']) .'" target="_blank">';
	$backlink .= $video['artist'] .' - '. $video['video_title'];
	$backlink .= '</a></p>';
	
	$embed_code = str_replace( array("\n", "\r", "\t"), '', $embed_code);
	$embed_code .= $backlink;
	
	return $embed_code;
}

function make_voth() {

	global $config;
	
	$video_id = '';
	
	$sql = "SELECT uniq_id 
			FROM pm_videos 
			WHERE featured = '1' 
			ORDER BY rand() 
			LIMIT 1";
	$result =  @mysql_query($sql);
	
	if (@mysql_num_rows($result) == 0)
	{
		$sql = "SELECT uniq_id 
				FROM pm_videos 
				ORDER BY rand() 
				LIMIT 1";
		
		$result = @mysql_query($sql);
		$row 	= @mysql_fetch_assoc($result);
		$video_id = $row['uniq_id'];
		mysql_free_result($result);
	}
	else
	{
		$row = mysql_fetch_assoc($result);
		mysql_free_result($result);
		
		$video_id = $row['uniq_id'];
	}
	
	return $video_id;
}
function show_more_featured($mvotd = '', $limit = 3) {
	//	todo
}
function show_voth_title() {	
	//	@deprecated
}

function return_bytes($val) 
{
    $val = trim($val);
    $last = strtolower($val[strlen($val)-1]);
    switch($last) {
    	default: 
			$val = (int) $val;
		break;
        case 'g':
            $val *= 1024;
        case 'm':
            $val *= 1024;
        case 'k':
            $val *= 1024;
    }
    return $val;
}

function readable_filesize($bytes)
{
	$filesizename = array(" Bytes", " KB", " MB", " GB", " TB", " PB", " EB", " ZB", " YB");
	return $bytes ? round($bytes/pow(1024, ($i = floor(log($bytes, 1024)))), 2) . $filesizename[$i] : '0 Bytes';
}

function today() {
	$thour=date('H');
	$tmin=date('i');
	$tsec=date('s');
	$tmonth=date('n');
	$tday=date('d');
	$tyear=date('Y');
	//convert it to unix timestamp
	$today=mktime($thour,$tmin,$tsec,$tmonth,$tday,$tyear);
	return $today;
}
function ezDate($d) {
	
		global $lang;
	$ts = time() - strtotime(str_replace("-","/",$d));
	
	if($ts > 31536000) 
	{
		$val = round($ts/31536000,0);
		$span = ($val == 1) ? 'year' : 'years';
	}
	elseif($ts > 2419200)
	{
		$val = round($ts/2419200,0);
		$span = ($val == 1) ? 'month' : 'months';
	}
	elseif($ts > 604800) 
	{
		$val = round($ts/604800,0);
		$span = ($val == 1) ? 'week' : 'weeks';
	}
	elseif($ts > 86400)
	{
		$val = round($ts/86400,0);
		$span = ($val == 1) ? 'day' : 'days';
	}
	elseif($ts > 3600)
	{
		$val = round($ts/3600,0);
		$span = ($val == 1) ? 'hour' : 'hours';
	}
	elseif($ts > 60)
	{
		$val = round($ts/60,0).' '.$lang['minute'];
		$span = ($val == 1) ? 'minute' : 'minutes';
	}
	else 
	{
		$val = $ts;
		$span = ($val == 1) ? 'second' : 'seconds';
	}
	$val .= ' '.$lang[$span];

	return $val;
}
function time_since($original) {
	global $lang;
    // array of time period chunks
    $chunks = array(
        array(60 * 60 * 24 * 365 , $lang['year']),
        array(60 * 60 * 24 * 30 , $lang['month']),
        array(60 * 60 * 24 * 7, $lang['week']),
        array(60 * 60 * 24 , $lang['day']),
        array(60 * 60 , $lang['hour']),
        array(60 , $lang['minute']),
    );
    $chunks2 = array(
		$lang['years'],
		$lang['months'],
		$lang['weeks'],
		$lang['days'],
		$lang['hours'],
		$lang['minutes']
	);
	
    $today = time(); /* Current unix time  */
    $since = $today - $original;
    
    // $j saves performing the count function each time around the loop
    for ($i = 0, $j = count($chunks); $i < $j; $i++) {
       
        $seconds = $chunks[$i][0];
        $name = $chunks[$i][1];
        $type = $chunks2[$i];
        // finding the biggest chunk (if the chunk fits, break)
        if (($count = floor($since / $seconds)) != 0) {
            break;
        }
    }

    $print = ($count == 1) ? '1 '.$name : $count." ".$type;
    
    if ($i + 1 < $j) {
        // now getting the second item
        $seconds2 = $chunks[$i + 1][0];
        $name2 = $chunks[$i + 1][1];
		$type2 = $chunks2[$i + 1];
		
        // add second item if it's greater than 0
        if (($count2 = floor(($since - ($seconds * $count)) / $seconds2)) != 0) {
             $print .= ($count2 == 1) ? ', 1 '.$name2 : ", $count2 ".$type2;
        }
    }
	
    return $print;
}
function sec2min($sec) 
{
    $minutes = intval(($sec / 60) % 60); 
    $seconds = intval($sec % 60); 
	$time = $minutes." min. ".$seconds." sec.";
    return $time;
}
function is_real_email_address($email){
	$regex = "/^[a-zA-Z0-9._+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}$/i";
	if( ! @preg_match($regex, $email))
		return 0;	// not valid
	return 1;	// valid
}
function count_entries($table, $field, $field_equal) { // Usage 1 = table name 2 = field to search 3 = what to match

	if(!empty($field) && isset($field_equal)) {
	$query = @mysql_query("SELECT COUNT(*) as total FROM $table WHERE $field = '".$field_equal."'");
	} else {
	$query = @mysql_query("SELECT COUNT(*) as total FROM $table");
	}
	$result = @mysql_fetch_assoc($query);
	
	return $result['total'];
}

function send_a_mail($var_array, $destinationmail, $mailsubject, $template, $special_sender = '') {
	
	global $config;
	
	$mail = new PHPMailer();
	$mail->SetLanguage("en", "include/");
	if (_ISSMTP == 1) 
	{
		$mail->IsSMTP();
	}
	if ($config['mail_server'] != '')
	{
		$mail->Host 	= $config['mail_server'];
		$mail->SMTPAuth = true;
		$mail->Port 	= $config['mail_port'];
		$mail->Username = $config['mail_user'];
		$mail->Password = $config['mail_pass'];
		$mail->From 	= ('' != $special_sender) ? $special_sender : $config['contact_mail'];
		$mail->FromName = ('' != $special_sender) ? $special_sender : html_entity_decode(_SITENAME, ENT_QUOTES);
	}
	else if (defined('_MAIL_HOST'))
	{
		$mail->Host 	= _MAIL_HOST; 
		$mail->SMTPAuth = true;
		$mail->Port 	= _MAIL_PORT;
		$mail->Username = _MAIL_USER;
		$mail->Password = _MAIL_PASS;
		$mail->FromName = _MAIL_FROM_NAME;
		$mail->From 	= ('' != $special_sender) ? $special_sender : _MAIL_FROM;
	}
	$mail->CharSet = "UTF-8";
	$mail->AddAddress($destinationmail); 
	$mail->IsHTML(true); 
	$mail->Subject = $mailsubject;
	
	// insert template 
	$filename = $template;
	$fd = fopen ($filename, "r");
	$mailcontent = fread ($fd, filesize ($filename));
	
	foreach ($var_array as $key=>$value)
	{
		$mailcontent = str_replace("%%$value[0]%%", $value[1],$mailcontent );
	}
	$mailcontent = stripslashes($mailcontent);
	fclose ($fd);
							
	$mail->Body=$mailcontent;
	if ( ! $mail->Send())
	{
		$result = $mail->ErrorInfo;
	}
	else 
	{
		$result = TRUE;
	}

	return $result;
}
// ** FOR REGISTRATION ** //
function prepare_for_mysql($value){
	return htmlspecialchars(magicSlashes(trim($value)));
}

function validate_email($email) {
	
	global $conn_id;
	
	if( empty($conn_id) ) {
		$conn_id = db_connect();
	}
	$rows = 0;
	if( !is_real_email_address($email))
		return 1;	// invalid characters;

	$sql = "SELECT email FROM pm_users WHERE email = '" . str_replace("\'", "''", $email) . "'";
	$result = @mysql_query($sql, $conn_id);
	if(!$result) { 
		return false;
	}
	$rows = @mysql_num_rows($result); 
	@mysql_free_result($result);
	if($rows > 0) 
		return 2;	// already in use
return false;
}
 
function check_username($username) {
	/*
	  this function checks the validity of $username. 
	  	1.	checks if the string is at least 3 characters long
	  	2.	checks if it is alpha-numeric
	  	3.	checks if it already exists in DB
	 -> Returns False if the $username is OK
	*/  
	global $conn_id;
	if( empty($conn_id) ) {
		$conn_id =  db_connect();
	}
	$username = magicSlashes(trim($username));
	$rows = 0;
	if(strlen(stripslashes($username)) < 3)
	 	return 1; // too short or empty
		
	$alpha_num = str_replace(" ", "", $username);
	if( !ctype_alnum($alpha_num))
		return 2; // invalid characters -> non-alpha-numeric
	
	$sql = "SELECT username FROM pm_users WHERE LOWER(username) = '".htmlspecialchars(strtolower($username))."'";
	$result = @mysql_query($sql, $conn_id);
	if(!$result) { 
	  	return false;
	}
	$rows = @mysql_num_rows($result);
	@mysql_free_result($result);
	if($rows > 0)
		return 3; // already in use
return false;	
}
// ** END FOR REGISTRATION ** //
function word_wrap_pass($message)
{
	$wrapAt = 45;
	$tempText = '';
	$finalText = '';
	$curCount = $tempCount = 0;
	$longestAmp = 9;
	$inTag = false;
	$ampText = '';
	$len = strlen($message);

	for ($num=0;$num<$len;$num++)
	{
		$curChar = $message{$num};

		if ($curChar == '<')
		{
			for ($snum=0;$snum<strlen($ampText);$snum++)
			{
				addWrap($ampText{$snum},$ampText{$snum+1},$wrapAt,$finalText,$tempText,$curCount,$tempCount);
			}
			$ampText = '';
			$tempText .= '<';
			$inTag = true;
		}
		elseif ($inTag && $curChar == '>')
		{
			$tempText .= '>';
			$inTag = false;
		}
		elseif ($inTag)
		{
			$tempText .= $curChar;
		}
		elseif ($curChar == '&')
		{
			for ($snum=0;$snum<strlen($ampText);$snum++)
			{
				addWrap($ampText{$snum},$ampText{$snum+1},$wrapAt,$finalText,$tempText,$curCount,$tempCount);
			}
			$ampText = '&';
		}
		elseif (strlen($ampText) < $longestAmp && $curChar == ';' && function_exists('html_entity_decode') &&
		       (strlen(html_entity_decode("$ampText;")) == 1 || preg_match('/^&#[0-9]+$/',$ampText)))
		{
			addWrap($ampText.';',$message{$num+1},$wrapAt,$finalText,$tempText,$curCount,$tempCount);
			$ampText = '';
		}
		elseif (strlen($ampText) >= $longestAmp || $curChar == ';')
		{
			for ($snum=0;$snum<strlen($ampText);$snum++)
			{
				addWrap($ampText{$snum},$ampText{$snum+1},$wrapAt,$finalText,$tempText,$curCount,$tempCount);
			}
			addWrap($curChar,$message{$num+1},$wrapAt,$finalText,$tempText,$curCount,$tempCount);
			$ampText = '';
		}
		elseif (strlen($ampText) != 0 && strlen($ampText) < $longestAmp)
		{
			$ampText .= $curChar;
		}
		else
		{
			addWrap($curChar,$message{$num+1},$wrapAt,$finalText,$tempText,$curCount,$tempCount);
		}
	}

	return $finalText . $tempText;
}

function addWrap($curChar,$nextChar,$maxChars,&$finalText,&$tempText,&$curCount,&$tempCount) {
	$wrapProhibitedChars = "([{!;,\\/:?}])";

	if ($curChar == ' ' || $curChar == "\n")
	{
		$finalText .= $tempText . $curChar;
		$tempText = '';
		$curCount = 0;
		$curChar = '';
	}
	elseif ($curCount >= $maxChars)
	{
		$finalText .= $tempText . ' ';
		$tempText = '';
		$curCount = 1;
	}
	else
	{
		$tempText .= $curChar;
		$curCount++;
	}

	// the following code takes care of (unicode) characters prohibiting non-mandatory breaks directly before them.

	// $curChar isn't a " " or "\n"
	if ($tempText != '' && $curChar != '')
	{
		$tempCount++;
	}
	// $curChar is " " or "\n", but $nextChar prohibits wrapping.
	elseif ( ($curCount == 1 && strstr($wrapProhibitedChars,$curChar) !== false) || 
	         ($curCount == 0 && $nextChar != '' && $nextChar != ' ' && $nextChar != "\n" && strstr($wrapProhibitedChars,$nextChar) !== false))
	{
		$tempCount++;
	}
	// $curChar and $nextChar aren't both either " " or "\n"
	elseif (!($curCount == 0 && ($nextChar == ' ' || $nextChar == "\n")))
	{
		$tempCount = 0;
	}

	if ($tempCount >= $maxChars && $tempText == '')
	{
		$finalText .= ' ';
		$tempCount = 1;
		$curCount = 2;
	}

	if ($tempText == ''  && $curCount > 0)
	{
		$finalText .= $curChar;
	}
}

function search_bad_words($input) {
	
	$filtered_input = $input;
	
	$phrases = explode("\r\n", file_get_contents('blacklist.txt'));
	
	if (count($phrases) > 0)
	{
		foreach ($phrases as $k => $phrase)
		{
			$filtered_input = str_ireplace($phrase, '', $filtered_input);
		}
	}

	return $filtered_input;
}
	

function RemoveCurseWords($original) 
{
	$patterns = explode("\r\n",file_get_contents("censor_words.txt"));
	$finalremove = $original;
	$piece_front = "";
	$piece_back = "";
	$piece_replace = "***";

    for ($x = 0; $x < count($patterns); $x++) 
	{
    	$safety=0; 
        while (@strstr(strtolower($finalremove), strtolower($patterns[$x]))) 
		{
	        $safety = $safety + 1;
	        if ($safety >= 100) { break; }
	
	        $occ = strpos(strtolower($finalremove), strtolower($patterns[$x]));
	        $piece_front = substr($finalremove, 0, $occ);
	        $piece_back = substr($finalremove, ($occ + strlen($patterns[$x])));
	        $finalremove = $piece_front . $piece_replace . $piece_back;
        }
    }
	return $finalremove;
}
$allowedTags = '<b><i><br>';
$stripAttrib = 'javascript:|onclick|ondblclick|onmousedown|onmouseup|onmouseover|'.
				'onblur|onchange|onfocus|onload|onsubmit|style|font|'.
               'onmousemove|onmouseout|onkeypress|onkeydown|onkeyup|object|object';
function removeEvilAttributes($tagSource)
{
   global $stripAttrib;
   return stripslashes(preg_replace("/$stripAttrib/i", 'forbidden', $tagSource));
}
function removeEvilTags($source)
{
   global $allowedTags;
   $source = RemoveCurseWords(strip_tags($source, $allowedTags));
   return preg_replace('/<(.*?)>/ie', "'<'.removeEvilAttributes('\\1').'>'", $source);
}

function show_comments($vid, $user_power, $page = 1) {

	global $template_f, $config, $lang;
	
	$sql	= '';
	$row 	= array();
	$from	= 0;
	$limit	= 10;
	$output	= '';
	$total_comments = 0;
	$comments  = array();
	$adjacents = 1;
	
	$vid 	= secure_sql($vid);
	$page = (int) $page;
	
	if (empty($page))
	{
		$page = 1;
	}
	
	$limit = $config['comments_page'];	//	comments per page
	$from  = $page * $limit - ($limit);
	
	$sql  = "SELECT COUNT(*) as total_comments 
			FROM pm_comments 
			WHERE uniq_id = '". $vid ."' 
			  AND approved = '1'";
	
	$result = mysql_query($sql);
	if ( ! $result)
	{
		return 'empty';
	}
	$row = mysql_fetch_assoc($result);
	$total_comments = $row['total_comments'];
	
	mysql_free_result($result);
	
	$sql = "SELECT * 
			FROM pm_comments 
			WHERE uniq_id = '". $vid ."' 
			  AND approved = '1' 
			ORDER BY added DESC 
			LIMIT ". $from .", ". $limit;
	
	$result = mysql_query($sql);
	if ( ! $result)
	{
		return 'empty';
	}
	
	if (mysql_num_rows($result) > 0) 
	{
		while ($row = mysql_fetch_array($result)) 
		{
			$comments[] = $row;
		}
		mysql_free_result($result);
		
		$inc_id = 0;
		foreach ($comments as $key => $comment)
		{
			$i 	  = 1;
			$k 	  = 1;
			$user 	= array();
			$banned = array();
			$avatar_url = '';
			
			if ($comment['user_id'] == 0)
			{
				$avatar_url = _URL .'/'. _UPFOLDER .'/avatars/no_avatar.gif';
			}
			else
			{
				$sql = "SELECT id, gender, avatar, power  
						FROM pm_users 
						WHERE username = '".secure_sql($comment['username'])."'";
				$result = @mysql_query($sql);
				if ( ! $result)
				{
					$avatar_url = _URL .'/'. _UPFOLDER .'/avatars/no_avatar.gif';
				}
				else
				{
					$user = mysql_fetch_assoc($result);
					mysql_free_result($result);
					
					if (empty($user['avatar']) || $user['avatar'] == 'no_avatar.gif')
					{
						$avatar_url = _URL .'/'. _UPFOLDER .'/avatars/'. $user['gender'] .'.gif';
					}
					else
					{
						$avatar_url = _URL .'/'. _UPFOLDER .'/avatars/'. $user['avatar'];
					}
				}
				
				$banned = banlist($comment['user_id']);
				
			}	//	end if comment[user_id] == 0
			
			
			$inc_id++;
			$output .= '<li id="comment-'. $inc_id .'">';
			$output .= "\r\n";
			$output	.= '<div class="comment-head">';
			$output .= '<img src="'. $avatar_url .'" alt="'. $comment['username'] .'" border="0" width="48" height="48" class="avatar_img" />';
			$output .= "\r\n";
			
			if($comment['user_id'] == 0)
			{
				$output .= '<div class="comment-author">'. $comment['username'] .'</div>';
			}
			else
			{
				$output .= '<div class="comment-author"><a href="'. _URL .'/profile.'. _FEXT .'?u='. $comment['username'] .'"';
				$output .= 'rel="nofollow">';
				
				if($banned['user_id'] == $comment['user_id'])
				{
					$output .= '<del>'. $comment['username'] .'</del>';
				}
				else
				{
					$output .= $comment['username'];
				}
				
				$output .= '</a></div>';
			}
			$output .= '<div class="comment-date">'. time_since($comment['added']) .' '. $lang['ago'] .'</div>';
			$output .= "</div><br />\r\n";
			$output .= $comment['comment'];
			
			$mod_can = mod_can();
			
			if($user_power == U_ADMIN || ($user_power == U_MODERATOR && $mod_can['manage_comments']))
			{
				$output .= '<div class="row_actions">';
				
				$output .= '<span id="users-'. $inc_id .'">';
				
				if($comment['user_id'] > 0 && $user['power'] != U_ADMIN && $user_power != $comment['user_id'])
				{
					if($user_power == U_MODERATOR && !$mod_can['manage_users'])
					{
						$output .= '';
					}
					else if($banned['user_id'] == $comment['user_id'])
					{
						$output .= '<a href="#" onclick="ajax_request(\'users\', \'&do=allow&uid='. $comment['user_id'] .'\', \'#users-'. $inc_id .'\', \'html\', true); return false;"';
						$output .= ' class="ban_user" title="Remove user ban">Remove ban</a>';
					}
					else
					{
						$output .= '<a href="#" onclick="ajax_request(\'users\', \'&do=ban&uid='. $comment['user_id'] .'\', \'#users-'. $inc_id .'\', \'\', true); return false;"';
						$output .= ' class="ban_user" title="Ban this user">Ban user</a>';
					}
				}
				else
				{
					$output .= '<span class="ipaddress">IP: '. $comment['user_ip'] .'</span>'; 
				}
				$output .= '</span>'; //	end span id="users-N"
				$output .= ' ';
				
				$output .= '<a href="#" onclick="onpage_delete_comment(\''. $comment['id'] .'\', ';
				$output .= '\''. $comment['uniq_id'] .'\', \'#comment-'. $inc_id .'\'); return false;" ';
				$output .= ' class="delete_comment" id="comment-'. $inc_id .'" title="Delete this comment">Delete</a>';
				$output .= '</div>';	
				
			}
			
			$output .= "\r\n";
			$output .= '</li>';
			$output .= "\r\n";
		}	//	end foreach
		
		/*	Pagination START	*/
		if ($total_comments > $limit)
		{
			
			$output .= '<br />';

			$pagination = '';
			$counter 	= 0;
			$prev 	 	= $page - 1;
			$next 	 	= $page + 1;
			$lastpage	= ceil($total_comments / $limit);
			$lpm1 	 	= $lastpage - 1;
			
			$pagination .= '<div class="pagination">';
			$pagination .= "\r\n";
			//	Previous button
			if ($page > 1)
			{
				$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'&do=show_comments&page='. $prev .'&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">« '. $lang['prev'] .'</a>';
			}
			else
			{
				$pagination .= '<span class="disabled">« '. $lang['prev'] .'</span>';
			}
			
			if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
			{	
				for ($counter = 1; $counter <= $lastpage; $counter++)
				{
					if ($counter == $page)
					{
						$pagination .= '<span class="current">'. $counter .'</span>';
					}
					else
					{
						$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page='. $counter .'&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">'. $counter .'</a>';
					}
				}

			}
			elseif($lastpage >= 7 + ($adjacents * 2))
			{
				//close to beginning; only hide later pages
				if($page < 2 + ($adjacents * 3))		
				{
					for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
					{
						if ($counter == $page)
						{
							$pagination .= '<span class="current">'. $counter .'</span>';
						}
						else
						{
							$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page='. $counter .'&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">'. $counter .'</a>';
						}
					}
					$pagination .= '...';
					$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page='. $lpm1 .'&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">'. $lpm1 .'</a>';
					$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page='. $lastpage .'&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">'. $lastpage .'</a>';
				}

				// in middle; hide some front and some back
				elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
				{
					$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page=1&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">1</a>';
					$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page=2&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">2</a>';
					$pagination .= '...';
					for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
					{
						if ($counter == $page)
						{
							$pagination .= '<span class="current">'. $counter .'</span>';
						}
						else
						{
							$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page='. $counter .'&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">'. $counter .'</a>';
						}
					}
					$pagination .= '...';
					$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page='. $lpm1 .'&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">'. $lpm1 .'</a>';
					$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page='. $lastpage .'&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">'. $lastpage .'</a>';
				}
				//close to end; only hide early pages
				else
				{
					$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page=1&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">1</a>';
					$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page=2&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">2</a>';
					$pagination .= '...';
					for ($counter = $lastpage - (1 + ($adjacents * 3)); $counter <= $lastpage; $counter++)
					{
						if ($counter == $page)
						{
							$pagination .= '<span class="current">'. $counter .'</span>';
						}
						else
						{
							$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page='. $counter .'&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">'. $counter .'</a>';
						}
					}
				}
			}

			//next button
			if ($page < $counter - 1) 
			{
				$pagination .= '<a href="#" onclick="ajax_request(\'comments\', \'do=show_comments&page='. $next .'&vid='. $comment['uniq_id'] .'\', \'#comments_ol\', \'html\', true); return false;">'. $lang['next'] .' »</a>';
			}
			else
			{
				$pagination .= '<span class="disabled">'. $lang['next'] .' »</span>';
			}
			$pagination .= '</div>';
			
			$output .= "\r\n";
			$output .= $pagination;
			$output .= "\r\n";
		}
		/*	Pagination END	*/
	} 
	else
	{
		$output = 'empty';
	}
	
	return $output;
}

function countryid2name($id) {
	$query = mysql_query("SELECT * FROM pm_countries WHERE countryid = '".$id."'");
	$result = mysql_fetch_array($query);
	return $result['country'];
}
function make_cats($cat_ids) {

	$cat = explode(",", $cat_ids);
	$links = '';
	foreach ($cat as $c) {
		if(!empty($c)) {
		$q = mysql_query("SELECT * FROM pm_categories WHERE id = '".$c."'");
		$r = mysql_fetch_array($q);
		
		if(_SEOMOD == 1)
		$links .= "<a href=\""._URL."/browse-".$r['tag']."-videos-1-date.html\">".$r['name']."</a> ";
		else
		$links .= "<a href=\""._URL."/category.php?cat=".$r['tag']."\">".$r['name']."</a> ";
		
		}
	}
	return $links;
}

function show_thumb($uniq_id, $t_id = 1)
{
	if(_THUMB_FROM == 1) 	//	Outsource
	{
		$q = mysql_query("SELECT yt_id, yt_thumb, source_id FROM pm_videos WHERE uniq_id = '".$uniq_id."'");
		$r = mysql_fetch_array($q);
		
		if(($r['source_id'] == 1) || ($r['yt_thumb'] != '' && strstr($r['yt_thumb'], "http://") === false))	//	thumbnail is hosted locally
		{
			if($r['source_id'] == 1 && $r['yt_thumb'] == '')
			{
				//	default thumbnail
				$thumb_url = _NOTHUMB;
			}
			elseif($r['yt_thumb'] != '' && strstr($r['yt_thumb'], "http://") === false)
			{
				if(!file_exists(_THUMBS_DIR_PATH . $r['yt_thumb']))
				{
					$thumb_url = _NOTHUMB;
				}
				else
				{
					$thumb_url = _THUMBS_DIR . $r['yt_thumb'];
				}
			}
			else
			{
				$thumb_url = $r['yt_thumb'];
			}
		}
		else
		{
			if($r['yt_thumb'] == '')
			{
				if($r['source_id'] == 3)
				{
					//	fix for videos imported in older versions using remote thumbails
					$thumb_url =  _YOUTUBETHUB."/".$r['yt_id']."/default.jpg";
				}
				else
				{
					$thumb_url = _NOTHUMB;
				}
			}
			else
			{
				$thumb_url = $r['yt_thumb'];
			}
		}
	}
	else 	//	Localhost
	{
		if(!file_exists(_THUMBS_DIR_PATH . $uniq_id . "-" . $t_id . ".jpg"))
		{
			$thumb_url = _NOTHUMB;
		}
		else
		{
			$thumb_url = _THUMBS_DIR . $uniq_id . "-" . $t_id . ".jpg";
		}
	}
	return $thumb_url;
}

function check_template($name) {
	// CHECK IF FOLDER EXISTS
	$template_dir = ABSPATH . "/templates/".$name;
	
	if(is_dir($template_dir)) {
	// CHECK FOR FILES
		$index = $template_dir."/index.tpl";
		$detail = $template_dir."/detail.tpl";
		$browse = $template_dir."/browse.tpl";
		if(file_exists($index) && file_exists($detail) && file_exists($browse)) {
		return TRUE;		
		}
		else { 
		return FALSE;
		}
	} elseif(!is_dir($template_dir)) {
	return FALSE;
	}	
}
function dropdown_templates() {

$path = ABSPATH ."/templates";
$dh = opendir($path);
$form_file = '';
while (($file = readdir($dh)) !== false) {
    if($file != "." && $file != "..") {
		
		if(check_template($file)) {
		$form_file .= "<option value=\"".$file."\">".$file."</option> \n";
		}
    }
}
closedir($dh);
return $form_file;
}
function secure_sql( $value )
	{
	if( get_magic_quotes_gpc() )
	{
	$value = stripslashes( $value );
	}
	if( function_exists( "mysql_real_escape_string" ) )
	{
	$value = mysql_real_escape_string( $value );
	}
	else
	{
	$value = addslashes( $value );
	}
	return $value;
}

function specialchars( $text, $and_quotes = 0 ) {

   if( $and_quotes == 1 || $and_quotes === true )
   {
      $text = str_replace('"', '"', $text);
      $text = str_replace("'", '&#039', $text);
   }
   $text = str_replace('<', '<', $text);
   $text = str_replace('>', '>', $text);
   return $text;
}

function makevideolink($uniq_id, $artist = '', $video_title = '')
{
	$r = array();
	
	if (_SEOMOD == 1) 
	{
		if ('' != $artist && '' != $video_title)
		{
			$r['artist'] = $artist;
			$r['video_title'] = $video_title;
		}
		else
		{
			$query 	= @mysql_query("SELECT artist, video_title FROM pm_videos WHERE uniq_id = '".$uniq_id."'");
			$r 		= mysql_fetch_array($query);
			mysql_free_result($query);
		}
		$artist = sanitize_title($r['artist']);
		//$artist = safename($artist); // @since 1.6.5
		$song 	= sanitize_title($r['video_title']);
		//$song 	= safename($song);	// @since 1.6.5
		
		$return = _URL .'/'. $artist .'/'. $song .'-video_'. $uniq_id .'.html';
	} 
	else 
	{
		$return = _URL .'/musicvideo.php?vid='.$uniq_id;
	}
	
	return $return;
}

// GET THE DOMAIN NAME
function get_dn($url) { 
	preg_match('@^(?:http://)?([^/]+)@i', $url, $matches);
	$host = $matches[1];
	// get last two segments of host name
	preg_match('/[^.]+\.[^.]+$/', $host, $matches);
	return $matches[0];
}

function retrieve_vid($url) {
	// establish the source: Youtube
	$source = get_dn($url);
	
	if($source == 'youtube.com') {
		$url = parse_url($url);
		$url = $url['query'];
		$url = explode('&', $url, 2);
		$vid = substr($url[0], 2);
	}

	return $vid;
}
function islive($timestamp) {
	$second = 1;
	$minute = $second*60;
	$time = time();
	$difference = $time-$timestamp;
	$mcount = 0;
	for($mcount = 0; $difference>$minute;
	$mcount++) {
	$difference = $difference - $minute;
	}
	if($mcount >= 3) 
	return TRUE;
	else
	return FALSE;
}
function videosplaying($limit = 4) { // SHOW THE CURRENTLY PLAYING VIDEOS
	$time_diff = time();
	$time_diff -= (3 * 60);
	$query = mysql_query("SELECT * FROM pm_videos WHERE lastwatched > ".$time_diff." ORDER BY lastwatched DESC LIMIT $limit");
	$countresults = mysql_num_rows($query);
	$results = '';
	while($row = mysql_fetch_array($query)) {
		$results .= "
		<li class=\"item\">
		<a href=\"".makevideolink($row['uniq_id'], $row['artist']. $row['video_title'])."\"><img src=\"".show_thumb($row['uniq_id'])."\" alt=\"".$row['video_title']."\" class=\"imag\" width=\"85\" height=\"63\" border=\"1\" /></a>
		<br />
		<a href=\"".makevideolink($row['uniq_id'], $row['artist']. $row['video_title'])."\" title=\"".$row['video_title']."\">".fewchars($row['video_title'], 20)."</a>
		</li>";
	}
	if($countresults == 1)
	{
		$results .= "<li></li>";
	}
	if($countresults >= 1)
	return $results;
	else
	return 0;
}
function generate_smart_pagination($page = 1, $totalitems, $limit = 15, $adjacents = 1, $targetpage = "/", $pagestring = "&page=", $seomod = 0)
{
	global $lang;
	
	if(!$adjacents) $adjacents = 1;
	if(!$limit) $limit = 15;
	if(!$page) $page = 1;
	if(!$targetpage) $targetpage = "/";
	
	$prev = $page - 1;
	$next = $page + 1;
	$lastpage = ceil($totalitems / $limit);
	$lpm1 = $lastpage - 1;
	//	this function will replace the existing "page=N" with it's own page number when building the links
	//	so let's check if there is any "page=" in the original $pagestring. If non found, add one to help things out
	if($seomod == 1)
	{
		$pagestring1 = preg_replace('/browse-(.*?)-videos-([0-9]*)-/', 'browse-$1-videos-1-', $targetpage);
		$pagestring2 = preg_replace('/browse-(.*?)-videos-([0-9]*)-/', 'browse-$1-videos-2-', $targetpage);
		$pagestringlpm1 = preg_replace('/browse-(.*?)-videos-([0-9]*)-/', 'browse-$1-videos-'.$lpm1.'-', $targetpage);
		$pagestringlast = preg_replace('/browse-(.*?)-videos-([0-9]*)-/', 'browse-$1-videos-'.$lastpage.'-', $targetpage);	
	}
	else
	{
		if(strpos($pagestring, 'page=', 0) === FALSE)
			$pagestring .= "&page=";
		
		$pagestring1 = preg_replace('/page=([0-9]*)/', 'page=1', $pagestring);
		$pagestring2 = preg_replace('/page=([0-9]*)/', 'page=2', $pagestring);
		$pagestringlpm1 = preg_replace('/page=([0-9]*)/', 'page='.$lpm1, $pagestring);
		$pagestringlast = preg_replace('/page=([0-9]*)/', 'page='.$lastpage, $pagestring);
	}	
		$pagination = "";
		if($lastpage > 1)
		{	
			$pagination .= "<div class=\"pagination\"";
			if($margin || $padding)
			{
				$pagination .= " style=\"";
				if($margin)
					$pagination .= "margin: $margin;";
				if($padding)
					$pagination .= "padding: $padding;";
				$pagination .= "\"";
			}
			$pagination .= ">";
	
			//previous button
			if ($page > 1)
			{
				if($seomod == 1)
				{
					$url_query = preg_replace('/browse-(.*?)-videos-([0-9]*)-/', 'browse-$1-videos-'.$prev.'-', $targetpage);
					$pagination .= "<a href=\"$url_query\">« ".$lang['prev']."</a>";
				}
				else
				{
					$url_query = preg_

eddyy93 · 4 Януари 2012

OFFTOPIC :

Първо ако relaxcho пише в тази тема, – НЕДЕЙ ГО СЛУШАЙ

, маняк е на тема Internet Protocol address.

--------------------------

ПО ТЕМАТА:

Ето как с бисквитка да го направиш:
http://web-tourist.net/login/login/view.php?st=3409

А ако искаш вместо бисквитка да ползваш сесия ето:

PHP:

<?php
session_start();

mysql_connect('localhost', 'ИМЕ КЪМ БАЗА ДАННИ', 'ПАРОЛА КЪМ БАЗА ДАННИ');
mysql_select_db('cu');


$time=time();

if($_SESSION['sesscheck_t']!=true) {

$_SESSION['sesscheck']=time();

$_SESSION['sesscheck_t']=true;

$ip=htmlspecialchars(addslashes($_SERVER['REMOTE_ADDR']));
$hostname=htmlspecialchars(addslashes(gethostname()));

mysql_query("INSERT INTO `cu`(`ip`,`hostname`,`vreme`) VALUES ('$ip','$hostname', '$time')");



}

if (time() - $_SESSION['sesscheck'] > 300) {
    
    $_SESSION['sesscheck_t']=false;
    
}

$time_check=$time-300; //Трябва да е равно на времето зададено на сесията
mysql_query("DELETE FROM `cu` WHERE vreme<$time_check");


?>




<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
</head>
<body>


<?php
//Да приемем, че това е админ панела.

$online_row=mysql_query("SELECT * FROM `cu` ");

$online_obshto=mysql_num_rows($online_row);
echo "В момента има: ".$online_obshto." гост в сайта<br><br><br>";

while($online=mysql_fetch_assoc($online_row)){

echo "<table border='1'>";
echo "<tr><td>".$online['ip']."</td>";
echo "<td>".stripslashes($online['hostname'])."</td>";
echo "</tr></table>";

}
?>

</body>
</html>

relax4o · 4 Януари 2012

Следващия път ще кажа да ти дадат на теб точката, че като гледам не ти хареса, че в другата тема дадоха на мен точката.

При положение, че се ползва база данни, не виждам какъв е смисъла да се ползват потребителски данни. Някой ще си смени бисквитката от 300 секунди на цяла година и какво ? Този потребител няма да излезе цяла година.

eddyy93 · 4 Януари 2012

Е, може да е смени(незнам как), ама той се трие от базата данни, така или иначе. Ако не иска бисквитка може и сесия да си ползва. А пък в миналата тема писах недостатъка на IP-то с базата данни(предполагам си го погледнал). Ама все пак 1200 заявки за 30 секунди са си доста. Оделно и неточноста с работа, с IP.

relax4o · 4 Януари 2012

Добре, ако ти се говори на тази тема, ще те затапя, както желаеш, но на лично. Не мисля да спамя темата на човека.
А това за заявките е просто е смешно. 1200 заявки за 30 секунди са просто едно нищо.

eddyy93 · 4 Януари 2012

Безмислено е за такова нещо толкова заявки. Който, каквото иска да ползва.

Колкото до точката не ми е това проблема. Ами по-скоро, че онзи автор не ми прочете сигурно един ред от кода. Поне според него да беше казал кое е положително кое е отрицателно в моя код спрямо твоя.

Как ще стане статистиката правилно?

qnkov

Registered

eddyy93

Registered

relax4o

Registered

eddyy93

Registered

relax4o

Registered

eddyy93

Registered