Wordpress Gear ™. Do Better!

Adaptive Login Action

Adaptive Login Form: Adjusting compromise between Comfort and Paranoia.

Conception:

If my current IP address is not marked as Dangerous since my last successful login, then there is no need to distrust me and force me to go through Quests to solve different types of Captchas.
In this case, the standard “Password” field is sufficient for one attempt.

But if the Attempt is unsuccessful, then we mark the IP address as Dangerous, and then it is possible and necessary to trick me (or the one who is trying to be me) with a more thorough login procedure.

There may be multilevel options. It doesn’t matter (this will be gradually added to the functionality). We are now talking about the General Principle.

= Futured =

* Separate statistics are generated for each IP address and the ratio “Successful number of entries” / “Total number of entries” is determined. Depending on how close this parameter is to 100%, we can talk about the need for the Toughness of the Mistrust process.

This mechanism starts before the User enters his Login.

The more Unsuccessful Login attempts occur from a given IP Address, the more thoroughly it is checked.
Conversely, the Login procedure can be simplified as much as possible if there is no obvious reason.

* Regardless of what kind of Authentication Error occurred, be it:
– Invalid Username;
– Invalid User Password;
– Incorrectly specified additional security elements: “Secret Key” / Captcha / etc.
This will not be indicated in the error message. There will always be only one message: “Authentication Failed”.
Thus, we do not explicitly indicate to the potential Villain / Bot the reason for the denial of access. And the more such Reasons there are, the more complicated the Entry procedure becomes.

* Интегрирован с плагином “New Users Monitor“.

Continue reading “Adaptive Login Action”

Hack-Info

“Hack-Info” – Free tools (Now, “Hack-Info” – it is a standalone independent complete tool.
Previously, it was like Add-On for “iThemes Security”. But time has shown that it is bad to be dependent on others.. Especially when their DB structure changes.
) to make improve the perception of information about events, which is important to quickly and in detail see and understand. Without the need for unnecessary clicks and conversions. “Hack-Info” notifies the site administrator by providing a detailed list of IP addresses, requests – attempts to scan resources and search for passwords with names.

Continue reading “Hack-Info”

PHP lib: phpExcel for WP5.7 (PHP 7.4)

Popular phpExcel library does not work under new WordPress 5.7 and higher, because WP5.7 requires PHP 7.4
As a result, exporting data to an Excel file does not work.

You can switch to new, alternative, modern tools for exporting to Excel tables, or continue to use the familiar phpExcel library, but specially modified for the requirements of PHP 7.4

This modification (2024.05.10 PHP 7.4.3) was done independently, taking into account the flow of falling out errors. It is likely that over time, new problem areas will be identified, but at the moment they are not. All the features you need (for me anyway) work great.

There are no evil facking-hack inclusions. Guaranteed.

List of changes:
\PHPExcel\Shared\OLE.php
\PHPExcel\Writer\Excel5\Worksheet.php
\PHPExcel\Writer\Excel5\Workbook.php
\PHPExcel\Writer\Excel5\Parser.php
\PHPExcel\Cell\DefaultValueBinder.php
\PHPExcel\Cell.php
\PHPExcel\ReferenceHelper.php
\PHPExcel\Worksheet\AutoFilter.php
\PHPExcel\Calculation.php
\PHPExcel\Shared\String.php
\PHPExcel\Calculation\Functions.php

Deleted:
\PHPExcel\Shared\PCLZip
* This library is already included in the set of WordPress libraries .

Free to download.

Download “phpExcel lib for WP5.7 (PHP 7.4)” phpExcel_7.4.3_20240510.zip – Downloaded 2820 times – 932 KB

Import Excel to Gravity Forms

Bulk Import of Records from Excel (CSV) files for “Gravity Forms” with Validation and Internal Logic support.

If you have a Form in which there are Calculated Fields based on the Values of other Fields and the need for bulk import of source data, then this Plugin will definitely be useful to you.

For example. Form Type Calculator:

Field id=2 “A“: Term 1.
Field id=3 “B“: Term 2.
Field id=5 “Ratio“: Coefficient.
Field “Calc“: C = (A + B) * Ratio

When Importing Records, you usually need to prepare all the Values of all Fields:
A; B; Ratio; C.
So, to carry out preliminary calculations.

Difficulties begin when branched Inner Logic is used. When there are various additional Fields for selecting conditions in the form of Lists, Options. (“Gravity Forms” allows you to use both built-in Internal Logic in each of the Fields, and connect JS Scripts with Scripts.)
Transferring JS Scripts with Scripts to an Excel-prepared Table can be quite a difficult task. Errors are almost inevitable. Moreover, it is necessary to carefully maintain the correspondence of the calculated formulas in the Table with the Form Algorithms. And if you have changed something in the algorithms of the Form, then you again need to change and then test the Formulas in the Table. Even writing about it is tiresome.

Moreover, some Field Values may have both Value and Format Constraints. In normal cases, import without checking such Restrictions may lead to an abnormal termination of the Import process, or to incorrectly filled Fields.
In any case, manual correction of Records after such an Import can be costly and resource intensive.

It is for such Tasks that this Plugin is needed: “Import Excel to Gravity Forms“.

It is enough to fill in only the Initial Fields.

In our Example – Fields: A B and Ratio.
Calculated Field “C” will be calculated in each imported Record by the internal Form algorithms and will be saved.

If some of the Values are out of range, then such a Record will not be saved and will require correction directly during the Import process.

= Features =
* Works with PHP 7.4
* Works with Gravity Forms versions 2.3.3.4 (earlier GF versions were simply not tested. Probably will work) and higher. Tested up to 2.5.7.1
* Import entries are lines of a text file (usually CSV) separated by commas.
* You can choose any other separator.
* You can navigate through the list of imported records and save only a few of them.
* Each record is checked for compatibility of field formats before saving.
* If the Form Fields have internal logic, then each record is processed with this logic in mind before being saved.
* All types of fields are imported: “Text”, “TextArea”, “Number”, “Date”, “Select”, “MultiSelect”, “Radio”, “CheckBox”.
* Works correctly with Cyrillic and other National character encodings.
* Each Form has its own “Import Enable” option.
* Works correctly when there are several other GForms on the page.
* Possibility to choose encoding of CSV file: ‘utf-8’ – default; ‘ISO-8859-1’; ‘CP1251’; etc…
Continue reading “Import Excel to Gravity Forms”

GV Excel-Export

Make realy comfortable, complete export to normal Excel files from GravityView.

GravityView (whatever my attitude towards him) popular tool. But the built-in Export allows to generate only CSV files. For many, this is inconvenient and insufficient, because tedious post-processing of such files is required. The presence of the Cyrillic alphabet in the name of the fields can greatly spoil the mood and desire to do something.

This Plugin is designed to solve this problem.
Continue reading “GV Excel-Export”

List-Forms for Gravity

The “List-Forms for Gravity” plugin extends the capabilities of the standard Forms-List in the Admin Panel on the “Gravity Forms” & “Gravity View” pages.

A new line with a Description of the Form itself is harmoniously added to each line with the Form, which indicates its Name, ID, Number of Records and Number of Views, as well as an Interactive Control Unit.
This Note – is the “Description” field on the “Settings” page of each GF/GV Form.

It would seem that it would be good for this Description to be initially in a separate Column right after the Title, but if you think carefully, you realize that no – not good. The point is that Names can be long, and Descriptions can be even longer, otherwise they simply don’t make sense. And besides, the same Interactive Control Unit 0n requires a lot of space and takes up half the width of the Form List table.

It is possible that the “Description” field is not used by many. And therefore, the developers did not bother about this. Although, the developers could also make the List Customization option.
But if there are really many Forms, then the Description is simply necessary.

This Plugin gives you this opportunity.

= Futured =
* Fits harmoniously with the usual style of the List of Forms.

Continue reading “List-Forms for Gravity”

Plugin Notes

This plugin is rarely updated. Yes there is no need. A good tool and it does its job well. And you do not need to do anything to improve it and make it the operating system. Respect to the author, because he understands.
This plugin no PRO version.

But there is a small, annoying problem (about which most people probably do not even know, especially someone on free hosting sites). This plugin makes a lot of error entries in the log file.
And in general it is possible to live with it. But over time, the log file can grow to an enormous size. This somehow affect the system performance.

Continue reading “Plugin Notes”

WordPress Gear