WordPress.org

1. koelle
   Member
   Posted 6 months ago #

   Hello everybody,

   finally I managed to complete LeagueManager Version 2.9. It introduces several changes and new features, the most important being a modular setup with several Wordpress actions and filters for easy implementation of different sport types. Here's a brief list:

   * Modular setup and several new sport types
   * unlimited number of widgets
   * different dropdown menues for match report
   * easy adding of custom fields for matches and teams via WP hooks
   * match statistics
   * shortcodes to show teamlist and single team page
   * TeamRoster via bridge to ProjectManager (for match stats)
   * track team rank of previous save

   Due to the growing complexity and number of sport types I cannot provide templates to cover everything. I can only impement the basic features to gather all needed data. I encourage anybody who to design new templates for any specific sport type or just for the fun of it. You can then send them to me by email for inclusion into the main plugin.

   The second topic I'd like to address here is a Championchip Mode. Unfortunately I don't have enough time to further develop this feature, as it would be highly complex. However I have some preliminary code, that resides in lib/championchip.php and admin/championchip.php. It follows a list of features I thought would be needed:

   * Option to set number of teams that adavance from preliminary round to final round (easy with WP action)
   * insert groups (like Seasons)
   * dropdown in team edit form to allocate group to team (easy with WP action)
   * Add final matches beforehand in a style Winner A - Second B (present)
   * replace code format of final matches with respective team

   So the basic features of the plugin already exist or are quite easy to implement. However the last part of inserting the true teams for respective final matches is quite complicated. My idea would be to add buttons to proceed into the next round.

   Is there anybody or group who would be willing to work on this feature. It should be already possible with LeagueManager 2.9 to implement a Championchip Mode as standalone-plugin. If not, I would provide needed hooks.

   I hope there is somebody who could work on that, because I think it would be a very cool feature.

   http://wordpress.org/extend/plugins/leaguemanager/

2. real_sanchez
   Member
   Posted 6 months ago #

   following problems after update from 2.9 RC1:

   1. Problem in matchday list: (cannot be displayed)

   WordPress database error: [Unknown column 'final' in 'where clause']
   SELECT <code>home_team</code>, <code>away_team</code>, DATE_FORMAT(<code>date</code>, '%Y-%m-%d %H:%i') AS date, DATE_FORMAT(<code>date</code>, '%e') AS day, DATE_FORMAT(<code>date</code>, '%c') AS month, DATE_FORMAT(<code>date</code>, '%Y') AS year, DATE_FORMAT(<code>date</code>, '%H') AS <code>hour</code>, DATE_FORMAT(<code>date</code>, '%i') AS <code>minutes</code>, <code>match_day</code>, <code>location</code>, <code>league_id</code>, <code>home_points</code>, <code>away_points</code>, <code>winner_id</code>, <code>post_id</code>, <code>points2</code>, <code>season</code>, <code>id</code>, <code>custom</code> FROM wp_leaguemanager_matches WHERE <code>league_id</code> = "1" AND <code>final</code> = "" AND <code>season</code> = '0809' ORDER BY <code>date</code> ASC

   2.Problem
   lost goals of standings

   3. Problem
   Add league Button in WYSIWYG editor dont works, in popup window only the message: wp-config.php not found... but there is still a config file for wordpress on my server.

   4. Problem
   cannot update league standings manually, if more then 19 teams are in my league.

   5. dropdown field for switching matchdays missing.

3. koelle
   Member
   Posted 6 months ago #

   All the issues, except for the point 4, should be fixed with the next version.

   The problem with many teams is somewhat disturbing, as I use a while loop over all teams, as is the case for match results. Does anybody know how to solve this?

   What Server and PHP version are you using?

4. koelle
   Member
   Posted 6 months ago #

   People who would like to work on a Championchip Mode please use my Blog post to reply.

5. real_sanchez
   Member
   Posted 6 months ago #

   All the issues, except for the point 4, should be fixed with the next version.

   The problem with many teams is somewhat disturbing, as I use a while loop over all teams, as is the case for match results. Does anybody know how to solve this?

   What Server and PHP version are you using?

   hi koelle,
   i can send u a new show-league.php file. In this version it works, and i can edit league standing with more then 19 teams manually. This file is from version 2.9 RC1. Its only a temporary fix for the plugin on my website. So its not really a solution, but maybe it helps you to find the bug.

   I tested the new version 2.9 on two server and on both systems the same problem with more then 19 teams:

   1. Server: FreeBSD PHP 5.2.9, MySQL 5 located in HongKong
   2. Server: SuseLinux PHP 5.2.5, MySQL 5 located in Germany

   Give me ur e-mail addy and i send u my temporary working show-league.php

6. koelle
   Member
   Posted 6 months ago #

   my email is kolja [dot] schleich [at] googlemail [dot] com

7. thisisfootball
   Member
   Posted 5 months ago #

   I have installed the plugin recently but when I enter the results score for the away team does not register in database.

   All the points work perfectly but this means the goals scored and goals conceded is wrong for all teams.

   I have 24 teams in my league.

8. koelle
   Member
   Posted 5 months ago #

   what sport type?

9. thisisfootball
   Member
   Posted 5 months ago #

   This has fixed now (caused by a missing line in the db), but the problem I'm getting no teams show upon the fixtures page. The sport I'm doing it for is soccer.

   http://www.thisisfootball.co.uk/thisisfootball/?page_id=646

