About BlitzPlus and MySQL

Blitz3D Forums/Blitz3D Beginners Area/About BlitzPlus and MySQL

ok, now make a *.bat file that does the following:
mysql --user=lexdark_gameuser --host=lexdark.com --password=**** --database=lexdark_game <batch.txt


Now you can feed the mysql client with the "batch.txt" (you have to create) textfile that must contain the mysql query or queries.

Best would be to try the following query first:

SELECT
 game_name,
 player_name, 
 player_score, 
 player_kills 
FROM
 gamewin;

Or, if it didn't work for some reason, write it on one line:
SELECT game_name, player_name, player_score, player_kills FROM gamewin;


This should print the Enties of the Tables Variables to your screen. Since it runs in batchmode, it will disconnect automaticly after proceeding.
Tell me if this works.