Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Dap-P

Pages: 1 ... 3 4 [5] 6 7 8
What does not look right?
to me it seems correct, i do the insert, and last_insert in 1 command, with the output in $PK_File var

it even works for me


I thought it would work that way, when i realised it didn't work as plan. thanks!!!

Here 2 new scripts,
 - add radiostations with select_last_id
 - delete radiostations


Had some sparetime, and name some progress on the script,

New features:
- Use variable for tempfile
- Check if the Url is already in the DB before adding
- Reuse genre if it exists
- Adds genre if it not exists
- Uses SELECT MAX(id) to find out last added row

@sambuca, i couldn't get a working SELECT LAST_INSERT_ID, i think if it because i used 2 seperate mysql -e statements, If MAX(id) is not suitable, i have to make LAST_INSERT_ID working somehow

Attached is the new version


I want to expand the script with checks to not add duplicates, and to check the genre and reuse that attribute, its still just a simple script.

As I have no experience using mysql, all advise is appreciated. I will try to make to as useable as possible.

@posde Thanks for the tips


Ok, here is a working script,

It will download an indexfile and process it into the LinuxMCE
It does not add Genre's, only the station's name and the url

Can somebody try this out? And yes, it could mess up your whole DB.....
If you only want to see what stations would be added, comment out the Add to Database lines before running the script


Another thing to consider is when to re-use an existing attribute.... You could keep adding attribute with the same name, but that would make duplicate attributes in LMCE, not sure you want that...

Sambuca, this would only affect the Genre... Personally, i dont use it, but i wanted to add it anyway.
I am not a database guy... i will try to make it as neat as possible, so your remark has been noted)))

Posde, Thanks, i will try that

I just saw it myself... Oops)
Fixed now

Made a little progress, i can fill pluto_main from the cmdline

Example to add Dutch Radio station 3FM to LMCE. run this in bash, and you should have an extra radio stream
Code: [Select]
Station="3FM 96.5"
Genre="Alternative Rock"

echo "insert into File (EK_MediaType,DateAdded,Filename,Missing,IsDirectory,IsNew) VALUES(43,NOW(),'$Url',0,0,1);" | mysql pluto_media
PK_File=$(echo "select * from File where Filename='$Url';" | mysql pluto_media | tail -n1 | awk -F" " '{print $1}')
echo "insert into Attribute (FK_AttributeType,Name) VALUES(10,'$Station');" | mysql pluto_media
FK_Attribute=$(echo "select * from Attribute where Name='$Station';" | mysql pluto_media | tail -n1 | awk -F" " '{print $1}')
echo "insert into File_Attribute (FK_File,FK_Attribute,Track,Section) VALUES('$PK_File','$FK_Attribute',0,0);" | mysql pluto_media
echo "insert into LongAttribute (FK_AttributeType,FK_File,Text) VALUES(8,'$PK_File','$Genre');" | mysql pluto_media

But somehow the Stations name does not get linked to the 'File'
Run the code from a commandline, and see for yourself.

What am i not seeing in the database?


Modified, to correct commands

Users / Automatic adding Internet Radio streams to LinuxMCE
« on: October 26, 2013, 12:18:36 am »
Hi all,

I found this nice site that had indexed a whole lot of internet radio stations.
Here you also can find 'Local' radio stations, based on your geolocation (IP based)

so i made a command that downloads the needed information, as this would seem to me like a handy function to have while installing LMCE, or available from the Webadmin

Code: [Select]
curl --silent | grep audio | grep station|  gawk -F'"' '{ print "Station : " $4}{system("curl --silent "$6" |  head -n1")}'
Code: [Select]
Station : #Station Name# (#Genre#)

Now i need some help with putting this info in LinuxMCE
Is there a commandline script i can call, to add media to the LMCE database?
Or should this be done via Mysql?


Users / Re: Need some dedicated testers.
« on: October 25, 2013, 10:39:21 pm »
I have the same as WhateverFits, Audio plays, but qorbiter crashes. At home, over wifi

