· 8 years ago · May 10, 2018, 02:20 PM
1function loadCharacters( )
2 -- ПерÑонажи
3 mysql_query(
4 connect_mysql,
5 "CREATE TABLE IF NOT EXISTS character1 (\
6 accountName TEXT, skin INTEGER, old TEXT, pole TEXT, \
7 name TEXT , secondname TEXT, city TEXT, nick TEXT, IC TEXT, OCC TEXT )"
8 )
9 mysql_query(
10 connect_mysql,
11 "CREATE TABLE IF NOT EXISTS character2 (\
12 accountName TEXT, skin INTEGER, old TEXT, pole TEXT, \
13 name TEXT , secondname TEXT, city TEXT, nick TEXT, IC TEXT, OCC TEXT )"
14 )
15 mysql_query(
16 connect_mysql,
17 "CREATE TABLE IF NOT EXISTS character3 (\
18 accountName TEXT, skin INTEGER, old TEXT, pole TEXT, \
19 name TEXT , secondname TEXT, city TEXT, nick TEXT, IC TEXT, OCC TEXT )"
20 )
21
22 outputDebugString( tostring( mysql_query(
23 connect_mysql,
24 "CREATE TABLE IF NOT EXISTS characterSettings1 (\
25 user TEXT, health FLOAT,\
26 armor FLOAT, money INTEGER, x FLOAT, y FLOAT, z FLOAT, wanted INTEGER, skin INTEGER, dim INTEGER,\
27 int INTEGER, r INTEGER, g INTEGER, b INTEGER, jailtime INTEGER,stat0 INTEGER ,stat1 INTEGER ,stat2 INTEGER ,\
28 stat3 INTEGER ,stat4 INTEGER ,stat5 INTEGER ,stat6 INTEGER ,stat7 INTEGER ,stat8 INTEGER ,stat9 INTEGER ,stat10 INTEGER,\
29 slot0 INTEGER,slot1 INTEGER,slot2 INTEGER,slot3 INTEGER,slot4 INTEGER,slot5 INTEGER,slot6 INTEGER,slot7 INTEGER,slot8 INTEGER,\
30 slot9 INTEGER,slot10 INTEGER,slot11 INTEGER,slot12 INTEGER,ammo0 INTEGER,ammo1 INTEGER,ammo2 INTEGER,ammo3 INTEGER,ammo4 INTEGER,\
31 ammo5 INTEGER,ammo6 INTEGER,ammo7 INTEGER,ammo8 INTEGER,ammo9 INTEGER,ammo10 INTEGER,ammo11 INTEGER,ammo12 INTEGER ) "
32 ) ) ) --nil
33
34 outputDebugString( tostring( mysql_query(
35 connect_mysql,
36 "CREATE TABLE IF NOT EXISTS characterSettings2 (\
37 user TEXT, health FLOAT,\
38 armor FLOAT, money INTEGER, x FLOAT, y FLOAT, z FLOAT, wanted INTEGER, skin INTEGER, dim INTEGER,\
39 int INTEGER, r INTEGER, g INTEGER, b INTEGER, jailtime INTEGER,stat0 INTEGER ,stat1 INTEGER ,stat2 INTEGER ,\
40 stat3 INTEGER ,stat4 INTEGER ,stat5 INTEGER ,stat6 INTEGER ,stat7 INTEGER ,stat8 INTEGER ,stat9 INTEGER ,stat10 INTEGER,\
41 slot0 INTEGER,slot1 INTEGER,slot2 INTEGER,slot3 INTEGER,slot4 INTEGER,slot5 INTEGER,slot6 INTEGER,slot7 INTEGER,slot8 INTEGER,\
42 slot9 INTEGER,slot10 INTEGER,slot11 INTEGER,slot12 INTEGER,ammo0 INTEGER,ammo1 INTEGER,ammo2 INTEGER,ammo3 INTEGER,ammo4 INTEGER,\
43 ammo5 INTEGER,ammo6 INTEGER,ammo7 INTEGER,ammo8 INTEGER,ammo9 INTEGER,ammo10 INTEGER,ammo11 INTEGER,ammo12 INTEGER ) "
44 ) ) ) -- nil
45
46 outputDebugString( tostring( mysql_query(
47 connect_mysql,
48 "CREATE TABLE IF NOT EXISTS characterSettings3 (\
49 user TEXT, health FLOAT,\
50 armor FLOAT, money INTEGER, x FLOAT, y FLOAT, z FLOAT, wanted INTEGER, skin INTEGER, dim INTEGER,\
51 int INTEGER, r INTEGER, g INTEGER, b INTEGER, jailtime INTEGER,stat0 INTEGER ,stat1 INTEGER ,stat2 INTEGER ,\
52 stat3 INTEGER ,stat4 INTEGER ,stat5 INTEGER ,stat6 INTEGER ,stat7 INTEGER ,stat8 INTEGER ,stat9 INTEGER ,stat10 INTEGER,\
53 slot0 INTEGER,slot1 INTEGER,slot2 INTEGER,slot3 INTEGER,slot4 INTEGER,slot5 INTEGER,slot6 INTEGER,slot7 INTEGER,slot8 INTEGER,\
54 slot9 INTEGER,slot10 INTEGER,slot11 INTEGER,slot12 INTEGER,ammo0 INTEGER,ammo1 INTEGER,ammo2 INTEGER,ammo3 INTEGER,ammo4 INTEGER,\
55 ammo5 INTEGER,ammo6 INTEGER,ammo7 INTEGER,ammo8 INTEGER,ammo9 INTEGER,ammo10 INTEGER,ammo11 INTEGER,ammo12 INTEGER ) "
56 ) ) ) -- nil
57
58end