[horde] Question about removing userdata from horde (mysql)

[Jacques Beaudoin]

Bonjour,

Glad to see that the script is useful.

>> I have used your script for the first time and it worked perfectly.
>> But, the script does not have option to delete horde_history table
>> entries for a user.  Have you updated your script to do that also.
>> Please send me your latest script.
>> Have you updated your script to do that also.

No, never did look at horde.histories but I will now
thanks to Patrick

> That is fairly easy to add to the script. Here are the two sql commands
> you need to add to the appropriate commands in the script:
>
>
> SELECT count(*) from $DB.horde_histories WHERE history_who='$USER'
> DELETE from $DB.horde_histories WHERE history_who='$USER

Merci Patrick, I will take a look.

Nice Vacations to all

Jacques






Jacques-Beaudoin at cspi.qc.ca

Agent d'administration
Les services des technologies
de l'information et des communications
Commission scolaire de la Pointe de l'Île


----- Message de boutilpj at ednet.ns.ca ---------
     Date : Tue, 03 Jul 2007 09:55:24 -0300
      De : Patrick Boutilier <boutilpj at ednet.ns.ca>
Répondre à : Patrick Boutilier <boutilpj at ednet.ns.ca>
  Objet : Re: [horde] Question about removing userdata from horde (mysql)
       À : horde at lists.horde.org


> Anant Athavale wrote:
>> Hello Jacques:
>>
>> I have used your script for the first time and it worked perfectly.
>> But, the script does not have option to delete horde_history table
>> entries for a user.  Have you updated your script to do that also.
>> Please send me your latest script.
>>
>> Regards,
>> anant.
>>
>>
>
> That is fairly easy to add to the script. Here are the two sql commands
> you need to add to the appropriate commands in the script:
>
>
> SELECT count(*) from $DB.horde_histories WHERE history_who='$USER'
>
> DELETE from $DB.horde_histories WHERE history_who='$USER
>
>
> <snip>
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>


----- Fin du message de boutilpj at ednet.ns.ca -----


----------------------------------------------------
Ce message a été acheminé par le Webmail de la CSPI.