Functionalities added to BibAdmin whose code given below:
* Main Keyword Cloud
* Keyword Clouds
* Author Photo Cloud
* Coauthor Graph
* Journal and Conference Clouds
* Program Page
* Keyword Definition



=== Main Keyword Cloud ===
in index.php
**************************
echo "
<tr>
<td>
<table width=\"750px\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
 <tr valign=\"middle\">
  <td align =\"center\" valign=\"middle\">
   <div class=\"petitnuage2\">
";

$thelinkid=@mysql_connect("$host","$login_user_db","$login_pass_db");   
$res = mysql_db_query($db_bibliography, "SELECT * FROM $tb_keywords ORDER BY `name` ASC;");
$maxnb=0;
while ($row=mysql_fetch_object($res )) {
   $newnb = mysql_num_rows(mysql_db_query($db_bibliography, "SELECT * FROM $tb_pub_to_keyw WHERE `id_keyw`='".$row->id."';"));
	 if ($newnb>$maxnb){
	    $maxnb=$newnb;
	 }
}	         
$res = mysql_db_query($db_bibliography, "SELECT * FROM $tb_keywords ORDER BY `name` ASC;");
while ($row=mysql_fetch_object($res )) {
   $res2 = mysql_db_query($db_bibliography, "SELECT * FROM $tb_pub_to_keyw WHERE `id_keyw`='".$row->id."';");
	 $coeff = mysql_num_rows($res2);
	 echo "<a href=\"http://www.lirmm.fr/~gambette/PhylogeneticNetworks/show.php?keyword=".str_replace(" ","%20",$row->name)."\" class=\"level".(floor(10*log(1+$coeff)/log(1+$maxnb )))."\">".str_replace(" ","-",$row->name)."(".$coeff.")</a> ";
}	         
echo "
   </div>";
