[QUESTION] Really weird String (most likely) problem

[Vortalex]

See that gray text of a different spell description all the way across the tooltip? Yeah...

It started doing this after my last edit, and it's not just this spell or this description, it's a bunch of random spell descriptions on each spell. No idea what's causing it. Nothing that I can think of may have caused this so if anyone has any suggestions?

Btw: The edit was done in the Spell.dbc

[Vortalex]

I found out what is wrong, but I have no idea how it happened. A bunch of strings in the Spell.dbc decided to randomly disappear... and when I say random, I mean RANDOM. The string table completely fucked itself. A lot of strings have CHANGED their ID values! What the fuck!?!

My new question, is there any way for me to replace the entire string folder of my editted DBC with one of a non-editted DBC? Any softwares out there?

[deep6ixed]

This might work...

Convert the Corrupted Spell.DBC to CSV, I opened the DBC in MyDBCEditor and saved as CSV.

Open the CSV file with Excel and clear out all the columns with text.  Make sure you leave the str as the first row if using MyDBCEditor.  Save.

Open a clean and working Spell.DBC in MyDBCEditor and select Export Strings as patch, save this patch somewhere you can find it.  

Open the Corrupted Spell.CSV with MyDBCEditor, and choose Apply Patch, and load in the patch you made in the last step.  It should take about 30 seconds and the strings should appear back.

Give it a shot and let me know if this fixed it.

[Vortalex]

MyDBCEditor refuses to open the edited CSV file because it has an incorrect filesize.

------------

To give a visual on what is seen in the DBC, here is what it looks like: http://oi42.tinypic.com/2eb8pye.jpg

[deep6ixed]

Can you post the corrupted DBC file?  I have a few more tricks up my sleeve that I might be able to try

[Vortalex]

I'm sorry but that file is confidential. Top secret, hush hush kind of stuff.

[schlumpf]

Sorry for your loss, then, but without the file, one can't help you.

[Vortalex]

I don't understand why I need to hand over a file. I'm not asking for anyone to fix it for me, I'm asking for a software that allows me to remove strings, and add in new ones. Excel obviously didn't do the trick, it gave me a file that was too small to edit (5kb).

[deep6ixed]

This is what happens when things go wrong, I'm the DBC guy for the Maruum Project, and I can tell you that sometimes there is no simple way to fix something.  You might need to keep tinkering until you figure it out.  

MyDBCEditor and DBCUtil are the two main programs I use along with Excel.  You might have to try several different programs and various different methods to make it work.  There might not be a simple use this program and fix it solution.

Can you open the DBC with MyDBCEditor?  Does it convert to CSV with DBCUtil?  

I see by your pic that you use Tallis, I don't... Ive found that it can lead to strange problems like this.

And as for secrecy, most of us here who can help you, have no honest care of what is exactly in there.  I'm not going to read 75,000 spells to see anything new.  I might see a name and go "huh that sounds cool."  But I've got my hands full reverse engineering and documenting how the DBC functions, to really look at anything in depth.

[Vortalex]

I use MyDBCEditor and Tallis both for different things. It was easier to take a pic of the strings if I pulled it up in Tallis, but the editing done that corrupted the file was via MyDBCEditor.

After having saved the corrupted Spell.dbc into a Spell.csv via MyDBCEditor, then opening it in Excel and removing all the fields of text and resaving, I got a file that was around 5kb which was too small for MyDBCEditor to open. Maybe you guys can just walk me through the process of fixing that. I'm sorry but the file is really dear to me I couldn't possibly give it out before it's complete.

[deep6ixed]

Without knowing what exactly is going wrong, I have no idea where to go from here.  

Sorry.

[stoneharry]

Sounds like string block saving did not go correctly which means there is no feasible way to recover the lost and corrupt data. Depends how bad the file is and we would need to see it in a full hex view to tell.

If you used my spell editor it has been known to corrupt rarely.

What you should take from this? Backups.

[Vortalex]

Ahaha I had a backup but I accidentally saved over it with the corrupt file. Pretty fail.

But anyways, if the string is fucked, could I just copy the custom spells from the corrupted dbc into a new Spell.dbc and just rewrite the strings? I'm asking because I don't know if there are any software limitations of trying to pull that off.

[deep6ixed]

The steps I showed worked exactly when I fucked up the maruum dbcs when we first went to both German and English DBC files.  Why your getting a 5kb file from excel is odd.  When you open the exported csv in excel does it have all 240 colums? All the spells?

I did something similar once and that's roughly how I fixed it.

It sounds like your just modifying spells and not adding new ones.

[Vortalex]

This is what it looks like when I pull up the freshly converted Spell.csv in Excel: