Operational Hooks, bug fixed. Installation problems on ionCube 12, solved.

Posted by Eugenio on 23 Dec 2022

Dear users,
a few things to discuss today.

Before INSERT and UPDATE hooks, bug fixed

As explained in this forum post I have recently found a bug related to before insert and before update operational hooks. I have fixed the bug and silently updated the current V 11.8.

If this bug impacts on your applications, you can download again V 11.8 and just replace the file /front_logic.php with the new one (you don't need to go through the upgrade process).

To get the new file, you can just click again on your download link and you will download the updated version.
Since the MD5 hash of the files have changed, if you want to check it, here are the new ones.

dadabik_11.8-Elba_enterprise.zip = f163b63fa6a2a5dca44ced8ffc518229
dadabik_11.8-Elba_enterprise_monthly.zip = 4ab3612246f52fb429855f2844c4183f
dadabik_11.8-Elba_platinum.zip = 72b67d48f6f8476631d65c79bd813117
dadabik_11.8-Elba_pro.zip = db9d4f26cc6bc854b67aac51bdb09fd4

Installation problems (typically on Windows + ioncube 12.x)

Some customers had issues installing DaDaBIK on Windows + PHP 8.1 + ionCube 12 (install.php and/or install2.php crashed). The latest ionCube loaders and some changes in this V 11.8 should fix all those issues. In this case, multiple files have been changed.

Last video of the year: how to backup and upgrade DaDaBIK

Finally, on Thursday I will publish on our YouTube channel the last video of the year: how to (properly) backup and upgrade DaDaBIK. I will show you, step-by-step, how to do it after having installed DaDaBIK on a common shared hosting service.

Merry Christmas, Happy Holidays and best wishes for a fantastic 2023!

--
Eugenio Tacchini
DaDaBIK Founder

New monthly payment model + V. 11.8 is out: change layout from the Admin GUI, login/registration hooks & more

Posted by Eugenio on 5 Dec 2022

Dear users,

I am glad to announce a new DaDaBIK release and a completely new subscription-based license.

THE NEW 11.8 ELBA

We have a lot of new features, probably more than a typical minor release. I show you the most significant in this video. Starting from this V 11.8, in fact, we have a new series, "DaDa Release": I will publish a short, informal video to show you the main new features for each minor release.

I'll summarize also here some of them:

• new layout tab: you can change from the admin panel the layout-related parameters (e.g. logo) and add your custom CSS without editing any file


• login and registration form are now more customizable: you can add up to 3 checkboxes (e.g. "accept privacy terms"), you have a login form layout hook and (operational) after login and after user self registration hooks (e.g. if you need to do something in your system when a new user registers)


• custom menu item names: you can now set the name of each item in the menu according to the group the currently logged user belongs to

As usual, you can see the complete list of changes and fixes in the change log. In fact, also some very important fixes have been released.

THE NEW SUBSCRIPTION-BASED LICENSED

There is other big news: for the first time I have introduced a monthly, subscription-based license for DaDaBIK.

The classic "pay once, use forever" license is still available, but now you have an additional option: only for DaDaBIK Enterprise (no Pro, no Platinum) you can pay a monthly subscription to use DaDaBIK.

You can cancel your subscription anytime, DaDaBIK will still work for a few days to allow you to fix possible payment issues and then it will stop working. If your subscription is active, not only you can use DaDaBIK but you can download for free any new version (minor or major) released.

For the first month, the price is $9 only. Starting from the second month, $15 /month.

You can see all the options in the pricing page.

As usual, for both standard and subscription-based licenses, you can buy your new license here.

You can upgrade your existing DaDaBIK (for free, if you are in your free upgrade period) here.

Have fun!

Best,

--
Eugenio Tacchini
DaDaBIK Founder

PHP 8.1 is now supported + Users can join multiple groups + Custom Code API - V. 11.7 is out

Posted by Eugenio on 18 Aug 2022

Dear users,

it took more than expected but DaDaBIK finally supports PHP 8.

The ionCube loaders for PHP 8.1 are now available so you can run this new DaDaBIK 11.7 Elba on PHP 8.1, the latest stable version of PHP.

PHP 8.0 at the moment is not supported, maybe it will be in the future. PHP 7 is still supported.

There is more:

1) Users can now join multiple groups

This new version comes with a huge improvement, sponsored by one of our customer, related to permissions management: a user can now join multiple groups.

This means each user belongs to a (main) group plus one or more (optional, additional) groups.

How do permissions work now?

The permissions for a user will be computed considering all the groups the user belongs to (main group + additional groups), using a most permissive strategy. You can check the resulting permissions for each user in the new Permissions -> Show user Permissions page. All the details in the documentation, chapter "Permissions based on multiple groups"

By default this feature is enabled, you can disable it by setting $enable_multiple_groups_permissions to 0.

