MySQL query first letter - Printable Version

MySQL query first letter - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL query first letter (/showthread.php?tid=661460)

MySQL query first letter - theralio - 04.12.2018

Hey,

My MySQL Script just repeats the first Letters.

This is the Output

Код:

UPDATE users SET geburtstag = '1', vorname = 'S', nachname = 'G' , geschlecht = '0' WHERE id = '6'

The Code is

Код:

	mysql_format(handle, query, sizeof(query), "UPDATE users SET geburtstag = '%e', vorname = '%e', nachname = '%e' , geschlecht = '%d' WHERE id = '%d'",
	PlayerInfo[playerid][pGeburtstag], PlayerInfo[playerid][pVorname],PlayerInfo[playerid][pNachname],PlayerInfo[playerid][pGeschlecht], PlayerInfo[playerid][p_id]);

The Enum is

Код:

pVorname[128],
	pNachname[128],
	pGeburtstag[20],

The pVorname gets read in OnDialogResponse

Code:

Код:

	strcpy(Vorname[playerid], inputtext, 128);
	if(strlen(inputtext) < 3) return SendClientMessage(playerid,-1,"Dein Vorname muss mindestens 3 Buchstaben enthalten!");
	format(string,sizeof(string),"Dein Vorname ist nun %s", Vorname[playerid]);
	SendClientMessage(playerid,-1,string);
	PlayerTextDrawSetString(playerid,RegisterPTD[playerid][1],Vorname[playerid]);
	SelectTextDraw(playerid, 0xFFFFFFFF);
	PlayerInfo[playerid][pVorname]  = Vorname[playerid];

Re: MySQL query first letter - Kaliber - 05.12.2018

Can you print your variables alone, to see, if there is really more than one char?

Re: MySQL query first letter - Calisthenics - 05.12.2018

pawn Код:

PlayerInfo[playerid][pVorname]  = Vorname[playerid];

Do not copy strings directly. Use strcpy instead.