'; echo $title; echo '

'; if ($t=='x') echo 'Acest clasament este realizat prin combinarea mai multor factori statistici'; elseif ($t=='g') echo 'Acest clasament este realizat pe baza mediilor tuturor voturilor pentru idee'; elseif ($t=='f') echo 'Acest clasament este realizat pe baza mediilor tuturor voturilor pentru exprimare'; elseif ($t=='a') echo 'Acest clasament este realizat pe baza mediilor tuturor voturilor pentru ton'; elseif ($t=='c') echo 'Acest clasament este realizat pe baza mediilor voturilor "amuzant" şi "comic" pentru ton'; elseif ($t=='s') echo 'Acest clasament este realizat pe baza mediilor tuturor voturilor pentru ton'; elseif ($t=='t') echo 'Acest clasament este realizat pe baza mediilor voturilor "serios" şi "trist" pentru ton'; elseif ($t=='v') echo 'Acest clasament este realizat pe baza numărului de voturi date de cititori'; elseif ($t=='r') echo 'Acest clasament este realizat pe baza numărului de recomandări trimise prin e-mail'; elseif ($t=='d') echo 'Acest clasament este realizat pe baza numărului de comentarii făcute de cititori'; elseif ($t=='y') echo 'Acest clasament este realizat pe baza numărului de comentarii făcute de cititori, doar acolo unde este mai mult de un comentariu'; elseif ($t=='q') echo 'Acest clasament este realizat prin contorizarea numărului de '.$voturi_pentru.' din Citatepedia'; if ($t<>'v' and $t<>'r' and $t<>'d' and $t<>'y' and $t<>'q') { echo ' (doar autorii cu cel puţin '.$voturi_min.' voturi).

Acesta este un clasament de popularitate, nu unul de critică de specialitate.

'; $link = mysql_connect( $citatepedia_serv, $citatepedia_user, $citatepedia_pass ); if ( ! $link ) die( "Couldn't connect to MySQL" ); else { mysql_select_db( $citatepedia_data,$link ) or die ( "Couldn't open database: ".mysql_error() ); if ($t=='x') { $result = mysql_query( "SELECT SUM(recomandari) AS _recomandari FROM citatepedia WHERE recomandari>0 ".$voturi_cond." GROUP BY id ORDER BY _recomandari DESC LIMIT 1", $link ) or die ( "Couldn't select: ".mysql_error() ); $row = mysql_fetch_array( $result ); $result = mysql_query( "SELECT autor,COUNT(*) AS _count,AVG((calitate+recomandari/".($row['_recomandari']/4).")/2) AS _vot,SUM(voturi) AS _voturi FROM citatepedia WHERE voturi>0 ".$voturi_cond." GROUP BY autor HAVING _voturi>=".$voturi_min." AND _vot>0.25 ORDER BY _vot DESC,_voturi DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='g') { $result = mysql_query( "SELECT autor,COUNT(*) AS _count,AVG(voti) AS _vot,SUM(voturi) AS _voturi FROM citatepedia WHERE voturi>0 ".$voturi_cond." GROUP BY autor HAVING _voturi>=".$voturi_min." AND _vot>0.25 ORDER BY _vot DESC,_voturi DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='f') { $result = mysql_query( "SELECT autor,COUNT(*) AS _count,AVG(vote) AS _vot,SUM(voturi) AS _voturi FROM citatepedia WHERE voturi>0 ".$voturi_cond." GROUP BY autor HAVING _voturi>=".$voturi_min." AND _vot>0.25 ORDER BY _vot DESC,_voturi DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='a') { $result = mysql_query( "SELECT autor,COUNT(*) AS _count,AVG(vott) AS _vot,SUM(voturi) AS _voturi FROM citatepedia WHERE voturi>0 AND calitate>0.25 ".$voturi_cond." GROUP BY autor HAVING _voturi>=".$voturi_min." AND _vot>0.25 ORDER BY _vot DESC,_voturi DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='c') { $result = mysql_query( "SELECT autor,COUNT(*) AS _count,AVG(vott) AS _vot,SUM(voturi) AS _voturi FROM citatepedia WHERE voturi>0 AND calitate>0.25 ".$voturi_cond." AND vott>0.25 GROUP BY autor HAVING _voturi>=".$voturi_min." AND _vot>0.25 ORDER BY _vot DESC,_voturi DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='s') { $result = mysql_query( "SELECT autor,COUNT(*) AS _count,AVG(vott) AS _vot,SUM(voturi) AS _voturi FROM citatepedia WHERE voturi>0 AND calitate>0.25 ".$voturi_cond." GROUP BY autor HAVING _voturi>=".$voturi_min." AND _vot<0.25 ORDER BY _vot,_voturi DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='t') { $result = mysql_query( "SELECT autor,COUNT(*) AS _count,AVG(vott) AS _vot,SUM(voturi) AS _voturi FROM citatepedia WHERE voturi>0 AND calitate>0.25 ".$voturi_cond." AND vott<0.25 GROUP BY autor HAVING _voturi>=".$voturi_min." AND _vot<0.25 ORDER BY _vot,_voturi DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='v') { $result = mysql_query( "SELECT autor,COUNT(*) AS _count,SUM(voturi) AS _voturi FROM citatepedia WHERE voturi>0 ".$voturi_cond." GROUP BY autor HAVING _voturi>50 ORDER BY _voturi DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='r') { $result = mysql_query( "SELECT autor,COUNT(*) AS _count,SUM(recomandari) AS _recomandari FROM citatepedia WHERE recomandari>0 ".$voturi_cond." GROUP BY autor HAVING _recomandari>10 ORDER BY _recomandari DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='d') { $result = mysql_query( "SELECT autor,COUNT(*) AS _count,SUM(comentarii) AS _comentarii FROM citatepedia WHERE comentarii>0 ".$voturi_cond." GROUP BY autor HAVING _comentarii>10 ORDER BY _comentarii DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='y') { $result = mysql_query( "SELECT autor,COUNT(*) AS _count,SUM(comentarii) AS _comentarii FROM citatepedia WHERE comentarii>1 ".$voturi_cond." GROUP BY autor HAVING _comentarii>10 ORDER BY _comentarii DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } elseif ($t=='q') { if (substr($voturi_cond,0,5)==' AND ') $voturi_cond=substr($voturi_cond,5); $result = mysql_query( "SELECT autor,COUNT(*) AS _count FROM citatepedia WHERE ".$voturi_cond." GROUP BY autor HAVING _count>25 ORDER BY _count DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); } while ( $row = mysql_fetch_array( $result ) ) { echo '
1. '; if (abs($row['_vot'])>=1) echo ''; echo ''.$row['autor'].''; if (abs($row['_vot'])>=1) echo ''; echo ' ('; if ($row['_recomandari']<>'') echo $row['_recomandari'].' recomandări la '.$row['_count'].' '.$voturi_pentru; elseif ($row['_comentarii']<>'') echo $row['_comentarii'].' comentarii la '.$row['_count'].' '.$voturi_pentru; elseif ($row['_voturi']<>'') echo $row['_voturi'].' voturi la '.$row['_count'].' '.$voturi_pentru; elseif ($row['_count']<>'') echo $row['_count'].' '.$voturi_pentru; echo ')
'; } } mysql_close( $link ); echo '

Continuare...