. $_SESSION[$GLOBALS['g_ssig'] .'FORUM-URL'] . get_msg('MISC-FORUM') . "\n";*/ /* echo "\n
" . get_msg('MISC-FORUM') . "
\n";*/ echo "\n
Discord
\n"; // // FORUM et OPTIONS // $playername=str_replace(' ', '_', get_player_name($playerid)); if ($file == "/jdm-options.php") {$class = "options-selected";} else {$class = '';} echo "\n
" . get_msg('MISC-OPTIONS') . "
"; echo "\n"; help_block(); /* if (stripos($file, "jdm-accueil.php") === false) {} else { if (stripos($file, "HELP") === false) {$class = "help-not-selected";} else {$class = "help-selected";} echo "\n
?
\n"; }*/ //get_msg('MISC-HELP') echo "\n\n"; if ($_SESSION[$GLOBALS['g_ssig'] .'debugmode'] != "") {display_warning(" --- some maintenance is undertaken - things may behave strangely...");} if (($_SESSION[$GLOBALS['g_ssig'] .'message'] ?? null) != "") { //echo "
Message : " . $_SESSION[$GLOBALS['g_ssig'] .'message'] . ""; } } //--------------------- function curPageName() { return substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1); } function add_notification_tchat ($title, $message, $tag = "") { // AUDIT : $tag optionnel (appel a 2 arguments dans misc_functions_tchats.php : ArgumentCountError en PHP 8) // echo "
add_notification_tchat ($title, $message, $tag)"; $esc_title = addslashes($title); $esc_message = addslashes($message); $code = "tchatroar.alert('$esc_title','$esc_message');"; $label = 'notif_code_tchat'; if ($tag != '') {$label = "{$tag}_{$label}";} $_SESSION[$GLOBALS['g_ssig'] .$label] = $_SESSION[$GLOBALS['g_ssig'] .$label] . ' ' . $code; } function add_notification ($title, $message, $tag=null) { $esc_title = addslashes($title); $esc_message = addslashes($message); $code = "roar.alert('$esc_title','$esc_message');"; $label = 'notif_code'; if ($tag != '') {$label = "{$tag}_{$label}";} $_SESSION[$GLOBALS['g_ssig'] .$label] = $_SESSION[$GLOBALS['g_ssig'] .$label] . ' ' . $code; } // z-index:4;opacity:0.99; position:absolute;top:10px;left:10px; function add_notification_hf ($title, $message) { $esc_title = addslashes($title); $esc_message = addslashes("$message


") . addslashes("
"); $code = "roar_hf.alert('$esc_title','$esc_message');"; $_SESSION[$GLOBALS['g_ssig'] .'notif_code_hf'] = $_SESSION[$GLOBALS['g_ssig'] .'notif_code_hf'] . ' ' . $code; } function bottomblock($twit_display=true, $giver_display=true, $time_display=true) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $_SESSION[$GLOBALS['g_ssig'] . 'jdm_previous_page'] = ($_SESSION[$GLOBALS['g_ssig'] . 'jdm_current_page'] ?? null); $_SESSION[$GLOBALS['g_ssig'] . 'jdm_current_page'] = $_SERVER['PHP_SELF']; //echo "
\n"; // echo "
\n"; // jdm_menu("B"); // echo "
\n"; // echo "
\n"; // code analytics // //if (curPageName() != "generateGames.php") { // include_once 'ANALYTICS-' . $_SESSION["LANG"] . '.php'; //} //echo curPageName(); $file = $_SERVER['PHP_SELF']; if ((stripos($file, "generateGames") === false) && (stripos($file, "diko") === false) && (stripos($file, "player_profile") === false) ) { echo "\n"; make_fly(); } if ($twit_display) { if ((stripos($file, "generateGames") === false) && (stripos($file, "accueil") === false) //&& (stripos($file, "generateEvents") === false) && (stripos($file, "player_profile") === false) && (stripos($file, "AKI") === false) && (stripos($file, "signin") === false) ) { echo "\n"; display_twick(); } } if ($giver_display) { if ((($_SESSION[$GLOBALS['g_ssig'] . 'gift_giver'] ?? null) != '') && ($_SESSION[$GLOBALS['g_ssig'] .'playerid'] != $_SESSION[$GLOBALS['g_ssig'] . 'gift_giver_id'])) { $giver = $_SESSION[$GLOBALS['g_ssig'] . 'gift_giver']; $msg = trim(stripslashes($_SESSION[$GLOBALS['g_ssig'] . 'gift_msg'])); $sab = $_SESSION[$GLOBALS['g_ssig'] . 'gift_sab']; if ($msg == '') { if ($sab > 0) {$str = "Patate chaude"; $sty="text-shadow: red 0px 1px 10px";} else {$str = "Cadeau";} if ($sab < 0) {$str = "Patate douce"; $sty="text-shadow: green 0px 1px 10px";} else {$str = "Cadeau";} echo "\n
$str offert par
$giver
"; } else { if ($sab > 0) {$str = "Patate chaude"; $sty="text-shadow: red 0px 1px 10px";} else {$str = "Message";} if ($sab < 0) {$str = "Patate douce"; $sty="text-shadow: green 0px 1px 10px";} else {$str = "Message";} echo "\n
$str de
$giver
"; } } } echo "\n"; if ( (is_numeric(stripos($file, "souk"))) || (is_numeric(stripos($file, "accueil"))) || (is_numeric(stripos($file, "generateRanking"))) || (is_numeric(stripos($file, "generateEvents"))) || (is_numeric(stripos($file, "generateResult"))) ) { echo "\n"; check_achievements($_SESSION[$GLOBALS['g_ssig'] .'playerid']); } // le script js $pos = $_SESSION[$GLOBALS['g_ssig'] .'notification_pos']; echo ' '; /* if ($_SESSION[$GLOBALS['g_ssig'] . 'playerid'] == 11) { echo "SELF = " . $file; echo "STRIPOS=" . (is_numeric(stripos($file, "generateResult"))); break; } */ /* echo ""; */ //display_shouts(); add_shout_shortcut(); if ($time_display) { echo "\n
"; echo round(end_time_record("page_loading_time"), 3); echo " s\n
"; } echo ($_SESSION[$GLOBALS['g_ssig'] .'image_code'] ?? null); //$_SESSION[$GLOBALS['g_ssig'] .'image_code'] = ''; } function insert_graphic_div($n, $tag) { for ($i=0 ; $i<$n ; $i++) { echo "\n
"; echo "
"; } for ($i=0 ; $i<$n ; $i++) { echo "\n
"; echo "
"; } } //--------------------- function produceplayasform ($loc='normal') { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $playeid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; $tag = ""; if ((($_SESSION[$GLOBALS['g_ssig'] .'harddebugmode'] ?? null)=="Y") or (($_SESSION[$GLOBALS['g_ssig'] .'BUSTED'] ?? null) <> "")) { if (test_playerp() !="Y") {$tag = "disabled"; } } //echo "
"; if ($loc == 'normal') {echo "
";} if ($loc == 'home') {echo "
";} $rand = rand(0,100); if ($playeid == 0) {$rand = 100;} // a enelevr = fourberie provisoire // $rand if (get_param('ONLYGIFT') >= 1) { $rand = 103; $newval = get_param('ONLYGIFT')-1; set_param('ONLYGIFT', "$newval"); } $directid = select_random_term_from_thema_direct($playeid); if ($directid > 0) { //echo "DIRECT = $directid"; $rand = 102; } else { //echo "INDIRECT"; $thema = get_thema($playeid); //echo "tehma=$thema"; if ($thema != -1) { $rand = 101; $thema_target = get_term_from_id($thema); } else { $thema_target = "fruit"; } if (($_SESSION[$GLOBALS['g_ssig'] .'thema_perm'] ?? null) != '') { //echo "tham perm"; $rand = 101; $thema_target = $_SESSION[$GLOBALS['g_ssig'] .'thema_perm']; } } if (($_SESSION[$GLOBALS['g_ssig'] .'demo'] ?? null) == 1) { $rand = 103; } switch(true) { case ($rand < 2): echo "\n
"; $_SESSION[$GLOBALS['g_ssig'] .'special_question_permisson'] = True; break; case ($rand < 4): echo "\n"; $_SESSION[$GLOBALS['g_ssig'] .'special_question_permisson'] = True; break; case ($rand < 6): echo "\n"; $_SESSION[$GLOBALS['g_ssig'] .'special_question_permisson'] = True; break; case ($rand == 101): //echo "

