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

[vmaiello]

I added the scores from our first week.

I made a mistake in the basic settings point.

I deleted all the event scores back to -- --

How can i reset the rankings?


tnx, Ken

i am looking for the same information

[Web Design Seo]

ARTEFACTO, there is all info, just read it: You have agree to these terms when you purchase.

You can buy with or without registration, but registration is needed to download updates for further versions of extensions. In every extension is described number of updates that are for current extension.

If you are not registered, just register from here with exact email from order and your orders will be added automatically to your account.

After this, you can download updates from menu My orders.

[pavelKukov]

You can't. It is possible to delete all records in "#__se_standings" and "#__se_cat_standings" tables. After that enter games scores and standings will be recalculated.

This future will be available in next version which will be released soon(till the end of month).

I added the scores from our first week.

I made a mistake in the basic settings point.

I deleted all the event scores back to -- --

How can i reset the rankings?


tnx, Ken

[vmaiello]

You can't. It is possible to delete all records in "#__se_standings" and "#__se_cat_standings" tables. After that enter games scores and standings will be recalculated.

is there a FAQ on how to delete records from tables?
Sorry I am new to joomla at all

[pavelKukov]

This should be done ONLY through phpMyAdmin or similar software - directly from database.

Query can be:

Код

TRUNCATE tbl_name

replace "tbl_name" with "se_cat_standings" with appropriate prefix (E.g. "joo_se_cat_standings")

[vmaiello]

Is there any method to translate the voices into predictions menu?

I'd like to turn them in italian

I mean SPORT EVENTS, BEST EXPERTS, PREDICTIONS HISTORY,


I'd like to remove TIMEZONE filter and month/week filter too

Can you help me to remove them?

Thaank you a lot

[adoewa]

When i click on ranking i receive a 1054 error.

Unknown column 'ses.month' in 'where clause' SQL=SELECT u.username, u.name, u.email, u.registerDate, ses.uid, ses.score, ses.timecrit FROM jos_se_cat_standings ses LEFT JOIN jos_users u ON ses.uid=u.id WHERE ses.month=201309 AND ses.cat_id=3 ORDER BY pos ASC LIMIT 0, 15

Did i do something wrong?


Greetz, Ken
adoewa

[pavelKukov]

When i click on ranking i receive a 1054 error.

Unknown column 'ses.month' in 'where clause' SQL=SELECT u.username, u.name, u.email, u.registerDate, ses.uid, ses.score, ses.timecrit FROM jos_se_cat_standings ses LEFT JOIN jos_users u ON ses.uid=u.id WHERE ses.month=201309 AND ses.cat_id=3 ORDER BY pos ASC LIMIT 0, 15

Did i do something wrong?


Greetz, Ken
adoewa

This appears to be a bug in component. It will be fixed soon as possible and you will receive fixed copy.

[pavelKukov]

To fix that bug follow this steps:

1. Open file "/components/com_sportspredictions/models/standings.php"


Find:(around line 54)

Код

function _buildQuery() {
    if ($this->_category)
        return 'SELECT u.username, u.name, u.email, u.registerDate, ses.uid, ses.score, ses.timecrit FROM #__se_cat_standings ses LEFT JOIN #__users u ON ses.uid=u.id'.$this->_buildContentWhere().' ORDER BY pos ASC';
    else
        return 'SELECT u.username, u.name, u.email, u.registerDate, ses.uid, ses.score, ses.timecrit FROM #__se_standings ses LEFT JOIN #__users u ON ses.uid=u.id'.$this->_buildContentWhere().' ORDER BY pos ASC';
}

function _buildContentWhere() {
    $where = array();
    if (!empty($this->_month))
        $where[] = 'ses.month='.$this->_month;
    if (!empty($this->_category))
        $where[] = 'ses.cat_id='.$this->_category;
    if (!empty($this->_weeks) && strpos($this->_weeks,' ') !== false)
    {
        $start_end_weeks = explode (' ',$this->_weeks);
        $where[] = 'ses.week_start=\''.$start_end_weeks[0].'\'';
        $where[] = 'ses.week_end=\''.$start_end_weeks[1].'\'';
    }
    if (empty($where))
        return '';
    else
        return ' WHERE '.implode(' AND ', $where);
}

Replace it with:

Код

