Search found 54 matches

by primitive_man
2017-04-24 12:10
Forum: Bugs/annoyances
Topic: Daylight Savings Time Error
Replies: 2
Views: 1608

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.
by primitive_man
2017-04-24 09:56
Forum: Bugs/annoyances
Topic: Daylight Savings Time Error
Replies: 2
Views: 1608

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...
by primitive_man
2016-07-28 16:29
Forum: Tips And Tricks
Topic: Audit Log
Replies: 33
Views: 9879

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...
by primitive_man
2016-06-07 12:42
Forum: Tips And Tricks
Topic: Audit Log
Replies: 33
Views: 9879

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...
by primitive_man
2016-05-17 10:00
Forum: Getting Started
Topic: Link Rows in Same Table
Replies: 8
Views: 4345

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.
by primitive_man
2016-05-17 09:59
Forum: Getting Started
Topic: Link Rows in Same Table
Replies: 8
Views: 4345

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...
by primitive_man
2016-05-17 09:22
Forum: Tips And Tricks
Topic: How to change Print out font size
Replies: 2
Views: 2284

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...
by primitive_man
2016-04-24 15:33
Forum: Getting Started
Topic: How safe is AppGini? How can it be made safer?
Replies: 18
Views: 6863

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...
by primitive_man
2016-04-15 10:03
Forum: Tips And Tricks
Topic: Audit Log
Replies: 33
Views: 9879

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...
by primitive_man
2016-04-12 13:40
Forum: Getting Started
Topic: Redirect after update
Replies: 0
Views: 1753

Redirect after update

Hi... I looked at this

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

and am still somewhat baffled... can anyone assist?
by primitive_man
2016-03-06 20:21
Forum: Tips And Tricks
Topic: Audit Log
Replies: 33
Views: 9879

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'] ==...
by primitive_man
2016-01-03 16:34
Forum: Tips And Tricks
Topic: Audit Log
Replies: 33
Views: 9879

Re: Audit Log

You may download the files and detailed installation information below: (tiny download, approx. 7kb)
by primitive_man
2015-07-07 10:24
Forum: Bugs/annoyances
Topic: Dates not Auto-filling in Details Views
Replies: 1
Views: 1365

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.
by primitive_man
2015-07-06 14:05
Forum: Bugs/annoyances
Topic: Dates not Auto-filling in Details Views
Replies: 1
Views: 1365

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?
by primitive_man
2015-06-25 12:30
Forum: Tips And Tricks
Topic: Landing in the right field when editing a record
Replies: 4
Views: 2261

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...
by primitive_man
2015-06-25 11:25
Forum: Tips And Tricks
Topic: List of functions
Replies: 2
Views: 1962

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!
by primitive_man
2015-06-24 10:56
Forum: Tips And Tricks
Topic: List of functions
Replies: 2
Views: 1962

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...
by primitive_man
2015-05-21 23:47
Forum: Bugs/annoyances
Topic: Upgrade
Replies: 5
Views: 3637

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...
by primitive_man
2015-05-18 11:44
Forum: Getting Started
Topic: How to Customize Print Preview
Replies: 3
Views: 2447

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...
by primitive_man
2015-05-07 12:33
Forum: Getting Started
Topic: Omit Fields in Print View if Empty Value
Replies: 3
Views: 1898

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.
by primitive_man
2015-05-07 12:14
Forum: Getting Started
Topic: Omit Fields in Print View if Empty Value
Replies: 3
Views: 1898

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...
by primitive_man
2015-05-02 11:27
Forum: Getting Started
Topic: Omit Fields in Print View if Empty Value
Replies: 3
Views: 1898

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...
by primitive_man
2015-04-17 15:37
Forum: Getting Started
Topic: Filter by Date Range
Replies: 8
Views: 6023

Re: Filter by Date Range

Sorry... Cancel the above request, got it and thank you for your help yet again, a.gneady
by primitive_man
2015-04-17 15:12
Forum: Getting Started
Topic: Filter by Date Range
Replies: 8
Views: 6023

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...