MySQL question
#1

Is the format correct or not?

pawn Код:
stock LoadVehicleFromSlot(playerid, slot)
{
    new query[500];
    format(query, sizeof(query), "SELECT * FROM `ownedvehicles` WHERE `owner` = '%s' AND `slot` = %d", GetName(playerid), slot);
    mysql_function_query(dbHandle, query, true, "OnPlayerSpawnVehicle", "ii", playerid, slot);
    return 1;
}
Reply
#2

Yes, it's fine.
Reply
#3

Huge "query". Make it 128.
Reply
#4

128 or just to be save 200 or 256 is enough. Your ruining about 300 cells with that query!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)