RESOURCE SMARTERS V4 + TELEGRAM BOT ( KEEP THE BOT.PHP PAGE OPEN TO GET THE REPORTS )

Rapidic3

Member
Joined
Jul 15, 2021
Messages
38
Awards
3
Offline
CODE STILL BEING WORKED ON BUT THOUGHT ID SHARE AS ITS WORKING FINE.

Right guys ive seen a few folk ask for this,.

Now the way ive done it might not be 100% the correct way. but it works for me and will only send the latest report.

So its using a php script to send information from the database table to telegram bot.

first make a bot using bot father on telegram,then make a channel and add that bot as an admin

upload the bot.php to /api/ folder where the .db file is.

now the bot is pulling from this table name ( rtxreport ) might differ from mine depending what panel you have. but you need to find the correct table for the data to pull.


"SELECT * FROM rtxreport


YOU'LL NEED TO CHANGE IN THE PHP FILE

ADD YOUR TELEGRAM API HERE

ADD YOUR TELEGRAM BOT USER WITH @





upload to hosting. ive got the script refreshing the page every 10 seconds( probs too fast but still tweaking and testing) but if you add it to a cron job. it will run without having the page open.
somebody will no doubt improve the code..

cheers


rapid
 

Attachments

  • Capture.PNG
    Capture.PNG
    13.8 KB · Views: 265
  • photo_2024-01-06_23-43-55.jpg
    photo_2024-01-06_23-43-55.jpg
    102.3 KB · Views: 262
  • photo_2024-01-06_23-51-50.jpg
    photo_2024-01-06_23-51-50.jpg
    250 KB · Views: 262
Last edited:

IɴғɪɴɪᴛᴇSᴛʀᴇᴀᴍs

Moderator
Staff member
VIP Member
Joined
Apr 7, 2021
Messages
1,163
Awards
4
Offline
CODE STILL BEING WORKED ON BUT THOUGHT ID SHARE AS ITS WORKING FINE.

Right guys ive seen a few folk ask for this,.

Now the way ive done it might not be 100% the correct way. but it works for me and will only send the latest report.

So its using a php script to send information from the database table to telegram bot.

first make a bot using bot father on telegram,then make a channel and add that bot as an admin

upload the bot.php to /api/ folder where the .db file is.

now the bot is pulling from this table name ( rtxreport ) might differ from mine depending what panel you have. but you need to find the correct table for the data to pull.


"SELECT * FROM rtxreport


YOU'LL NEED TO CHANGE IN THE PHP FILE

ADD YOUR TELEGRAM API HERE

ADD YOUR TELEGRAM BOT USER WITH @



*** Hidden text: cannot be quoted. ***



upload to hosting. ive got the script refreshing the page every 10 seconds( probs too fast but still tweaking and testing) but if you add it to a cron job. it will run without having the page open.
somebody will no doubt improve the code..

cheers


rapid
Thanks for the contribution mate
 

Rapidic3

Member
Joined
Jul 15, 2021
Messages
38
Awards
3
Offline
Please report back guys if this is working ok for ya. be nice to see some images of it working or reports back.,

cheers

rapid
 

Rapidic3

Member
Joined
Jul 15, 2021
Messages
38
Awards
3
Offline
also if having issues remove remove the _bot at the end of the chat ID. @ i had this issue to start with.
 

doubled

Active member
VIP Member
Joined
Oct 31, 2023
Messages
40
Awards
3
Offline
U can add the python code to check for any changes in the reports database and of is egual to true the send the post
 

Rapidic3

Member
Joined
Jul 15, 2021
Messages
38
Awards
3
Offline
U can add the python code to check for any changes in the reports database and of is egual to true the send the post
you could make this work how ever you want. the idea is what folk was missing and how it worked. i hope this would be worked on maybe for a few other ways to access to .db file mabye via telegram. to easy update panels.
 

credibletv

Well-known member
Joined
Jul 31, 2022
Messages
142
Awards
3
Offline
instead of getting it from DB make, take it from API trigger with that you dont need to keep the page open
 

Rapidic3

Member
Joined
Jul 15, 2021
Messages
38
Awards
3
Offline
also on each table you can pull what ever you want so then mabye could send those with expi

“If you have knowledge, let others light their candles in it.”​

 
Last edited:

credibletv

Well-known member
Joined
Jul 31, 2022
Messages
142
Awards
3
Offline
also on each table you can pull what ever you want so then mabye could send those with expi
Its quite easy bro you can jsut generate it with the chatgpt, i dont find this option too usefull or valued enough to make it cause most of the people are Reseller and they dont have any control over it instead just transfer the complaint to provider
 

Rapidic3

Member
Joined
Jul 15, 2021
Messages
38
Awards
3
Offline
Its quite easy bro you can jsut generate it with the chatgpt, i dont find this option too usefull or valued enough to make it cause most of the people are Reseller and they dont have any control over it instead just transfer the complaint to provider
yeah it could become a cluster fuck with all the reports, but you could code it to send a msg after 10 reports of the same channel. then that might be worth looking into, send directly to an admin. then bob's your uncle.
 
Top