Leigot
Изучающий
- Регистрация
- 11 Мар 2019
- Сообщения
- 210
- Лучшие ответы
- 1
- Репутация
- 2
Здрасьте, создаю 2 семьи, удаляю 1 семью, создаю 3 , удаляю 2 и удаляется 3 , но в бд удаляется 2:
В чем может быть дело?
Также прикладываю загрузку семей из MySQL:
PHP:
CMD:dellfam(playerid, params[])
{
if(PI[playerid][pAdmin] < 7)
return 1;
if(!ADuty{playerid})
return SendClientMessage(playerid, COLOR_GREY, NO_DUTY_TEXT);
extract params -> new string:familyname[15]; else
return SendClientMessage(playerid, COLOR_RED, !"Используй: /delfam [название семьи]");
if(strlen(familyname) > 15)
return 0;
new
string[128];
format(string, sizeof(string), "SELECT * FROM family WHERE name = '%s'", familyname);
mysql_tquery(mysql, string, "@DeleteFamily", "d", playerid);
return 1;
}
PHP:
@DeleteFamily(playerid);
@DeleteFamily(playerid)
{
new
rows,
fields;
cache_get_data(rows, fields);
if(!rows)
return SendClientMessage(playerid, COLOR_LIGHTRED, !"[Ошибка] {FFFFFF}Семьи с таким названием не существует!");
new
familyid;
familyid = cache_get_field_content_int(0, "id", mysql);
new
string[128];
format(string, sizeof(string), "[Информация] {FFFFFF}Семья {%s}%s {FFFFFF}успешно удалена!", FamilyChatColor[FamilyInfo[familyid][famChatColor]], FamilyInfo[familyid][famName]);
SendClientMessage(playerid, COLOR_RED, string);
FamilyInfo[familyid][famMembersCount] = 0;
FamilyInfo[familyid][famName] = EOS;
strmid(FamilyInfo[familyid][famCreator], "None", 0, MAX_PLAYER_NAME);
strmid(FamilyInfo[familyid][famZam], "None", 0, MAX_PLAYER_NAME);
strmid(FamilyInfo[familyid][famZam2], "None", 0, MAX_PLAYER_NAME);
strmid(FamilyInfo[familyid][famDiscord], "None", 0, 40);
strmid(FamilyInfo[familyid][famRaidCall], "None", 0, 10);
foreach(new i: Player)
{
if(!IsPlayerLogged{i} || PI[i][pFamilyMember] != familyid)
continue;
PI[i][pFamilyMember] = 0;
SendClientMessage(i, COLOR_RED, !"[Информация] {FFFFFF}Семья в которой вы состояли, была расформирована!");
}
format(string, sizeof(string), "UPDATE qelksekm SET FamilyMember = 0 WHERE FamilyMember = %d", familyid);
mysql_tquery(mysql, string, "", "");
TOTALFAMILY --;
format(string, sizeof(string), "DELETE FROM family WHERE id = '%d' LIMIT 1", familyid);
mysql_tquery(mysql, string, "", "");
return 1;
}
Также прикладываю загрузку семей из MySQL:
PHP:
@LoadFamily();
@LoadFamily()
{
new time = GetTickCount();
new rows, fields;
cache_get_data(rows, fields);
if(rows)
{
for(new i = 0; i < rows; i++)
{
FamilyInfo[i+1][famID] = cache_get_field_content_int(i, "id", mysql);
cache_get_field_content(i, "slogan", FamilyInfo[i+1][famSlogan], mysql);
cache_get_field_content(i, "name", FamilyInfo[i+1][famName], mysql);
FamilyInfo[i+1][famMembersCount] = cache_get_field_content_int(i, "memberscount", mysql);
cache_get_field_content(i, "creator", FamilyInfo[i+1][famCreator], mysql);
cache_get_field_content(i, "zam", FamilyInfo[i+1][famZam], mysql);
cache_get_field_content(i, "zam2", FamilyInfo[i+1][famZam2], mysql);
FamilyInfo[i+1][famChatColor] = cache_get_field_content_int(i, "chatcolor", mysql);
FamilyInfo[i+1][famGalka] = cache_get_field_content_int(i, "galka", mysql);
cache_get_field_content(i, "discord", FamilyInfo[i+1][famDiscord], mysql);
cache_get_field_content(i, "raidcall", FamilyInfo[i+1][famRaidCall], mysql);
TOTALFAMILY ++;
}
}
printf("[Загружено семей]: <%i>. Потрачено: <%i ms>.", TOTALFAMILY, GetTickCount() - time);
return 1;
}