PPNQVi4j

1<?php
2
3function towns($world){
4    $servername = "10.3.1.180";
5$username = "*****";
6$password = "*******";
7$dbname = "******";
8
9// Create connection
10$conn = new mysqli($servername, $username, $password, $dbname);
11
12
13if ($conn->connect_error) {
14    die("Connection failed: " . $conn->connect_error);
15}
16
17$sql ="CREATE TABLE IF NOT EXISTS `GREP_".$world."towns` (
18  `id` int(11) DEFAULT NULL,
19  `playerid` int(11) COLLATE utf8_unicode_ci DEFAULT NULL,
20  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
21  `x` int(11) DEFAULT NULL,
22  `y` int(11) DEFAULT NULL,
23  `islandNo` int(11) DEFAULT NULL,
24  `points` int(11) DEFAULT NULL,
25  PRIMARY KEY (id),
26  INDEX (x),
27INDEX (y),
28  FOREIGN KEY(playerid) REFERENCES GREP_".$world."players(id),
29  FOREIGN KEY(x) REFERENCES GREP_".$world."islands(x),
30  FOREIGN KEY(y) REFERENCES GREP_".$world."islands(y)
31);";/*,
32  */
33
34if ($conn->query($sql) === TRUE) {
35    echo "New record created successfully";
36} else {
37    echo "Error: " . $sql . "<br>" . $conn->error;
38}
39
40$query = mysqli_query($conn, "SELECT * FROM GREP_".$world."towns WHERE id=0");
41if(mysqli_num_rows($query) > 0){
42    echo 'exists';
43}else{
44    $sql = "INSERT INTO GREP_".$world."towns (id,playerid,name,x,y,islandNo,points)VALUES(0,0,null,null,null,null,null)";
45    if ($conn->query($sql) === TRUE) {
46   // echo "New record created successfully";
47} else {
48    echo "Error: " . $sql . "<br>" . $conn->error;
49}
50}
51
52
53
54$lines = gzfile('https://'.$world.'.grepolis.com/data/towns.txt.gz');
55if(!is_array($lines)) die("Data couldn't be found");
56foreach($lines as $line) { list($id,$playerid, $name,$x, $y, $islandNo, $points) = explode(',', $line);
57
58$name = urldecode($name);
59$name = addslashes($name);
60if(empty($playerid)){
61    $playerid = 0;
62}
63
64
65$sql ="INSERT INTO GREP_".$world."towns (id,playerid,name,x,y,islandNo,points) VALUES ('$id','$playerid','$name','$x','$y','$islandNo','$points') ON DUPLICATE KEY UPDATE playerid = '$playerid', name = '$name',x = '$x',y = '$y',islandNo = '$islandNo' , points = '$points'";
66
67if ($conn->query($sql) === TRUE) {
68    echo "New record created successfully";
69} else {
70    echo "Error: " . $sql . "<br>" . $conn->error;
71}
72                         }
73$conn->close();
74
75}
76
77
78
79
80?>