Changing user status in the system

[ramon]

Dear fellolws,

We have a problem when registering users as Reviewers, then trying to change their status to Board Members (we´ve only tried Editorial Board Members so far)...

What happens in our journal is that the board members are not permanent, and many times reviewers become board members, and after some time, they leave that post, for many reasons.

The problem is that once a reviewer is registered, we cannot use the same user as a Board Member...

We know Board Members are reviewers, but how do we change their status to not being a member and back again, if we need to?

thanks

[kevin]

If you find you use this often, you may wish to implement some functionality for making reviewers into board members, and vice versa.

To change a board member into a regular reviewer:

Code: Select all

UPDATE tblreviewers SET chReBoard = NULL where nReviewerID = '$reviewer_id'

To change a reviewer into a review board member:

Code: Select all

UPDATE tblreviewers SET chReBoard = 1 where nReviewerID = '$reviewer_id'

To change a reviewer into an editorial board member:

Code: Select all

UPDATE tblreviewers SET chReBoard = 0 where nReviewerID = '$reviewer_id'

[ramon]

Dear fellows,

I have the following problem (and others like this) in my database: a few users were registered many times, instead of changing the current registered user (same real life person, but with different entries for author, reviewer, etc).. here´s an example:

Code: Select all

nUserID | chUsername | fkAuthorID | fkEditorID | fkReviewerID | fkCopyEdID | fkProofID | fkReaderID | chFirstName | chSurname |
  12    | alvarenga  |    NULL    |     NULL   |     NULL     |     NULL   |    NULL   |    NULL    |    Lidia    | Alvarenga |
  66    | alvarenga1 |    NULL    |     NULL   |      29      |     NULL   |    NULL   |    NULL    |    Lídia    | Alvarenga |
  119   | alvarenga2 |    NULL    |     NULL   |      47      |     NULL   |    NULL   |    NULL    |    Lídia    | Alvarenga |
  167   | alvarenga3 |     82     |     NULL   |     NULL     |     NULL   |    NULL   |    NULL    |    lidia    | alvarenga |


Can I change all the entries in all the tables of the db, so that I would end up with just one user (say change all 29 for 47, and then add it to the one with the fkAuthorID=82)?? will there be any problems??

the only problematic entry is fkReviewerID=47, for it has done reviews.
fkReviewerID=29 has not reviewed anything, even though it did get schedule to it..

then i could delete the repeating entries....and maybe change the username ??

this issue happens with a few other users....

thanks to all

[kevin]

That could probably work, assuming you update any other tables referencing entries you delete.