[hanzen]

Well I have a problem inserting things to MySQL. This is the code:

Код:

	SetPlayerInterior(playerid, PlayerInfo[playerid][pInt]);
	format(query, sizeof(query), "INSERT INTO players (money, level, admin, interior, bank) VALUES ('%d', '%d', '%d', '%d', '%d')",PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pInt], PlayerInfo[playerid][pName], PlayerInfo[playerid][pBank]);

[Kyosaur]

more info please?

[hanzen]

Sorry, managed to post wrong lines.

Код:

	new query[256];
	format(query, sizeof(query), "INSERT INTO players (money, level, admin, interior, bank) VALUES ('%d', '%d', '%d', '%d', '%d')",PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pInt], PlayerInfo[playerid][pName], PlayerInfo[playerid][pBank]);
	mysql_query(query, SQLPtr);

[woot]

No, you managed to not-tell us what the issue is.

[Kyosaur]

Quote:

Originally Posted by hanzen Sorry, managed to post wrong lines. Код: new query[256]; format(query, sizeof(query), "INSERT INTO players (money, level, admin, interior, bank) VALUES ('%d', '%d', '%d', '%d', '%d')",PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pInt], PlayerInfo[playerid][pName], PlayerInfo[playerid][pBank]); mysql_query(query, SQLPtr);

Two things i noticed from that code: Specifier count doesnt match the variable count. Also, your using the wrong type of specifiers. pName and pAdmin should be strings (erm well pName for sure).

[hanzen]

Ok.. OnPlayerUpdate() is suppose to update som data in the database. I run this, but it wont insert into the table.

Код:

	new query[256];
	format(query, sizeof(query), "UPDATE players SET money = '%d', level = '%d', admin = '%d', skin = '%d', bank = '%d' WHERE name = '%s'",PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pBank]), PlayerInfo[playerid][pName];
	mysql_query(query, SQLPtr);

[Kyosaur]

Quote:

Originally Posted by hanzen Ok.. OnPlayerUpdate() is suppose to update som data in the database. I run this, but it wont insert into the table. Код: new query[256]; format(query, sizeof(query), "UPDATE players SET money = '%d', level = '%d', admin = '%d', skin = '%d', bank = '%d' WHERE name = '%s'",PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pBank]), PlayerInfo[playerid][pName]; mysql_query(query, SQLPtr);

Dont use OnPlayerUpdate to save stats, its called way to frequently.


Edit:

The problem with the second one is that the ")" is in the wrong place.


BTW: is "PlayerInfo[playerid][pAdmin]" a string or an integer? Im thinking its a string, as you already have a variable for admin level, so change the corresponding %d's into %s's.

[hanzen]

Seems like I got it working with changing the ")". Still it doesnt enter the info correctly.


Money is suppose to be 20000.
Level is correct.
Admin is suppose to be 5.
Skin is suppose to be 104.
Bank is suppose to be 0.

[hanzen]

Well.. it keeps inserting the info to random fields.