Beiträge von Marschl

Marschl · 12. Februar 2016

yay es geht, ...
wenn ich /fraktion mach steht drin das ich in der Fraktion ivilist bin und mein Rang heißt auch so... Statt Zivilist.. Why?

Marschl · 12. Februar 2016

Code

enum FraktionDaten {
	f_id,
	f_name[128],
	Float:f_x,
	Float:f_y,
	Float:f_z,
	Float:f_r,
	f_interior,
	f_world,
	f_color,
	f_kasse,
	f_rang1[32],
	f_rang2[32],
	f_rang3[32],
	f_rang4[32],
	f_rang5[32],
	f_rang6[32]
};


new fInfo[][FraktionDaten];

Alles anzeigen

Marschl · 12. Februar 2016

Also ich habe es eingefügt,.... aber es wird nicht gespeichert. Es wird nur geladen

Marschl · 12. Februar 2016

Das ist die Login funktion wo ich den Player lade:

Code

forward OnPasswortResponse(playerid);
public OnPasswortResponse(playerid)
{
    new num_rows, num_fields;
	cache_get_data(num_rows, num_fields, Handle);
	if(num_rows)
	{
	    //Passwort richtig
		SpielerLaden(playerid);
		SpawnPlayer(playerid);
	}
	else
	{
	    //Passwort falsch
	    SendClientMessage(playerid, -1, "Das eingegebene Passwort ist falsch!");
	    new str[145], name[MAX_PLAYER_NAME], ip[16];
		GetPlayerName(playerid, name, MAX_PLAYER_NAME);
		GetPlayerIp(playerid, ip, sizeof(ip));
		format(str, sizeof(str), ""#HTML_GELB"Hallo %s \n"#HTML_WEIS"Dein Account wurde gefunden! \nBitte gib nun dein Passwort ein \n Deine IP: "#HTM_GELB"%s", name, ip);
		ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,""ServerTag"Login",str ,"Login","Abbrechen");
	}
	return 1;
}

Alles anzeigen

@Jeffrydas Problem ist, dass es gar nicht gespeichert wird

Und so lade ich mein Spieler:

Code

stock SpielerLaden(playerid)
{
	sInfo[playerid][pID] = cache_get_field_content_int(0, "id", Handle);
	sInfo[playerid][pEingeloggt] = 1;
	sInfo[playerid][pAge] = cache_get_field_content_int(0,"Age",Handle);
	sInfo[playerid][pSex] = cache_get_field_content_int(0,"Geschlecht",Handle);
	sInfo[playerid][pAdminLevel] = cache_get_field_content_int(0,"AdminLevel",Handle);
	sInfo[playerid][pMapper] = cache_get_field_content_int(0,"Mapper",Handle);
	sInfo[playerid][pScripter] = cache_get_field_content_int(0,"Scripter",Handle);
	sInfo[playerid][pPremium] = cache_get_field_content_int(0,"Premium",Handle);
	sInfo[playerid][pLevel] = cache_get_field_content_int(0,"Level",Handle);
	SetPlayerScore(playerid, sInfo[playerid][pLevel]);
	sInfo[playerid][pRespektpunkte] = cache_get_field_content_int(0,"Respektpunkte",Handle);
	sInfo[playerid][pBarGeld] = cache_get_field_content_int(0,"BarGeld",Handle);
	ResetPlayerMoney(playerid);
	GivePlayerMoney(playerid, sInfo[playerid][pBarGeld]);
	sInfo[playerid][pBankKonto] = cache_get_field_content_int(0,"BankKonto",Handle);
	sInfo[playerid][pBankGeld] = cache_get_field_content_int(0,"BankGeld",Handle);
	sInfo[playerid][pSkin] = cache_get_field_content_int(0,"Skin",Handle);
	SetPlayerSkin(playerid, sInfo[playerid][pSkin]);
    sInfo[playerid][pFraktion] = cache_get_field_content_int(0,"Fraktion",Handle);
    sInfo[playerid][pFraktionRang] = cache_get_field_content_int(0,"FraktionRang",Handle);
    sInfo[playerid][pSpawn] = cache_get_field_content_int(0,"Spawn",Handle);
    sInfo[playerid][pHandy] = cache_get_field_content_int(0,"Handy",Handle);
    sInfo[playerid][pHandynummer] = cache_get_field_content_int(0,"Handynummer",Handle);
    sInfo[playerid][pPayDay] = cache_get_field_content_int(0,"PayDay",Handle);
    sInfo[playerid][pSpielzeit] = cache_get_field_content_int(0,"Spielzeit",Handle);
    sInfo[playerid][pJail] = cache_get_field_content_int(0,"Jail",Handle);
    sInfo[playerid][pJailTime] = cache_get_field_content_int(0,"JailTime",Handle);
	sInfo[playerid][pPrison] = cache_get_field_content_int(0,"Prison",Handle);
 	sInfo[playerid][pPrisonCheckpoints] = cache_get_field_content_int(0,"PrisonCheckpoints",Handle);
	return 1;
}

