Guild of the Month Flag

[Pink Guy]

Can someone please make me a Guild of the Month Flag NPC. Instead of using Getcastlename or something or GID, can I just put a guild name there and put a getguildmaster command? Example guild name: Amateurs.

 

Here's the example I made:

 

gonryun,160,118,4    script    Guild of The Month    722,{
        mes "[Guild of the Month]";
        mes "The Guild of the Month is the ^ff0000"Amateurs"^000000 Guild";
        mes "Their Guild Master is ^FF0000" + GetGuildMaster + "^000000";
 
end;
 
}

Can someone please help me with this? Also, I wanna put the emblem thing

Edited July 2, 2013 by Instinct

[Pink Guy]

Fixed it's just the server name has space.

Edited August 28, 2013 by Instinct

[Skorm]

gonryun,160,118,4	script	Guild of The Month	722,{
	mes "[Guild of the Month]";
	mes "The Guild of the Month is the ^ff0000"+getguildname(.a)+"^000000 Guild";
	mes "Their Guild Master is ^FF0000"+.b$+"^000000";
	close;

OnInit:
	set .guild$, "Amateurs";
	query_sql("SELECT `guild_id`,`master` FROM `guild` WHERE `name` = '"+.guild$+"';",.a,.b$);
	flagemblem .a;
}

Untested

Edit: Thank you for the example it made my job 100% easier.

Edited July 2, 2013 by Skorm

[Pink Guy]

I tested it but it's like this..

Is it because there's no "set .a" ? because I can see there's "set .guild$"

[Skorm]

I tested it but it's like this..

Is it because there's no "set .a" ? because I can see there's "set .guild$"

It worked fine for me?

Hey, are you using an sql server? If not then this script won't work for you and I'll have to do something different using the guild ID instead of the guild name. If you are using an sql server make sure that the guild name is spelled exactly as it appears in your database.

Edited July 2, 2013 by Skorm

[simplemhan]

try this:

 

gonryun,160,118,4    script    Guild of The Month    722,{
    mes "[Guild of the Month]";
    mes "The Guild of the Month is the ^ff0000"+getguildname(.a)+"^000000 Guild";
    mes "Their Guild Master is ^FF0000"+.b$+"^000000";
    close;

OnInit:
    set .guild$, "+getguildname(.a)+";
    query_sql("SELECT `guild_id`,`master` FROM `guild` WHERE `name` = '"+.guild$+"';",.a,.b$);
    flagemblem .a;
}

 

if not working make an sql query which getting the name of the guild of the month

Edited August 27, 2013 by Capuche
BBCode

[Pink Guy]

Skorm, on 02 Jul 2013 - 17:11, said:

Instinct, on 02 Jul 2013 - 15:21, said:

I tested it but it's like this..

Is it because there's no "set .a" ? because I can see there's "set .guild$"

It worked fine for me?

Hey, are you using an sql server? If not then this script won't work for you and I'll have to do something different using the guild ID instead of the guild name. If you are using an sql server make sure that the guild name is spelled exactly as it appears in your database.

Thanks! I realized I was using txt server lol.

Btw, can someone help me with the emblem thing? It only appears when you @reloadscript and after @refresh / log out or anything, you can't see the emblem anymore.. can someone help?

Edited July 2, 2013 by Instinct

[Skorm]

Firstly I strongly recommend switching to an SQL server.

gonryun,160,118,4	script	Guild of The Month	722,{

mes "[Guild of the Month]";

mes "The Guild of the Month is the ^ff0000"+getguildname(.guild_id)+"^000000 Guild";

mes "Their Guild Master is ^FF0000"+getguildmaster(.guild_id)+"^000000";

close;

OnInit:

set .guild_id, 1;

flagemblem .guild_id;

}

I can't really think of a way to return the guild_id using guild name on a txt server. :/ Perhaps someone else has more insight on this, but you can use the guilds ID here and it will work on a txt server.

[Pink Guy]

I used an SQL server and it works but the thing is, the emblem disappears if you walk away/@refresh/relog. So is there any way to make the emblem appear permanently?

[Skorm]

I used an SQL server and it works but the thing is, the emblem disappears if you walk away/@refresh/relog. So is there any way to make the emblem appear permanently?

I don't seem to have this problem the method used by all flags is relatively similar to what I've done here. You could try reloading the image with Ontouch but that might get a little bad with people walking through it and stuff.

If you've just reloaded scripts and are refreshing the map I recommend doing a full server restart and seeing how it works for you then because sometimes @reloadscript is a little buggy.

[Emistry]

I used an SQL server and it works but the thing is, the emblem disappears if you walk away/@refresh/relog. So is there any way to make the emblem appear permanently?

show your script .... emblem that display on flag will only clear after server reboot / reloaded ...depend on what type of variable you used to store the char id ...

[Pink Guy]

I used the script above provided by Skorm. I made the guild called "Amateurs" and it works fine but after I type @refresh, the emblem disappears but I'll try to restart the server and see.

I restarted the server and it still disappears. Anyone can help me?