Help - Search - Members - Calendar
Full Version: questions regarding the database
Hydrogenaudio Forums > Hosted Forums > foobar2000 > General - (fb2k)
Druss
Is it possible to access the database with another program and add info to it like comments about the album? also is it possible to pull stastical info from it like total trackcount and percentage of each file type?
foosion
QUOTE(Druss @ Sep 3 2004, 04:39 PM)
Is it possible to access the database with another program and add info to it like comments about the album?

It's not possible out-of-the-box. You'd have to use some plugin to access the foobar2000 database.

QUOTE
also is it possible to pull stastical info from it like total trackcount and percentage of each file type?

Like that? (probably doesn't display correctly in IE)
Druss
QUOTE(foosion @ Sep 3 2004, 04:14 PM)
QUOTE(Druss @ Sep 3 2004, 04:39 PM)
Is it possible to access the database with another program and add info to it like comments about the album?

It's not possible out-of-the-box. You'd have to use some plugin to access the foobar2000 database.

QUOTE
also is it possible to pull stastical info from it like total trackcount and percentage of each file type?

Like that? (probably doesn't display correctly in IE)
*



yep exactly like that, hows it done?

edit - while i use firefox i opened that site in IE as well to see if it worked, it was fine.
foosion
Get this plugin and these scripts. Put foo_lua.dll into your components directory, the other two DLLs go into your foobar2000 directory. You can put the scripts anywhere you like.
When the plugin is installed, run "Components/Scripting/Run lua script...". Select dbstats.lua and hit "Run". When prompted for an LHTML file, choose Example_1.lhtml from the scripts archive. Finally choose an output file. You can edit dbstats-prefs.lua to prevent the script from asking you for the names of these files, when you want to automate the process.

Disclaimer: I have stopped development of this plugin, and I currently don't have plans to pick it up again. The plugin uses Lua 5.0 and toLua++ 1.0 (both slightly modified). Source code can be picked up from here, a few meager hints for compiling are in this readme.

If you want to learn more about Lua, visit the official Lua homepage. Recommended reading, if you want to learn about programming in Lua: Lua 5.0 Reference Manual, Programming in Lua (online version of the book by Roberto Ierusalimschy).
Druss
thank you for the help.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.