[Character Rollback NPC]

15 hours ago, Hurtsky said:

i see, then just use this, it will reset your stats and skills point to what novice at first time creation

prontera,160,186,6	script	Reset	998,{
	// change to novice
	jobchange 0;
	//  reset all
	resetlvl 1;
	atcommand "@reset";
	end;
}

 

Now this is what I'm talking about! It works perfectly so far! Resets everything clean! I'm gonna test this out extensively though. But so far it is perfect! Thank you!

[Character Rollback NPC]

11 hours ago, Hurtsky said:

why not just do like this?

prontera,160,186,6	script	Reset	998,{
	// change to novice
	jobchange 0;
	// reset status point and skills
	atcommand "@reset";
	end;
}

 

Thanks! It works save for skill_point can't be set to 0. I mean it resets status and skill points but skill points need to be set to 0 if you're starting out as a level 1 Novice otherwise you'd have left over skill points and won't be able to change jobs. I tried it with this:

query_sql "UPDATE `char` SET `skill_point` = 0 WHERE `char_id` = "+ getcharid(0);

It works when you try it straight on the database but not in game on an active character. The base_level and status_point doesn't rollback to level 1 and 25 status points but I was told it's fine as long the status points are reset and can be realocated and it wouldn't be an issue changing jobs.

[Character Rollback NPC]

3 minutes ago, Emistry said:

these query should be executed during the char isn't online ...preferable during shutdown/maintenance of server.

its useless to execute this query when the char is online, the server will simply re-insert the exact same data into the server when the char relog

which is why its not provided as a npc script in the first place.

Understood. All in all I'm happy that it works and takes time off manually editing each entry. Thanks for the inputs!

[Character Rollback NPC]

Well it works. However it doesn't fully work when you're using the character you're trying to rollback. Like it doesn't unequip items, base level, skills, hp, sp doesn't rollback and you have to log out and log back in inorder for the changes to take effect. The queries work though if you try it directly on the database so it must be something else.

[Character Rollback NPC]

16 hours ago, Emistry said:

something like..

TRUNCATE TABLE `skill`;
 
UPDATE `char`
SET
	`class` = 0,
	`base_level` = 1,
	`job_level` = 1,
	`base_exp` = 0,
	`job_exp` = 0,
	`str` = 1,
	`agi` = 1,
	`vit` = 1,
	`int` = 1,
	`dex` = 1,
	`luk` = 1,
	`status_point` = 25,
	`skill_point` = 0,	
	`body` = 0,	
	`weapon` = 0,	
	`shield` = 0
;

UPDATE `inventory` SET `equip` = 0;

make sure you backup before execute..

Thank you! It works! However it rolls back the last character listed on the database. Say I'm using character 150002, but there's a character 150003. It will rollback 150003 instead. So I need a way to identify the current char_id for it to rollback. Also it doesn't reset hp and sp but I added that.

Yes. It would be a bit tideous to repeat a whole quest and would like to keep ranking and so on.

Here's what I did:

prontera,160,190,3    script    Rollback#cru    105,{

mes "[Rollback]";
mes "Do you want to rollback to Novice?";
next;
    switch(select("Yes:No")) {
    case 1:
    if (checkfalcon() || checkcart() || checkriding() || ismounting()) {
        mes "Please remove your " +
            ((checkfalcon()) ? "falcon" : "") +
            ((checkcart()) ? "cart" : "") +
            ((checkriding()) ? "Peco" : "") +
            ((ismounting()) ? "mount" : "") +
            " before proceeding.";
        close;
    }
    else {
    mes "Here you go!";
    query_sql "TRUNCATE TABLE `skill`";
    query_sql "UPDATE `inventory` SET `equip` = 0";
    query_sql "UPDATE `char` SET `class` = 0,`base_level` = 1,`job_level` = 1,`base_exp` = 0,`job_exp` = 0,`str` = 1,`agi` = 1,`vit` = 1,`int` = 1,`dex` = 1,`luk` = 1,'max_hp' = 40,'hp' = 40,'max_sp' = 40,'sp' = 40,`status_point` = 25,`skill_point` = 0,`body` = 0,`weapon` = 0,`shield` = 0";
    close;
    break;
    }
    case 2:
    mes "Okay. Good luck on your journey!";
    close;
    break;

    }
}

 

[Character Rollback NPC]

Good day! Was wondering if there's a script out there that rolls a character back to being a Novice with Skill and Stat reset back to begining and points deleted to 0? Kinda like a reverse of a Job NPC. You could say I could just create a new character but this is a bit more convenient. I could rollback a character to being a Novice manually by going to the database and resetting everything but it takes a bit of effort. Thank you.

[Ragnarok Online complete offline server & client pack 2019 | Make your RO server in less than 5 minutes]

17 hours ago, Anacondaqq said:

the exe strictly bounded to the emulator (packet protocol version). The package does not cover any other exes except 2015-11-04 inside the package. Only one thing I can suggest - its wait for an update on the package. I will try to include many interesting features what will fix issues like this which will make the package more stand-alone for the foreign user and unbound it from my updates and waiting for updates (you will be able manually without me update / upgrade everytime when you will need it). ETA? As soon as possible. 

Thanks! Appreciate your work! It's been ages since I last played RO and just wanted to play it again and feel a bit nostalgic about it.