GNU FM ClientCode table

Check the edit at the bottom first...

Earlier I asked:

On a !gnufm install, should the ClientCodes table be populated? Mine is empty and I imagine that is what is causing this: http://u.jpope.org/2w

Jeremy Pope (jpope)'s status on Tuesday, 08-Jan-13 12:12:38 CST - micro.jpope.org

Which resulted in the response:

We're discussing ways to populate it on install, or just add the data to source and scrap table, we've been inserting it manually up to now

Jonas (kabniel)'s status on Tuesday, 08-Jan-13 19:39:29 UTC

Which resulted in me writing this little insert statement to populate the ClientCodes table using the stated wiki entry:

insert into ClientCodes (`code`,`name`,`url`,`free`) values
 ('amk','Amarok 1.4.x plugin','http://amarok.kde.org/','y'),
 ('amp','Aimp2','http://www.aimp.ru/','n'),
 ('amy','Anomaly (Chrome extension)','Chrome webstore entry','y'),
 ('ark','Amarok','http://amarok.kde.org/','y'),
 ('ass','Last.fm player','http://www.last.fm/download','y'),
 ('atu','aTunes','http://www.atunes.org/','y'),
 ('aud','Audacious','http://audacious-media-player.org/','y'),
 ('bil','billy','http://www.sheepfriends.com/?page=billy','n'),
 ('blu','Bluemindo','http://bluemindo.codingteam.net/','y'),
 ('bsh','Banshee','http://banshee-project.org/','y'),
 ('bwt','Bowtie','http://www.bowtieapp.com/','n'),
 ('cmu','cmus (!CmuScrobbler)','http://n.ethz.ch/%7edflatz/cmuscrobbler/','y'),
 ('cpl','cplay scrobbler','http://sebi.tla.ro/cplay_scrobbler',''),
 ('cub','Cuberok','http://code.google.com/p/cuberok/','y'),
 ('dbl','Decibel Audio Player','http://decibel.silent-blade.org/','y'),
 ('ddb','DeaDBeeF','http://deadbeef.sourceforge.net/','y'),
 ('dms','donky mpdscrob','http://github.com/mjhayes/donky/tree/master','y'),
 ('ems','EMMS','http://www.gnu.org/software/emms/','y'),
 ('exa','Exaile','http://www.exaile.org/','y'),
 ('foo','foobar2000','http://www.foobar2000.org/','n'),
 ('gmb','gmusicbrowser','http://gmusicbrowser.org/','y'),
 ('gmm','Goggles Music Manager','http://code.google.com/p/gogglesmm/','y'),
 ('gst','GimmeSome Tune','http://www.eternalstorms.at/gimmesometune/','n'),
 ('gua','Guayadeque','http://sourceforge.net/projects/guayadeque/','y'),
 ('isp','iSproggler','http://iSproggler.org/','y'),
 ('jaj','Jajuk','http://jajuk.info/','y'),
 ('ldr','Libre Droid (Android)','http://linux.mikeasoft.com/libredroid/','y'),
 ('lfm','Libre.fm','http://libre.fm','y'),
 ('lib','LibreTunes','http://libretunes.sourceforge.net/','y'),
 ('liv','Livewwwire','http://ciarang.com','y'),
 ('lpd','lastPod','http://www.lastpod.org','y'),
 ('lsd','lastfmsubmitd','http://www.red-bean.com/decklin/lastfmsubmitd/','y'),
 ('mae','maemoscrobbler','https://garage.maemo.org/projects/maemoscrobbler','y'),
 ('maf','last.fm scrobbler / mafw-lastfm (on maemo5)','https://garage.maemo.org/projects/mafw-lastfm','y'),
 ('mcl','MOCp-Scrobbler','http://github.com/fluxid/mocp-scrobbler',''),
 ('mcn','mpdcron (MPD)','http://mpd.wikia.com/wiki/Client:MPDCRON','y'),
 ('mdc','mpdscribble (MPD)','http://musicpd.org/','y'),
 ('mlr','mobbler','http://code.google.com/p/mobbler/','y'),
 ('mmo','MediaMonkey','http://www.mediamonkey.com/','n'),
 ('mms','Maemo Scrobbler','http://github.com/felipec/maemo-scrobbler','y'),
 ('moc','music on console (MOC)','http://moc.daper.net/','y'),
 ('mp5','mpdas (MPD)','http://50hz.ws/mpdas/','y'),
 ('mpc','Scrobby (MPD)','http://unkart.ovh.org/scrobby/','y'),
 ('osx','iTunes','http://www.apple.com/itunes/','n'),
 ('pyj','pyjama','https://launchpad.net/pyjama','y'),
 ('qcd','Quintessential Media Player','http://www.quinnware.com/','n'),
 ('qlb','Quod Libet','http://code.google.com/p/quodlibet/','y'),
 ('qmm','Qmmp','http://qmmp.ylsoftware.com/index_en.php','y'),
 ('qmn','QMPDClient','http://bitcheese.net/wiki/QMPDClient','y'),
 ('qts','QTScrobbler','http://qtscrob.sourceforge.net/','y'),
 ('rbx','Rhythmbox','http://projects.gnome.org/rhythmbox/','y'),
 ('sbd','Songbird','http://www.getsongbird.com/','y'),
 ('scb','Scrobbl','http://www.last.fm/group/scrobbl','y'),
 ('sfm','shell-fm','http://nex.scrapping.cc/shell-fm/','y'),
 ('sls','Simple Last.fm Scrobbler','http://code.google.com/p/a-simple-lastfm-scrobbler/','y'),
 ('sna','Sonata','http://sonata.berlios.de/','y'),
 ('srd','scrobd (MPD)','http://codingteam.net/project/scrobd','y'),
 ('spc','scmpc','http://ngls.zakx.de/scmpc/','y'),
 ('spm','Spotify Mobile','http://www.spotify.com/uk/mobile/overview/','n'),
 ('spy','Spotify','http://spotify.com/','n'),
 ('ss7','SqueezeScrobbler 7','http://www.slimdevices.com/pi_features.html','y'),
 ('sub','Subsonic','http://www.subsonic.org','y'),
 ('tmh','scrobble for iPhone','http://www.nodomain.org/scrobble/','y'),
 ('tng','Clementine Player','http://code.google.com/p/clementine-player/','y'),
 ('trt','Trout','http://skwire.dcmembers.com/wb/pages/software/trout.php','n'),
 ('tst','Ecoute','http://ecouteapp.com/','n'),
 ('vag','vagalume','http://vagalume.igalia.com/','y'),
 ('vlc','VLC','http://videolan.org','y'),
 ('wa2','WinAmp 2','http://www.winamp.com/','n'),
 ('wmp','Windows Media Player','http://www.microsoft.com/windows/WindowsMedia/','n'),
 ('xbm','XBMC Media Center','http://xbmc.org','y'),
 ('xm2','XMMS2','http://www.xmms2.org/','y'),
 ('xmp','xmp-scrobbler (XMPlay)','http://www.un4seen.com/forum/?topic=5398.0','y'),
 ('xsp','XMMS2 (xmms2-scrobbler-py)','http://code.google.com/p/xmms2-scrobbler-py/','y'),
 ('yan','Jerboa','http://git.fredemmott.co.uk/?ph1.yanihp;asummary','y'),
 ('you','Youamp','http://www.rojtberg.net/workspace/youamp/','y'),
 ('zom','ZOMG','http://zomg.alioth.debian.org/','y')

Before:

before

After:

after

Badabing! Quick and easy. :)

EDIT: Seems that after I asked the original question, @kabniel pushed this merge request nullifying the need for this table to be populated. Now that was even quicker and easier. :D


Have a response to this post? Please use this link.