Last post Feb 26, 2014 07:52 PM by oned_gk
Feb 26, 2014 01:21 PM|TmoodASP|LINK
My website primarily allow user to watch videos and give scores. We have a team of 15 viewers and the number of videos uploaded to the website varies daily. However, because we have 15 viewers and only two viewers can view each videos -- because some viewers
quickly claim too many vidoes and not giving other viewers a chance -- I have to set up a limit to each viewers.
I need to set up a limit of 3 views per week per viewers.
I did some searches try to look into something similar to weekly emails but I wanted to see if there's an alternative solution to my dilemmas..
Any assistant would be greatly appreciated!!
Feb 26, 2014 02:44 PM|wavemaster|LINK
Add a table:
videoid, viewerid, date
User clicks on video then you check if that particular video has a recordcount of 2, if so then that video is not available to leave score
At the same time you check if that particular user has already scored two videos.
With the data in there as well you should be able to figure it out.
Feb 26, 2014 07:52 PM|oned_gk|LINK
You can try like this :
Create week group (week1, week2, and soon)
If User.IsInRole("week" & Now.DayOfWeek) Then
Dim grp As Integer = Now.DayOfYear Mod 7
If User.IsInRole("week" & grp) Then