Forum Replies Created

Viewing 13 replies - 1 through 13 (of 13 total)
  • Thread Starter sukritd

    (@sukritd)

    Dear Stef. Firstly, my apologies for the delayed response. My hosting provider ate up all my files and hence I could not test the solution you suggested until I gave up on them and installed WP locally. Secondly, many thanks for your useful and rapid response. I went with that option. The plugin isn’t perfect but definitely gets the job done.

    It would be great to see this kind of an option appear natively in Woocommerce. I haven’t coded much recently, but I’ll take a look the WC code and see if I can suggest something.

    Thanks again. Cheers,Sukrit.

    Here’s some SQL queries to get you started:

    —- Aggregated Report —-

    SELECT
    u.ID AS User_ID,
    u.display_name AS User_Name,
    l.name AS League,
    u.user_email AS User_Email,
    IFNULL(COUNT(p.user_id), 0) AS Nr_of_predictions,
    SUM(p.has_joker) AS JOKER_VALUE
    FROM wp_users u
    LEFT OUTER JOIN pool_wp_predictions p ON ( u.ID = p.user_id )
    JOIN pool_wp_league_users lu ON ( lu.user_id = u.id )
    JOIN pool_wp_leagues l ON ( l.id = lu.league_id )
    GROUP BY u.id
    ORDER BY u.id
    ;

    —- Detailed report —-

    SELECT
    p.user_id AS User_ID,
    u.display_name AS User_Name,
    l.name AS League,
    u.user_email AS User_Email,
    p.match_id AS Match_ID,
    t.name AS Home_Team,
    p.home_score AS Home_Team_Score_Prediction,
    t1.name AS Away_Team,
    p.away_score AS Away_Team_Score_Prediction,
    p.has_joker AS Joker_Match
    FROM pool_wp_predictions p
    JOIN wp_users u ON ( u.ID = p.user_id )
    JOIN pool_wp_matches m ON ( m.id = p.match_id )
    JOIN pool_wp_teams t ON ( t.id = m.home_team_id )
    JOIN pool_wp_teams t1 ON ( t1.id = m.away_team_id )
    JOIN pool_wp_league_users lu ON ( lu.user_id = u.id )
    JOIN pool_wp_leagues l ON ( l.id = lu.league_id )
    Order by p.match_id
    ;

    Thread Starter sukritd

    (@sukritd)

    Thanks Antoine.

    Thread Starter sukritd

    (@sukritd)

    Thanks.

    And while I have your attention (and I really really appreciate it), could you kindly give me any leads as to how I could try and implement point #2:

    2. Results simulation: I would like to have a table with all the teams in each group on the prediction sheet. As the user is entering the pool predictions, I would like for the points table for that group to be updated with the user’s prediction results. I hope I’m clear in expressing what I’m trying to do.

    Thanks in advance.

    Thread Starter sukritd

    (@sukritd)

    Hi Antoine. Sorry, this seem like a stupid question, but with file do I add this to? I’m currently trying to append it to the file “classes/class-football-pool.php” in the “public static function new_pool_user” section (and to no avail).

    Thread Starter sukritd

    (@sukritd)

    Thanks Antoine. Will test and revert.

    Thread Starter sukritd

    (@sukritd)

    Hi,

    Looks like it was indeed an issue with cache. As I don’t own a Windows computer I was depending on a friend to test it for me. However, when I tested it on several Windows 7+ computers with IE 9/10 and Firefox 21 it worked just fine.

    Thanks again,
    Sukrit

    Thread Starter sukritd

    (@sukritd)

    Hi,

    Here’s the address: old-continent.eu [pass: admin1324]. I think the problem is with JS part:

    onclick="jQuery('#bgndVideo1').playYTP(); jQuery('#bgndVideo1').one('YTPStart',function(){jQuery('#bgndVideo1').fullscreen()})

    Thanks,
    Sukrit
    PS: can you please remove this comment once you have read the message

    Thread Starter sukritd

    (@sukritd)

    Hi Matteo,

    As I mentioned earlier, the code above is working perfectly on my computer, which is a Mac. However, it does not appear to be working on Windows computers. What happens when the user clicks on the button to play and set the video to fullscreen is that only the first action seems to be working. Any idea what can be done to to fix this issue?

    Thanks,
    Sukrit

    Thread Starter sukritd

    (@sukritd)

    Hi Matteo. Perfect solution. Works like a charm. I hope this helps others as well.

    Cheers,
    Sukrit

    Thread Starter sukritd

    (@sukritd)

    Thanks again Matteo. Works quite well.

    Without sounding ungrateful, can I ask you one more tiny bit of help?

    So now video plays and goes in full screen. However, I seem to need to click on the button twice, which is a bit annoying. I tried a few things with no luck.

    I have the two functions daisy-chained, like this:

    onclick="jQuery('#bgndVideo1').getPlayer().playVideo();jQuery('#bgndVideo1').fullscreen();"

    Grazie mille πŸ™‚
    Sukrit

    PS: you’re really great with your support!

    Thread Starter sukritd

    (@sukritd)

    Hey there.

    Thanks for the tip. Have managed to implement both things.

    However, still stuck on one small issue. The video is playing from my custom button. However, I am unable to force it to go onto fullscreen on play.

    I used the following code to get the video to play. However, despite adding “.fullScreen()
    I could not force the fullscreen. I think I went through most of the documentation of the Wiki and other related google searches with no luck so far.

    <button class="command" onclick="jQuery('#bgndVideo1').getPlayer().playVideo()">

    Thanks again,
    Sukrit

    Thread Starter sukritd

    (@sukritd)

    Hi Matteo,

    Thanks a ton for a quick reply. Will check out the links and the code as suggested.

    Cheers,
    Sukrit

Viewing 13 replies - 1 through 13 (of 13 total)