forward updateDS(id);
public updateDS(id) {
mysql_tquery(dbHandle, "SELECT * FROM `dealerships`", "loadDEALERSHIPS");
return 1;
}
forward destroyDEALERSHIP(playerid, id);
public destroyDEALERSHIP(playerid, id) {
if(id > cache_get_row_count(dbHandle)) {
return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] Invalid DEALERSHIP ID.");
}
else if(id < cache_get_row_count(dbHandle)) {
new query[128];
mysql_format(dbHandle, query, sizeof(query), "DELETE FROM `dealerships` WHERE `DsID` = %d", id);
mysql_tquery(dbHandle, query);
DestroyPickup(DS[id][DsIcon]);
printf("Successfully deleted dealership id %d -- QUERY:\n%s", id, query);
format(ZString, sizeof(ZString), "[ ! ] Successfully DELETED DealerShip ID:%d.", id);
SendClientMessage(playerid, COLOR_SUCCESS, ZString);
SetTimerEx("updateDS", 1250, false, "d", id);
return 1;
}
return 1;
}
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);
}
Example
pawn Код:
|
YCMD:destroydealerships(playerid, params[], help) {
new id;
if(!IsPlayerAdmin(playerid)) return 0;
else {
if(sscanf(params, "d", id)) return SendClientMessage(playerid, COLOR_NOTE, "[ ! ] SYNTAX: /DestroyDealership [DS-ID]");
new query[128];
mysql_format(dbHandle, query, sizeof(query), "DELETE FROM `dealerships` WHERE `DsID` = %d", id);
mysql_tquery(dbHandle, query, "destroyDEALERSHIP", "dd", playerid, id);
}
return 1;
}
forward destroyDEALERSHIP(playerid, id);
public destroyDEALERSHIP(playerid, id) {
if(cache_affected_rows(dbHandle) > 0) {
DestroyPickup(DS[id][DsIcon]);
printf("Successfully deleted dealership id %d --", id);
format(ZString, sizeof(ZString), "[ ! ] Successfully DELETED DealerShip ID:%d. (SQL-ROW-ID:%d)", id, DS[id][DsID]); //Thanks to 'rickisme' for helping me with this one.
SendClientMessage(playerid, COLOR_SUCCESS, ZString);
mysql_tquery(dbHandle, "SELECT * FROM `dealerships`", "loadDEALERSHIPS");
} else return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] Invalid DEALERSHIP ID.");
return 1;
}
mysql_tquery(dbHandle, "SELECT * FROM `dealerships`", "loadDEALERSHIPS");
forward loadDEALERSHIPS();
public loadDEALERSHIPS()
{
if(cache_num_rows() > 0)
{
new i;
while( i < cache_num_rows())
{
DS[i][DsSQLID] = cache_get_field_content_int(i, "DsID", dbHandle);
printf("DealerShip ID: %d (SQLID: %d) loaded", i, DS[i][DsSQLID]);
i++
}
}
}
DealerShip ID: 0 (SQLID: 2) loaded
mysql_format(dbHandle, query, sizeof(query), "DELETE FROM `dealerships` WHERE `DsID` = %d", id);
DELETE FROM `dealerships` WHERE `DsID` = 0
[ ! ] Invalid DEALERSHIP ID.
mysql_format(dbHandle, query, sizeof(query), "DELETE FROM `dealerships` WHERE `DsID` = %d", DS[id][DsID]);
DELETE FROM `dealerships` WHERE `DsID` = 2
[ ! ] Successfully DELETED DealerShip ID: 0. (SQL-ROW-ID: 2)
mysql_format(dbHandle, query, sizeof(query), "DELETE FROM `dealerships` WHERE `DsID` = %d", id);
mysql_format(dbHandle, query, sizeof(query), "DELETE FROM `dealerships` WHERE `DsID` = %d", DS[id][DsID]);
forward destroyDEALERSHIP(playerid, id);
public destroyDEALERSHIP(playerid, id) {
if(cache_affected_rows(dbHandle) > 0) {
DestroyPickup(DS[id][DsIcon]); //This part, it doesn't delete the pickup.
printf("Successfully deleted dealership id %d --", DS[id][DsID]);
format(ZString, sizeof(ZString), "[ ! ] Successfully DELETED DealerShip ID:%d. (SQL-ROW-ID:%d)", id, DS[id][DsID]); //Thanks to 'rickisme' for helping me with this one.
SendClientMessage(playerid, COLOR_SUCCESS, ZString);
mysql_tquery(dbHandle, "SELECT * FROM `dealerships`", "loadDEALERSHIPS");
} else return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] Invalid DEALERSHIP ID.");
return 1;
}
forward loadDEALERSHIPS(); //Here's where I fetch all the ds info
public loadDEALERSHIPS() {
for(new i = 0 ; i < cache_num_rows(dbHandle) ; i++) { // Dealership information - Fetched.
DS[i][DsID] = cache_get_field_content_int(i, "DsID", dbHandle);
DS[i][DsLocX] = cache_get_field_content_float(i, "DsLocX", dbHandle);
DS[i][DsLocY] = cache_get_field_content_float(i, "DsLocY", dbHandle);
DS[i][DsLocZ] = cache_get_field_content_float(i, "DsLocZ", dbHandle);
DS[i][DsIcon] = cache_get_field_content_int(i, "DsIcon", dbHandle);
DS[i][DsIcon] = CreatePickup(1239, 23, DS[i][DsLocX], DS[i][DsLocY], DS[i][DsLocZ], -1); //And here is where I set the icon
}
printf("[ OXIGEN's VEHICLES ] [ ! ] Loaded %d DEALERSHIPS", cache_num_rows(dbHandle));
return 1;
}