Ayeshnikkk
Дебютант
Суть в том, что когда я регистрируюсь, то в базу записывается всегда нулевой айди скина. Помогите исправить
Строки системы:
new regmaleskins[9][4] =
{
(19,21,22,28), //Íåãðîèäíàÿ 18-29
(24,25,36,67), //Íåãðîèäíàÿ 30-45
(14,142,182,183), //Íåãðîèäíàÿ 46-60
(29,96,101,26), //Åâðîïåîäíàÿ 18-29
(2,37,72,202), //Åâðîïåîäíàÿ 30-45
(1,3,234,290), //Åâðîïåîäíàÿ 46-60
(23,60,170,180), // È Ò.Ä
(20,47,48,206),
(44,58,132,229)
};
new regfemaleskins[9][2] =
{
(13,69),
(9,190),
(10,218),
(41,56),
(31,151),
(39,89),
(169,193),
(207,225),
(54,130)
};
new newskinindex;
switch(player_info[playerid][RACE])
{
case 1: {}
case 2: newskinindex+=3;
case 3: newskinindex+=6;
}
switch(player_info[playerid][AGE])
{
case 18..29: {}
case 30..45: newskinindex++;
case 46..60: newskinindex+=2;
}
if(player_info[playerid][SEX] == 1) player_info[playerid][SKIN] = regmaleskins[newskinindex][random(4)];
else player_info[playerid][SKIN] = regfemaleskins[newskinindex][random(2)];
Если потребуются строки mysql:
static const fmt_query[] = "INSERT INTO `accounts` (`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], 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);
В логе mysql все чисто. Просьба помочь!
Строки системы:
new regmaleskins[9][4] =
{
(19,21,22,28), //Íåãðîèäíàÿ 18-29
(24,25,36,67), //Íåãðîèäíàÿ 30-45
(14,142,182,183), //Íåãðîèäíàÿ 46-60
(29,96,101,26), //Åâðîïåîäíàÿ 18-29
(2,37,72,202), //Åâðîïåîäíàÿ 30-45
(1,3,234,290), //Åâðîïåîäíàÿ 46-60
(23,60,170,180), // È Ò.Ä
(20,47,48,206),
(44,58,132,229)
};
new regfemaleskins[9][2] =
{
(13,69),
(9,190),
(10,218),
(41,56),
(31,151),
(39,89),
(169,193),
(207,225),
(54,130)
};
new newskinindex;
switch(player_info[playerid][RACE])
{
case 1: {}
case 2: newskinindex+=3;
case 3: newskinindex+=6;
}
switch(player_info[playerid][AGE])
{
case 18..29: {}
case 30..45: newskinindex++;
case 46..60: newskinindex+=2;
}
if(player_info[playerid][SEX] == 1) player_info[playerid][SKIN] = regmaleskins[newskinindex][random(4)];
else player_info[playerid][SKIN] = regfemaleskins[newskinindex][random(2)];
Если потребуются строки mysql:
static const fmt_query[] = "INSERT INTO `accounts` (`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], 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);
В логе mysql все чисто. Просьба помочь!
