Thanks guys. Hoping to get some free time in the next few days to finish out this month.
Between work and the new kid time has been super tight.
I'm a bit over halfway finished with the php/sql platform. It's in a very usable state right now to include secured individual logins and registration. When submitting a fillup users have the choice to include the fillup in their monthly aggregate for competition. 2 fillups of at least 6.1 gallons are required to be entered monthly. Users can choose to exclude all but their best tanks and the system will tally stats based on everything. Diesel users and our friends overseas are not excluded; the system allows for the input of liters, imperial gallons, and kilometers then converts that to US gallons and miles. Optionally users can enter cost per fuel unit but only in us$ as currency conversion would cause unnecessary bloat.
What is completed?
Registration, login, sessions, fillup submission form that also includes entries for common modifications (exhausts, intakes, wheels, bellypan, tunes, ported manifolds, and so on), full submission list sorted by mpg, monthly aggregate sorted by mpg, monthly aggregate filtering (if you wanted to view the end results from July of 2012 or other months), view all submissions by user, and a dashboard that is still wip.
TODO:
Uniformity of design, complete the dashboard, add filtering by trim, style, engine, mods, etc., awards system, and whatever else I think of. 1/4 mile archive?
Biggest PITA so far:
PHP:
$query = "SELECT *, SUM(FuelAmount) AS xFuelAmount, SUM(Distance) AS xDistance,
(SUM(Distance) / SUM(FuelAmount)) AS xMPG FROM `mpgdata` WHERE Aggregate=1 AND
SUBSTR(`Date`,5,2)='$month' AND SUBSTR(`Date`,1,4)='$year' GROUP BY Username HAVING
count(Aggregate) >= 3 AND xFuelAmount > 12.2 ORDER BY xMPG DESC";
^-* count(Aggregate) >= 3
should actually be >= 2
For submission rules I will go with the consensus. They can be changed easily.
