2014-10-24, 05:43 PM
I am creating a Plugin called MySurf, its a surfing system...
users can earn points on viewing sites like easyhits4u or another surfing sites
i have completed Admin Panel with settings but unable to complete user's surfing page.
i have problem in selecting site data from databse, i got confused at this point.
here is my Tables:-
mysurf_list
mysurf_log
mysurf_list has all sites that are ready to displayed in surfing page if their status is set to enable. i also add group permission on each site.
mysurf_log has logs of all sites that are viewed by users and they got paid for each site.
i also attached structure of both tables.
here is confusion:-
when a user visits MYBB_ROOT/mysurf.php then site displayed according to status, permission and dateline(this field only availble in mysurf_log).
Avoid to display duplicate site or user can view each site in per 24 hours
so now i am confused in fetching data in this case, i have other option too like check each site and each permission but they will be increase server load so i don;t think its good to add.
i am looking for a query that can automatically check those conditions ..
help in developing plugin, this plugin will very helpful for those people which want to increase traffic of their forum
Looking for best suppport
users can earn points on viewing sites like easyhits4u or another surfing sites
i have completed Admin Panel with settings but unable to complete user's surfing page.
i have problem in selecting site data from databse, i got confused at this point.
here is my Tables:-
mysurf_list
mysurf_log
mysurf_list has all sites that are ready to displayed in surfing page if their status is set to enable. i also add group permission on each site.
mysurf_log has logs of all sites that are viewed by users and they got paid for each site.
i also attached structure of both tables.
here is confusion:-
when a user visits MYBB_ROOT/mysurf.php then site displayed according to status, permission and dateline(this field only availble in mysurf_log).
Avoid to display duplicate site or user can view each site in per 24 hours
so now i am confused in fetching data in this case, i have other option too like check each site and each permission but they will be increase server load so i don;t think its good to add.
i am looking for a query that can automatically check those conditions ..
help in developing plugin, this plugin will very helpful for those people which want to increase traffic of their forum
Looking for best suppport