Topic awaiting preservation: Do some PHP work, get free hosting! (Page 1 of 1)

That's right!

I've got a simple VB application that uses an Access DB. I'd like to create a PHP/MySQL version of it that employs every feature. Not too terribly complicated.

It's a law enforcement training records application, and I have a sample version available at http://www.runningwolf.com/coptrak.zip is you'd like to take a look. You must be willing to support it to the point that all features work. We'll do the styling and make it look good. In the demo, the administrative password is 'coptrak'.

Please let me know if you're interested. I'm sure the arraingment will be mutually rewarding.

I'm up for that pugz...just email me exactly wyhat you want on there and any reelvant info (like style-sheet locations...the style-sheets themselves would be nice) and I'll get down to it.

___________________________

Skaarjj's ISP woes are not over yet...but I will return soon.

Okay....I think there are a total of three people who've decided to take a stab at this.

I also have two more projects, both in PHP/MySQL that I'll make the offer to.
The first is taking this page: http://www.missingkids.com/missingkids/servlet/PubCaseSearchServlet?act=usMapSearch&missState=MI&searchLang=en_US and stripping everything out but the data itself. Then dump the data into a MySQL table. This will run via a cron job.

The other job is much more complated.

The NCMEC offer still stands!

Take this page: http://www.missingkids.com/missingkids/servlet/PubCaseSearchServlet?act=usMapSearch&missState=MI&searchLang=en_US and stripping everything out but the data itself. Then dump the data into a MySQL table. This will run via a cron job.




[This message has been edited by Pugzly (edited 07-15-2003).]

This came out as a 15-minutes hack : http://www.maxworld.co.yu/ozone/ncmec.php.txt The script will parse that NCMEC page and store data in two-dimensional array. I didn't have time to add MySQL code, but I've added a for loop that generates HTML ordered list as an example, so it's up to you to replace this loop with appropriate MySQL code. Oh, and I would like to point out that if NCMEC ever changes the HTML code of that page, the script will probably be broken, and in that case it would require tweaking. If you have any questions, feel free to ask them...

Bastard. You make this look so easy!

The only thing I notice is that I'll need to parse the $profile[place], because one of the features I need is to be able sort based on location.

Other than that, it looks cool!

Yeah, I've thought about converting some values in computer readable form, but since this was just hack, I left them out...

Anyway, as far as $form[place] is concerned, a simple split() or substr() call would do it. Another thing that was on my mind is to convert date fields into UNIX timestamps, which would ease date formatting later.

BTW When you finish integrating my script, post a link, so that I can see it in action, heh...




[This message has been edited by mr.maX (edited 07-16-2003).]

Eh...sorry I haven't made any progress in the coptrak project...I've not been having a good time in the programming lateley...nothing seems to go right.

Ever had a time like that?

I'd probably find someone else to do this coptrak one for you...I am still willing to do any bits of work you want in return for free hosting...I've got a site I'm going to need to put online soon, so...anything else you'd like me to do?

If you want me to keep going on this coptrak one instead, I'll need to find out how you did the auto-selection lists in the session area, and also do you want any kind user authentication on anything other than the administration area?

Skaarjj - we'll take this offline, since it involves something else. Shoot me an email and we'll get it squared away. But that project is the most important one to me at the moment (you should see the data that's piling up to be entered).

I do have one more project, like the one above. Basically what I call a 'fetch & dump'. I know Emperor was noodling with it, but I think he's tied up with Gurus Network stuff....

Here's what I need to do:
Go to http://mipsor.state.mi.us/mipsor/default.htm and type in '48036' for a zip code.
I need to take the results and dump them into a database. But wait - there's more.

I actually need to cycle through an array of zip codes (I'd say no more than two dozen), and run a query for each one, dumping the results into the SAME database. This will be done once a day via cron.

Emperor is welcome to chime in here with ideas, or to claim this project for good. :-D

No biggie - just something I haven't had the time to tackle myself. Same deal goes - free hosting.

Pugzly:
Am I correct that this is the actual data you need?
(edited out names 'n stuff)

08572537
Name: XXX/XXXXX/XXXXX/
Sex: M
Race: W
Dob: XX/XX/XXXX
Height: 511
Weight: 225
Hair: BROWN
Eye: BROWN
Address: XXXXXX ZZZZZZZZZ
City: ZZZZZ ZZZ
State: MI
Zip: 48036
Offense: 750.520D
Description: CRIMINAL SEXUAL CONDUCT - THIRD DEGREE (MULTIPLE VARIABLES)

In that case I've got it now, just need to get rid of the rest of the stuff in each file I'm getting and to store it in the db.

Any particular preferences on how to store it in the db?
/Dan


{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

Don't worry about dumping it into the db. Just get it into an array, and I can cycle through it and toss it in.

Some minor changes:

Some may have an alias, or several, in the form of
Alias: last/first/middle/
Alias: last/first/middle/
Alias: last/first/middle/

And some may have multiple offenses, in the form of
Offense: 750.520D1B Description: CRIMINAL SEXUAL CONDUCT-3RD DEGREE(FORCE OR COERCION)
Offense: 750.520B Description: CRIMINAL SEXUAL CONDUCT 1ST DEGREE (MULTIPLE VARIABLES)
Offense: 750.520B Description: CRIMINAL SEXUAL CONDUCT 1ST DEGREE (MULTIPLE VARIABLES)

(the offense code, such as 750.520B, is pretty important, since I'm going to dynamically link to the actual law)

Go back and search under zip code 48043 and you'll see what I mean. I need to account for that (somehow).

Also, I'd like to parse the name into separate fields for first/middle/last.

Other than that, have fun!

Ahhhhhhhh yes this bad boy.

Basically (with help from Butcher) I have the different sections of this script working so one bit will fetch the page, one bit will process it and dump it all in the database, one bit will step through each zip code and the final bit draws it all out.

When run by themselves it all works (for example it will grab a local copy and process it and add it to the database) but whenever I brought it all together in one script it never worked. I have taken it all apart and tested the bits and put it all together again on a number of occasions all to no effect.

Sooooooooooo I can provide all the bits if that helps reduce time on this - a fresh pair of eyes might spot the error.

___________________
Emps

FAQs: Emperor

Oooo, look what just came in - another hack: http://www.maxworld.co.yu/ozone/psor.php.txt Man, I'm on fire!!!

Now, about that hosting...

Nice one mr.Max and welcome back!
I guess that does it then I'm off this one.
/Dan

{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

I'm away from the office, but I did run that once, and it did look like it was working fine. I'll have to noodle around with it once I get back.

Mr. Max, I'll contact you offline about the hosting. It's yours!

Okay....

The person who originally committed to doing the Coptrak project is no longer available. I'm upping the ante!

I need to completely implement this project in 60 days. There are a couple of minor changes, but the original offer stands.

I will give 500MB (+ unlimited domains, unlimited email, 5GB of bandwidth per month) of space for one year to the person who successfully completes this project to my specs. Due to work constraints, I will be pretty much hands off other than some guidance and the finishing styling. You, as the programmer must implement all of the features of the VB version, with the following additions:

1. Users will be able to log in and view their own data.
2. Certain 'admins' will be able to log in and view data for their divisions
3. 'master admins' will be able to log in and edit/view data for their divisions
4. 'super admin' can do anything.

This project will tie into other pieces already running, so the session/authentication is pretty much in place. Those interested in working on this will be supplied with that info.

If you're interested, please contact me offline. You only need to do the backend stuff. We'll do the style stuff.