Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Chen Zhen

1

I tested the mod on SMF 2.0.15 and SMF 2.0.17 whereas there are no issues with the installer.
You must have some modification installed that altered code in that file.
I suggest you uninstall any bbcode modification prior to installing SMF patches and/or this modification.



This mod has been updated yet again.
Please refer to this thread for version 1.6:
https://web-develop.ca/index.php?topic=481.0

Thread has been locked.
2
SMF 2.0 - Enable PHP7.2+ Compatibility version 1.5
Version 1.6 released February 25/2020.

Copyright 2020 ~ Chen Zhen @ web-develop.ca
Distributed under the GNU Lesser General Public License -> https://www.gnu.org/licenses/lgpl.html

This version includes a new copyright policy,fixes & omissions for SMF 2.0.17+ to facilitate proper PHP 7.2+ compatibility.

A new option has been implemented located in admin core features to enable/disable filtering "create_function" warnings.
SMF 2.0.17 default behavior is to strictly mute any "create_function()" deprecated warnings.
The purpose of this newer feature is for possibly debugging warnings created by other modifications although the default behavior can still be opted.




Note:
If you are updating SMF itself from version 2.0.15 to version 2.0.16 using available patches, you must first uninstall this modification tool.
After you have successfully upgraded to SMF 2.0.17 (without errors), you can then opt to install this modification (version 1.6 or better).
Failing to follow this procedure will cause both the SMF patches & this modification to be incapable of parsing your files properly.





Still pending:
Changes to ../Sources/Subs-Db-sqlite.php to replace sqlite_create_function with modern standard.
ie. PDO::sqliteCreateFunction or SQLite3::createFunction





Please uninstall and delete any previous versions prior to using this version.
Report any issues with this modification in this thread.

Enjoy.


Available from the download section.

DOWNLOAD MODIFICATION
3
You will not be able to install the SMF update patches with v1.4 of this mod without errors.

Make sure this mod is uninstalled, then update SMF with the patches.
After you are at SMF 2.0.17 then you can install v1.5 of this mod.
4
I will test it on SMF 2.0.15 later today. It should work but perhaps I made an error in the pkg info install file.

Why not update to SMF 2.0.17 ?
5
SMF 2.0 - Enable PHP7.2+ Compatibility version 1.5
Version 1.5 released February 24/2020.

This update includes fixes & omissions for SMF 2.0.17+ to facilitate proper PHP 7.2+ compatibility.

Still pending:
Changes to ../Sources/Subs-Db-sqlite.php to replace sqlite_create_function with modern standard.
ie. PDO::sqliteCreateFunction or SQLite3::createFunction





Please uninstall and delete any previous versions prior to using this version.
Report any issues with this modification in this thread.

Enjoy.


Available from the download section.

DOWNLOAD MODIFICATION
6
Thanks for the report.
Version 1.4 was deleted in error at some point.

Version 1.5 is now available which will work for SMF 2.0.17 (or a few versions previous to that).

