sukritd
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] Select multiple attributes with limitDear 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.
Forum: Plugins
In reply to: [Football Pool] Export user pool dataHere’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
;Forum: Plugins
In reply to: [Football Pool] Multiple jokers & group results simulationsThanks Antoine.
Forum: Plugins
In reply to: [Football Pool] Multiple jokers & group results simulationsThanks.
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.
Forum: Plugins
In reply to: [Football Pool] Multiple jokers & group results simulationsHi 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).
Forum: Plugins
In reply to: [Football Pool] Multiple jokers & group results simulationsThanks Antoine. Will test and revert.
Forum: Plugins
In reply to: [mb.YTPlayer for background videos] Trigger video with custom buttonHi,
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,
SukritForum: Plugins
In reply to: [mb.YTPlayer for background videos] Trigger video with custom buttonHi,
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 messageForum: Plugins
In reply to: [mb.YTPlayer for background videos] Trigger video with custom buttonHi 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,
SukritForum: Plugins
In reply to: [mb.YTPlayer for background videos] Trigger video with custom buttonHi Matteo. Perfect solution. Works like a charm. I hope this helps others as well.
Cheers,
SukritForum: Plugins
In reply to: [mb.YTPlayer for background videos] Trigger video with custom buttonThanks 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 π
SukritPS: you’re really great with your support!
Forum: Plugins
In reply to: [mb.YTPlayer for background videos] Trigger video with custom buttonHey 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,
SukritForum: Plugins
In reply to: [mb.YTPlayer for background videos] Trigger video with custom buttonHi Matteo,
Thanks a ton for a quick reply. Will check out the links and the code as suggested.
Cheers,
Sukrit