Installations

Remember that this resource has verified DMCA protection, and its illegal use or distribution could imply a claim for protection of Title 17 of Chapter 512 (c) (3) of the Digital Millennium Copyright Act
STEP 1 - Dependencies
This is one of the most important parts, since without the dependencies, the resource will never work or not start, here we will list the dependencies with their respective links for you to download and add them to your server
Don't forget to download all these resources, including the cfx-server-data, because without the latter, you won't be able to use the photographic system
GitHub - esx-framework/esx-legacy: Official Repo For ESX-Legacy
GitHub
esx_menu_default and dependencies
GitHub - mkafrin/PolyZone: PolyZone is a FiveM mod to define zones of different shapes and test whether a point is inside or outside of the zone
GitHub
GitHub - Xogy/xsound: Improved audio library for FiveM
GitHub
GitHub - citizenfx/screenshot-basic: FiveM client screenshot resource
GitHub
cfx-server-data/resources at master · citizenfx/cfx-server-data
GitHub
webpacks and yarn, important dependency
For screenshot-basic to work, you must keep your webpacks and yarn up to date, please replace all these files on your server, otherwise you will never be able to take screenshots
STEP 2 - Start order
This is one of the most important steps and here we will explain how to correctly start your resource
NEVER, but NEVER, you must place the resources above es_extended, if you do this they will never work and will throw errors
The correct order of the resources is as follows, always keeping es_extended and its cores above, but the other normal resources below
1
ensure PolyZone
2
ensure xsound
3
ensure screenshot-basic
4
ensure qs-base
5
ensure qs-videos
6
ensure qs-smartphone
STEP 3 - Database
Before placing our [sql] file, we will remove the old tables similar to qs-smartphone from our server, so as not to cause critical database errors
This code is mandatory to run before starting to install the new database
To do this, we will execute the following code in our database:
1
DROP TABLE IF EXISTS `insta_stories`;
2
DROP TABLE IF EXISTS `instagram_stories`;
3
DROP TABLE IF EXISTS `instagram_account`;
4
DROP TABLE IF EXISTS `instagram_followers`;
5
DROP TABLE IF EXISTS `instagram_posts`;
6
DROP TABLE IF EXISTS `tinder_accounts`;
7
DROP TABLE IF EXISTS `tinder_likes`;
8
DROP TABLE IF EXISTS `phone_invoices`;
9
DROP TABLE IF EXISTS `phone_accounts`;
10
DROP TABLE IF EXISTS `phone_chats`;
11
DROP TABLE IF EXISTS `phone_messages`;
12
DROP TABLE IF EXISTS `phone_notifies`;
13
DROP TABLE IF EXISTS `phone_alertjobs`;
14
DROP TABLE IF EXISTS `phone_news`;
15
DROP TABLE IF EXISTS `player_contacts`;
16
DROP TABLE IF EXISTS `player_gallery`;
17
DROP TABLE IF EXISTS `player_notes`;
18
DROP TABLE IF EXISTS `player_mails`;
19
DROP TABLE IF EXISTS `tinder_messages`;
20
DROP TABLE IF EXISTS `twitter_account`;
21
DROP TABLE IF EXISTS `twitter_hashtags`;
22
DROP TABLE IF EXISTS `twitter_mentions`;
23
DROP TABLE IF EXISTS `twitter_tweets`;
24
DROP TABLE IF EXISTS `whatsapp_accounts`;
25
DROP TABLE IF EXISTS `whatsapp_chats`;
26
DROP TABLE IF EXISTS `whatsapp_chats_messages`;
27
DROP TABLE IF EXISTS `whatsapp_groups`;
28
DROP TABLE IF EXISTS `whatsapp_groups_messages`;
29
DROP TABLE IF EXISTS `whatsapp_groups_users`;
30
DROP TABLE IF EXISTS `yellowpages_posts`;
31
DROP TABLE IF EXISTS `whatsapp_stories`;
32
DROP TABLE IF EXISTS `darkchat_messages`;
33
DROP TABLE IF EXISTS `tiktok_users`;
34
DROP TABLE IF EXISTS `tiktok_videos`;
35
DROP TABLE IF EXISTS `crypto_transactions`;
36
DROP TABLE IF EXISTS `phone_crypto`;
After making sure that our database is clean, we will proceed to install the database of our new Smartphone
1
ALTER TABLE `users` ADD IF NOT EXISTS `apps` TEXT;
2
ALTER TABLE `users` ADD IF NOT EXISTS `widget` TEXT;
3
ALTER TABLE `users` ADD IF NOT EXISTS `bt` TEXT;
4
ALTER TABLE `users` ADD IF NOT EXISTS `charinfo` TEXT;
5
ALTER TABLE `users` ADD IF NOT EXISTS `metadata` mediumtext;
6
ALTER TABLE `users` ADD IF NOT EXISTS `cryptocurrency` longtext;
7
ALTER TABLE `users` ADD IF NOT EXISTS `cryptocurrencytransfers` TEXT;
8
ALTER TABLE `users` ADD IF NOT EXISTS `phonePos` TEXT;
9
ALTER TABLE `users` ADD IF NOT EXISTS `spotify` TEXT;
10
ALTER TABLE `users` ADD IF NOT EXISTS `ringtone` TEXT;
11
ALTER TABLE `users` ADD IF NOT EXISTS `first_screen_showed` INT(11) DEFAULT NULL;
1
INSERT INTO `items` (`name`, `label`, `weight`) VALUES
2
    ('classic_phone', 'Classic Phone', 10),
3
    ('black_phone', 'Black Phone', 10),
4
    ('blue_phone', 'Blue Phone', 10),
5
    ('gold_phone', 'Gold Phone', 10),
6
    ('red_phone', 'Red Phone', 10),
7
    ('green_phone', 'Green Phone', 10),
8
    ('greenlight_phone', 'Green Light Phone', 10),
9
    ('pink_phone', 'Pink Phone', 10),
10
    ('white_phone', 'White Phone', 10),
11
    ('wet_classic_phone', 'Wet Classic Phone', 10),
12
    ('wet_black_phone', 'Wet Black Phone', 10),
13
    ('wet_blue_phone', 'Wet Blue Phone', 10),
14
    ('wet_gold_phone', 'Wet Gold Phone', 10),
15
    ('wet_red_phone', 'Wet Red Phone', 10),
16
    ('wet_green_phone', 'Wet Green Phone', 10),
17
    ('wet_greenlight_phone', 'Wet Green Light Phone', 10),
18
    ('wet_pink_phone', 'Wet Pink Phone', 10),
19
    ('wet_white_phone', 'Wet White Phone', 10),
20
    ('phone_module', 'Phone Module', 10),
21
    ('powerbank', 'Power Bank', 10)
22
;
1
CREATE TABLE IF NOT EXISTS `insta_stories` (
2
  `username` varchar(50),
3
  `location` varchar(50),
4
  `filter` varchar(50),
5
  `description` varchar(50),
6
  `image` text,
7
  `created` time
8
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
9
​
10
CREATE TABLE IF NOT EXISTS `instagram_stories` (
11
  `owner` varchar(50) COLLATE armscii8_bin,
12
  `data` text COLLATE armscii8_bin,
13
  PRIMARY KEY (`owner`) USING BTREE
14
) ENGINE = InnoDB DEFAULT CHARSET = armscii8 COLLATE = armscii8_bin;
15
​
16
CREATE TABLE IF NOT EXISTS `instagram_account` (
17
  `id` varchar(90) NOT NULL,
18
  `name` varchar(50) NOT NULL,
19
  `phone` varchar(50) NOT NULL,
20
  `username` varchar(50) NOT NULL,
21
  `password` varchar(50) NOT NULL,
22
  `avatar` text,
23
  `description` text,
24
  `verify` INT(11) NOT NULL DEFAULT '0'
25
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
26
​
27
CREATE TABLE IF NOT EXISTS `instagram_followers` (
28
  `username` varchar(50) NOT NULL,
29
  `followed` varchar(50) NOT NULL
30
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
31
​
32
CREATE TABLE IF NOT EXISTS `instagram_posts` (
33
  `id` int(11) NOT NULL AUTO_INCREMENT,
34
  `username` varchar(50) NOT NULL,
35
  `image` text NOT NULL,
36
  `description` varchar(255) NOT NULL,
37
  `location` varchar(50) NOT NULL DEFAULT 'Los Santos',
38
  `filter` varchar(50) NOT NULL,
39
  `created` timestamp NOT NULL,
40
  `likes` TEXT COLLATE 'utf8mb4_general_ci',
41
  PRIMARY KEY (`id`)
42
) ENGINE = InnoDB AUTO_INCREMENT = 14 DEFAULT CHARSET = utf8mb4;
43
​
44
CREATE TABLE IF NOT EXISTS `player_mails` (
45
  `id` INT(11) NOT NULL AUTO_INCREMENT,
46
  `identifier` VARCHAR(50) NULL COLLATE 'utf8mb4_general_ci',
47
  `sender` VARCHAR(50) NULL COLLATE 'utf8mb4_general_ci',
48
  `subject` VARCHAR(50) NULL COLLATE 'utf8mb4_general_ci',
49
  `message` TEXT NULL COLLATE 'utf8mb4_general_ci',
50
  `read` TINYINT(4) NULL,
51
  `mailid` INT(11) NULL,
52
  `date` TIMESTAMP NULL DEFAULT current_timestamp(),
53
  `button` TEXT COLLATE 'utf8mb4_general_ci',
54
  PRIMARY KEY (`id`) USING BTREE,
55
  INDEX `identifier` (`identifier`) USING BTREE
56
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 2;
57
​
58
CREATE TABLE IF NOT EXISTS `tinder_accounts` (
59
  `id` int(11) NOT NULL AUTO_INCREMENT,
60
  `phone` varchar(50) NOT NULL DEFAULT '0',
61
  `pp` text NOT NULL,
62
  `name` varchar(50) NOT NULL DEFAULT '0',
63
  `gender` varchar(50) NOT NULL,
64
  `targetGender` varchar(50) NOT NULL DEFAULT '0',
65
  `hobbies` varchar(50) NOT NULL DEFAULT '0',
66
  `age` varchar(50) NOT NULL DEFAULT '0',
67
  `description` varchar(50) NOT NULL DEFAULT '0',
68
  `password` varchar(50) NOT NULL,
69
  PRIMARY KEY (`id`)
70
) ENGINE = InnoDB AUTO_INCREMENT = 17 DEFAULT CHARSET = utf8mb4;
71
​
72
CREATE TABLE IF NOT EXISTS `tinder_likes` (
73
  `id` int(11) NOT NULL AUTO_INCREMENT,
74
  `phone` varchar(1024) NOT NULL,
75
  `likeds` mediumtext NOT NULL,
76
  PRIMARY KEY (`id`)
77
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4;
78
​
79
CREATE TABLE IF NOT EXISTS `phone_invoices` (
80
  `id` int(10) NOT NULL AUTO_INCREMENT,
81
  `citizenid` varchar(50) DEFAULT NULL,
82
  `amount` int(11) NOT NULL DEFAULT 0,
83
  `society` tinytext DEFAULT NULL,
84
  `sender` varchar(50) NULL,
85
  `sendercitizenid` varchar(50) DEFAULT NULL,
86
  PRIMARY KEY (id)
87
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
88
​
89
CREATE TABLE IF NOT EXISTS `phone_accounts` (
90
  `app` varchar(50) NOT NULL,
91
  `id` varchar(80) NOT NULL,
92
  `name` varchar(50) NOT NULL,
93
  `password` varchar(50) NOT NULL,
94
  `birthdate` varchar(50) NOT NULL,
95
  `gender` varchar(50) NOT NULL,
96
  `interested` text NOT NULL,
97
  `avatar` text NOT NULL
98
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
99
​
100
CREATE TABLE IF NOT EXISTS `phone_chats` (
101
  `app` varchar(50) NOT NULL,
102
  `author` varchar(50) NOT NULL,
103
  `number` varchar(50) NOT NULL,
104
  `created` varchar(50) NOT NULL
105
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
106
​
107
CREATE TABLE IF NOT EXISTS `phone_messages` (
108
  `id` int(11) NOT NULL AUTO_INCREMENT,
109
  `phone` varchar(50),
110
  `number` varchar(50) NOT NULL,
111
  `owner` varchar(50),
112
  `messages` text NOT NULL,
113
  `type` varchar(50),
114
  `read` int(11),
115
  `created` varchar(50),
116
  PRIMARY KEY (`id`)
117
) ENGINE = InnoDB AUTO_INCREMENT = 20 DEFAULT CHARSET = utf8mb4;
118
​
119
CREATE TABLE IF NOT EXISTS `phone_notifies` (
120
  `id` int(11) NOT NULL AUTO_INCREMENT,
121
  `phone` varchar(50) NOT NULL,
122
  `msg_content` text NOT NULL,
123
  `msg_head` varchar(50) NOT NULL DEFAULT '',
124
  `app_name` text NOT NULL,
125
  `msg_time` varchar(50) NOT NULL,
126
  PRIMARY KEY (`id`)
127
) ENGINE = InnoDB AUTO_INCREMENT = 64 DEFAULT CHARSET = utf8mb4;
128
​
129
CREATE TABLE IF NOT EXISTS `player_contacts` (
130
  `id` INT(11) NOT NULL AUTO_INCREMENT,
131
  `identifier` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
132
  `name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
133
  `number` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
134
  `iban` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
135
  `display` VARCHAR(50) COLLATE 'utf8mb4_general_ci',
136
  `note` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
137
  `pp` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
138
  `isBlocked` INT(11) NULL,
139
  PRIMARY KEY (`id`) USING BTREE,
140
  INDEX `identifier` (`identifier`) USING BTREE
141
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 38;
142
​
143
CREATE TABLE IF NOT EXISTS `player_gallery` (
144
  `id` INT(11) NOT NULL AUTO_INCREMENT,
145
  `identifier` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
146
  `resim` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
147
  `data` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
148
  `created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
149
  PRIMARY KEY (`id`) USING BTREE
150
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 11;
151
​
152
CREATE TABLE IF NOT EXISTS `tinder_messages` (
153
  `id` int(11) NOT NULL AUTO_INCREMENT,
154
  `phone` varchar(50) NOT NULL,
155
  `number` longtext NOT NULL,
156
  `messages` longtext DEFAULT '{}',
157
  PRIMARY KEY (`id`) USING BTREE
158
) ENGINE = InnoDB AUTO_INCREMENT = 11;
159
​
160
CREATE TABLE IF NOT EXISTS `twitter_account` (
161
  `id` varchar(90) NOT NULL,
162
  `name` varchar(50) NOT NULL,
163
  `phone` varchar(50) NOT NULL,
164
  `username` varchar(50) NOT NULL,
165
  `password` varchar(50) NOT NULL,
166
  `avatar` text NOT NULL
167
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
168
​
169
CREATE TABLE IF NOT EXISTS `twitter_hashtags` (
170
  `id` int(11) NOT NULL AUTO_INCREMENT,
171
  `name` varchar(80) NOT NULL,
172
  `created` varchar(50) NOT NULL,
173
  `count` int(11) NULL,
174
  PRIMARY KEY (`id`)
175
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4;
176
​
177
CREATE TABLE IF NOT EXISTS `twitter_mentions` (
178
  `id` INT(11) NOT NULL AUTO_INCREMENT COLLATE 'utf8mb4_general_ci',
179
  `id_tweet` INT(11) NOT NULL COLLATE 'utf8mb4_general_ci',
180
  `username` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
181
  `mentioned` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
182
  `created` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
183
  PRIMARY KEY (`id`) USING BTREE
184
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 4;
185
​
186
CREATE TABLE IF NOT EXISTS `twitter_tweets` (
187
  `id` int(5) NOT NULL AUTO_INCREMENT,
188
  `username` varchar(80) NOT NULL,
189
  `message` longtext NOT NULL,
190
  `hashtags` varchar(50) NOT NULL,
191
  `mentions` varchar(50) NOT NULL,
192
  `created` varchar(50) NOT NULL,
193
  `image` text NOT NULL,
194
  `likes` TEXT NULL COLLATE 'utf8mb4_general_ci',
195
  PRIMARY KEY (`id`)
196
) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = utf8mb4;
197
​
198
CREATE TABLE IF NOT EXISTS `whatsapp_accounts` (
199
  `id` varchar(100) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
200
  `name` varchar(50) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
201
  `phone` varchar(50) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
202
  `password` varchar(50) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
203
  `avatar` text NOT NULL COLLATE UTF8MB4_UNICODE_CI
204
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
205
​
206
CREATE TABLE IF NOT EXISTS `whatsapp_chats` (
207
  `id` int(11) NOT NULL AUTO_INCREMENT,
208
  `phone` varchar(50) NOT NULL,
209
  `number` varchar(50) NOT NULL,
210
  `created` varchar(50) NOT NULL,
211
  `messages` text NOT NULL,
212
  PRIMARY KEY (`id`)
213
) ENGINE = InnoDB AUTO_INCREMENT = 43 DEFAULT CHARSET = utf8mb4;
214
​
215
DROP TABLE IF EXISTS `whatsapp_chats_messages`;
216
CREATE TABLE IF NOT EXISTS `whatsapp_chats_messages` (
217
  `id` int(11) NOT NULL AUTO_INCREMENT,
218
  `id_chat` int(11) NOT NULL,
219
  `owner` varchar(50) NOT NULL,
220
  `type` varchar(50) NOT NULL,
221
  `created` varchar(50) NOT NULL,
222
  `message` text NOT NULL,
223
  `readed` int(1) NOT NULL,
224
  PRIMARY KEY (`id`)
225
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
226
​
227
CREATE TABLE IF NOT EXISTS `whatsapp_groups` (
228
  `id` int(11) AUTO_INCREMENT,
229
  `phone` varchar(50) NOT NULL,
230
  `number` varchar(50) NOT NULL,
231
  `type` varchar(50) NOT NULL,
232
  `name` varchar(50) NOT NULL,
233
  `image` text NOT NULL,
234
  `created` varchar(50) NOT NULL,
235
  PRIMARY KEY (`id`)
236
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4;
237
​
238
DROP TABLE IF EXISTS `whatsapp_groups_messages`;
239
CREATE TABLE IF NOT EXISTS `whatsapp_groups_messages` (
240
  `id` int(11) NOT NULL AUTO_INCREMENT,
241
  `id_group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
242
  `owner` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
243
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
244
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
245
  `created` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
246
  `read` int(11) NOT NULL,
247
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
248
  PRIMARY KEY (`id`)
249
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
250
​
251
CREATE TABLE IF NOT EXISTS `whatsapp_groups_users` (
252
  `number_group` varchar(50) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
253
  `admin` int(11) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
254
  `phone` varchar(50) NOT NULL COLLATE UTF8MB4_UNICODE_CI
255
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
256
​
257
CREATE TABLE IF NOT EXISTS `player_notes` (
258
  `id` int(11) NOT NULL AUTO_INCREMENT,
259
  `identifier` text NOT NULL,
260
  `baslik` text NOT NULL,
261
  `aciklama` text NOT NULL,
262
  PRIMARY KEY (`id`)
263
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
264
​
265
CREATE TABLE IF NOT EXISTS `whatsapp_stories` (
266
  `phone` varchar(50) NOT NULL,
267
  `image` text NOT NULL,
268
  `created` varchar(50) NOT NULL,
269
  `description` varchar(50),
270
  `location` varchar(50),
271
  `filter` varchar(50)
272
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
273
​
274
CREATE TABLE IF NOT EXISTS `darkchat_messages` (
275
  `id` INT(11) NOT NULL AUTO_INCREMENT,
276
  `password` text NOT NULL,
277
  `owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
278
  `name` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
279
  `messages` TEXT NULL COLLATE 'utf8mb4_general_ci',
280
  PRIMARY KEY (`id`) USING BTREE,
281
  INDEX `id` (`id`) USING BTREE
282
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 10;
283
​
284
CREATE TABLE IF NOT EXISTS `phone_alertjobs` (
285
  `id` int(11) NOT NULL,
286
  `job` varchar(255) NOT NULL,
287
  `alerts` longtext NULL,
288
  `date` timestamp NULL DEFAULT current_timestamp()
289
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
290
​
291
CREATE TABLE `phone_news` (
292
  `id` INT(11) NOT NULL AUTO_INCREMENT,
293
  `owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
294
  `title` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
295
  `content` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
296
  `image` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
297
  `created` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
298
  PRIMARY KEY (`id`) USING BTREE
299
)
300
COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB AUTO_INCREMENT=5;
301
​
302
CREATE TABLE `tiktok_users` (
303
    `id` INT(11) NOT NULL AUTO_INCREMENT,
304
    `username` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
305
    `phone` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
306
    `pp` TEXT NULL COLLATE 'utf8mb4_general_ci',
307
    `name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
308
    `bio` TEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
309
    `birthday` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
310
    `videos` TEXT NOT NULL DEFAULT '{}' COLLATE 'utf8mb4_general_ci',
311
    `followers` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
312
    `following` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
313
    `liked` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
314
    PRIMARY KEY (`id`) USING BTREE,
315
    INDEX `id` (`id`) USING BTREE
316
)
317
COLLATE='utf8mb4_general_ci'
318
ENGINE=InnoDB
319
AUTO_INCREMENT=13
320
;
321
​
322
CREATE TABLE `tiktok_videos` (
323
    `id` INT(11) NOT NULL AUTO_INCREMENT,
324
    `userID` INT(11) NULL DEFAULT NULL,
325
    `created` VARCHAR(50) NOT NULL DEFAULT '00:00:00' COLLATE 'utf8mb4_unicode_ci',
326
    `data` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
327
    `phone` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
328
    PRIMARY KEY (`id`) USING BTREE
329
)
330
COLLATE='utf8mb4_unicode_ci'
331
ENGINE=InnoDB
332
AUTO_INCREMENT=440
333
;
334
​
335
ALTER TABLE `phone_alertjobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `job` (`job`);
336
​
337
ALTER TABLE `phone_alertjobs`
338
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
339
COMMIT;
340
​
341
ALTER TABLE whatsapp_groups_messages CONVERT TO CHARACTER SET utf8mb4 COLLATE UTF8MB4_UNICODE_CI;
342
ALTER TABLE whatsapp_groups_users CONVERT TO CHARACTER SET utf8mb4 COLLATE UTF8MB4_UNICODE_CI;
343
ALTER TABLE whatsapp_accounts CONVERT TO CHARACTER SET utf8mb4 COLLATE UTF8MB4_UNICODE_CI;
344
ALTER TABLE whatsapp_chats_messages CONVERT TO CHARACTER SET utf8mb4 COLLATE UTF8MB4_UNICODE_CI;
EMOJIS AND CHARSET
This step is really simple, but if we don't do it we will receive constant errors in some phone chats, due to the lack of activated charset and emojis
This phone system requires you to modify a line in your server.cfg to allow the use of emojis and special characters. To do this, we simply need to add charset=utf8mb4 to the end of our string called string mysql_connection_string
Just add the charset=utf8mb4, don't modify or add anything else. If you already have this at the end of your server.cfg then you can avoid this step