Witajcie,

Próbuję za pomocą http://www.maani.us/xml_charts wygenerować sobie prosty (jak mi się wydawało) wykres. Ma on wyświetlać wyniki graczy.
Tabele:
GAME, PLAYER oraz ENTRY (wyjaśnień chyba nie potrzeba).
Wykres się generuje, ale mam "przesunięcie" - tzn nie generuje się na poziomej osi pierwsza wartość, z kolei w wynikach (słupkach) nie pokazuje się wynik ostatni. Męczę się z tym już 2 dzień, gdzieś pewnie jakiś iterator....
Zerkniecie? Z góry dzięki.

  1. $terminy_gier = array();
  2. $wyniki = array();
  3.  
  4. //********************************************************************************
    *
  5. // Terminy gier
  6. //********************************************************************************
    *
  7. $query1 = "SELECT G_ID, G_DATE FROM GAME WHERE G_STATS = 1";
  8. $result1 = @mysql_query ($query1);
  9. while($row1 = mysql_fetch_array ($result1, MYSQL_NUM)){
  10. $terminy_gier[$row1[0]] = $row1[1];
  11. }
  12.  
  13. //********************************************************************************
    *
  14. // ID i LOGIN
  15. //********************************************************************************
    *
  16.  
  17. $query2 = "SELECT DISTINCT P_ID, P_LOGIN FROM PLAYER INNER JOIN ENTRY ON P_ID = E_P_ID WHERE E_RESULT IS NOT NULL";
  18. $result2 = @mysql_query ($query2);
  19. while($row2 = mysql_fetch_array ($result2, MYSQL_NUM)){
  20. $wyniki[$row2[0]][0] = $row2[1];
  21. }
  22.  
  23. //********************************************************************************
    *
  24. // Wyniki
  25. //********************************************************************************
    *
  26.  
  27. $query3 = "SELECT E_P_ID, E_G_ID, E_RESULT FROM ENTRY WHERE E_RESULT IS NOT NULL";
  28. $result3 = @mysql_query ($query3);
  29. while($row3 = mysql_fetch_array ($result3, MYSQL_NUM)){
  30. $wyniki[$row3[0]][$row3[1]] = $row3[2];
  31. }
  32.  
  33. //********************************************************************************
    *
  34. // Wygenerowanie wykresu
  35. //********************************************************************************
    *
  36.  
  37. include "../charts/charts.php";
  38.  
  39. //pozioma skala
  40. $chart[ 'axis_category' ] = array ( 'size'=>10, 'color'=>"ffffff", 'alpha'=>50, 'font'=>"arial", 'bold'=>true, 'skip'=>0 ,'orientation'=>"vertical_up" );
  41. //pionowa skala
  42. $chart[ 'axis_value' ] = array ( 'min'=>-200, 'max'=>200, 'font'=>"arial", 'bold'=>true, 'size'=>10, 'color'=>"ffffff", 'alpha'=>50, 'steps'=>8, 'prefix'=>"", 'suffix'=>"", 'decimals'=>2, 'separator'=>"", 'show_min'=>true);
  43. //podzialki na pionowej skali
  44. $chart[ 'axis_ticks' ] = array ( 'value_ticks'=>true, 'category_ticks'=>true, 'major_thickness'=>2, 'minor_thickness'=>1, 'minor_count'=>1, 'major_color'=>"000000", 'minor_color'=>"222222" ,'position'=>"outside" );
  45. //poziomy grid line
  46. $chart[ 'chart_grid_h' ] = array ( 'alpha'=>10, 'color'=>"000000", 'thickness'=>1, 'type'=>"solid" );
  47. //pionowy grid line
  48. $chart[ 'chart_grid_v' ] = array ( 'alpha'=>10, 'color'=>"000000", 'thickness'=>1, 'type'=>"solid" );
  49. //ramka wykresu
  50. $chart[ 'chart_border' ] = array ( 'color'=>"000000", 'top_thickness'=>2, 'bottom_thickness'=>2, 'left_thickness'=>2, 'right_thickness'=>2 );
  51. //preferencje wykresu
  52. $chart[ 'chart_pref' ] = array ( 'line_thickness'=>2, 'point_shape'=>"none", 'fill_shape'=>false );
  53. //tlo wykresu
  54. $chart[ 'chart_rect' ] = array ( 'x'=>70, 'y'=>25, 'width'=>500, 'height'=>200, 'positive_color'=>"000000", 'positive_alpha'=>30, 'negative_color'=>"ff0000", 'negative_alpha'=>10 );
  55. //typ wykresu
  56. $chart[ 'chart_type' ] = "column";
  57. //wartosci na wykresie
  58. $chart[ 'chart_value' ] = array ( 'prefix'=>"", 'suffix'=>"", 'decimals'=>2, 'separator'=>"", 'position'=>"cursor", 'hide_zero'=>true, 'as_percentage'=>false, 'font'=>"arial", 'bold'=>true, 'size'=>12, 'color'=>"ffffff", 'alpha'=>75 );
  59. //Opis i inne
  60. $chart[ 'draw' ] = array ( array ( 'type'=>"text", 'color'=>"ffffff", 'alpha'=>15, 'font'=>"arial", 'rotation'=>-90, 'bold'=>true, 'size'=>30, 'x'=>0, 'y'=>250, 'width'=>250, 'height'=>150, 'text'=>"Wynik w PLN", 'h_align'=>"center", 'v_align'=>"top" ),
  61. array ( 'type'=>"text", 'color'=>"000000", 'alpha'=>15, 'font'=>"arial", 'rotation'=>0, 'bold'=>true, 'size'=>30, 'x'=>275, 'y'=>50, 'width'=>200, 'height'=>270, 'text'=>"Gry", 'h_align'=>"left", 'v_align'=>"bottom" ) );
  62. //legenda
  63. $chart[ 'legend_rect' ] = array ( 'x'=>580, 'y'=>30, 'width'=>80, 'height'=>40, 'margin'=>3 );
  64. //legenda
  65. $chart[ 'legend_label' ] = array ( 'layout'=>"vertical", 'bullet'=>"square", 'font'=>"arial", 'bold'=>false, 'size'=>9, 'color'=>"000000" );
  66. //kolory wykresow
  67. $chart[ 'series_color' ] = array ( "FFFF00", "FFFFFF", "cc5511", "800000", "FF0000","800080","FF00FF","008000","00FF00","91BDD3","C0C0C0", "000080", "0000FF" );
  68. //dane
  69. $chart[ 'chart_data' ] = array ($terminy_gier, $wyniki[3], $wyniki[4], $wyniki[9], $wyniki[13], $wyniki[29]);
  70. //
  71. SendChartData ( $chart );
  72.