require_once 'paginare/config.php';
require_once 'counter/visitorsonline.php';
function trim_text( $text, $limit )
{
if( strlen($text)>$limit )
{
$text = substr( $text,0,$limit ) . '..';
} return $text;
}
//function random() {
srand(floor(time()/86400));
$random_number = rand(10,30);
// return $random_number;
//}
$count = $count + $random_number;
?>
|
|
|
|
$query400='select * from hubs where (ok=1 and last_on=1) order by voturi desc limit 25';
$result400=mysqli_query($conexiune, $query400) or die ('nu pot sa cer detaliile hubului din mysql '.mysqli_error());
echo '
';
while($var400=mysqli_fetch_array($result400))
{
$id=$var400["id"];
$nume=$var400["nume"];
$voturi=$var400["voturi"];
$useri=$var400["useri_online"];
$last_on=$var400["last_on"];
$nume_seo=$var400["nume_seo"];
$scurt = trim_text( $nume,17 );
echo '
|
|
';
}
echo ' ';
?>
|
|
|
|
|
|
|
Statistici
|
|
|
$nr = mysqli_result(mysqli_query($conexiune,"SELECT COUNT(id) FROM hubs WHERE ok = 1"),0);
$nr2 = mysqli_result(mysqli_query($conexiune,"SELECT COUNT(id) FROM hubs WHERE ok = 0"),0);
$nr3 = mysqli_result(mysqli_query($conexiune,"SELECT COUNT(id) FROM hubs WHERE ok = 2"),0);
$nr4 = mysqli_result(mysqli_query($conexiune,"SELECT COUNT(id) FROM page_comments where is_approved = 1"),0);
$nr5 = mysqli_result(mysqli_query($conexiune,"SELECT COUNT(id) FROM hubs WHERE ok = 1 and last_on = 1"),0);
$nr6 = mysqli_result(mysqli_query($conexiune,"SELECT COUNT(id) FROM `hubs` where `ok`=1 and (`adaugat` >= DATE_SUB(CURDATE(), INTERVAL 280 DAY))"),0);
/*
$query401='SELECT * FROM hubs WHERE ok = 1';
$result401=mysql_query($query401) or die ('nu pot sa cer detaliile hubului din mysql '.mysql_error());
$nr=mysql_num_rows($result401);
$query402='SELECT * FROM hubs WHERE ok = 0';
$result402=mysql_query($query402) or die ('nu pot sa cer detaliile hubului din mysql '.mysql_error());
$nr2=mysql_num_rows($result402);
$query403='SELECT * FROM hubs WHERE ok = 2';
$result403=mysql_query($query403) or die ('nu pot sa cer detaliile hubului din mysql '.mysql_error());
$nr3=mysql_num_rows($result403);
$query404='SELECT * FROM page_comments where is_approved = 1';
$result404=mysql_query($query404) or die ('nu pot sa cer detaliile hubului din mysql '.mysql_error());
$nr4=mysql_num_rows($result404);
$query405='SELECT * FROM hubs WHERE ok = 1 and last_on = 1';
$result405=mysql_query($query405) or die ('nu pot sa cer detaliile hubului din mysql '.mysql_error());
$nr5=mysql_num_rows($result405);
$query406='SELECT * FROM `hubs` where `ok`=1 and (`adaugat` >= DATE_SUB(CURDATE(), INTERVAL 40 DAY))';
$result406=mysql_query($query406) or die ('nu pot sa cer detaliile hubului din mysql '.mysql_error());
$nr6=mysql_num_rows($result406);
*/
echo '
Huburi indexate: |
'.$nr.' |
Huburi online: |
'.$nr5.' |
Huburi noi: |
'.$nr6.' |
In asteptare: |
0 |
Respinse: |
'.$nr3.' |
Comentarii: |
'.$nr4.' |
Useri pe site: |
'.$count.' |
';
?>
|
|
|
|
|
|
|
|
|