1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
/*
Inserts the map information into the database.
Retrieves the MapID of the map and stores it in a global variable.
*/
void DB_SetupMap()
{
gB_MapSetUp = false;
char query[1024];
char map[PLATFORM_MAX_PATH];
GetCurrentMapDisplayName(map, sizeof(map));
char escapedMap[PLATFORM_MAX_PATH * 2 + 1];
SQL_EscapeString(gH_DB, map, escapedMap, sizeof(escapedMap));
Transaction txn = SQL_CreateTransaction();
// Insert/Update map into database
switch (g_DBType)
{
case DatabaseType_SQLite:
{
// UPDATE OR IGNORE
FormatEx(query, sizeof(query), sqlite_maps_update, escapedMap);
txn.AddQuery(query);
// INSERT OR IGNORE
FormatEx(query, sizeof(query), sqlite_maps_insert, escapedMap);
txn.AddQuery(query);
}
case DatabaseType_MySQL:
{
// INSERT ... ON DUPLICATE KEY ...
FormatEx(query, sizeof(query), mysql_maps_upsert, escapedMap);
txn.AddQuery(query);
}
}
// Retrieve mapID of map name
FormatEx(query, sizeof(query), sql_maps_findid, escapedMap, escapedMap);
txn.AddQuery(query);
SQL_ExecuteTransaction(gH_DB, txn, DB_TxnSuccess_SetupMap, DB_TxnFailure_Generic, 0, DBPrio_High);
}
public void DB_TxnSuccess_SetupMap(Handle db, any data, int numQueries, Handle[] results, any[] queryData)
{
switch (g_DBType)
{
case DatabaseType_SQLite:
{
if (SQL_FetchRow(results[2]))
{
gI_DBCurrentMapID = SQL_FetchInt(results[2], 0);
gB_MapSetUp = true;
Call_OnMapSetup();
}
}
case DatabaseType_MySQL:
{
if (SQL_FetchRow(results[1]))
{
gI_DBCurrentMapID = SQL_FetchInt(results[1], 0);
gB_MapSetUp = true;
Call_OnMapSetup();
}
}
}
}
|
