function db_log($botname, $action, $chat, $type, $content, $date)
{
global $LOGS_ENABLED;
if (!$LOGS_ENABLED) {
return;
}
if ($content != null) {
$content = "'{$content}'";
} else {
$content = "NULL";
}
$q = "INSERT INTO Logs(bot, action, chat, type, content, date) VALUES('{$botname}', '{$action}', '{$chat}', '{$type}', {$content}, '{$date}');";
db_nonquery($q);
}
public function movetostate($state)
{
global $STATES_ENABLED;
if (!$STATES_ENABLED) {
return;
}
if ($this->chat == null) {
return;
}
$q = "UPDATE States set state='{$state}' WHERE bot='" . $this->botname . "' AND chat='" . $this->chat . "';";
if ($this->getstate() == null) {
$q = "INSERT INTO States(bot, chat, state) VALUES('" . $this->botname . "', '" . $this->chat . "', '{$state}');";
}
db_nonquery($q);
}
$DELETEEXISTENTWBHOOK = false;
$REGISTERWEBHOOK = true;
$TOKEN = "...";
$SSLCERTIFICATEFILE = "@certificate.pem";
$WEBHOOKURL = "https://www.yourwebsite.org/webhook.php";
$SETUPDB = true;
$SETUPDBQUERIES = ["CREATE TABLE `Logs` (`id` bigint(20) NOT NULL AUTO_INCREMENT, `bot` varchar(100) NOT NULL, `action` varchar(100) NOT NULL, `chat` int(11) NOT NULL, `type` varchar(30) NOT NULL, `content` varchar(250) NOT NULL, `date` varchar(30) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `bot` (`bot`,`action`,`chat`,`date`));"];
include_once "lib/telegram.php";
if ($DELETEEXISTENTWBHOOK) {
echo "Deleting registered webhook...\n";
$bot = new telegram_bot($TOKEN);
$bot->set_webhook();
echo "Deleted!\n";
} else {
// you can register a new webhook only if you're not deleting existent webhook
if ($REGISTERWEBHOOK) {
echo "Registering webhook...\n";
$bot = new telegram_bot($TOKEN);
//$bot->set_webhook();
$bot->set_webhook($WEBHOOKURL, $SSLCERTIFICATEFILE);
echo "Registered!\n";
}
}
if ($SETUPDB) {
echo "Configuring Logs database...\n";
foreach ($SETUPDBQUERIES as $q) {
db_nonquery($q);
}
echo "Configured!\n";
}
echo "Installation completed!\n";
