js
const samp = require('samp-node');
const mysql = require('mysql');

// Replace these with your MySQL connection details
const MYSQL_HOST = 'localhost';
const MYSQL_USER = 'YOUR_MYSQL_USER';
const MYSQL_PASSWORD = 'YOUR_MYSQL_PASSWORD';
const MYSQL_DATABASE = 'YOUR_MYSQL_DATABASE';

// Create a new SAMP client
const client = new samp.Client();

// Create a new MySQL connection
const connection = mysql.createConnection({
  host: MYSQL_HOST,
  user: MYSQL_USER,
  password: MYSQL_PASSWORD,
  database: MYSQL_DATABASE
});

// When the client is connected, log a message to the console
client.on('connect', () => {
  console.log('Client connected');
});

// When the client receives a chat message, log it to the database
client.on('chat', message => {
  logMessage(message);
});

// This function logs a chat message to the database
function logMessage(message) {
  // Create a new MySQL query
  const query = connection.query(
    `INSERT INTO messages (
       sender,
       text,
       created_at
     ) VALUES (?, ?, ?)`,
    [message.sender, message.text, new Date()],
    (error, results) => {
      if (error) {
        console.error(error);
      }
    }
  );
}

c
// Create a new MySQL connection
new connection;
mysql_create_connection(connection, MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE);