[AphexCCFC]

I'm using the new cacheing function and this isn't working now:

pawn Код:

if(dialogid == DIALOG_GROTTI)
    {
        new query[128], pname[24], string[128], engine, lights, alarm, doors, bonnet, boot, objective;
        if(response)
        {
            if(PlayerInfo[playerid][pVehName] > 0 && PlayerInfo[playerid][pVeh2Name] > 0)
            {
                SendClientMessage(playerid, -1, ""Red"Error"White": You already own two vehicles.");
                return 1;
            }
            if(IsPlayerInVehicle(playerid, 1))
            {
                if(PlayerInfo[playerid][pCash] < Sabre)
                {
                    SendClientMessage(playerid, -1, ""Red"Error"White": You don't have enough cash to purchase this Sabre.");
                    return 1;
                }
                if(PlayerInfo[playerid][pVehID] == 0)
                {
                    DisablePlayerCheckpoint(playerid);
                    PlayerInfo[playerid][pVehID] = AddStaticVehicleEx(475, 440.2622, -1295.4160, 14.9873+1, 272.3125, 0, 0, 1200);
                    PlayerInfo[playerid][pVehX] = 440.2622;
                    PlayerInfo[playerid][pVehY] = -1295.4160;
                    PlayerInfo[playerid][pVehZ] = 14.9873;
                    PlayerInfo[playerid][pVehA] = 272.3125;
                    PlayerInfo[playerid][pCash] -= Sabre;
                    GivePlayerMoney(playerid, -Sabre);
                    GetPlayerName(playerid, pname, 24);
                    format(query, sizeof(query), "UPDATE `playerdata` SET `Cash`=%d, `VehID`=%d, `VehName`=475, `VehX`=%f, `VehY`=%f, `VehZ`=%f, `VehA`=%f WHERE `Username`='%s'",
                    PlayerInfo[playerid][pCash], PlayerInfo[playerid][pVehID], PlayerInfo[playerid][pVehX], PlayerInfo[playerid][pVehY], PlayerInfo[playerid][pVehZ], PlayerInfo[playerid][pVehA], pname);
                    mysql_function_query(dbHandle, query, false, "", "");
                    PlayerInfo[playerid][pVehName] = 475;
                    PlayerInfo[playerid][pVehSpawned] = 1;
                    format(string, sizeof(string), ""Green"Dealership Owner"White": You have purchased the Sabre for $%d. A checkpoint to your vehicle location has been marked.", Sabre);
                    SendClientMessage(playerid, -1, string);
                    SendClientMessage(playerid, -1, ""Green"Dealership Owner"White": A checkpoint to your vehicle location has been marked on your mini map.");
                    GetVehicleParamsEx(PlayerInfo[playerid][pVehID], engine, lights, alarm, doors, bonnet, boot, objective);
                    SetVehicleParamsEx(PlayerInfo[playerid][pVehID], 0, 0, 0, 0, 0, 0, 0);
                    SetPlayerCheckpoint(playerid, 440.2622, -1295.4160, 14.9873, 5);
                    return 1;
                }
                else
                {
                    DisablePlayerCheckpoint(playerid);
                    PlayerInfo[playerid][pVeh2ID] = AddStaticVehicleEx(475, 440.2622, -1295.4160, 14.9873, 272.3125, 0, 0, 1200);
                    PlayerInfo[playerid][pVeh2X] = 440.2622;
                    PlayerInfo[playerid][pVeh2Y] = -1295.4160;
                    PlayerInfo[playerid][pVeh2Z] = 14.9873;
                    PlayerInfo[playerid][pVeh2A] = 272.3125;
                    PlayerInfo[playerid][pCash] -= Sabre;
                    GivePlayerMoney(playerid, -Sabre);
                    GetPlayerName(playerid, pname, 24);
                    format(query, sizeof(query), "UPDATE `playerdata` SET `Cash`=%d, `Veh2ID`=%d, `Veh2Name`=475, `Veh2X`=%f, `Veh2Y`=%f, `Veh2Z`=%f, `Veh2A`=%f WHERE `Username`='%s'",
                    PlayerInfo[playerid][pCash], PlayerInfo[playerid][pVeh2ID], PlayerInfo[playerid][pVeh2X], PlayerInfo[playerid][pVeh2Y], PlayerInfo[playerid][pVeh2Z], PlayerInfo[playerid][pVeh2A], pname);
                    mysql_function_query(dbHandle, query, false, "", "");
                    PlayerInfo[playerid][pVeh2Name] = 475;
                    PlayerInfo[playerid][pVeh2Spawned] = 1;
                    format(string, sizeof(string), ""Green"Dealership Owner"White": You have purchased the Sabre for $%d.", Sabre);
                    SendClientMessage(playerid, -1, string);
                    SendClientMessage(playerid, -1, ""Green"Dealership Owner"White": A checkpoint to your vehicle location has been marked on your mini map.");
                    GetVehicleParamsEx(PlayerInfo[playerid][pVeh2ID], engine, lights, alarm, doors, bonnet, boot, objective);
                    SetVehicleParamsEx(PlayerInfo[playerid][pVeh2ID], 0, 0, 0, 0, 0, 0, 0);
                    SetPlayerCheckpoint(playerid, 440.2622, -1295.4160, 14.9873, 5);
                    return 1;
                }
            }

        }
        if(!response)
        {
        }
    }

All I did was change the mysql_query to mysql_function_query and add the correct syntax. Someone please help me resolve this. (I know the last bracket doesn't match the opening function but that's because I copied and pasted one of the dialog ID's in OnDialogResponse.

mysql_log error:

pawn Код:

[23:08:11] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`V' at line 1

Lol, been through this about 100 times, can someone just confirm to me that MySQL is just chatting crap? There's nothing even wrong with this, all syntax's are correct. :/

[DanishHaq]

The array for "query" is too small, same happened to me. Change it to

pawn Код:

new query[300];

[AphexCCFC]

Lmao, legend. I cannot believe I didn't recognise that, *smacks head*. I've ran outta repping today so I'll +rep you in 24 hours, cheers.

[AphexCCFC]

One more issue then my cacheing has been successfully converted.
Why doesn't this save my players position when they exit and rejoin?:

pawn Код:

stock SaveAccount(playerid)
{
    new query[2000], Float:x, Float:y, Float:z, Float:a, pname[24];

    GetPlayerName(playerid, pname, 24);
    GetPlayerPos(playerid, x, y, z);
    GetPlayerFacingAngle(playerid, a);
    PlayerInfo[playerid][pPos][0] = x;
    PlayerInfo[playerid][pPos][1] = y;
    PlayerInfo[playerid][pPos][2] = z;
    PlayerInfo[playerid][pPos][3] = a;
    PlayerInfo[playerid][pAdminDuty] = 0;

    format(query, sizeof(query), "UPDATE `playerdata` SET `Gender`=%d, `Cash`=%d, `Bank`=%d, `BankReg`=%d, `Level`=%d, `Skin`=%d, `Admin`=%d, `AdminDuty`=%d, `Owner`=%d, `Job`=%d, `Interior`=%d, `VirtualWorld`=%d, `NewbMute`=%d, `GetHouseID`=%d,");
    format(query, sizeof(query), "`VehID`=%d, `VehName`=%d, `VehX`=%f, `VehY`=%f, `VehZ`=%f, `VehA`=%f, `Veh2ID`=%d, `Veh2Name`=%d, `Veh2X`=%f, `Veh2Y`=%f, `Veh2Z`=%f, `Veh2A`=%f, `PosX`=%f, `PosY`=%f, `PosZ`=%f, `PosA`=%f WHERE `Username`=%s",
    PlayerInfo[playerid][pGender], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pBankReg], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pAdminDuty], PlayerInfo[playerid][pOwner],
    PlayerInfo[playerid][pJob], PlayerInfo[playerid][pInterior], PlayerInfo[playerid][pVirtualWorld], PlayerInfo[playerid][pNewbMute], PlayerInfo[playerid][pGetHouseID], PlayerInfo[playerid][pVehID], PlayerInfo[playerid][pVehName], PlayerInfo[playerid][pVehX],
    PlayerInfo[playerid][pVehY], PlayerInfo[playerid][pVehZ], PlayerInfo[playerid][pVehA], PlayerInfo[playerid][pVeh2ID], PlayerInfo[playerid][pVeh2Name], PlayerInfo[playerid][pVeh2X], PlayerInfo[playerid][pVeh2Y], PlayerInfo[playerid][pVeh2Z], PlayerInfo[playerid][pVeh2A],
    PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2], PlayerInfo[playerid][pPos][3], pname);
    mysql_function_query(dbHandle, query, false, "", "");
    return 1;
}