Harald Eilertsen
cbd208eea3
Remove use of NULL_DATE constant in core
...
The NULL_DATE constant is defined conditionally in the DBA static class.
This causes issues with static analyzing tools like PHPStan, because
they can not really know if the constant is defined or not.
We could make PHPStan ignore this, but since there already is a
`get_null_date()` method on the `dba_driver` class, this patch
changes the code to use this method instead.
We could also use the public static attribute `$null_date` on the DBA
class directly, but using a method feels cleaner, and allows for making
the attribute private, or even removing it completely at some later
time.
I'm not removing the NULL_DATE constant for now, in case it is in use by
any extensions.
2026-03-07 11:15:46 +01:00
Harald Eilertsen
738797467d
Turn dba_driver params into attributes
...
To allow for inspecting the params used to connect to the database, we
now save the params in the dba_driver object instance as readonly
attributes. An exception is made to the $pass parameter which is set to
protected access, to make it slightly harder to accidentally leak it.
Project......: Performance Profiling
Sponsored-by.: NLnet NGI0 Commons Fund
2026-02-23 21:20:52 +01:00
Mario Vavti
2bab7e2693
prevent duplicate definitions
2023-04-13 18:51:13 +02:00
Mario
35877b1382
allow to override the DB charset via the $db_charset variable in .htconfig.php
2022-02-10 18:57:44 +00:00
Hilmar R
c26dede97f
get dev
2021-03-01 18:48:11 +01:00
Mario
cbaf4b7536
introduce db_str_to_date()
2020-01-18 20:00:37 +00:00
Mario Vavti
fbe8d6144a
port db_indexes() from zap
2019-05-13 10:46:12 +02:00
Andrew Manning
108a892a11
Remove DNS check for database connection during installation. Causes friction with Docker deployment.
2018-11-09 05:31:55 -05:00
Mario Vavti
5c4fbbebe1
refine stream filter and forum notification behaviour (mostly for performance). personal posts will be displayed in unthreaded mode and clicking a forum notification will show only the unseen items of the forum in unthreaded mode. group the filters in the widget - threaded at the top, unthreaded beneath.
2018-10-24 20:58:25 +02:00
zotlabs
cd200ee706
The channel import page seems to have missed the big theme cleanup of the last couple of years.
2018-05-01 19:38:32 -07:00
Klaus Weidenbach
509844fd7e
🔥 Cleanup old database related files.
...
Remove non used database drivers, remove unused methods.
Improve documentation.
2018-01-28 23:02:15 +01:00
Mario Vavti
a86b260f73
query optimisations for notifications - use a specific index only
2018-01-28 12:09:47 +01:00
zotlabs
2d119c81a4
turn platform name and std_version into config variables
2017-07-13 20:18:19 -07:00
zotlabs
6c771f84ce
remove unused page_widgets.php include and provide a general function for loading sql from file to use in the cdav migration
2017-06-22 22:43:08 -07:00
zotlabs
3a00140797
remove php version checks for older ( < 5.4) code incompatibilities
2017-05-23 21:20:40 -07:00
Mario Vavti
a44c908147
silence php warning during install
2017-05-17 11:24:27 +02:00
zotlabs
33ff7bf968
provide platform specific install script
2017-03-31 10:27:28 +02:00
zotlabs
6cf17c7bcc
use array_shift - it's cleaner
2016-12-15 16:41:01 -08:00
zotlabs
793047919d
missed this from the earlier checkin
2016-11-29 02:57:29 -08:00
zotlabs
88a68b941f
put all dns checking into one function, allow it to be ignored
2016-10-25 18:27:32 -07:00
zotlabs
084b41fc2c
first cut at edit activities
2016-10-25 16:21:56 -07:00
zotlabs
25982f0475
set port if non-zero (instead of non-null)
2016-10-24 18:55:11 -07:00
zotlabs
d30892ea60
pdo hacks
2016-10-23 17:05:08 -07:00
zotlabs
04ac04e0ad
allow a dsn override to the database via the server argument. This could be used to allow unix domain sockets and other unusual configurations.
2016-10-20 17:04:43 -07:00
zotlabs
29340152b6
pdo - cleanup
2016-10-20 16:21:15 -07:00
zotlabs
b4b5eb5bab
pdo testing
2016-10-20 15:45:48 -07:00
zotlabs
3726b546d5
use pdo for postgres also
2016-10-19 19:24:12 -07:00
zotlabs
2702b82bc3
pdo fixes
2016-10-19 17:23:06 -07:00
zotlabs
aee4f8d2fe
pdo changes first cut
2016-10-19 16:58:26 -07:00
zotlabs
716a83d1f7
some pdo work
2016-10-17 16:12:32 -07:00
zotlabs
6532972e61
additional array checking
2016-10-13 00:30:41 -07:00
zotlabs
9bb847bb07
remove the rest of the backticks from sql queries; replace with TQUOT const which is driver dependent
2016-10-12 18:15:12 -07:00
Mario Vavti
ffee413d2d
fix dbescdate()
2016-09-28 12:43:02 +02:00
redmatrix
44a2cc872c
apply the same fix to our own DB as we did for hubzilla master and redmatrix.
2016-09-26 19:28:04 -07:00
redmatrix
cacdac16aa
next wave of nulldate fixes
2016-09-26 18:16:43 -07:00
redmatrix
d3369384d1
include port in pdo url when host is 'localhost'
2016-08-23 18:18:05 -07:00
redmatrix
1267d995ef
db statement debugging
2016-06-22 19:08:59 -07:00
redmatrix
00b4843425
provide a sort of mutex lock around db logging so it can't possibly recurse. Previous attempts to do something similar using other methods haven't worked out satisfactorily.
2016-05-31 16:16:54 -07:00
redmatrix
516c43ba15
more work associated with DBA and index.php shuffle
2016-05-24 17:54:45 -07:00
redmatrix
84ba6393ad
relocate index and db
2016-05-24 16:36:55 -07:00
redmatrix
3355210878
explain what we're doing and where we're going with this.
2016-05-18 22:03:43 -07:00
redmatrix
16f79b70e4
experimental PDO DBA driver
2016-05-17 22:32:49 -07:00
redmatrix
217db8f9b2
provide tools to extract a pdo constructor
2016-05-15 19:16:55 -07:00
redmatrix
6f486a3393
prevent recursion in the database driver when debugging is enabled and the system config is not yet loaded - caused by calling get_config and making db calls within the logger function; which we then attempt to log...
2016-05-09 01:12:24 -07:00
redmatrix
d62f490814
Setup was horked after this commit and I couldn't easily make it right so reverting - will try again at a future date
...
Revert "remove global db variable"
This reverts commit c3b0c0f32a
2016-04-25 20:12:36 -07:00
redmatrix
c3b0c0f32a
remove global db variable
2016-04-25 16:55:33 -07:00
redmatrix
9debfa348a
add syslog loglevels to dba functions
2016-03-07 20:43:52 -08:00
redmatrix
91801d2e2c
rev update
2016-02-10 13:55:51 -08:00
redmatrix
167e754a1b
issue #184
2015-11-23 15:17:38 -08:00
Klaus Weidenbach
124b17dcf4
Some cleanups.
...
Fixed dbesc_identifier(), but it is not used yet.
Corrected some other variable names and variable initialization before
using them.
2015-03-13 00:36:32 +01:00
