<?php
/* THIS FILE CONTAINS GENERAL FUNCTIONS WHERE ARE VERY INFREQUENTLY MODIFIED. PLEASE AVOID MODIFYING THIS FILE. */


function updateRelatedVideos($id) { 
	$result = mysql_query("SELECT * FROM content WHERE record_num = '$id'");
	$row = mysql_fetch_assoc($result);
	unset($relatedVideos); 
	$string = mysql_real_escape_string("$row[title] $row[keywords]");
	$rresult = mysql_query("SELECT content.*, (MATCH (title,keywords) AGAINST ('$string')) as score FROM content WHERE enabled = 1 AND record_num != '$row[record_num]' AND MATCH (title,keywords) AGAINST ('$string'  IN BOOLEAN MODE) HAVING score > 0  ORDER BY score DESC LIMIT 0,50");	        
	while($rrow = mysql_fetch_assoc($rresult)) {
		$relatedVideos[] = $rrow[record_num];	
	}
	$related = implode(",",$relatedVideos); 
	mysql_query("UPDATE content SET related = '$related' WHERE record_num = '$row[record_num]'");
}


function getVideoLink($row) { 
	global $basehttp; 
	$bad = array('%','?','!',' ','&','*','$','#','@','\'','√ß','‰ß','√©','‰©','√®','‰®','√™','‰™','√´','‰´','√?','‰?','√?','‰?','√Æ','‰Æ','√Ø','‰Ø','√¨','√?','‰?','√≤','‰≤','√¥','‰¥','√∂','‰∂','√µ','√≥','√∏','‰µ','‰≥','‰∏','√?','‰?','√?','‰?','√ ','‰ ','√¢','‰¢','√§','‰§','√•','‰•','√?','‰?','√?','‰?','√π','√ª','√º','‰º','√?','√?','‰π','‰ª','‰º','‰º','‰?','‰?','√≤','√±','Á','Á','È','È','Ë','Ë','Í','Í','Î','Î',' ',' ','À','À','Ó','Ó','Ô','Ô','Ï','Œ','Œ','Ú','Ú','Ù','Ù','ˆ','ˆ','ı','Û','¯','ı','Û','¯','‘','‘','÷','÷','‡','‡','‚','‚','‰','‰','Â','Â','¬','¬','ƒ','ƒ','u','˚','¸','¸','€','‹','u','˚','¸','¸','€','‹','Ò','Ò','.','…','√?','a?',',');
	$good = array('','','','-','','','','','','','c','c','e','e','e','e','e','e','e','e','e','e','e','e','i','i','i','i','i','i','i','o','o','o','o','o','o','o','o','o','o','o','o','o','o','o','o','a','a','a','a','a','a','a','a','a','a','a','a','u','u','u','u','u','u','u','u','u','u','u','u','n','n" ,"c','c','e','e','e','e','e','e','e','e','e','e','e','e','i','i','i','i','i','i','i','o','o','o','o','o','o','o','o','o','o','o','o','o','o','o','o','a','a','a','a','a','a','a','a','a','a','a','a','u','u','u','u','u','u','u','u','u','u','u','u','n','n','','e','e','e','');
	return "$basehttp/videos/".strtolower(str_replace($bad,$good,$row['title']))."-".$row['record_num'].".html"; 
}

function generateUrl($type,$name,$content_id){
    global $basehttp;
    
    switch($type){
        case 'video':
            return $basehttp.'/'.$type.'/'.clearString($name).'-'.$content_id.'.html';
            break;
        case 'galleries':
            return $basehttp.'/'.$type.'/'.clearString($name).'-'.$content_id.'.html';
            break;	
        case 'channel':
            return $basehttp.'/channels/'.$content_id.'/'.clearString($name).'/page1.html';
            break;	
        case 'pornstar':
            return $basehttp.'/pornstars/'.clearString($name).'-'.$content_id.'.html';
            break;
        case 'user':
            return $basehttp.'/'.$type.'/'.clearString($name).'-'.$content_id.'/';
            break;
        default:
            return $basehttp.'/'.$type.'/'.clearString($name).'-'.$content_id.'.html';
            break;
    }    
}

function validateUser($username,$password){
    $validate = dbQuery("SELECT * FROM users WHERE username = '$username' AND password = MD5(CONCAT('$password',users.salt))",false);
    
    if(is_array($validate)){
        return $validate;
    }else{
        return false;
    }
}


//check if device is mobile
if($enableMobile) {
	if(detectMobile()) {
		$isMobile = true;
	}
}



//redirect mobile phones away from site
if($redirect_mobile) {
	if(detectMobile()) {
		header("Location: $redirect_mobile");
		exit();
	}
}

//detects mobile devices. You can edit the string that matches them here
function detectMobile() {
	$user_agent = $_SERVER['HTTP_USER_AGENT'];
	if($_GET[mobileDevice]) {
		return true; 
	}
	switch(true) {
		case (stripos($user_agent,'android'));  
     		$isMobile = true;
	    break; 
		case (stripos($user_agent,'iphone')||stripos($user_agent,'ipod'));
			$isMobile = true; 
		break;
		case (stripos($user_agent,'opera mini')); 
     		$isMobile = true; 
 	    break; 
		case (stripos($user_agent,'blackberry'));
			$isMobile = true;
		break;
		case (preg_match('/(mini 9.5|vx1000|lge |m800|e860|u940|ux840|compal|wireless| mobi|ahong|lg380|lgku|lgu900|lg210|lg47|lg920|lg840|lg370|sam-r|mg50|s55|g83|t66|vx400|mk99|d615|d763|el370|sl900|mp500|samu3|samu4|vx10|xda_|samu5|samu6|samu7|samu9|a615|b832|m881|s920|n210|s700|c-810|_h797|mob-x|sk16d|848b|mowser|s580|r800|471x|v120|rim8|c500foma:|160x|x160|480x|x640|t503|w839|i250|sprint|w398samr810|m5252|c7100|mt126|x225|s5330|s820|htil-g1|fly v71|s302|-x113|novarra|k610i|-three|8325rc|8352rc|sanyo|vx54|c888|nx250|n120|mtk |c5588|s710|t880|c5005|i;458x|p404i|s210|c5100|teleca|s940|c500|s590|foma|samsu|vx8|vx9|a1000|_mms|myx|a700|gu1100|bc831|e300|ems100|me701|me702m-three|sd588|s800|8325rc|ac831|mw200|brew |d88|htc\/|htc_touch|355x|m50|km100|d736|p-9521|telco|sl74|ktouch|m4u\/|me702|8325rc|kddi|phone|lg |sonyericsson|samsung|240x|x320vx10|nokia|sony cmd|motorola|up.browser|up.link|mmp|symbian|smartphone|midp|wap|vodafone|o2|pocket|kindle|mobile|psp|treo|palm os|palm|hiptop|avantgo|fennec|plucker|xiino|blazer|elaine|iris|3g_t|windows ce|opera mobi|windows ce; smartphone;|windows ce; iemobile)/i',$user_agent));
			$isMobile = true; 
		break;
	}
	return $isMobile; 
}



