Page 1 of 1
Delete all User and File names at once
Posted: 13 Jul 2017, 13:35
by 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
Re: Delete all User and File names at once
Posted: 13 Jul 2017, 23:13
by 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
Re: Delete all User and File names at once
Posted: 14 Jul 2017, 12:08
by 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
Re: Delete all User and File names at once
Posted: 18 Jul 2017, 19:20
by 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
Re: Delete all User and File names at once
Posted: 19 Jul 2017, 17:13
by 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
Re: Delete all User and File names at once
Posted: 20 Jul 2017, 12:45
by 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
Re: Delete all User and File names at once
Posted: 25 Jul 2017, 11:38
by 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
Re: Delete all User and File names at once
Posted: 25 Jul 2017, 13:32
by 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
Re: Delete all User and File names at once
Posted: 25 Jul 2017, 16:21
by Milian
Thanks Jan,
I needed the bulk query.
Regards, Milian