Assignments as part of Msc Human Media Interaction

".$keywords.""; $subquery1="MATCH(opdracht.omschrijving) AGAINST('".$keywords."')"; $titelquery="(".$subquery1." OR titel LIKE '%".$keywords."%')"; $order="score desc, titel"; } if ($opdrachtsoort != "alletypes") { $subquery2.=" AND VERTALING.doelkort = '".$opdrachtsoort."'"; $assignmentsoort=$opdrachtsoort; } if ($keuze != "allelanden") { if (strncmp($keuze,"country",7) == 0) { $country=substr($keuze,7); $subquery2=$subquery2." AND instituten.land = '".$country."'"; $keywordsecho=$keywordsecho." located in '".$country."'"; if ($order != "") { $order.=", "; } $order.="opdracht.voltooid desc, instituten.naam"; } else { $deelinstituut=explode("|",$keuze); // echo "
".var_dump($deelinstituut)."
"; $subquery2=$subquery2." AND instituten.ID = ".$deelinstituut[0]; $keywordsecho=$keywordsecho." from institute '".$deelinstituut[1]."'"; if ($order != "") { $order.=", "; } $order.="opdracht.voltooid desc, instituten.naam"; } } else { if ($order != "") { $order.=", "; } $order.="instituten.land, opdracht.voltooid desc, instituten.naam"; } echo "

Open ".$assignmentsoort." assignments

\n"; echo utf8_decode("Results of search-query to find open ".$assignmentsoort." assignments ".$keywordsecho.": \n"); $query="SELECT ".$subquery1." as score, opdracht.*, instituten.naam as instituutnaam, instituten.land as instituutland, VERTALING.* FROM opdracht, VERTALING, instituten, opdrachten_instituten WHERE ".$titelquery." AND VERTALING.bron = opdracht.soort AND opdrachten_instituten.opdrachtID = opdracht.ID AND instituten.ID = opdrachten_instituten.instituutID AND opdrachten_instituten.soort = opdracht.soort AND opdracht.voltooid = 'false' AND instituten.actiefcontact = 'true' AND opdracht.persoonID = 0 AND ".$subquery2." ORDER by ".$order." LIMIT ".$limit; // echo "
".$query."
"; $result=sqlquery($query); if ($result) { $row=$result[0]; echo "
    \n"; foreach($result as $key => $row) { echo "
  • \n"; echo ''; if ($row["score"] != 1 && $row["score"] != 0) { echo "\n"; } echo "\n"; echo "\n"; $woorden=explode(" ",utf8_decode($row["omschrijving"])); $lengte=0; $i=0; echo "\n"; echo "
    Score:".substr($row["score"],0,5)."
    Title:".utf8_decode($row["titel"])."
    Location:".utf8_decode($row["instituutnaam"])."\n"; if (strlen($row["instituutland"]) != 0) { echo " (".utf8_decode($row["instituutland"]).")\n"; } echo "
    \n"; while ($lengte < 100 && $i < count($woorden)) { echo $woorden[$i]; echo " "; $lengte += strlen($woorden[$i]); $i++; } echo "...
    \n"; echo "
  • \n"; } echo "
\n"; if ($order == "RAND()") { echo '
NB: The order of open assignments is at random(). A [Refresh] of this webpage will show more assignments (if available)'; } if (sizeof($result) == 5 ) { $limitarr=explode(",",$limit); if (sizeof($limitarr) == 2) { $startlimit=$limitarr[0]+$limitarr[1]; } else { $startlimit=5; } $limit=$startlimit.",5"; $c='master/?ixcommand='.urlencode($command).'&ixkeywords='.urlencode($keywords).'&ixopdrachtsoort='.urlencode($opdrachtsoort).'&ixkeuze='.urlencode($keuze).'&ixlimit='.urlencode($limit); echo '
Next 5 assignments >> '; } } else { echo "
    \n"; echo "No open assignments found.\n"; echo "
