novorado

Hello All,
I was able to run headunit with MySQL, some changes was done to DBHandler.h (on Windows platform).
Sound loudness slider is not working, and also some buttons not functional.
What I also want is to add interface for cell phone (to widcomm).
Comments?

#define CREATE_MEDIA_TABLE "CREATE TABLE media (`id` INTEGER PRIMARY KEY AUTO_INCREMENT DEFAULT NULL, `key` TEXT, `artist` TEXT, `album` TEXT, `title` TEXT, `genre` TEXT, `mrl` TEXT)"
#define CREATE_MEDIA_INDEX "CREATE INDEX key_index ON media(`key`(255))"
#define TRUNCATE_MEDIA_TABLE "DROP TABLE media"
#define INSERT_MEDIA_ITEM "INSERT INTO media (`key`, `artist`, `album`, `title`, `genre`, `mrl`) VALUES (:key, :artist, :album, :title, :genre, :mrl)"
#define QUERY_MEDIA_ITEM_BY_MRL "SELECT `id`, `mrl`, `artist`, `album`, `title`, `genre`, `key` FROM `media` WHERE `mrl` = :mrl"
#define QUERY_MEDIA_ITEM_BY_KEY "SELECT `id`, mrl, artist, album, title, genre, `key` FROM media WHERE `key` like :key"
#define QUERY_MEDIA_ITEM_BY_ID "SELECT `id`, mrl, artist, album, title, genre, `key` FROM media WHERE `id` = :id"

// Playlist table
#define CREATE_PLAYLIST_TABLE "CREATE TABLE playlist (`id` INTEGER PRIMARY KEY, `name` TEXT, `description` TEXT, `type` TEXT)"
#define TRUNCATE_PLAYLIST_TABLE "DROP TABLE playlist"
#define INSERT_PLAYLIST "INSERT INTO playlist (`name`, `description`, `type`) VALUES (:name, :description, :type)"
#define QUERY_PLAYLIST "SELECT `name`, `description`, `type` FROM playlist"

// State table
#define CREATE_STATE_TABLE "CREATE TABLE `state` (`var` TEXT, `value` TEXT,PRIMARY KEY (`var`(250)))"
#define TRUNCATE_STATE_TABLE "DROP TABLE `state`"
#define INSERT_STATE "INSERT INTO `state` (`var`,`value`) VALUES (:var,:value)"
#define QUERY_STATE "SELECT `value` FROM `state` WHERE var = :var"

// Cover art table
#define CREATE_COVERART_TABLE "CREATE TABLE coverart (`key` TEXT, `image` blob, PRIMARY KEY (`key`(250)))"
#define TRUNCATE_COVERART_TABLE "DROP TABLE coverart"
#define INSERT_COVERART "INSERT INTO coverart (`key`,`image`) VALUES (:key,:image)"
#define QUERY_COVERART "SELECT `image` FROM coverart WHERE `key` = :key"

Attached Images

 

MP3Car.com

 

novorado

I was able to play/store any music/video in HeadUnit, except names in Russian. The thing still has sky load of bugs, not hard ones.

One of the most important I could not fix yet - how to pass names to DirectShow in CP1251 encoding.
I am talking about DirectShowMediaPlayer.cpp, this piece of code
mbstowcs(wfilename, mrl.ascii(), 1024);
if (FAILED(graphBuilder->RenderFile(wfilename, NULL)))
qWarning("open failed: %s", mrl.ascii());

When mrl.ascii() is in CP1251, DirectShow does not want to play it (same for latin1, etc)

For MySQL interface/GUI interfaces/tags reading, encoding issues has been fixed.

There are other annoying bugs in the interace that is easy to fix. Someone willing to share the load?

What really need to be implemented, is Cell Phone integration on top of WidComm, and also TV module. WidComm+DirectX make it easy.

Attached Images

 

novorado

Hello All,
today I embedded Tcl intepreter into it. From Tcl configuration file you can:
1) Set your national UNICODE so database and GUI will properly reflect special sybmols
2) Set up your MySQL database login credentials
3) Write your own queries if you want other database structure

puts "Loading Headunit settings .."

# MySQL server
set DBSERVER "rado"

# MySQL database & login credentials
set DBNAME "carpc"
set DBUSER "carpc"
set DBPASS "carpc123"

# National unicode
set DBUNICODE "cp1251"
set QTUNICODE "CP1251"

set CREATE_MEDIA_TABLE "CREATE TABLE media (`id` INTEGER PRIMARY KEY AUTO_INCREMENT DEFAULT NULL, `key` TEXT, `artist` TEXT, `album` TEXT, `title` TEXT, `genre` TEXT, `mrl` TEXT) CHARACTER SET utf8"
...

puts "WELCOME TO HEADUNIT"

kle_men

What is the current status of the project? Who are developers at the moment?

I transfered latest sources from CVS and I'm looking around the code. First thing I noticed was somewhat slow starup. The quest I'm after at the moment is to speed up startup.

So the question is where can I put my patches? Is there anyone responsible for the project to verify submited code?

Thanks for answers!

Yonen_

I started working on this project a few years ago since I never got a car and there wasn't this much interest in the software, I gave up.

But now I'm thinking about getting a car again, and I see the interest.

I have write access to CVS so I can upgrade code.

I'll try to contact the project's admin to see what we can do about the project and I'd like to know who's willing to help develop this project. We all need to work together to get something going.


I hope this time around we can get this project going.

Vagabond

Any progress. I just installed a copy of Ubuntu Edgy on my Epia and I like this setup.

__________________
Thats only half true...

novorado

__________________
C52B3901A0B3248C2BB13302DAB0F3E6

MP3Car.com