Improvement of the Telegram bot

Databases & SQL, PHP — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

Project: Integration of saving and loading player data in Telegram Mini App through a database.

Goal:

Set up a system for saving and loading player data in the database instead of the device's local storage. Ensure that when the player re-enters the game, the player data (balance, progress, and other parameters) is correctly loaded from the database and saved to it upon changes.

What has already been implemented:

Game logic in Construct — player data is saved in localStorage, but now it needs to be stored in the database.
Backend in PHP — the main files (getBalance.php, saveBalance.php) have been implemented, but there are issues with their operation.
Telegram Mini App — obtaining telegram_id through the Telegram WebApp API, but it is not always processed correctly.

What needs to be done:

Fix data loading:
- Check that getBalance.php correctly accepts telegram_id and returns data.
- Ensure that when the game starts, data is loaded from the database and not reset to 0.
Fix data saving:
- Check saveBalance.php to ensure that when the balance changes, it is correctly recorded in the database.
- Add logging of requests to debug_save.txt and debug_load.txt.
Check that telegram_id is passed correctly:
- Add console.log in getData and saveData to ensure that telegram_id is not undefined.
- Check that a record is created in the database for each new player.

Technical details

Frontend: Construct 3
Backend: PHP + MySQL
Hosting: Nginx (VPS)
Database: MySQL

What will be considered task completion?

✅ The game loads the player's balance from the database upon startup.
✅ Changes in the game are saved in the database and are not lost after a restart.

Proposals 6

Roman Smolyakov

33 1

Budget: 8000 UAH Deadline: 14 days

Good day! I am always available to help. Write to me, we will discuss! And don't forget to check out the portfolio — there is a lot of interesting stuff there!

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 14 proposals 31 July

Not specified
Construction of an automatic scheme for the movement of goods and monetary flows

32 proposals 30 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 41 proposals 27 July

178 USD
Development of an analytical system with a dashboard

Enterprise Resource Planning (ERP) 43 proposals 20 July

Not specified

Yury Karnashin
Kyiv, Ukraine

Projects 4
Rating -
Rating 164

Roman Smolyakov

Proposals are currently absent

Current freelance projects in the category Databases & SQL

Development of the CRM module "Requests" in custom 1C (bus center)

Construction of an automatic scheme for the movement of goods and monetary flows

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Development of an analytical system with a dashboard