\n"; // echo "
"; echo "

Current-running or Closed ".$assignmentsoort." assignments

\n"; echo utf8_decode("Results of search-query to find current-running or closed ".$assignmentsoort." assignments ".$keywordsecho.": \n"); $query="SELECT ".$subquery1." as score, opdracht.*, opdracht.ID as opdrachtID, instituten.naam as instituutnaam, instituten.land as instituutland, VERTALING.* FROM opdracht, VERTALING, instituten, opdrachten_instituten WHERE ".$subquery1." AND VERTALING.bron = opdracht.soort AND opdrachten_instituten.opdrachtID = opdracht.ID AND instituten.ID = opdrachten_instituten.instituutID AND opdrachten_instituten.soort = opdracht.soort AND instituten.actiefcontact = 'true' AND ".$subquery2." ORDER by ".$order." LIMIT ".$limit; // echo "
".$query."
"; $result=sqlquery($query); if ($result) { $row=$result[0]; echo "
    \n"; foreach($result as $key => $row) { echo "
  • \n"; echo ''; if ($row["score"] != 1 && $row["score"] != 0) { echo "\n"; } echo "\n"; echo "\n"; $woorden=explode(" ",utf8_decode($row["omschrijving"])); $lengte=0; $i=0; echo "\n"; echo "
    Score:".substr($row["score"],0,5)."
    Title:".utf8_decode($row["titel"])."
    Location:".utf8_decode($row["instituutnaam"]); if (strlen($row["instituutland"]) != 0) { echo " (".utf8_decode($row["instituutland"]).")\n"; } echo "
    Status:"; if ($row["voltooid"] == 'true') { echo "Closed"; } else { echo "Running"; } echo "
    "; while ($lengte < 100 && $i < count($woorden)) { echo $woorden[$i]; echo " "; $lengte += strlen($woorden[$i]); $i++; } echo "...
    \n"; echo "
  • \n"; } echo "
\n"; if ($order == "RAND()") { echo '
NB: The order of running or closed assignments is at random(). A [Refresh] of this webpage will show more assignments (if available)'; } if (sizeof($result) == 5 ) { $limitarr=explode(",",$limit); if (sizeof($limitarr) == 2) { $startlimit=$limitarr[0]+$limitarr[1]; } else { $startlimit=5; } $limit=$startlimit.",5"; $c='master/?ixcommand='.urlencode($command).'&ixkeywords='.urlencode($keywords).'&ixopdrachtsoort='.urlencode($opdrachtsoort).'&ixkeuze='.urlencode($keuze).'&ixlimit='.urlencode($limit); echo 'Next 5 assignments >> '; } } else { echo "
    \n"; echo "No current-running or closed assignments found.\n"; echo "
\n"; } } } else { ?> On this page you can search for different types of assignments to be carried out as part of the Msc Human Media Interaction.
\n"; $row=$result[0]; echo '
'; echo "\n"; echo '\n"; echo ''; $query='SELECT distinct(instituten.land) from instituten,opdrachten_instituten, opdracht WHERE opdracht.ID=opdrachten_instituten.opdrachtID AND instituten.ID = opdrachten_instituten.instituutID AND instituten.actiefcontact="true" AND land != "" ORDER BY land'; $resland=sqlquery($query); if ($resland) { echo '\n"; } // $query = "SELECT instituten.land from instituten,opdrachten_instituten, VERTALING WHERE VERTALING.doelkort='$type' AND opdrachten_instituten.soort=VERTALING.bron and opdrachten_instituten.opdrachtID=".$row["ID"]." AND instituten.ID = opdrachten_instituten.instituutID AND instituten.actiefcontact='true';"); echo ''; echo ''; echo ''; echo "
Type of assignment\n"; echo "
Keywords
Country/Institute\n"; echo "
\n"; echo "
\n"; } } echo "

"; echo '[<< Back]'; if ($command == "uitvoeren") { echo ' [Return to Searchform]'; } ?>