For me the screen rotation is working perfectly, almost instant, just like other apps. This is running on my Nexus4
On my Desire HD, it's a little slow. But also about the same as other apps.

Just the redraw is not a pretty sight...

Langston, thank you for you patience with us lousy and lazy testers (yes i speak only for myself) ;)


Users / Re: Need some dedicated testers.
« on: October 25, 2013, 04:59:24 pm »
Langston, did you also change something with the screen rotation? (landscape/portrait)
This seems to go much better for me.


Users / Re: Need some dedicated testers.
« on: October 25, 2013, 12:57:11 pm »

Downloaded the new APK, script, etc.
connected with the new qorbiter, i get the default skin. saw nothing about "starting audio service" selected smokey skin, saw "Starting audio service"

In the power menu, i still get crashes when selecting "Display on/off" but none when i select "Turn MD on/off"
Defintly have a more stable (and slower) datagrid. and the same speed when i sit at home via wifi, or at work, via 3g and vpn

When i press Advanced, Media test, from my work (over vpn/3g) i get media playback, and at the same time qorbiter crashes.
Tonight, i will try this via wifi.

Langston, keep up the good work!

Installation issues / Re: New install, Squeezeboxes not working
« on: October 24, 2013, 11:01:34 pm »
Checked MAC addresses, and they are correct.
But i noticed in the webadmin the 'SqueezeBox Player' device has not registered, maybe this has something to do with it?


Installation issues / Re: New install, Squeezeboxes not working
« on: October 24, 2013, 11:39:27 am »
They get get autodetected. I can control them from the Squeezeserver (http://dcerouter:9000), just cannot control them from an orbiter.
Is there a way to roll back to a previous version of the slimserver?

I will double check the MAC addresses tonight


Users / Re: Need some dedicated testers.
« on: October 24, 2013, 12:14:09 am »
Updates for x86 and android
Added ui, functionality to select private media on x86
*need ui on android
*added experimental android media player. More of a test of other possibilities in the domain.
*changed throttling speed on android to slow down. Previous speed caused crashes on long runs. (tested with 8,687 audio titles.))

upcoming priorities
*Implement private media selection, viewed/unviewed selection.
*Implement different item views for media types (movies, music, tv shows)
*Normalize small screen, tablet UI (smokey on small screen) as much as possible.
*Add missing functionality to media screens (missing ui, backend exists) on tablet, phone UI
*implement screensaver for phone / tablet UI (onscreen elements go away _except_ for actual screens saver.)
*Fix bugs found by people.
*RPI target
*semi-related work on autotagger.
*find someone to help with screens. there are already examples for everything including dvd playback. just need UI assembly.

oh, and i may be MIA as Qt DevDays is coming up Nov 6 - 8 and ill be attending.


Downloaded new apk, and new skins, and run new
I noticed there are still qt5 stuff downloaded via the setupqorbiter script

few small issues...
- Start qorbiter, i get a new screen, asking for a router reload. i have this problem on all my systems. but i cannot read the text on the buttons, both buttons just say 'Reload'. i found out the left button is yes, and the right button is no
- cannot select the smokey skin, i see it, but when i want to select it, nothing happens.
- Power menu is available. but if i press the display on, or display off buttons, qorbiter crashed
- I normally do not use the default skin, but now, i notice if i play any media, on qorbiter the screen just goes blank. only the background (blue/red pixels) is there.
- Definitly notice qorbiter is slower. the datagrid loading speed is now about the same as when i previously connect over 3g with a vpn from workplace, to show my colleges my new cool toy ;)
- Dont know if this is skin related or new version related, but i have difficulties selecting rooms. it's to easy to swipe the room left and right, and then it is not possible to scroll up and down.
- In the new security panel, the pincode that you enter gets displayed. And the buttons for selecting the security mode do not work
- While browings media (video), i notice that the A-Z button do not work right from the start. you have to wait until all media is loaded. is it possible to show these schortcut letters, when media is found that start with that specific letter?

Just a short check of functions, i will report back if i find new problems, although i really not like the default skin, i will put myself through this horror ;)


Pages: 1 ... 3 4 [5] 6 7 8