User information left in "spy" activity after removal

if i delete a user from my site or uninstall a module that was being use, the activity still remains in the "spy" section.

 

How can i move it?

Geminixx Lives!
Quote · 31 Oct 2011

Hello :

I solved the same problem :

Edit inc/admin.inc.php aprox in line 400 is defined the function profile_delete. There is a block to delete some user informacion :

    db_res( "DELETE FROM `sys_admin_ban_list` WHERE `ProfID`='". $ID . "' LIMIT 1");
    db_res( "DELETE FROM `sys_greetings` WHERE `ID` = '{$ID}' OR `Profile` = '{$ID}'" );
    db_res( "DELETE FROM `sys_block_list` WHERE `ID` = '{$ID}' OR `Profile` = '{$ID}'" );
    db_res( "DELETE FROM `sys_messages` WHERE Recipient = {$ID} " );
    db_res( "DELETE FROM `sys_fave_list` WHERE ID = {$ID} OR Profile = {$ID}" );
    db_res( "DELETE FROM `sys_friend_list` WHERE ID = {$ID} OR Profile = {$ID}" );
    db_res( "DELETE FROM `sys_acl_levels_members` WHERE `IDMember` = {$ID}" );
    db_res( "DELETE FROM `sys_tags` WHERE `ObjID` = {$ID} AND `Type` = 'profile'" );

add this :

    db_res( "DELETE FROM `bx_spy_data` WHERE sender_id = {$ID} " );

And all the activity of users in spy is deleted with the user.

Quote · 11 Nov 2011

I added the line, cleared all cache and its still there...

Any idea?

Sometimes communicating your problem and putting it out there is enough to solve it
Quote · 11 Jun 2012

 

I added the line, cleared all cache and its still there...

Any idea?

That is designed to delete spy data for a user when the user is deleted. However it does not clean out data for users that were already deleted. Only future user deletes.

Data for users that have already been deleted will have to be removed by hand.


https://www.deanbassett.com
Quote · 11 Jun 2012

 Thanks for clarifying this Dean.

 

 

I added the line, cleared all cache and its still there...

Any idea?

That is designed to delete spy data for a user when the user is deleted. However it does not clean out data for users that were already deleted. Only future user deletes.

Data for users that have already been deleted will have to be removed by hand.


 

Sometimes communicating your problem and putting it out there is enough to solve it
Quote · 11 Jun 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.