2) Custom Code API
A set of API functions will be released to make your custom code leaner, more readable and secure. In V 11.7, the first function, get_record_details(), has been released. In one code line you can get the field values of a record belonging to any of the tables you have in your database, without directly executing SQL queries. For example here I am getting all the info (name, address, ... ) of the customer having id 10:

$customer_info = get_record_details('customers', 'id', 10);

Finally a small but time-saving improvement: If the database $db_name you specify in your config_custom file doesn't exist, DaDaBIK tries to create it. This allows to create an application with DaDaBIK without using any external tool, not even for the creation of an empty database (experimental feature currently available for MySQL only).


There are also other changes and several bugs fixed so as usual I suggest to have a look at the change log.

You can buy your new license here.

You can upgrade your existing license (for free, if you are in your free upgrade period) here.

Best,

--
Eugenio Tacchini
DaDaBIK Founder

I created a complete, enterprise-ready, custom CRM application in 2 hours (video)

Posted by Eugenio on 11 Jul 2022

Dear users,
the most comprehensive tutorial on our YouTube channel ("Create a Web Application in 25 minutes without coding ...", 16k+ views) is quite old (2017) and still based on DaDaBIK 8.

The latest version of DaDaBIK, 11.6 Elba, has a lot of additional features so I thought it was time for a completely new and improved version of the video.

I decided to build a complete CRM (Customer Relationship Management) application with DaDaBIK, trying to exploit all its features, it has been fun and challenging!

The result is a two-hours video: I'll guide you, step by step, to create this application, starting from scratch. I think it is extremely useful for new users and it's also a good refresher for power users (it has 22 chapters, so you can easily watch the topic you are interested in).

This first 2h part is completely no-code while a second (and last) part of this tutorial will be published in the near future and will show some low-code development (custom functions, buttons, hooks, conditional fields, row level custom filters) that will refine and improve the CRM app. I will also show the development of a CRM funnel using an external library that I will integrate into DaDaBIK.

If you enjoy the video, don't forget to hit the like button :) this increases the chances that other people in our little niche will see the video and, as a result, can make our community grow, which is beneficial for all of us.

Finally, I'd like to create a series from this video: in the future, for example, I could show how to build an inventory management system or a library management system. Please let's discuss in the YouTube comments which application (if any) you would like me to build, using DaDaBIK.

Here is the video:




Have a good summer!

Best,
--
Eugenio Tacchini
DaDaBIK Founder

V 11.6 is out: save time with Permission Templates + Warning for unsaved data

Posted by Eugenio on 14 Jun 2022

Dear users,
V 11.6 is out with two main improvements.

Permissions Templates
One of the most tedious tasks when I develop a DaDaBIK app with many user groups is setting permissions for all of them when I create a new table or add a new field.

The new permissions templates are literally a time saver.

Let me give you an example, let's say you have three groups (IDs 1,2,3) and when you install a new table or add a new field you want to assign all the permissions to group 1, all the permissions except delete to group 2 and only read permissions to group 3; you can now add this to your config_custom file:

// group 1
// the values you see here (e.g. '111111') are a sequence of 6 numbers representing the table permissions (read, delet, edit, create, details, csv) and a sequence of 7 numbers representing the field permissions (results, edit, create, details, quick search, advanced search, csv)
$permissions_template['table_default'][1] = '111111'; // all the table permissions set to "1" means YES for all
$permissions_template['field_default'][1] = '1111111'; // all the field permissions set to "1" means YES for all

// group 2
$permissions_template['table_default'][2] = '101111'; // all the table permissions set to "1" except from the second (delete)
$permissions_template['field_default'][2] = '1111111'; // all the field permissions set to "1"

// group 3
$permissions_template['table_default'][3] = '100010'; // only read and details table permissions
$permissions_template['field_default'][3] = '1001010'; // only read, details and advanced search field permissions

That's it. Every time you add a new table or a new filed, these rules will be used by DaDaBIK to automatically set (granular) permissions.

And there's more! You can also set specific templates for specific tables, overriding the general rules, e.g. let's say you want to follow a different rule only for the fields you will add to the table "customers" and only for group 2 the edit must be disabled; this is the template rule you will add:

$permissions_template['field']['customers'][2] = '1011111'; // all the field permissions set to "1" except from edit

You can read all the details in the documentation; you'll find a new chapter dedicated to permissions templates. I think this is a huge improvement.

Warning for unsaved data
I guess it happened to some of your users: they modify a record, then they click somewhere (maybe they just want to sort the grid of a master/details form) before clicking save and they lost their changes.
Now DaDaBIK warns you if you are leaving the page with unsaved data. You can enable/disable this feature separately for edit and create forms. Since it is still an experimental feature, it is disabled by default.

Permissions Templates are available for DaDaBIK Enterprise and Platinum only, warnings for unsaved data also for DaDaBIK Pro.


There are also other changes and several bugs fixed so as usual I suggest to have a look at the change log.

You can buy your new license here.

You can upgrade your existing license (for free, if you are in your free upgrade period) here.

Best,
--
Eugenio Tacchini
DaDaBIK Founder