function player($dest, $user) { global $rank; $chc = ""; $tok= strtok($user," "); while($tok !== false) { $chc .= "'".$tok."',"; //on coupe mot à mot et rajoute , $tok = strtok(" "); //suivant } $chc = substr($chc,0,strlen($chc) - 1); // On vire le , qui reste dans la string $query='select * from player where name IN ('.$chc.')'; //say($dest,$query); //dedug msg $query_sql=mysql_query($query); $result=mysql_fetch_array($query_sql); $name=$user; $influ_rank=$result['influ_rank']; $influ_score=$result['influ_score']; $idr_rank=$result['idr_rank']; $idr_score=$result['idr_score']; $hyp_rank_num=$result['hyp_rank']; $hyp_rank=$rank["$hyp_rank_num"]; $now=time(); //temp actuel $twodago=$now-(2*24*3600); $query_hist='select * from player_hist where name IN ('.$chc.') AND date BETWEEN '.$twodago.' AND '.$now.' '; //say($dest,$query_hist); $query_sql_hist=mysql_query($query_hist); $result_hist=mysql_fetch_array($query_sql_hist); //calculons la diff $diff_infr=$result['influ_rank'] - $result_hist['influ_rank']; $diff_infs=$result['influ_score'] - $result_hist['influ_score']; $diff_idr=$result['idr_rank'] - $result_hist['idr_rank']; $diff_ids=$result['idr_score'] -$result_hist['idr_score']; //say($dest,$diff_idr); $msg = $hyp_rank.' '.$name.' infr: '.$influ_rank.'('.$diff_infr.')'.' infs: '.$influ_score.'('.$diff_infs.')'.' idr: '.$idr_rank.'('.$diff_idr.')'.' ids: '.$idr_score.'('.$diff_ids.')'; say($dest,$msg); }#############dans draybot.php:if ($command == "!r") { list($cmd,$message) = explode(" ",$message,2); player($fromto,$message); }