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

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

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

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

sscanf, mysql R7

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

Dimosha1337

Дебютант
Доброго времени суток. Проблема заключается в том, что не прогружает скиллы игрока. Причина не понятна, варнингов и эрроров ни в консоле, ни при компиляции нет.
Код:
stock LoadPlayerSkills(playerid)
{
	new string[200], result[300], name[24];
	format(string, sizeof(string), "SELECT * FROM `AccountSkill` WHERE `NickName` = '%s' LIMIT 1", PN(playerid));
	mysql_query(string);
	mysql_store_result();
	mysql_fetch_row(result, "|");
	sscanf(result, "p<|>is[24]dddddddddd",
	PlayerInfo[playerid][pID],
	name,
	PlayerInfo[playerid][pMinerSkill],
	PlayerInfo[playerid][pCarJSkill],
	PlayerInfo[playerid][pMechanicSkill],
	PlayerInfo[playerid][pTaxiSkill],
	PlayerInfo[playerid][pCoachSkill],
	PlayerInfo[playerid][pGuideSkill],
	PlayerInfo[playerid][pCollectorSkill],
	PlayerInfo[playerid][pScraperSkill],
	PlayerInfo[playerid][pMusorSkill],
	PlayerInfo[playerid][pTruckSkill]);
	return true;
}