Alles anzeigen

Marschl · 12. Februar 2016

Mein SpielerLaden

Code

stock SpielerLaden(playerid)
{
	sInfo[playerid][pID] = cache_get_field_content_int(0, "id", Handle);
	sInfo[playerid][pEingeloggt] = 1;
	sInfo[playerid][pAge] = cache_get_field_content_int(0,"Age",Handle);
	sInfo[playerid][pSex] = cache_get_field_content_int(0,"Geschlecht",Handle);
	sInfo[playerid][pAdminLevel] = cache_get_field_content_int(0,"AdminLevel",Handle);
	sInfo[playerid][pMapper] = cache_get_field_content_int(0,"Mapper",Handle);
	sInfo[playerid][pScripter] = cache_get_field_content_int(0,"Scripter",Handle);
	sInfo[playerid][pPremium] = cache_get_field_content_int(0,"Premium",Handle);
	sInfo[playerid][pLevel] = cache_get_field_content_int(0,"Level",Handle);
	SetPlayerScore(playerid, sInfo[playerid][pLevel]);
	sInfo[playerid][pRespektpunkte] = cache_get_field_content_int(0,"Respektpunkte",Handle);
	sInfo[playerid][pBarGeld] = cache_get_field_content_int(0,"BarGeld",Handle);
	ResetPlayerMoney(playerid);
	GivePlayerMoney(playerid, sInfo[playerid][pBarGeld]);
	sInfo[playerid][pBankKonto] = cache_get_field_content_int(0,"BankKonto",Handle);
	sInfo[playerid][pBankGeld] = cache_get_field_content_int(0,"BankGeld",Handle);
	sInfo[playerid][pSkin] = cache_get_field_content_int(0,"Skin",Handle);
	SetPlayerSkin(playerid, sInfo[playerid][pSkin]);
    sInfo[playerid][pFraktion] = cache_get_field_content_int(0,"Fraktion",Handle);
    sInfo[playerid][pFraktionRang] = cache_get_field_content_int(0,"FraktionRang",Handle);
    sInfo[playerid][pSpawn] = cache_get_field_content_int(0,"Spawn",Handle);
    sInfo[playerid][pHandy] = cache_get_field_content_int(0,"Handy",Handle);
    sInfo[playerid][pHandynummer] = cache_get_field_content_int(0,"Handynummer",Handle);
    sInfo[playerid][pPayDay] = cache_get_field_content_int(0,"PayDay",Handle);
    sInfo[playerid][pSpielzeit] = cache_get_field_content_int(0,"Spielzeit",Handle);
    sInfo[playerid][pJail] = cache_get_field_content_int(0,"Jail",Handle);
    sInfo[playerid][pJailTime] = cache_get_field_content_int(0,"JailTime",Handle);
	sInfo[playerid][pPrison] = cache_get_field_content_int(0,"Prison",Handle);
 	sInfo[playerid][pPrisonCheckpoints] = cache_get_field_content_int(0,"PrisonCheckpoints",Handle);
	return 1;
}

Alles anzeigen

Marschl · 12. Februar 2016

Also der User ist da:
http://prntscr.com/a2963z

Marschl · 12. Februar 2016

Du meinst den User? mit der ID 0

Marschl · 12. Februar 2016

Das kommt:
http://prntscr.com/a294kl
http://prntscr.com/a294q8

Marschl · 12. Februar 2016

In der datenbank oder im Script?

Marschl · 12. Februar 2016

Also:
http://prntscr.com/a292u3
http://prntscr.com/a292zm

Marschl · 12. Februar 2016

Also du meinst als SQL? Ich hab nicht so viel Ahnung davon

Marschl · 12. Februar 2016

Also dass ist der LOG:

Code

----------
Loaded log file: "server_log.txt".
----------


SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team


[11:58:46] filterscripts = ""  (string)
[11:58:46] 
[11:58:46] Server Plugins
[11:58:46] --------------
[11:58:46]  Loading plugin: sscanf
[11:58:46] 


[11:58:46]  ===============================


[11:58:46]       sscanf plugin loaded.     


[11:58:46]          Version:  2.8.1        


[11:58:46]    (c) 2012 Alex "Y_Less" Cole  


[11:58:46]  ===============================


[11:58:46]   Loaded.
[11:58:46]  Loading plugin: mysql
[11:58:46]  >> plugin.mysql: running on 6 threads.
[11:58:46]  >> plugin.mysql: R31 successfully loaded.
[11:58:46]   Loaded.
[11:58:46]  Loading plugin: streamer
[11:58:46] 


*** Streamer Plugin v2.7.9 by Incognito loaded ***


[11:58:46]   Loaded.
[11:58:46]  Loaded 3 plugins.


[11:58:46] 
[11:58:46] Filterscripts
[11:58:46] ---------------
[11:58:46]   Loaded 0 filterscripts.


[11:58:46] |>MySQL<| - Es konnte Verbindung zur der Datenbank samp aufgebaut werden
[11:58:46] Number of vehicle models: 0
[11:58:46] Fraktion  ivilist wurde geladen!
[11:58:46] Fraktion  an Andreas Police Department wurde geladen!
[11:58:46] Fraktion  ederal Bureau of Investigation wurde geladen!
[11:59:08] [connection] 25.60.48.4:57405 requests connection cookie.
[11:59:09] [connection] incoming connection: 25.60.48.4:57405 id: 0
[11:59:10] [join] Buzzy has joined the server (0:25.60.48.4)
[11:59:24] [part] Buzzy has left the server (0:1)
Console input: gmx
[12:04:53] |>MySQL<| - Es konnte Verbindung zur der Datenbank samp aufgebaut werden
[12:04:53] Number of vehicle models: 0
[12:04:53] Fraktion  ivilist wurde geladen!
[12:04:53] Fraktion  an Andreas Police Department wurde geladen!
[12:04:53] Fraktion  ederal Bureau of Investigation wurde geladen!
[12:06:17] [connection] 25.60.48.4:51334 requests connection cookie.
[12:06:18] [connection] incoming connection: 25.60.48.4:51334 id: 0
[12:06:18] [join] Buzzy has joined the server (0:25.60.48.4)
[12:06:33] UPDATE user SET Age='0', Geschlecht='0', AdminLevel='0', Mapper='0', Scripter='0', Premium='0', Level='0', Respektpunkte='0', BarGeld='0', BankKonto='0', BankGeld='0',Skin='0', Fraktion='0', FraktionRang='0', Spawn='0', Handy='0', Handynummer='0', PayDay='0', Spielzeit='0', Jail='0', JailTime='0', Prison='0', PrisonCheckpoints='0' WHERE id='3'
[12:06:33] [part] Buzzy has left the server (0:1)

Alles anzeigen

Marschl · 12. Februar 2016

Wie den query von phpmyadmin?

Marschl · 12. Februar 2016

Es wird kein LOG erstellt... aber wird auch nix gespeichert außer User und Passwort

Marschl · 12. Februar 2016

Ich benutze r31, ich habe unter Connect_To_Database diese reingeschrieben: mysql_log(LOG_DEBUG);

Marschl · 12. Februar 2016

