Frend Williams
Умник
Сама команда и сток.
Увидел еррор в mysql_log. Но, столбец имеется в базе с MuteTime.
Код:
CMD:offmute(playerid,params[])
{
if(PlayerInfo[playerid][pAlcoInvenxua] < 12) return true;
new query[128],param_reason[32],param_day;
if(sscanf(params, "s[24]ds[32]", params[0],param_day,param_reason)) return SendClientMessage(playerid, COLOR_WHITE, "Используйте: /offmute [Nick_Name] [Минуты] [Причина]");
foreach(Player, i)
{
new szName[64];
if(!IsPlayerConnected(i)) continue;
GetPlayerName(i,szName,64);
if(!strcmp(params[0], szName, false)) return SendClientMessage(playerid,-1,"Этот игрок в сети, используйте /mute");
}
if(param_day > 300 || param_day < 1) return SendClientMessage(playerid, -1, "Используйте от 1 до 300 мин.");
SetPVarString(playerid,"OffMuteReason",param_reason);
SetPVarInt(playerid,"OffMuteDay",param_day);
format(query,sizeof(query), "SELECT * FROM `"TABLE_ACCOUNT"` WHERE `Name` = '%s'", params[0]);
mysql_function_query(connects, query, true, "OffMutes", "is", playerid, params[0]);
PlayerInfo[params[0]][pMuteTime] = param_day*60;
PlayerInfo[params[0]][pMuted] = 1;
PlayerInfo[playerid][pMuteAdm]++;
return 1;
}
forward OffMutes(playerid, name[]);
public OffMutes(playerid, name[])
{
new rows,fields;
cache_get_data(rows, fields);
if(!rows) return SendClientMessage(playerid,-1,"Аккаунт по Вашему запросу не был найден.");
new string[216],reason[32];
GetPVarString(playerid,"OffMuteReason",reason,sizeof(reason));
format(string,sizeof(string),"UPDATE `"TABLE_ACCOUNT"` SET `MuteTime` = '%d', `Muted` = '1' WHERE `Name` = '%s'",GetPVarInt(playerid,"OffMuteDay"),name);
mysql_function_query(connects, string, true, "", "");
format(string,sizeof(string),"[OFFLINE]: Администратор %s выдал бан чата игроку %s на %i мин. Причина: %s",PlayerInfo[playerid][pNames],name,GetPVarInt(playerid,"OffMuteDay"),reason);
SendClientMessageToAll(COLOR_LIGHTRED,string);
DeletePVar(playerid,"OffMuteReason");
DeletePVar(playerid,"OffMuteDay");
return 1;
}
C++:
[00:30:28] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'MuteTime' in 'field list'
Последнее редактирование:
