MySQL problem
#1

I have two strings. I'm formating:
Код:
new bankszamla[11], bankjelszo[5];
format(bankszamla, 11, "%d%d%d-%d%d%d-%d%d%d",random(9),random(9),random(9),random(9),random(9),random(9),random(9),random(9),random(9));
format(bankjelszo, 5, "%d%d%d%d%d",random(9),random(9),random(9),random(9),random(9));
For some reason they're not saved to the database, only the player's ID.


What's the problem?
Код:
mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `Admin`, `Level`, `Money`, `PosX`, `PosY`, `PosZ`, `PosA`, `Eletkor`, `Nem`, `Skin`, `Szarmazas`, `Health`, `Armor`, `BankEgyenleg`, `BankSzamla`, `BankJelszo`) VALUES ('%e', '%e', '%e', 0, 0, 0, %f, %f, %f, %f, %d, %d, %d, %d, 100.0, 0.0, 0, '%e', '%e')",
playername, Player[playerid][Password], playerip, SPAWN_X, SPAWN_Y, SPAWN_Z, SPAWN_A, Player[playerid][Adat][0], Player[playerid][Adat][1], Player[playerid][Adat][2], Player[playerid][Adat][3], bankszamla, bankjelszo);
mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);
Reply


Messages In This Thread
MySQL problem - by Ripster - 02.01.2017, 16:15
Re: MySQL problem - by Vince - 02.01.2017, 16:22
Re: MySQL problem - by Ripster - 02.01.2017, 17:38

Forum Jump:


Users browsing this thread: 3 Guest(s)