Das ist der Globale log, wie kann ich es für mein Query aktivieren?

Marschl · 12. Februar 2016

Soviel wie ich daraus lesen konnte sind das nur die Fraktionen...

Code

[11:47:15] [DEBUG] mysql_errno - connection handle: 1
[11:47:15] [DEBUG] mysql_tquery - connection handle: 1
[11:47:15] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM `fraktion`"..
[11:47:15] [DEBUG] CMySQLQuery::Execute[OnFraktionLaden()] - starting query execution
[11:47:15] [DEBUG] CMySQLQuery::Execute[OnFraktionLaden()] - query was successful
[11:47:15] [DEBUG] CMySQLQuery::Execute[OnFraktionLaden()] - data being passed to ProcessCallbacks()
[11:47:15] [DEBUG] Calling callback "OnFraktionLaden"..
[11:47:15] [DEBUG] cache_get_data - connection handle: 1
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fid", data: "0"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fname", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_x", data: "369.652"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_y", data: "-2048.64"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_z", data: "7.8359"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_r", data: "359.47"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_interior", data: "0"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_world", data: "0"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_color", data: "0"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_kasse", data: "0"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_rang1", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_rang2", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_rang3", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_rang4", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_rang5", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "f_rang6", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fid", data: "1"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fname", data: "San Andreas Police Department"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_x", data: "369.652"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_y", data: "-2048.64"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_z", data: "10.8359"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_r", data: "359.47"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_interior", data: "0"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_world", data: "0"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_color", data: "0"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_kasse", data: "0"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_rang1", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_rang2", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_rang3", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_rang4", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_rang5", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "f_rang6", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "fid", data: "2"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "fname", data: "Federal Bureau of Investigation"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_x", data: "369.652"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_y", data: "-2048.64"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_z", data: "7.8359"
[11:47:15] [DEBUG] cache_get_field_content_float - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_r", data: "359.47"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_interior", data: "0"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_world", data: "0"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_color", data: "0"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_kasse", data: "0"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_rang1", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_rang2", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_rang3", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_rang4", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_rang5", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "f_rang6", data: "Zivilist"
[11:47:15] [DEBUG] cache_get_field_content_int - connection handle: 1
[11:47:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "fid", data: "3"
[11:47:15] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

Alles anzeigen

Marschl · 12. Februar 2016

Zitat von Jony

Lasss mich raten, es gibt warscheinlich eine schön lange ErrorLog von MySQL.

Wieso nutzt Du für einen Integer %i und nicht %d?
Warum nutzt Du Anführungszeichen? - Entweder Backticks, Anführungszeichen nur bei Strings.

Ich hab garkein MySQL Log bekommen... der wurde nicht erstellt

Marschl · 12. Februar 2016

1. Es werden nur 3. Fraktionen geladen...
Hier der Log

Code

[11:36:58] |>MySQL<| - Es konnte Verbindung zur der Datenbank samp aufgebaut werden
[11:36:58] Number of vehicle models: 0
[11:36:58] Fraktion  ivilist wurde geladen!
[11:36:58] Fraktion  an Andreas Police Department wurde geladen!
[11:36:58] Fraktion  ederal Bureau of Investigation wurde geladen!
[11:37:24] [connection] 127.0.0.1:56593 requests connection cookie.
[11:37:25] [connection] incoming connection: 127.0.0.1:56593 id: 0
[11:37:25] [join] Buzzy has joined the server (0:127.0.0.1)
[11:37:33] Fraktion: 0
[11:37:33] Name: 
[11:37:33] Rang: 
[11:37:33] ID: 16777216
[11:37:38] [part] Buzzy has left the server (0:1)

Alles anzeigen

Mein Fraktionladen public:

Code

forward OnFraktionLaden();
public OnFraktionLaden()
{
	new rows, fields;
	cache_get_data(rows, fields);
	for(new i = 0; i < rows; i++)
	{
	    fInfo[i][f_id] = cache_get_field_content_int(i, "fid", Handle);
	    fInfo[i][f_name] = cache_get_field_content(i, "fname", fInfo[i][f_name], Handle, 128);
		//Cords
		fInfo[i][f_x] = cache_get_field_content_float(i,"f_x", Handle);
		fInfo[i][f_y] = cache_get_field_content_float(i,"f_y", Handle);
		fInfo[i][f_z] = cache_get_field_content_float(i,"f_z", Handle);
		fInfo[i][f_r] = cache_get_field_content_float(i,"f_r", Handle);
		fInfo[i][f_interior] = cache_get_field_content_int(i, "f_interior", Handle);
		fInfo[i][f_world] = cache_get_field_content_int(i, "f_world", Handle);
		fInfo[i][f_color] = cache_get_field_content_int(i, "f_color", Handle);
        fInfo[i][f_kasse] = cache_get_field_content_int(i, "f_kasse", Handle);
		//Rangnamen
        fInfo[i][f_rang1] = cache_get_field_content(i, "f_rang1", fInfo[i][f_rang1], Handle, 128);
        fInfo[i][f_rang2] = cache_get_field_content(i, "f_rang2", fInfo[i][f_rang2], Handle, 128);
        fInfo[i][f_rang3] = cache_get_field_content(i, "f_rang3", fInfo[i][f_rang3], Handle, 128);
        fInfo[i][f_rang4] = cache_get_field_content(i, "f_rang4", fInfo[i][f_rang4], Handle, 128);
        fInfo[i][f_rang5] = cache_get_field_content(i, "f_rang5", fInfo[i][f_rang5], Handle, 128);
        fInfo[i][f_rang6] = cache_get_field_content(i, "f_rang6", fInfo[i][f_rang6], Handle, 128);
		printf("Fraktion  %s wurde geladen!", fInfo[i][f_name]);
	}
	return 1;
}

Alles anzeigen

Marschl · 12. Februar 2016

Hallo,

ich habe das Problem das mein MySQL nix speichert außer das Passwort und username...

hier mein SpielerSpeichern Funktion:

Code

stock SpielerSpeichern(playerid)
{
	if(sInfo[playerid][pEingeloggt] == 0)return 1;
	new result[1024], query[1024];
	format(query, sizeof(query), "Age='%i', Geschlecht='%i', AdminLevel='%i', Mapper='%i', Scripter='%i', Premium='%i', Level='%i', Respektpunkte='%i'",
	    sInfo[playerid][pAge], sInfo[playerid][pSex], sInfo[playerid][pAdminLevel], sInfo[playerid][pMapper], sInfo[playerid][pScripter], sInfo[playerid][pPremium], sInfo[playerid][pLevel], sInfo[playerid][pRespektpunkte]);
	format(query, sizeof(query), "BarGeld='%i', BankKonto='%i', BankGeld='%i',Skin='%i', Fraktion='%i', FraktionRang='%i', Spawn='%i', Handy='%i', Handynummer='%i'",
		GetPlayerMoney(playerid), sInfo[playerid][pBankKonto], sInfo[playerid][pBankGeld],sInfo[playerid][pSkin], sInfo[playerid][pFraktion], sInfo[playerid][pFraktionRang], sInfo[playerid][pSpawn], sInfo[playerid][pHandy], sInfo[playerid][pHandynummer]);
	format(query, sizeof(query), "PayDay='%i', Spielzeit='%i', Jail='%i', JailTime='%i', Prison='%i', PrisonCheckpoints='%i'",
	    sInfo[playerid][pPayDay], sInfo[playerid][pSpielzeit], sInfo[playerid][pJail], sInfo[playerid][pJailTime], sInfo[playerid][pPrison], sInfo[playerid][pPrisonCheckpoints]);
	format(result, sizeof(result), "UPDATE user SET %s WHERE id='%i'", query, sInfo[playerid][pID]);
	mysql_function_query(Handle, result, false, "", "");
	return 1;
}

Alles anzeigen

Ich habe keine Ahnung warum...
Hier meine Datenbank:

Danke für euere Hilfe

Gruß

Beiträge von Marschl

FrakLoad

FrakLoad

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

MySQL Speicher nix

FrakLoad

MySQL Speicher nix