Page 1 of 2
Nubuilder 4.5
Posted: Sat Jan 09, 2021 8:26 am
by miasoft
i have updated version to 4.5.
There are a lot of useful features. Great job! Tnx!
Re: Nubuilder 4.5
Posted: Sat Jan 09, 2021 9:25 am
by kev1n
Thanks miasoft !
Re: Nubuilder 4.5
Posted: Sat Jan 09, 2021 3:40 pm
by apmuthu
@kev1n: Good Job.
Two non
nudb files use the
Null coalescing (??) operator not available in pre
PHP 7 in
nubuilder 4.5.
The minimum requirements are stated to be
PHP 5.4.
Those using XAMPP v1.8.2.5 will have PHP 5.4.27.
These 2 files can be edited to work:
Change
core/nucommon.php at line 249:
replacing it with:
Code: Select all
return isset($o[$k]) ? $o[$k] : $d;
Change
nuform.php at line 1125:
Code: Select all
$formAndSessionData->filter = $_POST['nuFilter'] ?? null;
replacing it with:
Code: Select all
$formAndSessionData->filter = isset($_POST['nuFilter']) ? $_POST['nuFilter'] : null;
Wonder what replacing absence with null serves.
Replace the
core/libs/nudb v5.0.4 with
phpMyAdmin 4.0.10.17 and add in the attached
config.inc.php in
core/libs/nudb/ folder.
phpMyAdmin version is in the
core/libs/nudb/ChangeLog file.
Please note that the default database name in
nuconfig.php is still
nubuilder4 with
DBuser as
nuadmin and
DBPassword set as some text.
Re: Nubuilder 4.5
Posted: Sun Jan 10, 2021 7:22 am
by kev1n
apmuthu wrote:@kev1n: Good Job.
Two non
nudb files use the
Null coalescing (??) operator not available in pre
PHP 7 in
nubuilder 4.5.
The minimum requirements are stated to be
PHP 5.4.
Thanks, I replaced the Null coalescing operator.
Re: Nubuilder 4.5
Posted: Sun Jan 10, 2021 4:34 pm
by apmuthu
@kev1n: Thanks. Your
commit does it.
Also use 1
INSERTstatement for each language in
nubuilder4.sql.
Please re-release the v4.5.
Re: Nubuilder 4.5
Posted: Sun Jan 10, 2021 5:00 pm
by kev1n
apmuthu wrote:
Also use 1 INSERTstatement for each language in nubuilder4.sql.
nubuilder4.sql is generated automatically. I don't have much control over its creation.
What would be the advantage of having separate insert statements? If you don't want to have all languages in your db, run some post-installation scripts to remove them
Re: Nubuilder 4.5
Posted: Sun Jan 10, 2021 5:15 pm
by apmuthu
What is the process by which the nubuilder4.sql gets automatically created?
Having 1 insert per language can then allow for placing all language inserts in a separate lang folder and then selectively create the enduser nubuilder4.sql file with just the languages needed without any post install scripts. Mapping and managing translations would be easy for new language file creators.
Re: Nubuilder 4.5
Posted: Sun Jan 10, 2021 10:22 pm
by apmuthu
Attached are the changed files in dev v4.5 as of commit #267 replacing every leading 4 spaces with tab character
Re: Nubuilder 4.5
Posted: Mon Jan 11, 2021 10:13 am
by apmuthu
Duplicate German 3 Translations can be removed with:
Code: Select all
DELETE FROM zzzzsys_translate WHERE zzzzsys_translate_id IN (
'nu5ec114f2585bf45',
'nu5ec114f2586fae8',
'nu5fe60f1c6b83a52'
);
Choosing to retain the later ones, committed by @kev1n as
#268.
Identify duplicate strings with:
Code: Select all
SELECT trl_language, trl_english, COUNT(*) AS records FROM `zzzzsys_translate`
GROUP BY trl_language, trl_english HAVING records > 1;
Re: Nubuilder 4.5
Posted: Mon Jan 11, 2021 10:58 am
by apmuthu
There is a Russian language string translation required for the English string "Font Weight". The current v4.5 sql has the following:
Насыщенность шрифта
Размер шрифта
Many translation engines come up with:
Вес шрифта
Any native Russians, please contribute the preferred translation.