StatsLab SQL Utilities for OOTPX - Page 11

fhomess · 11-02-2009, 02:02 PM

Here's the CSS used by the PEBA as sent to me by Corsairs and developed by one of his league members:

PHP Code:


			
/* Division Block */

.wdgT

{

    width:170px;

    margin-bottom:5px;

}



/* Column Headers */

.wdgH td

{

    font-size:10px;

    font-weight:bold;

    text-align:center;

    width:23px;

    border-bottom:1px solid black;

}



/* Win, Loss and GB columns */

.wdg1 td,

.wdg2 td

{

     width:23px;

     font-size:10px;

     text-align:center;

}



/* Team Name Column */

.wdg1 .wdg1_l,

.wdg2 .wdg2_l

{

    font-size:12px;

    width:101px;

    text-align:left;

}



/* Divison Name Headers */

.wdgH .wdgH_l 

{

    width:101px;

    text-align:left;

}

Cooleyvol · 11-05-2009, 07:31 PM

Anyone versed in setting this up that is willing to help me configure it would be greatly appreciated.

I'm on AIM -- Cooleyvol.

Cooleyvol · 11-06-2009, 01:58 PM

I'm told I don't have the team_relations table uploaded, but I don't see that in the config area of the csv dump.

Alan T · 11-06-2009, 02:06 PM

Quote:

Originally Posted by Cooleyvol

I'm told I don't have the team_relations table uploaded, but I don't see that in the config area of the csv dump.

I assume by csv dump you mean sql dump here.

team_relations in my ootpx is 15th down in the configuration screen on what to include (right beneath league_* stuff, sub_leagues and divisions)

fhomess · 11-06-2009, 02:14 PM

From the standpoint of what's contained in it, that's a logical place to put it, but the name make you think it should be at the bottom with the other team stuff.

This post contains the checkboxes you need as of patch 1.2.1, and I believe they're in the in-game order:
http://www.ootpdevelopments.com/boar...ml#post2846853

MrWorkrate · 11-09-2009, 01:04 PM

RE: Widgets

I can take the code generated from the widget and copy that into my site and it works fine, but I would have to do that every single time we have a sim.

Is there a way to do it so that you don't have to re-copy the code each time? If it were possible to link to the WGT file and have that embedded into the page that would be the best way to go, I would think, but if I try to embed it into the HTML I either get a link going to the HTML code or nothing at all.

fhomess · 11-11-2009, 11:17 AM

There's a few options to get it to display and what you choose depends on how your league site is generated. You could use a server side include (SSI) provided that your host is configured for them. If your league page is php based, you can include it with a php command.

e.g. SSI:

Code:

<!--#include virtual="/<relative_path>/widget.wgt" -->

e.g. PHP:

Code:

include("/<relative_path>/widget.wgt");

Javasript could also be used, but would be a fair amount more complicated.

fhomess · 11-11-2009, 11:35 AM

Patch 1.2.2 is now available for download via the regular Patch 2 link. Enhancements primarily to the draft utility:
1. You can now schedule your draft out in serpentine fashion.
2. You can now display, filter, and sort players based on feeder league stats in the team war room.
3. The draft board and team war room pages have been made more efficient to provide faster page load times in leagues with a large number of players.
4. Draft board will now display the time a pick was made if logged in as a commissioner.
5. Other minor fixes.

Cooleyvol · 11-16-2009, 10:01 PM

All my widgets are updating except the standings. Any ideas from those who use these?

Which file does the standings use to update?

fhomess · 11-18-2009, 12:36 PM

Quote:

Originally Posted by Cooleyvol

All my widgets are updating except the standings. Any ideas from those who use these?

Which file does the standings use to update?

Make sure you've loaded the most recent version of team_record.mysql.sql. The team_relations table also needs to be accurate, but that only changes when you realign, expand, or contract your league.

Stu · 11-18-2009, 10:07 PM

I *think* I found an issue with the draft. I want to start my league's draft after thanksgiving weekend so I set the start date to '2009-11-30' however on the draft board screen it says 'Pick is due no later than 2009-11-19 12:00 EST' for the first team.

fhomess · 11-19-2009, 02:01 PM

Quote:

Originally Posted by Stu

I *think* I found an issue with the draft. I want to start my league's draft after thanksgiving weekend so I set the start date to '2009-11-30' however on the draft board screen it says 'Pick is due no later than 2009-11-19 12:00 EST' for the first team.

I'm pretty sure I had fixed that bug. Please download and install 1.2.2 again. I believe it should also reschedule correctly if you resave your draft timer settings.

