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
|
SQL query:
INSERT INTO `hlstats_Ranks` ( `game` , `image` , `minKills` , `maxKills` , `rankName` )
VALUES ( 'nd', 'nd_01', 0, 40, 'Survivor'),
( 'nd', 'nd_02', 41, 131, 'Private I'),
( 'nd', 'nd_03', 132, 272, 'Private II'),
( 'nd', 'nd_04', 273, 483, 'Private III'),
( 'nd', 'nd_05', 484, 764, 'Private First Class I'),
( 'nd', 'nd_06', 765, 1125, 'Private First Class II'),
( 'nd', 'nd_07', 1126, 1576, 'Private First Class III'),
( 'nd', 'nd_08', 1577, 2117, 'Lance Corporal I'),
( 'nd', 'nd_09', 2118, 2768, 'Lance Corporal II'),
( 'nd', 'nd_10', 2769, 3529, 'Lance Corporal III'),
( 'nd', 'nd_11', 3530, 4410, 'Corporal I'),
( 'nd', 'nd_12', 4411, 5421, 'Corporal II'),
( 'nd', 'nd_13', 5422, 6562, 'Corporal III'),
( 'nd', 'nd_14', 6563, 7853, 'Sergeant I'),
( 'nd', 'nd_15', 7854, 9294, 'Sergeant II'),
( 'nd', 'nd_16', 9295, 10895, 'Sergeant III'),
( 'nd', 'nd_17', 10896, 12666, 'Staff Sergeant I'),
( 'nd', 'nd_18', 12667, 14607, 'Staff Sergeant II'),
( 'nd', 'nd_19', 14608, 16738, 'Staff Sergeant III'),
( 'nd', 'nd_20', 16739, 19059, 'Gunnery Sergeant I'),
( 'nd', 'nd_21', 19060, 21580, 'Gunnery Sergeant II'),
( 'nd', 'nd_22', 21581, 24311, 'Gunnery Sergeant III'),
( 'nd', 'nd_23', 24312, 27252, 'Master Sergeant I'),
( 'nd', 'nd_24', 27253, 30423, 'Master Sergeant II'),
( 'nd', 'nd_25', 30424, 33824, 'Master Sergeant III'),
( 'nd', 'nd_26', 33825, 37465, 'First Sergeant I'),
( 'nd', 'nd_27', 37466, 41356, 'First Sergeant II'),
...... usw
|