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)