MySQL Speichern

enum SpielerDaten
{
        pName[MAX_PLAYER_NAME],
        pLevel,
        pGeld,
        pKills,
        pTode,
        pAdmin,
        Float:pHealth
}
stock LoadPlayer(playerid)
{
	if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
	{
	    GetPlayerName(playerid, SpielerInfo[playerid][pName], MAX_PLAYER_NAME);
		SpielerInfo[playerid][pLevel] = mysql_GetInt("accounts", "Level", "Name", SpielerInfo[playerid][pName]);
		SpielerInfo[playerid][pGeld] = mysql_GetInt("accounts", "Geld", "Name", SpielerInfo[playerid][pName]);
		SpielerInfo[playerid][pKills] = mysql_GetInt("accounts", "Kills", "Name", SpielerInfo[playerid][pName]);
		SpielerInfo[playerid][pTode] = mysql_GetInt("accounts", "Tode", "Name", SpielerInfo[playerid][pName]);
		SpielerInfo[playerid][pAdmin] = mysql_GetInt("accounts", "AdminLevel", "Name", SpielerInfo[playerid][pName]);
	}
	return 1;
}
stock SavePlayer(playerid)
{
	if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
	{
	    if(GetPVarInt(playerid,"Eingeloggt") == 1)
		{
		    mysql_SetInt("accounts", "Level", SpielerInfo[playerid][pLevel], "Name", SpielerInfo[playerid][pName]);
		    mysql_SetInt("accounts", "Geld", SpielerInfo[playerid][pGeld], "Name", SpielerInfo[playerid][pName]);
		    mysql_SetInt("accounts", "Kills", SpielerInfo[playerid][pKills], "Name", SpielerInfo[playerid][pName]);
		    mysql_SetInt("accounts", "Tode", SpielerInfo[playerid][pTode], "Name", SpielerInfo[playerid][pName]);
		    mysql_SetInt("accounts", "AdminLevel", SpielerInfo[playerid][pAdmin], "Name", SpielerInfo[playerid][pName]);
		    mysql_SetFloat("accounts", "Health", SpielerInfo[playerid][pHealth], "Name", SpielerInfo[playerid][pName]);
		}
	}
	return 1;
}

stock mysql_GetInt(Table[], Field[], Where[], Is[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Is, Is);
    format(query, 128, "SELECT %s FROM %s WHERE %s = '%s'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    new sqlint = mysql_fetch_int();
    mysql_free_result();
    return sqlint;
}
stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Where2, Where2);
    format(query, 128, "UPDATE %s SET %s = '%d' WHERE %s = '%s'", Table, Field, To, Where, Where2);
    mysql_query(query);
    return true;
}

[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(Kills); - Escaped 5 characters to Kills.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString([LoR]Chiro); - Escaped 10 characters to [LoR]Chiro.
[22:46:53] >> mysql_query( Connection handle: 1 )
[22:46:53] CMySQLHandler::Query(UPDATE accounts SET Kills = '0' WHERE Name = '[LoR]Chiro') - Successfully executed.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(Tode); - Escaped 4 characters to Tode.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString([LoR]Chiro); - Escaped 10 characters to [LoR]Chiro.
[22:46:53] >> mysql_query( Connection handle: 1 )
[22:46:53] CMySQLHandler::Query(UPDATE accounts SET Tode = '0' WHERE Name = '[LoR]Chiro') - Successfully executed.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(AdminLevel); - Escaped 10 characters to AdminLevel.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString([LoR]Chiro); - Escaped 10 characters to [LoR]Chiro.
[22:46:53] >> mysql_query( Connection handle: 1 )
[22:46:53] CMySQLHandler::Query(UPDATE accounts SET AdminLevel = '5' WHERE Name = '[LoR]Chiro') - Successfully executed.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(Health); - Escaped 6 characters to Health.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[22:46:53] >> mysql_real_escape_string( Connection handle: 1 )
[22:46:53] CMySQLHandler::EscapeString([LoR]Chiro); - Escaped 10 characters to [LoR]Chiro.
[22:46:53] >> mysql_query( Connection handle: 1 )
[22:46:53] CMySQLHandler::Query(UPDATE accounts SET Health = '0.0' WHERE Name = '[LoR]Chiro') - Successfully executed.
[21:28:10] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[21:28:10] CMySQLHandler::FreeResult() - The result is already empty.
[21:28:10] CMySQLHandler::Disconnect() - Connection was closed.
[21:28:10] CMySQLHandler::~CMySQLHandler() - deconstructor called.