[Grzechuso]

Hi I'm using mysql plugin from Bluegem and do not know how to change (want to update to the latest version of the script) these functions I know that the table needs to be removed but do not know how. Please help.

Код:

SQL_Connect() {
	g_iHandle = mysql_connect(SQL_HOSTNAME, SQL_USERNAME, SQL_DATABASE, SQL_PASSWORD);

	if (mysql_ping(g_iHandle) < 1) {
	    printf("[SQL] Connection to \"%s\" failed! Please check the connection settings...\a", SQL_HOSTNAME);
	}
	else {
		printf("[SQL] Connection to \"%s\" passed!", SQL_HOSTNAME);
	}
}

Код:

SQL_Connect();
	ManualVehicleEngineAndLights();
	new rcon[80];
	format(rcon, sizeof(rcon), "hostname %s", SERVER_NAME);
	SendRconCommand(rcon);
	format(rcon, sizeof(rcon), "weburl %s", SERVER_URL);
	SendRconCommand(rcon);
	format(rcon, sizeof(rcon), "map %s", SERVER_MAP);
	SendRconCommand(rcon);
	SetGameModeText(SERVER_REVISION);

	if (mysql_ping(g_iHandle) < 1)
	    return 0;

	Server_Load();
    mysql_function_query(g_iHandle, "SELECT * FROM `billboards`", true, "Billboard_Load", "");
	mysql_function_query(g_iHandle, "SELECT * FROM `houses`", true, "House_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `businesses`", true, "Business_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `dropped`", true, "Dropped_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `entrances`", true, "Entrance_Load", "");
	mysql_function_query(g_iHandle, "SELECT * FROM `cars`", true, "Car_Load", "");
	mysql_function_query(g_iHandle, "SELECT * FROM `jobs`", true, "Job_Load", "");
	mysql_function_query(g_iHandle, "SELECT * FROM `crates`", true, "Crate_Load", "");
	mysql_function_query(g_iHandle, "SELECT * FROM `plants`", true, "Plant_Load", "");
	mysql_function_query(g_iHandle, "SELECT * FROM `factions`", true, "Faction_Load", "");
	mysql_function_query(g_iHandle, "SELECT * FROM `arrestpoints`", true, "Arrest_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `gates`", true, "Gate_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `backpacks`", true, "Backpack_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `impoundlots`", true, "Impound_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `atm`", true, "ATM_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `garbage`", true, "Garbage_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `vendors`", true, "Vendor_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `gunracks`", true, "Rack_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `speedcameras`", true, "Speed_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `graffiti`", true, "Graffiti_Load", "");
    mysql_function_query(g_iHandle, "SELECT * FROM `detectors`", true, "Detector_Load", "");

How is it removed? (mysql_ping)

Код:

if(mysql_affected_rows(g_iHandle)) {
		format(string, sizeof(string), "You have successfully jailed %s's account.", name);
		SendClientMessageEx(index, COLOR_WHITE, string);

	}

Код:

public OnQueryExecute(playerid, query[])
{
	static
	    rows,
	    fields;

	cache_get_data(rows, fields, g_iHandle);

	if (strfind(query, "SELECT", true) != -1)
		Dialog_Show(playerid, ExecuteQuery, DIALOG_STYLE_INPUT, "Execute Query", "Success: MySQL returned %d rows from your query.\n\nPlease specify the MySQL query to execute below:", "Execute", "Back", rows);

	else
		Dialog_Show(playerid, ExecuteQuery, DIALOG_STYLE_INPUT, "Execute Query", "Success: Query executed successfully (affected rows: %d).\n\nPlease specify the MySQL query to execute below:", "Execute", "Back", mysql_affected_rows());

	PlayerData[playerid][pExecute] = 0;
	return 1;
}

How to change it? (mysql_affected_rows)

[Vince]

mysql_ping is removed because the plugin automatically reconnects. Replace the mysql_ping line with:

pawn Код:

if(mysql_errno(g_iHandle) != 0)

Change mysql_affected_rows to cache_affected_rows.