stylinjimp

Hi Lamonte,

I tried to reach you on a few threads but have not been successful. Running into a problem with Championship mode. When entering teams in for Quarter final matches, I can add one match, but any time I try to add a second one, I get this Error:

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
SELECT custom FROM wp_leaguemanager_matches WHERE id =

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
SELECT custom FROM wp_leaguemanager_matches WHERE id =

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
SELECT custom FROM wp_leaguemanager_matches WHERE id =

ANY Suggestions would be greatly appreciated.

Hi Lamonte,

When will the feature for allowing teams to play outside of their Division?

Is there a way I can accomplish this from the back end?

Hi Lamonte,

Any idea why the 7th place team is ahead of 8th place team yet 8th place has one point?

See here

https://burlingtonstampeders.com/jv-varsity-standings/

In matches.php, go to line 71 and remove the 0s as such:

$match->home_points : 0)
change to
$match->home_points : ”)
(two single quotes)

$match->away_points : 0)
change to
$match->away_points : ”)

Then clear out the 0s in your scores for unplayed matches.

Found solution to 0’s. Thanks!

FYI. The original issue on this thread is resolved. Thank you.

I figured out my last question by using User Defined Points. It works Well!!

One major issue ??

When I update the standings for the first week of a league, it works, but then there are 0’s in the results for all unplayed games below. The next time I submit scores, I get a 8 ties added to the database (all 0’s are inputed as scores). I tried updating standings, then reloading the league, but 0’s are still there. I thought I saw an article on this somewhere.

Is there a fix?

I will look for this feature. One more question if you don’t mind..

My client is not pleased that ties are counted as 0 pts and wins are counted as 1 point. They want ties to be 1 point and wins to be 2 points. Any quick way for me to change this? It is a US Football League.

Can I ask one more question?

I am trying to add a League like NFL..

4 Divisions

But teams play outside of their Divisions. So the problem is that I need standings for each Division, but Schedule and Matches that allows me to select teams in multiple divisions when creating matches. Up until now, I had leagues where where I only had teams in a league that played each other. Never matches across multiple divisions.

How can I accomplish this?

Sorry to make it clear. I cannot remove the 0’s so games that aren’t played are all getting put in as a tie.

There is a lot going on here. I am using US Football League. Do I need to replace baseball and soccer files also? Will your fix for #4 above help my 0-0 issue.

IF you enter in 0-0 as score, it goes in as a Tie.

I am seeing a lot of 0-0 matches added as ties. I remove the 0’s and submit and they go away. But next time scores are added, the future games all get added as ties 0-0.

I have a work around!

Assuming you are using match days, use this short code for each individual match day.

[matches league_id=4 match_day=1]

[matches league_id=4 match_day=2]

[matches league_id=4 match_day=3]

Full Schedule then shown.

See https://burlingtonstampeders.com/atom-a-schedule/

Oh Boy! My client upgraded to WP 3.9 while in the admin console before I could test it. Wish this didn’t happen.

Seems like making all of the fields blank (the games that haven’t been played), and click update Results removes extra games played and points. Maybe not same issue. I really need fix to this Schedule issue. About to dive in to the plugin myself!

Yes I will let you work in the environment. Maybe we can do screen share at same time so I can show you the issue also.

Please email me at [email protected] and we can arrange that. Don’t want to post admin credentials here in public forum.

Jim