Top PARTIDE





Frecventa consemnarii partidului in presa centrala de azi 30.03.2020
LocPartidArticole Ziare Aparitii Procente
Frecventa cumulata a consemnarii numelor partidelor in presa centrala
din luna curenta: 03. 2020
LocPartid Articole Ziare Aparitii Procente
Frecventa cumulata a consemnarii numelor partidelor in presa centrala
din ultimele 30 de zile
LocPartid Articole Ziare Aparitii Procente
"; $i_azi=1; while (list($id,$nume_azi,$azi,$poza)= mysql_fetch_array($interogare)) { // $link_lista = "".$nume_azi.""; $i_ieri=1; $gasit=0; $interogare2=mysql_query(" SELECT g.id, g.numelista,g.ieri FROM ( select c.id, c.numelista, SUM(IF(t.data=DATE_SUB(date(now()),INTERVAL '1 1:1:1' DAY_SECOND),t.articole,0)) as ieri from toppartide t INNER join cautari c ON t.idcautare=c.id GROUP BY c.numelista ORDER BY ieri DESC, c.numelista ASC ) g ORDER BY g.ieri DESC, g.numelista DESC; "); while (list($id,$nume_ieri,$ieri0)= mysql_fetch_array($interogare2)) { if($nume_azi==$nume_ieri) { if($i_ieri<$i_azi) {$status = "jos";} if($i_ieri>$i_azi) {$status = "sus";} if($i_ieri==$i_azi) {$status = "stationar";} $gasit=1; $ieri=$i_ieri; } $i_ieri+=1; } if($gasit==0) {$status = "sus"; $ieri=$i_ieri;} if($ieri>=100) $ieri="500"; /* echo " $status :: $nume_azi Ieri:$ieri // Azi:$i_azi "; */ $nume[$i_azi]=$nume_azi; $imag[$i_azi]="index.php?module=Photoshare&type=show&func=viewimage&iid=".$poza; $poz_cur[$i_azi] = $i_azi; $poz_ieri[$i_azi] = $ieri; echo "$numw [ $i_azi ] = ".$nume[$i_azi]; $i_azi++; } $tip=262; // zilnic,sapt,lunar $conn=mysql_connect("localhost","info","55t6y7"); mysql_select_db("info2007",$conn); if($poz_cur[10]==10) { //echo $nume['1'].$imag['1'].$poz_cur[1].$poz_ieri[1].$nume[2].$tip.$imag[2].$poz_cur[2].$poz_ieri[2]; $datacur=date("Y-m-d H:i:s"); $q_update="UPDATE info2007.nuke_pagesetter_counters as g set g.pg_count=g.pg_count+1 WHERE g.pg_name='tid15'"; $result_q_update=mysql_query($q_update); echo "2) ".mysql_error()."\n"; $qm="select max(pg_pid) from info2007.nuke_pagesetter_pubdata15"; $resultqm=mysql_query($qm); $qmidmaxim=mysql_result($resultqm,0)+1; echo "2.2.) ".mysql_error()."\n"; $queryinsertbaneasa="insert into info2007.nuke_pagesetter_pubdata15 values ('',$qmidmaxim, 'approved', 1,0,1,-1,1,1,'Gabriel GARAIS', '539','$datacur','$datacur','$datacur',NULL,'x_all', '".$nume[1]."','".$imag[1]."',".$poz_cur[1].",".$poz_ieri[1].",'','','', '".$nume[2]."',$tip,'".$imag[2]."',".$poz_cur[2].",".$poz_ieri[2].",'','','', '".$nume[3]."','".$imag[3]."',".$poz_cur[3].",".$poz_ieri[3].",'','','', '".$nume[4]."','".$imag[4]."',".$poz_cur[4].",".$poz_ieri[4].",'','','', '".$nume[5]."','".$imag[5]."',".$poz_cur[5].",".$poz_ieri[5].",'','','', '".$nume[6]."','".$imag[6]."',".$poz_cur[6].",".$poz_ieri[6].",'','','', '".$nume[7]."','".$imag[7]."',".$poz_cur[7].",".$poz_ieri[7].",'','','', '".$nume[8]."','".$imag[8]."',".$poz_cur[8].",".$poz_ieri[8].",'','','', '".$nume[9]."','".$imag[9]."',".$poz_cur[9].",".$poz_ieri[9].",'','','', '".$nume[10]."','".$imag[10]."',".$poz_cur[10].",".$poz_ieri[10].",'','','','','' )"; echo $queryinsertbaneasa; $resultinsertbaneasa=mysql_query($queryinsertbaneasa); echo "3) ".mysql_error()."\n"; /// STOP -->> Add din queue in pubdata15 STOP /// START -->> Add in pubheader START $queryinsertbaneasa="insert into info2007.nuke_pagesetter_pubheader values (15, (Select MAX(pg_pid) FROM nuke_pagesetter_pubdata15), 0, (Select MAX(pg_pid) FROM nuke_pagesetter_pubdata15), 0)"; $resultinsertbaneasa=mysql_query($queryinsertbaneasa); echo "4) ".mysql_error()."\n"; /// STOP -->> Add in pubheader STOP /// START -->> Add in revisions START $queryinsertbaneasa="insert into info2007.nuke_pagesetter_revisions values (15, (Select MAX(pg_id) FROM nuke_pagesetter_pubdata15), (Select MAX(pg_pid) FROM nuke_pagesetter_pubdata15), 0, '539', date(now()))"; $resultinsertbaneasa=mysql_query($queryinsertbaneasa); echo "5) ".mysql_error()."\n"; /// STOP -->> Add in revisions STOP /// insert in amos top arhivare } // echo mysql_errno().": ".mysql_error()."
"; // echo $num = mysql_numrows($interogare); } ////// END ZILNIC ARHIVARE ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// if ($saptamanal) { //echo mysql_errno().": ".mysql_error()."
"; ////START SAPTAMANAL ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $conn=mysql_connect("localhost","info","55t6y7"); mysql_select_db("listeautomate",$conn); $interogare=mysql_query(" SELECT g.id, g.numelista, g.azi, g.ps_id FROM ( select c.id, c.numelista, SUM(IF(t.data>=DATE_SUB(CURDATE(),INTERVAL 7 DAY),t.articole,0)) as azi, info.ps_id from toppartide t join cautari c ON t.idcautare=c.id, info2007.nuke_photoshare_images info WHERE c.numelista=info.ps_title AND info.ps_parentfolder = 87 GROUP BY c.numelista ORDER BY azi DESC, c.numelista ASC LIMIT 0,10 ) g ORDER BY g.azi DESC, g.numelista DESC; "); // echo mysql_errno().": ".mysql_error()."
"; echo " "; $i_azi=1; while (list($id,$nume_azi,$azi,$poza)= mysql_fetch_array($interogare)) { $link_lista = "".$nume_azi.""; $i_ieri=1; $gasit=0; $interogare2=mysql_query(" SELECT g.id, g.numelista,g.ieri FROM ( select c.id, c.numelista, SUM(IF(t.data between DATE_SUB(CURDATE(),INTERVAL 14 DAY) AND DATE_SUB(CURDATE(),INTERVAL 7 DAY),t.articole,0)) as ieri from toppartide t join cautari c ON t.idcautare=c.id GROUP BY c.numelista ORDER BY ieri DESC, c.numelista ASC ) g ORDER BY g.ieri DESC, g.numelista DESC; "); // echo mysql_errno().": ".mysql_error()."
"; while (list($id,$nume_ieri,$ieri0)= mysql_fetch_array($interogare2)) { if($nume_azi==$nume_ieri) { if($i_ieri<$i_azi) {$status = "jos";} if($i_ieri>$i_azi) {$status = "sus";} if($i_ieri==$i_azi) {$status = "stationar";} $gasit=1; $ieri=$i_ieri; } $i_ieri+=1; } if($gasit==0) {$status = "sus"; $ieri=$i_ieri;} if($ieri>=100) $ieri="500"; $nume[$i_azi]=$nume_azi; $imag[$i_azi]="index.php?module=Photoshare&type=show&func=viewimage&iid=".$poza; $poz_cur[$i_azi] = $i_azi; $poz_ieri[$i_azi] = $ieri; $i_azi++; } $tip=263; // zilnic,sapt,lunar $conn=mysql_connect("localhost","info","55t6y7"); mysql_select_db("info2007",$conn); if($poz_cur[10]==10) { //echo $nume['1'].$imag['1'].$poz_cur[1].$poz_ieri[1].$nume[2].$tip.$imag[2].$poz_cur[2].$poz_ieri[2]; $datacur=date("Y-m-d H:i:s"); $q_update="UPDATE info2007.nuke_pagesetter_counters set pg_count=pg_count+1 WHERE pg_name='tid15'"; $result_q_update=mysql_query($q_update); echo "2) ".mysql_error()."\n"; $qm="select max(pg_pid) from info2007.nuke_pagesetter_pubdata15"; $resultqm=mysql_query($qm); $qmidmaxim=mysql_result($resultqm,0)+1; echo "2.2.) ".mysql_error()."\n"; $queryinsertbaneasa="insert into info2007.nuke_pagesetter_pubdata15 values ('',$qmidmaxim, 'approved', 1,0,1,-1,1,1,'Gabriel GARAIS', '539','$datacur','$datacur','$datacur',NULL,'x_all', '".$nume[1]."','".$imag[1]."',".$poz_cur[1].",".$poz_ieri[1].",'','','', '".$nume[2]."',$tip,'".$imag[2]."',".$poz_cur[2].",".$poz_ieri[2].",'','','', '".$nume[3]."','".$imag[3]."',".$poz_cur[3].",".$poz_ieri[3].",'','','', '".$nume[4]."','".$imag[4]."',".$poz_cur[4].",".$poz_ieri[4].",'','','', '".$nume[5]."','".$imag[5]."',".$poz_cur[5].",".$poz_ieri[5].",'','','', '".$nume[6]."','".$imag[6]."',".$poz_cur[6].",".$poz_ieri[6].",'','','', '".$nume[7]."','".$imag[7]."',".$poz_cur[7].",".$poz_ieri[7].",'','','', '".$nume[8]."','".$imag[8]."',".$poz_cur[8].",".$poz_ieri[8].",'','','', '".$nume[9]."','".$imag[9]."',".$poz_cur[9].",".$poz_ieri[9].",'','','', '".$nume[10]."','".$imag[10]."',".$poz_cur[10].",".$poz_ieri[10].",'','','','','' )"; echo $queryinsertbaneasa; $resultinsertbaneasa=mysql_query($queryinsertbaneasa); echo "3) ".mysql_error()."\n"; /// STOP -->> Add din queue in pubdata15 STOP /// START -->> Add in pubheader START $queryinsertbaneasa="insert into info2007.nuke_pagesetter_pubheader values (15, (Select MAX(pg_pid) FROM nuke_pagesetter_pubdata15), 0, (Select MAX(pg_pid) FROM nuke_pagesetter_pubdata15), 0)"; $resultinsertbaneasa=mysql_query($queryinsertbaneasa); echo "4) ".mysql_error()."\n"; /// STOP -->> Add in pubheader STOP /// START -->> Add in revisions START $queryinsertbaneasa="insert into info2007.nuke_pagesetter_revisions values (15, (Select MAX(pg_id) FROM nuke_pagesetter_pubdata15), (Select MAX(pg_pid) FROM nuke_pagesetter_pubdata15), 0, '539', date(now()))"; $resultinsertbaneasa=mysql_query($queryinsertbaneasa); echo "5) ".mysql_error()."\n"; /// STOP -->> Add in revisions STOP /// insert in amos top arhivare } //////// END SAPTAMANAL ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// } if ($prima_duminica_din_luna) { ////START LUNAR ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $conn=mysql_connect("localhost","info","55t6y7"); mysql_select_db("listeautomate",$conn); $interogarel=mysql_query(" SELECT g.id, g.numelista, g.azi, g.ps_id FROM ( select c.id, c.numelista, SUM(IF(t.data>=DATE_SUB(CURDATE(),INTERVAL 1 MONTH),t.articole,0)) as azi, info.ps_id from toppartide t join cautari c ON t.idcautare=c.id, info2007.nuke_photoshare_images info WHERE c.numelista=info.ps_title AND info.ps_parentfolder = 87 GROUP BY c.numelista ORDER BY azi DESC, c.numelista ASC LIMIT 0,10 ) g ORDER BY g.azi DESC, g.numelista DESC; "); echo mysql_errno().": ".mysql_error()."
"; $i_azi=1; while (list($id,$nume_azi,$azi,$poza)= mysql_fetch_array($interogarel)) { echo $link_lista = "".$nume_azi.""; // echo "xxxxxxxxxxxxxxxxxx : ".$i_azi; $i_ieri=1; $gasit=0; $interogare2l=mysql_query(" SELECT g.id, g.numelista,g.ieri FROM ( select c.id, c.numelista, SUM(IF(t.data between DATE_SUB(CURDATE(),INTERVAL 2 MONTH) AND DATE_SUB(CURDATE(),INTERVAL 1 MONTH),t.articole,0)) as ieri from toppartide t join cautari c ON t.idcautare=c.id GROUP BY c.numelista ORDER BY ieri DESC, c.numelista ASC ) g ORDER BY g.ieri DESC, g.numelista DESC; "); // echo mysql_errno().": ".mysql_error()."
"; while (list($id,$nume_ieri,$ieri0)= mysql_fetch_array($interogare2l)) { if($nume_azi==$nume_ieri) { if($i_ieri<$i_azi) {$status = "jos";} if($i_ieri>$i_azi) {$status = "sus";} if($i_ieri==$i_azi) {$status = "stationar";} $gasit=1; $ieri=$i_ieri; } $i_ieri+=1; } if($gasit==0) {$status = "sus"; $ieri=$i_ieri;} if($ieri>=100) $ieri="500"; /* echo ""; */ $nume[$i_azi]=$nume_azi; $imag[$i_azi]="index.php?module=Photoshare&type=show&func=viewimage&iid=".$poza; $poz_cur[$i_azi] = $i_azi; $poz_ieri[$i_azi] = $ieri; echo "$num [ $i_azi ] = ".$nume[$i_azi]."
"; echo "$poz [ $i_azi ] = ".$poz_cur[$i_azi]."
"; echo "$old [ $i_azi ] = ".$poz_ieri[$i_azi]."
"; $i_azi++; } $tip=264; // zilnic,sapt,lunar $conn=mysql_connect("localhost","info","55t6y7"); mysql_select_db("info2007",$conn); if($poz_cur[10]==10) { //echo $nume['1'].$imag['1'].$poz_cur[1].$poz_ieri[1].$nume[2].$tip.$imag[2].$poz_cur[2].$poz_ieri[2]; $datacur=date("Y-m-d H:i:s"); $q_update="UPDATE info2007.nuke_pagesetter_counters set pg_count=pg_count+1 WHERE pg_name='tid15'"; $result_q_update=mysql_query($q_update); echo "2) ".mysql_error()."\n"; $qm="select max(pg_pid) from info2007.nuke_pagesetter_pubdata15"; $resultqm=mysql_query($qm); $qmidmaxim=mysql_result($resultqm,0)+1; echo "2.2.) ".mysql_error()."\n"; $queryinsertbaneasa="insert into info2007.nuke_pagesetter_pubdata15 values ('',$qmidmaxim, 'approved', 1,0,1,-1,1,1,'Gabriel GARAIS', '539','$datacur','$datacur','$datacur',NULL,'x_all', '".$nume[1]."','".$imag[1]."',".$poz_cur[1].",".$poz_ieri[1].",'','','', '".$nume[2]."',$tip,'".$imag[2]."',".$poz_cur[2].",".$poz_ieri[2].",'','','', '".$nume[3]."','".$imag[3]."',".$poz_cur[3].",".$poz_ieri[3].",'','','', '".$nume[4]."','".$imag[4]."',".$poz_cur[4].",".$poz_ieri[4].",'','','', '".$nume[5]."','".$imag[5]."',".$poz_cur[5].",".$poz_ieri[5].",'','','', '".$nume[6]."','".$imag[6]."',".$poz_cur[6].",".$poz_ieri[6].",'','','', '".$nume[7]."','".$imag[7]."',".$poz_cur[7].",".$poz_ieri[7].",'','','', '".$nume[8]."','".$imag[8]."',".$poz_cur[8].",".$poz_ieri[8].",'','','', '".$nume[9]."','".$imag[9]."',".$poz_cur[9].",".$poz_ieri[9].",'','','', '".$nume[10]."','".$imag[10]."',".$poz_cur[10].",".$poz_ieri[10].",'','','','','' )"; echo $queryinsertbaneasa; $resultinsertbaneasa=mysql_query($queryinsertbaneasa); echo "3) ".mysql_error()."\n"; /// STOP -->> Add din queue in pubdata15 STOP /// START -->> Add in pubheader START $queryinsertbaneasa="insert into info2007.nuke_pagesetter_pubheader values (15, (Select MAX(pg_pid) FROM nuke_pagesetter_pubdata15), 0, (Select MAX(pg_pid) FROM nuke_pagesetter_pubdata15), 0)"; $resultinsertbaneasa=mysql_query($queryinsertbaneasa); echo "4) ".mysql_error()."\n"; /// STOP -->> Add in pubheader STOP /// START -->> Add in revisions START $queryinsertbaneasa="insert into info2007.nuke_pagesetter_revisions values (15, (Select MAX(pg_id) FROM nuke_pagesetter_pubdata15), (Select MAX(pg_pid) FROM nuke_pagesetter_pubdata15), 0, '539', date(now()))"; $resultinsertbaneasa=mysql_query($queryinsertbaneasa); echo "5) ".mysql_error()."\n"; /// STOP -->> Add in revisions STOP /// insert in amos top arhivare } //////// END LUNAR ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// } //$link = mysql_connect("localhost","info","55t6y7"); //mysql_select_db("info2007",$link); $link = mysql_connect("localhost","info","55t6y7"); mysql_select_db("revistapresei",$link); } $garais = pnVarCleanFromInput('garais'); if($garais) { $datacurenta=date("Y-m-d"); $conn=mysql_connect("localhost","info","55t6y7"); mysql_select_db("listeautomate",$conn); if (empty($ordine)) $ordine="articole"; $prima_duminica_din_luna = 0; $saptamanal = 0; $zilnic = 0; $i=10; //if(date("D",mktime (0,0,0,date("m"),date("d"), date("Y")))=="Sun") // if(strftime("%u")==7 AND strftime("%e")<=7) { $prima_duminica_din_luna = 1; $limitare = " LIMIT 0,10 ";} if (strftime("%u")==7) { $saptamanal=1; $limitare = " LIMIT 0,10 ";} else { $zilnic=1; $limitare = " LIMIT 0,10 ";} //$prima_duminica_din_luna = 0; //$saptamanal = 0; //$zilnic = 0; //echo $zilnic; if ($zilnic) { $titlu = "
TOP 10 Partide
din in presa centrala
de azi
"; echo "$titlu
"; $interogare=mysql_query(" SELECT g.id, g.numelista, g.azi, (SELECT info.ps_id FROM info2007.nuke_photoshare_images info WHERE g.numelista=info.ps_title AND info.ps_parentfolder = 94) FROM ( select c.id, c.numelista, SUM(IF(t.data=date(now()),t.articole,0)) as azi FROM toppartide t join cautari c ON t.idcautare=c.id GROUP BY c.numelista ORDER BY azi DESC, c.numelista ASC LIMIT 0,10 ) g ORDER BY g.azi DESC, g.numelista DESC; "); /* $interogare=mysql_query(" SELECT g.id, g.numelista, g.azi FROM ( select c.id, c.numelista, SUM(IF(t.data=date(now()),t.articole,0)) as azi from toppartide t join cautari c ON t.idcautare=c.id GROUP BY c.numelista ORDER BY azi DESC, c.numelista ASC LIMIT 0,10 ) g ORDER BY g.azi DESC, g.numelista DESC; "); */ // echo mysql_errno().": ".mysql_error()."
"; echo "
$status :: $nume_azi Ieri:$ieri // Azi:$i_azi
"; $i_azi=1; while (list($id,$nume_azi,$azi,$poza)= mysql_fetch_array($interogare)) { $link_lista = "".$nume_azi.""; $i_ieri=1; $gasit=0; $interogare2=mysql_query(" SELECT g.id, g.numelista,g.ieri FROM ( select c.id, c.numelista, SUM(IF(t.data=DATE_SUB(date(now()),INTERVAL '1 1:1:1' DAY_SECOND),t.articole,0)) as ieri from toppartide t INNER join cautari c ON t.idcautare=c.id GROUP BY c.numelista ORDER BY ieri DESC, c.numelista ASC ) g ORDER BY g.ieri DESC, g.numelista DESC; "); while (list($id,$nume_ieri,$ieri0)= mysql_fetch_array($interogare2)) { if($nume_azi==$nume_ieri) { if($i_ieri<$i_azi) {$status = "jos";} if($i_ieri>$i_azi) {$status = "sus";} if($i_ieri==$i_azi) {$status = "stationar";} $gasit=1; $ieri=$i_ieri; } $i_ieri+=1; } if($gasit==0) {$status = "sus"; $ieri=$i_ieri;} if($ieri>=100) $ieri="-"; /* echo ""; */ echo " "; } echo "
$status :: $nume_azi Ieri:$ieri // Azi:$i_azi
"; if(!empty($poza)) echo "\"$nume_azi\"
".$link_lista.""; else echo "
".$nume_azi.""; echo"
".$i_azi++ ."

