Points handling solution

Points handling members log on only once on the same day, how to handle it, find the idea, the timestamp of the last database logon time type, and record the time and ip address. Determine whether the ip address exists today. Do not accumulate points, explore reference: record time and ip. Determine whether the ip address exists today. If it does not exist, add points. then, change the IP address to log on ., In fact, I think credits can be processed using online time.
The member logs in only once on the same day. how can this problem be solved? the time stamp of the last database logon time type?

------ Solution --------------------
Record the time and ip address. Determine whether the ip address exists today. Accumulate points only when the point does not exist
------ Solution --------------------
Discussion

Reference:

Record the time and ip address. Determine whether the ip address exists today. Accumulate points only when the point does not exist


Change the IP address to log on.

------ Solution --------------------
In fact, I think it's okay to use online time, that is, how long it takes to get online today. as long as there is online time, it means that he hasn't logged on.
------ Solution --------------------

Points are added when the last time obtained is less than date ('Y-m-D', time ().

Change the last logon time of the member.


Discussion

Reference:

Reference:

Reference:

Record the time and ip address. Determine whether the ip address exists today. Accumulate points only when the point does not exist


Change the IP address to log on.


It turns out to be a member. You don't need to use the ip address to determine the time and membership.


Ask again. can you give me more details and determine if the user is logged on the same day? that is, points can be added from.

------ Solution --------------------
1. create a database table check with the member and time fields. you can add other fields as needed.
2. when a member logs on, check whether the member has logged on today (select * from check where member = '$ user' and time =' $ now '). If yes, the member will not perform the points operation, if it does not exist, perform the point operation and insert the member name and time to the check table today.
(Insert into check ('member', 'time') values ('$ user',' $ now '))
3. for database optimization, it is recommended to regularly clean the check table (for example, once a day: delete from check where time)
------ Solution --------------------
Time comparison
------ Solution --------------------
The above is the pseudocode, just to make you better understand
You may need to modify it.
------ Solution --------------------
Test Reply