Sports Predictions For Joomla, Sports Predictions Component for Joomla 3 / 2.5 Options

[Web Design Seo]

Sean, component is tested and work perfect with based templates, included in clear joomla install. Try to switch to other template and post here result.

[Sean]

Same problem when I switch to another default joomla template.


When I click on Single Sport Event, it gives this error;


#1064 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 'AND `c`.`state`' at line 1 SQL=SELECT `gtc`.`game_id`, `gtc`.`categories_id`, `c`.`name` FROM `jos_sportspredictions_game_to_categories` `gtc` LEFT JOIN `jos_sportspredictions_categories` `c` ON `gtc`.`categories_id`=`c`.`id` WHERE `gtc`.`game_id`= AND `c`.`state`;


also, when I click on User Standings, it's a blank page.


When I go to Predictions, there is no where to save my Predictions.


Please help, or send a refund.

[michalis]

hello, can you tell me were to go to translate months that show up on front end?


and also i want to ask, if when game is predicted as a draw (X) and it ends up as a draw, does the formula count it as winner predicted correctly?

sorry for double post but for some reason forum keeps logging me out so i cannot edit

[Web Design Seo]

#1064 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 'AND `c`.`state`' at line 1 SQL=SELECT `gtc`.`game_id`, `gtc`.`categories_id`, `c`.`name` FROM `jos_sportspredictions_game_to_categories` `gtc` LEFT JOIN `jos_sportspredictions_categories` `c` ON `gtc`.`categories_id`=`c`.`id` WHERE `gtc`.`game_id`= AND `c`.`state`;

Sean, is this with new install or with upgrade? Is installed the right version? Versions for joomla 2.5 and Joomla 3 are different. As written in our Support TOS, we don't have technical support in non business days.

[michalis]

ok big problem

i created one tournament then i created a second and unpublished first tournament, but pagination still there, and when visitor clicks on second page, it gets this error

1064 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 ') AND `state`' at line 1 SQL=SELECT * FROM `btg0l_sportspredictions_predictions` `b` WHERE `game_id` IN() AND `state`;


and then component wont work at all it will stay on error even if you refresh

problem solved when i publish tournament

what am i doing wrong?



EDIT - ok so basically if i disable games/tournament, pagination does not go away, and when visitor goes on to second page, it either shows blank or causes the above error. and then it stays stuck there, even if user refreshes or leaves and comes back, he keeps going straight to error/blank page


This post has been edited by michalis: Jan 12 2014, 02:13 PM

[Sean]

Yes, I did use Joomla 3 components from your zip file download. This seems to produce the results I've shown you.

It's also a full install, fresh.

This post has been edited by Sean: Jan 13 2014, 12:50 AM

[Web Design Seo]

Is all steps from install guide done?

Configuration:
7. Form top menu navigate to "Components -> Sportspredictions"
8. From left side menu select "Teams"
9. Create at least two teams
10. Go to "Tournaments"
11. Create at least one tournament
12. Go to "Sport Events"
13. Create at least one
14. Create menu items for front - end
15. Optionally configure component by choosing from component top menu "Options"

Read more: https://3dwebdesign.org/forum/sports-predic...for-joomla-t996

[michalis]

ok big problem

i created one tournament then i created a second and unpublished first tournament, but pagination still there, and when visitor clicks on second page, it gets this error

1064 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 ') AND `state`' at line 1 SQL=SELECT * FROM `btg0l_sportspredictions_predictions` `b` WHERE `game_id` IN() AND `state`;


and then component wont work at all it will stay on error even if you refresh

problem solved when i publish tournament

what am i doing wrong?



EDIT - ok so basically if i disable games/tournament, pagination does not go away, and when visitor goes on to second page, it either shows blank or causes the above error. and then it stays stuck there, even if user refreshes or leaves and comes back, he keeps going straight to error/blank page

anything?

[pavelKukov]

anything?

I've send you personal message with details what i need in order to resolve this issue.

[michalis]

I've send you personal message with details what i need in order to resolve this issue.

great thanks, basically if there is a tournament or games that are unpublished it causes error

[Yuha]

Hi,

is there some way to get months/days to be visible on my own language?

I changed all of them on language file but the one that is on the settings (Datetimeformat in front-end) doesnt allow local format (ie. %A %e %B %Y)

[pavelKukov]

In the component is used "date" function: http://bg2.php.net/manual/en/function.date.php

If you with to use "strftime" then your hosting should allow use of "setlocale".
setlocale still causes problems on lots of hosting environments and because of this reason is not used.

[pavelKukov]

I have found bug in Sports Predictions for joomla 3.x (Thanks to @michalis!)
It is fixed and package is available for download!

Problem was that when you un-publish category all assigned games to it will be counted as published in front-end when they should not.
Now game is considered published when is assigned to at least one published category.

To fix this manually follow this steps:

1. Open "components/com_sportsprediction/models/predictions.php"
2. Find around line 124

Код

        // Join over the created by field 'created_by'
        $query -> select('created_by.name AS created_by');
        $query -> join('LEFT', '#__users AS created_by ON created_by.id = a.created_by');

Replace it with

Код

        // Join over the created by field 'created_by'
        $query -> select('created_by.name AS created_by');
        $query -> join('LEFT', '#__users AS created_by ON created_by.id = a.created_by');
      
        //Join categories status
        $query -> select('(SELECT SUM(`cats`.`state`)
                            FROM `#__sportspredictions_game_to_categories` AS `g2c`
                                LEFT JOIN `#__sportspredictions_categories` `cats` ON `g2c`.`categories_id`=`cats`.`id`
                                    WHERE `a`.id=`g2c`.game_id) AS `category_state`');
                                  
        //Filter only games assigned to at least one published category
        $query -> having('`category_state` > 0');

3. Find around line 193

Код

       //Select only not completed games
        $query -> where("a.h_teams_score < 0");
        $query -> where("a.g_teams_score < 0");

replace it with

Код

        //Select only not completed games
        $query -> where("a.h_teams_score < 0");
        $query -> where("a.g_teams_score < 0");
      
        //Only published games
        $query -> where("a.state > 0");

[michalis]

pavel thank you for working quickly to fix the bug

great guy

[Web Design Seo]

michalis, if you like our extension, please, vote for Sports Predictions in JED

[michalis]

michalis, if you like our extension, please, vote for Sports Predictions in JED

done!


can you clarify something for me? the person with the lowest score is the winner right?

what happens if someone signs up in the middle of a tournament? or if someone leaves a few predictions behind? does he collect less points and have a higher chance of winning?

[pavelKukov]

can you clarify something for me? the person with the lowest score is the winner right?

what happens if someone signs up in the middle of a tournament? or if someone leaves a few predictions behind? does he collect less points and have a higher chance of winning?

- person with the lowest score is the winner
- does he collect less points and have a higher chance of winning

There is no defined winner! Lower score is for accuracy calculation for each game. PREF rating(proportional reduction in error formula) is calculated:

PREF_rating = (1 - wins_percent) * accuracy

In standings view you can sort users by any criteria or combination of them. For example if you sort users by "games played" bigger to smaller and PREF_rating smaller to bigger then you will find user who is played many as possible games with most accurate predictions. (Hold control key while sorting by second or above column)
You can choose winner by different criteria!
Default sorting is by pref_rating lower to bigger.

You can create different standings pages by modifying url parameters of page:
Example:

Код

podosfairaki.com/index.php?option=com_sportspredictions&view=standings&sp_sort_cols[0][sortcol]=games_played&sp_sort_cols[0][sortdir]=DESC&sp_sort_cols[1][sortcol]=pref_rating&sp_sort_cols[1][sortdir]=ASC


"sp_sort_cols" parameter holds sorting information
sp_sort_cols[0][sortcol]=games_played
sp_sort_cols[0][sortdir]=DESC

sp_sort_cols[1][sortcol]=pref_rating
sp_sort_cols[1][sortdir]=ASC

.....

available sort cols are: 'username', 'pref_rating', 'avg_error', 'tot_error', 'wins_percent', 'wins', 'losses', 'games_played'

You can modify page defaults if you don't wist to use url parameters:
1. Open "/components/com_sportspredictions/models/standings.php"
2. Find around line 93

Код

$default_sort_cols = array(
            array(
                "sortcol" => "pref_rating",
                "sortdir" => "ASC"
            )
);

3. Replace above with

Код

$default_sort_cols = array(
            array(
                "sortcol" => "games_played",
                "sortdir" => "DESC"
            ),
            array(
                "sortcol" => "pref_rating",
                "sortdir" => "ASC"
            )
);

[Yuha]

Hi,

I have made myself some modifications for Sports Predictions component but there is something I cant quite figure out.

I would like to have all categories as invidual buttons/links instead of a selector menu. I'm trying to build a site with multiple sports, soccer, hockey, basketball etc and it would be nice to have some sort of filtering right on the front page.

Is there an easy way to do it?

[pavelKukov]

You can control categories filter by modifying URL parameters on the page.

Example: /index.php?option=com_sportspredictions&view=predictions&sp_cats[0]=2&sp_cats[1]=3
This will show only games from categories with id 2 and 3

Parameter responsible for categories selected is "sp_cats".

sp_cats[0]=1
sp_cats[1]=5
sp_cats[2]=11

[Yuha]

You can control categories filter by modifying URL parameters on the page.

Example: /index.php?option=com_sportspredictions&view=predictions&sp_cats[0]=2&sp_cats[1]=3
This will show only games from categories with id 2 and 3

Parameter responsible for categories selected is "sp_cats".

sp_cats[0]=1
sp_cats[1]=5
sp_cats[2]=11

Thanks I'll try with this! Very helpful