Premium Shogun 4587 Posted August 29, 2014 Author Premium Share Posted August 29, 2014 Thank you, Shogun Can someone tell me what are the differences between this skill proto and the official one? Because I also made many modifications in the skill proto and it would be a bit hard work for me to check every row. It's the sg skill proto. It may be slightly different to GF's but not much,just minor things. 1 Link to comment Share on other sites More sharing options...
hardrevo 27 Posted August 29, 2014 Share Posted August 29, 2014 shutgon can yu double check the skill_pronto DROP TABLE IF EXISTS `skill_proto`; Affected rows: 0 Time: 0.035s [sql] CREATE TABLE `skill_proto` ( `dwVnum` int(11) NOT NULL DEFAULT '0', `szName` varchar(32) NOT NULL DEFAULT '', `bType` tinyint(4) NOT NULL DEFAULT '0', `bLevelStep` tinyint(4) NOT NULL DEFAULT '0', `bMaxLevel` tinyint(4) NOT NULL DEFAULT '0', `bLevelLimit` tinyint(3) unsigned NOT NULL DEFAULT '0', `szPointOn` varchar(100) NOT NULL DEFAULT '0', `szPointPoly` varchar(100) NOT NULL DEFAULT '', `szSPCostPoly` varchar(100) NOT NULL DEFAULT '', `szDurationPoly` varchar(100) NOT NULL DEFAULT '', `szDurationSPCostPoly` varchar(100) NOT NULL DEFAULT '', `szCooldownPoly` varchar(100) NOT NULL DEFAULT '', `szMasterBonusPoly` varchar(100) NOT NULL DEFAULT '', `szAttackGradePoly` varchar(100) NOT NULL DEFAULT '', `setFlag` set('ATTACK','USE_MELEE_DAMAGE','COMPUTE_ATTGRADE','SELFONLY','USE_MAGIC_DAMAGE','USE_HP_AS_COST','COMPUTE_MAGIC_DAMAGE','SPLASH','GIVE_PENALTY','USE_ARROW_DAMAGE','PENETRATE','IGNORE_TARGET_RATING','ATTACK_SLOW','ATTACK_STUN','HP_ABSORB','SP_ABSORB','ATTACK_FIRE_CONT','REMOVE_BAD_AFFECT','REMOVE_GOOD_AFFECT','CRUSH','ATTACK_POISON','TOGGLE','DISABLE_BY_POINT_UP','CRUSH_LONG') DEFAULT NULL, `setAffectFlag` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD','MUYEONG','REVIVE_INVISIBLE','FIRE','GICHEON','JEUNGRYEOK','') DEFAULT NULL, `szPointOn2` varchar(100) NOT NULL DEFAULT 'NONE', `szPointPoly2` varchar(100) NOT NULL DEFAULT '', `szDurationPoly2` varchar(100) NOT NULL DEFAULT '', `setAffectFlag2` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD') NOT NULL DEFAULT 'YMIR', `szPointOn3` varchar(100) NOT NULL DEFAULT 'NONE', `szPointPoly3` varchar(100) NOT NULL DEFAULT '', `szDurationPoly3` varchar(100) NOT NULL DEFAULT '', `szGrandMasterAddSPCostPoly` varchar(100) NOT NULL DEFAULT '', `prerequisiteSkillVnum` int(11) NOT NULL DEFAULT '0', `prerequisiteSkillLevel` int(11) NOT NULL DEFAULT '0', `eSkillType` enum('NORMAL','MELEE','RANGE','MAGIC') NOT NULL DEFAULT 'NORMAL', `iMaxHit` tinyint(4) NOT NULL DEFAULT '0', `szSplashAroundDamageAdjustPoly` varchar(100) NOT NULL DEFAULT '1', `dwTargetRange` int(11) NOT NULL DEFAULT '1000', `dwSplashRange` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`dwVnum`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Affected rows: 0 Time: 0.055s [sql] -- ---------------------------- -- Records of skill_proto -- ---------------------------- INSERT INTO `skill_proto` VALUES ('1', '»ï¿¬Âü', '1', '1', '1', '0', 'HP', '-( 1.1*atk + (0.5*atk + 1.5 * str)*k)', '40+100*k', '', '', '12', '-( 1.1*atk + (0.5*atk + 1.5 * str)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+100*k', '0', '0', 'MELEE', '5', '1', '0', '0'); [Err] 1265 - Data truncated for column 'setAffectFlag2' at row 1 Link to comment Share on other sites More sharing options...
RoxaLyssa 309 Posted August 29, 2014 Share Posted August 29, 2014 hardrevo: You likely get this error because you are using MySQL5.6, which doesn't like null value for enum columns. Link to comment Share on other sites More sharing options...
siemka256 12 Posted November 2, 2014 Share Posted November 2, 2014 Okay, how do I fix that then? Do I downgrade or? Link to comment Share on other sites More sharing options...
siemka256 12 Posted November 3, 2014 Share Posted November 3, 2014 @Ref Link to comment Share on other sites More sharing options...
siemka256 12 Posted November 3, 2014 Share Posted November 3, 2014 skill_proto dump (.sql) This is the hidden content, please Sign In or Sign Up Virustotal This is the hidden content, please Sign In or Sign Up Pretty please for common 5 2 1 Link to comment Share on other sites More sharing options...
Former Staff flygun 304 Posted December 30, 2014 Former Staff Share Posted December 30, 2014 hardrevo: You likely get this error because you are using MySQL5.6, which doesn't like null value for enum columns. mmmm i got same problem i'm using Mysql5.6 and i want to add the 6th skill ps: I'm using fully untouched sf & db by Rumor and my own core & db Link to comment Share on other sites More sharing options...
Former Staff flygun 304 Posted June 10, 2015 Former Staff Share Posted June 10, 2015 anyone got 40k mob proto sql structure ?? Link to comment Share on other sites More sharing options...
mdxyz 240 Posted February 13, 2016 Share Posted February 13, 2016 tx 1 Link to comment Share on other sites More sharing options...
Premium Shogun 4587 Posted December 10, 2021 Author Premium Share Posted December 10, 2021 On 11/2/2014 at 8:19 PM, siemka256 said: Okay, how do I fix that then? Do I downgrade or? sql_mode = "" in my.cnf 1 Link to comment Share on other sites More sharing options...
Recommended Posts