Changing a user login

From WebCalendar Wiki

[edit] Changing a User's Login

Many of the database tables use the login name as a key, so it's not a simple task to change a user login. I have not tested this script yet, so there is no guarantee that this will work :-)

[edit] WebCalendar 1.0.X

Perform the following SQL commands from your db command line (phpMyAdmin, mysql, sqlplus, etc.), substituting the values of "oldname" and "newname" with your values:

UPDATE webcal_asst SET cal_assistant = 'newname' WHERE cal_assistant = 'oldname';
UPDATE webcal_asst SET cal_boss = 'newname' WHERE cal_boss = 'oldname';
UPDATE webcal_categories SET cat_owner = 'newname' WHERE cat_owner = 'oldname';
UPDATE webcal_entry_log SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_entry_log SET cal_user_cal = 'newname' WHERE cal_user_cal = 'oldname';
UPDATE webcal_entry_user SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_group SET cal_owner = 'newname' WHERE cal_owner = 'oldname';
UPDATE webcal_group_user SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_import SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_import_data SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_nonuser_cals SET cal_admin = 'newname' WHERE cal_admin = 'oldname';
UPDATE webcal_nonuser_cals SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_report SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_report SET cal_user = 'newname' WHERE cal_user = 'oldname';
UPDATE webcal_user SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_user_layers SET cal_layeruser = 'newname' WHERE cal_layeruser = 'oldname';
UPDATE webcal_user_layers SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_user_pref SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_user_template SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_view SET cal_owner = 'newname' WHERE cal_owner = 'oldname';
UPDATE webcal_view_user SET cal_login = 'newname' WHERE cal_login = 'oldname';

[edit] WebCalendar 1.1.X/1.2.X

If you have WebCalendar 1.1.X, you should also do the following commands:

UPDATE webcal_access_function SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_access_user SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_access_user SET cal_other_user = 'newname' WHERE cal_other_user = 'oldname';
UPDATE webcal_blob SET cal_login = 'newname' WHERE cal_login = 'oldname';
UPDATE webcal_entry_categories SET cat_owner = 'newname' WHERE cat_owner = 'oldname';