function clearString($str)
{
$chars = array(
	  chr(195).chr(128) => 'A', chr(195).chr(129) => 'A',
	  chr(195).chr(130) => 'A', chr(195).chr(131) => 'A',
	  chr(195).chr(132) => 'A', chr(195).chr(133) => 'A',
	  chr(195).chr(134) => 'AE', chr(195).chr(166) => 'ae',
	  chr(195).chr(135) => 'C', chr(195).chr(136) => 'E',
	  chr(195).chr(137) => 'E', chr(195).chr(138) => 'E',
	  chr(195).chr(139) => 'E', chr(195).chr(140) => 'I',
	  chr(195).chr(141) => 'I', chr(195).chr(142) => 'I',
	  chr(195).chr(143) => 'I', chr(195).chr(145) => 'N',
	  chr(195).chr(146) => 'O', chr(195).chr(147) => 'O',
	  chr(195).chr(148) => 'O', chr(195).chr(149) => 'O',
	  chr(195).chr(150) => 'O', chr(195).chr(153) => 'U',
	  chr(195).chr(152) => 'O', chr(195).chr(184) => 'o',
	  chr(195).chr(154) => 'U', chr(195).chr(155) => 'U',
	  chr(195).chr(156) => 'U', chr(195).chr(157) => 'Y',
	  chr(195).chr(159) => 's', chr(195).chr(160) => 'a',
	  chr(195).chr(161) => 'a', chr(195).chr(162) => 'a',
	  chr(195).chr(163) => 'a', chr(195).chr(164) => 'a',
	  chr(195).chr(165) => 'a', chr(195).chr(167) => 'c',
	  chr(195).chr(168) => 'e', chr(195).chr(169) => 'e',
	  chr(195).chr(170) => 'e', chr(195).chr(171) => 'e',
	  chr(195).chr(172) => 'i', chr(195).chr(173) => 'i',
	  chr(195).chr(174) => 'i', chr(195).chr(175) => 'i',
	  chr(195).chr(177) => 'n', chr(195).chr(178) => 'o',
	  chr(195).chr(179) => 'o', chr(195).chr(180) => 'o',
	  chr(195).chr(181) => 'o', chr(195).chr(182) => 'o',
	  chr(195).chr(182) => 'o', chr(195).chr(185) => 'u',
	  chr(195).chr(186) => 'u', chr(195).chr(187) => 'u',
	  chr(195).chr(188) => 'u', chr(195).chr(189) => 'y',
	  chr(195).chr(191) => 'y',
	  chr(196).chr(128) => 'A', chr(196).chr(129) => 'a',
	  chr(196).chr(130) => 'A', chr(196).chr(131) => 'a',
	  chr(196).chr(132) => 'A', chr(196).chr(133) => 'a',
	  chr(196).chr(134) => 'C', chr(196).chr(135) => 'c',
	  chr(196).chr(136) => 'C', chr(196).chr(137) => 'c',
	  chr(196).chr(138) => 'C', chr(196).chr(139) => 'c',
	  chr(196).chr(140) => 'C', chr(196).chr(141) => 'c',
	  chr(196).chr(142) => 'D', chr(196).chr(143) => 'd',
	  chr(196).chr(144) => 'D', chr(196).chr(145) => 'd',
	  chr(196).chr(146) => 'E', chr(196).chr(147) => 'e',
	  chr(196).chr(148) => 'E', chr(196).chr(149) => 'e',
	  chr(196).chr(150) => 'E', chr(196).chr(151) => 'e',
	  chr(196).chr(152) => 'E', chr(196).chr(153) => 'e',
	  chr(196).chr(154) => 'E', chr(196).chr(155) => 'e',
	  chr(196).chr(156) => 'G', chr(196).chr(157) => 'g',
	  chr(196).chr(158) => 'G', chr(196).chr(159) => 'g',
	  chr(196).chr(160) => 'G', chr(196).chr(161) => 'g',
	  chr(196).chr(162) => 'G', chr(196).chr(163) => 'g',
	  chr(196).chr(164) => 'H', chr(196).chr(165) => 'h',
	  chr(196).chr(166) => 'H', chr(196).chr(167) => 'h',
	  chr(196).chr(168) => 'I', chr(196).chr(169) => 'i',
	  chr(196).chr(170) => 'I', chr(196).chr(171) => 'i',
	  chr(196).chr(172) => 'I', chr(196).chr(173) => 'i',
	  chr(196).chr(174) => 'I', chr(196).chr(175) => 'i',
	  chr(196).chr(176) => 'I', chr(196).chr(177) => 'i',
	  chr(196).chr(178) => 'IJ',chr(196).chr(179) => 'ij',
	  chr(196).chr(180) => 'J', chr(196).chr(181) => 'j',
	  chr(196).chr(182) => 'K', chr(196).chr(183) => 'k',
	  chr(196).chr(184) => 'k', chr(196).chr(185) => 'L',
	  chr(196).chr(186) => 'l', chr(196).chr(187) => 'L',
	  chr(196).chr(188) => 'l', chr(196).chr(189) => 'L',
	  chr(196).chr(190) => 'l', chr(196).chr(191) => 'L',
	  chr(197).chr(128) => 'l', chr(197).chr(129) => 'L',
	  chr(197).chr(130) => 'l', chr(197).chr(131) => 'N',
	  chr(197).chr(132) => 'n', chr(197).chr(133) => 'N',
	  chr(197).chr(134) => 'n', chr(197).chr(135) => 'N',
	  chr(197).chr(136) => 'n', chr(197).chr(137) => 'N',
	  chr(197).chr(138) => 'n', chr(197).chr(139) => 'N',
	  chr(197).chr(140) => 'O', chr(197).chr(141) => 'o',
	  chr(197).chr(142) => 'O', chr(197).chr(143) => 'o',
	  chr(197).chr(144) => 'O', chr(197).chr(145) => 'o',
	  chr(197).chr(146) => 'OE',chr(197).chr(147) => 'oe',
	  chr(197).chr(148) => 'R',chr(197).chr(149) => 'r',
	  chr(197).chr(150) => 'R',chr(197).chr(151) => 'r',
	  chr(197).chr(152) => 'R',chr(197).chr(153) => 'r',
	  chr(197).chr(154) => 'S',chr(197).chr(155) => 's',
	  chr(197).chr(156) => 'S',chr(197).chr(157) => 's',
	  chr(197).chr(158) => 'S',chr(197).chr(159) => 's',
	  chr(197).chr(160) => 'S', chr(197).chr(161) => 's',
	  chr(197).chr(162) => 'T', chr(197).chr(163) => 't',
	  chr(197).chr(164) => 'T', chr(197).chr(165) => 't',
	  chr(197).chr(166) => 'T', chr(197).chr(167) => 't',
	  chr(197).chr(168) => 'U', chr(197).chr(169) => 'u',
	  chr(197).chr(170) => 'U', chr(197).chr(171) => 'u',
	  chr(197).chr(172) => 'U', chr(197).chr(173) => 'u',
	  chr(197).chr(174) => 'U', chr(197).chr(175) => 'u',
	  chr(197).chr(176) => 'U', chr(197).chr(177) => 'u',
	  chr(197).chr(178) => 'U', chr(197).chr(179) => 'u',
	  chr(197).chr(180) => 'W', chr(197).chr(181) => 'w',
	  chr(197).chr(182) => 'Y', chr(197).chr(183) => 'y',
	  chr(197).chr(184) => 'Y', chr(197).chr(185) => 'Z',
	  chr(197).chr(186) => 'z', chr(197).chr(187) => 'Z',
	  chr(197).chr(188) => 'z', chr(197).chr(189) => 'Z',
	  chr(197).chr(190) => 'z', chr(197).chr(191) => 's',
	  // Euro
	  chr(226).chr(130).chr(172) => 'E',
	  // Funt
	  chr(194).chr(163) => '');		  
	 $str= strtr($str, $chars);		 
	 $str = strip_tags(strtolower($str));
	 $trans = array(
		'_'             => '-',
		'\s+'           => '-',
		'[^a-z0-9-]'    => '',
		'-+'            => '-'
	  );
	  foreach ($trans as $search => $replace){
		$str = preg_replace("#".$search."#i", $replace, $str);
	  }

return trim($str, '-');
}

function makeImageThumbnail($input, $output, $thumbwidth, $thumbheight, $mode = 'convert') {
	global $convert_path;
    global $mogrify_path;
	if($input == $output) {
		exit("Error: makeImageThumbnail() input and output cannot be the same!");
	}
	if($mode == 'convert'){
		$convert_mode=$convert_path;
	} else {
		$convert_mode=$mogrify_path;
	}
	shell_exec("$convert_mode -adaptive-resize ".($thumbwidth)."x".($thumbheight)."^ -gravity Center -extent ".$thumbwidth."x".$thumbheight." \"$input\" \"$output\"");
}

?>