gggtttiii
Новичок
Здравствуйте! Начал писать мод по видео Leon Уроки павно #4 Дак вот, делал все как на виде а ошибка в mysql_log выскакивает! Помогите)
Ошибка : [22:33:23] [ERROR] error #1054 while executing query "INSERT INTO `users` (`name`, `password`, `salt`, `email`, `ref`, `sex`, `race`, `age`, `skin`, `regdata`, `regip`) VALUES (`Relax_Cris`, `FFBAB4F7E400F1600C2E2659B69DBAC6F95936D38BBDF178B01A8DA316EED1C1`, `KH4DJ]]gBt`, `dimau2188@gmail.com`, `0`, `1`, `1`, `18`, `19`, `07.02.2022`, `127.0.0.1`)": Unknown column 'Relax_Cris' in 'field list' (C:\Users\SAMPer\Desktop\ybdbq\gamemodes\kreker.pwn:545)
Код :
Буду признателен если поможете\
Ошибка : [22:33:23] [ERROR] error #1054 while executing query "INSERT INTO `users` (`name`, `password`, `salt`, `email`, `ref`, `sex`, `race`, `age`, `skin`, `regdata`, `regip`) VALUES (`Relax_Cris`, `FFBAB4F7E400F1600C2E2659B69DBAC6F95936D38BBDF178B01A8DA316EED1C1`, `KH4DJ]]gBt`, `dimau2188@gmail.com`, `0`, `1`, `1`, `18`, `19`, `07.02.2022`, `127.0.0.1`)": Unknown column 'Relax_Cris' in 'field list' (C:\Users\SAMPer\Desktop\ybdbq\gamemodes\kreker.pwn:545)
Код :
PHP:
if(player_info[playerid][SEX] == 1) player_info[playerid][SKIN] = regmaleskins[newskinindex][random(4)];
else player_info[playerid][SKIN] = regfemaleskins[newskinindex][random(2)];
new Year, Month, Day;
getdate(Year, Month, Day);
new date[13];
format(date, sizeof(date), "%02d.%02d.%d", Day, Month, Year);
new ip[16];
GetPlayerIp(playerid, ip, sizeof(ip));
static const fmt_query[] = "INSERT INTO `users` (`name`, `password`, `salt`, `email`, `ref`, `sex`, `race`, `age`, `skin`, `regdata`, `regip`) VALUES (`%s`, `%s`, `%s`, `%s`, `%d`, `%d`, `%d`, `%d`, `%d`, `%s`, `%s`)";
new query[sizeof(fmt_query)+(-2+MAX_PLAYER_NAME)+(-2+64)+(-2+10)+(-2+64)+(-2+8)+(-2+1)+(-2+1)+(-2+2)+(-2+3)+(-2+12)+(-2+15)];
format(query, sizeof(query), fmt_query, player_info[playerid][NAME], player_info[playerid][PASSWORD], player_info[playerid][SALT], player_info[playerid][EMAIL], player_info[playerid][REF], player_info[playerid][SEX], player_info[playerid][RACE], player_info[playerid][AGE], player_info[playerid][SKIN], date, ip);
mysql_query(dbHandle, query);
