Zeka_Peka228
Умник
Делал трудовую книгу по мануалу этому - http://pawno-info.ru/showthread.php?t=255469
Крч запрос идет как-то криво.
Вот что в таблице:
Вот мои запросы в командах/case'aх(немного подправил, ибо те что в мануале давали варнинги):
С меня +
Крч запрос идет как-то криво.
Вот что в таблице:
Вот мои запросы в командах/case'aх(немного подправил, ибо те что в мануале давали варнинги):
PHP:
case 1144:
{
if(!response) return 1;
new actplayerid = GetPVarInt(playerid,"actinplayerid");
new fractionid = GetPVarInt(actplayerid, "pOfferFractionid");
new skinid = ChangeSkin[fractionid-1][listitem];
if(PlayerInfo[playerid][pMRInections] != fractionid) return SendClientMessage(playerid,CGRAY,"Ошибка #001");
PlayerInfo[actplayerid][pMRInections] = fractionid;
PlayerInfo[actplayerid][pRKInections] = 1;
PlayerInfo[actplayerid][pModel] = skinid;
PlayerInfo[actplayerid][pJob] = 0;
SetPlayerToTeamColor(actplayerid);
new query[256];
format(query,sizeof(query),"UPDATE `accounts` SET `pRKInections` = '%d', `pRKInections` = '1', `pModel` = '%d', `pJob` = '0' WHERE `id` = '%d'",fractionid,skinid,PlayerInfo[actplayerid][pID]);
mysql_empty(connects, query);
new mes[128];
format(mes,sizeof(mes),"%s был принят во фракцию \"%s\"",PlayerInfo[actplayerid][pNames],GetMember[PlayerInfo[actplayerid][pMRInections]-1]);
SendClientMessage(playerid,CINFO,mes);
format(mes,sizeof(mes),"Вы были приняты во фракцию \"%s\"",GetMember[PlayerInfo[actplayerid][pMRInections]-1]);
SendClientMessage(actplayerid,CINFO,mes);
SetPlayerSkin(actplayerid,skinid);
new query_invite_player_to_fraction[103 + MAX_PLAYER_NAME],
name_player_invite_to_fraction[MAX_PLAYER_NAME + 1];
GetPlayerName(playerid, name_player_invite_to_fraction, MAX_PLAYER_NAME);
mysql_format(connects, query_invite_player_to_fraction, sizeof(query_invite_player_to_fraction), "INSERT INTO `employment_history`(`name_player`, `data_invite`) VALUES ('%e', NOW())", name_player_invite_to_fraction);
mysql_function_query(connects, query_invite_player_to_fraction, false, "", "");
name_player_invite_to_fraction[0] = EOS;
if(PlayerInfo[actplayerid][pFirstInvite] == 0)
{
SCM(playerid, -1, "Ура, вступил мазафака");
PlayerInfo[actplayerid][pFirstInvite] = 1;
UpdatePlayerData(actplayerid, "FirstInvite", PlayerInfo[playerid][pFirstInvite]);
PlayerInfo[playerid][pCash] += 3000000;
}
if(StartRabWork(actplayerid))
{
SCM(actplayerid,COLOR_BLUE,"Ваш рабочий день успешно начат!");
SetPVarInt(actplayerid, "StartRabWork", 1);
}
return 1;
}
PHP:
CMD:uninvite(playerid, params[])
{
if(!IsUninviteRank(playerid)) return 1;
if(StartRabWork(playerid) && !GetPVarInt(playerid,"StartRabWork")) return SCM(playerid,COLOR_WHITE,"• {AC0000}[Ошибка] {ffffff}Вы не начали рабочий день!");
if(sscanf(params, "ds[100]",params[0],params[1])) return SCM(playerid, COLOR_WHITE, "• {FFC800}[Подсказка] {ffffff}Используйте /uninvite [playerid] [причина]");
if(params[0] == playerid) return SCM(playerid,-1,"• {AC0000}[Ошибка] {ffffff}Себя невозможно уволить");
if(PlayerInfo[params[0]][pLRInections] >= 1) SCM(playerid, COLOR_WHITE, "• {AC0000}[Ошибка] {ffffff}Неверный ID");
if(PlayerInfo[playerid][pLRInections] <= 0 && PlayerInfo[playerid][pRKInections] <= PlayerInfo[params[0]][pRKInections]) return SCM(playerid, COLOR_WHITE, "Ошибка");
if(PlayerInfo[params[0]][pMRInections] == 0) return SCM(playerid, COLOR_WHITE,"• {AC0000}[Ошибка] {ffffff}Этот человек гражданский");
if(!IsPlayerConnected(params[0]) || params[0] == INVALID_PLAYER_ID) return 1;
if(PlayerInfo[params[0]][pMRInections] == PlayerInfo[playerid][pLRInections] ||PlayerInfo[params[0]][pMRInections] == PlayerInfo[playerid][pMRInections])
{
if(PlayerInfo[params[0]][pMRInections] > 0)
{
SCMF(params[0], 0xFF182DFF, "%s уволил Вас из организации. Причина: %s", PlayerInfo[playerid][pNames],params[1]);
SCMF(playerid, 0x269BD8FF, "%s был уволен из организации. Причина: %s", PlayerInfo[params[0]][pNames],params[1]);
if(StartRabWork(params[0]))
{
SCM(params[0],COLOR_BLUE,"Ваш рабочий день окончен!");
SetPVarInt(params[0], "StartRabWork", 0);
}
PlayerInfo[params[0]][pMRInections] = 0;
PlayerInfo[params[0]][pRKInections] = 0;
PlayerInfo[params[0]][pLRInections] = 0;
PlayerInfo[params[0]][pJob] = 0;
SetPlayerToTeamColor(params[0]);
SetPlayerSkin(params[0], PlayerInfo[params[0]][pChar]);
if(PlayerInfo[playerid][pRKInections] >= 3)
{
new query_un_invite_from_fraction[285+MAX_PLAYER_NAME],name_player_un_invite_from_frac[MAX_PLAYER_NAME + 1];
GetPlayerName(playerid, name_player_un_invite_from_frac, MAX_PLAYER_NAME);
mysql_format(connects, query_un_invite_from_fraction, sizeof(query_un_invite_from_fraction), "UPDATE `employment_history` SET `data_un_invite` = 'NOW()', `rang` = '%d', `organization` = '%e', `organization_position` = '%e', WHERE `name_player` = '%e'", PlayerInfo[playerid][pRKInections], get_player_fraction_name(PlayerInfo[playerid][pLRInections]), get_player_fraction_name_rang(PlayerInfo[playerid][pMRInections], PlayerInfo[playerid][pRKInections]), name_player_un_invite_from_frac);
mysql_pquery(connects, query_un_invite_from_fraction);
}
}
}
return 1;
}
