Handle cases when it get's invalid

[raj454raj]

trafficstars

At present the retrieval script marks handles invalid but they don't delete the submissions from the submission table for the previously valid handle.

[Sayak9495]

Hi @raj454raj , can you explain the problem little more? (my understanding is - if a user first gives a valid handle, all his submissions get recorded under table submission. Afterward, he changes it to some other handle then the previous submissions under that handle name needs to be deleted from 'submission' table).

[raj454raj]

So for example: https://www.stopstalk.com/user/profile/tanujkhattar The current codeforces handle of the user is tanujkhattar. Now this handle is invalid because the user has changed it to Baba and hence we made an entry in invalid_handle table for tanujkhattar. At this point in submission retrieval, we also need to delete the codeforces submissions with previously valid handle.