Skill Points can distribute to 3rd class [From Instant Job Change]

[Jezu]

Hello guys,

I just have a server running a months ago with script of instant level where you can select any jobs you want and it will turn the character into a 150/50 class with 167 Skill Points (49+69+49 = 167). The problem is, they can distribute skill points on 3rd job skills directly without filling up the 1st and 2nd jobs skills. Is there a solution for this guys? 

EDIT:

I just removed the script of instant level, then make OnPCLoginEvent that will ResetSkill every characters that born into instant, still, they can distribute skill points... 

 

[malufett]

bypassing the hierarchical sequencing on jobchanging will cause this problem..by using @stat you can see the change_lv_2nd/3rd is not properly computed...I suggest to modify your instant leveler just like iRO sakray..same with aegis when you bypass the hierarchy you will end the same problem..

 

[Jezu]

bypassing the hierarchical sequencing on jobchanging will cause this problem..by using @stat you can see the change_lv_2nd/3rd is not properly computed...I suggest to modify your instant leveler just like iRO sakray..same with aegis when you bypass the hierarchy you will end the same problem..

So what's the best solution for those who have born as instant sir malu? 

and may I know what iRO Sakray's instant leveler do?

 

[malufett]

So what's the best solution for those who have born as instant sir malu?

re-do the job change or modify internally their change_lv_2nd/3rd variable then reset...

and may I know what iRO Sakray's instant leveler do?

click select job->npc grants 99 blevel and job lv ten(player must set all skpoints)->click again npc grants change job then jlvl 50 and so on until your reach the max/selected job

 

[Jezu]

So what's the best solution for those who have born as instant sir malu?

re-do the job change or modify internally their change_lv_2nd/3rd variable then reset...

> 

and may I know what iRO Sakray's instant leveler do?

click select job->npc grants 99 blevel and job lv ten(player must set all skpoints)->click again npc grants change job then jlvl 50 and so on until your reach the max/selected job

May I know this variables in global_reg_value in SQL?  /heh /thx

 

[malufett]

jobchange_level and jobchange_level_3rd

 

[Jezu]

jobchange_level and jobchange_level_3rd

Going to check this now before clicking 'Solved' ... 

EDIT:

sir @malufett,

Is it correct, the value of `jobchange_level` must be 50 and `jobchange_level_3rd` must be 70? 

and how do I make it update on sql query like..

jobchange_level from 1 to 50 and

jobchange_level_3rd from 1 to 70.

 

[malufett]

UPDATE global_reg_value SET jobchange_level=50, jobchange_level_3rd=70 WHERE jobchange_level=1 AND jobchange_level_3rd=1;
or you can do it separately or add some additional criteria...

 

[Jezu]

UPDATE global_reg_value SET jobchange_level=50, jobchange_level_3rd=70 WHERE jobchange_level=1 AND jobchange_level_3rd=1;
or you can do it separately or add some additional criteria...

Thanks for this sir malu!

 i'll try this now!