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

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

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

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

Деление длинного запроса на части mysql(R5) sscanf2

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

hImIkAt

Новичок
Привет всем , вразумительного ответа на просторах интернета не нашел!
Проблема в том что при добавлении новых переменных в строку запроса данных с БД выдает ошибку fatal error 102: table overflow: "staging buffer"
Вот код строку пометил
PHP:
stock LoadAccounts(playerid)
{
	new Playername[MAX_PLAYER_NAME],EscName[MAX_PLAYER_NAME],n[MAX_PLAYER_NAME],p;
	new Query[256];
	GetPlayerName(playerid,Playername,sizeof(Playername));
	mysql_real_escape_string(Playername,EscName);
	format(Query,sizeof(Query),"SELECT * FROM `accounts` WHERE `Nickname` = '%s'",EscName);
	mysql_query(Query);
	mysql_store_result();
	new result[2048];
	mysql_fetch_row_format(result,"|");
	sscanf(result,"p<|>ds[32]s[32]ddddddddddddddddddddddddddddddddddddddddddddddddffdddddddfffddddddddddddddddddddddddddddddddds[128]dddddddddddddddddddddddddddd",//эта строка
	PlayerInfo[playerid][pID],n,p,
	PlayerInfo[playerid][pLevel],
	PlayerInfo[playerid][pAdmin],
	PlayerInfo[playerid][pDonateRank],
	PlayerInfo[playerid][gPupgrade],
	PlayerInfo[playerid][pConnectTime],
	PlayerInfo[playerid][pReg],
	PlayerInfo[playerid][pSex],
	PlayerInfo[playerid][pAge],
	PlayerInfo[playerid][pOrigin],
	PlayerInfo[playerid][pCK],
	PlayerInfo[playerid][pMuted],
	PlayerInfo[playerid][pExp],
	PlayerInfo[playerid][pAccount],
	PlayerInfo[playerid][pCrimes],
	PlayerInfo[playerid][pKills],
	PlayerInfo[playerid][pDeaths],
	PlayerInfo[playerid][pArrested],
	PlayerInfo[playerid][pWantedDeaths],
	PlayerInfo[playerid][pPhoneBook],
	PlayerInfo[playerid][pLottoNr],
	PlayerInfo[playerid][pFishes],
	PlayerInfo[playerid][pBiggestFish],
	PlayerInfo[playerid][pJob],
	PlayerInfo[playerid][pPayCheck],
	PlayerInfo[playerid][pHeadValue],
	PlayerInfo[playerid][pJailed],
	PlayerInfo[playerid][pJailTime],
	PlayerInfo[playerid][pMutedTime],
	PlayerInfo[playerid][pMats],
	PlayerInfo[playerid][pDrugs],
	PlayerInfo[playerid][pLeader],
	PlayerInfo[playerid][pMember],
	PlayerInfo[playerid][pFMember],
	PlayerInfo[playerid][pRank],
	PlayerInfo[playerid][pChar],
	PlayerInfo[playerid][pAidTime],
	PlayerInfo[playerid][pContractTimeM],
	PlayerInfo[playerid][pDetSkill],
	PlayerInfo[playerid][pSexSkill],
	PlayerInfo[playerid][pBoxSkill],
	PlayerInfo[playerid][pLawSkill],
	PlayerInfo[playerid][pMechSkill],
	PlayerInfo[playerid][pJackSkill],
	PlayerInfo[playerid][pCarSkill],
	PlayerInfo[playerid][pNewsSkill],
	PlayerInfo[playerid][pDrugsSkill],
	PlayerInfo[playerid][pCookSkill],
	PlayerInfo[playerid][pFishSkill],
	PlayerInfo[playerid][pHealth],
	PlayerInfo[playerid][pSHealth],
	PlayerInfo[playerid][pInt],
	PlayerInfo[playerid][pLocal],
	PlayerInfo[playerid][pTeam],
	PlayerInfo[playerid][pModel],
	PlayerInfo[playerid][pPnumber],
	PlayerInfo[playerid][pPhousekey],
	PlayerInfo[playerid][pPbiskey],
	PlayerInfo[playerid][pPos_x],
	PlayerInfo[playerid][pPos_y],
	PlayerInfo[playerid][pPos_z],
	PlayerInfo[playerid][pRMLic],
	PlayerInfo[playerid][pThiefLic],
	PlayerInfo[playerid][pDrugLic],
	PlayerInfo[playerid][pCarLic],
	PlayerInfo[playerid][pFlyLic],
	PlayerInfo[playerid][pBoatLic],
	PlayerInfo[playerid][pFishLic],
	PlayerInfo[playerid][pGunLic],
	PlayerInfo[playerid][pGun1],
	PlayerInfo[playerid][pGun2],
	PlayerInfo[playerid][pGun3],
	PlayerInfo[playerid][pGun4],
	PlayerInfo[playerid][pAmmo1],
	PlayerInfo[playerid][pAmmo2],
	PlayerInfo[playerid][pAmmo3],
	PlayerInfo[playerid][pAmmo4],
	PlayerInfo[playerid][pCarTime],
	PlayerInfo[playerid][pPayDay],
	PlayerInfo[playerid][pPayDayHad],
	PlayerInfo[playerid][pCDPlayer],
	PlayerInfo[playerid][pWins],
	PlayerInfo[playerid][pLoses],
	PlayerInfo[playerid][pAlcoholPerk],
	PlayerInfo[playerid][pDrugPerk],
	PlayerInfo[playerid][pMiserPerk],
	PlayerInfo[playerid][pPainPerk],
	PlayerInfo[playerid][pTraderPerk],
	PlayerInfo[playerid][pTut],
	PlayerInfo[playerid][pMissionNr],
	PlayerInfo[playerid][pWarns],
	PlayerInfo[playerid][pAdjustable],
	PlayerInfo[playerid][pFuel],
	PlayerInfo[playerid][pMarried],
	PlayerInfo[playerid][pMarriedTo],
	PlayerInfo[playerid][pCash],
	PlayerInfo[playerid][pParkkey],
	PlayerInfo[playerid][pCigar],
	PlayerInfo[playerid][pStyle],
	PlayerInfo[playerid][pInkas],
	PlayerInfo[playerid][pTax],
	PlayerInfo[playerid][pWantedLevel],
	PlayerInfo[playerid][pCar],
	PlayerInfo[playerid][pPasport],
	PlayerInfo[playerid][pHaveMute],
	PlayerInfo[playerid][pMuteTime],
	PlayerInfo[playerid][pArmy],
	PlayerInfo[playerid][pRobbedBank],
	PlayerInfo[playerid][pHotel],
	PlayerInfo[playerid][pRobbed],
	PlayerInfo[playerid][pMask],
	PlayerInfo[playerid][pVievMask],
	PlayerInfo[playerid][pICQ],
	PlayerInfo[playerid][pVig],
	PlayerInfo[playerid][pPcarkey],
	PlayerInfo[playerid][pPcarkey2],
	PlayerInfo[playerid][pPcarkey3],
	PlayerInfo[playerid][pDostig][0],
	PlayerInfo[playerid][pDostig][1],
	PlayerInfo[playerid][pDostig][2],
	PlayerInfo[playerid][pDostig][3],
	PlayerInfo[playerid][pDostig][4],
	PlayerInfo[playerid][pDostig][5]);
	mysql_free_result();
	gPlayerLogged[playerid]=true;
	return 1;
}
если кто может подскажите как поделить запрос на 2-е части , сам пробовал , не получилось
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу