Kala4ik
Компетентный
Всем добрый день, столкнулся с такой проблемой. В общем когда получил Exp, появилась ошибка в логах mysql. И Exp не обновилось в БД.
PHP:
[00:03:53] [ERROR] error #2013 while executing query "UPDATE `accounts` SET `LvL` = '0',`Exp` = '1' WHERE `ID` = '1'": Lost connection to MySQL server during query (C:\Users\d3mix\Desktop\MySql R41-4\gamemodes\newproject.pwn:969 -> C:\Users\d3mix\Desktop\MySql R41-4\gamemodes\newproject.pwn:952 -> C:\Users\d3mix\Desktop\MySql R41-4\gamemodes\newproject.pwn:830)
PHP:
stock PayDay(playerid)
{
SendClientMessage(playerid,0x006400AA,"Поздравляем, с зарплатой.");
GiveExp(playerid,1);
}
stock GiveExp(playerid,exp)
{
Player[playerid][pExp] += exp;
new expamount;
if(Player[playerid][pLvL] == 0) expamount = 3;
else expamount = Player[playerid][pLvL]*5;
if(Player[playerid][pExp] >= expamount)
{
Player[playerid][pLvL]++;
SetPlayerScore(playerid,Player[playerid][pLvL]);
SendClientMessage(playerid,0x006400AA,"Поздравляем, Вы получили новый уровень.");
}
static const fmt_query[] = "UPDATE `accounts` SET `LvL` = '%d',`Exp` = '%d' WHERE `ID` = '%d'";
new query[sizeof(fmt_query)+(-2+6)+(-2+10)+(-2+11)];
format(query,sizeof(query),fmt_query,Player[playerid][pLvL],Player[playerid][pExp],Player[playerid][pID]);
mysql_tquery(database,query);
}