(ieri:$ieri)

click pentru detalii ... "; // echo mysql_errno().": ".mysql_error()."
"; // echo $num = mysql_numrows($interogare); } else if ($saptamanal) { //echo mysql_errno().": ".mysql_error()."
"; $titlu = "
TOP 10 Partide
in presa centrala
din ultima saptamana!
"; ////START SAPTAMANAL ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// echo "$titlu
"; $interogare=mysql_query(" SELECT g.id, g.numelista, g.azi, (SELECT info.ps_id FROM info2007.nuke_photoshare_images info WHERE g.numelista=info.ps_title AND info.ps_parentfolder = 94) FROM ( select c.id, c.numelista, SUM(IF(t.data>=DATE_SUB(CURDATE(),INTERVAL 7 DAY),t.articole,0)) as azi from toppartide t join cautari c ON t.idcautare=c.id GROUP BY c.numelista ORDER BY azi DESC, c.numelista ASC LIMIT 0,10 ) g ORDER BY g.azi DESC, g.numelista DESC; "); // echo mysql_errno().": ".mysql_error()."
"; echo " "; $i_azi=1; while (list($id,$nume_azi,$azi,$poza)= mysql_fetch_array($interogare)) { $link_lista = "".$nume_azi.""; $i_ieri=1; $gasit=0; $interogare2=mysql_query(" SELECT g.id, g.numelista,g.ieri FROM ( select c.id, c.numelista, SUM(IF(t.data between DATE_SUB(CURDATE(),INTERVAL 14 DAY) AND DATE_SUB(CURDATE(),INTERVAL 7 DAY),t.articole,0)) as ieri from toppartide t join cautari c ON t.idcautare=c.id GROUP BY c.numelista ORDER BY ieri DESC, c.numelista ASC ) g ORDER BY g.ieri DESC, g.numelista DESC; "); // echo mysql_errno().": ".mysql_error()."
"; while (list($id,$nume_ieri,$ieri0)= mysql_fetch_array($interogare2)) { if($nume_azi==$nume_ieri) { if($i_ieri<$i_azi) {$status = "jos";} if($i_ieri>$i_azi) {$status = "sus";} if($i_ieri==$i_azi) {$status = "stationar";} $gasit=1; $ieri=$i_ieri; } $i_ieri+=1; } if($gasit==0) {$status = "sus"; $ieri=$i_ieri;} if($ieri>=100) $ieri="-"; /* echo ""; */ echo " "; } echo "
$status :: $nume_azi Ieri:$ieri // Azi:$i_azi
"; if(!empty($poza)) echo "\"$nume_azi\"
".$link_lista.""; else echo "
".$nume_azi.""; echo"
".$i_azi++ ."

