#43 Deleted Users Time

[ivan_nz]

when a user is deleted their time is not shown on
reports this causes a problem with tracking historical
data. the data is still in the database? seems that the
error lies in the report pages. Does anyone have any
ideas on how to approach this? I would be happy to pay
for this mod.

[ivan_nz]

Logged In: YES
user_id=1330385

I have found a workaround that seems ok

when you delete a user it moves all their time into a user that
I have added to the database called 'pastemployee'

So first you must add this user to the users

and then add this line to to user_action.php

if ($action == "delete") {

dbquery("delete from $USER_TABLE where

uid='$uid'");
dbquery("delete from $ASSIGNMENTS_TABLE
where username='$username'");
dbquery("delete from
$TASK_ASSIGNMENTS_TABLE where
username='$username'");
//mod by ivan_nz 07-11-05
dbQuery("UPDATE $TIMES_TABLE SET
uid='pastemployee' WHERE uid='$username'");

[Nobody/Anonymous]

Logged In: NO

I leave all users in the datbase, they just become inactive.
A task was assigned to them in the past, so they can stay.

[Nobody/Anonymous]

Logged In: NO

I leave all users in the datbase, they just become inactive.
A task was assigned to them in the past, so they can stay.