Database idea - HTML tables per player

[Gantry]

I'm starting to use the Mediawiki Templates to simplify some of the data entry.  The first ones I want to do are for pitchers and hitters, making a nice little table that'll go on the right side and give a pic, all the pertinent rbi stats etc.  A good example for what I want is on the RBI page:

http://en.wikipedia.org/wiki/Rbi_baseball

That would be perfect, but that table is highly "wikified" - calling other templates and the like.  As a result, I can't find the raw HTML to use and am too lazy to do it myself.  Anyone want to help a brother out?  Feel free to use the Doug Corbett page as a guinea pig:

http://dee-nee.com/wiki/index.php/Doug_Corbett

Here is the basic template I created so far, simply adds the bullets like we've been using. 

http://dee-nee.com/wiki/index.php/Template:Pitcher

The only page using it so far is the Don Sutton page:

http://dee-nee.com/wiki/index.php/Don_Sutton

[Gantry]

Created some more templates, BatterCareer and Batter.  Batter puts in the "RBI Stats" area and BatterCareer makes the nice little table for career stats.  The template page for BatterCareer:

http://dee-nee.com/wiki/index.php/Template:BatterCareer

To use a template, simply put {{TEMPLATE_NAME}} and if it has variables, fill them in.  Here is the BatterCareer template used on Jose Uribe's page.

{{BatterCareer|
|G=1038
|AB=3064
|R=307
|H=738
|2B=99
|3B=34
|HR=19
|RBI=256
|SB=72
|BB=256
|SO=425
|BA=.241
|OBP=.300
|SLG=.314
|OPS=.614
}}

Like many things wikipedia, it looks a bit tricky at first but really simple if you copy/past from another use.  Good thing about the template is that you don't have all that HTML code in each page for creating the table.  Also, if you decide to alter the table at some point, it'll automatically update all the pages that use the template.  Win-win situation

[fightonusc]

Why does Don Sutton's pitching page have Dave Smith's Stratomatic card on it? This seems to be a problem with all of the Pitcher templates...

[Attezz]

I suck

[Attezz]

I think I fixed it, I'm so proud (ashamed) of myself.

[Gantry]

Attezz accidentially put the Smith pic in the pitcher stat template.  If you see the history of the template, you can tell when it happened. 

No harm, no foul - actually it's good cause it's a little easier to understand how templates work.  You add any data to the template page, it shows up on all pages that use that template. 

[fightonusc]

Cool - it's a good concept, though, using Stratomatic pages...

I created a Bio template that should guide people through the basics for creating a player's bio, as well as standardizing the whole process:

http://dee-nee.com/wiki/index.php/Template:Bio

[fknmclane]

Great, great idea.  My biggest concern when adding to the Db is whether or not the shit I'm putting in is uniform, if it matches up with other entries.

[Gantry]

Made a new template for Pitcher Career stats, and would like some feedback. 

http://dee-nee.com/wiki/index.php/Template:PitcherCareer

Or to see one filled out, goto Dave Smith's page:

http://dee-nee.com/wiki/index.php/Dave_Smith

Specifially looking for suggestions on what stats to use.  Copy/pasted one someone created before and I think there are a couple fields I'd like to add/remove.  I removed Wild Pitches and switched it with ERA+,  now I'm thinking about removing HBP and adding Games and Hits.  Thoughts? 

[Gantry]

Still looking for pitcher categoryies, otherwise I'll remove HBP and add G/Hits

[fightonusc]

I would add games (this is especially important for relievers) and hits, although I wouldn't do it at the expense of HBP - I'd almost consider removing ERA+ instead. And I think that HR allowed would be a good stat too.

[Attezz]

I would add games finished.

You may be able to get lefty/righty BAA splits on mlb.com if you'd want to go through all that trouble.

Even so, I think Baseball-reference shows games finished.

[Gantry]

New table:

http://dee-nee.com/wiki/index.php/Dave_Smith

Added Games and hits...  Should I put Games Started right after games or leave it where it is?