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