How To Unpublish Mach Prediction Before Game Starts..?, Unpublish mach prediction beforo game starts..? Options

[andrai2]

Hello!

I have bought your component sport predictons to predict hockey games, very good compnent

My question is. Is there a posibility to unpublish match, so that users can not predict game when in starts..?
So how to unpublish prediction befere game starts..?

I click on match unpublish but users still can predict game

So for example game starts on Friday, i want that users can predit results till thursday, so that on Friday when game starts no one could predict the result.

May be I can click some where in admin panel

At this moment there is situation, i can submit prediction when game starts, there is posibilty to "cheat"

So how unpublish mach in prediction day befere game starts..?

I have joomla 2.5.9.

Thanks, hope for answer

[Ivan Stamenov]

Hi, Andrai!

This is a bug Thank you for pointing it to us.

Here is how it can be fixed:

1. Using FTP client (e.g. Filezilla), open /components/com_sportspredictions/models/matches.php

2. To prevent the unpublished games from displaying to the user, find the following code (lines 61-64):

Код

$where = array(
    "g.date>'{$this->_now}'",
    "g.res_fina_equipe1 = '--'"
);

Replace it with:

Код

$where = array(
    'g.published=1',
    "g.date>'{$this->_now}'",
    "g.res_fina_equipe1 = '--'"
);

3. To prevent attempts for voting for unpublished games, find (on line 90):

Код

$this->_db->setQuery('SELECT id_mat FROM #__se_games WHERE id_mat IN ('.implode(',', $match_ids).') AND `date`>\''.$this->_now.'\'');

Replace it with:

Код

$this->_db->setQuery('SELECT id_mat FROM #__se_games WHERE id_mat IN ('.implode(',', $match_ids).') AND `date`>\''.$this->_now.'\' AND published=1');

Best regards,

Ivan

[andrai2]

Great it works thanks!