Dynamics

#include <YSI_Coding\y_hooks>
#include <YSI_Coding\y_timers>
#include <YSI_Data\y_iterate>

#define MAX_TESTS (50)

forward TestCreate(Float:x = 0.0, Float:y = 0.0, Float:z = 0.0);
forward Test_Save(gpsid);
forward Test_Load();
forward OnTestCreated(gpsid);
forward TEST_Delete(gpsid);

enum TEST_DATA
{
    tID,
    tExist,
};

new testData[MAX_TESTS][TEST_DATA];



public Test_Load()
{

	static
	    rows;

	cache_get_row_count(rows);

	for (new i = 0; i < rows; i ++) if (i < MAX_TESTS)
	{
	    testData[i][tExist] = true;

	    cache_get_value_name_int(i, "tID", testData[i][tID]);
	}
	printf("[Database]: Test_Load ID:%i loaded...", rows);
	return 1;
}
CMD:test_mysql(playerid, params[]){

    new id = 0, string[256];
    id = TestCreate(0.0, 0.0, 0.0);

	if (id == -1)
		return SendClientMessage(playerid, 0xFFFF00FF, "[ระบบ]: {FFFFF}ฐานข้อมูลคุณเต็ม");
    format(string, sizeof(string), "[ + ]: คุณได้สร้าง ไอดี: %d", id);
	SendClientMessage(playerid, 0x99CCFFFF, string);
    return 1;
}


public TestCreate(Float:x = 0.0, Float:y = 0.0, Float:z = 0.0)
{
	new Float:pos[3];
	pos[0] = x;
	pos[1] = y;
	pos[2] = z;
	for (new i = 0; i < MAX_TESTS; i ++) if (!testData[i][tExist])
	{
	    testData[i][tExist] = true;

	    mysql_tquery(g_SQL, "INSERT INTO `tests` (`tID`) VALUES(0)", "OnTestCreated", "d", i);
		return i;
	}
	return -1;
}


public OnTestCreated(gpsid)
{
	if (gpsid == -1 || !testData[gpsid][tExist])
	    return 0;

	testData[gpsid][tID] = cache_insert_id();
	//Test_Save(gpsid);

	return 1;
}



public Test_Save(gpsid)
{
	static
	    query[220];

	mysql_format(g_SQL, query, sizeof(query), "UPDATE `tests` SET `PosX` = '%f', `PosY` = '%f', `PosZ` = '%f' WHERE `tID` = '%d'",
	    testData[gpsid][tID]
	);
	return mysql_tquery(g_SQL, query);
}



CMD:dtset_mysql(playerid, params[]){

	static
	    id = 0,
		string[64];

	if (sscanf(params, "d", id))
		return SendClientMessage(playerid, 0xFFFF00FF, "/dgps [ไอดี]");

	if ((id < 0 || id >= MAX_TESTS) || !testData[id][tExist])
		return SendClientMessage(playerid, 0xFFFF00FF, "ยังไม่มีพิกัด • GPS • จึงไม่สามารถลบได้");

	TEST_Delete(id);
	format(string, sizeof(string), "[ + ]: คุณได้ลบ GPS ไอดี %d ออกสำเร็จ", id);
	SendClientMessage(playerid, 0x99CCFFFF, string);
	return 1;

}

public TEST_Delete(gpsid)
{
	if (gpsid != -1 && testData[gpsid][tExist])
	{
	    static
	        string[64];

		format(string, sizeof(string), "DELETE FROM `tests` WHERE `tID` = '%d'", testData[gpsid][tID]);
		mysql_tquery(g_SQL, string);

		testData[gpsid][tExist] = false;
		testData[gpsid][tID] = 0;
	}
	return 1;
}

CMD:menutest(playerid, ps[]){

	new string[256];
	string = "ไอดี\tพิกัด";

	for (new i = 0; i < MAX_TESTS; i ++) if (testData[i][tExist])
	{
		fm(string, "%s\n%i\t%f\n", string, i);
	}
	Dialog_Show(playerid, DIALOG_TEST, DIALOG_STYLE_TABLIST_HEADERS, "Test", string, "OK", "NO");
	return 1;
}