Unfortunately I didn't have the console screen up when it started messing up, no idea how that happened either. It's printing ads correctly now since I changed maps, and I even added a new ad then did sm_reloadads and it shows the new one just fine. The only console messages I can give you, other then the adverts themselves is:
L 03/06/2011 - 09:04:11: [adsql.smx] [AdsQL] - Using Server ID 'bob' for ads search
L 03/06/2011 - 09:04:11: [adsql.smx] [AdsQL] - SetupAds: We seem to already have an Ads Display Timer
L 03/06/2011 - 09:04:11: [adsql.smx] [AdsQL] - SetupAds: Replaced existing Ad Display Timer
L 03/06/2011 - 09:04:11: [adsql.smx] [AdsQL] - SetupAds finishing, resetting bAdsBeingSetupAlready
Prints that every time a new map is loaded or sm_reloadads is issued. No idea if those messages are normal or helps at all hah. I've been up all night messing with this so I need some sleep. I have to carry out this install on 7 other servers so I might be back here with more questions or info, hopefully it all goes smoothly though. Thanks again for all the help!