ZmqVqaqv

1	// ovak kreiram bazu 
2	mysql_tquery(DB, "CREATE TABLE IF NOT EXISTS "LANG_DB" (\
3		`lang_id` INT NOT NULL AUTO_INCREMENT, \
4		`lang_key` VARCHAR(24) NOT NULL, \
5		`lang_english` VARCHAR(160) NOT NULL, \
6		`lang_serbian` VARCHAR(160) NOT NULL, \
7		`lang_comment` VARCHAR(32) NOT NULL, \
8		PRIMARY KEY (`lang_id`))");
9
10//funkcija koju koristim umjesto SCM
11stock ML_SendClientMessage(playerid, color, const key[])
12{
13	static query[96];
14	mysql_format(DB, query, sizeof(query), "SELECT `lang_serbian`, `lang_english` FROM "LANG_DB" WHERE `lang_key`='%s'", key);
15	mysql_pquery(DB, query, "mySQL_ML_SendClientMessage", "iis", playerid, color, key);
16	return 1;
17}
18
19function mySQL_ML_SendClientMessage(playerid, color, const key[])
20{
21	static rows;
22	cache_get_row_count(rows);
23	if(rows > 0)
24	{
25		static message[160];
26		if(isPlayerLanguage(playerid, LANG_BALKAN))
27		{
28			cache_get_value_name(0, "lang_serbian", message, sizeof(message));
29		}
30		else
31		{
32			cache_get_value_name(0, "lang_english", message, sizeof(message));
33		}
34		SendClientMessage(playerid, color, message);
35		return 1;
36	}
37	else printf("Cannot found message from database. (SendClientMessage(%d, %d, %s))", playerid, color, key);
38	return 0;
39}
40
41
42poruku insertujem u bazu sa unique keyom 
43i onda koristim nesto tipa
44ML_SendClientMessage(playerid, COL_SERVER, "test");