mirror/php-e107
1
0
Fork 0
mirror of https://github.com/e107inc/e107.git synced 2025-07-30 03:10:50 +02:00
Code Issues Releases Wiki Activity
14,374 Commits 2 Branches 22 Tags
master
Commit Graph

72 Commits

Author SHA1 Message Date
armpit
e30c373203 Add missing comma in 'admin_log' schema. 2025-05-11 21:24:31 -05:00
camer0n
218d0a5afc Issue #5490 Incorrect ALTER query created on index. Indexes added to admin_log for speed. 2025-05-06 18:08:52 -07:00
camer0n
d542936384 Issue #5382 - Avoid table schema mismatch 2025-04-14 10:42:48 -07:00
Nick Liu
639a367ed6 fix(core_sql.php): admin_history: MariaDB does not have the JSON type 2025-03-30 16:29:11 -05:00
camer0n
10ed5f8c95 Issue #5382 History/Revert changes. 2025-02-06 12:23:49 -08:00
camer0n
73d4e28040 Issue #5382 Database change logging for Admin-UI. More to come.. 2025-02-05 16:22:03 -08:00
Nick Liu
6ed8377b0e #5209: Add full-text indexes to table comments 
`e107_handlers/search/search_comment.php` hasn't been migrated to
e107 v2 standards yet, so we forgot to add indexes of the search
fields specified here:
a3c04d6b1d/e107_handlers/search/search_comment.php (L67)
 2025-01-04 15:48:28 +01:00
camer0n
0b89d5d301 Issue #5209 - Partial fix. Currently does not support FULLTEXT on a field that already has an INDEX. 2025-01-03 16:02:38 -08:00
camer0n
b25e60888b Closes #5365 Image alt attribute management via Media Manager. Test added. 2024-12-19 13:17:32 -08:00
camer0n
a27b9de560 Fixes #5203 Plugin preference size limitation 2024-03-02 13:29:31 -08:00
camer0n
3d000c8dc3 Issue #4501 - Improve verification and cron table engine. 2023-12-05 16:05:56 -08:00
Nick Liu
d790faa049 Convert and run e107 using the MySQL/MariaDB utf8mb4 character set and 
InnoDB storage engine

Components affected:
* `db_verify` now checks and corrects the table storage engine
* `db_verify` now checks and corrects the table default character set
  * Note: Field character sets can still be overridden
  * Note: When correcting, the entire table is converted to the target
    charset.
* The alt_auth plugin now connects via PDO using the e107 default
  charset, utf8mb4
* `e_db_pdo` now sets the charset to utf8mb4. This is currently not
  customizable because it was previously not customizable.
* `install.php` now generates an `e107_config.php` file with
  `$mySQLcharset = 'utf8mb4';`, though this option is not actually used.
* `install.php` now removes plugin tables before installing plugins.
* `e_db_mysql` now only accepts the `utf8mb4` charset. Previously, it
  only accepted the `utf8` charset.
* `e_db_mysql` now configures `mysqli_real_escape_string` to match the
  new default charset, `utf8mb4`.
* Plugin installations now use the preferred MySQL table storage engines
  and charsets.

The preferred MySQL table storage engines are now mapped like so:
* If `ENGINE=MyISAM` is specified, the actual storage engine set will be
  the first available of: InnoDB, Aria, Maria, MyISAM
* If `ENGINE=Aria` is specified, the actual storage engine set will be
  the first available of: Aria, Maria, MyISAM
* If `ENGINE=InnoDB` is specified, the actual storage engine set will be
  the first available of: InnoDB, XtraDB
* If `ENGINE=XtraDB` is specified, the actual storage engine set will be
  the first available of: XtraDB, InnoDB

The preferred MySQL character set is now aliased like so:
* `utf8`    => `utf8mb4`
* `utf8mb3` => `utf8mb3`
* `utf8mb4` => `utf8mb4`

Fixes: #4501
 2021-05-22 00:46:35 -05:00
Cameron
c494c04c7e Fixes #4806 - news keyword maxlength limitation fix. 2022-06-30 19:01:52 -07:00
Cameron
52cf8f5bfa Closes #4783 Added Page Meta-Title field and synced with Page title. 
Issue #6 global LAN_META_DESCRIPTION and LAN_META_TITLE added and replacements made throughout.
 2022-06-08 18:29:37 -07:00
Cameron
94bf1efda2 Issue #4783 Added new field for meta-news-title. New prefs added for SEO Title and Description character limits. 2022-06-06 17:28:23 -07:00
Cameron
057cc8e35b Closes #4702 - Added news_modified field. 2022-03-14 14:03:34 -07:00
Cameron
c7dc227e24 Merge pull request #4575 from Deltik/fix/4574 
Add index to database session handler for session expiry
 2021-09-27 10:30:06 -07:00
