hocam fileurl değişken değerini bulamadım functions.php aşağıdaki gibidir.
veritabanında oyunlar şu şekilde
oyunadi.swf <?php
// Get user ip
function getip() {
if (getenv('HTTP_CLIENT_IP')) {
$ip = getenv('HTTP_CLIENT_IP');
}
elseif (getenv('HTTP_X_FORWARDED_FOR')) {
$ip = getenv('HTTP_X_FORWARDED_FOR');
}
elseif (getenv('HTTP_X_FORWARDED')) {
$ip = getenv('HTTP_X_FORWARDED');
}
elseif (getenv('HTTP_FORWARDED_FOR')) {
$ip = getenv('HTTP_FORWARDED_FOR');
}
elseif (getenv('HTTP_FORWARDED')) {
$ip = getenv('HTTP_FORWARDED');
}
else {
$ip = $_SERVER['REMOTE_ADDR'];
}
return $ip;
}
function fileurl($fileId,$fileTitle) {
global $siteurl, $sefriendly;
if ($sefriendly == '1') {
$fileTitle = str_replace(" ","-",$fileTitle);
$fileTitle = str_replace("'","_",$fileTitle);
$fileTitle = str_replace(":","_",$fileTitle);
$fileTitle = str_replace("ä","a",$fileTitle);
$fileTitle = str_replace("ö","o",$fileTitle);
$fileTitle = str_replace("ü","u",$fileTitle);
$fileTitle = str_replace("ı","i",$fileTitle);
$fileTitle = str_replace("ö","o",$fileTitle);
$fileTitle = str_replace("ç","c",$fileTitle);
$fileTitle = str_replace("ğ","g",$fileTitle);
$fileTitle = str_replace("ş","s",$fileTitle);
$fileTitle = str_replace("Ç","c",$fileTitle);
$fileTitle = str_replace("I","i",$fileTitle);
$fileTitle = str_replace("Ö","o",$fileTitle);
$fileTitle = str_replace("Ğ","g",$fileTitle);
$fileTitle = str_replace("Ş","s",$fileTitle);
$fileTitle = str_replace("Ü","u",$fileTitle);
$fileTitle = str_replace("'","-",$fileTitle);
$fileTitle = str_replace(".","-",$fileTitle);
$fileTitle = str_replace("=","-",$fileTitle);
$fileTitle = str_replace("?","-",$fileTitle);
$fileTitle = str_replace("&","",$fileTitle);
$fileTitle = str_replace(",","-",$fileTitle);
$fileTitle = str_replace("İ","i",$fileTitle);
$fileTitle = str_replace("|","-",$fileTitle);
$categoryname = str_replace("ü","u",$categoryname);
$categoryname = str_replace("ı","i",$categoryname);
$categoryname = str_replace("ö","o",$categoryname);
$categoryname = str_replace("ç","c",$categoryname);
$categoryname = str_replace("ğ","g",$categoryname);
$categoryname = str_replace("ş","s",$categoryname);
$categoryname = str_replace("Ç","c",$categoryname);
$categoryname = str_replace("I","i",$categoryname);
$categoryname = str_replace("Ö","o",$categoryname);
$categoryname = str_replace("Ğ","g",$categoryname);
$categoryname = str_replace("Ş","s",$categoryname);
$categoryname = str_replace("Ü","u",$categoryname);
$categoryname = str_replace("'","-",$categoryname);
$categoryname = str_replace(".","-",$categoryname);
$categoryname = str_replace("=","-",$categoryname);
$categoryname = str_replace("?","-",$categoryname);
$categoryname = str_replace(",","-",$categoryname);
$categoryname = str_replace("|","-",$categoryname);
$categoryname = str_replace("İ","i",$categoryname);
$fileurl = $siteurl."/oyun-oyna/".$fileId."/".$fileTitle.".html";
} else {
$fileurl = $siteurl."/file.php?f=".$fileId;
}
return $fileurl;
}
function categoryurl($categoryId,$categoryname) {
global $siteurl, $sefriendly;
if ($sefriendly == '1') {
$categoryname = str_replace(" ","-",$categoryname);
$categoryname = str_replace("'","_",$categoryname);
$categoryname = str_replace("ä","a",$categoryname);
$categoryname = str_replace("ö","o",$categoryname);
$categoryname = str_replace("ü","u",$categoryname);
$categoryname = str_replace("ı","i",$categoryname);
$categoryname = str_replace("ö","o",$categoryname);
$categoryname = str_replace("ç","c",$categoryname);
$categoryname = str_replace("ğ","g",$categoryname);
$categoryname = str_replace("ş","s",$categoryname);
$categoryname = str_replace("Ç","c",$categoryname);
$categoryname = str_replace("I","i",$categoryname);
$categoryname = str_replace("Ö","o",$categoryname);
$categoryname = str_replace("Ğ","g",$categoryname);
$categoryname = str_replace("Ş","s",$categoryname);
$categoryname = str_replace("Ü","u",$categoryname);
$categoryname = str_replace("'","-",$categoryname);
$categoryname = str_replace(".","-",$categoryname);
$categoryname = str_replace("=","-",$categoryname);
$categoryname = str_replace("?","-",$categoryname);
$categoryname = str_replace(",","-",$categoryname);
$categoryname = str_replace("|","-",$categoryname);
$categoryname = str_replace("İ","i",$categoryname);
$categoryurl = $siteurl."/oyun-kategori/".$categoryId."/".$categoryname;
} else {
$categoryurl = $siteurl."/browse.php?c=".$categoryId;
}
return $categoryurl;
}
function profileurl($userid,$username) {
global $siteurl, $sefriendly;
if ($sefriendly == '1') {
$username = str_replace(" ","-",$username);
$username = str_replace("'","_",$username);
$username = str_replace("ä","a",$username);
$username = str_replace("ö","o",$username);
$username = str_replace("ü","u",$username);
$username = str_replace("ı","i",$username);
$username = str_replace("ö","o",$username);
$username = str_replace("ç","c",$username);
$username = str_replace("ğ","g",$username);
$username = str_replace("ş","s",$username);
$username = str_replace("Ç","c",$username);
$username = str_replace("I","i",$username);
$username = str_replace("Ö","o",$username);
$username = str_replace("Ğ","g",$username);
$username = str_replace("Ş","s",$username);
$username = str_replace("Ü","u",$username);
$username = str_replace("'","-",$username);
$username = str_replace(".","-",$username);
$username = str_replace("=","-",$username);
$username = str_replace("?","-",$username);
$username = str_replace(",","-",$username);
$username = str_replace("|","-",$username);
$username = str_replace("ß","b",$username);
$username = str_replace("İ","i",$username);
$username = str_replace(".","-",$username);
$categoryname = str_replace("ü","u",$categoryname);
$categoryname = str_replace("ı","i",$categoryname);
$categoryname = str_replace("ö","o",$categoryname);
$categoryname = str_replace("ç","c",$categoryname);
$categoryname = str_replace("ğ","g",$categoryname);
$categoryname = str_replace("ş","s",$categoryname);
$categoryname = str_replace("Ç","c",$categoryname);
$categoryname = str_replace("I","i",$categoryname);
$categoryname = str_replace("Ö","o",$categoryname);
$categoryname = str_replace("Ğ","g",$categoryname);
$categoryname = str_replace("Ş","s",$categoryname);
$categoryname = str_replace("Ü","u",$categoryname);
$categoryname = str_replace("'","-",$categoryname);
$categoryname = str_replace(".","-",$categoryname);
$categoryname = str_replace("=","-",$categoryname);
$categoryname = str_replace("?","-",$categoryname);
$categoryname = str_replace(",","-",$categoryname);
$categoryname = str_replace("|","-",$categoryname);
$profileurl = $siteurl."/uye-profili/".$userid."/".$username.".html";
} else {
$profileurl = $siteurl."/index.php?action=profile&uid=".$userid;
}
return $profileurl;
}
//Display categories
function displaycategories($userStatus) {
if ($userStatus == '1') {
$result = mysql_query("SELECT name, catid FROM categories WHERE status = '1' ORDER BY catorder, name");
} else {
$result = mysql_query("SELECT name, catid FROM categories WHERE status = '1' && permissions = '1' ORDER BY catorder, name");
}
if (mysql_num_rows($result)) {
while($row = mysql_fetch_array($result)) {
$categoryname = $row['name'];
$categoryid = $row['catid'];
?>
<a href="<?php echo categoryurl($categoryid,$categoryname); ?>" target="_self"><?php echo $categoryname; ?></a><br />
<?php
}
}
}
// Display files and categories on index page
function displaygamesindex($userStatus) {
global $siteurl, $maxindexpage, $sefriendly;
$cell = "1";
// Get categories
if ($userStatus == '1') {
$result = mysql_query("SELECT * FROM categories WHERE status = '1' ORDER BY catorder, name");
} else {
$result = mysql_query("SELECT * FROM categories WHERE status = '1' && permissions = '1' ORDER BY catorder, name");
}
if (mysql_num_rows($result)) {
while($row = mysql_fetch_array($result)) {
$categoryname = $row['name'];
$categoryid = $row['catid'];
// Get files in this category
$result2 = mysql_query("SELECT title, icon, iconlocation, fileid, description, timesplayed FROM files WHERE category = '$categoryid' && status = '1' ORDER BY fileid DESC LIMIT $maxindexpage");
if ($cell == '1') {
?>
<tr>
<td width="50%" valign="top">
<div class="gamesbox">
<div class="gamesboxheader">
<?php echo $categoryname; ?>
</div>
<div class="boxestext">
<table class="boxestext" border="0" width="100%">
<?php
if (mysql_num_rows($result2)) {
while($file = mysql_fetch_array($result2)) {
$filetitle = $file['title'];
$fileicon = $file['icon'];
$iconlocation = $file['iconlocation'];
$fileid = $file['fileid'];
$timesplayed = number_format($file['timesplayed']);
if ($iconlocation == '1') {
$imageurl = $siteurl."/files/image/".$fileicon;
} else {
$imageurl = $fileicon;
}
$filedescription = $file['description'];
if (strlen($filedescription) > '80') {
$filedescription = substr("$filedescription",0,77)."...";
}
?>
<tr>
<td width="71" valign="top">
<a href="<?php echo fileurl($fileid,$filetitle); ?>" target="_self"><img src="<?php echo $imageurl; ?>" width="70" height="59" title="<?php echo $filetitle; ?>" alt="<?php echo $filetitle; ?>" border="0"></a>
</td>
<td valign="top">
<a href="<?php echo fileurl($fileid,$filetitle); ?>" target="_self" class="gamelink"><?php echo $filetitle; ?></a><br />
<?php echo $filedescription; ?><br />
<span class="played">(Oynanma: <?php echo $timesplayed; ?> Kez)</span>
</td>
</tr>
<?php
}
}
?>
<tr>
<td colspan="2" align="right">
<a href="<?php echo categoryurl($categoryid,$categoryname); ?>" target="_self">Devamı <?php echo $categoryname; ?> ></a>
</td>
</tr>
</table>
</div>
</div>
</td>
<?php
$cell = "2";
} elseif ($cell == '2') {
?>
<td width="50%" valign="top">
<div class="gamesbox2">
<div class="gamesboxheader">
<?php echo $categoryname; ?>
</div>
<div class="boxestext">
<table class="boxestext" border="0" width="100%">
<?php
if (mysql_num_rows($result2)) {
while($file = mysql_fetch_array($result2)) {
$filetitle = $file['title'];
$fileicon = $file['icon'];
$iconlocation = $file['iconlocation'];
$fileid = $file['fileid'];
$timesplayed = number_format($file['timesplayed']);
if ($iconlocation == '1') {
$imageurl = $siteurl."/files/image/".$fileicon;
} else {
$imageurl = $fileicon;
}
$filedescription = $file[description];
if (strlen($filedescription) > '80') {
$filedescription = substr("$filedescription",0,77)."...";
}
?>
<tr>
<td width="71" valign="top">
<a href="<?php echo fileurl($fileid,$filetitle); ?>" target="_self"><img src="<?php echo $imageurl; ?>" width="70" height="59" title="<?php echo $filetitle; ?>" alt="<?php echo $filetitle; ?>" border="0"></a>
</td>
<td valign="top">
<a href="<?php echo fileurl($fileid,$filetitle); ?>" target="_self" class="gamelink"><?php echo $filetitle; ?></a><br />
<?php echo $filedescription; ?><br />
<span class="played">(Oynanma: <?php echo $timesplayed; ?> Kez)</span>
</td>
</tr>
<?php
}
}
?>
<tr>
<td colspan="2" align="right">
<a href="<?php echo categoryurl($categoryid,$categoryname); ?>" target="_self">Devamı <?php echo $categoryname; ?> ></a>
</td>
</tr>
</table>
</div>
</div>
</td>
</tr>
<?php
$cell = "1";
}
}
if ($cell == '2') {
echo "<td></td></tr>";
}
}
}
//Display most popular files
function displaymostpopular() {
global $maxmostpopular;
$result = mysql_query("SELECT title, fileid, timesplayed FROM files WHERE status = '1' ORDER BY timesplayed DESC LIMIT $maxmostpopular");
if (mysql_num_rows($result)) {
while($row = mysql_fetch_array($result)) {
$mpfiletitle = $row['title'];
$mpfileid = $row['fileid'];
$mptimesplayed = number_format($row['timesplayed']);
?>
<a href = "<?php echo fileurl($mpfileid,$mpfiletitle); ?>" target="_self"><?php echo $mpfiletitle; ?></a> (<?php echo $mptimesplayed; ?> Kere oynandı)<br />
<?php
}
} else {
echo "No files";
}
}
//Display newest files
function displaynewest() {
global $maxnewest;
$result = mysql_query("SELECT title, fileid, timesplayed FROM files WHERE status = '1' ORDER BY fileid DESC LIMIT $maxnewest");
if (mysql_num_rows($result)) {
while($row = mysql_fetch_array($result)) {
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<a href = "http://flash.oyunforumu.net/oyun/flash"><?php echo $nfiletitle; ?></a> (<?php echo $ntimesplayed; ?> Kere oynandı)<br />
<?php
}
} else {
echo "No files";
}
}
//Display top players
function displaytopplayers() {
global $maxtopplayers;
$top_result = mysql_query("SELECT * FROM users WHERE status = '1' ORDER BY played DESC LIMIT $maxtopplayers");
if (mysql_num_rows($top_result)) {
while($top_row = mysql_fetch_array($top_result)) {
$topuserName = $top_row['username'];
$topuserId = $top_row['userid'];
$topuserPlayed = number_format($top_row['played']);
?>
<a href = "<?php echo profileurl($topuserId,$topuserName); ?>" target="_self"><?php echo $topuserName; ?></a> (<?php echo $topuserPlayed; ?> Oyun Oynadı)<br />
<?php
}
} else {
echo "No users";
}
}
//Display top links
function displaytoplinks() {
global $maxlinks;
$result = mysql_query("SELECT * FROM links WHERE status = '1' ORDER BY hitsin DESC LIMIT $maxlinks");
if (mysql_num_rows($result)) {
while($row = mysql_fetch_array($result)) {
$linkName = htmlentities($row['name']);
$linkUrl = htmlentities($row['linkurl']);
?>
<a href = "<?php echo $linkUrl; ?>" target="_blank"><?php echo $linkName; ?></a><br />
<?php
}
} else {
echo "No links";
}
}
// BB Code
function bbcode($text) {
global $siteurl;
$text = str_replace("[b]","<b>",$text);
$text = str_replace("[/b]","</b>",$text);
$text = str_replace("[u]","<u>",$text);
$text = str_replace("[/u]","</u>",$text);
$text = str_replace("[i]","<i>",$text);
$text = str_replace("[/i]","</i>",$text);
$text = str_replace("[s]","<s>",$text);
$text = str_replace("[/s]","</s>",$text);
$text = str_replace("[quote]","<div class=\"quote\">",$text);
$text = str_replace("[/quote]","</div>",$text);
$text = str_replace(":)","<img src=\"".$siteurl."/images/happy.gif\" title=\"Happy\">",$text);
$text = str_replace(":(","<img src=\"".$siteurl."/images/sad.gif\" title=\"Sad\">",$text);
$text = str_replace(";)","<img src=\"".$siteurl."/images/wink.gif\" title=\"Wink\">",$text);
$text = str_replace(":@:","<img src=\"".$siteurl."/images/@.gif\" title=\"@\">",$text);
$text = str_replace(":8","<img src=\"".$siteurl."/images/cool.gif\" title=\"Cool\">",$text);
$text = str_replace(":wave:","<img src=\"".$siteurl."/images/wave.gif\" title=\"Wave\">",$text);
$text = str_replace(":think:","<img src=\"".$siteurl."/images/think.gif\" title=\"Hmm...\">",$text);
$text = str_replace(":clap:","<img src=\"".$siteurl."/images/clap.gif\" title=\"Clap hands\">",$text);
return $text;
}
// Get the number of files in database
function totalfiles() {
$totalfiles_result = mysql_query("SELECT count(fileid) AS total_files FROM files WHERE status = '1'");
$gettotalfiles = mysql_fetch_array($totalfiles_result);
$totalfiles = $gettotalfiles['total_files'];
return number_format($totalfiles);
}
// Count total played
function totalplayed() {
$totalplayed_result = mysql_query("SELECT sum(timesplayed) AS total_played FROM files");
$gettotalplayed = mysql_fetch_array($totalplayed_result);
$totalplayed = $gettotalplayed['total_played'];
return number_format($totalplayed);
}
// Count # of members
function totalmembers() {
$totalmembers_result = mysql_query("SELECT count(userid) AS total_members FROM users WHERE status = '1'");
$gettotalmembers = mysql_fetch_array($totalmembers_result);
$totalmembers = $gettotalmembers['total_members'];
return number_format($totalmembers);
}
// Display news
function displaynews() {
global $maxnews;
$news_result = mysql_query("SELECT * FROM news ORDER BY newsid DESC LIMIT $maxnews");
$numbernews = mysql_num_rows($news_result);
if ($numbernews) {
$newsnumber = "1";
while($news_row = mysql_fetch_array($news_result)) {
$newsTitle = $news_row['title'];
$newsMessage = nl2br($news_row['message']);
$newsMessage = bbcode($newsMessage);
if ($numbernews > '1' && $newsnumber < $numbernews) {
echo "<div class=\"newsline\">";
} else {
echo "<div>";
}
echo "<b>".$newsTitle."</b><br />";
echo $newsMessage."<br />";
echo "</div>";
$newsnumber++;
}
} else {
echo "No news";
}
}
function araz2($sadi) {
$sadi = strtr($sadi, "IĞÜŞİÖÇÄ", "iğüşiöçä");
$sadi = str_replace("ğ","g",$sadi);
$sadi = str_replace(" ","-",$sadi);
$sadi = str_replace("ä","a",$sadi);
$sadi = str_replace("ş","s",$sadi);
$sadi = str_replace("ß","ss",$sadi);
$sadi = str_replace("Ğ","g",$sadi);
$sadi = str_replace("Ş","s",$sadi);
$sadi = str_replace("ı","i",$sadi);
$sadi = str_replace("İ","i",$sadi);
$sadi = str_replace("Ö","o",$sadi);
$sadi = str_replace("ö","o",$sadi);
$sadi = str_replace("Ü","u",$sadi);
$sadi = str_replace("ü","u",$sadi);
$sadi = str_replace("ç","c",$sadi);
$sadi = str_replace("Ç","c",$sadi);
$sadi = str_replace("_","-",$sadi);
$sadi = str_replace(" ","-",$sadi);
$sadi = str_replace("--","-",$sadi);
$sadi = str_replace("--","-",$sadi);
$sadi = str_replace("--","-",$sadi);
$sadi = trim($sadi);
$sadi = ereg_replace("[^A-Za-z0-9çığşüö.-]", '', $sadi);
$sadi = str_replace("-"," ",$sadi);
return strtolower($sadi);
}
function aramagoster($pussy=30) {
$armut=mysql_query("select kelime from arananlar order by kno DESC limit 0,".$pussy);
while ($ayi=mysql_fetch_array($armut)) {
if ($ayi[kelime]!=''){
$kamil=$ayi[kelime];
if (strlen($ayi[kelime])>20) $kamil=substr($ayi[kelime],0,20)."...";
echo '<a href = "/'.make_url_friendly($ayi[kelime]).'.html" target="_self">'.$kamil.'</a><br />';
}
}
}
function make_url_friendly($url)
{
$url = trim($url);
$url = strtolower($url);
$find = array('<b>', '</b>');
$url = str_replace ($find, '', $url);
$url = preg_replace('/<(\/{0,1})img(.*?)(\/{0,1})\>/', 'image', $url);
$find = array(' ', '"', '&', '&', '\r\n', '\n', '/', '\\', '+', '<', '>');
$url = str_replace ($find, '-', $url);
$find = array('é', 'è', 'ë', 'ê', 'É', 'È', 'Ë', 'Ê');
$url = str_replace ($find, 'e', $url);
$find = array('í', 'ı', 'ì', 'î', 'ï', 'I', 'İ', 'Í', 'Ì', 'Î', 'Ï');
$url = str_replace ($find, 'i', $url);
$find = array('ó', 'ö', 'Ö', 'ò', 'ô', 'Ó', 'Ò', 'Ô');
$url = str_replace ($find, 'o', $url);
$find = array('á', 'ä', 'â', 'à', 'â', 'Ä', 'Â', 'Á', 'À', 'Â');
$url = str_replace ($find, 'a', $url);
$find = array('ú', 'ü', 'Ü', 'ù', 'û', 'Ú', 'Ù', 'Û');
$url = str_replace ($find, 'u', $url);
$find = array('ç', 'Ç');
$url = str_replace ($find, 'c', $url);
$find = array('ş', 'Ş');
$url = str_replace ($find, 's', $url);
$find = array('ğ', 'Ğ');
$url = str_replace ($find, 'g', $url);
$find = array('/[^a-z0-9\-<>]/', '/[\-]+/', '/<[^>]*>/');
$repl = array('', '_', '');
$url = preg_replace ($find, $repl, $url);
$url = str_replace ('++', '+', $url);
return $url;
}
?>