function _buildQuery() {
    if ($this->_category)
        return 'SELECT u.username, u.name, u.email, u.registerDate, ses.uid, ses.score, ses.timecrit FROM #__se_cat_standings ses LEFT JOIN #__users u ON ses.uid=u.id'.$this->_buildContentWhere(array('_month')).' ORDER BY pos ASC';
    else
        return 'SELECT u.username, u.name, u.email, u.registerDate, ses.uid, ses.score, ses.timecrit FROM #__se_standings ses LEFT JOIN #__users u ON ses.uid=u.id'.$this->_buildContentWhere().' ORDER BY pos ASC';
}
function _buildContentWhere($disable_fields = array()) {
    $where = array();
    if (!empty($this->_month) && !in_array('_month', (array)$disable_fields))
        $where[] = 'ses.month='.$this->_month;
    if (!empty($this->_category) && !in_array('_category', (array)$disable_fields))
        $where[] = 'ses.cat_id='.$this->_category;
    if (!empty($this->_weeks) && strpos($this->_weeks,' ') !== false && !in_array('_weeks', (array)$disable_fields))
    {
        $start_end_weeks = explode (' ',$this->_weeks);
        $where[] = 'ses.week_start=\''.$start_end_weeks[0].'\'';
        $where[] = 'ses.week_end=\''.$start_end_weeks[1].'\'';
    }
    if (empty($where))
        return '';
    else
        return ' WHERE '.implode(' AND ', $where);
}

2. Open file "administrator/components/com_sportspredictions/models/standings.php"

Find:(around line 53)

Код

function _buildQuery() {
    if ($this->_category)
        return 'SELECT u.username, u.name, u.email, u.registerDate, ses.score, ses.timecrit FROM #__se_cat_standings ses LEFT JOIN #__users u ON ses.uid=u.id'.$this->_buildContentWhere().' ORDER BY pos ASC';
    else
        return 'SELECT u.username, u.name, u.email, u.registerDate, ses.score, ses.timecrit FROM #__se_standings ses LEFT JOIN #__users u ON ses.uid=u.id'.$this->_buildContentWhere().' ORDER BY pos ASC';
}
function _buildContentWhere() {
    $where = array();
    if (!empty($this->_month))
        $where[] = 'ses.month='.$this->_month;
    if (!empty($this->_category))
        $where[] = 'ses.cat_id='.$this->_category;
    if (!empty($this->_weeks) && strpos($this->_weeks,' ') !== false)
    {
        $start_end_weeks = explode (' ',$this->_weeks);
        $where[] = 'ses.week_start=\''.$start_end_weeks[0].'\'';
        $where[] = 'ses.week_end=\''.$start_end_weeks[1].'\'';
    }
    $search    = trim(JFactory::getApplication()->getUserStateFromRequest(JRequest::getCmd('option').'search', 'search', '', 'string'));

    if (!empty($search)) {
        $search = $this->_db->Quote("%$search%");
        $where[] = "u.username LIKE $search OR u.name LIKE $search";
    }
    
    if (empty($where))
        return '';
    else
        return ' WHERE '.implode(' AND ', $where);
}

Replace it with:

Код

function _buildQuery() {
    if ($this->_category)
        return 'SELECT u.username, u.name, u.email, u.registerDate, ses.score, ses.timecrit FROM #__se_cat_standings ses LEFT JOIN #__users u ON ses.uid=u.id'.$this->_buildContentWhere(array('_month')).' ORDER BY pos ASC';
    else
        return 'SELECT u.username, u.name, u.email, u.registerDate, ses.score, ses.timecrit FROM #__se_standings ses LEFT JOIN #__users u ON ses.uid=u.id'.$this->_buildContentWhere().' ORDER BY pos ASC';
}
function _buildContentWhere($disable_fields = array()) {
    $where = array();
    if (!empty($this->_month) && !in_array('_month', (array)$disable_fields))
        $where[] = 'ses.month='.$this->_month;
    if (!empty($this->_category) && !in_array('_category', (array)$disable_fields))
        $where[] = 'ses.cat_id='.$this->_category;
    if (!empty($this->_weeks) && strpos($this->_weeks,' ') !== false && !in_array('_weeks', (array)$disable_fields))
    {
        $start_end_weeks = explode (' ',$this->_weeks);
        $where[] = 'ses.week_start=\''.$start_end_weeks[0].'\'';
        $where[] = 'ses.week_end=\''.$start_end_weeks[1].'\'';
    }
    $search    = trim(JFactory::getApplication()->getUserStateFromRequest(JRequest::getCmd('option').'search', 'search', '', 'string'));

    if (!empty($search) && !in_array('search', (array)$disable_fields)) {
        $search = $this->_db->Quote("%$search%");
        $where[] = "u.username LIKE $search OR u.name LIKE $search";
    }
    
    if (empty($where))
        return '';
    else
        return ' WHERE '.implode(' AND ', $where);
}

