Search found 246 matches

by peebee
2020-02-13 22:56
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 20
Views: 848

Re: Force Strong Passwords - Appgini V5.81

PS: I realise that this is far from a perfect fix for the issue in that there are now 7 x core files that require editing, ALL of which will need to be replaced if your app is regenerated/overwritten. Strong password policy is a requirement for me (and probably should be for most applications) but u...
by peebee
2020-02-13 22:35
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 20
Views: 848

Re: Force Strong Passwords - Appgini V5.81

Glad to hear it's working for you and suits your purpose aarlauskas. Thanks also for the generous offer of payment but seriously not necessary. Happy to assist if/when I can. I can see small glitches in the way the system accepts the passwords. Not actually a glitch. As it is at the moment (and I pr...
by peebee
2020-02-13 03:51
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 20
Views: 848

Re: Force Strong Passwords - Appgini V5.81

V3 below now includes all of the above plus one more additional edited file added (admin/pageSettings.php) to enforce strong password on resetting the Super Admin password. Only thing I can see that's missing now is enforce strong password for Super Admin when you first install/configure the app. I ...
by peebee
2020-02-12 23:59
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 20
Views: 848

Re: Force Strong Passwords - Appgini V5.81

OK, I've now added strong password policy to the "password reset" function and all should be working correctly everywhere now - except for the Super Admin password that I haven't quite got to yet. Just one additional file added to the new V2 upload below (/membership_passwordReset.php) So now, stron...
by peebee
2020-02-12 21:58
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 20
Views: 848

Re: Force Strong Passwords - Appgini V5.81

Ah, yes aarlauskas, part of what you report would be correct. Password function exists in more places than I had expected. My security audit requires me to remove the "password reset" function so I must admit I hadn't even touched that. I will get onto that now. Hopefully shouldn't be too hard to fi...
by peebee
2020-02-11 07:12
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 20
Views: 848

Re: Force Strong Passwords - Appgini V5.81

For testing: I just loaded an untouched app that I downloaded from AppGini's GitHub account. (https://github.com/bigprof-software/online-invoicing-system) I replaced ONLY the files in my original upload (with no further edits - not even changing the $app_name = " " variable). Worked a treat. Not sur...
by peebee
2020-02-11 06:34
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 20
Views: 848

Re: Force Strong Passwords - Appgini V5.81

Hmmm? It's working fine for me and I don't think I forgot to add anything in the upload? I've used this on a few apps so far - never failed. I just compared the files in the upload to what I'm using myself and they are the same? Should be working?? Q. Where (which page) did you change the password a...
by peebee
2020-01-22 00:09
Forum: Bugs/annoyances
Topic: image in table view and detail view
Replies: 11
Views: 669

Re: image in table view and detail view

Firstly, did you use Google Chrome browser Developer Tools to debug or did you use Microsoft Edge? Have you tried your app in any browser other than Edge/IE? Do the thumbnails display correctly in other browsers? Next, this: " Les images de la base de donnees doivent etre stockées dans le dossier im...
by peebee
2020-01-21 06:23
Forum: Bugs/annoyances
Topic: image in table view and detail view
Replies: 11
Views: 669

Re: image in table view and detail view

"Console" = we are referring to your web browser developer tools console. Perhaps try Google Chrome first. To "inspect" the image thumbnail element in Google Chrome: 1. Open your Appgini application in Google Chrome and go to a table with the missing thumbnails 2. Right click your mouse directly ove...
by peebee
2020-01-20 01:02
Forum: Bugs/annoyances
Topic: image in table view and detail view
Replies: 11
Views: 669

Re: image in table view and detail view

From that screenshot, it looks like the thumbnails do not exist rather than not displaying correctly? If you "inspect element" in your console, what is the URL of the thumbnail and do you see any error in the console? URL should be something like below: thumbnails.jpg Also, have you tried the "Rebui...
by peebee
2020-01-16 08:06
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 20
Views: 848

Force Strong Passwords - Appgini V5.81

By default, AppGini accepts ANY password with a minimum of 4 characters. Strong passwords (combination of uppercase, lowercase, numeric, special character and at least 8 characters) can be enforced by editing several core files. Files requiring editing: membership_profile.php membership_signup.php a...
by peebee
2020-01-14 22:37
Forum: Bugs/annoyances
Topic: Console Error on login & home page in V5.8.1
Replies: 2
Views: 354

Re: Console Error on login & home page in V5.8.1

Sorry Jan (and Ahmed), my apologies for nagging on something already reported. Should obviously have searched a little better.

It did appear that no actual error(s) were being caused - but any console error is very irritating nonetheless. Good to see it is being addressed. Thanks.
by peebee
2020-01-14 06:48
Forum: Bugs/annoyances
Topic: Console Error on login & home page in V5.8.1
Replies: 2
Views: 354

Console Error on login & home page in V5.8.1

Hate to be picky but I just upgraded an app to V5.8.1 and noticed that /common.js is causing a console error when loading the login and home page (or any other non /admin/ page without a table name in the URL). Error: "AppGini.currentTableName: Could not retrieve table name from page URL" The error ...
by peebee
2019-12-17 22:10
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 12
Views: 644

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

Thanks for the speedy reply and fix Ahmed. Much appreciated, as always.

I'll have a test and report back.

Also good to see that I'm not actually going completely insane...... :)
by peebee
2019-12-17 22:02
Forum: Getting Started
Topic: timepicker start time
Replies: 4
Views: 206

Re: timepicker start time

I haven't actually ever used the timepicker myself but have you tried:

$j('#time_a').timepicker({ defaultTime: '08:00 AM' });
by peebee
2019-12-17 06:51
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 12
Views: 644

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

The issue certainly relates to the code snippet below in datalist.php as you suggested Jan. With a tiny bit of editing I can easily change the behaviour - add or remove the opening/closing parentheses depending on filters being applied or not and if $options->QueryWhere exists. Sadly, I can only man...
by peebee
2019-12-17 02:49
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 12
Views: 644

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

Seems to me like this is an actual bug in Appgini rather than something I'm messing up? I can easily resolve the issue when the WHERE clause is added to the invoices_init hook AND a filter is applied by simply adding an opening bracket to complete the query, like so: $options->QueryWhere = "WHERE ((...
by peebee
2019-12-17 02:29
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 12
Views: 644

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

Thanks again Jan. Yes, I'd already tried single quotes and double quotes - same outcome. I'd also tried injecting the WHERE clause straight into the invoices_view.php core file ($x->QueryWhere = ' ';) thinking that might get around the issue - same SQL error outcome with the superfluous closing brac...
by peebee
2019-12-16 01:10
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 12
Views: 644

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

Took a few days off and have just revisted this, to see if I can work out what's going wrong. Here is how you can easily replicate the issue. (1) I loaded this project (without any edits) from the BigProf (Appgini) github repository: https://github.com/bigprof-software/online-invoicing-system (2) I ...
by peebee
2019-12-10 05:45
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 12
Views: 644

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: 1234

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: 12
Views: 644

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: 12
Views: 644

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: 1001

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: 1001

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