|
You last visited: Today at 04:31
Advertisement
Query Problemm in db einfügen
Discussion on Query Problemm in db einfügen within the Metin2 Private Server forum part of the Metin2 category.
04/21/2016, 18:17
|
#1
|
elite*gold: 110
Join Date: Jun 2015
Posts: 85
Received Thanks: 22
|
Query Problemm in db einfügen
Hallo habe ein problemm wenn ich die query in db einfügen will kommt bei mir folgende fehler
PHP Code:
Data truncated for column 'size' at row 1
hab versucht versucht leider krieg ich es nicht hin hoffe ihr könnt mir helfen
PHP Code:
INSERT INTO mob_proto VALUES(8028, 'Metin der Hoffnung', 'Metin der Hoffnung', 5, 2, 3, 95, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8029, 'Metin des Schreckens', 'Metin des Schreckens', 5, 2, 3, 100, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8030, 'Metin des Zorns', 'Metin des Zorns', 5, 2, 3, 105, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8031, 'Metin der Barmherzigkeit', 'Metin der Barmherzigkeit', 5, 2, 3, 110, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8032, 'Metin der Unterwelt', 'Metin der Unterwelt', 5, 2, 3, 115, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8033, 'Metin der Wiedergeburt', 'Metin der Wiedergeburt', 5, 2, 3, 120, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8034, 'Metin der Wut', 'Metin der Wut', 5, 2, 3, 125, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8035, 'Metin der Vernunft', 'Metin der Vernunft', 5, 2, 3, 130, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8036, 'Metin des Lichts', 'Metin des Lichts', 5, 2, 3, 135, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8037, 'Metin der Verzweiflung', 'Metin der Verzweiflung', 5, 2, 3, 140, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8038, 'Metin der Geduld', 'Metin der Geduld', 5, 2, 3, 145, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO mob_proto VALUES(8039, 'Metin der Elemente', 'Metin der Elemente', 5, 2, 3, 150, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
|
|
|
04/21/2016, 18:41
|
#2
|
elite*gold: 0
Join Date: Apr 2016
Posts: 12
Received Thanks: 5
|
Kann es sein, dass deine mob_proto tabelle column `size` nicht "NOT NULL" ist?
Die size spalte braucht diese Werte:
Code:
`size` enum('SMALL','MEDIUM','BIG') NOT NULL default 'SMALL'
Um das zu prüfen, dump deine mob_proto Tabelle in Navicat und öffne mit einen Text Editor die mob_proto.sql Datei.
mfg
|
|
|
04/21/2016, 19:02
|
#3
|
elite*gold: 110
Join Date: Jun 2015
Posts: 85
Received Thanks: 22
|
ich check grad nix mehr
PHP Code:
INSERT INTO `mob_proto` VALUES ('8001', '???', 0x4D6574696E20646573204B756D6D657273, '5', '2', '3', '5', '', 'NOMOVE', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '0', '0', '0', '6', '0', '0', '0', '14550', '5', '1', '2432', '1824', '1', '8', '104', '109', '0', '2000', '175', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '0', '0', '0', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
Könntes du bitte mal Prüfen und machen weill komme echt nicht weiter
PHP Code:
`vnum` int(11) NOT NULL DEFAULT '0', `name` varchar(24) NOT NULL DEFAULT 'Noname', `locale_name` varbinary(24) NOT NULL DEFAULT 'Noname', `rank` tinyint(2) NOT NULL DEFAULT '0', `type` tinyint(2) NOT NULL DEFAULT '0', `battle_type` tinyint(1) NOT NULL DEFAULT '0', `level` smallint(3) NOT NULL DEFAULT '1', `size` enum('SMALL','MEDIUM','BIG') DEFAULT NULL, `ai_flag` set('AGGR','NOMOVE','COWARD','NOATTSHINSU','NOATTCHUNJO','NOATTJINNO','ATTMOB','BERSERK','STONESKIN','GODSPEED','DEATHBLOW','REVIVE') DEFAULT '', `mount_capacity` tinyint(2) NOT NULL DEFAULT '0', `setRaceFlag` set('ANIMAL','UNDEAD','DEVIL','HUMAN','ORC','MILGYO','INSECT','FIRE','ICE','DESERT') NOT NULL DEFAULT '', `setImmuneFlag` set('STUN','SLOW','FALL','CURSE','POISON','TERROR') NOT NULL DEFAULT '', `empire` tinyint(4) NOT NULL DEFAULT '0', `folder` varchar(100) NOT NULL DEFAULT '', `on_click` tinyint(4) NOT NULL DEFAULT '0', `st` smallint(5) unsigned NOT NULL DEFAULT '0', `dx` smallint(5) unsigned NOT NULL DEFAULT '0', `ht` smallint(5) unsigned NOT NULL DEFAULT '0', `iq` smallint(5) unsigned NOT NULL DEFAULT '0', `damage_min` smallint(5) unsigned NOT NULL DEFAULT '0', `damage_max` smallint(5) unsigned NOT NULL DEFAULT '0', `max_hp` int(10) unsigned NOT NULL DEFAULT '0', `regen_cycle` tinyint(3) unsigned NOT NULL DEFAULT '0', `regen_percent` tinyint(3) unsigned NOT NULL DEFAULT '0', `gold_min` int(11) NOT NULL DEFAULT '0', `gold_max` int(11) NOT NULL DEFAULT '0', `exp` int(10) unsigned NOT NULL DEFAULT '0', `def` smallint(5) unsigned NOT NULL DEFAULT '0', `attack_speed` smallint(6) unsigned NOT NULL DEFAULT '100', `move_speed` smallint(6) unsigned NOT NULL DEFAULT '100', `aggressive_hp_pct` tinyint(3) unsigned NOT NULL DEFAULT '0', `aggressive_sight` smallint(10) unsigned NOT NULL DEFAULT '0', `attack_range` smallint(5) unsigned NOT NULL DEFAULT '0', `drop_item` int(10) unsigned NOT NULL DEFAULT '0', `resurrection_vnum` int(10) unsigned NOT NULL DEFAULT '0', `enchant_curse` tinyint(4) unsigned NOT NULL DEFAULT '0', `enchant_slow` tinyint(4) unsigned NOT NULL DEFAULT '0', `enchant_poison` tinyint(4) unsigned NOT NULL DEFAULT '0', `enchant_stun` tinyint(3) unsigned NOT NULL DEFAULT '0', `enchant_critical` tinyint(3) unsigned NOT NULL DEFAULT '0', `enchant_penetrate` tinyint(3) unsigned NOT NULL DEFAULT '0', `resist_sword` tinyint(4) NOT NULL DEFAULT '0', `resist_twohand` tinyint(4) NOT NULL DEFAULT '0', `resist_dagger` tinyint(4) NOT NULL DEFAULT '0', `resist_bell` tinyint(4) NOT NULL DEFAULT '0', `resist_fan` tinyint(4) NOT NULL DEFAULT '0', `resist_bow` tinyint(4) NOT NULL DEFAULT '0', `resist_fire` tinyint(4) NOT NULL DEFAULT '0', `resist_elect` tinyint(4) NOT NULL DEFAULT '0', `resist_magic` tinyint(4) NOT NULL DEFAULT '0', `resist_wind` tinyint(4) NOT NULL DEFAULT '0', `resist_poison` tinyint(4) NOT NULL DEFAULT '0', `dam_multiply` float DEFAULT NULL, `summon` int(11) DEFAULT NULL, `drain_sp` int(11) DEFAULT NULL, `mob_color` int(10) unsigned DEFAULT NULL, `polymorph_item` int(10) unsigned NOT NULL DEFAULT '0', `skill_level0` tinyint(3) unsigned DEFAULT NULL, `skill_vnum0` int(10) unsigned DEFAULT NULL, `skill_level1` tinyint(3) unsigned DEFAULT NULL, `skill_vnum1` int(10) unsigned DEFAULT NULL, `skill_level2` tinyint(3) unsigned DEFAULT NULL, `skill_vnum2` int(10) unsigned DEFAULT NULL, `skill_level3` tinyint(3) unsigned DEFAULT NULL, `skill_vnum3` int(10) unsigned DEFAULT NULL, `skill_level4` tinyint(3) unsigned DEFAULT NULL, `skill_vnum4` int(10) unsigned DEFAULT NULL, `sp_berserk` tinyint(4) NOT NULL DEFAULT '0', `sp_stoneskin` tinyint(4) NOT NULL DEFAULT '0', `sp_godspeed` tinyint(4) NOT NULL DEFAULT '0', `sp_deathblow` tinyint(4) NOT NULL DEFAULT '0', `sp_revive` tinyint(4) NOT NULL DEFAULT '0', `vnum` int(11) NOT NULL DEFAULT '0', `name` varchar(24) NOT NULL DEFAULT 'Noname', `locale_name` varbinary(24) NOT NULL DEFAULT 'Noname', `rank` tinyint(2) NOT NULL DEFAULT '0', `type` tinyint(2) NOT NULL DEFAULT '0', `battle_type` tinyint(1) NOT NULL DEFAULT '0', `level` smallint(3) NOT NULL DEFAULT '1', `size` enum('SMALL','MEDIUM','BIG') DEFAULT NULL, `ai_flag` set('AGGR','NOMOVE','COWARD','NOATTSHINSU','NOATTCHUNJO','NOATTJINNO','ATTMOB','BERSERK','STONESKIN','GODSPEED','DEATHBLOW','REVIVE') DEFAULT '', `mount_capacity` tinyint(2) NOT NULL DEFAULT '0', `setRaceFlag` set('ANIMAL','UNDEAD','DEVIL','HUMAN','ORC','MILGYO','INSECT','FIRE','ICE','DESERT') NOT NULL DEFAULT '', `setImmuneFlag` set('STUN','SLOW','FALL','CURSE','POISON','TERROR') NOT NULL DEFAULT '', `empire` tinyint(4) NOT NULL DEFAULT '0', `folder` varchar(100) NOT NULL DEFAULT '', `on_click` tinyint(4) NOT NULL DEFAULT '0', `st` smallint(5) unsigned NOT NULL DEFAULT '0', `dx` smallint(5) unsigned NOT NULL DEFAULT '0', `ht` smallint(5) unsigned NOT NULL DEFAULT '0', `iq` smallint(5) unsigned NOT NULL DEFAULT '0', `damage_min` smallint(5) unsigned NOT NULL DEFAULT '0', `damage_max` smallint(5) unsigned NOT NULL DEFAULT '0', `max_hp` int(10) unsigned NOT NULL DEFAULT '0', `regen_cycle` tinyint(3) unsigned NOT NULL DEFAULT '0', `regen_percent` tinyint(3) unsigned NOT NULL DEFAULT '0', `gold_min` int(11) NOT NULL DEFAULT '0', `gold_max` int(11) NOT NULL DEFAULT '0', `exp` int(10) unsigned NOT NULL DEFAULT '0', `def` smallint(5) unsigned NOT NULL DEFAULT '0', `attack_speed` smallint(6) unsigned NOT NULL DEFAULT '100', `move_speed` smallint(6) unsigned NOT NULL DEFAULT '100', `aggressive_hp_pct` tinyint(3) unsigned NOT NULL DEFAULT '0', `aggressive_sight` smallint(10) unsigned NOT NULL DEFAULT '0', `attack_range` smallint(5) unsigned NOT NULL DEFAULT '0', `drop_item` int(10) unsigned NOT NULL DEFAULT '0', `resurrection_vnum` int(10) unsigned NOT NULL DEFAULT '0', `enchant_curse` tinyint(4) unsigned NOT NULL DEFAULT '0', `enchant_slow` tinyint(4) unsigned NOT NULL DEFAULT '0', `enchant_poison` tinyint(4) unsigned NOT NULL DEFAULT '0', `enchant_stun` tinyint(3) unsigned NOT NULL DEFAULT '0', `enchant_critical` tinyint(3) unsigned NOT NULL DEFAULT '0', `enchant_penetrate` tinyint(3) unsigned NOT NULL DEFAULT '0', `resist_sword` tinyint(4) NOT NULL DEFAULT '0', `resist_twohand` tinyint(4) NOT NULL DEFAULT '0', `resist_dagger` tinyint(4) NOT NULL DEFAULT '0', `resist_bell` tinyint(4) NOT NULL DEFAULT '0', `resist_fan` tinyint(4) NOT NULL DEFAULT '0', `resist_bow` tinyint(4) NOT NULL DEFAULT '0', `resist_fire` tinyint(4) NOT NULL DEFAULT '0', `resist_elect` tinyint(4) NOT NULL DEFAULT '0', `resist_magic` tinyint(4) NOT NULL DEFAULT '0', `resist_wind` tinyint(4) NOT NULL DEFAULT '0', `resist_poison` tinyint(4) NOT NULL DEFAULT '0', `dam_multiply` float DEFAULT NULL, `summon` int(11) DEFAULT NULL, `drain_sp` int(11) DEFAULT NULL, `mob_color` int(10) unsigned DEFAULT NULL, `polymorph_item` int(10) unsigned NOT NULL DEFAULT '0', `skill_level0` tinyint(3) unsigned DEFAULT NULL, `skill_vnum0` int(10) unsigned DEFAULT NULL, `skill_level1` tinyint(3) unsigned DEFAULT NULL, `skill_vnum1` int(10) unsigned DEFAULT NULL, `skill_level2` tinyint(3) unsigned DEFAULT NULL, `skill_vnum2` int(10) unsigned DEFAULT NULL, `skill_level3` tinyint(3) unsigned DEFAULT NULL, `skill_vnum3` int(10) unsigned DEFAULT NULL, `skill_level4` tinyint(3) unsigned DEFAULT NULL, `skill_vnum4` int(10) unsigned DEFAULT NULL, `sp_berserk` tinyint(4) NOT NULL DEFAULT '0', `sp_stoneskin` tinyint(4) NOT NULL DEFAULT '0', `sp_godspeed` tinyint(4) NOT NULL DEFAULT '0', `sp_deathblow` tinyint(4) NOT NULL DEFAULT '0', `sp_revive` tinyint(4) NOT NULL DEFAULT '0',
|
|
|
04/21/2016, 19:39
|
#4
|
elite*gold: 0
Join Date: Apr 2016
Posts: 12
Received Thanks: 5
|
Code:
`vnum` int(11) NOT NULL DEFAULT '0',
`name` varchar(24) NOT NULL DEFAULT 'Noname',
`locale_name` varbinary(24) NOT NULL DEFAULT 'Noname',
`rank` tinyint(2) NOT NULL DEFAULT '0',
`type` tinyint(2) NOT NULL DEFAULT '0',
`battle_type` tinyint(1) NOT NULL DEFAULT '0',
`level` smallint(3) NOT NULL DEFAULT '1',
`size` enum('SMALL','MEDIUM','BIG') NOT NULL default 'SMALL',
`ai_flag` set('AGGR','NOMOVE','COWARD','NOATTSHINSU','NOATTCHUNJO','NOATTJINNO','ATTMOB','BERSERK','STONESKIN','GODSPEED','DEATHBLOW','REVIVE') DEFAULT '',
`mount_capacity` tinyint(2) NOT NULL DEFAULT '0',
`setRaceFlag` set('ANIMAL','UNDEAD','DEVIL','HUMAN','ORC','MILGYO','INSECT','FIRE','ICE','DESERT') NOT NULL DEFAULT '',
`setImmuneFlag` set('STUN','SLOW','FALL','CURSE','POISON','TERROR') NOT NULL DEFAULT '',
`empire` tinyint(4) NOT NULL DEFAULT '0',
`folder` varchar(100) NOT NULL DEFAULT '',
`on_click` tinyint(4) NOT NULL DEFAULT '0',
`st` smallint(5) unsigned NOT NULL DEFAULT '0',
`dx` smallint(5) unsigned NOT NULL DEFAULT '0',
`ht` smallint(5) unsigned NOT NULL DEFAULT '0',
`iq` smallint(5) unsigned NOT NULL DEFAULT '0',
`damage_min` smallint(5) unsigned NOT NULL DEFAULT '0',
`damage_max` smallint(5) unsigned NOT NULL DEFAULT '0',
`max_hp` int(10) unsigned NOT NULL DEFAULT '0',
`regen_cycle` tinyint(3) unsigned NOT NULL DEFAULT '0',
`regen_percent` tinyint(3) unsigned NOT NULL DEFAULT '0',
`gold_min` int(11) NOT NULL DEFAULT '0',
`gold_max` int(11) NOT NULL DEFAULT '0',
`exp` int(10) unsigned NOT NULL DEFAULT '0',
`def` smallint(5) unsigned NOT NULL DEFAULT '0',
`attack_speed` smallint(6) unsigned NOT NULL DEFAULT '100',
`move_speed` smallint(6) unsigned NOT NULL DEFAULT '100',
`aggressive_hp_pct` tinyint(3) unsigned NOT NULL DEFAULT '0',
`aggressive_sight` smallint(10) unsigned NOT NULL DEFAULT '0',
`attack_range` smallint(5) unsigned NOT NULL DEFAULT '0',
`drop_item` int(10) unsigned NOT NULL DEFAULT '0',
`resurrection_vnum` int(10) unsigned NOT NULL DEFAULT '0',
`enchant_curse` tinyint(4) unsigned NOT NULL DEFAULT '0',
`enchant_slow` tinyint(4) unsigned NOT NULL DEFAULT '0',
`enchant_poison` tinyint(4) unsigned NOT NULL DEFAULT '0',
`enchant_stun` tinyint(3) unsigned NOT NULL DEFAULT '0',
`enchant_critical` tinyint(3) unsigned NOT NULL DEFAULT '0',
`enchant_penetrate` tinyint(3) unsigned NOT NULL DEFAULT '0',
`resist_sword` tinyint(4) NOT NULL DEFAULT '0',
`resist_twohand` tinyint(4) NOT NULL DEFAULT '0',
`resist_dagger` tinyint(4) NOT NULL DEFAULT '0',
`resist_bell` tinyint(4) NOT NULL DEFAULT '0',
`resist_fan` tinyint(4) NOT NULL DEFAULT '0',
`resist_bow` tinyint(4) NOT NULL DEFAULT '0',
`resist_fire` tinyint(4) NOT NULL DEFAULT '0',
`resist_elect` tinyint(4) NOT NULL DEFAULT '0',
`resist_magic` tinyint(4) NOT NULL DEFAULT '0',
`resist_wind` tinyint(4) NOT NULL DEFAULT '0',
`resist_poison` tinyint(4) NOT NULL DEFAULT '0',
`dam_multiply` float DEFAULT NULL,
`summon` int(11) DEFAULT NULL,
`drain_sp` int(11) DEFAULT NULL,
`mob_color` int(10) unsigned DEFAULT NULL,
`polymorph_item` int(10) unsigned NOT NULL DEFAULT '0',
`skill_level0` tinyint(3) unsigned DEFAULT NULL,
`skill_vnum0` int(10) unsigned DEFAULT NULL,
`skill_level1` tinyint(3) unsigned DEFAULT NULL,
`skill_vnum1` int(10) unsigned DEFAULT NULL,
`skill_level2` tinyint(3) unsigned DEFAULT NULL,
`skill_vnum2` int(10) unsigned DEFAULT NULL,
`skill_level3` tinyint(3) unsigned DEFAULT NULL,
`skill_vnum3` int(10) unsigned DEFAULT NULL,
`skill_level4` tinyint(3) unsigned DEFAULT NULL,
`skill_vnum4` int(10) unsigned DEFAULT NULL,
`sp_berserk` tinyint(4) NOT NULL DEFAULT '0',
`sp_stoneskin` tinyint(4) NOT NULL DEFAULT '0',
`sp_godspeed` tinyint(4) NOT NULL DEFAULT '0',
`sp_deathblow` tinyint(4) NOT NULL DEFAULT '0',
`sp_revive` tinyint(4) NOT NULL DEFAULT '0', `vnum` int(11) NOT NULL DEFAULT '0',
`name` varchar(24) NOT NULL DEFAULT 'Noname',
`locale_name` varbinary(24) NOT NULL DEFAULT 'Noname',
`rank` tinyint(2) NOT NULL DEFAULT '0',
`type` tinyint(2) NOT NULL DEFAULT '0',
`battle_type` tinyint(1) NOT NULL DEFAULT '0',
`level` smallint(3) NOT NULL DEFAULT '1',
`size` enum('SMALL','MEDIUM','BIG') DEFAULT NULL,
`ai_flag` set('AGGR','NOMOVE','COWARD','NOATTSHINSU','NOATTCHUNJO','NOATTJINNO','ATTMOB','BERSERK','STONESKIN','GODSPEED','DEATHBLOW','REVIVE') DEFAULT '',
`mount_capacity` tinyint(2) NOT NULL DEFAULT '0',
`setRaceFlag` set('ANIMAL','UNDEAD','DEVIL','HUMAN','ORC','MILGYO','INSECT','FIRE','ICE','DESERT') NOT NULL DEFAULT '',
`setImmuneFlag` set('STUN','SLOW','FALL','CURSE','POISON','TERROR') NOT NULL DEFAULT '',
`empire` tinyint(4) NOT NULL DEFAULT '0',
`folder` varchar(100) NOT NULL DEFAULT '',
`on_click` tinyint(4) NOT NULL DEFAULT '0',
`st` smallint(5) unsigned NOT NULL DEFAULT '0',
`dx` smallint(5) unsigned NOT NULL DEFAULT '0',
`ht` smallint(5) unsigned NOT NULL DEFAULT '0',
`iq` smallint(5) unsigned NOT NULL DEFAULT '0',
`damage_min` smallint(5) unsigned NOT NULL DEFAULT '0',
`damage_max` smallint(5) unsigned NOT NULL DEFAULT '0',
`max_hp` int(10) unsigned NOT NULL DEFAULT '0',
`regen_cycle` tinyint(3) unsigned NOT NULL DEFAULT '0',
`regen_percent` tinyint(3) unsigned NOT NULL DEFAULT '0',
`gold_min` int(11) NOT NULL DEFAULT '0',
`gold_max` int(11) NOT NULL DEFAULT '0',
`exp` int(10) unsigned NOT NULL DEFAULT '0',
`def` smallint(5) unsigned NOT NULL DEFAULT '0',
`attack_speed` smallint(6) unsigned NOT NULL DEFAULT '100',
`move_speed` smallint(6) unsigned NOT NULL DEFAULT '100',
`aggressive_hp_pct` tinyint(3) unsigned NOT NULL DEFAULT '0',
`aggressive_sight` smallint(10) unsigned NOT NULL DEFAULT '0',
`attack_range` smallint(5) unsigned NOT NULL DEFAULT '0',
`drop_item` int(10) unsigned NOT NULL DEFAULT '0',
`resurrection_vnum` int(10) unsigned NOT NULL DEFAULT '0',
`enchant_curse` tinyint(4) unsigned NOT NULL DEFAULT '0',
`enchant_slow` tinyint(4) unsigned NOT NULL DEFAULT '0',
`enchant_poison` tinyint(4) unsigned NOT NULL DEFAULT '0',
`enchant_stun` tinyint(3) unsigned NOT NULL DEFAULT '0',
`enchant_critical` tinyint(3) unsigned NOT NULL DEFAULT '0',
`enchant_penetrate` tinyint(3) unsigned NOT NULL DEFAULT '0',
`resist_sword` tinyint(4) NOT NULL DEFAULT '0',
`resist_twohand` tinyint(4) NOT NULL DEFAULT '0',
`resist_dagger` tinyint(4) NOT NULL DEFAULT '0',
`resist_bell` tinyint(4) NOT NULL DEFAULT '0',
`resist_fan` tinyint(4) NOT NULL DEFAULT '0',
`resist_bow` tinyint(4) NOT NULL DEFAULT '0',
`resist_fire` tinyint(4) NOT NULL DEFAULT '0',
`resist_elect` tinyint(4) NOT NULL DEFAULT '0',
`resist_magic` tinyint(4) NOT NULL DEFAULT '0',
`resist_wind` tinyint(4) NOT NULL DEFAULT '0',
`resist_poison` tinyint(4) NOT NULL DEFAULT '0',
`dam_multiply` float DEFAULT NULL,
`summon` int(11) DEFAULT NULL,
`drain_sp` int(11) DEFAULT NULL,
`mob_color` int(10) unsigned DEFAULT NULL,
`polymorph_item` int(10) unsigned NOT NULL DEFAULT '0',
`skill_level0` tinyint(3) unsigned DEFAULT NULL,
`skill_vnum0` int(10) unsigned DEFAULT NULL,
`skill_level1` tinyint(3) unsigned DEFAULT NULL,
`skill_vnum1` int(10) unsigned DEFAULT NULL,
`skill_level2` tinyint(3) unsigned DEFAULT NULL,
`skill_vnum2` int(10) unsigned DEFAULT NULL,
`skill_level3` tinyint(3) unsigned DEFAULT NULL,
`skill_vnum3` int(10) unsigned DEFAULT NULL,
`skill_level4` tinyint(3) unsigned DEFAULT NULL,
`skill_vnum4` int(10) unsigned DEFAULT NULL,
`sp_berserk` tinyint(4) NOT NULL DEFAULT '0',
`sp_stoneskin` tinyint(4) NOT NULL DEFAULT '0',
`sp_godspeed` tinyint(4) NOT NULL DEFAULT '0',
`sp_deathblow` tinyint(4) NOT NULL DEFAULT '0',
`sp_revive` tinyint(4) NOT NULL DEFAULT '0',
guck mal ob es so klappt. Auch wenn es "eigentlich" kein großen Unterschied macht, das einzige was jetzt passiert ist, er trägt in der size Spalte keine "NULL" Werte mehr ein sondern "SMALL".
Falls es nicht klappt, pack den alten Code wieder rein und ich gucke mal was ich sonst noch tun kann.
|
|
|
|
Similar Threads
|
WICHTig....query und einfügen
06/18/2015 - Metin2 Private Server - 7 Replies
hey, ich habe eben was cooles bekommen zum einfügen, ist wie ein Reititer... cliet habe ich alles hinzugefügt aber ic weiß nicht wie ich solche query erstellen kann... kann mir jemadn helfen?:confused:
|
Item_proto query einfügen ?
07/09/2012 - Metin2 Private Server - 3 Replies
Hey wollte eben in der Item_proto ne query einfügen aber es kommt immer dieser error <-
http://i.epvpimg.com/vLhqf.png
Weiß wer wie ich mysql upgrade ?
Mfg Reall
|
Sachen in die Query einfügen
11/16/2010 - Metin2 Private Server - 2 Replies
Guten Tag,
Wie fügt man sachen z.B. in die item_proto query oder so für neue waffen, items etc.? Weis nämlich nicht was einen Query ist und wo icvh die Codes einfügen muss
Mit freundlichen Grüßen
Tim29
|
navicat query einfügen
10/10/2010 - Metin2 Private Server - 3 Replies
wie kann ich bei navicat die querys einfügen
|
query einfügen
09/23/2010 - Metin2 Private Server - 6 Replies
hey com,
ich wollte heute die neuen reittiere einfügen bloß ich weis nicht wie ich die 4 querys einfüge.
INSERT INTO mob_proto VALUES ('39912', 'lion', 0x4E6F6E616D65202020202020202020202020202020202020 , '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', 'lion', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '2', '2', '400', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',...
|
All times are GMT +2. The time now is 04:31.
|
|