Jump to content
  • Welcome Guest To Mopar1973Man.Com

    We are a Dodge Ram Cummins Turbo Diesel forum. We are very friendly and helpful group of Dodge Ram Cummins owners. We will try to keep your truck running the best we can and provide information for diagnostics, repairs and even guide you on the best replacement parts to use. 

     

    Registration is free. Registering on the site will provide access to many more things like...
     

    • Contribute to the Forum being able to ask questions and get support for your Dodge Ram Cummins.
    • Contribute to Article Database adding your ideas and suggestions.
    • Classified Ads posted by the members. Post up your used parts and vehicles.
    • Member Garage where you can proudly display your vehicles and modifications that you have done to them.
    • Download files, documents, and Quadzilla Adrenaline tunes for your truck.
    • 911 Support Network. We've got a group of members will to aid you if your truck breaks down on the road.
    • Reduced Advertisements displayed to you.

Sign in to follow this  
Mopar1973Man

Software for the site...

Recommended Posts

Well gang...

winter is coming to Idaho soon. I've got a crazy idea for a software I want to build for the site. I've been hunting all over the internet for something even close but never found it yet.

Ok... I need to explain myself. Currently I'm using a program called Automotive Wolf to track my maintenance on my vehicle. But then I thought like yeah with today's economy nobody can just throw money at software for a purpose like this. But I started studing MySQL and PHP for the past few nights and getting a rough road map of design made up.

I'm looking to build a stand-alone program for now that will track your vehicle(s) maintence records. But I'm wanting to have a average calculator that can try to predict when next oil change is going to be and send you a email notifing the owner of that maintenance.

Being I've never really created a PHP program it going to very rough and crude at first but I'm going to give it my best shot. The first few small program I produced is the ratio calculator (Liters/metric) here.

<?php   $gal = $_POST["liter"];  $rat = $_POST["ratio0"];  $ozfuel = (1000 * $gal);  $mix = ($ozfuel / $rat); ?>

So now to move beyond the simple few lines of code to a wider idea to try and help my group of vehicle owners...

I'm open to ideas and suggestions...:smart:

--- Update to the previous post...

Like last night I did the studying and reading up for how to layout the database to hold the information on the server. Now I'm working out what information I need to capture from the members or users... But the more I think about it I'm might barrow or share information from vBulletin (forum) so registered members can just click and enjoy.

Like on the template layout I'm going to most likely use defined constants for the text layout of the screen.

I need to contact vBulletin and find out if there is any special login requirements so I can access the database.

Oh the ideas and dreams running through my head right now... I've got all winter to get something slamed together... :drool:

Share this post


Link to post
Share on other sites

having some php and a bit of MySQL DB history, I can try to help you if you'd like. Im more familiar with SyBase and Oracle DB space, but I do deal with ColdFusion, PHP and the likes..

Share this post


Link to post
Share on other sites

Cool. :thumb1: I'm still very greeen to the PHP programming and learning as we speak... I've been reading "PHP & MySQL for Dummies" to bone up. It simular to older BASIC programming back in the day... But then add the MySQL server tosses a monkey wrench in things... So I've been playing with smaller programs to get boned up and then start playing with the idea of a maintenance database of the members...

Share this post


Link to post
Share on other sites

I'm getting my notes and ideas hammered out on what I want to store for data... Ultimately I want to be hooked to vBulletin database for the user data but for my first program I'm going to build my own solo database for now. (Safer for the Forum :rolleyes:) But here is the information I want to capture... [ATTACH]1825[/ATTACH]

Mopar1973Man Vehicle Maintenance.doc

Share this post


Link to post
Share on other sites

Michael, within your table structure, you've got subtables (using maint. int. table as an example), that have (from what I understand) variables.. Ex:

MAINTENANCE INTERVAL[INDENT]AIR FILTER[INDENT]InspectionReplace[/INDENT][/INDENT]
Are these essentially "Yes/No" or "either/Or" selections? Are these to be a drop-down option for the fields in which you want to populate user data? Are you not allowing NULL values?

Share this post


Link to post
Share on other sites

Michael, within your table structure, you've got subtables (using maint. int. table as an example), that have (from what I understand) variables.. Ex:

MAINTENANCE INTERVAL[INDENT]AIR FILTER[INDENT]InspectionReplace[/INDENT][/INDENT]
Are these essentially "Yes/No" or "either/Or" selections? Are these to be a drop-down option for the fields in which you want to populate user data? Are you not allowing NULL values?
At this point they should be filled with non-null value of the next service of each.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  



×