test.pwn

// generated by "sampctl package generate"

#include <a_samp>

#include <a_mysql>

#include <YSI_Coding\y_va>
#include <YSI_Coding\y_inline>

#include "mysql_prepared"

new MySQL:MySQLHandle;

new
    Statement:stmt_readone;

main() {

    MySQLHandle = mysql_connect("localhost", "root", "", "cnr");

    mysql_log(ALL);

    mysql_pquery(MySQLHandle, "CREATE TABLE IF NOT EXISTS accounts(\
        username VARCHAR(24) NOT NULL, \
        password VARCHAR(65) NOT NULL, \
        salt VARCHAR(11) NOT NULL, \
        money INT(11), \
        kills, INT(11), \
        deaths INT(11))");

    new Statement: stmt_insert = MySQL_PrepareStatement(MySQLHandle, "INSERT INTO accounts(username, password, salt, money, kills, deaths) VALUES (?,?,?,?,?,?) " );

    // Arrow values in questions (first 0, second is 1, etc ...)
    MySQL_Bind(stmt_insert, 0 , "patrickgtr");
    MySQL_Bind(stmt_insert, 1 , "patrickgtrpassword");
    MySQL_Bind(stmt_insert, 2 , "pgtrhash");
    MySQL_BindInt(stmt_insert, 3, 100);
    MySQL_BindInt(stmt_insert, 4, 200);
    MySQL_BindInt(stmt_insert, 5, 300);

    MySQL_ExecuteParallel(stmt_insert);
    MySQL_StatementClose(stmt_insert);

    stmt_readone = MySQL_PrepareStatement(MySQLHandle, "SELECT username, password, salt, money, kills, deaths FROM accounts where username = ?");


    new Statement:stmt_readloop = MySQL_PrepareStatement(MySQLHandle, "SELECT * FROM spawns");

    // Run Threaded on statement
    inline OnSpawnsLoad() {
        new
        spawnID,
        Float:spawnX,
        Float:spawnY,
        Float:spawnZ,
        Float:spawnA;

        MySQL_BindResultInt(stmt_readloop, 0, spawnID);
        MySQL_BindResultFloat(stmt_readloop, 1, spawnX);
        MySQL_BindResultFloat(stmt_readloop, 2, spawnY);
        MySQL_BindResultFloat(stmt_readloop, 3, spawnZ);
        MySQL_BindResultFloat(stmt_readloop, 4, spawnA);

        while(MySQL_Statement_FetchRow(stmt_readloop)) {
            printf("%i, %.3f, %.3f, %.3f", spawnID, spawnX, spawnY, spawnZ, spawnA);
        }
        MySQL_StatementClose(stmt_readloop);
    }
    MySQL_ExecuteThreaded_Inline(stmt_readloop, using inline OnSpawnsLoad);

    SetTimerEx("Emulate_OnPlayerConnect", 2000, false, "i", 0);
}

forward Emulate_OnPlayerConnect(playerid);
public Emulate_OnPlayerConnect(playerid) {
    printf("OPC, playerid: %i", playerid);
    MySQL_Bind(stmt_readone, 0, "patrickgtr");
    MySQL_ExecuteThreaded(stmt_readone, "OnPlayerLoad", "isf", playerid, "Hello World;", 192.168);
    return 1;
}

forward OnPlayerLoad(playerid,const fmat[], Float:pos);
public OnPlayerLoad(playerid, const fmat[], Float:pos)
{
    printf("OnPlayerLoad, playerid: %i", playerid);
    printf("OnPlayerLoad, fmat: %s", fmat);
    printf("OnPlayerLoad, pos: %.4f", pos);

    new
        playerUsername[MAX_PLAYER_NAME],
        playerPassword[65],
        playerSalt[11],
        playerMoney,
        playerKills,
        playerDeaths;

    // retrieve
    MySQL_BindResult(stmt_readone, 0, playerUsername, sizeof(playerUsername));
    MySQL_BindResult(stmt_readone, 1, playerPassword, sizeof(playerPassword));
    MySQL_BindResult(stmt_readone, 2, playerSalt, sizeof(playerSalt));
    MySQL_BindResultInt(stmt_readone, 3, playerMoney);
    MySQL_BindResultInt(stmt_readone, 4, playerKills);
    MySQL_BindResultInt(stmt_readone, 5, playerDeaths);

    if(MySQL_Statement_FetchRow(stmt_readone)) {
        printf("username %s", playerUsername);
        printf("password %s", playerPassword);
        printf("salt %s", playerSalt);
        printf("money %i", playerMoney);
        printf("kills %i", playerKills);
        printf("deaths %i", playerDeaths);
    }
    MySQL_StatementClose(stmt_readone);
}