Correct way to delete classipress ads with plugin
I am looking to make a plugin that will find ads marked as 'sold' or more technically in _postmeta where meta_key = cp_ad_sold and meta_value = yes. I can do the search no problem in MySQL, and use a join to use the post ID to delete related data out of other tables, but my question is, what tables have ad data in them? I want to delete ads "correctly"... I.E. delete their data from every table so there isn't junk data laying around in the tables.
The following tables have ad data in them that I know of: cp_ad_geocodes, _posts, _post_meta. Are there any other tables that contain ad data that should be deleted when removing an ad?
It's terrible having 'sold' ads sitting around on the site with no way to automatically prune them.
Reply With Quote
You must be an AppThemes customer and logged in to view this response.