26-11-2011, 06:00 PM
for people who have upgraded and have lost the video comments function,
replace your functions.php file with this one
(this will be fixed in v3)
replace your functions.php file with this one
(this will be fixed in v3)
Code:
<?
// start v2.12 new functions
// searchform(*)
// * can be h or v
// horizontal or vertical
function searchform($option) {
global $website , $root_url;
$action = $website.$root_url."?option=search";
if ($option=="h") {
return '<form name="search" action="'.$action.'" method="post"><input type="text" name="search" /><input type="submit" value="Search" /></form>';
} else if ($option=="v") {
return '<center><form name="search" action="'.$action.'" method="post"><input type="text" name="search" /><br /><input type="submit" value="Search" /></form></center>';
}
}
// search page, called from the content() function
// would prefer match against, but our field is not fulltext
// maybe change this in later releases?
// might cause problems for existing users
// maybe we can alter the tables?
function search($q) {
global $lcl,$sutun,$satir,$cache_time;
$title = "<h1 class=\"title\">".$lcl['search_results'].": ".urldecode($q)."</h1>";
$novideo = "<h1 class=\"title\">".$lcl['search_novideo']."</h1>";
$noinput = "<h1 class=\"title\">".$lcl['search_noinput']."</h1>";
if (!$q) {
return $noinput;
} else {
$sayfa = 1;
$adet = $satir*$sutun;
if ($i==""){$i=0;}
if(isset($_GET['p'])) {
$sayfa = temizle($_GET['p']);
}
$offset = ($sayfa - 1) * $adet;
echo 'debug: '.$offset.' - '.$adet.'<br />';
//$sayfalama = pager("video where `title` rlike ('.*[[:<:]]".$q."[[:>:]].*')",$adet,"?p=#p#");
db_baglan();
$sayfalama = pager("video where `title` like '%$q%'",$adet,"?option=search&search=".$q."&p=#p#");
db_baglan();
$sorgu = "select * from video where `title` like '%$q%' order by `title` asc limit ".$offset.",".$adet."";
$result = mysql_query($sorgu) or die(mysql_error());
$return = $title.'<br />'.$sayfalama.'<table><tr>';
if(mysql_affected_rows()>0) {
while($row = mysql_fetch_array($result)) {
if ($video_link=="") {
$video_link="?option=video&id=#id&title=#title";
}
$linki=str_replace('#id',$row['v_id'],$video_link);
$linki=str_replace('#title',$row['title'],$linki);
$return=$return.'<td valign="top">
<div class="video">
<a href="'.$root_url.$linki.'"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" />
'.substr(urldecode($row['title']),0,25).'...</a></div>
</td>';
if ($i % $sutun==$sutun-1) {
$return=$return."</tr>";
}
$i=$i+1;
}
} else { return $novideo; }
return $return.'</tr></table>'.$sayfalama.'';
}
}
// featured()
// open featured.txt and put one video id per line
function featured($show,$option) {
global $website,$root_url,$sutun,$satir,$lcl,$video_link;
$filename = $website.$root_url.'featured.txt';
$filelines = $show;
db_baglan();
if ($option=="h") {
$data='<h1 class="title">'.$lcl['featured_videos'].'</h1><table><tr>';
if ($fileContents = file($filename)) {
for ($i = 0; $i < $filelines; $i++) {
$v_id = ($fileContents[$i]);
$query="Select * from video where v_id='$v_id'";
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result)) {
if ($video_link=="") {
$video_link="?option=video&id=#id&title=#title";
}
$linki=str_replace('#id',$row['v_id'],$video_link);
$linki=str_replace('#title',$row['title'],$linki);
$data=$data.'<td valign="top">
<div class="video">
<a href="'.$root_url.$linki.'"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" />
'.substr(urldecode($row['title']),0,25).'...</a></div>
</td>';
}
}
}
return $data.'</tr><tr><td colspan="'.$sutun.'"><hr></td></tr></table>';
}
} else if ($option=="v") {
$data='<h1 class="title">'.$lcl['featured_videos'].'</h1><table>';
if ($fileContents = file($filename)) {
for ($i = 0; $i < $filelines; $i++) {
$v_id = ($fileContents[$i]);
$query="Select * from video where v_id='$v_id'";
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result)) {
if ($video_link=="") {
$video_link="?option=video&id=#id&title=#title";
}
$linki=str_replace('#id',$row['v_id'],$video_link);
$linki=str_replace('#title',$row['title'],$linki);
$data=$data.'<tr><td valign="top">
<div class="video">
<a href="'.$root_url.$linki.'"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" />
'.substr(urldecode($row['title']),0,25).'...</a></div>
</td></tr>';
}
}
}
return $data.'</table>';
}
}
}
// end v2.12 new functions
function right_one()
{
include 'tmp/html/right_one.php';
}
function right_two()
{
include 'tmp/html/right_two.php';
}
function left_one()
{
include 'tmp/html/left_one.php';}
function left_two()
{
include 'tmp/html/left_two.php';}
function left_tree()
{
include 'tmp/html/left_tree.php';}
function center_up()
{
include 'tmp/html/center_up.php';}
function center_down()
{
include 'tmp/html/center_down.php';}
function tepe_reklam()
{
include 'tmp/html/header.php';}
function left_side()
{
global $kolonlar;
left_one();
if ($_GET['option']=="games" || $_GET['option']=="game" || $_GET['option']=="populargames" || $_GET['option']=="category_game" || $_GET['option']=="tag_game")
{
echo categories_game();
left_two();
echo recent_game_comments();
left_tree();
if ($kolonlar=="sol.css") {
echo taglar_game();
}
}
else
{
echo categories();
left_two();
echo recent_comments();
left_tree();
if ($kolonlar=="sol.css") {
echo taglar();
}
}
}
function right_side()
{
global $kolonlar;
right_one();
if ($_GET['option']=="games" || $_GET['option']=="game" || $_GET['option']=="populargames" || $_GET['option']=="category_game" || $_GET['option']=="tag_game")
{
if ($kolonlar=="sag.css") {
echo categories_game();
echo recent_game_comments();
}
echo taglar_game();
}
else {
if ($kolonlar=="sag.css") {
echo categories();
echo recent_comments();
}
echo taglar();
}
right_two();
}
function content() {
global $lcl;
switch ($_GET['option']) {
case "search":
$q = urlencode($_POST['search']);
if(!$q) { $q = urlencode($_GET['search']); }
return search($q);
break;
case "video":
global $video_arr;
return '<h1 class="title">'.$video_arr[1].' </h1><center>'.$video_arr[2].'<br />'.$video_arr[3].'<br /><br />'.$video_arr[4].'<br />'.$lcl['relatedvideos'].':<br />'.tablo(true,true).'</center>';
break;
case "game":
global $game_arr;
return '<h1 class="title">'.$game_arr[1].' </h1><center>'.$game_arr[2].'<br />'.$game_arr[3].'<br /><br />'.$game_arr[4].'<br />'.$lcl['relatedgames'].':<br />'.tablo_games(true,true).'</center>';
break;
case "tag":
return '<h1 class="title">'.$_GET['tag'].' </h1> <center>'.tablo(false,true).' </center> <hr />'.encok().' <hr />'.google_kelimeler();
break;
case "tag_game":
return '<h1 class="title">'.$_GET['tag'].' </h1> <center>'.tablo_games(false,true).' </center> <hr />'.encok_game().' <hr />'.google_game_kelimeler();
break;
case "popular":
return '<h1 class="title">'.$lcl['popularvideos'].' </h1> <center>'.tablo(false,false,false,true).' </center>';
break;
case "populargames":
return '<h1 class="title">'.$lcl['populargames'].' </h1> <center>'.tablo_games(false,false,false,true).' </center>';
break;
case "category":
return '<h1 class="title">'.$_GET['category'].' </h1> <center>'.tablo(false,false,true).' </center>';
break;
case "category_game":
return '<h1 class="title">'.$_GET['category'].' </h1> <center>'.tablo_games(false,false,true).' </center>';
break;
case "contact":
return '<h1 class="title">'.$lcl['contact'].' </h1> <center>'.contact().' </center>';
break;
case "games":
return '<center>'.tablo_games().' </center>';
break;
default:
return '<h1 class="title">'.$lcl['recently_added'].'</h1><center>'.tablo().' </center>';
}
}
function call_menuler()
{
global $root_url,$lcl;
return '<li><a href="'.$root_url.'">'.$lcl['homepage'].'</a></li>
<li><a href="'.$root_url.'?option=popular">'.$lcl['popularvideos'].'</a></li>
<li><a href="/blog/">Amateur blog</a><li>
<li><a href="http://www.hotamateurchat.com/?w=12163&ws=1107001 ">Webcam</a><li>
<li><a href="mailto:[email protected]" target="_blank">Contact</a></li>';
}
function call_metalar()
{
tag_kaydet();
tag_game_kaydet();
global $metalar,$meta_title,$meta_keywords,$meta_description,$root_url,$template,$kolonlar;
return '<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>'.$metalar.$meta_title.'</title>
<meta name="keywords" content="'.$metalar.$meta_keywords.'">
<meta name="description" content="'.$metalar.$meta_description.'">
<meta name="allow-search" content="yes">
<meta name="robots" content="follow">
<meta name="revisit-after" content="1 days">
<meta name="rating" content="general">
<link href="'.$root_url.'css/main.css" rel="stylesheet" type="text/css" media="screen" />
<link href="'.$root_url.'template/'.$template.'/default.css" rel="stylesheet" type="text/css" media="screen" />
<link rel="stylesheet" type="text/css" href="'.$root_url.'template/'.$template.'/'.$kolonlar.'" />';
}
function email_gonder($adresi, $adi, $konusu, $mesaji)
{
global $email;
$headers="From: ".$adi." <".$adresi.">\r\n";
$headers=$headers."MIME-Version: 1.0\r\n";
$headers=$headers."Content-type: text/HTML; charset=iso-8859-9\r\n";
$mesaji="Name : ".$adi."<br>E-mail:".$adresi."<br>Subject:".$konusu."<br><br>".$mesaji;
mail($email,$konusu,$mesaji,$headers);
}
function contact()
{
global $root_url,$lcl;
if ($_POST['name']) {
if (intval($_POST['security'])!=$_SESSION['security'])
{$mesaj="<font color='red'>".$lcl['contact_security_err2']."</font>";}
else
{
$check1 = 'http';
$check2 = 'www.';
$spamcheck = strpos($_POST['mesaj'],$check1);
$spamcheck = strpos($_POST['mesaj'],$check2);
if($spamcheck === false) {
email_gonder($_POST['email'],$_POST['name'],$_POST['subject'],$_POST['mesaj']); $mesaj=$lcl['contact_succes'];
} else {
echo '<script language="javascript">
alert("'.$lcl['spammer'].'");
</script>';
}
}
}
$form='<br>'.$mesaj.'<br><form name="contact" onsubmit="return denetle()" method="post">
<table>
<tr><td>'.$lcl['contact_name'].' : </td><td><input type="text" size="40" value="'.$_POST['name'].'" name="name" id="name" /></td></tr>
<tr><td>'.$lcl['contact_email'].' : </td><td><input type="text" size="40" value="'.$_POST['email'].'" name="email" id="email" /></td></tr>
<tr><td>'.$lcl['contact_subject'].' : </td><td><input type="text" size="40" value="'.$_POST['subject'].'" name="subject" id="subject" /></td></tr>
<tr><td>'.$lcl['contact_message'].' :</td><td> <textarea rows="10" cols="30" name="mesaj" id="mesaj">'.$_POST['mesaj'].'</textarea></td></tr>
<tr><td>'.$lcl['contact_security'].' :</td><td><input name="security" id="security" /> <img src="'.$root_url.'captcha.php"></td></tr>
<tr><td colspan=2> <input type="submit" value="'.$lcl['send'].'" /></td></tr></table>
</form>
<script language="javascript">
function denetle()
{
if (document.getElementById("name").value=="") {alert("'.$lcl['contact_name_err'].'");return false;}
if (document.getElementById("email").value=="") {alert("'.$lcl['contact_email_err'].'");return false;}
if (document.getElementById("subject").value=="") {alert("'.$lcl['contact_subject_err'].'");return false;}
if (document.getElementById("mesaj").value=="") {alert("'.$lcl['contact_message_err'].'");return false;}
if (document.getElementById("security").value=="") {alert("'.$lcl['contact_security_err'].'");return false;}
return true;
}
</script>';
return $form;
}
function db_baglan()
{
global $sunucu,$db_username,$db_password,$db_database,$conn;
$conn = mysql_connect($sunucu,$db_username,$db_password);
if (!$conn)
{
return false;
}
mysql_select_db($db_database, $conn);
return true;
}
function temizle($x)
{
$x=str_ireplace("'","",$x);
$x=str_ireplace(" and ","",$x);
$x=str_ireplace(" or ","",$x);
$x=str_ireplace("delete ","",$x);
$x=str_ireplace("select ","",$x);
$x=str_ireplace(" user ","",$x);
$x=str_ireplace(" where ","",$x);
$x=str_ireplace("drop ","",$x);
$x=str_ireplace("exec ","",$x);
$x=str_ireplace("update ","",$x);
$x=str_ireplace("insert ","",$x);
$x=str_ireplace("into ","",$x);
$x=str_ireplace("union ","",$x);
$x=str_ireplace("concat ","",$x);
$x=str_ireplace("admin ","",$x);
return $x;
}
function tag_al()
{
return $_GET['tag'];
}
function tablo($related=false,$rastgele=false,$kategori=false,$popular=false)
{
global $cache_time;
$sayfa = 1;
if(isset($_GET['p']))
{
$sayfa = temizle($_GET['p']);
}
if ($related) {$cache_id=temizle($_GET['id']);$cache_group="related_v";} //video altindaki alakali videolar
else if ($related==false & $rastgele==false) {$cache_id=$sayfa;$cache_group="index_v";} // index sayfasindaki sayfalamali videolar
else if ($related==false & $rastgele==true) {$cache_id=tag_al();$cache_group="tag_v";}
if ($kategori) {$cache_id=temizle($_GET['id']).$sayfa;$cache_group="kategori_v";}
if ($popular) {$cache_id="popular";$cache_group="popular_v";}
$options = array(
'cacheDir' => 'tmp/tablo/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get($cache_id,$cache_group)) {
return $data;
} else {
global $sutun,$satir,$video_link,$conn,$kaynak_url,$root_url,$category_link;
if ($related){$satir=3;}
$adet=$satir*$sutun;
if ($rastgele)
{
if ($related) { //video ile alakali
$sorgu=get_tags3(temizle($_GET['id']));
if ($sorgu!="()") {
$sorgu="select * from tag where ".$sorgu." GROUP BY v_id limit ".$adet;
//echo $sorgu."<br>";
db_baglan();
$result = mysql_query($sorgu);
$sql_sorgu2="(";
while($row = mysql_fetch_array($result))
{
if ($sql_sorgu2=="(") {
$sql_sorgu2=$sql_sorgu2." v_id=".$row['v_id'];}
else {
$sql_sorgu2=$sql_sorgu2." or v_id=".$row['v_id'];}
}
$sql_sorgu2=$sql_sorgu2.")";
$sql_sorgu3=str_replace("or v_id=","and v_id!=",$sql_sorgu2);
$sql_sorgu3=str_replace("v_id=","v_id!=",$sql_sorgu3);
mysql_close($conn);
}
}
else
{ // tag ile alakali
$sorgu="select * from tag where kelime='".urlencode(temizle($_GET['tag']))."' and v_id!=0 limit ".$adet;
//echo $sorgu."<br>";
db_baglan();
$result = mysql_query($sorgu);
$sql_sorgu2="(";
while($row = mysql_fetch_array($result))
{
if ($sql_sorgu2=="(") {
$sql_sorgu2=$sql_sorgu2." v_id=".$row['v_id'];}
else {
$sql_sorgu2=$sql_sorgu2." or v_id=".$row['v_id'];}
}
$sql_sorgu2=$sql_sorgu2.")";
$sql_sorgu3=str_replace("or v_id=","and v_id!=",$sql_sorgu2);
$sql_sorgu3=str_replace("v_id=","v_id!=",$sql_sorgu3);
mysql_close($conn);
}
}
else
{
$offset = ($sayfa - 1) * $adet;
if ($kategori) {
if ($category_link=="") {$linkim='?id=#id&category=#category&option=category&p=#p#';} else {$linkim=$category_link;}
$linkim=str_replace('#id',temizle($_GET['id']),$linkim);
$linkim=str_replace('#category',urlencode($_GET['category']),$linkim);
$linkim=str_replace('#p','#p#',$linkim);
$linkim=$root_url.$linkim;
$sql_sorgu=" and category=".temizle($_GET['id'])." order by tarih desc limit ".$offset.",".$adet;
$sayfalama=pager("video where tamam=1 and category=".temizle($_GET['id']),$adet,$linkim);
}
else if ($popular)
{$sql_sorgu=" order by hit desc limit ".$adet;}
else {
$sql_sorgu=" order by tarih desc limit ".$offset.",".$adet;
$sayfalama=pager("video where tamam=1",$adet,"?p=#p#");
}
}
db_baglan();
$sql_sorgu="Select * from video where tamam=1 ".$sql_sorgu;
$data=$sayfalama."<table>";
if ($rastgele)
{
if ($sql_sorgu2!="" & $sql_sorgu2!="()")
{
$sql_sorgu2="Select * from video where tamam=1 and ".$sql_sorgu2." order by tarih desc";
$result = mysql_query($sql_sorgu2);
if ($i==""){$i=0;}
$cikacak=mysql_affected_rows();
if(mysql_affected_rows()>0) {
while($row = mysql_fetch_array($result))
{
$title=urldecode($row['title']);
if ($i % $sutun==0) {$data=$data."<tr>";}
if ($video_link==""){$video_link="?option=video&id=#id&title=#title";}
$linki=str_replace('#id',$row['v_id'],$video_link);
$linki=str_replace('#title',$row['title'],$linki);
$cat_id = $row['category'];
$result2 = mysql_query("select * from category where `id` = '$cat_id'");
$cat_tot = mysql_num_rows($result2);
while ($row2 = mysql_fetch_array($result2))
{
$category = urldecode($row2['category']);
}
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a><br>Category: '.$category.'<br>Views: '.$row['hit'].'</<br>Comments: $com_tot</td>';
$vid_id = $row['v_id'];
$result2 = mysql_query("select * from comments where `v_id` = '$vid_id'");
$com_tot = mysql_num_rows($result2);
if ($i % $sutun==$sutun-1) {$data=$data."</tr>";}
$i=$i+1;
}
}
}
$adet=$adet-$cikacak;
if ($cikacak>0) {
$sql_sorgu="Select * from video where tamam=1 and ".$sql_sorgu3." order by rand() limit ".$adet; }
else {
$sql_sorgu="Select * from video where tamam=1 order by rand() limit ".$adet; }
}
if ($adet>0) {
//$result = mysql_query("Select * from video2 where tamam=1 order by id limit 1,18");
$result = mysql_query($sql_sorgu);
if ($i==""){$i=0;}
if(mysql_affected_rows()>0) {
while($row = mysql_fetch_array($result))
{
$title=urldecode($row['title']);
if ($i % $sutun==0) {$data=$data."<tr>";}
if ($video_link==""){$video_link="?option=video&id=#id&title=#title";}
$linki=str_replace('#id',$row['v_id'],$video_link);
$linki=str_replace('#title',$row['title'],$linki);
$data=$data.'<td valign="top">
<div class="video">
<a href="'.$root_url.$linki.'">
<img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" />
'.substr(urldecode($row['title']),0,20).'...</a></div>
</td>';
if ($i % $sutun==$sutun-1) {$data=$data."</tr>";}
$i=$i+1;
}
}
mysql_close($conn);
$dondur=$data.'</table>'.$sayfalama.' <script type="text/javascript" src="http://yui.yahooapis.com/combo?2.8.0r4/build/yahoo-dom-event/yahoo-dom-event.js&2.8.0r4/build/element/element-min.js&2.8.0r4/build/container/container-min.js&2.8.0r4/build/connection/connection-min.js"></script>
<script type="text/javascript" src="'.$root_url.'thumbchange-r5.js"></script>
<script type="text/javascript">
YAHOO.youporn.thumbchange.register('.($adet+1).', \'thumb\');
</script> ';
if ($cache_group=="tag_v")
{
if (google_referans()==true) {$cache->save($dondur);}
}
else {$cache->save($dondur);}
return $dondur;
}
else {return false;}
}
}
function tablo_games($related=false,$rastgele=false,$kategori=false,$popular=false)
{
global $cache_time;
$sayfa = 1;
if(isset($_GET['p']))
{
$sayfa = temizle($_GET['p']);
}
if ($related) {$cache_id=temizle($_GET['id']);$cache_group="related_g";} //video altindaki alakali videolar
else if ($related==false & $rastgele==false) {$cache_id=$sayfa;$cache_group="index_g";} // index sayfasindaki sayfalamali videolar
else if ($related==false & $rastgele==true) {$cache_id=tag_al();$cache_group="tag_g";}
if ($kategori) {$cache_id=temizle($_GET['id']).$sayfa;$cache_group="kategori_g";}
if ($popular) {$cache_id="popular";$cache_group="popular_g";}
$options = array(
'cacheDir' => 'tmp/tablo_game/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get($cache_id,$cache_group)) {
return $data;
} else {
global $sutun_game,$satir_game,$game_link,$conn,$kaynak_url,$root_url,$category_game_link;
if ($related){$satir_game=3;}
$adet=$satir_game*$sutun_game;
if ($rastgele)
{
if ($related) { //video ile alakali
$sorgu=get_tags3(temizle($_GET['id']),"tag_game");
if ($sorgu!="()") {
$sorgu="select * from tag_game where ".$sorgu." GROUP BY v_id limit ".$adet;
db_baglan();
$result = mysql_query($sorgu);
$sql_sorgu2="(";
while($row = mysql_fetch_array($result))
{
if ($sql_sorgu2=="(") {
$sql_sorgu2=$sql_sorgu2." v_id=".$row['v_id'];}
else {
$sql_sorgu2=$sql_sorgu2." or v_id=".$row['v_id'];}
}
$sql_sorgu2=$sql_sorgu2.")";
$sql_sorgu3=str_replace("or v_id=","and v_id!=",$sql_sorgu2);
$sql_sorgu3=str_replace("v_id=","v_id!=",$sql_sorgu3);
mysql_close($conn);
}
}
else
{ // tag ile alakali
$sorgu="select * from tag_game where kelime='".urlencode(temizle($_GET['tag']))."' and v_id!=0 limit ".$adet;
//echo $sorgu."<br>";
db_baglan();
$result = mysql_query($sorgu);
$sql_sorgu2="(";
while($row = mysql_fetch_array($result))
{
if ($sql_sorgu2=="(") {
$sql_sorgu2=$sql_sorgu2." v_id=".$row['v_id'];}
else {
$sql_sorgu2=$sql_sorgu2." or v_id=".$row['v_id'];}
}
$sql_sorgu2=$sql_sorgu2.")";
$sql_sorgu3=str_replace("or v_id=","and v_id!=",$sql_sorgu2);
$sql_sorgu3=str_replace("v_id=","v_id!=",$sql_sorgu3);
mysql_close($conn);
}
}
else
{
$offset = ($sayfa - 1) * $adet;
if ($kategori) {
if ($category_game_link=="") {$linkim='?id=#id&category=#category&option=category_game&p=#p#';} else {$linkim=$category_game_link;}
$linkim=str_replace('#id',temizle($_GET['id']),$linkim);
$linkim=str_replace('#category',urlencode($_GET['category']),$linkim);
$linkim=str_replace('#p','#p#',$linkim);
$linkim=$root_url.$linkim;
$sql_sorgu=" and category=".temizle($_GET['id'])." order by tarih desc limit ".$offset.",".$adet;
$sayfalama=pager("game where tamam=1 and category=".temizle($_GET['id']),$adet,$linkim);
}
else if ($popular)
{$sql_sorgu=" order by hit desc limit ".$adet;}
else {
$sql_sorgu=" order by tarih desc limit ".$offset.",".$adet;
$sayfalama=pager("game where tamam=1",$adet,"?p=#p#&option=games");
}
}
$baglanti=db_baglan();
$sql_sorgu="Select * from game where tamam=1 ".$sql_sorgu;
$data=$sayfalama."<table>";
if ($rastgele)
{
if ($sql_sorgu2!="" & $sql_sorgu2!="()")
{
$sql_sorgu2="Select * from game where tamam=1 and ".$sql_sorgu2." order by tarih desc";
$result = mysql_query($sql_sorgu2);
if ($i==""){$i=0;}
$cikacak=mysql_affected_rows();
if(mysql_affected_rows()>0) {
while($row = mysql_fetch_array($result))
{
$title=urldecode($row['title']);
if ($i % $sutun_game==0) {$data=$data."<tr>";}
if ($game_link==""){$game_link="?option=game&id=#id&title=#title";}
$linki=str_replace('#id',$row['v_id'],$game_link);
$linki=str_replace('#title',$row['title'],$linki);
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div class="video"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb_game/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a></td>';
if ($i % $sutun_game==$sutun_game-1) {$data=$data."</tr><tr><td colspan='".$sutun_game."'><hr /></td></tr>";}
$i=$i+1;
}
}
}
$adet=$adet-$cikacak;
if ($cikacak>0) {
$sql_sorgu="Select * from game where tamam=1 and ".$sql_sorgu3." order by rand() limit ".$adet; }
else {
$sql_sorgu="Select * from game where tamam=1 order by rand() limit ".$adet; }
}
if ($adet>0) {
//$result = mysql_query("Select * from video2 where tamam=1 order by id limit 1,18");
$result = mysql_query($sql_sorgu);
if ($i==""){$i=0;}
if(mysql_affected_rows()>0) {
while($row = mysql_fetch_array($result))
{
$title=urldecode($row['title']);
if ($i % $sutun_game==0) {$data=$data."<tr>";}
if ($game_link==""){$game_link="?option=game&id=#id&title=#title";}
$linki=str_replace('#id',$row['v_id'],$game_link);
$linki=str_replace('#title',$row['title'],$linki);
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div class="video"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb_game/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a></td>';
if ($i % $sutun_game==$sutun_game-1) {$data=$data."</tr><tr><td colspan='".$sutun_game."'><hr /></td></tr>";}
$i=$i+1;
}
}
mysql_close($conn);
$dondur=$data.'</table>'.$sayfalama.' <script type="text/javascript" src="http://yui.yahooapis.com/combo?2.8.0r4/build/yahoo-dom-event/yahoo-dom-event.js&2.8.0r4/build/element/element-min.js&2.8.0r4/build/container/container-min.js&2.8.0r4/build/connection/connection-min.js"></script>
<script type="text/javascript" src="'.$root_url.'thumbchange-r5.js"></script>
<script type="text/javascript">
YAHOO.youporn.thumbchange.register('.($adet+1).', \'thumb\');
</script> ';
if ($cache_group=="tag_g")
{
if (google_referans()==true) {$cache->save($dondur);}
}
else {$cache->save($dondur);}
return $dondur;
}
else {return false;}
}
}
function pager($tablo,$adet,$link)
{
global $conn;
$sayfa = 1;
$baglanti=db_baglan();
if(isset($_GET['p']))
{
$sayfa = temizle($_GET['p']);
}
$result = mysql_query("Select count(id) as toplam from ".$tablo);
$row = mysql_fetch_array($result);
$toplam=$row['toplam'];
mysql_close($conn);
$kacsayfa=$toplam/$adet;
if (strpos($kacsayfa,".")>0){$kacsayfa=intval($kacsayfa)+1;}
$sayfalama="<div class='paginator'>";
if ($sayfa>6){$linkir3=str_replace('#p#',1,$link);
$sayfalama=$sayfalama."<a href='".$linkir3."'>1</a>";}
if($sayfa>1){
$linkir2=str_replace('#p#',$sayfa-1,$link);
$sayfalama=$sayfalama."<a href='".$linkir2."'><<</a>";}
for ($i=1;$i<12;$i++)
{
$c_sayfa=$sayfa-6+$i;
if ($c_sayfa>0 && $kacsayfa>=$c_sayfa)
{
$linkir=str_replace('#p#',$c_sayfa,$link);
if ($c_sayfa==$sayfa){$sayfalama=$sayfalama."<a class='secili' href='javascript:;'>".$c_sayfa."</a>";} else { $sayfalama=$sayfalama."<a href='".$linkir."'>".$c_sayfa."</a>";}
}
}
if($kacsayfa>1 && $sayfa<$kacsayfa)
{
$linkir=str_replace('#p#',$sayfa+1,$link);
$sayfalama=$sayfalama."<a href='".$linkir."'>>></a>";
}
if(($kacsayfa-$sayfa)>5)
{
$linkir=str_replace('#p#',$kacsayfa,$link);
$sayfalama=$sayfalama."<a href='".$linkir."'>".$kacsayfa."</a>";
}
$sayfalama=$sayfalama."</div>";
return $sayfalama;
}
function categories()
{
global $cache_time;
$options = array(
'cacheDir' => 'tmp/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get('categories')) {
return $data;
} else {
global $conn,$category_link,$root_url,$lcl;
$baglanti=db_baglan();
$kategoriler='<li><h2>'.$lcl['categories'].'</h2><ul>';
$result = mysql_query("select * from category order by category");
if ($category_link==""){$linki="?id=#id&category=#category&option=category&p=1";} else {$linki=$category_link;}
while ($row = mysql_fetch_array($result))
{
$linki2=str_replace('#id',$row['id'],$linki);
$linki2=str_replace('#category',$row['category'],$linki2);
$linki2=str_replace('#p','1',$linki2);
$cat_id = $row['id'];
$result2 = mysql_query("select * from video where `category` = '$cat_id'");
$cat_tot = mysql_num_rows($result2);
$kategoriler=$kategoriler.'<li><a href="'.$root_url.$linki2.'">'.urldecode($row['category']).'</a>('.$cat_tot.')</li>';
}
$kategoriler=$kategoriler.'</ul></li>';
mysql_close($conn);
$cache->save($kategoriler);
return $kategoriler;
}
}
function categories_game()
{
global $cache_time;
$options = array(
'cacheDir' => 'tmp/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get('categories_game')) {
return $data;
} else {
global $conn,$category_game_link,$root_url,$lcl;
$baglanti=db_baglan();
$kategoriler='<li><h2>'.$lcl['categories'].'</h2><ul>';
$result = mysql_query("select * from category_game order by category");
if ($category_game_link==""){$linki="?id=#id&category=#category&option=category_game&p=1";} else {$linki=$category_game_link;}
while ($row = mysql_fetch_array($result))
{
$linki2=str_replace('#id',$row['id'],$linki);
$linki2=str_replace('#category',$row['category'],$linki2);
$linki2=str_replace('#p','1',$linki2);
$kategoriler=$kategoriler.'<li><a href="'.$root_url.$linki2.'">'.urldecode($row['category']).'</a></li>';
}
$kategoriler=$kategoriler.'</ul></li>';
mysql_close($conn);
$cache->save($kategoriler);
return $kategoriler;
}
}
function footer()
{
include 'tmp/html/footer.php';
return '<p class="copyright">© 2011 All Rights Reserved • Scripted by <a href="http://freeadultscript.com/">Free Adult Script V 2.12</a>.</p> ';
}
function tepe()
{
include 'tmp/html/tepe.php';
}
function recent_comments()
{
global $cache_time;
$options = array(
'cacheDir' => 'tmp/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get('recent_comments')) {
return $data;
} else {
global $conn,$video_link,$root_url,$lcl;
$baglanti=db_baglan();
$kategoriler='<li><h2>'.$lcl['recentcomments'].'</h2><ul>';
$result = mysql_query("select * from comments where yayin=1 order by tarih desc limit 5");
if ($video_link==""){$video_link="?option=video&id=#id&title=#title";}
while ($row = mysql_fetch_array($result))
{
$result2 = mysql_query("select * from video where v_id=".$row['v_id']);
$row2 = mysql_fetch_array($result2);
$linki=str_replace('#id',$row2['v_id'],$video_link);
$linki=str_replace('#title',$row2['title'],$linki);
$kategoriler=$kategoriler.'<li><a href="'.$root_url.$linki.'">'.substr(urldecode($row['comment']),0,60).'...</a></li>';
}
$kategoriler=$kategoriler.'</ul></li>';
mysql_close($conn);
$cache->save($kategoriler);
return $kategoriler;
}
}
function recent_game_comments()
{
global $cache_time;
$options = array(
'cacheDir' => 'tmp/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get('recent_game_comments')) {
return $data;
} else {
global $conn,$game_link,$root_url,$lcl;
$baglanti=db_baglan();
$kategoriler='<li><h2>'.$lcl['recentcomments'].'</h2><ul>';
$result = mysql_query("select * from comments_game where yayin=1 order by tarih desc limit 5");
if ($game_link==""){$game_link="?option=game&id=#id&title=#title";}
while ($row = mysql_fetch_array($result))
{
$result2 = mysql_query("select * from game where v_id=".$row['v_id']);
$row2 = mysql_fetch_array($result2);
$linki=str_replace('#id',$row2['v_id'],$game_link);
$linki=str_replace('#title',$row2['title'],$linki);
$kategoriler=$kategoriler.'<li><a href="'.$root_url.$linki.'">'.substr(urldecode($row['comment']),0,60).'...</a></li>';
}
$kategoriler=$kategoriler.'</ul></li>';
mysql_close($conn);
$cache->save($kategoriler);
return $kategoriler;
}
}
function video($id)
{
global $conn,$cache_time;
$id=temizle($id);
$baglanti=db_baglan();
mysql_query("update video set hit=hit+1 where v_id=".$id);
mysql_close($conn);
if ($_POST['comment']){post_comment();}
$options = array(
'cacheDir' => 'tmp/video/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get($id,"video")) {
$datalar=explode("###",$data);
return array(true,$datalar[0],$datalar[1],$datalar[2],$datalar[3]);
} else {
global $lcl,$kaynak_url,$comment_enable,$website,$root_url,$video_link;
$baglanti=db_baglan();
$result = mysql_query("Select * from video where v_id=".$id);
if(mysql_affected_rows()>0)
{ $row = mysql_fetch_array($result);
$description=$row['description'];
$title=$row['title'];
$kaynak=$row['kaynak'];
mysql_close($conn);
$taglari=get_tags2($id);
if($comment_enable==1){$commentti=comments();}
// video share option
if ($video_link==""){$video_link="?option=video&id=#id&title=#title";}
$linki=str_replace('#id',$row['v_id'],$video_link);
$linki=str_replace('#title',$row['title'],$linki);
$share = $lcl['share'].':<br/><textarea rows="2" cols="40"><div align="center">
<a href="'.$website.$root_url.$linki.'">
<img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$website.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></a>
<br /><a href="'.$website.$root_url.$linki.'">'.substr(urldecode($row['title']),0,25).'...</a></div></textarea>';
$data_v=array(true,urldecode($title),'<script type="text/javascript" src="'.$kaynak_url.'video/video.php?id='.$id.'&kaynak='.$kaynak.'"></script>
<br>'.$taglari,urldecode($description),$share.''.$commentti);
$data_2=urldecode($title).'###<script type="text/javascript" src="'.$kaynak_url.'video/video.php?id='.$id.'&kaynak='.$kaynak.'"></script>
<br>'.$taglari.'###'.urldecode($description).'###'.$share.'###'.$commentti;
$cache->save($data_2);
return $data_v;
}
else
{
return array(false);
}
}
}
function get_tags3($id,$kim="tag")
{
global $conn;
db_baglan();
$result = mysql_query("select * from ".$kim." where v_id=".$id);
$data="(";
while($row = mysql_fetch_array($result))
{
if ($data=="(")
{
$data=$data."kelime='".$row['kelime']."'";
}
else
{
$data=$data." or kelime='".$row['kelime']."'";
}
}
if ($data=="(") {$data=$data.")";} else {$data=$data.") and (v_id!=0 and v_id!=".$id.")";}
mysql_close($conn);
return $data;
}
function get_tags2($id,$kim="tag")
{
global $conn,$tag_link,$tag_game_link,$root_url;
db_baglan();
if ($kim=="tag"){
if ($tag_link=="") {$linki2="?option=tag&tag=#tag";} else {$linki2=$tag_link;}
}
else if ($kim=="tag_game"){
if ($tag_game_link=="") {$linki2="?option=tag_game&tag=#tag";} else {$linki2=$tag_game_link;}
}
$result = mysql_query("select * from ".$kim." where v_id=".$id);
$data="TAGS : ";
while($row = mysql_fetch_array($result))
{
$linki=str_replace('#tag',$row['kelime'],$linki2);
$data=$data.'<a href="'.$root_url.$linki.'">'.urldecode($row['kelime']).'</a>, ';
}
mysql_close($conn);
return $data;
}
function game($id)
{
$id=temizle($id);
global $conn,$cache_time,$root_url;
$baglanti=db_baglan();
mysql_query("update game set hit=hit+1 where v_id=".$id);
echo mysql_error();
mysql_close($conn);
if ($_POST['comment']){post_game_comment();}
$options = array(
'cacheDir' => 'tmp/game/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get($id,"game")) {
$datalar=explode("###",$data);
return array(true,$datalar[0],$datalar[1],$datalar[2],$datalar[3]);
} else {
global $kaynak_url,$comment_game_enable;
$baglanti=db_baglan();
$result = mysql_query("Select * from game where v_id=".$id);
if(mysql_affected_rows()>0)
{ $row = mysql_fetch_array($result);
$description=$row['description'];
$title=$row['title'];
mysql_close($conn);
if($comment_game_enable==1){$commentti=comments_game();}
// BU KISIM YAPILACAK
$taglari=get_tags2($id,'tag_game');
$data_v=array(true,urldecode($title),'<div id="loading" class="loading-invisible"><embed src="'.$root_url.'img/swf/'.$id.'.swf" quality="high" width="90%" height="90%" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"/></embed><br />
<input type="button" onclick="document.getElementById(\'loading\').className = \'loading-invisible\';document.getElementById(\'game\').className = \'loading-visible2\';" value="Close Full Screen">
</div><div id="game"><embed src="'.$root_url.'img/swf/'.$id.'.swf" quality="high" width="500" height="400" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"/></embed><br />
<input type="button" onclick="document.getElementById(\'loading\').className = \'loading-visible\'; location.href=\'#\'; document.getElementById(\'game\').className = \'loading-invisible\';" value="Full Screen"><br>'.$taglari.'</div>',urldecode($description),$commentti);
$data_2=urldecode($title).'###<div id="loading" class="loading-invisible"><embed src="'.$root_url.'img/swf/'.$id.'.swf" quality="high" width="90%" height="90%" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"/></embed><br />
<input type="button" onclick="document.getElementById(\'loading\').className = \'loading-invisible\';document.getElementById(\'game\').className = \'loading-visible2\';" value="Close Full Screen">
</div><div id="game"><embed src="'.$root_url.'img/swf/'.$id.'.swf" quality="high" width="500" height="400" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"/></embed><br />
<input type="button" onclick="document.getElementById(\'loading\').className = \'loading-visible\'; location.href=\'#\'; document.getElementById(\'game\').className = \'loading-invisible\';" value="Full Screen"><br>'.$taglari.'</div>###'.urldecode($description).'###'.$commentti;
// BU KISIM YAPILACAK SONU
$cache->save($data_2);
return $data_v;
}
else
{
return array(false);
}
}
}
function post_game_comment()
{
global $cache_time,$lcl;
if (intval($_POST['security'])!=$_SESSION['security'])
{
echo '<script language="javascript">
alert("'.$lcl['comment_form_security_err2'].'");
</script>';
return false;
}
$id=temizle($_GET['id']);
$adi=temizle($_POST['adi']);
$email=temizle($_POST['email']);
$comment=temizle($_POST['comment']);
$check1 = 'http';
$check2 = 'www.';
$spamcheck = strpos($comment,$check1);
$spamcheck = strpos($comment,$check2);
if($spamcheck === false) {
global $conn,$comment_game_yayin;
if ($comment_game_yayin==1) {
$options = array(
'cacheDir' => 'tmp/game/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get($id,"game")) {$cache->remove($id,"game");}
$options2 = array('cacheDir' => 'tmp/','lifeTime' => $cache_time,'pearErrorMode' => CACHE_LITE_ERROR_DIE);
$cache2 = new Cache_Lite($options2);
if ($data2 = $cache2->get('recent_game_comments') ) {$cache2->remove('recent_game_comments');}
}
else
{
echo '<script language="javascript">
alert("'.$lcl['comment_form_succes'].'");
</script>';
}
$baglanti=db_baglan();
mysql_query("INSERT INTO comments_game (adi,email,comment,v_id,tarih,yayin) VALUES ('".$adi."','".$email."','".$comment."',".$id.",now(),".$comment_game_yayin.")");
echo mysql_error();
mysql_close($conn);
} else {
echo '<script language="javascript">
alert("'.$lcl['spammer'].'");
</script>';
}
}
function post_comment()
{
global $cache_time,$lcl;
if (intval($_POST['security'])!=$_SESSION['security'])
{
echo '<script language="javascript">
alert("'.$lcl['comment_form_security_err2'].'");
</script>';
return false;
}
$id=temizle($_GET['id']);
$adi=temizle($_POST['adi']);
$email=temizle($_POST['email']);
$comment=temizle($_POST['comment']);
$check1 = 'http';
$check2 = 'www.';
$spamcheck = strpos($comment,$check1);
$spamcheck = strpos($comment,$check2);
if($spamcheck === false) {
global $conn,$comment_yayin;
if ($comment_yayin==1) {
$options = array(
'cacheDir' => 'tmp/video/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get($id,"video")) {$cache->remove($id,"video");}
$options2 = array('cacheDir' => 'tmp/','lifeTime' => $cache_time,'pearErrorMode' => CACHE_LITE_ERROR_DIE);
$cache2 = new Cache_Lite($options2);
if ($data2 = $cache2->get('recent_comments') ) {$cache2->remove('recent_comments');}
}
else
{
echo '<script language="javascript">
alert("'.$lcl['comment_form_succes'].'");
</script>';
}
$baglanti=db_baglan();
mysql_query("INSERT INTO comments (adi,email,comment,v_id,tarih,yayin) VALUES ('".$adi."','".$email."','".$comment."',".$id.",now(),".$comment_yayin.")");
mysql_close($conn);
} else {
echo '<script language="javascript">
alert("'.$lcl['spammer'].'");
</script>';
}
}
function comments()
{
$id=temizle($_GET['id']);
global $conn,$comment_order,$root_url,$lcl;
$baglanti=db_baglan();
$sql_sorgu="Select * from comments where yayin=1 and v_id=".$id." order by tarih ".$comment_order;
$result = mysql_query($sql_sorgu);
if(mysql_affected_rows()>0) {
$yorumlar="<div id='yorumlar'><table width='90%' class='yorumlar'>";
while($row = mysql_fetch_array($result))
{
$yorumlar=$yorumlar."<tr><td><b>".$lcl['comment_list_name'].": </b>".$row['adi']."</td><td><b>".$lcl['comment_list_date'].": </b>".$row['tarih']."</td></tr><tr><td colspan='2'><b>".$lcl['comment_list_comment'].":</b><br>".$row['comment']."<hr></td></tr>";
}
mysql_close($conn);
$yorumlar=$yorumlar."</table></div>";
}
$form='<form name="comment" onsubmit="return denetle()" method="post">
<table class="post-comment">
<tr><th>'.$lcl['comment_form_title'].'</th></tr>
<tr><td>'.$lcl['comment_form_name'].':<br><input type="text" name="adi" /></td></tr>
<tr><td>'.$lcl['comment_form_email'].'<br><input type="text" name="email" /></td></tr>
<tr><td>'.$lcl['comment_form_comment'].':<br><textarea cols="50" rows="5" name="comment" id="comment"></textarea></td></tr>
<tr><td>'.$lcl['comment_form_security'].':<input name="security" id="security" /> <img src="'.$root_url.'captcha.php"></td></tr>
<tr><td><input type="submit" value="'.$lcl['send'].'" /></td></tr>
</table>
</form>
<script language="javascript">
function denetle()
{
if (document.getElementById("comment").value=="") {alert("'.$lcl['comment_form_comment_err'].'");return false;}
if (document.getElementById("security").value=="") {alert("'.$lcl['comment_form_security_err'].'");return false;}
return true;
}
</script>';
return $form.$yorumlar;
}
function comments_game()
{
$id=temizle($_GET['id']);
global $conn,$comment_game_order,$root_url,$lcl;
$baglanti=db_baglan();
$sql_sorgu="Select * from comments_game where yayin=1 and v_id=".$id." order by tarih ".$comment_game_order;
$result = mysql_query($sql_sorgu);
if(mysql_affected_rows()>0) {
$yorumlar="<div id='yorumlar'><table width='90%' class='yorumlar'>";
while($row = mysql_fetch_array($result))
{
$yorumlar=$yorumlar."<tr><td><b>".$lcl['comment_list_name'].": </b>".$row['adi']."</td><td><b>".$lcl['comment_list_date'].": </b>".$row['tarih']."</td></tr><tr><td colspan='2'><b>".$lcl['comment_list_comment'].":</b><br>".$row['comment']."<hr></td></tr>";
}
mysql_close($conn);
$yorumlar=$yorumlar."</table></div>";
}
$form='<form name="comment" onsubmit="return denetle()" method="post">
<table class="post-comment">
<tr><th>'.$lcl['comment_form_title'].'</th></tr>
<tr><td>'.$lcl['comment_form_name'].':<br><input type="text" name="adi" /></td></tr>
<tr><td>'.$lcl['comment_form_email'].'<br><input type="text" name="email" /></td></tr>
<tr><td>'.$lcl['comment_form_comment'].':<br><textarea cols="50" rows="5" name="comment" id="comment"></textarea></td></tr>
<tr><td>'.$lcl['comment_form_security'].':<input name="security" id="security" /> <img src="'.$root_url.'captcha.php"></td></tr>
<tr><td><input type="submit" value="'.$lcl['send'].'" /></td></tr>
</table>
</form>
<script language="javascript">
function denetle()
{
if (document.getElementById("comment").value=="") {alert("'.$lcl['comment_form_comment_err'].'");return false;}
if (document.getElementById("security").value=="") {alert("'.$lcl['comment_form_security_err'].'");return false;}
return true;
}
</script>';
return $form.$yorumlar;
}
function taglar()
{
global $root_url,$cache_time;
if ($_GET['option']=="video") {$cache_id=temizle($_GET['id']);$cache_group="video_t";}
else if ($_GET['option']=="tag") {$cache_id=urlencode($_GET['tag']);$cache_group="tag_t";}
else {
$sayfa = 1;
if(isset($_GET['p']))
{
$sayfa = temizle($_GET['p']);
}
$cache_id=$sayfa;$cache_group="index_t";}
$options = array(
'cacheDir' => 'tmp/taglar/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get($cache_id,$cache_group)) {
return $data;
//return $data.backlinkspider();
} else {
global $lcl;
$baglanti=db_baglan();
$sql_sorgu="Select DISTINCT(kelime) from tag order by rand() limit 20";
$data='<li><h2>'.$lcl['tags'].'</h2><ul>';
global $conn,$tag_link;
$result = mysql_query($sql_sorgu);
if(mysql_affected_rows()>0) {
if ($tag_link=="") {$tag_link="?option=tag&tag=#tag";}
while($row = mysql_fetch_array($result))
{
$linki=str_replace('#tag',$row['kelime'],$tag_link);
$data=$data.'<a href="'.$root_url.$linki.'">'.urldecode($row['kelime']).'</a>, ';
}
$data=$data.'</ul></li>';
if ($cache_group=="tag_t")
{
if (google_referans()==true) {$cache->save($data);}
}
else {$cache->save($data);}
}
mysql_close($conn);
return $data;
//return $data.backlinkspider();
}
}
function taglar_game()
{
global $root_url,$cache_time;
if ($_GET['option']=="game") {$cache_id=temizle($_GET['id']);$cache_group="game_t";}
else if ($_GET['option']=="tag_game") {$cache_id=urlencode($_GET['tag']);$cache_group="tag_t";}
else {
$sayfa = 1;
if(isset($_GET['p']))
{
$sayfa = temizle($_GET['p']);
}
$cache_id=$sayfa;$cache_group="index_t";}
$options = array(
'cacheDir' => 'tmp/taglar_game/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get($cache_id,$cache_group)) {
return $data;
} else {
global $lcl;
$baglanti=db_baglan();
$sql_sorgu="Select DISTINCT(kelime) from tag_game order by rand() limit 20";
$data='<li><h2>'.$lcl['tags'].'</h2><ul>';
global $conn,$tag_game_link;
$result = mysql_query($sql_sorgu);
if(mysql_affected_rows()>0) {
if ($tag_game_link=="") {$tag_game_link="?option=tag_game&tag=#tag";}
while($row = mysql_fetch_array($result))
{
$linki=str_replace('#tag',$row['kelime'],$tag_game_link);
$data=$data.'<a href="'.$root_url.$linki.'">'.urldecode($row['kelime']).'</a>, ';
}
$data=$data.'</ul></li>';
if ($cache_group=="tag_t")
{
if (google_referans()==true) {$cache->save($data);}
}
else {$cache->save($data);}
}
mysql_close($conn);
return $data;
}
}
function tag_kaydet()
{
global $tag_stop;
if ($tag_stop==1) {return false;}
$referans=$_SERVER['HTTP_REFERER'];
if (strpos($referans,"www.google")>0)
{
$yerisi1=strpos($referans,"&q=");
$yerisi2=strpos($referans,"&",$yerisi1+2);
if ($yerisi1===false || $yerisi2===false) {return false;break;}
$kelimesi=substr($referans,$yerisi1+3,$yerisi2-$yerisi1-3);
$kelimesi=str_replace('%20','+',$kelimesi);
if (filtre($kelimesi)) {
global $conn;
$baglanti=db_baglan();
$result = mysql_query("Select count(id) as toplam from tag");
$row = mysql_fetch_array($result);
$toplam=$row['toplam'];
if ($toplam>500) {
mysql_query("update ignore tag set kelime='" . $kelimesi . "', tarih=now(), ping=0 order by tarih limit 1");
}
else
{
mysql_query("INSERT INTO tag (kelime,tarih) VALUES ('".$kelimesi."',now())");
}
return true;
mysql_close($conn);
}
}
return false;
}
function tag_game_kaydet()
{
global $tag_game_stop;
if ($tag_game_stop==1) {return false;}
$referans=$_SERVER['HTTP_REFERER'];
if (strpos($referans,"www.google")>0)
{
$yerisi1=strpos($referans,"&q=");
$yerisi2=strpos($referans,"&",$yerisi1+2);
if ($yerisi1===false || $yerisi2===false) {return false;break;}
$kelimesi=substr($referans,$yerisi1+3,$yerisi2-$yerisi1-3);
$kelimesi=str_replace('%20','+',$kelimesi);
if (filtre($kelimesi)) {
global $conn;
$baglanti=db_baglan();
$result = mysql_query("Select count(id) as toplam from tag_game");
$row = mysql_fetch_array($result);
$toplam=$row['toplam'];
if ($toplam>500) {
mysql_query("update ignore tag_game set kelime='" . $kelimesi . "', v_id=0, tarih=now(), ping=0 order by tarih limit 1");
}
else
{
mysql_query("INSERT INTO tag_game (kelime,tarih) VALUES ('".$kelimesi."',now())");
}
return true;
mysql_close($conn);
}
}
return false;
}
function filtre($haystack ,$offset=0){
$chr = array();
$baglanti=db_baglan();
$sql_sorgu="Select kelime from filtre";
global $conn;
$result = mysql_query($sql_sorgu);
while($row = mysql_fetch_array($result))
{
if (stripos($haystack,$row['kelime'],$offset)) {
$chr[] = stripos($haystack,$row['kelime'],$offset);
}
}
mysql_close($conn);
if(empty($chr)) return true;
return false;
}
function encok()
{
global $cache_time;
$options = array(
'cacheDir' => 'tmp/encok/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get(urlencode($_GET['tag']),"encok")) {
return $data;
} else {
$sql_sorgu="Select kelime from encok order by rand() limit 10";
global $conn;
$baglanti=db_baglan();
$result = mysql_query($sql_sorgu);
$tag=$_GET['tag'];
while($row = mysql_fetch_array($result))
{
$data=$data.$tag." ".urldecode($row['kelime']).", ";
}
if (google_referans()==true) {
$cache->save($data);}
mysql_close($conn);
return $data;
}
}
function encok_game()
{
global $cache_time;
$options = array(
'cacheDir' => 'tmp/encok_game/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get(urlencode($_GET['tag']),"encok")) {
return $data;
} else {
$sql_sorgu="Select kelime from encok_game order by rand() limit 10";
global $conn;
$baglanti=db_baglan();
$result = mysql_query($sql_sorgu);
$tag=$_GET['tag'];
while($row = mysql_fetch_array($result))
{
$data=$data.$tag." ".urldecode($row['kelime']).", ";
}
if (google_referans()==true) {
$cache->save($data);}
mysql_close($conn);
return $data;
}
}
function google_kelimeler()
{
global $cache_time,$content_stop;
if ($content_stop==1) {return "";}
$options = array(
'cacheDir' => 'tmp/google/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get(urlencode($_GET['tag']),"google")) {
return $data;
} else {
if (surekli()==urlencode($_GET['tag'])) {
$kelimeler=get_from_google(urlencode($_GET['tag']));
$cache->save($kelimeler);
}
else
{
$kelimeler=get_from_google(urlencode($_GET['tag']));
if (google_referans()==true && zaman_araligi()==true)
{
$cache->save($kelimeler);
}
}
return $kelimeler;
}
}
function google_game_kelimeler()
{
global $cache_time,$content_game_stop;
if ($content_game_stop==1) {return "";}
$options = array(
'cacheDir' => 'tmp/google_game/',
'lifeTime' => $cache_time,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get(urlencode($_GET['tag']),"google_game")) {
return $data;
} else {
if (surekli()==urlencode($_GET['tag'])) {
$kelimeler=get_from_google(urlencode($_GET['tag']));
$cache->save($kelimeler);
}
else
{
$kelimeler=get_from_google(urlencode($_GET['tag']));
if (google_referans()==true && zaman_araligi()==true)
{
$cache->save($kelimeler);
}
}
return $kelimeler;
}
}
function get_from_google($kelimesi)
{
$options2 = array(
'cacheDir' => 'tmp/',
'lifeTime' => 26400,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache_id='getgoogle';
$cache2 = new Cache_Lite($options2);
if ($data2 = $cache2->get($cache_id)) {
return "";
}
else
{
$ch = curl_init("http://www.google.com/search?num=20&q=".$kelimesi);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$data = curl_exec($ch);
if(curl_errno($ch))
{
$cache2->save("onur");
return "";
}
curl_close($ch);
$dilkodlamasi="Windows-1254";
$devam="evet";
while($devam=="evet")
{
$yeri1=strpos($data,'<div class="s">',$yeri1+2);
if ($yeri1===false){break;}
$yeri2=strpos($data,"<br>",$yeri1);
if ($yeri2===false){break;}
$kelime=substr($data,$yeri1+15,$yeri2-$yeri1-15);
$kelime = iconv($dilkodlamasi , "utf-8", $kelime );
$kelime = html_entity_decode( $kelime, ENT_QUOTES, "UTF-8" );
$yeri3=strpos($kelime,'div class="f">');
$yeri4=strpos($kelime,'</div>');
if ($yeri3>0)
{
$cikacak=substr($kelime,$yeri3-1,$yeri4-$yeri3+1);
$kelime=str_replace($cikacak,' ',$kelime);
}
$kelime=str_replace('<em>',' ',$kelime);
$kelime=str_replace('</em>',' ',$kelime);
$kelime=str_replace('<b>',' ',$kelime);
$kelime=str_replace('</b>',' ',$kelime);
$kelime=str_replace('...',' ',$kelime);
$devam="evet";
while($devam=="evet")
{
$yer1=strpos($kelime,'<');
if($yer1===false){break;}
$yer2=strpos($kelime,'>',$yer1);
if($yer2===false){break;}
$cikacak=substr($kelime,$yer1,$yer2-$yer1+1);
$kelime=str_replace($cikacak,' ',$kelime);
}
$kelime=str_replace('#','*',$kelime);
$kelimeler_arr[]=$kelime;
}
shuffle($kelimeler_arr);
$kelimeler_arr = array_slice($kelimeler_arr, 0, 5);
foreach($kelimeler_arr as $deger) {
$kelimeler=$kelimeler."<br>".$deger;
}
return $kelimeler;
}
}
function google_referans()
{
if (strpos($_SERVER['HTTP_REFERER'],"www.google")>0){return true;}
return false;
}
function zaman_araligi()
{
$options = array(
'cacheDir' => 'tmp/',
'lifeTime' => 30,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get("zaman")) {
return false;
} else {
$cache->save("omurtlak");
return true;
}
}
function surekli()
{
$options = array(
'cacheDir' => 'tmp/',
'lifeTime' => 20,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get("surekli")) {
return $data;
} else {
$cache->save(urlencode($_GET['tag']));
return false;
}
}
function clean_old_cache()
{
$options = array(
'cacheDir' => 'tmp/',
'lifeTime' => 86400,
'pearErrorMode' => CACHE_LITE_ERROR_DIE
);
$cache = new Cache_Lite($options);
if ($data = $cache->get("clean")) {
return false;
} else {
$cache->save("omurtlak");
$options = array('cacheDir' => 'tmp/encok/');
$cache = new Cache_Lite($options);
$cache->clean(false,'old');
$options = array('cacheDir' => 'tmp/encok_game/');
$cache = new Cache_Lite($options);
$cache->clean(false,'old');
$options = array('cacheDir' => 'tmp/google/');
$cache = new Cache_Lite($options);
$cache->clean(false,'old');
$options = array('cacheDir' => 'tmp/google_game/');
$cache = new Cache_Lite($options);
$cache->clean(false,'old');
$options = array('cacheDir' => 'tmp/tablo/');
$cache = new Cache_Lite($options);
$cache->clean(false,'old');
$options = array('cacheDir' => 'tmp/tablo_game/');
$cache = new Cache_Lite($options);
$cache->clean(false,'old');
$options = array('cacheDir' => 'tmp/taglar/');
$cache = new Cache_Lite($options);
$cache->clean(false,'old');
$options = array('cacheDir' => 'tmp/taglar_game/');
$cache = new Cache_Lite($options);
$cache->clean(false,'old');
$options = array('cacheDir' => 'tmp/video/');
$cache = new Cache_Lite($options);
$cache->clean(false,'old');
$options = array('cacheDir' => 'tmp/game/');
$cache = new Cache_Lite($options);
$cache->clean(false,'old');
}
}
?>