Snaehild

Any plans to support buying @Easycore?

Hi, We've been getting these errors for a few weeks now. Characters gets randomly stuck and can't do any movements. It mostly happens on instance with rare occasions on the fields as well. [Error]: delete_timer error : function mismatch 01B037B0(unit_walktoxy_timer) != 01430DAB(skill_keep_using) [Error]: delete_timer error : function mismatch 01B037B0(unit_walktoxy_timer) != 01430DAB(skill_keep_using) [Error]: Skill '59783' is undefined! e:\server\src\map\skill.cpp:183::skill_check [Error]: Skill '40384' is undefined! e:\server\src\map\skill.cpp:183::skill_check [Error]: Skill '27733' is undefined! e:\server\src\map\skill.cpp:183::skill_check [Error]: Skill '27881' is undefined! e:\server\src\map\skill.cpp:183::skill_check [Error]: Skill '7133' is undefined! e:\server\src\map\skill.cpp:183::skill_check [Error]: Skill '61237' is undefined! e:\server\src\map\skill.cpp:183::skill_check [Error]: Skill '60502' is undefined! e:\server\src\map\skill.cpp:183::skill_check [Error]: Skill '20450' is undefined! e:\server\src\map\skill.cpp:183::skill_check [Error]: Skill '32824' is undefined! e:\server\src\map\skill.cpp:183::skill_check Edit: We were using PR d04e0 and then upgraded to 1deb5 today with the same errors.

Thanks @Emistry, I thought there would be a simpler way by calling out the variable. I'm having issues with my SQL query when using AND checkExist: mes "^FF0000"+.c_id$+""; mes "^FF0000"+.w_key$+""; /* SELECT * FROM `char_reg_str` WHERE `char_id` = 150875 AND `key` LIKE 'slyr_Wallet$' */ if( query_sql( "SELECT `char_id` FROM `char_reg_str` WHERE `key` LIKE '"+.w_key$+"'", .@c_id$ ) ){ mes "^FF0000"+.c_id$+""; } else { goto addMember; } I also tried nitrous' suggestion in discord to debug my sql query: query_sql( "SELECT `char_id`,`name` FROM `char` WHERE `char_id` LIKE '%"+escape_sql( getcharid(0) )+"%' GROUP BY `char_id` LIMIT 50",.@id,.@name$ ); query_sql( "SELECT * FROM `char_reg_str` WHERE `char_id`='"+escape_sql( getcharid(0) )+"'",.c_id$,.c_key$,.index$,.value$ ); mes "^FF0000"+.c_id$+""; mes "^FF0000"+.w_key$+""; .@string$ = "SELECT char_id FROM char_reg_str WHERE char_id = '"+.c_id$+"' & key = '" + .w_key$ + "'"; debugmes .@string$; if (query_sql(.@string$, .@c_id$)) { } OnInit: .w_key$ = "slyr_Member$"; end; [SQL]: DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = 'slyr_Member$'' at line 1 Does this have something to do with my mySQL installation?

Follow up questions @Emistry Instead of adding this to a separate database, I want to just use a character variable so when a character gets deleted, the team can add a member. So I have set team_Name$, .@w_reg$; But how can I properly get the count if a team_Name already have 3 members? query_sql( "SELECT COUNT(1) FROM `tournament` WHERE `team_name` = '"+escape_sql(.@w_reg$)+"' GROUP BY `team_name",.@amount ); mes "Total Member: " + .@amount; if (.@amount >= 3) { goto moreThanThree; }

Is there a fix for this?

I got the zeny and cash working too. Did you have any luck making the other items work?

[Warning]: buildin_clear: There is no mes active. [Debug]: Source (NPC): Premium Storage at prontera (150,150) [Debug]: Source (NPC): Premium Storage is located in: npc/custom/storage_premium.txt Not working?

@Easycore I tried this on a fresh 6672bf But it doesn't seem to recognize the items. "You do not have enough items" https://streamable.com/oxqcwx

Hi, I'm not sure if this is the correct forum for this but, does anyone have any idea about this error? This has been bugging us for almost a month now. Microsoft Visual C++ Runtime Library Debug Error! Program: C:\Server\map-server.exe Module: C:\Server\map-server.exe File: Run-Time Check Failure #3 - The variable 'deleted' is being used without being initialized. (Press Retry to debug the application)

Any idea what I missed?

Hey latios, thank you for letting me know. I actually need YML more. you're the best!

Awesome work @Easycore! Is it possible to remove the [Currency] part of the vending name?

Perfect. Thank you Emistry. P.S. I'm your fan ?

Lovely. I will be waiting.

