This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Get your amarok 2.x statistics! (mysql only)

Tags: None
(comma "," separated)
small
Registered Member
Posts
2
Karma
0
Hi all,

I just wrote quick and dirty a small php code to retrieve statistics of amarok2.
I use Kubuntu Karmik (9.10) with KDE 4.4.0 and amarok 2.2.2 but it should works on any amarok 2.x version running with mysql.

How it works :
- You need a apache + mysql + php installed on your favorite amarok2 workstation
- download http://glopglop.net/phpmyamarok2stats/phpmyamarok2stats.tar.gz
- unzip into a directory your apache2 can access it (/var/www/ usually)
- modify index.php by inserting your own login/password/databasename
- test it by opening it in your favorite browser with something like http://127.0.0.1/phpmyamarok2stats/

I warn you : it's a pure quick and dirty dev, so the code is bad and slow.
But, well, it's a beginning, and feel free to modify the SQL code to feet your own needs.

By the way, did someone now if it's possible to open a particular webpage in a widget under amarok 2 ? In fact I really wish to access my statistics page under amarok2?
User avatar
Mamarok
Manager
Posts
6071
Karma
16
OS


Running Kubuntu 22.10 with Plasma 5.26.3, Frameworks 5.100.0, Qt 5.15.6, kernel 5.19.0-23 on Ryzen 5 4600H, AMD Renoir, X11
FWIW: it's always useful to state the exact Plasma version (+ distribution) when asking questions, makes it easier to help ...
nhn
KDE Developer
Posts
114
Karma
0
OS
Mamarok wrote:Hm, how about making a script?


Or even better; how about making a new context view applet showing statistics information? This is something we really need! ;)
small
Registered Member
Posts
2
Karma
0
I never tried to program a script or a widget. Sounds hard to me, but, who knows :)
Let's see if I can do this...


Bookmarks



Who is online

Registered users: Bing [Bot], gfielding, Google [Bot], markhm, Sogou [Bot], Yahoo [Bot]