[HUYA]

DELETE

[L.Hudson]

I don't really know much of MySQL but as I can understand you're missing an argument [= words seperated with comma (,) ] or put more than needed

[HUYA]

is not "MySQL" is "C-MySQL" xD

[mamorunl]

http://forum.sa-mp.com/archive/index.php/t-358096.html

[HUYA]

Is not really work? x(

[HUYA]

DELETE

[HUYA]

please?

[burnuk]

try this:

Код:

public OnQueryFinish( query[], resultid, extraid, connectionHandle ) {
    new
        QueryID = 0,
        string[1500];

    if(resultid == 1) {
        mysql_store_result();
        while(mysql_fetch_row_format(string,"|"))
        {
                if(mysql_num_rows() <= 0) continue;
                sscanf(string, "p<|>iffffiisiiiiiiiiiiiiiii",
                CarInfo[QueryID][cModel], CarInfo[QueryID][cX],
                CarInfo[QueryID][cY], CarInfo[QueryID][cZ], CarInfo[QueryID][cAngle],
                CarInfo[QueryID][cColorOne], CarInfo[QueryID][cColorTwo],
                CarInfo[QueryID][cOwner], CarInfo[QueryID][cOwned],
                CarInfo[QueryID][cValue], CarInfo[QueryID][cLock],
                CarInfo[QueryID][cFuel], CarInfo[QueryID][cDonate],
                CarInfo[QueryID][cMod][0],CarInfo[QueryID][cMod][1],
                CarInfo[QueryID][cMod][2], CarInfo[QueryID][cMod][3],
                CarInfo[QueryID][cMod][4], CarInfo[QueryID][cMod][5],
                CarInfo[QueryID][cMod][6], CarInfo[QueryID][cMod][7],
                CarInfo[QueryID][cMod][8], CarInfo[QueryID][cMod][9]);
                QueryID ++;
            } //Ends While
            mysql_free_result();
        } //Ends Case
        if(resultid == MySQL_QUERY_LOGIN) {
        mysql_store_result();
        if(mysql_num_rows() >= 1) {
        mysql_fetch_row_format(string, "|");
        print(string);
        new ustring[5];
        sscanf(string, "p<|>s[5]s[5]iiiifffffiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii iiiiiiiiiiiiiiiiiiiis[5]s[5]s[128]iiiiiiiiiis[5]",
        ustring, ustring, PlayerInfo[extraid][pCash], PlayerInfo[extraid][pModel], PlayerInfo[extraid][pCrash],
        PlayerInfo[extraid][pAge], PlayerInfo[extraid][pPosX], PlayerInfo[extraid][pPosY],PlayerInfo[extraid][pPosZ],
        PlayerInfo[extraid][pHealth], PlayerInfo[extraid][pArmour], PlayerInfo[extraid][pInt], PlayerInfo[extraid][pWorld],
        PlayerInfo[extraid][pPayDay], PlayerInfo[extraid][pPayCheck], PlayerInfo[extraid][pBank], PlayerInfo[extraid][pConnectTime], PlayerInfo[extraid][pMember],
        PlayerInfo[extraid][pRank], PlayerInfo[extraid][pWeed], PlayerInfo[extraid][pCrack],PlayerInfo[extraid][pCocaine],
        PlayerInfo[extraid][pHouseKey], PlayerInfo[extraid][pBizzKey],PlayerInfo[extraid][pCarKey1], PlayerInfo[extraid][pCarKey2], PlayerInfo[extraid][pCarKey3], PlayerInfo[extraid][pAdmin], PlayerInfo[extraid][pHelper],
        PlayerInfo[extraid][pBanned], PlayerInfo[extraid][pDrugTime], PlayerInfo[extraid][pHouseEnter], PlayerInfo[extraid][pBizzEnter],
        PlayerInfo[extraid][pGunLic], PlayerInfo[extraid][pDriveLic], PlayerInfo[extraid][pPhoneNum], PlayerInfo[extraid][pJob], PlayerInfo[extraid][pJailed],
        PlayerInfo[extraid][pJailTime], PlayerInfo[extraid][pWeapon][0],
        PlayerInfo[extraid][pWeapon][1], PlayerInfo[extraid][pWeapon][2], PlayerInfo[extraid][pWeapon][3],
        PlayerInfo[extraid][pWeapon][4], PlayerInfo[extraid][pWeapon][5], PlayerInfo[extraid][pWeapon][6],
        PlayerInfo[extraid][pWeapon][7], PlayerInfo[extraid][pWeapon][8], PlayerInfo[extraid][pWeapon][9],
        PlayerInfo[extraid][pWeapon][10], PlayerInfo[extraid][pWeapon][11], PlayerInfo[extraid][pWeapon][12],
        PlayerInfo[extraid][pAmmo][0],PlayerInfo[extraid][pAmmo][1],PlayerInfo[extraid][pAmmo][2],
        PlayerInfo[extraid][pAmmo][3], PlayerInfo[extraid][pAmmo][4], PlayerInfo[extraid][pAmmo][5],
        PlayerInfo[extraid][pAmmo][6], PlayerInfo[extraid][pAmmo][7], PlayerInfo[extraid][pAmmo][8],
        PlayerInfo[extraid][pAmmo][9], PlayerInfo[extraid][pAmmo][10], PlayerInfo[extraid][pAmmo][11],
        PlayerInfo[extraid][pAmmo][12], PlayerInfo[extraid][pWantedLevel], PlayerInfo[extraid][pDonateRank],
        PlayerInfo[extraid][pMask], PlayerInfo[extraid][pMaskID], PlayerInfo[extraid][pCellphone],
        PlayerInfo[extraid][pCrimes], PlayerInfo[extraid][pArrest], PlayerInfo[extraid][pChanges], ustring,
        ustring, PlayerInfo[extraid][pAdmName], extraid, extraid, PlayerInfo[extraid][pSex], PlayerInfo[extraid][pTut],
        PlayerInfo[extraid][pCarTicket], extraid, extraid, extraid, extraid, extraid, ustring);
        } //Ends mysql_fetch_row_format
        new ppname[24], testline1, testline2, testline3, testline4;
        GetPlayerName(extraid, ppname, 24);
        testline = CMySQL_Set(ppname, "Accounts", "Username", "CarTicket");
        testline1 = CMySQL_Set(ppname, "Accounts", "Username", "Tutorial");
        testline2 = CMySQL_Set(ppname, "Accounts", "Username", "Sex");
        testline3 = CMySQL_Set(ppname, "Accounts", "Username", "Changes");
        testline4 = CMySQL_Get(ppname, "Accounts", "Username", "AdmName");
        PlayerInfo[extraid][pCarTicket] = testline;
        PlayerInfo[extraid][pTut] = testline1;
        PlayerInfo[extraid][pSex] = testline2;
        PlayerInfo[extraid][pChanges] = testline3;
        strmid(PlayerInfo[extraid][pAdmName], testline4, 0, strlen(CMySQL_Get(ppname, "Accounts", "Username", "AdmName")), 255);
        mysql_free_result();
        OnLoginInit(extraid);
        } //Finishes IF
        if(resultid != 1 && resultid != MySQL_QUERY_LOGIN)
        {
        if(PlayerInfo[extraid][pWrongPassword] >= 5)
        {
        SendClientMessage(extraid,COLOR_LIGHTRED,"SERVER: You have been banned for entering the wrong password in five times.");
        BanEx(extraid,"Wrong Password");
        }
        else
        {
        PlayerInfo[extraid][pWrongPassword]++;
        SendClientMessage(extraid,COLOR_LIGHTRED,"SERVER: Invalid password.");
        }
        }
        }
        return 1;
}