Szerző Téma: MySQL Hiba(csak egy sor)[Sürgõs]  (Megtekintve 812 alkalommal)

MySQL Hiba(csak egy sor)[Sürgõs]
« Dátum: 2011. február 14. - 17:04:26 »
0 Show voters
Sziasztok, most állítottam át a szerverem mysqljét Adrenalyn-jkérõl StrickenKid Pluginjára, de az OnPlayerLogin(playerid, password) alatt elakadtam!
Pls Segítsetek!

HibaÜzenet:

 
F:\\Programozás\\SAMP\\WRP[0.3c]\\gamemodes\\SQL\\WRP.pwn(16695) : error 035: argument type mismatch (argument 3)

 
MySQL es rész:
 
MySQLFetchAcctSingle(PlayerInfo[playerid][pID], \"Password\", PlayerInfo[playerid][pKey]);
if (IsPlayerConnected(playerid))
{
if(strcmp(PlayerInfo[playerid][pKey],password, true ) == 0 )
{
        new Data[1024];
   new Field[64];
   new rcnt = 1;
   MySQLFetchAcctRecord(PlayerInfo[playerid][pID], Data);
   //mysql_fetch_row(Data, \"|\", Field);
   while (mysql_fetch_row(Data, \"|\", \"\"))
   {
      if (rcnt == 3) PlayerInfo[playerid][pLevel] = strval(Field);
      if (rcnt == 4) PlayerInfo[playerid][pAdmin] = strval(Field);
      if (rcnt == 5) PlayerInfo[playerid][pReg] = strval(Field);
      if (rcnt == 6) PlayerInfo[playerid][pConnectTime] = strval(Field);
      if (rcnt == 7) PlayerInfo[playerid][pNem] = strval(Field);
      if (rcnt == 8) PlayerInfo[playerid][pKor] = strval(Field);
      if (rcnt == 9) PlayerInfo[playerid][pVanGPS] = strval(Field);
      if (rcnt == 10) PlayerInfo[playerid][pOrigin] = strval(Field);
      if (rcnt == 11) PlayerInfo[playerid][pCK] = strval(Field);
      if (rcnt == 12) PlayerInfo[playerid][pMuted] = strval(Field);
      if (rcnt == 13) PlayerInfo[playerid][pBlind] = strval(Field);
      if (rcnt == 14) PlayerInfo[playerid][pExp] = strval(Field);
      if (rcnt == 15) PlayerInfo[playerid][pCash] = strval(Field);
      if (rcnt == 16) PlayerInfo[playerid][pAccount] = strval(Field);
      if (rcnt == 17) PlayerInfo[playerid][pSzamla] = strval(Field);
      if (rcnt == 18) PlayerInfo[playerid][pCrimes] = strval(Field);
      if (rcnt == 19) PlayerInfo[playerid][pKills] = strval(Field);
      if (rcnt == 20) PlayerInfo[playerid][pDeaths] = strval(Field);
      if (rcnt == 21) PlayerInfo[playerid][pArrested] = strval(Field);
      if (rcnt == 22) PlayerInfo[playerid][pWantedDeaths] = strval(Field);
      if (rcnt == 23) PlayerInfo[playerid][pPhoneBook] = strval(Field);
      if (rcnt == 24) PlayerInfo[playerid][pLottoNr] = strval(Field);
      if (rcnt == 25) PlayerInfo[playerid][pFishes] = strval(Field);
      if (rcnt == 26) PlayerInfo[playerid][pBiggestFish] = strval(Field);
      if (rcnt == 27) PlayerInfo[playerid][pJob] = strval(Field);
      if (rcnt == 28) PlayerInfo[playerid][pPayCheck] = strval(Field);
      if (rcnt == 29) PlayerInfo[playerid][pHeadValue] = strval(Field);
      if (rcnt == 30) PlayerInfo[playerid][pJailed] = strval(Field);
      if (rcnt == 31) PlayerInfo[playerid][pJailTime] = strval(Field);
      if (rcnt == 32) PlayerInfo[playerid][pRobTime] = strval(Field);
      if (rcnt == 33) PlayerInfo[playerid][pMats] = strval(Field);
      if (rcnt == 34) PlayerInfo[playerid][pMuanyag] = strval(Field);
      if (rcnt == 35) PlayerInfo[playerid][pDrugs] = strval(Field);
      if (rcnt == 36) PlayerInfo[playerid][pLeader] = strval(Field);
      if (rcnt == 37) PlayerInfo[playerid][pMember] = strval(Field);
      if (rcnt == 38) PlayerInfo[playerid][pFMember] = strval(Field);
      if (rcnt == 39) PlayerInfo[playerid][pRank] = strval(Field);
      if (rcnt == 40) PlayerInfo[playerid][pMunkaSkin] = strval(Field);
      if (rcnt == 41) PlayerInfo[playerid][pContractTime] = strval(Field);
      if (rcnt == 42) PlayerInfo[playerid][pDetSkill] = strval(Field);
      if (rcnt == 43) PlayerInfo[playerid][pSexSkill] = strval(Field);
      if (rcnt == 44) PlayerInfo[playerid][pBoxSkill] = strval(Field);
      if (rcnt == 45) PlayerInfo[playerid][pLawSkill] = strval(Field);
      if (rcnt == 46) PlayerInfo[playerid][pMechSkill] = strval(Field);
      if (rcnt == 47) PlayerInfo[playerid][pJackSkill] = strval(Field);
      if (rcnt == 48) PlayerInfo[playerid][pCarSkill] = strval(Field);
      if (rcnt == 49) PlayerInfo[playerid][pNewsSkill] = strval(Field);
      if (rcnt == 50) PlayerInfo[playerid][pDrugsSkill] = strval(Field);
      if (rcnt == 51) PlayerInfo[playerid][pCookSkill] = strval(Field);
      if (rcnt == 52) PlayerInfo[playerid][pFishSkill] = strval(Field);
      if (rcnt == 53) PlayerInfo[playerid][pSHealth] = floatstr(Field);
      if (rcnt == 54) PlayerInfo[playerid][pElet] = floatstr(Field);
      if (rcnt == 55) PlayerInfo[playerid][pPajzs] = floatstr(Field);
      if (rcnt == 56) PlayerInfo[playerid][pInt] = strval(Field);
      if (rcnt == 57) PlayerInfo[playerid][pInteriorNr] = strval(Field);
      if (rcnt == 58) PlayerInfo[playerid][pLocal] = strval(Field);
      if (rcnt == 59) PlayerInfo[playerid][pSimaSkin] = strval(Field);
      if (rcnt == 60) PlayerInfo[playerid][pPnumber] = strval(Field);
      if (rcnt == 61) PlayerInfo[playerid][pPcarkey] = strval(Field);
      if (rcnt == 62) PlayerInfo[playerid][pPcarkey2] = strval(Field);
      if (rcnt == 63) PlayerInfo[playerid][pPhousekey] = strval(Field);
      if (rcnt == 64) PlayerInfo[playerid][pPos_x] = floatstr(Field);
      if (rcnt == 65) PlayerInfo[playerid][pPos_y] = floatstr(Field);
      if (rcnt == 66) PlayerInfo[playerid][pPos_z] = floatstr(Field);
      if (rcnt == 67) PlayerInfo[playerid][pUtlevel] = strval(Field);
      if (rcnt == 68) PlayerInfo[playerid][pAutoJogsi] = strval(Field);
      if (rcnt == 69) PlayerInfo[playerid][pFlyLic] = strval(Field);
      if (rcnt == 70) PlayerInfo[playerid][pBoatLic] = strval(Field);
      if (rcnt == 71) PlayerInfo[playerid][pFishLic] = strval(Field);
      if (rcnt == 72) PlayerInfo[playerid][pGunLic] = strval(Field);
      if (rcnt == 73) PlayerInfo[playerid][pCopLic] = strval(Field);
      if (rcnt == 74) PlayerInfo[playerid][pCarTime] = strval(Field);
      if (rcnt == 75) PlayerInfo[playerid][pPayDay] = strval(Field);
      if (rcnt == 76) PlayerInfo[playerid][pSzabalyzat] = strval(Field);
      if (rcnt == 77) PlayerInfo[playerid][pOra] = strval(Field);
      if (rcnt == 78) PlayerInfo[playerid][pWins] = strval(Field);
      if (rcnt == 79) PlayerInfo[playerid][pLoses] = strval(Field);
      if (rcnt == 80) PlayerInfo[playerid][pAlcoholPerk] = strval(Field);
      if (rcnt == 81) PlayerInfo[playerid][pDrugPerk] = strval(Field);
      if (rcnt == 82) PlayerInfo[playerid][pMiserPerk] = strval(Field);
      if (rcnt == 83) PlayerInfo[playerid][pPainPerk] = strval(Field);
      if (rcnt == 84) PlayerInfo[playerid][pTraderPerk] = strval(Field);
      if (rcnt == 85) PlayerInfo[playerid][pTut] = strval(Field);
      if (rcnt == 86) PlayerInfo[playerid][pWarns] = strval(Field);
      if (rcnt == 87) PlayerInfo[playerid][pVirWorld] = strval(Field);
      if (rcnt == 88) PlayerInfo[playerid][pFuel] = strval(Field);
      if (rcnt == 89) PlayerInfo[playerid][pMarried] = strval(Field);
      if (rcnt == 90) PlayerInfo[playerid][pMarriedTo] = strmid(PlayerInfo[playerid][pMarriedTo], Field, 0, strlen(Field)-1, 255);
      if (rcnt == 91) PlayerInfo[playerid][pFishTool] = strval(Field);
      if (rcnt == 92) PlayerInfo[playerid][pGyujto] = strval(Field);
      if (rcnt == 93) PlayerInfo[playerid][pCigi] = strval(Field);
      if (rcnt == 94) PlayerInfo[playerid][pNikotin] = strval(Field);
      if (rcnt == 95) PlayerInfo[playerid][pWarned] = strval(Field);
      if (rcnt == 96) PlayerInfo[playerid][pSwat] = strval(Field);
      if (rcnt == 97) PlayerInfo[playerid][pTactical] = strval(Field);
      if (rcnt == 98) PlayerInfo[playerid][pSpecialF] = strval(Field);
      if (rcnt == 99) PlayerInfo[playerid][pDBanned] = strval(Field);
      if (rcnt == 100) PlayerInfo[playerid][pFS] = strval(Field);
      if (rcnt == 101) PlayerInfo[playerid][pBoxiSkill] = strval(Field);
      if (rcnt == 102) PlayerInfo[playerid][pKneeSkill] = strval(Field);
      if (rcnt == 103) PlayerInfo[playerid][pKungSkill] = strval(Field);
      if (rcnt == 104) PlayerInfo[playerid][pGrabSkill] = strval(Field);
      if (rcnt == 105) PlayerInfo[playerid][pElbowSkill] = strval(Field);
      if (rcnt == 106) PlayerInfo[playerid][pCD] = strval(Field);
      if (rcnt == 107) PlayerInfo[playerid][pSpeedo] = strval(Field);
      if (rcnt == 108) PlayerInfo[playerid][pAppearList] = strval(Field);
      if (rcnt == 109) PlayerInfo[playerid][pShiftName] = strval(Field);
      if (rcnt == 110) PlayerInfo[playerid][pGun] = strval(Field);
      if (rcnt == 111) PlayerInfo[playerid][pAmmo] = strval(Field);
      if (rcnt == 112) PlayerInfo[playerid][pGun2] = strval(Field);
      if (rcnt == 113) PlayerInfo[playerid][pAmmo2] = strval(Field);
      if (rcnt == 114) PlayerInfo[playerid][pGun3] = strval(Field);
      if (rcnt == 115) PlayerInfo[playerid][pAmmo3] = strval(Field);
      if (rcnt == 116) PlayerInfo[playerid][pGun4] = strval(Field);
      if (rcnt == 117) PlayerInfo[playerid][pAmmo4] = strval(Field);
      if (rcnt == 118) PlayerInfo[playerid][pGun5] = strval(Field);
      if (rcnt == 119) PlayerInfo[playerid][pAmmo5] = strval(Field);
      if (rcnt == 120) PlayerInfo[playerid][pGun6] = strval(Field);
      if (rcnt == 121) PlayerInfo[playerid][pAmmo6] = strval(Field);
      if (rcnt == 122) PlayerInfo[playerid][pGun7] = strval(Field);
      if (rcnt == 123) PlayerInfo[playerid][pAmmo7] = strval(Field);
      if (rcnt == 124) PlayerInfo[playerid][pGun8] = strval(Field);
      if (rcnt == 125) PlayerInfo[playerid][pAmmo8] = strval(Field);
      if (rcnt == 126) PlayerInfo[playerid][pGun9] = strval(Field);
      if (rcnt == 127) PlayerInfo[playerid][pAmmo9] = strval(Field);
      if (rcnt == 128) PlayerInfo[playerid][pGun10] = strval(Field);
      if (rcnt == 129) PlayerInfo[playerid][pAmmo10] = strval(Field);
      if (rcnt == 130) PlayerInfo[playerid][pGun11] = strval(Field);
      if (rcnt == 131) PlayerInfo[playerid][pAmmo11] = strval(Field);
      if (rcnt == 132) PlayerInfo[playerid][pGun12] = strval(Field);
      if (rcnt == 133) PlayerInfo[playerid][pAmmo12] = strval(Field);
      if (rcnt == 134) PlayerInfo[playerid][pBan] = strval(Field);
      if (rcnt == 135) PlayerInfo[playerid][pChatMode] = strval(Field);
      if (rcnt == 136) PlayerInfo[playerid][pKotszer] = strval(Field);
      if (rcnt == 137) PlayerInfo[playerid][pKaja] = strval(Field);
      if (rcnt == 138) PlayerInfo[playerid][pDrogido] = strval(Field);
      if (rcnt == 139) PlayerInfo[playerid][pPia] = strval(Field);
      if (rcnt == 140) PlayerInfo[playerid][pKredit] = strval(Field);
      if (rcnt == 141) PlayerInfo[playerid][pCserje] = strval(Field);
      if (rcnt == 142) PlayerInfo[playerid][pMak] = strval(Field);
      if (rcnt == 143) PlayerInfo[playerid][pCannabis] = strval(Field);
      if (rcnt == 144) PlayerInfo[playerid][pKokain] = strval(Field);
      if (rcnt == 145) PlayerInfo[playerid][pHeroin] = strval(Field);
      if (rcnt == 146) PlayerInfo[playerid][pMarihuana] = strval(Field);
      if (rcnt == 147) PlayerInfo[playerid][pC4] = strval(Field);
      if (rcnt == 148) PlayerInfo[playerid][pTerkep] = strval(Field);
      if (rcnt == 149) PlayerInfo[playerid][pBeteg] = strval(Field);
      if (rcnt == 150) PlayerInfo[playerid][pBusz] = strval(Field);
      if (rcnt == 151) PlayerInfo[playerid][pAdo] = strval(Field);
      if (rcnt == 152) PlayerInfo[playerid][pAdoBeadva] = strval(Field);
      if (rcnt == 153) PlayerInfo[playerid][pAdoBefizetve] = strval(Field);
      if (rcnt == 154) PlayerInfo[playerid][pAlvas] = strval(Field);
      if (rcnt == 155) PlayerInfo[playerid][pHouseEntered] = strval(Field);
      if (rcnt == 156) PlayerInfo[playerid][pUserChecked] = strval(Field);
                rcnt++;
   }
            mysql_free_result();
}
else
{
        //fclose(UserFile);
        gPlayerLogTries[playerid] += 1;
            ShowPlayerDialog(playerid, 1245, DIALOG_STYLE_INPUT,\"Hibás jelszó\",\"Rossz jelszód adtál meg!\\nJelszavad:\",\"Log-in\",\"Quit\");
        if(gPlayerLogTries[playerid] == 3) { WKick(playerid,\"Folyamatos Hibás bejelentkezés!\"); }
        return 1;
}

Nem elérhető DrAkE

  • 2078
    • Profil megtekintése
MySQL Hiba(csak egy sor)[Sürgõs]
« Válasz #1 Dátum: 2011. február 14. - 19:33:41 »
0 Show voters
esetleg ha leírnád melyik az 16695. sor sokat segítenél.

MySQL Hiba(csak egy sor)[Sürgõs]
« Válasz #2 Dátum: 2011. február 14. - 20:40:58 »
0 Show voters
16694 és 16695m sor is hibás, csak az 16694-et commenteltem.:
 
//mysql_fetch_row(Data, \"|\", Field);
   while (mysql_fetch_row(Data, \"|\", \"\"))

 

SimplePortal 2.3.7 © 2008-2024, SimplePortal