inner_ability_skills V117

[ilikeme]

Who can give me SQL code for the table 'inner_ability_skills'.

[MentaL]

[Kuuichi]

CREATE TABLE `inner_ability_skills` (
  `player_id` int(11) NOT NULL AUTO_INCREMENT,
  `skill_id` int(11) NOT NULL,
  `skill_level` tinyint(1) NOT NULL,
  `max_level` tinyint(1) NOT NULL,
  `rank` tinyint(1) NOT NULL,
  PRIMARY KEY (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

Not sure if those are the right variables/sizes, but it works for me.

[sunnyboy]

here's correct one

DROP TABLE IF EXISTS `inner_ability_skills`;
CREATE TABLE `inner_ability_skills` (
  `player_id` int(11) unsigned NOT NULL,
  `skill_id` int(9) unsigned NOT NULL,
  `skill_level` tinyint(2) unsigned NOT NULL,
  `max_level` tinyint(2) unsigned NOT NULL,
  `rank` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`player_id`,`skill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

[ilikeme]

here's correct one

DROP TABLE IF EXISTS `inner_ability_skills`;
CREATE TABLE `inner_ability_skills` (
  `player_id` int(11) unsigned NOT NULL,
  `skill_id` int(9) unsigned NOT NULL,
  `skill_level` tinyint(2) unsigned NOT NULL,
  `max_level` tinyint(2) unsigned NOT NULL,
  `rank` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`player_id`,`skill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

CREATE TABLE `inner_ability_skills` (
  `player_id` int(11) NOT NULL AUTO_INCREMENT,
  `skill_id` int(11) NOT NULL,
  `skill_level` tinyint(1) NOT NULL,
  `max_level` tinyint(1) NOT NULL,
  `rank` tinyint(1) NOT NULL,
  PRIMARY KEY (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

Not sure if those are the right variables/sizes, but it works for me.

Thank you guys ;)
but when I'm wearing white angelic blessing ring the player get d/c

[noviceboy55]

Thank you guys ;)
but when I'm wearing white angelic blessing ring the player get d/c

It's due to the player not having the angel passive.

[ilikeme]

It's due to the player not having the angel passive.

How the player can have angle passive?

BTW,
I've been programming for 5 years (2 years in school and 3 years I've learned before the school), but MapleStory Private Server I'm new then I don't know how it's work, and it's look really intersting ;)

[pwx603]

The white angelic passive appears to only work on certain classes. humm~~~ I'm still delving into the codes to find out why...

[even]

use this in playerstats.java

        if (first_login && chra.getLevel() >= 30) { //Angelic blessing for all jobs
             if (chra.isGM()) { //!job lol
                for (int i = 0; i < allJobs.length; i++) {
                    sData.put(SkillFactory.getSkill(1085 + allJobs[i]), new SkillEntry((byte) 1, (byte) 0, -1));
                    sData.put(SkillFactory.getSkill(1087 + allJobs[i]), new SkillEntry((byte) 1, (byte) 0, -1));
                    sData.put(SkillFactory.getSkill(1179 + allJobs[i]), new SkillEntry((byte) 1, (byte) 0, -1));
                }
            } else {
                sData.put(SkillFactory.getSkill(getSkillByJob(1085, chra.getJob())), new SkillEntry((byte) 1, (byte) 0, -1));
                sData.put(SkillFactory.getSkill(getSkillByJob(1087, chra.getJob())), new SkillEntry((byte) 1, (byte) 0, -1));
                sData.put(SkillFactory.getSkill(getSkillByJob(1179, chra.getJob())), new SkillEntry((byte) 1, (byte) 0, -1));
            }
        }