johnbond

Because the kagerou job change is not working in https://github.com/r...m/jobmaster.txt

I have this cart renter NPC. Here are the lines to give a cart to merchants and super novices: case 1: if((BaseClass == Job_Merchant || BaseJob == Job_SuperNovice || BaseJob == Job_Super_Baby || BaseJob == Job_Baby_Merchant || BaseJob == Job_Baby_Blacksmith || BaseJob == Job_Baby_Alchem || BaseJob == Job_Baby_Alchemist) && checkcart() == 0 && (getskilllv("MC_PUSHCART") > 0) ) { setcart; mes "[Breeder]"; mes "There you go, " + strcharinfo(0) + "!"; close; }else{ mes "[Breeder]"; mes "Sorry " + strcharinfo(0) + ", Please make sure you are the required job and have the required skill."; close; } The problem is it does not give the cart. It says "Please make sure you are the required job ...". Maybe the checker for the job is wrong? Or there is another skill name for the pushcart skill of supernovices other than "MC_PUSHCART"?? Other jobs work well, only the super novice and super baby have a problem. What I am doing wrong here? Thanks.

Is there any other good job changer script besides this one? Also, it seems that this job changer is not working for the kagerou. It only says "No more jobs are available" even when ninja is 99/70 already. Any other good job changer?

Does somebody know where to get a good job changer script that has kagerou and oborro jobs but rebellion is disabled. 1. all baby jobs 2. all first, second, trans, 3rds jobs enabled. 3. expanded classes taekwon, soul linker etc enabled. 4. super novice, kagerou/oborro 5. no rebellion Mayeb somebody can link me to it. Thanks guys.

Hello, Can somebody kindly point me to a good WoE Manager script that I can use for rathena. Features like these would be great: 1. waitingroom timer countdown 2. can warp gamemaster 99 to emp room 3. enables change of castle owner per castle or all castles. 4. other cool features I was using the woe_setter_3.txt of [GM]Xeon before when I was in 3ceam but now it has errors on rathena. I know the npc\custom\woe_controller.txt of Euphy but I think it does not have the #2 and #3 above. Maybe somebody would be kind enough to link me a good script. Thanks.

Thanks!

Guys, where can I find the most updated english RENEWAL version of the .txt files with all the latest items: idnum2itemdesctable.txt idnum2itemdisplaynametable.txt idnum2itemresnametable.txt num2itemdesctable.txt num2itemdisplaynametable.txt num2itemresnametable.txt and the others.. If somebody would be so kind to link me to it. Thank you.

Oh nevermind this sirs. I have already fixed it. It was because of wrong column numbering on the harmony patch on account.c. Good to close. Thanks.

Not yet sir, I still get the errors everytime I start server and when somebody logs in.

Thanks for the reply Sir, The value in the "character_slots" column of login table is 0. This is because as per sql-files upgrade_svn17176.sql query is: ALTER TABLE `login` ADD `character_slots` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'; I even tried to manually make the value in character_slots column row 1 to 15 and still reports the same error in console everytime I start server and everytime a character logs in. What do you think is wrong guys? What value you think I should put? The "row 1" is the s1/p1 of the database. When I create a new character, its character_slots column value is 15 but when logging in I still get the same error in login console: [15:49:15] : DB error - Incorrect integer value: '' for column 'character_slots' at row 1 [15:49:15][Debug]: at ..\src\login\account.c:679 - UPDATE `login` SET `userid`=? ,`user_pass`=?,`sex`=?,`email`=?,`group_id`=?,`state`=?,`unban_time`=?,`expirati on_time`=?,`logincount`=?,`lastlogin`=?,`last_ip`=?,`birthdate`=?,`character_slo ts`=?,`pincode`=?, `pincode_change`=?, `bank_vault`=?, `last_mac`=? WHERE `accou nt_id` = '2000002' The newly made account is in row 4 but the error still reports the row 1 error evertime an account logs in.

Oh thank you!

Anyone dear friends?

