Search found 360 matches

by onoehring
2019-12-08 14:57
Forum: Bugs/annoyances
Topic: bugs unauthorized users access pdf files knowing the link
Replies: 12
Views: 2505

Re: bugs unauthorized users access pdf files knowing the link

Hi, just moving a site to 1and1 ... and the htaccess from above does not work there (at least in my case). I needed to make an adjustment - so this is the .htaccess which works (for me) at 1and1 as well: RewriteEngine on #If you have changes your uploads directory, change next line accoring RewriteB...
by onoehring
2019-12-05 09:14
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 104

Re: How do I: Filter, based on 2nd table?

Hi Jan, marvelous! I very much like the idea of prepending the session variable with the tablename. My solution works for now ... but shows my hint that the data has been prefiltered also in other parts of the application. I will probably use your suggestion to improve my solution. Thank you very mu...
by onoehring
2019-12-05 07:54
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 104

Re: How do I: Filter, based on 2nd table?

Hi Jan, well, my QueryWhere works .. initially. I added a test for $_GET in the URL to the INI and according to that value I set my QueryWhere. The problem occurs, when I want to flip through pages or sort: Then, of course, the $_GET parameters are not available anymore and my QueryWhere is lost. Ho...
by onoehring
2019-12-05 06:33
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 104

Re: How do I: Filter, based on 2nd table?

Hi Jan,
yes, there is the QueryWhere option, but it's not documented in the page itself. One can find it when running the code (in _init) I added to my former posting.

Olaf
by onoehring
2019-12-05 06:26
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 104

Re: How do I: Filter, based on 2nd table?

Hi Jan, thanks for the links, I was looking at the pdf docs only. But even at the first link the $options->QueryWhere property is missing. Bute the code on the bottom of the page helped: ob_start(); $xc=get_object_vars($options); ksort($xc); print_r($xc); $c=ob_get_clean(); echo "<pre>".htmlspecialc...
by onoehring
2019-12-04 16:39
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 104

Re: How do I: Filter, based on 2nd table?

Hi Jan,

thanks, sorry for being annoying.
I found a solution which should work (will try later):

Code: Select all

WHERE
     mytable.PK IN
