MWnpcdb_050_default0_3 - Page 2

mollymillions · #16 10-04-2003, 07:24 PM

Is there a technique for importing characters items when importing characters from a 0.44 databases? I assume you have to extract (and convert?) the item data from the character_.profile blob and populate the new character_.inventory blob.
I guess this information is already available but I haven't located it yet.

Trumpcard · #17 10-04-2003, 11:59 PM

Quote:

The first statement returned two rows. I removed these entries from the database and was able to get pass the charater screen and into the zone. I'm not sure if this did it because I did alot of other data normalization and came up with a completly different database than the one I initially started with. But it works.

Very possible... Incorrect handling of NULLS is often the source of many problems. If you could recreate it and verify for sure it happened right there (Backup your database, put the original database back in, test, remove the offending entries, test) and let us know exactly what stage of the zone server boot it occured at, we could put some checks in the code to make the server more robust when it encounters bad data...

tcsmyworld · #18 10-06-2003, 10:38 AM

It seems that one of the starting items is the crash problem.
One of the starting items has an itemid of 0.
Remove the entry with itemid 0 from starting_items table and it should work.
I'm putting fixed files up on same links , so won't be an issue anymore.
Sorry for any inconvenience , but this IS still just in alpha stage

Trumpcard · #19 10-06-2003, 10:42 AM

Hmmm... I'd still like to know the offender..

The code I merged of krich's for starting items should handle the 0 item id correctly, it did on my machine at least...

krich · #20 10-07-2003, 04:38 PM

Trump,

Here's the code you added to avoid the crash problem:

Code:

                                const Item_Struct* myitem = database.GetItem(atoi(row[0]));
                                if ( myitem !=0)

The problem is that I tracked down the source of the crash inside of the GetItem method. You won't get to check myitem!=0, because it's too late, world has crashed already.

This is what I saw in my testing. GetItem calls something in the Mutex library and I really didn't want to mess with that stuff. If I get a chance, I'll try to reproduce and give you a gdb backtrace.

Regards,

krich

AK1122 · #21 10-30-2003, 10:20 PM

Hmmmm... tcsmyworld.. ur db link is broken..

Could some1 mirror his file, or could you tcs put it up again? =)

If you wanna use my site as a mirror:
ftp://ak1121.no-ip.info
just drop it into uploads and ill put it in home folder n post link

Thank You

Kroeg · #22 10-31-2003, 01:43 AM

removing itemid 0 from table starting_items causes serious errors when you source the sql... is this supposed to happen?

devn00b · #23 10-31-2003, 04:19 AM

As i have posted in a different thread, I host all tcs files, my webserver recently canged my addy from : http://nctimes.net to forcing this addy http://www.nctimes.net

Tcs hasnt updated his dns you can reach any of his files at the following location

http://www.nctimes.net/~threeofus/db/<instertcasesensitivefilenamehere>.ace

thank you and have a nice day

tcsmyworld · #24 11-01-2003, 10:32 AM

Kroeg , only one item in starting items needs to be removed , it's the item with id# 0.