How can I reset the scores of the game on certain days using firebase in "Unity"

Question

How can I reset the scores of the game on certain days using firebase in "Unity"

I want the scores I marked in the picture to be reset every day, every week, at the end of every month, in short, when their time comes. How can I do this?

Answer 1

What you want to look into is the Cloud Functions feature called scheduled functions.

If you're only familiar with Unity, you'll want to follow this getting started guide for more details. The basic gist of it is that you'll create a tiny snippet of JavaScript that runs at a fixed schedule and lets you perform some administrative tasks on your database.

I'll try to encapsulate the basic setup:

• install Node
• run npm install -g firebase-tools
• create a directory where you want to work on functions - you probably want to to do this outside of your Unity directory
• run firebase login to log in to the Firebase CLI
• run firebase init (or firebase init functions) and follow the steps in the wizard to create some functions code to test
• when you're ready to use them in your game, you can use firebase deploy to send them off to the cloud.

From the Scheduled functions doc page, you can see this example of how to run a function every day:

exports.scheduledFunctionCrontab = functions.pubsub.schedule('5 11 * * *')
  .timeZone('America/New_York') // Users can choose timezone - default is America/Los_Angeles
  .onRun((context) => {
  console.log('This will be run every day at 11:05 AM Eastern!');
  return null;
});

You can use these with the Node Admin SDK. Something like:

// Import Admin SDK
var admin = require("firebase-admin");

// Get a database reference to our blog
var db = admin.database();

exports.scheduledFunctionCrontab = functions.pubsub.schedule('5 11 * * *')
  .timeZone('America/New_York') // Users can choose timezone - default is America/Los_Angeles
  .onRun((context) => {
  db.ref(`users/${user_id}/`).update({userGameScore: 0, userMonthScore: 0, userScore: 0, userWeeklyScore: 0});
  return null;
});

Of course, here I'm not iterating over user ids &c.

One final note: this is a very literal interpretation and answer to your question. It may be easier to (and save you some money if your game scales up) to write a score and timestamp (maybe using ServerValue.Timestamp) together into your database and just cause the scores to appear zeroed out as client logic. I would personally first try taking this approach and abandon it if it felt like it was getting too complex.