notbugIf you buy from Amazon USA, please support us by using this link.
Port details
logitechmediaserver-sqlplaylist Logitech Media Server plugin to create playlists based on SQL queries
2.5.3859 audio on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port
2.5.3859Version of this port present on the latest quarterly branch.
Maintainer: mark@tranquillussoftware.co.uk search for ports maintained by this maintainer
Port Added: 2016-10-05 22:50:40
Last Update: 2016-10-05 23:50:25
SVN Revision: 423393
License: GPLv2+
This plugin for Logitech Media Server makes it possible to create smart
playlists. Although the standard Logitech Media Server doesn't support
smart playlists by itself, together with iTunes and the standard
Logitech Media Server iTunes integration, it is possible to use smart
playlists defined in iTunes. The problem though is that the integrated
iTunes smart playlists will not be recalculated until the next time
you perform a rescan in Logitech Media Server. The SQL Playlist plugin
takes care of this problem and implements native smart playlist in
Logitech Media Server without any need to use iTunes. The smart playlists
implemented in SQL Playlist will also be automatically re-calculated
after each track played so they will be based on the latest statistic
information.

A smart playlist in SQL Playlist are continous and will run forever in
the same way as the standard Random Mix plugin, you can optionally
also choose that a smart playlist shouldn't repeat already played
tracks and in that case the music will stop when all songs matching
the playlist has been played.

WWW: http://wiki.slimdevices.com/index.php/SQL_Playlist_plugin
SVNWeb : Homepage
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (109 items)
  1. /usr/local/share/licenses/logitechmediaserver-sqlplaylist-2.5.3859/catalog.mk
  2. /usr/local/share/licenses/logitechmediaserver-sqlplaylist-2.5.3859/LICENSE
  3. /usr/local/share/licenses/logitechmediaserver-sqlplaylist-2.5.3859/GPLv2+
  4. share/logitechmediaserver/Plugins/SQLPlayList/BaseSettings.pm
  5. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/BaseParser.pm
  6. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/ContentParser.pm
  7. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/DirectoryLoader.pm
  8. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/Main.pm
  9. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/ParameterHandler.pm
  10. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/PlaylistWebAdminMethods.pm
  11. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/PluginLoader.pm
  12. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/TemplateContentParser.pm
  13. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/TemplateParser.pm
  14. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/WebAdminMethods.pm
  15. share/logitechmediaserver/Plugins/SQLPlayList/HTML/Classic/html/images/sqlplaylist_mix.gif
  16. share/logitechmediaserver/Plugins/SQLPlayList/HTML/Default/html/images/sqlplaylist_mix.gif
  17. share/logitechmediaserver/Plugins/SQLPlayList/HTML/Default/plugins/SQLPlayList/dynamicplaylistlink.html
  18. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/catchtab.js
  19. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/dynamicplaylistlink.html
  20. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/mixerlink.html
  21. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/settings/basic.html
  22. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/settings/subpage_chooser.html
  23. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/sqlplaylist_list.html
  24. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/sqlplaylist_redirect.html
  25. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/sqlplaylist_reload.html
  26. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_edititem.html
  27. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_editsimpleitem.html
  28. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_login.html
  29. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_newitem.html
  30. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_newitemparameters.html
  31. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_newitemtypes.html
  32. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_newsimpleitem.html
  33. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_publishitemparameters.html
  34. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_register.html
  35. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_savedownloadeditem.html
  36. share/logitechmediaserver/Plugins/SQLPlayList/HTML/Fishbone/html/images/sqlplaylist_mix.gif
  37. share/logitechmediaserver/Plugins/SQLPlayList/LICENSE.txt
  38. share/logitechmediaserver/Plugins/SQLPlayList/MixHandler.pm
  39. share/logitechmediaserver/Plugins/SQLPlayList/Mixes/sqlplaylist.cb.mix.xml
  40. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbums.sql.values.xml
  41. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbumsforartist.sql.values.xml
  42. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbumsfordecade.sql.values.xml
  43. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbumsforgenre.sql.values.xml
  44. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbumsforplaylist.sql.values.xml
  45. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbumsforyear.sql.values.xml
  46. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomartists.sql.values.xml
  47. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomforalbum.sql.values.xml
  48. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomforartist.sql.values.xml
  49. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomfordecade.sql.values.xml
  50. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomforgenre.sql.values.xml
  51. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomforplaylist.sql.values.xml
  52. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomforyear.sql.values.xml
  53. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomtracks.sql.values.xml
  54. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomyears.sql.values.xml
  55. share/logitechmediaserver/Plugins/SQLPlayList/Plugin.pm
  56. share/logitechmediaserver/Plugins/SQLPlayList/README.txt
  57. share/logitechmediaserver/Plugins/SQLPlayList/Settings.pm
  58. share/logitechmediaserver/Plugins/SQLPlayList/Template/Reader.pm
  59. share/logitechmediaserver/Plugins/SQLPlayList/Templates/advanced.sql.template
  60. share/logitechmediaserver/Plugins/SQLPlayList/Templates/advanced.sql.xml
  61. share/logitechmediaserver/Plugins/SQLPlayList/Templates/advancedwithrating.sql.template
  62. share/logitechmediaserver/Plugins/SQLPlayList/Templates/advancedwithrating.sql.xml
  63. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomalbums.sql.template
  64. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomalbums.sql.xml
  65. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomartists.sql.template
  66. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomartists.sql.xml
  67. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforrating.sql.template
  68. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforrating.sql.xml
  69. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandartist.sql.template
  70. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandartist.sql.xml
  71. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandgenre.sql.template
  72. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandgenre.sql.xml
  73. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandyear.sql.template
  74. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandyear.sql.xml
  75. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomfrommixer.sql.template
  76. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomfrommixer.sql.xml
  77. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomplaylisttracks.sql.template
  78. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomplaylisttracks.sql.xml
  79. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomtracks.sql.template
  80. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomtracks.sql.xml
  81. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomweightedtracks.sql.template
  82. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomweightedtracks.sql.xml
  83. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomyears.sql.template
  84. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomyears.sql.xml
  85. share/logitechmediaserver/Plugins/SQLPlayList/Templates/simple.sql.template
  86. share/logitechmediaserver/Plugins/SQLPlayList/Templates/simple.sql.xml
  87. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforalbum.sql.template
  88. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforalbum.sql.xml
  89. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforartist.sql.template
  90. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforartist.sql.xml
  91. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedfordecade.sql.template
  92. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedfordecade.sql.xml
  93. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforgenre.sql.template
  94. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforgenre.sql.xml
  95. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforplaylist.sql.template
  96. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforplaylist.sql.xml
  97. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforyear.sql.template
  98. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforyear.sql.xml
  99. share/logitechmediaserver/Plugins/SQLPlayList/install.xml
  100. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Constants.pm
  101. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite.pm
  102. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite/Deserializer/XMLSchema1999.pm
  103. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite/Deserializer/XMLSchema2001.pm
  104. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite/Deserializer/XMLSchemaSOAP1_1.pm
  105. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite/Deserializer/XMLSchemaSOAP1_2.pm
  106. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite/Utils.pm
  107. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Packager.pm
  108. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Transport/HTTP.pm
  109. share/logitechmediaserver/Plugins/SQLPlayList/strings.txt
  110. Collapse this list.
