Freelance projects

Freelance projects

Telegram bot

Bot Development, Databases & SQL — incorrectly specified categories?

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

Good day, it is necessary to develop a Telegram bot.

The Telegram bot is needed for sending messages (questions) to subscribers of the bot.

Its functions:

Admin panel buttons: example on the screen.

1. Tournament

2. Distribution

3. User statistics. (Statistics of people who have joined the bot)

1. Tab ''Tournament'' is divided into buttons:

1. Start the tournament (The tournament session begins)

2. Add a question -- (After clicking, a form for submitting a question appears.) What the form looks like - First, the text of the question is entered and an image is added, then text for answer buttons "YES" - "NO" or "Vova" - "Kolya". Next form (How long the question will be active, I enter the time, or choose to close manually.) - Next form with points (I choose how many points a person receives for a correct answer. For "YES" answer - 7 points, for "NO" - 3 points)

Then a question is sent to all bot subscribers. (I have attached how it should look in the file)

The bot stores all participants' answers in an online table. Here is a link to what the table looks like - https://docs.google.com/spreadsheets/d/1u703PO-R5FRGiEeVxX6KWVtqZp17N6zY1XbirPjIYg0/edit?gid=0#gid=0

After the event has taken place. We go to

3. tab "Close question" where we have the opportunity to indicate which answer was correct YES/NO. After closing the question, participants are credited with their points, then a message is sent to the person whether they answered correctly or incorrectly - example "You answered YES to question #3 and receive 7 points. Congratulations" for those who answered "NO" - "You answered NO to question #3 and receive 0 points". Then our Google table is formed online.

This is what the "Tournament" tab should look like. Example on screens + video of preparing questions.

Admin panel - Distribution:

1. This is simply the ability to send subscribers information in text format or text + photo (with sound or without sound)

Admin panel - Statistics

3. User statistics. (Statistics of people who have joined the bot) example on screens.

Features that should be included:

1. Adding 2 questions at the same time with the ability to close them regardless of the order of publication.

Buttons:

1. Start the game (Informational post about the tournament)

2. My statistics - gives the choice:

1. General tournament table (When clicked, redirects the person to a Google table)

2. My statistics (When clicked, provides the person's results - their place in the tournament table and the number of points)

4. Rules (Information about the bot. Picture + text)

More details will be discussed during the call.

Proposals 22

Yevhenii Hudymenko

23 0

Budget: 4000 UAH Deadline: 3 days

I specialize in developing Telegram bots "turnkey".
I have similar completed projects on collecting user data and on sports topics.
I can implement everything in a short time.
Write in private messages

Oleksandr Stinkovyi

117 0

Budget: 15000 UAH Deadline: 14 days

Hello.

I develop Telegram bots in NodeJS. Ready to start. Write me, let's discuss.

Artur Lavrinovich

63 1

Projects 63
Rating -
Rating 8 125

Budget: 20000 UAH Deadline: 1 day

Good day! Ready to develop a Telegram bot for sending messages and conducting tournaments. Looking forward to clarifying the details and starting work!

Andrey A

24 0

Projects 24
Rating -
Rating 849

Budget: 8000 UAH Deadline: 14 days

Good day!
Ready to take on the task.
Write in private messages - we will discuss the details of cooperation.

Vladislav Greshnov

3 0

Projects 3
Rating -
Rating 512

Budget: 6000 UAH Deadline: 14 days

Good day.
I am ready to perform your task.
Please write to me in a personal message to discuss in more detail the terms of reference, payment, and deadlines for the work.
I will be glad to cooperate with you!

Andrii Shmagala

53 4

Projects 55
Rating -
Rating 2 281

Budget: 5000 UAH Deadline: 5 days

Good day. I have extensive experience in developing Telegram bots. I will develop on Python aiogram, SQL, Google Sheets. I will implement a database, save to a Google spreadsheet, the bot itself, and an admin panel. Also, if necessary, additional functionality.

Reviews in profile

Yuliia Lomykina

0 0

Projects -
Rating -
Rating 207

Budget: 4000 UAH Deadline: 7 days

Good day.

Developing a bot with the described functionality will take up to 7 days.
Cost based on the description in the specification: 4000 UAH.

Additional functionality, for an additional cost:
- Scheduled messaging
- WebApp for creating and managing tournaments. A web form, instead of step-by-step tournament description in Telegram. The form will open in the bot (an example of a WebApp is Notcoin, TapSwap).
- Detailed admin panel in the form of a WebApp with extended statistics and user and tournament management.
- Transferring the tournament table from Google Sheets to the admin panel (depending on what is more convenient)

Development stack:
Node.js, Telegraf, React, Ant Design, Express (depending on approved functionality)

It's better to host on a VPS. But we can discuss a convenient way.

It's better to discuss all the details over a call,
have a nice day

Vadym Riabchenko

5 1

Projects 6
Rating -
Rating 200

Budget: 3000 UAH Deadline: 3 days

Good day, ready to develop a bot according to your technical specification, quickly and qualitatively, waiting for your message to discuss one detail.
Writing in Python3/Node.js + SQLite3/MySQL/PostgreSQL