This thread has been locked.
7
EhPortal Support / Re: Portal for SMF 2.0.17
February 22, 2020, 12:32:32 pm
I did not read the topic properly nor notice the section and initially replied on my phone/mobile & missed that somehow.
Somehow I thought you were having trouble installing Simple Portal into SMF 2.0.17  :-[

Btw - Eh Portal is only for the SMF 2.1 branch
Simple Portal is for the SMF 2.0 branch.

You can not use EhPortal for SMF 2.0.17.
When you finally upgrade to the SMF 2.1 branch then you can switch to EhPortal which is a port of Simple Portal.
This means all the blocks and like settings from your older Simple Portal will remain.
8
EhPortal Support / Re: Portal for SMF 2.0.17
February 19, 2020, 04:22:37 pm

Make sure you download it anew from the Simple Portal website & try again.
Do not use an older file on your computer or in your Packages directory.
9
EhPortal Support / Re: Portal for SMF 2.0.17
February 17, 2020, 07:18:35 pm
Simple Portal will work for SMF 2.0.17

I just tested it on an installation of SMF 2.0.17 and there does not seem to be any issue.
It installs & uninstalls fine.

What is the problem you are having?
10

Version 2.3 is now available from the download link.
The mod will occasionally refresh the page during database changes to thwart PHP timeouts.

Also for the more thorough character conversion option it now only edits field columns that need editing and ignores those that don't need any changes.
11

I'll provide that after I finish the next update.

At the moment the download link only provides v2.0 because I discovered some issues with v2.2 that I am working on.

Large tables ie. messages for some forums which contains posts, needs the script to refresh the page and continue after X number of queries else PHP will time out. I am working on this so that it will work with a large amount of queries.
12

If their mixed collations are all utf8 or all utf8mb4 then it should work just fine.
I've not tested mixed iso & utf8 tables as of yet.

One can always make backups first and then try it out.
Another option is to first try the SMF built in function to convert to utf8.
After that, run this utility to convert all collations to utf8.
13
SMF Database -> Uniform collation, character set & engine type settings utility

This tool will allow you to opt your default database settings for common configurations.
The new settings options will be available in your Admin Maintenance section.
It will adjust all tables & columns to match.

This Simple Machines Forum Database Tool c/o Chen Zhen @ https://web-develop.ca
Copyright 2020 Chen Zhen
SMF DB Uniform Collation & Engine is distributed under the terms of the GNU General Public License

Please remember to backup your database prior to using this tool.
UTF8 or UTF8MB4 collation and character sets are available.

The TEXT & VARCHAR conversion is available to convert the actual text in those type of database fields to UTF-8.
This will likely be necessary for either UTF8 OR UTF8MB4.
There is also an option to convert any UTF8MB4 emojis to their UTF8 equivalents if opting a UTF8 database setting.

Note regarding databases converted to UTF8MB4: TEXT and MEDIUMTEXT fields will remain and will not be downgraded when converting to UTF8.


Disclaimer:

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.



Version 2.3
! fixed utf8 character conversion sub-routine
! fixed namespace declaration to beginning of file
! fixed login cookie will not timeout amidst database changes

Version 2.2
+ added option to convert utf8mb4 emoji to utf8 character codes
+& admin button names altered to shorter format
+& utf8mb4 optional conversion added
+ all tables are repaired & optimized after changes

Version 2.1
+ added option to convert TEXT & BLOB to UTF-8
! removed single problematic collation
! fixed save button in Uniform Collations admin

Version 2.0
+& added settings template to SMF maintenance admin section
+& added drop-down to opt collation setting
+ restricted setting to utf8 or utf8mb4


Version 1.2
+ changes made to use more native/inherent SMF database query syntax

Version 1.1
! collation & character set now based on overall database setting
? previous query did not work for database designations containing hyphens

Version 1.0
+ initial release
+ sets collation & character set for all tables to be uniform

CLICK HERE TO DOWNLOAD UNIFORM COLLATIONS
14
Releases & Version Updates / Zhen Mailer version 1.3
January 25, 2020, 04:12:25 pm

Zhen Mailer

Version 1.3


Notations:

This version concerns major changes and bug fixes.

Zhen Mailer is no longer restricted to SMTP email usage.
People using regular PHP mail may now take advantage of this utility.
If you operate a VPS or dedicated server and need help installing any of the requirements, please feel free to leave a post in the forum.


Branch differences:
SMF 2.1 offers a bit more flexibility due to its structure and use of more hooks compared to the SMF 2.0 branch.
Multiple emailed attachments from a single post in the SMF 2.1 branch will be sent as one email.
SMTP usage is no longer mandatory for this utility as it now supports regular PHP email.

However for the SMF 2.0 branch, it will send an email for each attachment even if all of them are from a single post.
SMTP-STARTTLS support is added for this branch as it is not normally available in SMF 2.0.X.
SMTP usage is no longer mandatory for this utility as it now supports regular PHP email.


Zhen Mailer Admin Setting ~ Admin/User ID To Send DB Dumps
Be careful when adding an additional user email address to the sent database and/or attachment emails.
Ensure that the extra email address is one that should be receiving those emails (ie. an admin)


This installation process will add the following:

-> Database dumps that are forwarded to the webmaster email and/or an additional admin email.
-> Attachment backups to the webmaster email and/or an additional admin email as they are posted
-> STARTTLS-SMTP compatibility for use of 3rd party email providers (not necessary when using a properly configured PHP mail transfer client)
-> Options to encrypt any email attachments as compressed zip archives (requires PHP 7.2+ & ZipArchive)

Compatibility notes:
- PHP version 5.5 with the openssl PHP extension enabled is the minimum requirement for STARTTLS-SMTP compatibility
- ZipArchive extension is required for compression of any attachment backups
- PHP version 7.2+ with the ZipArchive extension is required for any archive encryption
- cURL extension is required for the scheduled database dumps option

This will allow your forum to use SMTP email using gmail, hotmail or yahoo mail.
PHP version 7.2+, ZipArchive & cURL extensions are recommended to make full use of this modification.

Updated CA certificates are required for your forum to communicate with email providers using the STARTTLS SMTP extension.
Example settings for your php.ini file may be:
openssl.cafile = /etc/ssl/cacert.pem
curl.cainfo = /etc/ssl/cacert.pem

You can download the latest cacert.pem file here:
https://curl.haxx.se/ca/cacert.pem

Notes:
Although it is not mandatory, a mail user named "members" should be created for BCC bulk emails.
SMTP port 587 is recommended.


Zhen Mailer for Simple Machines Forum
c/o Chen Zhen @ web-develop.ca
@license  http://www.gnu.org/copyleft/lesser.html GNU Lesser General Public License
@copyright 2020 Chen Zhen

3rd Party Usage:
PHPMailer - PHP email creation and transport class.
@license  http://www.gnu.org/copyleft/lesser.html GNU Lesser General Public License
@author    Marcus Bointon (Synchro/coolbru) <phpmailer@synchromedia.co.uk>
@copyright 2012 - 2017 Marcus Bointon

Shuttle-Export c/o 2createStudio
PHP based MySQL dump library
@license  http://www.gnu.org/copyleft/lesser.html GNU Lesser General Public License
@copyright 2015 - 2017 2createStudio

Distributed under the GNU Lesser General Public License -> https://www.gnu.org/licenses/lgpl.html

CLICK HERE TO DOWNLOAD ZHEN MAILER
15

Welcome to Webdev, Dankirk.

The SMF devs probably thought it would be best to come up with a solution that would allow any installed mods to also circumvent the PHP warnings. 

For those that still want to have all occurrences of create_function omitted, I will work on an updated release for SMF 2.0.16+.