ok so I setup this vbulletin 2 years ago and im pretty sure I added ads using the admin cp
however I went to ad management and much to my surprise they weren't there, but they display on my page so they must be somewhere. I set it to default un altered template and they ads are still there. I even checked the header template file just to be sure.
where else can I find the ad code and why isnt it in the proper ad tables in the database im using 4.2.2 im thinking something may have happened when I upgraded from 4.1
Yes. If you revert an ad template, then any ad you inserted into the template would be removed. In your first post, you were just asking where the ads could be stored and so I told you.