Đã Hủy

Php Script for logging users(repost)

Hi,

Please read the DETAILED DESCRIPTION for a good understanding of what this project is about.

This project requires 3 different scripts.

[1] The first script will work like this:

I will supply: [url removed, login to view]

[2] The second script does the following:

This one is simple, it will be called like this:

[url removed, login to view]

[3] Now, the third script. The [url removed, login to view]:

This script will show me(the admin) the stored information.

Again, please read the DETAILED DESCRIPTION!

Regards.

## Deliverables

Hi,

This project requires 3 different scripts.

[1] The first script will work like this:

I will supply: [url removed, login to view]

It will first try to find the username in a mysql table, if it is not found, a new entry will be created which will contain 4 fields: USERNAME, HWID, FIRST_LOGIN_DATE, FIRST_LOGIN_TIME. These should be filled with the supplied info and the current date and time should also be stored. It will then add this entry to the "complete logs table" as explained below and do "echo '1'" after.

If an existing username is found then it will compare the supplied HARDWAREID to the hardware id for the matching username. If a mismatch happens, it will first fill in the following fields in the "complete logs table": USERNAME, LOGIN_DATE, LOGIN_TIME, REASON. Most of these fields are self-explanatory however the REASON field should say "Hardware ID mismatch!"(this info will later be displayed in the admincp). After this the script should "echo '0'" so that my software knows it did not succeed.

If there is no hardware id mismatch or if the hardware id field is empty the script should "echo '1'".

[2] The second script does the following:

This one is simple, it will be called like this:

[url removed, login to view]

The script should find the username in the complete logs table, and add the GAMENAME to the last entry associated with the user. This script will always be called after script1.php.

[3] Now, the third script. The [url removed, login to view]:

This script will show me(the admin) the stored information.

1. The admincp should look somewhat like the one in the following screenshot: [url removed, login to view]

As you can see it contains 2 different tables, the first one "All active users" should go through both tables in the mysql database and find the following:

From 1st table: the username, first login date and hardware id.

From the 2nd table: last login date and last game. The last login date is basically just the last entry in the logs table associated with the username.

All this should be sortable in ascending or descending order, for ex. pressing "Username" in the table should display all usernames in ascending order clicking again should display in descending order etc.

The second table, this one should use the cut off date(top of the page) after I put in a cut off date and press "APPLY FILTER" button it should fill in this table with all users who have logged in after the cut off date, it should first parse the "complete logs table" to get a list of all usernames whose "LAST_LOGIN_DATE" is more than the cut off date, after this it should look for the first_login_date and hardware_id for the users(that passed the filter) from the first table.

Next, clicking on a username in any of the lists should display all logs associated with him in the LOGS box at the bottom. The log should again be sortable in ascending/descending order just like with the other lists. There will also be 3 buttons at the bottom of this box: Delete User, pressing this should delete the user from the first table. Delete Logs: pressing this should delete all logs associated with the user from the "complete logs table" and the Reset Hardware ID: pressing this button should empty the hardware id field from the first table.

Finally, there is a 4th box the "Most played Game" one, this should display the game that has the most occurances in the "complete logs list", after the cut off date.

It should show the game name, and the number of users that have played it.

Clicking on the games name should fill the "Filtered List" with all the users that have played it, after the cut off date.

Thats it!

Regards.

Kĩ năng: MySQL, PHP, Kiến trúc phần mềm, Kiểm tra phần mềm, Web Hosting, Quản lý website, Thử nghiệm trang web

Xem nhiều hơn: look php id, echo press, 3-1 table games, architecture games, first users, active filter, php mysql display existing table, php sortable, reason supplied user, php script last, list ascending, php log found, sortable table, display sortable table php, mysql delete mysql database tables, order entry database software, active admin php, mysql parse date, table sortable, php script read table

Về Bên Thuê:
( 71 nhận xét ) stockholm, Sweden

ID dự án: #3593152

9 freelancer đang chào giá trung bình $34 cho công việc này

cr8tivewebexpert

See private message.

$42.5 USD trong 6 ngày
(171 Nhận xét)
7.5
bhavin12300sl

See private message.

$42.5 USD trong 6 ngày
(232 Nhận xét)
6.4
paulmartin84

See private message.

$40 USD trong 6 ngày
(49 Nhận xét)
5.4
galaxywebtechvw

See private message.

$25.5 USD trong 6 ngày
(8 Nhận xét)
4.4
cutequaidian

See private message.

$35.7 USD trong 6 ngày
(3 Nhận xét)
2.1
rcastro78

See private message.

$35.7 USD trong 6 ngày
(1 Nhận xét)
1.4
opendemos

See private message.

$25.5 USD trong 6 ngày
(2 Nhận xét)
0.7
2ddesign

See private message.

$30.6 USD trong 6 ngày
(0 Nhận xét)
0.0
mrkendy

See private message.

$30.6 USD trong 6 ngày
(0 Nhận xét)
0.0