He's not editing any of the scripts. <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />

Assuming you're running 6.4.

[]

Table---------------Columns
w3t_Last--------------L_Uid [:"red"]Correct[/]
w3t_Messages-----M_Uid, M_sender [:"red"]Correct[/]
w3t_Moderators----M_Uid [:"red"]Correct[/]
w3t_Posts------------B_PosterId, B_LastPosterId [:"red"]Correct[/]

I'm unsure about these...

Table---------------Columns
w3t_Online----------O_Uid [:"red"]The online table is temp data so no worries here[/]
w3t_Ratings---------R_What [:"red"]Yes R_What holds a user number IF R_Type = u. If R_Type = t then it's a thread rating as opposed to a user rating.[/]
w3t_Subscribe------S_Uid [:"red"]Correct[/]
[/]

Additional tables

w3t_AddressBook --- Add_Owner,Add_Member
w3t_Banned ---- B_Uid
w3t_Boards --- Bo_Posterid (the last poster usernumber in each forum)
w3t_Calendar --- C_Owner
w3t_DisplayNames (if there's no display name changes in the queue, don't worry about this table)
w3t_Favorites --- F_Owner
w3t_Moderators --- Mod_Uid
w3t_PollVotes --- P_Voter

Also the U_Ignored field in the w3t_Users table will contain a list of any user numbers that particular user is ignoring.

I *think* that covers it. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com