@@ -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); |
@@ -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 | } |
@@ -25,7 +25,7 @@ discard block |
||
25 | 25 | include("../../config/admin.php"); |
26 | 26 | |
27 | 27 | if (empty($catpick)) { |
28 | - $catpick=1; |
|
28 | + $catpick = 1; |
|
29 | 29 | } |
30 | 30 | |
31 | 31 | $SQL = "SELECT website_category_id, website_category_name FROM website_category ORDER BY website_category_name"; |
@@ -35,16 +35,16 @@ discard block |
||
35 | 35 | |
36 | 36 | mysqli_data_seek($linkcategorysql, 0) or die("what happend?"); |
37 | 37 | while (list($category_id, $category_name) = $linkcategorysql->fetch_array(MYSQLI_BOTH)) { |
38 | - if ($category_id==$website_category_id) { |
|
39 | - $selected="SELECTED"; |
|
38 | + if ($category_id == $website_category_id) { |
|
39 | + $selected = "SELECTED"; |
|
40 | 40 | } else { |
41 | - $selected=""; |
|
41 | + $selected = ""; |
|
42 | 42 | } |
43 | 43 | |
44 | - if ($catpick==$category_id) { |
|
45 | - $selected="SELECTED"; |
|
44 | + if ($catpick == $category_id) { |
|
45 | + $selected = "SELECTED"; |
|
46 | 46 | } else { |
47 | - $selected=""; |
|
47 | + $selected = ""; |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | $smarty->append('category', array( |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | } |
55 | 55 | |
56 | 56 | if (isset($catpick)) { |
57 | - $website_category_id=$catpick; |
|
57 | + $website_category_id = $catpick; |
|
58 | 58 | } |
59 | 59 | |
60 | 60 | $LINKSQL = $mysqli->query("SELECT * FROM website |
@@ -32,11 +32,11 @@ |
||
32 | 32 | |
33 | 33 | $rowlink= $LINKSQL->fetch_array(MYSQLI_BOTH); |
34 | 34 | |
35 | - $website_image = $website_image_path; |
|
36 | - $website_image .= $rowlink['website_id']; |
|
37 | - $website_image .= "."; |
|
38 | - $website_image .= $rowlink['website_imgext']; |
|
39 | - $website_description_text = trim($rowlink['description']); |
|
35 | + $website_image = $website_image_path; |
|
36 | + $website_image .= $rowlink['website_id']; |
|
37 | + $website_image .= "."; |
|
38 | + $website_image .= $rowlink['website_imgext']; |
|
39 | + $website_description_text = trim($rowlink['description']); |
|
40 | 40 | |
41 | 41 | $smarty->assign('website', array( |
42 | 42 | 'website_name' => $rowlink['website_name'], |
@@ -30,7 +30,7 @@ discard block |
||
30 | 30 | WHERE website.website_id='$website_id'") |
31 | 31 | or die("Error while querying the links database"); |
32 | 32 | |
33 | -$rowlink= $LINKSQL->fetch_array(MYSQLI_BOTH); |
|
33 | +$rowlink = $LINKSQL->fetch_array(MYSQLI_BOTH); |
|
34 | 34 | |
35 | 35 | $website_image = $website_image_path; |
36 | 36 | $website_image .= $rowlink['website_id']; |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | $smarty->assign('nr_of_cats', $nr_of_cats); |
68 | 68 | |
69 | 69 | // Do the category selector |
70 | -$RESULT=$mysqli->query("SELECT * FROM website_category ORDER BY website_category_name"); |
|
70 | +$RESULT = $mysqli->query("SELECT * FROM website_category ORDER BY website_category_name"); |
|
71 | 71 | |
72 | 72 | while ($rowlinkcat = $RESULT->fetch_array(MYSQLI_BOTH)) { |
73 | 73 | $smarty->append('category', array( |
@@ -72,4 +72,4 @@ |
||
72 | 72 | } |
73 | 73 | |
74 | 74 | //Send all smarty variables to the templates |
75 | -$smarty->display("file:" . $cpanel_template_folder . "links/link_addnew.html"); |
|
75 | +$smarty->display("file:".$cpanel_template_folder."links/link_addnew.html"); |