· 5 years ago · Jun 13, 2020, 11:20 AM
1<?php
2 ini_set('display_errors', 1);
3 define("DB_HOST", "");
4 define("DB_USER", "");
5 define("DB_PASS", "");
6 define("DB_NAME", "");
7
8 //kz_players();//przenosi informacje o graczach ze starego formatu bazy do nowego
9 //kz_map(); //przenosi informacje o mapach ze starego formatu bazy do nowego
10 //kz_pro15(); //przenosi informacje o rekordach pro ze starego formatu bazy do nowego
11 //kz_nub15(); //przenosi informacje o rekordach nub ze starego formatu bazy do nowego
12 kz_abh15(); //przenosi informacje o rekordach abh ze starego formatu bazy do nowego
13
14 Function kz_players(){
15 $sql = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Unable to connect to MySQL.");
16 mysql_select_db(DB_NAME, $sql) or die ("Unable to select database.");
17 $tabelagraczy = "CREATE TABLE IF NOT EXISTS kz_players_new (player_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR(64) NOT NULL,ip VARCHAR(39) NOT NULL,authid VARCHAR(35) NOT NULL, lastseen datetime NOT NULL, country VARCHAR(6) NOT NULL, avatar VARCHAR(1024) NOT NULL, INDEX(name,authid))";
18 $tabelagraczy1 = mysql_query($tabelagraczy, $sql);
19 mysql_fetch_array($tabelagraczy1);
20
21 $q = "Select DISTINCT authid from kz_pro15 UNION select DISTINCT authid from kz_nub15 UNION select DISTINCT authid from kz_abh";
22 $r = mysql_query($q, $sql);
23
24 while($a = mysql_fetch_array($r))
25 {
26 $d = 'SELECT name, country, date, authid from (SELECT name, country, date, authid from kz_pro15 UNION select name, country, date, authid from kz_nub15 UNION select name, country, date, authid from kz_abh)a WHERE authid = "'.$a['authid'].'" ORDER BY date DESC';
27 $p = mysql_query($d, $sql);
28 $b = mysql_fetch_array($p);
29
30 $e = 'INSERT INTO kz_players_new(authid, name, country, lastseen) VALUES("'.$b['authid'].'", "'.$b['name'].'", "'.$b['country'].'", "'.$b['date'].'")';
31 $er = mysql_query($e, $sql);
32 while(mysql_fetch_array($er));
33 }
34 }
35
36 Function kz_map(){
37 $sql = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Unable to connect to MySQL.");
38 mysql_select_db(DB_NAME, $sql) or die ("Unable to select database.");
39 $tabelamap = "CREATE TABLE IF NOT EXISTS kz_map_new (map_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,mapname VARCHAR(64) NOT NULL, difficulty TINYINT NOT NULL, maptype TINYINT NOT NULL, coolmap TINYINT NOT NULL, maptime SMALLINT NOT NULL)";
40 $tabelamap1 = mysql_query($tabelamap, $sql);
41 mysql_fetch_array($tabelamap1);
42
43 $q = "Select DISTINCT mapname from kz_pro15 UNION select DISTINCT mapname from kz_nub15 UNION select DISTINCT mapname from kz_abh";
44 $r = mysql_query($q, $sql);
45
46 while($a = mysql_fetch_array($r))
47 {
48 $e = 'INSERT INTO kz_map_new(mapname) VALUES("'.$a['mapname'].'")';
49 $er = mysql_query($e, $sql);
50 while(mysql_fetch_array($er));
51 }
52 }
53
54 Function kz_pro15(){
55 $sql = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Unable to connect to MySQL.");
56 mysql_select_db(DB_NAME, $sql) or die ("Unable to select database.");
57 $tabelamap = "CREATE TABLE IF NOT EXISTS kz_pro15_new (`record_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `player_id` INT NOT NULL, `map_id` INT NOT NULL,`time` decimal(65,2) NOT NULL, `date` datetime NOT NULL, `weapon` varchar(64) NOT NULL, `server` varchar(64) NOT NULL, INDEX(player_id, map_id),CONSTRAINT KLUCZMAP1 FOREIGN KEY (map_id) REFERENCES kz_map_new(map_id),CONSTRAINT KLUCZGRACZY1 FOREIGN KEY (player_id) REFERENCES kz_players_new(player_id))";
58 $tabelamap1 = mysql_query($tabelamap, $sql);
59 mysql_fetch_array($tabelamap1);
60
61 $q = "Select authid, time, weapon, mapname, date from kz_pro15";
62 $r = mysql_query($q, $sql);
63
64 while($a = mysql_fetch_array($r))
65 {
66 $d = 'SELECT player_id from kz_players_new WHERE authid = "'.$a['authid'].'"';
67 $p = mysql_query($d, $sql);
68 $b = mysql_fetch_array($p, MYSQL_NUM);
69 $player_id = $b[0];
70
71 $d = 'SELECT map_id from kz_map_new WHERE mapname = "'.$a['mapname'].'"';
72 $p = mysql_query($d, $sql);
73 $b = mysql_fetch_array($p, MYSQL_NUM);
74 $map_id = $b[0];
75
76 $e = 'INSERT INTO kz_pro15_new(player_id, map_id, time, date, weapon) VALUES("'.$player_id.'", "'.$map_id.'", "'.$a['time'].'", "'.$a['date'].'", "'.$a['weapon'].'")';
77 echo $e;
78 $er = mysql_query($e, $sql);
79 mysql_fetch_array($er);
80 }
81 }
82
83 Function kz_nub15(){
84 $sql = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Unable to connect to MySQL.");
85 mysql_select_db(DB_NAME, $sql) or die ("Unable to select database.");
86 $tabelamap = "CREATE TABLE IF NOT EXISTS kz_nub15_new (record_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, player_id INT NOT NULL, map_id INT NOT NULL, `time` decimal(65,2) NOT NULL, `date` datetime NOT NULL, `weapon` varchar(64) NOT NULL, `server` varchar(64) NOT NULL,`checkpoints` real NOT NULL, `gocheck` real NOT NULL, INDEX(player_id, map_id),CONSTRAINT KLUCZMAP2 FOREIGN KEY (map_id) REFERENCES kz_map_new(map_id),CONSTRAINT KLUCZGRACZY2 FOREIGN KEY (player_id) REFERENCES kz_players_new(player_id))";
87 $tabelamap1 = mysql_query($tabelamap, $sql);
88 mysql_fetch_array($tabelamap1);
89
90 $q = "Select checkpoints, gocheck, authid, time, weapon, mapname, date from kz_nub15";
91 $r = mysql_query($q, $sql);
92
93 while($a = mysql_fetch_array($r))
94 {
95 $d = 'SELECT player_id from kz_players_new WHERE authid = "'.$a['authid'].'"';
96 $p = mysql_query($d, $sql);
97 $b = mysql_fetch_array($p, MYSQL_NUM);
98 $player_id = $b[0];
99
100 $d = 'SELECT map_id from kz_map_new WHERE mapname = "'.$a['mapname'].'"';
101 $p = mysql_query($d, $sql);
102 $b = mysql_fetch_array($p, MYSQL_NUM);
103 $map_id = $b[0];
104
105 $e = 'INSERT INTO kz_nub15_new(player_id, map_id, time, date, weapon, checkpoints, gocheck) VALUES("'.$player_id.'", "'.$map_id.'", "'.$a['time'].'", "'.$a['date'].'", "'.$a['weapon'].'", "'.$a['checkpoints'].'", "'.$a['gocheck'].'")';
106 echo $e;
107 $er = mysql_query($e, $sql);
108 mysql_fetch_array($er);
109 }
110 }
111
112 Function kz_nub15(){
113 $sql = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Unable to connect to MySQL.");
114 mysql_select_db(DB_NAME, $sql) or die ("Unable to select database.");
115 $tabelamap = "CREATE TABLE IF NOT EXISTS kz_abh15_new (record_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, player_id INT NOT NULL, map_id INT NOT NULL, `time` decimal(65,2) NOT NULL, `date` datetime NOT NULL, `weapon` varchar(64) NOT NULL, `server` varchar(64) NOT NULL,`checkpoints` real NOT NULL, `gocheck` real NOT NULL, INDEX(player_id, map_id),CONSTRAINT KLUCZMAP2 FOREIGN KEY (map_id) REFERENCES kz_map_new(map_id),CONSTRAINT KLUCZGRACZY2 FOREIGN KEY (player_id) REFERENCES kz_players_new(player_id))";
116 $tabelamap1 = mysql_query($tabelamap, $sql);
117 mysql_fetch_array($tabelamap1);
118
119 $q = "Select checkpoints, gocheck, authid, time, weapon, mapname, date from kz_abh";
120 $r = mysql_query($q, $sql);
121
122 while($a = mysql_fetch_array($r))
123 {
124 $d = 'SELECT player_id from kz_players_new WHERE authid = "'.$a['authid'].'"';
125 $p = mysql_query($d, $sql);
126 $b = mysql_fetch_array($p, MYSQL_NUM);
127 $player_id = $b[0];
128
129 $d = 'SELECT map_id from kz_map_new WHERE mapname = "'.$a['mapname'].'"';
130 $p = mysql_query($d, $sql);
131 $b = mysql_fetch_array($p, MYSQL_NUM);
132 $map_id = $b[0];
133
134 $e = 'INSERT INTO kz_abh15_new(player_id, map_id, time, date, weapon, checkpoints, gocheck) VALUES("'.$player_id.'", "'.$map_id.'", "'.$a['time'].'", "'.$a['date'].'", "'.$a['weapon'].'", "'.$a['checkpoints'].'", "'.$a['gocheck'].'")';
135 echo $e;
136 $er = mysql_query($e, $sql);
137 mysql_fetch_array($er);
138 }
139 }
140
141?>