I've used phpadsnew for years. I did run into a problem about 6 months ago when my db got corrupted but it wasn't a hard fix. Ditto on trimming your databases unless you really needs months of data.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.