As part of my quest to consolidate all of the modding resources in one place, I've started to upload the Maplantis DB to SEN. As of now I've uploaded all of the GRPs.

Where do you come in? Well... all of the description and author information was lost. I've done my best to fill it in from memory, but it turns out there are a lot of files that I just don't remember where they came from. (The problem will only get worse once I start uploading all the other, non-Maplantis files I have lying around. At least I had some partial notes to go with the Maplantis stuff...)

I would really appreciate it if people were able to look through the DB and see if there are any files marked with author "Unknown" that they recognize. A lot of the names of files are placeholders too.

Do you happen to have some SQL for the maplantis DB? I might be able to install a copy of that on my latova version and speed things up a bit. I only have files you have sent to me but I don't find sql dbs.

No, I only have the files - hence the problem.

If I still had access to SEN's SQL stuff I could give you the maplantis table again. I don't think I kept it, I can't find it

EDIT:
lol disregard here it is.

EDIT2:
It opens in Excel if you open in notepad and ctrl+h ; with ,

Attachments:

Post has been edited 1 time(s), last time on Apr 12 2016, 4:53 am by FaRTy1billion.

Do you have the table structure? Maybe I could write an excel macro to parse the content into something more... readable

EDIT:

Nevermind, I did it anyway and half guessed stuff.

The database has filenames, descriptions, etc. I figure we can probably tell what is what via filesize. The filesize is stored in the db and chances are almost all of the files have different filesizes so we can figure out what is what that way since all the files are just randomly ###.zip (If you have the same files I have, voy)

ACTUALLY. A lot of the ZIPs contain the grp filename inside. which IS in the DB.

Here: have my formatted version of it. Without the ; delimiter farty's one has. Hopefully it's more readable this way.

Attachments:

Post has been edited 2 time(s), last time on Apr 12 2016, 7:03 am by Corbo.

Thanks Farty, that's helpful. Do we have a table of Maplantis user IDs somewhere? Mine is apparently 79 and I can guess a couple others from the submissions, but for people that only submitted a few files it's more difficult...


I had them as the ###.zips originally but I renamed them all a while ago to help Hercanic when he uploaded them to Modcrafters. (Also so I could find stuff when modding)