Cleanup / bug fixes
Ubbthreads has long had a lot of waste in the display of various pages. The 'user_fields' were duplicated a lot of times unnecessarily, when user.inc.php would grab the field by default.
The admin section was most notorious for this as well.
Additionally, the cryptic 't1' and 't2' designations for user and user_profile tables were used instead of something more meaningful like maybe oh...... u and up ?
This has all been cleaned up and there are now a lot of pages that will run much more efficiently, because we aren't querying multiple columns, multiple times per page load.
Also, the hard wired __LINE__ and __FILE__ variables passed to the queries for error messages are all gone, because php has a function ( debug_backtrace ) that does this already.
Another thing that was done, was to use do_query, instead of do_placeholder_query where obvious. HUGE time saver here!
Bottom line: efficiency, cleanup were added while quite a few bugs were removed..