Find Jobs
Hire Freelancers

Most Active User Stats

$30-250 USD

Completed
Posted almost 6 years ago

$30-250 USD

Paid on delivery
What I want to do is pull a list of online users from a file on my webserver (i will maintain the file and can make it show with tags before and after the username if that helps). I want these usernames to be added to a mysql database and if the username isn't already in there then to add it. I want to track how active each user is. I am ok with something like a database that just has the date and a tally count in minutes, so for example today is 6/5/2018 if i pull the user list every 15 minutes then the value associated to todays date of 6/5/2018 will have +15 added to it. I am just a novice coder so if you have a better way to hold a ton of activity data let me know. I then want to have a website that shows a list of the online users sorted by most minutes online in the last 7 days but also show the stat for minutes online in the last 30 days. I picture it going like this: Code grabs userlist, checks if username is already in the database, if its not then it adds the username. It then checks to see if todays date is already in the database if not then it creates the table (or whatever its called) for todays date . The value of +15 is added to todays date to signify 15 minutes as the code should run every 15 minutes (I may change the frequency in the future). I figure i'll put this in a cronjob or something that runs every 15minutes? I also want separate code for me to be able to search a username and have it calculate the number of minutes spent online in the last 7 days and last 30 days.
Project ID: 17113777

About the project

8 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Greetings! I will like to work on this project. I am Web application and software developer having many years of experience. In past i have worked in various project so i have gain knowledge about implementing various libraries, apis and debugging application. Skill Java, php, javascript, C++ C# and different other web technologies such as css html node.js ajax json and various software development techniques and methodology. Pm for more detail and budget discussion. Thank You!Have a good day
$30 USD in 1 day
4.9 (3 reviews)
2.6
2.6
8 freelancers are bidding on average $114 USD for this job
User Avatar
Hi there, You'll need two tables in database, one is for the users that store unique username for every one and the other table is to store the online activity for each user (database relation here). Message me to discuss more details. Regards, Amr
$200 USD in 3 days
5.0 (117 reviews)
7.6
7.6
User Avatar
I read your project description ……Most Active User Stats …..and we are very exited to work on it We are an group and we have an expert & qualified to accomplish your project in professional & unique We are working all section of integrated solution And for project ………………Most Active User Stats ……. There are an specialist expert that can make your project like you want and more! We are looking for delivering unique services and add all feature that make your project is complete and professional You can check our sample and previous work before we start in work We provide for you the best services with the lowest prices
$50 USD in 3 days
4.9 (68 reviews)
6.6
6.6
User Avatar
I have 5 years of experience in web development . Feel free to contact me .........................
$100 USD in 3 days
4.9 (52 reviews)
5.1
5.1
User Avatar
Greetings! ***IMMEDIATE START*** I read your job requirements carefully. Your job profile completely matches my skills. I have got 4 years of work experience in working with MySQL, PHP for INTERNATIONAL CLIENTS. I can help you with your given job by providing you quality work. Thanks
$155 USD in 3 days
5.0 (22 reviews)
4.6
4.6
User Avatar
​​With an overall experience of 12 years in creation and development of digital properties and online marketing activities, all my solutions are process based. With a customized solution that meets business objectives, my solid understanding on the basic principles of marketing enables me to give you a competitive edge. I believe in the following: Solutions that ascertain growth: This is more than just a slogan. I promise to embody my commitment in developing solutions with results. Your Digital Collaborator: I work with you. Understanding your business aspects, I strive to produce interactive campaigns. I offer a full spectrum of digital services with end-to-end solutions that achieve your objectives. Being Meticulous: I pay attention to your requirements and needs and yet never lose sight of the big picture. Delivering outstanding results: Irrespective of the deliverable, I diligently strive to improve the brand's demand, build trust, generate revenue and create brand loyalty for your customers.
$102 USD in 2 days
5.0 (5 reviews)
1.9
1.9

About the client

Flag of UNITED STATES
LEXINGTON, United States
5.0
8
Payment method verified
Member since Jun 5, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.