Delete all User and File names at once

[Milian]

I see no button in Phoca Download to delete all the user downloads.
Only a Reset Button (count=0). I want to delete all the Users and Fil names on a regular basis.
For cleaning up the database and outdated downloads.
Can you realise this in a next update and/or do you have a work-around?
Thans, Regards, Milian

[Jan]

Hi, what exactly do you want to delete. For example, users are Joomla! users and you can manage them in Joomla! user manager. If you want to clean all the data in database, the best way is to use phpMyAdmin

Jan

[Milian]

Hi Jan,
Components->Phoca Download->Downloads
Here you see al ist of All the downloads with a counter.
On this location you can only reset the Counter per User.
I want to delete/clear only this list.

Hope this is a more specific explanation.
I cannot upload a screendump here.
If needed let me know how I can send it to you.
Regards, Milian

[Milian]

Hi Jan,
Will you please answer me?
Summary: I cannot delete the stats in Phoca download. Only reset the counts.
I want to delete all names to get a fresh download season.
Regards, Milian

[Jan]

Hi,

I cannot upload a screendump here

see forum rules, you can paste the screenshot here per external service like imgur is



Not sure what you mean with the names, names are users which are managed in Joomla! user manager, so names can be removed only in Joomla! user manager

Jan

[Milian]

Hi,
This picture explanes my question:
img tags was not accepted so therfore See:
(removed)
I want to delete all the content (see the red arrows) of the Statistics.
Title. FIlename Downloads (set to zerro)
Regards, Milian

[Milian]

Hi Jan,
Did you see the screendump?
I wana get rid of the Titles and FIlenames.
So I got a fresh download stats.
This is at the moment not possible.
Do you have a work-around (SQL query) or place it in an update?
Regards, Milian

[Jan]

Hi, this is statistics for all files.

1) To change it for each file:
Files - edit a file - Publishing Optiosn - set Download to 0

2) to change it in bulk:
e.g. phpMyAdmin - SQL:

Code: Select all

UPDATE jos_phocadownload SET hits = '0';

Change the jos_ to your database prefix, be aware, this query deletes all hits (downloads) of all files.

Jan

[Milian]

Thanks Jan,
I needed the bulk query.
Regards, Milian