Registration/Activation Process

[consolegaming]

It's not exactly the easiest of scripts to follow lol. I'll give it a go though, had hoped someone would just know which tables have rows inserted to them though lol.

EDIT:
So far I've found:

user has a row inserted, usergroupid is the unactivated group in my case 3, pass is encrypted as to be expected,

useractivation seems to have a row inserted - though I'm not sure what is done with this table - does the row get removed once the user is activated? does usergroupid store the user group the user is to become once activated? and what is activation id? is that the activation code that gets emailed out or? if so how is that generated as the lengths seem to be various lengths. If it's not the activation code where is it stored.

It looks like userfield and usertextfield also get tables before activation takes place. Do any values in these fields get altered after activation too? I doubt it but thought i'd ask.

EDIT2:

Is there a way through plugin/s to make it avoid the closed forum check/suspended user check for certain urls i.e. anything non forum or would I need to manually alter the php files? and if so would that cause any issues for upgrading the forum in future.