Improvement of the Telegram bot
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_idthrough the Telegram WebApp API, but it is not always processed correctly.
What needs to be done:
Fix data loading:
- Check that
getBalance.phpcorrectly acceptstelegram_idand returns data. - Ensure that when the game starts, data is loaded from the database and not reset to
0.
- Check that
Fix data saving:
- Check
saveBalance.phpto ensure that when the balance changes, it is correctly recorded in the database. - Add logging of requests to
debug_save.txtanddebug_load.txt.
- Check
Check that
telegram_idis passed correctly:- Add
console.logingetDataandsaveDatato ensure thattelegram_idis notundefined. - Check that a record is created in the database for each new player.
- Add
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.
Current freelance projects in the category Databases & SQL
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 6 hours 32 minutes back ∙ 24 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 3 days 1 hour back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 5 days 5 hours back ∙ 55 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 5 days 5 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 5 days 18 hours back ∙ 10 proposals |