Search found 54 matches
- 2017-04-24 12:10
- Forum: Bugs/annoyances
- Topic: Daylight Savings Time Error
- Replies: 2
- Views: 1879
Re: Daylight Savings Time Error
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.
- 2017-04-24 09:56
- Forum: Bugs/annoyances
- Topic: Daylight Savings Time Error
- Replies: 2
- Views: 1879
Daylight Savings Time Error
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...
- 2016-07-28 16:29
- Forum: Tips And Tricks
- Topic: Audit Log
- Replies: 88
- Views: 59673
Re: Audit Log
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...
- 2016-06-07 12:42
- Forum: Tips And Tricks
- Topic: Audit Log
- Replies: 88
- Views: 59673
Re: Audit Log
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...
- 2016-05-17 10:00
- Forum: Getting Started
- Topic: Link Rows in Same Table
- Replies: 8
- Views: 5022
Re: Link Rows in Same Table
This is the reason why pretty much all family tree software uses diagrams to define relationships and not text fields.
- 2016-05-17 09:59
- Forum: Getting Started
- Topic: Link Rows in Same Table
- Replies: 8
- Views: 5022
Re: Link Rows in Same Table
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...
- 2016-05-17 09:22
- Forum: Tips And Tricks
- Topic: How to change Print out font size
- Replies: 2
- Views: 2641
Re: How to change Print out font size
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...
- 2016-04-24 15:33
- Forum: Getting Started
- Topic: How safe is AppGini? How can it be made safer?
- Replies: 18
- Views: 7950
Re: How safe is AppGini? How can it be made safer?
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...
- 2016-04-15 10:03
- Forum: Tips And Tricks
- Topic: Audit Log
- Replies: 88
- Views: 59673
Re: Audit Log
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...
- 2016-04-12 13:40
- Forum: Getting Started
- Topic: Redirect after update
- Replies: 0
- Views: 1912
Redirect after update
Hi... I looked at this
http://forums.appgini.com/phpbb/viewtop ... ader#p3924
and am still somewhat baffled... can anyone assist?
http://forums.appgini.com/phpbb/viewtop ... ader#p3924
and am still somewhat baffled... can anyone assist?
- 2016-03-06 20:21
- Forum: Tips And Tricks
- Topic: Audit Log
- Replies: 88
- Views: 59673
Re: Audit Log
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'] ==...
- 2016-01-03 16:34
- Forum: Tips And Tricks
- Topic: Audit Log
- Replies: 88
- Views: 59673
Re: Audit Log
You may download the files and detailed installation information below: (tiny download, approx. 7kb)
- 2015-07-07 10:24
- Forum: Bugs/annoyances
- Topic: Dates not Auto-filling in Details Views
- Replies: 1
- Views: 1592
Re: Dates not Auto-filling in Details Views
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.
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.
- 2015-07-06 14:05
- Forum: Bugs/annoyances
- Topic: Dates not Auto-filling in Details Views
- Replies: 1
- Views: 1592
Dates not Auto-filling in Details Views
Hi, for some reason, Dates have stopped appearing when in detail view (but not in every case) - has something been changed?
- 2015-06-25 12:30
- Forum: Tips And Tricks
- Topic: Landing in the right field when editing a record
- Replies: 4
- Views: 2666
Re: Landing in the right field when editing a record
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...
- 2015-06-25 11:25
- Forum: Tips And Tricks
- Topic: List of functions
- Replies: 2
- Views: 2328
Re: List of functions
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!
Included file MUST have opening and closing PHP tags since it is an inclusion within an inclusion!
- 2015-06-24 10:56
- Forum: Tips And Tricks
- Topic: List of functions
- Replies: 2
- Views: 2328
Re: List of functions
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...
- 2015-05-22 12:17
- Forum: Getting Started
- Topic: Not Show ALL results upon page load
- Replies: 5
- Views: 2472
- 2015-05-21 23:47
- Forum: Bugs/annoyances
- Topic: Upgrade
- Replies: 5
- Views: 4169
Upgrade
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...
- 2015-05-18 11:44
- Forum: Getting Started
- Topic: How to Customize Print Preview
- Replies: 3
- Views: 2917
Re: How to Customize Print Preview
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...
- 2015-05-07 12:33
- Forum: Getting Started
- Topic: Omit Fields in Print View if Empty Value
- Replies: 3
- Views: 2275
Re: Omit Fields in Print View if Empty Value
Ooops... forgot...
you should usually add your template code above the 'if($dvprint)' section of any field you wish to check.
you should usually add your template code above the 'if($dvprint)' section of any field you wish to check.
- 2015-05-07 12:14
- Forum: Getting Started
- Topic: Omit Fields in Print View if Empty Value
- Replies: 3
- Views: 2275
Re: Omit Fields in Print View if Empty Value
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...
- 2015-05-02 11:27
- Forum: Getting Started
- Topic: Omit Fields in Print View if Empty Value
- Replies: 3
- Views: 2275
Omit Fields in Print View if Empty Value
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...
- 2015-04-17 15:37
- Forum: Getting Started
- Topic: Filter by Date Range
- Replies: 8
- Views: 6899
Re: Filter by Date Range
Sorry... Cancel the above request, got it and thank you for your help yet again, a.gneady
- 2015-04-17 15:12
- Forum: Getting Started
- Topic: Filter by Date Range
- Replies: 8
- Views: 6899
Re: Filter by Date Range
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...