I'm currently having problems with a gaming ladder script and specifically the register/validate part.
A player will register and will have to validate via a code sent in e-mail. The username etc. are stored in the table 'validate'. Once validated the username etc. should be transferred to the 'users' table but this doesn't happen.
The data is deleted from the 'validate' table but doesn't appear in 'users'
The code can be seen at: