open.mp forum

Trying to save player health but doesn't seem to be working i'll like to know what im doing wrong?

Created a table in OnGameModeInit:

db_query(server_database, "CREATE TABLE IF NOT EXISTS `USERS` (`NAME`, `IP`, `REGISTER_DATE`, `PASS`, `SCORE`, `KILLS`, `DEATHS`, `SKIN`, `HEALTH`, `pX`, `pY`, `pZ`, `pA`, `INT`, `WORLD`, `ADMIN`)");;



Selecting data:


public OnPlayerLogin(playerid, bool:success)
{
    if(success)
    {
        new query, field, field2;
        format(query, sizeof(query), "SELECT * FROM `USERS` WHERE `NAME` = '%s' COLLATE NOCASE", DB_Escape(ReturnName(playerid)));
        database_result = db_query(server_database, query);
        if(db_num_rows(database_result))
        {
            db_get_field_assoc(database_result, "ADMIN", field, sizeof(field));
            PlayerInfo = strval(field);

            db_get_field_assoc(database_result, "SCORE", field, sizeof(field));
            SetPlayerScore(playerid, strval(field));

            db_get_field_assoc(database_result, "KILLS", field, sizeof(field));
            PlayerInfo = strval(field);

            db_get_field_assoc(database_result, "DEATHS", field, sizeof(field));
            PlayerInfo = strval(field);

            db_get_field_assoc(database_result, "SKIN", field, sizeof(field));
            PlayerInfo = strval(field);

            db_get_field_assoc(database_result, "REGISTER_DATE", field2, sizeof(field2));
            PlayerInfo = field2;

			db_get_field_assoc(database_result, "HEALTH", field, sizeof(field));
            PlayerInfo = floatstr(field);

            db_get_field_assoc(database_result, "pX", field, sizeof(field));
            PlayerInfo = floatstr(field);

            db_get_field_assoc(database_result, "pY", field, sizeof(field));
            PlayerInfo = floatstr(field);

            db_get_field_assoc(database_result, "pZ", field, sizeof(field));
            PlayerInfo = floatstr(field);

            db_get_field_assoc(database_result, "pA", field, sizeof(field));
            PlayerInfo = floatstr(field);

            db_get_field_assoc(database_result, "INT", field, sizeof(field));
            PlayerInfo = strval(field);

            db_get_field_assoc(database_result, "WORLD", field, sizeof(field));
            PlayerInfo = strval(field);
        }



Inserting Health Data:


? ??
    new query;
    format(query, sizeof(query), "INSERT INTO `USERS` (`NAME`, `PASS`, `ADMIN`, `IP`, `REGISTER_DATE`, `SCORE`, `KILLS`, `DEATHS`, `SKIN`, `HEALTH`, `pX`, `pY`, `pZ`, `pA`, `INT`, `WORLD`) VALUES ('%s', '%s', %d, '%s', '%s', %d, %d, %d, %d, %f, %f, %f, %f, %f, %d, %d)", DB_Escape(ReturnName(playerid)), password, PLAYER, ip, Date, GetPlayerScore(playerid), PlayerInfo, PlayerInfo, GetPlayerSkin(playerid), PlayerInfo,
	PlayerInfo,
    PlayerInfo,
    PlayerInfo,
    PlayerInfo,
    PlayerInfo,
    PlayerInfo);
    database_result = db_query(server_database, query);
    db_free_result(database_result);



Updating Data:



? ? ? ? ? ??
stock SaveAccount(playerid)
{
    new query, Float:pos;
    if(PlayerInfo == true)
    {
        GetPlayerPos(playerid, pos, pos, pos);
        GetPlayerFacingAngle(playerid, pos);
		GetPlayerHealth(playerid, PlayerInfo);

        format(query, sizeof(query),
		"UPDATE `USERS` SET `ADMIN` = %d, `SCORE` = %d, `KILLS` = %d, `DEATHS` = %d, `SKIN` = %d, `HEALTH` = %f, `pX` = %f, `pY` = %f, `pZ` = %f, `pA` = %f, `INT` = %d, `WORLD` = %d, `ADMIN` = %d WHERE `NAME` = '%s' COLLATE NOCASE",
		PlayerInfo, GetPlayerScore(playerid), PlayerInfo, PlayerInfo, GetPlayerSkin(playerid), PlayerInfo, pos, pos, pos, pos, GetPlayerInterior(playerid), GetPlayerVirtualWorld(playerid), PlayerInfo, DB_Escape(ReturnName(playerid)));
        database_result = db_query(server_database, query);
        db_free_result(database_result);
    }
    return 1;
}



Code runs without errors but im still unsure on why its not saving and loading the players health..