I am currently moving my current server from 3ceam to rathena but I encountered this error when a character is logging in my test server. login server console: [03:31:06][1;35m[SQL][0m: DB error - Incorrect integer value: '' for column 'character_slots' at row 1 [03:31:06][1;36m[Debug][0m: at ..\src\login\account.c:679 - UPDATE `login` SET `userid`=?,`user_pass`=?,`sex`=?,`email`=?,`group_id`=?,`state`=?,`unban_time`=?,`expiration_time`=?,`logincount`=?,`lastlogin`=?,`last_ip`=?,`birthdate`=?,`character_slots`=?,`pincode`=?, `pincode_change`=?, `bank_vault`=?, `last_mac`=? WHERE `account_id` = '2000008' I already ran these queries which i got from here: https://rathena.org/board/topic/69741-switching-3ceam-to-rathena/?p=136265 UPDATE `global_reg_value` SET `str` = 'jobchange_level_3rd' WHERE `str` = 'jobchange_level2'; DROP TABLE `skillcooldown`; Plus I also ran all the queries from sql-files/updates. No significant errors when I ran these updates but I got the error above on login console when a character logs in. What am I missing here? Thank you.

Pls someone give me enlighenment in my query. Thanks.

I would like to know what query to use to reset all THQS tokens in my database. (\npc\custom\quests\thq\). The scripts use this line when buying from it using the tokens given by these NPC sets. set #Treasure_Token,#Treasure_Token-240; But I want to know on how I can reset all the #Treasure_Token on every character/account in my database through query. Thank you dear Sirs.

It is hexed into the client and certain things are in the msgstringtable. They're relatively easy to find, but I wonder do you mean a cash shop script that you made or placing items in the item_cash_db type of cash-shop (the one accessible from the button next to the mini-map)? No I mean a script which is a cash shop script. - shop CustShop1 -1,909:-1 But then if I change it in the cleint then all "shops" in game will have P instead of Z? Even the ones from official item shop npcs?

I am using cash shop npc scripts in my server of which a special donation currency is used, but the problem is it is confusing to players if they see prices in "z" for zeny instead of "P" for the item actually used to buy from the cash shop. They always think prices are in zeny. Can somebody show me how to change the "z" to "P" in source? Or is it a source modification? or maybe a script edit? Thank you guys.

I don't have this problem. Try putting sleep2(2000); after OnPCStatCalcEvent: Stil same thing happened sir. After the 2nd time player is killed and warped automatically to savepoint his name is still "Player". I also tried that after the player first dies and clicked "return to last savepoint", his name is still "Player". Here is my full script so you can inspect if ever I did something wrong: - script fake_name -1,{ OnInit: set .eventmap$, "turbo_roomc|morocc_mem|pvp_y_8-2"; end; OnPCLoadMapEvent: if( compare( "|"+.eventmap$+"|", "|"+strcharinfo(3)+"|" ) ) { set .@strcharinfo$, strcharinfo(0); set @fakename, 1; detachrid; charcommand "#fakename \""+ .@strcharinfo$ +"\" Player"; } end; OnPCStatCalcEvent: sleep2(2000); if ( @fakename && !compare( "|"+.eventmap$+"|", "|"+strcharinfo(3)+"|" ) ) { set .@strcharinfo$, strcharinfo(0); set @fakename, 0; detachrid; charcommand "#fakename \""+ .@strcharinfo$ +"\""; } } Thank you. Sir Skorm?

Oh thanks but can we just make it that the player will first choose in a menu which requirement he wants to use? Thanks.

Hello Sirs, I have this sure refiner script to +10 which requires 4500 mithril coins to be able to refine with 100% chance. May I request an edit for this script so that it will have 2 options/menu to refine. One option/menu is to require 4500 mithril coins and a second option/menu to require 1 PC of item #7179. So basically players will have to 2 options in transacting with the NPC whichever they want. Here is my script: prt_in,53,56,7 script Mithril Refiner +1 to +10::Mithril Refiner1 86,{ function Refine; set @itemid, 674; set @itemquantity, 4500; set @maxrefine, 10; mes "[Forger]"; mes "Hi, I can refine any upgradeable equipment of your choice to sure +10. Just pay me ^FF00004,500 Mithril Coins^000000."; next; mes "Oh and by the way, I can refine your refinable equipment even if it already has a previous upgrade. I can upgrade them whether if its +5, +7 or +9 doesn't matter."; menu "Refine equipment",REFIN,"Nothing at all",QUIT; REFIN: if (countitem(674)<4500) goto NOREQ; next; mes "To refine an item you need:"; mes "^FF0000 "+@itemquantity+" "+getitemname(@itemid)+"^000000"; set @headtop$,getequipname(1); set @armor$,getequipname(2); set @handl$,getequipname(3); set @handr$,getequipname(4); set @garment$,getequipname(5); set @shoes$,getequipname(6); set @accl$,getequipname(7); set @accr$,getequipname(8); set @headmid$,getequipname(9); set @headlow$,getequipname(10); menu "[Head - Top] "+@headtop$,HEADTOP, "[Head - Mid] "+@headmid$,HEADMID, "[Head - Low] "+@headlow$,HEADLOW, "[Armor] "+@armor$,ARMOR, "[Garment] "+@garment$,GARMENT, "[Left Hand] "+@handl$,HANDL, "[Right Hand] "+@handr$,HANDR, "[Left Acc] "+@accl$,ACCL, "[Right Acc] "+@accr$,ACCR, "[Shoes] "+@shoes$,SHOES, "Cancel",QUIT; HEADTOP: set @slot, 1; callfunc Refine; HEADMID: set @slot, 9; callfunc Refine; HEADLOW: set @slot, 10; callfunc Refine; ARMOR: set @slot, 2; callfunc Refine; GARMENT: set @slot, 5; callfunc Refine; HANDL: set @slot, 3; callfunc Refine; HANDR: set @slot, 4; callfunc Refine; ACCL: set @slot, 7; callfunc Refine; ACCR: set @slot, 8; callfunc Refine; SHOES: set @slot, 6; callfunc Refine; QUIT: mes "Oh, bye then."; close; LATER: mes "Thanks, have a nice day."; close; CANCEL: mes "Okay, come back another time."; close; MAX: mes "Sorry, but I can't refine this anymore."; close; NOWAY: mes "Oh my, I can't refine this item!!!"; close; NOREQ: next; mes "Sorry, but you don't have the items I need. Get out!"; close; // ---------------Refine Equipment function Refine { if (getequiprefinerycnt(@slot) >= @maxrefine) goto MAX; if (getequipisenableref(@slot) == 0) goto NOWAY; menu "Do it!",-,"Cancel",CANCEL; if (countitem(@itemid) < @itemquantity) goto NOREQ; delitem @itemid, @itemquantity; set @repeat, (@maxrefine - getequiprefinerycnt(@slot)); while (@repeat > 0) { successrefitem(@slot); set @repeat, @repeat - 1; } goto LATER; } } Thank you Sirs. Anyone? Kindly please help a newbie scripter like me. Thank you.

Can this already be used alongside client-type Ragnarok Servers? With the same sql database? That would be great if ROBrowser can so players wil have the option to play in PC if at home and play in mobile when outside home, on the same server. Can it? Somebody please give me enlightenment on the matter hehe. PS: I would like to donate to ROBrowser too, to help in developing this. How?

Anyone?

I don't have this problem. Try putting sleep2(2000); after OnPCStatCalcEvent: Stil same thing happened sir. After the 2nd time player is killed and warped automatically to savepoint his name is still "Player". I also tried that after the player first dies and clicked "return to last savepoint", his name is still "Player". Here is my full script so you can inspect if ever I did something wrong: - script fake_name -1,{ OnInit: set .eventmap$, "turbo_roomc|morocc_mem|pvp_y_8-2"; end; OnPCLoadMapEvent: if( compare( "|"+.eventmap$+"|", "|"+strcharinfo(3)+"|" ) ) { set .@strcharinfo$, strcharinfo(0); set @fakename, 1; detachrid; charcommand "#fakename \""+ .@strcharinfo$ +"\" Player"; } end; OnPCStatCalcEvent: sleep2(2000); if ( @fakename && !compare( "|"+.eventmap$+"|", "|"+strcharinfo(3)+"|" ) ) { set .@strcharinfo$, strcharinfo(0); set @fakename, 0; detachrid; charcommand "#fakename \""+ .@strcharinfo$ +"\""; } } Thank you.

It's not missing anything. It works fine for me, and I've tested it multiple times with different characters of varying gm levels. If that version isn't working for you try the untrimmed version I posted instead. Sir still slight problem as I had mentioned above. Everything was already good but when a player is killed twice in pvp and when he gets summoned back to savepoint, his name is still "Player". Can we make it that when he is back to savepoint his name will be normal again? Thank you Sir Skorm.

It's not missing anything. It works fine for me, and I've tested it multiple times with different characters of varying gm levels. If that version isn't working for you try the untrimmed version I posted instead. I used the "untrimmed version" and its working. The "dead animation" now shows after killing for the second time just before killed player gets automatically warped back to savepoint. Btw, just a small problem remains. Whenever the killed player for the 2nd time in pvp automatically respawns in savepoint his name still remains being "Player". Can we make it that when the player killed for the 2nd time in pvp and automatically spawns in savepoint that his name will be back to normal? Thank you very much sir Skorm for all the help!