AppGini Community Forums

Additional Information: If you've set up a field as a 'Timestamp' with the usual default - 'Current_Time' and Attributes: 'on_update' you may still get incorrect timestamps - so, instead set the field type to: DATETIME and let AppGini take care of it.

In the file ' lib.php ' - when the language is set to 'English, British' - the date_default_timezone_set() php function gets set to ' GB '. This is not a valid, supported timezone - See list here: http://php.net/manual/en/timezones.php - in this case, it should be set to ' Europe/London '. This erro...

PLEASE IGNORE THE ABOVE -- CORRECT VERSION BELOW! CHANGE TO AUDIT LOG FUNCTION: A section of the ' table_after_change ' Function as been updated: FROM: // GET ALL COLUMN NAMES IN THE TABLE $colnames = array(); // Create Empty Array $colquery =sql("SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COL...

CHANGE TO AUDIT LOG FUNCTION: A section of the ' table_after_change ' Function as been updated: FROM: // GET ALL COLUMN NAMES IN THE TABLE $colnames = array(); // Create Empty Array $colquery =sql("SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`='$db_name' AND `TABLE_N...

This is the reason why pretty much all family tree software uses diagrams to define relationships and not text fields.

What you're looking at here is the recursive generation of relationships - the type you typically see in 'Family Tree' software. It's also extremely difficult and tedious to explain via text. The biggest problem you'll face is that it is exponentially regenerative, for example: In a family tree of o...

Print Font size is controlled via the 'theme' css. Example css theme file: resources\initializr\css\paper.css Search for: @media print In the ' *:after' section, just add, for example: font-size: 12px; You might can also change the line height with: line-height: 1; or Change a specific attribute: .s...

When it comes to safety for AppGini Applications I've tried a few things and have now settled upon one that works well. In my last application, A database for a large private Residential Care Home: 1st Approach: Usual Web App Security on a LAN server (mid-range power) - this didn't work too well - l...

I did think of this... but my requirements were somewhat different at the time... though I should have offered this as a better way to add the paging/search options on the audit log page. I'm currently working on a method of restoring previous values from within the Audit Log Table - and building th...

Hi... I looked at this

http://forums.appgini.com/phpbb/viewtop ... ader#p3924

and am still somewhat baffled... can anyone assist?

This is possible but a few alterations have to be made: 1. In auditLog.php -> A) Add the following code just after ' include("$currDir/incHeader.php"); ' -> if(!isset($_SESSION ['auditLogRecords'])){ $_SESSION ['auditLogRecords'] = "10"; $auditLogRecords = "10"; } if($_SESSION ['auditLogRecords'] ==...

You may download the files and detailed installation information below: (tiny download, approx. 7kb)

Ooops! Sorry about that... false alert.

I had to restore the database a couple of days ago and for some bizarre reason, it decided to change the Camel Case names of some of the fields.

Hi, for some reason, Dates have stopped appearing when in detail view (but not in every case) - has something been changed?

This technique will only work on a single field - it basically overrides the default setting -> first field in the form. In order to work with multiple fields in Table view, you'd have to add an OnClick event to the tables fields that you wish to enable focus on. You can do this by editing the table...

Note regarding inclusion of your own PHP file at the bottom of the 'incCommon.php' (See above).
Included file MUST have opening and closing PHP tags since it is an inclusion within an inclusion!

And to add your own Javascript functions and php, in the (root)header.php and (admin) incHeader.php files: For Javascript: after "<script src="common.js.php"></script>", simply include your own file ref: <!-- added by Creator--> <script type="text/javascript" src="creators_common.js.php"></script> Y...

See: http://bigprof.com/appgini/tips-and-tut ... arch-forms

Hello, let me open this statement with the following: I will be buying this minor-version . BUT I do so, having no alternative. I do not mind paying for 'Upgrades' - but this, version 5.40 is NOT an upgrade... it's a minor-version (See: http://programmers.stackexchange.com/questions/3199/what-versio...

Because the option to display a child table is not inherent in appgini 5.3 (It requires a modification of the _templateDV (Details View) file - See http://bigprof.com/appgini/tips-and-tutorials/two-tables-same-page ), a similar modification would be required in the _templateDVP (Detail View Print) f...

Ooops... forgot...

you should usually add your template code above the 'if($dvprint)' section of any field you wish to check.

Figured this out after a marathon drinking session last night... who says beers good for nothing! The answer lies in two files: The ' *_templateDVP.html ' file and the '* _dml.php ' files. (Place your own filename at the *) Example: notes_templateDVP.html file: I'd previously modified the template h...

Hi, I have several reports wherein parts are optional. Anyone know how I can Omit them during printing if there value is empty. For example, if (<%%VALUE(notes)%%>) = '') { echo $this; } else { echo $that; } Of course, <%%VALUE(notes)%%> is part of the templating system and this is simply replaced b...

Sorry... Cancel the above request, got it and thank you for your help yet again, a.gneady

Ok. I've managed to create a nice little date range filter that works on TimeStamp formats with a couple of pop up calendars (jQuery-UI): Cap.jpg from the information supplied here: http://bigprof.com/appgini/tips-and-tutorials/customized-search-forms and it does filter on the dates - but be it also...