<?php
$dbhost = "localhost"; // The host where your database is
$dbname = "*****"; // Your database name
$dbuser = "*******"; // The user name
$dbpass = "******t"; // The user's password
$domain = "http://www.domain.com";
@mysql_connect ($dbhost, $dbuser, $dbpass) or die ("?§U…?©?§U†?¯?³???±?³UŒ ?¨U‡ ?¨?§U†?© ?§?·U„?§?¹?§??UŒ U†U…UŒ?¨?§?´?¯" ) ;
@mysql_select_db ($dbname);
if (isset( $_POST["id"]) ) {
sethit($_POST["id"]);
}
function sethit($entry_id)
{
$query = "SELECT * FROM mt_hits WHERE entry='$entry_id'";
$res = mysql_query($query);
if ( $row = mysql_fetch_array($res) )
{
$new_hit = $row['hits'] + 1;
$rr = mysql_query ("UPDATE mt_hits SET hits = '$new_hit' WHERE entry = '$entry_id' LIMIT 1");
return $new_hit;
}
else
{
mysql_query("INSERT INTO mt_hits ( `uid` , `entry` , `hits` ) VALUES ('', '$entry_id', '1' )");
return "1";
}
}
function showhits($entry_id)
{
$hits=0;
$query = "SELECT hits FROM mt_hits WHERE entry = '$entry_id'";
$res = mysql_query($query);
while ( $row = mysql_fetch_array($res))
{
$hits=$row["hits"];
}
echo $hits;
}
function tophits($bid,$total=10,$showhits=1)
{
$query="SELECT mt_hits.hits,mt_entry.entry_title,mt_fileinfo.fileinfo_url FROM ".
"mt_hits ,mt_entry ,mt_fileinfo WHERE mt_hits.entry = mt_entry.entry_id AND ".
"mt_entry.entry_id = mt_fileinfo.fileinfo_entry_id AND ".
"mt_entry.entry_blog_id IN ($bid) ORDER BY mt_hits.hits DESC LIMIT 0,$total";
//echo ($query);
$res = mysql_query($query);
while ( $row = mysql_fetch_array($res) )
{
if ($showhits == 0 )
{
echo ("<a href=\"".$row["fileinfo_url"]. "\">".$row["entry_title"]."</a>") ;
}
else
{
echo ("<a href=\"".$row["fileinfo_url"]. "\" style=\"direction:rtl\">" .$row["entry_title"]." [".$row["hits"]."]</a>");
}
}
}
function rndentry($bid,$total=10,$showhits=1)
{
if ($showhits == 1)
$query="SELECT mt_hits.hits,mt_entry.entry_title,mt_fileinfo.fileinfo_url FROM ".
"mt_hits ,mt_entry ,mt_fileinfo WHERE mt_hits.entry = mt_entry.entry_id AND ".
"mt_entry.entry_id = mt_fileinfo.fileinfo_entry_id AND ".
"mt_entry.entry_blog_id IN ($bid) ORDER BY RAND() LIMIT 0,$total";
else
$query="SELECT mt_entry.entry_title,mt_fileinfo.fileinfo_url FROM ".
"mt_entry ,mt_fileinfo WHERE ".
"mt_entry.entry_id = mt_fileinfo.fileinfo_entry_id AND ".
"mt_entry.entry_blog_id IN ($bid) ORDER BY RAND() LIMIT 0,$total";
$res = mysql_query($query);
while ( $row = mysql_fetch_array($res) )
{
if ($showhits == 0 )
{
echo ("<a href=\"".$row["fileinfo_url"]. "\">".$row["entry_title"]."</a>") ;
}
else
{
echo ("<a href=\"".$row["fileinfo_url"]. "\" >" .$row["entry_title"]." [".$row["hits"]."]</a>");
}
}
}
?>
موفق و پیروز باشی
