Navigation » MPC Club Community Board > Media Player Section > Art Work (ALL) > HDI Artwork > Zappiti » Database access/batch editing

Notices

» Slysoft Recommended!
1 CLick BD and DVD backups
Download AnyDVD HD!
For Blu-Ray and DVD!
» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Stats
Members: 88,317
Threads: 29,730
Posts: 252,155
Welcome to our newest member, Steve Zodiac
» MPC Club Advertisers and Sponsors
Reply
 
Thread Tools
Old 24-03-12, 00:25   #1
xtrips
Premium Potential
TIP: Upgrade to Premium
Addicted to MPC
 
Join Date: Nov 2008
Posts: 71
Contribution: 0.03%
Thanks: 3
Thanked 7 Times in 4 Posts
Downloads: 0
Uploads: 0
Smile Database access/batch editing

Hello,

Is there any tool/mean in order to access the Zappiti database, whatever its format is?
The objective is to batch edit my library.
I mean how can you, for example:
- look for all the movies that do not have a genre?
- select a list of movies and tag them with a new genre?

These kind of stuff.
Any idea?
xtrips is offline   Reply With Quote
Advertising
Advertising temporarily disabled
Old 25-03-12, 15:37   #2
petmal
Premium Potential
TIP: Upgrade to Premium
Almost Active
 
Join Date: Mar 2012
Posts: 3
Contribution: 0%
Thanks: 0
Thanked 1 Time in 1 Post
Downloads: 0
Uploads: 0
Default Re: Database access/batch editing

I think Zappiti uses the SQLite engine. The problem is that it is somehow encrypted... Any ideas on how to get in? I cannot find the encryption key which is suppesed to be in Zappiti.exe.config.

Last edited by petmal; 25-03-12 at 15:55.
petmal is offline   Reply With Quote
Old 27-03-12, 14:20   #3
petmal
Premium Potential
TIP: Upgrade to Premium
Almost Active
 
Join Date: Mar 2012
Posts: 3
Contribution: 0%
Thanks: 0
Thanked 1 Time in 1 Post
Downloads: 0
Uploads: 0
Exclamation Re: Database access/batch editing

Got it! The database can be opened by SQLite2009 Pro. The encryption key is: U7t3RS6EiG (RSA mode).
petmal is offline   Reply With Quote
The Following User Says Thank You to petmal For This Useful Post:
wiepie (30-03-12)
Old 02-04-12, 08:39   #4
xtrips
Premium Potential
TIP: Upgrade to Premium
Addicted to MPC
 
Join Date: Nov 2008
Posts: 71
Contribution: 0.03%
Thanks: 3
Thanked 7 Times in 4 Posts
Downloads: 0
Uploads: 0
Default Re: Database access/batch editing

Originally Posted by petmal View Post
Got it! The database can be opened by SQLite2009 Pro. The encryption key is: U7t3RS6EiG (RSA mode).
Thank you! I got in, but, bad surprise...
I couldn't find a table where the movies showed up with the categories they belong to.
Do you know of any method that could help me batch edit the movie's categories?

Thanks
xtrips is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


» MPC top List...

TOP 5 Regular media players

  • Popcorn Hour C-300 (81%)
  • Mede8er Med500x2 (80%)
  • Dune SMART (D1) (65%)
  • HDI Dune Base 3.0 (52%)
  • DViCo TViX X-Roid (00%)

TOP 5 Hybrid media players

  • HDI Dune BD Prime 3.0 (75%)
  • HDI Dune HD SMART B1 (74%)
  • PoPCorn Hour C-200 (68%)
  • HDI Dune MAX (54%)

We do not recommend currently...

  • Xtreamer products
  • Hantech products
  • MViX products
  • DviCo products
  • HDX products
Powered by vBadvanced CMPS v3.2.1 - twisted by vbTwist and Hi-Jack (MPC Club)