TechWilk / rota

public/old/includes/functions.database.php

Unused Use Statements -2 removed lines

@@ -2,8 +2,6 @@
 
 namespace TechWilk\Rota;
 
-use DateTime;
-
 /*
     This file is part of Church Rota.
 

Spacing +28 added lines, -28 removed lines

@@ -26,14 +26,14 @@ 
 function executeDbSql($sql)
 {
     if (!mysqli_query(db(), $sql)) {
-        die('Error: '.mysqli_error(db()).', SQL: '.$sql);
+        die('Error: ' . mysqli_error(db()) . ', SQL: ' . $sql);
     }
 }
 
 function updateDatabase()
 {
     $sql = 'SELECT VERSION( ) AS mysqli_version';
-    $result = mysqli_query(db(), $sql) or die('MySQL-Error: '.mysqli_error(db()));
+    $result = mysqli_query(db(), $sql) or die('MySQL-Error: ' . mysqli_error(db()));
     $dbv = mysqli_fetch_array($result, MYSQLI_ASSOC);
     $mysqli_version = $dbv['mysqli_version'];
     //echo $mysqli_version."<br>";
@@ -87,41 +87,41 @@ 
             executeDbSql("alter table cr_users add(isOverviewRecipient char(2) NOT NULL DEFAULT '0')");
             executeDbSql('alter table cr_groups add(short_name char(2))');
 
-            executeDbSql("update cr_settings set lang_locale = 'en_GB'");                     // de_DE
+            executeDbSql("update cr_settings set lang_locale = 'en_GB'"); // de_DE
             executeDbSql('update cr_settings set event_sorting_latest = 0');
             executeDbSql('update cr_settings set snapshot_show_two_month = 0');
             executeDbSql('update cr_settings set snapshot_reduce_skills_by_group = 0');
             executeDbSql('update cr_settings set logged_in_show_snapshot_button = 0');
             executeDbSql("update cr_settings set time_format_long = '%A, %B %e @ %I:%M %p'"); // de_DE: %A, %e. %B %Y, %R Uhr, KW%V
             executeDbSql("update cr_settings set time_format_normal = '%m/%d/%y %I:%M %p'"); // de_DE: %d.%m.%Y %H:%M
-            executeDbSql("update cr_settings set time_format_short = '%a, <strong>%b %e</strong>, %I:%M %p'");              // de_DE: %a, <strong>%e. %b</strong>, KW%V
+            executeDbSql("update cr_settings set time_format_short = '%a, <strong>%b %e</strong>, %I:%M %p'"); // de_DE: %a, <strong>%e. %b</strong>, KW%V
             executeDbSql("update cr_settings set version = '2.1.0'");
             executeDbSql('update cr_settings set users_start_with_myevents = 0');
             executeDbSql("update cr_settings set time_zone = 'Europe/London'"); //de_DE: Europe/Berlin
             executeDbSql("update cr_settings set google_group_calendar = ''");
             executeDbSql("update cr_settings set overviewemail = 'Hello,\r\n\r\nIn this email you find the Rota for [MONTH] [YEAR].\r\n\r\n[OVERVIEW]\r\n\r\nPlease inform us as soon as possible, if you are not able to serve as scheduled.\r\n\r\nBe blessed.\r\nChurch Support Stuff'");
 
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.1.0', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.1.0', $_SESSION['userid']);
         case '2.1.0':
             executeDbSql('create table cr_settings_bkp2_1_0 as select * from cr_settings');
             executeDbSql('alter table cr_settings add(group_sorting_name int(1))');
             executeDbSql("update cr_settings set version = '2.1.1'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.1.1', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.1.1', $_SESSION['userid']);
         case '2.1.1':
             executeDbSql("update cr_settings set version = '2.1.2'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.1.2', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.1.2', $_SESSION['userid']);
         case '2.1.2':
             executeDbSql("alter table cr_settings add(debug_mode int(1) DEFAULT '0')");
-            executeDbSql('update cr_settings set group_sorting_name = 0');  //was a workaround, fixed in V2.2.1
+            executeDbSql('update cr_settings set group_sorting_name = 0'); //was a workaround, fixed in V2.2.1
 
             executeDbSql("update cr_settings set version = '2.2.0'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.2.0', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.2.0', $_SESSION['userid']);
         case '2.2.0':
             executeDbSql("alter table cr_users add(isBandAdmin char(2) NOT NULL DEFAULT '0')");
             executeDbSql('update cr_settings set group_sorting_name = 0'); //due to an error reset it again
 
             executeDbSql("update cr_settings set version = '2.2.1'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.2.1', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.2.1', $_SESSION['userid']);
         case '2.2.1':
                 $sql = "CREATE TABLE IF NOT EXISTS `cr_statistics` (
 				  `id` int(11) NOT NULL AUTO_INCREMENT,
@@ -137,21 +137,21 @@ 
             executeDbSql($sql);
 
             executeDbSql("update cr_settings set version = '2.3.0'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.3.0', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.0', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.3.0', $version);
         case '2.3.0':
             executeDbSql("alter table cr_users add(isEventEditor char(2) NOT NULL DEFAULT '0')");
 
             executeDbSql("update cr_settings set version = '2.3.1'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.3.1', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.1', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.3.1', $version);
         case '2.3.1':
             executeDbSql("update cr_settings set version = '2.3.2'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.3.2', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.2', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.3.2', $version);
         case '2.3.2':
             executeDbSql("update cr_settings set version = '2.3.3'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.3.3', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.3', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.3.3', $version);
         case '2.3.3':
             if (substr($mysqli_version, 0, 1) == 5) {
@@ -199,33 +199,33 @@ 
                     );
             }
             executeDbSql("update cr_settings set version = '2.3.4'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.3.4', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.4', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.3.4', $version);
         case '2.3.4':
             executeDbSql("update cr_settings set version = '2.3.5'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.3.5', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.5', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.3.5', $version);
         case '2.3.5':
             executeDbSql("update cr_settings set version = '2.4.0'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.4.0', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.0', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.4.0', $version);
         case '2.4.0':
             executeDbSql("update cr_settings set version = '2.4.1'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.4.1', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.1', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.4.1', $version);
         case '2.4.1':
             executeDbSql('alter table cr_settings add(days_to_alert int(2) DEFAULT 5) ');
             executeDbSql("alter table cr_settings add(token varchar(100) DEFAULT '') ");
             executeDbSql("update cr_settings set version = '2.4.2'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.4.2', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.2', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.4.2', $version);
         case '2.4.2':
             executeDbSql("update cr_settings set version = '2.4.3'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.4.3', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.3', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.4.3', $version);
         case '2.4.3':
             executeDbSql("update cr_settings set version = '2.4.4'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.4.4', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.4', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.4.4', $version);
         case '2.4.4':
             if (substr($mysqli_version, 0, 1) == 5) {
@@ -274,27 +274,27 @@ 
                 );
             }
             executeDbSql("update cr_settings set version = '2.4.5'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.4.5', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.5', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.4.5', $version);
         case '2.4.5':
             executeDbSql("update cr_settings set version = '2.5.0'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.5.0', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.5.0', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.5.0', $version);
         case '2.5.0':
             executeDbSql("update cr_settings set version = '2.5.1'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.5.1', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.5.1', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.5.1', $version);
         case '2.5.1':
             executeDbSql("update cr_settings set version = '2.5.2'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.5.2', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.5.2', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.5.2', $version);
         case '2.5.2':
             executeDbSql("update cr_settings set version = '2.5.3'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.5.3', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.5.3', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.5.3', $version);
         case '2.5.3':
             executeDbSql("update cr_settings set version = '2.6.0'");
-            notifyInfo(__FILE__, 'db-update='.$version.'->2.6.0', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->2.6.0', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '2.6.0', $version);
         case '2.6.0':
             $sql = "ALTER TABLE cr_users
@@ -370,7 +370,7 @@ 
             executeDbSql($sql);
             executeDbSql("update cr_settings set version = '3.0.0-pre1'");
 
-            notifyInfo(__FILE__, 'db-update='.$version.'->3.0.0-pre1', $_SESSION['userid']);
+            notifyInfo(__FILE__, 'db-update=' . $version . '->3.0.0-pre1', $_SESSION['userid']);
             insertStatistics('system', __FILE__, 'db-update', '3.0.0-pre1', $version);
         case '3.0.0-pre1':
             $sql = "CREATE TABLE IF NOT EXISTS cr_notifications (

public/api/v1/index.php

Spacing +31 added lines, -31 removed lines

@@ -23,15 +23,15 @@ 
 // Start of API
 // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
-require_once dirname(__FILE__).'/../../../vendor/autoload.php';
+require_once dirname(__FILE__) . '/../../../vendor/autoload.php';
 
-include_once dirname(__FILE__).'/../../../config/database.php';
+include_once dirname(__FILE__) . '/../../../config/database.php';
 
 // Create and configure Slim app
 $app = new \Slim\App(['settings' => $config]);
 
-spl_autoload_register(function ($classname) {
-    require dirname(__FILE__).'/../../../api-classes/'.$classname.'.php';
+spl_autoload_register(function($classname) {
+    require dirname(__FILE__) . '/../../../api-classes/' . $classname . '.php';
 });
 
 // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@@ -40,7 +40,7 @@ 
 
 $container = $app->getContainer();
 
-$container['db'] = function ($c) {
+$container['db'] = function($c) {
     $db_config = $c['settings']['db'];
     $db = new Database($db_config);
 
@@ -53,7 +53,7 @@ 
 
 // ~~~~~~~~~~~~~~~ Event ~~~~~~~~~~~~~~~
 
-$app->post('/events', function ($request, $response, $args) {
+$app->post('/events', function($request, $response, $args) {
     $postData = $request->getParsedBody();
 
     $name = filter_var($postData['name'], FILTER_SANITIZE_STRING);
@@ -65,7 +65,7 @@ 
     return $response->withJson($data);
 });
 
-$app->get('/events/{id}', function ($request, $response, $args) {
+$app->get('/events/{id}', function($request, $response, $args) {
     $id = filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $event = new Event();
@@ -91,8 +91,8 @@ 
                     'relationships' => [
                                         'series' => [
                                                     'links' => [
-                                                                'self'    => '/events/'.$event->getId().'/relationships/series',
-                                                                'related' => '/events/'.$event->getId().'/series/'.$series->getId(),
+                                                                'self'    => '/events/' . $event->getId() . '/relationships/series',
+                                                                'related' => '/events/' . $event->getId() . '/series/' . $series->getId(),
                                                     ],
                                                     'data' => [
                                                       'type' => 'series',
@@ -101,8 +101,8 @@ 
                                         ],
                                         'types' => [
                                                     'links' => [
-                                                                'self'    => '/events/'.$event->getId().'/relationships/types',
-                                                                'related' => '/events/'.$event->getId().'/types/'.$type->getId(),
+                                                                'self'    => '/events/' . $event->getId() . '/relationships/types',
+                                                                'related' => '/events/' . $event->getId() . '/types/' . $type->getId(),
                                                     ],
                                                     'data' => [
                                                       'type' => 'types',
@@ -111,8 +111,8 @@ 
                                         ],
                                         'sub-types' => [
                                                     'links' => [
-                                                                'self'    => '/events/'.$event->getId().'/relationships/sub-types',
-                                                                'related' => '/events/'.$event->getId().'/sub-types/'.$sub_type->getId(),
+                                                                'self'    => '/events/' . $event->getId() . '/relationships/sub-types',
+                                                                'related' => '/events/' . $event->getId() . '/sub-types/' . $sub_type->getId(),
                                                     ],
                                                     'data' => [
                                                                 'type' => 'sub-types',
@@ -121,8 +121,8 @@ 
                                         ],
                                         'location' => [
                                                     'links' => [
-                                                                'self'    => '/events/'.$event->getId().'/relationships/locations',
-                                                                'related' => '/events/'.$event->getId().'/locations/'.$location->getId(),
+                                                                'self'    => '/events/' . $event->getId() . '/relationships/locations',
+                                                                'related' => '/events/' . $event->getId() . '/locations/' . $location->getId(),
                                                     ],
                                                     'data' => [
                                                                 'type' => 'locations',
@@ -140,7 +140,7 @@ 
                                           'description' => $series->description,
                             ],
                             'links' => [
-                                        'self' => '/series/'.$series->getId(),
+                                        'self' => '/series/' . $series->getId(),
                             ],
                           ],
                           [
@@ -151,7 +151,7 @@ 
                                       'description' => $type->description,
                             ],
                             'links' => [
-                                        'self' => '/types/'.$type->getId(),
+                                        'self' => '/types/' . $type->getId(),
                             ],
                           ],
                           [
@@ -162,7 +162,7 @@ 
                                       'description' => $sub_type->description,
                             ],
                             'links' => [
-                                        'self' => '/sub-types/'.$sub_type->getId(),
+                                        'self' => '/sub-types/' . $sub_type->getId(),
                             ],
                           ],
                           [
@@ -172,7 +172,7 @@ 
                                       'name' => $location->name,
                             ],
                             'links' => [
-                                        'self' => '/locations/'.$location->getId(),
+                                        'self' => '/locations/' . $location->getId(),
                             ],
                           ],
           ],
@@ -186,7 +186,7 @@ 
 
 // ~~~~~~~~~~~~~~~ Series ~~~~~~~~~~~~~~~
 
-$app->post('/series', function ($request, $response, $args) {
+$app->post('/series', function($request, $response, $args) {
     $postData = $request->getParsedBody();
 
     $name = filter_var($postData['name'], FILTER_SANITIZE_STRING);
@@ -209,7 +209,7 @@ 
     return $response->withJson($data);
 });
 
-$app->get('/series/{id}', function ($request, $response, $args) {
+$app->get('/series/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $series = new Series();
@@ -226,7 +226,7 @@ 
     return $response->withJson($data);
 });
 
-$app->delete('/series/{id}', function ($request, $response, $args) {
+$app->delete('/series/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $series = new Series();
@@ -244,7 +244,7 @@ 
 
 // ~~~~~~~~~~~~~~~ Type ~~~~~~~~~~~~~~~
 
-$app->post('/types', function ($request, $response, $args) {
+$app->post('/types', function($request, $response, $args) {
     $postData = $request->getParsedBody();
 
     $name = filter_var($postData['name'], FILTER_SANITIZE_STRING);
@@ -267,7 +267,7 @@ 
     return $response->withJson($data);
 });
 
-$app->get('/types/{id}', function ($request, $response, $args) {
+$app->get('/types/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $type = new Type();
@@ -284,7 +284,7 @@ 
     return $response->withJson($data);
 });
 
-$app->delete('/types/{id}', function ($request, $response, $args) {
+$app->delete('/types/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $type = new Type();
@@ -302,7 +302,7 @@ 
 
 // ~~~~~~~~~~~~~~~ Sub Type ~~~~~~~~~~~~~~~
 
-$app->post('/sub-types', function ($request, $response, $args) {
+$app->post('/sub-types', function($request, $response, $args) {
     $postData = $request->getParsedBody();
 
     $name = filter_var($postData['name'], FILTER_SANITIZE_STRING);
@@ -325,7 +325,7 @@ 
     return $response->withJson($data);
 });
 
-$app->get('/sub-types/{id}', function ($request, $response, $args) {
+$app->get('/sub-types/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $type = new SubType();
@@ -342,7 +342,7 @@ 
     return $response->withJson($data);
 });
 
-$app->delete('/sub-types/{id}', function ($request, $response, $args) {
+$app->delete('/sub-types/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $type = new SubType();
@@ -360,7 +360,7 @@ 
 
 // ~~~~~~~~~~~~~~~ Location ~~~~~~~~~~~~~~~
 
-$app->post('/locations', function ($request, $response, $args) {
+$app->post('/locations', function($request, $response, $args) {
     $postData = $request->getParsedBody();
 
     $name = filter_var($postData['name'], FILTER_SANITIZE_STRING);
@@ -380,7 +380,7 @@ 
     return $response->withJson($data);
 });
 
-$app->get('/locations/{id}', function ($request, $response, $args) {
+$app->get('/locations/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $location = new Location();
@@ -396,7 +396,7 @@ 
     return $response->withJson($data);
 });
 
-$app->delete('/locations/{id}', function ($request, $response, $args) {
+$app->delete('/locations/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $location = new Location();

public/plugins/datatables/extensions/Scroller/examples/data/ssp.php

Spacing +5 added lines, -5 removed lines

@@ -29,11 +29,11 @@
 // parameter represents the DataTables column identifier. In this case simple
 // indexes
 $columns = [
-    ['db' => 'id',         'dt' => 0],
-    ['db' => 'firstname',  'dt' => 1],
-    ['db' => 'surname',    'dt' => 2],
-    ['db' => 'zip',        'dt' => 3],
-    ['db' => 'country',    'dt' => 4],
+    ['db' => 'id', 'dt' => 0],
+    ['db' => 'firstname', 'dt' => 1],
+    ['db' => 'surname', 'dt' => 2],
+    ['db' => 'zip', 'dt' => 3],
+    ['db' => 'country', 'dt' => 4],
 ];
 
 // SQL server connection information

public/old/swaps.php

Spacing +3 added lines, -3 removed lines

@@ -39,7 +39,7 @@ 
 // ensure user is allowed to see page
 
 if (!isAdmin() && $queryStringUser != $sessionUserId) {
-    header('Location: swaps.php?user='.$sessionUserId);
+    header('Location: swaps.php?user=' . $sessionUserId);
 }
 
 // fetch swaps
@@ -90,11 +90,11 @@ 
               <p>
                 <strong>
                   <s class="text-red">
-                    <?php echo $swap->getOldUserRole()->getUser()->getFirstName().' '.$swap->getOldUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getOldUserRole()->getRole()->getName() ?>)
+                    <?php echo $swap->getOldUserRole()->getUser()->getFirstName() . ' ' . $swap->getOldUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getOldUserRole()->getRole()->getName() ?>)
                   </s>
                   &#8594;
                   <span class="text-green">
-                    <?php echo $swap->getNewUserRole()->getUser()->getFirstName().' '.$swap->getNewUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getNewUserRole()->getRole()->getName() ?>)
+                    <?php echo $swap->getNewUserRole()->getUser()->getFirstName() . ' ' . $swap->getNewUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getNewUserRole()->getRole()->getName() ?>)
                   </span>
                 </strong>
               </p>

public/old/overview.php

Spacing +2 added lines, -2 removed lines

@@ -33,7 +33,7 @@ 
     exit;
 }
 if (!isAdmin()) {
-    header('Location: error.php?no=100&page='.basename($_SERVER['SCRIPT_FILENAME']));
+    header('Location: error.php?no=100&page=' . basename($_SERVER['SCRIPT_FILENAME']));
     exit;
 }
 
@@ -115,7 +115,7 @@ 
 
 		  <?php
             else:
-                echo '<div class="box-body">'.$sentSuccess.'</div>';
+                echo '<div class="box-body">' . $sentSuccess . '</div>';
             endif;
             ?>
 				</div>

public/old/editBand.php

Spacing +11 added lines, -11 removed lines

@@ -33,7 +33,7 @@ 
     exit;
 }
 if (!isAdmin()) {
-    header('Location: error.php?no=100&page='.basename($_SERVER['SCRIPT_FILENAME']));
+    header('Location: error.php?no=100&page=' . basename($_SERVER['SCRIPT_FILENAME']));
     exit;
 }
 
@@ -119,15 +119,15 @@ 
                 }
 
                 if ($viewPeople['skill'] != '') {
-                    $skill = ' - <em>'.$viewPeople['skill'].'</em>';
+                    $skill = ' - <em>' . $viewPeople['skill'] . '</em>';
                 } else {
                     $skill = '';
                 }
                 if ($position == 2) {
-                    echo "<div class='checkboxitem right'><label class='styled' for='rehearsaldate[".$viewPeople['skillID']."]'>".
-                        $viewPeople['name'].$skill."</em></label><input class='styled' ".$checked."type='checkbox' id='rehearsaldate[".
-                        $viewPeople['skillID']."]'	name='rehearsaldate[]' value='".
-                        $viewPeople['skillID']."' /></div></div>";
+                    echo "<div class='checkboxitem right'><label class='styled' for='rehearsaldate[" . $viewPeople['skillID'] . "]'>" .
+                        $viewPeople['name'] . $skill . "</em></label><input class='styled' " . $checked . "type='checkbox' id='rehearsaldate[" .
+                        $viewPeople['skillID'] . "]'	name='rehearsaldate[]' value='" .
+                        $viewPeople['skillID'] . "' /></div></div>";
 
                     $position = 1;
                 } else {
@@ -139,11 +139,11 @@ 
                         $i = '1';
                     }
 
-                    echo "<div class='row".$class."'>
-						<div class='checkboxitem'><label class='styled' for='rehearsaldate[".$viewPeople['skillID']."]'>".
-                        $viewPeople['name'].$skill."</em></label><input class='styled' ".$checked."type='checkbox' id='rehearsaldate[".
-                        $viewPeople['skillID']."]'	name='rehearsaldate[]' value='".
-                        $viewPeople['skillID']."' /></div>";
+                    echo "<div class='row" . $class . "'>
+						<div class='checkboxitem'><label class='styled' for='rehearsaldate[".$viewPeople['skillID'] . "]'>" .
+                        $viewPeople['name'] . $skill . "</em></label><input class='styled' " . $checked . "type='checkbox' id='rehearsaldate[" .
+                        $viewPeople['skillID'] . "]'	name='rehearsaldate[]' value='" .
+                        $viewPeople['skillID'] . "' /></div>";
 
                     $position = 2;
                 }

public/old/plugins/datatables/extensions/Scroller/examples/data/ssp.php

Spacing +5 added lines, -5 removed lines

@@ -29,11 +29,11 @@
 // parameter represents the DataTables column identifier. In this case simple
 // indexes
 $columns = [
-    ['db' => 'id',         'dt' => 0],
-    ['db' => 'firstname',  'dt' => 1],
-    ['db' => 'surname',    'dt' => 2],
-    ['db' => 'zip',        'dt' => 3],
-    ['db' => 'country',    'dt' => 4],
+    ['db' => 'id', 'dt' => 0],
+    ['db' => 'firstname', 'dt' => 1],
+    ['db' => 'surname', 'dt' => 2],
+    ['db' => 'zip', 'dt' => 3],
+    ['db' => 'country', 'dt' => 4],
 ];
 
 // SQL server connection information

public/old/swap.php

Spacing +7 added lines, -7 removed lines

@@ -110,7 +110,7 @@ 
 if (!empty($eventId)) {
     // ensure user is logged in before allowing creation of swap
   if (!(isset($_SESSION['is_logged_in']) || $_SESSION['db_is_logged_in'] == true)) {
-      $_SESSION['redirectUrl'] = siteSettings()->getSiteUrl().'/swap.php?event='.$eventId;
+      $_SESSION['redirectUrl'] = siteSettings()->getSiteUrl() . '/swap.php?event=' . $eventId;
       header('Location: login.php');
   }
     $createSwap = true;
@@ -186,11 +186,11 @@ 
             <p>
               <strong>
                 <s class="text-red">
-                  <?php echo $swap->getOldUserRole()->getUser()->getFirstName().' '.$swap->getOldUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getOldUserRole()->getRole()->getName() ?>)
+                  <?php echo $swap->getOldUserRole()->getUser()->getFirstName() . ' ' . $swap->getOldUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getOldUserRole()->getRole()->getName() ?>)
                 </s>
                 &#8594;
                 <span class="text-green">
-                  <?php echo $swap->getNewUserRole()->getUser()->getFirstName().' '.$swap->getNewUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getNewUserRole()->getRole()->getName() ?>)
+                  <?php echo $swap->getNewUserRole()->getUser()->getFirstName() . ' ' . $swap->getNewUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getNewUserRole()->getRole()->getName() ?>)
                 </span>
               </strong>
             </p>
@@ -225,16 +225,16 @@ 
                 <select name="newUserRole" class="form-control">
                   <?php
                   if (roleCanSwapToOtherRoleInGroup($role->roleId)) {
-                      $whereAnd = 'r.groupId = '.groupIdWithRole($role->roleId).' AND r.allowRoleSwaps IS NOT FALSE';
+                      $whereAnd = 'r.groupId = ' . groupIdWithRole($role->roleId) . ' AND r.allowRoleSwaps IS NOT FALSE';
                   } else {
-                      $whereAnd = 'r.id = '.$role->roleId;
+                      $whereAnd = 'r.id = ' . $role->roleId;
                   }
-                  $sql = 'SELECT ur.id, u.firstName, u.lastName, r.name FROM cr_users u INNER JOIN cr_userRoles ur ON ur.userId = u.id INNER JOIN cr_roles r ON r.id = ur.roleId WHERE u.id <> '.$role->userId.' AND '.$whereAnd.' ORDER BY lastName, firstName, r.name';
+                  $sql = 'SELECT ur.id, u.firstName, u.lastName, r.name FROM cr_users u INNER JOIN cr_userRoles ur ON ur.userId = u.id INNER JOIN cr_roles r ON r.id = ur.roleId WHERE u.id <> ' . $role->userId . ' AND ' . $whereAnd . ' ORDER BY lastName, firstName, r.name';
                   $result = mysqli_query(db(), $sql) or die(mysqli_error(db()));
 
                   while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
                       ?>
-                    <option value='<?php echo $row['id']; ?>'><?php echo $row['firstName'].' '.$row['lastName'].' ('.$row['name'].')'; ?></option>
+                    <option value='<?php echo $row['id']; ?>'><?php echo $row['firstName'] . ' ' . $row['lastName'] . ' (' . $row['name'] . ')'; ?></option>
                   <?php
                   } ?>
                 </select>

public/old/createEvents.php

Spacing +4 added lines, -4 removed lines

@@ -88,7 +88,7 @@ 
                                         while ($ob = mysqli_fetch_object($result)) {
                                             if (!(isset($type) && $ob->id == $type)) {
                                                 $defaultTime = strftime('%H:%M', strtotime($ob->defaultTime));
-                                                echo "<option value='".$ob->id."' title='".$ob->description."' data-time='".($defaultTime == '00:00' ? '' : $defaultTime)."' data-location='".(is_null($ob->defaultLocationId) ? '' : $ob->defaultLocationId)."'>".$ob->name.'</option>';
+                                                echo "<option value='" . $ob->id . "' title='" . $ob->description . "' data-time='" . ($defaultTime == '00:00' ? '' : $defaultTime) . "' data-location='" . (is_null($ob->defaultLocationId) ? '' : $ob->defaultLocationId) . "'>" . $ob->name . '</option>';
                                             }
                                         } ?>

 									</select>

@@ -114,7 +114,7 @@ 
                                         while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
                                             if (isset($subtype) && $row['id'] == $subtype) {
                                             } else {
-                                                echo "<option value='".$row['id']."' title='".$row['description']."'>".$row['name'].'</option>';
+                                                echo "<option value='" . $row['id'] . "' title='" . $row['description'] . "'>" . $row['name'] . '</option>';
                                             }
                                         } ?>

 									</select>

@@ -142,7 +142,7 @@ 
                                         while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
                                             if (isset($location) && $row['id'] == $location) {
                                             } else {
-                                                echo "<option value='".$row['id']."'>".$row['name'].'</option>';
+                                                echo "<option value='" . $row['id'] . "'>" . $row['name'] . '</option>';
                                             }
                                         } ?>

 									</select>

@@ -285,7 +285,7 @@ 
                                     while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
                                         if (isset($type) && $row['id'] == $type) {
                                         } else {
-                                            echo "<option value='".$row['id']."' title='".$row['description']."'>".$row['name'].'</option>';
+                                            echo "<option value='" . $row['id'] . "' title='" . $row['description'] . "'>" . $row['name'] . '</option>';
                                         }
                                     } ?>

 								</select>