Stu · 11-19-2009, 04:51 PM

Quote:

Originally Posted by fhomess

I'm pretty sure I had fixed that bug. Please download and install 1.2.2 again. I believe it should also reschedule correctly if you resave your draft timer settings.

I re-uploaded patch 2 and tried saving the timer settings again and it's still showing up as 11-19-2009. No big deal since I can just disable the draft until I'm ready but figured I'd let you know.

fhomess · 11-19-2009, 07:00 PM

Quote:

Originally Posted by Stu

I re-uploaded patch 2 and tried saving the timer settings again and it's still showing up as 11-19-2009. No big deal since I can just disable the draft until I'm ready but figured I'd let you know.

Then I'm not sure what the problem is, as I'm not able to reproduce this and haven't heard of other leagues having this issue. If you're willing to provide me access (shoot me a PM), then I can take a closer look.

Stu · 11-25-2009, 10:48 AM

Feature Request:

- Manually add players to HOF ballot. Even if it was just entering a player id, it would be nice to be able to manually add players.

fhomess · 11-25-2009, 01:40 PM

Patch 2.3 is now available: Patch #2.3

Mostly just fixes, but there is one new feature which is already one of my favorites: Stat of the Day. Inspired by BB-Ref's blog and some friends in the PBRL, StatsLab's Stat of the Day is enabled in the Last Sim module and will provide a daily unique statistical insight into your league. The page will change daily, and there are 183 different SOTD's, so it'll be 6 months real-time before you start seeing the same ones again.

Some examples include the following:
- Most Home Runs by Age
- Most Walks in a Season by Batter Height
- Highest Number Of Team Runs Scored Relative to League
- Most Career Wins Without Being An All-Star
- Most Earned Runs Without Allowing An Unearned Run
- More Walks Than Hits In A Season
- Highest Percentage of Team Runs Knocked In By One Batter

Many thanks to the PEBA for testing and providing some great suggestions to go into this new page.

Also, you can now force the HOF ballot to contain specific players by adding their player ID on the HOF Admin page.

Stu · 11-25-2009, 02:08 PM

You rule.

Stu · 11-25-2009, 02:25 PM

I'm getting this error when I try to manually add a pitcher to the ballot:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.../ootpsqlou/hall_of_fame_vote.php on line 485

Stu · 11-25-2009, 02:37 PM

Never mind it's because my General Settings weren't valid.

Stu · 11-25-2009, 04:22 PM

Sorry for the confusion but I think there is a minor issue. I kept getting the error above when I tried to add a pitcher to the ballot and the guy I was trying to add wouldn't show up on the ballot. However, I added a hitter to test and they both showed up (both the hitter and pitcher I tried to add previously). If I enter '0' in the hitters section it works fine as well.

So it seems like you can't enter a player in one field and leave the other one blank. It needs to have something entered, even if it's just '0'.

Make sense?

11-02-2009, 02:02 PM	#201
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 3,585	Here's the CSS used by the PEBA as sent to me by Corsairs and developed by one of his league members: PHP Code: /* Division Block / .wdgT { width:170px; margin-bottom:5px; } / Column Headers / .wdgH td { font-size:10px; font-weight:bold; text-align:center; width:23px; border-bottom:1px solid black; } / Win, Loss and GB columns / .wdg1 td, .wdg2 td { width:23px; font-size:10px; text-align:center; } / Team Name Column / .wdg1 .wdg1_l, .wdg2 .wdg2_l { font-size:12px; width:101px; text-align:left; } / Divison Name Headers */ .wdgH .wdgH_l { width:101px; text-align:left; } __________________ StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development.

11-06-2009, 02:14 PM	#205
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 3,585	From the standpoint of what's contained in it, that's a logical place to put it, but the name make you think it should be at the bottom with the other team stuff. This post contains the checkboxes you need as of patch 1.2.1, and I believe they're in the in-game order: http://www.ootpdevelopments.com/boar...ml#post2846853 __________________ StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development.

11-09-2009, 01:04 PM	#206
MrWorkrate All Star Starter Join Date: Mar 2002 Location: Raleigh, NC Posts: 1,262	RE: Widgets I can take the code generated from the widget and copy that into my site and it works fine, but I would have to do that every single time we have a sim. Is there a way to do it so that you don't have to re-copy the code each time? If it were possible to link to the WGT file and have that embedded into the page that would be the best way to go, I would think, but if I try to embed it into the HTML I either get a link going to the HTML code or nothing at all. __________________ I used to come here a lot. Now, not so much.

11-11-2009, 11:17 AM	#207
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 3,585	There's a few options to get it to display and what you choose depends on how your league site is generated. You could use a server side include (SSI) provided that your host is configured for them. If your league page is php based, you can include it with a php command. e.g. SSI: Code: <!--#include virtual="/<relative_path>/widget.wgt" --> e.g. PHP: Code: include("/<relative_path>/widget.wgt"); Javasript could also be used, but would be a fair amount more complicated. __________________ StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development.

11-11-2009, 11:35 AM	#208
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 3,585	Patch 1.2.2 is now available for download via the regular Patch 2 link. Enhancements primarily to the draft utility: 1. You can now schedule your draft out in serpentine fashion. 2. You can now display, filter, and sort players based on feeder league stats in the team war room. 3. The draft board and team war room pages have been made more efficient to provide faster page load times in leagues with a large number of players. 4. Draft board will now display the time a pick was made if logged in as a commissioner. 5. Other minor fixes. __________________ StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. Last edited by fhomess; 11-11-2009 at 04:58 PM.

11-05-2009, 07:31 PM	#202
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	Anyone versed in setting this up that is willing to help me configure it would be greatly appreciated. I'm on AIM -- Cooleyvol.

11-06-2009, 01:58 PM	#203
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	I'm told I don't have the team_relations table uploaded, but I don't see that in the config area of the csv dump.

11-16-2009, 10:01 PM	#209
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	All my widgets are updating except the standings. Any ideas from those who use these? Which file does the standings use to update?

11-18-2009, 10:07 PM	#211
Stu All Star Starter Join Date: Dec 2005 Posts: 1,255	I think I found an issue with the draft. I want to start my league's draft after thanksgiving weekend so I set the start date to '2009-11-30' however on the draft board screen it says 'Pick is due no later than 2009-11-19 12:00 EST' for the first team. __________________ Brewers League Baseball

11-25-2009, 10:48 AM	#215
Stu All Star Starter Join Date: Dec 2005 Posts: 1,255	Feature Request: - Manually add players to HOF ballot. Even if it was just entering a player id, it would be nice to be able to manually add players. __________________ Brewers League Baseball

11-25-2009, 01:40 PM	#216
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 3,585	Patch 2.3 is now available: Patch #2.3 Mostly just fixes, but there is one new feature which is already one of my favorites: Stat of the Day. Inspired by BB-Ref's blog and some friends in the PBRL, StatsLab's Stat of the Day is enabled in the Last Sim module and will provide a daily unique statistical insight into your league. The page will change daily, and there are 183 different SOTD's, so it'll be 6 months real-time before you start seeing the same ones again. Some examples include the following: - Most Home Runs by Age - Most Walks in a Season by Batter Height - Highest Number Of Team Runs Scored Relative to League - Most Career Wins Without Being An All-Star - Most Earned Runs Without Allowing An Unearned Run - More Walks Than Hits In A Season - Highest Percentage of Team Runs Knocked In By One Batter Many thanks to the PEBA for testing and providing some great suggestions to go into this new page. Also, you can now force the HOF ballot to contain specific players by adding their player ID on the HOF Admin page. __________________ StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. Last edited by fhomess; 11-25-2009 at 01:43 PM.

11-25-2009, 02:08 PM	#217
Stu All Star Starter Join Date: Dec 2005 Posts: 1,255	You rule. __________________ Brewers League Baseball

11-25-2009, 02:25 PM	#218
Stu All Star Starter Join Date: Dec 2005 Posts: 1,255	I'm getting this error when I try to manually add a pitcher to the ballot: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.../ootpsqlou/hall_of_fame_vote.php on line 485 __________________ Brewers League Baseball

11-25-2009, 02:37 PM	#219
Stu All Star Starter Join Date: Dec 2005 Posts: 1,255	Never mind it's because my General Settings weren't valid. __________________ Brewers League Baseball

11-25-2009, 04:22 PM	#220
Stu All Star Starter Join Date: Dec 2005 Posts: 1,255	Sorry for the confusion but I think there is a minor issue. I kept getting the error above when I tried to add a pitcher to the ballot and the guy I was trying to add wouldn't show up on the ballot. However, I added a hitter to test and they both showed up (both the hitter and pitcher I tried to add previously). If I enter '0' in the hitters section it works fine as well. So it seems like you can't enter a player in one field and leave the other one blank. It needs to have something entered, even if it's just '0'. Make sense? __________________ Brewers League Baseball Last edited by Stu; 11-25-2009 at 04:34 PM.