Total overhaul of the medal updates. No longer requires 1 select per medal, now it all happens at once and we just do 1 update or insert per medal. Works wonderfully. Cleaned up the code a little bit too and added some comments. Also added a method for checking if a user has played halo 3 since the last time they updated in preparation for nightly updates of the gamertags. ALSO (yes, I know I should have done this all in more than 1 commit) switched the front_page and career local variables to instance variables so that I still only need to fetch the pages once.
Total overhaul of the medal updates. No longer requires 1 select per medal, now it all happens at once and we just do 1 update or insert per medal. Works wonderfully. Cleaned up the code a little bit too and added some comments. Also added a method for checking if a user has played halo 3 since the last time they updated in preparation for nightly updates of the gamertags. ALSO (yes, I know I should have done this all in more than 1 commit) switched the front_page and career local variables to instance variables so that I still only need to fetch the pages once.

swemoney/rhalo3stats