Search found 15 matches

by andygb4
Fri Oct 23, 2015 10:56 am
Forum: Verison 4.0x Support Forum
Topic: Early Games in London lock all Sunday games
Replies: 1
Views: 2832

Early Games in London lock all Sunday games

So this isn't really a question, but I thought it might help others in the future. There's a game in London this week, and it's at 9:30 AM, so with the current logic of the pool, ALL of the Sunday (and Monday) games get locked at 9:30 AM. Lot's of players in my pool didn't like that, since they all ...
by andygb4
Fri Sep 19, 2014 10:09 am
Forum: Verison 4.0x Support Forum
Topic: SideStandings page extremely slow
Replies: 6
Views: 4958

Re: SideStandings page extremely slow

I forgot to mention that I stripped down the menu to only show what I needed, like the Survivor pool.

Just a heads up if any of you are using the other pool modes as well!
by andygb4
Fri Sep 19, 2014 9:56 am
Forum: Verison 4.0x Support Forum
Topic: SideStandings page extremely slow
Replies: 6
Views: 4958

Re: SideStandings page extremely slow

Hey PAUDASH, I replied to your PM, hope that helps :) Ive made some other changes to the page like using mini logos instead of abbreviations. Also added a red box when the pick is incorrect. I even added big background images to match a user's "favorite" team. On the login page, I also rem...
by andygb4
Mon Sep 08, 2014 12:20 pm
Forum: Verison 4.0x Support Forum
Topic: SideStandings page extremely slow
Replies: 6
Views: 4958

Re: SideStandings page extremely slow

Yes!! Fixed it! With about 300 players in the pool, the standings page was taking way over 60 seconds to load! But I changed some code, so instead of querying the database for each player, it would only query it once, get all the info, store them in arrays, and go pick up wtv info u need for each pl...
by andygb4
Thu Sep 04, 2014 3:52 pm
Forum: Verison 4.0x Support Forum
Topic: SideStandings page extremely slow
Replies: 6
Views: 4958

Re: SideStandings page extremely slow

I've been making some changes to the page for the last 2 days.
I noticed that the code could be a bit more efficient, so I'm trying to cut down on the number of SQL queries.
It's a lot of work, but so far it seems like it's helping.
We'll see what it's like when I'm done.
by andygb4
Thu Sep 04, 2014 12:08 pm
Forum: Verison 4.0x Support Forum
Topic: Survivor Pool multiple entrys
Replies: 2
Views: 2810

Re: Survivor Pool multiple entrys

I've been using 2 usernames for my pool. I couldn't think of a way to do it under the same username... There would be so many modifications to make, like the SideEntry page. There would have to be way to know for which user you would be entering the pick for. (kind of like the way the admin does it,...
by andygb4
Wed Sep 03, 2014 10:04 am
Forum: Verison 4.0x Support Forum
Topic: SideStandings page extremely slow
Replies: 6
Views: 4958

SideStandings page extremely slow

Hey Everyone, I now have over 50 users that placed their Week 1 pick in my survivor pool, and when I load the Side Standings page, it takes between 35-45 seconds to load. Does anyone else have many users and have trouble with loading that page? The way the SidePicks table is set up seems like there ...
by andygb4
Thu Oct 10, 2013 5:45 pm
Forum: Verison 4.0x Support Forum
Topic: SQL Pool version
Replies: 11
Views: 20613

Re: SQL Pool version

Is that really all you changed from the zip files philwojo put up ? Like what about the includes->common.asp ? There's a OpenDB function, not sure if I need to do anything to it. Because with the change you gave me, I can see the login page, and the listbox IS populated with all the users names (so ...
by andygb4
Thu Oct 10, 2013 5:45 pm
Forum: Downloads
Topic: 2013 SQL Pool version
Replies: 9
Views: 10342

Re: SQL Pool version

Is that really all you changed from the zip files philwojo put up ? Like what about the includes->common.asp ? There's a OpenDB function, not sure if I need to do anything to it. Because with the change you gave me, I can see the login page, and the listbox IS populated with all the users names (so ...
by andygb4
Sun Oct 06, 2013 12:12 pm
Forum: Verison 4.0x Support Forum
Topic: SQL Pool version
Replies: 11
Views: 20613

Re: SQL Pool version

thanks so much, I'll give that a try!
by andygb4
Sun Oct 06, 2013 12:12 pm
Forum: Downloads
Topic: 2013 SQL Pool version
Replies: 9
Views: 10342

Re: SQL Pool version

thanks so much, I'll give that a try!
by andygb4
Thu Oct 03, 2013 6:49 pm
Forum: Verison 4.0x Support Forum
Topic: SQL Pool version
Replies: 11
Views: 20613

Re: SQL Pool version

My SQL Server is set up properly with all the tables and data, but I can't seem to get the website to connect to it. What did you change in the config file, and did you change anything else?
thanks!
by andygb4
Thu Oct 03, 2013 6:49 pm
Forum: Downloads
Topic: 2013 SQL Pool version
Replies: 9
Views: 10342

Re: SQL Pool version

My SQL Server is set up properly with all the tables and data, but I can't seem to get the website to connect to it. What did you change in the config file, and did you change anything else?
thanks!
by andygb4
Wed Oct 02, 2013 6:07 pm
Forum: Verison 4.0x Support Forum
Topic: SQL Pool version
Replies: 11
Views: 20613

Re: SQL Pool version

Aw man, I wish I had seen this earlier... I had all the INSERT statements to populate the schedule!

I can't really help you much for the auto-updater though, sorry...
by andygb4
Wed Oct 02, 2013 6:07 pm
Forum: Downloads
Topic: 2013 SQL Pool version
Replies: 9
Views: 10342

Re: SQL Pool version

Aw man, I wish I had seen this earlier... I had all the INSERT statements to populate the schedule!

I can't really help you much for the auto-updater though, sorry...