cherryrep/functions.php at master · xtomflo/cherryrep · GitHub

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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
<?php

function get_offers($db) {
    $sql = 'SELECT dzialki.id, planety.nazwa as "nazwa_planety", kategorie_dzialek.nazwa as "nazwa_kategorii", dzialki.ilosc
	FROM dzialki
	INNER JOIN planety
	ON dzialki.fk_id_planety=planety.id
	INNER JOIN kategorie_dzialek
	ON  dzialki.fk_id_kategorii=kategorie_dzialek.id';

	if(!$result = $db->query($sql)){
					die('There was an error running the query [' . $db->error . ']');
				}

	$data = mysqli_fetch_all($result,MYSQLI_ASSOC);
	$result->free();
    return $data;
}

function get_offers_for_single_planet($db, $planet_id) {
    $sql = 'SELECT dzialki.id, planety.nazwa as "nazwa_planety", kategorie_dzialek.nazwa as "nazwa_kategorii", dzialki.ilosc
	FROM dzialki
	INNER JOIN planety
	ON dzialki.fk_id_planety=planety.id
	INNER JOIN kategorie_dzialek
	ON  dzialki.fk_id_kategorii=kategorie_dzialek.id
    WHERE planety.id = '.$planet_id;

	if(!$result = $db->query($sql)){
					die('There was an error running the query [' . $db->error . ']');
				}

	$data = mysqli_fetch_all($result,MYSQLI_ASSOC);
	$result->free();
    return $data;
}

function get_number_of_buyouts($db, $id) {
    $sql = 'SELECT IFNULL(SUM(ilosc),0) as number FROM kupione_dzialki k WHERE k.fk_id_dzialki = '.$id;

	if(!$result = $db->query($sql)){
					die('There was an error running the query [' . $db->error . ']');
				}

	$data = mysqli_fetch_all($result,MYSQLI_ASSOC);
	$result->free();
    return $data[0]['number'];
}

function delete_buyout($db, $password) {
    $sql = 'DELETE FROM kupione_dzialki WHERE haslo = SHA1("'.$password.'")';
	return $db->query($sql);
}

function get_planet_names($db) {
    $sql = 'SELECT id, nazwa FROM planety';

	if(!$result = $db->query($sql)){
					die('There was an error running the query [' . $db->error . ']');
				}

	$data = mysqli_fetch_all($result,MYSQLI_ASSOC);
	$result->free();
    return $data;
}

function buy_things($db, $imie, $nazwisko, $haslo, $id_dzialki, $ilosc) {
    $sql = 'INSERT INTO kupione_dzialki (id, imie, nazwisko, haslo, fk_id_dzialki, ilosc)
	VALUES (NULL, "'.$imie.'", "'.$nazwisko.'", SHA1("'.$haslo.'"), "'.$id_dzialki.'", "'.$ilosc.'")';
	return $db->query($sql);
}

function get_categories_prices($db) {
    $sql = 'SELECT nazwa, cena FROM kategorie_dzialek';

	if(!$result = $db->query($sql)){
					die('There was an error running the query [' . $db->error . ']');
				}

	$data = mysqli_fetch_all($result,MYSQLI_ASSOC);
	$result->free();
    return $data;
}

function get_number_of_all_buyouts($db) {
    $sql = 'SELECT SUM(ilosc) as "suma" FROM kupione_dzialki';

	if(!$result = $db->query($sql)){
					die('There was an error running the query [' . $db->error . ']');
				}

	$data = mysqli_fetch_all($result,MYSQLI_ASSOC);
	$result->free();
    return $data[0]['suma'];
}

function get_planet_with_most_plots($db){
	$sql = 'SELECT planety.nazwa, sum(ilosc) as "suma"
			FROM dzialki
			INNER JOIN planety
			ON dzialki.fk_id_planety = planety.id
			GROUP BY fk_id_planety
			ORDER BY suma DESC
			LIMIT 1';

	if(!$result = $db->query($sql)){
					die('There was an error running the query [' . $db->error . ']');
				}

	$data = mysqli_fetch_all($result,MYSQLI_ASSOC);
	$result->free();
    return $data[0];
}

function get_planet_with_most_luxuty_plots($db){
	$sql = 'SELECT planety.nazwa, sum(ilosc) as "suma"
			FROM dzialki
			INNER JOIN planety
			ON dzialki.fk_id_planety = planety.id
			WHERE dzialki.fk_id_kategorii = 3
			GROUP BY fk_id_planety
			ORDER BY suma DESC
			LIMIT 1';

	if(!$result = $db->query($sql)){
					die('There was an error running the query [' . $db->error . ']');
				}

	$data = mysqli_fetch_all($result,MYSQLI_ASSOC);
	$result->free();
    return $data[0];
}

function get_most_popular_plot_type($db){
	$sql = 'SELECT kategorie_dzialek.nazwa, SUM(kupione_dzialki.ilosc) as "suma" FROM kupione_dzialki
			INNER JOIN dzialki
			ON kupione_dzialki.fk_id_dzialki = dzialki.id
			INNER JOIN kategorie_dzialek
			ON dzialki.fk_id_kategorii = kategorie_dzialek.id
			GROUP BY dzialki.fk_id_kategorii
			ORDER BY SUM(kupione_dzialki.ilosc) DESC
			LIMIT 1';

	if(!$result = $db->query($sql)){
					die('There was an error running the query [' . $db->error . ']');
				}

	$data = mysqli_fetch_all($result,MYSQLI_ASSOC);
	$result->free();
    return $data[0]['nazwa'];
}

?>