- Регистрация
- 23 Апр 2012
- Сообщения
- 198
- Лучшие ответы
- 0
- Репутация
- 22
Вот запрос:
pChar точно загружается, а вот остальное не хочет..
PHP:
new query[256],result[2048];
format(query, sizeof(query), "SELECT * FROM `users` WHERE `Key` = '%s' AND `Name` = '%s'", password, GN(playerid));
// SELECT * - выбрать, FROM - с таблицы, WHERE - где, пароль равен введенному паролю и ID равен иду ника человека.
mysql_query(query); // Отправляем запрос.
mysql_store_result(); // Смотрим записи, которые мы выбрали запросом выше.
if(mysql_num_rows() == 1)
{
mysql_fetch_row_format(result, "|"); // Расставляем между значиями знак "|". То есть результат будет выглядить примерно так: Nick_Name|password|8|1|5.0000
sscanf(result,"p<|>s[24]s[32]iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiffiiiiiiiiiiiiiiiiiiiiiiis[24]iiiis[24]s[24]",
GN(playerid),PlayerInfo[playerid][pKey],
PlayerInfo[playerid][pFWarns],
PlayerInfo[playerid][pFightStyle],
PlayerInfo[playerid][pTaxiv],
PlayerInfo[playerid][pGinex],
PlayerInfo[playerid][pRobHous],
PlayerInfo[playerid][pMatsrob],
PlayerInfo[playerid][pVisa],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pBonus],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pHelper],
PlayerInfo[playerid][pDonate],
PlayerInfo[playerid][pZaezd],
PlayerInfo[playerid][pConnectTime],
PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pAccount],
PlayerInfo[playerid][pNarcoZavisimost],
PlayerInfo[playerid][pNarcoLomka],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pKills],
PlayerInfo[playerid][pDeaths],
PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pWantedDeaths],
PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pFishes],
PlayerInfo[playerid][pBiggestFish],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pHeadValue],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pMehDost],
PlayerInfo[playerid][pMusorDost],
PlayerInfo[playerid][pSpermaDost],
PlayerInfo[playerid][pProdsDost],
PlayerInfo[playerid][pFishDost],
PlayerInfo[playerid][pSellcarDost],
PlayerInfo[playerid][pMedicDost],
PlayerInfo[playerid][pHealDost],
PlayerInfo[playerid][pGuneditDost],
PlayerInfo[playerid][pNalogDost],
PlayerInfo[playerid][pPaintDost],
PlayerInfo[playerid][pDuelkiDost],
PlayerInfo[playerid][pPaintKills],
PlayerInfo[playerid][pLevelDost],
PlayerInfo[playerid][pNarkoDost],
PlayerInfo[playerid][pZonaDost],
PlayerInfo[playerid][pGonkaDost],
PlayerInfo[playerid][pSuDost],
PlayerInfo[playerid][pAmmoDost],
PlayerInfo[playerid][pArestDost],
PlayerInfo[playerid][pDm],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pFMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pCharSlot2],
PlayerInfo[playerid][pCharSlot3],
PlayerInfo[playerid][pCharSlot4],
PlayerInfo[playerid][pCharSlot5],
PlayerInfo[playerid][pContractTime],
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][pFishSkill],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pGun3],
PlayerInfo[playerid][pGun4],
PlayerInfo[playerid][pAmmo1],
PlayerInfo[playerid][pAmmo2],
PlayerInfo[playerid][pAmmo3],
PlayerInfo[playerid][pAmmo4],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pCDPlayer],
PlayerInfo[playerid][pAlcoholPerk],
PlayerInfo[playerid][pDrugPerk],
PlayerInfo[playerid][pMiserPerk],
PlayerInfo[playerid][pPainPerk],
PlayerInfo[playerid][pTraderPerk],
PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pMuteTime],
PlayerInfo[playerid][pFMuteTime],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pCarKey],
PlayerInfo[playerid][pMask],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pVaip],
PlayerInfo[playerid][pDostup],
PlayerInfo[playerid][pEmail],
PlayerInfo[playerid][pEmailReg],
PlayerInfo[playerid][pChangeName],
PlayerInfo[playerid][pPid],
PlayerInfo[playerid][pYESprigl],
PlayerInfo[playerid][pPriglasil],
PlayerInfo[playerid][pMarriedTo]);
mysql_free_result(); //Отчищаем результат