<?php
require'fun.php';
require'f_admin.php';
if($perm<2)
require'interzis.php';
$detalii_membru=$conn->query('SELECT`email`,`sex`,`activitate`,`trivia`,`spune_cartea`,`anagrame`,`vizualizari`,`data`,`vizite`,`lastvst`FROM`membrii`WHERE`id`="'.$la.'"')->fetch_row();
$titlu='Intrări în baza de date membru '.nume($la,1);
require'f_profil.php';
$back[1]=profil($la,'Profil membru '.nume($la));
$back[2]='<a href="/admin-moderare-membru/la/'.$la.'-'.seo(nume($la,1)).'">'.img('administrare.png',1).'Moderare membru '.nume($la).'</a>';
require'f_sus.php';
if(!in_array($de,$id_proprietari))
{
echo$div[4].'<img src="'.$domenii_statice[2].'actiune_delete.png" alt="" width="16" height="16" />Eroare!'.$div[5].$div[7].'Nu ai privilegiul de a accesa această pagină, păstrează distanța!'.$div[0];
require'f_jos.php';
}
require'f_data.php';
require'f_ramas.php';
$sex_la=($detalii_membru[1]=='F'?'ă':'');
$activitatea=$detalii_membru[2];
echo$div[4].img('administrare.png',1).'Intrări în baza de date membru '.nume($la).$div[5].$div[1].'E-mail: <a href="mailto:'.$detalii_membru[0].'"><strong>'.$detalii_membru[0].'</strong></a>'.$div[0].$div[1].'Puncte trivia: <strong>'.number_format($detalii_membru[3]).'</strong>'.$div[0].($meniu['biblia']==1?$div[1].'Puncte Spune Cartea: <strong>'.number_format($detalii_membru[4]).'</strong>'.$div[0]:'').$div[1].'Puncte Anagrame: <strong>'.number_format($detalii_membru[5]).'</strong>'.$div[0].$div[1].'Vizite profil: <strong>'.number_format($detalii_membru[6]).'</strong>'.$div[0].$div[1].'Inregistrat: <small>'.data($detalii_membru[7]).'</small>'.$div[0].$div[1].'Ultima data activ: <small>'.data($activitatea).'</small>'.$div[0].$div[1].'<img src="'.$domenii_statice[2].'ofl.png" alt="-" width="16" height="16" />Deconectat'.$sex_la.' de '.ramas($_SERVER['REQUEST_TIME']-$activitatea).$div[0].$div[1].'Ultima vizita: <small>'.data($detalii_membru[9]).'</small>'.$div[0].$div[1].'Vizite pe '.$adresasite[2].': <strong>'.number_format($detalii_membru[8]).'</strong>'.$div[0];
$etime=mktime(0,0,0,3,6,2007);
if($etime>$detalii_membru[7])
$dtime=$_SERVER['REQUEST_TIME']-$etime;
else
$dtime=$_SERVER['REQUEST_TIME']-$detalii_membru[7];
$timeage=ceil($dtime/86400);
$avgtime=ceil($detalii_membru[10]/$timeage);
$avgmsgtime=ramas($avgtime);
$otime=ramas($detalii_membru[10]);
echo$div[1].'Timp total online: <strong>'.$otime.'</strong>'.$div[0].$div[1].'Conectat'.$sex_la.' zilnic: <strong>'.$avgmsgtime.'</strong>'.$div[0];
$sage=$_SERVER['REQUEST_TIME']-$detalii_membru[7];
$rwage=ceil($sage/86400);
echo$div[1].'Pe '.$adresasite[2].' de: <strong>'.number_format($rwage).' zile</strong>'.$div[0];
$procentaj=$detalii_membru[10]/$sage*100;
@[$nr1,$nr2]=explode('.',$procentaj);
if($nr2[0]=='')
$nr2[0]=0;
if(@$nr2[1]=='')
$nr2[1]=0;
$procentaj=$nr1.$nr2[0].$nr2[1];
echo$div[1].'Procentaj timp conectat: <strong>'.$procentaj.'%</strong>'.$div[0];
$interogari=[
['`alerte`','`de`'],
['`alerte`','`la`'],
['`anagrame_conectati`','`de`'],
['`anagrame_raspunsuri`','`de`'],
['`baiatul_zilei`','`de`'],
['`baiatul_zilei`','`la`'],
['`baiatul_zilei_din`','`de`'],
['`bancuri`','`de`'],
['`bancuri_abonati`','`de`'],
['`bancuri_aprecieri`','`de`'],
['`bancuri_comentarii`','`de`'],
['`bancuri_note`','`de`'],
['`biblioteca_carti`','`de`'],
['`biblioteca_comentarii`','`de`'],
['`biblioteca_semne`','`de`'],
['`blog_abonati`','`de`'],
['`blog_aprecieri`','`de`'],
['`blog_articole`','`de`'],
['`blog_comentarii`','`de`'],
['`blog_note`','`de`'],
['`barnbuddy_experienta`','`de`'],
['`barnbuddy_membrii`','`de`'],
['`barnbuddy_plante`','`de`'],
['`cantari`','`de`'],
['`cantari_abonati`','`de`'],
['`cantari_aprecieri`','`de`'],
['`cantari_comentarii`','`de`'],
['`cantari_note`','`de`'],
['`casatorii_produse_cumparate`','`de`'],
['`casatorii_produse_oferite`','`de`'],
['`casatorii_produse_oferite`','`la`'],
['`casatorii_virtuale`','`de`'],
['`casatorii_virtuale`','`la`'],
['`chat_arhiva`','`de`'],
['`chat_arhiva`','`la`'],
['`chat_conectati`','`de`'],
['`chat_mesaje`','`de`'],
['`chat_mesaje`','`la`'],
['`chestionar_intrebari`','`de`'],
['`chestionar_raspunsuri`','`de`'],
['`comentarii_profil`','`de`'],
['`comentarii_profil`','`la`'],
['`contact`','`la`'],
['`daruri_oferite`','`de`'],
['`daruri_oferite`','`la`'],
['`descarcari_abonati`','`de`'],
['`descarcari_aprecieri`','`de`'],
['`descarcari_comentarii`','`de`'],
['`descarcari_fisiere`','`de`'],
['`descarcari_note`','`de`'],
['`devotionale`','`de`'],
['`devotionale_abonati`','`de`'],
['`devotionale_aprecieri`','`de`'],
['`devotionale_comentarii`','`de`'],
['`devotionale_note`','`de`'],
['`eroul`','`de`'],
['`evenimente`','`de`'],
['`evenimente`','`la`'],
['`fata_zilei`','`de`'],
['`fata_zilei`','`la`'],
['`fata_zilei_din`','`de`'],
['`forum_abonati_forumuri`','`de`'],
['`forum_abonati_topicuri`','`de`'],
['`forum_conectati`','`de`'],
['`forum_postari`','`de`'],
['`forum_topicuri`','`de`'],
['`galerie_albume`','`de`'],
['`galerie_aprecieri`','`de`'],
['`galerie_comentarii`','`de`'],
['`galerie_note`','`de`'],
['`galerie_poze`','`de`'],
['`gradina_membrii`','`de`'],
['`gradina_plante_cumparate`','`de`'],
['`gradina_seminte_cumparate`','`de`'],
['`grupuri`','`de`'],
['`grup_membrii`','`de`'],
['`ignorati`','`de`'],
['`ignorati`','`la`'],
['`imagini_zambareti_favoriti`','`de`'],
['`istoric_browsere`','`de`'],
['`istoric_logari`','`de`'],
['`istoric_nume`','`de`'],
['`istoric_vizite_profil`','`de`'],
['`istoric_vizite_profil`','`la`'],
['`jurnal_admini`','`de`'],
['`jurnal_admini`','`la`'],
['`magazin_cumparaturi`','`de`'],
['`maxime`','`de`'],
['`maxime_abonati`','`de`'],
['`maxime_aprecieri`','`de`'],
['`maxime_comentarii`','`de`'],
['`maxime_note`','`de`'],
['`meditatii`','`de`'],
['`meditatii_abonati`','`de`'],
['`meditatii_aprecieri`','`de`'],
['`meditatii_comentarii`','`de`'],
['`meditatii_note`','`de`'],
['`membrii`','`id`'],
['`membrii_conectati`','`de`'],
['`membrii_pedepsiti`','`de`'],
['`mesaje`','`de`'],
['`mesaje`','`la`'],
['`mesaje_instant`','`de`'],
['`mesaje_instant_aprecieri`','`de`'],
['`mesaje_instant_comentarii`','`de`'],
['`mesaje_instant_admini`','`de`'],
['`mesaje_instant_admini_aprecieri`','`de`'],
['`mesaje_instant_admini_comentarii`','`de`'],
['`notificari`','`de`'],
['`notificari`','`la`'],
['`ora_lei`','`de`'],
['`poezii`','`de`'],
['`poezii_abonati`','`de`'],
['`poezii_aprecieri`','`de`'],
['`poezii_comentarii`','`de`'],
['`poezii_note`','`de`'],
['`prieteni`','`de`'],
['`prieteni`','`la`'],
['`quiz_membrii`','`de`'],
['`sms`','`de`'],
['`sms_abonati`','`de`'],
['`sms_aprecieri`','`de`'],
['`sms_comentarii`','`de`'],
['`sms_note`','`de`'],
['`spune_cartea_conectati`','`de`'],
['`spune_cartea_raspunsuri`','`de`'],
['`stiri`','`de`'],
['`stiri_abonati`','`de`'],
['`stiri_aprecieri`','`de`'],
['`stiri_comentarii`','`de`'],
['`stiri_note`','`de`'],
['`t2_ajutor`','`de`'],
['`t2_ajutor`','`la`'],
['`t2_armata`','`de`'],
['`t2_conectati`','`de`'],
['`t2_invitatii`','`de`'],
['`t2_invitatii`','`la`'],
['`t2_membrii`','`de`'],
['`t2_procese`','`de`'],
['`t2_rapoarte`','`la`'],
['`t2_targ`','`de`'],
['`t2_triburi`','`de`'],
['`tichet_intrebari`','`de`'],
['`tichet_raspunsuri`','`de`'],
['`trivia_conectati`','`de`'],
['`trivia_raspunsuri`','`de`'],
['`x_0`','`de`'],
['`x_0`','`la`'],
['`x_0_jurnal`','`de`'],
['`alerte`','`raportat`'],
['`anagrame_cuvinte`','`de`'],
['`anagrame_cuvinte`','`valid`'],
['`barnbuddy_membrii`','`care`'],
['`casatorii_virtuale`','`divort`'],
['`chat_camere`','`raportat`'],
['`comentarii_profil`','`raportat`'],
['`contact`','`valid`'],
['`descarcari_fisiere`','`raportat`'],
['`eroul`','`care`'],
['`forum_postari`','`raportat`'],
['`forum_topicuri`','`raportat`'],
['`galerie_comentarii`','`raportat`'],
['`galerie_poze`','`raportat`'],
['`galerie_poze`','`valid`'],
['`gradina_membrii`','`care`'],
['`istoric_nume`','`valid`'],
['`membrii`','`invitatde`'],
['`membrii`','`valid`'],
['`membrii_pedepsiti`','`exid`'],
['`mesaje`','`raportat`'],
['`recupereaza`','`de`'],
['`trivia_intrebari`','`de`'],
['`trivia_intrebari`','`valid`'],
];
$x2=$div[1].'<a href="/admin-intrari-in-tabela-coloana-pentru-membru/la/'.$la.'-'.seo(nume($la,1)).'?tabela=';
$numar_interogari=count($interogari);
for($i=0;$i<$numar_interogari;$i++)
{
$intrari=$conn->query('SELECT COUNT(*)FROM'.$interogari[$i][0].'WHERE'.$interogari[$i][1].'="'.$la.'"')->fetch_row()[0];
if($intrari>0)
echo$x2.$interogari[$i][0].'&amp;coloana='.$interogari[$i][1].'">Tabela '.$interogari[$i][0].'.'.$interogari[$i][1].' conține '.$intrari.' intrări</a>'.$div[0];
}
echo$div[1].'<a accesskey="4" href="/admin-sterge-cont-membru/la/'.$la.'-'.seo(nume($la,1)).'/pagina/1">Șterge-i contul</a>'.$div[0];
require'f_jos.php';