Lighting Survey

[DLeDeaux]

I'm working on a very rudimentary lighting survey at http://www.doodlefrog.com/aquarium/index.php

It is just a study in lighting intensity levels, as I'm just curious to see how everyone is lighting their tanks.

The green band through the center shows the "optimal" lighting of 2 to 3 watts per gallon. I'm curious to see how much that deviates on the upper and lower ends of the size spectrum.

The graph is self updating, so if you enter a larger tank size it will accomodate that size after the page has been reloaded.

Enjoy

[GulfCoastAquarian]

Interesting survey! I'm subscribing to this!

[DLeDeaux]

Cool, I'm glad you like it. I'm messing with a new set of tools called jpgraph. I typically try to learn how to use something new like this by doing a personal project (because I'm more driven to complete it) and then I apply my new found knowledge to a project here at work.

I'm still messing with some of the features of the jpgraph tool, so the graph will probably change a little over the course of time.

One of the things that is next on my list is adding some options to drill down to set a range of aquarium sizes to that the graph shows more relevant information.

[DLeDeaux]

Bug Fixes:
Fixed problem where optimum range was not displayed properly when a low range was selected.
Low filter can no longer be higher than high filter. Graph returns to unfiltered state in this instance.
Fixed stylesheet problem

Enhancements:
Graph now substracts 1 from low end and adds 1 to high end in a filter mode so it is easier to see desired data.
Added statistics

[Scorpion]

Awesome!

[infin]

since most tanks range from 1-150 gal, is there a way you can just graph that portion seperate, instead of showing all the way to 500

[GulfCoastAquarian]

Just select the low and high limits on the left side. You can shoose to see tanks between, say, 20g and 55g.

[DLeDeaux]

I'm also working on a logarithmic version that can be seem here.
www.doodlefrog.com/aquarium/wpgavg_log.php

[Daemonfly]

Tried to enter my 2.5g with 13w, but either it didn't take it, or it put the 2.5 at 2.0

[DLeDeaux]

It never occurred to me that someone might have a tank size with a decimal point in it. I set up the fields in the database as INTEGER fields. I'll have to go back and make the change and convert to decimal. Might be a while though, I'm up at work still trying to resurrect an exchange server and I won't be done anytime soon and then I'm going home to sleep.

[Nordic]

Can you make it so that when its viewed your PC's little plot point has a diffirent colour from the rest please.

[DLeDeaux]

Originally Posted by Daemonfly

Tried to enter my 2.5g with 13w, but either it didn't take it, or it put the 2.5 at 2.0

Ok, decimals are allowed now. You can enter a tank size up to 9999.9 gallons.

Originally Posted by Nordic

Can you make it so that when its viewed your PC's little plot point has a diffirent colour from the rest please.

There are ways of doing it, but it wouldn't be 100% reliable. The only two ways of doing it without going to a login based scheme is by IP and/or cookies.

I do log the IP address of entries, but only for security reasons. That way the same tank entry can't be entered 500 times by the same person whether by accident or on purpose. If there is some malicious activity I can easily weed out the offending records based on IP as well.

Now, I could highlight the entry based on IP but it would really only work if you were on cable modem or dsl, and even then it might only highlight it for a little while depending on how often your IP changed. Dialup it would be totally useless since you get a new IP every time you connect.

I could do a cookie based scheme, but it's a too late for all of the entries that are already in there and that's not 100% reliable since cookies can be cleaned out.

Now using a combination of IP and cookies would give better overall performance because I could check for the presence of a unique string in a cookie file and update the IP in the database based on the cookie, and then if the cookie were gone I could recreate the cookie if the IP matched with the database. Honestly, I never really thought about doing all of that on this project though.

*phew* Bet you weren't looking for a tutorial on web authentication, were ya?

<-- Webmaster extraordinaire

So, at this point really, the only option would be IP based. I'll see if I can implement it a little later when I get a little time. I'm off all next week for Christmas so I'll be looking for stuff to do.

[Nordic]

I was thinking more in terms of session management, where yes, you would assing an ID to the viewer, but wont record it.

It will just show your point diffirent directly after having submitted it