Recently upgraded from UBB Threads 6.2.2 to 7.2.2
We have some scripts that used to pull data from w3t_Posts and w3t_Users under 6.2.2.
Similarly named tables exist in the new database as ubbt_Posts and ubbt_Users, however, all the fields are different.
Sample select statements for 6.2.2 ....
"select B_Subject, B_Last_Post from w3t_Posts where B_Board='gendiscussion' or B_Board='tripreports' group by B_Main order by B_Last_Post DESC limit ".$limit." ,20"
"select count(*) AS online from w3t_Users where U_Laston > ".mktime(date("G")-2,date("i"),date("s"),date("m"),date("d"),date("Y")))

Questions;
Is there any documentation that describes how that old and new database structures compare ?
Anyone want to take a bash at converting the select statements above ?

Any help would be much appreciated.