10.03.2011, 11:18
(
Last edited by MahmutBey; 10/03/2011 at 02:39 PM.
Reason: updated
)
solved
new EscPass[38], Query[ 1500 ];
mysql_real_escape_string(password, EscPass);
format(Query ,600,"SELECT pSQLID,pKey,pLevel,pAdmin,pDonateRank,gPupgrade,pConnectTime,pReg,pSex,pAge,pOrigin,pCK,pMuted,pExp,pCash,pAccount,pCrimes,pKills,pDeaths,pArrested,pWantedDeaths,pPhoneBook,pLottoNr,pFishes,pBiggestFish,pJob,pPayCheck,pHeadValue,pJailed,pJailTime,pMats,pDrugs,pLeader,pMember,pFMember,pRank,pChar,pContractTime,pDetSkill,pSexSkill,pLawSkill,pMechSkill,pJackSkill,pCarSkill,pNewsSkill,pDrugsSkill,pFishSkill,pHealth,pSHealth,pInt,pLocal,pTeam,pModel,pPnumber,pPhousekey,pPcarkey,pPcarkey2,pPcarkey3,pGangKey,pPbiskey,pPos_x,pPos_y,pPos_z,pCarLic,pFlyLic,pBoatLic,pFishLic,pGunLic,pGun1,pGun2");
format(Query ,600, "%s,pGun3,pGun4,pAmmo1,pAmmo2,pAmmo3,pAmmo4,pCarTime,pPayDay,pPayDayHad,pWatch,pCrashed,pWins,pLoses,pAlcoholPerk,pDrugPerk,pMiserPerk,pPainPerk,pTraderPerk,pTut,pWarns,pVirWorld,pFuel,pMarried,pMarriedTo,pFishTool,pInvWeapon,pInvAmmo,pLighter,pCigarettes,pRequestingBackup,pRoadblock,pMask,pMaskuse,pHideNumber,pSpeaker,pLocked FROM `information` WHERE `pUsername` = '%s' AND `pKey` = md5('%s')",Query, PlayerName(playerid), EscPass );
format(Query,sizeof(Query),"SELECT pSQLID,pKey,pLevel,pAdmin,pDonateRank,gPupgrade,pConnectTime, \
pReg,pSex,pAge,pOrigin,pCK,pMuted,pExp,pCash\
,pAccount,pCrimes,pKills,pDeaths,pArrested,pWantedDeaths,pPhoneBook,pLottoNr,pFishes,pBiggestFish,pJob,pPayCheck,pHeadValue,pJailed,pJailTime,pMats,pDrugs,pLeader,pMember\
,pFMember,pRank,pChar,pContractTime,pDetSkill,pSexSkill,pLawSkill,pMechSkill,pJackSkill,pCarSkill,pNewsSkill,pDrugsSkill,pFishSkill,pHealth,pSHealth,pInt,pLocal,pTeam,pModel,pPnumber,pPhousekey,pPcarkey,pPcarkey2,pPcarkey3,pGangKey,pPbiskey,pPos_x,pPos_y,pPos_z,\
pCarLic,pFlyLic,pBoatLic,pFishLic,pGunLic,pGun1,pGun2,pGun3,pGun4,pAmmo1,pAmmo2,pAmmo3,pAmmo4,pCarTime,pPayDay,pPayDayHad,pWatch,pCrashed,pWins,pLoses,pAlcoholPerk,pDrugPerk,pMiserPerk,pPainPerk,pTraderPerk,pTut,pWarns,pVirWorld,pFuel,pMarried,\
pMarriedTo,pFishTool,pInvWeapon,pInvAmmo,pLighter,pCigarettes,pRequestingBackup,pRoadblock,pMask,pMaskuse,pHideNumber,pSpeaker,pLocked FROM `information` WHERE `pUsername` = '%s' AND `pKey` = md5('%s')", PlayerName(playerid), EscPass);