Great idea extreme_one, I'm in the process of moving house so apols for the delay in responding.
I've just opened the admin panel and investigated the db structure and Steve's right.
There's a bundle of fields for fish alone and then another bunch for the conflicts and then a few more for tank size, substrate etc.
It's terribly clunky and takes an age to add new fish.
Here are the fish fields
id common_name scientific_name main_text family synonyms other_names
origin natural_habitat natural_water_conditions max_size max_tankmate_size feeding tank_area ph water_hardness
min_number max_number min_temperature max_temperature min_tank_size behaviour breeding
sexing algae_eater bottom_feeder surface_dweller shoaling fin_nipper territorial plant_friendly
suitable_for_beginner south_american rift_lake african south_east_asian asian australian
size_0_5 size_5_10 size_10_15 size_16_up undefined_1 undefined_2 undefined_3 code
type_id slug meta_code map_image main_image exclude_from_cc allow_too_large
Fish types
Freshwater
Tropical
Artic
Artic2
River
Barbs
Catfish
Catfish (Corydoras)
Catfish (Synodontis)
Characins (Including Tetras)
Cichlids
Cichlids (Dwarf)
Cichlids (Rift Lake)
Anabantoids (Including Gouramies)
Livebearers
Loaches & similar
Oddballs
Rainbowfish
Rasboras, Danios & Minnows
Freshwater Inverts
Coldwater
Unknown
Tank filter and multiplier
name multiplier
Undergravel 0.8
Internal 1
Oversized Internal 1.2
External 1.6
Oversized External 1.8
and then you have to add the various conflicts, so spot on knowledge is essential.
As you might concur, with all those fields it's quite a task just to add one fish and has to be 100% factual, else people will pick out discrepancies and or argue around the details too!
Happy to add that fish you've supplied as above, but perhaps the addition of lots and lots of new fish is perhaps a tad ambitious given time constraints and what not.
I can definitely edit fish, so maybe as an interim compromise if anyone's seeing huge discrepancies then let me know and I'll correct them.
What I am also going to try and do (another suggestion from Simon) is to integrate a link in our profiles to your tank set ups in the community creator - There maybe a challenge or two as the databases and usernames are separate systems. If a person's username or email address on the forum doesn't match their email address on the community creator then...i'm pretty stuffed for linking them. That said, I am whirling it around in my head, and I don't like to concede defeat. I've just got to wait for a eureka moment!
I will also try and unite the two sign up and login systems (forums and cc) at some point,but it's a lot of coding and I don't know whether the value created is necessarily worth the pain involved in making it happen. Does anyone have a spare 50 hours I could borrow!?
Ok, I have to go and strip wallpaper now
But I hope it's given you all some food for thought - meantime, if someone wants to draw up a list of fish that have the wrong sizes or conflicts or whatever else, then please do let me know and I'll edit them when we have a completed list.
Thanks all,I hope that helps!