MySQL Speichern

Chiro1x · 13. Januar 2012

Hey Leute ich weiß nicht wie man das Admin level speichert bisher hab ich es so :

Code

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;
}

Alles anzeigen

Kann mir keiner helfen ?

[NeS]ThomasTailor93 · 13. Januar 2012

Haste mit Navicat ne neue Tabelle "AdminLevel" angelegt?

Chiro1x · 13. Januar 2012

Ja hab ich da hab ich dann z.b. 5 drin und trotzdem bin ich kein Admin ...
Die Tabelle habe ich so angelegt :

SQL

9 	AdminLevel 	int(50)

[D.R.L]SP33D · 13. Januar 2012

Genau sowas suche ich in meinem Thread wenn du es hin hast kannst du den code mal pls posten hier

Ich wäre dir sehr dankbar

MfG SP33D

Andre_R · 13. Januar 2012

beim Integer sind 11 ausreichend, meine ich

Chiro1x · 13. Januar 2012

Ich hab den Integer jetzt auf 11 geändert passiert trotzdem nichts

xuNsHiNe · 14. Januar 2012

zeige mal deine

- mysql_SetInt

- mysql_GetInt

und mache mal bitte ein foto von deiner tabelenstruktur

Chiro1x · 14. Januar 2012

Code

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;
}

Alles anzeigen

Hier

maddin · 14. Januar 2012

Zeig mal den inhalt der mysql_log.txt, wenns da einen fehler gab wirds drin stehn

Chiro1x · 16. Januar 2012

Code

[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.

Alles anzeigen

Ich kann kein fehler erkennen

breadfish.de 11. März 2022