Find Jobs
Hire Freelancers

A few ASP pages with DB and some server-side commands

$100-500 USD

Dibatalkan
Disiarkan lebih dari 11 tahun yang lalu

$100-500 USD

Dibayar semasa penghantaran
**_Simple web-based Database for users to self-register their devices_** Must be written in classic ASP or ASP.NET, will be hosted on IIS 6, 7, or 7.5 MS Access or multiple text file back-end (cannot be SQL based) **_Page 1.a / Self-register new device:_** ID Number: First Name: Last Name: Device IP: Browser user agent: Device Type: First seen: - After user press's Next, check that the ID number is valid and matches what the DB holds for their first or last name, if the ID and at least one name field (first or last) is not matched, then return to the self-registration - If ID number is matched to the first or last name, then save the info in the DB and proceed to page 2. **_Page 2 / Get MAC address of the device:_** ASP page should run command-line "arp -a" on the server or some similar method to obtain the MAC address of the device (the device is connecting to this webserver with no router in-between) When MAC is found and added successfully then proceed to page 3. **Page 1.b / I've already registered this device:** ASP page with the following input fields? ID Number: Device IP: - After user press's Next, then use their referring IP to check if the MAC of the device (run "arp -a" or similar, just like on Page 2) is already in the DB. If the IP is different then update the DB with the current IP. Either way update the last seen date/time stamp in the DB. After this is done proceed to page 3. - If the MAC is not found then display the message: Sorry, we haven't seen this device before, do you want to try again(-link to page 1.b) or register this new device(-link to page 1.a)? **Page 3 / Thank you** **Page 4 / Search for a previous registered device** **Page 5 / Device statistics** ## Deliverables **_Simple web-based Database for users to self-register their devices_** Must be written in classic ASP or ASP.NET MS Access or multiple text file back-end (cannot be SQL based, don't worry this is a very low-load website) If using a text file, we suggest the filename be the ID number, ex: [login to view URL] Structure of the file can then be something like? line1: first name line2: last name line3: device_IP / browser_user_agent / device_type / First_seen / Last_seen / MAC address line4: (same as line 3, but with details of the next next device registered to this same user) line5: (same as line 4, etc?) **_Page 1.a / Self-register new device:_** ASP page with the following input fields? ID Number: First Name: Last Name: Device IP: - *make this a read-only field where the current referring IP is pre-filled* Browser user agent: - *make this a hidden field where the current user's browser info is saved* Device Type: - *drop-down to select?* Laptop running Windows Laptop running MAC OS Laptop running Other (such as Linux, or unknown) Phone running Android Phone running IOS (such as iPhone or iPod touch) Phone running Windows Phone running BlackBerry OS Phone running Other (or unknown) Tablet running IOS (such as iPad) Tablet running Android Tablet running Windows Tablet running Other (or unknown) Any other device First seen: - *make this a hidden field where today's date and time is saved* Last seen: - *make this a hidden field where today's date and time is saved* - After user press's Next, check that the ID number is valid and matches what the DB holds for their first or last name, if the ID and at least one name field (first or last) is not matched, then return to the self-registration (page 1.a) with the notice in red: ID number or name not found. - If ID number is matched to the first or last name, then save the info in the DB and proceed to page 2? **_Page 2 / Get MAC address of the device:_** ASP page should run command-line "arp -a" on the server or some similar method to obtain the MAC address of the device (the device is connecting to this webserver already, with no router in-between, so the webserver machine should have the MAC in it's ARP table) Display some text "processing?" if this page takes a while to run. Parse the list produced from "arp -a" to match the device's IP with the MAC, then save the MAC to the DB. - If no MAC is found, or the MAC is ff-ff-ff-ff-ff-ff or 00-00-00-00-00-00 then display an error on the page. - If MAC is added successfully then proceed to page 3? **Page 1.b / I've already registered this device:** ASP page with the following input fields? ID Number: Device IP: - *make this a read-only field where the current referring IP is pre-filled* - After user press's Next, then use their referring IP to check if the MAC of the device (run "arp -a" or similar, just like on Page 2) is already in the DB. If the IP is the same, that's fine leave it - if the IP is different then update the DB with the current referring IP. Either way update the last seen date/time stamp in the DB. After this is done proceed to page 3. - If the MAC is not found then display the message: Sorry, we haven't seen this device before, do you want to try again(-link to page 1.b) or register this new device(-link to page 1.a)? **Page 3 / Thank you:** Display a message thank you, you may now use your device. **Page 4 / Search for a device:** ASP page with the following input fields? ID Number: Device IP: Device MAC: When any of the 3 fields is filled out and user press's Search, then return all the details from that ID number in the DB **Page 5 / Device Stats:** ASP page with the following links? Find oldest devices (return a list of 20 devices where the Last Seen time is furthest from today) Find newest devices (return a list of 20 devices where the Last Seen time is closest to today) Find devices that have never returned (return a list of 20 devices where First Seen is same as Last Seen) Device popularity (display a bar graph or count of how many devices of each Device Type)
ID Projek: 2764111

Tentang projek

1 cadangan
Projek jarak jauh
Aktif 12 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
1 pekerja bebas membida secara purata $251 USD untuk pekerjaan ini
Avatar Pengguna
See private message.
$250.75 USD dalam 20 hari
5.0 (25 ulasan)
4.6
4.6

Tentang klien

Bendera UNITED STATES
Lake Zurich, United States
5.0
4
Ahli sejak Mei 19, 2003

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.