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); while($result=mysql_fetch_array($query_sql)) { if(sizeof($result) == 1) { say($dest,"User not found!"); } else { $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']; if($diff_infr > 0) $diff_infr = color(dark_green,'+'.number_format($diff_infr)); elseif($diff_infr <0) $diff_infr = color(red,number_format($diff_infr)); else $diff_infr = color(blue,'='); $diff_infs=$result['influ_score'] - $result_hist['influ_score']; if($diff_infs > 0) $diff_infs = color(dark_green,'+'.number_format($diff_infs)); elseif($diff_infs <0) $diff_infs = color(red,number_format($diff_infs)); else $diff_infs = color(blue,'='); $diff_idr=$result['idr_rank'] - $result_hist['idr_rank']; if($diff_idr > 0) $diff_idr = color(dark_green,'+'.number_format($diff_idr)); elseif($diff_idr <0) $diff_idr = color(red,number_format($diff_idr)); else $diff_idr = color(blue,'='); $diff_ids=$result['idr_score'] - $result_hist['idr_score']; if($diff_ids > 0) $diff_ids = color(dark_green,'+'.number_format($diff_ids)); elseif($diff_ids <0) $diff_ids = color(red,number_format($diff_ids)); else $diff_ids = color(blue,'='); //say($dest,$diff_idr); $msg = $hyp_rank.' '.color(dark_blue,$name).' - infr: '.color(cyan,number_format($influ_rank)).' ('.$diff_infr.')'.' - infs '.color(dark_red,number_format($influ_score)).' ('.$diff_infs.')'.' - idr: '.color(dark_gray,number_format($idr_rank)).' ('.$diff_idr.')'.' - ids: '.color(dark_purple,number_format($idr_score)).' ('.$diff_ids.')'; say($dest,$msg); } } }