(ieri:$ieri)

click pentru detalii ...
"; //////// END SAPTAMANAL ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// } else if ($prima_duminica_din_luna) { ////START LUNAR ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $titlu = "
TOP 10
consemnari
in presa centrala
din ultima luna!
"; echo "$titlu
"; $interogare=mysql_query(" SELECT g.id, g.numelista, g.azi, (SELECT info.ps_id FROM info2007.nuke_photoshare_images info WHERE g.numelista=info.ps_title AND info.ps_parentfolder = 94) FROM ( select c.id, c.numelista, SUM(IF(t.data>=DATE_SUB(CURDATE(),INTERVAL 1 MONTH),t.articole,0)) as azi from toppartide t join cautari c ON t.idcautare=c.id GROUP BY c.numelista ORDER BY azi DESC, c.numelista ASC LIMIT 0,10 ) g ORDER BY g.azi DESC, g.numelista DESC; "); // echo mysql_errno().": ".mysql_error()."
"; echo " "; $i_azi=1; while (list($id,$nume_azi,$azi,$poza)= mysql_fetch_array($interogare)) { $link_lista = "".$nume_azi.""; $i_ieri=1; $gasit=0; $interogare2=mysql_query(" SELECT g.id, g.numelista,g.ieri FROM ( select c.id, c.numelista, SUM(IF(t.data between DATE_SUB(CURDATE(),INTERVAL 2 MONTH) AND DATE_SUB(CURDATE(),INTERVAL 1 MONTH),t.articole,0)) as ieri from toppartide t join cautari c ON t.idcautare=c.id GROUP BY c.numelista ORDER BY ieri DESC, c.numelista ASC ) g ORDER BY g.ieri DESC, g.numelista DESC; "); // echo mysql_errno().": ".mysql_error()."
"; while (list($id,$nume_ieri,$ieri0)= mysql_fetch_array($interogare2)) { if($nume_azi==$nume_ieri) { if($i_ieri<$i_azi) {$status = "jos";} if($i_ieri>$i_azi) {$status = "sus";} if($i_ieri==$i_azi) {$status = "stationar";} $gasit=1; $ieri=$i_ieri; } $i_ieri+=1; } if($gasit==0) {$status = "sus"; $ieri=$i_ieri;} if($ieri>=100) $ieri="-"; /* echo ""; */ echo " "; } echo "
$status :: $nume_azi Ieri:$ieri // Azi:$i_azi
"; if(!empty($poza)) echo "\"$nume_azi\"
".$link_lista.""; else echo "
".$nume_azi.""; echo"
".$i_azi++ ."

(ieri:$ieri)

click pentru detalii ...
"; //////// END LUNAR ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// } $link = mysql_connect("localhost","info","55t6y7"); mysql_select_db("info2007",$link); $link = mysql_connect("localhost","info","55t6y7"); mysql_select_db("revistapresei",$link); } include("footer.php"); ?>