İyinet'e Hoşgeldiniz!

Türkiye'nin En Eski Webmaster Forum'una Hemen Kayıt Olun!

Kayıt Ol!

arkadaşlar bunu msQL ya çevirebilirmnisiniz?

O

oyunbahcesi

Misafir
Kod:
<?php 
$db_server = "xxxxx";  
$db_name = "xxxxx"; 
$db_user = "xxxxx"; 
$db_passwort = "xxxxx"; 

?> 
<font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>Last 10 Members</b> 
<br> 
<?PHP 
$db = @MYSQL_CONNECT($db_server,$db_user,$db_passwort); 
$result = mysql_db_query("db_name","SELECT title,url,jointime,id,active FROM Toplist_members WHERE active='1'ORDER BY jointime DESC LIMIT 10"); 
while($satir = mysql_fetch_object($result)) 
{ 
echo "<a href=\"out.php?id=$satir->id\"target=\"_blank\">$satir->title</a> <br>"; 
} 
?> 
<br> 
<b>Top 10 Hits In</b> 
<br> 
<?php 
$result = mysql_db_query("db_name","SELECT title,url,active,id,unq_in_today FROM Toplist_members,Toplist_stToplist WHERE id = id2 AND active='1'AND unq_in_today >0 ORDER BY unq_in_today DESC LIMIT 10"); 
while($satir = mysql_fetch_object($result)) 
if(unq_in_today > 0) ; 
else 
{ 
echo 
"$satir->unq_in_today <a href=\"out.php?id=$satir->id\"target=\"_blank\">$satir->title</a><br>"; 
} 
?> 
<br> 
<b>Top 10 Hits Out</b> 
<br> 
<?php 
$result = mysql_db_query("db_name","SELECT title,url,active,id,unq_out_today FROM Toplist_members,Toplist_stToplist WHERE id = id2 AND active='1' AND unq_out_today >0 ORDER BY unq_out_today DESC LIMIT 20"); 
while($satir = mysql_fetch_object($result)) 
if(unq_out_today > 0) ; 
else 
{ 
echo 
"$satir->unq_out_today <a href=\"out.php?id=$satir->id\" target=\"_blank\">$satir->title</a><br>"; 
} 
?> 
<br> 
<b>Total Sites:</b> 

<b> 
<?PHP 
$db_select = @MYSQL_SELECT_DB($db_name); 
$result = mysql_query("SELECT * FROM Toplist_members WHERE active=1"); 
$menge = mysql_num_rows($result); 
echo 
$menge; 
?> 
</b> 
<br> 
<b>Members wait for approve:</b> 
<b> 
<?PHP 
$db_select = @MYSQL_SELECT_DB($db_name); 
$result = mysql_query("SELECT * FROM Toplist_members WHERE active=0"); 
$menge = mysql_num_rows($result); echo $menge; 
?>
 

Türkiye’nin ilk webmaster forum sitesi iyinet.com'da forum üyeleri tarafından yapılan tüm paylaşımlardan; Türk Ceza Kanunu’nun 20. Maddesinin, 5651 Sayılı Kanununun 4. maddesinin 2. fıkrasına göre, paylaşım yapan üyeler sorumludur.

Backlink ve Tanıtım Yazısı için iletişime geçmek için Skype Adresimiz: .cid.1580508955483fe5

Üst