Hi @Emistry Thank you for the help, I was able to complete the script somehow, but i'm getting a debug error [Warning]: script:query_sql: Too many columns, discarding last 1 columns. [Debug]: Source (NPC): Tournament at gm_room (77,47) It seems to be the checkExist if statement if( query_sql( "SELECT `team_name` FROM `tournament` WHERE `team_name` = '"+escape_sql( .@team_name$ )+"'" ) ){ gm_room,77,47,5 script Tournament 757,{ query_sql( "SELECT * FROM `tournament` WHERE `char_id`='"+escape_sql( getcharid(0) )+"'",.@w_id$,.@a_id$,.@c_id$,.@c_name$,.@team_name$,.amount$,.@time$ ); goto checkExist; checkExist: if( query_sql( "SELECT `team_name` FROM `tournament` WHERE `team_name` = '"+escape_sql( .@team_name$ )+"'" ) ){ goto boundAddress; } else { goto addMember; } boundAddress: mes "This character is already registered to the team:"; mes "^FF0000"+.@team_name$+""; mes "You can't change your wallet address at this time."; close; checkTotal: mes "Do you want "; query_sql( "SELECT COUNT(1) FROM `tournament` WHERE `team_name` = '"+escape_sql(.@w_reg$)+"' GROUP BY `team_name",.@amount ); mes "Total Member: " + .@amount; if (.@amount >= 3) { goto moreThanThree; } else { query_sql "INSERT INTO `tournament` VALUES ( '', '" + .@a_id$ + "', '" + getcharid(0) + "', '" + strcharinfo(0) + "', '" + .@w_reg$ + "', '1' , NOW() )"; close; } moreThanThree: mes "There are already 3 members of that team."; close; addMember: mes "Enter your team name"; input .@w_reg$; goto checkTotal; close; }

Hi, I'm trying to write a script where players can register for a tournament of up to 3 members per team and saves in the database. But I got stuck in the counting part. I tried using this: gm_room,76,56,5 script Tournament 757,{ mes "Team Name"; input .@team_name; next; mes "test"; for( set .@w,0; .@w < 1; set .@w,.@w + 1 ){ query_sql( "SELECT SUM(`amount`) FROM `tournament` WHERE `team_name`='"+.@team_name+"'",.@amount ); set .@total,.@total + ( .@amount ); } mes "Found "+.@total+" x "+.@i+ ""; query_sql "INSERT INTO `tournament` VALUES ( '', '" + .@id + "', '" + getcharid(0) + "', '" + strcharinfo(0) + "', '" + .@team_name + "', '1' , NOW() )"; close; end; }

This is an awesome tool. Do you have an ETA for the mob_db.txt support?

But is this totally normal?

Thanks for this! [Warning]: vend loot = 674 Edit: Fixed the issue earlier, just to make sure; Is this warning normal?

Hi @L1nkZ, Awesome patcher. I've been using this for a while now. Do you have any idea what could be causing this? This happens to a quite few of my players

Hi @Poring King Thanks for this awesome script. Any idea what could be causing this? [Error]: WFIFOSET: Maximum write buffer size for client connection 4 exceeded, most likely caused by packet 0x08c8 (len=34, ip=127.0.0.1). [Error]: WFIFOSET: Maximum write buffer size for client connection 4 exceeded, most likely caused by packet 0x0acc (len=18, ip=127.0.0.1). [Error]: WFIFOSET: Maximum write buffer size for client connection 4 exceeded, most likely caused by packet 0x0acc (len=18, ip=127.0.0.1). [Error]: WFIFOSET: Maximum write buffer size for client connection 4 exceeded, most likely caused by packet 0x00b6 (len=6, ip=127.0.0.1). [Error]: WFIFOSET: Maximum write buffer size for client connection 4 exceeded, most likely caused by packet 0x00b6 (len=6, ip=127.0.0.1).

[Error]: script error on npc/custom/roservers/Illusion Moonlight.c line 96 parse_line: expect command, missing function name or calling undeclared function 91 : close; 92 : } 93 : 94 : OnInit: 95 : questinfo 7776,QTYPE_QUEST2; * 96 : 's'etquestinfo_level 7776,100,175; 97 : end; 98 : } 99 : payon,167,229,3 script Elder Jagyeom#illusion_moonlight 4_M_HUOLDARMY,{ 100 : if(BaseLevel < 100){ 101 : mes "[ Jagyeom ]"; [Error]: script error on npc/custom/roservers/Illusion Moonlight.c line 307 parse_line: expect command, missing function name or calling undeclared function 302 : } 303 : 304 : 305 : OnInit: 306 : questinfo 7777,QTYPE_QUEST; * 307 : 's'etquestinfo_req 7777,7776,1; 308 : end; 309 : } 310 : payon_in03,33,95,3 script Muyeon#moonlight_in 4_F_TAEKWON,{ 311 : if(illusion_moonlight < 2){ 312 : mes "[ Muyeon ]"; [Error]: script error on npc/custom/roservers/Illusion Moonlight.c line 317 parse_line: expect command, missing function name or calling undeclared function 312 : mes "[ Muyeon ]"; 313 : mes "If you're looking for the teacher, she's in the other room."; 314 : close; 315 : } 316 : if(illusion_moonlight == 2){ * 317 : 'p'cblockall getcharid(3),1; 318 : sleep2 2000; 319 : npctalk "Whatever you say, I'm not doing it anymore.","Muyeon#moonlight_in",bc_self; 320 : sleep2 2000; 321 : npctalk "This is the third time I had nightmares. I can't take it anymore!","Muyeon#moonlight_in",bc_self; 322 : sleep2 2000; [Error]: script error on npc/custom/roservers/Illusion Moonlight.c line 692 parse_line: expect command, missing function name or calling undeclared function 687 : end; 688 : } 689 : 690 : OnInit: 691 : questinfo 7781,QTYPE_QUEST; * 692 : 's'etquestinfo_req 7781,7780,1; 693 : end; 694 : } 695 : pay_d03_i,140,46,0 script Shimmering Portal#illusion_moonlight_2 4_ENERGY_BLUE,{ 696 : mes "I can go back to the ruined village.","What should I do?"; 697 : next;

By default, it should inherit id: 5 name: "VIP" inherit: ( "Player" ) /* can do everything Players can */

It's around 16.2 I believe. https://github.com/rathena/rathena/projects/4

Hi, Any idea about these errors on the webservice? This is taken from this PR: https://github.com/rathena/rathena/pull/5731 [Warning]: Request with AID 2000022 and token 4e38fe3eba3a6ac5 unverified [Info]: 99.231.191.2 400 [Error]: [GuildID: 4 / World: "ROServer"] Not found in table [Info]: 49.150.58.7 404