getguildname bug (?)

[Angeluz]

Hi, I have the following problem with the getguildname command, at the moment that no member has connected after a reload I get return parameter null

	mes "Guild name "+getguildname(22)+".";
	set .@nb, query_sql("select name from guild where guild_id = 22 limit 1",.@guild_name$);
	if ( .@nb == 0 ) {
		mes "No existe.";
		Close;
	}
	mes "Guild Name "+.@guild_name$+".";
	close;

Image DB

Image script

[Hyroshima]

here's normal [ r16311 ]

prontera,155,191,5	script	teste22	112,{
	mes "guild name: "+getguildname(getcharid(2))+"";
	mes "guild name: "+getguildname(1)+"";
	close;
}

 

@Edit:
I did another test and the result was abnormal!

https://streamable.com/6czh9

Edited February 27, 2020 by Hyroshima

[Emistry]

using the npc script right after create a new guild? 

if yes, then its probably because the server havent obtained the information yet

you can try use the *requestguildinfo(...) to fix/update the info of the newly created guild.

*requestguildinfo <guild id>{,"<event label>"};

This command requests the guild data from the char server and merrily continues
with the execution. Whenever the guild information becomes available (which
happens instantly if the guild information is already in memory, or later, if it
isn't and the map server has to wait for the char server to reply) it will run
the specified event as in a 'donpcevent' call.

 

[Angeluz]

It also doesn't work with the requestguildinfo command

[Emistry]

-	script	sample	-1,{
	
	OnInit:
		// sleep 2000;
		
		.guild_id = 1;
		
		debugmes("====== OnInit (ID = "+.guild_id+") =========");
		debugmes("Guild Name = " + getguildname(.guild_id));
		.@size = query_sql("SELECT name FROM `guild` WHERE `guild_id` = "+.guild_id+" LIMIT 1", .@guild_name$);
		debugmes("Guild Name (SQL) = " + .@guild_name$);
		requestguildinfo .guild_id, strnpcinfo(3)+"::OnRequestInfo";
		end;
		
	OnRequestInfo:
		debugmes("====== OnRequestInfo =========");
		debugmes("Guild Name = " + getguildname(.guild_id));
		.@size = query_sql("SELECT name FROM `guild` WHERE `guild_id` = "+.guild_id+" LIMIT 1", .@guild_name$);
		debugmes("Guild Name (SQL) = " + .@guild_name$);
		end;
}

Output:

[Info]: consolemes: ====== OnInit (ID = 1) =========
[Info]: consolemes: Guild Name = null                <--- It failed
[Info]: consolemes: Guild Name (SQL) = Sleepywood
[Info]: consolemes:
====== OnRequestInfo =========
[Info]: consolemes: Guild Name = Sleepywood          <--- Now it worked.
[Info]: consolemes: Guild Name (SQL) = Sleepywood