Welcome Guest
Log In | Register )
You last visited January 24, 2017, 12:09 pm
All times shown are
Eastern Time (GMT-5:00)

Implemented safety feature for predictions

Topic closed. 12 replies. Last post 11 years ago by Fibonacci.

Page 1 of 1
PrintE-mailLink
Todd's avatar - Cylon 2.gif
Chief Bottle Washer
New Jersey
United States
Member #1
May 31, 2000
23355 Posts
Online
Posted: July 24, 2006, 6:38 pm - IP Logged

I made another change to the post predictions page today to hopefully prevent partial posting.  It did not happen all the time, but sometimes when the database was especially busy some all states predictions only posted to some of the states.  What was happening was the post was taking so long (due to database activity) that the code stopped functioning.

The new code I implemented today does three things:

  1. Eliminated some overhead from the database functions to speed up the performance (so the post does not take as long).
  2. Wrapped the entire process in one transaction that will either completely pass or completely fail.  It wont get partially done and leave things halfway done.  If it gets halfway and stops, the data will be put back to the state it was prior to posting.
  3. Inserted error checking after each step in the process.  Posting to all states involves literally hundreds of database calls, and I have put error checking after each one, so that an error cannot slip past.

I really hope this solves any lingering posting problems.  I know that some people have [rightfully] been upset that their numbers haven't posted correctly, and I am hoping this will solve any such problems. It's still possible for a busy database to stop a post, but at least it shouldn't be left half-posted anymore.

 

Check the State Lottery Report Card
What grade did your lottery earn?

 

Sign the Petition for True Lottery Drawings
Help eliminate computerized drawings!

    JAP69's avatar - alas
    South Carolina
    United States
    Member #6
    November 4, 2001
    8797 Posts
    Offline
    Posted: July 24, 2006, 6:48 pm - IP Logged

    Thanks Todd for all your hard work you do.

    This site has come a long way since I first came here.

    Oo'Ka

      Todd's avatar - Cylon 2.gif
      Chief Bottle Washer
      New Jersey
      United States
      Member #1
      May 31, 2000
      23355 Posts
      Online
      Posted: July 24, 2006, 6:54 pm - IP Logged

      Thanks Todd for all your hard work you do.

      This site has come a long way since I first came here.

      Thank you.  I'm just loving how fast the threads are loading now.

       

      Check the State Lottery Report Card
      What grade did your lottery earn?

       

      Sign the Petition for True Lottery Drawings
      Help eliminate computerized drawings!

        four4me's avatar - gate1
        MD
        United States
        Member #1701
        June 18, 2003
        8396 Posts
        Offline
        Posted: July 24, 2006, 7:08 pm - IP Logged

        ah that's good news i just looked at the predictions i posted for all states last night and noticed that most of my pick 3's didn't post for all states. usually i check them and make corrections if they didn't go through.

        now we woln't have to worry bout it.

        Your the man!

          bellyache's avatar - 64x64a9wg

          United States
          Member #12618
          March 18, 2005
          2060 Posts
          Offline
          Posted: July 24, 2006, 7:22 pm - IP Logged

          Thank you Todd for continuing to making Lottery Post better and better! =)

          Dance like no one is watching.

            LottoChica23's avatar - Aquarius
            Fughedaboutit (NY)
            United States
            Member #8160
            October 26, 2004
            6777 Posts
            Offline
            Posted: July 24, 2006, 7:57 pm - IP Logged

            Thanks Todd for the prediction posting insurance, it is much appreciated.

            Partial posting happened to me the other day (on a good day too Let It All Out). LOL

            Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

            check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

            You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

              Todd's avatar - Cylon 2.gif
              Chief Bottle Washer
              New Jersey
              United States
              Member #1
              May 31, 2000
              23355 Posts
              Online
              Posted: July 24, 2006, 9:49 pm - IP Logged

              Importantly, if anyone ever notices it -- even if one number is missing -- please let me know.  At this point I would have had to majorly miss something in order for a posting error to occur.

              As I had mentioned above, if it detects an error, it should cleanup everything you just attempted to post, so it would be as if you never tried posting those picks at all.

               

              Check the State Lottery Report Card
              What grade did your lottery earn?

               

              Sign the Petition for True Lottery Drawings
              Help eliminate computerized drawings!

                Kola's avatar - image
                Blundering Time Traveler

                United States
                Member #28945
                December 25, 2005
                1532 Posts
                Offline
                Posted: July 25, 2006, 11:44 am - IP Logged

                Thanks Todd!

                  tntea's avatar - Lottery-059.jpg

                  United States
                  Member #5344
                  June 30, 2004
                  23641 Posts
                  Offline
                  Posted: July 25, 2006, 11:53 am - IP Logged

                  I have a question about the prediction page..

                  Is there any way it can be set up like the deflation page where you can copy and paste numbers..

                  For example..

                  say your work out came out with these numbers

                  153, 255, 226, 222

                  Right now we have to copy paste these... then put each to its own line and remove the commas..

                  very time consuming..

                       OLD/Vtrac   Lottery Bible         Double Warnings      Thumbs Up TN F34/F44

                    four4me's avatar - gate1
                    MD
                    United States
                    Member #1701
                    June 18, 2003
                    8396 Posts
                    Offline
                    Posted: July 25, 2006, 11:59 am - IP Logged

                    peice of cake copy whatever predictions you want. then click resources up top of this page and drop them in the deflator click deflate and copy the out put the commas will be gone.

                      tntea's avatar - Lottery-059.jpg

                      United States
                      Member #5344
                      June 30, 2004
                      23641 Posts
                      Offline
                      Posted: July 25, 2006, 12:07 pm - IP Logged

                      peice of cake copy whatever predictions you want. then click resources up top of this page and drop them in the deflator click deflate and copy the out put the commas will be gone.

                      Thanks

                      that will take away one step on prediction page.. by adding that step..

                      wish they could be listed side by side ......

                           OLD/Vtrac   Lottery Bible         Double Warnings      Thumbs Up TN F34/F44

                        Todd's avatar - Cylon 2.gif
                        Chief Bottle Washer
                        New Jersey
                        United States
                        Member #1
                        May 31, 2000
                        23355 Posts
                        Online
                        Posted: July 25, 2006, 12:33 pm - IP Logged

                        I will definitely be changing the post predictions page to make it much, much easier, and you will be able to do things like choosing a block of states to post to.

                         

                        Check the State Lottery Report Card
                        What grade did your lottery earn?

                         

                        Sign the Petition for True Lottery Drawings
                        Help eliminate computerized drawings!

                          Fibonacci's avatar - Lottery-050.jpg
                          New York, NY
                          United States
                          Member #39471
                          May 16, 2006
                          2698 Posts
                          Offline
                          Posted: July 25, 2006, 12:39 pm - IP Logged

                          That will be thebest innovation in my view. I like dealing with about 7-8 states but usually i post all states because I hate having to repeat the same task 8 times...

                          Thanks Todd for this great site and all you do to let it stay cutting edge.

                          $$$