- Регистрация
- 13 Апр 2018
- Сообщения
- 202
- Лучшие ответы
- 0
- Репутация
- 0
PHP:
[15:40:52 01/22/19] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'Crdate' in 'field list' (Query: "INSERT INTO family (ID,Name,MembersCount,Crdate,Creator) VALUES (1,'СЕРВЕР',1,CURDATE(),'Benjamin_Rivera')")
PHP:
forward CreateFamily(playerid, inputtext[]);
public CreateFamily(playerid, inputtext[])
{
new rows;
cache_get_row_count(rows);
if(rows)
{
SendClientMessage(playerid, COLOR_GREY, "[Ошибка] Указанное название семьи занято");
stringer[0] = EOS;
format(stringer, 300, "\
{FFFFFF}Всего семей: {FF9900}%d\n\
{FFFFFF}Создание семьи стоит: {FFCC00}500 кредитов\n\n\
{FFFFFF}Введите название семьи:\n\n\
{AFAFAF}Допустимое значение количества символов от 3 до 20",
TOTALFAMILY);
return ShowPlayerDialog(playerid, dCreateFamily, DIALOG_STYLE_INPUT, " ", stringer, "Принять", "Назад");
}
TOTALFAMILY++;
pInfo[playerid][pCredits] -= 500;
pInfo[playerid][pFamilyMember] = TOTALFAMILY;
mysql_query_string[0] = EOS;
format(mysql_query_string, 300, "UPDATE "T_ACCOUNTS" SET credits = %d, fam_m = %d WHERE id = %d", pInfo[playerid][pCredits], pInfo[playerid][pFamilyMember], pInfo[playerid][pID]);
mysql_tquery(dbHandle, mysql_query_string, "", "");
mysql_query_string[0] = EOS;
format(mysql_query_string, 500, "INSERT INTO "T_FAMILY" (ID,Name,MembersCount,Crdate,Creator) VALUES (%d,'%s',1,CURDATE(),'%s')", TOTALFAMILY, inputtext, GetName(playerid));
mysql_tquery(dbHandle, mysql_query_string, "", "");
format(FamilyInfo[TOTALFAMILY][famName], 20, inputtext);
FamilyInfo[TOTALFAMILY][famMembersCount] = 1;
FamilyInfo[TOTALFAMILY][famOnline] = 1;
new fam_create_year, fam_create_month, fam_create_day;
getdate(fam_create_year, fam_create_month, fam_create_day);
format(FamilyInfo[TOTALFAMILY][famCreatingDate], 20, "%02d-%02d-%02d", fam_create_year, fam_create_month, fam_create_day);
format(FamilyInfo[TOTALFAMILY][famCreator], MAX_PLAYER_NAME, GetName(playerid));
new string[128];
format(string, sizeof(string), "[Информация] {FFFFFF}Вы успешно создали семью {63BD4E}%s{FFFFFF}. Используйте {FF9900}/family {FFFFFF}для управления", FamilyInfo[TOTALFAMILY][famName]);
SendClientMessage(playerid, COLOR_YELLOW, string);
return 1;
}
Последнее редактирование: