Testseite flashchart

{flashchart width="700" title="Statistik RWK 2012 2. Mannschaft" legend="Schuetze 1,Schuetze 2" type="line_dotted" line_animation="drop" y_min="320" y_max="400" y_step="10" dimension=" Ringe" x_label_rotate="40" x_step="2" data="database" sql="SELECT CONCAT_WS(' ',pr.lastname, pr.firstname) AS schuetze, me.event_sum as rwkergebnis FROM jos_joomleague_match_event AS me INNER JOIN jos_joomleague_team_player AS tp ON tp.id=me.teamplayer_id INNER JOIN jos_joomleague_person AS pr ON pr.id=tp.person_id WHERE me.teamplayer_id =5 OR me.teamplayer_id =7 ORDER BY me.teamplayer_id"}chart_id{/flashchart}

{flashchart width="700" title="Statistik RWK 2012 2. Mannschaft" legend="Herz Roland,Jörg Stefan" type="line_dotted" line_animation="drop" y_min="320" y_max="400" y_step="10" dimension=" Ringe" x_label_rotate="40" x_step="1" x_axis_labels="1,2,3,4,5,6,7,8,9,10" sql_labels="0" data="database" sql="SELECT me.event_sum AS rwkergebnis,me2.event_sum AS rwkergebnis2
FROM (jos_joomleague_match_event AS me, jos_joomleague_match_event AS me2)
WHERE me.teamplayer_id =5
AND me2.teamplayer_id =7
AND me.match_id=me2.match_id"}chart_id2{/flashchart}

SELECT me.event_sum AS rwkergebnis,me2.event_sum AS rwkergebnis2,me3.event_sum AS rwkergebnis3
FROM (jos_joomleague_match_event AS me, jos_joomleague_match_event AS me2, jos_joomleague_match_event AS me3)
WHERE me.teamplayer_id =5
AND me2.teamplayer_id =7
AND me3.teamplayer_id =22
AND me.match_id=me2.match_id
AND me2.match_id=me3.match_id

das geht nur, wenn alle Schützen, genau gleich viele RWKs geschossen haben :(

• Weiter >