- Регистрация
- 20 Июл 2014
- Сообщения
- 84
- Лучшие ответы
- 0
- Репутация
- 1
Всем привет. Решил скопировать систему регистрации на MySQL на чистый сервер. Всё получилось, но есть одно но, при регистрации, сервер сохраняет: ID игрока, его ник, и пароль, а остальные переменные нет. Подскажите в чём может быть проблема?
Вот stock сохранение данных:
Вот stock сохранение данных:
PHP:
stock SecondUpdate(playerid)
{
if(IsPlayerConnected(playerid))
{
if(PlayerInfo[playerid][pID] > 0 && gPlayerLogged[playerid])
{
new escname[MAX_PLAYER_NAME], Pname[MAX_PLAYER_NAME], sql[700];
GetPlayerName(playerid, Pname, sizeof(Pname));
mysql_real_escape_string(Pname, escname);
format(sql, sizeof(sql), "UPDATE `players` SET `Pcarkey`=%d,\
`Pcarkey2`=%d,\
`Pcarkey3`=%d, \
`RabotalLopatoy`=%d, \
`Vig`=%d, \
`Adjustable`=%d, \
`Fuel`=%d, \
`Married`=%d, \
`MarriedTo`='%s',",
PlayerInfo[playerid][pPcarkey],
PlayerInfo[playerid][pPcarkey2],
PlayerInfo[playerid][pPcarkey3],
PlayerInfo[playerid][pRabotalLopatoy],
PlayerInfo[playerid][pVig],
PlayerInfo[playerid][pAdjustable],
PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pMarriedTo]);
format(sql, sizeof(sql), "%s`InvWeapon`=%d,\
`InvAmmo`=%d,\
`Banned`=%d, \
`SD`=%d, \
`Lighter`=%d, \
`Cigarettes`=%d, \
`Pivo`=%d, \
`Chips`=%d, \
`Roliki`=%d, \
`Mask`=%d, \
`MaskOn`=%d,",sql,
PlayerInfo[playerid][pInvWeapon],
PlayerInfo[playerid][pInvAmmo],
PlayerInfo[playerid][pBanned],
PlayerInfo[playerid][pSD],
PlayerInfo[playerid][pLighter],
PlayerInfo[playerid][pCigarettes],
PlayerInfo[playerid][pPivo],
PlayerInfo[playerid][pChips],
PlayerInfo[playerid][pRoliki],
PlayerInfo[playerid][pMask],
PlayerInfo[playerid][pMaskOn]);
format(sql, sizeof(sql), "%s `Boxing`=%d, \
`Kneehead`=%d, \
`Kunfu`=%d, \
`Grabkick`=%d, \
`Wanted`=%d, \
`PlayerCuffed`=%d, \
`Spawn`=%d, \
`Posobie`=%d, \
`Bomb`=%d, \
`InvCash`=%d, \
`ArmBil`=%d, \
`Priz`=%d,\
`InvWeapon2`=%d, \
`InvAmmo2`=%d WHERE `ID` = %d LIMIT 1",sql,
PlayerInfo[playerid][pBoxing],
PlayerInfo[playerid][pKneehead],
PlayerInfo[playerid][pKunfu],
PlayerInfo[playerid][pGrabkick],
PlayerInfo[playerid][pWanted],
PlayerInfo[playerid][pPlayerCuffed],
PlayerInfo[playerid][pSpawn],
PlayerInfo[playerid][pPosobie],
PlayerInfo[playerid][pBomb],
PlayerInfo[playerid][pInvCash],
PlayerInfo[playerid][pArmBil],
PlayerInfo[playerid][pPriz],
PlayerInfo[playerid][pInvWeapon2],
PlayerInfo[playerid][pInvAmmo2], PlayerInfo[playerid][pID]);
mysql_query(sql);
if(mysql_errno()) SendClientMessage(playerid,COLOR_RED,"Ошибка MySQL");
new name[24]; GetPlayerName(playerid, name, sizeof(name));
printf("SavePlayer2(ID: %d, Name: %s, DB ID: %d)", playerid, name, PlayerInfo[playerid][pID]);
return true;
}
}
return false;
}