Support Questions For Sports Predictions, Post here Support Questions for Sports Predictions component Options

[7heo]

I am sure you know, as developer, an easy way to do that.. Please.

[pavelKukov]

But I don't need members to be able to filter rankings.

Actually I deleted this fonctionality from frontend pages because I wanted to simplify as much as possible the interface, moreover I don't need members to be able to see monthly rankings.

Is it deleted or not? If is deleted then users will see default standings for all time and will not be able to change it.

I only want them to see general ranking (seasonal ranking actually).
I looked a little bit in the code but didn't find what to change.

Could you help me on that ?

Seasonal ranking actually is not possible to be filtered. You can filter only by month or for all time.
Seasonal standings and many more options are available only in component for joomla 3.x.

[7heo]

Hi, thank you pavelKukov for answering.

Yes yes, it is deleted !

But I am wondering if the points earned accumulate from one month to the next? Example, if a player earns 4 points in March and 5 in April, should we see only one row with a score of 9 in the default standings for all time, or two rows ?

Thanks

[Mei3am]

Hi
I've installed on Joomla 3 component Sports Predictions
I encountered the error Runtime Components menu
Someone can advise me?

CODE

Table 'fifa2014_joomla.o5e7i_sportspredictions_games' doesn't exist SQL=SELECT COUNT(*) as `count` FROM `o5e7i_sportspredictions_games` WHERE `h_teams_score` = -1 AND `g_teams_score` = -1 AND `state`;

Teams

CODE

Table 'fifa2014_joomla.o5e7i_sportspredictions_teams' doesn't exist SQL=SELECT COUNT(*) FROM `o5e7i_sportspredictions_teams` AS a LEFT JOIN o5e7i_users AS uc ON uc.id=a.checked_out LEFT JOIN o5e7i_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1)) Table 'fifa2014_joomla.o5e7i_sportspredictions_teams' doesn't exist SQL=SELECT a.*,uc.name AS editor,created_by.name AS created_by FROM `o5e7i_sportspredictions_teams` AS a LEFT JOIN o5e7i_users AS uc ON uc.id=a.checked_out LEFT JOIN o5e7i_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1)) ORDER BY a.name asc LIMIT 0, 20 Table 'fifa2014_joomla.o5e7i_sportspredictions_teams' doesn't exist SQL=SELECT COUNT(*) FROM `o5e7i_sportspredictions_teams` AS a LEFT JOIN o5e7i_users AS uc ON uc.id=a.checked_out LEFT JOIN o5e7i_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1))

Tournaments

CODE

Table 'fifa2014_joomla.o5e7i_sportspredictions_categories' doesn't exist SQL=SELECT COUNT(*) FROM `o5e7i_sportspredictions_categories` AS a LEFT JOIN o5e7i_users AS uc ON uc.id=a.checked_out LEFT JOIN o5e7i_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1)) Table 'fifa2014_joomla.o5e7i_sportspredictions_categories' doesn't exist SQL=SELECT a.*,uc.name AS editor,created_by.name AS created_by FROM `o5e7i_sportspredictions_categories` AS a LEFT JOIN o5e7i_users AS uc ON uc.id=a.checked_out LEFT JOIN o5e7i_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1)) ORDER BY a.name asc LIMIT 0, 20 Table 'fifa2014_joomla.o5e7i_sportspredictions_categories' doesn't exist SQL=SELECT COUNT(*) FROM `o5e7i_sportspredictions_categories` AS a LEFT JOIN o5e7i_users AS uc ON uc.id=a.checked_out LEFT JOIN o5e7i_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1))

Sport Events

CODE

Table 'fifa2014_joomla.o5e7i_sportspredictions_games' doesn't exist SQL=SELECT COUNT(*) FROM `o5e7i_sportspredictions_games` AS a LEFT JOIN o5e7i_users AS uc ON uc.id=a.checked_out LEFT JOIN o5e7i_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1)) Table 'fifa2014_joomla.o5e7i_sportspredictions_games' doesn't exist SQL=SELECT a.*,uc.name AS editor,created_by.name AS created_by,(SELECT GROUP_CONCAT(DISTINCT accuracy_calculation_method ORDER BY accuracy_calculation_method ASC SEPARATOR ',') FROM `o5e7i_sportspredictions_predictions` `predictions` WHERE `a`.id= `predictions`.`game_id`) AS accuracy_calculation_method FROM `o5e7i_sportspredictions_games` AS a LEFT JOIN o5e7i_users AS uc ON uc.id=a.checked_out LEFT JOIN o5e7i_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1)) ORDER BY a.desciption asc LIMIT 0, 20 Table 'fifa2014_joomla.o5e7i_sportspredictions_games' doesn't exist SQL=SELECT COUNT(*) FROM `o5e7i_sportspredictions_games` AS a LEFT JOIN o5e7i_users AS uc ON uc.id=a.checked_out LEFT JOIN o5e7i_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1))

Predictions

CODE

Table 'fifa2014_joomla.o5e7i_sportspredictions_games' doesn't exist SQL=SELECT COUNT(*) as `count` FROM `o5e7i_sportspredictions_games` WHERE `h_teams_score` = -1 AND `g_teams_score` = -1 AND `state`;

Standings

CODE

Table 'fifa2014_joomla.o5e7i_sportspredictions_categories' doesn't exist SQL=SELECT * FROM `o5e7i_sportspredictions_categories` WHERE `state` ORDER BY `ordering` ASC;

Standings History

CODE

Table 'fifa2014_joomla.o5e7i_sportspredictions_standings' doesn't exist SQL=SELECT COUNT(*) FROM `o5e7i_sportspredictions_standings` AS a LEFT JOIN o5e7i_users `u` ON `u`.id = a.users_id LEFT JOIN `o5e7i_sportspredictions_categories` `c` ON `c`.id= `a`.`categories_id` Table 'fifa2014_joomla.o5e7i_sportspredictions_standings' doesn't exist SQL=SELECT a.*,`u`.id AS users_id,`u`.name AS user_name,`u`.username AS username,CASE WHEN `a`.`categories_id` THEN `c`.name ELSE "All" END AS categories_id FROM `o5e7i_sportspredictions_standings` AS a LEFT JOIN o5e7i_users `u` ON `u`.id = a.users_id LEFT JOIN `o5e7i_sportspredictions_categories` `c` ON `c`.id= `a`.`categories_id` ORDER BY a.id asc LIMIT 0, 20 Table 'fifa2014_joomla.o5e7i_sportspredictions_standings' doesn't exist SQL=SELECT COUNT(*) FROM `o5e7i_sportspredictions_standings` AS a LEFT JOIN o5e7i_users `u` ON `u`.id = a.users_id LEFT JOIN `o5e7i_sportspredictions_categories` `c` ON `c`.id= `a`.`categories_id`

This post has been edited by Mei3am: Jun 5 2014, 08:17 AM