Gameode Startet nicht

Markuslobicher · 25. August 2016

Guten Morgen zusammen.

Ich habe ein altes angefangen Selfmade gefunden was auf Mysql basiert.
Folgendes Problem.

Spieler X logt sich auf den Server ein und registriert sich.
Spieler Spawnt aber accountdaten werden nicht in die Mysql-Datenbank abgespeichert.

Mysql-Log:

SQL

[00:44:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[00:44:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[00:44:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[00:44:38] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:44:38] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:44:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[00:44:38] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:44:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[00:44:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[01:02:25] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Spieler x' ", callback: "OnUserCheck", format: "i"
[01:02:25] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution
[01:02:25] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.316 milliseconds
[01:02:25] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[01:02:25] [DEBUG] Calling callback "OnUserCheck"..
[01:02:25] [DEBUG] cache_get_data - connection: 1
[01:02:25] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[01:02:31] [DEBUG] mysql_escape_string - source: "x", connection: 1, max_len: 35
[01:02:31] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO user username = 'Spieler x', passwort = 'x', ", callback: "(null)", format: "(null)"
[01:02:31] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[01:02:31] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'username = 'Spieler x', passwort = 'x', level = '1'' at line 1
[01:02:31] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Alles anzeigen

Scriptcode:

Code

//enum bereich:
       enum playerInfo{
	eingeloggt,
	level,
	db_id,
	alevel,
	fraktion,
	rang,
	spawnchan


new sInfo[MAX_PLAYERS][playerInfo];


//mysql verbindung:
	dbhandle = mysql_connect(db_host,db_user,db_db,db_pass);




public OnGameModeExit()
{
	mysql_close(dbhandle);
	KillTimer(sekunden_timer);
	return 1;
}


public OnUserCheck(playerid)
{
	new num_rows,num_fields;
	cache_get_data(num_rows,num_fields,dbhandle);
	if(num_rows==0)
	{
		//Register
		ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Account Erstellung","Gebe bitte nun dein gewünschtes Passwort ein!","Registrieren","Abbrechen");
	}
	else
	{
		//Login
	ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Anmelden","Gebe bitte dein Passwort ein.","Anmleden","Abbrechen");
	}
	return 1;


public OnPlayerConnect(playerid)
{
	if(IsPlayerNPC(playerid)) return 1;
	new nachricht[128];
	format(nachricht,sizeof(nachricht),"Du bist mit der ID %i verbunden.",playerid);
	SendClientMessage(playerid,rot,nachricht);
	//Login/Register:
	new name[MAX_PLAYER_NAME],query[128];
	GetPlayerName(playerid,name,sizeof(name));
	format(query,sizeof(query),"SELECT id FROM user WHERE username='%s' ",name);
	mysql_function_query(dbhandle,query,true,"OnUserCheck","i",playerid);
	SendClientMessage(playerid,grün,"Willkommen auf Reallife Version 0.1.4! Wir wünschen euch ein angenehmen Spiel spaß bei uns!");
	//textdraws anzeigen:
	TextDrawShowForPlayer(playerid,Text:uhrzeitLabel);
	TextDrawShowForAll(Jahr);
	SetPlayerColor(playerid,weiß);
	sInfo[playerid][level]=1;
	SetPlayerScore(playerid,sInfo[playerid][level]);
	return 1;
}
  savePlayer(playerid)
{
	if(sInfo[playerid][eingeloggt]==0)return 1;
	//Speichern level,money
	new query[256];
	format(query,sizeof(query),"UPDATE user SET level='%i',money='%i',alevel='%i',fraktion='%i',rang='%i',spawnchange='%i' WHERE id='%i'",sInfo[playerid][level],GetPlayerMoney(playerid),sInfo[playerid][alevel],sInfo[playerid][fraktion],sInfo[playerid][rang],sInfo[playerid][spawnchange],sInfo[playerid][db_id]);
	mysql_function_query(dbhandle,query,false,"","");
	return 1;
}
resetPlayer(playerid)
{
	for(new i=0; i<sizeof(sInfo[]); i++)
	{
	    sInfo[playerid][playerInfo:i]=0;
	}
	return 1;
}


public OnPlayerDisconnect(playerid, reason)
{
	for(new i=0; i<sizeof(aInfo); i++)
	{
		if(aInfo[i][id_x]==0)continue;
		if(aInfo[i][besitzer]!=sInfo[playerid][db_id])continue;
		GetVehiclePos(aInfo[i][id_x],aInfo[i][c_x],aInfo[i][c_y],aInfo[i][c_z]);
		GetVehicleZAngle(aInfo[i][id_x],aInfo[i][c_r]);
		new query[156];
		format(query,sizeof(query),"UPDATE user SET level='%i',money='%i',alevel='%i',fraktion='%i',rang='%i' WHERE id='%i'",sInfo[playerid][level],
		GetPlayerMoney(playerid),sInfo[playerid][alevel],sInfo[playerid][fraktion],sInfo[playerid][rang],sInfo,sInfo[playerid][db_id]);
		mysql_function_query(dbhandle,query,false,"","");
		DestroyVehicle(aInfo[i][id_x]);
		aInfo[i][id_x]=0;
		break;
	}
	savePlayer(playerid);
	resetPlayer(playerid);
	loadPlayerCars(playerid);
	return 1;
}




public OnPlayerSpawn(playerid)
{
	if(IsPlayerNPC(playerid)) return 1;
	if(!isPlayerInFrakt(playerid,0))
	{
		if(sInfo[playerid][spawnchange]==1)
		{




			new fID;
			fID= sInfo[playerid][fraktion];
			SetPlayerPos(playerid,fInfo[fID][f_x],fInfo[fID][f_y],fInfo[fID][f_z]);
			SetPlayerFacingAngle(playerid,fInfo[fID][f_r]);
			SetPlayerInterior(playerid,fInfo[fID][f_inter]);
			SetPlayerVirtualWorld(playerid,fInfo[fID][f_world]);
			SetPlayerColor(playerid,fInfo[fID][f_color]);
		}
	}
	SendClientMessage(playerid,rot,"/hilfe um die Befehle zu sehen!");
	return 1;
}


public OnPasswordResponse(playerid)
{
	new num_rows,num_fields;
	cache_get_data(num_rows,num_fields,dbhandle);
	if(num_rows==1)
	{
		//passwort Richtig
		sInfo[playerid][eingeloggt] = 1;
		sInfo[playerid][level] = cache_get_field_content_int(0,"level",dbhandle);
		SetPlayerScore(playerid,sInfo[playerid][level]);
		sInfo[playerid][db_id] = cache_get_field_content_int(0,"id",dbhandle);
		SetPlayerMoney(playerid,cache_get_field_content_int(0,"money",dbhandle));
		sInfo[playerid][alevel] = cache_get_field_content_int(0,"alevel",dbhandle);
		sInfo[playerid][fraktion] = cache_get_field_content_int(0,"fraktion",dbhandle);
		sInfo[playerid][rang] = cache_get_field_content_int(0,"rang",dbhandle);
		sInfo[playerid][spawnchange] = cache_get_field_content_int(0,"spawnchange",dbhandle);
		SetPlayerScore(playerid,sInfo[playerid][level]);
		loadPlayerCars(playerid);


	}
	else
	{
		//Passwort Falsch
		SendClientMessage(playerid,grün,"Du hast dein Passwort falsch eingetippt. Versuche es nochmal!");
		ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gibt bitte dein Passwort ein:","Anmelden","Abbrechen");
	}
	return 1;
}


if(dialogid==DIALOG_LOGIN)
	{
	    if(response)
	    {
	        new name[MAX_PLAYER_NAME],query[128],passwort[35];
	        GetPlayerName(playerid,name,sizeof(name));
	        if(strlen(inputtext)>0)
	        {
	            mysql_escape_string(inputtext,passwort,dbhandle);
	            format(query,sizeof(query),"SELECT * FROM user WHERE username='%s' AND passwort=MD5('%s')",name,passwort);
	            mysql_function_query(dbhandle,query,true,"OnPasswordResponse","i",playerid);
	        }
	        else
			{
				//Keine Eingabe
				SendClientMessage(playerid,grün,"Gibt bitte dein Passwort ein.");
				ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gibt bitte dein Passwort ein:","Anmelden","Abbrechen");
   			}
	    }
	    else
	    {
	        Kick(playerid);
	    }
	}
	if(dialogid==DIALOG_REGISTER)
	{
	    if(response)
	    {
	        new name[MAX_PLAYER_NAME],query[128],passwort[35];
	        GetPlayerName(playerid,name,sizeof(name));
	        if(strlen(inputtext)>5)
	        {
	            //Registrierungsfunktion
	            mysql_escape_string(inputtext,passwort,dbhandle);
	            format(query,sizeof(query),"INSERT INTO user username = '%s', passwort = '%s', level = '1' ",name,passwort);
	            mysql_function_query(dbhandle,query,false,"","");
	            sInfo[playerid][level]=1;
	            SetPlayerScore(playerid,sInfo[playerid][level]);
	        }
	        else
	        {
	            //Kleiner als 4 Zeichen
	            SendClientMessage(playerid,helblau,"Dein Passwort muss mindestens 6 Zeichen lang sein.");
	            ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Account Erstellung","Gebe bitte nun dein gewünschtes Passwort ein!","Erstellen","Abbrechen");
	        }
	    }
	    else
	    {
	        Kick(playerid);
	    }
	}


stock SpielerName(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,MAX_PLAYER_NAME);
    return name;
}

Alles anzeigen

robbi2304 · 25. August 2016

Hallo erstmals startest du deine Verbindung gerade drei mal. Wie verbindest du dein Mode mit dem Server ? Zeig uns mal die Code Zeilen.

Hinzu schau mal ob die Zeilen vorhanden sind die hier angegeben sind

Code

[01:02:31] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'username = 'Spieler x', passwort = 'x', level = '1'' at line 1

Markuslobicher · 25. August 2016

Alles was mit dem Spieler zu tun hat:

Code

enum playerInfo{
	eingeloggt,
	level,
	db_id,
	alevel,
	fraktion,
	rang,
	spawnchange
}


enum frakteEnum{


	f_name[300],
	Float:f_x,
	Float:f_y,
	Float:f_z,
	Float:f_r,
	f_inter,
	f_world,
	f_color
}


enum autoEnum{
	id_x,
	model,
	besitzer,
	Float:c_x,
	Float:c_y,
	Float:c_z,
	Float:c_r,
	db_id
}


new sInfo[MAX_PLAYERS][playerInfo];


new fInfo[][frakteEnum] ={
{"Zivilist",329.0244,-1513.3033,36.0391,225.8344,0,0,weiß},//Zivilist 0
{"SAPD",213.4162,162.7460,1003.0234,274.4569,3,1,blau},//SAPD 1
{"SWAT",2731.5903,-2450.0164,17.5937,272.4424,0,0,helblau},//SWAT2
{"FBI",2286.9651,2431.6011,10.8203,176.4887,0,0,duneklhelblau},//FBI3
{"ARMY",214.2768,1822.5925,6.4141,265.0869,0,0,hellgrün},//ARMY4
{"Medic/Feuerwehr",302.9467,-1505.8025,24.6007,231.6743,0,0,rot},//MEDIC5
{"Fahrschule",2124.3032,-2273.0491,20.6719,221.7338,0,0,orange},//Fahrschule6
{"Aztecas",2788.4141,-1944.7075,13.5469,87.2128,0,0,türkis},//AZTECAS7
{"Vagos",204.6566,39.7421,2.5781,260.2514,0,0,gelb},//Vagos8
{"Ballas",1084.8976,-1226.7927,15.8203,269.7700,0,0,pink},//Ballas9
{"Yakuza",-2188.6282,-2265.0452,30.6250,71.4091,0,0,grau}//Yakuza10
};


new aInfo[999][autoEnum];


//mysql:
#define db_host "217.198.140.14"
#define db_user "x"
#define db_pass "x"
#define db_db "x"
new dbhandle;


//mysql verbindung:
	dbhandle = mysql_connect(db_host,db_user,db_db,db_pass);
	print("Mysql wurde verbunden!");
	mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG);




public OnGameModeExit()
{
	mysql_close(dbhandle);
	KillTimer(sekunden_timer);
	return 1;
}


public OnUserCheck(playerid)
{
	new num_rows,num_fields;
	cache_get_data(num_rows,num_fields,dbhandle);
	if(num_rows==0)
	{
		//Register
		ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Account Erstellung","Gebe bitte nun dein gewünschtes Passwort ein!","Registrieren","Abbrechen");
	}
	else
	{
		//Login
	ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Anmelden","Gebe bitte dein Passwort ein.","Anmleden","Abbrechen");
	}
	return 1;
}


public OnPlayerConnect(playerid)
{
	if(IsPlayerNPC(playerid)) return 1;
	new nachricht[128];
	format(nachricht,sizeof(nachricht),"Du bist mit der ID %i verbunden.",playerid);
	SendClientMessage(playerid,rot,nachricht);
	//Login/Register:
	new name[MAX_PLAYER_NAME],query[128];
	GetPlayerName(playerid,name,sizeof(name));
	format(query,sizeof(query),"SELECT id FROM user WHERE username='%s' ",name);
	mysql_function_query(dbhandle,query,true,"OnUserCheck","i",playerid);
	SendClientMessage(playerid,grün,"Willkommen auf Reallife Version 0.1.4! Wir wünschen euch ein angenehmen Spiel spaß bei uns!");
	//textdraws anzeigen:
	TextDrawShowForPlayer(playerid,Text:uhrzeitLabel);
	TextDrawShowForAll(Jahr);
	SetPlayerColor(playerid,weiß);
	sInfo[playerid][level]=1;
	SetPlayerScore(playerid,sInfo[playerid][level]);
	return 1;
}
  savePlayer(playerid)
{
	if(sInfo[playerid][eingeloggt]==0)return 1;
	//Speichern level,money
	new query[256];
	format(query,sizeof(query),"UPDATE user SET level='%i',money='%i',alevel='%i',fraktion='%i',rang='%i',spawnchange='%i' WHERE id='%i'",sInfo[playerid][level],GetPlayerMoney(playerid),sInfo[playerid][alevel],sInfo[playerid][fraktion],sInfo[playerid][rang],sInfo[playerid][spawnchange],sInfo[playerid][db_id]);
	mysql_function_query(dbhandle,query,false,"","");
	return 1;
}
resetPlayer(playerid)
{
	for(new i=0; i<sizeof(sInfo[]); i++)
	{
	    sInfo[playerid][playerInfo:i]=0;
	}
	return 1;
}


public OnPlayerDisconnect(playerid, reason)
{
	for(new i=0; i<sizeof(aInfo); i++)
	{
		if(aInfo[i][id_x]==0)continue;
		if(aInfo[i][besitzer]!=sInfo[playerid][db_id])continue;
		GetVehiclePos(aInfo[i][id_x],aInfo[i][c_x],aInfo[i][c_y],aInfo[i][c_z]);
		GetVehicleZAngle(aInfo[i][id_x],aInfo[i][c_r]);
		new query[156];
		format(query,sizeof(query),"UPDATE user SET level='%i',money='%i',alevel='%i',fraktion='%i',rang='%i' WHERE id='%i'",sInfo[playerid][level],
		GetPlayerMoney(playerid),sInfo[playerid][alevel],sInfo[playerid][fraktion],sInfo[playerid][rang],sInfo,sInfo[playerid][db_id]);
		mysql_function_query(dbhandle,query,false,"","");
		DestroyVehicle(aInfo[i][id_x]);
		aInfo[i][id_x]=0;
		break;
	}
	savePlayer(playerid);
	resetPlayer(playerid);
	loadPlayerCars(playerid);
	return 1;
}


public OnPlayerSpawn(playerid)
{
	if(IsPlayerNPC(playerid)) return 1;
	if(!isPlayerInFrakt(playerid,0))
	{
		if(sInfo[playerid][spawnchange]==1)
		{




			new fID;
			fID= sInfo[playerid][fraktion];
			SetPlayerPos(playerid,fInfo[fID][f_x],fInfo[fID][f_y],fInfo[fID][f_z]);
			SetPlayerFacingAngle(playerid,fInfo[fID][f_r]);
			SetPlayerInterior(playerid,fInfo[fID][f_inter]);
			SetPlayerVirtualWorld(playerid,fInfo[fID][f_world]);
			SetPlayerColor(playerid,fInfo[fID][f_color]);
		}
	}
	SendClientMessage(playerid,rot,"/hilfe um die Befehle zu sehen!");
	return 1;
}


public carSavedToDB(carid)
{
	 aInfo[carid][db_id]=cache_insert_id(dbhandle);
	 return 1;
}


 saveCarToDB(playerid,carid)
 {
	new query[128];
	format(query,sizeof(query),"INSERT INTO autos(besitzer,model,x,y,z,r) VALUES('%i','%i','%f','%f','%f','%f')",sInfo[playerid][db_id],aInfo[carid][model],aInfo[carid][c_x],aInfo[carid][c_y],aInfo[carid][c_z],aInfo[carid][c_r]);
	mysql_function_query(dbhandle,query,true,"carSavedToDB","i",carid);
	return 1;
}
createPlayerCar(playerid,modelid,Float:x,Float:y,Float:z,Float:r)
{
	for(new i=0; i<sizeof(aInfo); i++)
	{
		if(aInfo[i][id_x]!=0)continue;
		aInfo[i][besitzer]=sInfo[playerid][db_id];
		aInfo[i][c_x] =x;
		aInfo[i][c_y] =y;
		aInfo[i][c_z] =z;
		aInfo[i][c_r]	=r;
		aInfo[i][model] =modelid;
		aInfo[i][id_x] =   CreateVehicle(modelid,x,y,z,r,-1,-1,-1);
		new string[128];
		format(string,sizeof(string),"Das Auto aInfo[%i]wurde erstellt",i);
		SendClientMessageToAll(duneklhelblau,string);
		saveCarToDB(playerid,i);
		return 1;
	}
	return 1;
}
getPlayerName(playerid)
{
	new name[MAX_PLAYER_NAME];
	GetPlayerName(playerid,name,sizeof(name));
	return name;
}


     SetPlayerMoney(playerid,money)
{
	ResetPlayerMoney(playerid);
	GivePlayerMoney(playerid,money);
	return 1;
}
 getFreeCarID()
{
	for(new i=0; i<sizeof(aInfo); i++)
	{
	    if(aInfo[i][id_x]==0)return i;
	}
	return 0;
}






public OnPlayerCarsLoad(playerid)
{
	new num_fields,num_rows;
	cache_get_data(num_rows,num_fields,dbhandle);
	if(!num_rows)return 1;
	for(new i=0; i<num_rows; i++)
	{
		new id=getFreeCarID();
		aInfo[id][model]=cache_get_field_content_int(i,"model",dbhandle);
		aInfo[id][besitzer]=cache_get_field_content_int(i,"besitzer",dbhandle);
		aInfo[id][c_x]=cache_get_field_content_float(i,"x",dbhandle);
		aInfo[id][c_y]=cache_get_field_content_float(i,"y",dbhandle);
		aInfo[id][c_z]=cache_get_field_content_float(i,"z",dbhandle);
		aInfo[id][c_r]=cache_get_field_content_float(i,"r",dbhandle);
		aInfo[id][db_id]=cache_get_field_content_int(i,"id",dbhandle);
		aInfo[id][id_x]=CreateVehicle(aInfo[id][model],aInfo[id][c_x],aInfo[id][c_y],aInfo[id][c_z],aInfo[id][c_r],-1,-1,-1);
	}
	return 1;
}


loadPlayerCars(playerid)
{
	new query[128];
	format(query,sizeof(query),"SELECT * FROM autos WHERE besitzer='%i'",sInfo[playerid][db_id]);
	mysql_function_query(dbhandle,query,true,"OnPlayerCarsLoad","i",playerid);
	return 1;
}




public OnPasswordResponse(playerid)
{
	new num_rows,num_fields;
	cache_get_data(num_rows,num_fields,dbhandle);
	if(num_rows==1)
	{
		//passwort Richtig
		sInfo[playerid][eingeloggt] = 1;
		sInfo[playerid][level] = cache_get_field_content_int(0,"level",dbhandle);
		SetPlayerScore(playerid,sInfo[playerid][level]);
		sInfo[playerid][db_id] = cache_get_field_content_int(0,"id",dbhandle);
		SetPlayerMoney(playerid,cache_get_field_content_int(0,"money",dbhandle));
		sInfo[playerid][alevel] = cache_get_field_content_int(0,"alevel",dbhandle);
		sInfo[playerid][fraktion] = cache_get_field_content_int(0,"fraktion",dbhandle);
		sInfo[playerid][rang] = cache_get_field_content_int(0,"rang",dbhandle);
		sInfo[playerid][spawnchange] = cache_get_field_content_int(0,"spawnchange",dbhandle);
		SetPlayerScore(playerid,sInfo[playerid][level]);
		loadPlayerCars(playerid);


	}
	else
	{
		//Passwort Falsch
		SendClientMessage(playerid,grün,"Du hast dein Passwort falsch eingetippt. Versuche es nochmal!");
		ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gibt bitte dein Passwort ein:","Anmelden","Abbrechen");
	}
	return 1;
}




if(dialogid==DIALOG_LOGIN)
	{
	    if(response)
	    {
	        new name[MAX_PLAYER_NAME],query[128],passwort[35];
	        GetPlayerName(playerid,name,sizeof(name));
	        if(strlen(inputtext)>0)
	        {
	            mysql_escape_string(inputtext,passwort,dbhandle);
	            format(query,sizeof(query),"SELECT * FROM user WHERE username='%s' AND passwort=MD5('%s')",name,passwort);
	            mysql_function_query(dbhandle,query,true,"OnPasswordResponse","i",playerid);
	        }
	        else
			{
				//Keine Eingabe
				SendClientMessage(playerid,grün,"Gibt bitte dein Passwort ein.");
				ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gibt bitte dein Passwort ein:","Anmelden","Abbrechen");
   			}
	    }
	    else
	    {
	        Kick(playerid);
	    }
	}
	if(dialogid==DIALOG_REGISTER)
	{
	    if(response)
	    {
	        new name[MAX_PLAYER_NAME],query[128],passwort[35];
	        GetPlayerName(playerid,name,sizeof(name));
	        if(strlen(inputtext)>5)
	        {
	            //Registrierungsfunktion
	            mysql_escape_string(inputtext,passwort,dbhandle);
	            format(query,sizeof(query),"INSERT INTO user username = '%s', passwort = '%s', level = '1' ",name,passwort);
	            mysql_function_query(dbhandle,query,false,"","");
	            sInfo[playerid][level]=1;
	            SetPlayerScore(playerid,sInfo[playerid][level]);
	        }
	        else
	        {
	            //Kleiner als 4 Zeichen
	            SendClientMessage(playerid,helblau,"Dein Passwort muss mindestens 6 Zeichen lang sein.");
	            ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Account Erstellung","Gebe bitte nun dein gewünschtes Passwort ein!","Erstellen","Abbrechen");
	        }
	    }
	    else
	    {
	        Kick(playerid);
	    }




stock SpielerName(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,MAX_PLAYER_NAME);
    return name;
}

Alles anzeigen

robbi2304 · 25. August 2016

Schaue bitte in der Datenbank ob dort alle Tabellen vorhanden sind. Es sieht danach aus als wenn eine oder mehrere Tabellen fehlen.

Hinzu zeig mir mal bitte deine

public OnGameModeInit()

Markuslobicher · 25. August 2016

Die Tabellen existieren alle

robbi2304 · 25. August 2016

Code

[01:02:31] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'username = 'Spieler x', passwort = 'x', level = '1'' at line 1

Du scheinst hier ein Problem mit deiner MySQL Datenbank zu haben. Evtl hast du Schreibfehler oder ähnliches drin. Prüfe das bitte. Am Script kannst du nichts machen wenn du nicht weißt was du an der MySQL Datenbank falsch gemacht hast.

Markuslobicher · 25. August 2016

es ist alles 1:1 aus dem Ordner wo alles geklappt hat.

@Jeffry bitte wenn du zeit hast kannst du mal drüber schauen!

robbi2304 · 25. August 2016

Dann würde nun ja alles klappen =). Hat wiegesagt was mit der Verbindung zur MySQL zutun. Da kann einfach etwas nicht stimmen und ich bezweifle das @Jeffry dir bei den gemachten Angaben wie bisher helfen kann.

Probier das hier mal in phpmyadmin einzufügen unter den Reiter SQL

CREATE TABLE `user` (
`username` varchar(64) DEFAULT NULL,
`password` varchar(128) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Tabelle für die Spieler-Statistiken';

breadfish.de 12. März 2022