V1.2.0.202104122145 Player database!

After a few days of figuring out how to interact with a database, I’m finally confident that I can interact with a database using code-generated SQL.

  1. Linked the player creator to an external data source (presently using a 2004 version MS Access file).
  2. Player creator generate player button reads a random first name and surname and (state or country) from separate tables.
  3. Player creator now has a button to save the randomised player to the database.
  4. Player creator also has a button to save randomised players to database in bulk (user-specified number). Temporarily used a pop-up input box just to get it working. Tested out with 100 players – took 10 seconds.

Player data is incomplete at present (eg no pitching attributes) but the basic structure is complete and fields can be added/changed as required.

Comments

Post a Comment

Popular posts from this blog

V1.1.4.202103032300 Basic player creator, line score tidy up and additional play results, including errors

This was a pretty huge four days! Player creator: This idea came to me when I started wondering how I could fulfil my plan of creating 10,000 players at random, at the same time giving them realistic attributes. Added a separate form to generate players which can eventually be saved to database. Presently just generates attributes for contact and power vs L/R based on an entered minimum number of points to allocate, and entered maximum value for bonus points. Bonus points are calculated at random and added to total points to allocate across all attributes. If an attribute is already on 100, that bonus point is wasted. Works pretty well and will be expanded upon. Line score tidy up: This was something that was mostly a quick fix so I thought I may as well get it out of the way now. Now the button for the bottom of the current inning is disabled if playing the top of the inning. Now puts an X in the bottom of the 9th if not played at game end and disables tha...
Read more

MLB (Road to) The Show attribute progression

Image
Two key features of MLB The Show’s career mode have each divided its player base in two; satisfying one group of its users while alienating the other.  This first of two posts focuses on one of those features - the mode’s core feature of attribute progression. The proposed change will keep both groups of users satisfied without compromising the integrity of the mode. RPGs infiltrate the sport genre with career modes First introduced in MLB 07 The Show, Road to the Show (RTTS) is MLB The Show’s role-playing game (RPG) mode, which in sport games is often called career mode. We control a single character, whose existence (behaviours, skills and appearance) in its world is determined by a set of (mostly) numeric attributes. As the puppeteer of that character (and no other in the world) the attribute values are in our hands. It’s a difficult undertaking in sports games to implement a team-based career mode. Maintaining a balance between realism and keeping the player engage...
Read more

Writing a baseball game

Image
Baseball is the perfect sport for which to create a simulator. Every season, every game, every play, every pitch, every player  is comprised of a set of numbers. The choice of pitch, the target pitch location, how many outs, the batter's count, who's on base and where... and that's only part of what's going through the pitcher's  head even before a pitch is thrown. Then there's the batter, the baserunners, the fielders, the Manager, the General Manager... It's no wonder those who don't follow the game have trouble getting their heads around how it all works. Who would be crazy enough to try and recreate that in simulation form, AI logic and all? Well, this guy, as it turns out (in addition to a few awesome development studios who have had many years head start).  Yes, I finally pulled my finger out and started the 'baseball simulator' project that has been traversing my thoughts for the last year. The few scribbles I jotted down pre-COVID either ...
Read more