Pick'em Leagues: THE BIG SHOW CASUAL BEST OF THE REST Single Event PvP: FANTASY POOLS Betting Leagues: THE BIG SHOW BEST OF THE REST

Database / programming changes + favor to ask of the regulars

Print  
Posted By Message

DoTheMMAth

MMA Sensei

DoTheMMAth Avatar
1
 
 
 


 
 
Posts:1,572
Career:1,500-932
Joined:Dec 2006
Chips:
356
Greetings all,

Item # 1

In preparation of upcoming site update we will be sending live a large set of changes that primarily affects things behind the scenes. Essentially we've merged all the primary league and league 2 data into the same set of tables in the same database, cleaned up duplicate fighter entries resultant from the merge, and added a number of fields and tables behind the scenes that under development games and an improved fighter ranking system rely on.

This affected the code on 40+ pages of the site, including the large statistics procedures for both leagues.

So my request is that if you see anything that seems off (in either league), any fights where the fighters aren't lined up properly, any fights where your point or wager totals are off in some way, etc - please let me know. Not much should look different hopefully. Pay particular attention after the first event or two in each league, as doing open-heart surgery on the stats code is hairy. Everything seems fine on the development server, but nothing ever goes according to plan...

Please Note: At the time of this posting, until the time I post the "all clear" below, picks and wagers made in both the primary and secondary leagues may not be saved in the new merged database.


Item # 2

1 day this week we will have a brief down time (not sure what day/time yet). The site's owner has purchased a new database server with better performance numbers and will be migrating the live site's data to this new server. So if you try to log on for a random evening and can't access us for a few hours - don't panic!

_______________________________________

Post #1   10/14/13 2:48:54PM   

Shawn91111

The MMAPlayground's Co-Creator

Shawn91111 Avatar
18
 
 
 


 
 
Posts:5,744
Career:2,781-1,448
Joined:Sep 2007
Camp: Dark Horse
Chips:
1,086
Thanks for the update, really appreciate keeping us in the know

_______________________________________
In 2006 I had a vision to create a fantasy MMA site, thus the Playground was born

Post #2   10/14/13 3:40:56PM   

FastKnockout

TRICK 'R TREAT

FastKnockout Avatar
7
 
 
 
 


 
 
Posts:13,326
Career:1,856-1,025
Joined:Sep 2010
Camp: Project Mayhem
Chips:
1,703
Thanks for the heads up! We appreciate it.

Post #3   10/14/13 3:42:51PM   

DoTheMMAth

MMA Sensei

DoTheMMAth Avatar
1
 
 
 


 
 
Posts:1,572
Career:1,500-932
Joined:Dec 2006
Chips:
356

Posted by DoTheMMAth

Please Note: At the time of this posting, until the time I post the "all clear" below, picks and wagers made in both the primary and secondary leagues may not be saved in the new merged database.



All clear to make picks and wagers in both leagues for now (just need a few more to make picks for secondary to have wagers!).

There may be a bug or two, perhaps to come when we run the stats at the next event, but I squashed the few bugs I came across and sent it live.

Thx all.

_______________________________________

Post #4   10/14/13 3:48:19PM   

DoTheMMAth

MMA Sensei

DoTheMMAth Avatar
1
 
 
 


 
 
Posts:1,572
Career:1,500-932
Joined:Dec 2006
Chips:
356
The only thing that I can think of by way of changes that impact gameplay is that we now have the ability to mark fights on UFC events as being "main card" fights. If main card bouts are entered, the hot bout will be selected from the main card only.

For future bouts that do not already have system-generated odds in place, we now have the option to manually enter the odds so long as they haven't already been set. This will allow us to input real sportsbook odds for fights when possible.

Last edited 10/14/13 3:51PM server time by dothemmath
Edit note/reason: n/a

_______________________________________

Post #5   10/14/13 3:50:02PM   

FastKnockout

TRICK 'R TREAT

FastKnockout Avatar
7
 
 
 
 


 
 
