Jump to content

Snaehild

Members
 View Profile  See their activity

  • Posts

    72

  • Joined

  • Last visited

 Content Type 

Posts posted by Snaehild

    skill.cpp:183::skill_check

    in General Support

    Posted · Edited by Snaehild

    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.

    Tournament Team DB Registration

    in Scripting Support

    Posted

    22 hours ago, Emistry said:

    query the data from the char_reg_str table

    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?

    Tournament Team DB Registration

    in Scripting Support

    Posted

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

     

    Release: Extended Vending 2.0

    in Source Releases

    Posted

    On 9/25/2021 at 12:01 AM, Easycore said:

    New Version:
    Working on latest Git: 6672bf

    • Refactored 'item_vending.txt' to YAML Format 'item_vending_db.yml'.
    • Fixed an issue regarding bound items in the buyer's inventory.
    • Added a config to enable/disable buying with bounded items.
    • Prevent buying if seller has the Max Item in the inventory (30,000 ea).
    • Added GetComma for a better visualization of the amount of zeny received (Vending Report).
    • Code clean-up.

    Status: Pending Approval.


    @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

    The variable 'deleted' is being used without being initialized.

    in General Support

    Posted

    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)

     

    Tournament Team DB Registration

    in Scripting Support

    Posted

    On 9/19/2021 at 2:11 AM, Emistry said: 
    if( query_sql( "SELECT `team_name` FROM `tournament` WHERE `team_name` = '"+escape_sql( .@team_name$ )+"'", .@team_name$ ) ){

    you need to assign a variable to store the data you query from database.

    Perfect. Thank you Emistry.

    P.S. I'm your fan ?

    Tournament Team DB Registration

    in Scripting Support

    Posted

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

     

    Tournament Team DB Registration

    in Scripting Support

    Posted

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

     

    Quests, Games: Alon Event

    in Game, Event, Quest Script Releases

    Posted

    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).

     

    Quests, Games: Illusion Moonlight

    in Game, Event, Quest Script Releases

    Posted 

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

     

×
×
  • Create New...