Need information regarding resources for some servers

[Sobuno]

This post only regards Ahazi/Bloodfin/Chilastra/Chimaera/Corbantis/Kettemoor/Lowca/Valcyn/Test Center

I am in the process of cleaning up our database in order to strengthen the data integrity. Back in the early days of this site, the resource adding functions did not force unique names for resources. As such, there were a few duplicates around. I have managed to remove most of these as the stats were identical for the most part.

The following 4 resources, however, have duplicates whose stats are not identical, due to input mistakes or something like that, and thus, I cannot simply choose to delete one of the duplicates.

This is why I come to you.
I need to know the correct stats for:

Chilastra:
Eraris, Rhodium Steel
Eteo, Dolovite Iron
Wrisow, Polymer


As you can see by searching for the above resources using Find Resources, they will return two results (One with just the name and another with "alternative" appended to it) each. Which one is the correct?


I also need information regarding the following resources whose class is not fully determined:

Ahazi/Chimaera/Corbantis/Kettemoor/Lowca/Valcyn/Test Center

I need to know resource class for:

Ahazi:
Bisi
Efosi

Corbantis:
Odosi

Lowca:
Uno

Valcyn:
Ofac

I realize that some of these servers no longer exist and it may therefore be impossible to determine the correct resource. Any suggestions as to what we do then?

Thanks in advance,
Sobuno

[Sobuno]

Bumpity bump (Is this even allowed per our rule set?)

[Zimoon]

nope

hereby we must baneliban you

[Savacc]

Says the dude who just "bumped" his city recruitment thread...

[Monty Burns]

I need to know resource class for:

Test Center:
Avef Nabooian Water Vapor
Cofa Class1 Liquid Petro Fuel
Diris Cortosis Siliclastic Ore
Fero Dolovite Iron
Fofo Lokian Vegetable Beans
Itae Corellia Fiberplast

I realize that some of these servers no longer exist and it may therefore be impossible to determine the correct resource. Any suggestions as to what we do then?

Thanks in advance,
Sobuno

Well since I have a few TCPrime toons I figured I may be able to tidy some of them up for ya.

The correct classes for the resources are recorded in red next to the link.

Personally I would just rename the incorrect resources as their numbers are more than likely correct and it may be possible to sort them out at a later date as well.

[Zimoon]

...
Chimaera:
Igeer

...

These two are fixed, added the missing "r" to the meat and everything is sorted.

[orad]

Waonavyk

Quaranium Extrusive Ore (Bloodfin)

CR - 842
DR - 927
HR - 950
Ma - 506
OQ - 466
SR - 901
UT - 888

[Sobuno]

Updated first post to reflect the current missing information

[orad]

Valcyn:
Ofac


I checked my stock.. and I don't have any of this one.. there weren't a ton of people who moved resources off Valcyn when it went down (Other than Eenat and the Vintrium that was in spawn right before the end that is) and honestly I probably have about 80% of them.. So probably going to be hard to figure that one out!

On a funny note.. all these years and I never even realized that there were forums attached to this site!

I am such a dork lol..

[Zimoon]

better late than never

[Sobuno]

Another cleaning project (Spring just began and everything!):

Resources imported from .com back in the days with one or more stats higher than 1000. Please fix:

Flurry: Roavercht
Intrepid: Piwok
Kauri: Akiepa
Kettemoor: Faiekid
Lowca: Sade
Shadowfire: Trislerfecoar
Tarquinas: Misti
Wanderhome: Actiet

[Monty Burns]

Sunrunner done.

[Sobuno]

Sunrunner done.

Cool, thanks, removed them from the list then

[Sobuno]

All the resources in the first post should no longer have conflicting names: One variant kept the name, the other got alternative postfixed to the name (Test => Testalternative)

[Sobuno]

And the "unique server/resource-name combination" restriction is now enforced on the database-level, ensuring that this should never happen again