hambeast Posted November 3, 2014 Author Report Share Posted November 3, 2014 you could try modifying my code to convert to int64 instead of 32 and see if that helps. If you have visual studio, I'd set a breakpoint along those lines and see where it is throwing the exception, exactly. Link to comment Share on other sites More sharing options...
Sandbird Posted November 3, 2014 Report Share Posted November 3, 2014 you could try modifying my code to convert to int64 instead of 32 and see if that helps. If you have visual studio, I'd set a breakpoint along those lines and see where it is throwing the exception, exactly. Yeah, i figured its something to do with that....nah dont have VS...had it but cant be bothered really to compile it for that....i'll be reconverting my db back to normal when the normal hivext gets released...i'll use it then :) Link to comment Share on other sites More sharing options...
hambeast Posted November 3, 2014 Author Report Share Posted November 3, 2014 been waiting for the hive code for... a year now lol. good luck tho. Link to comment Share on other sites More sharing options...
Defent Posted November 3, 2014 Report Share Posted November 3, 2014 Nice diagrams hambeast. I love diagrams. More please. Link to comment Share on other sites More sharing options...
Tricks Posted November 3, 2014 Report Share Posted November 3, 2014 Hey guys, sorry total noob here. I entered the info requied in the Config file. Moved all the files from the bin folder to a new folder on my desktop called Dupe Checker. I opened up my command prompt and entered "dze_inventory_parser.exe --configfile=config.xml". Didn't work obviously, what do I do next? :huh: Link to comment Share on other sites More sharing options...
Tricks Posted November 7, 2014 Report Share Posted November 7, 2014 bump Link to comment Share on other sites More sharing options...
Phobix Posted November 10, 2014 Report Share Posted November 10, 2014 There seems to be an issue with case sensitivity. if I do 'DESCRIBE dayz_epoch.object_data;" I get "does not exist. If I do DESCRIBE "dayz_epoch.Object_DATA;" it works. May need an update. Link to comment Share on other sites More sharing options...
hambeast Posted November 10, 2014 Author Report Share Posted November 10, 2014 Hey guys, sorry total noob here. I entered the info requied in the Config file. Moved all the files from the bin folder to a new folder on my desktop called Dupe Checker. I opened up my command prompt and entered "dze_inventory_parser.exe --configfile=config.xml". Didn't work obviously, what do I do next? :huh: can I get a screenshot of your console or pipe it to a text file There seems to be an issue with case sensitivity. if I do 'DESCRIBE dayz_epoch.object_data;" I get "does not exist. If I do DESCRIBE "dayz_epoch.Object_DATA;" it works. May need an update. is your sql server running on linux or windows? I've seen this happen before but not typically on windows Link to comment Share on other sites More sharing options...
Phobix Posted November 10, 2014 Report Share Posted November 10, 2014 can I get a screenshot of your console or pipe it to a text file is your sql server running on linux or windows? I've seen this happen before but not typically on windows My sql server is running on a linux box. Link to comment Share on other sites More sharing options...
Tricks Posted November 10, 2014 Report Share Posted November 10, 2014 can I get a screenshot of your console or pipe it to a text file Hey hambeast, I am using a hosted server, not sure if that is what you mean. I am totally over my head in this thread. What do u mean by a screenshot of my console? Link to comment Share on other sites More sharing options...
hambeast Posted November 11, 2014 Author Report Share Posted November 11, 2014 you are running this program thru your local console right? If so, take a screenshot of the console's output so I can see what its saying. alt + printscreen - copies the curernt picture of window to clipboard then goto imgur.com and hit ctrl+v and upload OK in other news... I'm going to release a lite version of this tool as this was more a proof of concept. I'll also release an API so you can use the functionality in the main program in your own a taste of what the API can do :D Link to comment Share on other sites More sharing options...
Sandbird Posted November 15, 2014 Report Share Posted November 15, 2014 And here is the .exe file recompiled for CharacterID bigger than int32 https://www.dropbox.com/s/ms513342cx2imuu/dze_inventory_parser.rar?dl=0 I am using arma2net and have my CharacterID table as bigint24 to fit the whole steamID. Compiled it with MSBuild...no need for vstudio :) Link to comment Share on other sites More sharing options...
Caveman1 Posted November 20, 2014 Report Share Posted November 20, 2014 Very interesting Ham will try this out. By chance does this tool show orphaned object? Meaning objects owned by players that no longer are in the player database? Also do i unerstand this correctly that this doesn,t just dump the sql but is a live connection so changes made are immediately in the database? Link to comment Share on other sites More sharing options...
hambeast Posted November 21, 2014 Author Report Share Posted November 21, 2014 I'm generalizing this but the tool pulls the inventory of all the objects in the objects_data tables and parses each item and counts them up. It is a huge pain to compare two inventories to another as the order of items is pretty dynamic, this tool allows you to do lots of neat stuff like that. As for orphaned records, if you're running a stock epoch server, each characterID key should tie to a character_data row. It does not check for orphans as far as I remember and I don't think it even looks at that although it could I guess. Link to comment Share on other sites More sharing options...
Phobix_ Posted December 15, 2014 Report Share Posted December 15, 2014 I tried to recompile with the correct case for my linux sql box, but I am getting an "outside the bounds of the array error" now. Any chance you could take a look at making this work with a linux sql box? Link to comment Share on other sites More sharing options...
hambeast Posted December 16, 2014 Author Report Share Posted December 16, 2014 I tried to recompile with the correct case for my linux sql box, but I am getting an "outside the bounds of the array error" now. Any chance you could take a look at making this work with a linux sql box? can you please screenshot the error? Also if you can send me a pastebin of your schema via pm that would be helpful as well. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now