· 5 years ago · Jun 13, 2020, 10:42 AM
1<?php
2 ini_set('display_errors', 1);
3 define("DB_HOST", "sql.pukawka.pl");
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
10 Function kz_players(){
11 $sql = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Unable to connect to MySQL.");
12 mysql_select_db(DB_NAME, $sql) or die ("Unable to select database.");
13 $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))";
14 $tabelagraczy1 = mysql_query($tabelagraczy, $sql);
15 mysql_fetch_array($tabelagraczy1);
16
17 $q = "Select DISTINCT authid from kz_pro15 UNION select DISTINCT authid from kz_nub15 UNION select DISTINCT authid from kz_abh";
18 $r = mysql_query($q, $sql);
19
20 while($a = mysql_fetch_array($r))
21 {
22 $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';
23 $p = mysql_query($d, $sql);
24 $b = mysql_fetch_array($p);
25
26 $e = 'INSERT INTO kz_players_new(authid, name, country, lastseen) VALUES("'.$b['authid'].'", "'.$b['name'].'", "'.$b['country'].'", "'.$b['date'].'")';
27 $er = mysql_query($e, $sql);
28 while(mysql_fetch_array($er));
29 }
30 }
31
32 //kz_map(); //przenosi informacje o mapach ze starego formatu bazy do nowego
33
34 Function kz_map(){
35 $sql = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Unable to connect to MySQL.");
36 mysql_select_db(DB_NAME, $sql) or die ("Unable to select database.");
37 $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)";
38 $tabelamap1 = mysql_query($tabelamap, $sql);
39 $wyslij = mysql_fetch_array($tabelamap1);
40
41 $q = "Select DISTINCT mapname from kz_pro15 UNION select DISTINCT mapname from kz_nub15 UNION select DISTINCT mapname from kz_abh";
42 $r = mysql_query($q, $sql);
43
44 while($a = mysql_fetch_array($r))
45 {
46 $e = 'INSERT INTO kz_map_new(mapname) VALUES("'.$a['mapname'].'")';
47 $er = mysql_query($e, $sql);
48 while(mysql_fetch_array($er));
49 }
50 }
51
52 kz_pro15(); //przenosi informacje o rekordach pro ze starego formatu bazy do nowego
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 $wyslij = 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);
69 $player_id = $b['$player_id'];
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);
74 $map_id = $b['$map_id'];
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 $er = mysql_query($e, $sql);
78 mysql_fetch_array($er);
79 }
80 }
81?>