Nubuilder 4.5

Questions related to using nuBuilder Forte.

Nubuilder 4.5

Postby miasoft » Sat Jan 09, 2021 4:56 pm

i have updated version to 4.5.
There are a lot of useful features. Great job! Tnx!
miasoft
 
Posts: 17
Joined: Wed Dec 23, 2020 8:58 pm

Re: Nubuilder 4.5

Postby kev1n » Sat Jan 09, 2021 5:55 pm

Thanks miasoft !
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (85)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
nuBuilder Team
 
Posts: 1193
Joined: Mon Oct 15, 2018 2:13 am

Re: Nubuilder 4.5

Postby apmuthu » Sun Jan 10, 2021 12:10 am

@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:
Code: Select all
return $o[$k] ?? $d;

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.
Attachments
nudb_4.0.10.17.png
phpMyAdmin v4.0.10.17 versions of Server, PHP, client, webserver listed
nudb_4.0.10.17.png (11.34 KiB) Viewed 106 times
config.inc.php.zip
For use with nudb (phpMyAdmin) 4.0.10.17
(1.96 KiB) Downloaded 1 time
apmuthu
 
Posts: 114
Joined: Sun Dec 06, 2020 3:20 pm
Location: Chennai, India, Singapore

Re: Nubuilder 4.5

Postby kev1n » Sun Jan 10, 2021 3:52 pm

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.
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (85)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
nuBuilder Team
 
Posts: 1193
Joined: Mon Oct 15, 2018 2:13 am

Re: Nubuilder 4.5

Postby apmuthu » Mon Jan 11, 2021 1:04 am

@kev1n: Thanks. Your commit does it.

Also use 1 INSERTstatement for each language in nubuilder4.sql.

Please re-release the v4.5.
apmuthu
 
Posts: 114
Joined: Sun Dec 06, 2020 3:20 pm
Location: Chennai, India, Singapore

Re: Nubuilder 4.5

Postby kev1n » Mon Jan 11, 2021 1:30 am

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
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (85)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
nuBuilder Team
 
Posts: 1193
Joined: Mon Oct 15, 2018 2:13 am

Re: Nubuilder 4.5

Postby apmuthu » Mon Jan 11, 2021 1:45 am

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.
apmuthu
 
Posts: 114
Joined: Sun Dec 06, 2020 3:20 pm
Location: Chennai, India, Singapore

Re: Nubuilder 4.5

Postby apmuthu » Mon Jan 11, 2021 6:52 am

Attached are the changed files in dev v4.5 as of commit #267 replacing every leading 4 spaces with tab character
Attachments
NuB45_cleaned_up.zip
Updated to address 1,2,3 and 4 leading spaces.
(387 KiB) Downloaded 1 time
apmuthu
 
Posts: 114
Joined: Sun Dec 06, 2020 3:20 pm
Location: Chennai, India, Singapore

Re: Nubuilder 4.5

Postby apmuthu » Mon Jan 11, 2021 6:43 pm

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;
Attachments
DuplicateGermanTranslations.png
DuplicateGermanTranslations.png (22.14 KiB) Viewed 53 times
apmuthu
 
Posts: 114
Joined: Sun Dec 06, 2020 3:20 pm
Location: Chennai, India, Singapore

Re: Nubuilder 4.5

Postby apmuthu » Mon Jan 11, 2021 7:28 pm

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.
Attachments
Russian_Font_Weight_in_NuB45.png
Russian_Font_Weight_in_NuB45.png (3.1 KiB) Viewed 49 times
apmuthu
 
Posts: 114
Joined: Sun Dec 06, 2020 3:20 pm
Location: Chennai, India, Singapore

Next

Return to General



cron