OFBD Scraper (1 Viewer)

[bonkers]

Hi at all.

This Program parse the ogdb and mobygame site for game covers and titles for myEmulators.
I hope that will be usefull.


Update V1.2:
Shows correct Genre when game is a PC game.
Batch save process fixed.
Formular redesigned.

Update V1.3

Search Formular redesigned. Results lists in a Table.
Under preview you can add fanart / screenshots and custom Pictures.
Database scraper gamona.de added
Now auto save pictures and informations without choosing an emulator.

Update V1.3.1

When a screenshot is gif or png format then error 404 is coming up.
This fixed now Gif and PNG are supported.

When no result in ogdb found an URL Error is coming up. This is fixed.

Update V1.4

New redesign.
Windows x86 & x64 compatibility
Its an Alpha Version. Only mobygames is supported at the moment. OGDB and GAMEONA will
implement soon.

Quick start guide

1. Start the program
2. Load the myemulator database.
3. Go to the settingsmenü
4. Please associate the Platforms to your emulator in Settings and Platforms TAB
5. Now in main menu select emulator you will parse.
6. When more results for an ro / game was found please choose from dropdownbox
7. You importet games / roms you can change in the Tab manager.
8. Custom Picture will be implement soon.

I hope this is a better version as the last.

Update V1.4.1

HTML2Plain Special chars conversion added.
Catch error when no internet connection is avaliable.
Define custom filename for thumbnails and backarts.
Define creation of subdirectory with emulator title.
So i hope the plugin becomes compatibility with any skin.

Update V1.4.2

Mobygames changed their SearchEngine. Searchscript adjusted.


Bye

 

[simpman]

Hi I tried your OFDB Scraper 1.1 and get a JIT error when I try and load the my emulators db.

Here's the error

************** Exception Text **************
System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.60.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.
File name: 'System.Data.SQLite, Version=1.0.60.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139'
   at OFDB_Scraper.start.ConnectDB(String sDatabase)
   at OFDB_Scraper.start.bOpenDatabase_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I have Windows XP SP3 and put the sqlite.dll in the same folder as OFDB Scraper.exe... is there somewhere else I should be putting it? (eg C:\Windows\system32)

for looking into this

 

[bonkers]

Hi.

Please download again.
Please install the SQL Lite Runtime Library

OFDB Scraper removed from this post
Please show the next posts for new versions

 

[simpman]

This works really well! With some minor improvements it would be outstanding and something that compliments myEmulators so well, it should have been included since day 1.

here are my suggestions for improvement:

• Have the program automatically detect what system or console you're trying to emulate and only return search results from that console.
• Automatically parse filenames to remove unnessisary information like (EU), , etc. Also have the HTML parser remove <tags> and parse HTML Character Codes
  [*]Make the search results text-only. Seeing the images is nice, but it would be nice to see a nice table there instead of having to click all the items to read the text associated with them
  [*]On the game select page, it should automatically choose the emulator chosen by myEmulators as well as select the first image (I forgot to click a couple of images and had to go back and re-do them)
  [*]The main database view should be sortable (and include the system)
  

Those are my suggestions, great program hope you continue to develop it and it will definitely help give myEmulators that polish it needs.

 

[marksteel]

Hi.

Please download again

Hi, this looks like a really cool tool. But I'm having load problems with it right now. I have Vista 64 bit. This is the error I get:

ee the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.BadImageFormatException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.60.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. An attempt was made to load a program with an incorrect format.
File name: 'System.Data.SQLite, Version=1.0.60.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139'
at OFDB_Scraper.start.ConnectDB(String sDatabase)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
OFDB Scraper
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Emulators/Scraper/OFDB%20Scraper.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

 

[bonkers]

Hi marksteel.

Plaese install this SQL Lite Runtime Library and Copy the SQL.Lite.Data dll in the ofdb scraper folder.
Do not uninstall the runtime library after Copying.

 

[marksteel]

Hi marksteel.

Plaese install this SQL Lite Runtime Library and Copy the SQL.Lite.Data dll in the ofdb scraper folder.
Do not uninstall the runtime library after Copying.

Wow, thanks Bonkers! That did the trick! Great little tool.


Edit: Oh 1 thing I just noticed. Upon looking at details of a game after a search, The window cuts off the option button to select emulator. I tried expanding the window but with no luck. Any ideas?

 

[bonkers]

Hi marksteel.

Can you post a Screenshot of it? I dont know what you mean.
My window looks like the picture.

 

[marksteel]

Hi marksteel.

Can you post a Screenshot of it? I dont know what you mean.
My window looks like the picture.

Hi, here is my screen shot.

 

[bonkers]

Download the programm from the first post. Version numbers added.