SQL function to chek"Display Inaccessible File" for all file

Phoca Download - download manager
sasamm
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 10 Apr 2010, 01:21

SQL function to chek"Display Inaccessible File" for all file

Post by sasamm »

Hello
excellent component with super abilities..
how to mark "Display Inaccessible File" for all files in archive with one SQL command
to be always visible in the download section?

tnx :|
sasamm
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 10 Apr 2010, 01:21

Re: SQL function to chek"Display Inaccessible File" for all

Post by sasamm »

UPDATE jos_phocadownload SET unaccessible_file=1
8)
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: SQL function to chek"Display Inaccessible File" for all

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
daza
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 03 Jun 2010, 18:59

How can I do that

Post by daza »

How can I do that?In which file???
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9965
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: SQL function to chek"Display Inaccessible File" for all

Post by Benno »

Hi,
jos_phocadownload SET unaccessible_file=1
How can I do that?In which file???
with eg. phpmyadmin in your database. But make a backup before you change anything there!!!
Kind regards,
Benno
akitotenk
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 26 Sep 2011, 20:01

Re: SQL function to chek"Display Inaccessible File" for all

Post by akitotenk »

Sorry i need the same think but i not understand how to make it, i have open myphpadmin with super user go in tab SQL and put jos_phocadownload SET unaccessible_file=1 but send me an error
i have gator host and joomla 1.7.
I need also how to add a license files to all my files when i try to dl, now i can do it but i net to set only 1 files for time. pls help a poor medicine student ^_^
OlegSkr
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 30 Sep 2011, 15:51

Re: SQL function to chek"Display Inaccessible File" for all

Post by OlegSkr »

As far as I can see this option is not evaluated further in the "Phoca Download Plugin" (2.0.1).

It is easy to change the SQL-query in the "/plugins/content/phocadownload/plocadownload.php" to get this option from the database, but I'm not sure how to check against the "access rights" at this point.

@Jan: Are there any updates concerning this issue planned to be released in the near furute?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: SQL function to chek"Display Inaccessible File" for all

Post by Jan »

Hi, which option you mean? There is discussed component not plugin?
If you find Phoca extensions useful, please support the project
OlegSkr
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 30 Sep 2011, 15:51

Re: SQL function to chek"Display Inaccessible File" for all

Post by OlegSkr »

The option I was talking about is located in "Control Panel" of the "Phoca Download" component (if a new file is created or an existing one is edited).

See print-screen below:

Image

Maybe I'm wrong, but as I see in source code, this option is not used further.

But if I do correctly understand the name of this option, a link to the "inaccessible" file should be hidden from not authorized users. Or does "inaccessible" mean that the file was deleted or so?

My problem is, that I would like to have the following behaviour:

I create 4 links in my content, 3 of them are public and the last one should be only seen for authentificated users. As it is implemented now all 4 links are shown but the user cannot download the fourth file without authentification.

Is it somehow possible to completely hide the last link from the content to not autherized users?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: SQL function to chek"Display Inaccessible File" for all

Post by Jan »

Hi, this is the component feature, not a plugin feature, for this the plugin must be customized.

Jan
If you find Phoca extensions useful, please support the project
Post Reply