[adoewa]

Tnx... for the great support...

Ken

[Web Design Seo]

Bug fix now is fixed in files in our file directory also.

Adoewa, if you like our extension, please, vote for us in JED here.

[adoewa]

Allready did...

Bug fix now is fixed in files in our file directory also.

Adoewa, if you like our extension, please, vote for us in JED here.

[Web Design Seo]

Thank you, this is really important for us!

[kmanos7]

hello i have buy your extension 10 days ago ..i was wondering if its possible the sports events be visible to all the guests but in order to give actual prediction then you will asked to log in .... is that possible ??

[pavelKukov]

It is possible with slight modification. If you are interested write details to email "admin" @ our website.

[Web Design Seo]

Version 1.4.3 for Joomla 2.5 is released today. In latest Joomla 2.5 version you have one New game: 1x2 (just like lotto). Now you can have two different games in one website - standart game and 1x2.

1x2 views and standart game views are different - you can publish in website both games over new menus to standart game and to 1x2 game. Now there are 6 views - 3 views for every type of game (history, sport events and best experts).

New version is already uploaded and available for download.

Is updated only Joomla 2.5 version! New 1x2 game is only inside Joomla 2.5 version of Sports Predictions!









Changes in latest Joomla 2.5 version:

compatible with **php <= v5.3.8** with **turned off error reporting**

## Site ##

1. ### Make a prediction in 1X2 Mode ###
Allows user to predict games in 1X2 mode.
Users can cancel their predictions before game starts.
This predictions are stored in separate database table and do not affect standard predictions and standings.

2. ### Predictions history for 1X2 game ###
Show history for 1X2 predictions.
It is possible to show predictions only for current user.

3. ### Best experts in 1X2 game ###
Standings in 1X2 game


## Administrator ##

1. ### Predictions 1X2 ###
Show history for 1X2 predictions.

2. ### Standings 1X2 ###
Standings in 1X2 game


## Configuration ##

1. Score 1X2 Winner default: 2
DESC: Score which user will get when rightly predicts game result in 1x2 mode.

2. Score 1X2 Loser default: 0
DESC: Score which user will get when wrongly predicts game result in 1x2 mode.

3. Score 1X2 Loser X default: 2
DESC: Score, which user will get, when wrongly predicted game and game is 1 or 2 and user is predicted X.


## Database ##

### New tables ### : "#__se_bets_1x2", "#__se_standings_1x2", "#__se_cat_standings_1x2"


How to update to latest version?

Backup first! Than just install new version over joomla installer.

[adoewa]

Hi,

We have a tournament id for each week of games.

We can show the weekranking by selecting the tournament id.
We switch this every week to the next id number... so far so good.

I can't show the general ranking from from all tournaments together?

I tought it was possible by selecting ID 0, but it's not.

Is this possible?

greetz,
Ken
adoewa


Read more: https://3dwebdesign.org/forum/general-ranki...9#ixzz2hP0kYjmX

This post has been edited by adoewa: Oct 11 2013, 09:04 AM

[kmanos7]

when can we expekt the update with the 12x option to be avaliable on joomla 3 users ????

[Web Design Seo]

when can we expekt the update with the 12x option to be avaliable on joomla 3 users ????

kmanos7, joomla3 version will be updated with 1x2 in min. one month. In joomla 3 version will be updated (after 1-2 weeks) standart game first - there is new version, work with better alghorithm and with 5-6 new options (new functions) like vip games, new module and others.

[kmanos7]

kmanos7, joomla3 version will be updated with 1x2 in min. one month. In joomla 3 version will be updated (after 1-2 weeks) standart game first - there is new version, work with better alghorithm and with 5-6 new options (new functions) like vip games, new module and others.

that is great news...any idea of the cost ??

thnks in advance