DSAccountManager Version 1.4

Yay!

Thanks for invaluable tool. Works OK!
Just a small glitch as it can be seen.

So is M1C developing this now?

Also @sumanuti, wow, those names remind me of the time I played on EU.

M1C wrote:
@Alex, I’ve done nearly all in changes this version, yes.
I’ll also continue doing this if someone needs something.

@sumanuti, thanks for your report!
I’ll look into this tomorrow (GMT+2).

@Alex, Yea we started to gather again, like in old good times.

@M1C, While r u at this, have few proposition if they doable without much effort.
1. Option to remove Characters by System in online list
2. Option to adjust server local time or the time to be collected from OS
With or without this - its perfect tool as I said!

and ur welcome

M1C Exellent work, i used it already from svn )

M1C wrote:
@sumanuti: Everything done.
At the moment I’m not able to test it (due to a FL-Bug…), but it should work. If it doesn’t tell me

Marvelous
Works fantastic!

Hey Guys,

We recently changed over our SVN because a bit of a fuck up on my part.We deleted c:\fwtow and reinstalled FL (install dir under d:\install). Dowloaded svn and after that reverted it. Set flhook socket on and passworded (This is FL Hook 2.0). Installed DSProcessManger. We are unable to get DS Account Manager (1.4.1) to work at all. It keeps on saying it’s unable to load the playeraccount settings. I then removed all the player accounts and started fresh, but still the error comes up. This is the error coming up in the dsaccount log:

Opening database… Loading game data… Error ‘Could not load file or assembly ‘System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139’ or one of its dependencies. An attempt was made to load a program with an incorrect format.’ at at DAM.DataAccess.Dispose() at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e)

In the FL Hook 2.0 log connects properly.

I also tried 1.4.0 and got the same result.

Any ideas on what is wrong?

Sounds like you’ve got a bad System.Data.SQLite.dll file. This is unrelated to FLHook. My suggestion is to try re-downloading DSAM 1.4 and using it’s System.Data.SQLIte.dll.

=Alex= wrote:
Sounds like you’ve got a bad System.Data.SQLite.dll file. This is unrelated to FLHook. My suggestion is to try re-downloading DSAM 1.4 and using it’s System.Data.SQLIte.dll.

Ya, tried that, several times. Didn’t work, sadly. Just comes up with this error

Error ‘SQLite error
no such table: CharacterList’ at at DAM.DataAccess.GetConnection()
at DAM.DataAccess.GetBanList(BanListDataTable dsTable, Boolean onlyExistent)
at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e)

No such table ‘CharacterList’? What? Are you sure your dsam.db is not corrupt?

=Alex= wrote:
No such table ‘CharacterList’? What? Are you sure your dsam.db is not corrupt?

I’ve deleted it just be sure it wasn’t causing an issue. It comes up with that error every time.

M1C wrote:
The System.Data.SQLite error is known, I tried many things to fix but… but none worked…
Hmm there are a few bugs on my list… I’ll have to find some time to fix them…

Sushi are you sure you deleted the right db? and is the Char File Directory set to the right value?
It should create all missing tables in “GetConnection()”…

The character file directory is set to the multiplayer file. I deleted the .db in the multiplayer file. It has 0 bytes, though.

Any other thoughts?

Not sure if this will help or not, but a couple things you can check:

1. go to: http://sqlitebrowser.sourceforge.net/ and download this applicaiton. once downloaded run it, and open the dsam.db file. verify that the table: CharacterList has actually been created. and contains the following table columns:

CharPath, AccDir,Charame, IsDeleted, Location, Ship, Money, Rank, Created, Updated, OnLineSecs, LastOnline

2. verify that you are running the correct ‘bit depth’ version of dsam.

3. if 2 is correct, verify that the System.Data.SQLite.dll for your bit depth is actually the correct bit depth dll for that version.

if none of the above works for you load the ‘DSAccountManager_2010.sln’ in Visual Studio 2010 (if you do not have VS 2010, download the VS C# Express Edition from Microsoft) , open DataAccess.cs, find the line:

private SQLiteConnection GetConnection()

and set a breakpoint on the first if statement in that function and step through it one line at a time, this will tell you what line is actually barfing the error. Then post here what line number throws the error. This will help narrow down where the problem is.

Sushi wrote:
Error ‘Could not load file or assembly ‘System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139’ or one of its dependencies. An attempt was made to load a program with an incorrect format.’ at at DAM.DataAccess.Dispose() at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e)

Give it what it wants: 1.0.66.0 version

HeIIoween wrote:

Sushi wrote:
Error ‘Could not load file or assembly ‘System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139’ or one of its dependencies. An attempt was made to load a program with an incorrect format.’ at at DAM.DataAccess.Dispose() at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e)

Give it what it wants: 1.0.66.0 version

Thanks for the link. Tried it and I got the same issue but with this error

Error 'SQLite error
no such table: CharacterList' when updating db
Loading player information...
Error 'SQLite error
no such table: CharacterList' at    at DAM.DataAccess.GetConnection()
   at DAM.DataAccess.GetBanList(BanListDataTable dsTable, Boolean onlyExistent)
   at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e)