**************************
It uses the following CSS code for "petitnuage2":
++++++++++++++++++++++++++
.petitnuage2  {line-height:18px;font: normal small verdana, arial, helvetica, sans-serif; text-align: justify; border:0px #B6CDE1; padding:10px; position:relative;
width:100%}
.petitnuage2 a {text-decoration:none}
.petitnuage2 a:hover {color: white; background-color: #668AA8;}
.petitnuage2 a.level0 {font-size:8px;color:#DFDFDF;}
.petitnuage2 a.level1 {font-size:9px;color:#B8C9D6;}
.petitnuage2 a.level2 {font-size:10px;color:#668AA8;}
.petitnuage2 a.level3 {font-size:11px;color:#47657B;}
.petitnuage2 a.level4 {font-size:12px;color:#E76300;}
.petitnuage2 a.level5 {font-size:13px;color:#E76300;}
.petitnuage2 a.level6 {font-size:14px;color:#E76300;}
.petitnuage2 a.level7 {font-size:15px;color:#E76300;font-weight: bold}
.petitnuage2 a.level8 {font-size:16px;color:#E76300;font-weight: bold}
.petitnuage2 a.level9 {font-size:17px;color:#E76300;font-weight: bold}
.petitnuage2 a.level10 {font-size:18px;color:#FF3300;font-weight: bold}
.petitnuage_titre {font: normal small verdana, arial, helvetica, sans-serif; font-size:10px;color:gray; font-style:italic;}
++++++++++++++++++++++++++



=== Keyword Clouds ===
in show.php, in the part about author pages, after the "titlu" line:
**************************
$kwarray=array();
	 $res = mysql_db_query($db_bibliography, "SELECT * FROM $tb_pub_to_auth WHERE id_author='".$author_id."';");
   while ($row = mysql_fetch_object($res)){
      $ress2 = mysql_db_query($db_bibliography,"SELECT * FROM ".$tb_pub_to_keyw." WHERE id_pub=".$row->id_pub.";");
      while ($row2 = mysql_fetch_object($ress2)){
         if (array_key_exists($row2->id_keyw,$kwarray)){
              $kwarray[$row2->id_keyw]++;
         } else {
              $kwarray[$row2->id_keyw]=1;
         }
      }
   }

$maxnb=0;
$thekeywords=array();
foreach ($kwarray as $word_id => $value) {
    $ress=mysql_db_query($db_bibliography,"SELECT * FROM ".$tb_keywords." WHERE id=".$word_id.";");
    while ($row = mysql_fetch_object($ress)){
        $thekeywords[$row->name]=$value;
        if ($value>$maxnb){$maxnb=$value;}
    }
}

function insensitive_uksort($a,$b) { 
    return strtolower($a)>strtolower($b); 
} 
uksort($thekeywords, "insensitive_uksort");

if (count($thekeywords)>0){

titlu("center", "$subt_col", "000000", "<b>Associated keywords</b>".$top_btn);

echo "
<tr> 
   <td> 
    <table width=\"750px\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
     <tr valign=\"middle\"> 
      <td align =\"center\" valign=\"middle\"> 
       <div class=\"petitnuage2\">";


foreach ($thekeywords as $word => $value) {
    if ($maxnb<6) {$value=$value/2;}
    echo "<a href=\"http://www.lirmm.fr/~gambette/PhylogeneticNetworks/show.php?keyword=".str_replace(" ","%20",$word)."\" title=\"".$value."\" class=\"level".(floor(10*log(1+$value)/log(1+$maxnb )))."\">".str_replace(" ","-",$word)."</a> ";
}

echo "       </div>
      </td> 
     </tr> 
    </table> 
   </td> 
  </tr> 
	     ";
	       
}		  
**************************
in show.php, in the part about keyword pages, after line "$keyword = str_replace(",", "','", $keyword);".
**************************
titlu("center", "$subt_col", "000000", "<b>Associated keywords</b>".$top_btn);

echo "
<tr> 
   <td> 
    <table width=\"750px\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
     <tr valign=\"middle\"> 
      <td align =\"center\" valign=\"middle\"> 
       <div class=\"petitnuage2\">";


$keywordsid="";
for ($i=0; $i<count($keywords); $i++) {
$ress=mysql_db_query($db_bibliography,"SELECT * FROM ".$tb_keywords." WHERE name='".$keywords[$i]."';");
   while ($row = mysql_fetch_object($ress)){
       if ($i>0){
       $keywordsid=$keywordsid.",".$row->id;
       } else {
       $keywordsid=$row->id;
       }
   }
}

$kwarray=array();

   $ress = mysql_db_query($db_bibliography,"SELECT * FROM ".$tb_pub_to_keyw." WHERE id_keyw in ('".$keywordsid."') GROUP BY id_pub;");
   while ($row = mysql_fetch_object($ress)){
      $ress2 = mysql_db_query($db_bibliography,"SELECT * FROM ".$tb_pub_to_keyw." WHERE id_pub=".$row->id_pub.";");
      while ($row2 = mysql_fetch_object($ress2)){
         if (array_key_exists($row2->id_keyw,$kwarray)){
              $kwarray[$row2->id_keyw]++;
         } else {
              $kwarray[$row2->id_keyw]=1;
         }
      }
   }

$maxnb=0;
$thekeywords=array();
foreach ($kwarray as $word_id => $value) {
    $ress=mysql_db_query($db_bibliography,"SELECT * FROM ".$tb_keywords." WHERE id=".$word_id.";");
    while ($row = mysql_fetch_object($ress)){
        $thekeywords[$row->name]=$value;
        if ($value>$maxnb){$maxnb=$value;}
    }
}

function insensitive_uksort($a,$b) { 
    return strtolower($a)>strtolower($b); 
} 
uksort($thekeywords, "insensitive_uksort");


foreach ($thekeywords as $word => $value) {
    if ($maxnb<6) {$value=$value/2;}
    echo "<a href=\"http://www.lirmm.fr/~gambette/PhylogeneticNetworks/show.php?keyword=".str_replace(" ","%20",$word)."\" title=\"".$value."\" class=\"level".(floor(10*log(1+$value)/log(1+$maxnb )))."\">".str_replace(" ","-",$word)."</a> ";
}

echo "       </div>
      </td> 
     </tr> 
    </table> 
   </td> 
  </tr> 
	     ";
**************************



=== Author Photo Cloud ===
in index.php
Table $tb_authors now contains the 2 following fields to store the original picture URL and the local picture (100px*100px) URL:
- picture varchar(255)
- formattedpicture varchar(255)
**************************
<table width=\"750px\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
 <tr valign=\"middle\">
  <td align =\"center\" valign=\"middle\">
  
    <div class=\"petitnuage2\">
";
     $linkid=@mysql_connect("$host","$login_user_db","$login_pass_db");     
     $res = mysql_db_query($db_bibliography, "SELECT * FROM $tb_authors WHERE `picture`!='' ORDER BY `name` ASC;");
     if (mysql_num_rows($res) > 0){
	         while ($row=mysql_fetch_object($res )) {
	            $res2 = mysql_db_query($db_bibliography, "SELECT * FROM $tb_pub_to_auth WHERE `id_author`='".$row->id."' AND `tip`='a';");
	            $coeff = 0;
	            while ($row2=mysql_fetch_object($res2)) {
	               $res3 = mysql_db_query($db_bibliography, "SELECT * FROM $tb_pub_to_auth WHERE `id_pub`='".$row2->id_pub."' AND `tip`='a';");
	               $coeff += 10/mysql_num_rows($res3);
   	          }
              if ($coeff>0){
	            echo "<a href=
	            \"./show.php?author_id=".$row->id.
	            "\"><img src=\"".$row->formattedpicture."\" border=\"0\" width=\"".(floor(11+20*log(1+$coeff)))."px\" alt=\"".($row->surname." ".$row->name)."\" title=\"".($row->surname." ".$row->name)."\"></a>";     
	            }
	            //echo "<a href=\"http://www.google.com/search?q=".$row->name."\" class=\"level".rand(1,10)."\">".$row->name."</a> ";     
	            //\"".(!empty($row->homepage)? ("./show.php?author_id=".$row->id):"http://www.google.com/search?q=".$row->surname." ".$row->name).
       }
        }
  mysql_free_result($res);
	mysql_close($linkid);
  echo "
    </div>
    <div class=\"petitnuage_titre\">Authors present in the database (size representing the number of publications, weighted by the number of coauthors on each publication)<br></div>
  </td>
 </tr>
</table>    
**************************



=== Coauthor Graph ===
in new page coauthor.php
it uses the JAVA applet available on http://java.sun.com/applets/jdk/1.4/demo/applets/GraphLayout/Graph.class
**************************
echo '<h2>Coauthor graph in 2007</h2>';
//<!--codebase=""-->
echo '<APPLET code="Graph.class" 
codebase="http://java.sun.com/applets/jdk/1.4/demo/applets/GraphLayout/"
height=400 width=800><PARAM NAME="edges" VALUE="';

$res = mysql_db_query($db_bibliography, "SELECT * FROM $tb_authors WHERE 1 ORDER BY name;");
$premier = 1;
while ($row=mysql_fetch_object($res )) {
   $array=array();
   $i=1;
   $leprenom=$row->surname;
   $thename=str_replace(" ","",str_replace("-","",$leprenom{0}.$row->name));
   $res2 = mysql_db_query($db_bibliography, "SELECT * FROM $tb_pub_to_auth WHERE `id_author`='".$row->id."' and `tip`='a';");
   $nbres2 = mysql_num_rows($res2);
   if ($nbres2>1){
      while ($row2=mysql_fetch_object($res2)) {
         if (mysql_num_rows(mysql_db_query($db_bibliography, "SELECT * FROM $tb_publications WHERE `id`='".$row2->id_pub."' and year<2008;"))>0){
         $res3 = mysql_db_query($db_bibliography, "SELECT * FROM $tb_pub_to_auth WHERE `id_pub`='".$row2->id_pub."';");         
         while ($row3=mysql_fetch_object($res3)) {
         $res4 = mysql_db_query($db_bibliography, "SELECT * FROM $tb_authors WHERE `id`='".$row3->id_author."';");
         $row4=mysql_fetch_object($res4);
            if (!array_key_exists($row4->name,$array)){
               $array[$row4->name]=1;
               $leprenom2=$row4->surname;
               $theother=str_replace(" ","",str_replace("-","",$leprenom2{0}.$row4->name));
               if (strnatcmp($thename,$theother)<0){
                  $res5 = mysql_db_query($db_bibliography, "SELECT * FROM $tb_pub_to_auth WHERE `id_author`='".$row4->id."' and `tip`='a';");
                  if ((mysql_num_rows($res5)>2) && ($nbres2>2))
                     if ($premier==1){
                        echo $thename.'-'.$theother.'/'.(25+15*$i);
                        $premier=0;
                     }                         
                     else
                        echo ','.$thename.'-'.$theother.'/'.(25+15*$i);
                   $i++;
               }
            }
         }
         }
      }
   }
}
echo '"></APPLET> ';
**************************



=== Journal and Conference Cloud ===
in show.php
**************************
	     if ($entry_type=="InProceedings")
	     {
	     echo "
<tr> 
   <td> 
    <table width=\"750px\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
     <tr valign=\"middle\"> 
      <td align =\"center\" valign=\"middle\"> 
       <div class=\"petitnuage2\">
";
       $res = mysql_db_query($db_bibliography, "SELECT DISTINCT booktitle FROM $tb_publications WHERE entry_type='$entry_type' ORDER BY booktitle ASC;");
       while ($row = mysql_fetch_object($res )){
       
           $res2 = mysql_db_query($db_bibliography, "SELECT * FROM $tb_publications WHERE `booktitle`='".mysql_real_escape_string($row->booktitle)."';");
	         $coeff = mysql_num_rows($res2);
	         echo "<a href=\"http://www.lirmm.fr/~gambette/PhylogeneticNetworks/browse.php?q=".htmlentities($row->booktitle)."\" class=\"level".(2*$coeff)."\">";
           if (strpos($row->booktitle,")")){
               $text=str_replace(")","",str_replace("(","",strstr($row->booktitle,"(")));
               echo str_replace(" ","-",$text)."(".$coeff.")</a> ";
           } else {
               echo str_replace(" ","-",$row->booktitle)."(".$coeff.")</a> ";
           }
       }


echo
"       </div>
      </td> 
     </tr> 
    </table> 
   </td> 
  </tr> 
	     ";
	     }
	     elseif ($entry_type=="Article (Journal)")
	     {
	     echo "
<tr> 
   <td> 
    <table width=\"750px\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
     <tr valign=\"middle\"> 
      <td align =\"center\" valign=\"middle\"> 
       <div class=\"petitnuage2\">
";
       $res = mysql_db_query($db_bibliography, "SELECT DISTINCT journal FROM $tb_publications WHERE entry_type='$entry_type' ORDER BY journal ASC;");
       while ($row = mysql_fetch_object($res )){
       
           $res2 = mysql_db_query($db_bibliography, "SELECT * FROM $tb_publications WHERE `journal`='".mysql_real_escape_string($row->journal)."';");
	         $coeff = mysql_num_rows($res2);
	         echo "<a href=\"http://www.lirmm.fr/~gambette/PhylogeneticNetworks/browse.php?q=".htmlentities($row->journal)."\" class=\"level".min(10,($coeff))."\">";
           if (strpos($row->journal,")")){
               $text=str_replace(")","",str_replace("(","",strstr($row->journal,"(")));
               echo str_replace(" ","-",$text)."(".$coeff.")</a> ";
           } else {
               echo str_replace(" ","-",$row->journal)."(".$coeff.")</a> ";
           }
       }


echo
"       </div>
      </td> 
     </tr> 
    </table> 
   </td> 
  </tr> 
	     ";
	     }
**************************



=== Program Page ===
in show.php
**************************
else if (!empty($keyword) && ($keyword=='programs')) {
     
       //Show by programs
	 $titlul = '<b>Programs to compute, evaluate, compare, visualize...
	 <a href="http://www.lirmm.fr/~gambette/show.php?keyword=phylogenetic network">phylogenetic networks</a>.<br>
	 </b><font size=\"2\"><i>This page is automatically built from all publications
	 tagged by Program* in the <a href="http://www.lirmm.fr/~gambette/PhylogeneticNetworks/show.php?type=html&amp;ord=year">database</a>.</i></font><b>';
   titlu("left", "$title_bg", "FFFFFF", $titlul . "</b></font> &nbsp;
     </td>
     <td align=\"right\">
      <font>");
       require_once('./fc_enum.php');

//    echo "   <table cellpadding=\"0\" cellspacing=\"10\" border=\"0\" width=\"100%\">";
      
      echo "</table>";
   $res = mysql_db_query($db_bibliography, "SELECT * FROM $tb_keywords WHERE `name` LIKE 'Program%' ORDER BY `name`;");
   while ($row=mysql_fetch_object($res )){
     $res2 = mysql_db_query($db_bibliography, "SELECT * FROM $tb_pub_to_keyw WHERE `id_keyw`='$row->id';");

    echo "
        <table cellpadding=\"0\" cellspacing=\"10\" border=\"0\" width=\"100%\">
        <tr>
         <td align=\"center\" class=\"tit\"> 
         <b><a href=\"$show_sc?keyword=".$row->name."\" title=\"Show publications on ".$row->name."\" class=\"subl\">".$row->name."</a></b>
         </td>
        </tr>
			  <tr>
			    <td valign=\"top\">
			    ".$row->about."
			    ";
	  if (mysql_num_rows($res2)>1){
	  echo  "			    <br><i><font size=2><a class=\"subl\" href=\"$show_sc?keyword=".$row->name."\">".mysql_num_rows($res2)." publications in the database mention ".$row->name."</a></font></i>
	  ";}
	  else{
	  echo  "			    <br><i><font size=2><a class=\"subl\" href=\"$show_sc?keyword=".$row->name."\">".mysql_num_rows($res2)." publication in the database mentions ".$row->name."</a></font></i>
	  ";
	  }
    echo  "
  		    </td>
			  </tr>
			  </table>
			  ";
		}
    echo "           <table cellpadding=\"0\" cellspacing=\"10\" border=\"0\" width=\"100%\">";





     
     } 
**************************



=== Keyword Defintion ===
in show.php, a few lines after "} else if (!empty($keyword)) {"
**************************
	 $lin .= (empty($lin)?"":",").$keywords[$i];
	 $titlul .= "'<a href=\"$show_sc?keyword=".$lin."&amp;op=".($operation)."\" title=\"Related to keywords: ".$lin."\">".$keywords[$i]."</a>'".
	   (empty($user) ? "":"<a href=\"$edit_sc?keyword=".$keywords[$i]."\" title=\"Edit keyword  ".$keywords[$i]."\"><img src=\"images/ed.gif\" alt=\"Edit\" height=\"12px\" width=\"12px\" border=\"0\"></a>").
	   (empty($row->about) ? "<br>":" : <font size=\"2\">".$row->about."</font><br>");
**************************