Posts:13,326
Career:1,856-1,025
Joined:Sep 2010
Camp: Project Mayhem
Chips:
1,703

Posted by DoTheMMAth

If main card bouts are entered, the hot bout will be selected from the main card only.




A lot of members will be happy to hear that.

Post #6   10/14/13 3:52:55PM   

Shawn91111

The MMAPlayground's Co-Creator

Shawn91111 Avatar
18
 
 
 


 
 
Posts:5,744
Career:2,781-1,448
Joined:Sep 2007
Camp: Dark Horse
Chips:
1,086
When clicking on someones name to see their profile I get this




Last edited 10/14/13 5:40PM server time by shawn91111
Edit note/reason: n/a
2 total post edits

_______________________________________
In 2006 I had a vision to create a fantasy MMA site, thus the Playground was born

Post #7   10/14/13 5:12:03PM   

Shawn91111

The MMAPlayground's Co-Creator

Shawn91111 Avatar
18
 
 
 


 
 
Posts:5,744
Career:2,781-1,448
Joined:Sep 2007
Camp: Dark Horse
Chips:
1,086

Posted by Shawn91111

When clicking on someones name to see their profile I get this









Back up and working

_______________________________________
In 2006 I had a vision to create a fantasy MMA site, thus the Playground was born

Post #8   10/14/13 5:40:52PM   

george112

The Playground OG

george112 Avatar
2

 
 
 


 
 
Posts:5,371
Career:1,258-821
Joined:Jan 2007
Camp: Playground Legends
Chips:
1,059

_______________________________________
Ron Paul 2016

Post #9   10/14/13 6:24:41PM   

Bubbles

Come at me bro

Bubbles Avatar
5




 
 
 


 
 
Posts:9,368
Career:1,120-670
Joined:Oct 2009
Chips:
1,461

Posted by DoTheMMAth

For future bouts that do not already have system-generated odds in place, we now have the option to manually enter the odds so long as they haven't already been set. This will allow us to input real sportsbook odds for fights when possible.


How is this going to work when most of the fight card odds don't come out until a few days before the event?

_______________________________________
The best cure for insomnia is a lot of sex. Even if it doesn't end up putting you to sleep, you don't mind so much

Men be careful, female sexual predators are using a date rape drug called a Blowjob to trap men into scams called relationships.

Post #10   10/14/13 8:24:59PM   

DoTheMMAth

MMA Sensei

DoTheMMAth Avatar
1
 
 
 


 
 
Posts:1,572
Career:1,500-932
Joined:Dec 2006
Chips:
356
Thanks to those that pointed out errors so far.

To those that contacted me about some of the L2 fighter pictures being incorrect, this should be fine now. To see the updated pictures, do a hard refresh (CTRL+F5), as the filename hasn't changed.

_______________________________________

Post #11   10/15/13 10:53:02AM   

tepid55

MMA Sensei

tepid55 Avatar
9
 
 
 
 


 
 
Posts:1,513
Career:2,987-1,634
Joined:Feb 2007
Camp: Pride FC Forever
Chips:
121
How will players be able to tell which fights are main card fights?

Post #12   10/15/13 1:39:14PM   

DoTheMMAth

MMA Sensei

DoTheMMAth Avatar
1
 
 
 


 
 
Posts:1,572
Career:1,500-932
Joined:Dec 2006
Chips:
356

Posted by tepid55

How will players be able to tell which fights are main card fights?



They'll be marked on the updated site, and the new games will depend on this data.

Like I said, these changes are more of a preparatory nature. I just wanted to get the bugs worked out of this massive chunk of the update that was sitting there already complete.

_______________________________________

Post #13   10/15/13 2:08:41PM   

wonderfulspam

Learning to Sprawl

 
 
 


 
 
Posts:1
Career:801-426
Joined:Jun 2011
Camp: BE Civil War
Chips:
Appreciate the heads up, sounds like you guys have put in some good work!

Quick question: does the site overhaul also include a more general UI update or is it mainly backend stuff?

Post #14   10/16/13 3:30:26PM