Screwed up while adding movies to the movies database. Forgot to add (Trailer 2) to the title for Delivery Man. My database gui won't let me edit so I had to write a script to update the database directly. So I don't have to figure out how to do it again later, here it is...
UPDATE `movietrailers` SET `title`='Delivery Man (Trailer 2)' WHERE poster='delivery-man-trailer-2'
The trick is my SQL admin says to wrap the SET title value in brackets but should be apostrophes.
Been learning a lot of Object Oriented Programming the last couple of days. So much to learn, so little time to figure it out. I can see why it is preferred. You can do some pretty sweet stuff with adding and removing nodes and junk.
Finally managed to get the 'Wing And A Prayer' achievement on Left 4 Dead 2. After trying about a dozen times I tried a different method than what the tutorials were saying. Start level 2 'Swamp' on the Swamp Fever campaign on easy and head to the plane. Open the door and then run to the back of the plane and try and jump into the seats in the tail section. The Ai characters should be able to take out all of the zombies. I thought it was interesting that the zombies coming through the door would run straight out the other side instead of trying to come down the aisle. That probably helped. the other characters only had to watch one direction towards the back of the plane.
The new job doesn't have me doing any PHP so I have to get my fix at home. Latest code update will automatically remove the movie posters from the CDN and delete the movie from the database at the end of the month if they have been in theaters for a month. I might want to update that to keep movies for an extra month or two and change the copy to say 'Coming to DVD and Bluray'. Maybe even link to Amazon to purchase. The game achievement stats also download the images to the server so I don't have to ping Steam every time somebody views the page. Not huge breakthroughs like the guys that coded a Minecraft server in PHP but it's a start.
I always thought I would pick up Counter-Strike: Global Offensive if it went down to around $5. Well, it is down to $5.09 on the Steam Summer Sale and I would buy it except I don't know anybody else accept coL_Lake's son plus I haven't had time for much gaming lately. Sorry Counter-Strike: Global Offensive. I will have to pass for now.
I'm starting to figure out how the managers code works. I use to think I knew how to work in the DOM but the new team is really working in the DOM. I should probably remove OOP until I know it a little better but I hope not to have to look for a job again for a long time so maybe if I do have to look again, I will actually be qualified.
The 2013 Steam Summer Sale is going on now destroying wallets everywhere. I managed to survive the first week with only one purchase of The Walking Dead for $6.25 but I was close to purchasing several other games quite a few times over the weekend. I was even trying to get the kids to give me money to buy them games but they were too involved in their Roblox. To take my mind off all the games I could be buying I revised the game stats achievements code on the server to download the images from Valve if they aren't already on the server and display them from the DOH! Network cdn so the site is not always requesting content from Valve. The images coming from the Valve server would probably load faster but it was still interesting figuring out the code to do it.
I survived the first sprint at the new job. The second one ends this week and I really need to get on cleaning up the code I have been writing. I hope o learn a lot at this job but it is kind of intimidating working with all these really smart people. I hear nobody has ever been fired from this company but there is always a first time.
I started up a Minecraft Pocket Edition server for the kids to connect to. Wouldn't you know they finally stopped playing Minecraft?
I hate when I get everything on my wish list because then I have to make a new wish list.