session_start();?> function ssig() { return ($_SESSION["GAME"] . $_SESSION["LANG"] . '-'); } function get_term_from_id($id) { $query = "SELECT name FROM `Nodes` WHERE Nodes.id = \"$id\";" ; $r = @mysql_query($query) or die("bug in get_term_id : $query"); $nb = mysql_num_rows($r); if ($nb == 0) {return -1;} else {return mysql_result($r , 0 , 0);} // si -1 alors exist po ! } function term_exist_in_BD_p($term) { $query = "SELECT id FROM `Nodes` WHERE Nodes.name = \"$term\";" ; //echo $query; $r = @mysql_query($query) or die("bug in term_exist_in_BD_p : $query"); $nb = mysql_num_rows($r); if ($nb == 0) {return $nb;} else {return mysql_result($r , 0 , 0);} // si 0 alors exist po ! } function fetch_random_signature($terme=''){ //echo "
term==$terme"; if ($terme == '') { $query = "SELECT sig, termid FROM `LexSig` ORDER BY Rand() LIMIT 1;" ; $r = @mysql_query($query) or die("pb1 in fetch_signature : $query"); $nb = mysql_num_rows($r); if ($nb > 0) { $_SESSION['termid'] = mysql_result($r , 0 , 1); return mysql_result($r , 0 , 0); } else { return -1; } } else { $id = term_exist_in_BD_p($terme); $query = "SELECT sig, termid FROM `LexSig` WHERE termid = $id" ; $r = @mysql_query($query) or die("pb1 in fetch_signature : $query"); $nb = mysql_num_rows($r); if ($nb > 0) { $_SESSION['termid'] = mysql_result($r , 0 , 1); return mysql_result($r , 0 , 0); } else { return -1; } } } function unserialize_sig($sig_str) { if ($sig_str == -1) {return -1;} $sig = array(); $tab=explode('&',$sig_str); $nb=count($tab); for ($i=0 ; $i<$nb ; $i++) { $ar = explode('=',$tab[$i]); $sig[$ar[0]] = $ar[1]; } return $sig; } function play_decode_sig($sig) { //$j = 0; $size=5; arsort($sig); $j=0; foreach ($sig as $key => $value) { $term = get_term_from_id($key); if (($term != '***') && ($_SESSION['termid'] != $key)) { if (stripos($term, '::') === 0) { } else { $val = round($value, 2); echo "$term - "; $j=$j+1; } } if ($j > $size) {return;} } } function produce_sig () { $Connexion = mysql_connect("mysql.lirmm.fr", "lafourca", "newfann1"); // Ouverture de la base de données : mysql_select_db("Lafourcade_AS" , $Connexion); $query = "SELECT terme FROM `LS` ORDER BY Rand() LIMIT 1;" ; $r = @mysql_query($query) or die("pb1 in produce_sig_LSA : $query"); //$nb = mysql_num_rows($r); $terme = mysql_result($r , 0 , 0); //echo "
terme $terme";
$Connexion = mysql_connect("mysql.lirmm.fr", "lafourca", "newfann1");
// Ouverture de la base de données :
mysql_select_db("LafourcadeRezoLexical" , $Connexion);
$sig_str = fetch_random_signature($terme);
$sig = unserialize_sig($sig_str);
play_decode_sig($sig);
$id = $_SESSION['termid'];
$term = get_term_from_id($id);
$_SESSION['reponse'] = $term;
$ar = explode(' ', $term);
$nb = count($ar);
$_SESSION['aide'] = "C'est un terme composé de $nb mot(s)";
if (stripos($term, '-') === false) {
} else {
$_SESSION['aide'] = $_SESSION['aide'] . "
comportant un tiret (-)";
}
if (strtolower ($term) == $term) {
} else {
$_SESSION['aide'] = $_SESSION['aide'] . "
comportant une ou plusieurs majuscules";
}
$_SESSION['aide'] = '';
$_SESSION['SOURCE'] = 'JDM';
//echo "
$term";
}
function produce_sig_LSA () {
$Connexion = mysql_connect("mysql.lirmm.fr", "lafourca", "newfann1");
// Ouverture de la base de données :
mysql_select_db("Lafourcade_AS" , $Connexion);
$query = "SELECT id, terme, signature FROM `LS` ORDER BY Rand() LIMIT 1;" ;
$r = @mysql_query($query) or die("pb1 in produce_sig_LSA : $query");
//$nb = mysql_num_rows($r);
$terme = mysql_result($r , 0 , 1);
$sig_string = mysql_result($r , 0 , 2);
//echo "
$sig_string";
$size=6;
$sig = explode(' ', $sig_string);
//print_r($sig);
for($i=0;$i<$size;$i=$i+1) {
$term = $sig[$i];
echo "$term - ";
}
//$_SESSION['reponse'] = utf8_decode($terme);
$_SESSION['reponse'] = $terme;
$_SESSION['SOURCE'] = 'LSA';
$_SESSION['aide'] = '';
}
function produce_res() {
$res = $_SESSION['reponse'];
echo "\n
";
echo "\n
";
echo "\n \n";
echo 'Cette zone est vide';
echo "\n |
Détails :" . $_SESSION['detail']; } function make_nouveau_form () { echo "
|
|
$rand = rand(0, 1);
if ($rand == 1) {
produce_sig ();
} else {
produce_sig_LSA ();
}
?>
Ta réponse
(ne pas appuyer sur la touche entrée, mais passer la souris dans la case de résultat)
//if ($_SESSION[ssig() . 'playerid'] == 11) {
$rep = $_SESSION['reponse'];
echo "";
//echo "
" . $_SESSION['SOURCE']; //echo "
" . $_SESSION['reponse']; //} ?>
" . $_SESSION['SOURCE']; } ?> //if ($_SESSION[ssig() . 'playerid'] == 11) {echo $_SESSION['reponse'];}?>