Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Запрос MySQL

Статус
В этой теме нельзя размещать новые ответы.

DennyShow

Новичок
Server-Log

PHP:
[02:47:20] UPDATE `accounts` SET `name` = 'Black_Shclycha', `key` = 'GyyVDAAY', `mail` = 'galonskij@list.ru', `level` = '0', `Money` = '0', `exp` = '0', `warn` = '0', `number` = '0', `cashnumber` = '0', `zakon` = '0', `zvezda` = '0', `narko` = '0', `zavnarko` = '0', `ammo` = '0', `sex` = '1', `age` = '19', `member` = '0', `rank` = '0', `house` = '0', `biz` = '0', `hotel` = '0', `rabota` = '0', `admin` = '8', `dostup` = '0', `Health` = '0.000000', `Bronya` = '0.000000', `Skin` = '2', `LicAvto` = '0', `LicGun` = '0', `LicBiz` = '0', `LicLodka` = '0', `LicVert` = '0', `Weapon` = '0', `Mats` = '0', `Card` = '0', `PassCard` = '0', `NalCar` = '0', `Car` = '0', `Donat` = '0', `MuteTime` = '0', `Ban` = '0', `RegIp` = '127.0.0.1', `LastIp` = '255.255.255.255', `SkinOrg` = '53', `Kod` = '49', `Ref` = 'Denny_Show8525.255.255.2Беларус55', `Nacia` = 'Беларус55', `Leader` = '53', `ZamLeader` = '53', `Prichina` = '255.255' WHERE `id` = '0'
Mysql-Log

PHP:
[02:45:03 08/11/17] [ERROR] mysql_query - invalid connection handle (id: 0)
[02:45:03 08/11/17] [ERROR] mysql_query - invalid connection handle (id: 0)
Код:

PHP:
stock SaveAccount(playerid)
{
    new query[1000];
    GetPlayerIp(playerid, PlayerInfo[playerid][pLastIp], 16);
    format(query, sizeof(query), "UPDATE `accounts` SET `name` = '%s', `key` = '%s', `mail` = '%s', `level` = '%i', `Money` = '%i', `exp` = '%i', `warn` = '%i', `number` = '%i', `cashnumber` = '%i', `zakon` = '%i', `zvezda` = '%i', `narko` = '%i', `zavnarko` = '%i', `ammo` = '%i', `sex` = '%i', `age` = '%i', `member` = '%i', `rank` = '%i', `house` = '%i', `biz` = '%i', `hotel` = '%i', `rabota` = '%i', `admin` = '%i', `dostup` = '%i', `Health` = '%f', `Bronya` = '%f', `Skin` = '%i', `LicAvto` = '%i', `LicGun` = '%i', `LicBiz` = '%i', `LicLodka` = '%i', `LicVert` = '%i', `Weapon` = '%i', `Mats` = '%i', `Card` = '%i', `PassCard` = '%i', `NalCar` = '%i', `Car` = '%i', `Donat` = '%i', `MuteTime` = '%i', `Ban` = '%i', `RegIp` = '%s', `LastIp` = '%s', `SkinOrg` = '%i', `Kod` = '%i', `Ref` = '%s', `Nacia` = '%s', `Leader` = '%i', `ZamLeader` = '%i', `Prichina` = '%s' WHERE `id` = '%d'", PlayerInfo[playerid][pName], PlayerInfo[playerid][pKey], PlayerInfo[playerid][pMail], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pExp], PlayerInfo[playerid][pWarn], PlayerInfo[playerid][pNumber], PlayerInfo[playerid][pCashNumber], PlayerInfo[playerid][pZakon], PlayerInfo[playerid][pZvezda], PlayerInfo[playerid][pNarko], PlayerInfo[playerid][pZavNarko], PlayerInfo[playerid][pAmmo], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pMember], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pHouse], PlayerInfo[playerid][pBiz], PlayerInfo[playerid][pHotel], PlayerInfo[playerid][pRabota], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDostup], PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pBronya], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pLicAvto], PlayerInfo[playerid][pLicGun], PlayerInfo[playerid][pLicBiz], PlayerInfo[playerid][pLicLodka], PlayerInfo[playerid][pLicVert], PlayerInfo[playerid][pWeapon], PlayerInfo[playerid][pMats], PlayerInfo[playerid][pCard], PlayerInfo[playerid][pPassCard], PlayerInfo[playerid][pNalCar], PlayerInfo[playerid][pCar], PlayerInfo[playerid][pDonat], PlayerInfo[playerid][pMuteTime], PlayerInfo[playerid][pBan], PlayerInfo[playerid][pRegIp], PlayerInfo[playerid][pLastIp], PlayerInfo[playerid][pSkinOrg], PlayerInfo[playerid][pKod], PlayerInfo[playerid][pRef], PlayerInfo[playerid][pNacia], PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pZamLeader], PlayerInfo[playerid][pPrichina], PlayerInfo[playerid][pID]);
    PlayerInfo[playerid][pPickOrg] = 0;
    mysql_function_query(mysql_connect_ID, query, false, "", "");
    print(query);
    return 1;
}


Просто не сохраняет аккаунт!
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу