· 7 years ago · Oct 19, 2018, 11:14 PM
1public OnGameModeInit()
2{
3 SetGameModeText("Delray World | 0.2.0b |");
4 AddPlayerClass(0, 939.7047, 2593.0583, 14.5219, 0, 0, 0, 0, 0, 0, 0);
5 DisableInteriorEnterExits();
6 //
7 if ((Database = db_open("ServerFiles.db")) == DB: 0)
8 {
9 print("Failed to open a connection to \"ServerFiles.db\"");
10 }
11 else
12 {
13 db_query(Database, "PRAGMA synchronous = OFF");
14 db_query(Database, "CREATE TABLE IF NOT EXISTS users (userid INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(24) COLLATE NOCASE, password VARCHAR(129), admin INTEGER DEFAULT 0 NOT NULL, vip INTEGER DEFAULT 0 NOT NULL, money INTEGER DEFAULT 6500 NOT NULL, skin INTEGER DEFAULT 137 NOT NULL)");
15 db_query(Database, "CREATE TABLE IF NOT EXISTS houses (houseid INTEGER DEFAULT 0 NOT NULL, hX INTEGER DEFAULT 0 NOT NULL, hY INTEGER DEFAULT 0 NOT NULL, hZ INTEGER DEFAULT 0 NOT NULL, hIX INTEGER DEFAULT 0 NOT NULL, hIY INTEGER DEFAULT 0 NOT NULL, hIZ INTEGER DEFAULT 0 NOT NULL, housetext VARCHAR(24), majitel VARCHAR(24), int INTEGER DEFAULT 0 NOT NULL, intname VARCHAR(24), vw INTEGER DEFAULT 0 NOT NULL, zamek INTEGER DEFAULT 0 NOT NULL, cena INTEGER DEFAULT 0 NOT NULL, naprodej INTEGER DEFAULT 1 NOT NULL, pickup INTEGER DEFAULT 1272 NOT NULL, pickupex INTEGER DEFAULT 1318 NOT NULL");
16 }
17 return 1;
18}