Utility: SQL Job Changer

[Emistry]

View File

SQL Job Changer

---

Introduction:

Tired of searching for a job changer that never satisfied your need ? Try this out !!

It allow any combination of classes-tree that you can imagine with your brain.

Example: Common Job Change Sequences

Novice >> First >> Second >> High First >> High Second >> ThirdNovice >> First >> Second >> High First >> High SecondNovice >> First >> Second >> High SecondNovice >> First >> Second >> ThirdNovice >> All

* Standard NPC that commonly found in the forum.

Example: Rare Job Change Sequences

Novice >> First >> Second >> Second >> Second >> ThirdNovice >> First >> Second >> Third >> Third >> Third

* Suitable for server who decide to plan for story-lines that allow players to switch to each jobs before they can reach the final class.

---

Setup Guide:

OnInterIfInitOnce:	query_sql( "TRUNCATE `e_jobchanger`" ); // dont remove this line if you're not sure what's it.		// Add any combination that you like.	AddJob( <current job>,<min. base lv>,<min. job lv>,<bonus statpoints>,<bonus skillpoints>,<resetlvl>,<required zeny>,<next job>,...,<next job> );	end;

Put any combination that you want, and let the NPC done the rest of the setup.

• *current job - current char job class
  
• *min. base level - minimum base level to qualify for the job advancement.
  
• *min. job level - minimum job level to qualify for the job advancement.
  
• *bonus status point - amount of extra status point given to char for the job advancement.
  
• *bonus skill point - amount of extra skill point given to char for the job advancement.
  
• *resetlvl - option to reset based on resetlvl.
  
• *req_zeny - amount of zeny required for the job advancement.
  
• the rest - all possible option for classes that you intend to allow current job to change to.
  

If you don't know how to setup it using the NPC script above, you can remove/disable all the lines within the OnInterIfInit lines.

You can modify and execute this sample of SQL Database - Job Changer to generate the data required once and for all eternity.

---

Note:

* Basic knowledge on using SQL Database are required.

* Don't remove the TRUNCATE line if you're not sure what you're doing.

* The script suppose to load the setup part once, clear table and re-insert everything. If you removed that, your SQL tables will be a goddamn mess when you loaded for second times and onward.

* It was suppose to be 2 separated individual script, but I merged it since I am sure there are always some member ask for how to setup the things. Too lazy to answer/spoon-feeding all these questions. So I merged it.

Future Development:

If you have any nice suggestion that are useful/interesting, I may consider to implement it in the future.

Thank in advance.

---

• Submitter
  Emistry
• Submitted
  05/04/2016
• Category
  Utilities
• Video
• Content Author
  Emistry

 

Edited November 28, 2016 by Emistry

[Darknessfmy]

This JM no have Extended SN and 3class Babys

And SN baby and Extended SN Baby

Edited May 26, 2016 by Darknessfmy

[Secrets]

This JM no have Extended SN and 3class Babys

And SN baby and Extended SN Baby

Baby classes are supposed to be able to change via adoptation only.

You can add these classes in the script yourself though. 

[Emistry]

This JM no have Extended SN and 3class Babys

And SN baby and Extended SN Baby

You can follow the setup guide given to create your own version of Job Changer.

[Darknessfmy]

Anyone knows that.

[Emistry]

some minor updates.

 

4 new parameters added to expand customization.

• *bonus status point - amount of extra status point given to char for the job advancement.
• *bonus skill point - amount of extra skill point given to char for the job advancement.
• *resetlvl - option to reset based on resetlvl.
• *req_zeny - amount of zeny required for the job advancement.

Edited July 30, 2016 by Emistry

[mirabell]

On 7/30/2016 at 3:23 AM, Emistry said:

some minor updates.

 

4 new parameters added to expand customization.

• *bonus status point - amount of extra status point given to char for the job advancement.
• *bonus skill point - amount of extra skill point given to char for the job advancement.
• *resetlvl - option to reset based on resetlvl.
• *req_zeny - amount of zeny required for the job advancement.

very nice script. I have suggestion:

when changing to 3rd class i think there supposed to be some item that are given to 3rd class. maybe add some option to provide a player with item upon job change.

 

[ichikun1]

can you please help me to install this ? im sorry im new here also this kind of stuffs ..................... please help me to understand this SQL jobchanger. thank you folks

[ViciousEntropy]

When trying to run the NPC I get this error:

 

"

: DB error - Table 'rathena_prere_db.e_jobchanger' doesn't exist

	[Debug]: at d:\downloads\idm\ragnarok online offline pack rathena 2018\ragnarok

	online offline pack rathena 2018\01_emulator\01_emulator\rathena_prere\src\map\s

	cript.cpp:16671 - SELECT `next_job`,`base_lv`,`job_lv`,`bonus_stpoint`,`bonus_sk

	point`,`resetlvl`,`req_zeny` FROM `e_jobchanger` WHERE `status` = 1 AND `job` =

	9 LIMIT 100

	[Debug]: Source (NPC): sql_job_changer_main (invisible/not on a map)"

 

Is this something you would be able to assist with?

[Emistry]

perhaps try open the file and take a look?

create the sql table using the script provided, its pretty straight forward..

DROP TABLE IF EXISTS `e_jobchanger`;

CREATE TABLE IF NOT EXISTS `e_jobchanger` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`job` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
	`next_job` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
	`base_lv` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
	`job_lv` SMALLINT(6) UNSIGNED NULL DEFAULT '0',
	`bonus_stpoint` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	`bonus_skpoint` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`resetlvl` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`req_zeny` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	`status` TINYINT(3) NOT NULL DEFAULT '1',
	PRIMARY KEY (`id`)
) ENGINE=MyISAM;

 

[Loke]

No working on latest rathena, always said Doesnt have any job advancement for you noweven im just a novice.

 

Edit : Working now I just restart my server.

But I saw this one.

[Debug]: script debug : 0 110008724 :  Loaded	 

Edited April 20, 2021 by Loke

[sapiro1403]

tried this to latest rathena, zeny requirement did not deduct from the player/gm

 

[Emistry]

2 hours ago, sapiro1403 said:

tried this to latest rathena, zeny requirement did not deduct from the player/gm

fixed in v1.1.3

[sapiro1403]

2 hours ago, Emistry said:

fixed in v1.1.3

Hi @Emistry . Thanks for the fix, will be testing on my server.