stock OnPlayerLogin(playerid, bool:spawn = true)
{
	new string[400], style, result[2000], name[24], pass[35], NewVirMoney;
	if(IsAFexistAccount(PN(playerid)))
	{
		format(string, sizeof(string), "SELECT * FROM `Accounts` WHERE `ID` = '%i' LIMIT 1", PlayerInfo[playerid][pID]);
		mysql_query(string);
		mysql_store_result();
		mysql_fetch_row(result, "|");
		sscanf(result, "p<|>is[24]s[35]s[16]s[16]s[16]s[16]s[24]s[50]s[20]s[30]dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddfd",
		PlayerInfo[playerid][pID], //ID
		name, //NickName
		pass, //Password
		PlayerRegIP[playerid], //RegIP
		PlayerIp[playerid], //OldIP
		PlayerCheckIP1[playerid], //CheckIP
		PlayerCheckIP2[playerid], //CheckIP
		PlayerReferal[playerid], //Referal
		PlayerMail[playerid], //Mail
		PlayerTelephone[playerid], //Telephone
		PlayerFName[playerid], //Name
		PlayerInfo[playerid][pLevel], //Level
		PlayerInfo[playerid][pExp], //Exp
		PlayerInfo[playerid][pPlayHours], //PlayHours
		PlayerInfo[playerid][pSex], //Sex
		PlayerInfo[playerid][pAge], //Age
		PlayerInfo[playerid][pRace], //Race
		PlayerInfo[playerid][pAdmin], //Admin
		PlayerInfo[playerid][pHelper], //Helper
		PlayerInfo[playerid][pMoney], //Money
		PlayerInfo[playerid][pBank], //Bank
		PlayerInfo[playerid][pWanted], //Wanted
		PlayerInfo[playerid][pVIP], //VIP
		PlayerInfo[playerid][pLeader], //Leader
		PlayerInfo[playerid][pMember], //Member
		PlayerInfo[playerid][pRank], //Rank
		PlayerInfo[playerid][pGunLic], //GunLic
		PlayerInfo[playerid][pBoatLic], //BoatLic
		PlayerInfo[playerid][pFishLic], //FishLic
		PlayerInfo[playerid][pFlyLic], //FlyLic
		PlayerInfo[playerid][pCarLic], //CarLic
		PlayerInfo[playerid][pBikeLic], //BikeLic
		PlayerInfo[playerid][pD_Packets], //D_Packets
		PlayerInfo[playerid][pWarns], //Warns
		PlayerInfo[playerid][pPayDay], //PayDay
		PlayerInfo[playerid][pHouseKey], //HouseKey
		PlayerInfo[playerid][pBizKey], //BizKey
		PlayerInfo[playerid][pFWarns], //FWarns
		PlayerInfo[playerid][pSkin], //Skin
		PlayerInfo[playerid][pTelNum], //TelNum
		PlayerInfo[playerid][pPhone], //Phone
		PlayerInfo[playerid][pMats], //Mats
		PlayerInfo[playerid][pPackets], //Packets
		PlayerInfo[playerid][pDrugs], //Drugs
		PlayerInfo[playerid][pJob], //Job
		PlayerInfo[playerid][pMuteTime], //MuteTime
		PlayerInfo[playerid][pFMuteTime], //FMuteTime
		PlayerInfo[playerid][pJailTime], //JailTime
		PlayerInfo[playerid][pBailPrice], //BailPrice
		PlayerInfo[playerid][pKungfu], //KungfuStyle
		PlayerInfo[playerid][pKneehead], //KneeheadStyle
		PlayerInfo[playerid][pBoxing], //BoxingStyle
		PlayerInfo[playerid][pElbow], //ElbowStyle
		style, //Style
		PlayerInfo[playerid][pSpawned], //Spawned
		NeSdal[playerid], //NeSdal
		PlayerInfo[playerid][pDCTime], //DropCarTime
		PlayerDrunkLevel[playerid], //Drunk
		PlayerInfo[playerid][pSpining], //Spining
		PlayerInfo[playerid][pWorms], //Worms
		PlayerInfo[playerid][pLotto], //Lotto
		PlayerInfo[playerid][pMask], //Mask
		PlayerInfo[playerid][pRoliki], //Roliki
		PlayerInfo[playerid][pFuel], //Fuel
		PlayerInfo[playerid][pPhoneBook], //PhoneBook
		PlayerInfo[playerid][pPistol_Skill], //Pistol_Skill
		PlayerInfo[playerid][pSDPistol_Skill], //SDPistol_Skill
		PlayerInfo[playerid][pEagle_Skill], //Eagle_Skill
		PlayerInfo[playerid][pShotGun_Skill], //ShotGun_Skill
		PlayerInfo[playerid][pUZI_Skill], //UZI_Skill
		PlayerInfo[playerid][pMP5_Skill], //MP5_Skill
		PlayerInfo[playerid][pAK47_Skill], //AK47_Skill
		PlayerInfo[playerid][pM4_Skill], //M4_Skill
		PlayerInfo[playerid][pSniper_Skill], //Sniper_Skill
		PlayerInfo[playerid][pGlasses], //Glasses
		PlayerInfo[playerid][pBandans], //Bandans
		PlayerInfo[playerid][pHats], //Hats
		IncReset[playerid], //IncReset
		PlayerInfo[playerid][pSyringe], //Syringe
		PlayerInfo[playerid][pPoison], //Poison
		PlayerInfo[playerid][pSigs], //Smokes
		PlayerInfo[playerid][pLighter], //Lighter
		PlayerInfo[playerid][pFrom], //From
		PlayerInfo[playerid][pBL], //BlackList
		PlayerInfo[playerid][pOOC], //OOC
		PlayerInfo[playerid][pZKP], //ZKP
		CarPoundTime[playerid], //CarPoundTime
		PlayerInfo[playerid][pHeal], //Heal
		Fullness[playerid], //Fullness
		PlayerInfo[playerid][pPack], //Pack
		PlayerInfo[playerid][pSprunks], //Sprunks
		PlayerInfo[playerid][pCheepses], //Cheeps
		PlayerInfo[playerid][pRadio], //Radio
		TruckReset[playerid], //TruckReset
		PlayerInfo[playerid][pSnow], //Snow
		PlayerInfo[playerid][pVirMoney], //VirMoney
		PlayerInfo[playerid][pOldRepl], //OldRepl
		PlayerInfo[playerid][pAllRepl], //AllRepl
		PlayerInfo[playerid][pKey], //Key
		PlayerInfo[playerid][pKeyCheck], //KeyCheck
		PlayerInfo[playerid][pStatsStyle], //StatsStyle
		PlayerInfo[playerid][pCredit], //Credit
		PlayerInfo[playerid][pEnterKey], //EnterKey
		NewVirMoney, //NewVirMoney
		PlayerInfo[playerid][pView],  //View
		PlayerInfo[playerid][pFeFinder], //FeFinder
		PlayerInfo[playerid][pGold], //Gold
		PlayerInfo[playerid][pRepBan],
		PlayerInfo[playerid][pAskBan],
		PlayerInfo[playerid][pClip],
		PlayerInfo[playerid][pContractTime],
		ResetGunsUP[playerid],
		ResetBuyGuns[playerid],
		PlayerInfo[playerid][pRPTest],
		PlayerInfo[playerid][pEnergy],
		PlayerInfo[playerid][pRepPack]);
		
		GetPlayerIp(playerid,PlayerIp[playerid],16);
		format(result,sizeof(result),"UPDATE `Accounts` SET `OldIP` = '%s' WHERE `ID` = '%i'",PlayerIp[playerid],PlayerInfo[playerid][pID]);
		mysql_query(result);
		LoadPlayerSkills(playerid);
	}
}


---------- Post added at 23:41 ---------- Previous post was at 23:38 ----------

Проверка скиллов (вывод)

Код:
stock ShowJobSkills(playerid, giveplayerid, dialogid = INVALID_DIALOG_ID)
{
	new str[500],string[50];
    format(string,sizeof(string),"{FFFFFF}Водитель мусоровоза: \t\t\t{10F441}%d/100%%\n",PlayerInfo[giveplayerid][pMusorSkill]/100);
	strcat(str,string);
	format(string,sizeof(string),"{FFFFFF}Таксист: \t\t{10F441}%d/100%%\n",PlayerInfo[giveplayerid][pTaxiSkill]/100);
	strcat(str,string);
	format(string,sizeof(string),"{FFFFFF}Шахтёр: \t{10F441}%d/100%%\n",PlayerInfo[giveplayerid][pMinerSkill]/100);
	strcat(str,string);
	format(string,sizeof(string),"{FFFFFF}Экскурсовод: \t\t{10F441}%d/100%%\n",PlayerInfo[giveplayerid][pGuideSkill]/100);
	strcat(str,string);
	format(string,sizeof(string),"{FFFFFF}Инкассатор: \t\t\t{10F441}%d/100%%\n",PlayerInfo[giveplayerid][pCollectorSkill]/100);
	strcat(str,string);
	format(string,sizeof(string),"{FFFFFF}Дальнобойщик: \t\t\t{10F441}%d/100%%\n",PlayerInfo[giveplayerid][pTruckSkill]/100);
	strcat(str,string);
	format(string,sizeof(string),"{FFFFFF}Механик: \t\t\t{10F441}%d/100%%\n",PlayerInfo[giveplayerid][pMechanicSkill]/100);
	strcat(str,string);
	format(string,sizeof(string),"{FFFFFF}Тренер: \t\t\t{10F441}%d/100%%\n",PlayerInfo[giveplayerid][pCoachSkill]/100);
	strcat(str,string);
	format(string,sizeof(string),"{FFFFFF}Вор: \t\t\t{10F441}%d/100%%\n",PlayerInfo[giveplayerid][pScraperSkill]/100);
	strcat(str,string);
	format(string,sizeof(string),"{FFFFFF}Автоугонщик: \t\t\t{10F441}%d/100%%\n",PlayerInfo[giveplayerid][pCarJSkill]/100);
	strcat(str,string);
	if(!ShowPlayerDialogEx(playerid,dialogid,0,"Статистика",str,"Ок",""))
	{
	    SendClientMessage(playerid, COLOR_GREY, "Недоступно в данный момент.");
	    return false;
	}
	return true;
}
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу