Mysql query function question
#1

Hello,

Well I was wondering if this is possible:

pawn Код:
mysql_function_query(connectionHandle, query, false, "SaveVehicleCallback", "dd", carid, playerid);
So I can use playerid in the function so I can for example send the playerid a message "Vehicle already exists"
(this is for saving a vehicle)

pawn Код:
command(savecar, playerid, params[])
{
    new carid = GetPlayerVehicleID(playerid);
    if(AdminLoggedIn[playerid] == 1 && Player[playerid][Adminlevel] >= 6)
    {
        if(IsPlayerInAnyVehicle(playerid))
        {
            new query[300];

            format(query, sizeof(query), "SELECT * FROM `Vehicles` WHERE `VehicleID` = %d", carid);
            mysql_function_query(connectionHandle, query, false, "SaveVehicleCallback", "dd", carid, playerid);
        }
    }
    else
    {
        TextDrawShowForPlayer(playerid, Text:CantCommand);
        SetTimerEx("RemoveCantCommand", 3500, false, "d", playerid);
    }
    return 1;
}
pawn Код:
public SaveVehicleCallback(vehicleid, playerid)
{
    new
        rows,
        fields;

    cache_get_data(rows, fields);
    if(rows == 1)
    {
        SendClientMessage(playerid, WARNRED, "This Vehicle already exists");
    }
    else if(rows == 0)
    {
        new query[300];

        format(query, sizeof(query), "INSERT INTO `Vehicles` (`ModelID`) VALUES(%d)", Vehicles[vehicleid][ModelID]);
        mysql_function_query(connectionHandle, query, false, "DefaultCallback", "");
    }
    else
    {
        SendClientMessage(playerid, COLOR_WHITE, "There was a "#COL_EMB_RED"fatal error "#COL_EMB_WHITE"during registration! Please contact a developer.");
    }
    return 1;
}
Reply


Messages In This Thread
Mysql query function question - by Stefand - 09.05.2013, 10:32
Re: Mysql query function question - by Pooh7 - 09.05.2013, 10:51
Re: Mysql query function question - by Stefand - 09.05.2013, 11:04
Re: Mysql query function question - by LiamM - 09.05.2013, 12:11
Re: Mysql query function question - by Stefand - 09.05.2013, 13:30
Re: Mysql query function question - by Scenario - 09.05.2013, 17:51

Forum Jump:


Users browsing this thread: 4 Guest(s)