TERM INDIRECT = $thema_target"; $target_url = urlencode($thema_target); if ($_SESSION[$GLOBALS['g_ssig'] .'thema_perm'] != '') { echo "\n"; } else { echo "\n"; } $_SESSION[$GLOBALS['g_ssig'] .'special_question_permisson'] = True; break; case ($rand == 102): //echo "

TERM DIRECT = $directid"; echo "\n"; break; case ($rand == 103): // echo "

TERM PLAYAS GIFT = make_playasgift_link"; $link = make_playasgift_link(); echo "\n"; break; default: echo "\n"; break; } //echo "\n"; $rotation=0; echo "\n

"; echo "\n"; //if ($loc == 'home') { if (true) { echo "\n
j
"; echo "\n
uer
"; } echo "
"; // SRC=\"pics/jdm-logo-jouer.png\" echo "\n"; echo "\n
"; echo "\n
"; if (($_REQUEST['playasname'] ?? null) != $_SESSION[$GLOBALS['g_ssig'] .'login']) { //echo "

"; //echo "Vous n'êtes plus connecté."; //echo ""; } if (guestplayerp() != "Y") { // $_SESSION[$GLOBALS['g_ssig'] .'login'] = "guest"; } else { if ($loc == 'home') { //if (true) { echo "\n

