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