summaryrefslogtreecommitdiffstats
path: root/lib/class/update.class.php
Commit message (Collapse)AuthorAgeFilesLines
* Increase supported sessionID lengthPaul Arthur2013-10-301-0/+19
| | | | Should fix GH #74
* Clean up UpdatePaul Arthur2013-10-301-93/+29
| | | | Remove some cruft, update some comments.
* Update the stream_playlist table to use MyISAMPaul Arthur2013-04-291-1/+14
| | | | | | | | | | | | InnoDB's performance is unacceptable out of the box, and there's no clean way to batch these insertions into transactions, and stuff. Benchmarks for 1000 inserts: InnoDB: 54.826 MyISAM: 0.091 InnoDB transaction: 0.159 Fixes GH #14
* Switch Dba from mysql to PDO-MySQLPaul Arthur2013-01-291-1/+3
| | | | | The mysql extension is deprecated in PHP 5.5 and will be removed in the future.
* Fix incorrect updatesPaul Arthur2013-01-281-9/+1
| | | | | Starting with a fresh 3.3.3.5 import these updates failed. Kick them to the curb.
* Drop unnecessary updatesPaul Arthur2013-01-281-219/+2
| | | | | We only claim to support updates from 3.3.3.5, and that tarball has 340002.
* Clean up updatesPaul Arthur2013-01-281-148/+12
| | | | | Drop useless updates that created or modified tables which were later dropped.
* Make the update process potentially sanePaul Arthur2013-01-281-606/+361
| | | | | Make sure our writes succeed before declaring the update a success and updating the DB version.
* Rename the 'local' auth method to 'pam'Paul Arthur2013-01-281-2/+14
| | | | It's what it should have been from the start.
* Cosmetics: death to tabsPaul Arthur2013-01-261-1649/+1649
| | | | | The refactoring I've been doing has reminded me of my strong preference for spaces, and I feel inclined to impose my will on the tree.
* Cosmetics: clean up heads in lib/Paul Arthur2013-01-251-11/+1
|
* Remove explicit collation settings from updatesPaul Arthur2013-01-251-17/+17
| | | | Shouldn't be necessary, might be wrong, hmm.
* Make playlist downloads idempotentPaul Arthur2013-01-151-0/+25
| | | | | | | | | | | | | | | | | | | | Should fix the VLC plugin, as well as allow direct use of an Ampache site on Android devices. First, split the Stream class into an instantiable class that does the playlist wrangling and a static class that handles the streaming stuff. How does this work? Well, stream.php does its fancy stuff like gathering the media IDs and clearing the playlist, but instead of generating the playlist file there we use the Stream_Playlist class to store the list of URLs in the database, then redirect to play/index.php to create the actual download (there are some magic playlist types like localplay that don't need to redirect.) The playlist will be cached as long as that stream session is active, so it can be downloaded multiple times and by clients that don't share the browser's cookie cache. Clean up the playlist generation by reducing copypasta.
* Switch from print_r to json_encode in debug outputPaul Arthur2012-11-131-1/+0
|
* Switch from _() to T_()Paul Arthur2012-04-121-2/+2
| | | | | | Even if we move away from php-gettext in the future, it's easy to write a quick T_() as a simple wrapper; it's not so easy to rewrite PHP to allow redeclaration of a function.
* Increase the size of the mbid column in artistPaul Arthur2012-03-311-0/+15
| | | | | | Picard is putting multiple MBIDs in the tags now that MusicBrainz' new schema is live. The easiest way to deal with this is to store all of them as an aggregate value and match against that.
* Add CLI tool for running database updatesPaul Arthur2012-03-061-8/+24
|
* Lengthen varchar for `tmp_playlist`.`session`Paul Arthur2012-02-211-0/+16
| | | | Sessions can be longer than 32 characters. Bump to 64.
* Fix DB updates so catalog remote_username and remote_password are added ↵Karl Vollmer2011-11-231-1/+39
| | | | correctly, also fix catalog creation so they are stored in the database
* Use Dba::fetch_assoc instead of mysql_fetch_assocPaul Arthur2011-06-241-1/+1
|
* Make require_session work with local auth.Paul Arthur2011-05-311-0/+13
|
* Clean up some PHPDoc crapPaul Arthur2011-04-041-9/+0
| | | | | | Remove misleading, unvetted, or in some cases just plain wrong data. Packages and categories weren't being used correctly. They still aren't.
* Reworked searchPaul Arthur2011-04-021-0/+22
| | | | | Still has tentacles and should have been integrated into the existing API/Browse implementation better, but it's functional.
* header comment modified for phpdocmomo-i2011-02-031-1/+1
|
* header comment for phpdocmomo-i2011-02-031-1/+1
|
* test header for phpdoc. now using only classes and libraries.momo-i2011-02-021-17/+41
|
* Fix installation (base.js requires prototype). Also squelch a warning in update.Paul 'flowerysong' Arthur2010-06-291-1/+1
|
* Miscellaneous cleanup.Paul 'flowerysong' Arthur2010-06-131-1/+4
|
* Change Browse from static to instantiable. Among other things, fixes FS#13;Paul 'flowerysong' Arthur2010-06-101-0/+23
| | | | | probably also breaks things. Most things appear to still work, but I may have missed some cases.
* Clean up the rating code by moving uniqueness constraints into the database,Paul 'flowerysong' Arthur2010-06-071-0/+14
| | | | | using SQL's AVG() when we want an average, updating the cache when a rating changes, etc.
* Minor output change. FS#96, reported by Nate Gotz.Paul 'flowerysong' Arthur2010-05-291-1/+1
|
* Testing is all well and good...but uncomment things before you commit them.Paul 'flowerysong' Arthur2010-05-061-1/+1
|
* You know, maybe I shouldn't be allowed to use computers. Revert accidentally Paul 'flowerysong' Arthur2010-05-051-18/+0
| | | | committed hunk.
* Art work. Rationalise DB schema, support multiple thumbnail sizes and Paul 'flowerysong' Arthur2010-05-051-0/+61
| | | | | caching thereof, call Catalog->gather_art instead of Catalog->gather_album_art, unbreak (hopefully) gather_musicbrainz.
* Cosmetics: remove trailing whitespacePaul 'flowerysong' Arthur2010-03-141-32/+32
|
* Cosmetics: use tabs for indentation, tweak some indentation/coding style.Paul 'flowerysong' Arthur2010-03-141-95/+95
|
* Add vim modelines to all php files (Thx ascheel)Karl 'vollmerk' Vollmer2010-03-141-0/+1
|
* Typo - will require another db update eventually... sighKarl 'vollmerk' Vollmer2010-02-171-1/+1
|
* Fix typos, and tweak insert_now_playing preping for Video now playingKarl 'vollmerk' Vollmer2010-02-141-0/+10
|
* Tweaked how features / bandwidth level is checked, not happy with it.Karl 'vollmerk' Vollmer2010-02-141-2/+6
|
* moved database alterations to proper placemartian2010-02-111-0/+10
|
* Adding the bandwidth option to the preferences. This changes the complexity ↵martian2010-02-091-4/+13
| | | | of the UI and toggles album art.
* Add AmpacheAPI external, start work on future db changesKarl 'vollmerk' Vollmer2010-02-041-1/+40
|
* Replaced almost every dba::query to dba::read or dba::write.dipsol2009-12-141-780/+780
|
* whole bunch more Dba::query replacementsKarl 'vollmerk' Vollmer2009-12-141-6/+6
|
* add MBID support Thx flowerysongKarl 'vollmerk' Vollmer2009-06-021-2/+17
|
* api fixes, added librefm scrobbler (untested) and fixed minor error in ↵Karl 'vollmerk' Vollmer2009-05-181-0/+16
| | | | header file with rtl vs ltr languages also removed dead RioPlayer plugin
* add download for video that does not work, and most likely break song ↵Karl 'vollmerk' Vollmer2009-05-151-0/+11
| | | | downloads \o/
* reset database charset on db update to make sure it remains in syncKarl 'vollmerk' Vollmer2009-03-221-0/+4
|
* move server prefs to admin menu (Thx geekdawg) fix missing web_path on radio ↵Karl 'vollmerk' Vollmer2009-03-181-2/+2
| | | | creation link
generated by cgit (git 2.34.1) at 2025-08-13 11:51:14 +0000