Witam. Na wstepie powiem, ze dopiero ucze sie MySQL wi?c za du?o nie wiem, ale szybko ?apie.
Ot?z tworze sobie system zapisywania pieniedzy w bazie danych z nickiem
(nick varchar(24), hajs int(9)).
Problem u mnie lezy w tym, ?e kompletnie nic sie nie zapisuje, a okienko z stanem konta (tym co w bazie jest) sie nie pokazuje.
Oto kod:
[pawn]#include <a_samp>
#include <mysql>
#include <dcmd>
#define HOST "localhost"
#define USER "samp"
#define PASS "samp"
#define DB "samp"
#define D_BANK 5
#define D_STANKONTA 6
main(){}
enum Gracz
{
pNick[MAX_PLAYER_NAME],
pHajs
};
new Player[MAX_PLAYERS][Gracz];
public OnFilterScriptInit()
{
mysql_init(LOG_ONLY_ERRORS);
mysql_connect(HOST, USER, PASS, DB);
return 1;
}
public OnPlayerConnect(playerid)
{
new query[126];
GetPlayerName(playerid, Player[playerid][pNick], MAX_PLAYER_NAME);
format(query, sizeof(query), "INSERT INTO bank (nick, hajs) VALUES('%s', '%d')", Player[playerid][pNick], Player[playerid][pHajs]);
mysql_query(query);
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
new query[256];
GetPlayerName(playerid, Player[playerid][pNick], MAX_PLAYER_NAME);
format(query, sizeof(query), "UPDATE bank SET hajs = '%d' WHERE nick = '%s'", Player[playerid][pHajs], Player[playerid][pNick]);
mysql_query(query);
return 1;
}
public OnPlayerSpawn(playerid)
{
GivePlayerMoney(playerid, ... |