[BrnX]

Hi People! How to fix the mysql R41-2 CHARACTER DATA SAVE AND LOAD??


[MYSQL R41-2]


SUCCESFULLY REGISTERED ACCOUNT CODE:

Код:

new escape[128]; mysql_escape_string(query,escape);
		format(query,sizeof(query),"INSERT INTO players (IP,Name,Password,Properties,RegDate,LogDate,Admin,JatekosPenz,JatekosSzint,PosX,PosY,PosZ,JatekosInti,JatekosOles,JatekosHalal,JatekosOra,JatekosPerc,JatekosMPerc,JatekosSkin) VALUES ('%s','%s',MD5('%s'),'%s','%s','%s',%d,%d,%d,%f,%f,%f,%d,%d,%d,%d,%d,%d,%d)",
		pIP(playerid),
		pName(playerid),
		password,
		properties_string,
		GetFormatedDate(),
		GetFormatedDate(),
		0,
		1000,
		1,
		1753.3008,
		-1894.0869,
		13.5572,
		0,
		0,
		0,
		0,
		0,
		0,
		26);

		mysql_tquery(SQL,query);
		MSG(playerid,""COL_GREEN"(( User registered sucesfully. ))");
		PlayerPlaySound(playerid,1058,0.0,0.0,0.0);
		ShowLoginDialog(playerid,PHASE_USERNAME);

Код:

stock LoadPlayer(playerid)
{
    cache_get_value_int(0, "ID", pInfo[playerid][pID]);
    cache_get_value_name_int(playerid, "Admin", pInfo[playerid][pAdmin]);
    cache_get_value_name_int(playerid,"JatekosPenz", pInfo[playerid][pJatekosPenz]);
    cache_get_value_name_int(playerid, "JatekosSzint", pInfo[playerid][pJatekosSzint]);
	cache_get_value_name_float(playerid, "PosX", pInfo[playerid][PosX]);
	cache_get_value_name_float(playerid, "PosY", pInfo[playerid][PosY]);
	cache_get_value_name_float(playerid, "PosZ", pInfo[playerid][PosZ]);
	cache_get_value_name_int(playerid, "JatekosOra", pInfo[playerid][pJatekosOra]);
	cache_get_value_name_int(playerid, "JatekosPerc", pInfo[playerid][pJatekosPerc]);
	cache_get_value_name_int(playerid, "JatekosMPerc", pInfo[playerid][pJatekosMPerc]);
	cache_get_value_name_int(playerid,"JatekosOles", pInfo[playerid][pJatekosOles]);
	cache_get_value_name_int(playerid,"JatekosInti", pInfo[playerid][pJatekosInti]);
	cache_get_value_name_int(playerid, "JatekosHalal", pInfo[playerid][pJatekosHalal]);
	cache_get_value_name_int(playerid, "JatekosSkin", pInfo[playerid][pJatekosSkin]);
	return 1;
}

Код:

stock SavePlayer(playerid)
{

		format(query,sizeof(query),"UPDATE players SET LogDate = '%s', Admin = %d, JatekosPenz = %d, JatekosSzint = %d, PosX = %f, PosY = %f, PosZ = %f, JatekosInti = %d, JatekosOles = %d, JatekosHalal = %d, JatekosOra = %d, JatekosPerc = %d, JatekosMPerc = %d, JatekosSkin = %d, WHERE ID = %d",
		GetFormatedDate(),
		pInfo[playerid][pAdmin],
		pInfo[playerid][pJatekosPenz],
		pInfo[playerid][pJatekosSzint],
		pInfo[playerid][PosX],
		pInfo[playerid][PosY],
		pInfo[playerid][PosZ],
		pInfo[playerid][pJatekosInti],
		pInfo[playerid][pJatekosOles],
		pInfo[playerid][pJatekosHalal],
		pInfo[playerid][pJatekosOra],
		pInfo[playerid][pJatekosPerc],
		pInfo[playerid][pJatekosMPerc],
		pInfo[playerid][pJatekosSkin],
		pInfo[playerid][pID]);
		mysql_tquery(SQL,query);
	// Reset Enums kйsőbbiekben.
	ResetPlayerVariables(playerid,1);
	return 1;
}

[Vince]

Quote:

Код: mysql_tquery(SQL,query); MSG(playerid,""COL_GREEN"(( User registered sucesfully. ))");

You don't even know that at this point. Use a callback and use cache_insert_id(). Then you have certainty.

Also, uhm, where is the actual load query?

[STRIKER19501]

Use y_ini it's easier

[Luke_James]

The load function is missing an SQL query which gets information from your database; it cannot load something if you're not telling it to.

EDIT: I didn't notice that Vince had replied with the same thing.

[BrnX]

mysql_tquery(Database, DB_Query, "OnPlayerDataCheck", "ii", playerid, Corrupt_Check[playerid]);

Should it be similar?

And do you pass it on to me?

Thank You

[BrnX]

he??

[BrnX]

stock LoadPlayer(playerid)
{
cache_get_value_int(0, "ID", pInfo[playerid][pID]);
cache_get_value_name_int(playerid, "Admin", pInfo[playerid][pAdmin]);
cache_get_value_name_int(playerid,"JatekosPenz", pInfo[playerid][pJatekosPenz]);
cache_get_value_name_int(playerid, "JatekosSzint", pInfo[playerid][pJatekosSzint]);
cache_get_value_name_float(playerid, "PosX", pInfo[playerid][PosX]);
cache_get_value_name_float(playerid, "PosY", pInfo[playerid][PosY]);
cache_get_value_name_float(playerid, "PosZ", pInfo[playerid][PosZ]);
cache_get_value_name_int(playerid, "JatekosOra", pInfo[playerid][pJatekosOra]);
cache_get_value_name_int(playerid, "JatekosPerc", pInfo[playerid][pJatekosPerc]);
cache_get_value_name_int(playerid, "JatekosMPerc", pInfo[playerid][pJatekosMPerc]);
cache_get_value_name_int(playerid,"JatekosOles", pInfo[playerid][pJatekosOles]);
cache_get_value_name_int(playerid,"JatekosInti", pInfo[playerid][pJatekosInti]);
cache_get_value_name_int(playerid, "JatekosHalal", pInfo[playerid][pJatekosHalal]);
cache_get_value_name_int(playerid, "JatekosSkin", pInfo[playerid][pJatekosSkin]);
return 1;
}

its okey?