An good idea from BAR.

mecold

New member
I noticed this link on the zoanthid forums.
http://www.bareefers.com/bar/viewforum.php?f=17&sid=8e92365207cd0c128c4d0391bc7f3e55

A nice premise with it. It is interesting, and a good way to share some common and not so common corals. Kinda like ssweet1's xenia and kenya tree :) (I think about everyone has some of her frags by now either directly or indirectly).

I would be willing to put up a frag or two of zoo's or some of my better growing sps. What do you all think?
 
This sounds very interesting. Maybe we could do the same if enough people want to do this.

Not sure how elaborate we would want it, but if we want to keep it simple to begin with I recommend having a dedicated forum for this and perhaps each "parent" of the frag(s) have it's own thread for tracking. It would be up to the recipient of the frag(s) to provide updates in the thread of who they have given a frag to and so on. I don't recommend doing this on RC, but on NFMAS.com. If needed, I can host a forum for this and it could be accessed from NFMAS.com.

A much better way of tracking this would be to use a database. I opt for this approach verses the one above. I can help with the database design and hosting it on the internet. I am not too much into web site development. If anyone has web design skills with db integration I'm sure we could pull this off.

The types of tracking methods I just mentioned were discussed in the link mecold provided.

High level db concept may look something like this:
  • The Parent table would have one record for each parent frag given
  • and would contain pertinent details,
  • but most importantly the parent frag would be auto assigned a unique id.
  • The unique parent frag id would be included as a column in the Daughter table.
  • The Daughter table would contain records for every "daughter" frag "paid forward" and include its own details.
  • The unique parent frag id will "stay" with all daughter frags to track it origination and how it has been passed down.
We could even have a few "canned" queries available on the site for reporting on things like...
  • how many parent frags has a user given,
  • how many daughter frags has a member received,
  • how many daughter frags did the member pass on,
  • which frag has the most history.
  • What are the most common type of frags being "paid forward".
As far as the details we would want to include, it could benefit the recipients of new frags by including details such as the conditions the coral was kept under (this could show throughout its "family tree") and maybe a free form comment as to how well it grew in each recipients tank under their own tank conditions.

Do we have anyone in our club that could help with the web development aspects? Like I said I can contribute to the db and hosting if needed or work with someone who also wants to help with this... more minds are better than one!
 
nfmas.com already had a db and hosting set up. It should be no problem to develop this, I just want to make sure that there is enough interest in this project before we put a lot of effort into it. I am swamped with work at the moment but if you want to spearhead the planning stage and work with me on development then we could get a project like this up within a few weeks. Let's discuss it at the next meeting and see how much interest there is.
 
Sounds good. Like you, I always have a lot going on ...hence why I usually read and post to the forum in the late evening hours. I try to check in at RC, off and on, during the day to see what's going on.

I agree, it would be a waste of time if there is not enough interest. Since I'm new to the club I'm unaware of how much trading that goes on.

If there is a lot of interest, what are your thoughts about us hosting a site dedicated to this for other clubs to use as well. I personally think this is a great concept. Each club would have their own section ( own db and dbadmin). I'm sure we could get sponsors to cover the hosting cost if space/bandwidth increased over time, but this should not be too much of a concern to begin with. I think this could be something that can benefit other clubs as well as further promote "tank raised" coral propagation and sharing to reduce buying corals from the wild. It also may encourage ppl to participate more since they could track how the daughter frags of their parent frags are circulating.

My 2cents.
 
I can definately help out with the web site development since it's what I do for a living.
Not much going on at work at the momement.

Joseph, what does the NFMAS site allow for database and website development?
MySQL and PHP?
 
I like the silent auctions that Orca has. This way everyone gets to see everything available and pays what they feel comfortable with.
 
<a href=showthread.php?s=&postid=6874182#post6874182 target=_blank>Originally posted</a> by grochmal

Joseph, what does the NFMAS site allow for database and website development?
MySQL and PHP?

Yes, PHP 4.3.10 and MySQL 4.0.16.
So far the code for the site has been quick hacks in my spare time over the years so it does not follow a true MVC framework pattern.
 
Back
Top