(Select .... HERE THE QUERY THAT SELECTS ALL PKs THAT I NEED
Olaf
by onoehring
2019-12-04 16:05
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 104

Re: How do I: Filter, based on 2nd table?

Hi,

I do not find any documentation for this. So I am asking: Can I use a new SQL statement there or only a WHERE clause?
As I need some JOINS in my SQL before the WHERE I am wondering.

Olaf
by onoehring
2019-12-04 14:26
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 104

Re: How do I: Filter, based on 2nd table?

Hi Jan,
I hoped for a quick an easy answer. No, I did not see this option .. I looked in the documentation and there this was not listed and in -ini I must have overlooked it.

Thank you very much.

Olaf
by onoehring
2019-12-04 13:07
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 104

How do I: Filter, based on 2nd table?

Hi I am writing some custom code to open the table view von table C but only show filtered items. But how do I tell AG which filter to use? The database is set up like this: C has a field that is lookup from table L which has a field that is lookup from table O. I need to create a filter which shows...
by onoehring
2019-12-04 12:56
Forum: Getting Started
Topic: BLOB datatype
Replies: 6
Views: 77

Re: BLOB datatype

Hi mekin,

did you test: Download an image that you have uploaded to AG - does your tool work? Maybe it's only a different label.
BTW: I would recommend NOT to save images to the database.
Olaf
by onoehring
2019-12-03 06:23
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Setting the title dynamically in detail view
Replies: 2
Views: 75

Re: Setting the title dynamically in detail view

Hi pilandros,

probably Jan will answer this much better than I can: You could create an ajax call to some php file which returns your content only...

Olaf
by onoehring
2019-12-02 17:04
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 29
Views: 2290

Re: AppGini Helper JavaScript Library

Hi pilandros,

maybe I can help: Simply click on the download link in your order email again. You will receive the latest version (at least this works for me).

Olaf
by onoehring
2019-12-01 08:22
Forum: Getting Started
Topic: Non-Admins approving users
Replies: 2
Views: 115

Re: Non-Admins approving users

Hi bdurfee, this should work: Create a new table in your AG project named membership_users (like the internal table name where users are found). In this table have 2 fields (or more from the membership_users if you like, but hide them, see below): memberID (varchar 100) and isApproved (tinyint (4) N...
by onoehring
2019-11-30 17:11
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Releases
Replies: 6
Views: 168

Re: Releases

Hi Jan, Hi G Belgrado,

same here: Download was the same as the previous version.
Olaf
by onoehring
2019-11-30 09:32
Forum: Tips And Tricks
Topic: Backup your database (easy)
Replies: 0
Views: 92

Backup your database (easy)

Hi, I had the urge to backup the database as there are many, many changes in one day and it would be catastrophic to loose even one day. After searching the net I found a nice, easy to implement script to backup a database: Open the script in a browser and the database will be backed up. The backup ...
by onoehring
2019-11-29 08:05
Forum: Getting Started
Topic: How to? Not focus first field in details view?
Replies: 4
Views: 84

Re: How to? Not focus first field in details view?

Hi Ja,

as always: Perfect solution.
In my case your one-liner was enough, as I just needed to remove the focus.

Thank you very much
Olaf
by onoehring
2019-11-29 05:33
Forum: Getting Started
Topic: How to? Not focus first field in details view?
Replies: 4
Views: 84

Re: How to? Not focus first field in details view?

Hi Jan, I tried this code in the beginning of hooks/tablename-dv.js $j(function() { document.querySelector("#deselect").focus(); }); (Same with your line of code) Unfortunately AG seems to jump back to the field. Notice in the image, that first the back button (zurück) is focused, but then the focus...
by onoehring
2019-11-28 17:12
Forum: Getting Started
Topic: How to? Not focus first field in details view?
Replies: 4
Views: 84

How to? Not focus first field in details view?

Hi,

how can I prevent AG from putting the focus on the first field in the details table view?
There must be a very simple way - which I have not found yet ;-)

Thanks already
Olaf
by onoehring
2019-11-27 16:10
Forum: Getting Started
Topic: Alternative to 'connect by prior'
Replies: 1
Views: 289

Re: Alternative to 'connect by prior'

Hi Chhavi,

maybe this is of some help:
https://code-examples.net/en/q/2eedc

Olaf
by onoehring
2019-11-27 15:09
Forum: Advanced Customizations > Others
Topic: Language file
Replies: 3
Views: 110

Re: Language file

Hi,

why not simply add your line to it?
(Code not tested)
Somewhere in your code add

Code: Select all

$Translation['Hello User'].= '\nThis is your new line';
Notice the .= which should add to the current string the new text.
\n should create a new line

Olaf
by onoehring
2019-11-26 17:57
Forum: Bugs/annoyances
Topic: Missing hooks/links-nav title
Replies: 6
Views: 155

Re: Missing hooks/links-nav title

Hi Ron,

thanks for trying and reporting.
Olaf
by onoehring
2019-11-26 04:11
Forum: Bugs/annoyances
Topic: Missing hooks/links-nav title
Replies: 6
Views: 155

Re: Missing hooks/links-nav title

Hi Ron, sounds good. I will try that, but i still think it's a workaround. Does on really need fields in the simply AG table which is used to create the navigation link, or did you try to create a table only without any fields? I agree that the line between AG tables and added links-files in the men...
by onoehring
2019-11-24 13:10
Forum: Bugs/annoyances
Topic: Missing hooks/links-nav title
Replies: 6
Views: 155

Re: Missing hooks/links-nav title

Hi Ron,

I believe no, as the array ends there... checking ... no, No difference.
php: The comma would not need to be after the last "entry" before the closesing ) - the array ends there, so no comma needed.

Olaf
by onoehring
2019-11-24 10:40
Forum: Bugs/annoyances
Topic: Missing hooks/links-nav title
Replies: 6
Views: 155

Missing hooks/links-nav title

Hi, AG 5.81. I notice, that when I add a new item to a menu in hooks/links-navmenu.php like this $navLinks[] = array( 'url' => 'hooks/setup_googleauth.php', 'title' => 'Google Authenticator', 'icon' => '/resources/table_icons/googleauthenticator.png', 'groups' => array('*'), 'table_group' => 1 ); bu...
by onoehring
2019-11-21 04:15
Forum: Bugs/annoyances
Topic: Uploaded files are not saved from deletion and not unique
Replies: 4
Views: 121

Re: Uploaded files are not saved from deletion and not unique

Hi Jan,

thanks for the hint to PHP's $_FILES array. This will make things probably a lot easier (than I tried to to until now ;-) )

Olaf