Onarcade indexpage Yardim..

25-05-2009, 23:08:56

Üyeliği durduruldu

Merhaba Arkadaşlar..
İndexPage.html ye yeni eklenen oyunlar ve populer oyunlar yapmak istedim yeni eklenen oyunları yaptım ama populer oyunları yapamadım yardımcı olabilirmisiniz kodlar alttadır yardımlarınızdan dolayı tskler...

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

<style type="text/css">

</style>
<tr>
<td width="20%" valign="top">
<?php include("menu.html"); ?> </td>
<td width="80%" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" align="center">
<div class="contentbox">
<div class="boxestext style1"><font color="#000000"><strong>
</strong></font>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td style="border-style: none; border-width: medium">
<center>

<div class="contentheader">
<left>
<font size="1" color="#333333"><span class="style2">YENİ EKLENEN OYUNLAR </span></div>
<table><td>
<?php
$result = mysql_query("SELECT title, fileid, icon, timesplayed FROM files WHERE status = '1' ORDER BY fileid DESC LIMIT 24");
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
</td>
<tr>
<table>
<table><td>
<div class="newstext">
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center>
</td>
<td>
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>

<td>
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>

<td>

<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>
</tr><table><td>
<div class="newstext">
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center>
</td>
<td>
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>

<td>
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>

<td>

<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>
</tr>

</tr>

</center>
<center>
</table><br>
</center></td>
</tr>
</table>

<?php if ($shownews == '1') { ?>
<?php } ?>
<?php displaygamesindex($userStatus); ?>
</table>

<div class="contentheader">
<left>
<font size="1" color="#333333"><span class="style2">POPÜLER OYUNLAR </span></div>
<table><td>
<?php
$result = mysql_query("SELECT title, fileid, icon, timesplayed FROM files WHERE status = '1' ORDER BY fileid DESC LIMIT 24");
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
</td>
<tr>
<table>
<table><td>
<div class="newstext">
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center>
</td>
<td>
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>

<td>
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>

<td>

<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>
</tr><table><td>
<div class="newstext">
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center>
</td>
<td>
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>

<td>
<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>

<td>

<?php
$row = mysql_fetch_array($result);
$nfiletitle = $row['title'];
$nfileid = $row['fileid'];
$nicon = $row['icon'];
$ntimesplayed = number_format($row['timesplayed']);
?>
<center><a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" title="<?php echo $nfiletitle; ?>"><img src="files/image/<?php echo $nicon; ?>" width="130" height="90" border="0"></a>    
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo substr("$nfiletitle",0,50)."..."; ?></span><br></a>
<a href="<?php echo fileurl($nfileid,$nfiletitle); ?>" class="contentbox" title="<?php echo $nfiletitle; ?>"><span class="browsegamesbox4"><?php echo $ntimesplayed; ?> kez izlendi </a></span></center></td>
</tr>

</tr>

</center>
<center>
</table><br>
</center></td>
</tr>
</table>

<?php if ($shownews == '1') { ?>
<?php } ?>
<?php displaygamesindex($userStatus); ?>
</table>

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

25-05-2009, 23:13:41

#2

taylanaktepe

Eposta Aktivasyonu Gerekmekte

Nerde hata verdi, veya neresi görünmedi...

Onarcade 2.2 mi bu?

25-05-2009, 23:38:42

#3

~~TheXjL~~

Üyeliği durduruldu

onarcade 1

hata vermedi populer oyunlarda en cok hangi oyun oynandıysa onu göstermek istiyorum ama burda sadece yeni eklenen oyunlar gösteriyor..

26-05-2009, 03:22:18

#4

star2218

mysql_query("SELECT title, fileid, icon, timesplayed FROM files WHERE status = '1' ORDER BY fileid DESC LIMIT 24")

Sorguda ORDER BY fileid DESC burdaki fileid yerine tablonda oyunun hitini tutan veri ile değiştirmen gerekir

örnek ORDER BY hit ASC

27-05-2009, 19:17:56

#5

~~TheXjL~~

Üyeliği durduruldu

onu nasıl yapıcam acaba kardes..

Sorun orda..

27-05-2009, 19:21:29

#6

Misafir

hiç php bilmiyorsanız ücrete mukabil yapılabilir
biliyorsanız hatanız yada yapmak istediğinizşey yanıtlanmış

27-05-2009, 22:00:33

#7

~~sdemirkeser~~

Üyeliği durduruldu

Misafir adlı üyeden alıntı: mesajı görüntüle

hiç php bilmiyorsanız ücrete mukabil yapılabilir
biliyorsanız hatanız yada yapmak istediğinizşey yanıtlanmış

yeni php forumu uygulaması, yardım sonuna kadar ücretsiz. kod yazmak ve bireysel destek ücrete tabi

27-05-2009, 23:22:04

#8

Misafir

aynen üstad

27-05-2009, 23:32:13

#9

futli

Arkadaşım verdigim kodu kullan.Php bilgim yok sadece kendi scriptimdeki kodu sana tavsiye amaçlı veriyorum.Bende zamanında çok konu açtım bulundugun durumu anlayabiliyorum.

kod:

<?php

$result = mysql_query("SELECT title, fileid, icon, timesplayed FROM files WHERE status = '1' ORDER BY timesplayed DESC LIMIT 8");

$row = mysql_fetch_array($result);

$nfiletitle = $row['title'];

$nfileid = $row['fileid'];

$nicon = $row['icon'];

$ntimesplayed = number_format($row['timesplayed']);

?>