"; echo "\n
"; echo get_msg('MISC-PLAYAS-GUESTWARNING'); echo "\n
\n
"; } } if (($_SESSION['again_link'] ?? null) != '') { echo "\n
" . jdm_msg('RESULT-AGAIN') . "
\n"; } if ($_SESSION[$GLOBALS['g_ssig'] .'playerid'] == 0) { echo ""; /*echo "
Cliquez sur jouer
pour lancer une partie !
";*/ } echo " "; } //--------------------- RELATIONS AND COTATIONS // function get_relation_gpname($relid) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $query = "SELECT gpname FROM `RelationTypes` WHERE id='$relid' ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("bug in get_relation_gpname : $query"); $gpname = jdm_mysql_result($r , 0 , 0); $gpname = my_utf8_decode($gpname); return $gpname; } // // Les relations jouables proposées dans le Souk de JDM // function active_relations() { $l = array(0, 5, 8, 3, 6, 7, 9, 10, 15, 17, 11, 22, 20, 21, 84, 34, 13, 14, 16, 32, 35, 37, 38, 41, 42, 73, 74, 64, 150, 106, 129, 147); return $l; } function all_relations() { $l = array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 41, 42, 73, 74, 64, 150, 106, 129 ); return $l; } function set_relation_cotation($relid, $value) { if ($relid==0) {return;} $query2 = "UPDATE `RelationTypes` SET quot=$value, quotmin=1000, quotmax=$value WHERE id='$relid' LIMIT 1;"; $r2 = jdm_mysql_query_trace($query2) or userdiejdm("pb in set_relation_cotation 5 : $query2"); } // AUDIT 2026-10-15 : relid et delta etaient inseres tels quels dans l'UPDATE (appel depuis jdm-about-detail-relations.php) => entiers. function incf_relation_cotation($relid, $delta) { $relid = (int)$relid; $delta = (int)$delta; echo " incf_relation_cotation($relid, $delta) "; if ($relid==0) {return;} // $query2 = "UPDATE `RelationTypes` SET quot=MIN(MAX(quot+$delta, quotmin), quotmax) WHERE id='$relid' ;"; $query2 = "UPDATE `RelationTypes` SET quot=quot+$delta WHERE id='$relid' LIMIT 1;"; echo " $query2 "; $r2 = jdm_mysql_query_trace($query2) or userdiejdm("pb in incf_relation_cotation 5 : $query2"); } // AUDIT 2026-10-15 : relid insere tel quel dans le SQL => entier ; $adjust2 (variable jamais definie, donc 0) supprime : la valeur est simplement ramenee dans [quotmin, quotmax]. function ensure_relation_cotation($relid) { $relid = (int)$relid; if ($relid==0) {return;} $query1 = "SELECT id, quot, quotmin, quotmax FROM RelationTypes WHERE id=$relid LIMIT 1 ;"; $r1 = jdm_mysql_query_trace($query1) or userdiejdm("pb in ensure_relation_cotation 4 : $query1"); $nb1 = jdm_mysql_num_rows($r1); if ($nb1 > 0) { $id = (int)jdm_mysql_result($r1 , 0 , 0); $quot = max(100, jdm_mysql_result($r1 , 0 , 1)); $quotmin = max(100, jdm_mysql_result($r1 , 0 , 2)); $quotmax = max(100, jdm_mysql_result($r1 , 0 , 3)); $theval = min($quotmax, max($quotmin, $quot)); $query2 = "UPDATE `RelationTypes` SET quot=$theval WHERE id='$id' LIMIT 1;"; $r2 = jdm_mysql_query_trace($query2) or userdiejdm("pb in ensure_relation_cotation 5 : $query2"); } } // valeur publique * 1000 set_relation_cotation(0, 1000) ; // set_relation_cotation(17, 5000) ; // // La relation idées assoc (id=0) ne change PAs pour la quotation // // function adjust_relation_cotations($relid, $f) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ // echo "adjust_relation_cotations($relid, $f)"; if ($relid==0) {return;} $query = "SELECT * FROM RelationTypes WHERE playable=1 ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in adjust_cotation 1 : $query"); $nb = jdm_mysql_num_rows($r); if ($nb <= 1) {return;} //$l = active_relations(); //$nb = count($l); $query = "SELECT quot, quotmin, quotmax FROM RelationTypes WHERE id= '$relid' ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in adjust_cotation 2 : $query"); $quot = max(100, jdm_mysql_result($r , 0 , 0)); $quotmin = max(100, jdm_mysql_result($r , 0 , 1)); $quotmax = max(100, jdm_mysql_result($r , 0 , 2)); $adjust = abs(2 + (2 * $f)); $theval = min($quotmax, max($quotmin, $quot - $adjust)); $query = "UPDATE `RelationTypes` SET quot = $theval WHERE id= '$relid' LIMIT 1;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in adjust_cotation 3 : $query"); $adjust2 = abs((1 + $f) / ($nb - 1)) ; $query1 = "SELECT id, quot, quotmin, quotmax FROM RelationTypes WHERE playable=1 ;"; $r1 = jdm_mysql_query_trace($query1) or userdiejdm("pb in adjust_cotation 4 : $query1"); $nb1 = jdm_mysql_num_rows($r1); for ($i=0 ; $i<$nb1 ; $i++) { $id = jdm_mysql_result($r1 , 0 , 0); $quot = max(100, jdm_mysql_result($r1 , 0 , 1)); $quotmin = max(100, jdm_mysql_result($r1 , 0 , 2)); $quotmax = max(100, jdm_mysql_result($r1 , 0 , 3)); $theval = min($quotmax, max($quotmin, $quot + $adjust2)); if ($id != $relid){ $query2 = "UPDATE `RelationTypes` SET quot =$theval WHERE id= '$id' LIMIT 1;"; $r2 = jdm_mysql_query_trace($query2) or userdiejdm("pb in adjust_cotation 5 : $query2"); } } } function compute_rel_cotation_ratio($relid) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $query = "SELECT quot FROM RelationTypes WHERE id = '$relid'"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in compute_rel_cotation_ratio : $query"); $cotation = jdm_mysql_result($r , 0 , 0); return $cotation/1000; } //--------------------- //--------------------- EVENTS function make_event($string) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ //$string = addslashes($string); $string = str_replace('œ', 'œ', $string); $string = str_replace('Œ', 'Œ', $string); $string_enc = my_utf8_encode($string); $query = "INSERT INTO `Events` (`what`) VALUES (\"$string_enc\");"; $r = jdm_mysql_query_trace($query) or userdiejdm("merdum in make_event : $query"); file_put_contents('jdm-last-event.txt', $string); add_twit('event', $string); $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; touch_last_login($playerid); } //--------------------- MESSAGES AND LOCALIZATION function safe_echo ($str) { echo my_htmlentities($str); } function my_htmlentities($str) { return htmlentities($str, ENT_COMPAT, "ISO-8859-1", true); } function get_msg($s){ $tab = array("\'", "<0>", "<1>", "<2>", "<3>", "<4>", "<5>", "<6>", "<7>", "<8>", "<9>", "<10>", "<11>", "<12>", "<13>", "<14>", "<15>", "<16>", "<17>", "<18>", "<19>"); $glob = array("'", ($GLOBALS[0] ?? null), ($GLOBALS[1] ?? null), ($GLOBALS[2] ?? null), ($GLOBALS[3] ?? null), ($GLOBALS[4] ?? null), ($GLOBALS[5] ?? null),($GLOBALS[6] ?? null), ($GLOBALS[7] ?? null), ($GLOBALS[8] ?? null),($GLOBALS[9] ?? null), ($GLOBALS[10] ?? null), ($GLOBALS[11] ?? null), ($GLOBALS[12] ?? null), ($GLOBALS[13] ?? null), ($GLOBALS[14] ?? null), ($GLOBALS[15] ?? null),($GLOBALS[16] ?? null), ($GLOBALS[17] ?? null), ($GLOBALS[18] ?? null),($GLOBALS[19] ?? null)); $lang = jdm_msg_lang_for_key($s); // (i18n 2026-11-07) langue d'interface du joueur (FR par defaut) ; FR force pour les textes ecrits en base / envoyes par mail jdm_load_loc($lang); $tag = $lang."-".$s; $string = ($GLOBALS[$tag] ?? null); if ($string === null && $lang !== 'FR' && $lang !== 'EN') {$string = ($GLOBALS['EN-' . $s] ?? null);} // (i18n) 3e langue : repli sur l'anglais if ($string === null) {$string = ($GLOBALS['FR-' . $s] ?? null);} // (i18n 2026-11-07) repli sur le francais if ($string === NULL) { $string = "[get_msg:string not found:$tag]"; } else { $string = str_replace($tab,$glob,$string); } return $string; } // (i18n 2026-11-07) Message localise AVEC PARAMETRES passes en argument : jdm_msg('CLE', array(valeur0, valeur1, ...)) remplace <0>, <1>... du // texte (comme get_msg, mais sans passer par $GLOBALS[0..19]). Meme repli que get_msg : langue courante, puis francais, puis "[get_msg:string not found:...]". // Les messages sont ranges dans LOC-.php sous la cle -. Texte en ASCII + entites HTML ; les valeurs passees sont inserees telles quelles. function jdm_msg($key, $vals = array()) { return jdm_msg_in(jdm_msg_lang_for_key($key), $key, $vals); // langue d'interface (jdm_lang.php) ; repli FR } // Idem, pour une chaine JavaScript entre guillemets doubles (humane("...") etc.) : \ et " echappes, retours a la ligne supprimes. function jdm_msg_js($key, $vals = array()) { return addcslashes(str_replace(array("\r", "\n"), ' ', jdm_msg($key, $vals)), '\\"'); } //--------------------- MOST WANTED TERMS function get_rand_mostwanted() { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ //return -1; $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; //cleanup // $query = "DELETE FROM `WantedWords` WHERE id in (SELECT N.id FROM Nodes as N WHERE N.type=444) ; "; // $r = jdm_mysql_query_trace($query) or userdiejdm("pb get_rand_mostwanted 0 : $query"); $query = "SELECT /* get_rand_mostwanted */id FROM WantedWords ORDER By Rand() LIMIT 100;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb get_rand_mostwanted 1 : $query"); $nb = jdm_mysql_num_rows($r); if ($nb == 0) {return -1;} for ($i=0 ; $i<$nb ; $i++) { $rand = rand(0, $nb-1); $id = jdm_mysql_result($r , $rand , 0); $nodetype = get_node_type($id); if ($nodetype == 444) { $query = "DELETE FROM `WantedWords` WHERE id = $id LIMIT 1 ; "; // AUDIT-ACCUEIL (bug) : le resultat du DELETE ecrasait $r (le jeu de lignes) : l'iteration suivante lisait jdm_mysql_result() sur un booleen. $rdel = jdm_mysql_query_trace($query) or userdiejdm("pb get_rand_mostwanted 2 : $query"); continue; } //$check = check_proposed_word($id, $playerid); //if ($check == false) {return $id;} return $id; } return -1; } function display_mostwanted () { $query = "SELECT id,date FROM WantedWords ORDER BY `date` DESC ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb display_mostwanted 1 : $query"); $nb = jdm_mysql_num_rows($r); for ($i=0 ; $i<$nb ; $i++) { $termid = jdm_mysql_result($r , $i , 0); $date = jdm_mysql_result($r , $i , 1); $notfree = check_term_owners($termid); if ($notfree) { $tag = "déjà capturé"; } else { $tag = "libre"; } $value = round(($date - $time)/60); $term = get_term_from_id($termid); if ($value > 0){ echo"
'$term' ($termid)
"; } } } function display_mostwanted_old () { $time = microtime_float(); //echo $time; $rtime = round($time); //echo $rtime; $query = "SELECT count(*) FROM WantedWords WHERE (date-$rtime)>0 ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb display_mostwanted 0 : $query"); $nb = jdm_mysql_result($r , 0 , 0); if ($nb < 7) { $query = "SELECT id FROM WantedWords WHERE (date-$rtime)<0 ORDER BY Rand() LIMIT 1 ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb display_mostwanted 0bis : $query"); $id = jdm_mysql_result($r , 0 , 0); //echo "
$id"; $value = 50000; $endtime = round($time + 60*$value); $query = "UPDATE `WantedWords` SET date = $endtime WHERE id= $id ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb display_mostwanted 0bis : $query"); } $query = "SELECT id,date FROM WantedWords ORDER BY `date` DESC ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb display_mostwanted 1 : $query"); for ($i=0 ; $i < jdm_mysql_num_rows($r) ; $i++) { $termid = jdm_mysql_result($r , $i , 0); $date = jdm_mysql_result($r , $i , 1); $notfree = check_term_owners($termid); if ($notfree) { $tag = "déjà capturé"; } else { $tag = "libre"; } $value = round(($date - $time)/60); $term = get_term_from_id($termid); if ($value > 0){ echo"
'$term'
"; } } } function check_mostwanted($termid) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $query = "SELECT id, date FROM `WantedWords` WHERE id=$termid ;"; //echo "query=$query"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb check_mostwanted 1: $query"); $nb = jdm_mysql_num_rows($r); if ($nb <= 0) {return 0 ;} // on simplifie return 10000; // old $date = jdm_mysql_result($r , 0 , 1); $time = microtime_float(); $value = round(($date - $time)/60); if ($value <= 0) {return 0 ;} return $value; } /* * OBSOLETE * function display_collection() { $query = "SELECT id, name, t1, t2, t3, t4, t5, t6, t7, t8, t9, t10 FROM Collections ORDER BY name"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb display_collection 1 : $query"); for ($i=0 ; $i < jdm_mysql_num_rows($r) ; $i++) { $cid = jdm_mysql_result($r , $i , 0); $cname = jdm_mysql_result($r , $i , 1); $t1 = jdm_mysql_result($r , $i , 2); $t2 = jdm_mysql_result($r , $i , 3); $t3 = jdm_mysql_result($r , $i , 4); $t4 = jdm_mysql_result($r , $i , 5); $t5 = jdm_mysql_result($r , $i , 6); $t6 = jdm_mysql_result($r , $i , 7); $t7 = jdm_mysql_result($r , $i , 8); $t8 = jdm_mysql_result($r , $i , 9); $t9 = jdm_mysql_result($r , $i , 10); $t10 = jdm_mysql_result($r , $i , 11); $string = ""; for ($j=2 ; $j<=11 ; $j++) { $s = jdm_mysql_result($r , $i , $j); if ($s != "") { $string = $string . $s . " - "; } } //$string = trim("$t1 $t2 $t3 $t4 $t5 $t6 $t7 $t8 $t9 $t10"); //echo "$string"; echo"
'$cname'
\n"; } } */ //--------------------- INVOCATION - HYPEWORDS function invok_term($term, $userid=0) { $query = "INSERT INTO `HypeWords` (name, token, owner) VALUES (\"$term\", 1, '$userid') ON DUPLICATE KEY UPDATE date=NOW();"; $r = @jdm_mysql_query($query) or userdiejdm("
PB in query 0 $query"); } function get_invok_number($playerid) { $query = "SELECT COUNT(name) FROM `HypeWords` WHERE `owner` = $playerid AND token != 0 ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("bug in get_invok_number : $query"); return jdm_mysql_result($r , 0 , 0); } function reward_invok_term($entry, $relid) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $entry_enc = my_utf8_encode($entry); $query = "SELECT owner, token, gain, relationType FROM `HypeWords` WHERE `name` = \"$entry_enc\" ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("bug in reward_invok_term : $query"); $nb = jdm_mysql_num_rows($r); if ($nb <= 0) {return;} $owner = jdm_mysql_result($r , 0 , 0); $token = jdm_mysql_result($r , 0 , 1); $gain = jdm_mysql_result($r , 0 , 2); $relationType = jdm_mysql_result($r , 0 , 3); if (($token > 0)&&($relid==$relationType)){ $gain = $gain + 1; $token = $token - 1; $query = "UPDATE `HypeWords` SET token = $token, gain=$gain WHERE name=\"$entry_enc\";" ; //$r = jdm_mysql_query_trace($query) or userdiejdm("Bug in reward_invok_term 3"); inc_player_honnor($owner, 1); } } // //--------------------- STATS // // function get_all_relation_number() { // return jdm_get_relation_number('rtotal'); $query = "SELECT COUNT(*) FROM Relations ;"; $r = jdm_mysql_query($query); return jdm_mysql_result($r , 0 , 0); } /* function get_relation_number() { $query = "SELECT COUNT(*) FROM `Relations` WHERE `type` not in (1, 2, 4, 12, 18, 19, 36)"; $r = jdm_mysql_query($query); return jdm_mysql_result($r , 0 , 0); } */ function get_relation_number() { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ // return get_relation_number_fast(); return jdm_get_relation_number('rtotal'); } function get_relation_number_negative() { $fname = 'stats_off_relation_neg.txt'; $lastfilemodif = @filemtime($fname); $curtime = time(); $delta = $curtime - $lastfilemodif; // x minutes $deltath = 60 * 30; if ($delta < $deltath) {return file_get_contents($fname);} if (file_exists($fname)) {@touch($fname);} // (modif) anti-stampede : on rafraichit la date AVANT le calcul couteux, sinon toutes les requetes concurrentes recalculent en meme temps ; en attendant elles renvoient l'ancienne valeur $query = "SELECT COUNT(*) FROM `Relations` FORCE INDEX (w) WHERE w<=0 ; "; $r = jdm_mysql_query($query); $val = jdm_mysql_result($r , 0 , 0); file_put_contents($fname, $val); return $val; } // faster version // function get_relation_number_fast() { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ return jdm_get_relation_number('total'); //!!!!!! // $fname = 'stats_relation_number.txt'; $lastfilemodif = @filemtime($fname); $curtime = time(); $delta = $curtime - $lastfilemodif; // x minutes $deltath = 60 * 30; if ($delta < $deltath) {return file_get_contents($fname);} if (file_exists($fname)) {@touch($fname);} // (modif) anti-stampede : on rafraichit la date AVANT le calcul couteux, sinon toutes les requetes concurrentes recalculent en meme temps ; en attendant elles renvoient l'ancienne valeur $query = "SELECT COUNT(*) FROM `Relations` ; "; $r = jdm_mysql_query($query); $excl = jdm_mysql_result($r , 0 , 0); file_put_contents($fname, $excl); return $excl; //!!!!!!!!!!! // return 1000000; $ar = array(1, 2, 4, 12, 18, 19, 36); $msc = microtime(true); $count = 0; foreach($ar as $key => $value) { //$query = "SELECT COUNT(*) FROM `Relations` WHERE `type` in (1, 2, 4, 12, 18, 19, 36)"; $query = "SELECT COUNT(*) FROM `Relations` WHERE `type`=$value ; "; $r = jdm_mysql_query($query); $excl = jdm_mysql_result($r , 0 , 0); $count += $excl; } $msc=microtime(true)-$msc; // echo "temps $msc s.
"; $query = "SELECT COUNT(*) FROM `Relations` ; "; $r = jdm_mysql_query($query); $nb = jdm_mysql_result($r , 0 , 0); $delta = $_SESSION[$GLOBALS['g_ssig'] .'RELATIONS-COUNT-DELTA']; return ($nb - $count - $delta); } function get_relation_wsum() { $fname = 'stats_off_relation_wsum.txt'; $lastfilemodif = @filemtime($fname); $curtime = time(); $delta = $curtime - $lastfilemodif; // x minutes $deltath = 60 * 30; if ($delta < $deltath) {return file_get_contents($fname);} if (file_exists($fname)) {@touch($fname);} // (modif) anti-stampede : on rafraichit la date AVANT le calcul couteux, sinon toutes les requetes concurrentes recalculent en meme temps ; en attendant elles renvoient l'ancienne valeur $query = "SELECT SUM(w) FROM `Relations` WHERE `type` != 1 AND `type` != 2 AND `type` != 3 AND `type` != 4 AND `type` != 12 AND `type` != 18 AND `type` != 19 ; "; $r = jdm_execquery_mysqli($query) or userdiejdm("bug in get_relation_wsum : $query"); $val = jdm_mysql_result($r , 0 , 0); file_put_contents($fname, $val); return $val; } function get_off_relation_number() { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $fname = 'stats_off_relation_number.txt'; $lastfilemodif = @filemtime($fname); $curtime = time(); $delta = $curtime - $lastfilemodif; // x minutes $deltath = 60 * 30; if ($delta < $deltath) {return file_get_contents($fname);} if (file_exists($fname)) {@touch($fname);} // (modif) anti-stampede : on rafraichit la date AVANT le calcul couteux, sinon toutes les requetes concurrentes recalculent en meme temps ; en attendant elles renvoient l'ancienne valeur $notinrel = '(1, 2, 4, 12, 18, 19, 36, 333, 444, 200, 128, 140)'; $th = $_SESSION[$GLOBALS['g_ssig'] .'offlimits_thresh']; if ($th <= 0) {$th = 1000;} $query = "SELECT COUNT(*) FROM `Relations` WHERE w >= $th AND `type` not in $notinrel ; "; // $msc=microtime(true); $r = jdm_execquery_mysqli($query) or userdiejdm("bug in get_off_relation_number : $query"); // $msc=microtime(true)-$msc; //echo "temps $msc s.
"; // SELECT COUNT(*) FROM `Relations` WHERE w >= 300 AND `type` in (1, 2, 4, 12, 18, 19, 36, 333, 444, 200, 128, 140) $val = jdm_mysql_result($r , 0 , 0); file_put_contents($fname, $val); return $val; } function get_node_number() { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $fname = 'JDM-LEXICALNET-FR/STATS/stats_term_number.txt'; $lastfilemodif = @filemtime($fname); $curtime = time(); $delta = $curtime - $lastfilemodif; // x minutes $deltath = 60 * 30; if ($delta < $deltath) {return file_get_contents($fname);} if (file_exists($fname)) {@touch($fname);} // (modif) anti-stampede : on rafraichit la date AVANT le calcul couteux, sinon toutes les requetes concurrentes recalculent en meme temps ; en attendant elles renvoient l'ancienne valeur $query = "SELECT COUNT(*) /* get_node_number */ FROM `Nodes` WHERE `type` IN (1, 8, 9, 666, 777) ; "; $r = jdm_execquery_mysqli($query) or userdiejdm("bug in get_node_number : $query"); $val = jdm_mysql_result($r , 0 , 0); file_put_contents($fname, $val); return $val; } function get_out_relation_number() { $fname = 'JDM-LEXICALNET-FR/STATS/stats_out_relation_number.txt'; $lastfilemodif = @filemtime($fname); $curtime = time(); $delta = $curtime - $lastfilemodif; // x minutes $deltath = 60 * 30; if ($delta < $deltath) {return file_get_contents($fname);} if (file_exists($fname)) {@touch($fname);} // (modif) anti-stampede : on rafraichit la date AVANT le calcul couteux, sinon toutes les requetes concurrentes recalculent en meme temps ; en attendant elles renvoient l'ancienne valeur $query = "SELECT count(distinct(node1)) FROM `Relations` WHERE type NOT IN (4, 12, 18, 36, 998, 999) AND node1 IN (SELECT id FROM Nodes WHERE `type` IN (1, 8, 9, 666, 777)) ;"; $r = jdm_execquery_mysqli($query) or userdiejdm("bug in get_out_relation_number : $query"); $val = jdm_mysql_result($r , 0 , 0); file_put_contents($fname, $val); return $val; } function get_in_relation_number() { $fname = 'JDM-LEXICALNET-FR/STATS/stats_in_relation_number.txt'; $lastfilemodif = @filemtime($fname); $curtime = time(); $delta = $curtime - $lastfilemodif; if ($delta < 3600) {return file_get_contents($fname);} if (file_exists($fname)) {@touch($fname);} // (modif) anti-stampede : on rafraichit la date AVANT le calcul couteux, sinon toutes les requetes concurrentes recalculent en meme temps ; en attendant elles renvoient l'ancienne valeur $query = "SELECT count(distinct(node2)) FROM `Relations` WHERE type NOT IN (4, 12, 18, 36, 998, 999) AND node1 IN (SELECT id FROM Nodes WHERE `type` IN (1, 8, 9, 666, 777)) ; "; $r = jdm_execquery_mysqli($query) or userdiejdm("bug in get_in_relation_number : $query"); $val = jdm_mysql_result($r , 0 , 0); file_put_contents($fname, $val); return $val; } function get_relation_id_number($id) { $query = "SELECT COUNT(*) FROM `Relations` WHERE `type`=$id ;"; $r = jdm_execquery_mysqli($query) or userdiejdm("bug in get_relation_id_number : $query"); return jdm_mysql_result($r , 0 , 0); } // get_relation_type_id : version avec cache (duree de la requete). // Avant, chaque appel faisait une requete SQL (ex : dans infer_answer, tables $impl_ar / $specSC). // Les resultats null (relation inconnue / ignoree) sont aussi caches. // Desactivable pour comparaison A/B : fichier 'infer_noopt.on' (voir infer_opt() dans rezo-ask.php). function get_relation_type_id($name) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $use_cache = (!function_exists('infer_opt')) || infer_opt(); $name_key = (string)$name; if ($use_cache && isset($GLOBALS['jdm_c_grti']) && array_key_exists($name_key, $GLOBALS['jdm_c_grti'])) {return $GLOBALS['jdm_c_grti'][$name_key];} $id = get_relation_type_id_nocache($name); if ($use_cache) {$GLOBALS['jdm_c_grti'][$name_key] = $id;} return $id; } function get_relation_type_id_nocache($name) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ //echo "
***debug : get_relation_type_id($name) "; //myflush(); $name = normalize_rel_name($name); if ($name === null) { return null; // relation explicitement ignorée (r_def, r_example, r_source...) } $name = my_utf8_encode($name); $query = "SELECT id FROM `RelationTypes` WHERE `name`='$name' LIMIT 1 ;"; $r = jdm_execquery_mysqli($query) or userdiejdm("bug in get_relation_type_id($name) : $query"); $nb = jdm_mysql_num_rows($r); if ($nb <= 0) {return null ;} return jdm_mysql_result($r , 0 , 0); } function get_relation_type_oppos($id) { $query = "SELECT oppos FROM `RelationTypes` WHERE `id`='$id' LIMIT 1 ;"; $r = jdm_execquery_mysqli($query) or userdiejdm("bug in get_relation_type_oppos($id) : $query"); $nb = jdm_mysql_num_rows($r); return jdm_mysql_result($r , 0 , 0); } function make_stats_string() { $l = active_relations(); $nb = count($l); $string = ""; for ($i=0 ; $i<$nb ; $i++) { $string = $string . $l[$i] . ":" . get_relation_id_number($l[$i]) . ";"; } $string = $string . "w:". get_relation_wsum() . ";" ; $time = round(microtime_float()*1000); $query = "INSERT INTO `Stats` (`id` , `data`) VALUES ('$time', '$string');"; $r = jdm_execquery_mysqli($query) or userdiejdm("pb make_stats_string: $query"); } // --- END Stats // // GIFTS // function check_gifts() { $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; $query = "SELECT * FROM Gifts WHERE destid='$playerid' LIMIT 1 ; "; $r = jdm_execquery_mysqli($query) or userdiejdm("pb check_gifts : $query"); $nb = jdm_mysql_num_rows($r); if ($nb>0) {return true;} else {return false;} } function check_gifts_number() { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; $query = "SELECT COUNT(*) FROM Gifts WHERE destid='$playerid' ; "; $r = jdm_execquery_mysqli($query) or userdiejdm("pb check_gifts : $query"); // $nb = jdm_mysql_num_rows($r); $nb = jdm_mysql_result($r , 0 , 0); return $nb; } function game_bonus_factor($id) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ //debugecho("in game_bonus_factor($id)"); if ($id <= 0) {return 1;} $query = "SELECT max(id) FROM PendingGames"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb game_bonus_factor : $query"); $lastid = jdm_mysql_result($r , 0 , 0); $seuilmin = 0.5; $seuil = $id/$lastid; // echo "in game_bonus_factor($id) maxid=$lastid seuil= $seuil"; //break; if ($seuil > $seuilmin) { $_SESSION[$GLOBALS['g_ssig'] .'old_game'] = false; return 1; } $f = round(max(10, min(1000,1/$seuil))); // echo " factor = $f"; if ($f < 10) {$f = 1;} //if (count($_SESSION[$GLOBALS['g_ssig'] .'offlimits']) <= 0) {$f = 1;} if ($f >= 10){ // $_SESSION[$GLOBALS['g_ssig'] .'old_game'] = True; } //debugecho("in game_bonus_factor id=$id lastid=$lastid F=$f"); return $f; } function display_game_bonus_factor(){ if ($_SESSION[$GLOBALS['g_ssig'] .'bonus-factor'] > 1) { $f = ($_SESSION[$GLOBALS['g_ssig'] .'bonus-factor']*1); echo "\n
"; echo "\n
"; echo "+$f%"; echo "
"; } } function display_antik_tag(){ /* if ($_SESSION[$GLOBALS['g_ssig'] .'old_game'] == True) { echo "\n
"; echo " 
"; }*/ } //--------------------- PROPOSED WORDS // PERF / DOUTE : check_proposed_word() est DESACTIVE (return false) mais cette fonction continue d'ecrire a chaque partie : INSERT, puis // COUNT(term_id) sur le joueur, puis eventuellement SELECT + DELETE de purge. Si la fonctionnalite reste desactivee, ces ecritures sont inutiles. function insert_proposed_word($termid, $playerid=-1) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ if ($playerid == -1) { $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; } $time = microtime_float(); // if (check_proposed_word($termid)) { // rien // } else { $query = "INSERT INTO `ProposedWords` (`player_id` , `term_id`, `date`) VALUES ('$playerid', '$termid','$time');"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb insert_proposed_word 2: $query"); // } // on vire les trop vieux si nb > 200 $query = "SELECT count(term_id) FROM ProposedWords WHERE player_id='$playerid' ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb insert_proposed_word 3 : $query"); $nb = jdm_mysql_result($r , 0 , 0); // $thresh = max(1000, 250*get_player_eff($playerid)); $thresh = 100*jdm_num(get_player_data($playerid, 'TERM_DELAY')); // (PHP 8) '' si absent if ($thresh == 0) { $thresh = 100; } if ($nb > $thresh) { $query = "SELECT date FROM ProposedWords WHERE player_id='$playerid' ORDER by DATE DESC LIMIT $thresh ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb insert_proposed_word 4: $query"); $nb2= jdm_mysql_num_rows($r); $mindate = jdm_mysql_result($r , ($thresh-1) , 0); if ($mindate > 0) { $query = "DELETE FROM `ProposedWords` WHERE date < '$mindate' AND player_id='$playerid' ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb insert_proposed_word 5: $query"); } } } // désactivé function check_proposed_word($term_id, $playerid=-1) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ return false; if ($playerid == -1) { $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; } $query = "SELECT player_id,term_id FROM ProposedWords WHERE player_id='$playerid' AND term_id='$term_id' ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb check_proposed_word : $query"); $nb = jdm_mysql_num_rows($r); if ($nb<=0) { return false; } else { return true; } } function count_proposed_word($term_id, $playerid=-1) { if ($playerid == -1) { $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; } $query = "SELECT COUNT(*) FROM ProposedWords WHERE player_id='$playerid' AND term_id='$term_id' ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb count_proposed_word : $query"); // $nb = jdm_mysql_num_rows($r); $nb = jdm_mysql_result($r , 0 , 0); return $nb; } //--------------------- LAST PLAYER function insert_last_player($player2_id) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ start_time_record("insert_last_player"); if ($player2_id === "") { //echo "

bug in insert_last_player : player2_id is null

"; //echo " - COPIEZ CET ECRAN ET AVERTISSEZ L'ADMIN :)"; //return; $player2_id = 0; } $player1_id = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; if (check_last_player($term_id)) { // mise a jour $query = "UPDATE `LastPlayer` SET player2_id = $player2_id WHERE player1_id= '$player1_id' ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb insert_last_player 1: $query"); } else { // creation $query = "INSERT INTO `LastPlayer` (`player1_id` , `player2_id`) VALUES ('$player1_id', '$player2_id');"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb insert_last_player 2: $query"); } debugecho("insert_last_player=" . end_time_record("insert_last_player")); } // a réécrire // function check_last_player() { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $player1_id = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; $query = "SELECT player1_id, player2_id FROM LastPlayer WHERE player1_id= '$player1_id' ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb check_last_player : $query"); $nb = jdm_mysql_num_rows($r); if ($nb<=0) { return false; } else { return true; } } // a réécrire // function get_last_player() { $player1_id = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; if ($player1_id == 0) {return -1;} $query = "SELECT player1_id, player2_id FROM LastPlayer WHERE player1_id= '$player1_id' ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb get_last_player : $query"); $nb = jdm_mysql_num_rows($r); if ($nb<=0) { return -1; } else { return jdm_mysql_result($r , 0 , 1); } } function insert_friend($player1_id, $player2_id) { //start_time_record("insert_last_player"); if ($player1_id == "") {//echo "

