Streams/streams
Streams/streams
1
0
Fork 0
mirror of https://codeberg.org/streams/streams.git synced 2024-09-19 21:15:14 +00:00
Code Issues Projects Releases Packages Wiki Activity Actions
30779 commits 7 branches 30 tags 160 MiB
Commit graph

619 commits

Author SHA1 Message Date
zotlabs
9c05f37c0f update setup and install documents for PDO and the freebsd issue with 
dns_get_record()
 2016-10-27 19:02:27 -07:00
Florian Steinel
c1c96e01fa sql: limit 1 for UPDATE and DELETE is not supported by the SQL standard and postgresql 
(see: https://www.postgresql.org/message-id/flat/1291109101.26137.35.camel%40pcd12478 )
 2016-10-27 02:41:32 +02:00
zotlabs
6c7972470b if we have to go through this contortion every time we change a DB column from unsigned to signed... 2016-10-17 16:10:32 -07:00
zotlabs
40ce6724a9 "alter table alter" has completely different rules between postgres and mysql 2016-10-17 15:13:58 -07:00
zotlabs
5ea46444e9 issue #550 2016-10-16 00:29:51 -07:00
zotlabs
e314510005 minor 2016-10-12 20:41:59 -07:00
zotlabs
facc6ee6b3 allow hooks to have negative priority 2016-10-12 20:04:19 -07:00
redmatrix
71632ac2d2 issue #536, path to nginx and lighttpd config scripts was wrong 2016-09-27 22:04:52 -07:00
redmatrix
4663278f52 Merge branch 'nulldate' into dev 2016-09-26 18:17:38 -07:00
redmatrix
cacdac16aa next wave of nulldate fixes 2016-09-26 18:16:43 -07:00
redmatrix
24ddc8e026 issue #523 2016-09-22 17:00:32 -07:00
redmatrix
ec5cc08fab issue #521, add 'map' extension to files served natively by nginx without using the project controller 2016-09-21 15:47:18 -07:00
Mario Vavti
f55636bcb5 fix #514 2016-09-15 10:20:04 +02:00
redmatrix
7121d8e427 issue #511, postgres schema issues 2016-09-09 21:25:57 -07:00
redmatrix
c2f83639d4 provide version info in /pubsites 2016-09-07 17:36:45 -07:00
redmatrix
ea0be8ea1a provide techlevels in the pro server role. Should have no visible effect on other roles. 2016-08-31 17:49:22 -07:00
redmatrix
1e6a491400 change default server role 2016-08-22 19:45:21 -07:00
redmatrix
5243dd153b use config system.server_role and deprecate 'UNO' 2016-08-07 17:29:35 -07:00
redmatrix
b63165b6e0 more perms work (a lot more) 2016-07-18 21:37:34 -07:00
redmatrix
de4f9d68bd Merge branch 'dev' into perms 2016-07-17 21:40:04 -07:00
redmatrix
d660bde324 missing brace 2016-07-14 20:53:38 -07:00
redmatrix
94bd53c0f1 schema updates for zot access tokens 2016-07-14 20:51:15 -07:00
redmatrix
6424bac47c Merge branch 'dev' into perms 2016-07-12 20:50:27 -07:00
redmatrix
b6987b4287 the abconfig defaults weren't changed in the schema files when they were changed in the code 2016-07-12 13:15:20 -07:00
redmatrix
917a465ccd more work on perms 2016-07-09 19:03:29 -07:00
redmatrix
e11330a5c8 revise how we store perm_limits 2016-07-07 16:44:58 -07:00
redmatrix
6bf2e8a108 some perms fixes to stuff that was already written before I move on 2016-07-04 16:30:03 -07:00
redmatrix
916e088462 make permissionlimits into a class 2016-07-03 18:20:15 -07:00
redmatrix
c918bbba25 more work on x permissions 2016-07-03 17:10:00 -07:00
Habeas Codice
f40f7b4d6e typos 2016-06-27 16:06:09 -07:00
redmatrix
51e2ef39c2 db update for abconfig transition 2016-06-23 18:35:01 -07:00
redmatrix
dbb0a0283f schema changes needed for the caldav client bit 2016-06-18 15:33:47 -07:00
redmatrix
1e68d4fb75 deprecate the item_id table - replace with iconfig. A possibly useful function in the iconfig class would be a search which takes a service id and type and uid, matches against an item and returns the iid. That could save a bit of code duplication. 2016-06-13 19:58:24 -07:00
redmatrix
05d9e1bee5 check all return values 2016-06-01 22:05:17 -07:00
redmatrix
a9d7acda27 the rest of the schema updates - WARNING: some third party plugins may fail; e.g. embedphotos and chess. $item['object'] is now $item['obj'] and $photo['type'] is $photo['mimetype'], $photo['scale'] is $photo['imgscale'] and $photo['data'] is now $photo['content']. There are a number of other changes, but these are the ones noted to cause issues with third-party plugins. The project plugins have been updated. Please note any new issues as this effort touched a lot of code in a lot of files. 2016-06-01 21:48:54 -07:00
redmatrix
b1259876bf more db column renames 2016-05-31 21:45:33 -07:00
redmatrix
dfb6255f59 more removal of reserved words from DB schemas 2016-05-31 17:50:47 -07:00
redmatrix
ca78374f30 remove unused tables 2016-05-30 22:41:45 -07:00
redmatrix
6602ff83dd start removing reserved words from database column names (this run: addon and hook) 2016-05-30 19:44:30 -07:00
redmatrix
3b2679db29 fix remote_channel(), update php minversion requirement 2016-05-29 18:38:24 -07:00
redmatrix
ac4688eac0 allow objs to represent inventory 2016-05-27 23:57:47 -07:00
redmatrix
096fdfc61b consolidate all the sys_boot functionality that is common between the web server and the cli daemon manager. Get rid of yet another global variable ($default_timezone) whilst doing so. 2016-05-26 16:33:01 -07:00
redmatrix
7b91e551c4 kill off mcrypt 2016-05-26 13:21:43 -07:00
redmatrix
3aa6e96904 update the installation text for the cron setup 2016-05-19 22:59:25 -07:00
redmatrix
3df0bb5522 some preliminary structural work for app organisation 2016-05-03 18:41:16 -07:00
redmatrix
bd2f11ed8b db schema change to add tags to content sources 2016-05-01 21:00:02 -07:00
redmatrix
1ff189ee90 new hook interface (the old one still works but requires handlers to have two calling arguments; the first of which is no longer used). The new interface is called from Zotlabs\Extend\Hook::register() and allows you to specify which hook version to use. The default will be the new interface with one function argument. We also implement the hook priority field which was always there but needed to be set manually in the DB. This provides a way for two hook handlers that implement the same hook interface to determine which order to be called in the event of conflicts. 2016-04-21 17:03:05 -07:00
redmatrix
c0bdcfedeb log if the session handler fails and surface the ssl_cookie config setting 2016-04-08 05:10:36 -07:00
redmatrix
9abd95fad3 static App 2016-03-31 16:06:03 -07:00
redmatrix
32c23ef562 some minor cleanups 2016-03-10 15:43:59 -08:00
Peter Hormanns
7edc505c2f fix typo in postgres schema 2016-03-01 17:54:52 +01:00
redmatrix
be2b7c0b5f abconfig 2016-02-29 19:31:52 -08:00
redmatrix
6300f47cdc schema change to support channel move (a completely different operation than channel clone) 2016-02-24 17:00:16 -08:00
Bob Mottram
29c9e7c0a2 Remove stray comma 2016-02-23 19:50:45 +00:00
redmatrix
76bf892f9f iconfig - add sharing variable 2016-02-18 00:20:08 -08:00
redmatrix
4da7fcb41d schema updates for iconfig 2016-02-17 16:24:26 -08:00
Jeroen van Riet Paap
d04aef4c44 don't confuse people with matrix 2016-02-12 17:17:26 +01:00
redmatrix
a14b87baf2 make yet another recommended security header optional - this time because of piwik. Personally I think if you want to track people you really don't understand this project and its history, but whatever.... 2016-02-08 14:48:11 -08:00
redmatrix
9cf105f8ea initial uno config 2016-02-04 23:58:31 -08:00
Jeroen van Riet Paap
08fbe17627 no trailing slash 
it will break your system
 2016-01-27 23:40:33 +01:00
redmatrix
48495f41e8 provide mechanism for custom .well-known handlers and static files (e.g. for letsencypt ownership verification). Document that if you create a .well-known directory to validate a letsencrypt cert you need to remove it before installing hubzilla. We probably need a check for this in the install checklist. 2016-01-22 02:22:27 -08:00
redmatrix
a076a248bf add db_type to sample htconfig 2016-01-18 14:47:16 -08:00
redmatrix
961540160f cleanup text in INSTALL.txt 2016-01-12 20:05:16 -08:00
redmatrix
2aa3acae6b remove deprecated table 2015-12-15 19:46:24 -08:00
jeroenpraat
7244dfce1d Typos 2015-12-12 17:32:29 +01:00
jeroenpraat
fb5ac37ca2 That script is taken from someone else without any contribution (http://blog.strictly-software.com/2013/07/apache-performance-tuning-bash-script.html). Also the English is very bad. Anyway, I've replaced it with some general tips that all web admins should know. 2015-12-12 17:30:02 +01:00
royalterra
4633273279 Update INSTALL.txt 
Add Link to ApacheTune for configure mod Prefork
 2015-12-11 09:49:14 +00:00
royalterra
d0482133a5 Update INSTALL.txt 2015-12-11 09:48:04 +00:00
redmatrix
3f920da413 update error 2015-12-06 14:25:47 -08:00
redmatrix
36ef1d1bc6 move the instance stuff to abook where it belongs 2015-12-05 13:24:58 -08:00
zottel
4c4db6f73c added info about Apache settings to avoid Apache running wild 2015-11-27 10:35:31 +01:00
redmatrix
391807b46c small fixes, removed old unused database row, and log more prominently a missing directory server URL 2015-11-12 16:45:38 -08:00
Waitman Gobble
f94a8698dd updates to Postgres schema 2015-11-11 07:42:41 -08:00
redmatrix
9a42d63516 Merge https://github.com/redmatrix/redmatrix into pending_merge 
Conflicts:
	boot.php
	install/update.php
 2015-11-06 12:43:51 -08:00
redmatrix
1c8f63f1e5 rev update 2015-11-06 12:34:29 -08:00
redmatrix
2ebd9a2774 fix path for attachments using os_storage uploaded through attach_store 2015-11-04 23:48:55 -08:00
redmatrix
f8b612a2c0 Merge https://github.com/redmatrix/redmatrix into pending_merge 
Conflicts:
	install/update.php
 2015-11-04 23:17:09 -08:00
redmatrix
76043d97bd dummy update 2015-11-04 23:06:37 -08:00
redmatrix
ea37882b95 Merge https://github.com/redmatrix/redmatrix into pending_merge 
Conflicts:
	include/zot.php
	install/schema_mysql.sql
	install/schema_postgres.sql
	install/update.php
	mod/zfinger.php
 2015-10-19 16:18:04 -07:00
redmatrix
57e0bfc5a9 add the project name to site info packet 2015-10-19 16:07:14 -07:00
redmatrix
7fe6bc52d0 change setup defaults to 127.0.0.1 instead of localhost for DB server, add documentation to the INSTALL.txt explaining the choice. 2015-10-16 13:05:40 -07:00
redmatrix
93f061f78a mail sync/migrate continued; also abstract delivery loop to make it re-usable, change refresh_all to use delivery loop. 2015-10-15 18:52:04 -07:00
redmatrix
7517c76ae4 Merge https://github.com/redmatrix/redmatrix into pending_merge 
Conflicts:
	install/update.php
 2015-10-15 16:02:37 -07:00
redmatrix
e26f771cbe dummy update 2015-10-15 16:00:31 -07:00
redmatrix
5c526995d8 resolve conflicts 2015-09-28 19:07:31 -07:00
redmatrix
50ee82e8bd Merge https://github.com/redmatrix/redmatrix into pending_merge 2015-09-28 19:06:10 -07:00
redmatrix
3a8e1e0484 process_delivery: ignore self 2015-09-28 19:04:36 -07:00
redmatrix
edbcba6f11 schema support for additional site types 2015-09-28 04:15:21 -07:00
redmatrix
e04f04ef0f Merge https://github.com/redmatrix/redmatrix into pending_merge 
Conflicts:
	install/update.php
 2015-09-23 22:33:48 -07:00
redmatrix
0f3c2c4b24 add vdata field for caldav 2015-09-23 22:32:46 -07:00
redmatrix
8a94a4938f dummy update 2015-09-23 22:31:49 -07:00
redmatrix
15b241cc3e remove dummy update from merge 2015-09-22 02:34:34 -07:00
redmatrix
2b07a69b93 Merge https://github.com/redmatrix/redmatrix into pending_merge 2015-09-22 02:34:05 -07:00
redmatrix
5068ce0569 dummy update 2015-09-22 02:33:24 -07:00
redmatrix
0b1b11ea53 heavy lifting for delivery reports 2015-09-22 02:32:04 -07:00
redmatrix
40bb1699a5 DB table for delivery reports 2015-09-18 22:55:47 -07:00
redmatrix
74827133b2 Merge https://github.com/redmatrix/redmatrix into pending_merge 
Conflicts:
	util/messages.po
 2015-09-18 22:46:21 -07:00
redmatrix
3dc066a143 dummy update 2015-09-18 22:43:35 -07:00
redmatrix
46e9c4299e Merge https://github.com/redmatrix/redmatrix into pending_merge 2015-09-03 15:48:52 -07:00
redmatrix
e1af81ea55 in this case no results is not an error 2015-09-03 15:48:01 -07:00
redmatrix
99848ab3bb Merge https://github.com/redmatrix/redmatrix into pending_merge 2015-09-03 13:11:25 -07:00
zottel
5cef672f9a fix update 1148 2015-09-03 13:55:47 +02:00
redmatrix
669e111118 add timestamps for syncing apps 2015-09-02 21:07:24 -07:00
redmatrix
360fda15e9 Merge https://github.com/redmatrix/redmatrix into pending_merge 2015-09-02 20:54:00 -07:00
redmatrix
2018b88093 dummy update 2015-09-02 20:53:26 -07:00
redmatrix
3852b5ce7f separate objs/things from taxonomy 2015-09-01 17:06:58 -07:00
redmatrix
d753ae4cf1 dummy update placeholder 2015-09-01 16:25:10 -07:00
redmatrix
d7089ab471 Merge https://github.com/redmatrix/redmatrix into pending_merge 
Conflicts:
	include/identity.php
	install/update.php
	util/messages.po
	view/nl/messages.po
 2015-08-31 21:00:28 -07:00
redmatrix
d7cf7316be change the likes db structure to make it more easily importable/exportable 2015-08-31 20:55:25 -07:00
redmatrix
de3012ccf1 documentation re-org 2015-08-31 17:08:09 -07:00
redmatrix
b1f091e4d7 issues with abook sync between hubzilla and red 2015-08-23 17:40:47 -07:00
redmatrix
43fbbfe0df Merge https://github.com/redmatrix/redmatrix into pending_merge 2015-08-20 22:14:51 -07:00
redmatrix
fef93af0a6 missed this one - it's required 2015-08-20 22:13:25 -07:00
redmatrix
3b1554db2e Merge https://github.com/redmatrix/redmatrix into pending_merge 2015-08-18 17:15:53 -07:00
redmatrix
37d07a7d2a add event_sequence for vtodo's 2015-08-18 17:10:40 -07:00
redmatrix
6a1d1867f0 Merge https://github.com/redmatrix/redmatrix into pending_merge 2015-08-16 19:13:29 -07:00
redmatrix
b3b566c907 add DB support for tasks, todo items and repeating events 2015-08-16 17:17:34 -07:00
redmatrix
ec41899328 update some of the old attach.flag values to the new schema 2015-07-30 17:16:23 -07:00
redmatrix
26411ab385 Merge branch 'master' of https://github.com/redmatrix/redmatrix 2015-07-30 17:12:23 -07:00
redmatrix
4c6368d075 dummy update 2015-07-30 17:07:03 -07:00
redmatrix
4abb114474 very crude but working doc search 2015-07-05 21:09:04 -07:00
redmatrix
a7135b5ecd fix the postgres schema with all the changes to date 2015-06-29 19:58:44 -07:00
redmatrix
6e8ad5089e Merge branch 'master' of https://github.com/redmatrix/redmatrix 
Conflicts:
	view/nl/messages.po
	view/nl/strings.php
 2015-06-29 18:01:51 -07:00
redmatrix
63f2e9b412 Merge branch 'master' of https://github.com/redmatrix/redmatrix 
Conflicts:
	include/zot.php
	mod/connedit.php
	util/messages.po
 2015-06-28 22:33:13 -07:00
redmatrix
de13497333 no this isn't it. well ok, it's part of it, but not the important part. it's still pretty cool. 2015-06-28 21:16:56 -07:00
redmatrix
859a2ac8ef DB changes for some channel flags 2015-06-15 17:28:52 -07:00
redmatrix
41085ae03f start on the DAV/photos merger 2015-06-11 22:32:08 -07:00
redmatrix
ca870dbf31 more work on item table optimisation 2015-06-10 16:59:04 -07:00
redmatrix
03357481f7 Merge branch 'master' of https://github.com/redmatrix/redmatrix 
Conflicts:
	install/schema_mysql.sql
	mod/home.php
	mod/page.php
	view/nl/messages.po
	view/nl/strings.php
 2015-06-09 16:52:00 -07:00
redmatrix
39f0e6fe62 add site_dead flag to prevent delivery to dead sites. Allow sys channel webpages to be viewed even if site is configured "block public". 2015-06-08 16:55:17 -07:00
redmatrix
8fe3daab21 Merge branch 'master' of https://github.com/redmatrix/redmatrix 
Conflicts:
	install/schema_mysql.sql
	mod/impel.php
	view/pt-br/messages.po
	view/pt-br/strings.php
 2015-05-28 19:06:31 -07:00
redmatrix
0f09a4499b add menu_created, menu_edited fields to DB 2015-05-28 16:59:56 -07:00
redmatrix
e68a00d381 more db structure 2015-05-19 22:43:24 -07:00
redmatrix
c78869e437 Merge branch 'master' of https://github.com/redmatrix/redmatrix 
Conflicts:
	view/nl/messages.po
	view/nl/strings.php
 2015-05-19 17:36:11 -07:00
Alexandre Hannud Abdo
2c7b786907 Document php-xml requirement for webdav. 2015-05-19 16:46:15 +00:00
redmatrix
da7abbb089 bring the new photo schema into play 2015-05-18 19:43:53 -07:00
redmatrix
af27457da5 here's a fair chunk of the new schema - still a lot of bits missing and no migration tools, and only for mysql currently. Oh, and you still don't have the new code to make use of the new schema yet. That's on another branch that I'm not checking in yet because then you might get the idea that bits of it actually work and infect the rest of the matrix with unstable code and bring other sites down that have never even heard of hubzilla. Please do not use this code. Let me repeat, please do not use this code. One more time in case you didn't understand - please do not use this code. 2015-05-17 22:43:36 -07:00
redmatrix
291f3beccf Merge branch 'master' of https://github.com/redmatrix/redmatrix 2015-05-14 22:12:37 -07:00
redmatrix
47564d4310 provide default permissions ('all') for existing and newly created OAuth app clients, which will be extended in the future to allow specific permissions. 2015-05-14 21:57:20 -07:00
redmatrix
25b599a4bd convert ITEM_WALL from bitfield to standalone 2015-05-06 21:03:33 -07:00
redmatrix
5b5f0666f9 second pass name change 2015-05-05 03:59:51 -07:00
redmatrix
a3c37f1458 first pass name change 2015-05-05 03:56:10 -07:00
Oliver Lorenz
c6400b30c9 Updated INSTALL.txt - outdated link corrected 2015-04-28 15:09:18 +02:00
friendica
d599ebe742 update resource links 2015-04-01 15:52:02 -07:00
friendica
0bb89778d3 add channel_lastpost timestamp to help optimise some outrageously expensive queries. 2015-03-26 19:55:52 -07:00
friendica
aa6549c239 we upped the php version requirement. So up yours. 2015-03-18 12:27:30 -07:00
friendica
6537a65053 mysql schema typo, do the install check for store before chcking smarty, as that is where the dir is created, change install doc to point to install/schema_xxxxx.sql instead of database.sql 2015-03-15 15:36:01 -07:00
friendica
9d1df58759 sql optimisation for affinity searches. A new index was added which wasn't added retro-actively to existing DBs as an update. It isn't clear if this helps sites any more than just restricting the abook table to certain channel_id's is (and this field is already indexed). 2015-03-10 18:55:56 -07:00
friendica
011ccd57f6 add queue priority 2015-03-04 17:56:07 -08:00
friendica
dce0bb0ef8 finish converting "delete" to trash icons for consistency. The 'x' was left in a couple of places like the group list widget and saved search term widget and ignoring friend suggestions where it was more appropriate to leave it. 2015-02-26 16:41:38 -08:00
Daniel Frank
32e4d4633a fix issues in schema_postgres.sql 
- change PRIMARY_KEY to PRIMARY KEY
- replace smallint(1) with smallint
 2015-02-26 23:50:46 +01:00
friendica
08f054130f require access token to view, query, or join directories in private realms, if the realm is so configured. 2015-02-24 16:36:27 -08:00
friendica
8eedc9d576 updated install doc 2015-02-20 13:18:44 -08:00
friendica
eeec826eda update the install doc for addons - the procedure is a bit different now (although it shouldn't break anything on existing sites.) 2015-02-19 20:53:24 -08:00
Habeas Codice
46964a8a88 make sql work on both db types 2015-02-13 02:57:28 -08:00
friendica
da2349bb6a provide relief to sites that are severely impacted by the slow ITEM_UNSEEN searches. This does not incorporate any other flag optimisations as that will require a major DB update and possibly involve significant downtime. This is just to bite off a little chunk now and provide some much needed relief. 2015-02-12 17:45:25 -08:00
zottel
9dda248b94 make update 1133 work in PHP < 5.5 2015-02-10 09:49:26 +01:00
Habeas Codice
9ed23f9081 Merge branch 'master' of https://github.com/friendica/red 2015-02-05 09:15:39 -08:00
Habeas Codice
84843984b8 typo/cleanup pg only 2015-02-05 09:14:24 -08:00
friendica
e58bef049d admin/dbsync not reporting failed updates 2015-02-01 15:41:01 -08:00
friendica
b1a92d620e two tracks proceeding in parallel - first adding the ability to store a digital signature with ratings so that directories can pass them around, second provide some directory registration functions so we can obtain a list of directories from somewhere (to pass ratings around between them). This gives the primary directory role some value as that is where you register your directory. 2015-02-01 15:10:52 -08:00
Habeas Codice
3e5226adc7 Add more detail about directory_mode settings to default config and docs 2015-01-30 19:37:25 -08:00
Habeas Codice
2039710962 postgres does not support the , syntax. a ; would work, if it weren't statement-locked. 
FWIW, the exact same queries listed for postgres are perfectly valid and equivalent on mysql. no need for separate
statements.
 2015-01-28 17:47:31 -08:00
friendica
0596097f86 provide storage for directory based reputation in the xlink table by setting xlink_static = 1, so that xlink_static = 0 is traditional poco linkages 2015-01-26 19:13:06 -08:00
Habeas Codice
dc259ba027 typo 2015-01-25 04:13:14 -08:00
Habeas Codice
0ca71a6b5e update schema 2015-01-25 04:05:28 -08:00
Habeas Codice
200d973581 suppress notices that might be confusing 2015-01-25 04:04:53 -08:00
Habeas Codice
146efbc18e unmatched parens 2015-01-23 22:34:45 -08:00
zottel
eb4e6ab073 add db update 1131/1132 to database schemas 2015-01-23 23:20:30 +01:00
friendica
9028e6bd30 typo in postgres db update, remove redmatrix.nl from directory servers since it isn't a directory server any more. 2015-01-20 19:41:09 -08:00
friendica
e3041b80fd oauth permissions table 2015-01-19 20:06:12 -08:00
Habeas Codice
547d852ef7 fix update 1131 for postgres databases 2015-01-18 18:33:32 -08:00
friendica
1c9299ed42 more backend work on poco rating 2015-01-15 14:05:18 -08:00
Habeas Codice
28a0209ffd fix driver issue for large dbs 
add rudimentary resume
 2014-11-20 12:41:48 -08:00
Habeas Codice
9443ef8a3d simple command-line migrator from mysql to postgres 
provided with the WorksForMe(tm) warranty of fitness for a purpose implied or otherwise
 2014-11-17 12:26:24 -08:00
Habeas Codice
ac27db22c1 Merge remote-tracking branch 'upstream/master' 
Conflicts:
	boot.php
	include/dba/dba_driver.php
	include/diaspora.php
	include/follow.php
	include/session.php
	include/zot.php
	mod/photos.php
	mod/ping.php
 2014-11-13 13:06:31 -08:00
Habeas Codice
1a5a5c7edb PostgreSQL support initial commit 
There were 11 main types of changes:
- UPDATE's and DELETE's sometimes had LIMIT 1 at the end of them. This is not only non-compliant but
it would certainly not do what whoever wrote it thought it would. It is likely this mistake was just
copied from Friendica. All of these instances, the LIMIT 1 was simply removed.
- Bitwise operations (and even some non-zero int checks) erroneously rely on MySQL implicit
integer-boolean conversion in the WHERE clauses. This is non-compliant (and bad programming practice
to boot). Proper explicit boolean conversions were added. New queries should use proper conventions.
- MySQL has a different operator for bitwise XOR than postgres. Rather than add yet another dba_
func, I converted them to "& ~" ("AND NOT") when turning off, and "|" ("OR") when turning on. There
were no true toggles (XOR). New queries should refrain from using XOR when not necessary.
- There are several fields which the schema has marked as NOT NULL, but the inserts don't specify
them. The reason this works is because mysql totally ignores the constraint and adds an empty text
default automatically. Again, non-compliant, obviously. In these cases a default of empty text was
added.
- Several statements rely on a non-standard MySQL feature
(http://dev.mysql.com/doc/refman/5.5/en/group-by-handling.html). These queries can all be rewritten
to be standards compliant. Interestingly enough, the newly rewritten standards compliant queries run
a zillion times faster, even on MySQL.
- A couple of function/operator name translations were needed (RAND/RANDOM, GROUP_CONCAT/STRING_AGG,
UTC_NOW, REGEXP/~, ^/#) -- assist functions added in the dba_
- INTERVALs: postgres requires quotes around the value, mysql requires that there are not quotes
around the value -- assist functions added in the dba_
- NULL_DATE's -- Postgres does not allow the invalid date '0000-00-00 00:00:00' (there is no such
thing as year 0 or month 0 or day 0). We use '0001-01-01 00:00:00' for postgres. Conversions are
handled in Zot/item packets automagically by quoting all dates with dbescdate().
- char(##) specifications in the schema creates fields with blank spaces that aren't trimmed in the
code. MySQL apparently treats char(##) as varchar(##), again, non-compliant. Since postgres works
better with text fields anyway, this ball of bugs was simply side-stepped by using 'text' datatype
for all text fields in the postgres schema. varchar was used in a couple of places where it actually
seemed appropriate (size constraint), but without rigorously vetting that all of the PHP code
actually validates data, new bugs might come out from under the rug.
- postgres doesn't store nul bytes and a few other non-printables in text fields, even when quoted.
bytea fields were used when storing binary data (photo.data, attach.data). A new dbescbin() function
was added to handle this transparently.
- postgres does not support LIMIT #,# syntax. All databases support LIMIT # OFFSET # syntax.
Statements were updated to be standard.

These changes require corresponding changes in the coding standards. Please review those before
adding any code going forward.

Still on my TODO list:
- remove quotes from non-reserved identifiers and make reserved identifiers use dba func for quoting
- Rewrite search queries for better results (both MySQL and Postgres)
 2014-11-13 12:21:58 -08:00
friendica
3b74e3c1e1 add defaults to database tables 2014-11-09 19:24:14 -08:00
friendica
d5d6158973 ok heads up - potentially destabilising change. I've tried to sort out all the default connection permissions for those who don't have a predefined (or therefore have a "custom") permissions role. Unfortunately this includes most people that were using this software more than a month ago. The real changes are that the SELF address book entry no longer holds "auto-permissions" but instead holds your "default permissions" (if you have a pre-defined role, the defaults will be pulled from the role table). 
The auto permissions have moved to a pconfig (uid.system.autoperms). A DB update will move these settings into their new homes.

What used to be the "Auto-permissions settings" page is now the "default permissions settings" page and a checkbox therein decides whether or not to apply the permissions automatically. A link to this page will only be shown when you have the "custom" role selected.

With luck nobody will notice anything wrong. But at least for the next few days, please review permissions that have been assigned to new connections (either automatically or manually) and make sure they make sense (e.g. they aren't "nothing"). You still need to take action when seeing a message "permissions have changed but not yet submitted" as we always let you review and perhaps adjust the settings _before_ a connection is established (unless you have autoperms turned on).
 2014-11-04 17:11:02 -08:00
Thomas Willingham
77fb1c2ee6 Doco - some clean up to install - keep politics out of it, 80 columnise it and 
whitespace.
 2014-10-22 20:22:37 +01:00
zottel
4fe8630518 document store writability requirements 2014-10-22 13:09:56 +02:00
friendica
5362943330 missing quote 2014-10-14 18:05:32 -07:00
friendica
2db7d88e28 this is the reason Diaspora forum tagging was broken 2014-10-14 18:02:34 -07:00
friendica
5236516145 install doc double escapes the store/[data] path. 2014-10-06 15:01:55 -07:00
jeroenpraat
0049f4c71a +png support 
https://redmatrix.nl/channel/jeroenpraat/?f=&mid=83603d8f0876c040efafce87755fcd252dbe8da4a75d82fdb230519e3c8dcb72@redmatrix.nl
 2014-10-05 21:05:50 +02:00
friendica
e8ef515b61 store diaspora meta info in the item table. It has to go there or it will kill us with complex joins. We can phase out the sign table once this all checks out. 2014-09-03 05:09:43 -07:00
Jeroen
3e8f9e8b62 update nl + Friendica>RedMatrix in two text files 2014-08-30 14:07:38 +00:00
friendica
53b5cf7f50 Ability to close comments at a certain date/time - needed for loom.io emulation (and many other uses) 2014-08-28 16:56:13 -07:00
friendica
eb27bea794 mind numbing drudgery continued... 2014-08-27 19:15:34 -07:00
friendica
e179dca446 place to store multiple choice and select items for extensible profiles 2014-08-26 22:37:04 -07:00
friendica
8c6067b411 more hard work 2014-08-26 20:51:59 -07:00
friendica
9196c9eef0 We really can't do this without a hubloc. I was hoping we could, but notifier is setup to take hublocs, not xchans. 2014-08-22 21:37:08 -07:00
friendica
4a76925787 some more work on realms 2014-08-17 19:06:56 -07:00
friendica
20bdcb037f provide backend storage and declaration of directory realm 2014-08-16 16:10:35 -07:00
friendica
7044975520 item table upgrade for storing post visibility 2014-08-06 17:00:25 -07:00
friendica
85032a1fa3 db tables for extensible profile fields 2014-08-02 14:56:17 -07:00
friendica
35ed18967a block channel removal for 48 hours after changing the account password, since the password is required to remove a channel. Somebody looking at an open session on somebody else's computer can simply change the password and then proceed to maliciously remove the channel. This change gives the owner 2 days to discover that something is wrong and recover his/her password and potentially save their channel from getting erased by the vandal. This is most likely to happen if a relationship has gone bad, or something incriminating was found in your private messages when you left your computer briefly unattended. 2014-07-29 20:13:01 -07:00
friendica
b19176169c provide a specific permission for liking profiles (reuse the obsolete bookmark permission), also remove the unused 'unconnected contacts' view for now. 2014-07-17 20:54:30 -07:00
friendica
3a31ddea2b provide os_mkdir to workaround permission issues with php mkdir 2014-07-16 01:07:00 -07:00
friendica
c74fd78993 move smarty compiled files to store/[data]/smarty3 - which puts all writeable areas of the server except the config file and logs under the "store" directory. We'll do logs at a future time. 2014-07-10 21:34:52 -07:00
friendica
fa706c8e86 finish implementing email verification. Currently it only applies if REGISTER_OPEN is in effect. 2014-07-09 21:10:56 -07:00
friendica
0cfcb02311 ability to like things 2014-06-23 05:19:28 -07:00
friendica
1dacfb375e honour the admin censored flag in the directory, and some slow progress on extended likes 2014-06-22 17:15:42 -07:00
friendica
a0747799fc likes table for liking things besides posts and comments 2014-06-22 03:39:43 -07:00
friendica
3821efb99e issue #477 2014-06-01 01:30:34 -07:00
friendica
bcac633085 implement 'requires' on personal apps 2014-05-22 19:19:04 -07:00
friendica
696f62331d try to recover from bad update 2014-05-20 22:38:33 -07:00
friendica
6d01707a72 more app backend work 2014-05-19 16:49:11 -07:00
friendica
68ca4ef19e support commerical apps 2014-05-18 02:21:06 -07:00
friendica
28e8a1d2d3 app DB structure 2014-05-17 17:18:56 -07:00
friendica
c93353c0a3 we seem to have lost any install text mentioning that subdirs and alternate ports aren't supported 2014-04-12 03:31:55 -07:00
Thomas Willingham
742e2686ca Don't explicitly deny our strongest features existence. 2014-04-11 14:53:18 +01:00
sasiflo
f16fc1eb4f Added some more details about why browser-valid SSL certificates must be 
used when SSL is used at all.

It is now in the check failure message in the installation routine, the
installation readme and in the documentation pages.
 2014-04-10 23:41:18 +02:00
friendica
ad60e2c566 use parent_mid in the parent query for enotify instead of of the parent id. This should fix the issue with encrypted content in the notification messages (for locally posted replies). The fix was a bit harder than anticipated because we store the parent id as an int in the notify table so this had to be modified to char storage as well. 2014-04-06 02:57:33 -07:00
friendica
27fec9cb64 more efficient public feed fetching 2014-04-02 15:13:50 -07:00
friendica
ced6d82633 finish up the source route storage so we can prevent messages from flowing upstream in complicated delivery chains 2014-03-31 16:25:05 -07:00
friendica
7375e30506 This should be a slight improvement in setting ciphers - we'll punt on RedHat but open up the list just for openssl distros which seem to have all the problems at the moment. 2014-03-25 15:19:18 -07:00
Thomas Willingham
fea711ecde Typo in database.sql 2014-03-07 17:27:44 +00:00
friendica
2a1729e671 typo 2014-03-06 01:34:39 -08:00
friendica
8c7e076dae bring friends back 2014-03-06 01:29:42 -08:00
friendica
3d49bf0320 directory sync issues 2014-03-03 21:00:42 -08:00
friendica
e7e97e578b put bookmarked chatrooms into poco 2014-02-25 19:48:13 -08:00
friendica
2c72e49d1f more chatroom discovery 2014-02-25 17:55:30 -08:00
Thomas Willingham
36085bc608 Also update database.sql 2014-02-25 21:12:19 +00:00
Thomas Willingham
8e3a16bcdd Update channel permissions to full ints 2014-02-25 21:06:47 +00:00
friendica
4944070e79 vsprintf error on update 2014-02-20 02:30:37 -08:00
friendica
a7194bc79a fix the broken hublocs in an update 2014-02-20 01:44:29 -08:00
Thomas Willingham
35a3b2d8eb s/Options All/AllowOverride All 2014-02-10 21:36:19 +00:00
friendica
8c845f5d50 set default for account_level in DB 2014-02-07 22:47:03 -08:00
friendica
d8f16442a1 bookmark permissions 2014-02-04 00:52:34 -08:00
friendica
a1d40431f2 chat expiration (default 2 hours) - but can be set on a per-chatroom basis 2014-01-30 20:10:47 -08:00
friendica
9261a170eb basic chatroom management backend 2014-01-29 00:08:29 -08:00
friendica
8c8be2a05e add client field to chatpresence - which will give us a place to put IP addresses for webRTC. Might as well allow for that since we'll (soon) have presence. Then we wouldn't need SIP and folks can "just" p2p each other using any mechanism they wish if they have permission to do so. 2014-01-28 15:05:44 -08:00
friendica
8c80589b5a chat data structures 2014-01-27 21:02:57 -08:00
friendica
8a5c747010 move some store things 2014-01-21 00:19:53 -08:00
friendica
762a543249 allow menus to have special roles 2014-01-15 12:57:12 -08:00
friendica
a309bc0d47 only let visitors remove their own files. 2014-01-09 19:20:10 -08:00
friendica
352e4dc21b add store directory write check to install checks 2014-01-08 18:20:47 -08:00
friendica
aacd3164fa allow objects to have permissions 2013-12-28 16:05:03 -08:00
friendica
5dee22c94d db update for directory profiles - and fix broken database.sql from the sys_perms addition a couple days back 2013-12-25 01:22:51 -08:00
friendica
63a42480c7 add account_level, is_foreigner and is_member functions; convert all e2ee user input and prompts to hex to avoid javascipt's lame handling of quotes. !!This breaks all prior encrypted posts.!! 2013-12-23 15:13:09 -08:00
friendica
1a42580ad4 remove a couple of mysql reserved words from being used as table or row names. For this round we're getting 'group' and 'desc'. Warning: potentially destabilising as this touches a lot of code. 2013-12-22 18:37:39 -08:00
Thomas Willingham
569e93d6e1 Ooops, also update the DB 2013-12-22 20:54:41 +00:00
Thomas Willingham
c4b4f27796 Some sys chan stuff 2013-12-22 20:47:57 +00:00
friendica
4791b2fd9c add aid to notifiy table which we may need to supress duplicate notify emails across your channels 
also try to handle the wretched mess of broken and duplicated hublocs that fred.cepheus.uberspace.de typically reports
 2013-11-20 21:09:13 -08:00
friendica
d37f4da37b remove the challenge table as well 2013-11-18 20:10:53 -08:00
friendica
bbd69c1e81 drop the queue table which we no longer use 2013-11-18 19:54:02 -08:00
friendica
8b9633e46b DB - allow private messages to expire 2013-11-06 17:27:51 -08:00
friendica
310ccfda99 INSTALL for dummies - step 1: ensure that we throw an ugly error message in their face 
if there's an ugly error when we first try to install. DON'T white screen until after
they've got it running.
 2013-11-05 19:45:02 -08:00
Antoine G
8baf617c89 Fix missing parenthesis in database.sql 
This was blocking database creation process
 2013-11-01 14:02:07 +01:00
friendica
2035a5dd76 allow zot public providers to list their location, as a non US-based server could be a strong selling point. 2013-10-30 01:58:45 -07:00
friendica
d389ceed6c Schema change - add channel_dirdate so we can ping a directory server once a month which means we can find dead channels - because they won't be pinging the directory server once a month. 2013-10-27 22:04:59 -07:00
friendica
e3504df514 installing sabre is a whole lot more complicated. It also doesn't like co-existing with other projects in the same web path. This is going to be fun. 2013-10-21 15:29:27 -07:00
friendica
ad29d0f9a1 preserve the source owner when creating a delivery fork so that we can uplink back to them without any ambiguity. 2013-10-13 18:36:28 -07:00
friendica
a92e1c617b Add install instructions for cloning WebDAV component (which I think is best if we make optional). There may be webserver dependencies so let's just call this a plugin of sorts, but different than normal plugins because if it's installed it will be tightly integrated with everything we do. Eventually we may provide a static repository or select a specific sabre-dav version so that we're immune from changes upstream which break stuff we're doing; but for now we'll use the fruux main repository and install using the trunk. 2013-10-10 16:09:26 -07:00
friendica
78a8d176ac post signatures 2013-10-02 21:04:48 -07:00
friendica
dffce63662 implement republish permission for use in sourced channels 2013-09-30 21:49:26 -07:00
friendica
e992cfeca9 directory sync - this will either work, or it won't work, or it will possibly recurse and blow up the matrix. Hard to say. Do you feel lucky? Well do ya' ... punk? Rule #1 - don't mess with anything unless it's blowing up the matrix. If it doesn't blow up the matrix, but doesn't work, just let it go and let's figure out what it is doing and what it isn't doing. 
The flow is as follows:
Once a day go out to all the directory servers besides yourself and grab a list of updates. This happens in the poller. If we've never seen them before add them to the updates table. The poller also looks to see if we're a directory server and have updates that haven't yet been processed. It calls onedirsync.php to process each one. If we contact the channel to update and don't find anything (we're just doing a basic zot_finger), set a ud_last timestamp. If this is set we will only try once a day for seven days. Then we stop trying to update.

This will probably cause a spike the first time through because you haven't seen any updates before, but we spread out the load over your delivery interval.
 2013-09-30 18:33:27 -07:00
friendica
edc5566f79 structure for channel unions 2013-09-26 16:25:28 -07:00
friendica
2a0406ec8c add some text for issue #79 2013-09-24 19:23:39 -07:00
friendica
e62dfc6f8a add a flag field to xtags so that we can filter tags based on whether or not the parent xchan is safe or not. Otherwise we'll have tags that lead to nowhere because the directory entry is hidden but the tag isn't. A successful porn site in the matrix could also swamp the directory with x-rated tags, even if the site was playing nice and did everything right to self-censor. Accomplishing this with joins would be horrendously inefficient, though it will take a bit of code re-org to get this flag where it needs to be when it's time to set keywords. 2013-09-19 22:27:12 -07:00
friendica
63fc92b9e5 sync item_search with yesterday's network fix for collections. Add ud_addr to update table to store the target address since it's possible the mirroring directory won't yet have an xchan or hubloc they can link the ud_hash to and therefore mayn't know how to contact them. 2013-09-19 01:01:51 -07:00
friendica
14f6bf06e7 set default charset of email_header_encode, add ud_flags to indicate which (directory sync) updates have been processed in some way. 2013-09-18 21:22:08 -07:00
friendica
d3aa31be4d site sellpage links 2013-09-17 22:27:51 -07:00
ndurchx
bf3e7f5e9f Fixed error in SQL Statement 2013-09-12 11:39:07 +02:00
Michael Meer
f93e92c260 extends DB in hubloc to maintain hubloc connectivity 2013-09-10 14:18:51 +02:00
friendica
0565a6ef01 change primary key on updates table 2013-09-09 04:55:43 -07:00
friendica
c65ea0b97b public site list (will take a few days to populate, assuming folks have updated their site access policy which old sites do not have) 2013-09-05 22:00:06 -07:00
friendica
de3345f5f3 This isn't optimal, but on the short term we'll clone the page editor to use as a block editor, and probably a layout editor as well. Eventually, these should all probably just be switches onto a single editor instance. Decided to put the layout_mid into the item table directory rather than re-use resource_id, so that we can still have pages attached to different resources like photos and events and stuff. The block editor is far from finished, at this point I've only cloned it and changed the name and type of item it looks for. 2013-09-01 17:07:55 -07:00
friendica
00622779f3 add a guid to directory update table to avoid recursion 2013-08-31 04:30:01 -07:00
friendica
2d3a489f51 basic structure for premium channel implementation 2013-08-21 17:15:56 -07:00
friendica
d8ef1417fb poll stuff 2013-08-21 01:33:20 -07:00
friendica
5d35d21100 network-wide poll voting structure 2013-08-20 20:39:00 -07:00
friendica
cd5fdbcb48 email attachments (and fix email photos) 2013-08-19 21:19:39 -07:00
friendica
1c1449cd82 we only want to maintain one INSTALL.txt - and it is in the directory 'install' where it belongs. 2013-08-15 22:41:34 -07:00
friendica
6191cfef2a check these in so I can go back and find out why the stylsheet is horked 2013-08-11 19:04:07 -07:00
friendica
68d907803a basic *account* removal, but the channel removal which it calls still needs (lots of) work. Oh and the intro table is no longer used and won't be - so it's gone. 2013-08-04 17:17:00 -07:00
friendica
6197f945ad add "xchan_instance_url" for communicating with services that lack nomadic identity. This will be set to the url of the Red site that they are connected with. Only the nomadic identity clone at that site can communicate directly with them. Other instances will need to relay through that site - and if it goes down, that connection is stuffed. 2013-08-01 16:55:37 -07:00
friendica
c00c550c58 better mail obscuring 2013-07-31 02:32:41 -07:00
friendica
7b3c29ebe6 fix bug #84, make imported messages from your clones show up on your wall 2013-07-29 17:30:46 -07:00
friendica
c975e51e8a add chandesc field to profiles to provide some arbitrary text in the directory - such as to inform people what this channel is about before they connect. This will work best with a "channel detail" popup in the directory to provide more info than is available in the micro-profiles (when hovered, or clicked or something). And of course, the first thing is to enable this data to be stored in the directory. 2013-07-24 21:23:20 -07:00
friendica
94e87c0a84 update friends/followers API so Friendica Android client won't choke 2013-07-17 21:53:35 -07:00
friendica
fc265a8e3a block duplicate channels 2013-07-17 21:38:37 -07:00
friendica
de734bbea8 photo_flags - for adding taxonomy photos and other stuff. 2013-07-16 04:46:01 -07:00
friendica
12c2cea36f fix xtag 2013-07-14 18:52:24 -07:00
friendica
25ed8788e9 install typo 2013-07-14 01:22:56 -07:00
friendica
39856f7cb1 Add self to recipient lists. Sure we already have a copy but it's possible our nomadic channel clones don't. 2013-07-14 01:12:05 -07:00
friendica
5a8cda632b remove double tags on search results, updates to install doco to get rid of Friendica name there and clarify Red requirements. 2013-07-09 22:48:34 -07:00
friendica
429ebabfd9 any questions regarding this checkin will be ignored 2013-07-03 04:28:36 -07:00
friendica
72f6edd595 add age to directory profile - requires updating on each birthday and that part is still missing 2013-06-30 00:38:02 -07:00
friendica
cdc66da52f Basic ability to create "things" 2013-06-27 19:35:59 -07:00
friendica
61601dc23d Add site registration policy to site record. This is not yet used or stored, but potentially can be exchanged through directory mirrors to automatically create "open site" lists. 2013-06-20 18:36:02 -07:00
friendica
4f06905a18 infrastructure for future stuff 2013-06-19 18:06:14 -07:00
friendica
764ee785f5 We will need a per item comment policy to be able to determine in advance if we have permission to comment on something , and we'll need to send it out with all communications. The current check is not only flawed but also a huge performance hit. Also provide the ability for an item to disable commenting completely - such as for a webpage or wherever you want to prevent comments on one item, without requiring a change to your entire permission scheme. All of this is only partially implemented at the moment but we need the structures in place on several sites in order to finish it without breaking everything. 2013-06-16 19:14:01 -07:00
friendica
0deec983b4 DB: add timestamps to hubloc table so we can eventually expire dead entries. 2013-06-04 17:46:21 -07:00
friendica
98018f4969 update the really old sample config file 2013-05-16 16:29:03 -07:00
Thomas Willingham
069e874e6d Typo 2013-05-14 23:23:04 +01:00
fabrixxm
d4c07930d5 add $db_port to .htconfig.php and $a->config['syste]['smarty3_folder'] for compiled templates 2013-05-10 06:13:24 -04:00
friendica
027f932ff5 add driver param to output queue so we know what protocol to use when faced with multiple choice 2013-05-06 03:55:58 -07:00
friendica
dc028ce8ba fixes 2013-05-06 02:17:20 -07:00