PHP/SQL MPG WebApp

[ungawd]

I reworked the menubar in JavaScript to allow groups with dropdown links. It will go through some alterations as I'm not satisfied with how it's laid out.

Here's a note to consider when using the filter form. If a checkbox group such as trim has no items checked then it is the same as having them all checked. So, if you wanted to include all engines and styles just don't select any from either of those groups.

 

[joe truck driver]

must apologize... enter cents on cost and can find no way to edit...oops threw off the cost,

 

[ungawd]

must apologize... enter cents on cost and can find no way to edit...oops threw off the cost,

If your fuel unit is US Gallons then your fuel unit cost is price per gallon. The system does all the calculating for you. If the pump shows $3.599 per gallon enter that sans the $.

 

[ungawd]

Oh. To view details or edit a fillup click on the date in the fillup information. You should be able to see all your fillups listed chronologically in your dashboard.

 

[ungawd]

Updated first post with more of a description since the app is nearly completed. It really could use more testers if everyone could please give it a shot. I currently hold the only dragstrip data and would love it if others would input their data whether real or not. It desperately needs some digits so I can see if the sorting and everything works. I'd also like some feedback on user experiences; what seems flaky, what could use improvement, what could be added. Thanks.

 

[joe truck driver]

i fixed it, thanks.... guess... i'm ...just... a.... stupid... truck driver?

can't help it.

last year i lernt how to spel tuck diver...no i r one

 

[taketwoaspirin]

I poked around a bit more tonight and tried a little bit to break it, as promised in the other thread. I'm assuming that you know about the more obvious bits, such as the SQL being displayed on the viewfilter page, and will fix those in due time.

The first thing that threw me off a little bit was the need to create a "loadout" without really knowing what one of those was. Once I figured out what it was, I had little trouble entering one; I did pause over the octane calculation method, but figured the default was safe. I suppose I could have googled that, but it's past my bedtime.

I tried a couple of bad names for my loadout, but it seems you've got those sanitized nicely. I did run into one bug where I created a second loadout with the same name (well, that part was intentional); when I attempted to delete the second one, both were removed. At least when I recreated it, it seems that my previous fill-up reconnected correctly. Before recreating it, I went back to the dashboard and tried to click on the link to my loadout; the resulting page had lots of undefined variable errors. On other aggregate pages, my entry simply didn't show due to the missing row in the join table; that's likely just fine.

The "Leaders" entry and the "Awards" table are inconsistent in how they treat back-dated tanks; my back-dated tank doesn't show on the "Leaders" table, which I have a recollection is intentional, but it does show in the "Awards" table. Whether I checked the "include in competition" button seems to have had no effect on either of these. Is that intentional?

I'm probably going to fill up tomorrow, since I have to be at the gas station to get gas for the mower anyway, and that'll give me an excuse to play around some more.

 

[ungawd]

I poked around a bit more tonight and tried a little bit to break it, as promised in the other thread. I'm assuming that you know about the more obvious bits, such as the SQL being displayed on the viewfilter page, and will fix those in due time.

The first thing that threw me off a little bit was the need to create a "loadout" without really knowing what one of those was. Once I figured out what it was, I had little trouble entering one; I did pause over the octane calculation method, but figured the default was safe. I suppose I could have googled that, but it's past my bedtime.

I tried a couple of bad names for my loadout, but it seems you've got those sanitized nicely. I did run into one bug where I created a second loadout with the same name (well, that part was intentional); when I attempted to delete the second one, both were removed. At least when I recreated it, it seems that my previous fill-up reconnected correctly. Before recreating it, I went back to the dashboard and tried to click on the link to my loadout; the resulting page had lots of undefined variable errors. On other aggregate pages, my entry simply didn't show due to the missing row in the join table; that's likely just fine.

The "Leaders" entry and the "Awards" table are inconsistent in how they treat back-dated tanks; my back-dated tank doesn't show on the "Leaders" table, which I have a recollection is intentional, but it does show in the "Awards" table. Whether I checked the "include in competition" button seems to have had no effect on either of these. Is that intentional?

I'm probably going to fill up tomorrow, since I have to be at the gas station to get gas for the mower anyway, and that'll give me an excuse to play around some more.

This is the type of response I've been waiting for. Thanks for your diligence.

The sql query being shown is mentioned previously in this thread. I used it to aid in creating the query generator. It was a major pain and left it in just so people could see it; temporarily of course.

The loadout, octane methods and such will be detailed when I create and implement the help system. To get a handle on how it operates you'd have to read this thread for the time being.

The leaders and awards behaviors are intentional. When submitting a fillup that's older than 3 days with the competition flag checked it will be removed and it will alert you on the confirmation page. The competition flag is only used by the monthly leaders list and does not affect the awards. The full scope of awards aren't yet implemented, but from some which are it can be seen where only competition tanks wouldn't be justifiable.

If you want to keep track of real data you can use your existing username. What it needs is a good bit of fake data to ensure it all works so I encourage multiple accounts for testing in this approach. Some things are a bit screwey and I know several issues already. I need to know what users are experiencing and what their expectations are. It's in a state of usefulness right now with minor annoyances, but the plan has evolved into a much larger, yet manageable, system than I first conceived.

Again, thanks very much for your input. It is greatly appreciated.

 

[joe truck driver]

liked the app ...i liked the awards page...did have trouble with log in ,but found it was my mistake and was easily fixed. log in using my user with out spaces and it loged my in with the same pass code. I deleted other entry.

 

[taketwoaspirin]

A couple more notes; the fillups archive and the dragstrip archive both have paginations that just keep going, even though the entries do not. I also noted some oddness in the number of entries per page in the fillups archive, not sure if that was intended or not.

Also, for those of us who are prone to losing the sticky note with the password on it, could you please add some kind of a password reset feature? I um may have done that recently...

 

[ungawd]

A couple more notes; the fillups archive and the dragstrip archive both have paginations that just keep going, even though the entries do not. I also noted some oddness in the number of entries per page in the fillups archive, not sure if that was intended or not.

Also, for those of us who are prone to losing the sticky note with the password on it, could you please add some kind of a password reset feature? I um may have done that recently...

The extended pagination is the consequence of PDO and the inability to check if the database returned a result. PDO is a real pain in the butt in some instances. I can suppress the errors in code when there is no result but that's it. The old easy method was to count the results returned from the query and paginate based on that; that simple method is no longer workable. My math in the query is probably off thus resulting in missing entries in the archive. It probably skips the real page 3, 5, 7 and so on. It's not intended and is also a casualty of PDO.

The current registration and login system was quickly implemented for record accountability during testing. The original intent was to send the application, when completed, to this site's owner(s) to hook into and use the forum's session username without a seperate user accountability system. I contemplated adding a password reset feature comprising of a user-generated question and answer but due to the lack of interest garnered I didn't get around to it. I imagined it would be more acceptable than asking for personal details such as email address, phone number, or whatnot and wouldn't be viewed as me trying to datamine information from people for personal gain. People are reluctant to give out personal information and I sympathize with that.

Anyway, I can set your password to whatever you want if you pm me on here, but I cannot retrieve your current password as it's hashed using SHA 256-bit encryption. I think I mentioned previously in this thread that my password is 1234 just for simplicity.