frankcastle11

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!

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.

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

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.

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; } }

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.

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.