Dependency lines:
  • logitechmediaserver-sqlplaylist>0:audio/logitechmediaserver-sqlplaylist

To install the port: cd /usr/ports/audio/logitechmediaserver-sqlplaylist/ && make install clean
To add the package: pkg install logitechmediaserver-sqlplaylist

PKGNAME: logitechmediaserver-sqlplaylist

There is no flavor information for this port.

distinfo:

TIMESTAMP = 1463782116
SHA256 (logitechmediaserver/SQLPlayList-2.5.3859.zip) = b0363cbd0433ebae58e6357cee26ce40548f7b8b87ae4a7dae9bbff4a4bfdd53
SIZE (logitechmediaserver/SQLPlayList-2.5.3859.zip) = 188051


NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Runtime dependencies:
  1. slimserver.pl : audio/logitechmediaserver
  2. install.xml : audio/logitechmediaserver-dynamicplaylist
There are no ports dependent upon this port

Configuration Options
     No options to configure

USES:
zip

Master Sites:
  1. http://downloads.isaksson.info/download/do/downloadapplication?name=slimserver-sqlplaylist&filename=/
Port Moves

Number of commits found: 1

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
05 Oct 2016 22:50:25
Original commit files touched by this commit  2.5.3859
Revision:423393
woodsb02 search for other commits by this committer
Move audio/squeezeboxserver to audio/logitechmediaserver

audio/squeezeboxserver:
- Move to audio/logitechmediaserver
- Update to 7.9.0 pre-release (git commit from 7.9 branch on 2016.09.30)
- Change default install and database locations to suit new PORTNAME
- Remove softsqueeze.sh as it is no longer bundled with the server
- Add /usr/local/etc/newsyslog.conf.d/, don't edit /etc/newsyslog.conf
- Add LICENSE details
- Update maintainer (previous maintainer timeout)
- Use customized perl modules provided in distfile and slimserver-vendor
  GitHub repo, rather than using perl dependencies from ports
- Changed install method to now copy directly to stagedir instead of an
  intermediate step to TMP_SLIMDIR
(Only the first 15 lines of the commit message are shown above View all of this commit message)

Number of commits found: 1

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
curl*May 26
dovecot*May 26
ocaml*May 26
serendipityMay 26
sqlite3May 26
suricata*May 26
firefoxMay 22
firefox-esrMay 22
libxulMay 22
linux-firefoxMay 22
linux-seamonkeyMay 22
linux-thunderbirdMay 22
seamonkeyMay 22
thunderbirdMay 22
waterfoxMay 22

10 vulnerabilities affecting 120 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-05-26 19:03:58


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 36566
Broken 77
Deprecated 120
Ignore 296
Forbidden 3
Restricted 163
No CDROM 74
Vulnerable 34
Expired 34
Set to expire 94
Interactive 0
new 24 hours 9
new 48 hours29
new 7 days65
new fortnight116
new month197

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2019 Dan Langille. All rights reserved.