Cameron
66d8081580 Added new field to navigation links table: link_rel 2021-09-27 10:22:14 -07:00
Nick Liu
54ed823aba Add index to database session handler for session expiry 
Greatly improves garbage collection performance

Fixes: #4574
 2021-09-25 15:15:33 -05:00
Cameron
45bb6c2f35 Custom meta-image option added to Pages. 2021-09-23 12:01:26 -07:00
Cameron
f8f40a23fe Missing page-subtitle field added. 2021-01-04 12:48:37 -08:00
Cameron
07f92d92cc Issue #4207 - SQL Insert error 2020-07-03 12:30:30 -07:00
Cameron
99016f5b4a Fix for error: session_start(): Failed to decode session object under some circumstances when 'db' method is used. 
'session' set as default user tracking.
 2020-07-01 13:02:58 -07:00
Cameron
560f290ae4 Avoid session table creation issue on some servers. (ie. "Specified key was too long; max key length is 1000 bytes" ) 2020-06-08 10:00:36 -07:00
Cameron
7439d599f8 Issue #4176 - Incremental introduction of database sessions - Experimental (work in progress) 2020-06-02 13:43:21 -07:00
Cameron
6c242729b9 Closes #4107 - hide email by default when creating a new user. 2020-03-20 07:54:56 -07:00
Cameron
5cf54d07d2 Basic per-item search engine robots handling added to News and Pages. 2019-12-02 13:32:21 -08:00
Cameron
ce7f3feb38 PDO class now used by default. mysql_class.php currently deprecated until it is modified to use mysqli. Install routine upgraded. Install logging vastly improved. 2019-06-03 15:27:36 -07:00
Cameron
9a44513c91 Fixes #3812 - Page insert failure in PHP 7.3 2019-05-23 11:13:42 -07:00
Deltik
1f824faa69 Renormalized all text file line endings 2019-03-29 19:13:32 -05:00
Lóna Lore
8ff0f36077 Possible fix for issue #2860. 2017-12-09 21:10:33 +01:00
Lóna Lore
865c3f7c98 Possible fix for Issue #2860 - Add more indexes. 2017-11-14 21:14:43 +01:00
Cameron
2a37288dc7 Book/Chapter image field added. 2017-11-10 14:06:30 -08:00
Cameron
36a087f1ce Fixes #2805 - News table update correction. 2017-10-10 13:04:07 -07:00
Cameron
18ea662b35 Fixes #2805 - Database News-table upgrade issue. 2017-10-09 08:40:36 -07:00
Cameron
229f0486aa Issue #2000 Enable news category to determine news category default template. Admin area completed. Frontend still to come. 2017-09-28 09:35:56 -07:00
Cameron
13d58de464 Issue #2795 Support multiple news 'view' layouts (requires database update) 2017-09-23 14:08:47 -07:00
Cameron
4b443bc2c8 Experimental Feature: Page/Menu custom fields. Enable debug to experiment. Usage: {CPAGEFIELD: name=xxxxx} where 'name' is the field name. Currently only functions in edit mode when the chapter is already set. 2017-01-18 17:10:12 -08:00
Lóna Lore
04cf3a6dc2 Updated Timezone EUF. Use user-defined timezone as default date timezone, if it's possible. 2016-12-13 20:48:45 +01:00
Cameron
bba40d458c SubmitNews: Added USERID to table. 2016-08-30 14:20:38 -07:00
Cameron
15ac53c601 Issue #1796 - Submit news enhancements ToDo: preferences for input items. 2016-08-11 18:00:50 -07:00
Cameron
2116805fe7 Increased user_image field to 255 chars to avoid issues with external URLs. 2016-06-23 11:07:54 -07:00
Cameron
127271e9fc Issue #595 - Use PHP 5.5+ password methods when available. User password field expanded to 255 chars. Fixes issue with salt password being updated via User > Edit User. 2016-06-06 19:54:48 -07:00
Cameron
e1414cb688 Submitnews Image import fix. Upload page now using e_upload.php. Upload admin area still needs work. 2016-03-06 17:42:47 -08:00
Cameron
e2fab78302 Online handler now records language 2015-11-18 20:28:41 -08:00
Cameron
e5ea9d689d Fixes database upgrade routines for v2.0+. Fixes #1231 (tablet navigation). Adds extra DB fields for future use. 2015-11-18 20:22:18 -08:00
Cameron
c0a62c16c7 Fix for lengthy "news_extended" content. Admin-UI: $fields 'type' of false will hide the field, but still save it if posted. 2015-10-23 11:48:24 -07:00
Cameron
d5388e7313 Increment bootstrap version. Fix for bbarea width. 2015-04-18 15:09:56 -07:00
Cameron
6661eb28de Improved parent/child drag-n-drop sorting on custom-pages and forum. 2015-04-03 21:19:43 -07:00
Cameron
3cc97e1fb4 Blogger import improvements and news_title and news_body field size limitations removed. (DB Update Required) 2015-03-29 20:28:33 -07:00