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

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 engaged re
Read more

MLB The Show 21: create a stadium prediction & using created stadiums in online games

Background We now know that (as predicted) MLB The Show 20's rebranding feature will incorporate the Diamond Dynasty team branding features.  Leveraging the DD team branding assets in Franchise mode is a simple first-step solution to a feature long-requested by its player base. It’s also step in the (right) direction of blurring the lines between the game’s two segregated platforms (DD and non-DD). Despite being a mostly Franchise and strictly non-DD player, I’ve never supported the idea of a stadium creator in MLB The Show, or for that matter, the idea of rebranding/relocating a Franchise. I’ve always considered it a lot of effort for not a lot of gain. Personally I would prefer that Franchise resources be allocated to adding depth to some of the content already there to improve the immersion in what’s going on around the league.  However, now that franchise mode has rebranding v1 in The Show 20, my prediction is that rebranding v2 in The Show 21 will see the birth
Read more

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