Search found 227 matches

by peebee
2019-12-10 05:45
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 4
Views: 146

Re: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?

Thanks for the time in replying Jan. The WHERE clause in the jobs_init() itself is not an issue in that it is working fine. The problem arises when I try to apply any filter from the standard built in filter function. So, the WHERE query in jobs_init() = working fine on it's own Filters = working fi...
by peebee
2019-12-09 04:36
Forum: Advanced Customizations > Hooks
Topic: Modify the original DV SQL
Replies: 16
Views: 702

Re: Modify the original DV SQL

Hi Cesteban, Did you manage to get your WHERE clause in the [QueryWhere] => hook to work with standard Appgini filters? I am trying to achieve a similar thing as you but I can manage to get filters to work when the WHERE clause is applied? See here: https://forums.appgini.com/phpbb/viewtopic.php?f=2...
by peebee
2019-12-09 04:31
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 4
Views: 146

Re: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?

Thanks for the reply pböttcher. Unfortunately, I still can't get it to work? In debug, I can see that [QueryWhere] => is empty until I add my WHERE query in the function jobs_init hook. Then I get: [QueryWhere] => WHERE `jobs`.`referred` > DATE_SUB(NOW(),INTERVAL 7 YEAR) That query works just as it ...
by peebee
2019-12-05 05:41
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 4
Views: 146

Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?

