summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2016-02-28 22:26:54 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2016-02-28 22:26:54 +0100
commit37fefe0d863f74a8229dd57c72a6cef6c1071730 (patch)
tree4c1318f97acba074011767474ef983277046ca41 /sql-files
parent37521747b02e605fbdde22d27800526a53e3aa72 (diff)
downloadhercules-37fefe0d863f74a8229dd57c72a6cef6c1071730.tar.gz
hercules-37fefe0d863f74a8229dd57c72a6cef6c1071730.tar.bz2
hercules-37fefe0d863f74a8229dd57c72a6cef6c1071730.tar.xz
hercules-37fefe0d863f74a8229dd57c72a6cef6c1071730.zip
MobDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/mob_db.sql4
-rw-r--r--sql-files/mob_db2.sql2
-rw-r--r--sql-files/mob_db_re.sql4
3 files changed, 5 insertions, 5 deletions
diff --git a/sql-files/mob_db.sql b/sql-files/mob_db.sql
index 6b67f4fdb..5097e89ac 100644
--- a/sql-files/mob_db.sql
+++ b/sql-files/mob_db.sql
@@ -52,7 +52,7 @@ CREATE TABLE `mob_db` (
`Scale` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`Race` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`Element` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `Mode` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `Mode` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`Speed` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`aDelay` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`aMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
@@ -347,7 +347,7 @@ REPLACE INTO `mob_db` VALUES (1283,'CHIMERA','Chimera','Chimera',70,32600,1,4950
REPLACE INTO `mob_db` VALUES (1285,'ARCHER_GUARDIAN','Archer Guardian','Archer Guardian',74,28634,1,1,1,12,1120,1600,35,60,95,80,80,90,165,55,14,16,2,7,80,0x1FA5,265,1200,1200,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
REPLACE INTO `mob_db` VALUES (1286,'KNIGHT_GUARDIAN','Knight Guardian','Knight Guardian',86,30214,1,1,1,2,1280,1560,55,30,110,40,140,65,125,65,14,16,2,7,80,0x1FA5,275,1200,1200,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
REPLACE INTO `mob_db` VALUES (1287,'SOLDIER_GUARDIAN','Soldier Guardian','Soldier Guardian',56,15670,1,1,1,1,873,1036,35,0,85,56,100,45,103,43,10,12,0,4,22,0x21A5,265,1288,288,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
-REPLACE INTO `mob_db` VALUES (1288,'EMPELIUM','Emperium','Emperium',90,68430,1,0,0,1,60,71,40,50,1,17,80,50,26,20,10,12,0,8,26,0x120,300,1288,288,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
+REPLACE INTO `mob_db` VALUES (1288,'EMPELIUM','Emperium','Emperium',90,68430,1,0,0,1,60,71,40,50,1,17,80,50,26,20,10,12,0,8,26,0x8120,300,1288,288,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
REPLACE INTO `mob_db` VALUES (1289,'MAYA_PUPLE','Maya Purple','Maya Purple',81,55479,1,10496,3893,2,1447,2000,68,48,95,90,80,95,90,119,10,12,2,4,82,0x37B5,100,1024,1000,480,0,0,0,0,0,0,0,7053,4413,757,250,756,300,969,100,984,150,10006,1,7481,2,0,0,0,0,4198,1);
REPLACE INTO `mob_db` VALUES (1290,'SKELETON_GENERAL','Skeleton General','Skeleton General',73,17402,1,8170,3370,1,910,1089,25,25,90,25,40,20,77,25,10,12,1,1,29,0x3695,150,2276,576,432,0,0,0,0,0,0,0,7068,2550,756,160,508,800,1220,35,1219,80,13035,15,2274,1,0,0,0,0,4221,1);
REPLACE INTO `mob_db` VALUES (1291,'WRAITH_DEAD','Wraith Dead','Wraith Dead',74,43021,1,10341,3618,2,1366,1626,25,30,5,99,55,75,115,45,10,12,2,1,89,0x3695,175,1816,576,240,0,0,0,0,0,0,0,1059,4413,2206,10,2506,8,716,700,732,5,603,100,568,300,0,0,0,0,4189,1);
diff --git a/sql-files/mob_db2.sql b/sql-files/mob_db2.sql
index 404e032c1..5ed77d174 100644
--- a/sql-files/mob_db2.sql
+++ b/sql-files/mob_db2.sql
@@ -52,7 +52,7 @@ CREATE TABLE `mob_db2` (
`Scale` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`Race` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`Element` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `Mode` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `Mode` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`Speed` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`aDelay` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`aMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
diff --git a/sql-files/mob_db_re.sql b/sql-files/mob_db_re.sql
index 90d0e4caf..379a192e5 100644
--- a/sql-files/mob_db_re.sql
+++ b/sql-files/mob_db_re.sql
@@ -52,7 +52,7 @@ CREATE TABLE `mob_db` (
`Scale` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`Race` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`Element` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `Mode` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `Mode` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`Speed` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`aDelay` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`aMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
@@ -336,7 +336,7 @@ REPLACE INTO `mob_db` VALUES (1283,'CHIMERA','Chimera','Chimera',70,26406,1,5426
REPLACE INTO `mob_db` VALUES (1285,'ARCHER_GUARDIAN','Archer Guardian','Archer Guardian',74,28634,1,1,1,12,1232,480,56,60,95,80,80,90,198,55,14,16,2,7,80,0x1FA5,265,1200,1200,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
REPLACE INTO `mob_db` VALUES (1286,'KNIGHT_GUARDIAN','Knight Guardian','Knight Guardian',86,30214,1,1,1,2,1408,280,88,30,110,40,140,65,150,65,14,16,2,7,80,0x1FA5,275,1200,1200,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
REPLACE INTO `mob_db` VALUES (1287,'SOLDIER_GUARDIAN','Soldier Guardian','Soldier Guardian',56,15670,1,1,1,1,873,163,56,0,85,56,100,45,103,43,10,12,2,7,20,0x21A5,265,1288,288,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
-REPLACE INTO `mob_db` VALUES (1288,'EMPELIUM','Emperium','Emperium',90,100,1,0,0,1,66,13,64,50,1,17,80,50,31,20,10,12,0,8,26,0x160,300,1288,288,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
+REPLACE INTO `mob_db` VALUES (1288,'EMPELIUM','Emperium','Emperium',90,100,1,0,0,1,66,13,64,50,1,17,80,50,31,20,10,12,0,8,26,0x8160,300,1288,288,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
REPLACE INTO `mob_db` VALUES (1289,'MAYA_PUPLE','Maya Purple','Maya Purple',81,77670,1,12884,6516,2,1592,553,139,40,95,52,80,95,88,119,10,12,2,4,82,0x37B5,100,1024,1000,480,0,0,0,0,0,0,0,7053,4413,757,250,756,300,969,100,984,150,10006,1,7481,2,0,0,0,0,4198,1);
REPLACE INTO `mob_db` VALUES (1290,'SKELETON_GENERAL','Skeleton General','Skeleton General',139,180130,1,10614,10115,1,1317,1701,100,35,72,34,52,31,101,25,10,12,1,1,29,0x3695,150,2276,576,432,0,0,0,0,0,0,0,7068,2550,756,160,508,800,1220,35,1219,80,13035,15,2274,1,0,0,0,0,4221,1);
REPLACE INTO `mob_db` VALUES (1291,'WRAITH_DEAD','Wraith Dead','Wraith Dead',121,25990,1,3802,3410,2,1002,160,88,56,63,69,55,45,106,45,10,12,2,1,89,0x3695,175,1816,576,240,0,0,0,0,0,0,0,1059,4413,2206,10,2506,8,716,700,732,5,603,4,568,300,0,0,0,0,4189,1);