summaryrefslogtreecommitdiff
path: root/db
AgeCommit message (Collapse)Author
2010-04-26Give users more control over URL shorteningEvan Prodromou
Users and administrators can set how long an URL can be before it's shortened, and how long a notice can be before all its URLs are shortened. They can also turn off shortening altogether. Squashed commit of the following: commit d136b390115829c4391b3666bb1967f190a0de35 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:39:00 2010 -0400 use site and user settings to determine when to shorten URLs commit 1e1c851ff3cb2da5e0dc3a0b06239a9d9c618488 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:38:40 2010 -0400 add a method to force shortening URLs commit 4d29ca0b91201f6df42940297ed5b64b070efe49 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:37:41 2010 -0400 static method for getting best URL shortening service commit a9c6a3bace0af44bcf38d1c790425a7be9c72147 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:37:11 2010 -0400 allow 0 in numeric entries in othersettings commit 767ff2f7ecfd7e76e8418fc79d45e61898f09382 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:36:46 2010 -0400 allow 0 or blank string in inputs commit 1e21af42a685f600f4a53f49a194013e78b12f20 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:01:11 2010 -0400 add more URL-shortening options to othersettings commit 869a6be0f5779aff69018d02f9ac0273946040d9 Author: Evan Prodromou <evan@status.net> Date: Sat Apr 24 14:22:51 2010 -0400 move url shortener superclass to lib from plugin commit 9c0c9863d532942b99184f14e923fc3c050f8177 Author: Evan Prodromou <evan@status.net> Date: Sat Apr 24 14:20:28 2010 -0400 documentation and whitespace on UrlShortenerPlugin commit 7a1dd5798f0fcf2c03d1257a18ddcb9008879de0 Author: Evan Prodromou <evan@status.net> Date: Sat Apr 24 14:05:46 2010 -0400 add defaults for URL shortening commit d259c37ad231ca0010c60e5cfd397bb1732874a4 Author: Evan Prodromou <evan@status.net> Date: Sat Apr 24 13:40:10 2010 -0400 Add User_urlshortener_prefs Add a table for URL shortener prefs, a corresponding class, and the correct mumbo-jumbo in statusnet.ini to make everything work.
2010-03-24Use InnoDB and UTF-8 options when creating user_im_prefs table, to match othersBrion Vibber
2010-03-08Merge branch '0.9.x' into 1.0.xCraig Andrews
Conflicts: classes/statusnet.ini db/statusnet.sql lib/jabber.php lib/xmppmanager.php
2010-03-04Roll up some missing items from 08to09.sql; now hits all changed ↵Brion Vibber
tables/columns/keys in core. Added partial data conversions: user_groups -> local_user: ids, names filled out; mainpage, uri left null notice -> conversation: stub entry added to push the autoincrement past existing notice items
2010-03-04Create new field in consumer table in 08to09.sqlCiaran Gultnieks
2010-03-04Added oauth_appication tables to 08to09.sqlBrion Vibber
Conflicts: db/08to09.sql
2010-03-01Add index on group_index.notice_id, needed to pull list of target groups for ↵Brion Vibber
inbox delivery. Index was present on live identi.ca database but missing from master definitions: group_inbox_notice_id_idx
2010-03-01Add index on post_id for file_to_post, needed for efficient lookups of ↵Brion Vibber
files/urls attached to a given post.
2010-02-25add beta5 to beta6 scriptEvan Prodromou
2010-02-25Not sure how this ended up in wrong-cased dir...Brion Vibber
2010-02-25Add 'mainpage' to User_groupEvan Prodromou
Add the mainpage attribute to user_group objects.
2010-02-24Make user_group able to handle remote groupsEvan Prodromou
We add a local_group table to store data about local groups. It has the unique key for nickname, so /group/<nickname> looks up here. Updated DB data object classes and data files.
2010-02-24Merge branch '0.9.x' into 1.0.xCraig Andrews
Conflicts: EVENTS.txt db/statusnet.sql lib/queuemanager.php
2010-02-17Merge branch 'testing' into 0.9.xBrion Vibber
2010-02-17- conversation.uri needs to be nullableZach Copley
- factory method for creating new local conversations
2010-02-16New Conversation DO to handle remote notices as conversation rootsZach Copley
2010-02-16Merge branch '0.9.x' into 1.0.xCraig Andrews
Conflicts: lib/queuemanager.php
2010-02-05OAuth app name should not be nullZach Copley
2010-02-05OAuth app name should not be nullZach Copley
2010-02-02Merge branch '0.9.x' into 1.0.xCraig Andrews
Conflicts: EVENTS.txt lib/imqueuehandler.php lib/jabber.php lib/util.php plugins/Xmpp/Sharing_XMPP.php
2010-02-02Better token revocationZach Copley
2010-02-02OAuth app names should be unique.Zach Copley
2010-02-02Merge branch 'oauth-continued' into 0.9.xZach Copley
2010-02-02Better token revocationZach Copley
2010-02-01Create new field in consumer table in 08to09.sqlCiaran Gultnieks
2010-02-01OAuth app names should be unique.Zach Copley
2010-02-01Added oauth_appication tables to 08to09.sqlCiaran Gultnieks
2010-01-27Merge branch '0.9.x' into 1.0.xCraig Andrews
Conflicts: lib/queuemanager.php
2010-01-27fix update script -- read the diff wrong and put a couple fields on wrong ↵Brion Vibber
table (whoops)
2010-01-27Rename rc3to09.sql to rc3torc4.sql to avoid confusion if we add a ↵Brion Vibber
last-minute change after this!
2010-01-27Add new oauth tables and modifications to 'consumer' table for rc4Brion Vibber
2010-01-27Create IM plugin, Pluginize XMPP, Create AIM pluginCraig Andrews
2010-01-26Site metadata tags in status_network: single 'tags' field, pipe-separated.Brion Vibber
$sn->tags() returns tag list as array; $sn->hasTag('blah') to check for a particular tag only Could be used to control things in config file: $sn = Status_network::setupSite($_server, $_path, $_wildcard); if (!$sn) { die("No such site"); } if ($sn->hasTag('individual')) { /* blah */ } Note memcached keys are unchanged; if tags are changed from an external tool clear: statusnet:<dbname>:status_network:<key>:<val> for <key>s 'nickname', 'hostname', and 'pathname'
2010-01-24Add verifier and verified callback to token for OAuth 1.0aZach Copley
2010-01-24Remove verifier from Oauth_application_user (not needed there)Zach Copley
2010-01-24Callback URL can be nullZach Copley
2010-01-24Decided we didn't need to keep the token secret in theZach Copley
Oauth_application_user record
2010-01-24Associate request tokens with OAuth apps and app usersZach Copley
2010-01-24Workflow for registering new OAuth apps pretty much done.Zach Copley
2010-01-24Changed the OAuth app tables to refer to profiles instead of users.Zach Copley
Added an owner column to oauth_application.
2010-01-24Add new OAuth application tables and DataObjects. Also add a newZach Copley
column for consumer secret to consumer table.
2010-01-22Merge branch 'testing' into 0.9.xEvan Prodromou
2010-01-21XMPP queued output & initial retooling of DB queue manager to support ↵Brion Vibber
non-Notice objects. Queue handlers for XMPP individual & firehose output now send their XML stanzas to another output queue instead of connecting directly to the chat server. This lets us have as many general processing threads as we need, while all actual XMPP input and output go through a single daemon with a single connection open. This avoids problems with multiple connected resources: * multiple windows shown in some chat clients (psi, gajim, kopete) * extra load on server * incoming message delivery forwarding issues Database changes: * queue_item drops 'notice_id' in favor of a 'frame' blob. This is based on Craig Andrews' work branch to generalize queues to take any object, but conservatively leaving out the serialization for now. Table updater (preserves any existing queued items) in db/rc3to09.sql Code changes to watch out for: * Queue handlers should now define a handle() method instead of handle_notice() * QueueDaemon and XmppDaemon now share common i/o (IoMaster) and respawning thread management (RespawningDaemon) infrastructure. * The polling XmppConfirmManager has been dropped, as the message is queued directly when saving IM settings. * Enable $config['queue']['debug_memory'] to output current memory usage at each run through the event loop to watch for memory leaks To do: * Adapt XMPP i/o to component connection mode for multi-site support. * XMPP input can also be broken out to a queue, which would allow the actual notice save etc to be handled by general queue threads. * Make sure there are no problems with simply pushing serialized Notice objects to queues. * Find a way to improve interactive performance of the database-backed queue handler; polling is pretty painful to XMPP. * Possibly redo the way QueueHandlers are injected into a QueueManager. The grouping used to split out the XMPP output queue is a bit awkward.
2010-01-14Add verifier and verified callback to token for OAuth 1.0aZach Copley
2010-01-14Remove verifier from Oauth_application_user (not needed there)Zach Copley
2010-01-14Callback URL can be nullZach Copley
2010-01-14Decided we didn't need to keep the token secret in theZach Copley
Oauth_application_user record
2010-01-14Associate request tokens with OAuth apps and app usersZach Copley
2010-01-14Workflow for registering new OAuth apps pretty much done.Zach Copley
2010-01-14Changed the OAuth app tables to refer to profiles instead of users.Zach Copley
Added an owner column to oauth_application.