@@ -8,7 +8,7 @@ discard block |
||
8 | 8 | ) ENGINE=InnoDB |
9 | 9 | CHARSET=utf8 |
10 | 10 | COMMENT 'Laravel DB migrations'") |
11 | - or die("Unable to create migrations table: " . $mysqli->error); |
|
11 | + or die("Unable to create migrations table: ".$mysqli->error); |
|
12 | 12 | |
13 | 13 | $mysqli->query("INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES |
14 | 14 | (1, '2020_10_17_161643_create_andreas_table', 1), |
@@ -221,4 +221,4 @@ discard block |
||
221 | 221 | (208, '2020_10_17_161644_add_foreign_keys_to_game_table', 1), |
222 | 222 | (209, '2020_10_17_161644_add_foreign_keys_to_media_scan_table', 1), |
223 | 223 | (210, '2020_10_17_161644_add_foreign_keys_to_media_table', 1);") |
224 | - or die("Unable to insert migrations: " . $mysqli->error); |
|
224 | + or die("Unable to insert migrations: ".$mysqli->error); |
@@ -247,4 +247,4 @@ |
||
247 | 247 | mysqli_commit($mysqli) or die("Unable to commit transaction: ".$mysqli->error); |
248 | 248 | |
249 | 249 | //Send all smarty variables to the templates |
250 | -$smarty->display("file:" . $cpanel_template_folder . "administration/database_update.html"); |
|
250 | +$smarty->display("file:".$cpanel_template_folder."administration/database_update.html"); |
@@ -42,4 +42,4 @@ |
||
42 | 42 | } |
43 | 43 | |
44 | 44 | //Send all smarty variables to the templates |
45 | -$smarty->display("file:" . $cpanel_template_folder . "administration/bug_report.html"); |
|
45 | +$smarty->display("file:".$cpanel_template_folder."administration/bug_report.html"); |
@@ -53,4 +53,4 @@ |
||
53 | 53 | )); |
54 | 54 | |
55 | 55 | //Send all smarty variables to the templates |
56 | -$smarty->display("file:" . $cpanel_template_folder . "administration/ajax_comments.html"); |
|
56 | +$smarty->display("file:".$cpanel_template_folder."administration/ajax_comments.html"); |
@@ -62,7 +62,7 @@ discard block |
||
62 | 62 | LEFT JOIN users on (interview_main.user_id = users.user_id) |
63 | 63 | LEFT JOIN individuals on (interview_main.ind_id = individuals.ind_id) |
64 | 64 | LEFT JOIN individual_text on (interview_main.ind_id = individual_text.ind_id) |
65 | - ORDER BY interview_text.interview_date DESC LIMIT " . $v_counter . ", 5") |
|
65 | + ORDER BY interview_text.interview_date DESC LIMIT " . $v_counter.", 5") |
|
66 | 66 | or die("Error - Couldn't query interview data"); |
67 | 67 | |
68 | 68 | while ($query_interview = $sql_interview->fetch_array(MYSQLI_BOTH)) { |
@@ -112,13 +112,13 @@ discard block |
||
112 | 112 | //Check if back arrow is needed |
113 | 113 | if ($v_counter > 0) { |
114 | 114 | // Build the link |
115 | - $v_linkback = ('?v_counter=' . ($v_counter - 5)); |
|
115 | + $v_linkback = ('?v_counter='.($v_counter - 5)); |
|
116 | 116 | } |
117 | 117 | |
118 | 118 | //Check if we need to place a next arrow |
119 | 119 | if ($v_rows > ($v_counter + 5)) { |
120 | 120 | //Build the link |
121 | - $v_linknext = ('?v_counter=' . ($v_counter + 5)); |
|
121 | + $v_linknext = ('?v_counter='.($v_counter + 5)); |
|
122 | 122 | } |
123 | 123 | |
124 | 124 | if (empty($c_counter)) { |
@@ -141,7 +141,7 @@ discard block |
||
141 | 141 | $smarty->assign("user_id", $_SESSION['user_id']); |
142 | 142 | |
143 | 143 | //Send all smarty variables to the templates |
144 | -$smarty->display("file:" . $cpanel_template_folder . "interviews/interviews_main.html"); |
|
144 | +$smarty->display("file:".$cpanel_template_folder."interviews/interviews_main.html"); |
|
145 | 145 | |
146 | 146 | //close the connection |
147 | 147 | mysqli_close($mysqli); |
@@ -37,4 +37,4 @@ |
||
37 | 37 | } |
38 | 38 | |
39 | 39 | //Send all smarty variables to the templates |
40 | -$smarty->display("file:" . $cpanel_template_folder . "trivia/did_you_know.html"); |
|
40 | +$smarty->display("file:".$cpanel_template_folder."trivia/did_you_know.html"); |
@@ -33,4 +33,4 @@ |
||
33 | 33 | } |
34 | 34 | |
35 | 35 | //Send all smarty variables to the templates |
36 | -$smarty->display("file:" . $cpanel_template_folder . "trivia/manage_trivia_quotes.html"); |
|
36 | +$smarty->display("file:".$cpanel_template_folder."trivia/manage_trivia_quotes.html"); |
@@ -46,7 +46,7 @@ discard block |
||
46 | 46 | // Delete did you know quote! |
47 | 47 | //**************************************************************************************** |
48 | 48 | if (isset($action) and $action == "did_you_know_delete") { |
49 | - if ($_SESSION['permission']==1 or $_SESSION['permission']=='1') { |
|
49 | + if ($_SESSION['permission'] == 1 or $_SESSION['permission'] == '1') { |
|
50 | 50 | create_log_entry('Trivia', $trivia_id, 'DYK', $trivia_id, 'Delete', $_SESSION['user_id']); |
51 | 51 | |
52 | 52 | $sql = $mysqli->query("DELETE FROM trivia WHERE trivia_id = '$trivia_id'") |
@@ -77,14 +77,14 @@ discard block |
||
77 | 77 | $smarty->assign('smarty_action', 'delete_did_you_know'); |
78 | 78 | |
79 | 79 | //Send to smarty for return value |
80 | - $smarty->display("file:" . $cpanel_template_folder . "trivia/ajax_trivia_quotes_edit.html"); |
|
80 | + $smarty->display("file:".$cpanel_template_folder."trivia/ajax_trivia_quotes_edit.html"); |
|
81 | 81 | } |
82 | 82 | |
83 | 83 | //**************************************************************************************** |
84 | 84 | // Delete trivia quote! |
85 | 85 | //**************************************************************************************** |
86 | 86 | if (isset($action) and $action == "delete_trivia_quote") { |
87 | - if ($_SESSION['permission']==1 or $_SESSION['permission']=='1') { |
|
87 | + if ($_SESSION['permission'] == 1 or $_SESSION['permission'] == '1') { |
|
88 | 88 | create_log_entry('Trivia', $trivia_quote_id, 'Quote', $trivia_quote_id, 'Delete', $_SESSION['user_id']); |
89 | 89 | |
90 | 90 | $sql = $mysqli->query("DELETE FROM trivia_quotes WHERE trivia_quote_id = '$trivia_quote_id'") |
@@ -113,7 +113,7 @@ discard block |
||
113 | 113 | $smarty->assign('smarty_action', 'delete_trivia_quote'); |
114 | 114 | |
115 | 115 | //Send to smarty for return value |
116 | - $smarty->display("file:" . $cpanel_template_folder . "trivia/ajax_trivia_quotes_edit.html"); |
|
116 | + $smarty->display("file:".$cpanel_template_folder."trivia/ajax_trivia_quotes_edit.html"); |
|
117 | 117 | } |
118 | 118 | |
119 | 119 | //**************************************************************************************** |
@@ -126,7 +126,7 @@ discard block |
||
126 | 126 | $trivia_quote = $mysqli->real_escape_string($trivia_quote); |
127 | 127 | |
128 | 128 | $mysqli->query("INSERT INTO trivia_quotes (trivia_quote) VALUES ('$trivia_quote')") |
129 | - or die('Error: ' . mysqli_error($mysqli)); |
|
129 | + or die('Error: '.mysqli_error($mysqli)); |
|
130 | 130 | |
131 | 131 | $new_trivia_id = $mysqli->insert_id; |
132 | 132 | create_log_entry('Trivia', $new_trivia_id, 'Quote', $new_trivia_id, 'Insert', $_SESSION['user_id']); |
@@ -142,11 +142,11 @@ discard block |
||
142 | 142 | //**************************************************************************************** |
143 | 143 | if (isset($action) and $action == "edit_trivia_quote") { |
144 | 144 | if (isset($trivia_text)) { |
145 | - if ($_SESSION['permission']==1 or $_SESSION['permission']=='1') { |
|
145 | + if ($_SESSION['permission'] == 1 or $_SESSION['permission'] == '1') { |
|
146 | 146 | $trivia_quote = $mysqli->real_escape_string($trivia_text); |
147 | 147 | |
148 | 148 | $mysqli->query("UPDATE trivia_quotes SET trivia_quote='$trivia_quote' |
149 | - WHERE trivia_quote_id = $trivia_quote_id") or die('Error: ' . mysqli_error($mysqli)); |
|
149 | + WHERE trivia_quote_id = $trivia_quote_id") or die('Error: '.mysqli_error($mysqli)); |
|
150 | 150 | |
151 | 151 | create_log_entry('Trivia', $trivia_quote_id, 'Quote', $trivia_quote_id, 'Edit', $_SESSION['user_id']); |
152 | 152 | |
@@ -168,7 +168,7 @@ discard block |
||
168 | 168 | |
169 | 169 | $smarty->assign('smarty_action', 'trivia_quote_update_returnview'); |
170 | 170 | //Send all smarty variables to the templates |
171 | - $smarty->display("file:" . $cpanel_template_folder . "trivia/ajax_trivia_quotes_edit.html"); |
|
171 | + $smarty->display("file:".$cpanel_template_folder."trivia/ajax_trivia_quotes_edit.html"); |
|
172 | 172 | } |
173 | 173 | } |
174 | 174 | |
@@ -177,11 +177,11 @@ discard block |
||
177 | 177 | //**************************************************************************************** |
178 | 178 | if (isset($action) and $action == "update_trivia") { |
179 | 179 | if (isset($trivia_text)) { |
180 | - if ($_SESSION['permission']==1 or $_SESSION['permission']=='1') { |
|
180 | + if ($_SESSION['permission'] == 1 or $_SESSION['permission'] == '1') { |
|
181 | 181 | $trivia_text = $mysqli->real_escape_string($trivia_text); |
182 | 182 | |
183 | 183 | $mysqli->query("UPDATE trivia SET trivia_text='$trivia_text' WHERE trivia_id = $trivia_id") |
184 | - or die('Error: ' . mysqli_error($mysqli)); |
|
184 | + or die('Error: '.mysqli_error($mysqli)); |
|
185 | 185 | |
186 | 186 | create_log_entry('Trivia', $trivia_id, 'Quote', $trivia_id, 'Edit', $_SESSION['user_id']); |
187 | 187 | $osd_message = "Trivia quote updated"; |
@@ -205,7 +205,7 @@ discard block |
||
205 | 205 | |
206 | 206 | $smarty->assign('smarty_action', 'did_you_know_update_returnview'); |
207 | 207 | //Send all smarty variables to the templates |
208 | - $smarty->display("file:" . $cpanel_template_folder . "trivia/ajax_trivia_quotes_edit.html"); |
|
208 | + $smarty->display("file:".$cpanel_template_folder."trivia/ajax_trivia_quotes_edit.html"); |
|
209 | 209 | } |
210 | 210 | } |
211 | 211 | |
@@ -214,10 +214,10 @@ discard block |
||
214 | 214 | //**************************************************************************************** |
215 | 215 | if ($action == "spotlight_delete") { |
216 | 216 | if (isset($spotlight_id)) { |
217 | - if ($_SESSION['permission']==1 or $_SESSION['permission']=='1') { |
|
217 | + if ($_SESSION['permission'] == 1 or $_SESSION['permission'] == '1') { |
|
218 | 218 | //Let's get the screenshot id |
219 | 219 | $query_spotlight_screenshot = $mysqli->query("SELECT * FROM spotlight |
220 | - WHERE spotlight_id = " . $spotlight_id . "") |
|
220 | + WHERE spotlight_id = " . $spotlight_id."") |
|
221 | 221 | or die("something is wrong with mysqli of spotlight screenshots"); |
222 | 222 | |
223 | 223 | while ($sql_spotlight_screenshot = $query_spotlight_screenshot->fetch_array(MYSQLI_BOTH)) { |
@@ -275,7 +275,7 @@ discard block |
||
275 | 275 | $smarty->assign('smarty_action', 'delete_spotlight'); |
276 | 276 | |
277 | 277 | //Send to smarty for return value |
278 | - $smarty->display("file:" . $cpanel_template_folder . "trivia/ajax_trivia_quotes_edit.html"); |
|
278 | + $smarty->display("file:".$cpanel_template_folder."trivia/ajax_trivia_quotes_edit.html"); |
|
279 | 279 | } |
280 | 280 | } |
281 | 281 | |
@@ -372,11 +372,11 @@ discard block |
||
372 | 372 | //**************************************************************************************** |
373 | 373 | if (isset($action) and $action == "update_spotlight") { |
374 | 374 | if (isset($spot_text)) { |
375 | - if ($_SESSION['permission']==1 or $_SESSION['permission']=='1') { |
|
375 | + if ($_SESSION['permission'] == 1 or $_SESSION['permission'] == '1') { |
|
376 | 376 | $trivia_text = $mysqli->real_escape_string($spot_text); |
377 | 377 | |
378 | 378 | $mysqli->query("UPDATE spotlight SET spotlight='$trivia_text' WHERE spotlight_id = $spotlight_id") |
379 | - or die('Error: ' . mysqli_error($mysqli)); |
|
379 | + or die('Error: '.mysqli_error($mysqli)); |
|
380 | 380 | |
381 | 381 | create_log_entry('Trivia', $spotlight_id, 'Spotlight', $spotlight_id, 'Edit', $_SESSION['user_id']); |
382 | 382 | |
@@ -408,6 +408,6 @@ discard block |
||
408 | 408 | |
409 | 409 | $smarty->assign('smarty_action', 'spotlight_update_returnview'); |
410 | 410 | //Send all smarty variables to the templates |
411 | - $smarty->display("file:" . $cpanel_template_folder . "trivia/ajax_trivia_quotes_edit.html"); |
|
411 | + $smarty->display("file:".$cpanel_template_folder."trivia/ajax_trivia_quotes_edit.html"); |
|
412 | 412 | } |
413 | 413 | } |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | |
27 | 27 | $smarty->assign('smarty_action', 'trivia_quote_edit'); |
28 | 28 | //Send all smarty variables to the templates |
29 | - $smarty->display("file:" . $cpanel_template_folder . "trivia/ajax_trivia_quotes_edit.html"); |
|
29 | + $smarty->display("file:".$cpanel_template_folder."trivia/ajax_trivia_quotes_edit.html"); |
|
30 | 30 | } |
31 | 31 | |
32 | 32 | if (isset($trivia_quote_id) and $action == "display_trivia_quoute") { |
@@ -39,7 +39,7 @@ discard block |
||
39 | 39 | |
40 | 40 | $smarty->assign('smarty_action', 'display_trivia_quoute'); |
41 | 41 | //Send all smarty variables to the templates |
42 | - $smarty->display("file:" . $cpanel_template_folder . "trivia/ajax_trivia_quotes_edit.html"); |
|
42 | + $smarty->display("file:".$cpanel_template_folder."trivia/ajax_trivia_quotes_edit.html"); |
|
43 | 43 | } |
44 | 44 | |
45 | 45 | if (isset($trivia_id) and $action == "did_you_know_edit_view") { |
@@ -50,7 +50,7 @@ discard block |
||
50 | 50 | |
51 | 51 | $smarty->assign('smarty_action', 'did_you_know_edit_view'); |
52 | 52 | //Send all smarty variables to the templates |
53 | - $smarty->display("file:" . $cpanel_template_folder . "trivia/ajax_trivia_quotes_edit.html"); |
|
53 | + $smarty->display("file:".$cpanel_template_folder."trivia/ajax_trivia_quotes_edit.html"); |
|
54 | 54 | } |
55 | 55 | |
56 | 56 | if (isset($spotlight_id) and $action == "spotlight_edit_view") { |
@@ -75,5 +75,5 @@ discard block |
||
75 | 75 | |
76 | 76 | $smarty->assign('smarty_action', 'spotlight_edit_view'); |
77 | 77 | //Send all smarty variables to the templates |
78 | - $smarty->display("file:" . $cpanel_template_folder . "trivia/ajax_trivia_quotes_edit.html"); |
|
78 | + $smarty->display("file:".$cpanel_template_folder."trivia/ajax_trivia_quotes_edit.html"); |
|
79 | 79 | } |