Welcome Guest ( Log In | Register )

 Forum Rules Extensions Support
6 Pages V  « < 4 5 6  
Reply to this topicStart new topic
> Support Questions For Sports Predictions, Post here Support Questions for Sports Predictions component
7heo
post Apr 26 2014, 11:56 AM
Post #101


Newbie
*

Group: Members
Posts: 7
Joined: 1-April 14
Member No.: 1,992



I am sure you know, as developer, an easy way to do that.. Please.
Go to the top of the page
 
+Quote Post
pavelKukov
post Apr 28 2014, 07:48 AM
Post #102


Php programmer
****

Group: Administrators
Posts: 285
Joined: 26-November 12
From: Bulgaria
Member No.: 1,452



Цитат
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.


--------------------
Php programmer in 3D Web Design
Go to the top of the page
 
+Quote Post
7heo
post May 18 2014, 10:32 AM
Post #103


Newbie
*

Group: Members
Posts: 7
Joined: 1-April 14
Member No.: 1,992



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
Go to the top of the page
 
+Quote Post
Mei3am
post Jun 4 2014, 02:24 PM
Post #104


Newbie
*

Group: Members
Posts: 2
Joined: 4-June 14
Member No.: 2,043



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
Go to the top of the page
 
+Quote Post

6 Pages V  « < 4 5 6
Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

Collapse

> Similar Topics

  Topic Replies Topic Starter Views Last Action
No new Pinned: Topic has attachmentsSports Predictions For Joomla
Sports Predictions Component for Joomla 3 / 2.5
307 Web Design Seo 81,793 1st April 2016 - 01:10 AM
Last post by: eder
No New Posts Questions About Mailorder Email
1 n-b 2,077 14th July 2015 - 07:31 AM
Last post by: Web Design Seo
No New Posts Sports Predictions
Scoring method used?
3 Stef 2,312 15th June 2015 - 07:54 AM
Last post by: Web Design Seo
No New Posts Sports Prediction: Remove The Host And Guest
i need a little assistance
0 eric258 2,057 5th June 2015 - 05:16 PM
Last post by: eric258
No New Posts Sports Predictions Problem: Wrong Score Inserted, League Table Problem
2 vmaiello 2,482 23rd February 2015 - 11:41 PM
Last post by: vmaiello
No New Posts Sports Predictions And Aup
3 calciodonne 2,378 11th February 2015 - 08:02 AM
Last post by: Web Design Seo
No new Sports Predictions - Standings Module
Standings module not showing standings
4 Voltex 2,873 19th January 2015 - 08:41 AM
Last post by: Web Design Seo
No New Posts Sports Predictions - Standings Module (field Names)
1 Voltex 3,187 18th January 2015 - 09:52 AM
Last post by: Web Design Seo
No New Posts Sports Predictions For Joomla - Module Settings
0 Voltex 1,974 17th January 2015 - 08:49 AM
Last post by: Voltex
No new Sports Predictions V.2.1
Problems installing Sports Predictions v.2.1 [solved]
6 bertvdb 3,728 24th July 2014 - 05:39 AM
Last post by: Web Design Seo


 



RSS Lo-Fi Version Time is now: 22nd November 2017 - 12:35 PM
Clicky Web Analytics