Welcome Guest
Log In | Register )
You last visited December 5, 2016, 9:28 am
All times shown are
Eastern Time (GMT-5:00)

LotSoftPro

Topic closed. 570 replies. Last post 2 years ago by winsumloosesum.

Page 12 of 39
59
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: June 20, 2014, 9:43 pm - IP Logged

Here is the list of Pick 3 games and their StateID's

Excel

https://app.box.com/s/1k9zlmnkyygpdsc6b1wt

 

StateIDStateInfo
9NY (M)New York midday
11NY (E)New York numbers (evening)
12VA (M)Virginia midday 3
13SC (M)South Carolina Midday 3
14SC (E)South Carolina Pick3 (evening)
15AZ (E)Arizona Pick3 (Evening)
17PA (M)Pennsylvania Midday Daily Number
18PA (E)Pennsylvania Daily number (evening)
19IL (E)Illinois daily 3 Eve
20CA (E)California Daily 3 Evening
24IL (M)Illinois midday 3
25NJ (M)New Jersey midday 3
26NJ (E)New Jersey Pick 3 evening
28MI (E)Michigan evening pick3
29MI (M)Michigan Daily 3 day
31TX (E)Texas Pick3 night
32TN (E)Tennessee Cash3 evening
33OH (E)Ohio Pick3 evening
34DE (E)Delaware Play3 evening
35WC (E)Western Canada Pick3 eve
36GA (M)Georgia midday 3
37GA (E)Georgia Cash 3 evening
38FL (E)Florida Cash3 evening
39OH (M)Ohio Midday 3 midday
40Tri State (M)Tri-State midday draws
41Tri State (E)Tri State evening draws
42CA (M)California midday
43VA (E)Virginia evening
44MO (E)Missouri
45MO (M)Missouri
46IN (E)Indiana evening
47IN (M)Indiana midday
48ID (E)Idaho
49WI (E)Wisconsin
50NM (E)New Mexico
51TX (M)Texas midday 3
52MD (M)Maryland midday
53MD (E)Maryland Evening
54DE (M)Delaware midday
55CT (E)Connecticut evening
56KY (M)Kentucky midday pick3
57KY (E)Kentucky Evening
58DC (M)District Of Columbia Lucky Midday
59DC (E)District Of Columbia Lucky numbers
61LA (E)Louisiana Pick3
62MN (E)Minnesota Daily 3
63OK (E)Oklahoma
64NE (E)Nebraska
65Ontario (E)Ontario Pick 3
66KS (E)Kansas
67TN (M)Tennesse midday
68WV (E)West-Virginia
69WA (E)Washington daily
70CT (M)Connecticut midday 3
72QC (E)Quebec La Quotidienne 3
73NC (E)North Carlolina Pick3
74NC (M)North Carlolina Pick3 midday
75FL (M)Florida Midday
76AR (M)Arkansas Cash 3 midday
77AR (E)Arkansas Cash 3 evening
78ID (M)Idaho Midday
79Ontario (M)Ontarion Midday
80CO (E)Colorado Evening
81ILMy3 (M)Illinois My3 Midday
82ILMy3 (E)Illinois My3 Evening
83IA (M)Iowa Midday
84IA (E)Iowa Evening
    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: June 21, 2014, 8:54 am - IP Logged

    Draws updated 6/21/2014 at 8:50 am

    History through Friday 6/20/2014

      Best Picks's avatar - Lottery-036.jpg
      Eastern Missouri
      United States
      Member #841
      November 7, 2002
      2430 Posts
      Offline
      Posted: June 21, 2014, 2:34 pm - IP Logged

      I haven't been on for some months, now I see why my live updates were not working. I'm shocked to hear about Ricky, he was amazing in how he took all the ideas that were presented to him and created this software.  Winsum is also amazing, you would always create a spreadsheet of whatever someone came up with. Thank you for going above and beyond in finding a way for this wonderful software to continue to be used.

      Smile

      Numbers.

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Offline
        Posted: June 21, 2014, 5:31 pm - IP Logged

        Added the following Pick 3 states/game to Lotsoft Pro.

        You have the option of creating the games yourself using the following codes or downloading my file p3.mdb

        Those who want to enter your own:

        Puerto Rico Midday  State ID = 85,  8  Digit Code = AR9986T6,  Name = PR (D), Info = Puerto Rico Pega 3 midday

        Puerto Rico Evening  State ID = 86,  8  Digit Code = AR9985T6,  Name = PR (E), Info = Puerto Rico Pega 3 evening

        Tennessee Morning  State ID = 87,  8  Digit Code = AR9984T6,  Name = TN (M), Info = Tennessee Pick 3 morning

        Texas Morning  State ID = 88,  8  Digit Code = AR9983T6,  Name = TX (M), Info = Texas Pick 3 morning

        Texas Evening  State ID = 89,  8  Digit Code = AR9982T6,  Name = TX (E), Info = Texas Pick 3 evening

         

        I manually changed my p3.mdb file to make the following changes:

        1.  Since Tennessee and Texas have added additional games for the Pick 3 such as Tennessee adding the morning game and Texas adding a morning and evening game.  Texas evening draws from inception (older) are now called the Texas nite draws and the new game for the evening draws is now evening.

        2. I changed the (M) which designated any state that midday draw to the letter (D) which represents "day".  The (M) now represents "morning".

        Make sure you make a backup of your p3.mdb file located in the Lotsoft data folder where Lotsoft was installed.  Check the modified date which would be the date when you last performed a live update.  Place this in a new folder where you can remember it. 

        Here is the download link to the p3.mdb file that I have currently for the Pick 3 games for Lotsoft.  You can download and then copy and paste the p3.mdb file into your data folder. 

        https://app.box.com/s/kvkpbjadweeiko4r63mb

         

        I uploaded the draw histories for the above games.

        Just click the "Live Update" button. 

        Let me know if any errors or questions.

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: June 21, 2014, 5:44 pm - IP Logged

           

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5387 Posts
            Offline
            Posted: June 21, 2014, 5:57 pm - IP Logged

            This Excel file is all the information exported from the tbl_States database file.

            https://app.box.com/s/logoy72sa47pqt142hqa

            If you have Microsoft Access or want to use a FREE database program (see my Blog post) you can open the Pick 3 database file located in your Lotsoft data folder.  When you open the file it will require a password. 

            The password is: {0,1}f(XP)

            Enter the password and the database file should open.

            Look for a table labeled tbl_States

            Double click this table and it will open.

            You can make changes to each of the cells

            If you would like to compare your p3.mdb tbl_States with the information in the Excel file.

            Remember any changes you make will be reflected when you re-open Lotsoft.

            Open the p3.mdb file located in one of the 2 possible locations on your computer.  You will need to add a column called "modified date".  You want to open the p3.mdb file that has the most recent "modified date".  This will be the p3.mdb file that is currently being used by Lotsoft when you click the "Live Update" button.

            In my version of Windows 7 the p3.mdb file that I use is located in the following folder:

            C:/Program Files/INW/Lotsoft/data/ 

             

            2 Possible locations - check the folder that contains the most recent "modified date"

            C:/Program Files/INW/Lotsoft/data/

            and/or

            C:/Users/(your name)/AppData/Local/VirtualStore/Program Files/INW/LotSoft/data

            Note: (your name) will be whatever appears as the Users

              bootleg233's avatar - Lottery-034.jpg
              Tn
              United States
              Member #54963
              September 4, 2007
              1164 Posts
              Offline
              Posted: June 21, 2014, 7:58 pm - IP Logged

              Added the following Pick 3 states/game to Lotsoft Pro.

              You have the option of creating the games yourself using the following codes or downloading my file p3.mdb

              Those who want to enter your own:

              Puerto Rico Midday  State ID = 85,  8  Digit Code = AR9986T6,  Name = PR (D), Info = Puerto Rico Pega 3 midday

              Puerto Rico Evening  State ID = 86,  8  Digit Code = AR9985T6,  Name = PR (E), Info = Puerto Rico Pega 3 evening

              Tennessee Morning  State ID = 87,  8  Digit Code = AR9984T6,  Name = TN (M), Info = Tennessee Pick 3 morning

              Texas Morning  State ID = 88,  8  Digit Code = AR9983T6,  Name = TX (M), Info = Texas Pick 3 morning

              Texas Evening  State ID = 89,  8  Digit Code = AR9982T6,  Name = TX (E), Info = Texas Pick 3 evening

               

              I manually changed my p3.mdb file to make the following changes:

              1.  Since Tennessee and Texas have added additional games for the Pick 3 such as Tennessee adding the morning game and Texas adding a morning and evening game.  Texas evening draws from inception (older) are now called the Texas nite draws and the new game for the evening draws is now evening.

              2. I changed the (M) which designated any state that midday draw to the letter (D) which represents "day".  The (M) now represents "morning".

              Make sure you make a backup of your p3.mdb file located in the Lotsoft data folder where Lotsoft was installed.  Check the modified date which would be the date when you last performed a live update.  Place this in a new folder where you can remember it. 

              Here is the download link to the p3.mdb file that I have currently for the Pick 3 games for Lotsoft.  You can download and then copy and paste the p3.mdb file into your data folder. 

              https://app.box.com/s/kvkpbjadweeiko4r63mb

               

              I uploaded the draw histories for the above games.

              Just click the "Live Update" button. 

              Let me know if any errors or questions.

              Thanks Steve!!!!! Da Boot!!

              WHEN IT FEELS THE WHOLE WORLD SUCKS!

              RELAX.........IT'S ONLY GRAVITY Big Smile

              I think I can I think I can!!!!

                winsumloosesum's avatar - Lottery-060.jpg
                Pennsylvania
                United States
                Member #2218
                September 1, 2003
                5387 Posts
                Offline
                Posted: June 22, 2014, 8:51 am - IP Logged

                Live Update - Draws for Pick 3 and Pick 4 updated through Saturday June 21, 2014

                  Jack-C's avatar - us
                  San Diego, CA
                  United States
                  Member #61467
                  May 24, 2008
                  28146 Posts
                  Offline
                  Posted: June 22, 2014, 9:15 am - IP Logged

                  Live Update - Draws for Pick 3 and Pick 4 updated through Saturday June 21, 2014

                  Yesterday when I did a Pick 3 Live Update, it showed that it had updated over 800 draws.  This morning it was over 2,000 draws, but I know that's not true, because it would have taken much longer!

                    Jack-C's avatar - us
                    San Diego, CA
                    United States
                    Member #61467
                    May 24, 2008
                    28146 Posts
                    Offline
                    Posted: June 22, 2014, 10:04 am - IP Logged

                    Yesterday when I did a Pick 3 Live Update, it showed that it had updated over 800 draws.  This morning it was over 2,000 draws, but I know that's not true, because it would have taken much longer!

                    I just did the live update again because I noticed that I did not get 06/21 results.  This time it shows 0 files updated and I still don't have the 21st.  This might be because I have not been closing LotSoftPro.  When I shut down my computer, I actually keep everything that is open in RAM.  This way I continue to have 20 days left on LotSoftPro!  I did shut it down once and it only lost a day (now 19 days left) after many days of not closing it.

                      Jack-C's avatar - us
                      San Diego, CA
                      United States
                      Member #61467
                      May 24, 2008
                      28146 Posts
                      Offline
                      Posted: June 22, 2014, 11:08 am - IP Logged

                      After shutting down LSP and doing another live update, I now have the 21st!  Now I have 18 days left!!

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5387 Posts
                        Offline
                        Posted: June 23, 2014, 3:19 am - IP Logged

                        Live Update good through 6/22/2014 draw dates

                          winsumloosesum's avatar - Lottery-060.jpg
                          Pennsylvania
                          United States
                          Member #2218
                          September 1, 2003
                          5387 Posts
                          Offline
                          Posted: June 24, 2014, 2:42 am - IP Logged

                          Live Update draws good through Monday 6/23/2014 draw dates

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5387 Posts
                            Offline
                            Posted: June 24, 2014, 8:47 pm - IP Logged

                            Carbob informed me that there are duplicate draws for the Texas Midday Pick 3 game.

                            This is how I corrected my copy of Lotsoft.  The original installation of Lotsoft there were duplicate drawings in the p3.mdb database file.

                            1.  I deleted the Texas Midday Pick 3 game

                            2.  I created a new Texas Midday Game with the following entries:

                            Texas Pick 3 Midday

                            3.  Make sure you uncheck the Sunday

                            4.  Click add

                            5.  Then click "Draws - Live Update"

                            6.  I uploaded the corrected "FTPDrawsUSA.txt" file to the server that contains only the Texas Midday Pick 3 draws which start on 4/29/2002 through June 23, 2014

                            This will correct the duplicate issue. 

                            In a previous post I explained how I created the Texas Morning and Evening games along with how I changed the p3.mdb database file.

                            p3mdb file

                            7. In the screen shot above is the p3.mdb file located in the Lotsoft data folder.

                            If you want to change the entries to match the ones in the screen shot above you will need to have either Microsoft Access or download the FREE program I posted in my Blog.  Locate the "StateID" and make the appropriate changes to match the entries above.  Select the tbl_states.

                            You will be required to enter a password which is the following: {0,1}f(XP)

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5387 Posts
                              Offline
                              Posted: June 24, 2014, 8:54 pm - IP Logged

                              You can also download thw p3.mdb file and replace your existing file with the following:

                              https://app.box.com/s/yypig5i2k4g45cfs599i

                              Check the following 2 folders and see which folder has the p3.mdb file with the most current date or most recent date.  You may need to add a "modified date" column.

                              C:/Program Files/INW/Lotsoft/data/

                              and/or

                              C:/Users/(your name)/AppData/Local/VirtualStore/Program Files/INW/LotSoft/data

                              Note: (your name) will be whatever appears as the Users

                                 
                                Page 12 of 39