bug in insert_friend : player1_id is null

"; return;} if ($player2_id == "") {//echo "

bug in insert_friend : player2_id is null

"; return;} $query = "SELECT playerid, friendid FROM PlayerFriends WHERE playerid= '$player1_id' and friendid= '$player2_id';"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb insert_friend : $query"); $nb = jdm_mysql_num_rows($r); if ($nb > 0) {return;} $query = "INSERT INTO `PlayerFriends` (playerid, friendid) VALUES ('$player1_id', '$player2_id');"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb insert_friend 2: $query"); //debugecho("insert_last_player=" . end_time_record("insert_last_player")); } function delete_friend($player1_id, $player2_id) { //start_time_record("insert_last_player"); if ($player1_id == "") {//echo "

bug in insert_friend : player1_id is null

"; return;} if ($player2_id == "") {//echo "

bug in insert_friend : player2_id is null

"; return;} $query = "DELETE FROM PlayerFriends WHERE playerid= '$player1_id' and friendid= '$player2_id';"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb delete_friend : $query"); $nb = jdm_mysql_num_rows($r); } function make_friend_list($playerid) { $str = ''; $query = "SELECT friendid FROM PlayerFriends WHERE playerid= '$playerid';"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb insert_friend : $query"); $nb = jdm_mysql_num_rows($r); if ($nb > 0) { $id = jdm_mysql_result($r , 0 , 0); $str = "($id"; for ($i=1 ; $i < jdm_mysql_num_rows($r) ; $i++) { $id = jdm_mysql_result($r , $i , 0); $str = $str . ", $id"; } $str = $str . ")"; } return $str; } function randomselection($c, $sql) { // run the query $result= jdm_mysql_query($sql) or userdiejdm($sql); // get the upper limit for rand() $up = jdm_mysql_num_rows($result)-1; // check that there is more data than rows required if ($up <= $c) { while ($row=mysqli_fetch_assoc($result)) { $selection[] = $row; } return $selection; } // set up array to hold primary keys AND elliminate duplicates // since random DOES NOT mean unique // or the query may not return DISTINCT rows $keys = array(); // get random selection while (count($keys) < $c) { // get random number for index $i = rand(0, $up); // move pointer to that row number AND fetch the data mysqli_data_seek($result, $i); $row = mysqli_fetch_assoc($result); // check if the primary key has already been fetched if (!in_array($row['id'], $keys)) { // store the row $selection[] = $row; // store the id to prevent duplication $keys[] = $row['id']; } } return $selection; } function make_raffinement_link_down($term) { if ($_SESSION[$GLOBALS['g_ssig'] .'playerid'] != 11) {return "";} if (has_some_raffinement_down($term) > 0) { return " > "; } } function make_raffinement_link_up($term) { if ($_SESSION[$GLOBALS['g_ssig'] .'playerid'] != 11) {return "";} if (has_some_raffinement_up($term) > 0) { return " < "; } } function has_some_raffinement_down($node1_name) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $id1 = term_exist_in_BD_p($node1_name); if ($id1 == 0) {return 0;} $query = "SELECT count(*) FROM Relations WHERE type=1 AND node1 = $id1 AND w>0 ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb has_some_raffinement_down 1: $query"); $nb = jdm_mysql_result($r , 0 , 0); return $nb; } function has_some_raffinement_up($node1_name) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $id1 = term_exist_in_BD_p($node1_name); if ($id1 == 0) {return 0;} $query = "SELECT count(*) FROM Relations WHERE type=1 AND node2 = $id1 AND w>0 ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb has_some_raffinement_up 1: $query"); $nb = jdm_mysql_result($r , 0 , 0); return $nb; } function get_raffinement_number($node1) { $query = "SELECT count(*) FROM Relations WHERE type=1 AND node1 = $node1 AND w>0 ; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb get_raffinement_number 1: $query"); $nb = jdm_mysql_result($r , 0 , 0); return $nb; } function display_toggle($bool) { if ($bool) {return "" ;} else {return "";} } function handle_toggle($toggle_tag, $url) { echo ""; if (($_GET[$toggle_tag] ?? null)=="1") { $_SESSION[$GLOBALS['g_ssig'] .$toggle_tag] = true;} if (($_GET[$toggle_tag] ?? null)=="0") { $_SESSION[$GLOBALS['g_ssig'] .$toggle_tag] = false;} if (($_SESSION[$GLOBALS['g_ssig'] .$toggle_tag] ?? null)) {$val=0;} else {$val=1;} $tag = display_toggle(($_SESSION[$GLOBALS['g_ssig'] .$toggle_tag] ?? null)); echo "

"; } function get_nb_token_term_comp($playerid, $termid, $compid) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ // echo "get_nb_token_term_comp($playerid, $termid, $compid)"; if ($termid == 0) {return 0;} $query = "SELECT SUM(P.token) FROM `PendingGames` as P WHERE P.creator = $playerid AND P.rel=$compid AND P.target = $termid;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in get_nb_token_term_comp : $query"); $nb = jdm_mysql_result($r , 0 , 0); // echo "nb=$nb"; return $nb; } function get_play_token($gameid) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $query = " SELECT token FROM `PendingGames` WHERE id= '$gameid' ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb get_play_token ($gameid) 1"); $nb = jdm_mysql_num_rows($r); if ($nb > 0) { $token = jdm_mysql_result($r , 0 , 0); return $token; } else { return -1; } } function decf_play_token ($gameid, $del=1) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ // combien de jeton pour cette partie ? // $query = " SELECT token FROM `PendingGames` WHERE id= '$gameid' ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb decf_play_token 1"); $nb = jdm_mysql_num_rows($r); if ($nb > 0) { $token = jdm_mysql_result($r , 0 , 0); if ($token > 10) { // on normalise... en cas de pb ou de triche $query = "UPDATE `PendingGames` SET token = 10 WHERE id= '$gameid';" ; $r1 = jdm_mysql_query_trace($query) or userdiejdm("pb decf_play_token 2"); } $query = "UPDATE `PendingGames` SET token = token-$del WHERE id= '$gameid' ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb decf_play_token 3"); $query = " SELECT token FROM `PendingGames` WHERE id= '$gameid' ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb decf_play_token 2"); $token = jdm_mysql_result($r , 0 , 0); if ($token >= 1) { // rien check_lock($gameid); } else { // si plus de jeton, on degage la partie et tout ce qui s'y rapporte // $lock = check_lock($gameid); if ($lock <= 0) { delete_game($gameid); } } } } // Ramene a 10 le nombre de jetons d'une partie qui en a plus (appele par GEN-loterie.php). // (audit) l'ancienne version testait "if ($token > 10)" alors que $token n'etait jamais lu dans le resultat : l'UPDATE ne se // faisait jamais et les jetons n'etaient donc jamais plafonnes. Un seul UPDATE conditionnel fait maintenant le travail. function normalize_play_token ($gameid) { $gameid = (int)$gameid; $query = "UPDATE `PendingGames` SET token = 10 WHERE id= '$gameid' AND token > 10;" ; $r1 = jdm_mysql_query_trace($query) or userdiejdm("pb normalize_play_token 2"); } function find_first_game($term, $playername, $rel) { $termid = term_exist_in_BD_p($term); $playerid = get_player_id($playername); $query = " SELECT id FROM `PendingGames` WHERE creator='$playerid' and rel='$rel' and target = '$termid' LIMIT 1;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb find_first_game 1"); $nb = jdm_mysql_num_rows($r); if ($nb > 0) { $gameid = jdm_mysql_result($r , 0 , 0); return $gameid; } else { return -1; } } function delete_game($gameid) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $query = "DELETE FROM `PendingGames` WHERE id= '$gameid' ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb delete_game 4"); $query = "DELETE FROM `PendingAnswers` WHERE gameId = '$gameid'"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb delete_game 5"); $query = "DELETE FROM `PendingGameData` WHERE gameId = '$gameid'"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb delete_game 6"); $query = "DELETE FROM `ProposedGames` WHERE gameId = '$gameid'"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb delete_game 7"); } function get_game_msg($gameid) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $query = "SELECT datastring FROM PendingGameData where gameId='$gameid' AND dataType='2'"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in get_game_msg($gameid)"); $nb = jdm_mysql_num_rows($r); $msg = ''; if ($nb > 0) { $msg = jdm_mysql_result($r , 0 , 0); } return $msg; } function delete_duplicates_termid($termid) { /* $query = "DELETE t1 FROM `Relations` t1 delete_duplicates_termid INNER JOIN `Relations` t2 WHERE t1.node1 = t2.node1 AND t1.node2 = t2.node2 AND t1.type = t2.type AND t1.id > t2.id AND t1.node1 = '$termid' ;" ; */ $query = " DELETE FROM Relations WHERE id IN ( SELECT id FROM ( SELECT t1.id FROM Relations t1 JOIN Relations t2 ON t1.node1 = t2.node1 AND t1.node2 = t2.node2 AND t1.type = t2.type AND t1.id > t2.id WHERE t1.node1 = '$termid' LIMIT 5000 ) AS sub ); "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in delete_duplicates_termid($termid)"); } // jdmmisc_update_network_relation function direct_update_entry_cleanup($termid) { $termid = (int)$termid; if ($termid <= 0) { return;} $q = "DELETE FROM Relations WHERE node1 = $termid AND node2 = $termid AND type IN (0, 666, 777, 5, 6, 72, 71, 61) LIMIT 8;"; $r = jdm_mysql_query($q) or userdiejdm("pb in direct_update_entry_cleanup 3 : $q"); } function direct_update_network_relation($node1, $node2, $relationtype, $incr=1, $initval=1) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ // echo "
direct_update_network_relation ($node1, $node2, $relationtype)"; if ($relationtype < 0) {return;} if ($node1 <= 0) {return;} if ($node2 <= 0) {return;} if ($node1 == 239128) {return;} /// NON !! // // DOUTE (non modifie) : '===' 0 ne matche qu'un entier 0 ; si $relationtype arrive en chaine ('0', cas courant // depuis $_REQUEST / SQL) ce test n'est jamais vrai et on peut creer une relation r_associated X -> X. if (($relationtype===0) && ($node1==$node2)) {return;} $query = "SELECT /* direct_update_network_relation */ id, w FROM `Relations` FORCE INDEX (`node1-node2-type`) WHERE node1=$node1 AND node2=$node2 AND type=$relationtype LIMIT 1 ;" ; $r3 = jdm_mysql_query($query) or userdiejdm("pb in direct_update_network_relation 3 : $query"); $nb3 = jdm_mysql_num_rows($r3); if ($nb3 > 0) { // la relation existe deja //echo "
updating relation between $node1 AND $node2"; if ($incr != 0) { $poids = jdm_mysql_result($r3 , 0 , 1); $query = "UPDATE /* direct_update_network_relation */ `Relations` FORCE INDEX (`node1-node2-type`) SET w = $incr + w WHERE node1=$node1 AND node2=$node2 AND type=$relationtype LIMIT 1;" ; //echo $query; $r = jdm_mysql_query($query) or userdiejdm("pb in direct_update_network_relation 6 : $query"); //echo "
la relation existe déja !!"; //$r = jdm_mysql_query_trace($query) or userdiejdm("pb update_network_relation 4 : $query"); } } else { // la relation n existe pas -> on insere //echo "
inserting relation between $node1 AND $node2"; $query = "INSERT /* direct_update_network_relation */ INTO Relations(node1, node2, type, w, creationdate) VALUES('$node1', '$node2', '$relationtype', $initval, CURRENT_DATE)"; //echo $query; $r = jdm_mysql_query($query) or userdiejdm("pb in direct_update_network_relation 6 : $query"); //echo "
la relation est validée !!"; } // maj du cache jdm_rel_written($node1, $node2, $relationtype); // (modif) remplace un SELECT de rafraichissement : l'ecriture ci-dessus a deja vide le cache (jdm_cache_note_write), le prochain lecteur $usecache relira la base } /* function direct_update_network_relation($node1, $node2, $relationtype, $incr=1, $initval=1) { //echo "
direct_update_network_relation ($node1, $node2, $relationtype)"; if ($relationtype < 0 || $node1 <= 0 || $node2 <= 0 || $node1 == 239128) { return; } $query = "UPDATE `Relations` SET w = $incr + w WHERE node1='$node1' AND node2='$node2' AND type='$relationtype' LIMIT 1;" ; $r = jdm_mysql_query($query); if ($r === FALSE) { userdiejdm("pb in direct_update_network_relation 1 : " . $query . " - Erreur : " . jdm_mysql_error()); } echo " affected = " . jdm_mysql_affected_rows($r) ; myflush(); // le == 0 est important if (jdm_mysql_affected_rows() == 0) { $query = "INSERT INTO Relations(node1, node2, type, w, creationdate) VALUES('$node1', '$node2', '$relationtype', $initval, CURRENT_TIMESTAMP)"; $r = jdm_mysql_query($query) or userdiejdm("pb in direct_update_network_relation 2 : $query - Erreur : " . jdm_mysql_error()); } } */ /* /// seulement si index UNIQUE function direct_update_network_relation($node1, $node2, $relationtype, $incr = 1, $initval = 1) { // Vérifications initiales if ($relationtype < 0 || $node1 <= 0 || $node2 <= 0 || $node1 == 239128) { return; } // Requête unique pour insérer ou mettre à jour $query = "INSERT INTO `Relations` (`node1`, `node2`, `type`, `w`, `creationdate`) VALUES ($node1, $node2, $relationtype, $initval, CURRENT_TIMESTAMP) ON DUPLICATE KEY UPDATE `w` = `w` + $incr;"; // Exécution de la requête $r = jdm_mysql_query($query) or userdiejdm("Problème dans direct_update_network_relation : $query"); } */ function update_network_relation ($term, $entryid, $gamerelationtype, $meanlevel=200) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $term = trim($term); if ($term == '') {return 0;} start_time_record("update_network_relation"); $points = 0; //$allrelnb_before=get_relation_number(); // DOUTE (non modifie) : $term est insere tel quel dans le SQL (ni echappement ni encodage UTF-8, contrairement // a l'INSERT plus bas qui utilise my_utf8_encode). A verifier d'ou vient $term ; sinon addslashes + encodage. $query = "SELECT id FROM `Nodes` WHERE Nodes.name = \"$term\" LIMIT 1 ;" ; //echo $query; $r2 = jdm_mysql_query_trace($query) or userdiejdm("pb in update_network_relation 1 : $query"); $nb2 = jdm_mysql_num_rows($r2); if ($nb2 > 0) { // le mot est deja dans la base // on met à jour $wid = jdm_mysql_result($r2 , 0 , 0); //echo "
updating word $wid $term"; $query = "UPDATE `Nodes` SET w=w+1 WHERE Nodes.name = \"$term\" LIMIT 1;"; //echo $query; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in update_network_relation 2 : $query"); // Gestion de la relation $query = "SELECT id, w FROM `Relations` FORCE INDEX (`node1-node2-type`) WHERE node1=$entryid AND node2=$wid AND type=$gamerelationtype LIMIT 1 ;" ; $r3 = jdm_mysql_query_trace($query) or userdiejdm("pb in update_network_relation 3 : $query"); $nb3 = jdm_mysql_num_rows($r3); if ($nb3 > 0) { // la relation existe deja $poids = jdm_mysql_result($r3 , 0 , 1); $points = $points+max(1,round((1000-$poids)/20)); $query = "UPDATE `Relations` FORCE INDEX (`node1-node2-type`) SET w = w+10, infoid=0 WHERE node1='$entryid' AND node2='$wid' AND type='$gamerelationtype' LIMIT 1;" ; $r = jdm_mysql_query_trace($query) or userdiejdm("pb update_network_relation 4 : $query"); $query = "UPDATE `Nodes` SET w=w+1 WHERE id='$wid' LIMIT 1;" ; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in update_network_relation 5 : $query"); } else { // la relation n existe pas -> on insere //echo "
inserting relation between $entry AND $term"; $_SESSION[$GLOBALS['g_ssig'] .'newrelcount'] = $_SESSION[$GLOBALS['g_ssig'] .'newrelcount'] + 1; $query = "INSERT INTO Relations (node1, node2, type, w, creationdate) VALUES('$entryid', '$wid', '$gamerelationtype', 50, CURRENT_DATE)"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in update_network_relation 6 : $query"); $query = "UPDATE `Nodes` SET w=w+1 WHERE id='$wid' LIMIT 1;" ; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in update_network_relation 7 : $query"); $points = $points+50; } } else { //echo "
inserting word $term"; // bonus pour un mot nouveau $term_enc = my_utf8_encode($term); // 'game' = 99999 $infoID = 99999 ; $query = "INSERT INTO Nodes (name, type, w, creationdate, level, infoid) VALUES(\"$term_enc\" , 1 , 50, CURRENT_TIMESTAMP, $meanlevel, $infoID) ;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in update_network_relation inserting new node : $query"); $LASTPGID = jdm_mysql_insert_id(); $wid = $LASTPGID; $points = $points+20; // insertion de la relation // //echo "
inserting relation between $entry AND $term"; $query = "INSERT INTO Relations (node1, node2, type, w, creationdate) VALUES('$entryid', '$LASTPGID', '$gamerelationtype', 50, CURRENT_DATE)"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb in update_network_relation inserting rel after new node : $query"); $points = $points+50; } //$allrelnb_after=get_relation_number(); //process_relation_increase($allrelnb_before,$allrelnb_after); $factor = term_get_log_freq($wid); debugecho("update_network_relation" . end_time_record("update_network_relation")); return round($points/$factor); } function display_relation_increase($th, $g, $msg=-1) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; if ($playerid <= 0) {return;} $playername = get_player_name($playerid); if ($msg == -1) { $msg = "$playername a fait passer un cap de $th relations. Bravo ! + $g H"; } make_event($msg); inc_player_honnor($playerid, $g); add_notification('Un cap, une péninsule...', "Bravo ! Vous venez de faire passer un cap de $th relations.
+ $g points H"); } function process_relation_increase($nb_before,$nb_after) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; if ($playerid <= 0) {return;} // DIX MILLIONS $th = 10000000; $g = 66666; $mod1_before = floor($nb_before/$th); $mod1_after = floor($nb_after/$th); if ($mod1_after > $mod1_before) { $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; $playername = get_player_name($playerid); display_relation_increase($th, $g, "$playername est tout simplement magn de sublime et a fait passer un cap de 10 MILLIONS de relations. Bravo ! + $g H"); return; } $th = 1000000; $g = 10000; $mod1_before = floor($nb_before/$th); $mod1_after = floor($nb_after/$th); if ($mod1_after > $mod1_before) { $playerid = $_SESSION[$GLOBALS['g_ssig'] .'playerid']; $playername = get_player_name($playerid); display_relation_increase($th, $g, "$playername est irrésistible et a fait passer un cap de UN MILLION de relations. Bravo ! + $g H"); return; } $th = 100000; $g = 2500; $mod1_before = floor($nb_before/$th); $mod1_after = floor($nb_after/$th); if ($mod1_after > $mod1_before) { display_relation_increase($th, $g); return; } $th = 10000; $g = 500; $mod1_before = floor($nb_before/$th); $mod1_after = floor($nb_after/$th); if ($mod1_after > $mod1_before) { display_relation_increase($th, $g); return; } $th = 1000; $g = 100; $mod1_before = floor($nb_before/$th); $mod1_after = floor($nb_after/$th); if ($mod1_after > $mod1_before) { display_relation_increase($th, $g); return; } $th = 100; $g = 20; $mod1_before = floor($nb_before/$th); $mod1_after = floor($nb_after/$th); if ($mod1_after > $mod1_before) { display_relation_increase($th, $g); return; } /*$th = 1; $g = 0; $mod1_before = floor($nb_before/$th); $mod1_after = floor($nb_after/$th); if ($mod1_after > $mod1_before) { display_relation_increase($th, $g); return; }*/ } //---------------------- function update_honnor_score($playerid) { $h=get_player_honnor($playerid); $query = "INSERT INTO `Scores` (id, score, date) VALUES ('$playerid','$h', CURRENT_TIMESTAMP);"; //echo $query; $r = jdm_mysql_query_trace($query) or userdiejdm("bug dans update_honnor_score :$query"); } function update_some_honnor_scores() { $query = "SELECT id FROM `Players` WHERE TO_DAYS(NOW()) - TO_DAYS(lastlogin) <= 30 AND id NOT IN (SELECT id FROM `Scores` WHERE (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(date))/3600 < 24) ORDER BY Rand() LIMIT 50;"; $r = jdm_mysql_query_trace($query) or userdiejdm("bug dans update_some_honnor_scores :$query"); $nb = jdm_mysql_num_rows($r); for ($i=0 ; $i<$nb ; $i++) { $playerid = jdm_mysql_result($r , $i , 0); update_honnor_score($playerid); } } function check_referer() { $_SESSION[$GLOBALS['g_ssig'] .'FRAUD'] = false; if ($_SESSION[$GLOBALS['g_ssig'] .'playerid'] == 22) { print "
\n";
		print "\nContents of \$_SERVER:\n";
   		foreach ($_SERVER as $k => $v) {
     		print "   $k = $v\n";
   		}
   		print "
