Autoit and remote connection to mysql database

Hi
I want to make a small program in autoit.

Main function of program is to have
- login ( when user enters data in input fields username and password connect to remote mysql database, find username, password, id, banned fields and check data that user enterd with data on mysql server, check if user is banned or not )
- detect file in windows and when he find a file to store file path to registry
- on start button ( show only if user is logged ) start file path game
- if game runs take screenshoots and send to remote server map where logged in user id is equal to map name on server
- need to take screens random time ( 5sec, 50 sec, 20 sec, 80 sec ) an upload it automatic on server map

So my question is
-is autoit can connect to mysql on remote server,
-can i compare data from mysql database with this one from input fields in login form of program
-can screenshoot-s can be uploaded directly to map on host without ftp data

Hi,

as far as I know AutoIT itself only supports SQLite,
but there´s an MySQL UDF to solve it.
[Only registered and activated users can see links. Click Here To Register...]

If you include the MySQL UDF, you can connect on the MySQL-Server,
additionally the UDF supports a _Query()-function, so you can use regular SQL-Statements.

But I would advise you to write php-files for the SQLConnection.

PHP File:

The AutoIT-Code:

If you Connect to your datebase directly from AutoIT, you need your MySQL-Connection data in your au3-file,
but autoit-scripts aren´t really hard to decompile, so everyone who decompile your scripts can connect on your database.


To upload something, you can use the FTP-protocol,
to connect you need login data to the ftp server.
The only way to connect / upload without data is, if your ftp-server accept guest login and the guest becomes permissions to write data (I wouldn´t recommend it).

never put a mysql connection in a script use a server with php

Ah i see, so this is not secure way to do it :(

thx for answers