".$dilltitre.""; $link = mysql_pconnect("tecfa2.unige.ch","nobody","") or die( "Unable to connect to SQL server"); mysql_select_db('campus', $link) or die ( "Unable to select database"); if (! isset($order_key)) { $order_key="BeginningProject DESC"; } # TETRE POUR PLUS TARD, POUR LES QUERY if (isset($mode) && $mode =='query_result') { $from_list = array("Objects"); $join_list = array(); if (isset($Themes)) { $multi_criteria++; echo "THEMES
"; $from_list[] = "Objects_Themes"; $join_list[] = "Objects_Themes.ObjectId =Objects.Id"; $tt = array(); $i=0; while ($i < sizeOf($Themes)) { $tt[] = "Objects_Themes.ThemeId = ". $Themes[$i]; $i++; } if (sizeOf($tt > 0)) { $themes_query = join($tt, " OR "); } else { $themes_query = ""; } } if (isset($Types)) { echo "TYPES
"; $from_list[] = "Objects_Types"; $join_list[] = "Objects_Types.ObjectId = Objects.Id"; $tt = array(); $i=0; while ($i < sizeOf($Types)) { $tt[] = "Objects_Types.TypeId = ". $Types[$i]; $i++; } if (sizeOf($tt > 0)) { $types_query = "(". join($tt, " OR ").")"; } else { $types_query = ""; } } if (isset($Keywords)) { echo "KEYS
"; } if (isset($Creators)) { echo "CREATORS
"; } if (isset($MetadocumentAuthors)) { echo "METAAUTHORS
"; } if (isset($Types) && isset($Themes)) { $types_themes = " AND "; } else { $types_themes = " "; } if (isset($Themes) && isset($Keywords)) { $themes_keywords = " AND "; } else { $themes_keywords = " "; } $query = "SELECT * FROM " . join($from_list,',') . " WHERE $types_query ". $types_themes ." $themes_query AND " . join($join_list, ' AND '); # echo $query; $objects = mysql_query($query); } # PASSE TOUJOURS PAR LA POUR L'INSTANT else { if (isset($personId)) { $objects = mysql_query("select * FROM Objects WHERE MetadocumentAuthorId=$personId ORDER BY $order_key DESC"); } elseif (isset($quantite)) { $objects = mysql_query("select * FROM Objects ORDER BY $order_key DESC LIMIT $quantite"); } elseif (isset ($letitre)) { $objects = mysql_query("select * FROM Objects WHERE Title like '%$letitre%' ORDER BY $order_key "); } elseif (isset ($auteurtecfa)) { $objects = mysql_query("select * FROM Objects, Objects_AuthorTecfa WHERE Objects_AuthorTecfa.AuthorTecfaId = $auteurtecfa AND Objects.Id=Objects_AuthorTecfa.ObjectId ORDER BY $order_key DESC "); } elseif (isset ($PreciseId)) { $objects = mysql_query("select * FROM Objects WHERE Id=$PreciseId"); } elseif (isset ($motclef)) { if (!isset($lang)) { die("Retournez en arrière et choisissez une langue!"); } $query="select * FROM Objects, Objects_Keywords, Keywords WHERE Keywords.Key$lang like '%$motclef%' AND Keywords.Id = Objects_Keywords.KeywordId AND Objects_Keywords.ObjectId = Objects.Id ORDER BY Objects.$order_key "; $objects = mysql_query($query); # echo $query; } elseif (isset ($auteur)){ if (isset ($motcle)){ if (!isset($lang)) { die("Retournez en arrière et choisissez une langue!"); } $query="select * FROM Objects, Objects_Keywords, Keywords, Objects_AuthorTecfa WHERE Keywords.Key$lang like '%$motcle%' AND Keywords.Id = Objects_Keywords.KeywordId AND Objects_Keywords.ObjectId = Objects.Id AND Objects_AuthorTecfa.AuthorTecfaId = $auteur AND Objects.Id=Objects_AuthorTecfa.ObjectId AND Objects.EndProject 0) { echo ""; $i=0; while ($i < mysql_num_rows($objects)) { $CurrId=mysql_result($objects,$i,'Id'); echo ""; echo "\n"; echo ""; echo ""; echo "\n"; $CurrTitle=mysql_result($objects,$i,'Title'); echo "\n"; echo ""; $link = mysql_pconnect("tecfa2.unige.ch","nobody","") or die( "Unable to connect to SQL server"); mysql_select_db('campus', $link) or die ( "Unable to select database"); $Objects_Types= mysql_query("SELECT * FROM Objects_Types WHERE ObjectId=$CurrId ORDER BY TypeId"); $CurrClassFrench = array(); $CurrSubClassFrench = array(); $CurrItemFrench =array(); $Total =array(); $Objects_Themes= mysql_query("SELECT * FROM Objects_Themes WHERE ObjectId=$CurrId"); echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; $link = mysql_pconnect("tecfa2.unige.ch","nobody","") or die( "Unable to connect to SQL server"); mysql_select_db('campus', $link) or die ( "Unable to select database"); # MONTRE LES DÉTAILS if (isset($details) && $details==1 && $detailId==$CurrId) { # echo "\n"; $zequeryAuthorTecfa=mysql_query("SELECT * FROM Objects_AuthorTecfa WHERE ObjectId=$CurrId"); echo ""; echo "\n"; echo "\n"; echo ""; $zequeryAuthorExt=mysql_query("SELECT * FROM Objects_AuthorExternal WHERE ObjectId=$CurrId"); echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; $zequeryKeywords=mysql_query("SELECT * FROM Objects_Keywords WHERE ObjectId=$CurrId"); echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo ""; # PreciseId echo ""; echo "\n"; echo "\n"; echo ""; } $i++; } echo "
"; echo "Edit
Titre $CurrTitle "; echo " \n"; echo "
Themes"; $k=0; while ($k < mysql_num_rows($Objects_Themes)) { $CurrThemeId= mysql_result($Objects_Themes,$k,'ThemeId'); $TypesD = mysql_query("SELECT * FROM Themes WHERE Id=$CurrThemeId"); echo mysql_result($TypesD,0,'GroupFrench').": "; echo mysql_result($TypesD,0,'TitleFrench'); echo "
"; $k++; } echo "
Start".mysql_result($objects,$i,'BeginningProject')."
End".mysql_result($objects,$i,'EndProject')."
Location"; $laloc=mysql_result($objects,$i,'Location'); if (strstr($laloc, "http://")) { echo ""; } echo $laloc; if (strstr($laloc, "http://")) { echo ""; } echo "
Tecfa Author(s)"; if ($zequeryAuthorTecfa) { $zz=0; while ($zz < mysql_num_rows($zequeryAuthorTecfa)) { $QID=mysql_result($zequeryAuthorTecfa,$zz,'AuthorTecfaId'); if (getUserHomepage($QID)) { echo ""; } echo getUserRealName($QID); if (getUserHomepage($QID)) { echo ""; } echo " "; $zz++; } } $link = mysql_pconnect("tecfa2.unige.ch","nobody","") or die( "Unable to connect to SQL server"); mysql_select_db('campus', $link) or die ( "Unable to select database"); echo "
External Author(s)"; if ($zequeryAuthorExt) { $zz=0; while ($zz < mysql_num_rows($zequeryAuthorExt)) { echo mysql_result($zequeryAuthorExt,$zz,'AuthorExternal')." "; $zz++; } } echo "
Contributors".mysql_result($objects,$i,'Contributors')."
Keywords"; if ($zequeryKeywords) { $zz=0; while ($zz < mysql_num_rows($zequeryKeywords)) { $newquery=mysql_query("SELECT * FROM Keywords WHERE Id=".mysql_result($zequeryKeywords,$zz,'KeywordId')); echo mysql_result($newquery,0,'KeyFrench')." "; $zz++; } } echo "
FullReference".mysql_result($objects,$i,'FullReference')."
Abstract".mysql_result($objects,$i,'Abstract')."
Description ".mysql_result($objects,$i,'Description')."
Presentation".mysql_result($objects,$i,'Presentation')."
MimeType".mysql_result($objects,$i,'MimeType')."
Support".mysql_result($objects,$i,'Support')."
SizeOf".mysql_result($objects,$i,'SizeOf')."
Version".mysql_result($objects,$i,'Version')."
Platform".mysql_result($objects,$i,'Platform')."
Coverage".mysql_result($objects,$i,'Coverage')."
PriceCode".mysql_result($objects,$i,'PriceCode')."
Publisher".mysql_result($objects,$i,'Publisher')."
AvailabilityDate".mysql_result($objects,$i,'AvailabilityDate')."
Expiration".mysql_result($objects,$i,'ExpirationDate')."
LastModifiedDate".mysql_result($objects,$i,'LastModifiedDate')."
PublicationDate".mysql_result($objects,$i,'PublicationDate')."
Objective".mysql_result($objects,$i,'Objective')."
Prerequisite".mysql_result($objects,$i,'Prerequisite')."
Pedagogy".mysql_result($objects,$i,'Pedagogy')."
TECFAAudience"; $toutaud=explode(",",mysql_result($objects,$i,'TECFAAudience')); $q=0; while ($q < sizeOf($toutaud)) { $yaquery=mysql_query("SELECT * FROM TECFA_Audience WHERE Id =".$toutaud[$q]); echo mysql_result($yaquery,0,'Audience')." "; $q++; } # $newquery=mysql_query("SELECT * FROM TECFA_Audience WHERE Id IN(".mysql_result($objects,$i,'TECFAAudience').")"); # echo mysql_result($newquery,0,'Audience')." "; echo "
InteractivityLevel".mysql_result($objects,$i,'InteractivityLevel')."
LearningLevel".mysql_result($objects,$i,'LearningLevel')."
Structure".mysql_result($objects,$i,'Structure')."
Metametadata".mysql_result($objects,$i,'Metametadata')."
Rights".mysql_result($objects,$i,'Rights')."
Scheme".mysql_result($objects,$i,'Scheme')."
Financing".mysql_result($objects,$i,'Financing')."
BeginningProject".mysql_result($objects,$i,'BeginningProject')."
EndProject".mysql_result($objects,$i,'EndProject')."
RelatedPublications"; $zurl=explode(",",mysql_result($objects,$i,'RelatedPublications')); $o=0; while ($o< sizeOf($zurl)) { echo "".$zurl[$o]."
"; $o++; } echo "
RelatedUrl"; $zurl=explode(",",mysql_result($objects,$i,'RelatedUrl')); $o=0; while ($o< sizeOf($zurl)) { echo "".$zurl[$o]."
"; $o++; } echo "
RelatedObjects".mysql_result($objects,$i,'RelatedObjects')."
"; } else { echo "

There are no objects matching your query in the database !

"; } ?>