pawn Код:
mysql_tquery(dbHandle, "SELECT * FROM `dealerships`", "loadDEALERSHIPS");
forward loadDEALERSHIPS();
public loadDEALERSHIPS()
{
if(cache_num_rows() > 0)
{
new i;
while( i < cache_num_rows())
{
DS[id][DsSQLID] = cache_get_field_content_int(i, "id", dbHandle);
//... your code ....
i++
}
if(i > 0) g_TotalDealerShip = i
}
}
forward deleteDEALERSHIP(playerid, id);
public deleteDEALERSHIP(playerid, id) {
if(cache_affected_rows() > 0)
{
new str[128];
format(str, sizeof str, "Successfully deleted dealership id %d (SQLID: %d)", id, DS[id][DsSQLID]);
SendClientMessage(playerid, -1, str);
}
else
{
SendClientMessage(playerid, -1, "Nothing was deleted, invalid id");
}
}
CMD:deldealership(playerid, params[])
{
new id;
if(sscanf(params, "i", id)) return SendClientMessage(playerid, -1, "/deldealership id");
if(id > MAX_DEALERSHIP) return SendClientMessage(playerid, -1, "invalid id");
mysql_format(dbHandle, query, sizeof(query), "DELETE FROM `dealerships` WHERE `DsID` = %d", DS[id][DsSQLID]);
mysql_tquery(dbHandle, query, "deleteDEALERSHIP", "ii", playerid, id);
}