I have need to hide all records older than 7 years from all Users. Easy solution is to add WHERE query to $options in hooks/tablename.php like so: function jobs_init(&$options, $memberInfo, &$args){ // Only display jobs referred less than 7 years ago $options->QueryWhere = 'WHERE `jobs`.`referred` >...
by peebee
2019-11-21 01:52
Forum: Advanced Customizations > Hooks
Topic: Build Two Factor Authentication
Replies: 9
Views: 576

Re: Build Two Factor Authentication

Thanks for putting in the effort Olaf, much appreciated. I haven't tried your version yet but I'll give it a go as soon as time permits.
by peebee
2019-11-14 05:13
Forum: Advanced Customizations > Hooks
Topic: Build Two Factor Authentication
Replies: 9
Views: 576

Re: Build Two Factor Authentication

As a matter of interest, I just tested Google Authenticator as per GitHub instructions on V5.81. Still works although one change is necessary in inCommon.php due to hardening of password hashes in recently released versions (post V5.73). Instead of replacing with this (final instruction): if(sqlValu...
by peebee
2019-11-14 00:13
Forum: Advanced Customizations > Hooks
Topic: Build Two Factor Authentication
Replies: 9
Views: 576

Re: Build Two Factor Authentication

Hmmm? Just checked the GoogleAuthenticatorClass.php link in that GitHub link above and I see it is now dead? Not sure why it's no longer available and obviously I can't vouch for the code but here is a copy of the original attached if anybody is interested in giving it a go/edit: GoogleAuthenticator...
by peebee
2019-11-13 23:58
Forum: Advanced Customizations > Hooks
Topic: Build Two Factor Authentication
Replies: 9
Views: 576

Re: Build Two Factor Authentication

I have tried this Google Authenticator plugin developed by a past Appgini subscriber in previous versions of AppGini (not on Version 5.81 yet - but I can't see any reason why it won't still work OK?): https://github.com/massyn/appgini-tools/blob/master/google-authenticator.md It does work well! Goog...
by peebee
2019-11-13 23:44
Forum: Tips And Tricks
Topic: Improve security the easy way
Replies: 1
Views: 369

Re: Improve security the easy way

Another option: NinjaFirewall I personally subscribe to the premium ($45 USD) version of NinjaFirewall WAF. A stand alone web application firewall for all php projects. Incredibly comprehensive and all configured via a simple dashboard. Works a treat with AppGini projects. Logs prove it does its job...
by peebee
2019-11-05 02:02
Forum: Bugs/annoyances
Topic: Image/Photo 'well' in AppGini 5.81
Replies: 8
Views: 587

Re: Image/Photo 'well' in AppGini 5.81

Sorry, provided the simplest solution I could think of as I was presuming you were wanting to hide ALL instances of .well class app wide. I'm not aware of where, other than images, the .well class has been added in V5.81? To hide individual elements, you'd just need to add the specific element selec...
by peebee
2019-11-04 21:40
Forum: Bugs/annoyances
Topic: Image/Photo 'well' in AppGini 5.81
Replies: 8
Views: 587

Re: Image/Photo 'well' in AppGini 5.81

Hmm, odd? I just tried it in developer tools on an image in the Appgini Northwind demo (V5.81) and it worked ok?

Did you add the <style> tags? Also try clearing your browser cache? Try this?

<style>
.well {
background-color: #ffffff !important;
border: none !important;
}
</style>
by peebee
2019-11-03 23:42
Forum: Bugs/annoyances
Topic: Image/Photo 'well' in AppGini 5.81
Replies: 8
Views: 587

Re: Image/Photo 'well' in AppGini 5.81

I haven't actually installed V5.81 yet but as far as I'm aware .well is just Bootstrap css class so I'm guessing you should be able to hide it pretty easily if you want to? Just add the following css style (or something along these lines depending on your background colour if it isn't white) to your...
by peebee
2019-11-01 05:51
Forum: Bugs/annoyances
Topic: Lock a record to prevent simultaneous User access
Replies: 2
Views: 866

Re: Lock a record to prevent simultaneous User access

Thanks for the detailed reply Jan. I can see how your solution could solve the problem in many cases. Record ownership could prove a problem in my particular situation however. Ideally, I had hoped from a more programmatic solution to be built into Appgini, much say like this similar software here: ...
by peebee
2019-10-29 06:44
Forum: Bugs/annoyances
Topic: Lock a record to prevent simultaneous User access
Replies: 2
Views: 866

Lock a record to prevent simultaneous User access

I hate to raise this old issue yet again but as far as I can see (from the changelog and my tests at least) there is still no record lock function implemented into the current Appgini release? This is an issue first raised back in 2015 and has been revisited many times since. Whilst I haven't actual...
by peebee
2019-10-10 07:03
Forum: Getting Started
Topic: hook for index.php / homepage?
Replies: 8
Views: 566

Re: hook for index.php / homepage?

You could also view one of Ahmad's handy video tutorials which will show you how to select the desired page via php and include your javascript.

https://www.youtube.com/watch?v=hBkvdWh-OEw
by peebee
2019-10-08 04:14
Forum: Getting Started
Topic: hook for index.php / homepage?
Replies: 8
Views: 566

Re: hook for index.php / homepage?

/hooks/footer-extras.php is loaded with every page including your homepage. You could call your javascript file from there?
by peebee
2019-08-29 11:20
Forum: Advanced Customizations > Hooks
Topic: Add button on table view page
Replies: 8
Views: 463

Re: Add button on table view page

File name should be dossier_individuel-tv.js (for table view) - not dossier_individuel-dv.js
by peebee
2019-08-28 23:48
Forum: Advanced Customizations > Hooks
Topic: Add button on table view page
Replies: 8
Views: 463

Re: Add button on table view page

Create (or use existing if you already have one) a new yourtablename-tv.js in your hooks folder (where of course yourtablename is the actual name of your table) Example to add a new Filter button next to existing buttons. Edit the function/style to suit your purpose: jQuery(function(){ jQuery('#Filt...
by peebee
2019-05-17 07:43
Forum: Advanced Customizations > Others
Topic: Force password reset 90 days after last change
Replies: 2
Views: 585

Re: Force password reset 90 days after last change

Sory for late reply. Have been sidetracked on another project.

Sounds like a great and relatively simple plan for what I need to achieve. I'll give it a go as soon as time permits. Thanks! Much appreciated.
by peebee
2019-05-08 05:14
Forum: Advanced Customizations > Others
Topic: Force password reset 90 days after last change
Replies: 2
Views: 585

Force password reset 90 days after last change

For purposes of a security audit, I'm looking to implement a function to force a password reset for all users, 90 days after their last password change. How exactly to achive that with minimum fuss and hopefully not requiring further tables/fields is the problem? I'm thinking a cron script might do ...
by peebee
2019-02-17 23:13
Forum: Feature Suggestions
Topic: Updating multiple records using Batch Action
Replies: 2
Views: 538

Re: Updating multiple records using Batch Action

Although I can't actually find an Appgini licence agreement anywhere (?), I'm pretty sure it doesn't have any restriction on editing generated code and that the developer Ahmad has no objection to the editing of (generated) source code. See this: https://forums.appgini.com/phpbb/viewtopic.php?t=743 ...
by peebee
2019-02-17 22:29
Forum: Getting Started
Topic: mask CPF e Tel
Replies: 4
Views: 651

Re: mask CPF e Tel

This jquery mask also works extremely well and includes input validation. I use it myself. https://github.com/RobinHerbots/Inputmask Can be loaded with hooks. Call the jquery.inputmask.bundle.js in your hooks/header-extras.php and include the jquery Inputmask function in your hooks/tablename-dv.js Y...
by peebee
2019-02-11 03:09
Forum: Bugs/annoyances
Topic: Error when generating project with 5.73/5,74
Replies: 3
Views: 500

Re: Error when generating project with 5.73/5,74

What version of PHP are you running? Not sure as I haven't seen lib.php in V5.73 or 5.74 yet but it is possibly an anonymous function causing the error? Anonymous functions are not supported on PHP < 5.3 If that is the problem and if you are running PHP 5.2 or lower, you would be well advised to upg...
by peebee
2019-02-08 05:00
Forum: Advanced Customizations > Others
Topic: Why this provision?
Replies: 13
Views: 1441

Re: Why this provision?

Yes, as bescott53 and jsetzer suggested it looks you need to limit the amount of characters viewable per field by entering a value in the "Max characters in table view" box for each field to be shown in the specific table view. See below. screenshot.jpg Or you can control column widths in hooks with...