@@ -111,7 +111,7 @@ discard block |
||
| 111 | 111 | mysqli_free_result($sql); |
| 112 | 112 | |
| 113 | 113 | // START - NUMBER OF reviews |
| 114 | -$sql = $mysqli->query("SELECT * FROM review_main |
|
| 114 | +$sql = $mysqli->query("SELECT * FROM review_main |
|
| 115 | 115 | LEFT JOIN review_game ON (review_main.review_id = review_game.review_id) |
| 116 | 116 | LEFT JOIN game ON ( review_game.game_id = game.game_id ) |
| 117 | 117 | WHERE review_main.user_id = $user_id_selected"); |
@@ -198,7 +198,7 @@ discard block |
||
| 198 | 198 | $smarty->assign('user_id_selected', $user_id_selected); |
| 199 | 199 | |
| 200 | 200 | //Send all smarty variables to the templates |
| 201 | -$smarty->display("file:" . $cpanel_template_folder . "user/user_statistics.html"); |
|
| 201 | +$smarty->display("file:".$cpanel_template_folder."user/user_statistics.html"); |
|
| 202 | 202 | |
| 203 | 203 | //close the connection |
| 204 | 204 | mysqli_close($mysqli); |
@@ -238,4 +238,4 @@ |
||
| 238 | 238 | $smarty->assign('nr_users_total', $v_rows); |
| 239 | 239 | |
| 240 | 240 | //Send all smarty variables to the templates |
| 241 | -$smarty->display("file:" . $cpanel_template_folder . "user/user_management.html"); |
|
| 241 | +$smarty->display("file:".$cpanel_template_folder."user/user_management.html"); |
|
@@ -12,9 +12,9 @@ |
||
| 12 | 12 | * - user search field now working |
| 13 | 13 | * |
| 14 | 14 | ***************************************************************************/ |
| 15 | - include("../../config/common.php"); |
|
| 16 | - include("../../admin/games/quick_search_games.php"); |
|
| 17 | - include("../../config/admin.php"); |
|
| 15 | + include("../../config/common.php"); |
|
| 16 | + include("../../admin/games/quick_search_games.php"); |
|
| 17 | + include("../../config/admin.php"); |
|
| 18 | 18 | |
| 19 | 19 | $start = microtime(true); |
| 20 | 20 | $last_visit_timestamp = date_to_timestamp($Date_Year, $Date_Month, $Date_Day); |
@@ -160,4 +160,4 @@ |
||
| 160 | 160 | $smarty->assign("query_time", $time_elapsed_secs); |
| 161 | 161 | |
| 162 | 162 | //Send all smarty variables to the templates |
| 163 | -$smarty->display("file:" . $cpanel_template_folder . "user/ajax_user_management.html"); |
|
| 163 | +$smarty->display("file:".$cpanel_template_folder."user/ajax_user_management.html"); |
|
@@ -129,7 +129,7 @@ |
||
| 129 | 129 | } |
| 130 | 130 | |
| 131 | 131 | //Send all smarty variables to the templates |
| 132 | -$smarty->display("file:" . $cpanel_template_folder . "user/user_karmasync.html"); |
|
| 132 | +$smarty->display("file:".$cpanel_template_folder."user/user_karmasync.html"); |
|
| 133 | 133 | |
| 134 | 134 | //close the connection |
| 135 | 135 | mysqli_close($mysqli); |
@@ -63,7 +63,7 @@ |
||
| 63 | 63 | } |
| 64 | 64 | |
| 65 | 65 | //Send all smarty variables to the templates |
| 66 | -$smarty->display("file:" . $cpanel_template_folder . "user/user_detail.html"); |
|
| 66 | +$smarty->display("file:".$cpanel_template_folder."user/user_detail.html"); |
|
| 67 | 67 | |
| 68 | 68 | //close the connection |
| 69 | 69 | mysqli_close($mysqli); |
@@ -38,7 +38,7 @@ |
||
| 38 | 38 | $smarty->assign("user_id", $_SESSION['user_id']); |
| 39 | 39 | |
| 40 | 40 | //Send all smarty variables to the templates |
| 41 | -$smarty->display("file:" . $cpanel_template_folder . "company/company_main.html"); |
|
| 41 | +$smarty->display("file:".$cpanel_template_folder."company/company_main.html"); |
|
| 42 | 42 | |
| 43 | 43 | //close the connection |
| 44 | 44 | mysqli_close($mysqli); |
@@ -74,7 +74,7 @@ |
||
| 74 | 74 | $smarty->assign("user_id", $_SESSION['user_id']); |
| 75 | 75 | |
| 76 | 76 | //Send all smarty variables to the templates |
| 77 | - $smarty->display("file:" . $cpanel_template_folder . "company/company_edit.html"); |
|
| 77 | + $smarty->display("file:".$cpanel_template_folder."company/company_edit.html"); |
|
| 78 | 78 | } |
| 79 | 79 | |
| 80 | 80 | //close the connection |
@@ -47,7 +47,7 @@ |
||
| 47 | 47 | $smarty->assign("user_id", $_SESSION['user_id']); |
| 48 | 48 | |
| 49 | 49 | //Send all smarty variables to the templates |
| 50 | -$smarty->display("file:" . $cpanel_template_folder . "company/company_logos.html"); |
|
| 50 | +$smarty->display("file:".$cpanel_template_folder."company/company_logos.html"); |
|
| 51 | 51 | |
| 52 | 52 | //close the connection |
| 53 | 53 | mysqli_close($mysqli); |
@@ -30,7 +30,7 @@ discard block |
||
| 30 | 30 | |
| 31 | 31 | //Lets get all the date of the selected user |
| 32 | 32 | $sql_users = $mysqli->query("SELECT * FROM users |
| 33 | - WHERE user_id = '" . $_SESSION['user_id'] . "' ") or die("Couldn't query users Database"); |
|
| 33 | + WHERE user_id = '" . $_SESSION['user_id']."' ") or die("Couldn't query users Database"); |
|
| 34 | 34 | |
| 35 | 35 | while ($query_users = $sql_users->fetch_array(MYSQLI_BOTH)) { |
| 36 | 36 | $smarty->assign('users', array( |
@@ -61,35 +61,35 @@ discard block |
||
| 61 | 61 | //******************************************// |
| 62 | 62 | |
| 63 | 63 | //* Karma 0 to 100 |
| 64 | -$result = $mysqli->query("SELECT * FROM users WHERE karma > '0' and karma <= '100'") |
|
| 64 | +$result = $mysqli->query("SELECT * FROM users WHERE karma > '0' and karma <= '100'") |
|
| 65 | 65 | or die("error getting karma 0 - 100"); |
| 66 | 66 | $karma = $result->num_rows; |
| 67 | 67 | $karma_good_value[0] = $karma; |
| 68 | 68 | $karma_good_label[0] = "<100"; |
| 69 | 69 | |
| 70 | 70 | //* Karma 100 to 500 |
| 71 | -$result = $mysqli->query("SELECT * FROM users WHERE karma > '100' and karma <= '500'") |
|
| 71 | +$result = $mysqli->query("SELECT * FROM users WHERE karma > '100' and karma <= '500'") |
|
| 72 | 72 | or die("error getting karma 0 - 500"); |
| 73 | 73 | $karma = $result->num_rows; |
| 74 | 74 | $karma_good_value[1] = $karma; |
| 75 | 75 | $karma_good_label[1] = "<500"; |
| 76 | 76 | |
| 77 | 77 | //* Karma 500 to 1000 |
| 78 | -$result = $mysqli->query("SELECT * FROM users WHERE karma > '500' and karma <= '1000'") |
|
| 78 | +$result = $mysqli->query("SELECT * FROM users WHERE karma > '500' and karma <= '1000'") |
|
| 79 | 79 | or die("error getting karma 500 - 2000"); |
| 80 | 80 | $karma = $result->num_rows; |
| 81 | 81 | $karma_good_value[2] = $karma; |
| 82 | 82 | $karma_good_label[2] = "<1000"; |
| 83 | 83 | |
| 84 | 84 | //* Karma 1000 to 2000 |
| 85 | -$result = $mysqli->query("SELECT * FROM users WHERE karma > '1000' and karma <= '2000'") |
|
| 85 | +$result = $mysqli->query("SELECT * FROM users WHERE karma > '1000' and karma <= '2000'") |
|
| 86 | 86 | or die("error getting karma 500 - 2000"); |
| 87 | 87 | $karma = $result->num_rows; |
| 88 | 88 | $karma_good_value[3] = $karma; |
| 89 | 89 | $karma_good_label[3] = "<2000"; |
| 90 | 90 | |
| 91 | 91 | //* Karma > 2000 |
| 92 | -$result = $mysqli->query("SELECT * FROM users WHERE karma > '2000'") |
|
| 92 | +$result = $mysqli->query("SELECT * FROM users WHERE karma > '2000'") |
|
| 93 | 93 | or die("error getting karma > 2000"); |
| 94 | 94 | $karma = $result->num_rows; |
| 95 | 95 | $karma_good_value[4] = $karma; |
@@ -103,35 +103,35 @@ discard block |
||
| 103 | 103 | //******************************************// |
| 104 | 104 | |
| 105 | 105 | //* Karma 0 to -100 |
| 106 | -$result = $mysqli->query("SELECT * FROM users WHERE karma <= '0' and karma >= '-100'") |
|
| 106 | +$result = $mysqli->query("SELECT * FROM users WHERE karma <= '0' and karma >= '-100'") |
|
| 107 | 107 | or die("error getting karma 0 -100"); |
| 108 | 108 | $karma = $result->num_rows; |
| 109 | 109 | $karma_bad_value[0] = $karma; |
| 110 | 110 | $karma_bad_label[0] = ">-100"; |
| 111 | 111 | |
| 112 | 112 | //* Karma -100 to -500 |
| 113 | -$result = $mysqli->query("SELECT * FROM users WHERE karma < '-100' and karma >= '-500'") |
|
| 113 | +$result = $mysqli->query("SELECT * FROM users WHERE karma < '-100' and karma >= '-500'") |
|
| 114 | 114 | or die("error getting karma -100 -500"); |
| 115 | 115 | $karma = $result->num_rows; |
| 116 | 116 | $karma_bad_value[1] = $karma; |
| 117 | 117 | $karma_bad_label[1] = ">-500"; |
| 118 | 118 | |
| 119 | 119 | //* Karma -500 to -1000 |
| 120 | -$result = $mysqli->query("SELECT * FROM users WHERE karma < '-500' and karma >= '-1000'") |
|
| 120 | +$result = $mysqli->query("SELECT * FROM users WHERE karma < '-500' and karma >= '-1000'") |
|
| 121 | 121 | or die("error getting karma -500 -2000"); |
| 122 | 122 | $karma = $result->num_rows; |
| 123 | 123 | $karma_bad_value[2] = $karma; |
| 124 | 124 | $karma_bad_label[2] = ">-1000"; |
| 125 | 125 | |
| 126 | 126 | //* Karma -1000 to -2000 |
| 127 | -$result = $mysqli->query("SELECT * FROM users WHERE karma < '-1000' and karma >= '-2000'") |
|
| 127 | +$result = $mysqli->query("SELECT * FROM users WHERE karma < '-1000' and karma >= '-2000'") |
|
| 128 | 128 | or die("error getting karma -500 -2000"); |
| 129 | 129 | $karma = $result->num_rows; |
| 130 | 130 | $karma_bad_value[3] = $karma; |
| 131 | 131 | $karma_bad_label[3] = ">-2000"; |
| 132 | 132 | |
| 133 | 133 | //* Karma < 2000 |
| 134 | -$result = $mysqli->query("SELECT * FROM users WHERE karma < '-2000'") or die("error getting karma > 2000"); |
|
| 134 | +$result = $mysqli->query("SELECT * FROM users WHERE karma < '-2000'") or die("error getting karma > 2000"); |
|
| 135 | 135 | $karma = $result->num_rows; |
| 136 | 136 | $karma_bad_value[4] = $karma; |
| 137 | 137 | $karma_bad_label[4] = "<-2000"; |
@@ -173,63 +173,63 @@ discard block |
||
| 173 | 173 | // Changes per Section |
| 174 | 174 | //************************************** |
| 175 | 175 | //* Changelog - Games |
| 176 | -$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Games'") |
|
| 176 | +$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Games'") |
|
| 177 | 177 | or die("error getting games from change_log"); |
| 178 | 178 | $change_log = $result->num_rows; |
| 179 | 179 | $change_log_data[0] = $change_log; |
| 180 | 180 | $change_log_label[0] = "Games"; |
| 181 | 181 | |
| 182 | 182 | //* Changelog - Users |
| 183 | -$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Users'") |
|
| 183 | +$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Users'") |
|
| 184 | 184 | or die("error getting Users from change_log"); |
| 185 | 185 | $change_log = $result->num_rows; |
| 186 | 186 | $change_log_data[1] = $change_log; |
| 187 | 187 | $change_log_label[1] = "Users"; |
| 188 | 188 | |
| 189 | 189 | //* Changelog - Links |
| 190 | -$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Links'") |
|
| 190 | +$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Links'") |
|
| 191 | 191 | or die("error getting Links from change_log"); |
| 192 | 192 | $change_log = $result->num_rows; |
| 193 | 193 | $change_log_data[2] = $change_log; |
| 194 | 194 | $change_log_label[2] = "Links"; |
| 195 | 195 | |
| 196 | 196 | //* Changelog - Individuals |
| 197 | -$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Individuals'") |
|
| 197 | +$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Individuals'") |
|
| 198 | 198 | or die("error getting Individuals from change_log"); |
| 199 | 199 | $change_log = $result->num_rows; |
| 200 | 200 | $change_log_data[3] = $change_log; |
| 201 | 201 | $change_log_label[3] = "Individuals"; |
| 202 | 202 | |
| 203 | 203 | //* Changelog - News |
| 204 | -$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'News'") |
|
| 204 | +$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'News'") |
|
| 205 | 205 | or die("error getting News from change_log"); |
| 206 | 206 | $change_log = $result->num_rows; |
| 207 | 207 | $change_log_data[4] = $change_log; |
| 208 | 208 | $change_log_label[4] = "News"; |
| 209 | 209 | |
| 210 | 210 | //* Changelog - Crew |
| 211 | -$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Crew'") |
|
| 211 | +$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Crew'") |
|
| 212 | 212 | or die("error getting Crew from change_log"); |
| 213 | 213 | $change_log = $result->num_rows; |
| 214 | 214 | $change_log_data[5] = $change_log; |
| 215 | 215 | $change_log_label[5] = "Crew"; |
| 216 | 216 | |
| 217 | 217 | //* Changelog - Menu disk |
| 218 | -$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Menu disk'") |
|
| 218 | +$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Menu disk'") |
|
| 219 | 219 | or die("error getting Menu disk from change_log"); |
| 220 | 220 | $change_log = $result->num_rows; |
| 221 | 221 | $change_log_data[6] = $change_log; |
| 222 | 222 | $change_log_label[6] = "Menu disk"; |
| 223 | 223 | |
| 224 | 224 | //* Changelog - Downloads |
| 225 | -$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Downloads'") |
|
| 225 | +$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Downloads'") |
|
| 226 | 226 | or die("error getting Downloads from change_log"); |
| 227 | 227 | $change_log = $result->num_rows; |
| 228 | 228 | $change_log_data[7] = $change_log; |
| 229 | 229 | $change_log_label[7] = "Downloads"; |
| 230 | 230 | |
| 231 | 231 | //* Changelog - Articles |
| 232 | -$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Articles'") |
|
| 232 | +$result = $mysqli->query("SELECT * FROM change_log WHERE section = 'Articles'") |
|
| 233 | 233 | or die("error getting Articles from change_log"); |
| 234 | 234 | $change_log = $result->num_rows; |
| 235 | 235 | $change_log_data[8] = $change_log; |
@@ -247,8 +247,8 @@ discard block |
||
| 247 | 247 | $last_year = date("Y") - 1; |
| 248 | 248 | $current_year = date("Y") - 1; |
| 249 | 249 | $current_day = 01; |
| 250 | -$months = array(1=>'Jan',2=>'Feb',3=>'Mar',4=>'Apr',5=>'May', |
|
| 251 | - 6=>'Jun',7=>'Jul',8=>'Aug',9=>'Sep',10=>'Oct',11=>'Nov',12=>'Dec'); |
|
| 250 | +$months = array(1=>'Jan', 2=>'Feb', 3=>'Mar', 4=>'Apr', 5=>'May', |
|
| 251 | + 6=>'Jun', 7=>'Jul', 8=>'Aug', 9=>'Sep', 10=>'Oct', 11=>'Nov', 12=>'Dec'); |
|
| 252 | 252 | $i = 0; |
| 253 | 253 | |
| 254 | 254 | if ($current_month == 13) { |
@@ -290,7 +290,7 @@ discard block |
||
| 290 | 290 | $date_high = date_to_timestamp($current_year, $current_month, $current_day); |
| 291 | 291 | $date_low = date_to_timestamp($last_year, $last_month, $current_day); |
| 292 | 292 | |
| 293 | - $result_monthly = $mysqli->query("SELECT * FROM change_log |
|
| 293 | + $result_monthly = $mysqli->query("SELECT * FROM change_log |
|
| 294 | 294 | WHERE timestamp >= $date_low and timestamp < $date_high") or die("error getting change_log data"); |
| 295 | 295 | $change_log_monthly = $result_monthly->num_rows; |
| 296 | 296 | $change_log_monthly_data[$i] = $change_log_monthly; |
@@ -314,4 +314,4 @@ discard block |
||
| 314 | 314 | $smarty->assign('change_log_border', json_encode($change_log_border)); |
| 315 | 315 | |
| 316 | 316 | //Send all smarty variables to the templates |
| 317 | -$smarty->display("file:" . $cpanel_template_folder . "administration/start_page.html"); |
|
| 317 | +$smarty->display("file:".$cpanel_template_folder."administration/start_page.html"); |
|