10. koelle
    Member
    Posted 5 months ago #

    are the teams displayed in the admin interface? what shortcode do you use?

11. thisisfootball
    Member
    Posted 5 months ago #

    This has fixed now (caused by a missing line in the db), but the problem I'm getting no teams show upon the fixtures page. The sport I'm doing it for is soccer.

    http://www.thisisfootball.co.uk/thisisfootball/?page_id=646

12. koelle
    Member
    Posted 5 months ago #

    are the teams displayed in the admin interface? what shortcode do you use for display in the frontend?

13. thisisfootball
    Member
    Posted 5 months ago #

    They do display in admin, the shortcode I use is [matches league_id=6 mode=all]

14. thisisfootball
    Member
    Posted 5 months ago #

    If we can get this all working as we want we'll be making a donation.

    Thanks for you help in advance.

15. koelle
    Member
    Posted 5 months ago #

    Try Version 3.0.3. For me it worked.

16. thisisfootball
    Member
    Posted 5 months ago #

    Did a full fresh install of 3.0.3 and I'm getting the same problem. Any ideas?

17. thisisfootball
    Member
    Posted 5 months ago #

    It looks like it can't connect to wp_leaguemanager_teams to get the title. If I remove ['title'] from the code it does show the IDs of both teams.

18. thisisfootball
    Member
    Posted 5 months ago #

    Sorry, confused matters there, I replaced the front end code in matches.php with the back end code to see if it would pull in the team names. When I did this I could get the ID but still no team name.

19. koelle
    Member
    Posted 5 months ago #

    Hey,

    do you use the default template or did you create a custom one? Could you do <?php print_r($matches) ?> in the template (If you use the default it's view/matches.php) and post the output here.

20. thisisfootball
    Member
    Posted 5 months ago #

    Here's the result, I use the default template.

    Array ( [0] => stdClass Object ( [home_team] => 63 [away_team] => 64 [date] => 2009-06-06 20:00 [day] => 6 [month] => 6 [year] => 2009 [hour] => 20 [minutes] => 00 [match_day] => 1 [location] => Test [league_id] => 6 [home_points] => 0 [away_points] => 0 [winner_id] => 0 [post_id] => 0 [season] => 09/10 [id] => 8 [custom] => [0] => [class] => alternate [hadPenalty] => [hadOvertime] => [start_time] => 8:00 pm [title] => - [report] => [score] => 0 - 0 ) )

21. koelle
    Member
    Posted 5 months ago #

    Wow, that was fast :)
    Next test. In lib/shortcodes.php there is the function showMatches().
    After the line

    $teams = $leaguemanager->getTeams("...", "ARRAY"):

    do

    print_r($teams);

    Also after

    $matches = getMatches($search, false, $order);

    do, before the foreach-loop

    print_r($matches)

22. thisisfootball
    Member
    Posted 5 months ago #

    I've added those.

23. thisisfootball
    Member
    Posted 5 months ago #

    Here you go: Array ( ) Array ( [0] => stdClass Object ( [home_team] => 63 [away_team] => 64 [date] => 2009-06-06 20:00 [day] => 6 [month] => 6 [year] => 2009 [hour] => 20 [minutes] => 00 [match_day] => 1 [location] => Test [league_id] => 6 [home_points] => 0 [away_points] => 0 [winner_id] => 0 [post_id] => 0 [season] => 09/10 [id] => 8 [custom] => [0] => ) ) Array ( [0] => stdClass Object ( [home_team] => 63 [away_team] => 64 [date] => 2009-06-06 20:00 [day] => 6 [month] => 6 [year] => 2009 [hour] => 20 [minutes] => 00 [match_day] => 1 [location] => Test [league_id] => 6 [home_points] => 0 [away_points] => 0 [winner_id] => 0 [post_id] => 0 [season] => 09/10 [id] => 8 [custom] => [0] => [class] => alternate [hadPenalty] => [hadOvertime] => [start_time] => 8:00 pm [title] => - [report] => [score] => 0 - 0 ) )

24. koelle
    Member
    Posted 5 months ago #

    OK, so the teams aren't retrieved from the database. What does

    echo $season;

    and

    echo $league_id

    in the showMatches function give?

25. thisisfootball
    Member
    Posted 5 months ago #

    The league id didn't show up.

26. koelle
    Member
    Posted 5 months ago #

    I have figured it out. The problem was that the MySQL query for the teams only worked with seasons that were just numbers (e.g. 2009), but not with string such as you had "08/09". I have released a patch (Version 3.0.4), which should fix it. It should be available within the next 15 minutes.

27. thisisfootball
    Member
    Posted 5 months ago #

    Thanks, that is great news. i'll sort out a donation, you've been a massive help.

28. s.gardner
    Member
    Posted 2 months ago #

    I have an issue I can't solve myself and need help please!

    I mistakenly added a league match and posted the results from said match only to later find out the match was infact a cup tie and should not have been posted.

    I need to remove this match and its result from the league as the league table is showing false information due to my ignorance.

    I have tried deleting the match from the match list but this does not effect the league table and the match still exisists but only as a 0-0 result (the actual result was 5-2).

    Can someone please help me?

    Thanks
    Steven Gardner

Reply

You must log in to post.