Search found 578 matches

by onoehring
2020-10-28 16:29
Forum: Getting Started
Topic: how to apply security fixes without updating to 5.90
Replies: 4
Views: 91

Re: how to apply security fixes without updating to 5.90

Hi, well, if you have 5.9, just give it my suggestion a try. You could MD5 all files, TotalCommander (ghisler.com) also offers a very simple way to compare multiple files. Concerning code adjustments I am skeptical myself about upgrading an existing generated application as I am using several adjust...
by onoehring
2020-10-28 11:45
Forum: Getting Started
Topic: how to apply security fixes without updating to 5.90
Replies: 4
Views: 91

Re: how to apply security fixes without updating to 5.90

Hi D Oliveira, I would think you could generate your app once with 5.8x and again with 5.9 and compare files. You would still need 5.9 once and - I am not so sure, but the generated code from AG with the files do have some copyright. If you buy 5.9 you are granted the license to distribute the files...
by onoehring
2020-10-23 08:51
Forum: Getting Started
Topic: Send to a specific link ie:Youtube video.
Replies: 2
Views: 138

Re: Send to a specific link ie:Youtube video.

Hi, you should be able to place a JS created link to some new/extra text/button. You could also try to make use of the help buttons in AG which are displayed as question marks. Maybe you can place a simple HTML link in those, so when the users clicks on the question mark to fold out the help, there ...
by onoehring
2020-10-23 08:44
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Script Info in Console
Replies: 2
Views: 61

Re: Script Info in Console

Hi Kai,

just my 2 cts:
Well, almost every tool leaves it's traces. As AG Helper is a JS tool (frontend), I would assume, that exposing the App Gini framework itself, which has it's own very specific files and folders, will be much more like to be an attack vector.

Olaf
by onoehring
2020-10-20 08:35
Forum: AppGini Plugins
Topic: Color Coding Calender Items
Replies: 1
Views: 37

Re: Color Coding Calender Items

Hi, as far as I know there is currently no easy way to add a color chooser. I did something similar however - I implemented a lookup field which holds the colors. How I did it: Create a table for the colors. Fields: ID, Colorname, Hexcode, Colordisplay, Color_sortorder. ID: PK autoincrement Colornam...
by onoehring
2020-10-08 16:23
Forum: Getting Started
Topic: combining data from more than one table
Replies: 14
Views: 325

Re: combining data from more than one table

Hi, I think you should try to create a view (let's say we name it v_all_my_tables) in your database which collects all data that you want to display. Once that is finished, go to AG and create a "pseudo" table that has the same name as the view: v_all_my_tables. Generate your app and AG will generat...
by onoehring
2020-10-07 10:15
Forum: Tips And Tricks
Topic: Added Page on Very Slow
Replies: 8
Views: 198

Re: Added Page on Very Slow

Hi, for me the code looks pretty much ok. Are there some things blocked in your browser (extensions that do that)? Are you using some external scripts to render your graphics? This might be the bottleneck as well - but if you mean, your graphics render fine without the code you present here I would ...
by onoehring
2020-10-07 10:11
Forum: Advanced Customizations > Others
Topic: Logoff in all users
Replies: 3
Views: 189

Re: Logoff in all users

Hi,

just an idea: Why do you clean the database? You could let users change their appointment. The only thing you would need to make sure is, that each user has only exactly one appointment (entry in the database). And of course each user should be able to change his own records only ;-)

Olaf
by onoehring
2020-09-29 14:47
Forum: Advanced Customizations > Others
Topic: How to realize a dual lookup?
Replies: 1
Views: 878

Re: How to realize a dual lookup?

Hi,
I do not understand what you mean. Should one be able to input project and activity into the logging table?

Olaf
by onoehring
2020-09-28 15:48
Forum: Tips And Tricks
Topic: Create a Copy of Current Record after Editing to another Table (children records) (change log)
Replies: 2
Views: 108

Re: Create a Copy of Current Record after Editing to another Table (children records) (change log)

Hi, just a quick answer. I did something similar using the Audit Log (see my footer). The audit log keeps track of all changes in table A - done. If you want to see that history, I suggest: 1. create a view in your database which reads the audit log for table a (you can skip this, if you only use au...
by onoehring
2020-09-26 14:07
Forum: Advanced Customizations > Others
Topic: Multilingual apps
Replies: 5
Views: 1240

Re: Multilingual apps

Hi, afaik, there is no simple solution to this at this time. Maybe you can follow this quick and very dirty blueprint.Single sentence: Make use of the /hooks/tablename.php -> _init function to manipulate page output. I try to do it more detailed but it's not thought through (just as a warning). A qu...
by onoehring
2020-09-26 06:51
Forum: Getting Started
Topic: Custom Primary Keys
Replies: 10
Views: 1321

Re: Custom Primary Keys

Hi,

if the PK for AG comes from another application, you could still use an autoincrement field. Just set an index (unique, can be done right in field definitions in AG) to the field which holds your code.

Olaf
by onoehring
2020-09-22 17:18
Forum: Getting Started
Topic: How to Archive Deleted Records?
Replies: 8
Views: 1057

Re: How to Archive Deleted Records?

Hi, good idea Jan. I want to add, that columns "deleted_on" and "deleted_by" are enough. You do not need an extra column "is_deleted". This would be redundant: A record is deleted, if it holds values in the "deleted_on" and "deleted_by" columns. A quick reminder: Be sure, you follow privacy rules. Y...
by onoehring
2020-09-22 16:23
Forum: Getting Started
Topic: Custom Primary Keys
Replies: 10
Views: 1321

Re: Custom Primary Keys

Hi, had to add my two cents. I totally agree with the above and strongly recommend using a purely automatic (autoincrement) primary key which has absolutely no other meaning than identifying a record on database level. If you want to have some identifier as you describe, I recommend - following Jan ...
by onoehring
2020-09-22 16:16
Forum: Getting Started
Topic: How to Archive Deleted Records?
Replies: 8
Views: 1057

Re: How to Archive Deleted Records?

Hi Mohamed, this should actually be quite easy. As pbötcher said - just intercept the delete using the hooks. ag_root/hooks/tablename.php function ...before_delete Before the delete will be executed this function will be run. You can simply copy the current record (which ID you get in the variable $...
by onoehring
2020-09-17 05:20
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Latest Release
Replies: 15
Views: 1243

Re: Latest Release

Hi SkyHH, interesting explanation. I would suggest a different point of view. First , Jan is obfuscating his code - ok, but Ahmed does not have an Open Source AppGini. Open Source does not mean free - so there is a similarity. Second , Ahmed (with App Gini) is providing a tool for one to create some...
by onoehring
2020-09-13 08:57
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Latest Release
Replies: 15
Views: 1243

Re: Latest Release

Hi SkayyHH, well, to use AGHelper the console is not necessary for one as a developer, nor for the end user. For you as developer the console provides valuable hints with possible error etc. Thus it's a great source of information. If one does not want to use that, that's certainly ok, but will make...
by onoehring
2020-08-12 08:59
Forum: Tips And Tricks
Topic: Field Permissions (hide / lock fields by usergroup)
Replies: 51
Views: 22778

Re: Field Permissions (hide / lock fields by usergroup)

Hi, I had a question like this: i want to build a system that, would require some fields to be locked only for existing records. When it is required to add a new record i would want to be unlocked the fields. Actually it should work as permissions (if you followed the docs) are checked in the _befor...
by onoehring
2020-08-12 07:25
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Fields in line in multi column layout
Replies: 4
Views: 203

Re: Fields in line in multi column layout

Hi Kai,

it seems that your images are missing in this post.
Olaf
by onoehring
2020-08-11 13:11
Forum: Getting Started
Topic: How to edit a record?
Replies: 2
Views: 199

Re: How to edit a record?

Hi

I suppose the field is not defined as readonly in AG, so:
did you set permissions for that user group? Is the user member of a group that is actually able to edit the record?
Go to admin-area in the generated application -> groups -> edit. Should look like this:
Zwischenablage01.jpg
Zwischenablage01.jpg (50.49 KiB) Viewed 197 times
Olaf
by onoehring
2020-08-11 13:05
Forum: Tips And Tricks
Topic: Field Permissions (hide / lock fields by usergroup)
Replies: 51
Views: 22778

Re: Field Permissions (hide / lock fields by usergroup)

Hi, well, I have not heard of ckebell yet. Do you, Ionut, have the same problem? If so, please provide details (description and screenshots - if the might help), I will try to help. Make sure you using the latest version of my AG using the latest version of my extension did all changes as documented...
by onoehring
2020-08-07 06:58
Forum: Tips And Tricks
Topic: Create automatic records with conditions for the user without the validity of the entry
Replies: 3
Views: 2003

Re: Create automatic records with conditions for the user without the validity of the entry

Hi, I think I do not understand the why and how of your request. Why don't you want to use another query? In your original code you actually suggested using a query // To get LAST INSERT ID from inserted record $last_id = sqlValue("select id from deposit_request where id = LAST_INSERT_ID() and creat...
by onoehring
2020-08-06 15:30
Forum: Tips And Tricks
Topic: Create automatic records with conditions for the user without the validity of the entry
Replies: 3
Views: 2003

Re: Create automatic records with conditions for the user without the validity of the entry

Hi, please use the [ code ] ... [ /code ] to display your code. This would make your post(s) much easier to read. I am not sure, If I understand your (very hidden ;-) ) question but as it says The LAST_INSERT_ID() function returns the first automatically generated integer ( BIGINT UNSIGNED) successf...
by onoehring
2020-08-06 15:16
Forum: Tips And Tricks
Topic: Custom Page problem
Replies: 2
Views: 1061

Re: Custom Page problem

Hi, interesting ... Did you try to change if(!$mi['username'] || $mi['username'] == 'guest'){ for testing? Maybe accept only a specific usergroup to access that page? Did you try to place the page directly into your hooks folder? Maybe this helps: What I did to secure a custom page: I created a tabl...
by onoehring
2020-08-06 15:06
Forum: Advanced Customizations > Hooks
Topic: Block Some Fields
Replies: 2
Views: 468

Re: Block Some Fields

Hi espo,

please see my extension (in my footer) - those might help.
Column-Value-Based-Permissions ( viewtopic.php?f=4&t=3498 ) and
Field Permissions ( viewtopic.php?f=4&t=3308 )

Olaf