\n"; } if (($_SERVER['HTTP_REFERER'] ?? null)=="") { $_SESSION[$GLOBALS['g_ssig'] .'FRAUD'] = true; echo "

Accès frauduleux... retournez à l'accueil"; $h = get_player_honnor($_SESSION[$GLOBALS['g_ssig'] .'playerid']); $c = get_player_credit($_SESSION[$GLOBALS['g_ssig'] .'playerid']); //inc_player_honnor($_SESSION[$GLOBALS['g_ssig'] .'playerid'], -1*round(0.1*$h)); //inc_player_credit($_SESSION[$GLOBALS['g_ssig'] .'playerid'], -1*round(0.1*$c)); $p1 = get_player_name($_SESSION[$GLOBALS['g_ssig'] .'playerid']); //make_event("'$p1' tente de tricher..."); } } function term_comp_no_relation_p ($termid, $relid) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ start_time_record("term_comp_no_relation_p"); $query = "Select id FROM Relations WHERE node1 = $termid AND type=$relid LIMIT 1"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb term_comp_no_relation_p 1 : $query"); $nb = jdm_mysql_num_rows($r); debugecho("term_comp_no_relation_p=" . end_time_record("term_comp_no_relation_p")); if ($nb == 0) { return true; } else { return false; } } /// /// Gestion poids des noeuds /// // GET W function term_get_w ($termid) { $query = "SELECT w FROM Nodes WHERE id = $termid LIMIT 1;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb term_get_w 1 : $query"); $poids = jdm_mysql_result($r , 0 , 0); return $poids; } function term_get_w_name ($term) { $term_enc = my_utf8_encode($term); $query = "SELECT w FROM Nodes WHERE name = \"$term_enc\" LIMIT 1;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb term_get_w_name 1 : $query"); $poids = jdm_mysql_result($r , 0 , 0); return $poids; } // GET W log freq function term_get_log_freq ($termid) { $__jdmt = isset($GLOBALS['jdm_trace']) ? jdm_trace_fn(__FUNCTION__) : null; /* (trace) */ $query = "SELECT w FROM Nodes WHERE id = $termid LIMIT 1;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb term_get_log_freq 1 : $query"); $poids = jdm_mysql_result($r , 0 , 0); return max(1, log($poids/100, 10)); } // SET W function term_set_w ($termid, $w) { $query = "UPDATE `Nodes` SET `w` = '$w' WHERE id = $termid LIMIT 1; "; $r = jdm_mysql_query_trace($query) or userdiejdm("pb term_set_w 1 : $query"); } function term_set_w_name ($term, $w) { $query = "UPDATE `Nodes` SET `w` = '$w' WHERE name = \"$term\" LIMIT 1;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb term_set_w_name 1 : $query"); } // INCF W function term_incf_w ($termid, $inc) { $query = "UPDATE `Nodes` SET `w` = w + '$inc' WHERE id = $termid LIMIT 1;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb term_incf_w 1 : $query"); } function term_incf_w_name ($term, $inc) { $query = "UPDATE `Nodes` SET `w` = w + '$inc' WHERE name = \"$term\" LIMIT 1;"; $r = jdm_mysql_query_trace($query) or userdiejdm("pb term_incf_w_name 1 : $query"); } /// /// /// function my_marquee() { echo "

"; echo ""; echo "top du top : n@t"; echo "  •   joueur plus innovant : luciole"; echo "  •   joueur le plus efficace : enc...moi"; echo "  •   joueur le plus riche : agnes"; echo "  •   joueur le plus collectionneur : Exelmans"; echo ""; echo "
"; } function generate_no_script(){ /* echo "
";*/ echo " \n