echo "\n";

$result=dbquery("SELECT * FROM ".$db_prefix."users WHERE user_lastvisit>'0' AND user_status='0' ORDER BY user_lastvisit DESC LIMIT 0,10");


$result = dbquery("SELECT count(news_id) FROM ".$db_prefix."news");
echo "</a><font color=#Ffffff>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
Turime Filmu:</span><font color=#00FF00> ".dbresult($result, 0)."</a>";


echo "<span class='small'><font color=#Ffffff>&nbsp; &nbsp; &nbsp; &nbsp;Turime narių:<font color=#00AEEF> ".number_format(dbcount("(user_id)", "users", "user_status<='1'"))."\n";


$result = dbrows(dbquery("SELECT * FROM `".DB_PREFIX."invites` WHERE `invite_user_id`='".$userdata['user_id']."'"));


$ip = $_SERVER['REMOTE_ADDR'];
//kintamąjam $ip priskiriu surastą identifikacinį numerį
if($ip == ""){$ip = "Nenustatytas";}
//jei IP yra nenustatytas (tuščias) tai jam priskiriu reikšmę "Nenustatytas"
echo "&nbsp; &nbsp; &nbsp; &nbsp;<font color=#Ffffff>jūsų IP yra : <font color=#000fff>$ip";


echo "</br>";