add 5v5 activatablesHEADmaster

3 files changed, 131 insertions, 0 deletions

diff --git a/migrations/2018_02_03_000000_Add5v5ItemsGlobalPoint.php b/migrations/2018_02_03_000000_Add5v5ItemsGlobalPoint.php
new file mode 100644
index 0000000..6e20fe6
--- /dev/null
+++ b/migrations/2018_02_03_000000_Add5v5ItemsGlobalPoint.php
@@ -0,0 +1,32 @@
+<?php
+
+use Illuminate\Support\Facades\Schema;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class Add5v5ItemsPlayerPoint extends Migration
+{
+    /**
+     * Run the migrations.
+     *
+     * @return void
+     */
+    public function up()
+    {
+        Schema::table('global_point', function (Blueprint $table) {
+            $table->unsignedBigInteger('item_076_use');  // Scout Cam
+            $table->unsignedBigInteger('item_080_use');  // Flare Loader
+            $table->unsignedBigInteger('item_081_use');  // Teleport Boots
+        });
+    }
+    
+    public function down()
+    {
+        Schema::table('global_point', function (Blueprint $table) {
+            $table->dropColumn('item_076_use');  // Scout Cam
+            $table->dropColumn('item_080_use');  // Flare Loader
+            $table->dropColumn('item_081_use');  // Teleport Boots
+        });
+
+    }
+}
diff --git a/migrations/2018_02_03_000000_Add5v5ItemsPlayerPoint.php b/migrations/2018_02_03_000000_Add5v5ItemsPlayerPoint.php
new file mode 100644
index 0000000..3034ca2
--- /dev/null
+++ b/migrations/2018_02_03_000000_Add5v5ItemsPlayerPoint.php
@@ -0,0 +1,32 @@
+<?php
+
+use Illuminate\Support\Facades\Schema;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class Add5v5ItemsPlayerPoint extends Migration
+{
+    /**
+     * Run the migrations.
+     *
+     * @return void
+     */
+    public function up()
+    {
+        Schema::table('player_point', function (Blueprint $table) {
+            $table->unsignedBigInteger('item_076_use');  // Scout Cam
+            $table->unsignedBigInteger('item_080_use');  // Flare Loader
+            $table->unsignedBigInteger('item_081_use');  // Teleport Boots
+        });
+    }
+    
+    public function down()
+    {
+        Schema::table('player_point', function (Blueprint $table) {
+            $table->dropColumn('item_076_use');  // Scout Cam
+            $table->dropColumn('item_080_use');  // Flare Loader
+            $table->dropColumn('item_081_use');  // Teleport Boots
+        });
+
+    }
+}
diff --git a/migrations/2018_02_03_000000_fix_5v5_items.php b/migrations/2018_02_03_000000_fix_5v5_items.php
new file mode 100644
index 0000000..3ead5cf
--- /dev/null
+++ b/migrations/2018_02_03_000000_fix_5v5_items.php
@@ -0,0 +1,67 @@
+<?php
+
+use Carbon\Carbon;
+
+use Illuminate\Support\Facades\Schema;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class Fix5V5Items extends Migration
+{
+    /**
+     * Run the migrations.
+     *
+     * @return void
+     */
+    public function up()
+    {
+        DB::table('item')
+            ->where('name', 'Scout Cam')
+            ->update([
+                'is_activable' => '1'
+            ]);
+
+        DB::table('item')
+            ->where('name', 'Buffed Cam')
+            ->update([
+                'name' => 'ScoutTuff',
+                'is_activable' => '0'
+            ]);
+
+        DB::table('item')
+            ->where('name', 'Multi-Cam')
+            ->update([
+                'name' => 'ScoutPak',
+                'is_activable' => '0'
+            ]);
+
+        DB::table('item')
+            ->where('name', 'Boosted Cam')
+            ->update([
+                'name' => 'SuperScout 2000',
+                'is_activable' => '0'
+            ]);
+
+        DB::table('item')
+            ->where('name', 'Flare Gun beta')
+            ->update([
+                'name' => 'Flare Loader',
+                'is_activable' => '1'
+            ]);
+
+        DB::table('item')
+            ->where('name', 'Teleport Boots')
+            ->update([
+                'is_activable' => '1'
+            ]);
+    }
+
+    /**
+     * Reverse the migrations.
+     *
+     * @return void
+     */
+    public function down()
+    {
+    }
+}