Li2f6zSB

1<?php
2
3//Name of you main file
4include 'command.php';
5
6
7# Dati del database [Mysql]
8$db = [
9
10//True to activate the Database - False to disactivate it
11'status' => false,
12
13//User of database [Default: root]
14'user' => "root",
15
16//password of Database
17'password' => "",
18
19//IP of the mysql server [Default: localhost]
20'host' => "localhost",
21
22//Name of the Database
23'db_name' => ""
24];
25
26// If the Database 'status' is 'true', the database will connect with the database and creare a table
27if ($db['status']) {
28try {
29    $PDO = new PDO("mysql:host=".$db['host'].";dbname=".$db['db_name'], $db['user'], $db['password']);
30    }
31catch(PDOException $e) {
32        echo "Connection failed: " . $e->getMessage();
33    }
34
35// Create table if not exist and if the Database is [TRUE]
36  $PDO->query("CREATE TABLE IF NOT EXISTS users (
37          user_id BIGINT(11) NOT NULL,
38          first_name TEXT(50) ,
39          last_name TEXT(50),
40          username TEXT(50),
41          status VARCHAR(10) NOT NULL
42          );");
43
44$fetch = $PDO->prepare("SELECT * FROM users WHERE user_id = ?");
45$fetch->execute([$HydraFW->Updater->Message->From->id]);
46$f = $fetch->fetch(\PDO::FETCH_ASSOC);
47
48if ($HydraFW->Updater->Message->From->id !== $f['user_id']) {
49   if ($HydraFW->Updater->Message->Chat->type === "private") {
50    $insert = $PDO->prepare("INSERT INTO users (user_id, first_name, last_name, username, status) VALUES (?,?,?,?,?)");
51    $insert->execute([$HydraFW->Updater->Message->From->id, $HydraFW->Updater->Message->From->first_name, $HydraFW->Updater->Message->From->last_name, $HydraFW->Updater->Message->From->username, '0']);
52      }
53    }
54}
55
56?>