Previous matches in nextmatch (JL 2.x and JL 3.x)

Status: under development
Branch: https://gitlab.com/joomleague/joomleague/tree/3.0.0

Moderator: And_One

MSK
.
Posts: 72
Joined: Sun Jul 21, 2013 12:12 pm

Previous matches in nextmatch (JL 2.x and JL 3.x)

Postby MSK » Thu Jan 21, 2016 2:55 pm

Feature "Previous matches in nextmatch" doesn't work both for JL 2.x and JL 3.x. But it works in JL 1.6

In the "frontend settings" we go to the "nextmatch" where this feature is. This function is in JL 1.6 , 2.5 and 3.x.

How it must work (from JL 1.6 screen).
16-exmaple.png

We see 5 (5 - as in frontend options) last matches for each team.


Frontend options for Nextmatch - Pic from JL 3.x :
jl-prev5.png



But in JL 2.x and 3.x there are bugs.
Pic from JL 2.x (only 1 match for each team? Settings = 5)
jl2x-prev.png


Continue to the next post (can't attach more than 3 files)
You do not have the required permissions to view the files attached to this post.

MSK
.
Posts: 72
Joined: Sun Jul 21, 2013 12:12 pm

Re: Previous matches in nextmatch (JL 2.x and JL 3.x)

Postby MSK » Thu Jan 21, 2016 3:07 pm

Pic from JL 3.x (settings = 5)

jl3x-prev.png


The result is strange. But in other team's nexmatch there are previous games for only 1 team. The results are different in different team's nextmatches.

The SQL query for JL 2.x and 3.x are identical :

Code: Select all

SELECT m.*, r.project_id, r.id AS roundid, r.roundcode, p.timezone, pt1.division_id
  FROM prefix_joomleague_match AS m
  INNER JOIN prefix_joomleague_round AS r
  ON r.id = m.round_id
  INNER JOIN prefix_joomleague_project AS p
  ON p.id = r.project_id
  INNER JOIN prefix_joomleague_project_team AS pt1
  ON p.id = m.projectteam1_id
  WHERE (m.projectteam1_id = 11 OR m.projectteam2_id = 11)
  AND r.roundcode < 14
  AND m.published = 1
  GROUP BY m.id
  ORDER BY r.roundcode DESC
  LIMIT 0, 5


JL 1.6 query:

Code: Select all

SELECT m.*, r.project_id, r.id AS roundid, r.roundcode 
  FROM prefix_joomleague_match AS m 
  INNER JOIN prefix_joomleague_round AS r
  ON r.id = m.round_id 
  WHERE (m.projectteam1_id = 2       OR m.projectteam2_id = 2) 
  AND r.roundcode < 6 
  AND m.published = 1 
  ORDER BY r.roundcode DESC 
  LIMIT 0, 5


This problem is in /components/com_joomleague/models/nexmatch.php
I think this function must show all the last matches for each team from any published projects? Not only from the actual project?

It will be nice to fix it both for JL 2.x and 3.x!
You do not have the required permissions to view the files attached to this post.

zicoo
.
Posts: 40
Joined: Thu Nov 26, 2009 9:13 am

Re: Previous matches in nextmatch (JL 2.x and JL 3.x)

Postby zicoo » Wed Aug 31, 2016 7:57 am

someone solved this problem?

User avatar
prevalje
.
Posts: 45
Joined: Sat Aug 30, 2008 11:31 pm

Re: Previous matches in nextmatch (JL 2.x and JL 3.x)

Postby prevalje » Wed Feb 15, 2017 12:48 am

i have same problem!

JoomLeague - Version 3.0.21.124789c ::


Return to “3.0.22.57ae969-Blue (Joomla: 3.x)”

Who is online

Users browsing this forum: No registered users and 4 guests

cron