TopCoder Support Tool Module Assembly 1

            - add the textbox for "username" and the button for "Remove Copilot". This should simply remove the copilot 

 

2. Create Topcoder Admin

-create a page with a heading of “Create Admin” and and a description of “This function is to make an internal employee an Admin”   

-add textbox for  “username” and a button called “Create Admin”

-the username can be used to retrieve the “User Id” needed below.

-if successful, show a green message “Admin has been added”

-if unsuccessful, show a RED message  “Error, no action completed” - Bubble up the error/exception to the screen

-Add duplicate validation if possible unless the database restricts and will throw an exception if the person already exists.

--INSTRUCTIONS TO KNIGHT A USER:

-- 1. Get the user_id of the user:

select user_id from common_oltp:user where handle = 'HANDLE'

 

-- 2. Get the USER_GROUP_ID for step 3

select max(user_group_id)+1 from user_group_xref

where user_group_id < 400

 

-- 3. Using the values from steps 1 and 2 replace them where appropriate in this query

insert into common_oltp:user_group_xref values (USER_GROUP_ID, CODER_ID, 2000115, 150148, 1,current);

update informixoltp:rating set rating =-1 where coder_id = CODER_ID;

 

-- 4. Get the resource_id to use in the next two queries

select max(resource_id)+1

from tcs_catalog:resource where resource_id <5000

 

-- 5. Using the value from step 4, replace RESOURCE_ID

INSERT INTO tcs_catalog:resource (resource_id, resource_role_id, user_id, create_user, create_date, modify_user, modify_date)

VALUES(RESOURCE_ID,13,CODER_ID,'YOUR_USER_ID',current,'YOUR_USER_ID', current);  

 

INSERT INTO tcs_catalog:resource_info (resource_id, resource_info_type_id, value, create_user, create_date, modify_user, modify_date)

VALUES(RESOURCE_ID,1,CODER_ID,'YOUR_USER_ID',current,'YOUR_USER_ID', current);

 

-- 6. Need to add Cockpit admin role add user to user_role_xref (role id 2087)

                      insert into user_role_xref  values (<min(user_role_id) - 1>, <user_id>, 2087, <operator_user_id>, 1)

                  Note that we use the negative value for manually inserted user_role_id here.

 

3. Add member to review board

-create a page with heading of Add Review Board Member”, with a description “This function is to add a member to the review board

-add a text box for “username” and drop down for CategoryID with button “Add Reviewer”

-The username will be used to retrieve the “User Id”

-category comes from select * from project_category_lu and presented to user as a dropdown with project category name.

-If successful, show a green message “Reviewer has been added”

-if unsuccessful, show a RED message “Error, no action completed” - Bubble up the error/exception to the screen

-Add duplicate validation if possible unless the database restricts and will throw an exception if the person already exists.

           STEPS:

//get user_id by username

select user_id from common_oltp:user where handle = 'HANDLE'

To actually add member to the review pool, run this in tcs_catalog DB (replace <user_id> with actual user ID, <project_category_id> with the actual category ID and <immunity_ind> is 1 for Studio and Code/F2F and 0 otherwise ):

INSERT INTO rboard_user VALUES (<user_id>, <project_category_id>, 4, 100, <immunity_ind>);

If you do not know the project category ID, you can look it up in project_category_lu table.

Example video: http://screencast.com/t/nzEXh8GGRC

Security

The authentication should be basic authentication with username / password - the same as the AdminLogin in direct-app. Only the user with role "TC Staff" can access this app. All the tasks should be protected with this logic.

Transaction (Important)

All the single task mentioned above should be done in one transaction. This is very important.