[Updated][Share] Subclass Master Multi Skills by Allen (Interlude-H5)

[Allengc]

Allengc is there a way to have more than 3 sub classe's?

yup, u need edit the sql, just add more variables to the sql for example this is the original sql.

 

CREATE TABLE `subclass_list` (
  `player_id` varchar(40) NOT NULL,
  `currentsub` int(3) NOT NULL DEFAULT '0',
  `sub_index` int(3) NOT NULL DEFAULT '0',
  `subclassid0` int(3) NOT NULL DEFAULT '-1',
  `subclassid1` int(3) NOT NULL DEFAULT '-1',
  `subclassid2` int(3) NOT NULL DEFAULT '-1',
  `subclassid3` int(3) NOT NULL DEFAULT '-1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

for 6 subclass u need change this, save and add to the DB again

 

CREATE TABLE `subclass_list` (
  `player_id` varchar(40) NOT NULL,
  `currentsub` int(3) NOT NULL DEFAULT '0',
  `sub_index` int(3) NOT NULL DEFAULT '0',
  `subclassid0` int(3) NOT NULL DEFAULT '-1',
  `subclassid1` int(3) NOT NULL DEFAULT '-1',
  `subclassid2` int(3) NOT NULL DEFAULT '-1',
  `subclassid3` int(3) NOT NULL DEFAULT '-1',
  `subclassid4` int(3) NOT NULL DEFAULT '-1',
  `subclassid5` int(3) NOT NULL DEFAULT '-1',
  `subclassid6` int(3) NOT NULL DEFAULT '-1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

also u need edit this into script section

 

maxsubsindb = 6

SubsNumber = 6

 

Thats all. Good luck ;)

[Slyyy]

Nice share. thank you.

[hades25]

y must use eclipse or somthing???? becouse y m not a god eclipse user ..  tnks...

[Allengc]

Eclipse ??? this is a npc made with python, you dont need eclipse.

[Dippindots]

Allen I appreciate your work! Keep the good work !

Thx for all your shares, all are great

[coObisteR]

Very good NPC and deserves a good server. But, man, the first photo looks only to GM, and several packages of Users sometimes.

[Allengc]

Very good NPC and deserves a good server. But, man, the first photo looks only to GM, and several packages of Users sometimes.

 

What do you meant :P? yup the first photo show the reload script option (It can be disable into script's config section), and is only to GMs, so just characters with GM's accesslevel can use and see it, the others can't see it ^^.

[wennaguy]

n1 share

[Dippindots]

Allengc is there a way to remove the stuck skills from all the players?

I want to remove the Manager + all the subs that players have made + Skills.

Can you tell me what i have to do? Thx

[VeneZuela]

I'll test it.. Thanks

[Allengc]

Allengc is there a way to remove the stuck skills from all the players?

I want to remove the Manager + all the subs that players have made + Skills.

Can you tell me what i have to do? Thx

 

??? u cant do it with this npc, at least that users delete the subclases by themself . Sorry You need doit by yourself deleting from data base all skills, and let them learn skills again, but enchanted skills and forgotten skills will be deleted.

[petros50]

Nice share. thank you.

[portokalakias]

bravo man nice share :) TY:)  ;) ;)

[mdg]

yup, u need edit the sql, just add more variables to the sql for example this is the original sql.

 

CREATE TABLE `subclass_list` (
  `player_id` varchar(40) NOT NULL,
  `currentsub` int(3) NOT NULL DEFAULT '0',
  `sub_index` int(3) NOT NULL DEFAULT '0',
  `subclassid0` int(3) NOT NULL DEFAULT '-1',
  `subclassid1` int(3) NOT NULL DEFAULT '-1',
  `subclassid2` int(3) NOT NULL DEFAULT '-1',
  `subclassid3` int(3) NOT NULL DEFAULT '-1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

for 6 subclass u need change this, save and add to the DB again

 

CREATE TABLE `subclass_list` (
  `player_id` varchar(40) NOT NULL,
  `currentsub` int(3) NOT NULL DEFAULT '0',
  `sub_index` int(3) NOT NULL DEFAULT '0',
  `subclassid0` int(3) NOT NULL DEFAULT '-1',
  `subclassid1` int(3) NOT NULL DEFAULT '-1',
  `subclassid2` int(3) NOT NULL DEFAULT '-1',
  `subclassid3` int(3) NOT NULL DEFAULT '-1',
  `subclassid4` int(3) NOT NULL DEFAULT '-1',
  `subclassid5` int(3) NOT NULL DEFAULT '-1',
  `subclassid6` int(3) NOT NULL DEFAULT '-1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

also u need edit this into script section

 

maxsubsindb = 6

SubsNumber = 6

 

Thats all. Good luck ;)

 

Thank you very much for that Allengc

[EboLLa]

does this work on epilogue too? any new updates or something?